videoalliance/.svn/pristine/60/60940dddab9336054ad4748100591451bd7ee2f0.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<properties>
	
	<property name="queryIpInfoAll">
		<![CDATA[
 			select start_ip,start_ip_value,end_ip,end_ip_value,country,area,operator from TB_IP_INFO
		]]>
	</property>
	
	<property name="queryIpInfoAllByKey">
		<![CDATA[
 			select start_ip,start_ip_value,end_ip,end_ip_value,country,area,operator from TB_IP_INFO where floor(start_ip_value/(256*256*256))=#[key]
		]]>
	</property>
	
	
	<property name="queryIpInfo">
		<![CDATA[
 			select start_ip,start_ip_value,end_ip,end_ip_value,country,area,operator from TB_IP_INFO
 			where start_ip_value<=#[ip_value] and end_ip_value>=#[ip_value] 
		]]>
	</property>
	
	<property name="queryCpidForIp">
		<![CDATA[
 			select cpid, netpwd signkey from TB_CP_ACCOUNT_CONFIG where cpid=#[cpid] 
		]]>
	</property>
	
	<property name="queryCpidAllForIp">
		<![CDATA[
 			select cpid,netpwd signkey from TB_CP_ACCOUNT_CONFIG 
		]]>
	</property>
	
	<property name="insertIpInfoNoQuery">
		<![CDATA[
			insert into TB_IP_NO_QUERY (id,cpid,ip) values(#[id],#[cpid],#[ip])
		]]>
	</property>
	
	<property name="insertIpInfoQuery">
		<![CDATA[
			insert into TB_IP_INFO (id,start_ip,start_ip_value,end_ip,end_ip_value,country,area,operator) 
			values(#[id],#[start_ip],#[start_ip_value],#[end_ip],#[end_ip_value],#[country],#[area],#[operator])
		]]>
	</property>

	
</properties>