cn_all_1.3.sql

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

DROP TABLE IF EXISTS vte_searchindex;
CREATE TABLE vte_searchindex (
  id int(10) unsigned NOT NULL auto_increment,
  srhcondition mediumtext NOT NULL,
  result int(10) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

INSERT INTO vte_searchindex VALUES('1','(productname LIKE \'%v%\') AND ourprice >= 0.00 AND ourprice <= 99999.99 ORDER BY productname','47','1082197409');

DROP TABLE IF EXISTS vte_settings;
CREATE TABLE vte_settings (
  sitename varchar(100) NOT NULL default '0',
  siteurl varchar(200) NOT NULL default '0',
  styleid tinyint(3) unsigned NOT NULL default '0',
  langid smallint(6) NOT NULL default '0',
  version varchar(10) default '0',
  agreement text,
  dateformat varchar(15) NOT NULL default '',
  timeformat varchar(15) NOT NULL default '',
  productperpage smallint(5) NOT NULL default '10',
  hotline varchar(250) default NULL,
  bbsurl varchar(250) default NULL,
  shopname varchar(100) default NULL,
  isclosed smallint(1) unsigned NOT NULL default '0',
  closedreason varchar(250) NOT NULL default '0',
  releasedate varchar(10) default NULL,
  copyright varchar(250) default NULL,
  isviewpt smallint(1) unsigned default '0',
  ccyunit varchar(20) default NULL,
  newgid smallint(10) unsigned default '2',
  webmaster varchar(100) default NULL,
  bbsid smallint(3) default NULL,
  isiclbbs smallint(1) unsigned NOT NULL default '0',
  issendpm smallint(1) unsigned NOT NULL default '0',
  pmmessage text,
  credits smallint(2) NOT NULL default '1',
  PRIMARY KEY  (sitename),
  KEY sitename_2 (sitename)
) TYPE=MyISAM;

INSERT INTO vte_settings VALUES('随意网','http://www.free-buy.net','1','1','1.3 COM','<b>随意网注册协议：</b>\r\n[last edited by 江南布衣 in 2005.02.01.]\r\n\r\n一、只有注册会员才可以在本商城进行购物、订单查询、参加各项优惠活动等。请记住您的会员号。它是您在商城的唯一识别，您的任何投诉、问题、购买记录，均采用这个会员号处理。而且，您再次光临本站购物会有很大的方便，许多信息不必重新输入。\r\n\r\n二、会员名可以是您便于记忆的任何代号比如网名。不过，在注册用户的时候，我们建议您务必输入您的真实信息，我们会为您绝对保密。这样有利于准确发货、提供各项服务、必要时迅速与您联系。 \r\n\r\n三、当您忘记密码时，可以通过点击首页\"取回密码\"的链接 ，输入您注册的用户名和邮箱，系统会为您重建一个随机的密码，并自动将新密码发送到您的注册邮箱，下次登陆本商城时，您可以在我的商城中可以重新设置一个您能记住的密码。\r\n\r\n四、您随时可以登录到“我的商城”，进入“我的资料编辑”查看并修改您的注册信息。  \r\n\r\n五、如果在使用中遇到程序问题或BUG，请到 [<a href=\"http://bbs.free-buy.net\" target=_blanket class=sort>随意论坛</a>] 进行反馈！谢谢支持！\r\n\r\n','Y-m-d','h:i:A','15','销售电话：xxx-xxxxxxxx 销售QQ：xxxxxxxx (24小时在线)','http://192.168.1.198/bbs','随意网','0','商城进行内部装修\r\n，暂时关闭，请稍后在访问，或者直接联系我们的销售人员，不便之处，敬请原谅！\r\n\r\n\r\n','2005-02-01','随意网版权所有,请遵重作者版权','1','元','2','','1','0','1','亲爱的会员：\r\n您好！\r\n欢迎您来随意网选购商品，我们将为您提供最好的服务和最满意的价格！','1');

DROP TABLE IF EXISTS vte_sorts;
CREATE TABLE vte_sorts (
  sortid smallint(6) unsigned NOT NULL auto_increment,
  sortname varchar(200) NOT NULL default '',
  supsortid smallint(6) NOT NULL default '0',
  remarks text,
  class enum('group','sort','sub') NOT NULL default 'sort',
  largesortid smallint(6) unsigned default '0',
  displayorder smallint(3) NOT NULL default '0',
  PRIMARY KEY  (sortid),
  KEY sortname (sortname)
) TYPE=MyISAM;

INSERT INTO vte_sorts VALUES('57','三星','54','','sub','0','0');
INSERT INTO vte_sorts VALUES('1','数码科技','0','','group','1','0');
INSERT INTO vte_sorts VALUES('3','笔记本电脑','1','各种品牌的笔记本电脑。在这里您一定可以找到适合您的笔记本电脑。','sort','1','2');
INSERT INTO vte_sorts VALUES('27','IBM','3','','sub','0','0');
INSERT INTO vte_sorts VALUES('48','数码商城','1','','sort','0','1');
INSERT INTO vte_sorts VALUES('28','HP','3','','sub','0','0');
INSERT INTO vte_sorts VALUES('59','摩托罗拉','54','','sub','0','0');
INSERT INTO vte_sorts VALUES('58','索爱','54','','sub','0','0');
INSERT INTO vte_sorts VALUES('31','VIAO','3','','sub','0','0');
INSERT INTO vte_sorts VALUES('49','数码相机','48','','sub','0','0');
INSERT INTO vte_sorts VALUES('54','手机商城','1','','sort','0','0');
INSERT INTO vte_sorts VALUES('63','电脑软件','48','','sub','0','0');
INSERT INTO vte_sorts VALUES('44','DELL','3','','sub','0','0');
INSERT INTO vte_sorts VALUES('45','东芝','3','','sub','0','0');
INSERT INTO vte_sorts VALUES('46','联想','3','','sub','0','0');
INSERT INTO vte_sorts VALUES('47','COMPAQ','3','','sub','0','0');
INSERT INTO vte_sorts VALUES('50','摄像机','48','','sub','0','0');
INSERT INTO vte_sorts VALUES('51','MD','48','','sub','0','0');
INSERT INTO vte_sorts VALUES('52','MP3','48','','sub','0','0');
INSERT INTO vte_sorts VALUES('60','西门子','54','','sub','0','0');
INSERT INTO vte_sorts VALUES('61','诺基亚','54','','sub','0','0');
INSERT INTO vte_sorts VALUES('62','阿尔卡特','54','','sub','0','0');

DROP TABLE IF EXISTS vte_styles;
CREATE TABLE vte_styles (
  styleid smallint(6) unsigned NOT NULL auto_increment,
  stylename varchar(20) NOT NULL default '0',
  tpldir varchar(50) NOT NULL default '0',
  imgdir varchar(50) NOT NULL default '0',
  copyright varchar(50) NOT NULL default '0',
  PRIMARY KEY  (styleid,styleid),
  UNIQUE KEY styleid (styleid),
  KEY styleid_2 (styleid)
) TYPE=MyISAM;

INSERT INTO vte_styles VALUES('1','default','./templates/default','./images/default','designed by 江南布衣');

DROP TABLE IF EXISTS vte_stylevars;
CREATE TABLE vte_stylevars (
  stylevarid smallint(6) unsigned NOT NULL auto_increment,
  styleid smallint(6) unsigned NOT NULL default '0',
  variable varchar(250) NOT NULL default '',
  substitute varchar(250) NOT NULL default '',
  PRIMARY KEY  (stylevarid,styleid)
) TYPE=MyISAM;

INSERT INTO vte_stylevars VALUES('1','1','bgcolor','#818189');
INSERT INTO vte_stylevars VALUES('2','1','altbg1','#f6f6f6');
INSERT INTO vte_stylevars VALUES('3','1','altbg2','#F7F7F7');
INSERT INTO vte_stylevars VALUES('4','1','link','#3A4F6C');
INSERT INTO vte_stylevars VALUES('5','1','bordercolor','#ffffff');
INSERT INTO vte_stylevars VALUES('6','1','headercolor','header_bg.gif');
INSERT INTO vte_stylevars VALUES('7','1','headertext','#FFFFFF');
INSERT INTO vte_stylevars VALUES('25','1','fontcolor','#333366');
INSERT INTO vte_stylevars VALUES('9','1','tabletext','#333366');
INSERT INTO vte_stylevars VALUES('10','1','text','sdf');
INSERT INTO vte_stylevars VALUES('11','1','borderwidth','1');
INSERT INTO vte_stylevars VALUES('12','1','tablewidth','775');
INSERT INTO vte_stylevars VALUES('13','1','tablespace','4');
INSERT INTO vte_stylevars VALUES('14','1','font','Verdana,Arial,Helvetica,sans-serif;');
INSERT INTO vte_stylevars VALUES('15','1','fontsize','13px');
INSERT INTO vte_stylevars VALUES('17','1','logo','logo.gif');
INSERT INTO vte_stylevars VALUES('21','1','smfontsize','11px');
INSERT INTO vte_stylevars VALUES('22','1','smfont','Verdana,Arial,Helvetica,sans-serif;');
INSERT INTO vte_stylevars VALUES('23','1','separater',' 〉');
INSERT INTO vte_stylevars VALUES('24','1','navlink','#ffffff');
INSERT INTO vte_stylevars VALUES('27','1','framecolor','#000000');
INSERT INTO vte_stylevars VALUES('28','1','cattext','#3A4F6C');
INSERT INTO vte_stylevars VALUES('29','1','catbgcolor','#EAE6E6');
INSERT INTO vte_stylevars VALUES('30','1','altbg3','#f6f6f6');
INSERT INTO vte_stylevars VALUES('31','1','outbordercolor','#0A75E7');
INSERT INTO vte_stylevars VALUES('32','1','hltext1','#FF6600');
INSERT INTO vte_stylevars VALUES('33','1','hltext2','#0A75E7');
INSERT INTO vte_stylevars VALUES('34','1','hltext3','#000000');

DROP TABLE IF EXISTS vte_updatesql;
CREATE TABLE vte_updatesql (
  id smallint(10) unsigned NOT NULL auto_increment,
  sqltext text,
  username varchar(50) default NULL,
  exectime int(10) unsigned default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

INSERT INTO vte_updatesql VALUES('1','alter table vte_sorts add displayorder smallint(3) NOT NULL default \'0\';','江南布衣','1102125952');

DROP TABLE IF EXISTS vte_votekeys;
CREATE TABLE vte_votekeys (
  vid smallint(10) unsigned default '0',
  sid smallint(10) unsigned NOT NULL default '0',
  options varchar(100) NOT NULL default '0',
  votenum smallint(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;

INSERT INTO vte_votekeys VALUES('1','1','系统的性能','0');
INSERT INTO vte_votekeys VALUES('1','2','系统的界面','0');
INSERT INTO vte_votekeys VALUES('1','3','系统的安全性','0');
INSERT INTO vte_votekeys VALUES('1','4','系统的稳定性','0');
INSERT INTO vte_votekeys VALUES('1','5','使用的便捷性','0');
INSERT INTO vte_votekeys VALUES('1','6','订单处理功能','1');

DROP TABLE IF EXISTS vte_votes;
CREATE TABLE vte_votes (
  vid smallint(10) unsigned NOT NULL auto_increment,
  question varchar(250) NOT NULL default '0',
  multi smallint(1) unsigned NOT NULL default '0',
  maxvotes smallint(10) unsigned NOT NULL default '0',
  totalvotes smallint(10) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  poster varchar(50) NOT NULL default '0',
  PRIMARY KEY  (vid)
) TYPE=MyISAM;

INSERT INTO vte_votes VALUES('1','您认为本商城哪些方面有待提高？','1','0','1','65535','');

DROP TABLE IF EXISTS vte_weblinks;
CREATE TABLE vte_weblinks (
  id smallint(6) unsigned NOT NULL auto_increment,
  name varchar(100) default '0',
  note varchar(200) default '0',
  url varchar(100) default '0',
  logo varchar(100) default '0',
  type enum('link','ally') default 'link',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

INSERT INTO vte_weblinks VALUES('1','随意论坛','随意论坛','http://bbs.free-buy.net','./images/logo/vitcies.gif','link');
INSERT INTO vte_weblinks VALUES('2','随意网','随意网','http://www.free-buy.net','./images/logo/vitciel.gif','ally');

DROP TABLE IF EXISTS vte_bbs;
CREATE TABLE vte_bbs (
  bbsid smallint(3) unsigned NOT NULL auto_increment,
  bbstype varchar(50) NOT NULL default '',
  iclfile varchar(50) NOT NULL default '',
  copyright varchar(100) default NULL,
  bbstablepre varchar(6) default NULL,
  bbstable varchar(8) default NULL,
  PRIMARY KEY  (bbsid),
  UNIQUE KEY bbsidx1 (bbstype)
) TYPE=MyISAM;

INSERT INTO vte_bbs VALUES('1','discuz2','discuz2.php','coded by Nnaqing','cdb_','discuz2');
INSERT INTO vte_bbs VALUES('2','phpwind','phpwind.php','coded by Nnaqing','pw_','phpwind');
INSERT INTO vte_bbs VALUES('3','discuz2.5','discuz25.php','coded by Nnaqing','cdb_','discuz2');