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

Conn.execute("ALTER TABLE aycaiwu ADD ayjslistid bigint")
Conn.execute("ALTER TABLE aycaiwu01 ADD ayjslistid bigint")
Conn.execute("ALTER TABLE aycaiwu02 ADD ayjslistid bigint")
Conn.execute("ALTER TABLE aycaiwu03 ADD ayjslistid bigint")
Conn.execute("ALTER TABLE aycaiwu04 ADD ayjslistid bigint")
Conn.execute("ALTER TABLE aycaiwu05 ADD ayjslistid bigint")



Conn.execute("ALTER TABLE aybuylx ADD aylxjin money") 
Conn.execute("ALTER TABLE aybuylx ADD zishoufs char(35)") 
Conn.execute("ALTER TABLE aybuylx ADD jjjzj bigint") 
Conn.execute("ALTER TABLE aybuylx ADD ddchaoshi int default 0") 



Conn.execute("ALTER TABLE ayshoukuan ADD allname char(30)")

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

Conn.execute("ALTER TABLE ayshoukuan ADD username char(30)") 
Conn.execute("ALTER TABLE ayshoukuan ADD userpass char(30)") 


Conn.execute("ALTER TABLE aybuylx ADD qudao char(15)") 
Conn.execute("ALTER TABLE aybuylx ADD suid bigint") 
Conn.execute("ALTER TABLE aybuylx ADD zhifufs int") 


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

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

conn.execute "update aydingdan set yongjin=0 where yongjin is null"
conn.execute "update aydingdan01 set yongjin=0 where yongjin is null"
conn.execute "update aydingdan02 set yongjin=0 where yongjin is null"
conn.execute "update aydingdan03 set yongjin=0 where yongjin is null"
conn.execute "update aydingdan04 set yongjin=0 where yongjin is null"
conn.execute "update aydingdan05 set yongjin=0 where yongjin is null"


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

Conn.execute("ALTER TABLE ayname ADD zishoudate datetime") 

Conn.execute("ALTER TABLE ayname ADD zsali ntext") 
Conn.execute("ALTER TABLE ayname ADD zswei ntext") 
Conn.execute("ALTER TABLE ayname ADD zsqq ntext") 

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

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

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


'表ayjiesuanid商家结算账号
SQL="Create Table ayjiesuanid(ayjid bigint PRIMARY key IDENTITY,ayjismoren int default 0,ayjisdel int default 0,ayjuid bigint,ayjname char(50),ayjcard char(30),ayjfs int,ayjpic ntext,ayjpicisok int default 0,ayjbank char(30),ayjzhihang ntext)"
Conn.execute(SQL) 


Conn.execute("ALTER TABLE aytongzhi ADD suijiid char(20)") 

SQL="Create Table logsession(logid bigint PRIMARY key IDENTITY,aymd5 char(10),ip char(30),useripd char(80),ayjibie int,ayusername char(30),aynameid bigint,aytrueuser char(50),aymasterid bigint,kamiku char(8),flku char(15),spku char(15),ddku char(15),cwku char(15),rzku char(15),aysignmd5 char(32),logdate datetime)"
Conn.execute(SQL) 

'表ayfeika 一月以上卡密
SQL="Create Table ayfeika(aykaid bigint PRIMARY key IDENTITY,aykagoodid bigint,ayka nchar(150),aykapass nchar(150),aykasuoyou bigint,aykasuoyoudd char(50),aykakai datetime,aykatel char(50),aydailiid bigint default 0,aykadstr char(100))"
Conn.execute(SQL) 

'表aybuylx  买家联系方式库
SQL="Create Table aybuylxold(aylxid bigint PRIMARY key IDENTITY,aylxcon char(25),aydddsum char(18),aylogdate datetime default getdate())"
Conn.execute(SQL) 


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

conn.execute "update aydingdan set kamino=0 where kamino is null"
conn.execute "update aydingdan01 set kamino=0 where kamino is null"
conn.execute "update aydingdan02 set kamino=0 where kamino is null"
conn.execute "update aydingdan03 set kamino=0 where kamino is null"
conn.execute "update aydingdan04 set kamino=0 where kamino is null"
conn.execute "update aydingdan05 set kamino=0 where kamino is null"


'表aytxtka     后台txt加卡
SQL="Create Table aytxtka(aytxtid bigint PRIMARY key IDENTITY,aytxtuid bigint,aytxtgid bigint,aytxthost char(20),aytxtname char(60),aytxtdate datetime default getdate(),sytxtsj bigint default 0,aytxtzt int default 0,aytxtjc int default 0,aytxtsum bigint default 0,)"
Conn.execute(SQL) 

