13 lines
288 B
SQL
13 lines
288 B
SQL
DROP TABLE IF EXISTS `site`;
|
|
|
|
CREATE TABLE `site` (
|
|
`site_id` INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
`key` TEXT NOT NULL,
|
|
`name` TEXT NOT NULL,
|
|
`host` TEXT NOT NULL,
|
|
`theme` TEXT NOT NULL,
|
|
`template` TEXT NOT NULL DEFAULT '',
|
|
`settings` TEXT NOT NULL DEFAULT ''
|
|
-- PRIMARY KEY (`site_id`)
|
|
);
|