You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

data_init.sql 14KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274
  1. --
  2. -- PostgreSQL database dump
  3. --
  4. -- Dumped from database version 9.4.7
  5. -- Dumped by pg_dump version 9.4.7
  6. -- Started on 2016-04-27 09:42:45 CEST
  7. SET statement_timeout = 0;
  8. SET lock_timeout = 0;
  9. SET client_encoding = 'UTF8';
  10. SET standard_conforming_strings = on;
  11. SET check_function_bodies = false;
  12. SET client_min_messages = warning;
  13. SET search_path = public, pg_catalog;
  14. --
  15. -- TOC entry 2119 (class 0 OID 25804)
  16. -- Dependencies: 184
  17. -- Data for Name: images; Type: TABLE DATA; Schema: public; Owner: dev
  18. --
  19. --
  20. -- TOC entry 2124 (class 0 OID 0)
  21. -- Dependencies: 183
  22. -- Name: images_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dev
  23. --
  24. SELECT pg_catalog.setval('images_id_seq', 14, true);
  25. --
  26. -- TOC entry 2109 (class 0 OID 25696)
  27. -- Dependencies: 174
  28. -- Data for Name: luticate_groups; Type: TABLE DATA; Schema: public; Owner: dev
  29. --
  30. INSERT INTO luticate_groups VALUES (0, 'Super Administrators');
  31. INSERT INTO luticate_groups VALUES (1, 'Administrators');
  32. --
  33. -- TOC entry 2125 (class 0 OID 0)
  34. -- Dependencies: 173
  35. -- Name: luticate_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dev
  36. --
  37. SELECT pg_catalog.setval('luticate_groups_id_seq', 2, true);
  38. --
  39. -- TOC entry 2110 (class 0 OID 25703)
  40. -- Dependencies: 175
  41. -- Data for Name: luticate_permissions; Type: TABLE DATA; Schema: public; Owner: dev
  42. --
  43. INSERT INTO luticate_permissions VALUES ('LU_USER_SET_PASSWORD', false);
  44. INSERT INTO luticate_permissions VALUES ('LU_USER_LOGIN', true);
  45. INSERT INTO luticate_permissions VALUES ('LU_USER_EDIT_ME', true);
  46. INSERT INTO luticate_permissions VALUES ('LU_USER_SET_PASSWORD_ME', true);
  47. INSERT INTO luticate_permissions VALUES ('LU_GROUP_ADD', false);
  48. INSERT INTO luticate_permissions VALUES ('LU_GROUP_DEL', false);
  49. INSERT INTO luticate_permissions VALUES ('LU_GROUP_EDIT', false);
  50. INSERT INTO luticate_permissions VALUES ('LU_GROUP_USER_ADD', false);
  51. INSERT INTO luticate_permissions VALUES ('LU_GROUP_USER_DEL', false);
  52. INSERT INTO luticate_permissions VALUES ('LU_PERM_ADD', false);
  53. INSERT INTO luticate_permissions VALUES ('LU_PERM_DEL', false);
  54. INSERT INTO luticate_permissions VALUES ('LU_PERM_EDIT', false);
  55. INSERT INTO luticate_permissions VALUES ('LU_PERM_EFFECTIVE_GET', false);
  56. INSERT INTO luticate_permissions VALUES ('LU_PERM_GET', false);
  57. INSERT INTO luticate_permissions VALUES ('LU_PERM_GROUP_ADD', false);
  58. INSERT INTO luticate_permissions VALUES ('LU_PERM_GROUP_DEL', false);
  59. INSERT INTO luticate_permissions VALUES ('LU_PERM_GROUP_EDIT', false);
  60. INSERT INTO luticate_permissions VALUES ('LU_PERM_GROUP_GET', false);
  61. INSERT INTO luticate_permissions VALUES ('LU_GROUP_GET', false);
  62. INSERT INTO luticate_permissions VALUES ('LU_PERM_USER_ADD', false);
  63. INSERT INTO luticate_permissions VALUES ('LU_PERM_USER_DEL', false);
  64. INSERT INTO luticate_permissions VALUES ('LU_PERM_USER_EDIT', false);
  65. INSERT INTO luticate_permissions VALUES ('LU_USER_EDIT', false);
  66. INSERT INTO luticate_permissions VALUES ('LU_USER_DEL', false);
  67. INSERT INTO luticate_permissions VALUES ('LU_USER_ADD', false);
  68. INSERT INTO luticate_permissions VALUES ('LU_PERM_USER_GET', false);
  69. INSERT INTO luticate_permissions VALUES ('LU_SETTING_DEL', false);
  70. INSERT INTO luticate_permissions VALUES ('LU_SETTING_EDIT', false);
  71. INSERT INTO luticate_permissions VALUES ('LU_SETTING_EFFECTIVE_GET', false);
  72. INSERT INTO luticate_permissions VALUES ('LU_SETTING_GET', false);
  73. INSERT INTO luticate_permissions VALUES ('LU_SETTING_USER_EDIT', false);
  74. INSERT INTO luticate_permissions VALUES ('LU_SETTING_USER_GET', false);
  75. INSERT INTO luticate_permissions VALUES ('LU_SETTING_EDIT_ME', false);
  76. INSERT INTO luticate_permissions VALUES ('LU_SETTING_ADD', false);
  77. INSERT INTO luticate_permissions VALUES ('PX_UPLOAD', true);
  78. INSERT INTO luticate_permissions VALUES ('LU_USER_GET', true);
  79. --
  80. -- TOC entry 2111 (class 0 OID 25706)
  81. -- Dependencies: 176
  82. -- Data for Name: luticate_permissions_groups; Type: TABLE DATA; Schema: public; Owner: dev
  83. --
  84. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_ADD', true, 0);
  85. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_DEL', true, 0);
  86. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_EDIT', true, 0);
  87. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_GET', true, 0);
  88. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_USER_ADD', true, 0);
  89. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_USER_DEL', true, 0);
  90. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_EFFECTIVE_GET', true, 0);
  91. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GET', true, 0);
  92. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_ADD', true, 0);
  93. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_DEL', true, 0);
  94. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_EDIT', true, 0);
  95. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_GET', true, 0);
  96. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_ADD', true, 0);
  97. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_DEL', true, 0);
  98. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_EDIT', true, 0);
  99. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_GET', true, 0);
  100. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_ADD', true, 0);
  101. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_DEL', true, 0);
  102. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_EDIT', true, 0);
  103. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_EDIT_ME', true, 0);
  104. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_GET', true, 0);
  105. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_LOGIN', true, 0);
  106. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_SET_PASSWORD', true, 0);
  107. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_SET_PASSWORD_ME', true, 0);
  108. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_ADD', true, 1);
  109. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_DEL', true, 1);
  110. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_EDIT', true, 1);
  111. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_GET', true, 1);
  112. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_USER_ADD', true, 1);
  113. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_USER_DEL', true, 1);
  114. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_EFFECTIVE_GET', true, 1);
  115. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GET', true, 1);
  116. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_ADD', true, 1);
  117. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_DEL', true, 1);
  118. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_EDIT', true, 1);
  119. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_GET', true, 1);
  120. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_ADD', true, 1);
  121. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_DEL', true, 1);
  122. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_EDIT', true, 1);
  123. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_GET', true, 1);
  124. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_ADD', true, 1);
  125. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_DEL', true, 1);
  126. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_EDIT', true, 1);
  127. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_EDIT_ME', true, 1);
  128. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_GET', true, 1);
  129. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_LOGIN', true, 1);
  130. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_SET_PASSWORD', true, 1);
  131. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_SET_PASSWORD_ME', true, 1);
  132. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_EDIT', true, 0);
  133. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_DEL', true, 0);
  134. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_ADD', true, 0);
  135. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_ADD', false, 1);
  136. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_EDIT', false, 1);
  137. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_DEL', false, 1);
  138. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_ADD', false, 1);
  139. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_DEL', false, 1);
  140. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_EDIT', true, 1);
  141. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_EFFECTIVE_GET', true, 1);
  142. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_GET', true, 1);
  143. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_USER_EDIT', true, 1);
  144. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_USER_GET', true, 1);
  145. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_ADD', true, 0);
  146. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_DEL', true, 0);
  147. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_EDIT', true, 0);
  148. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_EFFECTIVE_GET', true, 0);
  149. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_GET', true, 0);
  150. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_USER_EDIT', true, 0);
  151. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_USER_GET', true, 0);
  152. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_EDIT_ME', true, 1);
  153. INSERT INTO luticate_permissions_groups VALUES ('LU_SETTING_EDIT_ME', true, 0);
  154. --
  155. -- TOC entry 2114 (class 0 OID 25714)
  156. -- Dependencies: 179
  157. -- Data for Name: luticate_users; Type: TABLE DATA; Schema: public; Owner: dev
  158. --
  159. INSERT INTO luticate_users VALUES (0, 'anonymous', 'anonymous@example.com', '', '', NULL, 'anonymous', 'anonymous');
  160. INSERT INTO luticate_users VALUES (1, 'root', 'root@example.com', '$2y$10$m1aN1a1ZEr1vmjFPfWl4Pu/63EhcxVCrC/DF0DFhdGbvORwtJtCmy', 'AGLUILNxbh', NULL, 'root', 'root');
  161. --
  162. -- TOC entry 2112 (class 0 OID 25709)
  163. -- Dependencies: 177
  164. -- Data for Name: luticate_permissions_users; Type: TABLE DATA; Schema: public; Owner: dev
  165. --
  166. INSERT INTO luticate_permissions_users VALUES ('LU_GROUP_ADD', false, 0);
  167. INSERT INTO luticate_permissions_users VALUES ('LU_GROUP_DEL', false, 0);
  168. INSERT INTO luticate_permissions_users VALUES ('LU_GROUP_EDIT', false, 0);
  169. INSERT INTO luticate_permissions_users VALUES ('LU_GROUP_USER_ADD', false, 0);
  170. INSERT INTO luticate_permissions_users VALUES ('LU_GROUP_USER_DEL', false, 0);
  171. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_ADD', false, 0);
  172. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_DEL', false, 0);
  173. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_EDIT', false, 0);
  174. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_EFFECTIVE_GET', false, 0);
  175. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_GET', false, 0);
  176. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_GROUP_ADD', false, 0);
  177. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_GROUP_DEL', false, 0);
  178. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_GROUP_EDIT', false, 0);
  179. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_GROUP_GET', false, 0);
  180. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_USER_ADD', false, 0);
  181. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_USER_DEL', false, 0);
  182. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_USER_EDIT', false, 0);
  183. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_USER_GET', false, 0);
  184. INSERT INTO luticate_permissions_users VALUES ('LU_USER_DEL', false, 0);
  185. INSERT INTO luticate_permissions_users VALUES ('LU_USER_EDIT', false, 0);
  186. INSERT INTO luticate_permissions_users VALUES ('LU_USER_EDIT_ME', false, 0);
  187. INSERT INTO luticate_permissions_users VALUES ('LU_USER_SET_PASSWORD', false, 0);
  188. INSERT INTO luticate_permissions_users VALUES ('LU_USER_SET_PASSWORD_ME', false, 0);
  189. INSERT INTO luticate_permissions_users VALUES ('LU_USER_LOGIN', true, 0);
  190. INSERT INTO luticate_permissions_users VALUES ('LU_GROUP_GET', false, 0);
  191. INSERT INTO luticate_permissions_users VALUES ('LU_SETTING_USER_GET', true, 0);
  192. INSERT INTO luticate_permissions_users VALUES ('LU_SETTING_ADD', false, 0);
  193. INSERT INTO luticate_permissions_users VALUES ('LU_SETTING_EDIT', false, 0);
  194. INSERT INTO luticate_permissions_users VALUES ('LU_SETTING_EFFECTIVE_GET', false, 0);
  195. INSERT INTO luticate_permissions_users VALUES ('LU_SETTING_DEL', false, 0);
  196. INSERT INTO luticate_permissions_users VALUES ('LU_SETTING_EDIT_ME', false, 0);
  197. INSERT INTO luticate_permissions_users VALUES ('LU_SETTING_GET', false, 0);
  198. INSERT INTO luticate_permissions_users VALUES ('LU_SETTING_USER_EDIT', false, 0);
  199. INSERT INTO luticate_permissions_users VALUES ('LU_USER_ADD', true, 0);
  200. INSERT INTO luticate_permissions_users VALUES ('LU_USER_GET', true, 0);
  201. INSERT INTO luticate_permissions_users VALUES ('PX_UPLOAD', false, 0);
  202. --
  203. -- TOC entry 2116 (class 0 OID 25774)
  204. -- Dependencies: 181
  205. -- Data for Name: luticate_settings; Type: TABLE DATA; Schema: public; Owner: dev
  206. --
  207. INSERT INTO luticate_settings VALUES ('LU_SESSION_DAYS', 'int', '30', true, true);
  208. INSERT INTO luticate_settings VALUES ('LU_USERS_PER_PAGE', 'int', '15', false, false);
  209. INSERT INTO luticate_settings VALUES ('LU_GROUPS_PER_PAGE', 'int', '15', false, false);
  210. INSERT INTO luticate_settings VALUES ('LU_SETTINGS_PER_PAGE', 'int', '15', false, false);
  211. INSERT INTO luticate_settings VALUES ('LU_PERMISSIONS_PER_PAGE', 'int', '15', false, false);
  212. --
  213. -- TOC entry 2117 (class 0 OID 25780)
  214. -- Dependencies: 182
  215. -- Data for Name: luticate_settings_users; Type: TABLE DATA; Schema: public; Owner: dev
  216. --
  217. --
  218. -- TOC entry 2115 (class 0 OID 25721)
  219. -- Dependencies: 180
  220. -- Data for Name: luticate_users_groups; Type: TABLE DATA; Schema: public; Owner: dev
  221. --
  222. INSERT INTO luticate_users_groups VALUES (1, 0);
  223. --
  224. -- TOC entry 2126 (class 0 OID 0)
  225. -- Dependencies: 178
  226. -- Name: luticate_users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dev
  227. --
  228. SELECT pg_catalog.setval('luticate_users_id_seq', 3, true);
  229. -- Completed on 2016-04-27 09:42:45 CEST
  230. --
  231. -- PostgreSQL database dump complete
  232. --