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.
16 lines
507 B
16 lines
507 B
4 years ago
|
DROP TABLE IF EXISTS `babyfeed`.`tbl_sms_log` ;
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_sms_log` (
|
||
|
|
`s_no` INT NOT NULL AUTO_INCREMENT,
|
||
|
|
`sms_use_cd_no` VARCHAR(30) NULL,
|
||
|
|
`phone_num` VARCHAR(16) NOT NULL,
|
||
|
|
`title` VARCHAR(100) NULL,
|
||
|
|
`msg` VARCHAR(1000) NULL,
|
||
|
|
`check_num` INT NOT NULL,
|
||
|
|
`sms_cd_no` VARCHAR(30) NOT NULL,
|
||
|
|
`sms_code` VARCHAR(10) NULL,
|
||
|
|
`sms_msg` VARCHAR(100) NULL,
|
||
|
|
`reg_dt` DATETIME NOT NULL,
|
||
|
|
`mod_dt` DATETIME NULL,
|
||
|
|
PRIMARY KEY (`s_no`))
|
||
|
|
ENGINE = InnoDB;
|