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

Timestamp:

Oct 9, 2013, 4:53:45 PM (13 years ago)

Author:

heather

Message:

added feature of time range for P2/ST - doesnt work for ST yet, queue those seperately

File:

• trunk/ippToPsps/config/ippToPspsDbSchema.sql (modified) (1 diff)

trunk/ippToPsps/config/ippToPspsDbSchema.sql

@@ -129 +129 @@
   `P2_smf_version` varchar(16) default NULL,
   `ST_cmf_version` varchar(16) default NULL, 
+  `trange_start`  timestamp NOT NULL default '0000-00-00 00:00:00',
+  `trange_end` timestamp NOT NULL default '0000-00-00 00:00:00',  
   UNIQUE KEY `name` (`name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;