StudentTimetableSystem/SQL-Users.txt at master · markbennison/StudentTimetableSystem · 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
DROP TABLE Users;
CREATE TABLE Users
(
    id INTEGER NOT NULL
       PRIMARY KEY
       GENERATED ALWAYS AS IDENTITY
       (START WITH 1, INCREMENT BY 1),
    username VARCHAR(20) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    forename VARCHAR(20) NOT NULL,
    surname VARCHAR(20) NOT NULL,
    roleid INTEGER NOT NULL,
    FOREIGN KEY (roleid) REFERENCES Roles(id)
);

INSERT INTO MARKBENNISON.USERS (USERNAME, PASSWORD, FORENAME, SURNAME, ROLEID)
VALUES ('admin', 'GVE/3J2k+3KkoF62aRdUjTyQ/5TVQZ4fI2PuqJ3+4d0=', 'admin', 'admin', 1),
	('astaff', 'GVE/3J2k+3KkoF62aRdUjTyQ/5TVQZ4fI2PuqJ3+4d0=', 'Ada', 'Staff', 2),
	('bstafford', 'GVE/3J2k+3KkoF62aRdUjTyQ/5TVQZ4fI2PuqJ3+4d0=', 'Basil', 'Stafford', 2),
	('clongstaff', 'GVE/3J2k+3KkoF62aRdUjTyQ/5TVQZ4fI2PuqJ3+4d0=', 'Charly', 'Stafford', 2),
	('dstaffield', 'GVE/3J2k+3KkoF62aRdUjTyQ/5TVQZ4fI2PuqJ3+4d0=', 'David', 'Staffield', 2),
	('estaffin', 'GVE/3J2k+3KkoF62aRdUjTyQ/5TVQZ4fI2PuqJ3+4d0=', 'Edina', 'Staffin', 2),
	('sdent', 'GVE/3J2k+3KkoF62aRdUjTyQ/5TVQZ4fI2PuqJ3+4d0=', 'Stu', 'Dent', 3),
	('tdenant', 'GVE/3J2k+3KkoF62aRdUjTyQ/5TVQZ4fI2PuqJ3+4d0=', 'Ted', 'De Nant', 3),
	('ustudern', 'GVE/3J2k+3KkoF62aRdUjTyQ/5TVQZ4fI2PuqJ3+4d0=', 'Una', 'Studern', 3),
	('vpupal', 'GVE/3J2k+3KkoF62aRdUjTyQ/5TVQZ4fI2PuqJ3+4d0=', 'Viv', 'Pupal', 3),
	('wlerner', 'GVE/3J2k+3KkoF62aRdUjTyQ/5TVQZ4fI2PuqJ3+4d0=', 'William', 'Lerner', 3),
	('xlearnmouth', 'GVE/3J2k+3KkoF62aRdUjTyQ/5TVQZ4fI2PuqJ3+4d0=', 'Xavier', 'Learnmouth', 3),
	('ylearny', 'GVE/3J2k+3KkoF62aRdUjTyQ/5TVQZ4fI2PuqJ3+4d0=', 'Yvonne', 'Learny', 3),
	('zschooler', 'GVE/3J2k+3KkoF62aRdUjTyQ/5TVQZ4fI2PuqJ3+4d0=', 'Zach', 'Schooler', 3);


Note: 'Password1' =
GVE/3J2k+3KkoF62aRdUjTyQ/5TVQZ4fI2PuqJ3+4d0=