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

SQL="Create Table aypicsite(aypid bigint PRIMARY key IDENTITY,aypuid bigint,ayptit ntext,aypcon ntext,aypdate datetime default getdate())"
Conn.execute(SQL) 
response.Write("数据库-表aypicsite-添加成功")&"<br>"

conn.execute("ALTER TABLE aypicsite ADD aypfang int default 0") 
conn.execute("ALTER TABLE aypicsite ADD aypzt int default 0")
conn.execute("ALTER TABLE aypicsite ADD aypshibaizt int default 0") 


Conn.execute("ALTER TABLE aydingdan ADD jjjzj bigint default 0") 
Conn.execute("ALTER TABLE aydingdan01 ADD jjjzj bigint default 0") 
Conn.execute("ALTER TABLE aydingdan02 ADD jjjzj bigint default 0") 
Conn.execute("ALTER TABLE aydingdan03 ADD jjjzj bigint default 0") 
Conn.execute("ALTER TABLE aydingdan04 ADD jjjzj bigint default 0") 
Conn.execute("ALTER TABLE aydingdan05 ADD jjjzj bigint default 0") 


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

conn.execute("ALTER TABLE ayname ADD issprz int default 0")
conn.execute "update ayname set issprz=0 where issprz is null"

Conn.execute("ALTER TABLE ayname ADD sfz1 ntext") 
Conn.execute("ALTER TABLE ayname ADD sfz2 ntext") 


conn.execute("ALTER TABLE ayname ADD sfzisok int default 0")
conn.execute("ALTER TABLE ayname ADD isqzsfz int default 0")
conn.execute "update ayname set sfzisok=0 where sfzisok is null"
conn.execute "update ayname set isqzsfz=0 where isqzsfz is null"



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

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

Conn.execute("ALTER TABLE ayquanju ADD jiyiid char(10)") 
Conn.execute("ALTER TABLE ayquanju ADD jiyikey ntext")
Conn.execute("ALTER TABLE ayquanju ADD jiyire ntext") 
Conn.execute("ALTER TABLE ayquanju ADD jiyino ntext") 


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