X7LfXiDi

1DROP TABLE IF EXISTS users;
2
3CREATE TABLE IF NOT EXISTS users (
4	user_id INT auto_increment PRIMARY KEY,
5	user_name VARCHAR(20) NOt NULL, 
6    user_password VARCHAR(40) NOT NULL, 
7    user_role VARCHAR(10)
8);
9
10/* ~ INSERTION ~ */
11
12INSERT INTO users (user_name, user_password, user_role)
13VALUES
14('edvin' , '_myhren'      	  , 'Student'),
15('adrian', 'fortnite'         , 'Student'),
16('tobias', 'biased'   		  , 'Student'),
17('tord'  , 'iknow'            , 'Student'),
18('espen' , 'havetoraidredbull', 'Student'),
19('admin' , 'admin'			  , 'Lecturer');
20
21SELECT * FROM users;