java/trunk/conditions/src/main/sql
--- java/trunk/conditions/src/main/sql/conditions_db_testrun_full.sql (rev 0)
+++ java/trunk/conditions/src/main/sql/conditions_db_testrun_full.sql 2014-03-13 22:04:46 UTC (rev 295)
@@ -0,0 +1,406 @@
+-- MySQL dump 10.13 Distrib 5.1.73, for redhat-linux-gnu (x86_64)
+--
+-- Host: mysql-node03.slac.stanford.edu Database: rd_hps_cond
+-- ------------------------------------------------------
+-- Server version 5.5.23-log
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Table structure for table `beam_current`
+--
+
+DROP TABLE IF EXISTS `beam_current`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `beam_current` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `set_id` int(11) DEFAULT NULL,
+ `beam_current` double DEFAULT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `beam_current`
+--
+
+LOCK TABLES `beam_current` WRITE;
+/*!40000 ALTER TABLE `beam_current` DISABLE KEYS */;
+INSERT INTO `beam_current` VALUES (1,1,54879.7343788147),(2,2,26928.0426635742),(3,3,204325.132622242),(4,4,148839.141475141),(5,5,92523.9428218845),(6,6,91761.4541434497),(7,7,209883.979889035),(8,8,110298.553449392),(9,9,8556.8459701538);
+/*!40000 ALTER TABLE `beam_current` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `conditions_dev`
+--
+
+DROP TABLE IF EXISTS `conditions_dev`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `conditions_dev` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `run_start` int(11) NOT NULL,
+ `run_end` int(11) NOT NULL,
+ `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `created` datetime NOT NULL,
+ `valid_from` datetime DEFAULT NULL,
+ `valid_to` datetime DEFAULT NULL,
+ `created_by` varchar(255) DEFAULT NULL,
+ `notes` blob,
+ `name` varchar(40) NOT NULL,
+ `format_version` varchar(16) DEFAULT NULL,
+ `table_name` varchar(50) NOT NULL,
+ `field_name` varchar(50) NOT NULL,
+ `field_value` int(11) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `conditions_dev`
+--
+
+LOCK TABLES `conditions_dev` WRITE;
+/*!40000 ALTER TABLE `conditions_dev` DISABLE KEYS */;
+INSERT INTO `conditions_dev` VALUES (1,777,1365,'2013-09-30 23:05:51','2013-09-20 13:19:55',NULL,NULL,'jeremym',NULL,'svt_calibrations',NULL,'svt_calibrations','set_id',1),(2,777,1365,'2013-09-30 23:05:11','2013-09-24 16:48:39',NULL,NULL,'jeremym',NULL,'ecal_gains',NULL,'ecal_gains','set_id',1),(3,777,1365,'2013-09-30 23:05:11','2013-09-30 16:02:49',NULL,NULL,'jeremym',NULL,'ecal_bad_channels',NULL,'ecal_bad_channels','set_id',1),(4,777,1365,'2013-10-02 19:39:25','2013-09-30 17:25:21',NULL,NULL,'jeremym',NULL,'ecal_calibrations',NULL,'ecal_calibrations','set_id',1),(5,777,1365,'2013-10-02 19:39:25','2013-10-02 12:39:11',NULL,NULL,'jeremym',NULL,'svt_bad_channels',NULL,'svt_bad_channels','set_id',1),(6,777,1365,'2013-10-03 21:59:50','2013-10-03 14:59:33',NULL,NULL,'jeremym',NULL,'svt_pulse_parameters',NULL,'svt_pulse_parameters','set_id',1),(7,777,1365,'2013-10-10 23:02:42','2013-10-03 16:51:19',NULL,NULL,'jeremym',NULL,'svt_gains',NULL,'svt_gains','set_id',1),(8,777,1365,'2!
013-10-10 23[...]
+/*!40000 ALTER TABLE `conditions_dev` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `ecal_bad_channels`
+--
+
+DROP TABLE IF EXISTS `ecal_bad_channels`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ecal_bad_channels` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `ecal_channel_id` int(11) NOT NULL,
+ `set_id` int(11) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `ecal_bad_channels`
+--
+
+LOCK TABLES `ecal_bad_channels` WRITE;
+/*!40000 ALTER TABLE `ecal_bad_channels` DISABLE KEYS */;
+INSERT INTO `ecal_bad_channels` VALUES (1,20,1),(2,234,1),(3,235,1),(4,236,1),(5,238,1),(6,240,1),(7,256,1),(8,264,1),(9,266,1),(10,268,1),(11,270,1),(12,272,1),(13,274,1),(14,276,1),(15,278,1),(16,280,1),(17,282,1),(18,284,1),(19,286,1),(20,290,1),(21,292,1),(22,293,1),(23,300,1),(24,306,1),(25,308,1),(26,310,1),(27,346,1),(28,348,1),(29,370,1),(30,418,1),(31,420,1),(32,422,1),(33,424,1),(34,425,1),(35,426,1),(36,428,1),(37,430,1),(38,431,1),(39,432,1),(40,434,1),(41,436,1),(42,438,1),(43,440,1),(44,442,1);
+/*!40000 ALTER TABLE `ecal_bad_channels` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `ecal_calibrations`
+--
+
+DROP TABLE IF EXISTS `ecal_calibrations`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ecal_calibrations` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `ecal_channel_id` int(11) NOT NULL,
+ `set_id` int(11) DEFAULT NULL,
+ `pedestal` double NOT NULL,
+ `noise` double NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=556 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `ecal_calibrations`
+--
+
+LOCK TABLES `ecal_calibrations` WRITE;
+/*!40000 ALTER TABLE `ecal_calibrations` DISABLE KEYS */;
+INSERT INTO `ecal_calibrations` VALUES (1,1,1,84.753881,5.458664),(2,3,1,84.855231,5.079355),(3,5,1,116.119123,5.02221),(4,7,1,94.705737,5.134416),(5,9,1,104.188526,5.368471),(6,11,1,121.932283,5.208102),(7,13,1,110.893363,5.202804),(8,15,1,122.005624,4.972769),(9,17,1,139.244094,5.071151),(10,19,1,110.365354,5.474363),(11,21,1,154.716085,4.728363),(12,23,1,109.64342,4.53666),(13,25,1,78.065467,4.574049),(14,27,1,143.976715,4.54093),(15,29,1,90.033971,4.610056),(16,31,1,148.486614,5.02935),(17,33,1,123.077728,4.688464),(18,35,1,113.468279,4.547754),(19,37,1,110.754331,5.533226),(20,39,1,110.415636,6.380486),(21,41,1,109.32036,4.726009),(22,43,1,89.884139,4.777839),(23,45,1,147.128796,4.669933),(24,47,1,100.65928,4.735584),(25,49,1,127.842857,5.609905),(26,51,1,101.690664,4.818428),(27,53,1,106.753656,4.694521),(28,55,1,93.061305,4.732574),(29,57,1,111.990889,4.726564),(30,59,1,103.664679,4.932656),(31,61,1,103.072891,4.731993),(32,63,1,123.154218,4.385393),(33,65,1,130.8633!
3,4.529927),[...]
+/*!40000 ALTER TABLE `ecal_calibrations` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `ecal_channels`
+--
+
+DROP TABLE IF EXISTS `ecal_channels`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ecal_channels` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `x` smallint(6) NOT NULL,
+ `y` smallint(6) NOT NULL,
+ `crate` smallint(6) NOT NULL,
+ `slot` smallint(6) NOT NULL,
+ `channel` smallint(6) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=443 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `ecal_channels`
+--
+
+LOCK TABLES `ecal_channels` WRITE;
+/*!40000 ALTER TABLE `ecal_channels` DISABLE KEYS */;
+INSERT INTO `ecal_channels` VALUES (1,-23,1,1,10,0),(2,-23,-1,2,10,0),(3,-23,2,1,10,1),(4,-23,-2,2,10,1),(5,-23,3,1,10,2),(6,-23,-3,2,10,2),(7,-23,4,1,10,3),(8,-23,-4,2,10,3),(9,-23,5,1,10,4),(10,-23,-5,2,10,4),(11,-22,1,1,10,5),(12,-22,-1,2,10,5),(13,-22,2,1,10,6),(14,-22,-2,2,10,6),(15,-22,3,1,10,7),(16,-22,-3,2,10,7),(17,-22,4,1,10,8),(18,-22,-4,2,10,8),(19,-22,5,1,10,9),(20,-22,-5,2,10,9),(21,-21,1,1,10,10),(22,-21,-1,2,10,10),(23,-21,2,1,10,11),(24,-21,-2,2,10,11),(25,-21,3,1,10,12),(26,-21,-3,2,10,12),(27,-21,4,1,10,13),(28,-21,-4,2,10,13),(29,-21,5,1,10,14),(30,-21,-5,2,10,14),(31,-20,1,1,10,15),(32,-20,-1,2,10,15),(33,-20,2,1,13,0),(34,-20,-2,2,13,0),(35,-20,3,1,13,1),(36,-20,-3,2,13,1),(37,-20,4,1,13,2),(38,-20,-4,2,13,2),(39,-20,5,1,13,3),(40,-20,-5,2,13,3),(41,-19,1,1,13,4),(42,-19,-1,2,13,4),(43,-19,2,1,13,5),(44,-19,-2,2,13,5),(45,-19,3,1,13,6),(46,-19,-3,2,13,6),(47,-19,4,1,13,7),(48,-19,-4,2,13,7),(49,-19,5,1,13,8),(50,-19,-5,2,13,8),(51,-18,1,1,13,9),(52,-18!
,-1,2,13,9),[...]
+/*!40000 ALTER TABLE `ecal_channels` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `ecal_gains`
+--
+
+DROP TABLE IF EXISTS `ecal_gains`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ecal_gains` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `set_id` int(11) NOT NULL,
+ `ecal_channel_id` int(11) NOT NULL,
+ `gain` double NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=443 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `ecal_gains`
+--
+
+LOCK TABLES `ecal_gains` WRITE;
+/*!40000 ALTER TABLE `ecal_gains` DISABLE KEYS */;
+INSERT INTO `ecal_gains` VALUES (1,1,1,0.133127),(2,1,3,0.11578),(3,1,5,0.134208),(4,1,7,0.155521),(5,1,9,0.13377),(6,1,11,0.157064),(7,1,13,0.130944),(8,1,15,0.140505),(9,1,17,0.166728),(10,1,19,0.13377),(11,1,21,0.179666),(12,1,23,0.196879),(13,1,25,0.212828),(14,1,27,0.212381),(15,1,29,0.212381),(16,1,31,0.204436),(17,1,33,0.21458),(18,1,35,0.208637),(19,1,37,0.212381),(20,1,39,0.212381),(21,1,41,0.207319),(22,1,43,0.19391),(23,1,45,0.199045),(24,1,47,0.214641),(25,1,49,0.214641),(26,1,51,0.204768),(27,1,53,0.219602),(28,1,55,0.213419),(29,1,57,0.214641),(30,1,59,0.214641),(31,1,61,0.238475),(32,1,63,0.251577),(33,1,65,0.26581),(34,1,67,0.26104),(35,1,69,0.26104),(36,1,71,0.236384),(37,1,73,0.269346),(38,1,75,0.230097),(39,1,77,0.26104),(40,1,79,0.26104),(41,1,81,0.188842),(42,1,83,0.220022),(43,1,85,0.24098),(44,1,87,0.222194),(45,1,89,0.222194),(46,1,91,0.213146),(47,1,93,0.21083),(48,1,95,0.213309),(49,1,97,0.222194),(50,1,99,0.222194),(51,1,101,0.228191),(52,1,103,0.!
190975),(53,[...]
+/*!40000 ALTER TABLE `ecal_gains` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `svt_bad_channels`
+--
+
+DROP TABLE IF EXISTS `svt_bad_channels`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `svt_bad_channels` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `set_id` int(11) NOT NULL,
+ `svt_channel_id` int(11) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=3117 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `svt_bad_channels`
+--
+
+LOCK TABLES `svt_bad_channels` WRITE;
+/*!40000 ALTER TABLE `svt_bad_channels` DISABLE KEYS */;
+INSERT INTO `svt_bad_channels` VALUES (1,1,33),(2,1,129),(3,1,161),(4,1,257),(5,1,289),(6,1,385),(7,1,417),(8,1,545),(9,1,639),(10,1,673),(11,1,769),(12,1,801),(13,1,897),(14,1,929),(15,1,986),(16,1,1025),(17,1,1057),(18,1,1153),(19,1,1185),(20,1,1279),(21,1,1281),(22,1,1282),(23,1,1313),(24,1,1409),(25,1,1415),(26,1,1537),(27,1,1793),(28,1,1825),(29,1,1919),(30,1,1920),(31,1,1921),(32,1,2081),(33,1,2323),(34,1,2338),(35,1,2352),(36,1,2353),(37,1,2382),(38,1,2383),(39,1,2384),(40,1,2385),(41,1,2559),(42,1,2560),(43,1,2642),(44,1,3809),(45,1,5587),(46,1,5931),(47,1,7028),(48,1,7998),(49,1,7999),(50,1,8575),(51,2,2383),(52,2,3585),(53,2,3586),(54,2,3587),(55,2,3588),(56,2,3589),(57,2,3590),(58,2,3591),(59,2,3592),(60,2,3593),(61,2,3594),(62,2,3595),(63,2,3596),(64,2,3597),(65,2,3598),(66,2,3599),(67,2,3600),(68,2,3601),(69,2,3602),(70,2,3603),(71,2,3604),(72,2,3605),(73,2,3606),(74,2,3607),(75,2,3608),(76,2,3609),(77,2,3610),(78,2,3611),(79,2,3612),(80,2,3613),(81,2,3614),(82!
,2,3615),(83[...]
+/*!40000 ALTER TABLE `svt_bad_channels` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `svt_bad_channels_scratch`
+--
+
+DROP TABLE IF EXISTS `svt_bad_channels_scratch`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `svt_bad_channels_scratch` (
+ `channel` int(10) unsigned DEFAULT NULL,
+ `fpga` int(10) unsigned DEFAULT NULL,
+ `hybrid` int(10) unsigned DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `svt_bad_channels_scratch`
+--
+
+LOCK TABLES `svt_bad_channels_scratch` WRITE;
+/*!40000 ALTER TABLE `svt_bad_channels_scratch` DISABLE KEYS */;
+/*!40000 ALTER TABLE `svt_bad_channels_scratch` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `svt_calibrations`
+--
+
+DROP TABLE IF EXISTS `svt_calibrations`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `svt_calibrations` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `set_id` int(11) NOT NULL,
+ `svt_channel_id` int(11) NOT NULL,
+ `noise` double NOT NULL,
+ `pedestal` double NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=12801 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `svt_calibrations`
+--
+
+LOCK TABLES `svt_calibrations` WRITE;
+/*!40000 ALTER TABLE `svt_calibrations` DISABLE KEYS */;
+INSERT INTO `svt_calibrations` VALUES (1,1,1,144.439,4128.2),(2,1,2,73.8021,4221.44),(3,1,3,68.9208,4202.87),(4,1,4,67.5162,4212.69),(5,1,5,67.0612,4226.35),(6,1,6,66.8148,4277.98),(7,1,7,67.0852,4190.05),(8,1,8,66.6319,4249.81),(9,1,9,66.5855,4187.58),(10,1,10,66.5094,4280.37),(11,1,11,66.8626,4253.08),(12,1,12,67.2756,4201.57),(13,1,13,66.6692,4126.93),(14,1,14,66.3733,4240.99),(15,1,15,67.1244,4234.24),(16,1,16,67.267,4119.42),(17,1,17,67.417,4184.48),(18,1,18,66.8996,4141.2),(19,1,19,67.0237,4197.29),(20,1,20,67.2383,4252.4),(21,1,21,65.4174,4366.29),(22,1,22,65.4644,4314.95),(23,1,23,65.3006,4136.94),(24,1,24,66.7159,4287.62),(25,1,25,66.0618,4280.76),(26,1,26,65.9341,4197.06),(27,1,27,66.236,4256.05),(28,1,28,65.792,4295.79),(29,1,29,65.2681,4184.34),(30,1,30,65.2526,4164.29),(31,1,31,66.5423,4191.31),(32,1,32,65.142,4357.32),(33,1,33,110.69,4267.37),(34,1,34,70.185,4181.88),(35,1,35,65.4172,4263.31),(36,1,36,65.6101,4290.78),(37,1,37,64.9324,4295.53),(38,1,38,64.6467!
,4234.7),(39[...]
+/*!40000 ALTER TABLE `svt_calibrations` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `svt_channels`
+--
+
+DROP TABLE IF EXISTS `svt_channels`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `svt_channels` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `fpga` int(11) NOT NULL,
+ `hybrid` int(11) NOT NULL,
+ `channel` int(11) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=12801 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `svt_channels`
+--
+
+LOCK TABLES `svt_channels` WRITE;
+/*!40000 ALTER TABLE `svt_channels` DISABLE KEYS */;
+INSERT INTO `svt_channels` VALUES (1,0,0,0),(2,0,0,1),(3,0,0,2),(4,0,0,3),(5,0,0,4),(6,0,0,5),(7,0,0,6),(8,0,0,7),(9,0,0,8),(10,0,0,9),(11,0,0,10),(12,0,0,11),(13,0,0,12),(14,0,0,13),(15,0,0,14),(16,0,0,15),(17,0,0,16),(18,0,0,17),(19,0,0,18),(20,0,0,19),(21,0,0,20),(22,0,0,21),(23,0,0,22),(24,0,0,23),(25,0,0,24),(26,0,0,25),(27,0,0,26),(28,0,0,27),(29,0,0,28),(30,0,0,29),(31,0,0,30),(32,0,0,31),(33,0,0,32),(34,0,0,33),(35,0,0,34),(36,0,0,35),(37,0,0,36),(38,0,0,37),(39,0,0,38),(40,0,0,39),(41,0,0,40),(42,0,0,41),(43,0,0,42),(44,0,0,43),(45,0,0,44),(46,0,0,45),(47,0,0,46),(48,0,0,47),(49,0,0,48),(50,0,0,49),(51,0,0,50),(52,0,0,51),(53,0,0,52),(54,0,0,53),(55,0,0,54),(56,0,0,55),(57,0,0,56),(58,0,0,57),(59,0,0,58),(60,0,0,59),(61,0,0,60),(62,0,0,61),(63,0,0,62),(64,0,0,63),(65,0,0,64),(66,0,0,65),(67,0,0,66),(68,0,0,67),(69,0,0,68),(70,0,0,69),(71,0,0,70),(72,0,0,71),(73,0,0,72),(74,0,0,73),(75,0,0,74),(76,0,0,75),(77,0,0,76),(78,0,0,77),(79,0,0,78),(80,0,0,79),(81,0,0,80),(!
82,0,0,81),([...]
+/*!40000 ALTER TABLE `svt_channels` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `svt_daq_map`
+--
+
+DROP TABLE IF EXISTS `svt_daq_map`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `svt_daq_map` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `set_id` int(10) unsigned NOT NULL,
+ `half` tinyint(3) unsigned NOT NULL,
+ `layer` tinyint(3) unsigned NOT NULL,
+ `hybrid` tinyint(3) unsigned NOT NULL,
+ `fpga` tinyint(3) unsigned NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `svt_daq_map`
+--
+
+LOCK TABLES `svt_daq_map` WRITE;
+/*!40000 ALTER TABLE `svt_daq_map` DISABLE KEYS */;
+INSERT INTO `svt_daq_map` VALUES (1,1,1,1,1,4),(2,1,1,2,0,4),(3,1,1,3,0,3),(4,1,1,4,2,4),(5,1,1,5,2,3),(6,1,1,6,1,3),(7,1,1,7,1,6),(8,1,1,8,0,6),(9,1,1,9,2,6),(10,1,1,10,2,5),(11,1,0,1,1,0),(12,1,0,2,0,0),(13,1,0,3,0,1),(14,1,0,4,2,0),(15,1,0,5,2,1),(16,1,0,6,1,1),(17,1,0,7,1,2),(18,1,0,8,0,2),(19,1,0,9,2,2),(20,1,0,10,0,5);
+/*!40000 ALTER TABLE `svt_daq_map` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `svt_gains`
+--
+
+DROP TABLE IF EXISTS `svt_gains`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `svt_gains` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `set_id` int(11) NOT NULL,
+ `svt_channel_id` int(11) NOT NULL,
+ `gain` double NOT NULL,
+ `offset` double NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=13087 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `svt_gains`
+--
+
+LOCK TABLES `svt_gains` WRITE;
+/*!40000 ALTER TABLE `svt_gains` DISABLE KEYS */;
+INSERT INTO `svt_gains` VALUES (1,1,1,0.09041,168.54959),(2,1,2,0.09132,129.06331),(3,1,3,0.09269,121.73973),(4,1,4,0.09228,127.13628),(5,1,5,0.09474,116.85173),(6,1,6,0.0927,120.09408),(7,1,7,0.09368,125.54723),(8,1,8,0.09324,132.5109),(9,1,9,0.08913,118.85577),(10,1,10,0.08708,123.87396),(11,1,11,0.0887,115.30546),(12,1,12,0.08889,115.51142),(13,1,13,0.09074,107.8372),(14,1,14,0.08878,114.82484),(15,1,15,0.08972,121.13764),(16,1,16,0.08986,122.56405),(17,1,17,0.08839,120.55956),(18,1,18,0.08729,114.11262),(19,1,19,0.08823,114.78429),(20,1,20,0.08827,109.46955),(21,1,21,0.09049,103.61712),(22,1,22,0.0886,114.31911),(23,1,23,0.08998,105.11322),(24,1,24,0.08981,123.84481),(25,1,25,0.08868,115.05402),(26,1,26,0.08712,109.20123),(27,1,27,0.08794,106.37902),(28,1,28,0.08801,109.43693),(29,1,29,0.08965,105.21076),(30,1,30,0.08795,107.71108),(31,1,31,0.08927,109.57722),(32,1,32,0.08945,112.41569),(33,1,33,0.08953,189.18797),(34,1,34,0.08911,104.52473),(35,1,35,0.09018,106.40301),!
(36,1,36,0.0[...]
+/*!40000 ALTER TABLE `svt_gains` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `svt_pulse_parameters`
+--
+
+DROP TABLE IF EXISTS `svt_pulse_parameters`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `svt_pulse_parameters` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `set_id` int(11) NOT NULL,
+ `svt_channel_id` int(11) NOT NULL,
+ `amplitude` double NOT NULL,
+ `t0` double NOT NULL,
+ `tp` double NOT NULL,
+ `chisq` double NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=13113 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `svt_pulse_parameters`
+--
+
+LOCK TABLES `svt_pulse_parameters` WRITE;
+/*!40000 ALTER TABLE `svt_pulse_parameters` DISABLE KEYS */;
+INSERT INTO `svt_pulse_parameters` VALUES (1,1,1,2566.76,36.2141,49.5314,45.3601),(2,1,2,2557.65,34.8792,51.4634,1628.44),(3,1,3,2580.55,34.8269,52.3254,2590.75),(4,1,4,2570.08,34.9907,52.7496,2574.52),(5,1,5,2634.25,34.5281,52.3736,3388.62),(6,1,6,2579.41,34.612,52.3403,2630.34),(7,1,7,2607.43,34.6304,52.4653,3507.53),(8,1,8,2587.5,35.5808,53.9765,4339.65),(9,1,9,2470.49,35.1321,52.6679,1584.38),(10,1,10,2431.07,34.681,52.9538,3366.13),(11,1,11,2463.05,34.8131,52.8844,3758.31),(12,1,12,2464.5,34.9735,53.026,3184.54),(13,1,13,2515.97,34.6483,52.5323,3943.82),(14,1,14,2465.73,34.6363,52.6423,2967.8),(15,1,15,2499.96,34.6024,52.5392,3803.47),(16,1,16,2478.32,35.5557,54.264,4804.85),(17,1,17,2455.4,35.2826,52.6523,1719.91),(18,1,18,2424.47,34.8248,52.8653,3729.28),(19,1,19,2447.52,34.8615,53.0984,3929.35),(20,1,20,2447.24,35.057,53.049,3495.45),(21,1,21,2502.89,34.7726,52.4264,3836.1),(22,1,22,2458.68,34.7871,52.4676,2901.43),(23,1,23,2486.05,34.7067,52.6529,3915.48),(24,1,24,!
2483.28,35.7[...]
+/*!40000 ALTER TABLE `svt_pulse_parameters` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `svt_time_shifts`
+--
+
+DROP TABLE IF EXISTS `svt_time_shifts`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `svt_time_shifts` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `set_id` int(10) unsigned NOT NULL,
+ `fpga` tinyint(3) unsigned NOT NULL,
+ `hybrid` tinyint(3) unsigned NOT NULL,
+ `time_shift` double NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `svt_time_shifts`
+--
+
+LOCK TABLES `svt_time_shifts` WRITE;
+/*!40000 ALTER TABLE `svt_time_shifts` DISABLE KEYS */;
+INSERT INTO `svt_time_shifts` VALUES (1,1,0,1,1.5),(2,1,4,1,1),(3,1,0,0,1.6),(4,1,4,0,1.3),(5,1,1,0,-2.8),(6,1,3,0,-3),(7,1,0,2,2),(8,1,4,2,3.5),(9,1,1,2,-1.9),(10,1,3,2,0),(11,1,1,1,-2.2),(12,1,3,1,-0.5),(13,1,2,1,1.8),(14,1,6,1,-0.8),(15,1,2,0,1.2),(16,1,6,0,-1.1),(17,1,2,2,2.5),(18,1,6,2,3.5),(19,1,5,0,0),(20,1,5,2,-2.7);
+/*!40000 ALTER TABLE `svt_time_shifts` ENABLE KEYS */;
+UNLOCK TABLES;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+-- Dump completed on 2014-03-11 17:04:14
[Note: Some over-long lines of diff output only partialy shown]