<reponame>paytoncali/UTA-AUS-FSF-PT-12-2020-U-C<filename>12-MySQL/01-Activities/12-Top5000Schema/top5000songs.sql
DROP DATABASE IF EXISTS top_songsDB;

CREATE DATABASE top_songsDB;
USE top_songsDB;

CREATE TABLE top5000 (
position INT NOT NULL, 
artist VARCHAR(100) NULL, 
song VARCHAR(100) NULL, 
year INT NULL, 
raw_total DECIMAL(10, 4) NULL,
raw_usa DECIMAL(10, 4) NULL,
raw_uk DECIMAL(10, 4) NULL,
raw_eur DECIMAL(10, 4) NULL,
raw_row DECIMAL(10, 4) NULL,
PRIMARY KEY (position)
);