<!--#include virtual="/config/config.asp" -->
<%
conn.open constr

If isdbsql Then
		conn.execute("truncate table [_order]")
		conn.execute("truncate table [actionlist]")
		conn.execute("truncate table [ActionLog]")
		conn.execute("truncate table [adjustPrice]")
		conn.execute("truncate table [allBinds]")
		conn.execute("truncate table [APIuser_list]")
		conn.execute("truncate table [app_traffic]")
		conn.execute("truncate table [arealist]")
		conn.execute("truncate table [areatypelist]")
		conn.execute("truncate table [billlist]")
		conn.execute("truncate table [cache_app]")
		conn.execute("truncate table [countlist]")
		conn.execute("truncate table [databaselist]")
		conn.execute("truncate table [domainlist]")
		conn.execute("truncate table [domainTemp]")
		conn.execute("truncate table [domaintrans]")
		conn.execute("truncate table [Event_logs]")
		conn.execute("truncate table [FaPiao]")
		conn.execute("truncate table [Free]")
		conn.execute("truncate table [ftpforbid]")
		conn.execute("truncate table [FUser]")
		conn.execute("truncate table [GroupInfo]")
		conn.execute("truncate table [groupUser]")
		conn.execute("truncate table [HostRental]")
		conn.execute("truncate table [lockuser]")
		conn.execute("truncate table [maillog]")
		conn.execute("truncate table [mailsitelist]")
		conn.execute("truncate table [orderlist]")
		conn.execute("truncate table [OurMoney]")
		conn.execute("truncate table [PayEnd]")
		conn.execute("truncate table [PreDomain]")
		conn.execute("truncate table [PreHost]")
		conn.execute("truncate table [Pricelevellist]")
		conn.execute("truncate table [question]")
		conn.execute("truncate table [RegisterDomainPrice]")
		conn.execute("truncate table [registermap]")
		conn.execute("truncate table [registername]")
		conn.execute("truncate table [renewcomprice]")
		conn.execute("truncate table [Ring]")
		conn.execute("truncate table [searchlist]")
		conn.execute("truncate table [server_type]")
		conn.execute("truncate table [ServerActiolog]")
		conn.execute("truncate table [serverroomlist]")
		conn.execute("truncate table [ShopCart]")
		conn.execute("truncate table [SMSback]")
		conn.execute("truncate table [Unprocess]")
		conn.execute("truncate table [UserDetail]")
		conn.execute("truncate table [UserPrice]")
		conn.execute("truncate table [vcp_record]")
		conn.execute("truncate table [vcp_settlelist]")
		conn.execute("truncate table [vhhostlist]")
		conn.execute("truncate table [vps_agentprice]")
		conn.execute("truncate table [vps_price]")
		conn.execute("truncate table [web_admin]")
Else
		conn.execute("delete from [_order]")
		conn.execute("delete from [actionlist]")
		conn.execute("delete from [ActionLog]")
		conn.execute("delete from [adjustPrice]")
		conn.execute("delete from [allBinds]")
		conn.execute("delete from [APIuser_list]")
		conn.execute("delete from [app_traffic]")
		conn.execute("delete from [arealist]")
		conn.execute("delete from [areatypelist]")
		conn.execute("delete from [billlist]")
		conn.execute("delete from [cache_app]")
		conn.execute("delete from [countlist]")
		conn.execute("delete from [databaselist]")
		conn.execute("delete from [domainlist]")
		conn.execute("delete from [domainTemp]")
		conn.execute("delete from [domaintrans]")
		conn.execute("delete from [Event_logs]")
		conn.execute("delete from [FaPiao]")
		conn.execute("delete from [Free]")
		conn.execute("delete from [ftpforbid]")
		conn.execute("delete from [FUser]")
		conn.execute("delete from [GroupInfo]")
		conn.execute("delete from [groupUser]")
		conn.execute("delete from [HostRental]")
		conn.execute("delete from [lockuser]")
		conn.execute("delete from [maillog]")
		conn.execute("delete from [mailsitelist]")
		conn.execute("delete from [orderlist]")
		conn.execute("delete from [OurMoney]")
		conn.execute("delete from [PayEnd]")
		conn.execute("delete from [PreDomain]")
		conn.execute("delete from [PreHost]")
		conn.execute("delete from [Pricelevellist]")
		conn.execute("delete from [question]")
		conn.execute("delete from [RegisterDomainPrice]")
		conn.execute("delete from [registermap]")
		conn.execute("delete from [registername]")
		conn.execute("delete from [renewcomprice]")
		conn.execute("delete from [Ring]")
		conn.execute("delete from [searchlist]")
		conn.execute("delete from [server_type]")
		conn.execute("delete from [ServerActiolog]")
		conn.execute("delete from [serverroomlist]")
		conn.execute("delete from [ShopCart]")
		conn.execute("delete from [SMSback]")
		conn.execute("delete from [Unprocess]")
		conn.execute("delete from [UserDetail]")
		conn.execute("delete from [UserPrice]")
		conn.execute("delete from [vcp_record]")
		conn.execute("delete from [vcp_settlelist]")
		conn.execute("delete from [vhhostlist]")
		conn.execute("delete from [vps_agentprice]")
		conn.execute("delete from [vps_price]")
		conn.execute("delete from [web_admin]")

		'方象賠腎
		conn.execute("ALTER TABLE [_order] ALTER COLUMN [REALorder_ID] COUNTER (1, 1)")
