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

START TRANSACTION;



--
-- 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;
COMMIT;

