11 lines
244 B
SQL
11 lines
244 B
SQL
DROP TABLE IF EXISTS `region`;
|
|
|
|
CREATE TABLE `region` (
|
|
`region_id` INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
`country_id` INT NOT NULL,
|
|
`name` TEXT NOT NULL,
|
|
`code` TEXT NOT NULL,
|
|
`status` TINYINT NOT NULL DEFAULT '1'
|
|
-- PRIMARY KEY (`region_id`)
|
|
);
|