(10418,'remove','2024-04-30 16:20:32','8343','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8343;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-04-29 17:00:52.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-04-29 17:00:52.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:36:\"d374319cd798c9f20a7ac84c4b94a5b4.mp4\";s:8:\"duration\";i:30;s:11:\"description\";N;s:4:\"data\";a:1:{s:5:\"video\";s:82:\"https://eva50.serviceandmore.at/bl/data/files/d374319cd798c9f20a7ac84c4b94a5b4.mp4\";}s:8:\"position\";i:0;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:301;s:6:\"spotId\";i:4239;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";i:7;}','service_more'),(10419,'create','2024-04-30 16:20:42','8344','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-04-30 16:20:42.222102\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:36:\"6d92507828b1c85a9f1820f2ce211dd4.mp4\";s:11:\"description\";N;s:8:\"position\";i:0;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;}','service_more'),(10420,'create','2024-04-30 16:20:42','4240','DigitalSignage\\Entity\\Spot',1,'a:6:{s:4:\"name\";s:36:\"6d92507828b1c85a9f1820f2ce211dd4.mp4\";s:5:\"thumb\";s:89:\"https://eva50.serviceandmore.at/bl/data/files/thumbs/2a2532cb6759acbe2b3ff4b4907e317b.jpg\";s:4:\"data\";a:1:{s:5:\"video\";s:82:\"https://eva50.serviceandmore.at/bl/data/files/6d92507828b1c85a9f1820f2ce211dd4.mp4\";}s:11:\"description\";N;s:6:\"public\";b:0;s:10:\"changeable\";b:0;}','service_more'),(10421,'create','2024-04-30 16:20:42','8345','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-04-30 16:20:42.377759\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:36:\"6d92507828b1c85a9f1820f2ce211dd4.mp4\";s:11:\"description\";N;s:8:\"position\";i:1;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";N;s:7:\"enabled\";b:1;}','service_more'),(10422,'remove','2024-04-30 16:20:42','8344','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8344;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-04-30 16:20:42.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-04-30 16:20:42.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:36:\"6d92507828b1c85a9f1820f2ce211dd4.mp4\";s:8:\"duration\";i:30;s:11:\"description\";N;s:4:\"data\";a:1:{s:5:\"video\";s:82:\"https://eva50.serviceandmore.at/bl/data/files/6d92507828b1c85a9f1820f2ce211dd4.mp4\";}s:8:\"position\";i:0;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:301;s:6:\"spotId\";i:4240;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";i:7;}','service_more'),(10423,'create','2024-04-30 16:25:21','8346','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-04-30 16:25:21.700702\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:36:\"c41100a41b94eb26f89c032b96a928f2.mp4\";s:11:\"description\";N;s:8:\"position\";i:0;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;}','service_more'),(10424,'create','2024-04-30 16:25:21','4241','DigitalSignage\\Entity\\Spot',1,'a:6:{s:4:\"name\";s:36:\"c41100a41b94eb26f89c032b96a928f2.mp4\";s:5:\"thumb\";s:89:\"https://eva50.serviceandmore.at/bl/data/files/thumbs/1bc3083e397394a72ed1e40cda69b092.jpg\";s:4:\"data\";a:1:{s:5:\"video\";s:82:\"https://eva50.serviceandmore.at/bl/data/files/c41100a41b94eb26f89c032b96a928f2.mp4\";}s:11:\"description\";N;s:6:\"public\";b:0;s:10:\"changeable\";b:0;}','service_more'),(10425,'create','2024-04-30 16:25:21','8347','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-04-30 16:25:21.839075\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:36:\"c41100a41b94eb26f89c032b96a928f2.mp4\";s:11:\"description\";N;s:8:\"position\";i:2;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";N;s:7:\"enabled\";b:1;}','service_more'),(10426,'remove','2024-04-30 16:25:21','8346','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8346;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-04-30 16:25:21.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-04-30 16:25:21.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:36:\"c41100a41b94eb26f89c032b96a928f2.mp4\";s:8:\"duration\";i:30;s:11:\"description\";N;s:4:\"data\";a:1:{s:5:\"video\";s:82:\"https://eva50.serviceandmore.at/bl/data/files/c41100a41b94eb26f89c032b96a928f2.mp4\";}s:8:\"position\";i:0;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:301;s:6:\"spotId\";i:4241;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";i:7;}','service_more'),(10427,'update','2024-05-02 11:42:50','8345','DigitalSignage\\Entity\\ProgramSpot',2,'a:2:{s:8:\"position\";i:0;s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-02 11:42:50.089327\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}}','service_more'),(10428,'update','2024-05-02 11:42:50','8347','DigitalSignage\\Entity\\ProgramSpot',2,'a:2:{s:8:\"position\";i:1;s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-02 11:42:50.089381\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}}','service_more'),(10429,'remove','2024-05-02 11:42:50','8293','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8293;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-02-08 15:37:57.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-02-08 15:37:57.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:36:\"d374319cd798c9f20a7ac84c4b94a5b4.mp4\";s:8:\"duration\";i:0;s:11:\"description\";N;s:4:\"data\";N;s:8:\"position\";i:0;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:301;s:6:\"spotId\";i:4223;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";N;}','service_more'),(10430,'create','2024-05-02 11:44:17','8348','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-02 11:44:17.727835\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:36:\"4cc744c3a0a38f43a7a725463cb4e5e9.mp4\";s:11:\"description\";N;s:8:\"position\";i:0;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;}','service_more'),(10431,'create','2024-05-02 11:44:17','4242','DigitalSignage\\Entity\\Spot',1,'a:6:{s:4:\"name\";s:36:\"4cc744c3a0a38f43a7a725463cb4e5e9.mp4\";s:5:\"thumb\";s:89:\"https://eva50.serviceandmore.at/bl/data/files/thumbs/97b5152cee3bd9300a9a6a5705bce240.jpg\";s:4:\"data\";a:1:{s:5:\"video\";s:82:\"https://eva50.serviceandmore.at/bl/data/files/4cc744c3a0a38f43a7a725463cb4e5e9.mp4\";}s:11:\"description\";N;s:6:\"public\";b:0;s:10:\"changeable\";b:0;}','service_more'),(10432,'create','2024-05-02 11:44:17','8349','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-02 11:44:17.909804\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:36:\"4cc744c3a0a38f43a7a725463cb4e5e9.mp4\";s:11:\"description\";N;s:8:\"position\";i:2;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";N;s:7:\"enabled\";b:1;}','service_more'),(10433,'remove','2024-05-02 11:44:17','8348','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8348;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-02 11:44:17.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-02 11:44:17.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:36:\"4cc744c3a0a38f43a7a725463cb4e5e9.mp4\";s:8:\"duration\";i:30;s:11:\"description\";N;s:4:\"data\";a:1:{s:5:\"video\";s:82:\"https://eva50.serviceandmore.at/bl/data/files/4cc744c3a0a38f43a7a725463cb4e5e9.mp4\";}s:8:\"position\";i:0;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:301;s:6:\"spotId\";i:4242;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";i:7;}','service_more'),(10434,'create','2024-05-02 11:54:09','8350','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-02 11:54:09.087776\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:36:\"d374319cd798c9f20a7ac84c4b94a5b4.mp4\";s:11:\"description\";N;s:8:\"position\";i:0;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;}','service_more'),(10435,'create','2024-05-02 11:54:09','4243','DigitalSignage\\Entity\\Spot',1,'a:6:{s:4:\"name\";s:36:\"d374319cd798c9f20a7ac84c4b94a5b4.mp4\";s:5:\"thumb\";s:89:\"https://eva50.serviceandmore.at/bl/data/files/thumbs/60b1791a96b580c46a7c86d1b5aaeee8.jpg\";s:4:\"data\";a:1:{s:5:\"video\";s:82:\"https://eva50.serviceandmore.at/bl/data/files/d374319cd798c9f20a7ac84c4b94a5b4.mp4\";}s:11:\"description\";N;s:6:\"public\";b:0;s:10:\"changeable\";b:0;}','service_more'),(10436,'create','2024-05-02 11:54:09','8351','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-02 11:54:09.218551\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:36:\"d374319cd798c9f20a7ac84c4b94a5b4.mp4\";s:11:\"description\";N;s:8:\"position\";i:3;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";N;s:7:\"enabled\";b:1;}','service_more'),(10437,'remove','2024-05-02 11:54:09','8350','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8350;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-02 11:54:09.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-02 11:54:09.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:36:\"d374319cd798c9f20a7ac84c4b94a5b4.mp4\";s:8:\"duration\";i:30;s:11:\"description\";N;s:4:\"data\";a:1:{s:5:\"video\";s:82:\"https://eva50.serviceandmore.at/bl/data/files/d374319cd798c9f20a7ac84c4b94a5b4.mp4\";}s:8:\"position\";i:0;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:301;s:6:\"spotId\";i:4243;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";i:7;}','service_more'),(10438,'create','2024-05-29 09:36:47','8352','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:36:47.703993\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:36:\"bf36d8851aacd32032497ff6bc22ef3e.jpg\";s:11:\"description\";N;s:8:\"position\";i:0;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;}','service_more'),(10439,'create','2024-05-29 09:36:47','4244','DigitalSignage\\Entity\\Spot',1,'a:6:{s:4:\"name\";s:36:\"bf36d8851aacd32032497ff6bc22ef3e.jpg\";s:5:\"thumb\";s:89:\"https://eva50.serviceandmore.at/bl/data/files/thumbs/c879bd428dbae83d38b9f4fb6de548f6.jpg\";s:4:\"data\";a:1:{s:5:\"image\";s:82:\"https://eva50.serviceandmore.at/bl/data/files/bf36d8851aacd32032497ff6bc22ef3e.jpg\";}s:11:\"description\";N;s:6:\"public\";b:0;s:10:\"changeable\";b:0;}','service_more'),(10440,'create','2024-05-29 09:36:47','8353','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:36:47.866424\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:36:\"bf36d8851aacd32032497ff6bc22ef3e.jpg\";s:11:\"description\";N;s:8:\"position\";i:2;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";N;s:7:\"enabled\";b:1;}','service_more'),(10441,'remove','2024-05-29 09:36:47','8352','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8352;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:36:47.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:36:47.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:36:\"bf36d8851aacd32032497ff6bc22ef3e.jpg\";s:8:\"duration\";i:30;s:11:\"description\";N;s:4:\"data\";a:1:{s:5:\"image\";s:82:\"https://eva50.serviceandmore.at/bl/data/files/bf36d8851aacd32032497ff6bc22ef3e.jpg\";}s:8:\"position\";i:0;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:263;s:6:\"spotId\";i:4244;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";i:7;}','service_more'),(10442,'remove','2024-05-29 09:36:55','8353','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8353;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:36:47.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:36:47.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:36:\"bf36d8851aacd32032497ff6bc22ef3e.jpg\";s:8:\"duration\";i:0;s:11:\"description\";N;s:4:\"data\";N;s:8:\"position\";i:2;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:263;s:6:\"spotId\";i:4244;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";N;}','service_more'),(10443,'create','2024-05-29 09:40:06','8354','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:06.299101\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:12:\"Image Spot 2\";s:11:\"description\";N;s:8:\"position\";i:1;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";N;s:7:\"enabled\";b:1;}','service_more'),(10444,'create','2024-05-29 09:40:08','8355','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:08.218216\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:12:\"Image Spot 2\";s:11:\"description\";N;s:8:\"position\";i:1;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";N;s:7:\"enabled\";b:1;}','service_more'),(10445,'create','2024-05-29 09:40:08','8356','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:08.218503\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:12:\"Image Spot 2\";s:11:\"description\";N;s:8:\"position\";i:2;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";N;s:7:\"enabled\";b:1;}','service_more'),(10446,'remove','2024-05-29 09:40:08','8354','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8354;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:06.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:06.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:12:\"Image Spot 2\";s:8:\"duration\";i:0;s:11:\"description\";N;s:4:\"data\";N;s:8:\"position\";i:1;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:191;s:6:\"spotId\";i:3988;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";N;}','service_more'),(10447,'create','2024-05-29 09:40:09','8357','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:09.812790\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:12:\"Image Spot 2\";s:11:\"description\";N;s:8:\"position\";i:1;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";N;s:7:\"enabled\";b:1;}','service_more'),(10448,'create','2024-05-29 09:40:09','8358','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:09.813058\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:12:\"Image Spot 2\";s:11:\"description\";N;s:8:\"position\";i:2;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";N;s:7:\"enabled\";b:1;}','service_more'),(10449,'create','2024-05-29 09:40:09','8359','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:09.813299\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:12:\"Image Spot 2\";s:11:\"description\";N;s:8:\"position\";i:3;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";N;s:7:\"enabled\";b:1;}','service_more'),(10450,'remove','2024-05-29 09:40:09','8355','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8355;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:08.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:08.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:12:\"Image Spot 2\";s:8:\"duration\";i:0;s:11:\"description\";N;s:4:\"data\";N;s:8:\"position\";i:1;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:191;s:6:\"spotId\";i:3988;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";N;}','service_more'),(10451,'remove','2024-05-29 09:40:09','8356','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8356;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:08.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:08.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:12:\"Image Spot 2\";s:8:\"duration\";i:0;s:11:\"description\";N;s:4:\"data\";N;s:8:\"position\";i:2;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:191;s:6:\"spotId\";i:3988;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";N;}','service_more'),(10452,'create','2024-05-29 09:40:17','8360','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:17.076125\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:12:\"Image Spot 2\";s:11:\"description\";N;s:8:\"position\";i:1;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";N;s:7:\"enabled\";b:1;}','service_more'),(10453,'create','2024-05-29 09:40:17','8361','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:17.076439\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:12:\"Image Spot 2\";s:11:\"description\";N;s:8:\"position\";i:2;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";N;s:7:\"enabled\";b:1;}','service_more'),(10454,'remove','2024-05-29 09:40:17','8357','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8357;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:09.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:09.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:12:\"Image Spot 2\";s:8:\"duration\";i:0;s:11:\"description\";N;s:4:\"data\";N;s:8:\"position\";i:1;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:191;s:6:\"spotId\";i:3988;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";N;}','service_more'),(10455,'remove','2024-05-29 09:40:17','8358','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8358;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:09.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:09.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:12:\"Image Spot 2\";s:8:\"duration\";i:0;s:11:\"description\";N;s:4:\"data\";N;s:8:\"position\";i:2;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:191;s:6:\"spotId\";i:3988;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";N;}','service_more'),(10456,'remove','2024-05-29 09:40:17','8359','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8359;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:09.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:09.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:12:\"Image Spot 2\";s:8:\"duration\";i:0;s:11:\"description\";N;s:4:\"data\";N;s:8:\"position\";i:3;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:191;s:6:\"spotId\";i:3988;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";N;}','service_more'),(10457,'create','2024-05-29 09:40:17','8362','DigitalSignage\\Entity\\ProgramSpot',1,'a:11:{s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:17.631225\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:4:\"name\";s:12:\"Image Spot 2\";s:11:\"description\";N;s:8:\"position\";i:1;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";N;s:7:\"enabled\";b:1;}','service_more'),(10458,'remove','2024-05-29 09:40:17','8360','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8360;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:17.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:17.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:12:\"Image Spot 2\";s:8:\"duration\";i:0;s:11:\"description\";N;s:4:\"data\";N;s:8:\"position\";i:1;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:191;s:6:\"spotId\";i:3988;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";N;}','service_more'),(10459,'remove','2024-05-29 09:40:17','8361','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8361;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:17.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:17.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:12:\"Image Spot 2\";s:8:\"duration\";i:0;s:11:\"description\";N;s:4:\"data\";N;s:8:\"position\";i:2;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:191;s:6:\"spotId\";i:3988;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";N;}','service_more'),(10460,'remove','2024-05-29 09:40:18','8362','DigitalSignage\\Entity\\ProgramSpot',2,'a:21:{s:2:\"id\";i:8362;s:7:\"created\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:17.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:7:\"updated\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2024-05-29 09:40:17.000000\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:16:\"Europe/Amsterdam\";}s:9:\"updatedBy\";s:12:\"service_more\";s:4:\"name\";s:12:\"Image Spot 2\";s:8:\"duration\";i:0;s:11:\"description\";N;s:4:\"data\";N;s:8:\"position\";i:1;s:8:\"dateFrom\";N;s:6:\"dateTo\";N;s:8:\"timeFrom\";s:5:\"00:00\";s:6:\"timeTo\";s:5:\"24:00\";s:11:\"timeEnabled\";b:0;s:8:\"weekdays\";a:0:{}s:7:\"enabled\";b:1;s:9:\"programId\";i:191;s:6:\"spotId\";i:3988;s:20:\"programSpotScreensId\";N;s:23:\"programSpotCategoriesId\";N;s:9:\"mandateId\";N;}','service_more');

