install.sql

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

DROP TABLE IF EXISTS ps_address;
CREATE TABLE ps_address (
  aid mediumint(8) NOT NULL auto_increment,
  uid mediumint(8) NOT NULL default '0',
  toname varchar(20) NOT NULL default '',
  totel varchar(15) NOT NULL default '',
  tozip int(6) NOT NULL default '0',
  toemail varchar(60) NOT NULL default '',
  toaddress varchar(255) NOT NULL default '',
  PRIMARY KEY  (aid),
  KEY uid (uid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_announce;
CREATE TABLE ps_announce (
  aid smallint(6) unsigned NOT NULL auto_increment,
  `type` enum('system','seller','header') NOT NULL,
  tourl varchar(100) NOT NULL,
  vieworder smallint(6) NOT NULL default '0',
  author varchar(15) NOT NULL default '',
  posttime int(10) NOT NULL,
  `subject` varchar(100) NOT NULL,
  content text NOT NULL,
  ifuse tinyint(1) NOT NULL,
  PRIMARY KEY  (aid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_cache;
CREATE TABLE ps_cache (
  cid int(6) NOT NULL,
  infomation text NOT NULL,
  PRIMARY KEY  (cid),
  KEY cid (cid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_carry;
CREATE TABLE ps_carry (
  cid mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) NOT NULL,
  `type` varchar(40) NOT NULL default '',
  carriage decimal(5,2) NOT NULL default '0.00',
  description varchar(255) NOT NULL,
  ifcommend tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (cid),
  KEY uid (uid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_category;
CREATE TABLE ps_category (
  cid mediumint(8) unsigned NOT NULL auto_increment,
  cup smallint(5) unsigned NOT NULL default '0',
  `type` tinyint(3) unsigned NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  cupinfo varchar(255) NOT NULL default '',
  vieworder tinyint(3) NOT NULL default '0',
  ifshow tinyint(1) NOT NULL default '0',
  ifmenu tinyint(1) NOT NULL,
  items int(10) NOT NULL,
  nid varchar(255) NOT NULL,
  identity text NOT NULL,
  PRIMARY KEY  (cid)
) ENGINE=MyISAM;

INSERT INTO ps_category VALUES (1, 0, 0, '魅力男人', '', 0, 0, 1, 0, '', '');
INSERT INTO ps_category VALUES (2, 0, 0, '精致女人', '', 0, 0, 1, 0, '', '');
INSERT INTO ps_category VALUES (3, 0, 0, '数码广场', '', 0, 0, 1, 0, '', '');
INSERT INTO ps_category VALUES (4, 0, 0, '运动休闲', '', 0, 0, 1, 0, '', '');
INSERT INTO ps_category VALUES (5, 0, 0, '家居电器', '', 0, 0, 1, 0, '', '');
INSERT INTO ps_category VALUES (6, 2, 1, '女士内衣', '2,', 0, 0, 0, 0, '', '');
INSERT INTO ps_category VALUES (7, 2, 1, '无痕内裤', '2,', 0, 0, 0, 0, '', '');
INSERT INTO ps_category VALUES (8, 2, 1, '化妆品', '2,', 0, 0, 0, 0, '', '');
INSERT INTO ps_category VALUES (9, 3, 1, '数码相机', '3,', 0, 0, 0, 0, '', '');
INSERT INTO ps_category VALUES (10, 3, 1, '笔记本', '3,', 0, 0, 0, 0, '21,22,23,24', '');
INSERT INTO ps_category VALUES (11, 3, 1, '手机', '3,', 0, 0, 0, 0, '', '');
INSERT INTO ps_category VALUES (12, 5, 1, '空调', '5,', 0, 0, 0, 0, '25,26,27,28,29', '');
INSERT INTO ps_category VALUES (13, 5, 1, '液晶电视', '5,', 0, 0, 0, 0, '', '');
INSERT INTO ps_category VALUES (14, 5, 1, '家庭影院', '5,', 0, 0, 0, 0, '', '');
INSERT INTO ps_category VALUES (15, 5, 1, '电磁炉', '5,', 0, 0, 0, 0, '', '');
INSERT INTO ps_category VALUES (16, 4, 1, '帆布鞋', '4,', 0, 0, 0, 0, '', '');
INSERT INTO ps_category VALUES (17, 4, 1, '帐篷', '4,', 0, 0, 0, 0, '', '');
INSERT INTO ps_category VALUES (18, 4, 1, '登山鞋', '4,', 0, 0, 0, 0, '', '');
INSERT INTO ps_category VALUES (19, 4, 1, '运动服', '4,', 0, 0, 0, 0, '', '');
INSERT INTO ps_category VALUES (20, 1, 1, '保暖内衣', '1,', 0, 0, 0, 0, '', 'a:2:{s:4:"size";a:4:{s:5:"title";s:4:"大小";s:4:"type";s:1:"2";s:7:"content";s:18:"165 ,170 ,175 ,180";s:7:"explain";s:0:"";}s:5:"color";a:4:{s:5:"title";s:4:"颜色";s:4:"type";s:1:"2";s:7:"content";s:22:"黑色 ,灰色 ,米色 ,蓝色";s:7:"explain";s:0:"";}}');
INSERT INTO ps_category VALUES (21, 1, 1, '夹克', '1,', 0, 0, 0, 0, '', '');
INSERT INTO ps_category VALUES (22, 1, 1, '皮带', '1,', 0, 0, 0, 0, '', '');
INSERT INTO ps_category VALUES (23, 8, 2, '洁面', '2,8,', 0, 0, 0, 0, '30,31,32,33,34', '');
INSERT INTO ps_category VALUES (24, 8, 2, '爽肤', '2,8,', 0, 0, 0, 0, '', '');
INSERT INTO ps_category VALUES (25, 8, 2, '隔离霜', '2,8,', 0, 0, 0, 0, '', '');

DROP TABLE IF EXISTS ps_credit;
CREATE TABLE ps_credit (
  id int(10) unsigned NOT NULL auto_increment,
  oid int(10) unsigned NOT NULL,
  valueto enum('buyer','seller') NOT NULL,
  touid mediumint(8) NOT NULL,
  fromuid mediumint(8) NOT NULL,
  `point` tinyint(3) NOT NULL,
  content text NOT NULL,
  addate int(10) NOT NULL,
  PRIMARY KEY  (id),
  KEY touid (touid),
  KEY fromuid (fromuid),
  KEY addate (addate),
  KEY oid (oid,valueto)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_domain;
CREATE TABLE ps_domain (
  uid mediumint(8) unsigned NOT NULL,
  predomain varchar(20) NOT NULL,
  domain varchar(40) NOT NULL,
  PRIMARY KEY  (uid),
  KEY predomain (predomain),
  KEY domain (domain)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_goods_commend;
CREATE TABLE ps_goods_commend (
  tid mediumint(8) NOT NULL,
  presenter varchar(40) NOT NULL,
  operatetime int(10) NOT NULL,
  PRIMARY KEY  (tid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_goods_message;
CREATE TABLE ps_goods_message (
  id int(10) unsigned NOT NULL auto_increment,
  tid mediumint(8) unsigned NOT NULL default '0',
  touid mediumint(8) NOT NULL,
  username varchar(40) NOT NULL,
  uid mediumint(8) unsigned NOT NULL default '0',
  postdate int(10) NOT NULL default '0',
  ifcheck tinyint(1) NOT NULL default '0',
  messagedb text NOT NULL,
  redb text NOT NULL,
  retime int(10) NOT NULL,
  PRIMARY KEY  (id),
  KEY tid (tid,postdate),
  KEY reuid (retime),
  KEY touid (touid),
  KEY retime (retime)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_group;
CREATE TABLE ps_group (
  gid tinyint(3) unsigned NOT NULL auto_increment,
  `type` enum('system','default','member','seller') NOT NULL default 'member',
  title varchar(30) NOT NULL default '',
  img varchar(15) NOT NULL default '',
  creditneed int(10) NOT NULL default '0',
  ifdefault tinyint(1) NOT NULL default '0',
  sright text NOT NULL,
  sellright text NOT NULL,
  mright text NOT NULL,
  admincp tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (gid),
  KEY `type` (`type`),
  KEY creditneed (creditneed)
) ENGINE=MyISAM;

INSERT INTO `ps_group` VALUES (1, 'default', 'default', '', 78, 0, 'a:10:{s:8:"allowbuy";s:1:"0";s:13:"message_goods";s:1:"0";s:12:"message_shop";s:1:"0";s:12:"commentcheck";s:1:"0";s:12:"report_goods";s:1:"0";s:11:"report_shop";s:1:"0";s:5:"shops";s:1:"0";s:5:"items";s:1:"0";s:7:"address";s:1:"0";s:7:"imgsize";i:0;}', '', '', 0);
INSERT INTO `ps_group` VALUES (2, 'default', '游客', '', 78, 0, 'a:10:{s:8:"allowbuy";s:1:"0";s:13:"message_goods";s:1:"0";s:12:"message_shop";s:1:"0";s:12:"commentcheck";s:1:"0";s:12:"report_goods";s:1:"0";s:11:"report_shop";s:1:"0";s:5:"shops";s:1:"0";s:5:"items";s:1:"0";s:7:"address";s:1:"0";s:7:"imgsize";i:0;}', '', '', 0);
INSERT INTO `ps_group` VALUES (3, 'system', '管理员', '', 0, 0, 'a:11:{s:8:"allowbuy";s:1:"1";s:13:"message_goods";s:1:"1";s:12:"message_shop";s:1:"1";s:12:"commentcheck";s:1:"0";s:12:"report_goods";s:1:"1";s:11:"report_shop";s:1:"0";s:5:"shops";s:2:"10";s:5:"items";s:2:"10";s:7:"address";s:2:"10";s:6:"maxmsg";s:3:"100";s:7:"imgsize";i:0;}', 'a:11:{s:6:"ifsell";s:1:"1";s:15:"sell_team_goods";s:1:"1";s:12:"del_shop_msg";s:1:"1";s:13:"del_goods_msg";s:1:"1";s:7:"wysiwyg";s:1:"1";s:8:"htmlcode";s:1:"1";s:10:"info_check";s:1:"0";s:10:"shopwindow";s:1:"8";s:8:"shoplogo";s:1:"1";s:13:"shoplogowidth";s:3:"150";s:14:"shoplogoheight";s:3:"150";}', 'a:6:{s:12:"allowadmincp";s:1:"1";s:8:"delgoods";s:1:"1";s:12:"checkcomment";s:1:"1";s:17:"del_message_goods";s:1:"1";s:13:"goods_commend";s:1:"1";s:12:"shop_commend";s:1:"1";}', 1);
INSERT INTO `ps_group` VALUES (4, 'system', '商品管理组', '', 0, 0, 'a:11:{s:8:"allowbuy";s:1:"1";s:13:"message_goods";s:1:"1";s:12:"message_shop";s:1:"1";s:12:"commentcheck";s:1:"0";s:12:"report_goods";s:1:"1";s:11:"report_shop";s:1:"1";s:5:"shops";s:1:"5";s:5:"items";s:1:"5";s:7:"address";s:1:"5";s:6:"maxmsg";s:2:"80";s:7:"imgsize";i:0;}', 'a:11:{s:6:"ifsell";s:1:"1";s:15:"sell_team_goods";s:1:"1";s:12:"del_shop_msg";s:1:"1";s:13:"del_goods_msg";s:1:"1";s:7:"wysiwyg";s:1:"1";s:8:"htmlcode";s:1:"1";s:10:"info_check";s:1:"0";s:10:"shopwindow";s:1:"4";s:8:"shoplogo";s:1:"1";s:13:"shoplogowidth";s:3:"150";s:14:"shoplogoheight";s:3:"150";}', 'a:6:{s:12:"allowadmincp";s:1:"0";s:8:"delgoods";s:1:"1";s:12:"checkcomment";s:1:"1";s:17:"del_message_goods";s:1:"1";s:13:"goods_commend";s:1:"1";s:12:"shop_commend";s:1:"1";}', 0);
INSERT INTO `ps_group` VALUES (5, 'system', '禁止发商品组', '', 0, 0, 'a:11:{s:8:"allowbuy";s:1:"1";s:13:"message_goods";s:1:"0";s:12:"message_shop";s:1:"0";s:12:"commentcheck";s:1:"1";s:12:"report_goods";s:1:"0";s:11:"report_shop";s:1:"0";s:5:"shops";s:1:"0";s:5:"items";s:1:"0";s:7:"address";s:1:"0";s:6:"maxmsg";s:2:"50";s:7:"imgsize";i:0;}', 'a:11:{s:6:"ifsell";s:1:"0";s:15:"sell_team_goods";s:1:"0";s:12:"del_shop_msg";s:1:"0";s:13:"del_goods_msg";s:1:"0";s:7:"wysiwyg";s:1:"0";s:8:"htmlcode";s:1:"0";s:10:"info_check";s:1:"1";s:10:"shopwindow";s:1:"0";s:8:"shoplogo";s:1:"0";s:13:"shoplogowidth";s:1:"0";s:14:"shoplogoheight";s:1:"0";}', 'a:6:{s:12:"allowadmincp";s:1:"0";s:8:"delgoods";s:1:"0";s:12:"checkcomment";s:1:"0";s:17:"del_message_goods";s:1:"0";s:13:"goods_commend";s:1:"0";s:12:"shop_commend";s:1:"0";}', 0);
INSERT INTO `ps_group` VALUES (6, 'system', '未验证用户组', '', 0, 0, 'a:11:{s:8:"allowbuy";s:1:"0";s:13:"message_goods";s:1:"0";s:12:"message_shop";s:1:"0";s:12:"commentcheck";s:1:"1";s:12:"report_goods";s:1:"0";s:11:"report_shop";s:1:"0";s:5:"shops";s:1:"0";s:5:"items";s:1:"0";s:7:"address";s:1:"0";s:6:"maxmsg";s:1:"0";s:7:"imgsize";i:0;}', 'a:11:{s:6:"ifsell";s:1:"0";s:15:"sell_team_goods";s:1:"0";s:12:"del_shop_msg";s:1:"0";s:13:"del_goods_msg";s:1:"0";s:7:"wysiwyg";s:1:"0";s:8:"htmlcode";s:1:"0";s:10:"info_check";s:1:"1";s:10:"shopwindow";s:1:"0";s:8:"shoplogo";s:1:"0";s:13:"shoplogowidth";s:1:"0";s:14:"shoplogoheight";s:1:"0";}', 'a:6:{s:12:"allowadmincp";s:1:"0";s:8:"delgoods";s:1:"0";s:12:"checkcomment";s:1:"0";s:17:"del_message_goods";s:1:"0";s:13:"goods_commend";s:1:"0";s:12:"shop_commend";s:1:"0";}', 0);
INSERT INTO `ps_group` VALUES (7, 'member', '初级会员', 'b1', 0, 0, 'a:11:{s:8:"allowbuy";s:1:"1";s:13:"message_goods";s:1:"0";s:12:"message_shop";s:1:"0";s:12:"commentcheck";s:1:"1";s:12:"report_goods";s:1:"1";s:11:"report_shop";s:1:"1";s:5:"shops";s:1:"3";s:5:"items";s:1:"3";s:7:"address";s:1:"3";s:6:"maxmsg";s:2:"20";s:7:"imgsize";i:0;}', '', '', 0);
INSERT INTO `ps_group` VALUES (8, 'member', '二级会员', 'b2', 50, 0, 'a:11:{s:8:"allowbuy";s:1:"1";s:13:"message_goods";s:1:"1";s:12:"message_shop";s:1:"1";s:12:"commentcheck";s:1:"0";s:12:"report_goods";s:1:"1";s:11:"report_shop";s:1:"1";s:5:"shops";s:1:"6";s:5:"items";s:1:"6";s:7:"address";s:1:"6";s:6:"maxmsg";s:2:"20";s:7:"imgsize";i:0;}', '', '', 0);
INSERT INTO `ps_group` VALUES (9, 'member', '三级会员', 'b3', 100, 0, 'a:11:{s:8:"allowbuy";s:1:"1";s:13:"message_goods";s:1:"1";s:12:"message_shop";s:1:"1";s:12:"commentcheck";s:1:"0";s:12:"report_goods";s:1:"1";s:11:"report_shop";s:1:"1";s:5:"shops";s:2:"12";s:5:"items";s:2:"12";s:7:"address";s:2:"12";s:6:"maxmsg";s:2:"30";s:7:"imgsize";i:0;}', '', '', 0);
INSERT INTO `ps_group` VALUES (10, 'member', '四级会员', 'b4', 200, 0, 'a:11:{s:8:"allowbuy";s:1:"1";s:13:"message_goods";s:1:"1";s:12:"message_shop";s:1:"1";s:12:"commentcheck";s:1:"0";s:12:"report_goods";s:1:"1";s:11:"report_shop";s:1:"1";s:5:"shops";s:2:"15";s:5:"items";s:2:"15";s:7:"address";s:2:"15";s:6:"maxmsg";s:2:"40";s:7:"imgsize";i:0;}', '', '', 0);
INSERT INTO `ps_group` VALUES (11, 'member', '高级会员', 'b5', 500, 0, 'a:11:{s:8:"allowbuy";s:1:"1";s:13:"message_goods";s:1:"1";s:12:"message_shop";s:1:"1";s:12:"commentcheck";s:1:"0";s:12:"report_goods";s:1:"1";s:11:"report_shop";s:1:"1";s:5:"shops";s:2:"20";s:5:"items";s:2:"20";s:7:"address";s:2:"20";s:6:"maxmsg";s:2:"50";s:7:"imgsize";i:0;}', '', '', 0);
INSERT INTO `ps_group` VALUES (12, 'seller', '贩子', 's1', 0, 0, '', 'a:12:{s:6:"ifsell";s:1:"1";s:12:"del_shop_msg";s:1:"1";s:13:"del_goods_msg";s:1:"1";s:7:"wysiwyg";s:1:"1";s:8:"htmlcode";s:1:"1";s:10:"info_check";s:1:"0";s:10:"shopwindow";s:1:"2";s:8:"shoplogo";s:1:"1";s:13:"shoplogowidth";s:3:"150";s:14:"shoplogoheight";s:3:"150";s:10:"maxsellnum";i:20;s:7:"skinnum";i:3;}', '', 0);
INSERT INTO `ps_group` VALUES (13, 'seller', '小二', 's2', 50, 0, '', 'a:13:{s:6:"ifsell";s:1:"1";s:15:"sell_team_goods";s:1:"1";s:12:"del_shop_msg";s:1:"1";s:13:"del_goods_msg";s:1:"1";s:7:"wysiwyg";s:1:"1";s:8:"htmlcode";s:1:"1";s:10:"info_check";s:1:"0";s:10:"shopwindow";s:1:"4";s:8:"shoplogo";s:1:"1";s:13:"shoplogowidth";s:3:"150";s:14:"shoplogoheight";s:3:"150";s:10:"maxsellnum";i:20;s:7:"skinnum";i:3;}', '', 0);
INSERT INTO `ps_group` VALUES (14, 'seller', '掌柜', 's3', 100, 0, '', 'a:13:{s:6:"ifsell";s:1:"1";s:15:"sell_team_goods";s:1:"1";s:12:"del_shop_msg";s:1:"1";s:13:"del_goods_msg";s:1:"1";s:7:"wysiwyg";s:1:"1";s:8:"htmlcode";s:1:"1";s:10:"info_check";s:1:"0";s:10:"shopwindow";s:1:"8";s:8:"shoplogo";s:1:"1";s:13:"shoplogowidth";s:3:"150";s:14:"shoplogoheight";s:3:"150";s:10:"maxsellnum";i:20;s:7:"skinnum";i:3;}', '', 0);

DROP TABLE IF EXISTS ps_hack;
CREATE TABLE ps_hack (
  hk_name varchar(30) NOT NULL,
  hk_value text NOT NULL,
  descrip varchar(50) NOT NULL,
  PRIMARY KEY  (hk_name)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_information;
CREATE TABLE ps_information (
  itemid int(10) unsigned NOT NULL auto_increment,
  sortid int(6) NOT NULL,
  uid mediumint(8) NOT NULL,
  author varchar(40) NOT NULL,