<%
'On Error Resume Next
%>
<!--#include file="../conn.asp" -->
<HTML>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<body>
<%

'检查用户访问的权限
'call checkuser(5)

	mysql4="ALTER TABLE member ADD m_tplock bit DEFAULT 0"
	Conn.Execute(mysql4)  
	mysql4="update member set m_tplock=0"
	Conn.Execute(mysql4)  
	response.Write("member Update OK!<br>")
	
	mysql4="ALTER VIEW v_member AS SELECT member.*, website.id AS w_id, website.w_ComName, website.w_Title, website.w_Address, website.w_Mail, website.w_tel, website.w_fax, website.w_zip, website.w_calling, website.w_Contacts FROM member INNER JOIN website ON member.id = website.m_id"
	Conn.Execute(mysql4)  
	response.Write("v_member VIEW Update OK!<br>")

	mysql4="ALTER VIEW v_member_agent AS SELECT member.*, member_1.m_name AS agentname FROM member INNER JOIN member member_1 ON member.m_AgentName = member_1.id"
	Conn.Execute(mysql4)  
	response.Write("v_member v_member_agent Update OK!<br>")

%>
</body>
</head>
</HTML>