meet.sql

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

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

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


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

USE `meet`;

/*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=3 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,65,'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=65 DEFAULT CHARSET=gb2312;

/*Data for the table `adminlog` */

insert  into `adminlog`(`id`,`username`,`password`,`logintime`,`loginip`,`useros`,`ok`) values (29,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-02-29 11:13:05','Mozilla/4.0 (compatible','127.0.0.1','true'),(30,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-12 14:58:30','Mozilla/4.0 (compatible','127.0.0.1','true'),(31,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-12 15:13:32','Mozilla/4.0 (compatible','127.0.0.1','true'),(32,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-12 15:22:56','Mozilla/4.0 (compatible','127.0.0.1','true'),(33,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-12 15:33:37','Mozilla/4.0 (compatible','127.0.0.1','true'),(34,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-12 15:34:00','Mozilla/4.0 (compatible','127.0.0.1','true'),(35,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-12 15:36:26','Mozilla/4.0 (compatible','127.0.0.1','true'),(36,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-12 15:37:09','Mozilla/4.0 (compatible','127.0.0.1','true'),(37,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-12 15:37:15','Mozilla/4.0 (compatible','127.0.0.1','true'),(38,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-12 15:37:30','Mozilla/4.0 (compatible','127.0.0.1','true'),(39,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 12:58:28','Mozilla/4.0 (compatible','127.0.0.1','true'),(40,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 12:59:28','Mozilla/4.0 (compatible','127.0.0.1','true'),(41,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 12:59:44','Mozilla/4.0 (compatible','127.0.0.1','true'),(42,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 13:04:56','Mozilla/4.0 (compatible','127.0.0.1','true'),(43,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 13:10:36','Mozilla/4.0 (compatible','127.0.0.1','true'),(44,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 13:28:40','Mozilla/4.0 (compatible','127.0.0.1','true'),(45,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 15:21:04','Mozilla/4.0 (compatible','127.0.0.1','true'),(46,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 15:27:47','Mozilla/4.0 (compatible','127.0.0.1','true'),(47,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 15:51:13','Mozilla/4.0 (compatible','127.0.0.1','true'),(48,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 16:09:10','Mozilla/4.0 (compatible','127.0.0.1','true'),(49,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 16:15:01','Mozilla/4.0 (compatible','127.0.0.1','true'),(50,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 16:17:11','Mozilla/4.0 (compatible','127.0.0.1','true'),(51,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 16:17:38','Mozilla/4.0 (compatible','127.0.0.1','true'),(52,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 16:28:44','Mozilla/4.0 (compatible','127.0.0.1','true'),(53,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 16:30:54','Mozilla/4.0 (compatible','127.0.0.1','true'),(54,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-28 16:32:23','Mozilla/4.0 (compatible','127.0.0.1','true'),(55,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-29 01:23:04','Mozilla/4.0 (compatible','127.0.0.1','true'),(56,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-29 01:25:03','Mozilla/4.0 (compatible','127.0.0.1','true'),(57,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-03-29 01:25:49','Mozilla/4.0 (compatible','127.0.0.1','true'),(58,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-03 17:36:23','Mozilla/4.0 (compatible','127.0.0.1','true'),(59,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-03 17:40:36','Mozilla/4.0 (compatible','127.0.0.1','true'),(60,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-03 17:44:41','Mozilla/4.0 (compatible','127.0.0.1','true'),(61,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-03 17:57:03','Mozilla/4.0 (compatible','127.0.0.1','true'),(62,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-03 18:38:59','Mozilla/4.0 (compatible','127.0.0.1','true'),(63,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-03 18:43:14','Mozilla/4.0 (compatible','127.0.0.1','true'),(64,'admin','ae7783f0ae4cb82dfe39bb4ec4a53047','2012-04-03 19:04:01','Mozilla/4.0 (compatible','127.0.0.1','true');

/*Table structure for table `dp` */

DROP TABLE IF EXISTS `dp`;