orderticket.sql

质量越高得到的下载个数越多防卡死了几分鞍山市反反复复反反复复

/*
SQLyog Enterprise Trial - MySQL GUI v6.04
Host - 5.0.45-community-nt : Database - orderticket
*********************************************************************
Server version : 5.0.45-community-nt
*/

/*!40101 SET NAMES utf8 */;

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

create database if not exists `orderticket`;

USE `orderticket`;

/*!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' */;

/*Table structure for table `admin` */

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (
  `ID` bigint(20) unsigned NOT NULL auto_increment,
  `ADMIN_NO` varchar(20) NOT NULL,
  `PASSWORD` varchar(20) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `admin` */

insert  into `admin`(`ID`,`ADMIN_NO`,`PASSWORD`) values (1,'admin','admin');

/*Table structure for table `flights` */

DROP TABLE IF EXISTS `flights`;

CREATE TABLE `flights` (
  `ID` bigint(20) unsigned NOT NULL auto_increment,
  `FLIGHT_NO` varchar(20) NOT NULL,
  `START_PLACE` varchar(20) NOT NULL,
  `END_PLACE` varchar(20) NOT NULL,
  `TIME` int(11) NOT NULL,
  `PRICE` double NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

/*Data for the table `flights` */

insert  into `flights`(`ID`,`FLIGHT_NO`,`START_PLACE`,`END_PLACE`,`TIME`,`PRICE`) values (2,'006','88','88',6,1245),(6,'3444','上海','上海',4,245),(7,'007','美国','美国',45,2340);

/*Table structure for table `orderitems` */

DROP TABLE IF EXISTS `orderitems`;

CREATE TABLE `orderitems` (
  `ID` bigint(20) unsigned NOT NULL auto_increment,
  `FLIGHT_ID` bigint(20) unsigned NOT NULL,
  `DATE` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `orderitems` */

insert  into `orderitems`(`ID`,`FLIGHT_ID`,`DATE`) values (1,2,'3907-09-05 00:00:00'),(2,6,'3907-09-05 00:00:00');

/*Table structure for table `orders` */

DROP TABLE IF EXISTS `orders`;

CREATE TABLE `orders` (
  `ID` bigint(20) unsigned NOT NULL auto_increment,
  `USER_ID` bigint(20) unsigned NOT NULL,
  `ORDERITEM_ID` bigint(20) unsigned NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `orders` */

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `ID` bigint(20) NOT NULL auto_increment,
  `ACCOUNT_NO` varchar(20) NOT NULL,
  `NAME` varchar(20) character set latin1 collate latin1_bin default NULL,
  `PASSWORD` varchar(20) NOT NULL default '666666',
  `SEX` varchar(2) character set latin1 collate latin1_bin default 'M',
  `PHONE` varchar(20) default NULL,
  `EMAIL` varchar(30) character set latin1 collate latin1_bin default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `users` */

insert  into `users`(`ID`,`ACCOUNT_NO`,`NAME`,`PASSWORD`,`SEX`,`PHONE`,`EMAIL`) values (2,'liuyu','liuyu','888','2','1381239687','[e-mail]');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;