kWvHJd9L

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5CREATE SCHEMA IF NOT EXISTS `chats` DEFAULT CHARACTER SET utf8 COLLATE default collation ;
6
7-- -----------------------------------------------------
8-- Table `chats`.`chat`
9-- -----------------------------------------------------
10CREATE  TABLE IF NOT EXISTS `chats`.`chat` (
11  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
12  PRIMARY KEY (`id`) )
13ENGINE = InnoDB;
14
15
16-- -----------------------------------------------------
17-- Table `chats`.`chat_user`
18-- -----------------------------------------------------
19CREATE  TABLE IF NOT EXISTS `chats`.`chat_user` (
20  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
21  `handle` VARCHAR(45) NOT NULL ,
22  PRIMARY KEY (`id`) )
23ENGINE = InnoDB;
24
25
26-- -----------------------------------------------------
27-- Table `chats`.`chat_line`
28-- -----------------------------------------------------
29CREATE  TABLE IF NOT EXISTS `chats`.`chat_line` (
30  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
31  `chat_id` INT UNSIGNED NOT NULL ,
32  `user_id` INT UNSIGNED NOT NULL ,
33  `line_text` TEXT NOT NULL ,
34  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
35  PRIMARY KEY (`id`) ,
36  INDEX `fk_chat_line_chat` (`chat_id` ASC) ,
37  INDEX `fk_chat_line_chat_user1` (`user_id` ASC) ,
38  CONSTRAINT `fk_chat_line_chat`
39    FOREIGN KEY (`chat_id` )
40    REFERENCES `chats`.`chat` (`id` )
41    ON DELETE NO ACTION
42    ON UPDATE NO ACTION,
43  CONSTRAINT `fk_chat_line_chat_user1`
44    FOREIGN KEY (`user_id` )
45    REFERENCES `chats`.`chat_user` (`id` )
46    ON DELETE NO ACTION
47    ON UPDATE NO ACTION)
48ENGINE = InnoDB;
49
50
51
52SET SQL_MODE=@OLD_SQL_MODE;
53SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
54SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;