-
Notifications
You must be signed in to change notification settings - Fork 0
/
mysql
27 lines (24 loc) · 782 Bytes
/
mysql
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
/************************************
Copy and paste everything below into your mysql command prompt
*************************************/
CREATE DATABASE utitily_app;
CREATE TABLE user (
user_id BIGINT NOT NULL AUTO_INCREMENT,
username VARCHAR(50) NOT NULL,
password VARCHAR(50) NOT NULL,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NOT NULL,
email_address VARCHAR(100) NOT NULL,
PRIMARY KEY (user_id)
) ENGINE=MyISAM;
CREATE TABLE tracks (
track_id BIGINT NOT NULL AUTO_INCREMENT,
title VARCHAR(100) NOT NULL,
artist VARCHAR(100) NOT NULL,
album VARCHAR(100) NOT NULL,
year VARCHAR(100) NOT NULL,
tracknumber VARCHAR(100) NOT NULL,
genre VARCHAR(100) NOT NULL,
encoder VARCHAR(100) NOT NULL,
PRIMARY KEY (track_id)
) ENGINE=MyISAM;