/*
Navicat MySQL Data Transfer

Source Server         : 139.199.85.64
Source Server Version : 50730
Source Host           : 139.199.85.64:3306
Source Database       : ios_super_sign

Target Server Type    : MYSQL
Target Server Version : 50730
File Encoding         : 65001

Date: 2020-08-27 12:53:47
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for apple_iis
-- ----------------------------
DROP TABLE IF EXISTS `apple_iis`;
CREATE TABLE `apple_iis` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account` varchar(255) NOT NULL,
  `iis` varchar(255) NOT NULL,
  `kid` varchar(255) NOT NULL,
  `cert_id` varchar(255) NOT NULL,
  `identifier` varchar(255) NOT NULL,
  `p8` varchar(255) NOT NULL,
  `p12` varchar(255) NOT NULL COMMENT 'p8文件路径',
  `start` int(11) NOT NULL COMMENT '0不启用,1启用',
  `status` int(11) NOT NULL COMMENT '0失效,未失效',
  `ispublic` int(11) NOT NULL COMMENT '0私,1公',
  `count` int(10) unsigned NOT NULL,
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `iis` (`iis`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for distribute
-- ----------------------------
DROP TABLE IF EXISTS `distribute`;
CREATE TABLE `distribute` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account` varchar(255) NOT NULL,
  `app_name` varchar(255) NOT NULL,
  `page_name` varchar(255) NOT NULL,
  `version` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `ipa` varchar(255) DEFAULT NULL,
  `apk` varchar(255) DEFAULT NULL,
  `url` text,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for pack_status
-- ----------------------------
DROP TABLE IF EXISTS `pack_status`;
CREATE TABLE `pack_status` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account` varchar(255) DEFAULT NULL,
  `page_name` varchar(255) DEFAULT NULL,
  `uuid` varchar(32) DEFAULT NULL,
  `udid` varchar(255) DEFAULT NULL,
  `iis` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `ipa` varchar(255) DEFAULT NULL,
  `plist` varchar(255) DEFAULT NULL,
  `status` varchar(25) DEFAULT NULL,
  `sign_off` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `create_time` datetime NOT NULL,
  `type` int(1) unsigned NOT NULL COMMENT '0普通用户1管理员',
  PRIMARY KEY (`id`),
  UNIQUE KEY `account` (`account`)
) ENGINE=InnoDB AUTO_INCREMENT=11237 DEFAULT CHARSET=utf8mb4;
