text: /*
   Navicat Premium Data Transfer
  
   Source Server         : 本地
   Source Server Type    : MySQL
   Source Server Version : 50723
   Source Host           : localhost:3306
   Source Schema         : ssp
  
   Target Server Type    : MySQL
   Target Server Version : 50723
   File Encoding         : 65001
  
   Date: 14/09/2018 09:30:12
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for config
  -- ----------------------------
  DROP TABLE IF EXISTS `config`;
  CREATE TABLE `config`  (
    `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    PRIMARY KEY (`name`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of config
  -- ----------------------------
  INSERT INTO `config` VALUES ('AliPay_Cookie', NULL);
  INSERT INTO `config` VALUES ('AliPay_QRcode', NULL);
  INSERT INTO `config` VALUES ('AliPay_Status', '1');
  INSERT INTO `config` VALUES ('Notice_EMail', NULL);
  INSERT INTO `config` VALUES ('WxPay_Cookie', NULL);
  INSERT INTO `config` VALUES ('WxPay_QRcode', NULL);
  INSERT INTO `config` VALUES ('WxPay_Status', '1');
  INSERT INTO `config` VALUES ('WxPay_Url', 'wx.qq.com');
  INSERT INTO `config` VALUES ('WxPay_SyncKey', NULL);
  INSERT INTO `config` VALUES ('Pay_Price', NULL);
  INSERT INTO `config` VALUES ('Pay_Xposed', '0');
  
  ALTER TABLE `paylist`
  ADD COLUMN `type` int(1) NULL DEFAULT 0 AFTER `datetime`,
  ADD COLUMN `url` varchar(255) NULL AFTER `type`,
  ADD COLUMN `sys_sn` varchar(255) NULL AFTER `url`;
  
  SET FOREIGN_KEY_CHECKS = 1;
  