-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `cloud_gateway`
--

-- --------------------------------------------------------

--
-- Table structure for table `core_store`
--

CREATE TABLE `core_store` (
  `id` int(10) UNSIGNED NOT NULL,
  `key` varchar(255) DEFAULT NULL,
  `value` longtext DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `environment` varchar(255) DEFAULT NULL,
  `tag` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `core_store`
--

INSERT INTO `core_store` (`id`, `key`, `value`, `type`, `environment`, `tag`) VALUES
(1, 'model_def_strapi::core-store', '{\"uid\":\"strapi::core-store\",\"collectionName\":\"core_store\",\"info\":{\"name\":\"core_store\",\"description\":\"\"},\"options\":{\"timestamps\":false},\"pluginOptions\":{\"content-manager\":{\"visible\":false},\"content-type-builder\":{\"visible\":false}},\"attributes\":{\"key\":{\"type\":\"string\"},\"value\":{\"type\":\"text\"},\"type\":{\"type\":\"string\"},\"environment\":{\"type\":\"string\"},\"tag\":{\"type\":\"string\"}}}', 'object', NULL, NULL),
(2, 'model_def_application::demo.demo', '{\"uid\":\"application::demo.demo\",\"collectionName\":\"demos\",\"kind\":\"collectionType\",\"info\":{\"name\":\"demo\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"draftAndPublish\":false},\"attributes\":{\"client_id\":{\"type\":\"string\"},\"shortcode\":{\"type\":\"string\"},\"msisdn\":{\"type\":\"string\"},\"key_word\":{\"type\":\"string\"},\"transid\":{\"type\":\"string\"},\"operator\":{\"type\":\"string\"},\"serviceid\":{\"type\":\"string\"},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true}}}', 'object', NULL, NULL),
(3, 'model_def_application::limit.limit', '{\"uid\":\"application::limit.limit\",\"collectionName\":\"limits\",\"kind\":\"collectionType\",\"info\":{\"name\":\"limit\",\"description\":\"\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"draftAndPublish\":true},\"attributes\":{\"user_id\":{\"type\":\"string\"},\"start_time\":{\"type\":\"datetime\"},\"end_time\":{\"type\":\"datetime\"},\"hits\":{\"type\":\"integer\"},\"published_at\":{\"type\":\"datetime\",\"configurable\":false},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"private\":true}}}', 'object', NULL, NULL),
(4, 'model_def_application::test.test', '{\"uid\":\"application::test.test\",\"collectionName\":\"test\",\"kind\":\"collectionType\",\"info\":{\"name\":\"test\",\"description\":\"\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"Publish\":true,\"draftAndPublish\":false},\"attributes\":{\"name\":{\"type\":\"string\",\"unique\":false},\"uname\":{\"type\":\"string\"},\"pc\":{\"type\":\"string\",\"private\":true},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"private\":true}}}', 'object', NULL, NULL),
(5, 'model_def_strapi::webhooks', '{\"uid\":\"strapi::webhooks\",\"collectionName\":\"strapi_webhooks\",\"info\":{\"name\":\"Strapi webhooks\",\"description\":\"\"},\"options\":{\"timestamps\":false},\"pluginOptions\":{\"content-manager\":{\"visible\":false},\"content-type-builder\":{\"visible\":false}},\"attributes\":{\"name\":{\"type\":\"string\"},\"url\":{\"type\":\"text\"},\"headers\":{\"type\":\"json\"},\"events\":{\"type\":\"json\"},\"enabled\":{\"type\":\"boolean\"}}}', 'object', NULL, NULL),
(6, 'model_def_strapi::permission', '{\"uid\":\"strapi::permission\",\"collectionName\":\"strapi_permission\",\"kind\":\"collectionType\",\"info\":{\"name\":\"Permission\",\"description\":\"\"},\"options\":{\"timestamps\":[\"created_at\",\"updated_at\"]},\"pluginOptions\":{\"content-manager\":{\"visible\":false},\"content-type-builder\":{\"visible\":false}},\"attributes\":{\"action\":{\"type\":\"string\",\"minLength\":1,\"configurable\":false,\"required\":true},\"subject\":{\"type\":\"string\",\"minLength\":1,\"configurable\":false,\"required\":false},\"properties\":{\"type\":\"json\",\"configurable\":false,\"required\":false,\"default\":{}},\"conditions\":{\"type\":\"json\",\"configurable\":false,\"required\":false,\"default\":[]},\"role\":{\"configurable\":false,\"model\":\"role\",\"plugin\":\"admin\"}}}', 'object', NULL, NULL),
(7, 'model_def_strapi::role', '{\"uid\":\"strapi::role\",\"collectionName\":\"strapi_role\",\"kind\":\"collectionType\",\"info\":{\"name\":\"Role\",\"description\":\"\"},\"options\":{\"timestamps\":[\"created_at\",\"updated_at\"]},\"pluginOptions\":{\"content-manager\":{\"visible\":false},\"content-type-builder\":{\"visible\":false}},\"attributes\":{\"name\":{\"type\":\"string\",\"minLength\":1,\"unique\":true,\"configurable\":false,\"required\":true},\"code\":{\"type\":\"string\",\"minLength\":1,\"unique\":true,\"configurable\":false,\"required\":true},\"description\":{\"type\":\"string\",\"configurable\":false},\"users\":{\"configurable\":false,\"collection\":\"user\",\"via\":\"roles\",\"plugin\":\"admin\",\"attribute\":\"user\",\"column\":\"id\",\"isVirtual\":true},\"permissions\":{\"configurable\":false,\"plugin\":\"admin\",\"collection\":\"permission\",\"via\":\"role\",\"isVirtual\":true}}}', 'object', NULL, NULL),
(8, 'model_def_strapi::user', '{\"uid\":\"strapi::user\",\"collectionName\":\"strapi_administrator\",\"kind\":\"collectionType\",\"info\":{\"name\":\"User\",\"description\":\"\"},\"options\":{\"timestamps\":false},\"pluginOptions\":{\"content-manager\":{\"visible\":false},\"content-type-builder\":{\"visible\":false}},\"attributes\":{\"firstname\":{\"type\":\"string\",\"unique\":false,\"minLength\":1,\"configurable\":false,\"required\":false},\"lastname\":{\"type\":\"string\",\"unique\":false,\"minLength\":1,\"configurable\":false,\"required\":false},\"username\":{\"type\":\"string\",\"unique\":false,\"configurable\":false,\"required\":false},\"email\":{\"type\":\"email\",\"minLength\":6,\"configurable\":false,\"required\":true,\"unique\":true,\"private\":true},\"password\":{\"type\":\"password\",\"minLength\":6,\"configurable\":false,\"required\":false,\"private\":true},\"resetPasswordToken\":{\"type\":\"string\",\"configurable\":false,\"private\":true},\"registrationToken\":{\"type\":\"string\",\"configurable\":false,\"private\":true},\"isActive\":{\"type\":\"boolean\",\"default\":false,\"configurable\":false,\"private\":true},\"roles\":{\"collection\":\"role\",\"collectionName\":\"strapi_users_roles\",\"via\":\"users\",\"dominant\":true,\"plugin\":\"admin\",\"configurable\":false,\"private\":true,\"attribute\":\"role\",\"column\":\"id\",\"isVirtual\":true},\"blocked\":{\"type\":\"boolean\",\"default\":false,\"configurable\":false,\"private\":true},\"preferedLanguage\":{\"type\":\"string\",\"configurable\":false,\"required\":false}}}', 'object', NULL, NULL),
(9, 'model_def_plugins::upload.file', '{\"uid\":\"plugins::upload.file\",\"collectionName\":\"upload_file\",\"kind\":\"collectionType\",\"info\":{\"name\":\"file\",\"description\":\"\"},\"options\":{\"timestamps\":[\"created_at\",\"updated_at\"]},\"pluginOptions\":{\"content-manager\":{\"visible\":false},\"content-type-builder\":{\"visible\":false}},\"attributes\":{\"name\":{\"type\":\"string\",\"configurable\":false,\"required\":true},\"alternativeText\":{\"type\":\"string\",\"configurable\":false},\"caption\":{\"type\":\"string\",\"configurable\":false},\"width\":{\"type\":\"integer\",\"configurable\":false},\"height\":{\"type\":\"integer\",\"configurable\":false},\"formats\":{\"type\":\"json\",\"configurable\":false},\"hash\":{\"type\":\"string\",\"configurable\":false,\"required\":true},\"ext\":{\"type\":\"string\",\"configurable\":false},\"mime\":{\"type\":\"string\",\"configurable\":false,\"required\":true},\"size\":{\"type\":\"decimal\",\"configurable\":false,\"required\":true},\"url\":{\"type\":\"string\",\"configurable\":false,\"required\":true},\"previewUrl\":{\"type\":\"string\",\"configurable\":false},\"provider\":{\"type\":\"string\",\"configurable\":false,\"required\":true},\"provider_metadata\":{\"type\":\"json\",\"configurable\":false},\"related\":{\"collection\":\"*\",\"filter\":\"field\",\"configurable\":false},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true}}}', 'object', NULL, NULL),
(10, 'model_def_plugins::users-permissions.permission', '{\"uid\":\"plugins::users-permissions.permission\",\"collectionName\":\"users-permissions_permission\",\"kind\":\"collectionType\",\"info\":{\"name\":\"permission\",\"description\":\"\"},\"options\":{\"timestamps\":false},\"pluginOptions\":{\"content-manager\":{\"visible\":false}},\"attributes\":{\"type\":{\"type\":\"string\",\"required\":true,\"configurable\":false},\"controller\":{\"type\":\"string\",\"required\":true,\"configurable\":false},\"action\":{\"type\":\"string\",\"required\":true,\"configurable\":false},\"enabled\":{\"type\":\"boolean\",\"required\":true,\"configurable\":false},\"policy\":{\"type\":\"string\",\"configurable\":false},\"role\":{\"model\":\"role\",\"via\":\"permissions\",\"plugin\":\"users-permissions\",\"configurable\":false},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true}}}', 'object', NULL, NULL),
(11, 'model_def_plugins::users-permissions.role', '{\"uid\":\"plugins::users-permissions.role\",\"collectionName\":\"users-permissions_role\",\"kind\":\"collectionType\",\"info\":{\"name\":\"role\",\"description\":\"\"},\"options\":{\"timestamps\":false},\"pluginOptions\":{\"content-manager\":{\"visible\":false}},\"attributes\":{\"name\":{\"type\":\"string\",\"minLength\":3,\"required\":true,\"configurable\":false},\"description\":{\"type\":\"string\",\"configurable\":false},\"type\":{\"type\":\"string\",\"unique\":true,\"configurable\":false},\"permissions\":{\"collection\":\"permission\",\"via\":\"role\",\"plugin\":\"users-permissions\",\"configurable\":false,\"isVirtual\":true},\"users\":{\"collection\":\"user\",\"via\":\"role\",\"configurable\":false,\"plugin\":\"users-permissions\",\"isVirtual\":true},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true}}}', 'object', NULL, NULL),
(12, 'model_def_plugins::users-permissions.user', '{\"uid\":\"plugins::users-permissions.user\",\"collectionName\":\"users-permissions_user\",\"kind\":\"collectionType\",\"info\":{\"name\":\"user\",\"description\":\"\"},\"options\":{\"draftAndPublish\":false,\"timestamps\":[\"created_at\",\"updated_at\"]},\"attributes\":{\"username\":{\"type\":\"string\",\"minLength\":3,\"unique\":true,\"configurable\":false,\"required\":true},\"email\":{\"type\":\"email\",\"minLength\":6,\"configurable\":false,\"required\":true},\"provider\":{\"type\":\"string\",\"configurable\":false},\"resetPasswordToken\":{\"type\":\"string\",\"configurable\":false,\"private\":true},\"confirmationToken\":{\"type\":\"string\",\"configurable\":false,\"private\":true},\"confirmed\":{\"type\":\"boolean\",\"default\":false,\"configurable\":false},\"blocked\":{\"type\":\"boolean\",\"default\":false,\"configurable\":false},\"role\":{\"model\":\"role\",\"via\":\"users\",\"plugin\":\"users-permissions\",\"configurable\":false},\"password\":{\"type\":\"password\",\"private\":false,\"required\":false,\"default\":\"12345678\"},\"token\":{\"type\":\"string\"},\"uid\":{\"type\":\"string\"},\"amount\":{\"type\":\"float\",\"default\":0},\"paid\":{\"type\":\"float\",\"default\":0},\"due\":{\"type\":\"float\",\"default\":0},\"balance\":{\"type\":\"decimal\",\"default\":0,\"required\":true},\"rate_limit\":{\"type\":\"integer\",\"default\":0,\"required\":true},\"ip_whiteList\":{\"type\":\"boolean\",\"default\":false,\"private\":false},\"services\":{\"via\":\"vendor\",\"collection\":\"service\",\"isVirtual\":true},\"requestMethod\":{\"type\":\"enumeration\",\"enum\":[\"GET\",\"POST\"],\"required\":true},\"apiUrl\":{\"type\":\"string\",\"required\":true},\"authentication\":{\"type\":\"enumeration\",\"enum\":[\"NoAuth\",\"BasicAuth\",\"JwtToken\"],\"required\":true},\"credentials\":{\"type\":\"string\"},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true}}}', 'object', NULL, NULL),
(13, 'model_def_plugins::billing.payment', '{\"uid\":\"plugins::billing.payment\",\"collectionName\":\"payment\",\"kind\":\"collectionType\",\"info\":{\"name\":\"payment\",\"description\":\"\"},\"options\":{\"increments\":false,\"timestamps\":[\"created_at\",\"updated_at\"],\"Publish\":false,\"draftAndPublish\":false},\"attributes\":{\"user\":{\"model\":\"user\",\"plugin\":\"users-permissions\",\"configurable\":false,\"required\":true},\"balance\":{\"type\":\"float\",\"required\":false,\"default\":0},\"total_amount\":{\"type\":\"float\",\"required\":false,\"default\":0},\"paid\":{\"type\":\"float\",\"required\":false,\"default\":0},\"type\":{\"type\":\"enumeration\",\"enum\":[\"Add\",\"Return\"],\"required\":true,\"default\":\"Add\"},\"details\":{\"type\":\"text\"},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true}}}', 'object', NULL, NULL),
(14, 'model_def_plugins::billing.rate_api', '{\"uid\":\"plugins::billing.rate_api\",\"collectionName\":\"rate_api\",\"kind\":\"collectionType\",\"info\":{\"name\":\"rate_api\",\"description\":\"\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"Publish\":true,\"draftAndPublish\":false},\"attributes\":{\"api_name\":{\"type\":\"string\"},\"method\":{\"type\":\"string\"},\"rate\":{\"type\":\"integer\"},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"private\":true}}}', 'object', NULL, NULL),
(15, 'model_def_plugins::billing.records', '{\"uid\":\"plugins::billing.records\",\"collectionName\":\"records\",\"kind\":\"collectionType\",\"info\":{\"name\":\"records\",\"description\":\"\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"Publish\":true,\"draftAndPublish\":false},\"attributes\":{\"partner_name\":{\"type\":\"string\"},\"vendor\":{\"type\":\"string\"},\"rate\":{\"type\":\"decimal\"},\"operator\":{\"type\":\"string\"},\"keyWord\":{\"type\":\"string\"},\"serviceId\":{\"type\":\"string\"},\"tx_id\":{\"type\":\"string\"},\"msisdn\":{\"type\":\"string\",\"required\":false},\"serviceTier\":{\"type\":\"string\"},\"billerType\":{\"type\":\"string\",\"required\":true},\"created_at_gmt\":{\"type\":\"datetime\"},\"cronDate\":{\"type\":\"datetime\"},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true}}}', 'object', NULL, NULL),
(16, 'model_def_plugins::ip-whitelist.ip-whitelist', '{\"uid\":\"plugins::ip-whitelist.ip-whitelist\",\"collectionName\":\"ip-whitelist\",\"kind\":\"collectionType\",\"info\":{\"name\":\"ip-whitelist\"},\"options\":{\"timestamps\":[\"created_at\",\"updated_at\"],\"draftAndPublish\":false},\"attributes\":{\"user\":{\"model\":\"user\",\"plugin\":\"users-permissions\",\"configurable\":true,\"required\":true},\"ip\":{\"type\":\"string\",\"required\":true},\"rate_limit\":{\"type\":\"integer\",\"required\":true},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true}}}', 'object', NULL, NULL),
(17, 'plugin_upload_settings', '{\"sizeOptimization\":true,\"responsiveDimensions\":true}', 'object', 'development', ''),
(18, 'plugin_users-permissions_grant', '{\"email\":{\"enabled\":true,\"icon\":\"envelope\"},\"discord\":{\"enabled\":false,\"icon\":\"discord\",\"key\":\"\",\"secret\":\"\",\"callback\":\"/auth/discord/callback\",\"scope\":[\"identify\",\"email\"]},\"facebook\":{\"enabled\":false,\"icon\":\"facebook-square\",\"key\":\"\",\"secret\":\"\",\"callback\":\"/auth/facebook/callback\",\"scope\":[\"email\"]},\"google\":{\"enabled\":false,\"icon\":\"google\",\"key\":\"\",\"secret\":\"\",\"callback\":\"/auth/google/callback\",\"scope\":[\"email\"]},\"github\":{\"enabled\":false,\"icon\":\"github\",\"key\":\"\",\"secret\":\"\",\"callback\":\"/auth/github/callback\",\"scope\":[\"user\",\"user:email\"]},\"microsoft\":{\"enabled\":false,\"icon\":\"windows\",\"key\":\"\",\"secret\":\"\",\"callback\":\"/auth/microsoft/callback\",\"scope\":[\"user.read\"]},\"twitter\":{\"enabled\":false,\"icon\":\"twitter\",\"key\":\"\",\"secret\":\"\",\"callback\":\"/auth/twitter/callback\"},\"instagram\":{\"enabled\":false,\"icon\":\"instagram\",\"key\":\"\",\"secret\":\"\",\"callback\":\"/auth/instagram/callback\",\"scope\":[\"user_profile\"]},\"vk\":{\"enabled\":false,\"icon\":\"vk\",\"key\":\"\",\"secret\":\"\",\"callback\":\"/auth/vk/callback\",\"scope\":[\"email\"]},\"twitch\":{\"enabled\":false,\"icon\":\"twitch\",\"key\":\"\",\"secret\":\"\",\"callback\":\"/auth/twitch/callback\",\"scope\":[\"user:read:email\"]},\"linkedin\":{\"enabled\":false,\"icon\":\"linkedin\",\"key\":\"\",\"secret\":\"\",\"callback\":\"/auth/linkedin/callback\",\"scope\":[\"r_liteprofile\",\"r_emailaddress\"]},\"cognito\":{\"enabled\":false,\"icon\":\"aws\",\"key\":\"\",\"secret\":\"\",\"subdomain\":\"my.subdomain.com\",\"callback\":\"/auth/cognito/callback\",\"scope\":[\"email\",\"openid\",\"profile\"]},\"reddit\":{\"enabled\":false,\"icon\":\"reddit\",\"key\":\"\",\"secret\":\"\",\"state\":true,\"callback\":\"/auth/reddit/callback\",\"scope\":[\"identity\"]},\"auth0\":{\"enabled\":false,\"icon\":\"\",\"key\":\"\",\"secret\":\"\",\"subdomain\":\"my-tenant.eu\",\"callback\":\"/auth/auth0/callback\",\"scope\":[\"openid\",\"email\",\"profile\"]},\"cas\":{\"enabled\":false,\"icon\":\"book\",\"key\":\"\",\"secret\":\"\",\"callback\":\"/auth/cas/callback\",\"scope\":[\"openid email\"],\"subdomain\":\"my.subdomain.com/cas\"}}', 'object', '', ''),
(22, 'plugin_content_manager_configuration_content_types::strapi::permission', '{\"uid\":\"strapi::permission\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"action\",\"defaultSortBy\":\"action\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}},\"action\":{\"edit\":{\"label\":\"Action\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Action\",\"searchable\":true,\"sortable\":true}},\"subject\":{\"edit\":{\"label\":\"Subject\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Subject\",\"searchable\":true,\"sortable\":true}},\"properties\":{\"edit\":{\"label\":\"Properties\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Properties\",\"searchable\":false,\"sortable\":false}},\"conditions\":{\"edit\":{\"label\":\"Conditions\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Conditions\",\"searchable\":false,\"sortable\":false}},\"role\":{\"edit\":{\"label\":\"Role\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true,\"mainField\":\"name\"},\"list\":{\"label\":\"Role\",\"searchable\":true,\"sortable\":true}},\"created_at\":{\"edit\":{\"label\":\"Created_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Created_at\",\"searchable\":true,\"sortable\":true}},\"updated_at\":{\"edit\":{\"label\":\"Updated_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Updated_at\",\"searchable\":true,\"sortable\":true}}},\"layouts\":{\"list\":[\"id\",\"action\",\"subject\",\"role\"],\"edit\":[[{\"name\":\"action\",\"size\":6},{\"name\":\"subject\",\"size\":6}],[{\"name\":\"conditions\",\"size\":12}],[{\"name\":\"properties\",\"size\":12}]],\"editRelations\":[\"role\"]}}', 'object', '', ''),
(23, 'plugin_content_manager_configuration_content_types::strapi::role', '{\"uid\":\"strapi::role\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"name\",\"defaultSortBy\":\"name\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}},\"name\":{\"edit\":{\"label\":\"Name\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Name\",\"searchable\":true,\"sortable\":true}},\"code\":{\"edit\":{\"label\":\"Code\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Code\",\"searchable\":true,\"sortable\":true}},\"description\":{\"edit\":{\"label\":\"Description\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Description\",\"searchable\":true,\"sortable\":true}},\"users\":{\"edit\":{\"label\":\"Users\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true,\"mainField\":\"firstname\"},\"list\":{\"label\":\"Users\",\"searchable\":false,\"sortable\":false}},\"permissions\":{\"edit\":{\"label\":\"Permissions\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true,\"mainField\":\"action\"},\"list\":{\"label\":\"Permissions\",\"searchable\":false,\"sortable\":false}},\"created_at\":{\"edit\":{\"label\":\"Created_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Created_at\",\"searchable\":true,\"sortable\":true}},\"updated_at\":{\"edit\":{\"label\":\"Updated_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Updated_at\",\"searchable\":true,\"sortable\":true}}},\"layouts\":{\"list\":[\"id\",\"name\",\"code\",\"description\"],\"editRelations\":[\"users\",\"permissions\"],\"edit\":[[{\"name\":\"name\",\"size\":6},{\"name\":\"code\",\"size\":6}],[{\"name\":\"description\",\"size\":6}]]}}', 'object', '', ''),
(24, 'plugin_content_manager_configuration_content_types::strapi::user', '{\"uid\":\"strapi::user\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"firstname\",\"defaultSortBy\":\"firstname\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}},\"firstname\":{\"edit\":{\"label\":\"Firstname\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Firstname\",\"searchable\":true,\"sortable\":true}},\"lastname\":{\"edit\":{\"label\":\"Lastname\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Lastname\",\"searchable\":true,\"sortable\":true}},\"username\":{\"edit\":{\"label\":\"Username\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Username\",\"searchable\":true,\"sortable\":true}},\"email\":{\"edit\":{\"label\":\"Email\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Email\",\"searchable\":true,\"sortable\":true}},\"password\":{\"edit\":{\"label\":\"Password\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Password\",\"searchable\":true,\"sortable\":true}},\"resetPasswordToken\":{\"edit\":{\"label\":\"ResetPasswordToken\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"ResetPasswordToken\",\"searchable\":true,\"sortable\":true}},\"registrationToken\":{\"edit\":{\"label\":\"RegistrationToken\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"RegistrationToken\",\"searchable\":true,\"sortable\":true}},\"isActive\":{\"edit\":{\"label\":\"IsActive\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"IsActive\",\"searchable\":true,\"sortable\":true}},\"roles\":{\"edit\":{\"label\":\"Roles\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true,\"mainField\":\"name\"},\"list\":{\"label\":\"Roles\",\"searchable\":false,\"sortable\":false}},\"blocked\":{\"edit\":{\"label\":\"Blocked\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Blocked\",\"searchable\":true,\"sortable\":true}},\"preferedLanguage\":{\"edit\":{\"label\":\"PreferedLanguage\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"PreferedLanguage\",\"searchable\":true,\"sortable\":true}}},\"layouts\":{\"list\":[\"id\",\"firstname\",\"lastname\",\"username\"],\"edit\":[[{\"name\":\"firstname\",\"size\":6},{\"name\":\"lastname\",\"size\":6}],[{\"name\":\"username\",\"size\":6},{\"name\":\"email\",\"size\":6}],[{\"name\":\"password\",\"size\":6},{\"name\":\"resetPasswordToken\",\"size\":6}],[{\"name\":\"registrationToken\",\"size\":6},{\"name\":\"isActive\",\"size\":4}],[{\"name\":\"blocked\",\"size\":4},{\"name\":\"preferedLanguage\",\"size\":6}]],\"editRelations\":[\"roles\"]}}', 'object', '', ''),
(25, 'plugin_content_manager_configuration_content_types::plugins::upload.file', '{\"uid\":\"plugins::upload.file\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"name\",\"defaultSortBy\":\"name\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}},\"name\":{\"edit\":{\"label\":\"Name\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Name\",\"searchable\":true,\"sortable\":true}},\"alternativeText\":{\"edit\":{\"label\":\"AlternativeText\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"AlternativeText\",\"searchable\":true,\"sortable\":true}},\"caption\":{\"edit\":{\"label\":\"Caption\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Caption\",\"searchable\":true,\"sortable\":true}},\"width\":{\"edit\":{\"label\":\"Width\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Width\",\"searchable\":true,\"sortable\":true}},\"height\":{\"edit\":{\"label\":\"Height\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Height\",\"searchable\":true,\"sortable\":true}},\"formats\":{\"edit\":{\"label\":\"Formats\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Formats\",\"searchable\":false,\"sortable\":false}},\"hash\":{\"edit\":{\"label\":\"Hash\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Hash\",\"searchable\":true,\"sortable\":true}},\"ext\":{\"edit\":{\"label\":\"Ext\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Ext\",\"searchable\":true,\"sortable\":true}},\"mime\":{\"edit\":{\"label\":\"Mime\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Mime\",\"searchable\":true,\"sortable\":true}},\"size\":{\"edit\":{\"label\":\"Size\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Size\",\"searchable\":true,\"sortable\":true}},\"url\":{\"edit\":{\"label\":\"Url\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Url\",\"searchable\":true,\"sortable\":true}},\"previewUrl\":{\"edit\":{\"label\":\"PreviewUrl\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"PreviewUrl\",\"searchable\":true,\"sortable\":true}},\"provider\":{\"edit\":{\"label\":\"Provider\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Provider\",\"searchable\":true,\"sortable\":true}},\"provider_metadata\":{\"edit\":{\"label\":\"Provider_metadata\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Provider_metadata\",\"searchable\":false,\"sortable\":false}},\"related\":{\"edit\":{\"label\":\"Related\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Related\",\"searchable\":false,\"sortable\":false}},\"created_at\":{\"edit\":{\"label\":\"Created_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Created_at\",\"searchable\":true,\"sortable\":true}},\"updated_at\":{\"edit\":{\"label\":\"Updated_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Updated_at\",\"searchable\":true,\"sortable\":true}}},\"layouts\":{\"list\":[\"id\",\"name\",\"alternativeText\",\"caption\"],\"editRelations\":[\"related\"],\"edit\":[[{\"name\":\"name\",\"size\":6},{\"name\":\"alternativeText\",\"size\":6}],[{\"name\":\"caption\",\"size\":6},{\"name\":\"width\",\"size\":4}],[{\"name\":\"height\",\"size\":4}],[{\"name\":\"formats\",\"size\":12}],[{\"name\":\"hash\",\"size\":6},{\"name\":\"ext\",\"size\":6}],[{\"name\":\"mime\",\"size\":6},{\"name\":\"size\",\"size\":4}],[{\"name\":\"url\",\"size\":6},{\"name\":\"previewUrl\",\"size\":6}],[{\"name\":\"provider\",\"size\":6}],[{\"name\":\"provider_metadata\",\"size\":12}]]}}', 'object', '', ''),
(26, 'plugin_content_manager_configuration_content_types::plugins::users-permissions.permission', '{\"uid\":\"plugins::users-permissions.permission\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"type\",\"defaultSortBy\":\"type\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}},\"type\":{\"edit\":{\"label\":\"Type\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Type\",\"searchable\":true,\"sortable\":true}},\"controller\":{\"edit\":{\"label\":\"Controller\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Controller\",\"searchable\":true,\"sortable\":true}},\"action\":{\"edit\":{\"label\":\"Action\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Action\",\"searchable\":true,\"sortable\":true}},\"enabled\":{\"edit\":{\"label\":\"Enabled\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Enabled\",\"searchable\":true,\"sortable\":true}},\"policy\":{\"edit\":{\"label\":\"Policy\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Policy\",\"searchable\":true,\"sortable\":true}},\"role\":{\"edit\":{\"label\":\"Role\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true,\"mainField\":\"name\"},\"list\":{\"label\":\"Role\",\"searchable\":true,\"sortable\":true}}},\"layouts\":{\"list\":[\"id\",\"type\",\"controller\",\"action\"],\"editRelations\":[\"role\"],\"edit\":[[{\"name\":\"type\",\"size\":6},{\"name\":\"controller\",\"size\":6}],[{\"name\":\"action\",\"size\":6},{\"name\":\"enabled\",\"size\":4}],[{\"name\":\"policy\",\"size\":6}]]}}', 'object', '', ''),
(27, 'plugin_content_manager_configuration_content_types::plugins::users-permissions.role', '{\"uid\":\"plugins::users-permissions.role\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"name\",\"defaultSortBy\":\"name\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}},\"name\":{\"edit\":{\"label\":\"Name\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Name\",\"searchable\":true,\"sortable\":true}},\"description\":{\"edit\":{\"label\":\"Description\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Description\",\"searchable\":true,\"sortable\":true}},\"type\":{\"edit\":{\"label\":\"Type\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Type\",\"searchable\":true,\"sortable\":true}},\"permissions\":{\"edit\":{\"label\":\"Permissions\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true,\"mainField\":\"type\"},\"list\":{\"label\":\"Permissions\",\"searchable\":false,\"sortable\":false}},\"users\":{\"edit\":{\"label\":\"Users\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true,\"mainField\":\"username\"},\"list\":{\"label\":\"Users\",\"searchable\":false,\"sortable\":false}}},\"layouts\":{\"list\":[\"id\",\"name\",\"description\",\"type\"],\"edit\":[[{\"name\":\"name\",\"size\":6},{\"name\":\"description\",\"size\":6}],[{\"name\":\"type\",\"size\":6}]],\"editRelations\":[\"permissions\",\"users\"]}}', 'object', '', ''),
(28, 'plugin_content_manager_configuration_content_types::plugins::users-permissions.user', '{\"uid\":\"plugins::users-permissions.user\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"username\",\"defaultSortBy\":\"username\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}},\"username\":{\"edit\":{\"label\":\"Username\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Username\",\"searchable\":true,\"sortable\":true}},\"email\":{\"edit\":{\"label\":\"Email\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Email\",\"searchable\":true,\"sortable\":true}},\"provider\":{\"edit\":{\"label\":\"Provider\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Provider\",\"searchable\":true,\"sortable\":true}},\"resetPasswordToken\":{\"edit\":{\"label\":\"ResetPasswordToken\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"ResetPasswordToken\",\"searchable\":true,\"sortable\":true}},\"confirmationToken\":{\"edit\":{\"label\":\"ConfirmationToken\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"ConfirmationToken\",\"searchable\":true,\"sortable\":true}},\"confirmed\":{\"edit\":{\"label\":\"Confirmed\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Confirmed\",\"searchable\":true,\"sortable\":true}},\"blocked\":{\"edit\":{\"label\":\"Blocked\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Blocked\",\"searchable\":true,\"sortable\":true}},\"role\":{\"edit\":{\"label\":\"Role\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true,\"mainField\":\"name\"},\"list\":{\"label\":\"Role\",\"searchable\":true,\"sortable\":true}},\"password\":{\"edit\":{\"label\":\"Password\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Password\",\"searchable\":true,\"sortable\":true}},\"token\":{\"edit\":{\"label\":\"Token\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Token\",\"searchable\":true,\"sortable\":true}},\"uid\":{\"edit\":{\"label\":\"Uid\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Uid\",\"searchable\":true,\"sortable\":true}},\"amount\":{\"edit\":{\"label\":\"Amount\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Amount\",\"searchable\":true,\"sortable\":true}},\"paid\":{\"edit\":{\"label\":\"Paid\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Paid\",\"searchable\":true,\"sortable\":true}},\"due\":{\"edit\":{\"label\":\"Due\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Due\",\"searchable\":true,\"sortable\":true}},\"balance\":{\"edit\":{\"label\":\"Balance\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Balance\",\"searchable\":true,\"sortable\":true}},\"rate_limit\":{\"edit\":{\"label\":\"Rate_limit\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Rate_limit\",\"searchable\":true,\"sortable\":true}},\"ip_whiteList\":{\"edit\":{\"label\":\"Ip_whiteList\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Ip_whiteList\",\"searchable\":true,\"sortable\":true}},\"services\":{\"edit\":{\"label\":\"Services\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false,\"mainField\":\"keyWord\"},\"list\":{\"label\":\"Services\",\"searchable\":false,\"sortable\":false}},\"requestMethod\":{\"edit\":{\"label\":\"RequestMethod\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"RequestMethod\",\"searchable\":true,\"sortable\":true}},\"apiUrl\":{\"edit\":{\"label\":\"ApiUrl\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"ApiUrl\",\"searchable\":true,\"sortable\":true}},\"authentication\":{\"edit\":{\"label\":\"Authentication\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Authentication\",\"searchable\":true,\"sortable\":true}},\"credentials\":{\"edit\":{\"label\":\"Credentials\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Credentials\",\"searchable\":true,\"sortable\":true}},\"created_at\":{\"edit\":{\"label\":\"Created_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Created_at\",\"searchable\":true,\"sortable\":true}},\"updated_at\":{\"edit\":{\"label\":\"Updated_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Updated_at\",\"searchable\":true,\"sortable\":true}}},\"layouts\":{\"list\":[\"id\",\"username\",\"email\",\"confirmed\"],\"edit\":[[{\"name\":\"username\",\"size\":6},{\"name\":\"email\",\"size\":6}],[{\"name\":\"password\",\"size\":6},{\"name\":\"token\",\"size\":6}],[{\"name\":\"apiUrl\",\"size\":6},{\"name\":\"requestMethod\",\"size\":6}],[{\"name\":\"authentication\",\"size\":6},{\"name\":\"credentials\",\"size\":6}],[{\"name\":\"rate_limit\",\"size\":4},{\"name\":\"balance\",\"size\":4},{\"name\":\"amount\",\"size\":4}],[{\"name\":\"paid\",\"size\":4},{\"name\":\"due\",\"size\":4}],[{\"name\":\"confirmed\",\"size\":4},{\"name\":\"blocked\",\"size\":4},{\"name\":\"ip_whiteList\",\"size\":4}]],\"editRelations\":[\"role\",\"services\"]}}', 'object', '', ''),
(29, 'plugin_content_manager_configuration_content_types::plugins::billing.payment', '{\"uid\":\"plugins::billing.payment\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"id\",\"defaultSortBy\":\"id\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"details\":{\"edit\":{\"label\":\"Details\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Details\",\"searchable\":true,\"sortable\":true}},\"created_at\":{\"edit\":{\"label\":\"Created_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Created_at\",\"searchable\":true,\"sortable\":true}},\"user\":{\"edit\":{\"label\":\"User\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false,\"mainField\":\"username\"},\"list\":{\"label\":\"User\",\"searchable\":true,\"sortable\":true}},\"paid\":{\"edit\":{\"label\":\"Paid\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Paid\",\"searchable\":true,\"sortable\":true}},\"total_amount\":{\"edit\":{\"label\":\"Total_amount\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Total_amount\",\"searchable\":true,\"sortable\":true}},\"updated_at\":{\"edit\":{\"label\":\"Updated_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Updated_at\",\"searchable\":true,\"sortable\":true}},\"type\":{\"edit\":{\"label\":\"Type\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Type\",\"searchable\":true,\"sortable\":true}},\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}},\"balance\":{\"edit\":{\"label\":\"Balance\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Balance\",\"searchable\":true,\"sortable\":true}}},\"layouts\":{\"edit\":[[{\"name\":\"balance\",\"size\":4},{\"name\":\"total_amount\",\"size\":4},{\"name\":\"paid\",\"size\":4}],[{\"name\":\"type\",\"size\":6},{\"name\":\"details\",\"size\":6}]],\"editRelations\":[\"user\"],\"list\":[\"id\",\"user\",\"balance\",\"total_amount\"]}}', 'object', '', ''),
(31, 'plugin_content_manager_configuration_content_types::plugins::billing.records', '{\"uid\":\"plugins::billing.records\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"id\",\"defaultSortBy\":\"partner_name\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"rate\":{\"edit\":{\"label\":\"Rate\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Rate\",\"searchable\":true,\"sortable\":true}},\"partner_name\":{\"edit\":{\"label\":\"Partner_name\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Partner_name\",\"searchable\":true,\"sortable\":true}},\"operator\":{\"edit\":{\"label\":\"Operator\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Operator\",\"searchable\":true,\"sortable\":true}},\"vendor\":{\"edit\":{\"label\":\"Vendor\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Vendor\",\"searchable\":true,\"sortable\":true}},\"keyWord\":{\"edit\":{\"label\":\"KeyWord\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"KeyWord\",\"searchable\":true,\"sortable\":true}},\"created_at\":{\"edit\":{\"label\":\"Created_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Created_at\",\"searchable\":true,\"sortable\":true}},\"billerType\":{\"edit\":{\"label\":\"BillerType\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"BillerType\",\"searchable\":true,\"sortable\":true}},\"serviceId\":{\"edit\":{\"label\":\"ServiceId\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"ServiceId\",\"searchable\":true,\"sortable\":true}},\"tx_id\":{\"edit\":{\"label\":\"Tx_id\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Tx_id\",\"searchable\":true,\"sortable\":true}},\"updated_at\":{\"edit\":{\"label\":\"Updated_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Updated_at\",\"searchable\":true,\"sortable\":true}},\"serviceTier\":{\"edit\":{\"label\":\"ServiceTier\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"ServiceTier\",\"searchable\":true,\"sortable\":true}},\"created_at_gmt\":{\"edit\":{\"label\":\"Created_at_gmt\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Created_at_gmt\",\"searchable\":true,\"sortable\":true}},\"msisdn\":{\"edit\":{\"label\":\"Msisdn\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"MSISDN\",\"searchable\":true,\"sortable\":true}},\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}},\"cronDate\":{\"edit\":{\"label\":\"CronDate\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"CronDate\",\"searchable\":true,\"sortable\":true}}},\"layouts\":{\"edit\":[[{\"name\":\"partner_name\",\"size\":6},{\"name\":\"vendor\",\"size\":6}],[{\"name\":\"operator\",\"size\":6},{\"name\":\"keyWord\",\"size\":6}],[{\"name\":\"serviceId\",\"size\":6},{\"name\":\"tx_id\",\"size\":6}],[{\"name\":\"rate\",\"size\":4},{\"name\":\"msisdn\",\"size\":6}],[{\"name\":\"serviceTier\",\"size\":6},{\"name\":\"billerType\",\"size\":6}],[{\"name\":\"created_at_gmt\",\"size\":6},{\"name\":\"cronDate\",\"size\":6}]],\"editRelations\":[],\"list\":[\"serviceId\",\"msisdn\",\"created_at\",\"created_at_gmt\"]}}', 'object', '', ''),
(32, 'plugin_content_manager_configuration_content_types::plugins::ip-whitelist.ip-whitelist', '{\"uid\":\"plugins::ip-whitelist.ip-whitelist\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"ip\",\"defaultSortBy\":\"ip\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}},\"user\":{\"edit\":{\"label\":\"User\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true,\"mainField\":\"username\"},\"list\":{\"label\":\"User\",\"searchable\":true,\"sortable\":true}},\"ip\":{\"edit\":{\"label\":\"Ip\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Ip\",\"searchable\":true,\"sortable\":true}},\"rate_limit\":{\"edit\":{\"label\":\"Rate_limit\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Rate_limit\",\"searchable\":true,\"sortable\":true}},\"created_at\":{\"edit\":{\"label\":\"Created_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Created_at\",\"searchable\":true,\"sortable\":true}},\"updated_at\":{\"edit\":{\"label\":\"Updated_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Updated_at\",\"searchable\":true,\"sortable\":true}}},\"layouts\":{\"list\":[\"id\",\"user\",\"ip\",\"rate_limit\"],\"editRelations\":[\"user\"],\"edit\":[[{\"name\":\"ip\",\"size\":6},{\"name\":\"rate_limit\",\"size\":4}]]}}', 'object', '', ''),
(33, 'plugin_users-permissions_email', '{\"reset_password\":{\"display\":\"Email.template.reset_password\",\"icon\":\"sync\",\"options\":{\"from\":{\"name\":\"Administration Panel\",\"email\":\"no-reply@strapi.io\"},\"response_email\":\"\",\"object\":\"Reset password\",\"message\":\"<p>We heard that you lost your password. Sorry about that!</p>\\n\\n<p>But don’t worry! You can use the following link to reset your password:</p>\\n<p><%= URL %>?code=<%= TOKEN %></p>\\n\\n<p>Thanks.</p>\"}},\"email_confirmation\":{\"display\":\"Email.template.email_confirmation\",\"icon\":\"check-square\",\"options\":{\"from\":{\"name\":\"Administration Panel\",\"email\":\"no-reply@strapi.io\"},\"response_email\":\"\",\"object\":\"Account confirmation\",\"message\":\"<p>Thank you for registering!</p>\\n\\n<p>You have to confirm your email address. Please click on the link below.</p>\\n\\n<p><%= URL %>?confirmation=<%= CODE %></p>\\n\\n<p>Thanks.</p>\"}}}', 'object', '', ''),
(34, 'plugin_users-permissions_advanced', '{\"unique_email\":true,\"allow_register\":true,\"email_confirmation\":false,\"email_reset_password\":null,\"email_confirmation_redirection\":null,\"default_role\":\"authenticated\"}', 'object', '', ''),
(35, 'core_admin_auth', '{\"providers\":{\"autoRegister\":false,\"defaultRole\":null}}', 'object', '', ''),
(37, 'model_def_application::operator.operator', '{\"uid\":\"application::operator.operator\",\"collectionName\":\"operators\",\"kind\":\"collectionType\",\"info\":{\"name\":\"operator\",\"description\":\"\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"Publish\":true,\"draftAndPublish\":false},\"attributes\":{\"name\":{\"type\":\"string\",\"unique\":false},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"private\":true}}}', 'object', NULL, NULL);
INSERT INTO `core_store` (`id`, `key`, `value`, `type`, `environment`, `tag`) VALUES
(39, 'model_def_application::partner.partner', '{\"uid\":\"application::partner.partner\",\"collectionName\":\"partners\",\"kind\":\"collectionType\",\"info\":{\"name\":\"partner\",\"description\":\"\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"draftAndPublish\":false},\"attributes\":{\"name\":{\"type\":\"string\",\"required\":true,\"unique\":true},\"email\":{\"type\":\"email\",\"required\":true,\"unique\":true},\"shortCode\":{\"type\":\"text\",\"required\":true},\"password\":{\"type\":\"password\"},\"services\":{\"via\":\"partner\",\"collection\":\"service\",\"isVirtual\":true},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true}}}', 'object', NULL, NULL),
(41, 'model_def_application::client.client', '{\"uid\":\"application::client.client\",\"collectionName\":\"clients\",\"kind\":\"collectionType\",\"info\":{\"name\":\"client\",\"description\":\"\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"draftAndPublish\":true},\"attributes\":{\"method\":{\"type\":\"string\"},\"keyWord\":{\"type\":\"string\"},\"users_permissions_users\":{\"via\":\"client\",\"plugin\":\"users-permissions\",\"collection\":\"user\",\"isVirtual\":true},\"api\":{\"type\":\"text\"},\"published_at\":{\"type\":\"datetime\",\"configurable\":false},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"private\":true}}}', 'object', NULL, NULL),
(43, 'model_def_application::assign-keyword.assign-keyword', '{\"uid\":\"application::assign-keyword.assign-keyword\",\"collectionName\":\"assign_keywords\",\"kind\":\"collectionType\",\"info\":{\"name\":\"assign_keyword\",\"description\":\"\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"draftAndPublish\":false},\"attributes\":{\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true}}}', 'object', NULL, NULL),
(45, 'model_def_application::service.service', '{\"uid\":\"application::service.service\",\"collectionName\":\"services\",\"kind\":\"collectionType\",\"info\":{\"name\":\"service\",\"description\":\"\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"draftAndPublish\":false},\"attributes\":{\"operator\":{\"type\":\"enumeration\",\"enum\":[\"Robi_44778\",\"GP_78874\",\"BL_55481\",\"Airtel_48545\",\"TT_77594\"],\"required\":true},\"keyWord\":{\"type\":\"string\",\"required\":true},\"vendor\":{\"via\":\"services\",\"plugin\":\"users-permissions\",\"model\":\"user\"},\"rate\":{\"type\":\"decimal\",\"required\":true},\"shortCode\":{\"type\":\"string\",\"required\":true},\"serviceTier\":{\"type\":\"enumeration\",\"enum\":[\"OnDemand\",\"Subscription\"],\"required\":true},\"chargeType\":{\"type\":\"enumeration\",\"enum\":[\"SMS\",\"WAP\"],\"required\":true},\"serviceId\":{\"type\":\"string\",\"unique\":false,\"required\":true},\"timeLine\":{\"type\":\"integer\",\"default\":0},\"partner\":{\"via\":\"services\",\"model\":\"partner\"},\"serviceName\":{\"type\":\"string\",\"required\":true},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true}}}', 'object', NULL, NULL),
(46, 'plugin_content_manager_configuration_content_types::application::service.service', '{\"uid\":\"application::service.service\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"keyWord\",\"defaultSortBy\":\"keyWord\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"rate\":{\"edit\":{\"label\":\"Rate\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Rate\",\"searchable\":true,\"sortable\":true}},\"serviceName\":{\"edit\":{\"label\":\"ServiceName\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"ServiceName\",\"searchable\":true,\"sortable\":true}},\"timeLine\":{\"edit\":{\"label\":\"TimeLine\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"TimeLine\",\"searchable\":true,\"sortable\":true}},\"operator\":{\"edit\":{\"label\":\"Operator\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Operator\",\"searchable\":true,\"sortable\":true}},\"partner\":{\"edit\":{\"label\":\"Partner\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true,\"mainField\":\"name\"},\"list\":{\"label\":\"Partner\",\"searchable\":true,\"sortable\":true}},\"vendor\":{\"edit\":{\"label\":\"Vendor\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true,\"mainField\":\"username\"},\"list\":{\"label\":\"Vendor\",\"searchable\":true,\"sortable\":true}},\"shortCode\":{\"edit\":{\"label\":\"ShortCode\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"ShortCode\",\"searchable\":true,\"sortable\":true}},\"keyWord\":{\"edit\":{\"label\":\"KeyWord\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"KeyWord\",\"searchable\":true,\"sortable\":true}},\"created_at\":{\"edit\":{\"label\":\"Created_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Created_at\",\"searchable\":true,\"sortable\":true}},\"chargeType\":{\"edit\":{\"label\":\"ChargeType\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"ChargeType\",\"searchable\":true,\"sortable\":true}},\"serviceId\":{\"edit\":{\"label\":\"ServiceId\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"ServiceId\",\"searchable\":true,\"sortable\":true}},\"updated_at\":{\"edit\":{\"label\":\"Updated_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Updated_at\",\"searchable\":true,\"sortable\":true}},\"serviceTier\":{\"edit\":{\"label\":\"ServiceTier\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"ServiceTier\",\"searchable\":true,\"sortable\":true}},\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}}},\"layouts\":{\"edit\":[[{\"name\":\"serviceId\",\"size\":6},{\"name\":\"serviceName\",\"size\":6}],[{\"name\":\"keyWord\",\"size\":6},{\"name\":\"operator\",\"size\":6}],[{\"name\":\"chargeType\",\"size\":6},{\"name\":\"serviceTier\",\"size\":6}],[{\"name\":\"rate\",\"size\":4},{\"name\":\"timeLine\",\"size\":4}],[{\"name\":\"shortCode\",\"size\":6}]],\"editRelations\":[\"vendor\",\"partner\"],\"list\":[\"serviceName\",\"partner\",\"vendor\",\"keyWord\",\"rate\"]}}', 'object', '', ''),
(47, 'plugin_content_manager_configuration_content_types::application::demo.demo', '{\"uid\":\"application::demo.demo\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"client_id\",\"defaultSortBy\":\"client_id\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}},\"client_id\":{\"edit\":{\"label\":\"Client_id\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Client_id\",\"searchable\":true,\"sortable\":true}},\"shortcode\":{\"edit\":{\"label\":\"Shortcode\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Shortcode\",\"searchable\":true,\"sortable\":true}},\"msisdn\":{\"edit\":{\"label\":\"Msisdn\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Msisdn\",\"searchable\":true,\"sortable\":true}},\"key_word\":{\"edit\":{\"label\":\"Key_word\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Key_word\",\"searchable\":true,\"sortable\":true}},\"transid\":{\"edit\":{\"label\":\"Transid\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Transid\",\"searchable\":true,\"sortable\":true}},\"operator\":{\"edit\":{\"label\":\"Operator\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Operator\",\"searchable\":true,\"sortable\":true}},\"serviceid\":{\"edit\":{\"label\":\"Serviceid\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Serviceid\",\"searchable\":true,\"sortable\":true}},\"created_at\":{\"edit\":{\"label\":\"Created_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Created_at\",\"searchable\":true,\"sortable\":true}},\"updated_at\":{\"edit\":{\"label\":\"Updated_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Updated_at\",\"searchable\":true,\"sortable\":true}}},\"layouts\":{\"list\":[\"id\",\"client_id\",\"shortcode\",\"msisdn\"],\"edit\":[[{\"name\":\"client_id\",\"size\":6},{\"name\":\"shortcode\",\"size\":6}],[{\"name\":\"msisdn\",\"size\":6},{\"name\":\"key_word\",\"size\":6}],[{\"name\":\"transid\",\"size\":6},{\"name\":\"operator\",\"size\":6}],[{\"name\":\"serviceid\",\"size\":6}]],\"editRelations\":[]}}', 'object', '', ''),
(48, 'model_def_application::notification-record.notification-record', '{\"uid\":\"application::notification-record.notification-record\",\"collectionName\":\"notification_records\",\"kind\":\"collectionType\",\"info\":{\"name\":\"notification\",\"description\":\"\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"draftAndPublish\":true},\"attributes\":{\"vendor\":{\"type\":\"string\"},\"api\":{\"type\":\"string\"},\"method\":{\"type\":\"string\"},\"status\":{\"type\":\"string\"},\"tx_id\":{\"type\":\"string\"},\"published_at\":{\"type\":\"datetime\",\"configurable\":false},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"private\":true}}}', 'object', NULL, NULL),
(50, 'model_def_application::notification.notification-record', '{\"uid\":\"application::notification.notification-record\",\"collectionName\":\"notification_records\",\"kind\":\"collectionType\",\"info\":{\"name\":\"notification\",\"description\":\"\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"draftAndPublish\":true},\"attributes\":{\"vendor\":{\"type\":\"string\"},\"api\":{\"type\":\"string\"},\"method\":{\"type\":\"string\"},\"status\":{\"type\":\"string\"},\"tx_id\":{\"type\":\"string\"},\"published_at\":{\"type\":\"datetime\",\"configurable\":false},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"private\":true}}}', 'object', NULL, NULL),
(52, 'model_def_application::notification.notification', '{\"uid\":\"application::notification.notification\",\"collectionName\":\"notifications\",\"kind\":\"collectionType\",\"info\":{\"name\":\"notification\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"draftAndPublish\":true},\"attributes\":{\"vendor\":{\"type\":\"string\"},\"api\":{\"type\":\"string\"},\"method\":{\"type\":\"string\"},\"status\":{\"type\":\"string\"},\"tx_id\":{\"type\":\"string\"},\"published_at\":{\"type\":\"datetime\",\"configurable\":false,\"writable\":true,\"visible\":false},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true}}}', 'object', NULL, NULL),
(54, 'plugin_content_manager_configuration_content_types::application::notification.notification', '{\"uid\":\"application::notification.notification\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"vendor\",\"defaultSortBy\":\"vendor\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}},\"vendor\":{\"edit\":{\"label\":\"Vendor\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Vendor\",\"searchable\":true,\"sortable\":true}},\"api\":{\"edit\":{\"label\":\"Api\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Api\",\"searchable\":true,\"sortable\":true}},\"method\":{\"edit\":{\"label\":\"Method\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Method\",\"searchable\":true,\"sortable\":true}},\"status\":{\"edit\":{\"label\":\"Status\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Status\",\"searchable\":true,\"sortable\":true}},\"tx_id\":{\"edit\":{\"label\":\"Tx_id\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Tx_id\",\"searchable\":true,\"sortable\":true}},\"created_at\":{\"edit\":{\"label\":\"Created_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Created_at\",\"searchable\":true,\"sortable\":true}},\"updated_at\":{\"edit\":{\"label\":\"Updated_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Updated_at\",\"searchable\":true,\"sortable\":true}}},\"layouts\":{\"list\":[\"id\",\"vendor\",\"api\",\"method\"],\"edit\":[[{\"name\":\"vendor\",\"size\":6},{\"name\":\"api\",\"size\":6}],[{\"name\":\"method\",\"size\":6},{\"name\":\"status\",\"size\":6}],[{\"name\":\"tx_id\",\"size\":6}]],\"editRelations\":[]}}', 'object', '', ''),
(55, 'plugin_content_manager_configuration_content_types::application::partner.partner', '{\"uid\":\"application::partner.partner\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"name\",\"defaultSortBy\":\"name\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}},\"name\":{\"edit\":{\"label\":\"Name\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Name\",\"searchable\":true,\"sortable\":true}},\"email\":{\"edit\":{\"label\":\"Email\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Email\",\"searchable\":true,\"sortable\":true}},\"shortCode\":{\"edit\":{\"label\":\"ShortCode\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"ShortCode\",\"searchable\":true,\"sortable\":true}},\"password\":{\"edit\":{\"label\":\"Password\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true},\"list\":{\"label\":\"Password\",\"searchable\":true,\"sortable\":true}},\"services\":{\"edit\":{\"label\":\"Services\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":true,\"mainField\":\"keyWord\"},\"list\":{\"label\":\"Services\",\"searchable\":false,\"sortable\":false}},\"created_at\":{\"edit\":{\"label\":\"Created_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Created_at\",\"searchable\":true,\"sortable\":true}},\"updated_at\":{\"edit\":{\"label\":\"Updated_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Updated_at\",\"searchable\":true,\"sortable\":true}}},\"layouts\":{\"list\":[\"id\",\"name\",\"email\",\"shortCode\"],\"editRelations\":[\"services\"],\"edit\":[[{\"name\":\"name\",\"size\":6},{\"name\":\"email\",\"size\":6}],[{\"name\":\"shortCode\",\"size\":6},{\"name\":\"password\",\"size\":6}]]}}', 'object', '', ''),
(56, 'model_def_application::hit-report.hit-report', '{\"uid\":\"application::hit-report.hit-report\",\"collectionName\":\"hit_reports\",\"kind\":\"collectionType\",\"info\":{\"name\":\"hit-Report\",\"description\":\"\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"draftAndPublish\":true},\"attributes\":{\"vendor\":{\"type\":\"string\"},\"service\":{\"type\":\"string\"},\"totalHit\":{\"type\":\"integer\"},\"vendorTotal\":{\"type\":\"integer\"},\"published_at\":{\"type\":\"datetime\",\"configurable\":false,\"writable\":true,\"visible\":false},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true}}}', 'object', NULL, NULL),
(57, 'plugin_content_manager_configuration_content_types::application::hit-report.hit-report', '{\"uid\":\"application::hit-report.hit-report\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"vendor\",\"defaultSortBy\":\"vendor\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}},\"vendor\":{\"edit\":{\"label\":\"Vendor\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Vendor\",\"searchable\":true,\"sortable\":true}},\"service\":{\"edit\":{\"label\":\"Service\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Service\",\"searchable\":true,\"sortable\":true}},\"totalHit\":{\"edit\":{\"label\":\"TotalHit\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"TotalHit\",\"searchable\":true,\"sortable\":true}},\"vendorTotal\":{\"edit\":{\"label\":\"VendorTotal\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"VendorTotal\",\"searchable\":true,\"sortable\":true}},\"created_at\":{\"edit\":{\"label\":\"Created_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Created_at\",\"searchable\":true,\"sortable\":true}},\"updated_at\":{\"edit\":{\"label\":\"Updated_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Updated_at\",\"searchable\":true,\"sortable\":true}}},\"layouts\":{\"list\":[\"vendor\",\"service\",\"totalHit\",\"vendorTotal\"],\"edit\":[[{\"name\":\"vendor\",\"size\":6},{\"name\":\"service\",\"size\":6}],[{\"name\":\"totalHit\",\"size\":4},{\"name\":\"vendorTotal\",\"size\":4}]],\"editRelations\":[]}}', 'object', '', ''),
(58, 'plugin_upload_settings', '{\"sizeOptimization\":true,\"responsiveDimensions\":true}', 'object', 'production', ''),
(59, 'model_def_application::subscription-status.subscription-status', '{\"uid\":\"application::subscription-status.subscription-status\",\"collectionName\":\"subscription_statuses\",\"kind\":\"collectionType\",\"info\":{\"name\":\"subscription_Records\",\"description\":\"\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"draftAndPublish\":false},\"attributes\":{\"msisdn\":{\"type\":\"string\",\"unique\":false,\"required\":true},\"serviceId\":{\"type\":\"string\",\"required\":true,\"unique\":false},\"status\":{\"type\":\"string\",\"required\":false},\"vendor\":{\"type\":\"string\",\"required\":false},\"created_at_gmt\":{\"type\":\"datetime\"},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true}}}', 'object', NULL, NULL),
(60, 'plugin_content_manager_configuration_content_types::application::subscription-status.subscription-status', '{\"uid\":\"application::subscription-status.subscription-status\",\"settings\":{\"bulkable\":true,\"filterable\":true,\"searchable\":true,\"pageSize\":10,\"mainField\":\"msisdn\",\"defaultSortBy\":\"msisdn\",\"defaultSortOrder\":\"ASC\"},\"metadatas\":{\"id\":{\"edit\":{},\"list\":{\"label\":\"Id\",\"searchable\":true,\"sortable\":true}},\"msisdn\":{\"edit\":{\"label\":\"MSISDN\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"MSISDN\",\"searchable\":true,\"sortable\":true}},\"serviceId\":{\"edit\":{\"label\":\"ServiceId\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"ServiceId\",\"searchable\":true,\"sortable\":true}},\"status\":{\"edit\":{\"label\":\"Status\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Status\",\"searchable\":true,\"sortable\":true}},\"vendor\":{\"edit\":{\"label\":\"Vendor\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Vendor\",\"searchable\":true,\"sortable\":true}},\"created_at_gmt\":{\"edit\":{\"label\":\"Created_at_gmt\",\"description\":\"\",\"placeholder\":\"\",\"visible\":true,\"editable\":false},\"list\":{\"label\":\"Created_at_gmt\",\"searchable\":true,\"sortable\":true}},\"created_at\":{\"edit\":{\"label\":\"Created_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Created_at\",\"searchable\":true,\"sortable\":true}},\"updated_at\":{\"edit\":{\"label\":\"Updated_at\",\"description\":\"\",\"placeholder\":\"\",\"visible\":false,\"editable\":true},\"list\":{\"label\":\"Updated_at\",\"searchable\":true,\"sortable\":true}}},\"layouts\":{\"edit\":[[{\"name\":\"serviceId\",\"size\":6}],[{\"name\":\"status\",\"size\":6},{\"name\":\"vendor\",\"size\":6}],[{\"name\":\"msisdn\",\"size\":6},{\"name\":\"created_at_gmt\",\"size\":6}]],\"editRelations\":[],\"list\":[\"serviceId\",\"msisdn\",\"vendor\",\"status\",\"created_at\"]}}', 'object', '', ''),
(61, 'model_def_application::homepage.homepage', '{\"uid\":\"application::homepage.homepage\",\"collectionName\":\"homepages\",\"kind\":\"singleType\",\"info\":{\"name\":\"Homepage\"},\"options\":{\"increments\":true,\"timestamps\":[\"created_at\",\"updated_at\"],\"draftAndPublish\":true},\"attributes\":{\"hello\":{\"type\":\"string\"},\"published_at\":{\"type\":\"datetime\",\"configurable\":false,\"writable\":true,\"visible\":false},\"created_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true},\"updated_by\":{\"model\":\"user\",\"plugin\":\"admin\",\"configurable\":false,\"writable\":false,\"visible\":false,\"private\":true}}}', 'object', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `demos`
--

CREATE TABLE `demos` (
  `id` int(10) UNSIGNED NOT NULL,
  `client_id` varchar(255) DEFAULT NULL,
  `shortcode` varchar(255) DEFAULT NULL,
  `msisdn` varchar(255) DEFAULT NULL,
  `key_word` varchar(255) DEFAULT NULL,
  `transid` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL,
  `serviceid` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `gp`
--

CREATE TABLE `gp` (
  `id` int(11) NOT NULL,
  `servicekey` varchar(255) NOT NULL,
  `endUserId` varchar(255) NOT NULL,
  `accesschannel` varchar(255) NOT NULL,
  `referenceCode` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `partner` varchar(50) DEFAULT NULL,
  `amount` double NOT NULL,
  `taxAmount` double DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `msgTransactionId` varchar(255) NOT NULL,
  `language` varchar(255) NOT NULL,
  `senderId` varchar(255) DEFAULT NULL,
  `productIdentifier` varchar(100) DEFAULT NULL,
  `message` varchar(255) NOT NULL,
  `msgType` varchar(255) NOT NULL,
  `validity` varchar(255) DEFAULT NULL,
  `deliveryReport` varchar(255) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `hit_reports`
--

CREATE TABLE `hit_reports` (
  `id` int(10) UNSIGNED NOT NULL,
  `vendor` varchar(255) DEFAULT NULL,
  `service` varchar(255) DEFAULT NULL,
  `totalHit` int(11) DEFAULT NULL,
  `published_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `vendorTotal` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `hit_reports`
--

INSERT INTO `hit_reports` (`id`, `vendor`, `service`, `totalHit`, `published_at`, `created_by`, `updated_by`, `created_at`, `updated_at`, `vendorTotal`) VALUES
(13, 'Game1', 'PPU00056600009', 0, '2021-10-11 09:49:00', NULL, NULL, '2021-10-11 09:49:00', '2021-10-28 01:16:00', 0),
(14, 'Game1', 'PPU00056600005', 13, '2021-10-12 07:21:00', NULL, NULL, '2021-10-12 07:21:00', '2021-10-12 07:20:00', 50),
(15, 'Game1', 'PPU00056600008', 30, '2021-10-12 08:19:00', NULL, NULL, '2021-10-12 08:19:00', '2021-10-12 07:20:00', 50),
(16, 'Game1', 'PPU000566000012', 7, '2021-10-12 10:11:00', NULL, NULL, '2021-10-12 10:11:00', '2021-10-12 07:20:00', 50),
(17, 'Game1', 'PPU000566000078', 0, '2021-10-13 07:31:00', NULL, NULL, '2021-10-13 01:31:00', '2021-10-13 01:31:00', 50),
(18, 'Game1', 'PPU00056600004000000', 0, '2021-10-13 07:47:01', NULL, NULL, '2021-10-13 01:47:01', '2021-10-28 01:16:00', 0),
(19, 'Game1', '15987', 0, '2021-10-13 07:49:00', NULL, NULL, '2021-10-13 01:49:00', '2021-10-13 01:49:00', 50),
(20, 'Game1', '43412', 0, '2021-10-13 07:53:00', NULL, NULL, '2021-10-13 01:53:00', '2021-10-13 01:53:00', 50),
(21, 'Game1', 'PPU0005', 0, '2021-10-13 12:49:00', NULL, NULL, '2021-10-13 06:49:00', '2021-10-28 01:16:00', 0),
(22, 'Game1', 'PPU00056', 0, '2021-10-13 13:19:00', NULL, NULL, '2021-10-13 07:19:00', '2021-10-28 01:16:00', 0);

-- --------------------------------------------------------

--
-- Table structure for table `homepages`
--

CREATE TABLE `homepages` (
  `id` int(10) UNSIGNED NOT NULL,
  `hello` varchar(255) DEFAULT NULL,
  `published_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `ip-whitelist`
--

CREATE TABLE `ip-whitelist` (
  `id` int(10) UNSIGNED NOT NULL,
  `user` int(11) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `rate_limit` int(11) NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(10) UNSIGNED NOT NULL,
  `vendor` varchar(255) DEFAULT NULL,
  `api` varchar(255) DEFAULT NULL,
  `method` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `tx_id` varchar(255) DEFAULT NULL,
  `published_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `partners_vendors__users_partners`
--

CREATE TABLE `partners_vendors__users_partners` (
  `id` int(10) UNSIGNED NOT NULL,
  `partner_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `partners_vendors__users_partners`
--

INSERT INTO `partners_vendors__users_partners` (`id`, `partner_id`, `user_id`) VALUES
(1, 3, 3);

-- --------------------------------------------------------

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(10) UNSIGNED NOT NULL,
  `user` int(11) NOT NULL,
  `balance` double DEFAULT NULL,
  `total_amount` double DEFAULT NULL,
  `paid` double DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `details` longtext DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `records`
--

CREATE TABLE `records` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `partner_name` varchar(255) DEFAULT NULL,
  `vendor` varchar(255) DEFAULT NULL,
  `rate` decimal(10,2) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL,
  `keyWord` varchar(255) DEFAULT NULL,
  `serviceId` varchar(255) DEFAULT NULL,
  `tx_id` varchar(255) DEFAULT NULL,
  `mssidn` varchar(255) DEFAULT NULL,
  `msisdn` varchar(255) DEFAULT NULL,
  `serviceTier` varchar(255) DEFAULT NULL,
  `billerType` varchar(255) NOT NULL,
  `cronDate` datetime DEFAULT current_timestamp(),
  `created_at_gmt` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(10) UNSIGNED NOT NULL,
  `shortCode` varchar(255) NOT NULL,
  `operator` varchar(255) NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `partner_name` varchar(255) DEFAULT NULL,
  `keyWord` varchar(255) NOT NULL,
  `rate` decimal(10,2) NOT NULL,
  `serviceTier` varchar(255) NOT NULL,
  `chargeType` varchar(255) NOT NULL,
  `timeLine` int(11) DEFAULT NULL,
  `serviceId` varchar(255) NOT NULL,
  `vendor` int(11) DEFAULT NULL,
  `partner` int(11) DEFAULT NULL,
  `serviceName` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `shortCode`, `operator`, `created_by`, `updated_by`, `created_at`, `updated_at`, `partner_name`, `keyWord`, `rate`, `serviceTier`, `chargeType`, `timeLine`, `serviceId`, `vendor`, `partner`, `serviceName`) VALUES
(10, '16672', 'GP_78874', 1, 1, '2021-10-04 15:11:44', '2021-10-22 05:13:43', NULL, 'MG2', '2.00', 'OnDemand', 'SMS', 0, 'PPU00056600009', 5, 5, 'service1'),
(26228, '44785', 'Robi_44778', 1, 1, '2021-10-13 02:32:35', '2021-10-22 05:13:43', NULL, 'START SU', '2.00', 'Subscription', 'SMS', 0, 'PPU00056600004000000', 5, 5, 'service2'),
(26229, '44785', 'Robi_44778', 1, 1, '2021-10-13 02:32:35', '2021-10-22 05:13:43', NULL, 'STOP SU', '0.00', 'Subscription', 'SMS', 0, 'PPU00056600004000000', 5, 5, 'service2'),
(26230, '44785', 'Robi_44778', 1, 1, '2021-10-13 02:32:35', '2021-10-22 05:13:43', NULL, 'PENDING SU', '0.00', 'Subscription', 'SMS', 0, 'PPU00056600004000000', 5, 5, 'service2'),
(26231, '44785', 'Robi_44778', 1, 1, '2021-10-13 06:48:18', '2021-10-22 05:13:43', NULL, 'START NU', '5.00', 'Subscription', 'SMS', 1, 'PPU0005', 5, 5, 'service4'),
(26232, '44785', 'Robi_44778', 1, 1, '2021-10-13 06:48:18', '2021-10-22 05:13:43', NULL, 'STOP NU', '0.00', 'Subscription', 'SMS', 1, 'PPU0005', 5, 5, 'service4'),
(26233, '44785', 'Robi_44778', 1, 1, '2021-10-13 06:48:18', '2021-10-22 05:13:43', NULL, 'PENDING NU', '0.00', 'Subscription', 'SMS', 1, 'PPU0005', 5, 5, 'service4'),
(26234, '44520', 'Robi_44778', 1, 1, '2021-10-13 07:18:23', '2021-10-22 05:13:43', NULL, 'START ZU', '6.00', 'Subscription', 'SMS', 0, 'PPU00056', 5, 5, 'service3'),
(26235, '44520', 'Robi_44778', 1, 1, '2021-10-13 07:18:23', '2021-10-22 05:13:43', NULL, 'STOP ZU', '0.00', 'Subscription', 'SMS', 0, 'PPU00056', 5, 5, 'service3'),
(26236, '44520', 'Robi_44778', 1, 1, '2021-10-13 07:18:23', '2021-10-22 05:13:43', NULL, 'PENDING ZU', '0.00', 'Subscription', 'SMS', 0, 'PPU00056', 5, 5, 'service3');

-- --------------------------------------------------------

--
-- Table structure for table `strapi_permission`
--

CREATE TABLE `strapi_permission` (
  `id` int(10) UNSIGNED NOT NULL,
  `action` varchar(255) NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `fields` longtext DEFAULT NULL,
  `conditions` longtext DEFAULT NULL,
  `role` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `properties` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `strapi_permission`
--

INSERT INTO `strapi_permission` (`id`, `action`, `subject`, `fields`, `conditions`, `role`, `created_at`, `updated_at`, `properties`) VALUES
(4, 'plugins::content-manager.explorer.create', 'plugins::billing.payment', '[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]', '[]', 2, '2021-07-26 11:05:37', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]}'),
(6, 'plugins::content-manager.explorer.create', 'plugins::billing.records', '[]', '[]', 2, '2021-07-26 11:05:37', '2021-10-14 02:50:13', '{\"fields\":[\"billerType\"]}'),
(7, 'plugins::content-manager.explorer.create', 'plugins::ip-whitelist.ip-whitelist', '[\"user\",\"ip\",\"rate_limit\"]', '[]', 2, '2021-07-26 11:05:37', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"ip\",\"rate_limit\"]}'),
(11, 'plugins::content-manager.explorer.read', 'plugins::billing.payment', '[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]', '[]', 2, '2021-07-26 11:05:37', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]}'),
(13, 'plugins::content-manager.explorer.read', 'plugins::billing.records', '[]', '[]', 2, '2021-07-26 11:05:37', '2021-10-14 02:50:13', '{\"fields\":[\"billerType\"]}'),
(14, 'plugins::content-manager.explorer.read', 'plugins::ip-whitelist.ip-whitelist', '[\"user\",\"ip\",\"rate_limit\"]', '[]', 2, '2021-07-26 11:05:37', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"ip\",\"rate_limit\"]}'),
(18, 'plugins::content-manager.explorer.update', 'plugins::billing.payment', '[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]', '[]', 2, '2021-07-26 11:05:37', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]}'),
(20, 'plugins::content-manager.explorer.update', 'plugins::billing.records', '[]', '[]', 2, '2021-07-26 11:05:37', '2021-10-14 02:50:13', '{\"fields\":[\"billerType\"]}'),
(21, 'plugins::content-manager.explorer.update', 'plugins::ip-whitelist.ip-whitelist', '[\"user\",\"ip\",\"rate_limit\"]', '[]', 2, '2021-07-26 11:05:38', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"ip\",\"rate_limit\"]}'),
(25, 'plugins::content-manager.explorer.delete', 'plugins::billing.payment', NULL, '[]', 2, '2021-07-26 11:05:38', '2021-09-18 09:06:54', '{\"fields\":null}'),
(27, 'plugins::content-manager.explorer.delete', 'plugins::billing.records', NULL, '[]', 2, '2021-07-26 11:05:38', '2021-09-18 09:06:54', '{\"fields\":null}'),
(28, 'plugins::content-manager.explorer.delete', 'plugins::ip-whitelist.ip-whitelist', NULL, '[]', 2, '2021-07-26 11:05:38', '2021-09-18 09:06:54', '{\"fields\":null}'),
(31, 'plugins::upload.read', NULL, NULL, '[]', 2, '2021-07-26 11:05:38', '2021-09-18 09:06:54', '{\"fields\":null}'),
(32, 'plugins::upload.assets.create', NULL, NULL, '[]', 2, '2021-07-26 11:05:38', '2021-09-18 09:06:54', '{\"fields\":null}'),
(33, 'plugins::upload.assets.update', NULL, NULL, '[]', 2, '2021-07-26 11:05:38', '2021-09-18 09:06:54', '{\"fields\":null}'),
(34, 'plugins::upload.assets.download', NULL, NULL, '[]', 2, '2021-07-26 11:05:38', '2021-09-18 09:06:54', '{\"fields\":null}'),
(35, 'plugins::upload.assets.copy-link', NULL, NULL, '[]', 2, '2021-07-26 11:05:38', '2021-09-18 09:06:54', '{\"fields\":null}'),
(39, 'plugins::content-manager.explorer.create', 'plugins::billing.payment', '[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]', '[\"admin::is-creator\"]', 3, '2021-07-26 11:05:38', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]}'),
(41, 'plugins::content-manager.explorer.create', 'plugins::billing.records', '[]', '[\"admin::is-creator\"]', 3, '2021-07-26 11:05:38', '2021-10-14 02:50:13', '{\"fields\":[\"billerType\"]}'),
(42, 'plugins::content-manager.explorer.create', 'plugins::ip-whitelist.ip-whitelist', '[\"user\",\"ip\",\"rate_limit\"]', '[\"admin::is-creator\"]', 3, '2021-07-26 11:05:38', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"ip\",\"rate_limit\"]}'),
(46, 'plugins::content-manager.explorer.read', 'plugins::billing.payment', '[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]', '[\"admin::is-creator\"]', 3, '2021-07-26 11:05:38', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]}'),
(48, 'plugins::content-manager.explorer.read', 'plugins::billing.records', '[]', '[\"admin::is-creator\"]', 3, '2021-07-26 11:05:38', '2021-10-14 02:50:13', '{\"fields\":[\"billerType\"]}'),
(49, 'plugins::content-manager.explorer.read', 'plugins::ip-whitelist.ip-whitelist', '[\"user\",\"ip\",\"rate_limit\"]', '[\"admin::is-creator\"]', 3, '2021-07-26 11:05:38', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"ip\",\"rate_limit\"]}'),
(53, 'plugins::content-manager.explorer.update', 'plugins::billing.payment', '[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]', '[\"admin::is-creator\"]', 3, '2021-07-26 11:05:38', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]}'),
(55, 'plugins::content-manager.explorer.update', 'plugins::billing.records', '[]', '[\"admin::is-creator\"]', 3, '2021-07-26 11:05:38', '2021-10-14 02:50:13', '{\"fields\":[\"billerType\"]}'),
(56, 'plugins::content-manager.explorer.update', 'plugins::ip-whitelist.ip-whitelist', '[\"user\",\"ip\",\"rate_limit\"]', '[\"admin::is-creator\"]', 3, '2021-07-26 11:05:39', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"ip\",\"rate_limit\"]}'),
(60, 'plugins::content-manager.explorer.delete', 'plugins::billing.payment', NULL, '[\"admin::is-creator\"]', 3, '2021-07-26 11:05:39', '2021-09-18 09:06:54', '{\"fields\":null}'),
(62, 'plugins::content-manager.explorer.delete', 'plugins::billing.records', NULL, '[\"admin::is-creator\"]', 3, '2021-07-26 11:05:39', '2021-09-18 09:06:54', '{\"fields\":null}'),
(63, 'plugins::content-manager.explorer.delete', 'plugins::ip-whitelist.ip-whitelist', NULL, '[\"admin::is-creator\"]', 3, '2021-07-26 11:05:39', '2021-09-18 09:06:54', '{\"fields\":null}'),
(64, 'plugins::upload.read', NULL, NULL, '[\"admin::is-creator\"]', 3, '2021-07-26 11:05:39', '2021-09-18 09:06:54', '{\"fields\":null}'),
(65, 'plugins::upload.assets.create', NULL, NULL, '[]', 3, '2021-07-26 11:05:39', '2021-09-18 09:06:54', '{\"fields\":null}'),
(66, 'plugins::upload.assets.update', NULL, NULL, '[\"admin::is-creator\"]', 3, '2021-07-26 11:05:39', '2021-09-18 09:06:54', '{\"fields\":null}'),
(67, 'plugins::upload.assets.download', NULL, NULL, '[]', 3, '2021-07-26 11:05:39', '2021-09-18 09:06:54', '{\"fields\":null}'),
(68, 'plugins::upload.assets.copy-link', NULL, NULL, '[]', 3, '2021-07-26 11:05:39', '2021-09-18 09:06:54', '{\"fields\":null}'),
(73, 'plugins::content-manager.explorer.create', 'plugins::billing.payment', '[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]', '[]', 1, '2021-07-26 11:05:39', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]}'),
(76, 'plugins::content-manager.explorer.create', 'plugins::ip-whitelist.ip-whitelist', '[\"user\",\"ip\",\"rate_limit\"]', '[]', 1, '2021-07-26 11:05:39', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"ip\",\"rate_limit\"]}'),
(81, 'plugins::content-manager.explorer.read', 'plugins::billing.payment', '[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]', '[]', 1, '2021-07-26 11:05:39', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]}'),
(84, 'plugins::content-manager.explorer.read', 'plugins::ip-whitelist.ip-whitelist', '[\"user\",\"ip\",\"rate_limit\"]', '[]', 1, '2021-07-26 11:05:39', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"ip\",\"rate_limit\"]}'),
(89, 'plugins::content-manager.explorer.update', 'plugins::billing.payment', '[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]', '[]', 1, '2021-07-26 11:05:40', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"balance\",\"total_amount\",\"paid\",\"type\",\"details\"]}'),
(92, 'plugins::content-manager.explorer.update', 'plugins::ip-whitelist.ip-whitelist', '[\"user\",\"ip\",\"rate_limit\"]', '[]', 1, '2021-07-26 11:05:40', '2021-09-18 09:06:54', '{\"fields\":[\"user\",\"ip\",\"rate_limit\"]}'),
(283, 'plugins::content-manager.explorer.create', 'application::demo.demo', '[\"client_id\",\"shortcode\",\"msisdn\",\"key_word\",\"transid\",\"operator\",\"serviceid\"]', '[]', 1, '2021-08-31 04:16:49', '2021-09-18 09:06:54', '{\"fields\":[\"client_id\",\"shortcode\",\"msisdn\",\"key_word\",\"transid\",\"operator\",\"serviceid\"]}'),
(284, 'plugins::content-manager.explorer.read', 'application::demo.demo', '[\"client_id\",\"shortcode\",\"msisdn\",\"key_word\",\"transid\",\"operator\",\"serviceid\"]', '[]', 1, '2021-08-31 04:16:49', '2021-09-18 09:06:54', '{\"fields\":[\"client_id\",\"shortcode\",\"msisdn\",\"key_word\",\"transid\",\"operator\",\"serviceid\"]}'),
(285, 'plugins::content-manager.explorer.update', 'application::demo.demo', '[\"client_id\",\"shortcode\",\"msisdn\",\"key_word\",\"transid\",\"operator\",\"serviceid\"]', '[]', 1, '2021-08-31 04:16:49', '2021-09-18 09:06:54', '{\"fields\":[\"client_id\",\"shortcode\",\"msisdn\",\"key_word\",\"transid\",\"operator\",\"serviceid\"]}'),
(306, 'plugins::content-manager.explorer.create', 'application::notification.notification', '[\"vendor\",\"api\",\"method\",\"status\",\"tx_id\"]', '[]', 1, '2021-08-31 07:59:24', '2021-09-18 09:06:54', '{\"fields\":[\"vendor\",\"api\",\"method\",\"status\",\"tx_id\"]}'),
(307, 'plugins::content-manager.explorer.read', 'application::notification.notification', '[\"vendor\",\"api\",\"method\",\"status\",\"tx_id\"]', '[]', 1, '2021-08-31 07:59:24', '2021-09-18 09:06:54', '{\"fields\":[\"vendor\",\"api\",\"method\",\"status\",\"tx_id\"]}'),
(308, 'plugins::content-manager.explorer.update', 'application::notification.notification', '[\"vendor\",\"api\",\"method\",\"status\",\"tx_id\"]', '[]', 1, '2021-08-31 07:59:24', '2021-09-18 09:06:54', '{\"fields\":[\"vendor\",\"api\",\"method\",\"status\",\"tx_id\"]}'),
(386, 'plugins::content-manager.explorer.create', 'application::partner.partner', '[\"name\",\"email\",\"shortCode\",\"password\",\"services\"]', '[]', 1, '2021-09-09 13:22:08', '2021-09-18 09:06:54', '{\"fields\":[\"name\",\"email\",\"shortCode\",\"password\",\"services\"]}'),
(387, 'plugins::content-manager.explorer.create', 'application::service.service', '[\"operator\",\"keyWord\",\"vendor\",\"rate\",\"shortCode\",\"serviceTier\",\"chargeType\",\"serviceId\",\"timeLine\",\"partner\",\"serviceName\"]', '[]', 1, '2021-09-09 13:22:08', '2021-09-18 09:06:54', '{\"fields\":[\"operator\",\"keyWord\",\"vendor\",\"rate\",\"shortCode\",\"serviceTier\",\"chargeType\",\"serviceId\",\"timeLine\",\"partner\",\"serviceName\"]}'),
(389, 'plugins::content-manager.explorer.read', 'application::partner.partner', '[\"name\",\"email\",\"shortCode\",\"password\",\"services\"]', '[]', 1, '2021-09-09 13:22:08', '2021-09-18 09:06:54', '{\"fields\":[\"name\",\"email\",\"shortCode\",\"password\",\"services\"]}'),
(390, 'plugins::content-manager.explorer.read', 'application::service.service', '[\"operator\",\"keyWord\",\"vendor\",\"rate\",\"shortCode\",\"serviceTier\",\"chargeType\",\"serviceId\",\"timeLine\",\"partner\",\"serviceName\"]', '[]', 1, '2021-09-09 13:22:08', '2021-09-18 09:06:54', '{\"fields\":[\"operator\",\"keyWord\",\"vendor\",\"rate\",\"shortCode\",\"serviceTier\",\"chargeType\",\"serviceId\",\"timeLine\",\"partner\",\"serviceName\"]}'),
(392, 'plugins::content-manager.explorer.update', 'application::partner.partner', '[\"name\",\"email\",\"shortCode\",\"password\",\"services\"]', '[]', 1, '2021-09-09 13:22:08', '2021-09-18 09:06:54', '{\"fields\":[\"name\",\"email\",\"shortCode\",\"password\",\"services\"]}'),
(393, 'plugins::content-manager.explorer.update', 'application::service.service', '[\"operator\",\"keyWord\",\"vendor\",\"rate\",\"shortCode\",\"serviceTier\",\"chargeType\",\"serviceId\",\"timeLine\",\"partner\",\"serviceName\"]', '[]', 1, '2021-09-09 13:22:08', '2021-09-18 09:06:54', '{\"fields\":[\"operator\",\"keyWord\",\"vendor\",\"rate\",\"shortCode\",\"serviceTier\",\"chargeType\",\"serviceId\",\"timeLine\",\"partner\",\"serviceName\"]}'),
(395, 'plugins::content-manager.explorer.create', 'application::hit-report.hit-report', '[\"vendor\",\"service\",\"totalHit\",\"vendorTotal\"]', '[]', 1, '2021-09-12 06:52:48', '2021-09-18 09:06:54', '{\"fields\":[\"vendor\",\"service\",\"totalHit\",\"vendorTotal\"]}'),
(396, 'plugins::content-manager.explorer.read', 'application::hit-report.hit-report', '[\"vendor\",\"service\",\"totalHit\",\"vendorTotal\"]', '[]', 1, '2021-09-12 06:52:48', '2021-09-18 09:06:54', '{\"fields\":[\"vendor\",\"service\",\"totalHit\",\"vendorTotal\"]}'),
(397, 'plugins::content-manager.explorer.update', 'application::hit-report.hit-report', '[\"vendor\",\"service\",\"totalHit\",\"vendorTotal\"]', '[]', 1, '2021-09-12 06:52:48', '2021-09-18 09:06:54', '{\"fields\":[\"vendor\",\"service\",\"totalHit\",\"vendorTotal\"]}'),
(412, 'plugins::content-type-builder.read', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(413, 'plugins::email.settings.read', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(414, 'plugins::upload.read', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(415, 'plugins::upload.assets.create', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(416, 'plugins::upload.assets.update', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(417, 'plugins::upload.assets.download', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(418, 'plugins::upload.assets.copy-link', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(419, 'plugins::upload.settings.read', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(420, 'plugins::content-manager.single-types.configure-view', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(421, 'plugins::content-manager.collection-types.configure-view', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(422, 'plugins::content-manager.components.configure-layout', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(423, 'plugins::users-permissions.roles.create', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(424, 'plugins::users-permissions.roles.read', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(425, 'plugins::users-permissions.roles.update', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(426, 'plugins::users-permissions.roles.delete', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(427, 'plugins::users-permissions.providers.read', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(428, 'plugins::users-permissions.providers.update', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(429, 'plugins::users-permissions.email-templates.read', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(430, 'plugins::users-permissions.email-templates.update', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(431, 'plugins::users-permissions.advanced-settings.read', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(432, 'plugins::users-permissions.advanced-settings.update', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(433, 'admin::marketplace.read', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(434, 'admin::marketplace.plugins.install', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(435, 'admin::marketplace.plugins.uninstall', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(436, 'admin::webhooks.create', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(437, 'admin::webhooks.read', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(438, 'admin::webhooks.update', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(439, 'admin::webhooks.delete', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(440, 'admin::users.create', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(441, 'admin::users.read', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(442, 'admin::users.update', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(443, 'admin::users.delete', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(444, 'admin::roles.create', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(445, 'admin::roles.read', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(446, 'admin::roles.update', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(447, 'admin::roles.delete', NULL, NULL, '[]', 1, '2021-09-18 09:06:58', '2021-09-18 09:06:58', '{}'),
(1213, 'plugins::content-manager.explorer.delete', 'application::demo.demo', NULL, '[]', NULL, '2021-09-18 10:03:51', '2021-09-18 10:03:58', '{}'),
(1214, 'plugins::content-manager.explorer.delete', 'application::hit-report.hit-report', NULL, '[]', NULL, '2021-09-18 10:03:51', '2021-09-18 10:03:58', '{}'),
(1215, 'plugins::content-manager.explorer.delete', 'application::notification.notification', NULL, '[]', NULL, '2021-09-18 10:03:51', '2021-09-18 10:03:58', '{}'),
(1216, 'plugins::content-manager.explorer.delete', 'application::partner.partner', NULL, '[]', NULL, '2021-09-18 10:03:51', '2021-09-18 10:03:58', '{}'),
(1217, 'plugins::content-manager.explorer.delete', 'application::service.service', NULL, '[]', NULL, '2021-09-18 10:03:51', '2021-09-18 10:03:58', '{}'),
(1218, 'plugins::content-manager.explorer.delete', 'plugins::users-permissions.user', NULL, '[]', NULL, '2021-09-18 10:03:51', '2021-09-18 10:03:58', '{}'),
(1219, 'plugins::content-manager.explorer.delete', 'plugins::billing.payment', NULL, '[]', NULL, '2021-09-18 10:03:51', '2021-09-18 10:03:58', '{}'),
(1220, 'plugins::content-manager.explorer.delete', 'plugins::billing.records', NULL, '[]', NULL, '2021-09-18 10:03:51', '2021-09-18 10:03:58', '{}'),
(1221, 'plugins::content-manager.explorer.delete', 'plugins::ip-whitelist.ip-whitelist', NULL, '[]', NULL, '2021-09-18 10:03:51', '2021-09-18 10:03:58', '{}'),
(1222, 'plugins::content-manager.explorer.publish', 'application::hit-report.hit-report', NULL, '[]', NULL, '2021-09-18 10:03:51', '2021-09-18 10:03:58', '{}'),
(1223, 'plugins::content-manager.explorer.publish', 'application::notification.notification', NULL, '[]', NULL, '2021-09-18 10:03:51', '2021-09-18 10:03:58', '{}'),
(1334, 'plugins::content-manager.explorer.delete', 'application::hit-report.hit-report', NULL, '[]', NULL, '2021-09-18 10:18:45', '2021-09-18 10:45:13', '{}'),
(1335, 'plugins::content-manager.explorer.delete', 'application::notification.notification', NULL, '[]', NULL, '2021-09-18 10:18:45', '2021-09-18 10:45:13', '{}'),
(1336, 'plugins::content-manager.explorer.delete', 'application::partner.partner', NULL, '[]', NULL, '2021-09-18 10:18:45', '2021-09-18 10:45:13', '{}'),
(1337, 'plugins::content-manager.explorer.delete', 'application::service.service', NULL, '[]', NULL, '2021-09-18 10:18:45', '2021-09-18 10:45:13', '{}'),
(1338, 'plugins::content-manager.explorer.delete', 'plugins::users-permissions.user', NULL, '[]', NULL, '2021-09-18 10:18:45', '2021-09-18 10:45:13', '{}'),
(1339, 'plugins::content-manager.explorer.delete', 'plugins::billing.payment', NULL, '[]', NULL, '2021-09-18 10:18:45', '2021-09-18 10:45:13', '{}'),
(1340, 'plugins::content-manager.explorer.delete', 'plugins::billing.records', NULL, '[]', NULL, '2021-09-18 10:18:45', '2021-09-18 10:45:13', '{}'),
(1341, 'plugins::content-manager.explorer.delete', 'plugins::ip-whitelist.ip-whitelist', NULL, '[]', NULL, '2021-09-18 10:18:45', '2021-09-18 10:45:13', '{}'),
(1342, 'plugins::content-manager.explorer.publish', 'application::hit-report.hit-report', NULL, '[]', NULL, '2021-09-18 10:18:46', '2021-09-18 10:45:13', '{}'),
(1343, 'plugins::content-manager.explorer.publish', 'application::notification.notification', NULL, '[]', NULL, '2021-09-18 10:18:46', '2021-09-18 10:45:13', '{}'),
(7497, 'plugins::content-manager.explorer.delete', 'application::demo.demo', NULL, '[]', NULL, '2021-10-04 11:13:02', '2021-10-04 11:58:22', '{}'),
(7498, 'plugins::content-manager.explorer.delete', 'application::hit-report.hit-report', NULL, '[]', NULL, '2021-10-04 11:13:02', '2021-10-04 11:58:22', '{}'),
(7499, 'plugins::content-manager.explorer.delete', 'application::notification.notification', NULL, '[]', NULL, '2021-10-04 11:13:02', '2021-10-04 11:58:22', '{}'),
(7500, 'plugins::content-manager.explorer.delete', 'application::partner.partner', NULL, '[]', NULL, '2021-10-04 11:13:02', '2021-10-04 11:58:22', '{}'),
(7501, 'plugins::content-manager.explorer.delete', 'application::service.service', NULL, '[]', NULL, '2021-10-04 11:13:02', '2021-10-04 11:58:22', '{}'),
(7502, 'plugins::content-manager.explorer.delete', 'plugins::users-permissions.user', NULL, '[]', NULL, '2021-10-04 11:13:02', '2021-10-04 11:58:22', '{}'),
(7503, 'plugins::content-manager.explorer.delete', 'plugins::billing.payment', NULL, '[]', NULL, '2021-10-04 11:13:02', '2021-10-04 11:58:22', '{}'),
(7504, 'plugins::content-manager.explorer.delete', 'plugins::billing.records', NULL, '[]', NULL, '2021-10-04 11:13:02', '2021-10-04 11:58:22', '{}'),
(7505, 'plugins::content-manager.explorer.delete', 'plugins::ip-whitelist.ip-whitelist', NULL, '[]', NULL, '2021-10-04 11:13:02', '2021-10-04 11:58:22', '{}'),
(7506, 'plugins::content-manager.explorer.publish', 'application::hit-report.hit-report', NULL, '[]', NULL, '2021-10-04 11:13:02', '2021-10-04 11:58:22', '{}'),
(7507, 'plugins::content-manager.explorer.publish', 'application::notification.notification', NULL, '[]', NULL, '2021-10-04 11:13:02', '2021-10-04 11:58:22', '{}'),
(15279, 'plugins::content-manager.explorer.delete', 'plugins::ip-whitelist.ip-whitelist', NULL, '[]', NULL, '2021-10-17 04:30:11', '2021-10-17 04:30:19', '{}'),
(15280, 'plugins::content-manager.explorer.publish', 'application::hit-report.hit-report', NULL, '[]', NULL, '2021-10-17 04:30:11', '2021-10-17 04:30:19', '{}'),
(15281, 'plugins::content-manager.explorer.publish', 'application::notification.notification', NULL, '[]', NULL, '2021-10-17 04:30:11', '2021-10-17 04:30:19', '{}'),
(16858, 'plugins::content-manager.explorer.create', 'application::subscription-status.subscription-status', NULL, '[]', 1, '2021-10-18 06:26:57', '2021-10-18 06:26:57', '{\"fields\":[\"msisdn\",\"serviceId\",\"status\",\"vendor\",\"created_at_gmt\"]}'),
(16859, 'plugins::content-manager.explorer.read', 'application::subscription-status.subscription-status', NULL, '[]', 1, '2021-10-18 06:26:57', '2021-10-18 06:26:57', '{\"fields\":[\"msisdn\",\"serviceId\",\"status\",\"vendor\",\"created_at_gmt\"]}'),
(16860, 'plugins::content-manager.explorer.update', 'application::subscription-status.subscription-status', NULL, '[]', 1, '2021-10-18 06:26:57', '2021-10-18 06:26:57', '{\"fields\":[\"msisdn\",\"serviceId\",\"status\",\"vendor\",\"created_at_gmt\"]}'),
(17124, 'plugins::content-manager.explorer.create', 'plugins::billing.records', NULL, '[]', 1, '2021-10-19 00:37:48', '2021-10-19 00:37:48', '{\"fields\":[\"partner_name\",\"vendor\",\"rate\",\"operator\",\"keyWord\",\"serviceId\",\"tx_id\",\"msisdn\",\"serviceTier\",\"billerType\",\"created_at_gmt\",\"cronDate\"]}'),
(17125, 'plugins::content-manager.explorer.read', 'plugins::billing.records', NULL, '[]', 1, '2021-10-19 00:37:48', '2021-10-19 00:37:48', '{\"fields\":[\"partner_name\",\"vendor\",\"rate\",\"operator\",\"keyWord\",\"serviceId\",\"tx_id\",\"msisdn\",\"serviceTier\",\"billerType\",\"created_at_gmt\",\"cronDate\"]}'),
(17126, 'plugins::content-manager.explorer.update', 'plugins::billing.records', NULL, '[]', 1, '2021-10-19 00:37:48', '2021-10-19 00:37:48', '{\"fields\":[\"partner_name\",\"vendor\",\"rate\",\"operator\",\"keyWord\",\"serviceId\",\"tx_id\",\"msisdn\",\"serviceTier\",\"billerType\",\"created_at_gmt\",\"cronDate\"]}'),
(17492, 'plugins::content-manager.explorer.create', 'plugins::users-permissions.user', NULL, '[]', 1, '2021-10-19 04:45:19', '2021-10-19 04:45:19', '{\"fields\":[\"username\",\"email\",\"provider\",\"resetPasswordToken\",\"confirmationToken\",\"confirmed\",\"blocked\",\"role\",\"password\",\"token\",\"uid\",\"amount\",\"paid\",\"due\",\"balance\",\"rate_limit\",\"ip_whiteList\",\"services\",\"requestMethod\",\"apiUrl\",\"authentication\",\"credentials\"]}'),
(17494, 'plugins::content-manager.explorer.read', 'plugins::users-permissions.user', NULL, '[]', 1, '2021-10-19 04:45:19', '2021-10-19 04:45:19', '{\"fields\":[\"username\",\"email\",\"provider\",\"resetPasswordToken\",\"confirmationToken\",\"confirmed\",\"blocked\",\"role\",\"password\",\"token\",\"uid\",\"amount\",\"paid\",\"due\",\"balance\",\"rate_limit\",\"ip_whiteList\",\"services\",\"requestMethod\",\"apiUrl\",\"authentication\",\"credentials\"]}'),
(17496, 'plugins::content-manager.explorer.update', 'plugins::users-permissions.user', NULL, '[]', 1, '2021-10-19 04:45:19', '2021-10-19 04:45:19', '{\"fields\":[\"username\",\"email\",\"provider\",\"resetPasswordToken\",\"confirmationToken\",\"confirmed\",\"blocked\",\"role\",\"password\",\"token\",\"uid\",\"amount\",\"paid\",\"due\",\"balance\",\"rate_limit\",\"ip_whiteList\",\"services\",\"requestMethod\",\"apiUrl\",\"authentication\",\"credentials\"]}'),
(17731, 'plugins::content-manager.explorer.delete', 'application::demo.demo', NULL, '[]', 1, '2021-10-27 01:00:15', '2021-10-27 01:00:15', '{}'),
(17732, 'plugins::content-manager.explorer.delete', 'application::notification.notification', NULL, '[]', 1, '2021-10-27 01:00:15', '2021-10-27 01:00:15', '{}'),
(17733, 'plugins::content-manager.explorer.delete', 'application::hit-report.hit-report', NULL, '[]', 1, '2021-10-27 01:00:15', '2021-10-27 01:00:15', '{}'),
(17734, 'plugins::content-manager.explorer.delete', 'application::partner.partner', NULL, '[]', 1, '2021-10-27 01:00:15', '2021-10-27 01:00:15', '{}'),
(17735, 'plugins::content-manager.explorer.delete', 'application::service.service', NULL, '[]', 1, '2021-10-27 01:00:15', '2021-10-27 01:00:15', '{}'),
(17736, 'plugins::content-manager.explorer.delete', 'application::subscription-status.subscription-status', NULL, '[]', 1, '2021-10-27 01:00:15', '2021-10-27 01:00:15', '{}'),
(17737, 'plugins::content-manager.explorer.delete', 'plugins::users-permissions.user', NULL, '[]', 1, '2021-10-27 01:00:15', '2021-10-27 01:00:15', '{}'),
(17738, 'plugins::content-manager.explorer.delete', 'plugins::billing.payment', NULL, '[]', 1, '2021-10-27 01:00:15', '2021-10-27 01:00:15', '{}'),
(17739, 'plugins::content-manager.explorer.delete', 'plugins::billing.records', NULL, '[]', 1, '2021-10-27 01:00:15', '2021-10-27 01:00:15', '{}'),
(17740, 'plugins::content-manager.explorer.delete', 'plugins::ip-whitelist.ip-whitelist', NULL, '[]', 1, '2021-10-27 01:00:15', '2021-10-27 01:00:15', '{}'),
(17741, 'plugins::content-manager.explorer.publish', 'application::hit-report.hit-report', NULL, '[]', 1, '2021-10-27 01:00:15', '2021-10-27 01:00:15', '{}'),
(17742, 'plugins::content-manager.explorer.publish', 'application::notification.notification', NULL, '[]', 1, '2021-10-27 01:00:15', '2021-10-27 01:00:15', '{}');

-- --------------------------------------------------------

--
-- Table structure for table `strapi_role`
--

CREATE TABLE `strapi_role` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `strapi_role`
--

INSERT INTO `strapi_role` (`id`, `name`, `code`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'strapi-super-admin', 'Super Admins can access and manage all features and settings.', '2021-07-26 11:05:37', '2021-07-26 11:05:37'),
(2, 'Editor', 'strapi-editor', 'Editors can manage and publish contents including those of other users.', '2021-07-26 11:05:37', '2021-07-26 11:05:37'),
(3, 'Author', 'strapi-author', 'Authors can manage the content they have created.', '2021-07-26 11:05:37', '2021-07-26 11:05:37');

-- --------------------------------------------------------

--
-- Table structure for table `strapi_users_roles`
--

CREATE TABLE `strapi_users_roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `strapi_users_roles`
--

INSERT INTO `strapi_users_roles` (`id`, `user_id`, `role_id`) VALUES
(1, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `strapi_webhooks`
--

CREATE TABLE `strapi_webhooks` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `url` longtext DEFAULT NULL,
  `headers` longtext DEFAULT NULL,
  `events` longtext DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `subscription_statuses`
--

CREATE TABLE `subscription_statuses` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `serviceId` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `vendor` varchar(255) DEFAULT NULL,
  `msisdn` varchar(255) NOT NULL,
  `created_at_gmt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `subscription_statuses`
--

INSERT INTO `subscription_statuses` (`id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `serviceId`, `status`, `vendor`, `msisdn`, `created_at_gmt`) VALUES
(23, NULL, NULL, '2021-10-16 12:13:19', '2021-10-13 06:58:17', 'PPU00056600004000000', 'A', 'Game1', '57683122975591093078', '2021-10-18 18:16:22'),
(25, NULL, NULL, '2021-10-13 07:08:54', '2021-10-13 07:08:54', 'PPU0005', 'A', 'Game1', '57683122975591093078', '2021-10-18 18:16:22'),
(26, NULL, NULL, '2021-10-12 06:18:48', '2021-10-13 07:30:33', 'PPU00056', 'A', 'Game1', '57683122975591093078', '2021-10-18 18:16:22'),
(27, NULL, NULL, '2021-10-11 08:17:04', '2021-10-13 08:17:04', 'PPU00056', 'A', 'Game1', '576831229755910930', '2021-10-18 18:16:22'),
(34, NULL, NULL, '2021-10-17 12:17:10', '2021-10-22 05:07:49', 'PPU00056', 'A', 'Game1', '57683', '2021-10-18 18:17:10');

-- --------------------------------------------------------

--
-- Table structure for table `upload_file`
--

CREATE TABLE `upload_file` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `alternativeText` varchar(255) DEFAULT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `width` int(11) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `formats` longtext DEFAULT NULL,
  `hash` varchar(255) NOT NULL,
  `ext` varchar(255) DEFAULT NULL,
  `mime` varchar(255) NOT NULL,
  `size` decimal(10,2) NOT NULL,
  `url` varchar(255) NOT NULL,
  `previewUrl` varchar(255) DEFAULT NULL,
  `provider` varchar(255) NOT NULL,
  `provider_metadata` longtext DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `upload_file_morph`
--

CREATE TABLE `upload_file_morph` (
  `id` int(10) UNSIGNED NOT NULL,
  `upload_file_id` int(11) DEFAULT NULL,
  `related_id` int(11) DEFAULT NULL,
  `related_type` longtext DEFAULT NULL,
  `field` longtext DEFAULT NULL,
  `order` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `users-permissions_permission`
--

CREATE TABLE `users-permissions_permission` (
  `id` int(10) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL,
  `controller` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `policy` varchar(255) DEFAULT NULL,
  `role` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users-permissions_permission`
--

INSERT INTO `users-permissions_permission` (`id`, `type`, `controller`, `action`, `enabled`, `policy`, `role`, `created_by`, `updated_by`) VALUES
(73, 'billing', 'billing', 'create_api_rates', 0, '', 1, NULL, NULL),
(74, 'billing', 'billing', 'create_api_rates', 0, '', 2, NULL, NULL),
(75, 'billing', 'billing', 'create_records', 0, '', 1, NULL, NULL),
(76, 'billing', 'billing', 'create_records', 0, '', 2, NULL, NULL),
(77, 'billing', 'billing', 'delete_api_rates', 0, '', 1, NULL, NULL),
(78, 'billing', 'billing', 'delete_api_rates', 0, '', 2, NULL, NULL),
(79, 'billing', 'billing', 'delete_records', 0, '', 1, NULL, NULL),
(80, 'billing', 'billing', 'delete_records', 0, '', 2, NULL, NULL),
(81, 'billing', 'billing', 'find_api_rates', 0, '', 1, NULL, NULL),
(82, 'billing', 'billing', 'find_api_rates', 0, '', 2, NULL, NULL),
(83, 'billing', 'billing', 'find_records', 0, '', 1, NULL, NULL),
(84, 'billing', 'billing', 'find_records', 0, '', 2, NULL, NULL),
(85, 'billing', 'billing', 'fineone_api_rates', 0, '', 1, NULL, NULL),
(86, 'billing', 'billing', 'fineone_api_rates', 0, '', 2, NULL, NULL),
(87, 'billing', 'billing', 'fineone_records', 0, '', 1, NULL, NULL),
(88, 'billing', 'billing', 'fineone_records', 0, '', 2, NULL, NULL),
(89, 'billing', 'billing', 'update_api_rates', 0, '', 1, NULL, NULL),
(90, 'billing', 'billing', 'update_api_rates', 0, '', 2, NULL, NULL),
(91, 'billing', 'billing', 'update_records', 0, '', 1, NULL, NULL),
(92, 'billing', 'billing', 'update_records', 0, '', 2, NULL, NULL),
(93, 'content-manager', 'collection-types', 'bulkdelete', 0, '', 1, NULL, NULL),
(94, 'content-manager', 'collection-types', 'bulkdelete', 0, '', 2, NULL, NULL),
(95, 'content-manager', 'collection-types', 'create', 0, '', 1, NULL, NULL),
(96, 'content-manager', 'collection-types', 'create', 0, '', 2, NULL, NULL),
(97, 'content-manager', 'collection-types', 'delete', 0, '', 1, NULL, NULL),
(98, 'content-manager', 'collection-types', 'delete', 0, '', 2, NULL, NULL),
(99, 'content-manager', 'collection-types', 'find', 0, '', 1, NULL, NULL),
(100, 'content-manager', 'collection-types', 'find', 0, '', 2, NULL, NULL),
(101, 'content-manager', 'collection-types', 'findone', 0, '', 1, NULL, NULL),
(102, 'content-manager', 'collection-types', 'findone', 0, '', 2, NULL, NULL),
(103, 'content-manager', 'collection-types', 'previewmanyrelations', 0, '', 1, NULL, NULL),
(104, 'content-manager', 'collection-types', 'previewmanyrelations', 0, '', 2, NULL, NULL),
(105, 'content-manager', 'collection-types', 'publish', 0, '', 1, NULL, NULL),
(106, 'content-manager', 'collection-types', 'publish', 0, '', 2, NULL, NULL),
(107, 'content-manager', 'collection-types', 'unpublish', 0, '', 1, NULL, NULL),
(108, 'content-manager', 'collection-types', 'unpublish', 0, '', 2, NULL, NULL),
(109, 'content-manager', 'collection-types', 'update', 0, '', 1, NULL, NULL),
(110, 'content-manager', 'collection-types', 'update', 0, '', 2, NULL, NULL),
(111, 'content-manager', 'components', 'findcomponentconfiguration', 0, '', 1, NULL, NULL),
(112, 'content-manager', 'components', 'findcomponentconfiguration', 0, '', 2, NULL, NULL),
(113, 'content-manager', 'components', 'findcomponents', 0, '', 1, NULL, NULL),
(114, 'content-manager', 'components', 'findcomponents', 0, '', 2, NULL, NULL),
(115, 'content-manager', 'components', 'updatecomponentconfiguration', 0, '', 1, NULL, NULL),
(116, 'content-manager', 'components', 'updatecomponentconfiguration', 0, '', 2, NULL, NULL),
(117, 'content-manager', 'content-types', 'findcontenttypeconfiguration', 0, '', 1, NULL, NULL),
(118, 'content-manager', 'content-types', 'findcontenttypeconfiguration', 0, '', 2, NULL, NULL),
(119, 'content-manager', 'content-types', 'findcontenttypes', 0, '', 1, NULL, NULL),
(120, 'content-manager', 'content-types', 'findcontenttypes', 0, '', 2, NULL, NULL),
(121, 'content-manager', 'content-types', 'updatecontenttypeconfiguration', 0, '', 1, NULL, NULL),
(122, 'content-manager', 'content-types', 'updatecontenttypeconfiguration', 0, '', 2, NULL, NULL),
(123, 'content-manager', 'relations', 'find', 0, '', 1, NULL, NULL),
(124, 'content-manager', 'relations', 'find', 0, '', 2, NULL, NULL),
(125, 'content-manager', 'single-types', 'createorupdate', 0, '', 1, NULL, NULL),
(126, 'content-manager', 'single-types', 'createorupdate', 0, '', 2, NULL, NULL),
(127, 'content-manager', 'single-types', 'delete', 0, '', 1, NULL, NULL),
(128, 'content-manager', 'single-types', 'delete', 0, '', 2, NULL, NULL),
(129, 'content-manager', 'single-types', 'find', 0, '', 1, NULL, NULL),
(130, 'content-manager', 'single-types', 'find', 0, '', 2, NULL, NULL),
(131, 'content-manager', 'single-types', 'publish', 0, '', 1, NULL, NULL),
(132, 'content-manager', 'single-types', 'publish', 0, '', 2, NULL, NULL),
(133, 'content-manager', 'single-types', 'unpublish', 0, '', 1, NULL, NULL),
(134, 'content-manager', 'single-types', 'unpublish', 0, '', 2, NULL, NULL),
(135, 'content-manager', 'uid', 'checkuidavailability', 0, '', 1, NULL, NULL),
(136, 'content-manager', 'uid', 'checkuidavailability', 0, '', 2, NULL, NULL),
(137, 'content-manager', 'uid', 'generateuid', 0, '', 1, NULL, NULL),
(138, 'content-manager', 'uid', 'generateuid', 0, '', 2, NULL, NULL),
(139, 'content-type-builder', 'builder', 'getreservednames', 0, '', 1, NULL, NULL),
(140, 'content-type-builder', 'builder', 'getreservednames', 0, '', 2, NULL, NULL),
(141, 'content-type-builder', 'componentcategories', 'deletecategory', 0, '', 1, NULL, NULL),
(142, 'content-type-builder', 'componentcategories', 'deletecategory', 0, '', 2, NULL, NULL),
(143, 'content-type-builder', 'componentcategories', 'editcategory', 0, '', 1, NULL, NULL),
(144, 'content-type-builder', 'componentcategories', 'editcategory', 0, '', 2, NULL, NULL),
(145, 'content-type-builder', 'components', 'createcomponent', 0, '', 1, NULL, NULL),
(146, 'content-type-builder', 'components', 'createcomponent', 0, '', 2, NULL, NULL),
(147, 'content-type-builder', 'components', 'deletecomponent', 0, '', 1, NULL, NULL),
(148, 'content-type-builder', 'components', 'deletecomponent', 0, '', 2, NULL, NULL),
(149, 'content-type-builder', 'components', 'getcomponent', 0, '', 1, NULL, NULL),
(150, 'content-type-builder', 'components', 'getcomponent', 0, '', 2, NULL, NULL),
(151, 'content-type-builder', 'components', 'getcomponents', 0, '', 1, NULL, NULL),
(152, 'content-type-builder', 'components', 'getcomponents', 0, '', 2, NULL, NULL),
(153, 'content-type-builder', 'components', 'updatecomponent', 0, '', 1, NULL, NULL),
(154, 'content-type-builder', 'components', 'updatecomponent', 0, '', 2, NULL, NULL),
(155, 'content-type-builder', 'connections', 'getconnections', 0, '', 1, NULL, NULL),
(156, 'content-type-builder', 'connections', 'getconnections', 0, '', 2, NULL, NULL),
(157, 'content-type-builder', 'contenttypes', 'createcontenttype', 0, '', 1, NULL, NULL),
(158, 'content-type-builder', 'contenttypes', 'createcontenttype', 0, '', 2, NULL, NULL),
(159, 'content-type-builder', 'contenttypes', 'deletecontenttype', 0, '', 1, NULL, NULL),
(160, 'content-type-builder', 'contenttypes', 'deletecontenttype', 0, '', 2, NULL, NULL),
(161, 'content-type-builder', 'contenttypes', 'getcontenttype', 0, '', 1, NULL, NULL),
(162, 'content-type-builder', 'contenttypes', 'getcontenttype', 0, '', 2, NULL, NULL),
(163, 'content-type-builder', 'contenttypes', 'getcontenttypes', 0, '', 1, NULL, NULL),
(164, 'content-type-builder', 'contenttypes', 'getcontenttypes', 0, '', 2, NULL, NULL),
(165, 'content-type-builder', 'contenttypes', 'updatecontenttype', 0, '', 1, NULL, NULL),
(166, 'content-type-builder', 'contenttypes', 'updatecontenttype', 0, '', 2, NULL, NULL),
(167, 'email', 'email', 'send', 0, '', 1, NULL, NULL),
(168, 'email', 'email', 'send', 0, '', 2, NULL, NULL),
(169, 'ip-whitelist', 'ip-whitelist', 'create', 0, '', 1, NULL, NULL),
(170, 'ip-whitelist', 'ip-whitelist', 'create', 0, '', 2, NULL, NULL),
(171, 'ip-whitelist', 'ip-whitelist', 'delete', 0, '', 1, NULL, NULL),
(172, 'ip-whitelist', 'ip-whitelist', 'delete', 0, '', 2, NULL, NULL),
(173, 'ip-whitelist', 'ip-whitelist', 'find', 0, '', 1, NULL, NULL),
(174, 'ip-whitelist', 'ip-whitelist', 'find', 0, '', 2, NULL, NULL),
(175, 'ip-whitelist', 'ip-whitelist', 'fineone', 0, '', 1, NULL, NULL),
(176, 'ip-whitelist', 'ip-whitelist', 'fineone', 0, '', 2, NULL, NULL),
(177, 'ip-whitelist', 'ip-whitelist', 'update', 0, '', 1, NULL, NULL),
(178, 'ip-whitelist', 'ip-whitelist', 'update', 0, '', 2, NULL, NULL),
(179, 'upload', 'upload', 'count', 0, '', 1, NULL, NULL),
(180, 'upload', 'upload', 'count', 0, '', 2, NULL, NULL),
(181, 'upload', 'upload', 'destroy', 0, '', 1, NULL, NULL),
(182, 'upload', 'upload', 'destroy', 0, '', 2, NULL, NULL),
(183, 'upload', 'upload', 'find', 0, '', 1, NULL, NULL),
(184, 'upload', 'upload', 'find', 0, '', 2, NULL, NULL),
(185, 'upload', 'upload', 'findone', 0, '', 1, NULL, NULL),
(186, 'upload', 'upload', 'findone', 0, '', 2, NULL, NULL),
(187, 'upload', 'upload', 'getsettings', 0, '', 1, NULL, NULL),
(188, 'upload', 'upload', 'getsettings', 0, '', 2, NULL, NULL),
(189, 'upload', 'upload', 'search', 0, '', 1, NULL, NULL),
(190, 'upload', 'upload', 'search', 0, '', 2, NULL, NULL),
(191, 'upload', 'upload', 'updatesettings', 0, '', 1, NULL, NULL),
(192, 'upload', 'upload', 'updatesettings', 0, '', 2, NULL, NULL),
(193, 'upload', 'upload', 'upload', 0, '', 1, NULL, NULL),
(194, 'upload', 'upload', 'upload', 0, '', 2, NULL, NULL),
(195, 'users-permissions', 'auth', 'callback', 0, '', 1, NULL, NULL),
(196, 'users-permissions', 'auth', 'callback', 1, '', 2, NULL, NULL),
(197, 'users-permissions', 'auth', 'connect', 1, '', 1, NULL, NULL),
(198, 'users-permissions', 'auth', 'connect', 1, '', 2, NULL, NULL),
(199, 'users-permissions', 'auth', 'emailconfirmation', 0, '', 1, NULL, NULL),
(200, 'users-permissions', 'auth', 'emailconfirmation', 1, '', 2, NULL, NULL),
(201, 'users-permissions', 'auth', 'forgotpassword', 0, '', 1, NULL, NULL),
(202, 'users-permissions', 'auth', 'forgotpassword', 1, '', 2, NULL, NULL),
(203, 'users-permissions', 'auth', 'register', 0, '', 1, NULL, NULL),
(204, 'users-permissions', 'auth', 'register', 1, '', 2, NULL, NULL),
(205, 'users-permissions', 'auth', 'resetpassword', 0, '', 1, NULL, NULL),
(206, 'users-permissions', 'auth', 'resetpassword', 1, '', 2, NULL, NULL),
(207, 'users-permissions', 'auth', 'sendemailconfirmation', 0, '', 1, NULL, NULL),
(208, 'users-permissions', 'auth', 'sendemailconfirmation', 0, '', 2, NULL, NULL),
(209, 'users-permissions', 'user', 'count', 0, '', 1, NULL, NULL),
(210, 'users-permissions', 'user', 'count', 0, '', 2, NULL, NULL),
(211, 'users-permissions', 'user', 'create', 0, '', 1, NULL, NULL),
(212, 'users-permissions', 'user', 'create', 0, '', 2, NULL, NULL),
(213, 'users-permissions', 'user', 'destroy', 0, '', 1, NULL, NULL),
(214, 'users-permissions', 'user', 'destroy', 0, '', 2, NULL, NULL),
(215, 'users-permissions', 'user', 'destroyall', 0, '', 1, NULL, NULL),
(216, 'users-permissions', 'user', 'destroyall', 0, '', 2, NULL, NULL),
(217, 'users-permissions', 'user', 'find', 0, '', 1, NULL, NULL),
(218, 'users-permissions', 'user', 'find', 0, '', 2, NULL, NULL),
(219, 'users-permissions', 'user', 'findone', 0, '', 1, NULL, NULL),
(220, 'users-permissions', 'user', 'findone', 0, '', 2, NULL, NULL),
(221, 'users-permissions', 'user', 'me', 1, '', 1, NULL, NULL),
(222, 'users-permissions', 'user', 'me', 1, '', 2, NULL, NULL),
(223, 'users-permissions', 'user', 'update', 0, '', 1, NULL, NULL),
(224, 'users-permissions', 'user', 'update', 0, '', 2, NULL, NULL),
(225, 'users-permissions', 'userspermissions', 'createrole', 0, '', 1, NULL, NULL),
(226, 'users-permissions', 'userspermissions', 'createrole', 0, '', 2, NULL, NULL),
(227, 'users-permissions', 'userspermissions', 'deleterole', 0, '', 1, NULL, NULL),
(228, 'users-permissions', 'userspermissions', 'deleterole', 0, '', 2, NULL, NULL),
(229, 'users-permissions', 'userspermissions', 'getadvancedsettings', 0, '', 1, NULL, NULL),
(230, 'users-permissions', 'userspermissions', 'getadvancedsettings', 0, '', 2, NULL, NULL),
(231, 'users-permissions', 'userspermissions', 'getemailtemplate', 0, '', 1, NULL, NULL),
(232, 'users-permissions', 'userspermissions', 'getemailtemplate', 0, '', 2, NULL, NULL),
(233, 'users-permissions', 'userspermissions', 'getpermissions', 0, '', 1, NULL, NULL),
(234, 'users-permissions', 'userspermissions', 'getpermissions', 0, '', 2, NULL, NULL),
(235, 'users-permissions', 'userspermissions', 'getpolicies', 0, '', 1, NULL, NULL),
(236, 'users-permissions', 'userspermissions', 'getpolicies', 0, '', 2, NULL, NULL),
(237, 'users-permissions', 'userspermissions', 'getproviders', 0, '', 1, NULL, NULL),
(238, 'users-permissions', 'userspermissions', 'getproviders', 0, '', 2, NULL, NULL),
(239, 'users-permissions', 'userspermissions', 'getrole', 0, '', 1, NULL, NULL),
(240, 'users-permissions', 'userspermissions', 'getrole', 0, '', 2, NULL, NULL),
(241, 'users-permissions', 'userspermissions', 'getroles', 0, '', 1, NULL, NULL),
(242, 'users-permissions', 'userspermissions', 'getroles', 0, '', 2, NULL, NULL),
(243, 'users-permissions', 'userspermissions', 'getroutes', 0, '', 1, NULL, NULL),
(244, 'users-permissions', 'userspermissions', 'getroutes', 0, '', 2, NULL, NULL),
(245, 'users-permissions', 'userspermissions', 'index', 0, '', 1, NULL, NULL),
(246, 'users-permissions', 'userspermissions', 'index', 0, '', 2, NULL, NULL),
(247, 'users-permissions', 'userspermissions', 'searchusers', 0, '', 1, NULL, NULL),
(248, 'users-permissions', 'userspermissions', 'searchusers', 0, '', 2, NULL, NULL),
(249, 'users-permissions', 'userspermissions', 'updateadvancedsettings', 0, '', 1, NULL, NULL),
(250, 'users-permissions', 'userspermissions', 'updateadvancedsettings', 0, '', 2, NULL, NULL),
(251, 'users-permissions', 'userspermissions', 'updateemailtemplate', 0, '', 1, NULL, NULL),
(252, 'users-permissions', 'userspermissions', 'updateemailtemplate', 0, '', 2, NULL, NULL),
(253, 'users-permissions', 'userspermissions', 'updateproviders', 0, '', 1, NULL, NULL),
(254, 'users-permissions', 'userspermissions', 'updateproviders', 0, '', 2, NULL, NULL),
(255, 'users-permissions', 'userspermissions', 'updaterole', 0, '', 1, NULL, NULL),
(256, 'users-permissions', 'userspermissions', 'updaterole', 0, '', 2, NULL, NULL),
(325, 'application', 'service', 'count', 0, '', 1, NULL, NULL),
(326, 'application', 'service', 'count', 0, '', 2, NULL, NULL),
(327, 'application', 'service', 'create', 0, '', 2, NULL, NULL),
(328, 'application', 'service', 'create', 0, '', 1, NULL, NULL),
(329, 'application', 'service', 'delete', 0, '', 1, NULL, NULL),
(330, 'application', 'service', 'delete', 0, '', 2, NULL, NULL),
(331, 'application', 'service', 'find', 1, '', 1, NULL, NULL),
(332, 'application', 'service', 'find', 0, '', 2, NULL, NULL),
(333, 'application', 'service', 'findone', 1, '', 1, NULL, NULL),
(334, 'application', 'service', 'findone', 0, '', 2, NULL, NULL),
(335, 'application', 'service', 'update', 0, '', 1, NULL, NULL),
(336, 'application', 'service', 'update', 0, '', 2, NULL, NULL),
(337, 'application', 'demo', 'count', 0, '', 1, NULL, NULL),
(338, 'application', 'demo', 'count', 0, '', 2, NULL, NULL),
(339, 'application', 'demo', 'create', 1, '', 1, NULL, NULL),
(340, 'application', 'demo', 'create', 0, '', 2, NULL, NULL),
(341, 'application', 'demo', 'delete', 0, '', 1, NULL, NULL),
(342, 'application', 'demo', 'delete', 0, '', 2, NULL, NULL),
(343, 'application', 'demo', 'find', 1, '', 1, NULL, NULL),
(344, 'application', 'demo', 'find', 0, '', 2, NULL, NULL),
(345, 'application', 'demo', 'findone', 1, '', 1, NULL, NULL),
(346, 'application', 'demo', 'findone', 0, '', 2, NULL, NULL),
(347, 'application', 'demo', 'update', 0, '', 1, NULL, NULL),
(348, 'application', 'demo', 'update', 0, '', 2, NULL, NULL),
(373, 'application', 'notification', 'count', 0, '', 1, NULL, NULL),
(374, 'application', 'notification', 'count', 0, '', 2, NULL, NULL),
(375, 'application', 'notification', 'create', 0, '', 1, NULL, NULL),
(376, 'application', 'notification', 'create', 0, '', 2, NULL, NULL),
(377, 'application', 'notification', 'delete', 0, '', 1, NULL, NULL),
(378, 'application', 'notification', 'delete', 0, '', 2, NULL, NULL),
(379, 'application', 'notification', 'find', 0, '', 1, NULL, NULL),
(380, 'application', 'notification', 'find', 0, '', 2, NULL, NULL),
(381, 'application', 'notification', 'findone', 0, '', 1, NULL, NULL),
(382, 'application', 'notification', 'findone', 0, '', 2, NULL, NULL),
(383, 'application', 'notification', 'update', 0, '', 1, NULL, NULL),
(384, 'application', 'notification', 'update', 0, '', 2, NULL, NULL),
(385, 'application', 'partner', 'count', 0, '', 1, NULL, NULL),
(386, 'application', 'partner', 'count', 0, '', 2, NULL, NULL),
(387, 'application', 'partner', 'create', 0, '', 1, NULL, NULL),
(388, 'application', 'partner', 'create', 0, '', 2, NULL, NULL),
(389, 'application', 'partner', 'delete', 0, '', 1, NULL, NULL),
(390, 'application', 'partner', 'delete', 0, '', 2, NULL, NULL),
(391, 'application', 'partner', 'find', 0, '', 1, NULL, NULL),
(392, 'application', 'partner', 'findone', 0, '', 1, NULL, NULL),
(393, 'application', 'partner', 'find', 0, '', 2, NULL, NULL),
(394, 'application', 'partner', 'findone', 0, '', 2, NULL, NULL),
(395, 'application', 'partner', 'update', 0, '', 1, NULL, NULL),
(396, 'application', 'partner', 'update', 0, '', 2, NULL, NULL),
(403, 'application', 'hit-report', 'count', 0, '', 1, NULL, NULL),
(404, 'application', 'hit-report', 'count', 0, '', 2, NULL, NULL),
(405, 'application', 'hit-report', 'create', 0, '', 1, NULL, NULL),
(406, 'application', 'hit-report', 'create', 0, '', 2, NULL, NULL),
(407, 'application', 'hit-report', 'delete', 0, '', 1, NULL, NULL),
(408, 'application', 'hit-report', 'delete', 0, '', 2, NULL, NULL),
(409, 'application', 'hit-report', 'find', 0, '', 1, NULL, NULL),
(410, 'application', 'hit-report', 'find', 0, '', 2, NULL, NULL),
(411, 'application', 'hit-report', 'findone', 0, '', 1, NULL, NULL),
(412, 'application', 'hit-report', 'findone', 0, '', 2, NULL, NULL),
(413, 'application', 'hit-report', 'update', 0, '', 1, NULL, NULL),
(414, 'application', 'hit-report', 'update', 0, '', 2, NULL, NULL),
(415, 'content-manager', 'content-types', 'findcontenttypessettings', 0, '', 1, NULL, NULL),
(416, 'content-manager', 'content-types', 'findcontenttypessettings', 0, '', 2, NULL, NULL),
(417, 'email', 'email', 'getsettings', 0, '', 1, NULL, NULL),
(418, 'email', 'email', 'getsettings', 0, '', 2, NULL, NULL),
(419, 'email', 'email', 'test', 0, '', 1, NULL, NULL),
(420, 'email', 'email', 'test', 0, '', 2, NULL, NULL),
(423, 'application', 'subscription-status', 'count', 0, '', 1, NULL, NULL),
(424, 'application', 'subscription-status', 'count', 0, '', 2, NULL, NULL),
(425, 'application', 'subscription-status', 'create', 0, '', 1, NULL, NULL),
(426, 'application', 'subscription-status', 'create', 0, '', 2, NULL, NULL),
(427, 'application', 'subscription-status', 'delete', 0, '', 1, NULL, NULL),
(428, 'application', 'subscription-status', 'delete', 0, '', 2, NULL, NULL),
(429, 'application', 'subscription-status', 'find', 0, '', 1, NULL, NULL),
(430, 'application', 'subscription-status', 'find', 0, '', 2, NULL, NULL),
(431, 'application', 'subscription-status', 'findone', 0, '', 1, NULL, NULL),
(432, 'application', 'subscription-status', 'findone', 0, '', 2, NULL, NULL),
(433, 'application', 'subscription-status', 'update', 0, '', 1, NULL, NULL),
(434, 'application', 'subscription-status', 'update', 0, '', 2, NULL, NULL),
(435, 'import-export-content', 'import-export-content', 'exportitems', 0, '', 1, NULL, NULL),
(436, 'import-export-content', 'import-export-content', 'exportitems', 0, '', 2, NULL, NULL),
(437, 'import-export-content', 'import-export-content', 'importitems', 0, '', 1, NULL, NULL),
(438, 'import-export-content', 'import-export-content', 'importitems', 0, '', 2, NULL, NULL),
(439, 'import-export-content', 'import-export-content', 'index', 0, '', 1, NULL, NULL),
(440, 'import-export-content', 'import-export-content', 'index', 0, '', 2, NULL, NULL),
(441, 'import-export-content', 'import-export-content', 'preanalyzecontent', 0, '', 1, NULL, NULL),
(442, 'import-export-content', 'import-export-content', 'preanalyzecontent', 0, '', 2, NULL, NULL),
(443, 'content-export-import', 'import-export-content', 'exportitems', 0, '', 1, NULL, NULL),
(444, 'content-export-import', 'import-export-content', 'exportitems', 0, '', 2, NULL, NULL),
(445, 'content-export-import', 'import-export-content', 'importitems', 0, '', 1, NULL, NULL),
(446, 'content-export-import', 'import-export-content', 'importitems', 0, '', 2, NULL, NULL),
(447, 'content-export-import', 'import-export-content', 'index', 0, '', 1, NULL, NULL),
(448, 'content-export-import', 'import-export-content', 'index', 0, '', 2, NULL, NULL),
(449, 'content-export-import', 'import-export-content', 'preanalyzecontent', 0, '', 1, NULL, NULL),
(450, 'content-export-import', 'import-export-content', 'preanalyzecontent', 0, '', 2, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `users-permissions_role`
--

CREATE TABLE `users-permissions_role` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users-permissions_role`
--

INSERT INTO `users-permissions_role` (`id`, `name`, `description`, `type`, `created_by`, `updated_by`) VALUES
(1, 'Authenticated', 'Default role given to authenticated user.', 'authenticated', NULL, NULL),
(2, 'Public', 'Default role given to unauthenticated user.', 'public', NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `core_store`
--
ALTER TABLE `core_store`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `demos`
--
ALTER TABLE `demos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `gp`
--
ALTER TABLE `gp`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hit_reports`
--
ALTER TABLE `hit_reports`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `homepages`
--
ALTER TABLE `homepages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ip-whitelist`
--
ALTER TABLE `ip-whitelist`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `partners_vendors__users_partners`
--
ALTER TABLE `partners_vendors__users_partners`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payment`
--
ALTER TABLE `payment`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `records`
--
ALTER TABLE `records`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `strapi_permission`
--
ALTER TABLE `strapi_permission`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `strapi_role`
--
ALTER TABLE `strapi_role`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `strapi_role_name_unique` (`name`),
  ADD UNIQUE KEY `strapi_role_code_unique` (`code`);

--
-- Indexes for table `strapi_users_roles`
--
ALTER TABLE `strapi_users_roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `strapi_webhooks`
--
ALTER TABLE `strapi_webhooks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subscription_statuses`
--
ALTER TABLE `subscription_statuses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `upload_file`
--
ALTER TABLE `upload_file`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `upload_file_morph`
--
ALTER TABLE `upload_file_morph`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users-permissions_permission`
--
ALTER TABLE `users-permissions_permission`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users-permissions_role`
--
ALTER TABLE `users-permissions_role`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users-permissions_role_type_unique` (`type`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `core_store`
--
ALTER TABLE `core_store`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;

--
-- AUTO_INCREMENT for table `demos`
--
ALTER TABLE `demos`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `gp`
--
ALTER TABLE `gp`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hit_reports`
--
ALTER TABLE `hit_reports`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `homepages`
--
ALTER TABLE `homepages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ip-whitelist`
--
ALTER TABLE `ip-whitelist`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `partners_vendors__users_partners`
--
ALTER TABLE `partners_vendors__users_partners`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `payment`
--
ALTER TABLE `payment`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `records`
--
ALTER TABLE `records`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26237;

--
-- AUTO_INCREMENT for table `strapi_permission`
--
ALTER TABLE `strapi_permission`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17743;

--
-- AUTO_INCREMENT for table `strapi_role`
--
ALTER TABLE `strapi_role`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `strapi_users_roles`
--
ALTER TABLE `strapi_users_roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `strapi_webhooks`
--
ALTER TABLE `strapi_webhooks`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscription_statuses`
--
ALTER TABLE `subscription_statuses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `upload_file`
--
ALTER TABLE `upload_file`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `upload_file_morph`
--
ALTER TABLE `upload_file_morph`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users-permissions_permission`
--
ALTER TABLE `users-permissions_permission`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=457;

--
-- AUTO_INCREMENT for table `users-permissions_role`
--
ALTER TABLE `users-permissions_role`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