--
-- Table structure for table `sys_mandate`
--

CREATE TABLE `sys_mandate` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `updatedBy` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sys_mandate`
--

INSERT INTO `sys_mandate` VALUES (1,'2016-09-19 14:35:50','2016-09-19 14:35:52','peter','Radatz'),(2,'2016-09-19 14:35:50','2016-09-19 14:35:52','peter','Radatz (Test)'),(3,'2017-04-21 17:18:20','2017-04-21 17:18:21','peter','ElectronicPartner'),(4,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,'JT'),(5,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,'Post'),(6,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,'XXXLutz'),(7,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,'Service&More');

--
-- Table structure for table `sys_user`
--

CREATE TABLE `sys_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `retailer_id` int(11) DEFAULT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `updatedBy` varchar(255) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL,
  `admin` tinyint(1) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `firstName` varchar(255) NOT NULL,
  `lastName` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `language` varchar(255) NOT NULL,
  `userRole_id` int(10) unsigned NOT NULL,
  `mandate_id` int(10) unsigned DEFAULT NULL,
  `token` varchar(256) DEFAULT NULL,
  `tokenExpiration` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_A52FF2C2F85E0677` (`username`),
  KEY `IDX_A52FF2C223F5ED09` (`retailer_id`),
  KEY `IDX_A52FF2C285DFE78E` (`userRole_id`),
  KEY `IDX_A52FF2C26C1129CD` (`mandate_id`),
  CONSTRAINT `FK_A52FF2C223F5ED09` FOREIGN KEY (`retailer_id`) REFERENCES `ds_retailer` (`id`),
  CONSTRAINT `FK_A52FF2C26C1129CD` FOREIGN KEY (`mandate_id`) REFERENCES `sys_mandate` (`id`),
  CONSTRAINT `FK_A52FF2C285DFE78E` FOREIGN KEY (`userRole_id`) REFERENCES `sys_user_role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sys_user`
--

INSERT INTO `sys_user` VALUES (41,58,'0000-00-00 00:00:00','2018-11-21 15:35:34','service_more',1,1,'service_more','$2y$04$Fh.eIjM5nn8Ky.vXrCVqdOo/UC07uzP3/2.Wwb8DfUm1bBzgKauIO','','',NULL,'',13,7,NULL,'0000-00-00 00:00:00');

--
-- Table structure for table `sys_user_role`
--

CREATE TABLE `sys_user_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `updatedBy` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `mandate_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sys_user_role`
--