conn.execute("ALTER TABLE [actionlist] ALTER COLUMN [a_sysid] COUNTER (1, 1)")
conn.execute("ALTER TABLE [ActionLog] ALTER COLUMN [id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [adjustPrice] ALTER COLUMN [sysid] COUNTER (1, 1)")
conn.execute("ALTER TABLE [allBinds] ALTER COLUMN [s_sysid] COUNTER (1, 1)")
conn.execute("ALTER TABLE [APIuser_list] ALTER COLUMN [a_sysid] COUNTER (1, 1)")
conn.execute("ALTER TABLE [app_traffic] ALTER COLUMN [sid] COUNTER (1, 1)")
conn.execute("ALTER TABLE [arealist] ALTER COLUMN [sysid] COUNTER (1, 1)")
conn.execute("ALTER TABLE [areatypelist] ALTER COLUMN [areatypeid] COUNTER (1, 1)")
conn.execute("ALTER TABLE [billlist] ALTER COLUMN [b_sysid] COUNTER (1, 1)")
'conn.execute("ALTER TABLE [cache_app] ALTER COLUMN [ID] COUNTER (1, 1)")
conn.execute("ALTER TABLE [countlist] ALTER COLUMN [sysid] COUNTER (1, 1)")
conn.execute("ALTER TABLE [databaselist] ALTER COLUMN [dbsysid] COUNTER (1, 1)")
conn.execute("ALTER TABLE [domainlist] ALTER COLUMN [d_id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [domainTemp] ALTER COLUMN [id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [domaintrans] ALTER COLUMN [expid] COUNTER (1, 1)")
conn.execute("ALTER TABLE [Event_logs] ALTER COLUMN [e_sysid] COUNTER (1, 1)")
conn.execute("ALTER TABLE [FaPiao] ALTER COLUMN [f_id] COUNTER (1, 1)")
'conn.execute("ALTER TABLE [Free] ALTER COLUMN [f_id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [ftpforbid] ALTER COLUMN [sysid] COUNTER (1, 1)")
conn.execute("ALTER TABLE [FUser] ALTER COLUMN [id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [GroupInfo] ALTER COLUMN [PK_ID] COUNTER (1, 1)")
conn.execute("ALTER TABLE [groupUser] ALTER COLUMN [GID] COUNTER (1, 1)")
conn.execute("ALTER TABLE [HostRental] ALTER COLUMN [id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [lockuser] ALTER COLUMN [l_id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [maillog] ALTER COLUMN [id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [mailsitelist] ALTER COLUMN [m_sysid] COUNTER (1, 1)")
'conn.execute("ALTER TABLE [orderlist] ALTER COLUMN o_id COUNTER (1, 1)")
conn.execute("ALTER TABLE [OurMoney] ALTER COLUMN [id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [PayEnd] ALTER COLUMN [ID] COUNTER (1, 1)")
conn.execute("ALTER TABLE [PreDomain] ALTER COLUMN [d_id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [PreHost] ALTER COLUMN [id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [Pricelevellist] ALTER COLUMN [p_id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [question] ALTER COLUMN [q_id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [RegisterDomainPrice] ALTER COLUMN [RegisterDomainPriceId] COUNTER (1, 1)")
'conn.execute("ALTER TABLE [registermap] ALTER COLUMN [id] COUNTER (1, 1)")
'conn.execute("ALTER TABLE [registername] ALTER COLUMN [id] COUNTER (1, 1)")
 
conn.execute("ALTER TABLE [Ring] ALTER COLUMN [ring_id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [searchlist] ALTER COLUMN [id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [server_type] ALTER COLUMN [server_type_id] COUNTER (1, 1)")
'conn.execute("ALTER TABLE [ServerActiolog] ALTER COLUMN [sysid] COUNTER (1, 1)")
'conn.execute("ALTER TABLE [serverroomlist] ALTER COLUMN [r_id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [ShopCart] ALTER COLUMN [cartID] COUNTER (1, 1)")
conn.execute("ALTER TABLE [SMSback] ALTER COLUMN [id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [Unprocess] ALTER COLUMN [id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [UserDetail] ALTER COLUMN [u_id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [UserPrice] ALTER COLUMN [UserPriceId] COUNTER (1, 1)")
conn.execute("ALTER TABLE [vcp_record] ALTER COLUMN [v_id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [vcp_settlelist] ALTER COLUMN [s_id] COUNTER (1, 1)")
conn.execute("ALTER TABLE [vhhostlist] ALTER COLUMN [s_sysid] COUNTER (1, 1)")
'conn.execute("ALTER TABLE [vps_agentprice] ALTER COLUMN [a_sysid] COUNTER (1, 1)")
'conn.execute("ALTER TABLE [vps_price] ALTER COLUMN [v_sysid] COUNTER (1, 1)")
'conn.execute("ALTER TABLE [web_admin] ALTER COLUMN [id] COUNTER (1, 1)")

End if
%>