cn_all_1.3.sql

PHP+MySQL网上商城! VC 1.2版,可升级到1.3版！里面有升级说明

  newpassid varchar(10) default NULL,
  credits int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (userid),
  UNIQUE KEY username (username),
  KEY status (status)
) TYPE=MyISAM;

DROP TABLE IF EXISTS vte_menuitems;
CREATE TABLE vte_menuitems (
  id smallint(3) unsigned NOT NULL auto_increment,
  title varchar(200) NOT NULL default '',
  url varchar(250) default NULL,
  supid smallint(3) unsigned NOT NULL default '0',
  flag smallint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

INSERT INTO vte_menuitems VALUES('1','基本设置','','1','1');
INSERT INTO vte_menuitems VALUES('2','基本信息','adm_info.php','1','1');
INSERT INTO vte_menuitems VALUES('3','常规设置','adm_setting.php','1','1');
INSERT INTO vte_menuitems VALUES('4','公告设置','adm_bulletin.php','1','1');
INSERT INTO vte_menuitems VALUES('5','广告设置','adm_banner.php','1','1');
INSERT INTO vte_menuitems VALUES('25','风格设置','','25','1');
INSERT INTO vte_menuitems VALUES('26','风格编辑','adm_style.php','25','1');
INSERT INTO vte_menuitems VALUES('6','用户设置','','6','1');
INSERT INTO vte_menuitems VALUES('7','会员编辑','adm_members.php','6','1');
INSERT INTO vte_menuitems VALUES('8','会员组编辑','adm_group.php','6','1');
INSERT INTO vte_menuitems VALUES('11','投票设置','adm_vote.php','1','1');
INSERT INTO vte_menuitems VALUES('12','商品设置','','12','1');
INSERT INTO vte_menuitems VALUES('13','类别编辑','adm_sort.php','12','1');
INSERT INTO vte_menuitems VALUES('14','配置表编辑','adm_parameter.php','12','1');
INSERT INTO vte_menuitems VALUES('15','添加商品','adm_addproduct.php','12','1');
INSERT INTO vte_menuitems VALUES('16','商品编辑','adm_product.php','12','1');
INSERT INTO vte_menuitems VALUES('17','商品转移','adm_moveproduct.php','12','1');
INSERT INTO vte_menuitems VALUES('18','推荐设置','adm_recommend.php','12','1');
INSERT INTO vte_menuitems VALUES('19','购物设置','','19','1');
INSERT INTO vte_menuitems VALUES('20','送货方式','adm_delivery.php','19','1');
INSERT INTO vte_menuitems VALUES('21','订单管理','adm_order.php','19','1');
INSERT INTO vte_menuitems VALUES('30','帮助设置','','30','1');
INSERT INTO vte_menuitems VALUES('31','购物指南','adm_guide.php','30','1');
INSERT INTO vte_menuitems VALUES('33','数据设置','','33','1');
INSERT INTO vte_menuitems VALUES('34','更新模版','adm_updatecache.php','33','1');
INSERT INTO vte_menuitems VALUES('35','数据库升级','adm_updatesql.php','33','1');
INSERT INTO vte_menuitems VALUES('28','语言设置','adm_language.php','25','1');
INSERT INTO vte_menuitems VALUES('27','模版编辑','adm_tpl.php','25','1');
INSERT INTO vte_menuitems VALUES('36','数据备份','adm_backup.php','33','1');
INSERT INTO vte_menuitems VALUES('37','数据恢复','adm_restore.php','33','1');
INSERT INTO vte_menuitems VALUES('38','连接设置','adm_frendlink.php','1','1');
INSERT INTO vte_menuitems VALUES('39','论坛设置','','39','1');
INSERT INTO vte_menuitems VALUES('40','会员同步','adm_bbsmembers.php','39','1');
INSERT INTO vte_menuitems VALUES('41','论坛设置','adm_bbs.php','39','1');
INSERT INTO vte_menuitems VALUES('42','杂项设置','','42','1');
INSERT INTO vte_menuitems VALUES('43','商城通知','adm_notify.php','42','1');

DROP TABLE IF EXISTS vte_orders;
CREATE TABLE vte_orders (
  oid varchar(20) NOT NULL default '0',
  username varchar(50) default '0',
  totalprice decimal(20,2) default '0.00',
  realname varchar(50) default '0',
  addr text,
  postalcode varchar(10) default NULL,
  tel varchar(20) default '0',
  posttime int(10) unsigned default '0',
  did smallint(3) NOT NULL default '0',
  pid smallint(3) unsigned default '0',
  mobile varchar(20) default '0',
  PRIMARY KEY  (oid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS vte_orderstatus;
CREATE TABLE vte_orderstatus (
  pid smallint(3) NOT NULL default '0',
  subject varchar(100) NOT NULL default '',
  notes varchar(250) default NULL,
  PRIMARY KEY  (pid)
) TYPE=MyISAM;

INSERT INTO vte_orderstatus VALUES('0','订单删除','');
INSERT INTO vte_orderstatus VALUES('1','订单提交','');
INSERT INTO vte_orderstatus VALUES('2','等待付款','');
INSERT INTO vte_orderstatus VALUES('3','付款确认','');
INSERT INTO vte_orderstatus VALUES('4','付款成功','');
INSERT INTO vte_orderstatus VALUES('5','商品送出','');
INSERT INTO vte_orderstatus VALUES('6','商品收到','');
INSERT INTO vte_orderstatus VALUES('8','交易完成','');
INSERT INTO vte_orderstatus VALUES('9','订单撤消','');

DROP TABLE IF EXISTS vte_parameters;
CREATE TABLE vte_parameters (
  paraid smallint(6) unsigned NOT NULL auto_increment,
  paraname varchar(50) default NULL,
  tplfile varchar(100) default NULL,
  PRIMARY KEY  (paraid)
) TYPE=MyISAM;

INSERT INTO vte_parameters VALUES('2','笔记本电脑','');
INSERT INTO vte_parameters VALUES('1','不使用配置表','');

DROP TABLE IF EXISTS vte_paravals;
CREATE TABLE vte_paravals (
  productid smallint(10) unsigned NOT NULL default '0',
  paraid smallint(10) unsigned NOT NULL default '0',
  varname varchar(20) NOT NULL default '',
  value varchar(250) default NULL,
  PRIMARY KEY  (productid,paraid,varname)
) TYPE=MyISAM;


DROP TABLE IF EXISTS vte_paravars;
CREATE TABLE vte_paravars (
  paraid smallint(6) unsigned NOT NULL default '0',
  varname varchar(20) NOT NULL default '',
  varhint varchar(50) default NULL,
  remarks varchar(250) default NULL,
  sid smallint(6) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (paraid,varname),
  KEY sid (sid)
) TYPE=MyISAM;

INSERT INTO vte_paravars VALUES('2','lcd','显示屏','','2');
INSERT INTO vte_paravars VALUES('2','cpu','CPU (主频)','','1');
INSERT INTO vte_paravars VALUES('2','mainboard','主板','','8');
INSERT INTO vte_paravars VALUES('2','ram','内存大小','','4');
INSERT INTO vte_paravars VALUES('2','pcmcia','PCMCIA槽数','','6');
INSERT INTO vte_paravars VALUES('2','videocard','显示芯片','','7');
INSERT INTO vte_paravars VALUES('2','io','I/O接口','','9');
INSERT INTO vte_paravars VALUES('2','audiocard','声卡','','10');
INSERT INTO vte_paravars VALUES('2','cdrom','光驱','','11');
INSERT INTO vte_paravars VALUES('2','floppy','软驱','','12');
INSERT INTO vte_paravars VALUES('2','mouse','触摸板/指点棒','','13');
INSERT INTO vte_paravars VALUES('2','netcard','网卡','','14');
INSERT INTO vte_paravars VALUES('2','modem','MODEM','','15');
INSERT INTO vte_paravars VALUES('2','battery','电池','','16');
INSERT INTO vte_paravars VALUES('2','size','机身尺寸','','17');
INSERT INTO vte_paravars VALUES('2','weight','机身重量','','18');
INSERT INTO vte_paravars VALUES('2','os','预装操作系统','','19');

DROP TABLE IF EXISTS vte_pm;
CREATE TABLE vte_pm (
  pmid int(10) unsigned NOT NULL auto_increment,
  msgto varchar(15) NOT NULL default '',
  msgfrom varchar(15) NOT NULL default '',
  folder enum('inbox','outbox') NOT NULL default 'inbox',
  new tinyint(1) NOT NULL default '0',
  subject varchar(75) NOT NULL default '',
  dateline int(10) unsigned NOT NULL default '0',
  message text NOT NULL,
  PRIMARY KEY  (pmid),
  KEY msgto (msgto)
) TYPE=MyISAM;


DROP TABLE IF EXISTS vte_products;
CREATE TABLE vte_products (
  productid smallint(10) unsigned NOT NULL auto_increment,
  productname varchar(200) NOT NULL default '',
  sortid smallint(6) unsigned NOT NULL default '0',
  posttime int(15) unsigned default '0',
  unit varchar(20) default '0',
  ourprice decimal(20,2) default '0.00',
  marketprice decimal(20,2) default '0.00',
  finalprice decimal(20,2) default '0.00',
  smallimg varchar(250) default 'noimg',
  largeimg varchar(250) default 'noimg',
  notes mediumtext,
  paraid smallint(6) unsigned default NULL,
  brand varchar(100) default NULL,
  viewtimes int(10) unsigned default '0',
  buytimes int(10) unsigned default '0',
  poster varchar(50) default '0',
  edittime int(10) unsigned default '0',
  editer varchar(50) default '0',
  icons varchar(250) NOT NULL default '0',
  PRIMARY KEY  (productid),
  KEY productname (productname),
  KEY sortid (sortid)
) TYPE=MyISAM;

INSERT INTO vte_products VALUES('2','SONY（索尼） DSC-F828','49','1082425492','0','7200.00','7900.00','0.00','productimgs/smallimg/OtMK_f828_1ml.jpg','productimgs/largeimg/TdWB_f828_1m.jpg','型号: DSC-F828 \r\n \r\n有效像素: 800万像素 \r\n \r\n光学变焦倍数: 7.1倍光学变焦 \r\n \r\n数码变焦倍数: 14倍数码变焦 \r\n \r\n传感器类型: CCD传感器 \r\n \r\n最大分辨率: 3264×2448 \r\n \r\n短片拍摄功能: 支持无限短片拍摄功能:两种选择模式录制MPEG VX格式 \r\n \r\n存储介质: CF卡,CFⅡ卡,MS记忆棒,MS Pro记忆棒 \r\n','1','','13','0','江南布衣','1106702382','江南布衣','');
INSERT INTO vte_products VALUES('3','IBM T412374-8RC','27','1082429608','0','21000.00','25000.00','0.00','productimgs/smallimg/h0hX_1ml.jpg','productimgs/largeimg/nffU_1m.jpg','一般信息 \r\n型号名称:2374-8RC\r\n描述: ThinkPad T41\r\n\r\n\r\n软件 \r\n提供的操作系统: 中文 Microsoft Windows XP 专业版 \r\n通讯/网络: Access IBM; IBM Access Connections; IBM Update Connector \r\n设备驱动器/功能: IBM Rapid Restore PC; IBM Rapid Restore Ultra; Norton AntiVirus 2003 OEM Version; PC-Doctor; ThinkPad Configuration Utility \r\n多媒体应用: \r\n产能应用程序: \r\n其它提供的应用程序: Adobe Acrobat Reader \r\n支持操作系统: Microsoft Windows XP Professional, Microsoft Windows 2000 \r\n','1','','15','0','江南布衣','1106702093','江南布衣','');
INSERT INTO vte_products VALUES('4','超越CY301摄像头','49','1102138783','0','75.00','120.00','0.00','productimgs/smallimg/N3LN_DSC04765l.jpg','productimgs/largeimg/w1R1_DSC04764b.jpg','　　超越CY301摄像头  48万像素，软件插值48万象素中星徽301P＋镁光\r\n\r\n芯片，真正夜视效果，四个灯，金属外壳，高品质五玻镜头,感光性强。\r\n\r\n效果好速度快。\r\n','1','','12','0','江南布衣','1106701413','江南布衣','');

DROP TABLE IF EXISTS vte_recommend;
CREATE TABLE vte_recommend (
  rid smallint(10) unsigned NOT NULL auto_increment,
  productid smallint(10) unsigned default '0',
  productname varchar(200) default '0',
  words text,
  img varchar(250) default '0',
  sid smallint(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (rid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS vte_review;
CREATE TABLE vte_review (
  rid smallint(10) unsigned NOT NULL auto_increment,
  pid smallint(10) unsigned default NULL,
  message varchar(250) default NULL,
  author varchar(50) default NULL,
  posttime int(10) unsigned default NULL,
  PRIMARY KEY  (rid)
) TYPE=MyISAM;