ADCInstaller/setup.sql at master · bsakai2000/ADCInstaller · GitHub

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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
CREATE DATABASE ADC;
USE ADC;

CREATE TABLE
	users
	(
		rcsid VARCHAR(255) UNIQUE NOT NULL,
		password VARCHAR(255),
		admin BOOLEAN NOT NULL,
		enabled BOOLEAN NOT NULL
	);

CREATE TABLE
	complaints
	(
		location VARCHAR(255),
		message TEXT
	);

CREATE TABLE
	doors
	(
		name VARCHAR(255) UNIQUE NOT NULL,
		location VARCHAR(255) UNIQUE NOT NULL,
		latitude DECIMAL(10,8) NOT NULL,
		longitude DECIMAL(11,8) NOT NULL,
		`key` VARCHAR(255) UNIQUE NOT NULL,
		mac VARCHAR(255) UNIQUE NOT NULL
	);

CREATE TABLE
	tokens
	(
		rcsid VARCHAR(255) NOT NULL,
		reason VARCHAR(255) NOT NULL,
		expiration TIMESTAMP,
		value VARCHAR(255) UNIQUE NOT NULL
	);

CREATE USER 'developer'@'localhost' IDENTIFIED BY 'developer';
GRANT ALL PRIVILEGES ON *.* TO 'developer'@'localhost' IDENTIFIED BY 'developer';

INSERT INTO
	users
	(
		rcsid,
		password,
		admin,
		enabled
	)
VALUES
(
	"admin1",
	"$2y$10$CUoclxcmP3gLnRy00N.tdOHAihRx/VYD50u2eGyGbvMp61FYqQG5q",
	TRUE,
	TRUE
),
(
	"admin2",
	"$2y$10$XqcO4zlTtB5F9gKYBKbthObqMJwtE48pnV.HIGlA/sDNK4BYtOe1K",
	TRUE,
	TRUE
),
(
	"user1",
	"$2y$10$9AxuNZcQhKbjoHIHWFN59OlyvXwyyU5q3BI1b77KtqLiny2Yf2dDa",
	FALSE,
	TRUE
),
(
	"user2",
	"$2y$10$tItI1vGDKH1qJTeh3O3WYegS3FFvLqoLn6p1m0HoBXStgtHjgSEKu",
	FALSE,
	FALSE
);

INSERT INTO
	complaints
	(
		location,
		message
	)
VALUES
(
	"loc1",
	"this is message1"
),
(
	"location2",
	"message the second"
);