modusergroup.map.inc.php 3.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173
  1. <?php
  2. /**
  3. * @package modx
  4. * @subpackage sqlsrv
  5. */
  6. $xpdo_meta_map['modUserGroup']= array (
  7. 'package' => 'modx',
  8. 'version' => '1.1',
  9. 'table' => 'membergroup_names',
  10. 'extends' => 'modPrincipal',
  11. 'fields' =>
  12. array (
  13. 'name' => '',
  14. 'description' => NULL,
  15. 'parent' => 0,
  16. 'rank' => 0,
  17. 'dashboard' => 1,
  18. ),
  19. 'fieldMeta' =>
  20. array (
  21. 'name' =>
  22. array (
  23. 'dbtype' => 'nvarchar',
  24. 'precision' => '255',
  25. 'phptype' => 'string',
  26. 'null' => false,
  27. 'default' => '',
  28. 'index' => 'unique',
  29. ),
  30. 'description' =>
  31. array (
  32. 'dbtype' => 'text',
  33. 'phptype' => 'string',
  34. ),
  35. 'parent' =>
  36. array (
  37. 'dbtype' => 'int',
  38. 'phptype' => 'integer',
  39. 'null' => false,
  40. 'default' => 0,
  41. 'index' => 'index',
  42. ),
  43. 'rank' =>
  44. array (
  45. 'dbtype' => 'int',
  46. 'phptype' => 'integer',
  47. 'null' => false,
  48. 'default' => 0,
  49. 'index' => 'index',
  50. ),
  51. 'dashboard' =>
  52. array (
  53. 'dbtype' => 'int',
  54. 'phptype' => 'integer',
  55. 'null' => false,
  56. 'default' => 1,
  57. 'index' => 'index',
  58. ),
  59. ),
  60. 'indexes' =>
  61. array (
  62. 'name' =>
  63. array (
  64. 'alias' => 'name',
  65. 'primary' => false,
  66. 'unique' => true,
  67. 'type' => 'BTREE',
  68. 'columns' =>
  69. array (
  70. 'name' =>
  71. array (
  72. 'length' => '',
  73. 'collation' => 'A',
  74. 'null' => false,
  75. ),
  76. ),
  77. ),
  78. 'parent' =>
  79. array (
  80. 'alias' => 'parent',
  81. 'primary' => false,
  82. 'unique' => false,
  83. 'type' => 'BTREE',
  84. 'columns' =>
  85. array (
  86. 'parent' =>
  87. array (
  88. 'length' => '',
  89. 'collation' => 'A',
  90. 'null' => false,
  91. ),
  92. ),
  93. ),
  94. 'rank' =>
  95. array (
  96. 'alias' => 'rank',
  97. 'primary' => false,
  98. 'unique' => false,
  99. 'type' => 'BTREE',
  100. 'columns' =>
  101. array (
  102. 'rank' =>
  103. array (
  104. 'length' => '',
  105. 'collation' => 'A',
  106. 'null' => false,
  107. ),
  108. ),
  109. ),
  110. 'dashboard' =>
  111. array (
  112. 'alias' => 'dashboard',
  113. 'primary' => false,
  114. 'unique' => false,
  115. 'type' => 'BTREE',
  116. 'columns' =>
  117. array (
  118. 'dashboard' =>
  119. array (
  120. 'length' => '',
  121. 'collation' => 'A',
  122. 'null' => false,
  123. ),
  124. ),
  125. ),
  126. ),
  127. 'composites' =>
  128. array (
  129. 'UserGroupMembers' =>
  130. array (
  131. 'class' => 'modUserGroupMember',
  132. 'local' => 'id',
  133. 'foreign' => 'user_group',
  134. 'cardinality' => 'many',
  135. 'owner' => 'local',
  136. ),
  137. 'FormCustomizationProfiles' =>
  138. array (
  139. 'class' => 'modFormCustomizationProfileUserGroup',
  140. 'local' => 'id',
  141. 'foreign' => 'usergroup',
  142. 'cardinality' => 'many',
  143. 'owner' => 'local',
  144. ),
  145. ),
  146. 'aggregates' =>
  147. array (
  148. 'Parent' =>
  149. array (
  150. 'class' => 'modUserGroup',
  151. 'local' => 'parent',
  152. 'foreign' => 'id',
  153. 'cardinality' => 'one',
  154. 'owner' => 'foreign',
  155. ),
  156. 'Children' =>
  157. array (
  158. 'class' => 'modUserGroup',
  159. 'local' => 'id',
  160. 'foreign' => 'parent',
  161. 'cardinality' => 'many',
  162. 'owner' => 'local',
  163. ),
  164. 'Dashboard' =>
  165. array (
  166. 'class' => 'modDashboard',
  167. 'local' => 'dashboard',
  168. 'foreign' => 'id',
  169. 'cardinality' => 'one',
  170. 'owner' => 'foreign',
  171. ),
  172. ),
  173. );