Changeset 36699 for trunk/ippToPsps/config/ippToPspsDbSchema.sql

Timestamp:

Apr 25, 2014, 5:25:22 PM (12 years ago)

Author:

heather

Message:

stuff to get databases in place and make the first schema pv2 init batch!

File:

• trunk/ippToPsps/config/ippToPspsDbSchema.sql (modified) (4 diffs)

trunk/ippToPsps/config/ippToPspsDbSchema.sql

@@ -45 +45 @@
   `stage_id` bigint(20) default NULL,
   `total_detections` bigint(20) default NULL,
+  `skychunk` varchar(400) default NULL,
+  `datastore_file` varchar(400) default NULL,
   `comment` varchar(400) default NULL,
   `purged` tinyint(4) NOT NULL default '0',
@@ -156 +158 @@
 
 --
+-- Table structure for table `forcedwarp`
+--
+
+DROP TABLE IF EXISTS `forcedwarp`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `forcedwarp` (
+  `batch_id` bigint(20) unsigned NOT NULL,
+  `exp_id` bigint(20) default NULL,
+  `filter` varchar(1) default NULL,
+  KEY `batch_id` (`batch_id`),
+  CONSTRAINT `detection_ibfk_1` FOREIGN KEY (`batch_id`) REFERENCES `batch` (`batch_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
 -- Table structure for table `object`
 --
@@ -163 +181 @@
 SET character_set_client = utf8;
 CREATE TABLE `object` (
+  `batch_id` bigint(20) unsigned NOT NULL,
+  `region` varchar(50) default NULL,
+  KEY `batch_id` (`batch_id`),
+  CONSTRAINT `object_fk_1` FOREIGN KEY (`batch_id`) REFERENCES `batch` (`batch_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+--
+-- Table structure for table `diffobject`
+--
+
+DROP TABLE IF EXISTS `diffobject`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `diffobject` (
   `batch_id` bigint(20) unsigned NOT NULL,
   `region` varchar(50) default NULL,
@@ -204 +236 @@
 
 --
+-- Table structure for table `diff`
+--
+
+DROP TABLE IF EXISTS `diff`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `diff` (
+  `batch_id` bigint(20) unsigned NOT NULL,
+  `filter` varchar(1) default NULL,
+  `diff_type` varchar(20) default NULL,
+  KEY `batch_id` (`batch_id`),
+  CONSTRAINT `stack_ibfk_1` FOREIGN KEY (`batch_id`) REFERENCES `batch` (`batch_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
 -- Table structure for table `stripe`
 --