<!--#include virtual="/inc/conn.asp"-->
<%
Server.ScriptTimeOut = 999999 
on error resume next


Conn.execute("ALTER TABLE ayname ADD yquserid bigint default 0") 
conn.execute "update ayname set yquserid=0 where yquserid is null"

Conn.execute("ALTER TABLE ayerr ADD errdd char(20)") 
Conn.execute("ALTER TABLE ayerr ADD errqudao char(20)") 
Conn.execute("ALTER TABLE ayerr ADD errfs char(20)") 
Conn.execute("ALTER TABLE ayerr ADD errpcwap char(5)") 

Conn.execute("ALTER TABLE ayerr ADD errisdu int default 0") 
conn.execute "update ayerr set errisdu=0 where errisdu is null"


'表aysitesys 网站设置
SQL="Create Table aysitesys(aysiteid bigint PRIMARY key IDENTITY,webname char(30),zweburl char(30),weburl char(30),webyulei char(5),wapurl char(30),iswap char(5),pichost char(30),ossurl char(30),apijk char(30),isfan char(5),nofan ntext,faxinfang char(10),ptjiami char(20),rejiami char(20),gsname char(40),jname char(20),gsadd char(50),gsaddpic ntext,webkeywords ntext,webdescription ntext,weblogo ntext,xinlangweibo ntext,tengxunweibo ntext,gongzhonghaoname char(20),gongzhonghaopic ntext,icpbei char(30),icpzheng char(30),wanganbei char(30),buytishi char(5),allfuwuqqmai ntext,fuwuqq char(15),allfuwuqq ntext,shenheqq ntext,qq5 char(15),kfwxhao char(20),kfwxerweima ntext,gsmail char(30),fuwutel char(15),allfuwutel ntext,showtel char(5),appid char(20),secret char(40),iswxkfon char(5),wxkfappid char(20),wxkfsecret char(40),wxkfre ntext,isqqkfon char(5),qqkfappid char(20),qqkfsecret char(40),qqkfre ntext,maichukazhuanyi bigint,mailformname char(40),mailform char(40),mailservername char(40),mailserverpass char(40),mailserver char(40),aysmsuser char(20),aysmspass char(40),zzmail char(40),zztel char(20),bannerpic1 ntext,bannerlink1 ntext,bannerpic2 ntext,bannerlink2 ntext,bannerpic3 ntext,bannerlink3 ntext,bannerpic4 ntext,bannerlink4 ntext,bannerpic5 ntext,bannerlink5 ntext)"
Conn.execute(SQL) 
response.Write("数据库-表aysitesys-添加成功")&"<br>"

Conn.execute("ALTER TABLE aysitesys ADD webdlogo ntext") 
Conn.execute("ALTER TABLE aysitesys ADD adminaddress char(15)") 
Conn.execute("ALTER TABLE aysitesys ADD vipj bigint") 
Conn.execute("ALTER TABLE aysitesys ADD vneiqian bigint") 
Conn.execute("ALTER TABLE aysitesys ADD xiaobaojine bigint") 
Conn.execute("ALTER TABLE aysitesys ADD isgzhtika char(5)") 
Conn.execute("ALTER TABLE aysitesys ADD zidingyi1 ntext") 
Conn.execute("ALTER TABLE aysitesys ADD zidingyi2 ntext") 

sql="select * from aysitesys"  
rs.open sql,conn,1,3 
rs.addnew
rs("adminaddress")="admin"
rs("webyulei")="yes"
rs("iswap")="no"
rs("pichost")="/"
rs("ossurl")="/"
rs("apijk")="http://api.ikpay.cn/"
rs("isfan")="no"
rs("nofan")="www,admin,wap,vip"
rs("faxinfang")="IK"
rs("ptjiami")="ikfakaweb"
rs("rejiami")="ay"
rs("maichukazhuanyi")="60"
rs("jname")="发卡"
rs("gsadd")="XX市XX区XX街"
rs("gsaddpic")="/Template/Template4/img/map.jpg"
rs("weblogo")="/Template/Template4/logo/logo.gif"
rs("webdlogo")="/Template/Template4/logo/logo.png"
rs("icpbei")="京ICP备XXXXXXX号"
rs("vipj")=300
rs("vneiqian")=50
rs("xiaobaojine")=200
rs("buytishi")="no"
rs("allfuwuqqmai")="123456789"
rs("fuwuqq")="123456789"
rs("allfuwuqq")="123456789"
rs("gsmail")="XXX@163.com"
rs("fuwutel")="400-400-0000"
rs("allfuwutel")="010-00000000"
rs("showtel")="yes"
rs("isgzhtika")="no"
rs("iswxkfon")="no"
rs("isqqkfon")="no"
rs("bannerpic1")="/Template/Template5/banner/banner1.jpg"
rs("bannerpic2")="/Template/Template5/banner/banner2.jpg"
rs("bannerpic3")="/Template/Template5/banner/banner3.jpg"
rs("bannerlink1")="/index/reg"
rs("bannerlink2")="/index/reg"
rs("bannerlink3")="/index/reg"
rs.update
rs.close



response.Write("更新成功<br>")
%>