Skip to content

GitLab

Closed
Created by 姚坤@yaokDeveloper

数据库加表

mysql变更格式

数据库：shuidi_data

表名：tb_free_claim_count

sql：

CREATE TABLE `tb_free_claim_count` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dateindex` int(11) NOT NULL,
  `free_to_pay_num` int(11) NOT NULL,
  `free_num` int(11) NOT NULL,
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ix_dateindex` (`dateindex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8