--
-- Host: 127.0.0.1    Database: itsrest_api_db
-- ------------------------------------------------------


--
-- Table structure for table `access_token`
--

CREATE TABLE `access_token` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expires_at` int(11) DEFAULT NULL,
  `scope` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_B6A2DD685F37A13B` (`token`),
  KEY `IDX_B6A2DD6819EB6921` (`client_id`),
  KEY `IDX_B6A2DD68A76ED395` (`user_id`),
  CONSTRAINT `FK_B6A2DD6819EB6921` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`),
  CONSTRAINT `FK_B6A2DD68A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `access_token`
--

INSERT INTO `access_token` VALUES (1,12,2,'MGExNGNjNWU1ZDA0NGE2Nzk3ODhjNzRmYjJlNjRmNzBjZDc3ZjBiMzFhMDJmZjlkOGEwN2FiNGQ3OWZjZjY3OA',1593695326,NULL),(2,19,2,'OGJiYzZkZjJjNzlmNjUzNmFiZWZlNGQ3Yjc0YTYzYTYyNDNmZWQxYWFhMzZlOWRmNmRjNWRiYzkyZGUyMzE5YQ',1593695391,NULL),(3,21,2,'M2Q1OGE0YzMwYTc3ZWIxYjgxYmYxODJhZmQxNDA1NzczYzI1Y2ZiNzE4NzEzNTA2MDc4NjEwYzMwYjU4YTgxNQ',1593709032,NULL);

--
-- Table structure for table `auth_code`
--

CREATE TABLE `auth_code` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `redirect_uri` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expires_at` int(11) DEFAULT NULL,
  `scope` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_5933D02C5F37A13B` (`token`),
  KEY `IDX_5933D02C19EB6921` (`client_id`),
  KEY `IDX_5933D02CA76ED395` (`user_id`),
  CONSTRAINT `FK_5933D02C19EB6921` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`),
  CONSTRAINT `FK_5933D02CA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `auth_code`
--


--
-- Table structure for table `client`
--

