cDd5da8u

1DROP TABLE IF EXISTS Member, Song, Playlist;
2
3CREATE TABLE Member (
4    memberID INT AUTO_INCREMENT,
5    username VARCHAR(10) UNIQUE NOT NULL,
6    password CHAR(10) NOT NULL,
7    FName VARCHAR(25) NOT NULL,
8    LName VARCHAR(25) NOT NULL,
9    email VARCHAR(50) UNIQUE NOT NULL,
10    dob DATE NOT NULL,
11    gender CHAR(1) NOT NULL,
12    country VARCHAR (30) NOT NULL,
13    PRIMARY KEY (memberID)
14) ENGINE=InnoDB;
15
16CREATE TABLE Song (
17    songID INT AUTO_INCREMENT,
18    title VARCHAR (50) NOT NULL,
19    artist VARCHAR(50),
20    genre VARCHAR(20),
21    url VARCHAR(150) UNIQUE,
22    releaseYear YEAR(4),
23    PRIMARY KEY (songID)
24) ENGINE=InnoDB;
25
26CREATE TABLE Playlist (
27    playID INT AUTO_INCREMENT,
28    memberID INT NOT NULL,
29    songID INT,
30    data_saved TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
31    PRIMARY KEY (playID),
32    FOREIGN KEY (memberID)
33        REFERENCES Member (memberID),
34    FOREIGN KEY (songID)
35        REFERENCES Song (songID)
36) ENGINE=InnoDB;