<!--#include virtual="/inc/md52.asp"-->
<title>安装爱卡自动发卡平台系统</title>

<%
Server.ScriptTimeOut = 999999

if trim(Application("SqlDbHost"))<>"" or trim(Application("SqlDbName"))<>"" or trim(Application("SqlUserName"))<>"" or trim(Application("SqlUserPass"))<>"" then
response.Write "网站系统已经安装过了！"
response.end
end if


if request.Form("act")="add" then
webname=trim(request.Form("webname"))
weburl=trim(request.Form("weburl"))
SqlDbHost=trim(request.Form("SqlDbHost"))
SqlDbName=trim(request.Form("SqlDbName"))
SqlUserName=trim(request.Form("SqlUserName"))
SqlUserPass=trim(request.Form("SqlUserPass"))

if webname="" or weburl="" or SqlDbHost="" or SqlDbName="" or SqlUserName="" or SqlUserPass="" then%>
<script language='javascript'>
alert('缺少参数');
history.go(-1);
</script>  
<%end if

set rs=server.CreateObject("adodb.recordset")
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=SQLOLEDB.1; Persist Security Info=True; Connect Timeout=100; Data Source=" & SqlDbHost & "; Initial Catalog="&SqlDbName&"; User ID="&SqlUserName&"; Password=" & SqlUserPass
conn.Open connstr

hostshibie="ikhost"

	strOut="<script language=vbscript runat=server>"
	strOut=strOut&CHR(13)&"Sub Application_onStart"
	strOut=strOut&CHR(13)&"Application("&CHR(34)&"SqlDbHost"&CHR(34)&")="&CHR(34)&SqlDbHost&CHR(34)&""
	strOut=strOut&CHR(13)&"Application("&CHR(34)&"SqlDbName"&CHR(34)&")="&CHR(34)&SqlDbName&CHR(34)&""
	strOut=strOut&CHR(13)&"Application("&CHR(34)&"SqlUserName"&CHR(34)&")="&CHR(34)&SqlUserName&CHR(34)&""
	strOut=strOut&CHR(13)&"Application("&CHR(34)&"SqlUserPass"&CHR(34)&")="&CHR(34)&SqlUserPass&CHR(34)&""
	strOut=strOut&CHR(13)&"Application("&CHR(34)&"hostshibie"&CHR(34)&")="&CHR(34)&hostshibie&CHR(34)&""
	strOut=strOut&CHR(13)&"End Sub"
	strOut=strOut&CHR(13)&"</script>"
	Set fso=Server.CreateObject("Scripting.FileSystemObject")
	set linkw=fso.createtextfile(server.mappath("\global.asa"),true)
	linkw.writeline strOut
	linkw.close%>
<%
'表ayname 会员
SQL="Create Table ayname(aynameid bigint PRIMARY key IDENTITY,ayusername nchar(30),aypassword nchar(50),aymail nchar(30),ayqq bigint,aytel bigint,ayshenfenzheng char(20),ayjiesuanms int default 5,aytrueuser char(50),ayjibie int,aydata datetime,aylastdata datetime,ayip char(30),aylastip char(30),ayyue money default 0,ayxiaofei money default 0,aydongjie money default 0,ayusersuo int,aylogcishu bigint default 0,ayjifen bigint default 0,ayshenhe int default 0,aywebname char(200),ayweburl char(100),aychengjiao bigint default 0,aygename char(20),ayanquan nchar(50) default 0,ayusermiaoshu char(400),ayisxiaobao int default 0,ayisxiaojin money default 0,ayljjs money default 0,ayispay int default 0,aytxsy money default 0,aymd5 char(10),ayismd5 int default 0,ayisjssuo int default 0,ayisdaili int default 0,aymasterid bigint default 0,ayaisalipayfz int default 0,ayalipayyu money default 0,ayurlno int default 0,istelrz int default 0,ismailrz int default 0,xbdate datetime,mdulipa char(50),mailbj int default 0,aybeizhu ntext,ischengxin int default 0,isyaoqing int default 0,isjihuo int default 0,aybiaozhu int default 0,isvipid int default 0,smssum bigint default 0,vipdate datetime,kamiku char(8),wxopenid char(35),tsmaichu int default 1,tskucun int default 1,suijimd5 char(22),flku char(15),spku char(15),ddku char(15),cwku char(15),rzku char(15),isjiekou char(15),istixian int default 0,iswappay int default 1,jjmoney money default 0,isgzh int default 1)"
Conn.execute(SQL) 
response.Write("数据库-表ayname-添加成功")&"<br>"

'表aykafenlei 卡标题
SQL="Create Table aykafenlei(aykafenleiid bigint PRIMARY key IDENTITY,aykafenleiname char(60),ayshangjiid bigint default 0,aykafenleisx bigint,aykanamesuoyou bigint,aykafenleijin bigint,aykafenleishuoming char(80),aykafenleiqq bigint,aykafenleiurl char(80),aykafenleikg int default 0,aykafenleimd5 char(12),ayfenleidlid bigint default 0,ayflsumid char(20),ayfenleidlfid bigint default 0,ayfldlmd5url char(20))"
Conn.execute(SQL) 
response.Write("数据库-表aykafenlei-添加成功")&"<br>"

'表aygood  商品物品
SQL="Create Table aygood(aygoodid bigint PRIMARY key IDENTITY,aygoodsuoyouid bigint,aygoodfl bigint,aygoodsx bigint,aygoodname char(60),ayjiage money,aychenben money,ayycj money default 0,aypifayes int default 0,aypifa1 bigint default 0,aypifa2 bigint default 0,aypifa3 bigint default 0,aypifa4 bigint default 0,aypifa5 bigint default 0,aypifaj1 money default 0,aypifaj2 money default 0,aypifaj3 money default 0,aypifaj4 money default 0,aypifaj5 money default 0,ayyujing bigint default 0,ayyujingmail int default 0,ayyujingmss int default 0,ayyujingtel int default 0,ayxiangou bigint,ayyouhuiyes int default 0,ayzhifu int default 0,ayshoukatz int default 0,ayshmiaoshu char(130),ayshurl char(80),ayshqq bigint,aygoodzhuangtai int default 0,aygooddianka ntext,ayisbankpay int default 1,ayisalipay int default 1,ayistenpay int default 1,ayggodispass int default 0,aygoodiskucun int default 0,aygoodmd5 char(12),aygooddlid bigint default 0,aygoodisydl int default 0,aygsumid char(20),aygiska int default 0,aygismka int default 0,aysjjiage money default 0,aysjgid bigint default 0,ayissaopay int default 1,aygoodtodaili money default 0,aygdlmd5url char(20),goodxx ntext,goodbuyxx ntext,ayisqqpay int default 1,ayjujingwx int default 0 ,shoukamail int default 1,shoukatel int default 0,shouikawx int default 0,kahaoname char(10),kaminame char(10),bugpass char(15),issjsuo int default 0)"
Conn.execute(SQL) 
response.Write("数据库-表aygood-添加成功")&"<br>"

'表ayka 卡密
SQL="Create Table ayka(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 ayka01(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 ayka02(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 ayka03(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 ayka04(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 ayka05(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 ayka06(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 ayka07(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 ayka08(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 ayka09(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 ayka10(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 ayka11(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 ayka12(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 ayka13(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 ayka14(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 ayka15(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 ayka16(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 ayka17(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 ayka18(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 ayka19(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 ayka20(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 ayka21(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 ayka22(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 ayka23(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 ayka24(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 ayka25(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 ayka26(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 ayka27(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 ayka28(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 ayka29(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 ayka30(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 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)
response.Write("数据库-表ayka-添加成功")&"<br>"

'表aydingdan 订单
SQL="Create Table aydingdan(aydingdanid bigint PRIMARY key IDENTITY,aydingdansum char(50),aydingdanzt int default 0,aydingdanuser bigint,aydingdanjjhao char(50),aydigndanyf money,aydingdanin money,aydingdanyj money,aydingdanjin money,aydingdanzj money,aydingdancb money default 0,ayddquantity bigint,ayddfeileiid bigint,ayddshangid bigint,ayddyouhuiquanzhi char(10),ayddyouhuiquan char(50),ayddcontact char(30),ayddemail char(30),ayddzffangshi int,ayddpid char(20),aydingdansj datetime,aydingdanpass nchar(30),aybuyipxx text,ayddbody char(50),aygooddlid bigint default 0,aysgoodid bigint default 0,aysinddzj money default 0,ayuinddzj money default 0,isalipayfz int default 0,alipayfzfei money default 0,ayddsuo int default 0,apicheng money default 0,aysjjiage money default 0,shangqq char(20))"
Conn.execute(SQL) 
response.Write("数据库-表aydingdan-添加成功")&"<br>"

'表ayyouhuiquan 优惠券
SQL="Create Table ayyouhuiquan(ayyouhuiid bigint PRIMARY key IDENTITY,ayyouhuisuoyou bigint,ayyouhuiquan char(60),ayyouhuifangshi int default 0,ayyouhuiyesno int default 0,ayyouhuijiage bigint,ayyouhuidate datetime,ayyouhuishiyong datetime,ayyouhuishixiao bigint,ayyouhuishiyonid bigint,ayyouhuishangid ntext,ayyouhuiflid ntext,ayyouhuiall int default 0,ayyouhuijibie int default 0,ayyouhuihuozeng int default 0,ayyouhuibuch int default 0,ayyouhuiisty int default 0)"
Conn.execute(SQL) 
response.Write("数据库-表ayyouhuiquan-添加成功")&"<br>"

'表aycaiwu 财务  
SQL="Create Table aycaiwu(aycaiwuid bigint PRIMARY key IDENTITY,aycaiwuzt int default 0,aycailiushui char(30),aycaiwuleibie int,aychongjin money default 0,aycaiwujine money,aycaiwuyue money,aycaiwuuser bigint,aycaiwudingdan char(300),aycaiwudate datetime,aycaiwuptjy char(50),aycaiwuzhifu int,aycaiwupid char(30),aycaiwufangshi int,aycaiwuzhihang char(80),aycaiwulastjin money,aycaiwutxcl int default 0,aycaiwujsms int,aycaiwubody char(50),aycaiwuisjs int default 0,aycwfsjin money default 0,aycwinjin money default 0,aycwistj int default 0,aytxyue int default 0,aytxjj int default 0,ayshouname char(40),isalipayfz int default 0,alipayfzfei money default 0,apicheng money default 0,aycaishoubei ntext,aycwissuo int default 0,aycwdtime datetime,jjmoney money default 0,shanguid bigint default 0)"
Conn.execute(SQL) 
response.Write("数据库-表aycaiwu-添加成功")&"<br>"

