<?xml version="1.0" encoding="UTF-8"?>
<haxormap>
	<model class="Client" manager="Clients" alias="c" prefix="">
		<primary>
			<id datatype="AutoIncrement(AInt(2097152,SIGNED,Int))" property="id" notNull="true"/>
		</primary>
		<fields>
			<address datatype="AString(200)" property="address"/>
			<name datatype="AString(255)" property="name"/>
		</fields>
	</model>

	<exec methodName="insert"><![CDATA[
		INSERT `client`
		VALUES (::id::,::address::,::name::)
	]]></exec>

	<exec methodName="delete"><![CDATA[
		DELETE `client`
		 WHERE `id`=::id::
	]]></exec>

	<exec methodName="update"><![CDATA[
		UPDATE `client`
		   SET id=::id::, address=::address::, name=::name::
		 WHERE `id`=::id::
	]]></exec>

	<exec methodName="save"><![CDATA[
		UPDATE `client`
		   SET address=::address::, name=::name::
		 WHERE `id`=::id::
	]]></exec>

	<set methodName="select"><![CDATA[
		SELECT `c`.`id`, `c`.`address`, `c`.`name`
		  FROM `client` AS `c`
		 WHERE $$o(`c`.`id`=::id::)
	]]></set>

	<set methodName="search"><![CDATA[
		SELECT `c`.`id`, `c`.`address`, `c`.`name`
		  FROM `client` AS `c`
		 WHERE $$o(`c`.`id` LIKE "%::id::%")
	]]></set>

	<row methodName="get"><![CDATA[
		SELECT `c`.`id`, `c`.`address`, `c`.`name`
		  FROM `client` AS `c`
		 WHERE `c`.`id`=::id::
		 LIMIT 1
	]]></row>

	<row methodName="row"><![CDATA[
		SELECT *
		  FROM `client`
		 WHERE `id`=::id::
		 LIMIT 1
	]]></row>



	<!-- ------------ REMOVED QUERIES ------------ -->
</haxormap>