Changeset 39922 for branches/czw_branch/20160809/ippToPsps/config/ippToPspsDbSchema.sql

Timestamp:

Jan 6, 2017, 11:16:30 AM (10 years ago)

Author:

eugene

Message:

merge changes from trunk

File:

• branches/czw_branch/20160809/ippToPsps/config/ippToPspsDbSchema.sql (modified) (2 diffs)

branches/czw_branch/20160809/ippToPsps/config/ippToPspsDbSchema.sql

@@ -111 +111 @@
   `queue_FW` tinyint(1) default '0',
   `queue_FO` tinyint(1) default '0',
+  `queue_FG` tinyint(1) default '0',    
+  `queue_GO` tinyint(1) default '0',
   `active` tinyint(1) default '1',
   `parallel` tinyint(1) default '0',
@@ -217 +219 @@
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 SET character_set_client = @saved_cs_client;
+--
+-- 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;
+
 
 --