DB_51aspx/wex.sql

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

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

/*
SQLyog Community Edition- MySQL GUI v6.54
MySQL - 5.0.51a-community-nt : Database - wex
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/`wex` /*!40100 DEFAULT CHARACTER SET gb2312 */;

USE `wex`;

/*Table structure for table `admin` */

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(100) default NULL,
  `password` varchar(100) default NULL,
  `creattime` varchar(100) default NULL,
  `flag` int(4) default NULL,
  `isuse` int(4) default NULL,
  `logintimes` int(4) default NULL,
  `quanxian` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

/*Data for the table `admin` */

insert  into `admin`(`id`,`username`,`password`,`creattime`,`flag`,`isuse`,`logintimes`,`quanxian`) values (1,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2015-1-1',1,1,95,'1');

/*Table structure for table `adminlog` */

DROP TABLE IF EXISTS `adminlog`;

CREATE TABLE `adminlog` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(100) default NULL,
  `password` varchar(100) default NULL,
  `logintime` varchar(100) default NULL,
  `loginip` varchar(100) default NULL,
  `useros` varchar(100) default NULL,
  `ok` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=gb2312;

/*Data for the table `adminlog` */

insert  into `adminlog`(`id`,`username`,`password`,`logintime`,`loginip`,`useros`,`ok`) values (71,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-18 21:15:43','Mozilla/4.0 (compatible','127.0.0.1','true'),(72,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-18 21:18:51','Mozilla/4.0 (compatible','127.0.0.1','true'),(73,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-18 21:20:49','Mozilla/4.0 (compatible','127.0.0.1','true'),(74,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-18 22:33:17','Mozilla/4.0 (compatible','127.0.0.1','true'),(75,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-18 22:38:57','Mozilla/4.0 (compatible','127.0.0.1','true'),(76,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-18 23:00:43','Mozilla/4.0 (compatible','127.0.0.1','true'),(77,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-18 23:32:18','Mozilla/4.0 (compatible','127.0.0.1','true'),(78,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-19 00:17:41','Mozilla/4.0 (compatible','127.0.0.1','true'),(79,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-19 00:18:05','Mozilla/4.0 (compatible','127.0.0.1','true'),(80,'111111','96e79218965eb72c92a549dd5a330112','2012-02-19 00:37:46','Mozilla/4.0 (compatible','127.0.0.1','true'),(81,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-21 21:36:36','Mozilla/4.0 (compatible','127.0.0.1','true'),(82,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-22 23:51:10','Mozilla/4.0 (compatible','127.0.0.1','true'),(83,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-11 15:36:33','Mozilla/4.0 (compatible','127.0.0.1','true'),(84,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-11 16:11:55','Mozilla/4.0 (compatible','127.0.0.1','true'),(85,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-11 16:11:59','Mozilla/4.0 (compatible','127.0.0.1','true'),(86,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-01 16:43:37','Mozilla/4.0 (compatible','127.0.0.1','true'),(87,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-01 16:45:54','Mozilla/4.0 (compatible','127.0.0.1','true'),(88,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-01 16:46:24','Mozilla/4.0 (compatible','127.0.0.1','true'),(89,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-01 16:47:26','Mozilla/4.0 (compatible','127.0.0.1','true'),(90,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-01 16:50:06','Mozilla/4.0 (compatible','127.0.0.1','true'),(91,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-01 16:56:08','Mozilla/4.0 (compatible','127.0.0.1','true'),(92,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-01 17:01:30','Mozilla/4.0 (compatible','127.0.0.1','true'),(93,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-01 17:08:38','Mozilla/4.0 (compatible','127.0.0.1','true'),(94,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-11 17:15:33','Mozilla/4.0 (compatible','127.0.0.1','true'),(95,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-11 17:21:37','Mozilla/4.0 (compatible','127.0.0.1','true'),(96,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-18 12:00:36','Mozilla/4.0 (compatible','127.0.0.1','true'),(97,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-18 12:35:51','Mozilla/4.0 (compatible','127.0.0.1','true'),(98,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-18 12:36:34','Mozilla/4.0 (compatible','127.0.0.1','true'),(99,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-18 12:36:49','Mozilla/4.0 (compatible','127.0.0.1','true'),(100,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-18 12:39:29','Mozilla/4.0 (compatible','127.0.0.1','true'),(101,'admin','024adin','2012-04-18 12:48:27','Mozilla/4.0 (compatible','127.0.0.1','false'),(102,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-18 12:48:34','Mozilla/4.0 (compatible','127.0.0.1','true'),(103,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-18 12:58:29','Mozilla/4.0 (compatible','127.0.0.1','true'),(104,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-18 13:00:55','Mozilla/4.0 (compatible','127.0.0.1','true'),(105,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-18 13:12:50','Mozilla/4.0 (compatible','127.0.0.1','true');

/*Table structure for table `attend` */

DROP TABLE IF EXISTS `attend`;