INSERT INTO `country` (`id`, `name`, `acronym`, `flag`, `status`, `region`) VALUES
(27, 'Venezuela', 'VEN', 0x[encoded data, 14852 characters], 1, NULL),
(28, 'Jamaica', 'JAM', 0x646174613a696d6167652f706e673b6261736536342c6956424f5277304b47676f414141414e5355684555674141416b51414141456942414d41414144716939437a414141414c56424d5645582b305144467851314e717967416d7a6f3871437939784138384d5143396e4144466f67424e50774141414142464f5144456f514445784131467169716d6a6370734141414646556c455156523441657a5151534547415141473063326769677979794b4c4b6c67544d426643626b2f4739434f2f34777458317633487a31634f4f474e715247464a48472b4a6f512b5a6f5178787479427874694b4d4e6d614d4e63625168636251686a6a596b6a6a6245305962453059593432704134326842482f6145644d62516a4d62516a686e626b682f7a5268735452686a6a61554f7849444e33326a397a51335848326a397a51655a7a39497a6630564e512f4d6b4d7652666b6a4d5552522f6b674d5556512f4d6b4d5574592f5545455870497a644555666c49446c455550724a44464857503942424632534d2f524a452f7967355235492b79517854356f2b77515266346f4f30535250386f4f55525138386b5076692f7852636f6969334a45622b723749483457474b496f642b614876692f78525a6f6969314a45662b723749483457474b416f642b614876692f7852616f6969787045592b6d325250776f4d555a5134456b4f69794234466869684b484b6b685565534f416b4d55425937636b4367535234456869674a48596b67562b61504130484e523445674d32534a2f39486547664e454463335a5342434151413146554c7435474177377767414d386f49486c316339396c75525633376f33386b4a6669586f6a4c6653644b445543516f4149474a5643674167596c554b4143426956516f4149474a56436745676142554b57794274354955766b6a6279514a664a475873675365534d765a496d386b526579524e374943316b69622b53464c4a4533386b4b57794274354955766b6a6279514a664a475873675365534d765a496d386b526579524e374943316b69622b53464c4a4533386b4b57794274354955766b6a6279514a664a475873675365534d765a496d386b526579524e374943326b6962365346504a4533306b4b657942747049552f6b6a6253514a2f4a475773675465534d7435496d386b526279524e354943336b6962365346504a4533306b4b657942747049552f6b6a6253514a2f4a475773675465534d7435496d386b526279524e354943336b6962365346504a4533306b4b657942747049552f6b6a594451574b4b3176317231764635644f395a554970416a6e794650354932386b436679526c374945336b6a4c2b534a764a4558386b546579417435496d2f6b685479524e2f4a436e73676265534650354932386b436679526c374945336b6a4c2b534a764a4558386b546579417435496d7a6b685479524e664a436e736761655346505a4932386b436579526c374945316b6a4c2b534a724a4558386b545779417435496d766b685479524e664a436e736761655346505a4932386b43636958545a6f7065635462546637396b454151417a444d4c41597768397361546a4f51666a524b536e384a7a4c51544e63576656744857306348454d64596c79477531467a4d7574344869586f6845645149574e4d6579444d554c434a666a77354b4279555655394d46446a495a735658384b354c7343542f5473485165796e35702f39436b5a66716676547367414143415941445776375557344375796f5179414747645a4661774b6e416678424172447a55454c37394358364575414b6f5958356f77454238766667655831424a494c56597077353037627047325366796e6b5249513679777370716852567253746f316e7a4c3471657a2b4b7157446f67594241416f684e4a703964646748577867427a4f6f342b354468486349516e74476a41734e474445674e473745674e433445654e434130614d437730594d533430594d53343049415234304944526f774c445267784c6a5267784c6a516742486a51674e476a41734e474445754e474445674e433445514e433430594d434930624d53413062735341304c6752766c44644346306f623451743144664346756f62595176316a6243462b6b6259516e306a624b472b45625a513377686271472b454c6451336f69396b4732454c395932776866704732454a394932796876684732554e384957366876684333554e38495736687468432f574e734958365274684366534e736f623452746c44664346756f623451743144664346756f62595176316a6243462b6b6259516e306a624b472b45625a513377686271472b454c645133776862714732454c395932776866704732454a394932796876684732554e2b494c3038365073464f6e76536a2f35443955562f494e2b6f4c2b555a3949642b6f4c2b5162395956386f37365162395158386f3336517235525838673336677635526e306833366776354276316858796a76704276314266796a667043766c466679446671432f6c476653486671432f6b472f5746664b4f2b6b472f55462f4b4e2b6b4b2b55562f494e346f4b43555958544156564a38484f51783841414141415355564f524b35435949493d, 1, NULL),
(29, 'Martinique', 'MTQ', 0x[encoded data, 25342 characters], 1, NULL);
INSERT INTO `country` (`id`, `name`, `acronym`, `flag`, `status`, `region`) VALUES
(30, 'World', 'WR', 0x[encoded data, 69860 characters], 2, NULL);

