You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
74 lines
2.8 KiB
74 lines
2.8 KiB
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());
|
|
|