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

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_notice` (
  `gn_no` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `tp_cd_no` VARCHAR(30) NOT NULL,
  `n_title` VARCHAR(100) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL,
  `n_content` TEXT CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NULL DEFAULT NULL,
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL DEFAULT NULL,
  `sys_member_id` VARCHAR(100) NOT NULL,
  PRIMARY KEY (`gn_no`),
  INDEX `fk_tbl_notice_tbl_code_item_str1_idx` (`tp_cd_no` ASC))
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8;


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

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_notice_img` (
  `gni_no` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `append_src_img_file` BIGINT(20) NOT NULL,
  `append_300_img_file` BIGINT(20) NULL DEFAULT NULL,
  `gn_no` BIGINT(20) NOT NULL,
  PRIMARY KEY (`gni_no`),
  INDEX `fk_tbl_notice_img_tbl_notice1_idx` (`gn_no` ASC))
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8;


INSERT tbl_code_group (cg_cd, title, reg_dt, sys_member_id) Values ('M_BRD_TEXT_TP', '모바일 공지사항 글타입', now(), 'renamaestro');
INSERT tbl_code_item_str (cd_no, title, order_no, reg_dt, sys_member_id, cg_cd) Values ('M_BRD_TEXT_TP_NOTICE', '공지', 1, now(), 'renamaestro', 'M_BRD_TEXT_TP');





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

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_bf_alarm` (
  `sa_no` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `to_member_id` VARCHAR(30) NOT NULL,
  `a_title` VARCHAR(100) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NOT NULL,
  `a_link` VARCHAR(300) CHARACTER SET 'utf8' NULL DEFAULT NULL,  
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL DEFAULT NULL,
  PRIMARY KEY (`sa_no`))
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8;


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

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_bf_r_alarm_chk` (
  `sac_no` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sa_no` BIGINT(20) NOT NULL,
  `member_id` VARCHAR(30) NOT NULL,
  `reg_dt` DATETIME NOT NULL,
  PRIMARY KEY (`sa_no`, `member_id`),
  UNIQUE INDEX `sac_no_UNIQUE` (`sac_no` ASC))
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8;


INSERT tbl_bf_alarm (to_member_id, a_title, a_link, reg_dt) values ('renamaestro', '3월 신학기 계획을 잘 작성하세요', '', now());
INSERT tbl_bf_alarm (to_member_id, a_title, a_link, reg_dt) values ('renamaestro', '공지사항 - 서비스 점검 계획', '/m/bf_notice/view_bf_notice.do?gn_no=4', now());