-- phpMyAdmin SQL Dump -- version 5.1.0 -- https://www.phpmyadmin.net/ -- -- Host: localhost:8889 -- Generation Time: Sep 16, 2023 at 11:20 AM -- Server version: 5.7.32 -- PHP Version: 8.0.3 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: `thatsend_cloud_cam_license` -- -- -------------------------------------------------------- -- -- Table structure for table `refreshToken` -- CREATE TABLE `refreshToken` ( `id` int(11) NOT NULL, `userId` varchar(255) NOT NULL, `refreshToken` text NOT NULL, `issuedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `id` varchar(255) NOT NULL, `realm` varchar(255) NOT NULL, `username` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `emailVerified` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `verificationToken` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `realm`, `username`, `email`, `emailVerified`, `verificationToken`) VALUES ('1e667480-6816-4b60-acdb-8111cbef53c8', '/', 'careandtreatment', 'info@careandtreatment.com', 1, 'e2FG0OiTYxS'), ('3c87faf5-a58b-4f54-a731-60a8f9bf90e5', '/', 'thatsend', 'info@thatsend.com', 1, 'yR45G@r$OW9'), ('59884e2c-04fa-4815-8bd1-0f69f0e86759', '/', 'thatsenddev', 'info@thatsend.dev', 0, 'g20rYYoOIYxSd1'), ('a2d6cf01-7e9e-4a79-97a8-ff8de2c57619', '/', 'thatsendwork', 'info@thatsend.work', 0, 'w1uiIle4$TqAS'); -- -------------------------------------------------------- -- -- Table structure for table `userCredentials` -- CREATE TABLE `userCredentials` ( `id` varchar(255) NOT NULL, `password` text NOT NULL, `userId` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `userCredentials` -- INSERT INTO `userCredentials` (`id`, `password`, `userId`) VALUES ('254db369-5e8a-49d1-82d9-7712794ed495', '$2a$10$jrLQBqGvNG4yA63r6.57x.o54XblqYD..HSYa0exnBXB.rQT.Ta1K', '3c87faf5-a58b-4f54-a731-60a8f9bf90e5'), ('804df4db-6b57-4759-b991-f5bc34bc3c3a', '$2a$10$8.elENOrLP.DQVEEMYip5.nFsu23r/a7qFtrJ6FpPORIKYAYVfeoa', '59884e2c-04fa-4815-8bd1-0f69f0e86759'), ('c3c1f9ca-9d2b-49aa-8329-08c1e181ca14', '$2a$10$g84iZsuVMPO8Nfmr8v9KLO/F//2QLc0SVUjcinLAJArvnpzWuV0R.', '1e667480-6816-4b60-acdb-8111cbef53c8'), ('d528ec34-c380-4907-aa32-a6723ff24335', '$2a$10$9nQrgUb149.RR4YeTpqUde2Wz2ccf5sEKJeWvAn6ENBVI1syoIn2u', 'a2d6cf01-7e9e-4a79-97a8-ff8de2c57619'); -- -------------------------------------------------------- -- -- Table structure for table `userLicence` -- CREATE TABLE `userLicence` ( `id` int(10) UNSIGNED NOT NULL, `userId` varchar(255) NOT NULL COMMENT 'FK(user => u_id)', `startDateTime` datetime NOT NULL, `endDateTime` datetime NOT NULL, `type` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0=>free | 1=>premium', `payTransactionId` varchar(255) DEFAULT NULL COMMENT 'If premium user then online payment will be made and payment transaction id will be added here', `code` text COMMENT 'Licence json encrypted licence string' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `userLicence` -- INSERT INTO `userLicence` (`id`, `userId`, `startDateTime`, `endDateTime`, `type`, `payTransactionId`, `code`) VALUES (1, '3c87faf5-a58b-4f54-a731-60a8f9bf90e5', '2023-09-15 08:31:23', '2023-09-15 08:31:23', 0, NULL, 'PBTDxKupSCddFeFeu6rL4g=='), (2, '1e667480-6816-4b60-acdb-8111cbef53c8', '2023-09-15 00:00:00', '2033-09-15 00:00:00', 1, NULL, 'fpfJG9REqfo4Ki3v/2147Q=='), (3, '59884e2c-04fa-4815-8bd1-0f69f0e86759', '2023-09-15 08:54:52', '2023-09-15 08:54:52', 0, NULL, 'OmSmKjM8/q4eJg5S5LWjmg=='), (6, 'a2d6cf01-7e9e-4a79-97a8-ff8de2c57619', '2023-09-16 10:34:03', '2023-09-16 10:34:03', 0, NULL, '6k7FAb4CalYrWoD4ij7/8A=='); -- -------------------------------------------------------- -- -- Table structure for table `userRole` -- CREATE TABLE `userRole` ( `userId` varchar(255) NOT NULL COMMENT 'Fk(user => id)', `role` varchar(6) NOT NULL DEFAULT 'USER' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `userRole` -- INSERT INTO `userRole` (`userId`, `role`) VALUES ('3c87faf5-a58b-4f54-a731-60a8f9bf90e5', 'ADMIN'), ('1e667480-6816-4b60-acdb-8111cbef53c8', 'USER'), ('59884e2c-04fa-4815-8bd1-0f69f0e86759', 'USER'), ('a2d6cf01-7e9e-4a79-97a8-ff8de2c57619', 'USER'); -- -------------------------------------------------------- -- -- Table structure for table `userServerInfo` -- CREATE TABLE `userServerInfo` ( `userId` varchar(255) NOT NULL COMMENT 'FK (user => id)', `apiUrl` varchar(255) NOT NULL, `portNum` int(10) UNSIGNED NOT NULL DEFAULT '80', `deviceUid` varchar(255) NOT NULL COMMENT 'Device ID which is unique', `isActive` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `userServerInfo` -- INSERT INTO `userServerInfo` (`userId`, `apiUrl`, `portNum`, `deviceUid`, `isActive`) VALUES ('1e667480-6816-4b60-acdb-8111cbef53c8', 'https://api.careandtreatment.com/cloudcam', 80, 'cnt_linux_3.10.0-957.12.1.el7.x86_64', 1), ('3c87faf5-a58b-4f54-a731-60a8f9bf90e5', 'https://api.thatsend.com/cloudcam', 80, 'ts_linux_3.10.0-957.12.1.el7.x86_64', 1), ('59884e2c-04fa-4815-8bd1-0f69f0e86759', 'https://cloudcam.thatsend.com/api/private', 80, 'tedev_linux_3.10.0-957.12.1.el7.x86_64', 1), ('a2d6cf01-7e9e-4a79-97a8-ff8de2c57619', 'https://api.thatsend.work/cloudcam', 80, 'tework_linux_3.10.0-957.12.1.el7.x86_64', 0); -- -- Indexes for dumped tables -- -- -- Indexes for table `refreshToken` -- ALTER TABLE `refreshToken` ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`email`), ADD KEY `id` (`id`); -- -- Indexes for table `userCredentials` -- ALTER TABLE `userCredentials` ADD PRIMARY KEY (`id`), ADD KEY `userId` (`userId`); -- -- Indexes for table `userLicence` -- ALTER TABLE `userLicence` ADD PRIMARY KEY (`id`), ADD KEY `userId` (`userId`), ADD KEY `startDateTime` (`startDateTime`), ADD KEY `endDateTime` (`endDateTime`), ADD KEY `type` (`type`), ADD KEY `payTransactionId` (`payTransactionId`); -- -- Indexes for table `userRole` -- ALTER TABLE `userRole` ADD PRIMARY KEY (`userId`), ADD KEY `role` (`role`); -- -- Indexes for table `userServerInfo` -- ALTER TABLE `userServerInfo` ADD PRIMARY KEY (`userId`), ADD UNIQUE KEY `apiUrl` (`apiUrl`), ADD UNIQUE KEY `deviceUid` (`deviceUid`), ADD KEY `isActive` (`isActive`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `refreshToken` -- ALTER TABLE `refreshToken` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `userLicence` -- ALTER TABLE `userLicence` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- Constraints for dumped tables -- -- -- Constraints for table `userCredentials` -- ALTER TABLE `userCredentials` ADD CONSTRAINT `usercredentials_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `userLicence` -- ALTER TABLE `userLicence` ADD CONSTRAINT `userlicence_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `userServerInfo` (`userId`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `userRole` -- ALTER TABLE `userRole` ADD CONSTRAINT `userrole_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `userServerInfo` -- ALTER TABLE `userServerInfo` ADD CONSTRAINT `userserverinfo_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; 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 */;