'表ayquanju 全局
SQL="Create Table ayquanju(ayshangshenhe int,ayreg int,ayregshang int,aytixianjin bigint,aytixianfeiyong char(10),aylog int,aydajin money,aydashou money,ayzhongjin money,ayzhongshou money,ayxiaojin money,ayxiaoshou money,ayalipaypartner char(16),ayalipaykey ntext,ayalipayreturn ntext,ayalipaynotify ntext,ayalibankre ntext,ayalibankno ntext,aytenpaypartner char(16),aytenpaykey ntext,aytenpayreturn ntext,aytenpaynotify ntext,ayisbankpay int,aybankpay int,ayisalipay int,ayistenpay int,ayalif money,aytenf money,aybankf money,ayapipartner char(16),ayapikey ntext,ayapireturn ntext,ayapinotify ntext,ayjihuayy int,ayjihuaddwei int,ayjihuaddbai int,ayjihuacw int,ayjihuakami int,ayjihuauser int,ayjihuarizhi int,ayjihuaddday bigint,ayjihuacwday bigint,ayjihuakamiday bigint,ayjihuauserday bigint,ayjihuarizhiday bigint,ayjiesuanzhouqi bigint,aysmsuser char(20),aysmspass char(20),aysystemid char(30),ayzdyddison int,ayzdyddfei bigint,ayisguolv int default 0,ayguolvcon ntext,ayalipaymail char(30),ayadminpass char(50),ayisquan int default 0,ayjihuaokddday bigint,aychenbank money default 1,aychenalipay money default 1,aychentenpay money default 1,ayisraili int default 0,lastdate bigint,maxtxsulm bigint,ismaxtxjin int,iskqjiaji int,maxtxjin money,jiajifei char(10),alipayname ntext,isalipayfz int default 0,alipayfzxx money,alipayfzsx money,alipayfzfei money,alipayfz1 bigint,alipayfz2 bigint,ayalipaymailz1 char(30),ayalipaymailn ntext,aytenpbanku ntext,aytenpbankn ntext,saomacheng money,saomafei money,saomatourl ntext,saomanotify ntext,appsecret ntext,skey ntext,mchid char(12),appid ntext,ayissaopay int default 1,qzalipayf money,qzalipayc money,qzalipayf2 money,qzalipayc2 money,ayisyaoqing int default 0,kamishuju char(8),ayisqqpay int default 0,qqpar char(15),qqkey char(40),qqnotify ntext,qqsaomafei money,qqsaomacheng money,flku char(15),spku char(15),ddku char(15),cwku char(15),rzku char(15),ayalifwap money,aytenfwap money,saomafeiwap money,qqsaomafeiwap money,aychenalipaywap money,aychentenpaywap money,saomachengwap money,qqsaomachengwap money,ayisalipaywap int,ayistenpaywap int,ayissaopaywap int,ayisqqpaywap int,wapbank int,ayisbankwap int,aliqitajiekou int default 0,wxqitajiekou int default 0,qqqitajiekou int default 0,aliqitajiekouwap int default 0,wxqitajiekouwap int default 0,qqqitajiekouwap int default 0)"
Conn.execute(SQL) 
response.Write("数据库-表ayquanju-添加成功")&"<br>"

'表通知aytongzhi
SQL="Create Table aytongzhi(aytongzhiid bigint PRIMARY key IDENTITY,aytongzhilei int,aytongzhiuser bigint,aytongzhidate datetime,aytongzhisum bigint default 0,aytongzhibiao char(140),aytongzhicon ntext,aytongzhikejian int default 0,aytongzhisx bigint,aytongzhibtys char(40),aytongzhidu int default 0,t1 int default 0,t2 int default 0,t3 int default 0,t4 int default 0,t4isall int default 0,t5 int default 0,t6 int default 0,t7 int default 0)"
Conn.execute(SQL) 
response.Write("数据库-表aytongzhi-添加成功")&"<br>"


'表举报 ayjubao
SQL="Create Table ayjubao(ayjubaoid bigint PRIMARY key IDENTITY,ayjubaosjid bigint default 0,ayjubaosh int default 0,ayjubaogood int default 0,ayjubaocon char(30),ayjubaoxcon char(400),ayjubaouid bigint,ayjubaogid bigint,aydate datetime,ayjuname char(30),ayjuhuifu char(400),ayjuishui int default 0,ayjuishuisid int default 0,ayjudown ntext,ayjuzt int default 0,ayjupass char(30),ayjubaozt int default 0,jubaodd char(20),jubaomail char(30),jubaoisnew int default 0,jubaolastdate datetime default getdate(),jubaoqq char(15))"
Conn.execute(SQL) 
response.Write("数据库-表ayjubao-添加成功")&"<br>"

'表aylog 日志
SQL="Create Table aylog(aylogid bigint PRIMARY key IDENTITY,ayloguserid bigint,aylogleibie int default 0,aylogerr int default 0,aylogcon char(80),aylogip char(30),aylogdate datetime default getdate(),ayipd ntext)"
Conn.execute(SQL) 
response.Write("数据库-表aylog-添加成功")&"<br>"

'表ayujb 会员级别
SQL="Create Table ayujb(ayujbid bigint PRIMARY key IDENTITY,ayujbgid bigint,ayujbname char(12),ayujbtxje money,ayujbtxfei char(10),ayujbxiaoe money,ayujbxiaof money,ayujbzhonge money,ayujbzhongf money,ayujbdae money,ayujbdaf money,ayujbjsday bigint,ayujbbankbl money,ayujbalibl money,ayujbtenbl money,ayujbjjf char(10) default 0,ayujbsaobl money default 1,ayujbqqbl money default 1,ayujbjiekou int default 0,ayujbjiekoubank money default 0,ayujbjiekouali money default 0,ayujbjiekouten money default 0,ayujbjiekouwei money default 0,ayujbjiekouqq money default 0,ayujbaliblwap money default 0,ayujbtenblwap money default 0,ayujbsaoblwap money default 0,ayujbqqblwap money default 0,aybankpay int default 1,jbaliqitajiekou int default 0,jbwxqitajiekou int default 0,jbqqqitajiekou int default 0,jbaliqitajiekouwap int default 0,jbwxqitajiekouwap int default 0,jbqqqitajiekouwap int default 0)"
Conn.execute(SQL) 
response.Write("数据库-表ayujb-添加成功")&"<br>"

'表ayjslist 结算记录
SQL="Create Table ayjslist(ayjsid bigint PRIMARY key IDENTITY,ayjsjin money,ayjsname char(50),ayjstruename char(50),ayjsfs int,ayjssid char(30),ayjsbank char(30),ayjstel char(20),ayjsdate datetime default getdate())"
Conn.execute(SQL) 
response.Write("数据库-表ayjslist-添加成功")&"<br>"

'表aypttj 平台统计
SQL="Create Table aypttj(ayptid bigint PRIMARY key IDENTITY,aypttjzq int default 3,aypttjjl char(20),ayptdate datetime default getdate(),ayptcjbs bigint default 0,ayptcjje money default 0,ayptcjlr money default 0,ayptbank bigint default 0,ayptbankj money default 0,ayptcard bigint default 0,ayptcardj money default 0,ayptalipay bigint default 0,ayptalipayj money default 0,aypttenpay bigint default 0,aypttenpayj money default 0,aypttjuid bigint default 0,ayfandian bigint default 0,ayfandianj money default 0,chongzhij money default 0,chonglirun money default 0,chongzhib bigint default 0,diankalirun money default 0,diankalirunsum bigint default 0,jishilirun money default 0,jishilirunsum bigint default 0,jiajilirun money default 0,jiajilirunsum bigint default 0,aotolirun money default 0,aotolirunsum bigint default 0,shoukuanj money default 0,shoulirun money default 0,shoulirunsum bigint default 0,banklirun money default 0,alipaylirun money default 0,tenpaylirun money default 0,cardlirun money default 0,qitain money default 0,dailiin money default 0,ayptsaoj money default 0,ayptsaob bigint default 0,ayptsaol money default 0,wapalib bigint default 0,wapalij money default 0,wapalil money default 0,waptenb bigint default 0,waptenj money default 0,waptenl money default 0,qqsaob bigint default 0,qqsaoj money default 0,qqsaol money default 0)"
Conn.execute(SQL) 
response.Write("数据库-表aypttj-添加成功")&"<br>"

'表ayxiaoshou 销售统计
SQL="Create Table ayxiaoshou(ayxsid bigint PRIMARY key IDENTITY,ayxsuid bigint,ayxsjin money default 0,ayxsdate datetime,ayxsistj int default 0)"
Conn.execute(SQL) 
response.Write("数据库-表ayxiaoshou-添加成功")&"<br>"

'表userlog 登录记录
SQL="Create Table userlog(userlogid bigint PRIMARY key IDENTITY,userloguser bigint,userlogip char(20),userlogipx ntext,userlogawidth char(20),userlogaheight char(20),userlogwidth char(20),userlogheight char(20),userlogxiangxi ntext,userlogdate datetime default getdate(),userlogipd char(80))"
Conn.execute(SQL) 
response.Write("数据库-表userlog-添加成功")&"<br>"

'表aytaocan 套餐
SQL="Create Table aytaocan(aytcid bigint PRIMARY key IDENTITY,aytcname char(30),aytczong money,aytcjin money,aytcsj bigint,aytcisbuy int default 0,aytcisyear int default 0,aytcyearf money default 1)"
Conn.execute(SQL) 
response.Write("数据库-表aytaocan-添加成功")&"<br>"

'表aytaocanlog 套餐记录
SQL="Create Table aytaocanlog(aytcid bigint PRIMARY key IDENTITY,aytcuid bigint,aytcbuyd datetime default getdate(),aytcname char(30),aytczong money,aytcsheng money,aytcjin money,aytcsj bigint,aytczt int default 0,aytcisyear int default 0,aytcyearf money default 1,aytczhiding ntext)"
Conn.execute(SQL) 
response.Write("数据库-表aytaocanlog-添加成功")&"<br>"

