3
CREATE TABLE DB_TABLE_PREFIXLinkItem(
4
DB_COLUMN_PREFIXid int(11) NOT NULL,
5
DB_COLUMN_PREFIXlink varchar(128) NOT NULL,
6
PRIMARY KEY(DB_COLUMN_PREFIXid)
8
/*!40100 DEFAULT CHARACTER SET utf8 */;
10
INSERT INTO DB_TABLE_PREFIXSchema (
12
DB_COLUMN_PREFIXmajor,
14
) VALUES('LinkItem', 1, 0);
18
CREATE TABLE DB_TABLE_PREFIXLinkItem(
19
DB_COLUMN_PREFIXid INTEGER NOT NULL,
20
DB_COLUMN_PREFIXlink VARCHAR(128) NOT NULL
23
ALTER TABLE DB_TABLE_PREFIXLinkItem ADD PRIMARY KEY (DB_COLUMN_PREFIXid);
25
INSERT INTO DB_TABLE_PREFIXSchema (
27
DB_COLUMN_PREFIXmajor,
29
) VALUES('LinkItem', 1, 0);
33
CREATE TABLE DB_TABLE_PREFIXLinkItem(
34
DB_COLUMN_PREFIXid INTEGER NOT NULL,
35
DB_COLUMN_PREFIXlink VARCHAR2(128) NOT NULL
38
ALTER TABLE DB_TABLE_PREFIXLinkItem
39
ADD PRIMARY KEY (DB_COLUMN_PREFIXid)
42
INSERT INTO DB_TABLE_PREFIXSchema (
44
DB_COLUMN_PREFIXmajor,
46
) VALUES('LinkItem', 1, 0);
50
CREATE TABLE DB_TABLE_PREFIXLinkItem(
51
DB_COLUMN_PREFIXid INTEGER NOT NULL,
52
DB_COLUMN_PREFIXlink VARCHAR(128) NOT NULL
55
ALTER TABLE DB_TABLE_PREFIXLinkItem ADD PRIMARY KEY (DB_COLUMN_PREFIXid);
57
INSERT INTO DB_TABLE_PREFIXSchema (
59
DB_COLUMN_PREFIXmajor,
61
) VALUES('LinkItem', 1, 0);