A COLLER POUR LA CREATION DES TABLES.txt

A COLLER POUR LA CREATION DES TABLES

CREATE TABLE `vbcms-test`.`vbcmsWebSys_blogCategories` ( `id` INT NOT NULL AUTO_INCREMENT , `slug` VARCHAR(128) NOT NULL , `showName` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL , `childOf` INT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;

CREATE TABLE IF NOT EXISTS `vbcms-blogDrafts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `randId` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
  `categoryId` int(11) DEFAULT NULL,
  `authorId` bigint(255) NOT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `subTitle` text COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `headerImage` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  `writtenOn` datetime NOT NULL,
  `modifiedOn` datetime NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `autosave` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `vbcms-blogPosts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `categoryId` int(11) DEFAULT NULL,
  `authorId` bigint(255) NOT NULL,
  `slug` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `subTitle` text COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `headerImage` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `writtenOn` datetime NOT NULL,
  `modifiedOn` datetime NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `views` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;