app_config.php 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357
  1. <?php
  2. //application details
  3. $apps[$x]['name'] = "User Manager";
  4. $apps[$x]['uuid'] = "112124b3-95c2-5352-7e9d-d14c0b88f207";
  5. $apps[$x]['category'] = "Core";
  6. $apps[$x]['subcategory'] = "";
  7. $apps[$x]['version'] = "1.0";
  8. $apps[$x]['license'] = "Mozilla Public License 1.1";
  9. $apps[$x]['url'] = "http://www.fusionpbx.com";
  10. $apps[$x]['description']['en-us'] = "Add, edit, delete, and search for users.";
  11. $apps[$x]['description']['ar-eg'] = "";
  12. $apps[$x]['description']['de-at'] = "Benutzer hinzufügen, bearbeiten, löschen und suchen.";
  13. $apps[$x]['description']['de-ch'] = "";
  14. $apps[$x]['description']['de-de'] = "Benutzer hinzufügen, bearbeiten, löschen und suchen.";
  15. $apps[$x]['description']['es-cl'] = "Agregar, Editar, Eliminar y Buscar Usuarios.";
  16. $apps[$x]['description']['es-mx'] = "Agregar, Editar, Eliminar y Buscar Usuarios.";
  17. $apps[$x]['description']['fr-ca'] = "Ajouter, Editer, Supprimer et Chercher des Utilisateurs";
  18. $apps[$x]['description']['fr-fr'] = "Ajouter, Editer, Supprimer et Chercher des Utilisateurs";
  19. $apps[$x]['description']['he-il'] = "";
  20. $apps[$x]['description']['it-it'] = "";
  21. $apps[$x]['description']['nl-nl'] = "";
  22. $apps[$x]['description']['pl-pl'] = "";
  23. $apps[$x]['description']['pt-br'] = "Adicionar, editar, apagar e pesquisar usuários.";
  24. $apps[$x]['description']['pt-pt'] = "Adicionar, editar, apagar e pesquisa pelos utilizadores.";
  25. $apps[$x]['description']['ro-ro'] = "";
  26. $apps[$x]['description']['ru-ru'] = "Добавление, редактирование, удаление и поиск пользователей";
  27. $apps[$x]['description']['sv-se'] = "";
  28. $apps[$x]['description']['uk-ua'] = "";
  29. //permission details
  30. $y=0;
  31. $apps[$x]['permissions'][$y]['name'] = "user_view";
  32. $apps[$x]['permissions'][$y]['menu']['uuid'] = "0d57cc1e-1874-47b9-7ddd-fe1f57cec99b";
  33. $apps[$x]['permissions'][$y]['groups'][] = "admin";
  34. $apps[$x]['permissions'][$y]['groups'][] = "superadmin";
  35. $y++;
  36. $apps[$x]['permissions'][$y]['name'] = "user_add";
  37. $apps[$x]['permissions'][$y]['groups'][] = "admin";
  38. $apps[$x]['permissions'][$y]['groups'][] = "superadmin";
  39. $y++;
  40. $apps[$x]['permissions'][$y]['name'] = "user_edit";
  41. $apps[$x]['permissions'][$y]['groups'][] = "admin";
  42. $apps[$x]['permissions'][$y]['groups'][] = "superadmin";
  43. $y++;
  44. $apps[$x]['permissions'][$y]['name'] = "user_delete";
  45. $apps[$x]['permissions'][$y]['groups'][] = "admin";
  46. $apps[$x]['permissions'][$y]['groups'][] = "superadmin";
  47. $y++;
  48. $apps[$x]['permissions'][$y]['name'] = "user_groups";
  49. $apps[$x]['permissions'][$y]['groups'][] = "admin";
  50. $apps[$x]['permissions'][$y]['groups'][] = "superadmin";
  51. $y++;
  52. $apps[$x]['permissions'][$y]['name'] = "user_domain";
  53. $apps[$x]['permissions'][$y]['groups'][] = "superadmin";
  54. $y++;
  55. $apps[$x]['permissions'][$y]['name'] = "user_all";
  56. $apps[$x]['permissions'][$y]['groups'][] = "superadmin";
  57. $y++;
  58. $apps[$x]['permissions'][$y]['name'] = "user_import";
  59. $apps[$x]['permissions'][$y]['groups'][] = "superadmin";
  60. $y++;
  61. $apps[$x]['permissions'][$y]['name'] = "user_group_view";
  62. $apps[$x]['permissions'][$y]['menu']['uuid'] = "3b4acc6d-827b-f537-bf21-0093d94ffec7";
  63. $apps[$x]['permissions'][$y]['groups'][] = "superadmin";
  64. $apps[$x]['permissions'][$y]['groups'][] = "admin";
  65. $y++;
  66. $apps[$x]['permissions'][$y]['name'] = "user_group_add";
  67. $apps[$x]['permissions'][$y]['groups'][] = "superadmin";
  68. $apps[$x]['permissions'][$y]['groups'][] = "admin";
  69. $y++;
  70. $apps[$x]['permissions'][$y]['name'] = "user_group_edit";
  71. $apps[$x]['permissions'][$y]['groups'][] = "superadmin";
  72. $apps[$x]['permissions'][$y]['groups'][] = "admin";
  73. $y++;
  74. $apps[$x]['permissions'][$y]['name'] = "user_group_delete";
  75. $apps[$x]['permissions'][$y]['groups'][] = "superadmin";
  76. $apps[$x]['permissions'][$y]['groups'][] = "admin";
  77. $y++;
  78. $apps[$x]['permissions'][$y]['name'] = "api_key";
  79. $apps[$x]['permissions'][$y]['groups'][] = "superadmin";
  80. $apps[$x]['permissions'][$y]['groups'][] = "admin";
  81. $y++;
  82. $apps[$x]['permissions'][$y]['name'] = "view_users";
  83. $apps[$x]['permissions'][$y]['groups'][] = "superadmin";
  84. //default settings
  85. $y=0;
  86. $apps[$x]['default_settings'][$y]['default_setting_uuid'] = "38cf53d2-5fae-43ed-be93-33b0a5cc1c38";
  87. $apps[$x]['default_settings'][$y]['default_setting_category'] = "users";
  88. $apps[$x]['default_settings'][$y]['default_setting_subcategory'] = "unique";
  89. $apps[$x]['default_settings'][$y]['default_setting_name'] = "text";
  90. $apps[$x]['default_settings'][$y]['default_setting_value'] = "global";
  91. $apps[$x]['default_settings'][$y]['default_setting_enabled'] = "false";
  92. $apps[$x]['default_settings'][$y]['default_setting_description'] = "";
  93. $y++;
  94. $apps[$x]['default_settings'][$y]['default_setting_uuid'] = "e3f5f4cd-0f17-428a-b788-2f2db91b6dc7";
  95. $apps[$x]['default_settings'][$y]['default_setting_category'] = "users";
  96. $apps[$x]['default_settings'][$y]['default_setting_subcategory'] = "password_length";
  97. $apps[$x]['default_settings'][$y]['default_setting_name'] = "numeric";
  98. $apps[$x]['default_settings'][$y]['default_setting_value'] = "10";
  99. $apps[$x]['default_settings'][$y]['default_setting_enabled'] = "true";
  100. $apps[$x]['default_settings'][$y]['default_setting_description'] = "The default length of characters in a user password.";
  101. $y++;
  102. $apps[$x]['default_settings'][$y]['default_setting_uuid'] = "51c106d9-9aba-436b-b9b1-ff4937cef706";
  103. $apps[$x]['default_settings'][$y]['default_setting_category'] = "users";
  104. $apps[$x]['default_settings'][$y]['default_setting_subcategory'] = "password_number";
  105. $apps[$x]['default_settings'][$y]['default_setting_name'] = "boolean";
  106. $apps[$x]['default_settings'][$y]['default_setting_value'] = "true";
  107. $apps[$x]['default_settings'][$y]['default_setting_enabled'] = "true";
  108. $apps[$x]['default_settings'][$y]['default_setting_description'] = "Set whether to require at least one number in user passwords.";
  109. $y++;
  110. $apps[$x]['default_settings'][$y]['default_setting_uuid'] = "f0e601b9-b619-4247-9624-c33605e96fd8";
  111. $apps[$x]['default_settings'][$y]['default_setting_category'] = "users";
  112. $apps[$x]['default_settings'][$y]['default_setting_subcategory'] = "password_lowercase";
  113. $apps[$x]['default_settings'][$y]['default_setting_name'] = "boolean";
  114. $apps[$x]['default_settings'][$y]['default_setting_value'] = "true";
  115. $apps[$x]['default_settings'][$y]['default_setting_enabled'] = "true";
  116. $apps[$x]['default_settings'][$y]['default_setting_description'] = "Set whether to require at least one lowecase letter in user passwords.";
  117. $y++;
  118. $apps[$x]['default_settings'][$y]['default_setting_uuid'] = "973b6773-dac0-4041-844e-71c48fc9542c";
  119. $apps[$x]['default_settings'][$y]['default_setting_category'] = "users";
  120. $apps[$x]['default_settings'][$y]['default_setting_subcategory'] = "password_uppercase";
  121. $apps[$x]['default_settings'][$y]['default_setting_name'] = "boolean";
  122. $apps[$x]['default_settings'][$y]['default_setting_value'] = "true";
  123. $apps[$x]['default_settings'][$y]['default_setting_enabled'] = "true";
  124. $apps[$x]['default_settings'][$y]['default_setting_description'] = "Set whether to require at least one uppercase letter in user passwords.";
  125. $y++;
  126. $apps[$x]['default_settings'][$y]['default_setting_uuid'] = "a6b6d9cc-fb25-4bc3-ad85-fa530d9b334d";
  127. $apps[$x]['default_settings'][$y]['default_setting_category'] = "users";
  128. $apps[$x]['default_settings'][$y]['default_setting_subcategory'] = "password_special";
  129. $apps[$x]['default_settings'][$y]['default_setting_name'] = "boolean";
  130. $apps[$x]['default_settings'][$y]['default_setting_value'] = "true";
  131. $apps[$x]['default_settings'][$y]['default_setting_enabled'] = "true";
  132. $apps[$x]['default_settings'][$y]['default_setting_description'] = "Set whether to require at least one special character in user passwords.";
  133. $y++;
  134. $apps[$x]['default_settings'][$y]['default_setting_uuid'] = "727977e5-8b5f-4d80-af37-41fd3a4a1859";
  135. $apps[$x]['default_settings'][$y]['default_setting_category'] = "limit";
  136. $apps[$x]['default_settings'][$y]['default_setting_subcategory'] = "users";
  137. $apps[$x]['default_settings'][$y]['default_setting_name'] = "numeric";
  138. $apps[$x]['default_settings'][$y]['default_setting_value'] = "3";
  139. $apps[$x]['default_settings'][$y]['default_setting_enabled'] = "false";
  140. $apps[$x]['default_settings'][$y]['default_setting_description'] = "";
  141. //schema details
  142. $y=0;
  143. $apps[$x]['db'][$y]['table']['name'] = "v_users";
  144. $apps[$x]['db'][$y]['table']['parent'] = "";
  145. $z=0;
  146. $apps[$x]['db'][$y]['fields'][$z]['name'] = "user_uuid";
  147. $apps[$x]['db'][$y]['fields'][$z]['type']['pgsql'] = "uuid";
  148. $apps[$x]['db'][$y]['fields'][$z]['type']['sqlite'] = "text";
  149. $apps[$x]['db'][$y]['fields'][$z]['type']['mysql'] = "char(36)";
  150. $apps[$x]['db'][$y]['fields'][$z]['key']['type'] = "primary";
  151. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  152. $z++;
  153. $apps[$x]['db'][$y]['fields'][$z]['name'] = "id";
  154. $apps[$x]['db'][$y]['fields'][$z]['type']['pgsql'] = "serial";
  155. $apps[$x]['db'][$y]['fields'][$z]['type']['sqlite'] = "integer";
  156. $apps[$x]['db'][$y]['fields'][$z]['type']['mysql'] = "INT NOT NULL AUTO_INCREMENT";
  157. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  158. $apps[$x]['db'][$y]['fields'][$z]['deprecated'] = "true";
  159. $z++;
  160. $apps[$x]['db'][$y]['fields'][$z]['name'] = "domain_uuid";
  161. $apps[$x]['db'][$y]['fields'][$z]['type']['pgsql'] = "uuid";
  162. $apps[$x]['db'][$y]['fields'][$z]['type']['sqlite'] = "text";
  163. $apps[$x]['db'][$y]['fields'][$z]['type']['mysql'] = "char(36)";
  164. $apps[$x]['db'][$y]['fields'][$z]['key']['type'] = "foreign";
  165. $apps[$x]['db'][$y]['fields'][$z]['key']['reference']['table'] = "v_domains";
  166. $apps[$x]['db'][$y]['fields'][$z]['key']['reference']['field'] = "domain_uuid";
  167. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  168. $z++;
  169. $apps[$x]['db'][$y]['fields'][$z]['name'] = "v_id";
  170. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  171. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  172. $apps[$x]['db'][$y]['fields'][$z]['deprecated'] = "true";
  173. $z++;
  174. $apps[$x]['db'][$y]['fields'][$z]['name'] = "username";
  175. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  176. $apps[$x]['db'][$y]['fields'][$z]['search'] = "true";
  177. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  178. $z++;
  179. $apps[$x]['db'][$y]['fields'][$z]['name'] = "password";
  180. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  181. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  182. $z++;
  183. $apps[$x]['db'][$y]['fields'][$z]['name'] = "salt";
  184. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  185. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  186. $z++;
  187. $apps[$x]['db'][$y]['fields'][$z]['name']['text'] = "user_email";
  188. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  189. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  190. $z++;
  191. $apps[$x]['db'][$y]['fields'][$z]['name'] = "contact_uuid";
  192. $apps[$x]['db'][$y]['fields'][$z]['type']['pgsql'] = "uuid";
  193. $apps[$x]['db'][$y]['fields'][$z]['type']['sqlite'] = "text";
  194. $apps[$x]['db'][$y]['fields'][$z]['type']['mysql'] = "char(36)";
  195. //$apps[$x]['db'][$y]['fields'][$z]['key']['type'] = "foreign";
  196. //$apps[$x]['db'][$y]['fields'][$z]['key']['reference']['table'] = "v_contacts";
  197. //$apps[$x]['db'][$y]['fields'][$z]['key']['reference']['field'] = "contact_uuid";
  198. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  199. $z++;
  200. $apps[$x]['db'][$y]['fields'][$z]['name']['text'] = "user_status";
  201. $apps[$x]['db'][$y]['fields'][$z]['name']['deprecated'] = "userstatus";
  202. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  203. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  204. $z++;
  205. $apps[$x]['db'][$y]['fields'][$z]['name']['text'] = "user_time_zone";
  206. $apps[$x]['db'][$y]['fields'][$z]['name']['deprecated'] = "usertimezone";
  207. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  208. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  209. $apps[$x]['db'][$y]['fields'][$z]['deprecated'] = "true";
  210. $z++;
  211. $apps[$x]['db'][$y]['fields'][$z]['name'] = "api_key";
  212. $apps[$x]['db'][$y]['fields'][$z]['type']['pgsql'] = "uuid";
  213. $apps[$x]['db'][$y]['fields'][$z]['type']['sqlite'] = "text";
  214. $apps[$x]['db'][$y]['fields'][$z]['type']['mysql'] = "char(36)";
  215. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  216. $z++;
  217. $apps[$x]['db'][$y]['fields'][$z]['name'] = "user_enabled";
  218. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  219. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  220. $z++;
  221. $apps[$x]['db'][$y]['fields'][$z]['name'] = "add_user";
  222. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  223. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  224. $z++;
  225. $apps[$x]['db'][$y]['fields'][$z]['name'] = "add_date";
  226. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  227. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  228. $y++;
  229. $apps[$x]['db'][$y]['table']['name']['text'] = "v_user_groups";
  230. $apps[$x]['db'][$y]['table']['name']['deprecated'] = "v_group_users";
  231. $apps[$x]['db'][$y]['table']['parent'] = "v_users";
  232. $z=0;
  233. $apps[$x]['db'][$y]['fields'][$z]['name'] = "id";
  234. $apps[$x]['db'][$y]['fields'][$z]['type']['pgsql'] = "serial";
  235. $apps[$x]['db'][$y]['fields'][$z]['type']['sqlite'] = "integer";
  236. $apps[$x]['db'][$y]['fields'][$z]['type']['mysql'] = "INT NOT NULL AUTO_INCREMENT";
  237. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  238. $apps[$x]['db'][$y]['fields'][$z]['deprecated'] = "true";
  239. $z++;
  240. $apps[$x]['db'][$y]['fields'][$z]['name']['text'] = "user_group_uuid";
  241. $apps[$x]['db'][$y]['fields'][$z]['name']['deprecated'] = "group_user_uuid";
  242. $apps[$x]['db'][$y]['fields'][$z]['type']['pgsql'] = "uuid";
  243. $apps[$x]['db'][$y]['fields'][$z]['type']['sqlite'] = "text";
  244. $apps[$x]['db'][$y]['fields'][$z]['type']['mysql'] = "char(36)";
  245. $apps[$x]['db'][$y]['fields'][$z]['key']['type'] = "primary";
  246. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  247. $z++;
  248. $apps[$x]['db'][$y]['fields'][$z]['name'] = "domain_uuid";
  249. $apps[$x]['db'][$y]['fields'][$z]['type']['pgsql'] = "uuid";
  250. $apps[$x]['db'][$y]['fields'][$z]['type']['sqlite'] = "text";
  251. $apps[$x]['db'][$y]['fields'][$z]['type']['mysql'] = "char(36)";
  252. $apps[$x]['db'][$y]['fields'][$z]['key']['type'] = "foreign";
  253. $apps[$x]['db'][$y]['fields'][$z]['key']['reference']['table'] = "v_domains";
  254. $apps[$x]['db'][$y]['fields'][$z]['key']['reference']['field'] = "domain_uuid";
  255. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  256. $z++;
  257. $apps[$x]['db'][$y]['fields'][$z]['name'] = "v_id";
  258. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  259. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  260. $apps[$x]['db'][$y]['fields'][$z]['deprecated'] = "true";
  261. $z++;
  262. $apps[$x]['db'][$y]['fields'][$z]['name']['text'] = "group_name";
  263. $apps[$x]['db'][$y]['fields'][$z]['name']['deprecated'] = "groupid";
  264. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  265. $apps[$x]['db'][$y]['fields'][$z]['search'] = "true";
  266. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  267. $z++;
  268. $apps[$x]['db'][$y]['fields'][$z]['name'] = "group_uuid";
  269. $apps[$x]['db'][$y]['fields'][$z]['type']['pgsql'] = "uuid";
  270. $apps[$x]['db'][$y]['fields'][$z]['type']['sqlite'] = "text";
  271. $apps[$x]['db'][$y]['fields'][$z]['type']['mysql'] = "char(36)";
  272. $apps[$x]['db'][$y]['fields'][$z]['key']['type'] = "foreign";
  273. $apps[$x]['db'][$y]['fields'][$z]['key']['reference']['table'] = "v_groups";
  274. $apps[$x]['db'][$y]['fields'][$z]['key']['reference']['field'] = "group_uuid";
  275. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  276. $z++;
  277. $apps[$x]['db'][$y]['fields'][$z]['name'] = "username";
  278. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  279. $apps[$x]['db'][$y]['fields'][$z]['search'] = "true";
  280. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  281. $apps[$x]['db'][$y]['fields'][$z]['deprecated'] = "true";
  282. $z++;
  283. $apps[$x]['db'][$y]['fields'][$z]['name'] = "user_uuid";
  284. $apps[$x]['db'][$y]['fields'][$z]['type']['pgsql'] = "uuid";
  285. $apps[$x]['db'][$y]['fields'][$z]['type']['sqlite'] = "text";
  286. $apps[$x]['db'][$y]['fields'][$z]['type']['mysql'] = "char(36)";
  287. $apps[$x]['db'][$y]['fields'][$z]['key']['type'] = "foreign";
  288. $apps[$x]['db'][$y]['fields'][$z]['key']['reference']['table'] = "v_users";
  289. $apps[$x]['db'][$y]['fields'][$z]['key']['reference']['field'] = "user_uuid";
  290. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  291. $y++;
  292. $apps[$x]['db'][$y]['table']['name'] = "v_user_settings";
  293. $apps[$x]['db'][$y]['table']['parent'] = "v_users";
  294. $z=0;
  295. $apps[$x]['db'][$y]['fields'][$z]['name'] = "user_setting_uuid";
  296. $apps[$x]['db'][$y]['fields'][$z]['type']['pgsql'] = "uuid";
  297. $apps[$x]['db'][$y]['fields'][$z]['type']['sqlite'] = "text";
  298. $apps[$x]['db'][$y]['fields'][$z]['type']['mysql'] = "char(36)";
  299. $apps[$x]['db'][$y]['fields'][$z]['key']['type'] = "primary";
  300. $z++;
  301. $apps[$x]['db'][$y]['fields'][$z]['name'] = "user_uuid";
  302. $apps[$x]['db'][$y]['fields'][$z]['type']['pgsql'] = "uuid";
  303. $apps[$x]['db'][$y]['fields'][$z]['type']['sqlite'] = "text";
  304. $apps[$x]['db'][$y]['fields'][$z]['type']['mysql'] = "char(36)";
  305. $apps[$x]['db'][$y]['fields'][$z]['key']['type'] = "foreign";
  306. $apps[$x]['db'][$y]['fields'][$z]['key']['reference']['table'] = "v_users";
  307. $apps[$x]['db'][$y]['fields'][$z]['key']['reference']['field'] = "user_uuid";
  308. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  309. $z++;
  310. $apps[$x]['db'][$y]['fields'][$z]['name'] = "domain_uuid";
  311. $apps[$x]['db'][$y]['fields'][$z]['type']['pgsql'] = "uuid";
  312. $apps[$x]['db'][$y]['fields'][$z]['type']['sqlite'] = "text";
  313. $apps[$x]['db'][$y]['fields'][$z]['type']['mysql'] = "char(36)";
  314. $apps[$x]['db'][$y]['fields'][$z]['key']['type'] = "foreign";
  315. $apps[$x]['db'][$y]['fields'][$z]['key']['reference']['table'] = "v_domains";
  316. $apps[$x]['db'][$y]['fields'][$z]['key']['reference']['field'] = "domain_uuid";
  317. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  318. $z++;
  319. $apps[$x]['db'][$y]['fields'][$z]['name'] = "user_setting_category";
  320. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  321. $apps[$x]['db'][$y]['fields'][$z]['search'] = "true";
  322. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "Enter the category.";
  323. $z++;
  324. $apps[$x]['db'][$y]['fields'][$z]['name'] = "user_setting_subcategory";
  325. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  326. $apps[$x]['db'][$y]['fields'][$z]['search'] = "true";
  327. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "Enter the subcategory.";
  328. $z++;
  329. $apps[$x]['db'][$y]['fields'][$z]['name'] = "user_setting_name";
  330. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  331. $apps[$x]['db'][$y]['fields'][$z]['search'] = "true";
  332. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "Enter the name.";
  333. $z++;
  334. $apps[$x]['db'][$y]['fields'][$z]['name'] = "user_setting_value";
  335. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  336. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "Enter the value.";
  337. $z++;
  338. $apps[$x]['db'][$y]['fields'][$z]['name'] = "user_setting_order";
  339. $apps[$x]['db'][$y]['fields'][$z]['type'] = "numeric";
  340. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  341. $z++;
  342. $apps[$x]['db'][$y]['fields'][$z]['name'] = "user_setting_enabled";
  343. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  344. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  345. $z++;
  346. $apps[$x]['db'][$y]['fields'][$z]['name'] = "user_setting_description";
  347. $apps[$x]['db'][$y]['fields'][$z]['type'] = "text";
  348. $apps[$x]['db'][$y]['fields'][$z]['search'] = "true";
  349. $apps[$x]['db'][$y]['fields'][$z]['description']['en-us'] = "";
  350. ?>