'表ayjianyi 建议BUG提交
SQL="Create Table ayjianyi(ayjianyiid bigint PRIMARY key IDENTITY,ayjianyilx char(30),ayjianyicon text,ayjianyidate datetime default getdate(),ayjianyiisd int default 0)"
Conn.execute(SQL) 
response.Write("数据库-表ayjianyi-添加成功")&"<br>"

'表ayyanzheng 表验证
SQL="Create Table ayyanzheng(ayyanzhengid bigint PRIMARY key IDENTITY,ayyanzhengids char(10),ayyanzhengidc char(50))"
Conn.execute(SQL) 
response.Write("数据库-表ayyanzheng-添加成功")&"<br>"

'表aydailishang 代理商
SQL="Create Table aydailishang(aydlid bigint PRIMARY key IDENTITY,aydluserid char(10),aydlsjuserid char(10),aydlistongguo int default 0,aydlsdate datetime default getdate(),aydltdate datetime,aydliska int default 0,aydlismka int default 0,aydlfandian char(10),aydlfeiyongf int default 0)"
Conn.execute(SQL)  
response.Write("数据库-表aydailishang-添加成功")&"<br>"

'表aymaster 表平台管理
SQL="Create Table aymaster(aymasterid bigint PRIMARY key IDENTITY,aymastername char(20),aymasterqx text,aymasterjid bigint)"
Conn.execute(SQL) 
response.Write("数据库-表aymaster-添加成功")&"<br>"
 
'表ayiph 黑名单
SQL="Create Table ayiph(ayiphid bigint PRIMARY key IDENTITY,ayipn char(30),ayipnd datetime default getdate())"
Conn.execute(SQL) 
response.Write("数据库-表ayiph-添加成功")&"<br>"

'表aysumyz 次序验证
SQL="Create Table aysumyz(aysumyzd datetime default getdate(),aysumyzi bigint)"
Conn.execute(SQL) 
response.Write("数据库-表aysumyz-添加成功")&"<br>"

'表aymailmb 表邮箱模版
SQL="Create Table aymailmb(aymbid bigint PRIMARY key IDENTITY,aymbsuiji char(10),aymbname char(20),aymbbiaoti char(100),aymbdbiaoti char(60),aymbcon text)"
Conn.execute(SQL) 
response.Write("数据库-表aymailmb-添加成功")&"<br>"

'表ayzizhu 自助修改信息
SQL="Create Table ayzizhu(ayzizhuid bigint PRIMARY key IDENTITY,ayzizhusum char(50),ayzizhuuid bigint,ayzizhulb int,ayzizhudate datetime default getdate(),zyzizhuisok int default 0)"
Conn.execute(SQL)  
response.Write("数据库-表ayzizhu-添加成功")&"<br>"

'表ayyaoqing
SQL="Create Table ayyaoqing(id bigint PRIMARY key IDENTITY,card char(10),isyong int default 0,userid bigint)"
Conn.execute(SQL) 
response.Write("数据库-表ayyaoqing-添加成功")&"<br>"

'表mailto 发信
SQL="Create Table mailto(mid bigint PRIMARY key IDENTITY,mlei int default 0,mzt int default 0,mzt2 int default 0,mfs int default 0,mdate datetime default getdate(),mto char(50),mti ntext,mcon ntext,mdd char(30),wxtop char(30),wxend char(30),wx1 char(50),wx2 char(50),wx3 char(30),wx4 char(30),wx5 char(30),wxlei int,wxtext ntext,fanhui ntext)"
Conn.execute(SQL)  
response.Write("数据库-表mailto-添加成功")&"<br>"

'表ayerr 错误收集
SQL="Create Table ayerr(errid bigint PRIMARY key IDENTITY,errdate datetime default getdate(),errcon ntext,errlu ntext,errbei ntext)"
Conn.execute(SQL) 
response.Write("数据库-表ayerr-添加成功")&"<br>"
 
'表ayweixin
SQL="Create Table ayweixin(aywxid bigint PRIMARY key IDENTITY,aywxto char(35),aywxfrom char(35),aywxdate char(15),aywxtype char(10),aywxcon ntext,aywxmsgid char(20),aywxtime datetime default getdate(),aywxishf int default 0,aywxsid bigint default 0,PicUrl ntext,MediaId ntext)"
Conn.execute(SQL) 
response.Write("数据库-表ayweixin-添加成功")&"<br>"

'表aywxlog 微信操作日志
SQL="Create Table aywxlog(aywxlogid bigint PRIMARY key IDENTITY,aywxf char(35),aywxt char(10),aywxk char(20),aywxd datetime default getdate(),ayhfcon ntext)"
Conn.execute(SQL) 
response.Write("数据库-表aywxlog-添加成功")&"<br>"

'表aymailhei 邮件黑名单
SQL="Create Table aymailhei(aymheicon char(30))"
Conn.execute(SQL) 
response.Write("数据库-表aymailhei-添加成功")&"<br>"

'表aymaiweixin 买家微信号
SQL="Create Table aymaiweixin(id bigint PRIMARY key IDENTITY,maitel bigint,maiopenid char(35))"
Conn.execute(SQL) 
response.Write("数据库-表aymaiweixin-添加成功")&"<br>"


'表aydingdan
SQL="Create Table aydingdan01(aydingdanid bigint PRIMARY key IDENTITY,aydingdansum char(50),aydingdanzt int default 0,aydingdanuser bigint,aydingdanjjhao char(50),aydigndanyf money,aydingdanin money,aydingdanyj money,aydingdanjin money,aydingdanzj money,aydingdancb money default 0,ayddquantity bigint,ayddfeileiid bigint,ayddshangid bigint,ayddyouhuiquanzhi char(10),ayddyouhuiquan char(50),ayddcontact char(30),ayddemail char(30),ayddzffangshi int,ayddpid char(20),aydingdansj datetime,aydingdanpass nchar(30),aybuyipxx text,ayddbody char(50),aygooddlid bigint default 0,aysgoodid bigint default 0,aysinddzj money default 0,ayuinddzj money default 0,isalipayfz int default 0,alipayfzfei money default 0,ayddsuo int default 0,apicheng money default 0,aysjjiage money default 0,shangqq char(20))"
Conn.execute(SQL) 
response.Write("数据库-表aydingdan01-添加成功")&"<br>"
SQL="Create Table aydingdan02(aydingdanid bigint PRIMARY key IDENTITY,aydingdansum char(50),aydingdanzt int default 0,aydingdanuser bigint,aydingdanjjhao char(50),aydigndanyf money,aydingdanin money,aydingdanyj money,aydingdanjin money,aydingdanzj money,aydingdancb money default 0,ayddquantity bigint,ayddfeileiid bigint,ayddshangid bigint,ayddyouhuiquanzhi char(10),ayddyouhuiquan char(50),ayddcontact char(30),ayddemail char(30),ayddzffangshi int,ayddpid char(20),aydingdansj datetime,aydingdanpass nchar(30),aybuyipxx text,ayddbody char(50),aygooddlid bigint default 0,aysgoodid bigint default 0,aysinddzj money default 0,ayuinddzj money default 0,isalipayfz int default 0,alipayfzfei money default 0,ayddsuo int default 0,apicheng money default 0,aysjjiage money default 0,shangqq char(20))"
Conn.execute(SQL) 
response.Write("数据库-表aydingdan02-添加成功")&"<br>"
SQL="Create Table aydingdan03(aydingdanid bigint PRIMARY key IDENTITY,aydingdansum char(50),aydingdanzt int default 0,aydingdanuser bigint,aydingdanjjhao char(50),aydigndanyf money,aydingdanin money,aydingdanyj money,aydingdanjin money,aydingdanzj money,aydingdancb money default 0,ayddquantity bigint,ayddfeileiid bigint,ayddshangid bigint,ayddyouhuiquanzhi char(10),ayddyouhuiquan char(50),ayddcontact char(30),ayddemail char(30),ayddzffangshi int,ayddpid char(20),aydingdansj datetime,aydingdanpass nchar(30),aybuyipxx text,ayddbody char(50),aygooddlid bigint default 0,aysgoodid bigint default 0,aysinddzj money default 0,ayuinddzj money default 0,isalipayfz int default 0,alipayfzfei money default 0,ayddsuo int default 0,apicheng money default 0,aysjjiage money default 0,shangqq char(20))"
Conn.execute(SQL) 
response.Write("数据库-表aydingdan03-添加成功")&"<br>"
SQL="Create Table aydingdan04(aydingdanid bigint PRIMARY key IDENTITY,aydingdansum char(50),aydingdanzt int default 0,aydingdanuser bigint,aydingdanjjhao char(50),aydigndanyf money,aydingdanin money,aydingdanyj money,aydingdanjin money,aydingdanzj money,aydingdancb money default 0,ayddquantity bigint,ayddfeileiid bigint,ayddshangid bigint,ayddyouhuiquanzhi char(10),ayddyouhuiquan char(50),ayddcontact char(30),ayddemail char(30),ayddzffangshi int,ayddpid char(20),aydingdansj datetime,aydingdanpass nchar(30),aybuyipxx text,ayddbody char(50),aygooddlid bigint default 0,aysgoodid bigint default 0,aysinddzj money default 0,ayuinddzj money default 0,isalipayfz int default 0,alipayfzfei money default 0,ayddsuo int default 0,apicheng money default 0,aysjjiage money default 0,shangqq char(20))"
Conn.execute(SQL) 
response.Write("数据库-表aydingdan04-添加成功")&"<br>"
SQL="Create Table aydingdan05(aydingdanid bigint PRIMARY key IDENTITY,aydingdansum char(50),aydingdanzt int default 0,aydingdanuser bigint,aydingdanjjhao char(50),aydigndanyf money,aydingdanin money,aydingdanyj money,aydingdanjin money,aydingdanzj money,aydingdancb money default 0,ayddquantity bigint,ayddfeileiid bigint,ayddshangid bigint,ayddyouhuiquanzhi char(10),ayddyouhuiquan char(50),ayddcontact char(30),ayddemail char(30),ayddzffangshi int,ayddpid char(20),aydingdansj datetime,aydingdanpass nchar(30),aybuyipxx text,ayddbody char(50),aygooddlid bigint default 0,aysgoodid bigint default 0,aysinddzj money default 0,ayuinddzj money default 0,isalipayfz int default 0,alipayfzfei money default 0,ayddsuo int default 0,apicheng money default 0,aysjjiage money default 0,shangqq char(20))"
Conn.execute(SQL) 
response.Write("数据库-表aydingdan05-添加成功")&"<br>"

