individuation.sql

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

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

/*!40101 SET NAMES utf8 */;

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

create database if not exists `individuation`;

USE `individuation`;

/*!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 `subject` */

DROP TABLE IF EXISTS `subject`;

CREATE TABLE `subject` (
  `SUBJECTID` varchar(8) NOT NULL,
  `NAME` varchar(50) NOT NULL,
  `PARENTID` varchar(8) default NULL,
  `SUBJECTLEVEL` varchar(1) NOT NULL,
  PRIMARY KEY  (`SUBJECTID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `subject` */

insert  into `subject`(`SUBJECTID`,`NAME`,`PARENTID`,`SUBJECTLEVEL`) values ('A','语言与文学',NULL,'0'),('A1','语文','A','2'),('A2','英语','A','2'),('B','工科',NULL,'0'),('B1','数学','B','2'),('C','社科','','0'),('C1','历史','C','2'),('C2','地理','C','2');

/*Table structure for table `tb_user_info` */

DROP TABLE IF EXISTS `tb_user_info`;

CREATE TABLE `tb_user_info` (
  `USERID` int(11) NOT NULL,
  `NICKNAME` varchar(40) NOT NULL,
  `PASSWORD` varchar(50) NOT NULL,
  `EMAIL` varchar(100) NOT NULL,
  `SEX` int(11) NOT NULL,
  PRIMARY KEY  (`USERID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `tb_user_info` */

insert  into `tb_user_info`(`USERID`,`NICKNAME`,`PASSWORD`,`EMAIL`,`SEX`) values (1,'fra','fra','fra',1),(21,'fra','fra','fra',1);

/*Table structure for table `user_order_info` */

DROP TABLE IF EXISTS `user_order_info`;

CREATE TABLE `user_order_info` (
  `ID` int(11) NOT NULL,
  `USERID` int(11) NOT NULL,
  `SUBJECTID` varchar(8) NOT NULL,
  `NUM` int(11) NOT NULL default '5',
  `DISPLAY` varchar(2) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `USERID` (`USERID`),
  KEY `SUBJECTID` (`SUBJECTID`),
  CONSTRAINT `user_order_info_ibfk_1` FOREIGN KEY (`SUBJECTID`) REFERENCES `subject` (`SUBJECTID`),
  CONSTRAINT `user_order_info_ibfk_2` FOREIGN KEY (`USERID`) REFERENCES `tb_user_info` (`USERID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `user_order_info` */

insert  into `user_order_info`(`ID`,`USERID`,`SUBJECTID`,`NUM`,`DISPLAY`) values (1,21,'A1',5,'1'),(2,21,'A2',5,'1'),(3,21,'B1',5,'1'),(4,21,'C1',5,'0'),(5,21,'C2',5,'0'),(12,21,'B1',5,'0');

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