Learn SQL using MySQL in One Day and Learn It Well

Appendix C: Suggested Solution for Project

 

sportsDB.sql

 

CREATE DATABASE sports_booking;

USE sports_booking;

 

-- ********************* CREATE TABLES ********************************

 

CREATE TABLE members (

id VARCHAR(255) PRIMARY KEY,

password VARCHAR(255) NOT NULL,

email VARCHAR(255) NOT NULL,

member_since TIMESTAMP DEFAULT NOW() NOT NULL,

payment_due DECIMAL(6, 2) NOT NULL DEFAULT 0

);

 

CREATE TABLE pending_terminations (

id VARCHAR(255) PRIMARY KEY,

email VARCHAR(255) NOT NULL,

request_date TIMESTAMP DEFAULT NOW() NOT NULL,

payment_due DECIMAL(6, 2) NOT NULL DEFAULT 0

);

 

CREATE TABLE rooms (

id VARCHAR(255) PRIMARY KEY,

room_type VARCHAR(255) NOT NULL,

price DECIMAL(6, 2) NOT NULL

);

 

CREATE TABLE bookings (

id INT AUTO_INCREMENT ...