'表aycaiwu 
SQL="Create Table aycaiwu01(aycaiwuid bigint PRIMARY key IDENTITY,aycaiwuzt int default 0,aycailiushui char(30),aycaiwuleibie int,aychongjin money default 0,aycaiwujine money,aycaiwuyue money,aycaiwuuser bigint,aycaiwudingdan char(300),aycaiwudate datetime,aycaiwuptjy char(50),aycaiwuzhifu int,aycaiwupid char(30),aycaiwufangshi int,aycaiwuzhihang char(80),aycaiwulastjin money,aycaiwutxcl int default 0,aycaiwujsms int,aycaiwubody char(50),aycaiwuisjs int default 0,aycwfsjin money default 0,aycwinjin money default 0,aycwistj int default 0,aytxyue int default 0,aytxjj int default 0,ayshouname char(40),isalipayfz int default 0,alipayfzfei money default 0,apicheng money default 0,aycaishoubei ntext,aycwissuo int default 0,aycwdtime datetime,jjmoney money default 0,shanguid bigint default 0)"
Conn.execute(SQL) 
response.Write("数据库-表aycaiwu01-添加成功")&"<br>"
SQL="Create Table aycaiwu02(aycaiwuid bigint PRIMARY key IDENTITY,aycaiwuzt int default 0,aycailiushui char(30),aycaiwuleibie int,aychongjin money default 0,aycaiwujine money,aycaiwuyue money,aycaiwuuser bigint,aycaiwudingdan char(300),aycaiwudate datetime,aycaiwuptjy char(50),aycaiwuzhifu int,aycaiwupid char(30),aycaiwufangshi int,aycaiwuzhihang char(80),aycaiwulastjin money,aycaiwutxcl int default 0,aycaiwujsms int,aycaiwubody char(50),aycaiwuisjs int default 0,aycwfsjin money default 0,aycwinjin money default 0,aycwistj int default 0,aytxyue int default 0,aytxjj int default 0,ayshouname char(40),isalipayfz int default 0,alipayfzfei money default 0,apicheng money default 0,aycaishoubei ntext,aycwissuo int default 0,aycwdtime datetime,jjmoney money default 0,shanguid bigint default 0)"
Conn.execute(SQL) 
response.Write("数据库-表aycaiwu02-添加成功")&"<br>"
SQL="Create Table aycaiwu03(aycaiwuid bigint PRIMARY key IDENTITY,aycaiwuzt int default 0,aycailiushui char(30),aycaiwuleibie int,aychongjin money default 0,aycaiwujine money,aycaiwuyue money,aycaiwuuser bigint,aycaiwudingdan char(300),aycaiwudate datetime,aycaiwuptjy char(50),aycaiwuzhifu int,aycaiwupid char(30),aycaiwufangshi int,aycaiwuzhihang char(80),aycaiwulastjin money,aycaiwutxcl int default 0,aycaiwujsms int,aycaiwubody char(50),aycaiwuisjs int default 0,aycwfsjin money default 0,aycwinjin money default 0,aycwistj int default 0,aytxyue int default 0,aytxjj int default 0,ayshouname char(40),isalipayfz int default 0,alipayfzfei money default 0,apicheng money default 0,aycaishoubei ntext,aycwissuo int default 0,aycwdtime datetime,jjmoney money default 0,shanguid bigint default 0)"
Conn.execute(SQL) 
response.Write("数据库-表aycaiwu03-添加成功")&"<br>"
SQL="Create Table aycaiwu04(aycaiwuid bigint PRIMARY key IDENTITY,aycaiwuzt int default 0,aycailiushui char(30),aycaiwuleibie int,aychongjin money default 0,aycaiwujine money,aycaiwuyue money,aycaiwuuser bigint,aycaiwudingdan char(300),aycaiwudate datetime,aycaiwuptjy char(50),aycaiwuzhifu int,aycaiwupid char(30),aycaiwufangshi int,aycaiwuzhihang char(80),aycaiwulastjin money,aycaiwutxcl int default 0,aycaiwujsms int,aycaiwubody char(50),aycaiwuisjs int default 0,aycwfsjin money default 0,aycwinjin money default 0,aycwistj int default 0,aytxyue int default 0,aytxjj int default 0,ayshouname char(40),isalipayfz int default 0,alipayfzfei money default 0,apicheng money default 0,aycaishoubei ntext,aycwissuo int default 0,aycwdtime datetime,jjmoney money default 0,shanguid bigint default 0)"
Conn.execute(SQL) 
response.Write("数据库-表aycaiwu04-添加成功")&"<br>"
SQL="Create Table aycaiwu05(aycaiwuid bigint PRIMARY key IDENTITY,aycaiwuzt int default 0,aycailiushui char(30),aycaiwuleibie int,aychongjin money default 0,aycaiwujine money,aycaiwuyue money,aycaiwuuser bigint,aycaiwudingdan char(300),aycaiwudate datetime,aycaiwuptjy char(50),aycaiwuzhifu int,aycaiwupid char(30),aycaiwufangshi int,aycaiwuzhihang char(80),aycaiwulastjin money,aycaiwutxcl int default 0,aycaiwujsms int,aycaiwubody char(50),aycaiwuisjs int default 0,aycwfsjin money default 0,aycwinjin money default 0,aycwistj int default 0,aytxyue int default 0,aytxjj int default 0,ayshouname char(40),isalipayfz int default 0,alipayfzfei money default 0,apicheng money default 0,aycaishoubei ntext,aycwissuo int default 0,aycwdtime datetime,jjmoney money default 0,shanguid bigint default 0)"
Conn.execute(SQL) 
response.Write("数据库-表aycaiwu05-添加成功")&"<br>"

'表aylog
SQL="Create Table aylog01(aylogid bigint PRIMARY key IDENTITY,ayloguserid bigint,aylogleibie int default 0,aylogerr int default 0,aylogcon char(80),aylogip char(30),aylogdate datetime default getdate(),ayipd ntext)"
Conn.execute(SQL) 
response.Write("数据库-表aylog01-添加成功")&"<br>"
SQL="Create Table aylog02(aylogid bigint PRIMARY key IDENTITY,ayloguserid bigint,aylogleibie int default 0,aylogerr int default 0,aylogcon char(80),aylogip char(30),aylogdate datetime default getdate(),ayipd ntext)"
Conn.execute(SQL) 
response.Write("数据库-表aylog02-添加成功")&"<br>"
SQL="Create Table aylog03(aylogid bigint PRIMARY key IDENTITY,ayloguserid bigint,aylogleibie int default 0,aylogerr int default 0,aylogcon char(80),aylogip char(30),aylogdate datetime default getdate(),ayipd ntext)"
Conn.execute(SQL) 
response.Write("数据库-表aylog03-添加成功")&"<br>"
SQL="Create Table aylog04(aylogid bigint PRIMARY key IDENTITY,ayloguserid bigint,aylogleibie int default 0,aylogerr int default 0,aylogcon char(80),aylogip char(30),aylogdate datetime default getdate(),ayipd ntext)"
Conn.execute(SQL) 
response.Write("数据库-表aylog04-添加成功")&"<br>"
SQL="Create Table aylog05(aylogid bigint PRIMARY key IDENTITY,ayloguserid bigint,aylogleibie int default 0,aylogerr int default 0,aylogcon char(80),aylogip char(30),aylogdate datetime default getdate(),ayipd ntext)"
Conn.execute(SQL) 
response.Write("数据库-表aylog05-添加成功")&"<br>"
 
'表aygongdan 工单
SQL="Create Table aygongdan(aygdid bigint PRIMARY key IDENTITY,aygdzt int default 0,aygduid bigint,aygdshangid bigint default 0,aygdbiao char(60),aygdcon ntext,aygdpic1 ntext,aygdpic2 ntext,aygdpic3 ntext,aygdpic4 ntext,aygdpic5 ntext,aygdleibie char(40),aygddate datetime,aygdhuifu int default 0,aygdisnew int default 0,aygdhdate datetime)"
Conn.execute(SQL)  
response.Write("数据库-表aygongdan-添加成功")&"<br>"

'表aybuylx  买家联系方式库
SQL="Create Table aybuylx(aylxid bigint PRIMARY key IDENTITY,aylxcon char(25),aylxku char(15),aylogdate datetime default getdate())"
Conn.execute(SQL) 
response.Write("数据库-表aybuylx-添加成功")&"<br>"

'表ayduihuan  兑换系统
SQL="Create Table ayduihuan(aydhid bigint PRIMARY key IDENTITY,aydhhao char(20),aydhlei int default 1,aydhisok int default 0,aydhdate datetime default getdate(),aydhkdate datetime,aydhuid bigint,aydhmj money default 0,aydhsms bigint default 0)"
Conn.execute(SQL) 
response.Write("数据库-表ayduihuan-添加成功")&"<br>"

'表ayceshibz  测试步骤
SQL="Create Table ayceshibz(aybzid bigint PRIMARY key IDENTITY,aybz1 ntext,aybz2 ntext,aybz3 ntext,aybz4 ntext,aybz5 ntext)"
Conn.execute(SQL) 
response.Write("数据库-表ayceshibz-添加成功")&"<br>"

'表aybuyhei  买家黑名单
SQL="Create Table aybuyhei(aybhid bigint PRIMARY key IDENTITY,aybhlx char(30),aybhmail char(30),aybhip char(60))"
Conn.execute(SQL) 
response.Write("数据库-表aybuyhei-添加成功")&"<br>"

'获取openid
SQL="Create Table aywxhqopen(aywxid bigint PRIMARY key IDENTITY,aywxzt int default 0,aywxstr char(20),aywxopen char(35),nicheng char(30),aywxdate datetime default getdate())"
Conn.execute(SQL) 
response.Write("数据库-表aywxhqopen-添加成功")&"<br>"

'最后处理订单商品ID
SQL="Create Table aylastsid(aylid bigint PRIMARY key IDENTITY,aylsid bigint,aylsum bigint)"
Conn.execute(SQL) 
response.Write("数据库-表aylastsid-添加成功")&"<br>"

Conn.execute("Create Table aytoken(token ntext,tokendate datetime default getdate())") 
response.Write("数据库-表aytoken-添加成功")&"<br>"

Conn.execute("Create Table aymsn(aymsnid bigint PRIMARY key IDENTITY,aymsnzt int default 0,aymsnbt char(60),aymsnurl ntext)") 
response.Write("数据库-表aymsn-添加成功")&"<br>"

SQL="Create Table aykexinip(aykxid bigint PRIMARY key IDENTITY,aykxuid bigint,aykxipd char(80),aykxip char(80),aykxdate datetime)"
Conn.execute(SQL) 
response.Write("数据库-表aykexinip-添加成功")&"<br>"

SQL="Create Table smsmb(smsmbid bigint PRIMARY key IDENTITY,smsmgid char(15),smsmbbt char(30),smsmbcon ntext,smsmbmid char(15),smsmbikmid char(15))"
Conn.execute(SQL) 
response.Write("数据库-表smsmb-添加成功")&"<br>"

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>"

SQL="Create Table ayapiquanju2(shezhi1 int default 0,shezhi2 int default 0,shezhi3 int default 0,shezhi4 int default 0)"
Conn.execute(SQL) 
response.Write("数据库-表ayapiquanju2-添加成功")&"<br>"

'表ayshoukuan 收款码
SQL="Create Table ayshoukuan(ayshoukuanid bigint PRIMARY key IDENTITY,isok int default 0,lei int default 1,con char(35),pic ntext,paixu bigint default 1)"
Conn.execute(SQL) 
response.Write("数据库-表ayshoukuan-添加成功")&"<br>"

'表ddlasttime自收订单买家在线时间
SQL="Create Table ddlasttime(ddlid bigint PRIMARY key IDENTITY,ddhao char(50),ddku char(15),ddadd datetime default getdate(),ddtime datetime default getdate(),ddtime2 datetime default getdate())"
Conn.execute(SQL) 
response.Write("数据库-表ddlasttime-添加成功")&"<br>"

'表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) 
response.Write("数据库-表ayjiesuanid-添加成功")&"<br>"

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) 
response.Write("数据库-表logsession-添加成功")&"<br>"

'表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) 
response.Write("数据库-表ayfeika-添加成功")&"<br>"

'表aybuylx  买家联系方式库
SQL="Create Table aybuylxold(aylxid bigint PRIMARY key IDENTITY,aylxcon char(25),aydddsum char(18),aylogdate datetime default getdate())"
Conn.execute(SQL) 
response.Write("数据库-表aybuylxold-添加成功")&"<br>"

'表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) 
response.Write("数据库-表aytxtka-添加成功")&"<br>"

SQL="Create Table ikbaddd(ikbadddid bigint PRIMARY key IDENTITY,ddd char(20))"
Conn.execute(SQL)
response.Write("数据库-表ikbaddd-添加成功")&"<br>"

'表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>"

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

'表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 ayquanju ADD mch_id char(12)") 
Conn.execute("ALTER TABLE ayquanju ADD wftkey ntext") 
Conn.execute("ALTER TABLE ayquanju ADD wftalino ntext") 
Conn.execute("ALTER TABLE ayquanju ADD wftweino ntext") 
Conn.execute("ALTER TABLE ayquanju ADD wftqqno ntext") 
Conn.execute("ALTER TABLE ayquanju ADD regjibie bigint default 5") 
Conn.execute("ALTER TABLE ayquanju ADD aytenwapr ntext") 
Conn.execute("ALTER TABLE ayquanju ADD aytenwapn ntext") 
Conn.execute("ALTER TABLE ayquanju ADD ayaliwapr ntext") 
Conn.execute("ALTER TABLE ayquanju ADD ayaliwapn ntext") 
Conn.execute("ALTER TABLE ayquanju ADD merchant_no char(15)") 
Conn.execute("ALTER TABLE ayquanju ADD terminal_id char(8)") 
Conn.execute("ALTER TABLE ayquanju ADD access_token ntext") 
Conn.execute("ALTER TABLE ayquanju ADD saobeino ntext") 
Conn.execute("ALTER TABLE ayquanju ADD zlappid char(12)") 
Conn.execute("ALTER TABLE ayquanju ADD zlkey ntext") 
Conn.execute("ALTER TABLE ayquanju ADD zlno ntext") 
Conn.execute("ALTER TABLE ayquanju ADD nowxllq int default 0")
Conn.execute("ALTER TABLE ayquanju ADD tenqitajiekou int default 0") 
Conn.execute("ALTER TABLE ayquanju ADD tenqitajiekouwap int default 0") 
Conn.execute("ALTER TABLE ayquanju ADD wapwxispc int default 0") 
Conn.execute("ALTER TABLE ayquanju ADD dzid char(10)") 
Conn.execute("ALTER TABLE ayquanju ADD dzkey ntext") 
Conn.execute("ALTER TABLE ayquanju ADD dzre ntext") 
Conn.execute("ALTER TABLE ayquanju ADD dzno ntext") 
Conn.execute("ALTER TABLE ayquanju ADD tousutixian int default 0") 
Conn.execute("ALTER TABLE ayquanju ADD shangjiabao int default 0") 
Conn.execute("ALTER TABLE ayquanju ADD ayisjdpay int default 0") 
Conn.execute("ALTER TABLE ayquanju ADD jdqitajiekou int default 0") 
Conn.execute("ALTER TABLE ayquanju ADD ayisjdpaywap int default 0") 
Conn.execute("ALTER TABLE ayquanju ADD jdqitajiekouwap int default 0") 
Conn.execute("ALTER TABLE ayquanju ADD jdsaomafei money default 3") 
Conn.execute("ALTER TABLE ayquanju ADD jdsaomacheng money default 2") 
Conn.execute("ALTER TABLE ayquanju ADD jdsaomafeiwap money default 3") 
Conn.execute("ALTER TABLE ayquanju ADD jdsaomachengwap money default 2") 
Conn.execute("ALTER TABLE ayquanju ADD yisaofuid ntext") 
Conn.execute("ALTER TABLE ayquanju ADD yisaofukey ntext") 
Conn.execute("ALTER TABLE ayquanju ADD yisaofuno ntext")
Conn.execute("ALTER TABLE ayquanju ADD youchangid ntext") 
Conn.execute("ALTER TABLE ayquanju ADD youchangkey ntext") 
Conn.execute("ALTER TABLE ayquanju ADD youchangno ntext")
conn.execute("ALTER TABLE ayquanju ADD okjyrz int default 0")
conn.execute("ALTER TABLE ayquanju ADD rzshangjia int default 0")
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") 
Conn.execute("ALTER TABLE ayquanju ADD buyisdl int default 0") 

Conn.execute("ALTER TABLE ayname ADD isbutishi int default 0") 
Conn.execute("ALTER TABLE ayname ADD isjiaji int default 0") 
Conn.execute("ALTER TABLE ayname ADD tousulv money default 0") 
Conn.execute("ALTER TABLE ayname ADD moban char(10) default 'index'") 
Conn.execute("ALTER TABLE ayname ADD ayweixinid char(30)") 
Conn.execute("ALTER TABLE ayname ADD ayweixinpic ntext") 
Conn.execute("ALTER TABLE ayname ADD ayisweixinok int default 0")
Conn.execute("ALTER TABLE ayname ADD kfwxopenid char(35)") 
Conn.execute("ALTER TABLE ayname ADD kfqqopenid char(35)")
Conn.execute("ALTER TABLE ayname ADD isbuylog int default 0") 
Conn.execute("ALTER TABLE ayname ADD nobuyid ntext") 
Conn.execute("ALTER TABLE ayname ADD isnoanlink int default 0") 
Conn.execute("ALTER TABLE ayname ADD tanchuang ntext") 
Conn.execute("ALTER TABLE ayname ADD isyidiip int default 0") 
Conn.execute("ALTER TABLE ayname ADD xblast datetime") 
Conn.execute("ALTER TABLE ayname ADD isptbuy int default 0") 
Conn.execute("ALTER TABLE ayname ADD tousutixian int default 0") 
Conn.execute("ALTER TABLE ayname ADD shangjiabao int default 0") 
Conn.execute("ALTER TABLE ayname ADD ismiaotui int default 0") 
conn.execute("ALTER TABLE ayname ADD aysanrie money default 0") 
conn.execute("ALTER TABLE ayname ADD iszhuxiao int default 0") 
Conn.execute("ALTER TABLE ayname ADD qqkfname ntext") 
Conn.execute("ALTER TABLE ayname ADD wxkfname ntext") 
conn.execute("ALTER TABLE ayname ADD issprz int default 0")
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("ALTER TABLE ayname ADD ddmaxj bigint default 0")
Conn.execute("ALTER TABLE ayname ADD yquserid bigint default 0") 
Conn.execute("ALTER TABLE ayname ADD yongjin money default 0") 
Conn.execute("ALTER TABLE ayname ADD isshangzishou int default 0") 
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("ALTER TABLE ayname ADD iszswei int default 0") 
Conn.execute("ALTER TABLE ayname ADD iszsqq int default 0") 
Conn.execute("ALTER TABLE ayname ADD iseditbuy int default 0") 

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 ayujb ADD wapbank int")
Conn.execute("ALTER TABLE ayujb ADD aychenalipaywap money")
Conn.execute("ALTER TABLE ayujb ADD aychentenpaywap money")
Conn.execute("ALTER TABLE ayujb ADD saomachengwap money")
Conn.execute("ALTER TABLE ayujb ADD qqsaomachengwap money")
Conn.execute("ALTER TABLE ayujb ADD ayisbankpay int")
Conn.execute("ALTER TABLE ayujb ADD ayisalipay int")
Conn.execute("ALTER TABLE ayujb ADD ayistenpay int")
Conn.execute("ALTER TABLE ayujb ADD ayissaopay int")
Conn.execute("ALTER TABLE ayujb ADD ayisqqpay int")
Conn.execute("ALTER TABLE ayujb ADD ayisbankwap int")
Conn.execute("ALTER TABLE ayujb ADD ayisalipaywap int")
Conn.execute("ALTER TABLE ayujb ADD ayistenpaywap int")
Conn.execute("ALTER TABLE ayujb ADD ayissaopaywap int")
Conn.execute("ALTER TABLE ayujb ADD ayisqqpaywap int")
Conn.execute("ALTER TABLE ayujb ADD ayjbbeizhu ntext") 
Conn.execute("ALTER TABLE ayujb ADD ayjbpaixu bigint default 0")
Conn.execute("ALTER TABLE ayujb ADD nowxllq int default 0")
Conn.execute("ALTER TABLE ayujb ADD tenqitajiekou int default 0") 
Conn.execute("ALTER TABLE ayujb ADD tenqitajiekouwap int default 0") 
Conn.execute("ALTER TABLE ayujb ADD wapwxispc int default 0") 
Conn.execute("ALTER TABLE ayujb ADD ayisjdpay int default 0") 
Conn.execute("ALTER TABLE ayujb ADD jdqitajiekou int default 0") 
Conn.execute("ALTER TABLE ayujb ADD ayisjdpaywap int default 0") 
Conn.execute("ALTER TABLE ayujb ADD jdqitajiekouwap int default 0") 
Conn.execute("ALTER TABLE ayujb ADD jdsaomafei money default 3") 
Conn.execute("ALTER TABLE ayujb ADD jdsaomacheng money default 2") 
Conn.execute("ALTER TABLE ayujb ADD jdsaomafeiwap money default 3") 
Conn.execute("ALTER TABLE ayujb ADD jdsaomachengwap money default 2") 
conn.execute("ALTER TABLE ayujb ADD wapwxispcwap int default 0")

