xPDO schema with aggregate element

59 Posts

Thithi32 Reply #1, 16 years, 2 months ago

I used the following schema for creating a 3rd party table with xPDO:

<?xml version="1.0" encoding="UTF-8"?>
<model package="ga_users" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" phpdoc-package="ga_users" phpdoc-subpackage="model">
  <object class="GaUserSettings" table="gauser_settings" extends="xPDOSimpleObject">
    <field key="warning_user" dbtype="int" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
    <field key="warning_wind" dbtype="int" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
    <field key="warning_rain" dbtype="int" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
    <field key="warning_regular" dbtype="int" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
    <aggregate alias="User" class="modUser" local="user" foreign="id" cardinality="one" owner="foreign" />
  </object>
</model>

Why is my field ’user’ isn’t created in the table gauser_settings?

MODX Staff
10,725 Posts

opengeek Reply #2, 16 years, 2 months ago

Because you didn’t specify a user field in the definition???

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek

59 Posts

Thithi32 Reply #3, 16 years, 2 months ago

Ok I feel confused. I was tired yesterday evening I guess.

So I’ll add something like:

<field key="user" dbtype="int" precision="9" phptype="integer" null="false" default="0" index="pk" />

And it should work.

Thanks rolleyes