-- --------------------------------------------------------
--
-- Dumping data for table `system`
--

INSERT INTO `system_` (`id`, `name`, `description`, `order`) VALUES
(1, 'INVENTORY', 'INVENTORY', 3),
(2, 'CARPARK', 'CARPARK', 1),
(3, 'CAPACITY', 'CAPACITY', 2),
(4, 'PLANING', 'PLANNING', 4);

-- --------------------------------------------------------
--
-- Dumping data for table `module`
--

INSERT INTO `module` (`id`, `route`, `description`, `system_id`, `favicon`) VALUES(1, 'carpark_dash', 'DashBoard', 2, '<i class=\"fa fas fa-home\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(2, 'admin', 'DashBoard', 1, '<i class=\"fa fas fa-home\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(3, 'service_level', 'Service Level', 1, '<i class=\"fa fas fa-signal\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(4, 'product_search', 'Product Search', 1, '<i class=\"fa fas fa-book\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(5, 'user_uploaded', 'User Upload', 1, '<i class=\"fa far fa-copy\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(6, 'countries', 'Parameters', 1, '<i class=\"fa fas fa-globe\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(7, 'user', 'DashBoard', 1, '<i class=\"fa fas fa-home\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(8, 'service_level_user', 'Service Level', 1, '<i class=\"fa fas fa-signal\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(9, 'upload', 'Upload', 1, '<i class=\"fa fas fa-upload\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(10, 'files_uploaded', 'Files Uploaded', 1, '<i class=\"fa fas fa-copy\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(11, 'product_search_user', 'Product Search', 1, '<i class=\"fa fas fa-book\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(12, 'carpark_load_sales', 'Upload', 2, '<i class=\"fa fas fa-upload\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(13, 'index_capacity', 'Service Capacity per Market', 3, '<i class=\"fa fas fa-home\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(14, 'view_market_capacity', 'Market Capacity', 3, '<i class=\"fa fas fa-book\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(15, 'upload_capacity', 'Upload Capacity', 3, '<i class=\"fa fas fa-upload\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(16, 'carpark_models', 'Modules', 2, '<i class=\"fa fas fa-book\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(18, 'edit_capacity_market', 'Edit Market Capacity', 3, '<i class=\"fa fas fa-signal\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(19, 'countries_list', 'Parameters', 1, '<i class=\"fa fas fa-globe\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(20, 'planing_homepage', 'DashBoard', 4, '<i class=\"fa fas fa-home\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(21, 'planing_target', 'Target FY 2018', 4, '<i class=\"fa fas fa-book\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(22, 'planing_sales', 'PAG Purchases', 4, '<i class=\"fa fas fa-signal\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(23, 'planing_forecast', 'Forecast', 4, '<i class=\"fa fas fa-fire\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(24, 'planing_one_time_effects', 'One Time Effects<small> Summary</small>', 4, '<i class=\"fa fas fa-upload\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(25, 'planing_effects_country', 'Effects per Country', 4, '<i class=\"fa fas fa-copy\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(26, 'planing_effects_creation', 'Effects Creation', 4, '<i class=\"fa fas fa-plus\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(27, 'planing_carpark_evolution', 'Carpark Evolution', 4, '<i class=\"fa fas fa-cog\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(28, 'carpark_download_all_year', 'RY', 1, '<i class=\"fa fas fa-cog\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(29, 'planing_segment_penetration', 'Segment Penetration', 4, '<i class=\"fa fas fa-puzzle-piece\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(30, 'carpark_all_year', 'Total Carpark Report', 1, '<i class=\"fa fas fa-asterisk\"></i>');
INSERT INTO `module`(`id`, `route`, `description`, `system_id`, `favicon`) VALUES(31, 'planing_target_negotiated', 'Target Negotiated 2019', 4, '<i class=\"fa fas fa-book\"></i>');

-- --------------------------------------------------------
--
-- Dumping data for table `group_module`
--

INSERT INTO `group_module` (`id`, `code_group`, `module_id`) VALUES
(1, 'admin_imt', 2),
(2, 'admin_imt', 3),
(3, 'admin_imt', 4),
(4, 'admin_imt', 5),
(5, 'admin_imt', 6),
(6, 'market_imt', 7),
(7, 'market_imt', 8),
(8, 'market_imt', 9),
(9, 'market_imt', 10),
(10, 'market_imt', 11),
(11, 'pla_imt', 2),
(12, 'pla_imt', 3),
(13, 'pla_imt', 4),
(14, 'admin_carpark', 1),
(15, 'market_carpark', 1),
(16, 'admin_carpark', 12),
(17, 'pla_carpark', 1),
(18, 'pla_imt', 5),
(19, 'pla_imt_country', 7),
(20, 'pla_imt_country', 8),
(21, 'pla_imt_country', 11),
(22, 'admin_capacity', 13),
(23, 'pla_capacity', 13),
(24, 'market_capacity', 14),
(25, 'admin_capacity', 15),
(26, 'admin_carpark', 16),
(27, 'market_capacity_country', 14),
(28, 'market_capacity_country', 18),
(29, 'pla_imt', 19),
(30, 'pla_imt_country', 19),
(31, 'market_imt', 19),
(32, 'admin_planning', 20),
(33, 'admin_planning', 21),
(34, 'admin_planning', 22),
(35, 'admin_planning', 23),
(36, 'market_planning', 20),
(39, 'market_planning', 21),
(40, 'market_planning', 22),
(41, 'market_planning', 23),
(42, 'admin_planning', 24),
(43, 'admin_planning', 25),
(44, 'admin_planning', 26),
(45, 'market_planning', 24),
(46, 'admin_planning', 27),
(47, 'pla_planning', 20),
(48, 'pla_planning', 21),
(49, 'pla_planning', 22),
(50, 'pla_planning', 23),
(51, 'pla_planning', 24),
(52, 'pla_planning', 25),
(53, 'pla_planning', 26),
(54, 'pla_planning', 27),
(56, 'admin_planning', 29),
(57, 'market_planning', 29),
(58, 'market_planning', 27),
(59, 'admin_carpark', 30),
(61, 'market_carpark', 30),
(62, 'admin_planning', 31),
(63, 'market_planning', 31),
(64, 'pla_planning', 31);

-- --------------------------------------------------------
--
-- Dumping data for table `role`
--

INSERT INTO `role` (`id`, `name`, `description`) VALUES
(1, 'Administrator', 'ROLE_ADMIN'),
(2, 'PLA', 'ROLE_PLA'),
(5, 'Market', 'ROLE_MARKET');

-- --------------------------------------------------------
--
-- Dumping data for table `group_system`
--

INSERT INTO `group_system` (`id`, `code_group`, `name`, `role_id`, `system_id`) VALUES
(1, 'admin_imt', 'View and Edit', 1, 1),
(2, 'market_imt', 'Upload', 5, 1),
(3, 'pla_imt', 'View', 2, 1),
(4, 'admin_carpark', 'View and  Edit', 1, 2),
(5, 'market_carpark', 'View Market', 5, 2),
(6, 'pla_carpark', 'View', 2, 2),
(7, 'pla_imt_country', 'View Market', 5, 1),
(8, 'admin_capacity', 'View and Edit', 1, 3),
(9, 'pla_capacity', 'View', 2, 3),
(10, 'market_capacity', 'View Market', 5, 3),
(11, 'market_capacity_country', 'View and Edit Market', 5, 3),
(12, 'admin_planning', 'View and Edit', 1, 4),
(13, 'market_planning', 'View and Edit Market', 5, 4),
(14, 'pla_planning', 'View', 2, 4);

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `complete_name`, `username`, `password`, `role_id`, `active`) VALUES
(1, 'ADMINISTRATOR', 'ADMIN IM', '2e658e4ab8de553f3d774f7437f23d52', 1, 1),
(8, 'Fernando Rosas', 'Fernando_Rosas', '16ec922e3f1d48030e7f4e8f1ce27c17', 2, 1),
(9, 'Jeanette Rieger', 'Jeanette_Rieger', '0cc902d6eb476987870a4e613f63c844', 2, 1),
(10, 'Marisela Schneck', 'Marisela_Schneck', '4c73cf9550d85c20854fadc478067ea8', 2, 1),
(11, 'Eduardo Melo', 'Eduardo_Melo', '0d820175f592aa025e6f964dab7e6df1', 2, 1),
(12, 'Frank Basler', 'Frank_Basler', '8c5802074353e6b0d7cb69ac85b34676', 2, 1),
(13, 'Esteban Rico', 'Esteban_Rico', '8d0d59044951768c8f370b4828dffcf5', 2, 1),
(20, 'Eduardo Chavarria', 'echavarria', 'e5f4566206819b0c344e9bcf646ef1df', 5, 1),
(77, 'Horacio Alvarenga', 'halvarenga', 'b96dd66f458e8508033ff279e8f6bfbf', 5, 1),
(78, 'Sergio Llano', 'sllano', '2f9bd5e92c4a91a6614521b52164b218', 5, 1),
(80, 'Freddy Camina', 'fcamina', 'abc27353e25a21fcbef62b5086ef257e', 5, 1),
(81, 'Humberto Carlo', 'hcarlo', '5e811303e482cc8adad4d5d58f62f4aa', 5, 1),
(83, 'Jhonatan Toro', 'jtoro', 'a0afa20d5bd09e324034b2c7e20c153c', 5, 1),
(87, 'Raul Civiello', 'rciviello', '1b021d20d72a71201d84f87fe2be9c6e', 5, 1),
(88, 'Diego Cuestas', 'dcuestas', '847503572c3ed28a14ef07c6990e5823', 5, 1),
(89, 'Santos Garcia', 'sgarcia', 'aef756e2668e4cd35494996451a8b891', 5, 1),
(90, 'Anthony David', 'adavid', '9631d63ce826a0e14e6428f632711f00', 5, 1),
(92, 'Vicente Diaz Chile', 'vdiaz_chile', 'b63d5202da9c2e9e11c1747438db418c', 5, 1),
(94, 'Bruce DuQuesnay', 'bduquesnay', 'ef49c6fac4abb9c6bcdb1f5d0cdbba9b', 5, 1),
(96, 'Julian Naranjo', 'jnaranjo', 'fd207c06a2d6208ca10edcbe87d1fe47', 5, 1),
(98, 'Mike Ellenthorpe', 'mellenthorpe', 'a29526f08a5cbb1ed103f626d2a273c1', 5, 1),
(99, 'Christian Feucht', 'cfeucht', '8153cfa684b4640f746c6ac9613534e1', 5, 1),
(100, 'Daniel Andia', 'dandia', 'e28fe4062f51f7031de888de0a8e1777', 5, 1),
(101, 'Giovanni Fiorio', 'gfiorio', '350ff1201d500df4d7b2fd2cba33d32f', 5, 1),
(102, 'Gonzalo Flechelle', 'gflechelle', 'eae894d9bb25146d83d283245c57645f', 5, 1),
(103, 'Eugen Auer', 'eauer', '3673f106ef25e6510d4bf6619ad21816', 5, 1),
(104, 'Alfredo Gantz Chile', 'agantz_chile', '145cb5d04c74be81dcdb17cc14d60139', 5, 1),
(106, 'Gustavo Gioia', 'ggioia', '3936f6f4616977db30baa090a9bf7460', 5, 1),
(107, 'Jose Manuel Marquez Chile', 'jmarquez_chile', '40dc21b22d260a8d41f0957eae795a51', 5, 1),
(109, 'Bernard Hadeed', 'bhadeed', '9a5839c6efbb810777f126d9fb60802b', 5, 1),
(111, 'Jose David Ponce DomRep', 'jponce_domrep', '5440fe1ae9c85762244636e75e1c7504', 5, 1),
(114, 'Steven James', 'sjames', '8b331ee87480bd11ff01e6ae60a6f9e9', 5, 1),
(115, 'Gabriel Kornuta', 'gkornuta', '9ab759e79c5168f99aafedd86c3a983c', 5, 1),
(117, 'Maricet Leyva', 'mleyva', '70a287fea486664bf0b28732b84a4ae9', 5, 1),
(119, 'Christophe Nisus', 'cnisus', '986ce155207877ed4caedb6f21c8b9be', 5, 1),
(120, 'Noe Martinez', 'nmartinez', '62a672bb9d30d89f781a528629dc6e42', 5, 1),
(121, 'Juan Manuel Mendez', 'jmendez', 'b63dde114b1d9872928a58454db41ed6', 5, 1),
(122, 'Arturo Monzon DomRep', 'amonzon_domrep', 'fde229b7c92fda493531099e1d7e1731', 5, 1),
(125, 'Mark Wilmot', 'mwilmot', '24921b1f76fb21b43d6614cc8b445959', 5, 1),
(126, 'Avinash Rampersad', 'arampersad', '57a3c3597c473281b8d3a5e728469410', 5, 1),
(127, 'Marcelo Rossetti', 'mrossetti', '62f0740443b8390aa1fea687523cf9fb', 5, 1),
(128, 'Daniel Santiago', 'dsantiago', 'd9d0cc7f5ac15797101d02b5134a2aa5', 5, 1),
(129, 'Jorge I Santiago', 'jsantiago', 'da84c904c17fa915b9f21d82d5f6c8d9', 5, 1),
(130, 'Nigel Pilgrim', 'npilgrim', '595148f753f001f41fc5370072e0d078', 5, 1),
(131, 'Romina Telch', 'rtelch', '4d07ae418c4c62ce294d94915faf26c6', 5, 1),
(132, 'Denisse Vasquez', 'dvasquez', '281a457a659762f4e380cde3cbf2e744', 5, 1),
(133, 'Santiago Utreras', 'sutreras', '8719da95678928c8c502fc69892a41ec', 5, 1),
(134, 'Jorge Mirazo', 'Jorge_Mirazo', 'cd4b20a016cb3a2d0214ad777b2e980a', 2, 1),
(135, 'Oliver Ruggilo', 'oruggilo', '3717e06fd1658899eedb6cc18b5d32f3', 5, 1),
(136, 'Jonthan Esquivel', 'jesquivel', 'b397ab18c2eb114244760cb0f6a0d576', 5, 1),
(137, 'Lilian Lomba', 'Lilian_Lomba', '8f27bc83407c710fa05205a7c2393c8e', 2, 1),
(138, 'Giovanni Ruffatti', 'gruffatti', 'bd2bc29f9be9696e3d777a966e6f2024', 5, 1),
(144, 'William Ramirez', 'wramirez', '6eebc6660c6e17ba8fdab33179ff5b36', 5, 1),
(157, 'Jorge Behar', 'jbehar', '1af8ccecd9ec9a9319dcfb14a5497f0b', 5, 1),
(159, 'Carlos Barahona', 'cbarahona', 'a414234db7732e1bb4a062724c9e0625', 5, 1),
(160, 'Hugo Ernesto Mancia', 'hmancia', 'e5465d4e572ef6500e7ae79a8d8e0973', 5, 1),
(162, 'Martin Galvez', 'mgalvez', '96307e81073db4bd9966ec5e3a45c14e', 5, 1),
(163, 'Jose Luis Cabre', 'Jose_Cabre', 'ca882bcc94ab89313a25fcf02685be48', 2, 1),
(164, 'Yeison Aguirre', 'yaguirre', '89c3344f4659e6503ed2ea1324652556', 5, 1),
(165, 'Harold Beaugendre', 'hbeaugendre', '566dd2028f737ac162734737ba6aa4a6', 5, 1),
(167, 'Jorge Becerra', 'jbecerra_domrep', '181bc67eccdeb22733bdac3deae97ebb', 5, 1),
(168, 'Victor Andrade', 'vandrade', '10b9bd50454ae65f2f8d0b2a9140cd9a', 5, 1),
(169, 'Paulina Acuna', 'pacuna', '41277b237270ddc1ff5ee995f91facb1', 5, 1),
(170, 'Ana Castillo', 'acastillo', 'ca158c145abe589bc572f31d612227a5', 5, 1),
(171, 'Carlos Henry', 'chenry', 'e58486786adacf8a643b67c7b0c3b558', 5, 1),
(172, 'Jose Manuel Roque', 'jroque', 'c595b2340d9e7219ed7a3cf0cd4befa1', 5, 1),
(173, 'Frederick Meyer', 'Frederick_Meyer', 'eff2131222006e64d85a7ec45b337e2c', 2, 1),
(174, 'Eduardo Melo MX', 'emelomx', '6a287a77aab7b4283998579cbc1ad956', 5, 1),
(175, 'Francesca Fares', 'ffares', 'bddaeae66e3e5901c9a38ce64b5d5dd5', 5, 1),
(176, 'Fernando Rosas', 'frosas', 'b8c3f357c29a0812030f6e5d3e807a00', 5, 1);

