-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:8889 -- Generation Time: Aug 05, 2024 at 08:41 PM -- Server version: 8.0.35 -- PHP Version: 8.2.20 SET FOREIGN_KEY_CHECKS=0; SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `com_ndcrm_api` -- -- -------------------------------------------------------- -- -- Table structure for table `te_api_endpoint_auth` -- CREATE TABLE `te_api_endpoint_auth` ( `aepu_id` int UNSIGNED NOT NULL, `aepu_role_id` tinyint UNSIGNED NOT NULL DEFAULT '0', `aepu_username` varchar(128) COLLATE utf8mb4_general_ci NOT NULL, `aepu_email` varchar(128) COLLATE utf8mb4_general_ci NOT NULL, `aepu_identify` text COLLATE utf8mb4_general_ci NOT NULL, `aepu_jwt_access_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `aepu_jwt_refresh_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `aepu_suspended` datetime DEFAULT NULL COMMENT 'null: no | date_time: yes last action at ', `aepu_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `aepu_updated` datetime DEFAULT NULL COMMENT 'null: no | date_time: yes last action at', `aepu_deleted` datetime DEFAULT NULL COMMENT 'null: no | date_time: yes last action at' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='api end point access authentication'; -- -- Dumping data for table `te_api_endpoint_auth` -- INSERT INTO `te_api_endpoint_auth` (`aepu_id`, `aepu_role_id`, `aepu_username`, `aepu_email`, `aepu_identify`, `aepu_jwt_access_token`, `aepu_jwt_refresh_token`, `aepu_suspended`, `aepu_created`, `aepu_updated`, `aepu_deleted`) VALUES (1, 1, 'admin', 'info@thatsend.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkWSswNTk2LzhFc2RreE5CSWFLSWpFdyR5UHFQWS9RTHdBam9ES2xubFJ4dlFSNVM1bjdyWTNXOERRdGhqaUtOOEgw', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiJNUT09IiwidXNlcm5hbWUiOiJhZG1pbiIsImVtYWlsIjoiaW5mb0B0aGF0c2VuZC5jb20iLCJyb2xlIjoxLCJ0eXBlIjoiYWNjZXNzX3Rva2VuIiwiaWF0IjoxNzIyODQ2ODQyLCJleHAiOjE3MjI5MzMyNDIsImF1ZCI6IkFwcGxpY2F0aW9uIiwiaXNzIjoiVEhBVFNFTkQifQ.4xOm-upGGIuUeIQTPAGTrIQRj2pbA45Ku9YDjNE1_S4', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiJNUT09IiwidXNlcm5hbWUiOiJhZG1pbiIsImVtYWlsIjoiaW5mb0B0aGF0c2VuZC5jb20iLCJyb2xlIjoxLCJ0eXBlIjoicmVmcmVzaF90b2tlbiIsImlhdCI6MTcyMjg0Njg0MiwiZXhwIjoxNzIzNDUxNjQyLCJhdWQiOiJBcHBsaWNhdGlvbiIsImlzcyI6IlRIQVRTRU5EIn0.jd3jwb-hikntbjfhxzSJJKxSSZolvkGmBKMzbQPCprQ', NULL, '2024-07-31 18:44:35', '2024-08-05 19:38:41', NULL), (2, 0, 'ios-app', 'info@enterprise.app', '123', '', '', NULL, '2024-07-31 18:44:35', '2024-08-05 19:38:41', NULL), (3, 0, 'android-app', 'info@enterprise.app', '123', '', '', NULL, '2024-07-31 18:44:48', '2024-08-05 19:38:41', NULL), (4, 0, 'web-app', 'info@enterprise.app', '123', '', '', NULL, '2024-07-31 18:44:56', '2024-08-05 19:38:41', NULL), (5, 0, 'desktop-app', 'info@enterprise.app', '123', '', '', NULL, '2024-07-31 18:45:05', '2024-08-05 19:38:41', NULL), (51, 0, '6abcd@AK56', 'tarza@ndomain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkWldWU2pDU3Z0ODg2K01Nbk9ncVFvUSRMTmhsMDhxM293b1RNZ2ZCTFk5M2xJM3Q3L1lVNkRHOHF2bkluTzZhM2dz', NULL, NULL, NULL, '2024-08-03 23:06:21', '2024-08-06 01:23:21', NULL), (54, 0, '9abcd@AK56', '9email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkTS91R2x3UWZpZFR2N3Nsazk0emNVZyR2M2xKVk4zYmkrOWNzTllMMnVBeldOcVhFQ0hycDd3ODFaM2Y4VnM0ZC9z', NULL, NULL, NULL, '2024-08-03 23:07:43', '2024-08-06 01:32:51', NULL), (55, 0, '7abcd@AK56', '7email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkUU1PTldMRmwvYkwwN3NJM2VPNHplZyRCT2hCNHRyenRVUnJPSE1OalZJZGdQK0NPblJuaUhxcHhiS3g2WXNVdXc4', NULL, NULL, NULL, '2024-08-03 23:07:43', '2024-08-06 01:32:51', NULL), (56, 0, '8abcd@AK56', '8email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkTCtXMTZyVVJJL3RsNHZWL2gxMnc5QSRyc2JUZFBwRFJiMHBlNVMrWUdaUkYvQ3E3Q3JrWElHd2hSQmcvYk83U0RZ', NULL, NULL, NULL, '2024-08-03 23:07:43', '2024-08-06 01:43:02', NULL), (57, 0, '10abcd@AK56', '10email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkejJDQUdlQWh4Q0xvNFFyTmJHOHp0USR2b1Z2QjIzenBSZElpcmJzQXFTNDhRblJacS9aZUdidC84VEg0RmxtajNr', NULL, NULL, NULL, '2024-08-03 23:08:24', '2024-08-06 01:43:44', NULL), (58, 0, '11abcd@AK56', '11email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkZEx1c29iTVZUQktMSjJLdGtrUys3ZyRkSjdkUVluWWRjbFU2dzlNQjZzanFIcEIxR1NZdmhEWTl1ZjVuTmRPbWM0', NULL, NULL, NULL, '2024-08-03 23:08:24', '2024-08-06 01:43:44', NULL), (59, 0, '12abcd@AK56', '12email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkUjR4K2RPUGRDMi9kWHJqejNvK2taUSRnZ0lnUHh0aWFPVEx1dm42cTdnVVlWOXo2ajZtRDFLTHVmUWtFZUFPRUJR', NULL, NULL, NULL, '2024-08-03 23:08:24', '2024-08-05 23:30:05', '2024-08-01 20:20:20'), (60, 0, '13abcd@AK56', '13email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkQUdvQkhpb3ZjQ1dsekZxeXVub2hVQSRQWksycVFNL0p5WnE2QkVTSkxoSjg5c1pjdHk0cURjRTFUSit3TFJ1eVhr', NULL, NULL, NULL, '2024-08-03 23:10:30', '2024-08-05 23:30:05', '2024-08-01 20:20:20'), (61, 0, '14abcd@AK56', '14email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkS1ViRVRuZWdqZlp3VlRzMnQ1dEN1QSRBemMzVHlYcVhQaTBlblZ4QUxYZXFtdjZRR0kyZkwzbjl5QnNnUHFJRGQ4', NULL, NULL, NULL, '2024-08-03 23:14:38', '2024-08-05 23:30:05', '2024-08-01 20:20:20'), (63, 0, '15abcd@AK56', '15email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkQjJMdmNRemU1UENjRzJheXZuNkdEUSRPbzZGaHE1TmZISFVYakRGQ1N6RVUyMlBheGpOamViRTNkZW96OTdKUVFV', NULL, NULL, NULL, '2024-08-03 23:16:56', '2024-08-05 23:30:05', '2024-08-01 20:20:20'), (65, 0, '17abcd@AK56', '17email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkd1pKd25EbE9vWkJvWlZ1UUt5djlBdyQ4ZnBOSXcwd0VnVXJTV2VVWFlvcmkrcjE3QmkrS25WOEtVWS9McTZKc29r', NULL, NULL, NULL, '2024-08-03 23:23:27', '2024-08-05 23:30:05', '2024-08-01 20:20:20'), (67, 0, '18a', '18email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkSzlLNGFmckM5ZnE1ODNsRVZCS2F3ZyRWdFNTUzd3TXVsM3lZdXdJeVhyQmtGbURZeWMreG5OR3gwVXV3M1pqNWtJ', NULL, NULL, NULL, '2024-08-03 23:28:24', '2024-08-05 23:30:05', NULL), (69, 0, '19a', '19email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkTWtwTk5YcXJYU2ZMMWZzN1VMdkVoUSRkdEN4TFB2K2ZVN0pETy9zWDZmSDlER2dhdzROZFlyZk1Zc3pYSnU3YjhJ', NULL, NULL, NULL, '2024-08-03 23:41:26', '2024-08-05 23:30:05', NULL), (71, 0, '20a', '20email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkdU9wVFhjWjF3a0FpTnRFMlNtOWpxZyR1TFJRUXA3QVdmQkdJdkxqZ1dFd3NXeFpIQU53S2hIRzMyY2dyd29ia1JV', NULL, NULL, NULL, '2024-08-03 23:43:29', '2024-08-05 23:30:05', NULL), (72, 0, '20207878', '20email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkR3lLQ2tnTGUrR3RKRmVFcS95ejZ4QSRsWGg3d3g1Zis2Z2xCNTAxZEFRL0dkK0U1RkxWaUJoajE5Y2NTTUJiOUJr', NULL, NULL, NULL, '2024-08-04 00:08:57', '2024-08-05 23:30:05', NULL), (74, 0, '21207878', '21email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkMVFVQjRkbWVBOW5hcGRpVHQ0d1VSdyRsSU1PbWlKNnh6MEg3cjgrZnEvVys5U0MyVTkzWWNCanVZWXJTNmhtc2Vr', NULL, NULL, NULL, '2024-08-04 00:14:57', '2024-08-05 23:30:05', NULL), (75, 0, '2n323ewe', '2new@signup.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkRXRReTVWZGdYZXVtbXpRRVRaejJCZyQrQjdHVUQ4MDI3eUl5aWIyc096ZExXVm9LYTYvVHpweDJRVFptVzFNQ0pz', NULL, NULL, NULL, '2024-08-04 02:11:51', '2024-08-05 19:38:41', NULL), (76, 0, '12n323ewe', '12new@signup.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkd1Buc2tzMzlGcWtiL0NjclNPeTZHdyQ0SU9HVjBGb1U5NzZCeTRaalgwaDA3NGtpSVIreER5UGFYZEpkZWN1ZnY4', NULL, NULL, NULL, '2024-08-04 02:12:04', '2024-08-05 19:38:41', NULL), (78, 0, '112n323ewe', '112new@signup.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkYUxpVFhSdjZhSGR4L3NIMXpDSUNudyRZNkhOUnAwQ1lweHUzZkFhcjlJRURZSTBjMldRc2swMlBqSmJ4dG5TSlJv', NULL, NULL, NULL, '2024-08-04 02:21:41', '2024-08-05 19:38:41', NULL), (83, 0, '121207878', '121email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkV1VFbFpDSXhobVhkYjIzV2c2cFdyZyR4U0gxWjQ4R21QcDEyRUhaNkFjNytKNzR5aXI2VStRdGZDTTk2cnlJQ2hB', NULL, NULL, NULL, '2024-08-04 04:39:44', '2024-08-05 23:30:05', NULL), (85, 0, '0121207878', '121email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkM1pCTEMzUTArMlh3Zmo1OW1GM3hjUSRydVJOQ2lJVDZTVnVJckJUQm53ekhNWjg2SDJoVzZGRmtKbzBQa1lDQnEw', NULL, NULL, NULL, '2024-08-04 04:41:31', '2024-08-05 23:30:05', '2024-08-05 03:12:25'), (86, 1, '1121207878', '1121email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkWm1jYmpxTHUvM3FsQXBtcCt3Nm90QSRUUGlwS0NFaFgzdWtETEZUNUF1SnY5ejFVMCs0dEdydVdRSG0xakQ2bGlV', NULL, NULL, NULL, '2024-08-04 04:41:31', '2024-08-05 23:30:05', '2024-08-05 03:12:25'), (87, 0, '20121207878', '2121email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkWng2QXFOOTh4ekZMTUxiaWExeWR2QSRhTzlGdTdueVd2MTNLdkpTU2YrNjFkZmRZeTRoMkJWM0s5Z3NWaXZxWkQ4', NULL, NULL, NULL, '2024-08-04 04:42:27', '2024-08-05 23:30:05', '2024-08-05 03:12:25'), (89, 1, '120121207878', '12121email@domain.com', 'JGFyZ29uMmlkJHY9MTkkbT00MDk2LHQ9MyxwPTEkcXNHTHNrTXhYSjB2RFpvVXhjZkpJUSRjTEx0ekRsZ0FJRGNxM2RCT2lTampoeHBuZE9kTWswSnBCRHlqZzUwNHNr', NULL, NULL, NULL, '2024-08-04 16:29:14', '2024-08-05 23:30:05', '2024-08-05 03:11:33'); -- -- Indexes for dumped tables -- -- -- Indexes for table `te_api_endpoint_auth` -- ALTER TABLE `te_api_endpoint_auth` ADD PRIMARY KEY (`aepu_id`), ADD UNIQUE KEY `aepu_username` (`aepu_username`), ADD KEY `aepu_email` (`aepu_email`), ADD KEY `aepu_suspended` (`aepu_suspended`), ADD KEY `aepu_created` (`aepu_created`), ADD KEY `aepu_updated` (`aepu_updated`), ADD KEY `aepu_deleted` (`aepu_deleted`), ADD KEY `aepu_role_id` (`aepu_role_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `te_api_endpoint_auth` -- ALTER TABLE `te_api_endpoint_auth` MODIFY `aepu_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92; SET FOREIGN_KEY_CHECKS=1; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;