· 9 years ago · Oct 28, 2016, 06:36 PM
1DELETE DATABASE IF EXISTS COMP3095;
2
3CREATE DATABASE IF NOT EXISTS COMP3095;
4USE COMP3095;
5grant all on COMP3095.* to 'admin'@'localhost' identified by 'admin';
6
7CREATE TABLE USERS
8(
9 id int(11) AUTO_INCREMENT PRIMARY KEY,
10 firstname varchar(255),
11 lastname varchar(255),
12 email varchar(255),
13 phone varchar(10),
14 year varchar(10),
15 major varchar(10),
16 username varchar(20),
17 password varchar(20)
18);
19
20INSERT INTO `USERS` (`id`, `firstname`, `lastname`, `email`, `phone`, `year`, `major`, `username`, `password`) VALUES
21(99, NULL, NULL, `admin@domain.ca`, NULL, NULL, NULL, `admin`, `admin`);