-- MySQL Script generated by MySQL Workbench
-- Mon Jul 23 12:07:14 2018
-- Model: New Model Version: 1.0
-- MySQL Workbench Forward Engineering
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
-- -----------------------------------------------------
-- Schema melisv2
-- -----------------------------------------------------
-- -----------------------------------------------------
-- Table `melis_cms_page_tree`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `melis_cms_page_tree` (
`tree_page_id` INT(11) NOT NULL,
`tree_father_page_id` INT(11) NOT NULL DEFAULT '-1',
`tree_page_order` INT(11) NOT NULL,
PRIMARY KEY (`tree_page_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = 'List of Melis pages, and their parents';
-- -----------------------------------------------------
-- Table `melis_cms_lang`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `melis_cms_lang` (
`lang_cms_id` INT NOT NULL AUTO_INCREMENT,
`lang_cms_locale` VARCHAR(10) NOT NULL,
`lang_cms_name` VARCHAR(45) NOT NULL,
PRIMARY KEY (`lang_cms_id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `melis_cms_page_lang`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `melis_cms_page_lang` (
`plang_id` INT(11) NOT NULL AUTO_INCREMENT,
`plang_page_id` INT(11) NOT NULL,
`plang_lang_id` INT(11) NOT NULL,
`plang_page_id_initial` INT(11) NOT NULL,
PRIMARY KEY (`plang_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = 'Relation between pages and lang';
-- -----------------------------------------------------
-- Table `melis_cms_site`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `melis_cms_site` (
`site_id` INT(11) NOT NULL AUTO_INCREMENT,
`site_name` VARCHAR(45) NOT NULL,
`site_label` VARCHAR (100) NOT NULL,
`site_main_page_id` INT(11) NOT NULL,
PRIMARY KEY (`site_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = 'List of melis websites declared';
-- -----------------------------------------------------
-- Table `melis_cms_template`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `melis_cms_template` (
`tpl_id` INT(11) NOT NULL,
`tpl_site_id` INT(11) NOT NULL,
`tpl_name` VARCHAR(255) NOT NULL,
`tpl_type` ENUM('PHP','ZF2') NOT NULL DEFAULT 'ZF2',
`tpl_zf2_website_folder` VARCHAR(50) NULL DEFAULT NULL,
`tpl_zf2_layout` VARCHAR(50) NULL DEFAULT NULL,
`tpl_zf2_controller` VARCHAR(50) NULL DEFAULT NULL,
`tpl_zf2_action` VARCHAR(50) NULL DEFAULT NULL,
`tpl_php_path` VARCHAR(150) NULL DEFAULT NULL,
`tpl_creation_date` DATETIME NULL,
`tpl_last_user_id` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`tpl_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = 'List of Melis Templates used by the pages';
-- -----------------------------------------------------
-- Table `melis_cms_page_published`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `melis_cms_page_published` (
`page_id` INT(11) NOT NULL,
`page_type` ENUM('SITE', 'FOLDER', 'PAGE', 'NEWSLETTER') NOT NULL DEFAULT 'PAGE',
`page_status` TINYINT(4) NOT NULL DEFAULT '1',
`page_menu` ENUM('LINK','NOLINK','NONE') NOT NULL DEFAULT 'LINK',
`page_name` VARCHAR(255) NOT NULL,
`page_tpl_id` INT(11) NOT NULL,
`page_content` LONGTEXT NULL DEFAULT NULL,
`page_taxonomy` TEXT NULL,
`page_creation_date` DATETIME NULL DEFAULT NULL,
`page_edit_date` DATETIME NULL DEFAULT NULL,
`page_last_user_id` INT(11) NULL DEFAULT NULL,
`page_search_type` VARCHAR(60) NOT NULL DEFAULT 'tr_meliscms_page_tab_properties_search_type_option1',
PRIMARY KEY (`page_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = 'List of published pages';
-- -----------------------------------------------------
-- Table `melis_cms_page_saved`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `melis_cms_page_saved` (
`page_id` INT(11) NOT NULL,
`page_type` ENUM('SITE', 'FOLDER', 'PAGE', 'NEWSLETTER') NOT NULL DEFAULT 'PAGE',
`page_status` TINYINT(4) NOT NULL DEFAULT '1',
`page_menu` ENUM('LINK','NOLINK','NONE') NOT NULL DEFAULT 'LINK',
`page_name` VARCHAR(255) NOT NULL,
`page_tpl_id` INT(11) NOT NULL,
`page_content` LONGTEXT NULL DEFAULT NULL,
`page_taxonomy` TEXT NULL,
`page_creation_date` DATETIME NULL,
`page_edit_date` DATETIME NULL,
`page_last_user_id` INT(11) NULL DEFAULT NULL,
`page_search_type` VARCHAR(60) NOT NULL DEFAULT 'tr_meliscms_page_tab_properties_search_type_option1',
PRIMARY KEY (`page_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = 'List of saved pages';
-- -----------------------------------------------------
-- Table `melis_cms_page_seo`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `melis_cms_page_seo` (
`pseo_id` INT(11) NOT NULL,
`pseo_url` VARCHAR(255) NULL,
`pseo_url_redirect` VARCHAR(255) NULL,
`pseo_url_301` VARCHAR(255) NULL,
`pseo_meta_title` TEXT NULL,
`pseo_meta_description` TEXT NULL,
PRIMARY KEY (`pseo_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = 'SEO datas for pages';
-- -----------------------------------------------------
-- Table `melis_cms_platform_ids`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `melis_cms_platform_ids` (
`pids_id` INT(11) NOT NULL AUTO_INCREMENT,
`pids_page_id_start` INT(11) NOT NULL,
`pids_page_id_current` INT(11) NOT NULL,
`pids_page_id_end` INT(11) NOT NULL,
`pids_tpl_id_start` INT(11) NOT NULL,
`pids_tpl_id_current` INT(11) NOT NULL,
`pids_tpl_id_end` INT(11) NOT NULL,
PRIMARY KEY (`pids_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = 'Saves ids intervals for each environment so that no duplicate id can occur between platforms';
-- -----------------------------------------------------
-- Table `melis_cms_site_404`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `melis_cms_site_404` (
`s404_id` INT(11) NOT NULL AUTO_INCREMENT,
`s404_site_id` INT(11) NOT NULL,
`s404_page_id` INT(11) NOT NULL,
PRIMARY KEY (`s404_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = 'List of 404 pages per site';
-- -----------------------------------------------------
-- Table `melis_cms_site_domain`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `melis_cms_site_domain` (
`sdom_id` INT(11) NOT NULL AUTO_INCREMENT,
`sdom_site_id` INT(11) NOT NULL,
`sdom_env` VARCHAR(50) NOT NULL,
`sdom_scheme` VARCHAR(10) NOT NULL,
`sdom_domain` VARCHAR(50) NOT NULL,
PRIMARY KEY (`sdom_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = 'List of domains per site and per environments';
-- -----------------------------------------------------
-- Table `melis_cms_site_301`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `melis_cms_site_301` (
`s301_id` INT NOT NULL AUTO_INCREMENT COMMENT 'site redirect id',
`s301_site_id` INT NULL COMMENT 'Site Id',
`s301_old_url` VARCHAR(255) NOT NULL COMMENT 'Old Site url',
`s301_new_url` VARCHAR(255) NOT NULL COMMENT 'New Site url',
PRIMARY KEY (`s301_id`))
ENGINE = InnoDB
COMMENT = 'Site redirect';
-- -----------------------------------------------------
-- Table `melis_cms_page_default_urls`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `melis_cms_page_default_urls` (
`purl_page_id` INT NOT NULL AUTO_INCREMENT,
`purl_page_url` VARCHAR(255) NOT NULL,
PRIMARY KEY (`purl_page_id`))
ENGINE = InnoDB
COMMENT = 'This table saves the URLs of all pages, avoiding generation on demand by juste requesting it';
-- -----------------------------------------------------
-- Table `melis_cms_style`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `melis_cms_style` (
`style_id` INT(11) NOT NULL AUTO_INCREMENT,
`style_site_id` INT(11) NOT NULL,
`style_name` VARCHAR(255) NOT NULL,
`style_status` SMALLINT NOT NULL,
`style_path` VARCHAR(255) NOT NULL,
PRIMARY KEY (`style_id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `melis_cms_page_style`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `melis_cms_page_style` (
`pstyle_id` INT NOT NULL AUTO_INCREMENT COMMENT 'Table\'s primary key',
`pstyle_page_id` INT(11) NOT NULL,
`pstyle_style_id` INT(11) NOT NULL,
PRIMARY KEY (`pstyle_id`))
ENGINE = InnoDB;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
-- -----------------------------------------------------
-- Data for table `melis_cms_lang`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `melis_cms_lang` (`lang_cms_id`, `lang_cms_locale`, `lang_cms_name`) VALUES (1, 'en_EN', 'English');
INSERT INTO `melis_cms_lang` (`lang_cms_id`, `lang_cms_locale`, `lang_cms_name`) VALUES (2, 'fr_FR', 'Français');
COMMIT;
-- -----------------------------------------------------
-- Data for table `melis_cms_site_404`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `melis_cms_site_404` (`s404_id`, `s404_site_id`, `s404_page_id`) VALUES (1, -1, 1);
COMMIT;
-- -----------------------------------------------------
-- Table `melis_cms_gdpr_texts`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `melis_cms_gdpr_texts`;
CREATE TABLE IF NOT EXISTS `melis_cms_gdpr_texts` (
`mcgdpr_text_id` INT NOT NULL AUTO_INCREMENT,
`mcgdpr_text_site_id` INT(11) NOT NULL,
`mcgdpr_text_lang_id` INT NOT NULL,
`mcgdpr_text_value` LONGTEXT NOT NULL,
PRIMARY KEY (`mcgdpr_text_id`))
ENGINE = InnoDB;
|