cpyd.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
Navicat MySQL Data Transfer

Source Server         : 111
Source Server Version : 50051
Source Host           : localhost:3306
Source Database       : cpyd

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

Date: 2017-10-23 12:45:53
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `admin`
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL,
  `password` varchar(500) NOT NULL,
  `creattime` datetime NOT NULL,
  `flag` int(11) NOT NULL,
  `isuse` int(11) NOT NULL,
  `logintimes` int(11) NOT NULL,
  `quanxian` varchar(5000) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', 'ae7783f0ae4cb82dfe39bb4ec4a53047', '2009-05-07 00:00:00', '1', '1', '1410', '1');
INSERT INTO `admin` VALUES ('10', 'aaaaaa', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', '2016-11-24 11:28:24', '2', '1', '1', '111');

-- ----------------------------
-- Table structure for `adminlog`
-- ----------------------------
DROP TABLE IF EXISTS `adminlog`;
CREATE TABLE `adminlog` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(50) default NULL,
  `password` varchar(500) default NULL,
  `logintime` datetime default NULL,
  `loginip` varchar(50) default NULL,
  `useros` varchar(50) default NULL,
  `ok` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of adminlog
-- ----------------------------
INSERT INTO `adminlog` VALUES ('13', 'admin', 'ae7783f0ae4cb82dfe39bb4ec4a53047', '2016-11-28 13:38:41', 'Mozilla/4.0 (compatible', '127.0.0.1', 'true');
INSERT INTO `adminlog` VALUES ('14', 'admin', 'ae7783f0ae4cb82dfe39bb4ec4a53047', '2017-10-23 02:22:29', 'Mozilla/4.0 (compatible', '127.0.0.1', 'true');
INSERT INTO `adminlog` VALUES ('15', 'admin', 'ae7783f0ae4cb82dfe39bb4ec4a53047', '2017-10-23 03:07:43', 'Mozilla/4.0 (compatible', '127.0.0.1', 'true');