Advertisement
Guest User

mediaList xPDO schema

a guest
Oct 3rd, 2012
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 2.33 KB | None | 0 0
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <model package="mediaList" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.1">
  3.     <object class="mediaList" table="migx_medialist" extends="xPDOSimpleObject" >
  4.     <field key="title" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
  5.     <field key="description" dbtype="text" phptype="string" index="fulltext" />
  6.     <field key="resource_id" dbtype="int" precision="11" phptype="integer" null="false" default="0" />
  7.     <field key="resource_ids" dbtype="text" phptype="string" null="false" default="" />
  8.     <field key="button_text" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
  9.     <field key="button_url" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
  10.     <field key="extended" dbtype="text" phptype="json" null="false" default="" />
  11.     <field key="pos" dbtype="int" precision="10" phptype="integer" null="false" default="0" />        
  12.        
  13.     <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
  14.     <field key="createdby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
  15.     <field key="createdon" dbtype="datetime" phptype="datetime" null="false" />
  16.     <field key="editedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
  17.     <field key="editedon" dbtype="datetime" phptype="datetime" null="false" />
  18.     <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
  19.     <field key="deletedon" dbtype="datetime" phptype="datetime" null="false" />
  20.     <field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
  21.     <field key="publishedon" dbtype="datetime" phptype="datetime" null="false" />
  22.     <field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
  23.  
  24.     <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
  25.         <column key="id" collation="A" null="false" />
  26.     </index>
  27.        
  28.         <aggregate alias="Resource" class="modResource" local="resource_id" foreign="id" cardinality="one" owner="foreign" />
  29.         <aggregate alias="Creator" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign" />
  30.     </object>
  31.    
  32. </model>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement