shopping.sql

购物系统

/*
SQLyog 企业版 - MySQL GUI v5.02
主机 - 5.0.41-community-nt : 数据库 - shopping
*********************************************************************
服务器版本 : 5.0.41-community-nt
*/


create database if not exists `shopping`;

USE `shopping`;

/*数据表 `category` 的表结构*/

DROP TABLE IF EXISTS `category`;

CREATE TABLE `category` (
  `id` int(11) NOT NULL auto_increment,
  `pid` int(11) default NULL,
  `name` varchar(255) default NULL,
  `descr` varchar(255) default NULL,
  `cno` int(11) default NULL,
  `grade` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*数据表 `category` 的数据*/

insert into `category` values 
(1,0,'one','one',10000,1),
(2,1,'two','two',10100,2);

/*数据表 `product` 的表结构*/

DROP TABLE IF EXISTS `product`;

CREATE TABLE `product` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `descr` varchar(255) default NULL,
  `normalprice` double default NULL,
  `memberprice` double default NULL,
  `pdate` datetime default NULL,
  `categoryid` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*数据表 `product` 的数据*/

insert into `product` values 
(1,'milk','',23,22,'2008-01-19 14:46:09',2),
(2,'milk2','',23,22,'2008-01-19 14:46:56',2),
(3,'book','book',22,21,'2008-01-20 15:56:30',2);

/*数据表 `salesitem` 的表结构*/

DROP TABLE IF EXISTS `salesitem`;

CREATE TABLE `salesitem` (
  `id` int(11) NOT NULL auto_increment,
  `productid` int(11) default NULL,
  `unitprice` double default NULL,
  `pcount` int(11) default NULL,
  `orderid` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*数据表 `salesitem` 的数据*/

insert into `salesitem` values 
(1,2,22,2,6),
(2,2,22,4,7),
(3,2,22,4,8);

/*数据表 `salesorder` 的表结构*/

DROP TABLE IF EXISTS `salesorder`;

CREATE TABLE `salesorder` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) default NULL,
  `addr` varchar(255) default NULL,
  `odate` datetime default NULL,
  `status` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*数据表 `salesorder` 的数据*/

insert into `salesorder` values 
(1,1,'','2008-01-02 09:45:04',1),
(2,2,NULL,'2008-01-02 10:39:53',0),
(3,2,NULL,'2008-01-02 10:46:54',0),
(4,2,NULL,'2008-01-02 11:15:31',0),
(5,2,NULL,'2008-01-02 11:48:38',0),
(6,2,'aaaaa','2008-01-20 15:40:49',0),
(7,2,'aaaaa','2008-01-20 15:45:35',0),
(8,2,'aaaaa','2008-01-20 15:54:22',0);

/*数据表 `user` 的表结构*/

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(40) default NULL,
  `password` varchar(16) default NULL,
  `phone` varchar(40) default NULL,
  `addr` varchar(255) default NULL,
  `rdate` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*数据表 `user` 的数据*/

insert into `user` values 
(1,'liugd','1314','123456','qqqq','2008-01-02 10:47:19'),
(2,'admin','admin','88888888','aaaaa','2008-01-02 10:47:11');