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


'表aypayhuitiao 异步通知记录
SQL="Create Table aypayhuitiao(aypayid bigint PRIMARY key IDENTITY,aypaytime datetime default getdate(),aypaydd char(20),aypaytd char(15),aypayyu char(20),aypaycon ntext)"
Conn.execute(SQL) 
response.Write("数据库-表aypayhuitiao-添加成功")&"<br>"

Conn.execute("ALTER TABLE aypayhuitiao ADD aypayfyu char(20)") 

Conn.execute("ALTER TABLE aysitesys ADD qqkfwapre ntext") 
Conn.execute("ALTER TABLE aysitesys ADD chongali ntext") 
Conn.execute("ALTER TABLE aysitesys ADD chongwx ntext")

SQL="Create Table aymaiidhei(aymaiidheiid bigint PRIMARY key IDENTITY,aymaiuid bigint)"
Conn.execute(SQL) 
response.Write("数据库-表aymaiidhei-添加成功")&"<br>"


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

Conn.execute("ALTER TABLE ayname ADD iseditbuy int default 0") 
conn.execute "update ayname set iseditbuy=0 where iseditbuy is null"
 
Conn.execute("ALTER TABLE aykafenlei ADD issjsuo int default 0") 
conn.execute "update aykafenlei set issjsuo=0 where issjsuo is null"

conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK18','新投诉查询密码','SMS_173471655','投诉密码${code1}(10分钟有效)，用于查询与撤销投诉，请妥善保存。')")

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