⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 install.sql

📁 PHPShops多用户商城系统（简称PHPShops）是基于电子商务的一套平台交易系统
💻 SQL
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
  gid tinyint(3) unsigned NOT NULL default '0',
  `value` text NOT NULL,
  PRIMARY KEY  (gid)
) ENGINE=MyISAM;

INSERT INTO ps_rightset VALUES (3, 'a:29:{s:12:"basicsetting";s:1:"1";s:8:"setindex";s:1:"1";s:4:"html";s:1:"1";s:5:"style";s:1:"1";s:8:"userskin";s:1:"1";s:8:"adminlog";s:1:"0";s:7:"goodscp";s:1:"1";s:9:"goodscate";s:1:"1";s:9:"nameplate";s:1:"1";s:10:"goodscheck";s:1:"1";s:8:"goodsmsg";s:1:"1";s:11:"goodsreport";s:1:"1";s:7:"ordercp";s:1:"1";s:9:"volustats";s:1:"0";s:6:"usercp";s:1:"1";s:6:"shopcp";s:1:"1";s:8:"shopcate";s:1:"1";s:9:"shopcheck";s:1:"1";s:7:"shopmsg";s:1:"1";s:10:"shopreport";s:1:"1";s:5:"buyer";s:1:"1";s:6:"seller";s:1:"1";s:4:"list";s:1:"1";s:6:"report";s:1:"1";s:5:"level";s:1:"1";s:10:"hackcenter";s:1:"1";s:11:"information";s:1:"1";s:9:"sharelink";s:1:"1";s:7:"affiche";s:1:"1";}');

