core/model/schema/modx.registry.db.mysql.schema.xml
<?xml version="1.0" encoding="UTF-8"?>
<!--
/*
* This file is part of MODX Revolution.
*
* Copyright (c) MODX, LLC. All Rights Reserved.
*
* For complete copyright and license information, see the COPYRIGHT and LICENSE
* files found in the top-level directory of this distribution.
*/
-->
<!-- The following xPDO model represents an object-relational map structure of the MODX db registry package -->
<model package="modx.registry.db" baseClass="xPDOObject" platform="mysql" defaultEngine="InnoDB" phpdoc-package="modx" phpdoc-subpackage="registry.db" version="1.1">
<object class="modDbRegisterQueue" table="register_queues" extends="xPDOSimpleObject">
<field key="name" dbtype="varchar" precision="191" phptype="string" null="false" index="unique" />
<field key="options" dbtype="mediumtext" 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="integer" precision="10" attributes="unsigned" phptype="integer" null="false" index="fk" />
<field key="name" dbtype="varchar" precision="191" phptype="string" null="false" index="fk" />
<field key="created" dbtype="datetime" phptype="datetime" null="false" />
<field key="updated" dbtype="timestamp" phptype="timestamp" attributes="ON UPDATE CURRENT_TIMESTAMP" />
<field key="options" dbtype="mediumtext" 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="integer" precision="10" attributes="unsigned" phptype="integer" null="false" index="pk" />
<field key="id" dbtype="varchar" precision="191" 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="timestamp" phptype="timestamp" attributes="ON UPDATE CURRENT_TIMESTAMP" index="index" />
<field key="accesses" dbtype="integer" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" index="index" />
<field key="expires" dbtype="integer" precision="20" phptype="integer" null="false" default="0" index="index" />
<field key="payload" dbtype="mediumtext" phptype="string" null="false" />
<field key="kill" dbtype="tinyint" precision="1" attributes="unsigned" 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>