--these are because we do the update process 

alter table skychunk add column P2_smf_version varchar(16) after parallel;
alter table skychunk add column ST_cmf_version varchar(16) after P2_smf_version;


alter table skychunk add trange_start timestamp after ST_cmf_version;
alter table skychunk add trange_end timestamp after trange_start; 	     	     

-- not yet alter table batch add column smf_version varchar(16) after comment;

alter table skychunk add column queue_FG tinyint after queue_FO;
alter table skychunk add column queue_GO tinyint after queue_FG;

alter table skychunk change column queue_FG queue_FG tinyint(1); 
alter table skychunk change column queue_GO queue_GO tinyint(1);
alter table skychunk change column queue_GO queue_GO tinyint(1) default 0;
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;