DROP TABLE IF EXISTS ps_setting;
CREATE TABLE ps_setting (
  db_name varchar(30) NOT NULL default '',
  db_value text NOT NULL,
  descrip varchar(50) NOT NULL default '',
  PRIMARY KEY  (db_name)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_sharelink;
CREATE TABLE ps_sharelink (
  sid mediumint(8) NOT NULL auto_increment,
  uid mediumint(8) NOT NULL,
  vieworder tinyint(3) NOT NULL,
  sitename varchar(100) NOT NULL,
  siteurl varchar(100) NOT NULL,
  descrip varchar(200) NOT NULL,
  logo varchar(100) NOT NULL,
  ifcheck tinyint(1) NOT NULL,
  addate int(10) NOT NULL,
  PRIMARY KEY  (sid),
  KEY uid (uid)
) ENGINE=MyISAM;

INSERT INTO ps_sharelink VALUES (1, -1, 0, 'phpshops', 'http://www.phpshops.com', 'phpshops', 'http://www.phpshops.com/logo.png', 1, 1198913171);

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

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

DROP TABLE IF EXISTS ps_shopcate;
CREATE TABLE ps_shopcate (
  sid MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT ,
  sup INT( 6 ) NOT NULL ,
  name VARCHAR( 100 ) NOT NULL ,
  shopnum INT( 6 ) NOT NULL ,
  PRIMARY KEY (sid) 
) TYPE = MYISAM;

INSERT INTO ps_shopcate VALUES (1, 0, '服装', 0);
INSERT INTO ps_shopcate VALUES (2, 0, '数码', 0);
INSERT INTO ps_shopcate VALUES (3, 2, '相机', 0);
INSERT INTO ps_shopcate VALUES (4, 2, '笔记本', 0);
INSERT INTO ps_shopcate VALUES (5, 0, '家电', 0);
INSERT INTO ps_shopcate VALUES (6, 0, '土特产', 0);


DROP TABLE IF EXISTS ps_shopper;
CREATE TABLE ps_shopper (
  uid mediumint(8) unsigned NOT NULL auto_increment,
  groupid tinyint(3) NOT NULL default '-1',
  sellerid tinyint(3) NOT NULL default '0',
  memberid tinyint(3) NOT NULL default '0',
  username varchar(20) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  idcard varchar(30) NOT NULL default '',
  tel varchar(15) NOT NULL default '',
  address varchar(255) NOT NULL default '',
  zip int(6) NOT NULL default '0',
  regdate int(10) NOT NULL default '0',
  editor tinyint(1) NOT NULL default '0',
  gender tinyint(1) NOT NULL default '0',
  qq varchar(80) NOT NULL,
  province varchar(10) NOT NULL default '',
  city varchar(20) NOT NULL default '',
  PRIMARY KEY  (uid),
  KEY sellerid (sellerid)
) ENGINE=MyISAM ;

DROP TABLE IF EXISTS ps_shopperdata;
CREATE TABLE ps_shopperdata (
  uid mediumint(8) unsigned NOT NULL default '0',
  shopcredit int(6) NOT NULL default '0',
  bbargain int(8) NOT NULL,
  sbargain int(8) NOT NULL,
  bdegree int(8) NOT NULL,
  sdegree int(8) NOT NULL,
  saleroom float NOT NULL default '0',
  buyroom float NOT NULL default '0',
  lastvisit int(10) NOT NULL,
  thisvisit int(10) NOT NULL,
  onlineip varchar(30) NOT NULL,
  newmsg int(3) NOT NULL,
  bcredit int(10) NOT NULL,
  bcent decimal(5,2) NOT NULL,
  bcredit_1 int(10) NOT NULL,
  bcredit_2 int(10) NOT NULL,
  bcredit_3 int(10) NOT NULL,
  scredit int(10) NOT NULL,
  scent decimal(5,2) NOT NULL,
  scredit_1 int(10) NOT NULL,
  scredit_2 int(10) NOT NULL,
  scredit_3 int(10) NOT NULL,
  PRIMARY KEY  (uid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_shopset;
CREATE TABLE ps_shopset (
  uid mediumint(8) unsigned NOT NULL,
  collected int(6) NOT NULL,
  style varchar(12) NOT NULL,
  icon varchar(100) NOT NULL,
  storename varchar(50) NOT NULL,
  product varchar(255) NOT NULL,
  cateid int(6) NOT NULL,
  opentime int(10) NOT NULL,
  catedir text NOT NULL,
  ifopen tinyint(1) NOT NULL,
  aboutme text NOT NULL,
  ifcommend tinyint(1) NOT NULL,
  itemsnum int(6) NOT NULL,
  grooms varchar(255) NOT NULL,
  onlinepay text NOT NULL,
  link text NOT NULL,
  PRIMARY KEY  (uid),
  KEY ifcommend (ifcommend),
  KEY opentime (ifopen,opentime)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS ps_style;
CREATE TABLE ps_style (
  sid smallint(6) unsigned NOT NULL auto_increment,
  `name` char(50) NOT NULL default '',
  stylepath char(50) NOT NULL default '',
  tplpath char(50) NOT NULL default '',
  PRIMARY KEY  (sid)
) ENGINE=MyISAM;

INSERT INTO ps_style VALUES (1, 'shop', 'default', 'default');

DROP TABLE IF EXISTS ps_syscache;
CREATE TABLE ps_syscache (
  `name` varchar(15) NOT NULL,
  title varchar(40) NOT NULL,
  ifopen tinyint(1) NOT NULL,
  upstep mediumint(8) NOT NULL,
  `value` text NOT NULL,
  config text NOT NULL,
  lastupdate int(10) NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM;

INSERT INTO ps_syscache VALUES ('notice', '系统公告', 1, 0, '', 'a:1:{s:3:"num";s:2:"10";}', 0);
INSERT INTO ps_syscache VALUES ('player', '滚动播放器', 1, 0, 'a:1:{i:0;a:5:{s:5:"title";s:7:"我的啊 ";s:3:"url";s:19:"images/showpic2.jpg";s:4:"link";s:21:"http://www.google.com";s:9:"vieworder";i:0;s:6:"ifopen";i:1;}}', '', 1198604180);
INSERT INTO ps_syscache VALUES ('category', '商品分类', 1, 0, 'a:14:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:1:"3";i:3;s:1:"4";i:4;s:1:"5";i:5;s:2:"56";i:6;s:2:"25";i:7;s:2:"26";i:8;s:2:"50";i:9;s:2:"55";i:10;s:2:"60";i:11;s:2:"62";i:12;s:2:"67";i:13;s:2:"72";}', '', 0);
INSERT INTO ps_syscache VALUES ('hotgoods', '推荐商品', 1, 10, '', 'a:2:{s:3:"num";s:2:"10";s:4:"type";s:1:"2";}', 1199292870);
INSERT INTO ps_syscache VALUES ('hotshop', '推荐店铺', 1, 3, 'a:10:{i:0;a:2:{s:3:"uid";s:2:"36";s:9:"storename";s:11:"哈哈哈30-40";}i:1;a:2:{s:3:"uid";s:2:"35";s:9:"storename";s:11:"哈哈哈30-40";}i:2;a:2:{s:3:"uid";s:1:"1";s:9:"storename";s:10:"哈哈哈1-10";}i:3;a:2:{s:3:"uid";s:2:"23";s:9:"storename";s:11:"哈哈哈20-30";}i:4;a:2:{s:3:"uid";s:2:"24";s:9:"storename";s:11:"哈哈哈20-30";}i:5;a:2:{s:3:"uid";s:2:"46";s:9:"storename";s:18:"哈哈哈哈哈哈哈哈哈";}i:6;a:2:{s:3:"uid";s:2:"22";s:9:"storename";s:11:"哈哈哈20-30";}i:7;a:2:{s:3:"uid";s:2:"43";s:9:"storename";s:18:"哈哈哈哈哈哈哈哈哈";}i:8;a:2:{s:3:"uid";s:2:"21";s:9:"storename";s:11:"哈哈哈20-30";}i:9;a:2:{s:3:"uid";s:1:"8";s:9:"storename";s:10:"哈哈哈1-10";}}', 'a:2:{s:3:"num";s:2:"10";s:4:"type";s:1:"2";}', 1199290916);
INSERT INTO ps_syscache VALUES ('newtrade', '最新交易', 1, 30, 'a:6:{i:0;a:3:{s:7:"subject";s:47:"韩国同步 秋冬必备今年流行款式堆帽针黹帽 鸭舌帽 ";s:3:"tid";s:4:"2039";s:10:"goodsprice";s:6:"300.00";}i:1;a:3:{s:7:"subject";s:47:"韩国同步 秋冬必备今年流行款式堆帽针黹帽 鸭舌帽 ";s:3:"tid";s:4:"2039";s:10:"goodsprice";s:6:"300.00";}i:2;a:3:{s:7:"subject";s:47:"韩国同步 秋冬必备今年流行款式堆帽针黹帽 鸭舌帽 ";s:3:"tid";s:2:"79";s:10:"goodsprice";s:5:"18.00";}i:3;a:3:{s:7:"subject";s:14:"舍夫斯基接口撒";s:3:"tid";s:4:"2052";s:10:"goodsprice";s:6:"100.00";}i:4;a:3:{s:7:"subject";s:14:"舍夫斯基接口撒";s:3:"tid";s:4:"2052";s:10:"goodsprice";s:6:"100.00";}i:5;a:3:{s:7:"subject";s:47:"韩国同步 秋冬必备今年流行款式堆帽针黹帽 鸭舌帽 ";s:3:"tid";s:3:"201";s:10:"goodsprice";s:4:"1.00";}}', 'a:2:{s:3:"num";s:2:"10";s:6:"height";i:200;}', 1199292870);
INSERT INTO ps_syscache VALUES ('information', '资讯', 0, 30, '', '', 0);
INSERT INTO ps_syscache VALUES ('guidebuy', '导购', 1, 2, '', '', 0);
INSERT INTO ps_syscache VALUES ('friendlink', '友情链接', 1, 0, 'a:1:{i:0;a:4:{s:8:"sitename";s:8:"phpshops";s:7:"siteurl";s:23:"http://bbs.phpshops.com";s:7:"descrip";s:8:"phpshops";s:4:"logo";s:32:"http://bbs.phpshops.com/logo.png";}}', '', 0);
INSERT INTO ps_syscache VALUES ('ads', '', 0, 0, '', '', 0);
INSERT INTO ps_syscache VALUES ('bbs_1', '', '1', '0', '', '', '0');
INSERT INTO ps_syscache VALUES ('bbs_2', '', '1', '0', '', '', '0');
INSERT INTO ps_syscache VALUES ('bbs_3', '', '1', '0', '', '', '0');
INSERT INTO ps_syscache VALUES ('bbs_4', '', '1', '0', '', '', '0');

DROP TABLE IF EXISTS ps_sysinfo;
CREATE TABLE ps_sysinfo (
  id smallint(3) NOT NULL auto_increment,
1234

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -