--
-- Host: localhost    Database: ceterisprime_auth
-- ------------------------------------------------------


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES
(1,'0001_01_01_000001_create_cache_table',1),
(2,'2025_02_24_142023_create_api_keys',1),
(3,'2025_03_22_050437_create_user_codes_table',2),
(4,'2026_02_23_000001_create_users_table',3),
(5,'2026_02_23_000002_create_permission_tables',3),
(6,'2026_03_23_100000_add_must_change_password_to_users',4);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--


--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--


--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--


--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--


--
-- Table structure for table `user_codes`
--

CREATE TABLE `user_codes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_codes`
--

INSERT INTO `user_codes` VALUES
(1,'5a8b803f-8d3e-43c2-a4af-1bb9ac58eb1f','0a5ca26b2aab6144543397fbe691f9','+2250123456789','66484','2025-03-22 05:50:27','2025-03-22 05:50:27'),
(2,'f43fbcbf-b9d9-4016-8832-4de21c9b5dfa','7c5e6767c12d1b293c53e5e9203f3b','+2250788650263','94747','2025-03-23 12:52:54','2025-04-03 15:09:57'),
(3,'146a625e-6ded-4698-b051-3e40e018399c','9fbe8289c24e3c39167b2f90eb4074','+2250555555555','95434','2025-03-25 13:50:01','2025-04-07 11:23:46'),
(4,'b8a422e8-241a-48bd-9ddb-d59a944cab5a','3347f197c49ad9b5ae1fc208483eac','+2250111111111','70779','2025-03-25 14:01:23','2025-03-31 01:44:03'),
(5,'35aecb7e-a89f-4ee1-a564-71b4ffa0c066','be62d7092ed9f9e223ed21dbd8d61c','+2250546284618','80812','2025-03-25 14:07:42','2025-05-16 18:14:22'),
(6,'bd0d7ac1-b488-48a3-9021-99c0c5c5bbf9','44e39b0f5270f28a004a21a47033ec','+2252222222222','89239','2025-03-25 17:19:06','2025-03-25 17:19:06'),
(7,'cb8db9c6-593f-4daa-aa48-4c5302403a06','3579d2eaaae3f68c66b7ba2a81e1aa','+2250665588888','93364','2025-03-25 18:56:47','2025-03-25 18:56:47'),
(8,'09cab743-17a2-4200-9be3-e3cb3b153296','fc8f287270085bbdbb23567c2142b1','+2250171667388','73792','2025-03-25 18:57:07','2025-04-01 10:27:45'),
(9,'dc4f8772-bb2d-4a3f-b5a5-2d591232c48c','b78378009c7343aed5129efcfeb67e','+2250599595559','67462','2025-03-25 20:01:30','2025-03-25 20:01:30'),
(10,'bba67d89-af47-4b16-88b9-27a2b8003c37','7f5e4b563e988122ff138ef8451a59','+2250595959595','95849','2025-03-25 20:04:30','2025-03-26 22:49:09'),
(11,'3e9ddbd9-035e-413c-a8be-5b6fde7c8573','37ee21c509f0e8e97f42d151b01644','+2250999999999','49463','2025-03-25 20:05:56','2025-03-25 20:05:56'),
(12,'5a5d7c76-17fa-489f-a83e-a0f271cfccc4','b5d2a3abdaf059ac3483d5f9a34c76','+2250888888888','72541','2025-03-25 20:10:50','2025-04-03 14:38:36'),
(13,'97846da6-2847-40c4-a653-76f2e5698db6','f153eae20b0c1505681cbf29ee6beb','+2250696996969','25102','2025-03-25 20:11:20','2025-03-25 20:11:20'),
(14,'94eeefb1-ee4b-4c51-9d3c-327cb97bf2c1','81fef302fd1df1fd9362af71b31fd3','+2250444444444','73857','2025-03-25 20:19:41','2025-03-25 20:19:41'),
(15,'d168f30f-f13c-4587-8074-a5579d202a7d','412bb3aa178899ccf4bd843665f6be','+2250333333333','35054','2025-03-25 20:20:09','2025-03-25 22:58:33'),
(16,'9ae24272-408d-467f-92f2-734618a24bce','408609809ded4b137eddd3c0067bb1','+2250666666666','71647','2025-03-25 20:24:38','2025-04-01 15:40:08'),
(17,'0e099fdf-4527-4b5f-9c10-e10a8339bbf6','a53c1844ee7f20b1240bf10eb24215','+2250366666666','28662','2025-03-25 20:24:56','2025-03-25 20:24:56'),
(18,'f830c8c4-b478-4624-b8d7-ed228d41e8d1','8c0a80c7982679966fa2ec0d6a5155','+2250366666667','69403','2025-03-25 20:25:23','2025-03-25 20:25:23'),
(19,'47d97886-7603-4d6a-bbbe-9c095ef29b61','d28888efa628662fabd10843ccc6bc','+2250666666665','91046','2025-03-25 20:26:28','2025-03-25 20:26:28'),
(20,'5a4aa6a2-8c53-4b90-ac17-954ba7579d00','bbed4f0745e030a7aa1d5ba19ff330','+2250222222222','46915','2025-03-25 22:57:38','2025-03-27 01:58:45'),
(21,'46a63d79-7265-4e75-a8e5-c896a7873d69','0f2cee9181444c26f8bf31c23f24ef','+2250121212121','76459','2025-03-25 23:00:05','2025-03-26 01:47:03'),
(22,'37d5e748-5ab9-4e7e-84a8-f3ec52739900','298cc01583c69c6e5757f865d87cf0','+2250757905270','39953','2025-03-25 23:45:57','2025-03-30 14:16:32'),
(23,'1c64e4bf-6b6e-4e80-b940-edf3fc9009ce','19ec17adeffd5112018f2f94b1d7e7','+2250131313131','18485','2025-03-26 00:02:42','2025-03-26 00:02:42'),
(24,'9de94f48-df16-4cf2-a717-ffb6566a8b77','8a3f15ea2b2797718d300c8b15de9d','+2250161616161','99852','2025-03-26 00:09:18','2025-03-26 00:09:18'),
(25,'ca029fa0-7a62-4a97-9c15-e256afec38a7','8b22b4e7103f73e8445f0723df6813','+2250171717171','19280','2025-03-26 00:10:43','2025-03-31 00:10:41'),
(26,'b884c990-ce44-463f-9056-094a921e6b27','06fe3f881394664a3fff6239a91688','+2250171717172','38188','2025-03-26 00:11:27','2025-03-26 00:11:27'),
(27,'40ed949b-f77c-4e21-8fdf-85b7b7e6fa7d','ae68565a0f19df3c75b7b0e21c1e84','+2250919191919','75162','2025-03-26 00:14:57','2025-03-26 00:14:57'),
(28,'780eace1-6bf7-4a11-8305-a36316d97696','327e3ecb7a8800a5e9f1eb5846d862','+2250759730540','84192','2025-03-26 00:43:23','2025-04-03 15:20:38'),
(29,'d894ea9d-8c42-4d5f-93d6-d4e830f056b3','6f108c9b881a05bce28826dfc173c1','+2250181918191','75635','2025-03-26 02:02:18','2025-03-26 02:02:18'),
(30,'b1a92a5d-9594-4747-af09-687809690279','aba8c922e89c9963e12e10822152ae','+2250787430901','40464','2025-03-26 08:12:26','2025-04-03 11:20:35'),
(31,'075e18eb-60c0-44aa-b780-fa0355d221af','f5f350d0cf8a7da0d62b41b36d29f5','+2250788650267','59037','2025-03-26 08:56:09','2025-03-26 08:56:09'),
(32,'339635a0-65eb-4e8a-991b-0997fb0cc6d8','487d25176b1a5353eab76ba5509f42','+2250696969696','94146','2025-03-26 20:13:44','2025-03-26 20:30:22'),
(33,'20c7ca96-e396-46bc-9d5e-09a99271db31','6ac3a672ff2041dd7738910c64993f','+2250499494949','24735','2025-03-26 20:18:15','2025-03-26 20:18:15'),
(34,'b1e3e4b2-f128-418b-af27-99b72b596d30','c036726ced6f7fdfcfd710a5377439','+2250949499494','93672','2025-03-26 20:20:29','2025-03-26 20:20:29'),
(35,'d5f9431a-6d1e-40ed-b715-dc5115e5836f','bcc369ee33839932850de843e159ea','+2250599595959','39078','2025-03-26 20:22:47','2025-03-26 20:29:19'),
(36,'5afbc74b-4758-4b39-bf03-b83ff3367621','7917bc18b464615bc79b105d35a569','+2250696969699','50283','2025-03-26 20:39:01','2025-03-26 20:39:01'),
(37,'68810744-34fa-4854-9e65-d51e07eb3d27','7fd453402f992b6dee1d423b119865','+2250696996966','54849','2025-03-26 20:55:54','2025-03-26 20:55:54'),
(38,'77ba6e86-24f3-4e64-abc1-daf21bd4a749','c438b4be89b34a3a45ca3d3213644f','+2250595959959','24076','2025-03-26 20:57:14','2025-03-26 20:57:14'),
(39,'18004717-11af-4ff5-86c3-4ec3972ea13e','2e75c2816a2caa893a8f1459c12495','+2250595959599','97683','2025-03-26 22:13:13','2025-03-26 22:13:13'),
(40,'08ab81e3-8fb4-49de-9523-6deffa4d67ba','881d211884f3b7c56993c3460bd3eb','+2250494494949','63087','2025-03-26 22:18:18','2025-03-26 22:18:18'),
(41,'073d48fd-1827-4c82-b573-9efea2242952','e4385d13c6ac3e5472669911df5e9a','+2250669696969','86331','2025-03-26 22:41:37','2025-03-26 22:41:37'),
(42,'e47e8223-654d-4af1-ba32-724df6dbdced','8a2496f2b30bc4d21201fbb927613b','+2250559959595','27565','2025-03-26 22:42:55','2025-03-26 22:42:55'),
(43,'45c27bcd-ebe2-4f8c-9637-170d00812c77','d418e1a39b5ac2343ec0552cd262d8','+2250595959559','12815','2025-03-26 22:43:51','2025-03-26 22:43:51'),
(44,'3a1a7fcf-b841-4e0e-9a50-5d0c3f5dd326','fdd1fd8cab37fbd0616c41abaab10a','+2250494994944','69965','2025-03-26 22:57:03','2025-03-26 22:57:03'),
(45,'be832239-6e36-4aab-bd30-0bfca52deb64','46bc98018f3047f6e648bf93af42e6','+2250494949449','37413','2025-03-26 23:36:47','2025-03-26 23:36:47'),
(46,'546fa382-6d10-47a7-9260-cfa20a2ee51f','a638d7f7b8ef27d38d3943c5b7f81c','+2250595955959','52235','2025-03-26 23:42:02','2025-03-26 23:42:02'),
(47,'e05a8b9e-8b2d-495b-bb40-3c172d4df26f','1f5bbc95637c2c465fe3c984e66ccb','+33745096718','57380','2025-03-30 16:16:32','2025-03-30 16:28:14'),
(48,'a5453137-ebef-4ac3-ae01-551da899ef44','1657e4e9fabdf244f5e92c27a77af5','+2250818181818','99160','2025-03-31 00:19:37','2025-03-31 00:28:18'),
(49,'4fd9f4cd-3186-460f-bdbd-daa3552fce58','05d677f119f3654a132b157f69517d','+2250555555559','15493','2025-03-31 00:47:41','2025-03-31 00:47:41'),
(50,'a3dd3ba4-e2fe-43d9-b809-8611aebc3271','7ef4b9646e8ea70041fc18d4b99202','+2250555555888','78838','2025-03-31 01:08:20','2025-03-31 01:08:20'),
(51,'68fb727c-a6e8-4aee-923b-958db8d9acfb','732cb5d30820cddd772e7a1b4af120','+2250700252525','85967','2025-04-01 11:58:03','2025-05-16 19:19:22'),
(52,'e0010cc2-4874-4563-98ef-695a50ba917f','81b98a4a14b1675b7f9f878bb34676','+2250555225555','78069','2025-04-01 15:36:18','2025-04-01 15:36:18'),
(53,'9f0b759d-5025-4148-a516-2edb3810f56b','fb2e297d358a705e3778018c15249b','+2250555555556','71582','2025-04-02 05:03:02','2025-04-02 05:03:02'),
(54,'5dbeed0d-bb26-471b-bf68-fc9539c66a0d','fd4e9e13a7807e924fc39f8019a5fe','+2252089022222','34650','2025-04-02 15:56:26','2025-04-02 15:56:26'),
(55,'12c6f23f-ab70-43ac-92ab-cad35d2adf3c','42362628bdcb76b3cdfe533382e33b','+2250787894240','99542','2025-04-03 12:42:31','2025-04-03 12:42:31'),
(56,'003a1015-55a6-4a1b-a72c-f61bcbb5d651','49b649e8aeb248a4acb56029bd98f6','+2250546284617','93430','2025-04-03 14:43:46','2025-04-03 14:43:46'),
(57,'ec763367-da26-4f86-9a82-725266930b59','459623b22967dae23cb4915166d2f1','+2250787430903','85462','2025-04-03 14:45:08','2025-04-03 14:45:08'),
(58,'5d2d3e3a-3cf8-4cfe-9f86-327677584b1e','c9d24197f6bd6cce1cd5c96b755a5c','+2250787430906','47079','2025-04-03 14:55:00','2025-04-03 14:55:00'),
(59,'cc4571c2-8af6-44eb-833a-110beea80337','d6bc08351ad4b398f3ff808cdf9271','+2250555555554','30877','2025-04-03 14:55:50','2025-04-03 14:55:50'),
(60,'d049dccb-1e35-4044-b8c9-cd7a790394dd','51e4e5408c4f9c23cac32d72883005','+2250768068636','55258','2025-04-03 14:56:46','2025-04-03 14:56:46'),
(61,'e06ba046-efa6-432e-9ee9-19c859cd91cc','7231f1f18b9c7d012b348950966a0c','+2250255555554','74029','2025-04-03 14:57:15','2025-04-03 14:57:15'),
(62,'45c8a0d7-7f7f-4be2-bd61-2e4ad3197916','71c7b944997a2b8f9a0fbcb4736535','+2250707765283','73171','2025-04-03 17:28:32','2025-04-03 17:28:32'),
(63,'57d1db5e-3719-4246-acc3-cf512949e4e0','9bd6ff5321591fd6e014c28c7c1649','+2250747710305','54459','2025-04-03 17:51:04','2025-04-03 17:51:04'),
(64,'c8375291-caeb-4367-88c5-57c254a00d9b','a66f4c8232a877b9192f83ecf7c144','+2250747949206','62138','2025-04-03 18:00:09','2025-04-03 18:00:09'),
(65,'e509faf2-1f6d-4153-8779-b978926afcda','6ac76f9ce00f9e2ffa80562ec7e43c','+2250747949209','44257','2025-04-03 18:01:27','2025-04-03 18:01:27'),
(66,'2faf90fe-94a7-4469-8a96-111398297c5e','5ddf1e0506a53ed4c0fc77e5d9af59','+2250500572626','71925','2025-04-07 10:22:02','2025-04-07 10:22:02'),
(67,'16e5e3ec-9b3b-4d64-804e-423f22ad1a77','6316428a2e0935745fc054bdd6192f','+2250999999988','60480','2025-04-07 11:03:46','2025-04-07 11:03:46'),
(68,'78dd8c4c-fb93-458f-9a47-8ef3f77a37b9','554476ed743f6ae0bc2f422a4eb23d','+2250888886666','44828','2025-04-07 11:16:37','2025-04-07 11:16:37'),
(69,'89daf402-f792-44a1-85a9-ef4f6038386e','638e52bc423207cfae32a9288f9971','+2250669999999','77000','2025-04-07 11:21:58','2025-04-07 11:21:58'),
(70,'10647469-3e9c-47f5-be86-73842bc364dd','13e231342bb9c47dcd946831526f35','+2250999999888','60771','2025-04-07 15:24:57','2025-04-07 15:24:57'),
(71,'7f572d3c-0abe-4028-b684-173615396c8a','fc6fe881e0e69f523cd571aa6dd392','+2250747711304','85698','2025-04-08 21:38:51','2025-04-08 21:38:51'),
(72,'87794759-19e7-45de-926f-66020a34e181','75f8f9974be0ffa5b6bb322681c440','+2250787430923','32128','2025-05-16 18:13:27','2025-05-16 18:13:27'),
(73,'504ed438-5170-4bd3-b3be-9bce2b6c36dd','81887c5ebdbdd7683ad7f9f20b323b','+2250787430921','23623','2025-05-16 18:13:56','2025-05-16 18:23:00'),
(74,'4574ae52-dbfa-4d26-958e-5c74131f229a','c07292873e9c74aec0cd6d704fd0eb','+2250787430925','96815','2025-05-16 18:18:12','2025-05-16 18:20:22'),
(75,'263fc9d0-6f50-4ea1-8b19-cb86a6b9cbc8','4c5f864a0d19c0ce30b5bedfbcba3d','+2250787430930','30322','2025-05-16 18:23:20','2025-05-16 18:23:20'),
(76,'8308438c-1563-4690-9072-a68b54a7ae0a','1aa42426976c0580100a56592ce9e4','+2250787430939','26178','2025-05-16 19:49:03','2025-05-16 19:49:03'),
(77,'683b7988-952b-4d81-9a75-683069cfd91e','88f6c7a02caf22ac8cdfaa0c55f711','+2250787430940','51740','2025-05-16 19:52:35','2025-05-16 19:52:35'),
(78,'43bfe982-41d3-4ce7-b3ba-47523349aed5','ff90fb3cb859871218f65412da38c7','+2250777777777','38859','2025-05-19 02:24:55','2025-05-19 02:24:55');