SQL="Create Table ayka31(aykaid bigint PRIMARY key IDENTITY,aykayesno int default 0,aykagoodid bigint,ayka char(150),aykapass char(150),aykasuoyou bigint,aykasuoyoudd char(50),aykadata datetime default getdate(),aykakai datetime,aykatel char(50),aydailiid bigint default 0,aykadstr char(100))"
Conn.execute(SQL)  
SQL="Create Table ayka32(aykaid bigint PRIMARY key IDENTITY,aykayesno int default 0,aykagoodid bigint,ayka char(150),aykapass char(150),aykasuoyou bigint,aykasuoyoudd char(50),aykadata datetime default getdate(),aykakai datetime,aykatel char(50),aydailiid bigint default 0,aykadstr char(100))"
Conn.execute(SQL)
SQL="Create Table ayka33(aykaid bigint PRIMARY key IDENTITY,aykayesno int default 0,aykagoodid bigint,ayka char(150),aykapass char(150),aykasuoyou bigint,aykasuoyoudd char(50),aykadata datetime default getdate(),aykakai datetime,aykatel char(50),aydailiid bigint default 0,aykadstr char(100))"
Conn.execute(SQL)
SQL="Create Table ayka34(aykaid bigint PRIMARY key IDENTITY,aykayesno int default 0,aykagoodid bigint,ayka char(150),aykapass char(150),aykasuoyou bigint,aykasuoyoudd char(50),aykadata datetime default getdate(),aykakai datetime,aykatel char(50),aydailiid bigint default 0,aykadstr char(100))"
Conn.execute(SQL)
SQL="Create Table ayka35(aykaid bigint PRIMARY key IDENTITY,aykayesno int default 0,aykagoodid bigint,ayka char(150),aykapass char(150),aykasuoyou bigint,aykasuoyoudd char(50),aykadata datetime default getdate(),aykakai datetime,aykatel char(50),aydailiid bigint default 0,aykadstr char(100))"
Conn.execute(SQL)
SQL="Create Table ayka36(aykaid bigint PRIMARY key IDENTITY,aykayesno int default 0,aykagoodid bigint,ayka char(150),aykapass char(150),aykasuoyou bigint,aykasuoyoudd char(50),aykadata datetime default getdate(),aykakai datetime,aykatel char(50),aydailiid bigint default 0,aykadstr char(100))"
Conn.execute(SQL)
SQL="Create Table ayka37(aykaid bigint PRIMARY key IDENTITY,aykayesno int default 0,aykagoodid bigint,ayka char(150),aykapass char(150),aykasuoyou bigint,aykasuoyoudd char(50),aykadata datetime default getdate(),aykakai datetime,aykatel char(50),aydailiid bigint default 0,aykadstr char(100))"
Conn.execute(SQL)
SQL="Create Table ayka38(aykaid bigint PRIMARY key IDENTITY,aykayesno int default 0,aykagoodid bigint,ayka char(150),aykapass char(150),aykasuoyou bigint,aykasuoyoudd char(50),aykadata datetime default getdate(),aykakai datetime,aykatel char(50),aydailiid bigint default 0,aykadstr char(100))"
Conn.execute(SQL)
SQL="Create Table ayka39(aykaid bigint PRIMARY key IDENTITY,aykayesno int default 0,aykagoodid bigint,ayka char(150),aykapass char(150),aykasuoyou bigint,aykasuoyoudd char(50),aykadata datetime default getdate(),aykakai datetime,aykatel char(50),aydailiid bigint default 0,aykadstr char(100))"
Conn.execute(SQL)
SQL="Create Table ayka40(aykaid bigint PRIMARY key IDENTITY,aykayesno int default 0,aykagoodid bigint,ayka char(150),aykapass char(150),aykasuoyou bigint,aykasuoyoudd char(50),aykadata datetime default getdate(),aykakai datetime,aykatel char(50),aydailiid bigint default 0,aykadstr char(100))"
Conn.execute(SQL)

Conn.execute("ALTER TABLE aydingdan ADD ddrebiaoshi char(10)")
Conn.execute("ALTER TABLE aydingdan01 ADD ddrebiaoshi char(10)")
Conn.execute("ALTER TABLE aydingdan02 ADD ddrebiaoshi char(10)")
Conn.execute("ALTER TABLE aydingdan03 ADD ddrebiaoshi char(10)")
Conn.execute("ALTER TABLE aydingdan04 ADD ddrebiaoshi char(10)")
Conn.execute("ALTER TABLE aydingdan05 ADD ddrebiaoshi char(10)")


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