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 0,
`default` TINYINT NOT NULL DEFAULT 0
-- PRIMARY KEY (`language_id`)
);


CREATE INDEX `language_name` ON `language` (`name`);
