cn_all_1.2.bak.sql

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

# Table structure for table 'vte_icons'
#

DROP TABLE IF EXISTS vte_icons;
CREATE TABLE vte_icons (
  id smallint(3) unsigned NOT NULL auto_increment,
  url varchar(250) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;



#
# Dumping data for table 'vte_icons'
#

INSERT INTO vte_icons (id, url) VALUES("1", "images/producticons/icon1.gif");
INSERT INTO vte_icons (id, url) VALUES("2", "images/producticons/icon2.gif");
INSERT INTO vte_icons (id, url) VALUES("3", "images/producticons/icon3.gif");
INSERT INTO vte_icons (id, url) VALUES("4", "images/producticons/icon4.gif");
INSERT INTO vte_icons (id, url) VALUES("5", "images/producticons/icon5.gif");
INSERT INTO vte_icons (id, url) VALUES("6", "images/producticons/icon6.gif");
INSERT INTO vte_icons (id, url) VALUES("7", "images/producticons/icon7.gif");
INSERT INTO vte_icons (id, url) VALUES("8", "images/producticons/icon8.gif");
INSERT INTO vte_icons (id, url) VALUES("9", "images/producticons/icon9.gif");
INSERT INTO vte_icons (id, url) VALUES("10", "images/producticons/icon10.gif");
INSERT INTO vte_icons (id, url) VALUES("11", "images/producticons/icon11.gif");
INSERT INTO vte_icons (id, url) VALUES("12", "images/producticons/icon12.gif");
INSERT INTO vte_icons (id, url) VALUES("13", "images/producticons/icon13.gif");
INSERT INTO vte_icons (id, url) VALUES("14", "images/producticons/icon14.gif");


#
# Table structure for table 'vte_language'
#

DROP TABLE IF EXISTS vte_language;
CREATE TABLE vte_language (
  langid smallint(6) NOT NULL auto_increment,
  langname varchar(50) default '0',
  langdir varchar(250) default '0',
  copyright varchar(250) default '0',
  charset varchar(250) default '0',
  PRIMARY KEY  (langid,langid),
  KEY langid_2 (langid)
) TYPE=MyISAM;



#
# Dumping data for table 'vte_language'
#

INSERT INTO vte_language (langid, langname, langdir, copyright, charset) VALUES("1", "simple chinese", "./language/gb2312", "coded by tracemouse", "gb2312");


#
# Table structure for table 'vte_members'
#

DROP TABLE IF EXISTS vte_members;
CREATE TABLE vte_members (
  userid int(20) unsigned NOT NULL auto_increment,
  username varchar(50) NOT NULL default '',
  password varchar(40) NOT NULL default '',
  groupid smallint(6) unsigned NOT NULL default '0',
  regdate int(10) unsigned default NULL,
  regip varchar(15) default NULL,
  lastvisit int(10) unsigned default NULL,
  email varchar(100) NOT NULL default '',
  oicq varchar(20) default NULL,
  icq varchar(20) default NULL,
  msn varchar(100) default NULL,
  birthday varchar(10) default NULL,
  addr varchar(200) default NULL,
  postalcode varchar(20) default NULL,
  tel varchar(20) default NULL,
  mobile varchar(20) NOT NULL default '',
  newpm smallint(10) unsigned NOT NULL default '0',
  isadmin smallint(1) unsigned NOT NULL default '0',
  isonline smallint(1) NOT NULL default '0',
  isvip smallint(1) unsigned NOT NULL default '0',
  status enum('Member','Admin','Manager','Delivery','Sales','Banned','BuyBanned','Inactive','Swapper') NOT NULL default 'Member',
  gender smallint(1) default '0',
  realname varchar(50) default '0',
  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;


#
# Table structure for table 'vte_menuitems'
#

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;



#
# Dumping data for table 'vte_menuitems'
#

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

#
# Table structure for table 'vte_orders'
#

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;



#
# Dumping data for table 'vte_orders'
#



#
# Table structure for table 'vte_orderstatus'
#

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;



#
# Dumping data for table 'vte_orderstatus'
#

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


#
# Table structure for table 'vte_parameters'
#

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;



#
# Dumping data for table 'vte_parameters'
#

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


#
# Table structure for table 'vte_paravals'
#

DROP TABLE IF EXISTS vte_paravals;
CREATE TABLE vte_paravals (
  productid smallint(10) unsigned NOT NULL default '0',