数据库/room.sql

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

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

/*
SQLyog Community Edition- MySQL GUI v6.54
MySQL - 5.5.15 : Database - room
*********************************************************************
*/


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

USE `room`;

/*Table structure for table `admins` */

DROP TABLE IF EXISTS `admins`;

CREATE TABLE `admins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `loginname` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `tel` varchar(50) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `inputtime` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gbk;

/*Data for the table `admins` */

insert  into `admins`(`id`,`username`,`loginname`,`password`,`tel`,`email`,`inputtime`) values (1,'管理员','admin','123','18602499887','admin@163.com','2012-03-24'),(2,'孙一一','syy','123','13005698789','syy@126.com','2012-03-24'),(3,'张有1','zx1','a','1234355671','zx1@123.com','2012-03-25');

/*Table structure for table `plan` */

DROP TABLE IF EXISTS `plan`;

CREATE TABLE `plan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roomsid` int(11) NOT NULL,
  `pname` varchar(50) DEFAULT NULL,
  `pdate` varchar(20) DEFAULT NULL,
  `btime` int(20) DEFAULT NULL,
  `etime` int(11) DEFAULT NULL,
  `contents` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK348B29FAB3AAA5` (`roomsid`),
  CONSTRAINT `FK348B29FAB3AAA5` FOREIGN KEY (`roomsid`) REFERENCES `rooms` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=gbk;

/*Data for the table `plan` */

insert  into `plan`(`id`,`roomsid`,`pname`,`pdate`,`btime`,`etime`,`contents`) values (1,5,'李小强','2012-03-04',925,1125,' '),(2,3,'姚明','2012-03-06',921,1140,' d '),(3,7,'李娜','2012-03-16',1515,1959,'  q        '),(9,7,'王刚','2012-03-16',2034,2034,' 3234 '),(10,5,'张强','2012-03-11',1040,1220,' '),(11,3,'李仁','2012-03-12',1410,1539,' '),(12,5,'张强','2012-03-26',2100,2159,' '),(13,7,'张强2','2012-03-28',2100,2145,' '),(14,6,'张强3','2012-04-02',2100,2145,' '),(15,5,'张强4','2012-04-05',2100,2130,' ');

/*Table structure for table `resource` */