psQz8hKt

1DROP DATABASE IF EXISTS se266;
2CREATE DATABASE se266;
3
4
5use se266;
6CREATE TABLE users (
7  user_id        INT(11)        NOT NULL   AUTO_INCREMENT,
8  user_first       VARCHAR(50),
9  user_last      VARCHAR(50)    NOT NULL,
10  user_name      VARCHAR(50)   NOT NULL,
11  user_password  VARCHAR(50),
12  user_is_admin BIT,
13  PRIMARY KEY (user_id)
14);
15-- create the users and grant priveleges to those users
16GRANT SELECT, INSERT, DELETE, UPDATE
17ON se266.*
18TO se266_user@localhost
19IDENTIFIED BY 'pwd';
20
21INSERT INTO users (user_first, user_last, user_name, user_password, user_is_admin)
22VALUES ('Matt', 'McCarthy', 'matt', 'pwd', 1);
23use se266;
24SELECT * FROM users;