<?xml version="1.0" encoding="UTF-8"?>
<haxormap>
	<model class="Order" manager="Orders" alias="o" prefix="">
		<primary>
			<id datatype="AutoIncrement(AInt(2097152,SIGNED,Int))" property="id" notNull="true"/>
			<clientid datatype="AInt(2097152,SIGNED,Int)" property="client" notNull="true"/>
		</primary>
		<fields>
			<date datatype="ADate" property="date"/>
			<referrer_clientid datatype="AInt(2097152,SIGNED,Int)" property="referrer" notNull="false"/>
		</fields>
	</model>

	<exec methodName="insert"><![CDATA[
		INSERT `order`
		VALUES (::id::,::client.id::,::date::,::referrer.id::)
	]]></exec>

	<exec methodName="delete"><![CDATA[
		DELETE `order`
		 WHERE `id`=::id:: AND `clientid`=::client.id::
	]]></exec>

	<exec methodName="update"><![CDATA[
		UPDATE `order`
		   SET id=::id::, clientid=::client.id::, date=::date::, referrer_clientid=::referrer.id::
		 WHERE `id`=::id:: AND `clientid`=::client.id::
	]]></exec>

	<exec methodName="save"><![CDATA[
		UPDATE `order`
		   SET date=::date::, referrer_clientid=::referrer.id::
		 WHERE `id`=::id:: AND `clientid`=::client.id::
	]]></exec>

	<set methodName="select"><![CDATA[
		SELECT `o`.`id`, `o`.`clientid` AS `_c_id`, `o`.`date`, `o`.`referrer_clientid` AS `_c0_id`, `c`.`address` AS `_c_address`, `c`.`name` AS `_c_name`, `c0`.`address` AS `_c0_address`, `c0`.`name` AS `_c0_name`
		  FROM `order` AS `o`
		  LEFT JOIN `client` AS `c` ON `o`.`clientid`=`c`.`id`
		  LEFT JOIN `client` AS `c0` ON `o`.`referrer_clientid`=`c0`.`id`
		 WHERE $$o(`o`.`id`=::id:: AND) $$o(`c`.`clientid`=::client.id::)
	]]></set>

	<set methodName="search"><![CDATA[
		SELECT `o`.`id`, `o`.`clientid` AS `_c_id`, `o`.`date`, `o`.`referrer_clientid` AS `_c0_id`, `c`.`address` AS `_c_address`, `c`.`name` AS `_c_name`, `c0`.`address` AS `_c0_address`, `c0`.`name` AS `_c0_name`
		  FROM `order` AS `o`
		  LEFT JOIN `client` AS `c` ON `o`.`clientid`=`c`.`id`
		  LEFT JOIN `client` AS `c0` ON `o`.`referrer_clientid`=`c0`.`id`
		 WHERE $$o(`o`.`id` LIKE "%::id::%" AND) $$o(`c`.`clientid` LIKE "%::client.id::%")
	]]></set>

	<row methodName="get"><![CDATA[
		SELECT `o`.`id`, `o`.`clientid` AS `_c_id`, `o`.`date`, `o`.`referrer_clientid` AS `_c0_id`, `c`.`address` AS `_c_address`, `c`.`name` AS `_c_name`, `c0`.`address` AS `_c0_address`, `c0`.`name` AS `_c0_name`
		  FROM `order` AS `o`
		  LEFT JOIN `client` AS `c` ON `o`.`clientid`=`c`.`id`
		  LEFT JOIN `client` AS `c0` ON `o`.`referrer_clientid`=`c0`.`id`
		 WHERE `o`.`id`=::id:: AND `c`.`clientid`=::client.id::
		 LIMIT 1
	]]></row>

	<row methodName="row"><![CDATA[
		SELECT *
		  FROM `order`
		 WHERE `id`=::id:: AND `clientid`=::client.id::
		 LIMIT 1
	]]></row>



	<!-- ------------ REMOVED QUERIES ------------ -->
</haxormap>