-- --------------------------------------------------------
--
-- Dumping data for table `user_country`
--

INSERT INTO `user_country` (`user_id`, `country_id`) VALUES
(1, 30),
(2, 1),
(3, 30),
(4, 30),
(5, 14),
(6, 7),
(7, 8),
(8, 30),
(9, 30),
(10, 30),
(11, 30),
(12, 30),
(15, 1),
(20, 8),
(77, 20),
(78, 1),
(80, 21),
(81, 19),
(83, 19),
(87, 19),
(88, 14),
(89, 14),
(90, 13),
(92, 6),
(94, 28),
(96, 7),
(98, 28),
(99, 14),
(100, 21),
(101, 20),
(102, 21),
(103, 20),
(104, 6),
(106, 1),
(107, 6),
(109, 25),
(111, 10),
(114, 28),
(115, 1),
(117, 28),
(119, 13),
(120, 17),
(121, 11),
(122, 10),
(125, 28),
(126, 25),
(127, 1),
(128, 22),
(129, 22),
(130, 25),
(131, 1),
(132, 19),
(13, 30),
(133, 11),
(134, 30),
(135, 20),
(136, 20),
(137, 30),
(138, 12),
(144, 11),
(157, 7),
(159, 6),
(160, 12),
(162, 6),
(163, 30),
(164, 7),
(165, 13),
(167, 10),
(168, 17),
(169, 17),
(170, 17),
(171, 17),
(172, 17),
(173, 30),
(174, 17),
(175, 25),
(176, 7);

