選択できるのは25トピックまでです。 トピックは、先頭が英数字で、英数字とダッシュ('-')を使用した35文字以内のものにしてください。

data_init.sql 19KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365
  1. --
  2. -- PostgreSQL database dump
  3. --
  4. --
  5. -- Data for Name: camera_types; Type: TABLE DATA; Schema: public; Owner: dev
  6. --
  7. INSERT INTO camera_types VALUES (3, 'Trendnet TV-IP311PI', 'App\Http\Business\Cameras\Trendnet\TVIP311PI', '{"Host": "http://camX.example.com","Port":6080, "Username": "user", "Password": "PA$$W0RD"}');
  8. INSERT INTO camera_types VALUES (1, 'Dummy', '\App\Http\Business\Cameras\DummyCamera', '{}');
  9. --
  10. -- Name: camera_types_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dev
  11. --
  12. SELECT pg_catalog.setval('camera_types_id_seq', 3, true);
  13. --
  14. -- Data for Name: hosts; Type: TABLE DATA; Schema: public; Owner: dev
  15. --
  16. INSERT INTO hosts VALUES (9, 'Test.', 'http://backend.camotion.local/', '');
  17. --
  18. -- Data for Name: cameras; Type: TABLE DATA; Schema: public; Owner: dev
  19. --
  20. INSERT INTO cameras VALUES (9, 'Test.', 'Test. description', 9, 1, '{}');
  21. INSERT INTO cameras VALUES (6, 'Test.2', 'Test.2 description', 9, 1, '{}');
  22. INSERT INTO cameras VALUES (7, 'Test.3', 'Test.3 description', 9, 1, '{}');
  23. INSERT INTO cameras VALUES (8, 'Test.4', 'Test.4 description', 9, 1, '{}');
  24. --
  25. -- Name: cameras_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dev
  26. --
  27. SELECT pg_catalog.setval('cameras_id_seq', 11, true);
  28. --
  29. -- Data for Name: command_types; Type: TABLE DATA; Schema: public; Owner: dev
  30. --
  31. INSERT INTO command_types VALUES (1, 'Dummy command', 'App\Http\Business\Commands\DummyCommand', '{"Success": true}');
  32. INSERT INTO command_types VALUES (2, 'Wake on LAN', 'App\Http\Business\Commands\WakeOnLanCommand', '{"IP": "255.255.255.255", "Port": 9, "MACs": ["ff:ff:ff:ff:ff:ff"]}');
  33. INSERT INTO command_types VALUES (3, 'PiFace Digital', 'App\Http\Business\Commands\PiFaceCommand', '{"Commands":["device=0","up=0", "sleep=500", "down=0"]}');
  34. --
  35. -- Name: command_types_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dev
  36. --
  37. SELECT pg_catalog.setval('command_types_id_seq', 3, true);
  38. --
  39. -- Data for Name: commands; Type: TABLE DATA; Schema: public; Owner: dev
  40. --
  41. INSERT INTO commands VALUES (1, 'Dummy command', 'Command that will fail', 9, 1, '{"Success":false}');
  42. INSERT INTO commands VALUES (2, 'Dummy command 2', 'Command that will succeed', 9, 1, '{"Success":true}');
  43. --
  44. -- Name: commands_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dev
  45. --
  46. SELECT pg_catalog.setval('commands_id_seq', 4, true);
  47. --
  48. -- Name: hosts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dev
  49. --
  50. SELECT pg_catalog.setval('hosts_id_seq', 10, true);
  51. --
  52. -- Data for Name: luticate_groups; Type: TABLE DATA; Schema: public; Owner: dev
  53. --
  54. INSERT INTO luticate_groups VALUES (0, 'Super Administrators');
  55. INSERT INTO luticate_groups VALUES (1, 'Administrators');
  56. INSERT INTO luticate_groups VALUES (3, 'Cameras');
  57. INSERT INTO luticate_groups VALUES (4, 'Sensors');
  58. INSERT INTO luticate_groups VALUES (5, 'Commands');
  59. --
  60. -- Name: luticate_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dev
  61. --
  62. SELECT pg_catalog.setval('luticate_groups_id_seq', 5, true);
  63. --
  64. -- Data for Name: luticate_permissions; Type: TABLE DATA; Schema: public; Owner: dev
  65. --
  66. INSERT INTO luticate_permissions VALUES ('LU_USER_GET', false);
  67. INSERT INTO luticate_permissions VALUES ('LU_USER_SET_PASSWORD', false);
  68. INSERT INTO luticate_permissions VALUES ('LU_USER_LOGIN', true);
  69. INSERT INTO luticate_permissions VALUES ('LU_USER_EDIT_ME', true);
  70. INSERT INTO luticate_permissions VALUES ('LU_USER_SET_PASSWORD_ME', true);
  71. INSERT INTO luticate_permissions VALUES ('LU_GROUP_ADD', false);
  72. INSERT INTO luticate_permissions VALUES ('LU_GROUP_DEL', false);
  73. INSERT INTO luticate_permissions VALUES ('LU_GROUP_EDIT', false);
  74. INSERT INTO luticate_permissions VALUES ('LU_GROUP_USER_ADD', false);
  75. INSERT INTO luticate_permissions VALUES ('LU_GROUP_USER_DEL', false);
  76. INSERT INTO luticate_permissions VALUES ('LU_PERM_ADD', false);
  77. INSERT INTO luticate_permissions VALUES ('LU_PERM_DEL', false);
  78. INSERT INTO luticate_permissions VALUES ('LU_PERM_EDIT', false);
  79. INSERT INTO luticate_permissions VALUES ('LU_PERM_EFFECTIVE_GET', false);
  80. INSERT INTO luticate_permissions VALUES ('LU_PERM_GET', false);
  81. INSERT INTO luticate_permissions VALUES ('LU_PERM_GROUP_ADD', false);
  82. INSERT INTO luticate_permissions VALUES ('LU_PERM_GROUP_DEL', false);
  83. INSERT INTO luticate_permissions VALUES ('LU_PERM_GROUP_EDIT', false);
  84. INSERT INTO luticate_permissions VALUES ('LU_PERM_GROUP_GET', false);
  85. INSERT INTO luticate_permissions VALUES ('LU_GROUP_GET', false);
  86. INSERT INTO luticate_permissions VALUES ('LU_PERM_USER_ADD', false);
  87. INSERT INTO luticate_permissions VALUES ('LU_PERM_USER_DEL', false);
  88. INSERT INTO luticate_permissions VALUES ('LU_PERM_USER_EDIT', false);
  89. INSERT INTO luticate_permissions VALUES ('LU_USER_EDIT', false);
  90. INSERT INTO luticate_permissions VALUES ('LU_USER_DEL', false);
  91. INSERT INTO luticate_permissions VALUES ('LU_USER_ADD', false);
  92. INSERT INTO luticate_permissions VALUES ('LU_PERM_USER_GET', false);
  93. INSERT INTO luticate_permissions VALUES ('CAMOTION_HOST_ADD', false);
  94. INSERT INTO luticate_permissions VALUES ('CAMOTION_HOST_DEL', false);
  95. INSERT INTO luticate_permissions VALUES ('CAMOTION_HOST_EDIT', false);
  96. INSERT INTO luticate_permissions VALUES ('CAMOTION_COMMAND_ADD', false);
  97. INSERT INTO luticate_permissions VALUES ('CAMOTION_COMMAND_DEL', false);
  98. INSERT INTO luticate_permissions VALUES ('CAMOTION_COMMAND_EDIT', false);
  99. INSERT INTO luticate_permissions VALUES ('CAMOTION_SENSOR_ADD', false);
  100. INSERT INTO luticate_permissions VALUES ('CAMOTION_SENSOR_DEL', false);
  101. INSERT INTO luticate_permissions VALUES ('CAMOTION_SENSOR_EDIT', false);
  102. INSERT INTO luticate_permissions VALUES ('CAMOTION_CAMERA_ADD', false);
  103. INSERT INTO luticate_permissions VALUES ('CAMOTION_CAMERA_DEL', false);
  104. INSERT INTO luticate_permissions VALUES ('CAMOTION_CAMERA_EDIT', false);
  105. INSERT INTO luticate_permissions VALUES ('CAMOTION_SENSOR_EXEC', false);
  106. INSERT INTO luticate_permissions VALUES ('CAMOTION_SENSOR_GET', false);
  107. INSERT INTO luticate_permissions VALUES ('CAMOTION_CAMERA_EXEC', false);
  108. INSERT INTO luticate_permissions VALUES ('CAMOTION_CAMERA_GET', false);
  109. INSERT INTO luticate_permissions VALUES ('CAMOTION_COMMAND_EXEC', false);
  110. INSERT INTO luticate_permissions VALUES ('CAMOTION_COMMAND_GET', false);
  111. INSERT INTO luticate_permissions VALUES ('CAMOTION_HOST_GET', false);
  112. --
  113. -- Data for Name: luticate_permissions_groups; Type: TABLE DATA; Schema: public; Owner: dev
  114. --
  115. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_ADD', true, 0);
  116. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_DEL', true, 0);
  117. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_EDIT', true, 0);
  118. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_GET', true, 0);
  119. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_USER_ADD', true, 0);
  120. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_USER_DEL', true, 0);
  121. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_EFFECTIVE_GET', true, 0);
  122. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GET', true, 0);
  123. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_ADD', true, 0);
  124. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_DEL', true, 0);
  125. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_EDIT', true, 0);
  126. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_GET', true, 0);
  127. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_ADD', true, 0);
  128. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_DEL', true, 0);
  129. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_EDIT', true, 0);
  130. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_GET', true, 0);
  131. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_ADD', true, 0);
  132. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_DEL', true, 0);
  133. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_EDIT', true, 0);
  134. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_EDIT_ME', true, 0);
  135. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_GET', true, 0);
  136. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_LOGIN', true, 0);
  137. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_SET_PASSWORD', true, 0);
  138. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_SET_PASSWORD_ME', true, 0);
  139. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_ADD', true, 1);
  140. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_DEL', true, 1);
  141. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_EDIT', true, 1);
  142. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_GET', true, 1);
  143. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_USER_ADD', true, 1);
  144. INSERT INTO luticate_permissions_groups VALUES ('LU_GROUP_USER_DEL', true, 1);
  145. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_EFFECTIVE_GET', true, 1);
  146. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GET', true, 1);
  147. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_ADD', true, 1);
  148. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_DEL', true, 1);
  149. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_EDIT', true, 1);
  150. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_GROUP_GET', true, 1);
  151. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_ADD', true, 1);
  152. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_DEL', true, 1);
  153. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_EDIT', true, 1);
  154. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_USER_GET', true, 1);
  155. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_ADD', true, 1);
  156. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_DEL', true, 1);
  157. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_EDIT', true, 1);
  158. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_EDIT_ME', true, 1);
  159. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_GET', true, 1);
  160. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_LOGIN', true, 1);
  161. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_SET_PASSWORD', true, 1);
  162. INSERT INTO luticate_permissions_groups VALUES ('LU_USER_SET_PASSWORD_ME', true, 1);
  163. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_EDIT', true, 0);
  164. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_DEL', true, 0);
  165. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_ADD', true, 0);
  166. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_ADD', false, 1);
  167. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_EDIT', false, 1);
  168. INSERT INTO luticate_permissions_groups VALUES ('LU_PERM_DEL', false, 1);
  169. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_CAMERA_ADD', true, 1);
  170. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_CAMERA_DEL', true, 1);
  171. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_CAMERA_EDIT', true, 1);
  172. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_CAMERA_EXEC', true, 1);
  173. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_CAMERA_GET', true, 1);
  174. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_COMMAND_ADD', true, 1);
  175. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_COMMAND_DEL', true, 1);
  176. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_COMMAND_EDIT', true, 1);
  177. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_COMMAND_EXEC', true, 1);
  178. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_COMMAND_GET', true, 1);
  179. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_HOST_ADD', true, 1);
  180. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_HOST_DEL', true, 1);
  181. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_HOST_EDIT', true, 1);
  182. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_HOST_GET', true, 1);
  183. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_SENSOR_ADD', true, 1);
  184. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_SENSOR_DEL', true, 1);
  185. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_SENSOR_EDIT', true, 1);
  186. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_SENSOR_EXEC', true, 1);
  187. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_SENSOR_GET', true, 1);
  188. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_CAMERA_ADD', true, 0);
  189. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_CAMERA_DEL', true, 0);
  190. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_CAMERA_EDIT', true, 0);
  191. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_CAMERA_EXEC', true, 0);
  192. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_CAMERA_GET', true, 0);
  193. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_COMMAND_ADD', true, 0);
  194. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_COMMAND_DEL', true, 0);
  195. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_COMMAND_EDIT', true, 0);
  196. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_COMMAND_EXEC', true, 0);
  197. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_COMMAND_GET', true, 0);
  198. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_HOST_ADD', true, 0);
  199. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_HOST_DEL', true, 0);
  200. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_HOST_EDIT', true, 0);
  201. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_HOST_GET', true, 0);
  202. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_SENSOR_ADD', true, 0);
  203. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_SENSOR_DEL', true, 0);
  204. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_SENSOR_EDIT', true, 0);
  205. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_SENSOR_EXEC', true, 0);
  206. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_SENSOR_GET', true, 0);
  207. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_CAMERA_GET', true, 3);
  208. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_CAMERA_EXEC', true, 3);
  209. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_SENSOR_GET', true, 4);
  210. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_SENSOR_EXEC', true, 4);
  211. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_COMMAND_GET', true, 5);
  212. INSERT INTO luticate_permissions_groups VALUES ('CAMOTION_COMMAND_EXEC', true, 5);
  213. --
  214. -- Data for Name: luticate_users; Type: TABLE DATA; Schema: public; Owner: dev
  215. --
  216. INSERT INTO luticate_users VALUES (0, 'anonymous', 'anonymous@example.com', '', '', NULL, 'anonymous', 'anonymous');
  217. INSERT INTO luticate_users VALUES (1, 'root', 'root@example.com', '$2y$10$m1aN1a1ZEr1vmjFPfWl4Pu/63EhcxVCrC/DF0DFhdGbvORwtJtCmy', 'szHKcDk5v1', NULL, 'root', 'root');
  218. INSERT INTO luticate_users VALUES (4, 'user', 'uesr@example.com', '$2y$10$3aoyf68xWuL4/Rop1lAYDOaBTWeFyvX8H.lYBSZRH9HIwaFxhimDG', 'OqSvWHcjAB', NULL, 'User', 'User');
  219. --
  220. -- Data for Name: luticate_permissions_users; Type: TABLE DATA; Schema: public; Owner: dev
  221. --
  222. INSERT INTO luticate_permissions_users VALUES ('LU_GROUP_ADD', false, 0);
  223. INSERT INTO luticate_permissions_users VALUES ('LU_GROUP_DEL', false, 0);
  224. INSERT INTO luticate_permissions_users VALUES ('LU_GROUP_EDIT', false, 0);
  225. INSERT INTO luticate_permissions_users VALUES ('LU_GROUP_USER_ADD', false, 0);
  226. INSERT INTO luticate_permissions_users VALUES ('LU_GROUP_USER_DEL', false, 0);
  227. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_ADD', false, 0);
  228. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_DEL', false, 0);
  229. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_EDIT', false, 0);
  230. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_EFFECTIVE_GET', false, 0);
  231. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_GET', false, 0);
  232. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_GROUP_ADD', false, 0);
  233. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_GROUP_DEL', false, 0);
  234. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_GROUP_EDIT', false, 0);
  235. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_GROUP_GET', false, 0);
  236. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_USER_ADD', false, 0);
  237. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_USER_DEL', false, 0);
  238. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_USER_EDIT', false, 0);
  239. INSERT INTO luticate_permissions_users VALUES ('LU_PERM_USER_GET', false, 0);
  240. INSERT INTO luticate_permissions_users VALUES ('LU_USER_ADD', false, 0);
  241. INSERT INTO luticate_permissions_users VALUES ('LU_USER_DEL', false, 0);
  242. INSERT INTO luticate_permissions_users VALUES ('LU_USER_EDIT', false, 0);
  243. INSERT INTO luticate_permissions_users VALUES ('LU_USER_EDIT_ME', false, 0);
  244. INSERT INTO luticate_permissions_users VALUES ('LU_USER_GET', false, 0);
  245. INSERT INTO luticate_permissions_users VALUES ('LU_USER_SET_PASSWORD', false, 0);
  246. INSERT INTO luticate_permissions_users VALUES ('LU_USER_SET_PASSWORD_ME', false, 0);
  247. INSERT INTO luticate_permissions_users VALUES ('LU_USER_LOGIN', true, 0);
  248. INSERT INTO luticate_permissions_users VALUES ('LU_GROUP_GET', false, 0);
  249. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_COMMAND_ADD', false, 0);
  250. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_COMMAND_DEL', false, 0);
  251. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_COMMAND_EDIT', false, 0);
  252. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_COMMAND_EXEC', false, 0);
  253. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_COMMAND_GET', false, 0);
  254. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_SENSOR_ADD', false, 0);
  255. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_SENSOR_DEL', false, 0);
  256. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_SENSOR_EDIT', false, 0);
  257. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_SENSOR_EXEC', false, 0);
  258. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_SENSOR_GET', false, 0);
  259. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_HOST_ADD', false, 0);
  260. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_HOST_EDIT', false, 0);
  261. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_HOST_DEL', false, 0);
  262. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_HOST_GET', false, 0);
  263. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_CAMERA_GET', false, 0);
  264. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_CAMERA_EDIT', false, 0);
  265. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_CAMERA_ADD', false, 0);
  266. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_CAMERA_DEL', false, 0);
  267. INSERT INTO luticate_permissions_users VALUES ('CAMOTION_CAMERA_EXEC', false, 0);
  268. --
  269. -- Data for Name: luticate_users_groups; Type: TABLE DATA; Schema: public; Owner: dev
  270. --
  271. INSERT INTO luticate_users_groups VALUES (1, 0);
  272. INSERT INTO luticate_users_groups VALUES (4, 3);
  273. INSERT INTO luticate_users_groups VALUES (4, 5);
  274. INSERT INTO luticate_users_groups VALUES (4, 4);
  275. --
  276. -- Name: luticate_users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dev
  277. --
  278. SELECT pg_catalog.setval('luticate_users_id_seq', 4, true);
  279. --
  280. -- Data for Name: sensor_types; Type: TABLE DATA; Schema: public; Owner: dev
  281. --
  282. INSERT INTO sensor_types VALUES (1, 'Dummy Sensor', 'App\Http\Business\Sensors\DummySensor', '{"Minimum": 0, "Maximum": 42}');
  283. INSERT INTO sensor_types VALUES (2, 'PiFace Digital', 'App\Http\Business\Sensors\PiFaceSensor', '{"Device": 0, "Pin":0, "True": "Openned", "False": "Closed"}');
  284. --
  285. -- Name: sensor_types_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dev
  286. --
  287. SELECT pg_catalog.setval('sensor_types_id_seq', 3, true);
  288. --
  289. -- Data for Name: sensors; Type: TABLE DATA; Schema: public; Owner: dev
  290. --
  291. INSERT INTO sensors VALUES (6, 'Dummy sensor', 'Get a random value', 9, 1, '{"Minimum":0,"Maximum":42}');
  292. INSERT INTO sensors VALUES (7, 'Dummy sensor 2', 'Get a negative random value', 9, 1, '{"Minimum":-42,"Maximum":0}');
  293. --
  294. -- Name: sensors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dev
  295. --
  296. SELECT pg_catalog.setval('sensors_id_seq', 7, true);
  297. --
  298. -- PostgreSQL database dump complete
  299. --