12 lines
334 B
SQL
12 lines
334 B
SQL
DROP TABLE IF EXISTS `menu_item_content`;
|
|
|
|
CREATE TABLE `menu_item_content` (
|
|
`menu_item_id` INT NOT NULL,
|
|
`language_id` INT NOT NULL,
|
|
`name` TEXT NOT NULL DEFAULT '',
|
|
`slug` TEXT DEFAULT '',
|
|
`content` text NOT NULL,
|
|
PRIMARY KEY (`menu_item_id`,`language_id`)
|
|
);
|
|
|
|
CREATE INDEX `menu_item_content_name` ON `menu_item_content` (`name`); |