Changeset 39970

Timestamp:

Feb 2, 2017, 11:12:57 AM (9 years ago)

Author:

heather

Message:

gaia schema changes, forgot to check in

Location:

trunk/ippToPsps/config

Files:

• changes.txt (modified) (1 diff)
• render.pl (modified) (1 diff)
• settings.xml (modified) (1 diff)

trunk/ippToPsps/config/changes.txt

@@ -18 +18 @@
 alter table skychunk change column queue_FO queue_FO tinyint(1) default 0;
 alter table skychunk change column queue_FG queue_FG tinyint(1) default 0;
+
+
+--
+-- Table structure for table `forcedgalobject`
+--
+DROP TABLE IF EXISTS `forcedgalobject`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `forcedgalobject` (
+  `batch_id` bigint(20) unsigned NOT NULL,
+  `region` varchar(50) default NULL,
+  KEY `batch_id` (`batch_id`),
+  CONSTRAINT `forcedgalobject_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 `gaiaobject`
+--
+DROP TABLE IF EXISTS `gaiaobject`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `gaiaobject` (
+  `batch_id` bigint(20) unsigned NOT NULL,
+  `region` varchar(50) default NULL,
+  KEY `batch_id` (`batch_id`),
+  CONSTRAINT `gaiaobject_fk_1` FOREIGN KEY (`batch_id`) REFERENCES `batch` (`batch_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+

trunk/ippToPsps/config/render.pl

@@ -2 +2 @@
 
 
-my @tables = ('IN','P2','OB','ST','DF','DO','FW','FG','FO');
+my @tables = ('IN','P2','OB','ST','DF','DO','FW','FG','FO','GO');
 # my @tables = ('P2');
 

trunk/ippToPsps/config/settings.xml

@@ -819 +819 @@
   <!-- ippToPsps Db section (REAL version) -->
   <ipptopspsdatabase>
-    <name>ipptopsps3</name>
+    <name>ipptopsps2</name>
     <host>ipp006</host>
     <user>dvo</user>