Conn.execute("ALTER TABLE aytongzhi ADD ayshowcon ntext") 
Conn.execute("ALTER TABLE aytongzhi ADD aytongzhipic ntext") 
Conn.execute("ALTER TABLE aytongzhi ADD ayisshow int default 0") 
Conn.execute("ALTER TABLE aytongzhi ADD suijiid char(20)") 

Conn.execute("ALTER TABLE aypttj ADD shoufei money default 0")
Conn.execute("ALTER TABLE aypttj ADD wapweil money default 0") 
Conn.execute("ALTER TABLE aypttj ADD wapqql money default 0") 
Conn.execute("ALTER TABLE aypttj ADD wapweib bigint default 0") 
Conn.execute("ALTER TABLE aypttj ADD wapweij money default 0") 
Conn.execute("ALTER TABLE aypttj ADD wapqqb bigint default 0") 
Conn.execute("ALTER TABLE aypttj ADD wapqqj money default 0") 
Conn.execute("ALTER TABLE aypttj ADD xiaofeij money default 0") 
Conn.execute("ALTER TABLE aypttj ADD jdj money default 0") 
Conn.execute("ALTER TABLE aypttj ADD jdb bigint default 0")
Conn.execute("ALTER TABLE aypttj ADD jdl money default 0")
Conn.execute("ALTER TABLE aypttj ADD wapjdj money default 0") 
Conn.execute("ALTER TABLE aypttj ADD wapjdb bigint default 0")
Conn.execute("ALTER TABLE aypttj ADD wapjdl money default 0")
Conn.execute("ALTER TABLE aypttj ADD ysfj money default 0") 
Conn.execute("ALTER TABLE aypttj ADD ysfb bigint default 0")
Conn.execute("ALTER TABLE aypttj ADD ysfl money default 0")
Conn.execute("ALTER TABLE aypttj ADD wapysfj money default 0") 
Conn.execute("ALTER TABLE aypttj ADD wapysfb bigint default 0")
Conn.execute("ALTER TABLE aypttj ADD wapysfl money default 0")

Conn.execute("ALTER TABLE aydingdan ADD ayddsign char(50)") 
Conn.execute("ALTER TABLE aydingdan ADD dailikuo ntext") 
Conn.execute("ALTER TABLE aydingdan ADD openid char(35)") 
Conn.execute("ALTER TABLE aydingdan ADD msnurl char(22)") 
Conn.execute("ALTER TABLE aydingdan ADD qtgzh int default 0") 
Conn.execute("ALTER TABLE aydingdan ADD qudao char(15)") 
Conn.execute("ALTER TABLE aydingdan ADD ayddbuyid bigint default 0") 
Conn.execute("ALTER TABLE aydingdan ADD isptdxdd int default 0") 
Conn.execute("ALTER TABLE aydingdan ADD daishousid bigint default 0") 
Conn.execute("ALTER TABLE aydingdan ADD lailuyu ntext")
Conn.execute("ALTER TABLE aydingdan ADD zishouzt int default 0")
Conn.execute("ALTER TABLE aydingdan ADD zishoufs char(35)")
Conn.execute("ALTER TABLE aydingdan ADD jjjzj bigint default 0") 
Conn.execute("ALTER TABLE aydingdan ADD ddchaoshi int default 0") 
Conn.execute("ALTER TABLE aydingdan ADD yongjin money default 0") 
Conn.execute("ALTER TABLE aydingdan ADD kamino int default 0") 
Conn.execute("ALTER TABLE aydingdan ADD ddrebiaoshi char(10)")

Conn.execute("ALTER TABLE aydingdan01 ADD ayddsign char(50)") 
Conn.execute("ALTER TABLE aydingdan01 ADD dailikuo ntext")
Conn.execute("ALTER TABLE aydingdan01 ADD openid char(35)") 
Conn.execute("ALTER TABLE aydingdan01 ADD msnurl char(22)")
Conn.execute("ALTER TABLE aydingdan01 ADD qtgzh int default 0") 
Conn.execute("ALTER TABLE aydingdan01 ADD qudao char(15)")
Conn.execute("ALTER TABLE aydingdan01 ADD ayddbuyid bigint default 0")
Conn.execute("ALTER TABLE aydingdan01 ADD isptdxdd int default 0") 
Conn.execute("ALTER TABLE aydingdan01 ADD daishousid bigint default 0") 
Conn.execute("ALTER TABLE aydingdan01 ADD lailuyu ntext")
Conn.execute("ALTER TABLE aydingdan01 ADD zishouzt int default 0") 
Conn.execute("ALTER TABLE aydingdan01 ADD zishoufs char(35)")
Conn.execute("ALTER TABLE aydingdan01 ADD jjjzj bigint default 0") 
Conn.execute("ALTER TABLE aydingdan01 ADD ddchaoshi int default 0") 
Conn.execute("ALTER TABLE aydingdan01 ADD yongjin money default 0") 
Conn.execute("ALTER TABLE aydingdan01 ADD kamino int default 0") 
Conn.execute("ALTER TABLE aydingdan01 ADD ddrebiaoshi char(10)")

Conn.execute("ALTER TABLE aydingdan02 ADD ayddsign char(50)")
Conn.execute("ALTER TABLE aydingdan02 ADD dailikuo ntext")
Conn.execute("ALTER TABLE aydingdan02 ADD openid char(35)") 
Conn.execute("ALTER TABLE aydingdan02 ADD msnurl char(22)")
Conn.execute("ALTER TABLE aydingdan02 ADD qtgzh int default 0") 
Conn.execute("ALTER TABLE aydingdan02 ADD qudao char(15)")
Conn.execute("ALTER TABLE aydingdan02 ADD ayddbuyid bigint default 0")
Conn.execute("ALTER TABLE aydingdan02 ADD isptdxdd int default 0") 
Conn.execute("ALTER TABLE aydingdan02 ADD daishousid bigint default 0") 
Conn.execute("ALTER TABLE aydingdan02 ADD lailuyu ntext")
Conn.execute("ALTER TABLE aydingdan02 ADD zishouzt int default 0") 
Conn.execute("ALTER TABLE aydingdan02 ADD zishoufs char(35)")
Conn.execute("ALTER TABLE aydingdan02 ADD jjjzj bigint default 0") 
Conn.execute("ALTER TABLE aydingdan02 ADD ddchaoshi int default 0") 
Conn.execute("ALTER TABLE aydingdan02 ADD yongjin money default 0") 
Conn.execute("ALTER TABLE aydingdan02 ADD kamino int default 0") 
Conn.execute("ALTER TABLE aydingdan02 ADD ddrebiaoshi char(10)")

Conn.execute("ALTER TABLE aydingdan03 ADD ayddsign char(50)") 
Conn.execute("ALTER TABLE aydingdan03 ADD dailikuo ntext")
Conn.execute("ALTER TABLE aydingdan03 ADD openid char(35)") 
Conn.execute("ALTER TABLE aydingdan03 ADD msnurl char(22)")
Conn.execute("ALTER TABLE aydingdan03 ADD qtgzh int default 0") 
Conn.execute("ALTER TABLE aydingdan03 ADD qudao char(15)")
Conn.execute("ALTER TABLE aydingdan03 ADD ayddbuyid bigint default 0")
Conn.execute("ALTER TABLE aydingdan03 ADD isptdxdd int default 0") 
Conn.execute("ALTER TABLE aydingdan03 ADD daishousid bigint default 0") 
Conn.execute("ALTER TABLE aydingdan03 ADD lailuyu ntext")
Conn.execute("ALTER TABLE aydingdan03 ADD zishouzt int default 0") 
Conn.execute("ALTER TABLE aydingdan03 ADD zishoufs char(35)")
Conn.execute("ALTER TABLE aydingdan03 ADD jjjzj bigint default 0") 
Conn.execute("ALTER TABLE aydingdan03 ADD ddchaoshi int default 0")
Conn.execute("ALTER TABLE aydingdan03 ADD yongjin money default 0") 
Conn.execute("ALTER TABLE aydingdan03 ADD kamino int default 0") 
Conn.execute("ALTER TABLE aydingdan03 ADD ddrebiaoshi char(10)")

Conn.execute("ALTER TABLE aydingdan04 ADD ayddsign char(50)") 
Conn.execute("ALTER TABLE aydingdan04 ADD dailikuo ntext")
Conn.execute("ALTER TABLE aydingdan04 ADD openid char(35)")
Conn.execute("ALTER TABLE aydingdan04 ADD msnurl char(22)")
Conn.execute("ALTER TABLE aydingdan04 ADD qtgzh int default 0") 
Conn.execute("ALTER TABLE aydingdan04 ADD qudao char(15)")
Conn.execute("ALTER TABLE aydingdan04 ADD ayddbuyid bigint default 0")
Conn.execute("ALTER TABLE aydingdan04 ADD isptdxdd int default 0") 
Conn.execute("ALTER TABLE aydingdan04 ADD daishousid bigint default 0") 
Conn.execute("ALTER TABLE aydingdan04 ADD lailuyu ntext")
Conn.execute("ALTER TABLE aydingdan04 ADD zishouzt int default 0") 
Conn.execute("ALTER TABLE aydingdan04 ADD zishoufs char(35)")
Conn.execute("ALTER TABLE aydingdan04 ADD jjjzj bigint default 0") 
Conn.execute("ALTER TABLE aydingdan04 ADD ddchaoshi int default 0") 
Conn.execute("ALTER TABLE aydingdan04 ADD yongjin money default 0") 
Conn.execute("ALTER TABLE aydingdan04 ADD kamino int default 0") 
Conn.execute("ALTER TABLE aydingdan04 ADD ddrebiaoshi char(10)")

