DROP TABLE IF EXISTS `babyfeed`.`tbl_blog` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_blog` (
  `b_no` INT NOT NULL AUTO_INCREMENT,
  `child_m` INT NOT NULL DEFAULT 0,
  `b_content` VARCHAR(500) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL,
  `member_id` VARCHAR(30) NOT NULL,
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL,
  `cate1_cd_no` VARCHAR(30) NOT NULL,
  `cate2_cd_no` VARCHAR(30) NOT NULL,
  PRIMARY KEY (`b_no`))
ENGINE = InnoDB;

-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_blog_view`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_blog_view` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_blog_view` (
  `bv_no` INT NOT NULL AUTO_INCREMENT,
  `member_id` VARCHAR(30) NOT NULL,
  `reg_dt` DATETIME NOT NULL,
  `b_no` INT NOT NULL,
  PRIMARY KEY (`bv_no`))
ENGINE = InnoDB;


CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_blog_like` (
  `bl_no` INT NOT NULL AUTO_INCREMENT,
  `member_id` VARCHAR(30) NOT NULL,
  `reg_dt` DATETIME NOT NULL,
  `b_no` INT NOT NULL,
  PRIMARY KEY (`member_id`, `b_no`),
  UNIQUE INDEX `bl_no_UNIQUE` (`bl_no` ASC))
ENGINE = InnoDB;

-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_blog_comment_like`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_blog_comment_like` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_blog_comment_like` (
  `bcl_no` INT NOT NULL AUTO_INCREMENT,
  `member_id` VARCHAR(30) NOT NULL,
  `reg_dt` DATETIME NOT NULL,
  `bc_id` INT NOT NULL,
  PRIMARY KEY (`bcl_no`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_blog_img`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_blog_img` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_blog_img` (
  `bi_no` INT NOT NULL AUTO_INCREMENT,
  `append_src_img_file` BIGINT(20) NOT NULL,
  `append_300_img_file` VARCHAR(20) NOT NULL,
  `reg_dt` DATETIME NOT NULL,
  `b_no` INT NOT NULL,
  PRIMARY KEY (`bi_no`))
ENGINE = InnoDB;


DROP TABLE IF EXISTS `babyfeed`.`tbl_blog_tag` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_blog_tag` (
  `tag_seq` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `tag` VARCHAR(30) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL,
  `reg_dt` DATETIME NOT NULL,
  PRIMARY KEY (`tag_seq`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_r_blog_tag`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_r_blog_tag` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_r_blog_tag` (
  `rbt_no` INT NOT NULL AUTO_INCREMENT,
  `reg_dt` DATETIME NOT NULL,
  `b_no` INT NOT NULL,
  `tag_seq` BIGINT(20) NOT NULL,
  PRIMARY KEY (`rbt_no`))
ENGINE = InnoDB;






insert into tbl_blog_like (member_id, reg_dt, b_no) values ('test1', now(), 1);
insert into tbl_blog_like (member_id, reg_dt, b_no) values ('test1', now(), 2);
insert into tbl_blog_like (member_id, reg_dt, b_no) values ('test1', now(), 3);
insert into tbl_blog_like (member_id, reg_dt, b_no) values ('test2', now(), 2);
insert into tbl_blog_like (member_id, reg_dt, b_no) values ('test3', now(), 2);
insert into tbl_blog_like (member_id, reg_dt, b_no) values ('test3', now(), 3);

insert into tbl_blog_view (member_id, reg_dt, b_no) values ('test1', now(), 1);
insert into tbl_blog_view (member_id, reg_dt, b_no) values ('test2', now(), 2);
insert into tbl_blog_view (member_id, reg_dt, b_no) values ('test2', now(), 2);
insert into tbl_blog_view (member_id, reg_dt, b_no) values ('test2', now(), 2);
insert into tbl_blog_view (member_id, reg_dt, b_no) values ('test2', now(), 2);
insert into tbl_blog_view (member_id, reg_dt, b_no) values ('test2', now(), 2);
insert into tbl_blog_view (member_id, reg_dt, b_no) values ('test2', now(), 2);
insert into tbl_blog_view (member_id, reg_dt, b_no) values ('test3', now(), 2);
insert into tbl_blog_view (member_id, reg_dt, b_no) values ('test3', now(), 3);