3
CREATE TABLE DB_TABLE_PREFIXG1MigrateMap(
4
DB_COLUMN_PREFIXitemId int(11) NOT NULL,
5
DB_COLUMN_PREFIXg1album varchar(128) NOT NULL,
6
DB_COLUMN_PREFIXg1item varchar(128),
7
PRIMARY KEY(DB_COLUMN_PREFIXitemId)
9
/*!40100 DEFAULT CHARACTER SET utf8 */;
11
INSERT INTO DB_TABLE_PREFIXSchema (
13
DB_COLUMN_PREFIXmajor,
15
) VALUES('G1MigrateMap', 1, 0);
19
CREATE TABLE DB_TABLE_PREFIXG1MigrateMap(
20
DB_COLUMN_PREFIXitemId INTEGER NOT NULL,
21
DB_COLUMN_PREFIXg1album VARCHAR(128) NOT NULL,
22
DB_COLUMN_PREFIXg1item VARCHAR(128)
25
ALTER TABLE DB_TABLE_PREFIXG1MigrateMap ADD PRIMARY KEY (DB_COLUMN_PREFIXitemId);
27
INSERT INTO DB_TABLE_PREFIXSchema (
29
DB_COLUMN_PREFIXmajor,
31
) VALUES('G1MigrateMap', 1, 0);
35
CREATE TABLE DB_TABLE_PREFIXG1MigrateMap(
36
DB_COLUMN_PREFIXitemId INTEGER NOT NULL,
37
DB_COLUMN_PREFIXg1album VARCHAR2(128) NOT NULL,
38
DB_COLUMN_PREFIXg1item VARCHAR2(128)
41
ALTER TABLE DB_TABLE_PREFIXG1MigrateMap
42
ADD PRIMARY KEY (DB_COLUMN_PREFIXitemId)
45
INSERT INTO DB_TABLE_PREFIXSchema (
47
DB_COLUMN_PREFIXmajor,
49
) VALUES('G1MigrateMap', 1, 0);
53
CREATE TABLE DB_TABLE_PREFIXG1MigrateMap(
54
DB_COLUMN_PREFIXitemId INTEGER NOT NULL,
55
DB_COLUMN_PREFIXg1album VARCHAR(128) NOT NULL,
56
DB_COLUMN_PREFIXg1item VARCHAR(128)
59
ALTER TABLE DB_TABLE_PREFIXG1MigrateMap ADD PRIMARY KEY (DB_COLUMN_PREFIXitemId);
61
INSERT INTO DB_TABLE_PREFIXSchema (
63
DB_COLUMN_PREFIXmajor,
65
) VALUES('G1MigrateMap', 1, 0);