<?xml version="1.0" encoding="UTF-8"?>
<!-- 
/*
 * MODX CMS and PHP Application Framework ("MODX")
 * Copyright 2006-2011 by MODX, LLC.
 * All rights reserved.
 *
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU General Public License as published by the Free Software
 * Foundation; either version 2 of the License, or (at your option) any later
 * version.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
 * details.
 *
 * You should have received a copy of the GNU General Public License along with
 * this program; if not, write to the Free Software Foundation, Inc., 59 Temple
 * Place, Suite 330, Boston, MA 02111-1307 USA
 */
 -->
<!-- The following xPDO model represents an object-relational map structure of the MODX db registry package -->
<model package="modx.registry.db" baseClass="xPDOObject" platform="sqlsrv" defaultEngine="MyISAM" phpdoc-package="modx" phpdoc-subpackage="registry.db" version="1.1">
    <object class="modDbRegisterQueue" table="register_queues" extends="xPDOSimpleObject">
        <field key="name" dbtype="nvarchar" precision="255" phptype="string" null="false" index="unique" />
        <field key="options" dbtype="nvarchar" precision="max" phptype="array" />
        <index alias="name" name="name" primary="false" unique="true" type="BTREE">
            <column key="name" length="" collation="A" null="false" />
        </index>
        <composite alias="Topics" class="registry.db.modDbRegisterTopic" local="id" foreign="queue" cardinality="many" owner="local" />
    </object>
    <object class="modDbRegisterTopic" table="register_topics" extends="xPDOSimpleObject">
        <field key="queue" dbtype="int" phptype="integer" null="false" index="fk" />
        <field key="name" dbtype="nvarchar" precision="255" phptype="string" null="false" index="fk" />
        <field key="created" dbtype="datetime" phptype="datetime" null="false" />
        <field key="updated" dbtype="datetime" phptype="timestamp" />
        <field key="options" dbtype="nvarchar" precision="max" phptype="array" />
        <aggregate alias="Queue" class="registry.db.modDbRegisterQueue" local="queue" foreign="id" cardinality="one" owner="foreign" />
        <composite alias="Messages" class="registry.db.modDbRegisterMessage" local="id" foreign="topic" cardinality="many" owner="local" />
        <index alias="queue" name="queue" primary="false" unique="false" type="BTREE">
            <column key="queue" length="" collation="A" null="false" />
        </index>
        <index alias="name" name="name" primary="false" unique="false" type="BTREE">
            <column key="name" length="" collation="A" null="false" />
        </index>
    </object>
    <object class="modDbRegisterMessage" table="register_messages" extends="xPDOObject">
        <field key="topic" dbtype="int" phptype="integer" null="false" index="pk" />
        <field key="id" dbtype="nvarchar" precision="255" phptype="string" null="false" index="pk" />
        <field key="created" dbtype="datetime" phptype="datetime" null="false" index="index" />
        <field key="valid" dbtype="datetime" phptype="datetime" null="false" index="index" />
        <field key="accessed" dbtype="datetime" phptype="timestamp" index="index" />
        <field key="accesses" dbtype="int" phptype="integer" null="false" default="0" index="index" />
        <field key="expires" dbtype="integer" phptype="integer" null="false" default="0" index="index" />
        <field key="payload" dbtype="nvarchar" precision="max" phptype="string" null="false" />
        <field key="kill" dbtype="bit" phptype="boolean" null="false" default="0" />
        <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true" type="BTREE">
            <column key="topic" length="" collation="A" null="false" />
            <column key="id" length="" collation="A" null="false" />
        </index>
        <index alias="created" name="created" primary="false" unique="false" type="BTREE">
            <column key="created" length="" collation="A" null="false" />
        </index>
        <index alias="valid" name="valid" primary="false" unique="false" type="BTREE">
            <column key="valid" length="" collation="A" null="false" />
        </index>
        <index alias="accessed" name="accessed" primary="false" unique="false" type="BTREE">
            <column key="accessed" length="" collation="A" null="false" />
        </index>
        <index alias="accesses" name="accesses" primary="false" unique="false" type="BTREE">
            <column key="accesses" length="" collation="A" null="false" />
        </index>
        <index alias="expires" name="expires" primary="false" unique="false" type="BTREE">
            <column key="expires" length="" collation="A" null="false" />
        </index>
        <aggregate alias="Topic" class="registry.db.modDbRegisterTopic" local="topic" foreign="id" cardinality="one" owner="foreign" />
    </object>
</model>
