store.sql

来自「一本jsp自学教材」· SQL 代码 · 共 100 行

# Powered By Caxton

# Host: localhost    Database: store
# ------------------------------------------------------
# Server version 4.1.13-nt

CREATE DATABASE `store` /*!40100 DEFAULT CHARACTER SET gbk */;
USE `store`;

#
# Table structure for table commentary
#

CREATE TABLE `commentary` (
  `id` int(11) NOT NULL auto_increment,
  `pid` int(9) NOT NULL default '0',
  `customer` varchar(16) default NULL,
  `content` text,
  `ip` varchar(16) default NULL,
  `time` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

#
# Table structure for table customer
#

CREATE TABLE `customer` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(16) NOT NULL default '',
  `password` varchar(16) NOT NULL default '',
  `name` varchar(6) NOT NULL default '',
  `tel` varchar(13) default NULL,
  `address` varchar(36) default NULL,
  `email` varchar(30) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

#
# Table structure for table delivery
#

CREATE TABLE `delivery` (
  `id` int(2) NOT NULL auto_increment,
  `description` varchar(255) default NULL,
  `fee` int(4) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

#
# Table structure for table orders
#

CREATE TABLE `orders` (
  `id` int(11) NOT NULL auto_increment,
  `isorder` int(1) NOT NULL default '0',
  `orderid` int(11) default '0',
  `pid` int(8) default '0',
  `customerid` int(8) NOT NULL default '0',
  `quantity` int(6) default '0',
  `price` float(8,2) default NULL,
  `time` datetime default '2006-01-01 00:00:00',
  `delivery` int(1) default '0',
  `payment` int(1) default '0',
  `status` int(1) default '0',
  PRIMARY KEY  (`id`),
  KEY `orderid_index` (`orderid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

#
# Table structure for table product
#

CREATE TABLE `product` (
  `id` int(11) NOT NULL auto_increment,
  `sort` int(2) NOT NULL default '0',
  `pname` varchar(16) default NULL,
  `provider` varchar(16) default NULL,
  `stock` int(8) default '0',
  `sold` int(8) default '0',
  `price` float(8,2) default NULL,
  `sinfo` varchar(200) default NULL,
  `info` text,
  `image` varchar(50) default 'null.jpg',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

#
# Table structure for table sorts
#

CREATE TABLE `sorts` (
  `id` int(3) NOT NULL auto_increment,
  `sortname` varchar(20) NOT NULL default '',
  `total` int(5) default NULL,
  `info` varchar(150) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;