· 6 years ago · Oct 30, 2019, 06:26 AM
1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
5/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
6/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
7/*!40101 SET NAMES utf8mb4 */;
8
9CREATE DATABASE IF NOT EXISTS `ubox2` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
10USE `ubox2`;
11
12CREATE TABLE `emailtemplate` (
13 `uuid` char(255) NOT NULL,
14 `name` varchar(255) NOT NULL,
15 `subject` varchar(255) NOT NULL,
16 `message` longtext NOT NULL,
17 `createdAt` datetime NOT NULL,
18 `updatedAt` datetime NOT NULL
19) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
20
21INSERT INTO `emailtemplate` (`uuid`, `name`, `subject`, `message`, `createdAt`, `updatedAt`) VALUES
22('08f75ae2-56b0-4413-9176-2b78ab7228f2', 'invitation', 'You are invited to join a Team at .com', 'You\'ve been invited to join <b>{{teamName}}</b>. <br/>Click here to accept the invitation: {{invitationURL}} ', '2019-09-16 23:30:23', '2019-09-16 23:30:23'),
23('5fa17deb-bca2-455f-9401-3a45cbb09d86', 'email-verification', 'Thanks for signing up at .com. Your are just one click away from verification', ' {{ userName }}, <br /> <p> Thanks for signing up. You have made a great choice. </p> <br/>Click here to verify your email {{emailVerificationURL}} ', '2019-09-16 23:30:23', '2019-09-16 23:30:23'),
24('95ab2710-e852-46fb-9165-06ca836a1cbb', 'welcome', 'Welcome to SaaS', '{{userName}}, <p> Thanks for signing up on our website </p> <p> Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. </p> <p> Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. </p> <p> Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. </p> ', '2019-09-16 23:30:23', '2019-09-16 23:30:23');
25
26CREATE TABLE `emailverifytoken` (
27 `uuid` char(255) NOT NULL,
28 `token` varchar(255) NOT NULL,
29 `createdAt` datetime DEFAULT NULL,
30 `userUUID` char(255) DEFAULT NULL
31) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
32
33CREATE TABLE `users` (
34 `uuid` char(255) NOT NULL,
35 `firstName` varchar(255) DEFAULT NULL,
36 `lastName` varchar(255) DEFAULT NULL,
37 `displayName` varchar(255) DEFAULT NULL,
38 `gender` varchar(255) DEFAULT NULL,
39 `location` varchar(255) DEFAULT NULL,
40 `website` varchar(255) DEFAULT NULL,
41 `picture` varchar(255) DEFAULT NULL,
42 `avatarUrl` varchar(255) DEFAULT NULL,
43 `email` varchar(255) NOT NULL,
44 `password` varchar(255) NOT NULL,
45 `passwordResetToken` varchar(255) DEFAULT NULL,
46 `passwordResetExpires` date DEFAULT NULL,
47 `steam` varchar(255) DEFAULT NULL,
48 `facebook` varchar(255) DEFAULT NULL,
49 `twitter` varchar(255) DEFAULT NULL,
50 `google` varchar(255) DEFAULT NULL,
51 `github` varchar(255) DEFAULT NULL,
52 `instagram` varchar(255) DEFAULT NULL,
53 `linkedin` varchar(255) DEFAULT NULL,
54 `tokens` varchar(255) DEFAULT NULL,
55 `isVerified` tinyint(1) DEFAULT '0',
56 `isAdmin` tinyint(1) DEFAULT '0',
57 `isActive` tinyint(1) DEFAULT '0',
58 `createdAt` datetime NOT NULL,
59 `updatedAt` datetime NOT NULL
60) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
61
62INSERT INTO `users` (`uuid`, `firstName`, `lastName`, `displayName`, `gender`, `location`, `website`, `picture`, `avatarUrl`, `email`, `password`, `passwordResetToken`, `passwordResetExpires`, `steam`, `facebook`, `twitter`, `google`, `github`, `instagram`, `linkedin`, `tokens`, `isVerified`, `isAdmin`, `isActive`, `createdAt`, `updatedAt`) VALUES
63('a0d49ff2-ec0c-4f5c-abf4-6a0ec1ec0965', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'boss@aa.aa', '$2a$10$2/zDYMkEj03yMEJfQsckS.g8SkYCiEudluVUgXdgKUzZixOPr0MhS', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '2019-09-16 23:30:50', '2019-09-16 23:30:50');
64
65
66ALTER TABLE `emailtemplate`
67 ADD PRIMARY KEY (`uuid`),
68 ADD UNIQUE KEY `name` (`name`);
69
70ALTER TABLE `emailverifytoken`
71 ADD PRIMARY KEY (`uuid`),
72 ADD KEY `userUUID` (`userUUID`);
73
74ALTER TABLE `users`
75 ADD PRIMARY KEY (`uuid`),
76 ADD UNIQUE KEY `email` (`email`);
77
78
79ALTER TABLE `emailverifytoken`
80 ADD CONSTRAINT `emailverifytoken_ibfk_1` FOREIGN KEY (`userUUID`) REFERENCES `users` (`uuid`) ON DELETE SET NULL ON UPDATE CASCADE;
81
82/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
83/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
84/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;