2
CREATE TABLE IF NOT EXISTS `datatype` (
3
`DataTypeID` smallint(6) NOT NULL,
4
`DataType` varchar(100) NOT NULL
5
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
7
CREATE TABLE IF NOT EXISTS `datasetcolumntype` (
8
`DataSetColumnTypeID` smallint(6) NOT NULL,
9
`DataSetColumnType` varchar(100) NOT NULL
10
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
12
INSERT INTO `datatype` (`DataTypeID`, `DataType`) VALUES
17
INSERT INTO `datasetcolumntype` (`DataSetColumnTypeID`, `DataSetColumnType`) VALUES
21
ALTER TABLE `datasetcolumn` ADD `DataSetColumnTypeID` smallint(6) NOT NULL AFTER `DataTypeID`;
22
ALTER TABLE `datasetcolumn` ADD `Formula` VARCHAR( 1000 ) NULL;
24
UPDATE `datasetcolumn` SET `DataSetColumnTypeID` = 1;
26
ALTER TABLE `display` ADD `GeoLocation` POINT NULL;
28
UPDATE `version` SET `app_ver` = '1.5.1', `XmdsVersion` = 3;
29
UPDATE `setting` SET `value` = 0 WHERE `setting` = 'PHONE_HOME_DATE';
30
UPDATE `version` SET `DBVersion` = '63';
b'\\ No newline at end of file'