--------------------------- v0.4.2 ---------------------------
--开放app_code表
CREATE TABLE `open_account` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) NOT NULL COMMENT '开放id',
`app_code` varchar(32) NOT NULL COMMENT 'appcode',
`is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',
`creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_open_account_id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
--开放app_code的ip表
CREATE TABLE `ip_whitelist` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`open_acct_id` varchar(64) NOT NULL COMMENT '开放id',
`ip` varchar(16) NOT NULL COMMENT 'ip地址',
`is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',
`creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
--激活码表
CREATE TABLE `dy_activation_code` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`activation_code` varchar(64) NOT NULL COMMENT '激活码',
`ip` varchar(16) COMMENT 'ip地址',
`mac_address` varchar(64) COMMENT 'mac地址',
`status` tinyint(2) unsigned NOT NULL DEFAULT '1',
`is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',
`creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
--添加app_code
INSERT INTO `open_account` (`id`, `app_code`) VALUES ('OA6360E26DPJI0QV', 'gCnQs9yVbWd0zth6HeJ1m3OSRx5TP8Mj');
--注册激活码
INSERT INTO `dy_activation_code` (`activation_code`) VALUES ('DYAC63730298ANDWWY');