database-design.txt

《PHP专业项目实例开发》源代码

#
# Table structure for table `category`
#

CREATE TABLE category (
  categoryid bigint(20) NOT NULL auto_increment,
  parentcategoryid varchar(20) NOT NULL default '',
  name varchar(20) NOT NULL default '',
  description varchar(200) NOT NULL default '',
  PRIMARY KEY  (categoryid)
)
# --------------------------------------------------------

#
# Table structure for table `customerinfo`
#

CREATE TABLE customerinfo (
  customerid varchar(20) NOT NULL default '',
  name varchar(50) NOT NULL default '',
  address varchar(200) NOT NULL default '',
  dob date NOT NULL default '0000-00-00',
  gender char(1) NOT NULL default '',
  pop char(1) NOT NULL default '',
  rock char(1) NOT NULL default '',
  jazz char(1) NOT NULL default '',
  metal char(1) NOT NULL default '',
  instrumental char(1) NOT NULL default '',
  PRIMARY KEY  (customerid)
)
# --------------------------------------------------------



#
# Table structure for table `login`
#

CREATE TABLE login (
  customerid bigint(20) NOT NULL default '0',
  password char(100) NOT NULL default '',
  PRIMARY KEY  (customerid)
)
# 

--------------------------------------------------------

#
# Table structure for table `neworder`
#

CREATE TABLE neworder (
  id bigint(20) NOT NULL auto_increment,
  customerid varchar(20) NOT NULL default '',
  productid varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
)
# --------------------------------------------------------

#
# Table structure for table `newsmail`
#

CREATE TABLE newsmail (
  name varchar(20) NOT NULL default '',
  email varchar(40) NOT NULL default '',
  customerid varchar(20) NOT NULL default '',
  PRIMARY KEY  (customerid)
)
# --------------------------------------------------------

#
# Table structure for table `orders`
#

CREATE TABLE orders (
  orderid bigint(20) NOT NULL default '0',
  customerid varchar(20) default NULL,
  orderdate varchar(20) default NULL,
  price varchar(20) default NULL,
  status varchar(20) default NULL,
  PRIMARY KEY  (orderid)
)
# --------------------------------------------------------

#
# Table structure for table 
`products`
#

CREATE TABLE products (
  productid bigint(20) NOT NULL auto_increment,
  name varchar(40) NOT NULL default '',
  description varchar(200) NOT NULL default '',
  price varchar(20) NOT NULL default '',
  category varchar(20) NOT NULL default '',
  PRIMARY KEY  (productid)
)


# --------------------------------------------------------

#
# Table structure for table `products_ordered`
#

CREATE TABLE products_ordered (
  id varchar(20) NOT NULL default '',
  productid varchar(20) NOT NULL default '',
  orderid varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
)