buy.sql

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

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

/*!40101 SET NAMES utf8 */;

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

create database if not exists `buy`;

USE `buy`;

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

DROP TABLE IF EXISTS `add`;

CREATE TABLE `add` (
  `ADDID` int(11) NOT NULL,
  `TYPE` varchar(20) default NULL,
  `COIN` int(11) default NULL,
  `DATETIME` datetime default NULL,
  `USERID` int(11) default NULL,
  PRIMARY KEY  (`ADDID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `add` */

insert  into `add`(`ADDID`,`TYPE`,`COIN`,`DATETIME`,`USERID`) values (1,'在线充值',15,'2006-01-01 00:00:00',1),(2,'个人银行充值',15,'2006-02-01 00:00:00',1),(3,'代理充值',15,'2006-03-01 00:00:00',1),(4,'在线充值',15,'2006-04-01 00:00:00',1),(5,'汇款充值',15,'2006-05-01 00:00:00',1);

/*Table structure for table `consume` */

DROP TABLE IF EXISTS `consume`;

CREATE TABLE `consume` (
  `CONSUMEID` int(11) NOT NULL,
  `PRICE` int(11) default NULL,
  `DATETIME` datetime default NULL,
  `USERID` int(11) default NULL,
  `PRODUCTNAME` varchar(50) default NULL,
  PRIMARY KEY  (`CONSUMEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `consume` */

insert  into `consume`(`CONSUMEID`,`PRICE`,`DATETIME`,`USERID`,`PRODUCTNAME`) values (1,11,'2005-01-01 12:00:00',1,'商品1'),(2,25,'2006-02-03 00:00:00',1,'商品2'),(3,34,'2006-03-05 00:00:00',1,'商品3'),(4,221,'2006-03-13 00:00:00',1,'商品4');

/*Table structure for table `order` */

DROP TABLE IF EXISTS `order`;

CREATE TABLE `order` (
  `ORDERID` int(11) NOT NULL,
  `TYPE` varchar(20) default NULL,
  `PRICE` int(11) default NULL,
  `DATETIME` datetime default NULL,
  `USERID` int(11) default NULL,
  `PRODUCTNAME` varchar(20) default NULL,
  PRIMARY KEY  (`ORDERID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `order` */

insert  into `order`(`ORDERID`,`TYPE`,`PRICE`,`DATETIME`,`USERID`,`PRODUCTNAME`) values (1,'正在处理',15,'2006-04-04 00:00:00',1,'商品1'),(2,'支付成功',24,'2006-03-05 00:00:00',1,'商品2'),(3,'支付失败',55,'2006-02-01 00:00:00',1,'商品3'),(4,'支付失败',5,'2006-03-01 00:00:00',1,'商品4'),(5,'正在处理',54,'2006-01-01 00:00:00',1,'商品5');

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `ID` int(11) NOT NULL,
  `NAME` varchar(20) default NULL,
  `PASSWORD` varchar(10) default NULL,
  `COIN` int(11) default NULL,
  `CONSUME` int(11) default NULL,
  `TYPE` varchar(20) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `user` */

insert  into `user`(`ID`,`NAME`,`PASSWORD`,`COIN`,`CONSUME`,`TYPE`) values (1,'ABC','111111',100,250,'VIP'),(2,'bcd','111111',20,120,'普通用户');

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