v0.1版本数据库

--------------------------- 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');