Conn.execute("ALTER TABLE aydingdan05 ADD ayddsign char(50)") 
Conn.execute("ALTER TABLE aydingdan05 ADD dailikuo ntext")
Conn.execute("ALTER TABLE aydingdan05 ADD openid char(35)") 
Conn.execute("ALTER TABLE aydingdan05 ADD msnurl char(22)")
Conn.execute("ALTER TABLE aydingdan05 ADD qtgzh int default 0")
Conn.execute("ALTER TABLE aydingdan05 ADD qudao char(15)")
Conn.execute("ALTER TABLE aydingdan05 ADD ayddbuyid bigint default 0")
Conn.execute("ALTER TABLE aydingdan05 ADD isptdxdd int default 0") 
Conn.execute("ALTER TABLE aydingdan05 ADD daishousid bigint default 0") 
Conn.execute("ALTER TABLE aydingdan05 ADD lailuyu ntext")
Conn.execute("ALTER TABLE aydingdan05 ADD zishouzt int default 0") 
Conn.execute("ALTER TABLE aydingdan05 ADD zishoufs char(35)")
Conn.execute("ALTER TABLE aydingdan05 ADD jjjzj bigint default 0") 
Conn.execute("ALTER TABLE aydingdan05 ADD ddchaoshi int default 0") 
Conn.execute("ALTER TABLE aydingdan05 ADD yongjin money default 0") 
Conn.execute("ALTER TABLE aydingdan05 ADD kamino int default 0") 
Conn.execute("ALTER TABLE aydingdan05 ADD ddrebiaoshi char(10)")

conn.execute("ALTER TABLE aykafenlei ADD iszhuxiao int default 0") 
Conn.execute("ALTER TABLE aykafenlei ADD issjsuo int default 0") 

Conn.execute("ALTER TABLE aygood ADD buylx int default 0") 
Conn.execute("ALTER TABLE aygood ADD dailij1 money default 0") 
Conn.execute("ALTER TABLE aygood ADD dailij2 money default 0") 
Conn.execute("ALTER TABLE aygood ADD dailij3 money default 0") 
Conn.execute("ALTER TABLE aygood ADD dailij4 money default 0") 
Conn.execute("ALTER TABLE aygood ADD dailij5 money default 0") 
Conn.execute("ALTER TABLE aygood ADD dailicb1 money default 0") 
Conn.execute("ALTER TABLE aygood ADD dailicb2 money default 0") 
Conn.execute("ALTER TABLE aygood ADD dailicb3 money default 0") 
Conn.execute("ALTER TABLE aygood ADD dailicb4 money default 0") 
Conn.execute("ALTER TABLE aygood ADD dailicb5 money default 0") 
Conn.execute("ALTER TABLE aygood ADD isptdx int default 0") 
Conn.execute("ALTER TABLE aygood ADD ptdxtitle char(50)") 
Conn.execute("ALTER TABLE aygood ADD ptdxyfid bigint default 0") 
Conn.execute("ALTER TABLE aygood ADD ptdxyid bigint default 0") 
Conn.execute("ALTER TABLE aygood ADD ptdxpic ntext") 
Conn.execute("ALTER TABLE aygood ADD ptdxsign char(50)") 
Conn.execute("ALTER TABLE aygood ADD ayisjdpay int default 1") 
conn.execute("ALTER TABLE aygood ADD iszhuxiao int default 0") 

Conn.execute("ALTER TABLE aybuylx ADD aydddsum char(18)") 
Conn.execute("ALTER TABLE aybuylx ADD aydddj char(60)") 
Conn.execute("ALTER TABLE aybuylx ADD aydddzt int default 0") 
Conn.execute("ALTER TABLE aybuylx ADD ayddtsum bigint default 0") 
Conn.execute("ALTER TABLE aybuylx ADD aylxbuyid bigint default 0") 
Conn.execute("ALTER TABLE aybuylx ADD aylxxuid char(5)") 
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 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 aytaocan ADD aytczhiding ntext") 

Conn.execute("ALTER TABLE mailto ADD mbid char(15)") 
Conn.execute("ALTER TABLE mailto ADD code1 char(50)") 
Conn.execute("ALTER TABLE mailto ADD code2 char(50)") 
Conn.execute("ALTER TABLE mailto ADD code3 char(50)") 
Conn.execute("ALTER TABLE mailto ADD qtgzh int default 0") 

Conn.execute("ALTER TABLE aylog ADD isshow int default 0") 
Conn.execute("ALTER TABLE aylog01 ADD isshow int default 0") 
Conn.execute("ALTER TABLE aylog02 ADD isshow int default 0") 
Conn.execute("ALTER TABLE aylog03 ADD isshow int default 0") 
Conn.execute("ALTER TABLE aylog04 ADD isshow int default 0") 
Conn.execute("ALTER TABLE aylog05 ADD isshow int default 0") 

conn.Execute("Insert Into ayujb(ayujbgid,ayujbname,ayujbtxje,ayujbtxfei,ayujbxiaoe,ayujbxiaof,ayujbzhonge,ayujbzhongf,ayujbdae,ayujbdaf,ayujbjsday,ayujbbankbl,ayujbalibl,ayujbtenbl,ayujbsaobl,ayujbqqbl,ayujbjjf) values('1','特殊商户','50','3','50','3','500','3','30000','100','1','1','1','1','2','2','1')")
conn.Execute("Insert Into ayujb(ayujbgid,ayujbname,ayujbtxje,ayujbtxfei,ayujbxiaoe,ayujbxiaof,ayujbzhonge,ayujbzhongf,ayujbdae,ayujbdaf,ayujbjsday,ayujbbankbl,ayujbalibl,ayujbtenbl,ayujbsaobl,ayujbqqbl,ayujbjjf) values('2','铜牌商户','50','3','50','3','500','3','30000','100','1','1','1','1','2','2','1')")
conn.Execute("Insert Into ayujb(ayujbgid,ayujbname,ayujbtxje,ayujbtxfei,ayujbxiaoe,ayujbxiaof,ayujbzhonge,ayujbzhongf,ayujbdae,ayujbdaf,ayujbjsday,ayujbbankbl,ayujbalibl,ayujbtenbl,ayujbsaobl,ayujbqqbl,ayujbjjf) values('3','银牌商户','50','3','50','3','500','3','30000','100','1','1','1','1','2','2','1')")
conn.Execute("Insert Into ayujb(ayujbgid,ayujbname,ayujbtxje,ayujbtxfei,ayujbxiaoe,ayujbxiaof,ayujbzhonge,ayujbzhongf,ayujbdae,ayujbdaf,ayujbjsday,ayujbbankbl,ayujbalibl,ayujbtenbl,ayujbsaobl,ayujbqqbl,ayujbjjf) values('4','金牌商户','50','3','50','3','500','3','30000','100','1','1','1','1','2','2','1')")
conn.Execute("Insert Into ayujb(ayujbgid,ayujbname,ayujbtxje,ayujbtxfei,ayujbxiaoe,ayujbxiaof,ayujbzhonge,ayujbzhongf,ayujbdae,ayujbdaf,ayujbjsday,ayujbbankbl,ayujbalibl,ayujbtenbl,ayujbsaobl,ayujbqqbl,ayujbjjf) values('6','新签商户','50','3','50','3','500','3','30000','100','1','1','1','1','2','2','1')")

conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK01','验证码新版','SMS_68830047','本次的验证码：${code1}(10分钟有效)')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK02','WAP手机提取','SMS_68630029','提取卡密http://wap.ikpay.cn/tika?ka=${code1}')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK03','商家-付款成功卡密不足','SMS_69915046','您有订单买家已付款，库存卡密不足，请先添加卡密后进入订单管理，进行补发操作。')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK04','商家-密码重置','SMS_69005002','密码重置为：${code1}，请登录官网及时修改密码')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK05','密码找回成功','SMS_65975107','密码已经通过密保资料修改成功，详情登陆官网查看')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK06','商家-审核通过通知','SMS_68510163','尊敬的${code1}：您的商户名：${code2}，已经审核通过！')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK07','商家-库存不足通知','SMS_68560117','商品：${code1}，库存仅剩${code2}张，请及时补货')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK08','商家-商品卖出通知','SMS_68655087','商品：${code1}，卖出：${code2}张，订单号：${code3}')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK09','投诉自动回复，通知买家','SMS_65920181','我们已经收到了您的投诉申请，并通知了商家，请耐心等待')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK10','投诉进展通知买家','SMS_68625075','您的投诉得到了新的回复，使用查询密码进行查看，可再次回复或撤销投诉。')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK11','收到新投诉通知','SMS_66070083','收到新的投诉，请及时妥善处理')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK12','收到新投诉通知(新)','SMS_74600050','收到新的投诉,请在24小时内解决投诉问题,详情登陆平台查看')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK13','投诉新进展','SMS_66120069','投诉有了新的进展，请登录官网查看')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK14','投诉回复通知商家','SMS_65965091','您收到投诉得到了新的回复，请登录后进行查看，请妥善处理投诉，谢谢您的理解与配合')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK15','投诉警告通知商家','SMS_66090090','您有未处理的投诉，请及时处理投诉所涉及的问题，感谢您的配合，如长期不做处理账号资金将被冻结！')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK16','通知买家撤销投诉','SMS_142146294','您还有未处理的投诉，使用投诉密码${code1}登录www.ikpay.cn/tousu查看或撤销投诉')")
conn.Execute("Insert Into smsmb(smsmgid,smsmbbt,smsmbikmid,smsmbcon) values('IK18','新投诉查询密码','SMS_173471655','投诉密码${code1}(10分钟有效)，用于查询与撤销投诉，请妥善保存。')")

