pub_send_detail.sql 373 B

123456
  1. CREATE TABLE PUB_SEND_DETAIL (
  2. OSD_CODE varchar(20) NOT NULL COMMENT '校验码',
  3. OSD_USERID varchar(20) NOT NULL COMMENT '邮箱或带区号手机号',
  4. OSD_LASTTIME varchar(14) DEFAULT NULL COMMENT '发送时间',
  5. OSD_STATUS varchar(1) DEFAULT '0' COMMENT '0:未校验;1:已校验'
  6. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='短信流水表 ';