INSERT INTO `sys_user_role` VALUES (1,'2019-10-17 12:47:12','2019-10-17 12:47:16',NULL,'Admin','1'),(2,'2015-06-01 09:50:15','2015-06-01 09:50:17',NULL,'Admin','1'),(3,'2015-07-08 10:34:25','2015-07-08 10:34:21','admin','Retailer','1'),(4,'2016-09-07 16:24:57','2016-09-07 16:24:57','admin','Redakteur','1'),(13,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,'Admin','7'),(14,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,'Retailer','7');

--
-- Table structure for table `sys_user_role_permission`
--

CREATE TABLE `sys_user_role_permission` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `updatedBy` varchar(255) NOT NULL,
  `api` varchar(255) NOT NULL,
  `privileges` longtext DEFAULT NULL COMMENT '(DC2Type:simple_array)',
  `readFields` longtext DEFAULT NULL COMMENT '(DC2Type:simple_array)',
  `updateFields` longtext DEFAULT NULL COMMENT '(DC2Type:simple_array)',
  `userRole_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_idx` (`userRole_id`,`api`),
  KEY `IDX_9213AB5E85DFE78E` (`userRole_id`),
  CONSTRAINT `FK_9213AB5E85DFE78E` FOREIGN KEY (`userRole_id`) REFERENCES `sys_user_role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sys_user_role_permission`
--

INSERT INTO `sys_user_role_permission` VALUES (134,'2019-10-17 13:02:33','2019-10-17 13:02:41','admin','label','read',NULL,NULL,1),(136,'2019-10-17 13:02:33','2019-10-17 13:02:41','admin','label','read',NULL,NULL,2);


