Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 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 wypok
- -- -----------------------------------------------------
- -- -----------------------------------------------------
- -- Schema wypok
- -- -----------------------------------------------------
- CREATE SCHEMA IF NOT EXISTS `wypok` DEFAULT CHARACTER SET utf8 ;
- USE `wypok` ;
- -- -----------------------------------------------------
- -- Table `wypok`.`user`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `wypok`.`user` (
- `user_id` INT NOT NULL AUTO_INCREMENT,
- `username` VARCHAR(45) NOT NULL,
- `email` VARCHAR(60) NOT NULL,
- `is_active` TINYINT(1) NOT NULL,
- `password` VARCHAR(45) NOT NULL,
- PRIMARY KEY (`user_id`),
- UNIQUE INDEX `user_id_UNIQUE` (`user_id` ASC),
- UNIQUE INDEX `username_UNIQUE` (`username` ASC),
- UNIQUE INDEX `email_UNIQUE` (`email` ASC))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `wypok`.`discovery`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `wypok`.`discovery` (
- `discovery_id` INT NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(100) NOT NULL,
- `description` VARCHAR(250) NOT NULL,
- `url` VARCHAR(200) NOT NULL,
- `user_id` INT NOT NULL,
- `date` TIMESTAMP NOT NULL,
- `up_vote` INT NOT NULL,
- `down_vote` INT NOT NULL,
- PRIMARY KEY (`discovery_id`, `user_id`),
- UNIQUE INDEX `discovery_id_UNIQUE` (`discovery_id` ASC),
- UNIQUE INDEX `url_UNIQUE` (`url` ASC),
- INDEX `fk_discovery_user_idx` (`user_id` ASC),
- CONSTRAINT `fk_discovery_user`
- FOREIGN KEY (`user_id`)
- REFERENCES `wypok`.`user` (`user_id`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `wypok`.`role`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `wypok`.`role` (
- `role_name` VARCHAR(45) NOT NULL,
- `description` VARCHAR(120) NULL,
- PRIMARY KEY (`role_name`),
- UNIQUE INDEX `role_name_UNIQUE` (`role_name` ASC))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `wypok`.`vote`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `wypok`.`vote` (
- `vote_id` INT NOT NULL AUTO_INCREMENT,
- `discovery_id` INT NOT NULL,
- `user_id` INT NOT NULL,
- `date` TIMESTAMP NOT NULL,
- `type` VARCHAR(30) NOT NULL,
- PRIMARY KEY (`vote_id`, `discovery_id`, `user_id`),
- INDEX `fk_user_has_discovery_discovery1_idx` (`discovery_id` ASC),
- INDEX `fk_user_has_discovery_user1_idx` (`user_id` ASC),
- CONSTRAINT `fk_user_has_discovery_user1`
- FOREIGN KEY (`user_id`)
- REFERENCES `wypok`.`user` (`user_id`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `fk_user_has_discovery_discovery1`
- FOREIGN KEY (`discovery_id`)
- REFERENCES `wypok`.`discovery` (`discovery_id`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `wypok`.`user_role`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `wypok`.`user_role` (
- `role_name` VARCHAR(45) NOT NULL,
- `username` VARCHAR(45) NOT NULL,
- PRIMARY KEY (`role_name`, `username`),
- INDEX `fk_role_has_user_role1_idx` (`role_name` ASC),
- INDEX `fk_user_role_user_username_idx` (`username` ASC),
- CONSTRAINT `fk_role_has_user_role1`
- FOREIGN KEY (`role_name`)
- REFERENCES `wypok`.`role` (`role_name`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `fk_user_role_user_username`
- FOREIGN KEY (`username`)
- REFERENCES `wypok`.`user` (`username`)
- 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