HzpaaaVa

1
2drop database v8;
3
4SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
5SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
6SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
7
8-- -----------------------------------------------------
9-- Schema v8
10-- -----------------------------------------------------
11
12-- -----------------------------------------------------
13-- Schema v8
14-- -----------------------------------------------------
15CREATE SCHEMA IF NOT EXISTS `v8` DEFAULT CHARACTER SET utf8 ;
16USE `v8` ;
17
18-- -----------------------------------------------------
19-- Table `v8`.`status`
20-- -----------------------------------------------------
21CREATE TABLE IF NOT EXISTS `v8`.`status` (
22  `status_id` INT NOT NULL AUTO_INCREMENT COMMENT '상태를 관리하는 테이블',
23  `type` VARCHAR(50) NOT NULL COMMENT '상태를 저장하는 테이블',
24  PRIMARY KEY (`status_id`))
25ENGINE = InnoDB
26DEFAULT CHARACTER SET = utf8;