CREATE TABLE `client` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `random_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `redirect_uris` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `secret` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `allowed_grant_types` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `client`
--

INSERT INTO `client` VALUES (11,'2uale94ivhc0880swwkkkoww40skwswgsck40ow0w8k0wsc84k','a:1:{i:0;s:3:\"api\";}','4pum8rge7nac8o04s0o4c08oo84ww08sg08socs8gcc4ws004k','a:1:{i:0;s:8:\"password\";}'),(12,'466cj46x1b408wkskw8oss0s48gc804s884sskgo0wwg8owwc4','a:1:{i:0;s:3:\"api\";}','3v0wxjtcpbi8sooo0c0g4cc0o4cwg88skoo8wwo84css8w4ows','a:1:{i:0;s:8:\"password\";}'),(13,'1n7esr31rbusoswgcowk488gg84o0sc04cgsgow0g40ws4o0cw','a:1:{i:0;s:3:\"api\";}','6d1zdgpyem0wkcgo8ks40s4o8osgkgwg84swc84kkc8k0w0skw','a:1:{i:0;s:8:\"password\";}'),(14,'580dai9we0cokw84k44wggcs4gg8wg4ww4sw8ocksw0gg0wkso','a:1:{i:0;s:3:\"api\";}','10motqtc3sz4s8ogosk8wkwwgg8c0swwks44kwogow40kkssgc','a:1:{i:0;s:8:\"password\";}'),(15,'5d748lzbzx4wcwg8044w0osg04g0w0ck8o48o88oo0ssgkooog','a:1:{i:0;s:3:\"api\";}','3c87h9vucb40css0ggsk8owsg40scgcow880soo4cckc844s00','a:1:{i:0;s:8:\"password\";}'),(16,'4ugwx5m2px4w4oo4w84sww0ckogcsokocwgw44wwk88kk0sg4c','a:1:{i:0;s:3:\"api\";}','24ryvh4psnwkks4k8wo4kw00wogwo8wgkkwgo4gckc4804w80w','a:1:{i:0;s:8:\"password\";}'),(17,'d327b81w6qokkckk0woswkgcswk8owwk0wkwowowg4k4ggw00','a:1:{i:0;s:3:\"api\";}','567tv3cwqkg0w4koss8ko0w0c00w44cw04cc8c8wwsww0go0sk','a:1:{i:0;s:5:\"token\";}'),(18,'1019r1l0nxmskco8o88ocgo4ccoc4w0c48ogk0okko80c40go4','a:1:{i:0;s:3:\"api\";}','4uaf0ypmji80kwkssgg4gwswo48scggws8og4gwcgo4oocc8so','a:1:{i:0;s:18:\"authorization_code\";}'),(19,'3usypljuu8ao840csogsww04w40ggsgccg0wcwgwoc88ggw0w0','a:1:{i:0;s:3:\"api\";}','msfaq1bm6msscck8gggg0cksk880cck4c8wo8oc08kgcwgc4w','a:1:{i:0;s:8:\"password\";}'),(20,'5e9ieszydt0kwcoc4ckgkss04oc0o0gwsc0c0wgswow044o0co','a:1:{i:0;s:3:\"api\";}','4iasjtt7zh4wsg4scco44so00k84g4gkgcswwkoggc4sggg800','a:1:{i:0;s:18:\"authorization_code\";}'),(21,'466nt1rdymm80kckk848s0s880cw0ggs8cgswkkwog8g0c04s8','a:1:{i:0;s:3:\"api\";}','3ql8fcdkncu8ok4ok4kkkkwwkscc4kcwkskg8s00c0ocscccok','a:1:{i:0;s:8:\"password\";}');

--
-- Table structure for table `its_application`
--

CREATE TABLE `its_application` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_picture_id` int(11) DEFAULT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `app_description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `web_site` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_9651D42F5E237E06` (`name`),
  KEY `IDX_9651D42FB85E16C3` (`app_picture_id`),
  KEY `IDX_9651D42FB03A8386` (`created_by_id`),
  CONSTRAINT `FK_9651D42FB03A8386` FOREIGN KEY (`created_by_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_9651D42FB85E16C3` FOREIGN KEY (`app_picture_id`) REFERENCES `media_object` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `its_application`
--

INSERT INTO `its_application` VALUES (1,1,1,'Test Application','App for test','http://www.its.cm','2020-07-02 10:34:01'),(2,2,2,'EpassOffices','Manage access to your companies & workshops efficiently','https://www.epassoffices.cm','2020-07-04 12:47:11'),(3,4,2,'EpassEvents','Site achat ticket pour evenements','https://www.epassevents.cm','2020-07-04 13:03:23');

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `activity` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_F08FC65CA76ED395` (`user_id`),
  CONSTRAINT `FK_F08FC65CA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` VALUES (1,2,'login','192.168.1.119','2020-07-01 14:37:43'),(2,2,'loging','192.168.1.1','2020-07-01 13:34:12');

--
-- Table structure for table `media_object`
--

CREATE TABLE `media_object` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_object`
--

INSERT INTO `media_object` VALUES (1,'5efdb8fa8f47f_download.png'),(2,'5f007a980bd6a_epassoffices.png'),(3,'5f007de508f52_logo (1).png'),(4,'5f007e0bcef9b_epassevents.png'),(5,'5f00814b36d47_monetbil.png'),(6,'5f00825630d58_orange_money.png'),(7,'5f0082dbf1516_mobile_money.png'),(8,'5f0083277108f_visa_master.png'),(9,'5f00848d686c3_dohone-logo.png'),(10,'5f00a3e26264c_WhatsApp Image 2020-05-08 at 14.02.09.jpeg');

--
-- Table structure for table `patner_payment`
--

CREATE TABLE `patner_payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `partner_picture_id` int(11) DEFAULT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone1` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone2` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `web_site` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_588650927BFA0E49` (`phone1`),
  KEY `IDX_58865092F4B4BE59` (`partner_picture_id`),
  KEY `IDX_58865092B03A8386` (`created_by_id`),
  CONSTRAINT `FK_58865092B03A8386` FOREIGN KEY (`created_by_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_58865092F4B4BE59` FOREIGN KEY (`partner_picture_id`) REFERENCES `media_object` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `patner_payment`
--

INSERT INTO partner_payment VALUES (1,1,2,'Yaoundé','698707070','672877278','support@monetbil.com','https://www.monetbil.com','2020-07-02 16:11:14',0),(2,5,2,'Yaoundé, Biyémassi','23702224877','23780778788','support@monetbil.com','https://fr.monetbil.com','2020-07-04 13:14:20',1),(3,9,2,'Yaounde, Cameroun - BP 5033 Yaounde',' (+237) 243265918','23780778788','infos@my-dohone.com','https://my-dohone.com/dohone/','2020-07-04 13:14:20',1);

--
-- Table structure for table `payment_service`
--

CREATE TABLE `payment_service` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_picture_id` int(11) DEFAULT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `payment_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_desc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `partner_service_id` int(11) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_F8D49438DBB33C6A` (`payment_picture_id`),
  KEY `IDX_F8D49438B03A8386` (`created_by_id`),
  KEY `IDX_F8D49438F7ADAA00` (`partner_service_id`),
  CONSTRAINT `FK_F8D49438B03A8386` FOREIGN KEY (`created_by_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_F8D49438DBB33C6A` FOREIGN KEY (`payment_picture_id`) REFERENCES `media_object` (`id`),
  CONSTRAINT `FK_F8D49438F7ADAA00` FOREIGN KEY (`partner_service_id`) REFERENCES partner_payment (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_service`
--

INSERT INTO `payment_service` VALUES (1,1,1,'Orange Money','Payement Orange Money Via Monet Bil','2020-07-02 16:30:23',1,0),(2,6,2,'Orange Money','Payement Via Orange Money via MonetBil','2020-07-04 13:21:50',2,1),(3,7,2,'MTN Mobile Money','Payement Via Mtn Mobile Money via MonetBil','2020-07-04 13:21:50',2,1),(4,8,2,'Visa & Master Card Pay','Payement par Visa & Master via MonetBil','2020-07-04 13:21:50',2,1),(5,8,2,'Visa & Master Card Pay','Payement par Visa & Master via Dohone','2020-07-04 13:21:50',3,1),(6,7,2,'Mobile Money Pay','Payement par Mobile Money via Dohone','2020-07-04 13:21:50',3,1),(7,6,2,'Orange Money Pay','Payement par Orange Money via Dohone','2020-07-04 13:21:50',3,1);

--
-- Table structure for table `refresh_token`
--

CREATE TABLE `refresh_token` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expires_at` int(11) DEFAULT NULL,
  `scope` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_C74F21955F37A13B` (`token`),
  KEY `IDX_C74F219519EB6921` (`client_id`),
  KEY `IDX_C74F2195A76ED395` (`user_id`),
  CONSTRAINT `FK_C74F219519EB6921` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`),
  CONSTRAINT `FK_C74F2195A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `refresh_token`
--

INSERT INTO `refresh_token` VALUES (1,12,2,'NDBkZDQ0NDc1NWRlZWMzNzA1ZmE5NzE2ZGZmZmFjMGJjMzM1MGEzZmQ5ZWMyOTQ0MDU3MTAyYjQxZmM2NTY1MA',1594818526,NULL),(2,19,2,'MTUwNjczNWJkNGVmMjAzOGY2Y2Q3NWNmNjc1MzBhYTVkOWM4ODM3MTU0ODdlNTAwNGIxNjg0NzcxZTlhNWViYQ',1594818591,NULL),(3,21,2,'NzE0MGU2YmRkODlmMDM5YjY2MWQ3YTNlM2FiNWNhNGM5MTc3YzJkMjA3OTE5NTYwZjE4ZTUzNDk2MzE4OWE2Mw',1594832232,NULL);

--
-- Table structure for table `service`
--

CREATE TABLE `service` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by_id` int(11) DEFAULT NULL,
  `app_link_id` int(11) NOT NULL,
  `service_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `service_desc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_E19D9AD29060CAEA` (`service_name`),
  KEY `IDX_E19D9AD2B03A8386` (`created_by_id`),
  KEY `IDX_E19D9AD240F9823C` (`app_link_id`),
  CONSTRAINT `FK_E19D9AD240F9823C` FOREIGN KEY (`app_link_id`) REFERENCES `its_application` (`id`),
  CONSTRAINT `FK_E19D9AD2B03A8386` FOREIGN KEY (`created_by_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `service`
--

INSERT INTO `service` VALUES (1,1,1,'Achat Ticket','Serive pour le payement des ticket dans l\'application test','2020-07-02 10:35:20',0),(2,2,2,'Package Payment','Package pay for enterpise','2020-07-04 12:52:58',0),(3,2,2,'Ticket Pass Payment ','Pay ticket to have access in the enterprice','2020-07-04 12:52:58',0),(4,2,3,'Pay Ticket For Events','Pay ticket service on epassevent','2020-07-04 13:12:02',1);

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `service_id` int(11) NOT NULL,
  `payment_service_id` int(11) NOT NULL,
  `reference` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int(11) NOT NULL,
  `cost_per_unit` int(11) DEFAULT NULL,
  `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_amount` int(11) NOT NULL,
  `transaction_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_body_request` varchar(10000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_723705D12FC0CB0F` (`transaction_id`),
  KEY `IDX_723705D1ED5CA9E6` (`service_id`),
  KEY `IDX_723705D1D8AA2833` (`payment_service_id`),
  CONSTRAINT `FK_723705D1D8AA2833` FOREIGN KEY (`payment_service_id`) REFERENCES `payment_service` (`id`),
  CONSTRAINT `FK_723705D1ED5CA9E6` FOREIGN KEY (`service_id`) REFERENCES `service` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` VALUES (1,1,1,'0404a04a0abbbbee','a07070070bd07d',3,1000,'Jean Patrick','68087080','jean@gmail.com',3000,'SUCCEED','RAS','2020-07-02 16:38:48','192.168.14.1');

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `roles` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username_canonical` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_canonical` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `salt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `confirmation_token` varchar(180) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password_requested_at` datetime DEFAULT NULL,
  `user_picture_id` int(11) DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8D93D64992FC23A8` (`username_canonical`),
  UNIQUE KEY `UNIQ_8D93D649A0D96FBF` (`email_canonical`),
  UNIQUE KEY `UNIQ_8D93D649C05FB297` (`confirmation_token`),
  KEY `IDX_8D93D64949227B53` (`user_picture_id`),
  CONSTRAINT `FK_8D93D64949227B53` FOREIGN KEY (`user_picture_id`) REFERENCES `media_object` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `user` VALUES (1,'ronald.ngouaha@gajo-trading.com','a:0:{}','$2y$13$p.eQlKxpFLmYHUTLt2Njh.rBbOB4qU70D3ryvmcLZLOIbfoLGhG9i','ronaldnmr','ronaldnmr','ronald.ngouaha@gajo-trading.com',1,'GIIzw6xo54gMip84gMVPQbfhCbbCdfjcJmwZIfI41XE',NULL,NULL,NULL,NULL,NULL,NULL),(2,'test@gmail.com','a:0:{}','$2y$13$3OgL4ZFHcTEa0Mvwne5gd.xIWIboeaX5ElMa/dCGowOnpuH61XQ7u','test_user','test_user','test@gmail.com',1,'BUgkCFWGZf8sLgMJL2Qxcz6y9cZFrvDg8AsFboZ.7oY','2020-07-04 17:23:34',NULL,NULL,NULL,NULL,NULL),(3,'ronaldnmr@cfits.cm','a:1:{i:0;s:16:\"ROLE_SUPER_ADMIN\";}','$2y$13$7PXV6a3lGAXDu76GmtsKO.4xh8j.zJekXbqC8QTdxj6KwUwAuey.W','itsadmin','itsadmin','ronaldnmr@cfits.cm',1,'jnioT.YmsqGKGYJGFs6e/QzRZR0.K16i6MFv5sbMd10',NULL,NULL,NULL,NULL,NULL,NULL);


