17 lines
508 B
SQL
17 lines
508 B
SQL
DROP TABLE IF EXISTS `menu_item`;
|
|
|
|
CREATE TABLE `menu_item` (
|
|
`menu_item_id` INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
`menu_id` INT NOT NULL,
|
|
`type` TEXT NOT NULL DEFAULT 'link',
|
|
`url` TEXT NOT NULL DEFAULT '',
|
|
`parent_id` INT NOT NULL DEFAULT '0',
|
|
`item_id` INT DEFAULT NULL, -- post or product id
|
|
`options` TEXT NOT NULL DEFAULT '',
|
|
`sort_order` INTEGER NOT NULL DEFAULT 0,
|
|
`status` TINYINT NOT NULL DEFAULT 0
|
|
-- PRIMARY KEY (`menu_item_id`)
|
|
);
|
|
|
|
CREATE INDEX `menu_item_parent_id` ON `menu_item` (`parent_id`);
|