1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| CREATE TABLE IF NOT EXISTS `text_component` (
`id_text_component` int(1) NOT NULL,
`id_text_template` varchar(20) DEFAULT NULL,
`sound` varchar(300) DEFAULT NULL,
`mute` tinyint(1) NOT NULL,
PRIMARY KEY (`id_text_component`),
KEY `id_text_template` (`id_text_template`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `text_component` (`id_text_component`, `id_text_template`, `sound`, `mute`) VALUES
(1, NULL, NULL, 0);
CREATE TABLE IF NOT EXISTS `text_panel` (
`id_panel` int(11) NOT NULL,
`id_text_template` varchar(20) DEFAULT NULL,
`content` longtext NOT NULL,
PRIMARY KEY (`id_panel`),
KEY `id_text_template` (`id_text_template`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `text_template` (
`id_text_template` varchar(20) NOT NULL,
`label` varchar(200) NOT NULL,
PRIMARY KEY (`id_text_template`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
Partager