yly.sql

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

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

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


/*!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*/`yly` /*!40100 DEFAULT CHARACTER SET gb2312 */;

USE `yly`;

/*Table structure for table `admin` */

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(50) default NULL,
  `password` varchar(50) default NULL,
  `creattime` datetime default NULL,
  `flag` int(4) default NULL,
  `isuse` int(4) default NULL,
  `logintimes` int(4) default NULL,
  `quanxian` varchar(1000) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=gb2312;

/*Data for the table `admin` */

insert  into `admin`(`id`,`username`,`password`,`creattime`,`flag`,`isuse`,`logintimes`,`quanxian`) values (1,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','0000-00-00 00:00:00',1,1,151,'1'),(5,'guanli','96e79218965eb72c92a549dd5a330112','2012-04-04 11:46:02',2,1,1,'管理员');

/*Table structure for table `adminlog` */

DROP TABLE IF EXISTS `adminlog`;

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

/*Data for the table `adminlog` */

insert  into `adminlog`(`id`,`username`,`password`,`logintime`,`loginip`,`useros`,`ok`) values (89,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 19:14:10','Mozilla/4.0 (compatible','127.0.0.1','true'),(90,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 19:45:06','Mozilla/4.0 (compatible','127.0.0.1','true'),(91,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 20:04:33','Mozilla/4.0 (compatible','127.0.0.1','true'),(92,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 20:17:47','Mozilla/4.0 (compatible','127.0.0.1','true'),(93,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 20:23:21','Mozilla/4.0 (compatible','127.0.0.1','true'),(94,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 20:24:14','Mozilla/4.0 (compatible','127.0.0.1','true'),(95,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 20:31:49','Mozilla/4.0 (compatible','127.0.0.1','true'),(96,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 20:37:40','Mozilla/4.0 (compatible','127.0.0.1','true'),(97,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 21:55:08','Mozilla/4.0 (compatible','127.0.0.1','true'),(98,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 21:58:52','Mozilla/4.0 (compatible','127.0.0.1','true'),(99,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 21:59:35','Mozilla/4.0 (compatible','127.0.0.1','true'),(100,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 22:07:04','Mozilla/4.0 (compatible','127.0.0.1','true'),(101,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 22:10:34','Mozilla/4.0 (compatible','127.0.0.1','true'),(102,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 22:10:48','Mozilla/4.0 (compatible','127.0.0.1','true'),(103,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 22:16:06','Mozilla/4.0 (compatible','127.0.0.1','true'),(104,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-02 22:17:42','Mozilla/4.0 (compatible','127.0.0.1','true'),(105,'stu','698d51a19d8a121ce581499d7b701668','2012-04-02 22:28:59','Mozilla/4.0 (compatible','127.0.0.1','true'),(106,'wx','698d51a19d8a121ce581499d7b701668','2012-04-02 22:29:50','Mozilla/4.0 (compatible','127.0.0.1','true'),(107,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 11:45:37','Mozilla/4.0 (compatible','127.0.0.1','true'),(108,'guanli','96e79218965eb72c92a549dd5a330112','2012-04-04 11:46:14','Mozilla/4.0 (compatible','127.0.0.1','true'),(109,'caozuo','96e79218965eb72c92a549dd5a330112','2012-04-04 11:46:33','Mozilla/4.0 (compatible','127.0.0.1','true'),(110,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 11:54:29','Mozilla/4.0 (compatible','127.0.0.1','true'),(111,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 11:57:12','Mozilla/4.0 (compatible','127.0.0.1','true'),(112,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 11:59:08','Mozilla/4.0 (compatible','127.0.0.1','true'),(113,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 12:00:13','Mozilla/4.0 (compatible','127.0.0.1','true'),(114,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 12:04:55','Mozilla/4.0 (compatible','127.0.0.1','true'),(115,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 12:25:18','Mozilla/4.0 (compatible','127.0.0.1','true'),(116,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 12:40:19','Mozilla/4.0 (compatible','127.0.0.1','true'),(117,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 12:54:51','Mozilla/4.0 (compatible','127.0.0.1','true'),(118,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 13:00:15','Mozilla/4.0 (compatible','127.0.0.1','true'),(119,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 13:34:11','Mozilla/4.0 (compatible','127.0.0.1','true'),(120,'caozuo','96e79218965eb72c92a549dd5a330112','2012-04-04 13:42:18','Mozilla/4.0 (compatible','127.0.0.1','true'),(121,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 13:42:34','Mozilla/4.0 (compatible','127.0.0.1','true'),(122,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 14:35:18','Mozilla/4.0 (compatible','127.0.0.1','true'),(123,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 14:36:45','Mozilla/4.0 (compatible','127.0.0.1','true'),(124,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 14:38:00','Mozilla/4.0 (compatible','127.0.0.1','true'),(125,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 14:40:18','Mozilla/4.0 (compatible','127.0.0.1','true'),(126,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 15:05:43','Mozilla/4.0 (compatible','127.0.0.1','true'),(127,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 15:10:52','Mozilla/4.0 (compatible','127.0.0.1','true'),(128,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 15:12:43','Mozilla/4.0 (compatible','127.0.0.1','true'),(129,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 15:42:55','Mozilla/4.0 (compatible','127.0.0.1','true'),(130,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 15:46:19','Mozilla/4.0 (compatible','127.0.0.1','true'),(131,'duzhe','96e79218965eb72c92a549dd5a330112','2012-04-04 15:46:53','Mozilla/4.0 (compatible','127.0.0.1','true'),(132,'duzhe','96e79218965eb72c92a549dd5a330112','2012-04-04 15:48:56','Mozilla/4.0 (compatible','127.0.0.1','true'),(133,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 15:54:22','Mozilla/4.0 (compatible','127.0.0.1','true'),(134,'duzhe','96e79218965eb72c92a549dd5a330112','2012-04-04 16:01:19','Mozilla/4.0 (compatible','127.0.0.1','true'),(135,'duzhe','96e79218965eb72c92a549dd5a330112','2012-04-04 16:13:30','Mozilla/4.0 (compatible','127.0.0.1','true'),(136,'duzhe','96e79218965eb72c92a549dd5a330112','2012-04-04 16:17:36','Mozilla/4.0 (compatible','127.0.0.1','true'),(137,'duzhe','96e79218965eb72c92a549dd5a330112','2012-04-04 16:18:04','Mozilla/4.0 (compatible','127.0.0.1','true'),(138,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 16:46:15','Mozilla/4.0 (compatible','127.0.0.1','true'),(139,'duzhe','96e79218965eb72c92a549dd5a330112','2012-04-04 16:50:29','Mozilla/4.0 (compatible','127.0.0.1','true'),(140,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 16:59:15','Mozilla/4.0 (compatible','127.0.0.1','true'),(141,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 16:59:53','Mozilla/4.0 (compatible','127.0.0.1','true'),(142,'duzhe','96e79218965eb72c92a549dd5a330112','2012-04-04 17:02:29','Mozilla/4.0 (compatible','127.0.0.1','true'),(143,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 20:07:40','Mozilla/4.0 (compatible','127.0.0.1','true'),(144,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 20:09:29','Mozilla/4.0 (compatible','127.0.0.1','true'),(145,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 20:09:33','Mozilla/4.0 (compatible','127.0.0.1','true'),(146,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 20:10:35','Mozilla/4.0 (compatible','127.0.0.1','true'),(147,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 20:10:48','Mozilla/4.0 (compatible','127.0.0.1','true'),(148,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 20:11:07','Mozilla/4.0 (compatible','127.0.0.1','true'),(149,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 20:18:13','Mozilla/4.0 (compatible','127.0.0.1','true'),(150,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 20:25:22','Mozilla/4.0 (compatible','127.0.0.1','true'),(151,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 20:34:32','Mozilla/4.0 (compatible','127.0.0.1','true'),(152,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 20:48:51','Mozilla/4.0 (compatible','127.0.0.1','true'),(153,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 20:51:44','Mozilla/4.0 (compatible','127.0.0.1','true'),(154,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 20:59:45','Mozilla/4.0 (compatible','127.0.0.1','true'),(155,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-04 23:48:36','Mozilla/4.0 (compatible','127.0.0.1','true'),(156,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-05 00:13:50','Mozilla/4.0 (compatible','127.0.0.1','true'),(157,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-05 00:54:30','Mozilla/4.0 (compatible','127.0.0.1','true'),(158,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-05 00:58:24','Mozilla/4.0 (compatible','127.0.0.1','true'),(159,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-05 01:01:20','Mozilla/4.0 (compatible','127.0.0.1','true'),(160,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-05 01:12:10','Mozilla/4.0 (compatible','127.0.0.1','true'),(161,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-05 01:25:29','Mozilla/4.0 (compatible','127.0.0.1','true'),(162,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-05 01:35:10','Mozilla/4.0 (compatible','127.0.0.1','true'),(163,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-05 01:37:56','Mozilla/4.0 (compatible','127.0.0.1','true'),(164,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-05 01:40:24','Mozilla/4.0 (compatible','127.0.0.1','true');

/*Table structure for table `bz` */

DROP TABLE IF EXISTS `bz`;