89 lines
2.4 KiB
Smarty
89 lines
2.4 KiB
Smarty
## mysql
|
|
# PermalinksMap
|
|
CREATE TABLE DB_TABLE_PREFIXPermalinksMap(
|
|
DB_COLUMN_PREFIXaliasName varchar(128) NOT NULL,
|
|
DB_COLUMN_PREFIXdestId int(11) NOT NULL,
|
|
PRIMARY KEY(DB_COLUMN_PREFIXaliasName),
|
|
INDEX DB_TABLE_PREFIXPermalinksMap_84225(DB_COLUMN_PREFIXdestId)
|
|
) DB_TABLE_TYPE
|
|
/*!40100 DEFAULT CHARACTER SET utf8 */;
|
|
|
|
INSERT INTO DB_TABLE_PREFIXSchema (
|
|
DB_COLUMN_PREFIXname,
|
|
DB_COLUMN_PREFIXmajor,
|
|
DB_COLUMN_PREFIXminor
|
|
) VALUES('PermalinksMap', 1, 0);
|
|
|
|
## postgres
|
|
# PermalinksMap
|
|
CREATE TABLE DB_TABLE_PREFIXPermalinksMap(
|
|
DB_COLUMN_PREFIXaliasName VARCHAR(128) NOT NULL,
|
|
DB_COLUMN_PREFIXdestId INTEGER NOT NULL
|
|
);
|
|
|
|
ALTER TABLE DB_TABLE_PREFIXPermalinksMap ADD PRIMARY KEY (DB_COLUMN_PREFIXaliasName);
|
|
|
|
CREATE INDEX DB_TABLE_PREFIXPermalinksMap_84225 ON DB_TABLE_PREFIXPermalinksMap(DB_COLUMN_PREFIXdestId);
|
|
|
|
INSERT INTO DB_TABLE_PREFIXSchema (
|
|
DB_COLUMN_PREFIXname,
|
|
DB_COLUMN_PREFIXmajor,
|
|
DB_COLUMN_PREFIXminor
|
|
) VALUES('PermalinksMap', 1, 0);
|
|
|
|
## oracle
|
|
# PermalinksMap
|
|
CREATE TABLE DB_TABLE_PREFIXPermalinksMap(
|
|
DB_COLUMN_PREFIXaliasName VARCHAR2(128) NOT NULL,
|
|
DB_COLUMN_PREFIXdestId INTEGER NOT NULL
|
|
);
|
|
|
|
CREATE INDEX DB_TABLE_PREFIXPermalinksMap_84225
|
|
ON DB_TABLE_PREFIXPermalinksMap(DB_COLUMN_PREFIXdestId);
|
|
|
|
ALTER TABLE DB_TABLE_PREFIXPermalinksMap
|
|
ADD PRIMARY KEY (DB_COLUMN_PREFIXaliasName)
|
|
;
|
|
|
|
INSERT INTO DB_TABLE_PREFIXSchema (
|
|
DB_COLUMN_PREFIXname,
|
|
DB_COLUMN_PREFIXmajor,
|
|
DB_COLUMN_PREFIXminor
|
|
) VALUES('PermalinksMap', 1, 0);
|
|
|
|
## db2
|
|
# PermalinksMap
|
|
CREATE TABLE DB_TABLE_PREFIXPermalinksMap(
|
|
DB_COLUMN_PREFIXaliasName VARCHAR(128) NOT NULL,
|
|
DB_COLUMN_PREFIXdestId INTEGER NOT NULL
|
|
);
|
|
|
|
ALTER TABLE DB_TABLE_PREFIXPermalinksMap ADD PRIMARY KEY (DB_COLUMN_PREFIXaliasName);
|
|
|
|
CREATE INDEX DB_TABLE_PREFIXPerma66_84225
|
|
ON DB_TABLE_PREFIXPermalinksMap(DB_COLUMN_PREFIXdestId);
|
|
|
|
INSERT INTO DB_TABLE_PREFIXSchema (
|
|
DB_COLUMN_PREFIXname,
|
|
DB_COLUMN_PREFIXmajor,
|
|
DB_COLUMN_PREFIXminor
|
|
) VALUES('PermalinksMap', 1, 0);
|
|
|
|
## mssql
|
|
# PermalinksMap
|
|
CREATE TABLE DB_TABLE_PREFIXPermalinksMap(
|
|
DB_COLUMN_PREFIXaliasName NVARCHAR(128) NOT NULL,
|
|
DB_COLUMN_PREFIXdestId INT NOT NULL
|
|
);
|
|
|
|
ALTER TABLE DB_TABLE_PREFIXPermalinksMap ADD PRIMARY KEY (DB_COLUMN_PREFIXaliasName);
|
|
|
|
CREATE INDEX DB_TABLE_PREFIXPermalinksMap_84225 ON DB_TABLE_PREFIXPermalinksMap(DB_COLUMN_PREFIXdestId);
|
|
|
|
INSERT INTO DB_TABLE_PREFIXSchema (
|
|
DB_COLUMN_PREFIXname,
|
|
DB_COLUMN_PREFIXmajor,
|
|
DB_COLUMN_PREFIXminor
|
|
) VALUES('PermalinksMap', 1, 0);
|
|
|