Conn.execute("ALTER TABLE ayjubao ADD jubaomaiid bigint default 0") 
Conn.execute("ALTER TABLE ayjubao ADD jubaojinzhan int default 0") 
conn.execute("ALTER TABLE ayjubao ADD istongzhi int default 0") 
conn.execute("ALTER TABLE ayjubao ADD jine money default 0") 
conn.execute("ALTER TABLE ayjubao ADD jinzt int default 0") 
conn.execute("ALTER TABLE ayjubao ADD isguaqi int default 0") 
conn.execute("ALTER TABLE ayjubao ADD istuikuan int default 0") 

Conn.execute("ALTER TABLE aycaiwu ADD aylxxuid char(5)")
Conn.execute("ALTER TABLE aycaiwu ADD ayjslistid bigint")

Conn.execute("ALTER TABLE aycaiwu01 ADD aylxxuid char(5)")
Conn.execute("ALTER TABLE aycaiwu01 ADD ayjslistid bigint")

Conn.execute("ALTER TABLE aycaiwu02 ADD aylxxuid char(5)")
Conn.execute("ALTER TABLE aycaiwu02 ADD ayjslistid bigint")

Conn.execute("ALTER TABLE aycaiwu03 ADD aylxxuid char(5)")
Conn.execute("ALTER TABLE aycaiwu03 ADD ayjslistid bigint")

Conn.execute("ALTER TABLE aycaiwu04 ADD aylxxuid char(5)")
Conn.execute("ALTER TABLE aycaiwu04 ADD ayjslistid bigint")

Conn.execute("ALTER TABLE aycaiwu05 ADD aylxxuid char(5)")
Conn.execute("ALTER TABLE aycaiwu05 ADD ayjslistid bigint")

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("ALTER TABLE aybuyhei ADD aybhdate datetime default getdate()")

Conn.execute("ALTER TABLE ayshoukuan ADD allname char(30)")
Conn.execute("ALTER TABLE ayshoukuan ADD userid bigint default 0") 
Conn.execute("ALTER TABLE ayshoukuan ADD username char(30)") 
Conn.execute("ALTER TABLE ayshoukuan ADD userpass char(30)") 

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")
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="select * from ayapiquanju2" 
rs.open sql,conn,1,3
rs.addnew
rs("shezhi1")=0
rs("shezhi2")=0
rs("shezhi3")=0
rs("shezhi4")=0
rs.update
rs.close

sql="select * from ayquanju" 
rs.open sql,conn,1,3 
rs.addnew
rs("ayshangshenhe")=0
rs("ayreg")=1
rs("ayregshang")=1
rs("aytixianjin")=1
rs("aytixianfeiyong")=0
rs("aylog")=1
rs("aydajin")=3000
rs("aydashou")=0
rs("ayzhongjin")=500
rs("ayzhongshou")=0
rs("ayxiaojin")=10
rs("ayxiaoshou")=0
rs("ayisbankpay")=1
rs("aybankpay")=1
rs("ayisalipay")=1
rs("ayistenpay")=1
rs("ayalif")=0
rs("aytenf")=0
rs("aybankf")=0
rs("ayjihuayy")=0
rs("ayjihuaddwei")=0
rs("ayjihuaddbai")=0
rs("ayjihuacw")=0
rs("ayjihuakami")=0
rs("ayjihuauser")=0
rs("ayjihuarizhi")=0
rs("ayjihuaddday")=1
rs("ayjihuacwday")=1
rs("ayjihuakamiday")=1
rs("ayjihuauserday")=1
rs("ayjihuarizhiday")=1
rs("ayjiesuanzhouqi")=1
rs("aysystemid")="0000000000"
rs("ayzdyddison")=0
rs("ayzdyddfei")=30
rs("ayjihuaokddday")=90
rs("ayadminpass")="e10adc3949ba59abbe56e057f20f883e"
rs("lastdate")=23
rs("maxtxsulm")=99
rs("ismaxtxjin")=0
rs("iskqjiaji")=0
rs("maxtxjin")=2
rs("jiajifei")="1%"
rs("alipayfzxx")=1
rs("alipayfzsx")=50
rs("alipayfzfei")=1
rs("alipayfz1")=7
rs("alipayfz2")=21
rs("saomafei")=1
rs("saomacheng")=1
rs("qzalipayf")=1
rs("qzalipayc")=1
rs("qzalipayf2")=1
rs("qzalipayc2")=1
rs("kamishuju")="ayka"
rs("qqsaomafei")=1
rs("qqsaomacheng")=1
rs("flku")="aykafenlei"
rs("spku")="aygood"
rs("ddku")="aydingdan"
rs("cwku")="aycaiwu"
rs("rzku")="aylog"
rs("ayalifwap")=0
rs("aytenfwap")=0
rs("saomafeiwap")=0
rs("qqsaomafeiwap")=0
rs("aychenalipaywap")=0
rs("aychentenpaywap")=0
rs("saomachengwap")=0
rs("qqsaomachengwap")=0
rs("ayisalipaywap")=0
rs("ayistenpaywap")=0
rs("ayissaopaywap")=0
rs("ayisqqpaywap")=0
rs("ayisbankwap")=1
rs("wapbank")=1
rs("tenqitajiekou")=0
rs("tenqitajiekouwap")=0
rs.update
rs.close
response.Write("全局设置初始化成功")&"<br>"


sql="select * from ayname"  
rs.open sql,conn,1,3 
rs.addnew
rs("ayusername")="admin"
rs("aypassword")="e10adc3949ba59abbe56e057f20f883e"
rs("aytrueuser")="爱卡"
rs("ayjibie")=9
rs("aymasterid")=9
rs("aydata")=now()
rs("ayusersuo")=0
rs("ayshenhe")=1
rs("aymd5")=mid(md5(1),17,8) 
rs("kamiku")="ayka"
rs("flku")="aykafenlei"
rs("spku")="aygood"
rs("ddku")="aydingdan"
rs("cwku")="aycaiwu"
rs("rzku")="aylog"
rs("isjiekou")="1|1|1|1|1|1"
rs("aymail")="111@163.com"
rs("aytel")="13811111111"
rs.update
rs.close
response.Write("管理员账号添加成功")&"<br>"

sql="select * from ayujb" 
rs.open sql,conn,1,3
if not(rs.bof and rs.eof) then
do while not rs.eof
rs("wapbank")=1
rs("aychenalipaywap")=0
rs("aychentenpaywap")=0
rs("saomachengwap")=0
rs("qqsaomachengwap")=0
rs("ayisbankpay")=0
rs("ayisalipay")=0
rs("ayistenpay")=0
rs("ayissaopay")=0
rs("ayisqqpay")=0
rs("ayisbankwap")=0
rs("ayisalipaywap")=0
rs("ayistenpaywap")=0
rs("ayissaopaywap")=0
rs("ayisqqpaywap")=0
rs("tenqitajiekou")=0
rs("tenqitajiekouwap")=0
rs.movenext  
loop
end if
rs.close
response.Write("商家级别添加成功")&"<br>"

sql="select * from aysitesys"  
rs.open sql,conn,1,3 
rs.addnew
rs("adminaddress")="admin"
rs("webname")=webname
rs("weburl")=weburl
rs("zweburl")=weburl
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("gsname")=webname
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("zidingyi1")="云盘，虚假卡密，无效卡密，重复卡密，卡密为联系QQ，商品涉黄，不处理/消极/野蛮/敷衍处理投诉"
rs("zidingyi2")="您的ID将转为失信商家级别，我司有权永久冻结资金！永久停封ID！不予解封！并上报相关部门！"
rs.update
rs.close
response.Write("网站设置添加成功")&"<br><br>"

response.Write("数据库全部添加成功")&"<br>"
response.Write("管理员帐号添加成功 帐号admin  密码123456 独立密码123456")&"<br>"
response.Write "<br>"
response.Write("超级管理员后台登陆地址")&"<a href="&weburl&"admin/>"&weburl&"admin/</a>"


response.end 
end if%>
 

<form name="form1" method="post" action="">
  <table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <td height="30" colspan="3">&nbsp;</td>
    </tr>
    <tr>
      <td width="140" height="30" align="center">平台名称：</td>
      <td width="378"><input name="webname" type="text" id="webname" size="50"></td>
      <td width="482">如：XX发卡</td>
    </tr>
    <tr>
      <td width="140" height="30" align="center">平台网址：</td>
      <td><input name="weburl" type="text" id="weburl" size="50"></td>
      <td>完整网址 如 http://www.xx.com/ 以http://开头  以/结尾</td>
    </tr>
    <tr>
      <td width="140" height="30" align="center">数据库地址:</td>
      <td><input name="SqlDbHost" type="text" id="SqlDbHost" size="50"></td>
      <td>默认localhost,1433</td>
    </tr>
    <tr>
      <td width="140" height="30" align="center">数据库名：</td>
      <td><input name="SqlDbName" type="text" id="SqlDbName" size="50"></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td width="140" height="30" align="center">数据库用户名：</td>
      <td><input name="SqlUserName" type="text" id="SqlUserName" size="50"></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td width="140" height="30" align="center">数据库名密码：</td>
      <td><input name="SqlUserPass" type="text" id="SqlUserPass" size="50"></td>
      <td><input name="act" type="hidden" id="act" value="add"></td>
    </tr>
    <tr>
      <td height="30" colspan="3" align="center"  style="color:#F00">注意：根目录文件global.asa需要有写入权限，根目录updata文件夹需要有写入权限</td>
    </tr>
    <tr>
      <td height="30" colspan="3" align="center"><input type="submit" name="Submit" value=" 安 装 爱 卡 自 动 发 卡 平 台 系 统 (请勿重复点击)"></td>
    </tr>
    <tr style="line-height:25px;">
      <td height="30" colspan="3" align="center"  style="color:#F00">
      <br><br>
      正版爱卡发卡系统 <a style="color:#F00" href="http://www.ik678.cn" target="_blank">www.ik678.cn</a><br>
      爱卡官方发卡平台 <a style="color:#F00" href="http://www.ikpay.cn" target="_blank">www.ikpay.cn</a><br>
      技术支持与购买 QQ：121807184<br>
      在线购买：<a style="color:#F00" href="https://www.ikpay.cn/buy/xuliehao.html" target="_blank">https://www.ikpay.cn/buy/xuliehao.html</a></td>
    </tr>
  </table>
</form>
