'modx', 'version' => '1.1', 'table' => 'membergroup_names', 'extends' => 'modPrincipal', 'tableMeta' => array ( 'engine' => 'InnoDB', ), 'fields' => array ( 'name' => '', 'description' => NULL, 'parent' => 0, 'rank' => 0, 'dashboard' => 1, ), 'fieldMeta' => array ( 'name' => array ( 'dbtype' => 'varchar', 'precision' => '191', 'phptype' => 'string', 'null' => false, 'default' => '', 'index' => 'unique', ), 'description' => array ( 'dbtype' => 'text', 'phptype' => 'string', ), 'parent' => array ( 'dbtype' => 'int', 'precision' => '10', 'attributes' => 'unsigned', 'phptype' => 'integer', 'null' => false, 'default' => 0, 'index' => 'index', ), 'rank' => array ( 'dbtype' => 'int', 'precision' => '10', 'attributes' => 'unsigned', 'phptype' => 'integer', 'null' => false, 'default' => 0, 'index' => 'index', ), 'dashboard' => array ( 'dbtype' => 'int', 'precision' => '10', 'attributes' => 'unsigned', 'phptype' => 'integer', 'null' => false, 'default' => 1, 'index' => 'index', ), ), 'indexes' => array ( 'name' => array ( 'alias' => 'name', 'primary' => false, 'unique' => true, 'type' => 'BTREE', 'columns' => array ( 'name' => array ( 'length' => '', 'collation' => 'A', 'null' => false, ), ), ), 'parent' => array ( 'alias' => 'parent', 'primary' => false, 'unique' => false, 'type' => 'BTREE', 'columns' => array ( 'parent' => array ( 'length' => '', 'collation' => 'A', 'null' => false, ), ), ), 'rank' => array ( 'alias' => 'rank', 'primary' => false, 'unique' => false, 'type' => 'BTREE', 'columns' => array ( 'rank' => array ( 'length' => '', 'collation' => 'A', 'null' => false, ), ), ), 'dashboard' => array ( 'alias' => 'dashboard', 'primary' => false, 'unique' => false, 'type' => 'BTREE', 'columns' => array ( 'dashboard' => array ( 'length' => '', 'collation' => 'A', 'null' => false, ), ), ), ), 'composites' => array ( 'UserGroupMembers' => array ( 'class' => 'modUserGroupMember', 'local' => 'id', 'foreign' => 'user_group', 'cardinality' => 'many', 'owner' => 'local', ), 'FormCustomizationProfiles' => array ( 'class' => 'modFormCustomizationProfileUserGroup', 'local' => 'id', 'foreign' => 'usergroup', 'cardinality' => 'many', 'owner' => 'local', ), ), 'aggregates' => array ( 'Parent' => array ( 'class' => 'modUserGroup', 'local' => 'parent', 'foreign' => 'id', 'cardinality' => 'one', 'owner' => 'foreign', ), 'Children' => array ( 'class' => 'modUserGroup', 'local' => 'id', 'foreign' => 'parent', 'cardinality' => 'many', 'owner' => 'local', ), 'Dashboard' => array ( 'class' => 'modDashboard', 'local' => 'dashboard', 'foreign' => 'id', 'cardinality' => 'one', 'owner' => 'foreign', ), ), );