GitLab

mysql变更格式

数据库：admin

表名：balance_manage

sql：

CREATE TABLE `balance_manage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NOT NULL COMMENT '后台用户id',
  `p_id` int(11) NOT NULL DEFAULT '0' COMMENT '主账号id',
  `balance` double(11,2) NOT NULL COMMENT '余额',
  `discount` smallint(1) NOT NULL DEFAULT '10' COMMENT '折扣',
  `status` smallint(1) NOT NULL DEFAULT '1' COMMENT '状态1有效,2无效',
  `add_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `lastupdatetime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ix_admin_id` (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;