-
Notifications
You must be signed in to change notification settings - Fork 1
/
data.sql
39 lines (30 loc) · 967 Bytes
/
data.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
CREATE database pollsimple;
use pollsimple;
CREATE TABLE poll (
id INT PRIMARY KEY AUTO_INCREMENT,
poll_title VARCHAR(50) NOT NULL
) Engine = InnoDb;
CREATE TABLE poll_options
(
id INT PRIMARY KEY AUTO_INCREMENT,
poll_id INT NOT NULL,
name VARCHAR(20) NOT NULL,
pol int NOT NULL,
FOREIGN KEY(poll_id) REFERENCES poll(id) ON DELETE CASCADE
) Engine = InnoDb;
CREATE TABLE users
(
id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(20) NOT NULL,
password CHAR(60) NOT NULL,
email VARCHAR(20) NOT NULL
) Engine = InnoDb;
CREATE TABLE votes
(
id INT PRIMARY KEY AUTO_INCREMENT,
poll_id INT NOT NULL,
poll_option_id INT NOT NULL,
votes INT DEFAULT 0,
FOREIGN KEY(poll_id) REFERENCES poll(id) ON DELETE CASCADE
) Engine = InnoDb;
INSERT INTO `users` (`id`, `username`, `password`, `email`) VALUES ('1', 'Admin', '$2y$10$djaND9G.eqjorWTAWAfqxeDYykwzq9j4H1w6eA6PAFXfGSU0tVwea', 'admin@hotmail.com');