-- --------------------------------------------------------
--
-- Dumping data for table `user_group_system`
--

INSERT INTO `user_group_system` (`user_id`, `group_system_id`) VALUES
(1, 1),
(1, 8),
(1, 4),
(13, 3),
(8, 3),
(10, 1),
(11, 3),
(12, 3),
(77, 7),
(78, 2),
(80, 2),
(81, 7),
(83, 2),
(87, 7),
(88, 7),
(89, 2),
(90, 7),
(92, 7),
(94, 7),
(96, 7),
(98, 7),
(99, 7),
(101, 7),
(102, 7),
(103, 2),
(104, 7),
(106, 7),
(107, 2),
(109, 7),
(111, 2),
(114, 7),
(117, 7),
(119, 2),
(121, 7),
(122, 7),
(125, 2),
(126, 7),
(127, 7),
(128, 7),
(129, 7),
(130, 2),
(132, 7),
(20, 2),
(133, 2),
(12, 6),
(12, 9),
(127, 11),
(10, 9),
(10, 6),
(9, 9),
(9, 6),
(13, 6),
(13, 9),
(11, 6),
(11, 9),
(106, 10),
(81, 10),
(88, 10),
(102, 10),
(104, 10),
(122, 10),
(98, 10),
(109, 10),
(87, 11),
(99, 11),
(96, 11),
(80, 11),
(100, 11),
(77, 11),
(101, 11),
(121, 11),
(114, 11),
(94, 11),
(128, 11),
(78, 10),
(83, 10),
(89, 10),
(103, 10),
(107, 10),
(111, 10),
(119, 10),
(125, 10),
(130, 10),
(115, 7),
(90, 10),
(115, 10),
(117, 10),
(126, 10),
(129, 10),
(131, 10),
(132, 10),
(1, 12),
(134, 3),
(134, 6),
(134, 9),
(135, 2),
(135, 10),
(136, 2),
(136, 10),
(137, 6),
(138, 2),
(138, 11),
(159, 2),
(131, 7),
(131, 5),
(78, 5),
(106, 5),
(115, 5),
(127, 5),
(92, 5),
(104, 5),
(107, 5),
(159, 5),
(96, 5),
(157, 5),
(20, 5),
(111, 5),
(122, 5),
(121, 5),
(133, 5),
(144, 5),
(138, 5),
(160, 5),
(90, 5),
(119, 5),
(88, 5),
(89, 5),
(99, 5),
(94, 5),
(98, 5),
(114, 5),
(117, 5),
(125, 5),
(120, 5),
(81, 5),
(83, 5),
(87, 5),
(132, 5),
(77, 5),
(101, 5),
(103, 5),
(135, 5),
(136, 5),
(80, 5),
(100, 5),
(102, 5),
(128, 5),
(129, 5),
(109, 5),
(126, 5),
(130, 5),
(157, 7),
(159, 10),
(157, 10),
(160, 10),
(144, 2),
(133, 10),
(144, 10),
(162, 2),
(162, 5),
(162, 10),
(163, 6),
(163, 9),
(12, 14),
(100, 2),
(80, 13),
(164, 2),
(164, 5),
(164, 10),
(92, 13),
(107, 13),
(103, 13),
(165, 2),
(165, 5),
(165, 11),
(138, 13),
(167, 2),
(167, 5),
(167, 11),
(120, 2),
(120, 11),
(168, 2),
(168, 5),
(168, 11),
(169, 2),
(169, 5),
(169, 10),
(170, 2),
(170, 5),
(170, 10),
(171, 7),
(171, 5),
(171, 10),
(172, 2),
(172, 5),
(172, 10),
(173, 3),
(174, 2),
(92, 10),
(160, 13),
(160, 2),
(175, 2),
(176, 2),
(176, 5),
(176, 11),
(176, 13),
(9, 3);

-- --------------------------------------------------------
COMMIT;
