1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| CREATE TABLE IF NOT EXISTS `commentaire` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`article_id` int(11) NOT NULL,
`body` longtext NOT NULL,
`createdAt` datetime NOT NULL,
`updatedAt` datetime NOT NULL,
PRIMARY KEY (`id`),
)
CREATE TABLE IF NOT EXISTS `article` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`isEnabled` tinyint(1) NOT NULL,
`subject` varchar(100) NOT NULL,
`body` longtext NOT NULL,
`createdAt` datetime NOT NULL,
`updatedAt` datetime NOT NULL,
`slug` varchar(200) NOT NULL,
PRIMARY KEY (`id`),
) |
Partager