Changeset 35076 for branches/eam_branches/ipp-20121219/ippToPsps/config

Timestamp:

Jan 31, 2013, 4:13:09 PM (13 years ago)

Author:

eugene

Message:

split out config (static info) and skychunk (area being processed)

File:

• branches/eam_branches/ipp-20121219/ippToPsps/config/ippToPspsDbSchema.sql (modified) (4 diffs)

branches/eam_branches/ipp-20121219/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,
   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 +80 @@
   `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 +91 @@
 
 --
--- 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,
@@ -200 +200 @@
 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`),