17 lines
426 B
SQL
17 lines
426 B
SQL
DROP TABLE IF EXISTS `language`;
|
|
|
|
CREATE TABLE `language` (
|
|
`language_id` INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
`name` TEXT NOT NULL,
|
|
`code` TEXT NOT NULL,
|
|
`locale` TEXT NOT NULL,
|
|
`slug` TEXT NOT NULL,
|
|
`rtl` TINYINT NOT NULL DEFAULT 0,
|
|
`sort_order` INTEGER NOT NULL DEFAULT 0,
|
|
`status` TINYINT NOT NULL,
|
|
`default` TINYINT NOT NULL DEFAULT 0
|
|
-- PRIMARY KEY (`language_id`)
|
|
);
|
|
|
|
|
|
CREATE INDEX `language_name` ON `language` (`name`); |