install.sql

PHPShops多用户商城系统（简称PHPShops）是基于电子商务的一套平台交易系统

  cid mediumint(8) NOT NULL,
  `subject` varchar(255) NOT NULL,
  content text NOT NULL,
  ifcheck tinyint(1) NOT NULL,
  ifconvert tinyint(1) NOT NULL,
  posttime int(10) NOT NULL,
  views int(10) NOT NULL,
  PRIMARY KEY  (itemid),
  KEY uid (uid,cid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_infosort;
CREATE TABLE ps_infosort (
  sortid int(6) unsigned NOT NULL auto_increment,
  sortname varchar(100) NOT NULL,
  PRIMARY KEY  (sortid)
) ENGINE=MyISAM;

INSERT INTO ps_infosort VALUES (1, '葵花宝典');
INSERT INTO ps_infosort VALUES (2, '产品资讯');
INSERT INTO ps_infosort VALUES (3, '前沿动态');
INSERT INTO ps_infosort VALUES (4, '导购');
INSERT INTO ps_infosort VALUES (5, '安全购物');
INSERT INTO ps_infosort VALUES (6, '其他');


DROP TABLE IF EXISTS ps_iteminfo;
CREATE TABLE ps_iteminfo (
  tid mediumint(8) unsigned NOT NULL default '0',
  property text NOT NULL,
  extprice varchar(50) NOT NULL,
  attach text NOT NULL,
  carriage text NOT NULL,
  extra DECIMAL( 4, 2 ) NOT NULL,
  content text NOT NULL,
  ifconvert tinyint(1) NOT NULL,
  tags varchar(50) NOT NULL,
  PRIMARY KEY  (tid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_items;
CREATE TABLE ps_items (
  tid mediumint(8) unsigned NOT NULL auto_increment,
  cid mediumint(8) unsigned NOT NULL default '0',
  ucid mediumint(8) unsigned NOT NULL default '0',
  nid int(6) NOT NULL,
  uid mediumint(8) unsigned NOT NULL default '0',
  seller varchar(40) NOT NULL,
  itemtype tinyint(1) NOT NULL default '1',
  `subject` varchar(255) NOT NULL,
  postdate int(10) NOT NULL default '0',
  hits int(10) NOT NULL default '0',
  itemnum int(10) NOT NULL default '0',
  ifsale tinyint(1) NOT NULL default '0',
  ifcommend tinyint(1) NOT NULL default '0',
  ifcheck tinyint(1) NOT NULL default '1',
  degree tinyint(1) NOT NULL,
  itemprice decimal(8,2) NOT NULL,
  nowprice decimal(8,2) NOT NULL,
  shownum smallint(3) NOT NULL,
  httppic varchar(100) NOT NULL,
  salesnum int(10) NOT NULL default '0',
  salesmoney float NOT NULL default '0',
  duetime int(10) NOT NULL default '0',
  ifgroom tinyint(1) NOT NULL default '0',
  collected int(6) NOT NULL,
  comments smallint(5) NOT NULL,
  updatedegree varchar(3) NOT NULL,
  PRIMARY KEY  (tid),
  KEY ifcommend (ifcommend),
  KEY uid (uid,ucid),
  KEY postdate (ifcheck,cid,postdate)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_message;
CREATE TABLE ps_message (
  mid int(10) unsigned NOT NULL auto_increment,
  touid mediumint(8) unsigned NOT NULL default '0',
  fromuid mediumint(8) unsigned NOT NULL default '0',
  username varchar(15) NOT NULL default '',
  `type` enum('rebox','sebox','public') NOT NULL default 'rebox',
  ifnew tinyint(1) NOT NULL default '0',
  `subject` varchar(100) NOT NULL,
  wtime int(10) unsigned NOT NULL default '0',
  content text NOT NULL,
  PRIMARY KEY  (mid),
  KEY touid (touid),
  KEY fromuid (fromuid),
  KEY `type` (`type`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_nameplate;
CREATE TABLE ps_nameplate (
  nid mediumint(8) NOT NULL auto_increment,
  cid mediumint(8) NOT NULL,
  `name` varchar(30) NOT NULL,
  numbers int(10) NOT NULL,
  PRIMARY KEY  (nid),
  KEY cid (cid)
) ENGINE=MyISAM;

INSERT INTO ps_nameplate VALUES (1, 10, '联想', 0);
INSERT INTO ps_nameplate VALUES (2, 10, '苹果', 0);
INSERT INTO ps_nameplate VALUES (3, 10, '惠普', 0);
INSERT INTO ps_nameplate VALUES (4, 10, '神舟', 0);
INSERT INTO ps_nameplate VALUES (5, 12, '格力', 0);
INSERT INTO ps_nameplate VALUES (6, 12, '海尔', 0);
INSERT INTO ps_nameplate VALUES (7, 12, '奥克斯', 0);
INSERT INTO ps_nameplate VALUES (8, 12, '春兰', 0);
INSERT INTO ps_nameplate VALUES (9, 12, '长虹', 0);
INSERT INTO ps_nameplate VALUES (10, 23, '雅诗兰黛', 0);
INSERT INTO ps_nameplate VALUES (11, 23, '娇韵诗', 0);
INSERT INTO ps_nameplate VALUES (12, 23, '欧莱雅', 0);
INSERT INTO ps_nameplate VALUES (13, 23, '薇姿', 0);
INSERT INTO ps_nameplate VALUES (14, 23, '碧欧泉', 0);

DROP TABLE IF EXISTS ps_nav;
CREATE TABLE ps_nav (
  nid smallint(4) NOT NULL auto_increment,
  title char(50) NOT NULL default '',
  style char(50) NOT NULL default '',
  link char(100) NOT NULL default '',
  alt char(50) NOT NULL default '',
  pos char(10) NOT NULL default '',
  target tinyint(1) NOT NULL default '0',
  `view` smallint(4) NOT NULL default '0',
  PRIMARY KEY  (nid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_order;
CREATE TABLE ps_order (
  oid int(10) unsigned NOT NULL auto_increment,
  trade_no varchar(30) NOT NULL,
  `subject` varchar(255) NOT NULL,
  goodstype tinyint(1) NOT NULL,
  degree tinyint(1) NOT NULL,
  buyeruid mediumint(8) unsigned NOT NULL default '0',
  selleruid mediumint(8) unsigned NOT NULL default '0',
  tid mediumint(8) NOT NULL,
  goodsprice decimal(8,2) NOT NULL,
  quantity int(5) NOT NULL,
  logistics_fee decimal(6,2) NOT NULL,
  logistics_type varchar(40) NOT NULL,
  logistics_payment tinyint(1) NOT NULL,
  buydate int(10) NOT NULL default '0',
  ifpay tinyint(1) NOT NULL default '0',
  tradedate int(10) NOT NULL,
  overtime int(10) NOT NULL,
  payment varchar(20) NOT NULL default '0',
  PRIMARY KEY  (oid),
  KEY oid (trade_no),
  KEY tid (tid),
  KEY ifpay (ifpay,tradedate)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_orderextra;
CREATE TABLE ps_orderextra (
  oid int(10) NOT NULL,
  fromname varchar(20) NOT NULL default '',
  fromtel varchar(15) NOT NULL default '',
  consignee varchar(20) NOT NULL,
  totel varchar(15) NOT NULL default '',
  tozip int(6) NOT NULL default '0',
  toaddress varchar(255) NOT NULL default '',
  sid varchar(30) NOT NULL,
  scompany varchar(100) NOT NULL,
  seacrhway varchar(50) NOT NULL,
  demoey varchar(255) NOT NULL,
  `comment` varchar(255) NOT NULL,
  commentdate int(10) NOT NULL
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_report;
CREATE TABLE ps_report (
  id int(10) unsigned NOT NULL auto_increment,
  type enum('goods','shop','credit') NOT NULL default 'goods',
  tid mediumint(8) unsigned NOT NULL,
  uid mediumint(8) unsigned NOT NULL,
  username varchar(40) NOT NULL,
  reason varchar(255) NOT NULL,
  reporttime int(10) NOT NULL,
  PRIMARY KEY  (id),
  KEY type (type,tid),
  KEY uid (uid),
  KEY tid (tid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_rightset;
CREATE TABLE ps_rightset (