hps-java/src/main

conditions_backup.sql added at 1.1

diff -N conditions_backup.sql
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ conditions_backup.sql	2 Oct 2013 23:13:12 -0000	1.1
@@ -0,0 +1,222 @@

+-- MySQL dump 10.13  Distrib 5.1.69, 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 `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=5 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-01 00:25:21','2013-09-30 17:25:21',NULL,NULL,NULL,NULL,'ecal_calibrations',NULL,'ecal_calibrations','set_id',1);
+/*!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.86333
 ,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.1
 90975),(53,[...]
+/*!40000 ALTER TABLE `ecal_gains` 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),(8
 2,0,0,81),([...]
+/*!40000 ALTER TABLE `svt_channels` 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 2013-10-02 11:20:32

[Note: Some over-long lines of diff output only partialy shown]

Commit in `hps-java/src/main` on MAIN
`conditions_backup.sql`	+222		added 1.1