cn_all_1.2.bak.sql

这个版本只是修正了一些BUG

#
# Dumping data for table 'vte_sorts'
#

INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("57", "三星", "54", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("1", "数码科技", "0", "", "group", "1");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("34", "休闲娱乐", "0", "", "group", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("3", "笔记本电脑", "1", "各种品牌的笔记本电脑。在这里您一定可以找到适合您的笔记本电脑。", "sort", "1");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("27", "IBM", "3", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("56", "日常用品", "0", "", "group", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("48", "数码商城", "1", "", "sort", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("28", "HP", "3", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("59", "摩托罗拉", "54", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("58", "索爱", "54", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("31", "VIAO", "3", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("49", "数码相机", "48", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("54", "手机商城", "1", "", "sort", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("55", "健身器材", "0", "", "group", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("38", "数字卡类", "0", "", "group", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("63", "电脑软件", "48", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("40", "图书音像", "0", "", "group", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("41", "珠宝服饰", "0", "", "group", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("42", "化妆品", "0", "", "group", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("43", "鲜花礼品", "0", "", "group", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("44", "DELL", "3", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("45", "东芝", "3", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("46", "联想", "3", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("47", "COMPAQ", "3", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("50", "摄像机", "48", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("51", "MD", "48", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("52", "MP3", "48", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("60", "西门子", "54", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("61", "诺基亚", "54", "", "sub", "0");
INSERT INTO vte_sorts (sortid, sortname, supsortid, remarks, class, largesortid) VALUES("62", "阿尔卡特", "54", "", "sub", "0");


#
# Table structure for table 'vte_styles'
#

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;



#
# Dumping data for table 'vte_styles'
#

INSERT INTO vte_styles (styleid, stylename, tpldir, imgdir, copyright) VALUES("1", "default", "./templates/default", "./images/default", "designed by tracemouse");


#
# Table structure for table 'vte_stylevars'
#

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;



#
# Dumping data for table 'vte_stylevars'
#

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


#
# Table structure for table 'vte_updatesql'
#

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;



#
# Dumping data for table 'vte_updatesql'
#



#
# Table structure for table 'vte_votekeys'
#

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;



#
# Dumping data for table 'vte_votekeys'
#

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


#
# Table structure for table 'vte_votes'
#

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;



#
# Dumping data for table 'vte_votes'
#

INSERT INTO vte_votes (vid, question, multi, maxvotes, totalvotes, dateline, poster) VALUES("1", "您认为本商城哪些方面有待提高？", "1", "0", "1", "65535", "");


#
# Table structure for table 'vte_weblinks'
#

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;



#
# Dumping data for table 'vte_weblinks'
#

INSERT INTO vte_weblinks (id, name, note, url, logo, type) VALUES("1", "易卖论坛", "易卖论坛", "http://bbs.yaxun.net", "./images/logo/vitcies.gif", "link");
INSERT INTO vte_weblinks (id, name, note, url, logo, type) VALUES("2", "易卖商城", "易卖商城", "http://www.free-buy.net", "./images/logo/vitciel.gif", "ally");

#
#Table structure for table 'vte_city'
#

DROP TABLE IF EXISTS vte_city;
CREATE TABLE vte_city (
  id smallint(5) unsigned NOT NULL auto_increment,
  name varchar(20) default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

#
# Dumping data for table 'vte_city'
#

INSERT INTO vte_city (id, name) VALUES("1", "南宁");
INSERT INTO vte_city (id, name) VALUES("2", "柳州");
INSERT INTO vte_city (id, name) VALUES("3", "桂林");
INSERT INTO vte_city (id, name) VALUES("4", "梧州");
INSERT INTO vte_city (id, name) VALUES("5", "河池");
INSERT INTO vte_city (id, name) VALUES("6", "贵港");
INSERT INTO vte_city (id, name) VALUES("7", "钦州");
INSERT INTO vte_city (id, name) VALUES("8", "玉林");
INSERT INTO vte_city (id, name) VALUES("9", "上海");
INSERT INTO vte_city (id, name) VALUES("10", "北海");