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

Timestamp:

Feb 6, 2013, 3:16:35 PM (13 years ago)

Author:

eugene

Message:

upgrade to ippToPsps (see doc/upgrade.txt): adds native dvo to mysql ingest operations, adds autogen configuration & installation, splits out global config information from new "skychunk" information (current region on the sky being processed), adds test suites

Location:

trunk/ippToPsps

Files:

• . (modified) (1 prop)
• config (modified) (1 prop)
• config/ippToPspsDbSchema.sql (modified) (5 diffs)

trunk/ippToPsps/config/ippToPspsDbSchema.sql

@@ -58 +58 @@
   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `id` bigint(20) unsigned NOT NULL auto_increment,
-  `config` varchar(30) default NULL,
+  `skychunk` varchar(30) default NULL,
   `ra_center` float default NULL,
   `dec_center` float default NULL,
   `box_side` float default NULL,
+  `ingested` tinyint(1) default '0',
   PRIMARY KEY  (`id`),
-  KEY `fk_config` (`config`),
-  CONSTRAINT `fk_config` FOREIGN KEY (`config`) REFERENCES `config` (`name`) ON DELETE CASCADE
+  KEY `fk_skychunk` (`skychunk`),
+  CONSTRAINT `fk_skychunk` FOREIGN KEY (`skychunk`) REFERENCES `skychunk` (`name`) ON DELETE CASCADE
 ) ENGINE=InnoDB AUTO_INCREMENT=44588 DEFAULT CHARSET=latin1;
 SET character_set_client = @saved_cs_client;
@@ -80 +81 @@
   `pid` bigint(20) unsigned NOT NULL,
   `host` varchar(20) NOT NULL,
-  `config` varchar(30) default NULL,
+  `skychunk` varchar(30) default NULL,
   `paused` tinyint(1) default '0',
   `killed` tinyint(1) default '0',
@@ -91 +92 @@
 
 --
--- Table structure for table `config`
---
-
-DROP TABLE IF EXISTS `config`;
-SET @saved_cs_client     = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `config` (
+-- Table structure for table `skychunk`
+--
+
+DROP TABLE IF EXISTS `skychunk`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `skychunk` (
   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `name` varchar(30) NOT NULL,
@@ -122 +123 @@
   `queue_OB` tinyint(1) default '0',
   `active` tinyint(1) default '1',
+  `parallel` tinyint(1) default '0',
   UNIQUE KEY `name` (`name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
@@ -199 +201 @@
 CREATE TABLE `stripe` (
   `client_id` bigint(20) unsigned default NULL,
-  `config` varchar(30) default NULL,
+  `skychunk` varchar(30) default NULL,
   `ra_center` float default NULL,
   UNIQUE KEY `unique_key` (`client_id`),