Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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';
- CREATE SCHEMA IF NOT EXISTS `cms` DEFAULT CHARACTER SET utf8 ;
- USE `cms` ;
- -- -----------------------------------------------------
- -- Table `cms`.`entry_type`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `cms`.`entry_type` (
- `id` INT NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(45) NOT NULL,
- PRIMARY KEY (`id`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `cms`.`entry`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `cms`.`entry` (
- `id` INT NOT NULL AUTO_INCREMENT,
- `title` VARCHAR(45) NOT NULL,
- `slug` VARCHAR(45) NOT NULL,
- `content` TEXT NOT NULL,
- `content_raw` TEXT NOT NULL,
- `entry_type_id` INT NOT NULL,
- PRIMARY KEY (`id`),
- INDEX `fk_entry_entry_type1_idx` (`entry_type_id` ASC),
- CONSTRAINT `fk_entry_entry_type1`
- FOREIGN KEY (`entry_type_id`)
- REFERENCES `cms`.`entry_type` (`id`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `cms`.`user`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `cms`.`user` (
- `id` INT NOT NULL AUTO_INCREMENT,
- `first_name` VARCHAR(45) NULL,
- `last_name` VARCHAR(45) NULL,
- `email` VARCHAR(45) NULL,
- `alias` VARCHAR(45) NOT NULL,
- `password_hash` VARCHAR(32) NOT NULL,
- `password_salt` VARCHAR(32) NOT NULL,
- PRIMARY KEY (`id`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `cms`.`profile_pic`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `cms`.`profile_pic` (
- `id` INT NOT NULL AUTO_INCREMENT,
- `content` BLOB NOT NULL,
- `user_id` INT NOT NULL,
- PRIMARY KEY (`id`),
- INDEX `fk_profile_pic_user1_idx` (`user_id` ASC),
- CONSTRAINT `fk_profile_pic_user1`
- FOREIGN KEY (`user_id`)
- REFERENCES `cms`.`user` (`id`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `cms`.`comment`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `cms`.`comment` (
- `id` INT NOT NULL,
- `content` TEXT NOT NULL,
- `content-raw` TEXT NOT NULL,
- `has_replies` TINYINT(1) NOT NULL DEFAULT false,
- `entry_id` INT NOT NULL,
- `user_id` INT NOT NULL,
- `reply_comment_id` INT NULL,
- PRIMARY KEY (`id`),
- INDEX `fk_comment_entry_idx` (`entry_id` ASC),
- INDEX `fk_comment_user1_idx` (`user_id` ASC),
- INDEX `fk_comment_comment1_idx` (`reply_comment_id` ASC),
- CONSTRAINT `fk_comment_entry`
- FOREIGN KEY (`entry_id`)
- REFERENCES `cms`.`entry` (`id`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `fk_comment_user1`
- FOREIGN KEY (`user_id`)
- REFERENCES `cms`.`user` (`id`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `fk_comment_comment1`
- FOREIGN KEY (`reply_comment_id`)
- REFERENCES `cms`.`comment` (`id`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `cms`.`permission`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `cms`.`permission` (
- `id` INT NOT NULL,
- `name` VARCHAR(45) NOT NULL,
- PRIMARY KEY (`id`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `cms`.`user_has_permission`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `cms`.`user_has_permission` (
- `user_id` INT NOT NULL,
- `permission_id` INT NOT NULL,
- PRIMARY KEY (`user_id`, `permission_id`),
- INDEX `fk_user_has_permission_permission1_idx` (`permission_id` ASC),
- INDEX `fk_user_has_permission_user1_idx` (`user_id` ASC),
- CONSTRAINT `fk_user_has_permission_user1`
- FOREIGN KEY (`user_id`)
- REFERENCES `cms`.`user` (`id`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `fk_user_has_permission_permission1`
- FOREIGN KEY (`permission_id`)
- REFERENCES `cms`.`permission` (`id`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `cms`.`image`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `cms`.`image` (
- `id` INT NOT NULL AUTO_INCREMENT,
- `title` VARCHAR(45) NOT NULL,
- `content` BLOB NOT NULL,
- PRIMARY KEY (`id`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `cms`.`template_set`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `cms`.`template_set` (
- `id` INT NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(45) NOT NULL,
- PRIMARY KEY (`id`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `cms`.`theme`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `cms`.`theme` (
- `id` INT NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(45) NOT NULL,
- `content` TEXT NOT NULL,
- `template_set_id` INT NOT NULL,
- PRIMARY KEY (`id`),
- INDEX `fk_theme_template_set1_idx` (`template_set_id` ASC),
- CONSTRAINT `fk_theme_template_set1`
- FOREIGN KEY (`template_set_id`)
- REFERENCES `cms`.`template_set` (`id`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `cms`.`template`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `cms`.`template` (
- `id` INT NOT NULL AUTO_INCREMENT,
- `template_set_id` INT NOT NULL,
- PRIMARY KEY (`id`),
- INDEX `fk_template_template_set1_idx` (`template_set_id` ASC),
- CONSTRAINT `fk_template_template_set1`
- FOREIGN KEY (`template_set_id`)
- REFERENCES `cms`.`template_set` (`id`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `cms`.`stylesheet`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `cms`.`stylesheet` (
- `id` INT NOT NULL,
- `content` TEXT NULL,
- `stylesheet_set_id` INT NOT NULL,
- PRIMARY KEY (`id`),
- INDEX `fk_stylesheet_stylesheet_set1_idx` (`stylesheet_set_id` ASC),
- CONSTRAINT `fk_stylesheet_stylesheet_set1`
- FOREIGN KEY (`stylesheet_set_id`)
- REFERENCES `cms`.`theme` (`id`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- SET SQL_MODE=@OLD_SQL_MODE;
- SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
- SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement