-
Notifications
You must be signed in to change notification settings - Fork 1
/
install.sql
49 lines (45 loc) · 1.32 KB
/
install.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
CREATE TABLE `camagru`.`users` (
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`email` VARCHAR(255) NOT NULL,
`password` VARCHAR(255) NOT NULL,
`img` VARCHAR(255) NOT NULL,
`number` VARCHAR(255),
`notif` BOOLEAN NOT NULL DEFAULT TRUE,
`created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
`verified` tinyint(1) NOT NULL DEFAULT 0,
`vkey` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`)
);
CREATE TABLE `camagru`.`posts` (
`id` INT NOT NULL AUTO_INCREMENT,
`user_id` INT NOT NULL,
`img` VARCHAR(255) NOT NULL,
`likeCount` INT NOT NULL DEFAULT 0 ,
`cmntCount` INT NOT NULL DEFAULT 0 ,
`created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
);
CREATE TABLE `camagru`.`pwdReset` (
`id` INT NOT NULL AUTO_INCREMENT ,
`email` VARCHAR(255) NOT NULL ,
`selector` VARCHAR(255) NOT NULL ,
`token` VARCHAR(255) NOT NULL ,
`expires` INT NOT NULL ,
PRIMARY KEY (`id`)
);
CREATE TABLE `camagru`.`likes` (
`id` INT NOT NULL AUTO_INCREMENT ,
`user_id` INT NOT NULL ,
`post_id` INT NOT NULL ,
`created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
);
CREATE TABLE `camagru`.`comments` (
`id` INT NOT NULL AUTO_INCREMENT ,
`user_id` INT NOT NULL ,
`post_id` INT NOT NULL ,
`body` TEXT NOT NULL ,
`created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
);