📄 cn_all_1.2.bak.sql
字号:
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;
#
# Dumping data for table 'vte_paravals'
#
#
# Table structure for table 'vte_paravars'
#
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;
#
# Dumping data for table 'vte_paravars'
#
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "lcd", "显示屏", "", "2");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "cpu", "CPU (主频)", "", "1");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "mainboard", "主板", "", "8");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "ram", "内存大小", "", "4");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "pcmcia", "PCMCIA槽数", "", "6");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "videocard", "显示芯片", "", "7");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "io", "I/O接口", "", "9");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "audiocard", "声卡", "", "10");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "cdrom", "光驱", "", "11");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "floppy", "软驱", "", "12");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "mouse", "触摸板/指点棒", "", "13");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "netcard", "网卡", "", "14");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "modem", "MODEM", "", "15");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "battery", "电池", "", "16");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "size", "机身尺寸", "", "17");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) VALUES("2", "weight", "机身重量", "", "18");
INSERT INTO vte_paravars (paraid, varname, varhint, remarks, sid) 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',
cityid smallint(5) NOT NULL default '1',
PRIMARY KEY (productid),
KEY productname (productname),
KEY sortid (sortid)
) TYPE=MyISAM;
#
# Dumping data for table 'vte_products'
#
INSERT INTO vte_products (productid, productname, sortid, posttime, unit, ourprice, marketprice, finalprice, smallimg, largeimg, notes, paraid, brand, viewtimes, buytimes, poster, edittime, editer, icons) VALUES("1", "VITCIE 简体中文标准版", "63", "1076050518", "套", "100.00", "600.00", "0.00", "productimgs/smallimg/CD.png", "productimgs/largeimg/vitcie.gif", "VITCIE 的英文全称为:Vitci Eshop,中文名称为:易卖商城,是一款基于php+Mysql的网络商城.\r\nVITCIE 采用目前最流行的 PHP 语言编写,缺省内建 MYSQL 支持,无论在执行效率还是在系统的稳定性上都具有先天的优越性,另外还吸收了目前一些比较流行网络编程 技术,冽如编译摸版技术/投票系统/广告系统等,这些技术的使用使得VITCIE不但具有网络商城的一切功能,也具有一个综合网站的各种特性.\r\n选择 VITCIE ,您将用最小的成本/最快的速度获得一个强大/稳定/高效的电子商务解决方案! \r\n\r\nVITCIE具有以下特点：\r\n基于 Php+Mysql 构建,推荐选用免费或低廉的FreeBSD/Linux 服 \r\n 务器平台,具有稳定/高效/低廉/易用的特点. \r\n \r\n 采用目前业界最流行的模版编译系统,所有的页面都可以实现 \r\n 在线/离线修改,只需简单掌握HTML的知识,就可以轻松创建属 \r\n 于自己的个性化的专业用户界面. \r\n \r\n 内建多语言包替换模块,只需安装或修改语言包,就可以实现页 \r\n 页面上所有元素的多语言版本. \r\n \r\n 独创的商品参数模版系统,可以实现预先在后台维护好不同类 \r\n 别商品的参数表及参数表模版,而当新增商品时则可根据不同 \r\n 商品特性选择预先定义好的参数表模版,商品的详细参数维护 \r\n 将变得极之容易. \r\n \r\n 强大的后台管理支持和数据备份功能,使得系统的维护工作变 \r\n 得非常容易. \r\n \r\n 采用 DES5 算法进行加密,提供高度的安全性保证. \r\n ", "1", "", "92", "0", "vitci", "1082425583", "tracemouse", "");
INSERT INTO vte_products (productid, productname, sortid, posttime, unit, ourprice, marketprice, finalprice, smallimg, largeimg, notes, paraid, brand, viewtimes, buytimes, poster, edittime, editer, icons) VALUES("2", "SONY（索尼） DSC-V1", "49", "1082425492", "0", "4500.00", "4800.00", "0.00", "productimgs/smallimg/sony-dc-v1.jpg", "", "SONY（索尼） DSC-V1是索尼公司全面使用MemoryStick、MemoryStick Pro存储技术的500万象素的产品，相对索尼自己的系列产品而言，体积减小了20-25％，而重量方面也减轻了30％。这将更加便于携带及使用。测距型相机很好的结合了单反相机与EVF电子取景相机的优势，同时索尼还将拍摄像素从400万提升到了500万像素，从原本3倍的光学变焦镜头变成了4倍卡尔.蔡斯光学变焦镜头。其他重大的改进还包括增加了可选择的连对自动对焦模式，拥有程序曝光、光圈优先、速度优先以及手动曝光等多种选择，另外用户还可以随意调整图像的饱和度、反差以及闪光和白平衡等多项内容。DSC-V1是目前全球拥有全息自动对焦（Hologram AF）的最小的数码相机，该功能是运用了索尼专利全息激光辅助自动对焦技术。同时DSC-V1也是全球首部外置光圈调节，并能提供夜间拍摄及夜间取景的数码相机（该项功能将可使用户在夜间进行红外摄影；或者使用红外影像功能辅助对焦，然后进行闪光拍摄普通照片）。与S85相比，DSC-V1增加了多种程序模式（用户可自行调整光圈及速度，以获得所需的景深范围及拍摄速度）。新型的锂离子FC型电池取代了M型电池，随机配备32MB记忆棒，另外热靴插座将可提供外接闪光灯拍摄。", "1", NULL, "7", "0", "tracemouse", "1082425884", "tracemouse", "");
INSERT INTO vte_products (productid, productname, sortid, posttime, unit, ourprice, marketprice, finalprice, smallimg, largeimg, notes, paraid, brand, viewtimes, buytimes, poster, edittime, editer, icons) VALUES("3", "IBM T412374-8RC", "27", "1082429608", "0", "25588.00", "19800.00", "0.00", "productimgs/smallimg/10420_s.jpg", "productimgs/largeimg/10420_l.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", NULL, "3", "0", "tracemouse", "1082429710", "tracemouse", "");
#
# Table structure for table 'vte_recommend'
#
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;
#
# Dumping data for table 'vte_recommend'
#
INSERT INTO vte_recommend (rid, productid, productname, words, img, sid) VALUES("12", "2", "SONY（索尼） DSC-V1", "", "productimgs/i-2.gif", "1");
INSERT INTO vte_recommend (rid, productid, productname, words, img, sid) VALUES("13", "3", "IBM T412374-8RC", "", "productimgs/i-1.gif", "1");
INSERT INTO vte_recommend (rid, productid, productname, words, img, sid) VALUES("11", "1", "VITCIE 简体中文标准版", "", "productimgs/i-3.gif", "1");
#
# Table structure for table 'vte_review'
#
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;
#
# Dumping data for table 'vte_review'
#
#
# Table structure for table 'vte_searchindex'
#
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;
#
# Dumping data for table 'vte_searchindex'
#
INSERT INTO vte_searchindex (id, srhcondition, result, dateline) VALUES("1", "(productname LIKE \'%v%\') AND ourprice >= 0.00 AND ourprice <= 99999.99 ORDER BY productname", "47", "1082197409");
#
# Table structure for table 'vte_settings'
#
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',
bbstablepre varchar(20) default NULL,
issendpm smallint(1) unsigned NOT NULL default '0',
pmmessage text,
PRIMARY KEY (sitename),
KEY sitename_2 (sitename)
) TYPE=MyISAM;
#
# Dumping data for table 'vte_settings'
#
INSERT INTO vte_settings (sitename, siteurl, styleid, langid, version, agreement, dateformat, timeformat, productperpage, hotline, bbsurl, shopname, isclosed, closedreason, releasedate, copyright, isviewpt, ccyunit, newgid, webmaster, bbsid, isiclbbs, bbstablepre, issendpm, pmmessage) VALUES("易卖商城", "http://www.free-buy.net", "1", "1", "1.2 Alpha", "<b>易卖商城注册协议：</b>\r\n[last edited by tracemouse in 2004.03.18.]\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.yaxun.net\" target=_blanket class=sort>易卖论坛</a>] 进行反馈！谢谢支持！\r\n\r\n", "Y-m-d", "h:i:A", "15", "销售电话：xxx-xxxxxxxx 销售QQ：xxxxxxxx (24小时在线)", "http://bbs.yaxun.net", "易卖商城", "0", "商城进行内部装修\r\n，暂时关闭，请稍后在访问，或者直接联系我们的销售人员，不便之处，敬请原谅！\r\n\r\n\r\n", "2004-03-22", "易卖商城版权所有,请遵重作者版权", "1", "元", "2", "", "1", "0", "cdb_", "1", "亲爱的会员：\r\n您好！\r\n欢迎您来易卖商城选购商品，我们将为您提供最好的服务和最满意的价格！");
#
# Table structure for table 'vte_sorts'
#
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',
PRIMARY KEY (sortid),
KEY sortname (sortname)
) TYPE=MyISAM;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -