ALTER TABLE [c_article] ADD COLUMN keyword VARCHAR(100)
UPDATE [c_article] SET keyword=''
ALTER TABLE [c_product] ADD COLUMN keyword VARCHAR(100)
UPDATE [c_product] SET keyword=''
ALTER TABLE [c_photo] ADD COLUMN keyword VARCHAR(100)
UPDATE [c_photo] SET keyword=''
ALTER TABLE [c_special] ADD COLUMN template VARCHAR(100),keyword_chn VARCHAR(100), keyword_eng VARCHAR(100), addtime DATETIME DEFAULT NOW, orders SHORT DEFAULT 0, hits INTEGER DEFAULT 0
UPDATE [c_special] SET template='specialshow.html',keyword_chn='',keyword_eng='',addtime=now,orders=0,hits=0
ALTER TABLE [c_type] ADD COLUMN template VARCHAR(100),keyword_chn VARCHAR(100), keyword_eng VARCHAR(100), perpage SHORT DEFAULT 0, recordtemplate VARCHAR(100)
UPDATE [c_type] SET template='articlelist.html',keyword_chn='',keyword_eng='',perpage=20,recordtemplate='articleshow.html' where fenlei=1
UPDATE [c_type] SET template='productlist.html',keyword_chn='',keyword_eng='',perpage=20,recordtemplate='productshow.html' where fenlei=2
UPDATE [c_type] SET template='photolist.html',keyword_chn='',keyword_eng='',perpage=20,recordtemplate='photoshow.html' where fenlei=3
UPDATE [c_type] SET template='',keyword_chn='',keyword_eng='',perpage=0,recordtemplate='' where fenlei=4
UPDATE [c_type] SET template='guestbooklist.html',keyword_chn='',keyword_eng='',perpage=20,recordtemplate='guestbookshow.html' where fenlei=5
UPDATE [c_type] SET template='typeshow.html',keyword_chn='',keyword_eng='',perpage=0,recordtemplate='' where fenlei=6
UPDATE [c_type] SET template='joblist.html',keyword_chn='',keyword_eng='',perpage=20,recordtemplate='jobshow.html' where fenlei=7
ALTER TABLE [c_comment] ADD COLUMN path VARCHAR(100),lang BYTE DEFAULT 0, typeid INTEGER, hits INTEGER DEFAULT 0, orders SHORT DEFAULT 0, fax VARCHAR(50), mobile VARCHAR(50), memberid INTEGER DEFAULT 0, modifytime DATETIME DEFAULT NOW
UPDATE [c_comment],[c_type] SET c_comment.path=c_type.path,c_comment.lang=0,c_comment.typeid=c_type.id,c_comment.hits=0,c_comment.orders=0,c_comment.fax='',c_comment.mobile='',c_comment.memberid=0,c_comment.modifytime=now
ALTER TABLE [c_record_comment] ADD COLUMN path VARCHAR(100),typeid INTEGER, fenlei SHORT, lang BYTE DEFAULT 0, orders SHORT DEFAULT 0, memberid INTEGER, hits INTEGER DEFAULT 0
UPDATE [c_record_comment],[c_article] SET c_record_comment.path=c_article.path,c_record_comment.typeid=c_article.typeid,c_record_comment.fenlei=1,c_record_comment.lang=0,c_record_comment.orders=0,c_record_comment.memberid=0,c_record_comment.hits=0 where [c_record_comment].proc="ars" and [c_record_comment].recordid=[c_article].id
UPDATE [c_record_comment],[c_product] SET c_record_comment.path=c_product.path,c_record_comment.typeid=c_product.typeid,c_record_comment.fenlei=1,c_record_comment.lang=0,c_record_comment.orders=0,c_record_comment.memberid=0,c_record_comment.hits=0 where [c_record_comment].proc="prs" and [c_record_comment].recordid=[c_product].id
UPDATE [c_record_comment],[c_photo] SET c_record_comment.path=c_photo.path,c_record_comment.typeid=c_photo.typeid,c_record_comment.fenlei=1,c_record_comment.lang=0,c_record_comment.orders=0,c_record_comment.memberid=0,c_record_comment.hits=0 where [c_record_comment].proc="phs" and [c_record_comment].recordid=[c_photo].id
ALTER TABLE [c_advertise] ADD COLUMN ad_description MEMO
UPDATE [c_advertise] SET ad_description=''
CREATE TABLE [c_friendlink]  (id AUTOINCREMENT(1,1), name VARCHAR(100),url VARCHAR(255), logo VARCHAR(255), description MEMO , theorder SHORT)
ALTER TABLE [c_friendlink] ALTER COLUMN theorder SHORT DEFAULT 0
CREATE TABLE [c_job]  (id AUTOINCREMENT(1,1), name VARCHAR(100),place VARCHAR(50), salary VARCHAR(50), [number] VARCHAR(50), content MEMO, addtime DATETIME, author VARCHAR(50), typeid INTEGER, orders short, path VARCHAR(100), hits INTEGER, visible BYTE, lang BYTE, modifytime DATETIME, keyword VARCHAR(100), specialid INTEGER, endtime DATETIME)
ALTER TABLE [c_job] ALTER COLUMN addtime DATETIME DEFAULT NOW
ALTER TABLE [c_job] ALTER COLUMN orders SHORT DEFAULT 0
ALTER TABLE [c_job] ALTER COLUMN hits INTEGER DEFAULT 0
ALTER TABLE [c_job] ALTER COLUMN specialid INTEGER DEFAULT 0
ALTER TABLE [c_job] ALTER COLUMN visible BYTE DEFAULT 0
ALTER TABLE [c_job] ALTER COLUMN lang BYTE DEFAULT 0
CREATE TABLE [c_model] (id AUTOINCREMENT(1,1), modelname VARCHAR(100),description_chn VARCHAR(100), description_eng VARCHAR(100), template VARCHAR(100), params MEMO)
INSERT INTO [c_model](modelname,description_chn,description_eng,template,params) VALUES('recordcommentadd','添加评论对话框','Add Comment','model_recordcomment_add.html','path,typeid,lang,recordid')
INSERT INTO [c_model](modelname,description_chn,description_eng,template,params) VALUES('recordcomment','记录右侧评论','Record Comment','model_recordcomment.html','path,lang,recordid')
INSERT INTO [c_model](modelname,description_chn,description_eng,template,params) VALUES('recordcommentlist','查看评论','Comment List','model_recordcommentlist.html','path,lang,recordid')
INSERT INTO [c_model](modelname,description_chn,description_eng,template,params) VALUES('index_products','旧模板_首页商品','Products','model_indexproducts.html','path,lang')
INSERT INTO [c_model](modelname,description_chn,description_eng,template,params) VALUES('messagedialog','旧模板_发布留言对话框','Message Dialog','model_guestbookdialog.html','path,typeid,lang')
CREATE TABLE [c_smtp] ( smtphost VARCHAR(100),smtpuser VARCHAR(100), smtppassword VARCHAR(50), smtpfromname VARCHAR(100), smtpmailto MEMO)
INSERT INTO [c_smtp] VALUES('smtp.qq.com', 'abc@qq.com', '666666', '瑞志客服','abc@qq.com')
CREATE TABLE [c_tags] (id AUTOINCREMENT(1,1), tag_name VARCHAR(100),tag_tag VARCHAR(100), tag_content MEMO, tag_pre VARCHAR(50), tag_type VARCHAR(50))
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_广告_随机图片900','ad_900px','<!--{rzad type="photo" ids="38,37" random="1" number="1" width="900"}--> ${code} <!--{/rzad}-->','rzad','photo')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_首页_关于我们','index_aboutus','<!--{rzst type="type" id="207" contentlength="400" htmlclear="1"}--> <div class="thumb"><a title="" href="${url}"><img height="90" alt="" src="images/company.jpg" width="120" border="0"></a></div><h1><a href="${url}" target="_blank"><strong>@{sys.companyname}</strong></a></h1><p>${content}...</p><div id="more"><a title="" href="${url}"><strong>more details</strong></a></div> <!--{/rzst}-->','rzst','type')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_首页_公司动态','index_companynews','<!--{rzlist type="article" path="170" number="5"}--> <!--{loop}--> <!--{first}--><li class="firstone"><a href="${url}">${title_nolink}</a><sup style="color: red"> new!</sup></li><!--{/first}--><li><a href="${url}" target="_blank" rel="nofollow">${title_nolink}</a></li> <!--{/loop}--> <!--{/rzlist}-->','rzlist','article')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_首页_Flash推荐商品（未使用）','index_flashproducts','<!--{rzlist type="product" havephoto="1" number="5"}--> <!--{loop}--> imag[${i}]="${productimg_src}"; link[${i}]="${url}"; text[${i}]="${productname_nolink}"; <!--{/loop}--> <!--{/rzlist}-->','rzlist','product')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_首页/商品页_商品分类','index_productcategories','<!--{rztype depth="2" parentid="171" types="2"}--><!--{level1}--> <!--{loop1}--> <div class="index_categories_block"><ul class="cat-nav"><li><a href="${url}">${name}</a></li></ul><a href="${url}"><img src="${typeimg}"/></a><!--{level2}--><ul class=subcat-nav><!--{loop2}--><li><a href="${url}">${name}</a></li><!--{current2}--><li class="current"><a ref="${url}">${name}</a></li><!--{/current2}--><!--{/loop2}--></ul><!--{/level2}--></div> <!--{/loop1}--> <!--{/level1}--><!--{/rztype}-->','rztype','')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_右侧_公司动态5条','right_articles','<!--{rzlist type="article" path="170" number="5"}--> <!--{loop}--> <!--{first}--> <li><a href="${url}">${title_nolink}</a><sup style="color: red"> new!</sup></li><!--{/first}--><li><a href="${url}">${title_nolink}</a></li> <!--{/loop}--> <!--{/rzlist}-->','rzlist','article')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_右侧_热门商品','right_hotproducts','<!--{rzlist type="product" sort="7" number="5"}--> <!--{loop}--> <!--{first}--> <li><a href="${url}">${productname_nolink}</a><sup style="color: red"> hot!</sup></li><!--{/first}--><li><a href="${url}">${productname_nolink}</a></li> <!--{/loop}--> <!--{/rzlist}-->','rzlist','product')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_右侧_商品评论','right_comment','<!--{rzlist type="recordcomment" number="5"}--><!--{loop}--><li class="comment"><a href="${url}">${title_nolink}</a></li><!--{/loop}--><!--{/rzlist}-->','rzlist','recordcomment')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_右侧_商品分类','right_productcategories','<!--{rztype depth="2" parentid="171" notshow="1"}--><ul id="productcategories"><!--{level1}--> <!--{loop1}--> <li><span class="icon plus" onclick="showsubcategories(this);" title="Append/Close"></span><a href="${url}">${name}</a><!--{level2}--><div  style="display:none;"><!--{loop2}--><a href="${url}">  ${name}</a><!--{/loop2}--></div><!--{/level2}--></li> <!--{/loop1}--> <!--{/level1}--></ul><!--{/rztype}-->','rztype','')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_右侧_所有职位','right_alljobs','<!--{rzlist type="job" typeids="299"}--><!--{loop}--><li><a href="${url}">${name_nolink}</a></li><!--{/loop}--><!--{/rzlist}-->','rzlist','job')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_广告_招聘','ad_joinus','<!--{rzad type="photo" ids="36" number="1" width="900"}--> ${code} <!--{/rzad}-->','rzad','photo')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_二级搜索框_二级分类','productsearch_level2','<!--{rztype depth="1" parentid="171" types="2" samelevel="1"}--><!--{level2}-->group[${pi}][0]=new Option("@{lang_selectsub}",");<!--{loop2}-->group[${pi}][${i}-1]=new Option("${name}","${url_nonstatic}");<!--{/loop2}--><!--{/level2}--><!--{/rztype}-->','','')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_顶部搜索框_商品主分类','header_searchcategory','<!--{rzst type="type" id="171"}--> <input type="hidden" name="search_category" id="search_category" value="${url_nonstatic}"/> <!--{/rzst}-->','rzst','type')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_二级搜索框_主分类','productsearch_level1','<!--{rztype depth="1" parentid="171" types="2"}--> <!--{home}--> <option value="${url_nonstatic}" selected>@{lang_selectmain}</option> <!--{/home}--> <!--{level1}--> <!--{loop1}--> <option value="${url_nonstatic}">${name}</option> <!--{/loop1}--> <!--{/level1}--> <!--{/rztype}-->','rztype','')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_首页_Flash广告','index_flashadv','<!--{rzad type="photo" number="5" series="1" width="300"}--> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id=scriptmain name=scriptmain codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="300" height="155"> <param name="movie" value="images/bcastr.swf?bcastr_flie=${s_src}&bcastr_link=${s_href}"> <param name="quality" value="high"> <param name="scale" value="noscale"> <param name="LOOP" value="false"> <param name="menu" value="false"> <param name="wmode" value="transparent"> <embed src="images/bcastr.swf?bcastr_flie=${s_src}&bcastr_link=${s_href}" width="300" height="155" loop="false" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" salign="T" name="scriptmain" menu="false" wmode="transparent"></embed> </object> <!--{/rzad}-->','rzad','photo')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('classic_首页_Flash广告','index_flashadv_classic','<!--{rzad type="photo" number="5" series="1" width="550"}--> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id=scriptmain name=scriptmain codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="550" height="150"> <param name="movie" value="images/bcastr.swf?bcastr_flie=${s_src}&bcastr_link=${s_href}"> <param name="quality" value="high"> <param name="scale" value="noscale"> <param name="LOOP" value="false"> <param name="menu" value="false"> <param name="wmode" value="transparent"> <embed src="images/bcastr.swf?bcastr_flie=${s_src}&bcastr_link=${s_href}" width="550" height="150" loop="false" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" salign="T" name="scriptmain" menu="false" wmode="transparent"></embed> </object> <!--{/rzad}-->','rzad','photo')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('classic_首页_公司动态','index_news_classic','<!--{rzlist type="article" path="170" number="5"}--> <!--{loop}--> <!--{first}--> <li class="topnews"><a href="${url}" title="${title_nolink}">${title_nolink}</a></li> <!--{/first}--> <li ><a href="${url}" title="${title_nolink}">${title_nolink}</a></li> <!--{/loop}--> <!--{/rzlist}-->','rzlist','article')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('classic_首页_公告','index_board_classic','<!--{rzlist type="article" path="168" number="4"}--> <!--{loop}--> <li ><a href="${url}" title="${title_nolink}">${title_nolink}</a></li> <!--{/loop}--> <!--{/rzlist}-->','rzlist','article')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('classic_首页_滚动商品','index_recommend_classic','<!--{rzlist type="product" path="171" number="10"}--> <!--{loop}--> <td style="width:120px;height:120px;text-align:center;"><a href="${url}" title="${productname_nolink}"><img src="${productimg_src}" style="width:120px;height:120px;" alt="${productname_nolink}"/></a><br/><span></span></td> <!--{/loop}--> <!--{/rzlist}-->','rzlist','product')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('classic_首页_下拉商品分类','index_productcategories_classic','<!--{rztype depth="1" parentid="171"}--> <!--{level1}--><!--{loop1}--> <li><a onclick=ajax_getProducts("${path}",@{sys.lang});><span>${name}</span></a></li> <!--{/loop1}--><!--{/level1}--> <!--{/rztype}-->','rztype','')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('classic_留言本_分类','index_guestbookcats_classic','<!--{rztype depth="1" parentid="172"}--> <div id="childtypelist"> <ul> <!--{level1}--> <!--{loop1}--> <li><a href="${url}"><span>${name}</span></a></li> <!--{/loop1}--> <!--{/level1}--> </ul> </div> <!--{/rztype}-->','rztype','')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('default_留言本_下拉分类','guestbook_catsoption','<!--{rztype depth="1" parentid="172"}--> <!--{level1}--> <!--{loop1}--> <option value="${id}_${path}">${name}</option> <!--{/loop1}--> <!--{/level1}--> <!--{/rztype}-->','rztype','')
INSERT INTO [c_tags](tag_name,tag_tag,tag_content,tag_pre,tag_type) VALUES('classic_快速导航_商品分类','productcats_classic','<!--{rztype types="2" parentid="171" depth="2"}--> <!--{level1}--> <!--{loop1}--> <li><a href="${url}"><span>${name}</span></a> <!--{level2}--> <ul> <!--{loop2}--> <li><a href="${url}"><span>${name}</span></a></li> <!--{/loop2}--> </ul> <!--{/level2}--> </li> <!--{/loop1}--> <!--{/level1}--> <!--{/rztype}-->','rztype','')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_productmodel','Product Model|商品型号')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_productamount','Product Amount|商品数量')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_gbfax','Fax|传真')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_joblist','Jobs List|招聘信息列表')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_jobname','Name|职位名称')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_addjob','Add Job|添加职位信息')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_jobdescription','Description|职位要求')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_jobplace','Work Place|工作地点')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_jobsalary','Salary|每月薪酬')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_jobamount','Amount|招聘人数')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_keywordtips','Tips:keywords&nbsp;are&nbsp;separated&nbsp;by&nbsp;blank&nbsp;space|提示：关键字之间使用空格分隔')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_keyword','Keyword|关键字')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_allspecial','All Specials|所有专题')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_map','Site&nbsp;Map|网站地图')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_addtofavor','Add to Favorites|收藏本站')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_companynews','Latest News|公司动态')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_hotproducts','Hot Products|热门商品')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_productsearch','Product Search|商品检索')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_selectmain','Main Categories|请选择主分类')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_selectsub','Sub Categories|请选择子分类')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_enterkeyword','Enter Keyword|请输入关键字')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_deadline','Deadline|截止时间')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_nosubcategory','No&nbsp;Sub&nbsp;Categories|无子分类')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_friendlink','Friend Links|友情链接')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_subcategories','Sub Categories|本栏目分类')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_addmessage','Add Message|发表留言')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_send','Send|发送')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_transact','Transacted|已回复')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_nottransact','Not&nbsp;transacted|未回复')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_postscript','Postscript|附言')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_mobile','Mobile|手机')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_company','Company|公司')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_yourname','Your Name|联系人')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_productcategory','Product&nbsp;Categories|商品分类')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_hotjobs','Hot&nbsp;Jobs|热门职位')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_hotnews','Hot&nbsp;News|热门资讯')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_hotphotos','Hot&nbsp;Photos|热门图片')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_sheetno','Sheet&nbsp;No.|询价单号')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_tjtime','Add&nbsp;Time|提交时间')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_replystate','Reply&nbsp;State|回复状态')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_replytime','ReplyTime|回复时间')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_specials','Specials|专题信息')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_selectspecial','Please&nbsp;Select|请选择专题')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_viewallcomments','View&nbsp;all&nbsp;comments|查看所有评论')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_comment','Comments about:|评论')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_latestcomment','Latest&nbsp;Coments|最新评论')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_categories','Categories|相关分类')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_reply','Reply|回复')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_saveguestbook','Thanks&nbsp;for&nbsp;your&nbsp;message|感谢您的留言')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_alljobs','All Jobs|全部职位')
INSERT INTO c_words (w_name,w_value) VALUES ('lang_fronturl','Visting&nbsp;URL|前台访问地址')
UPDATE c_settings SET var_value='&#39;|;|exec |insert |select |delete |update |count |*|%|chr |mid |master |truncate |char |declare |drop | or | and ' WHERE var_name='rz_inj_keywords'