schema.sql

CREATE DATABASE record_company;
USE record_company;

CREATE TABLE bands (
 id INT NOT NULL AUTO_INCREMENT,
 name VARCHAR(255) NOT NULL,
 PRIMARY KEY (id)
);

CREATE TABLE albums (
 id INT NOT NULL AUTO_INCREMENT,
 name VARCHAR(255) NOT NULL,
 release_year INT,
 band_id INT NOT NULL,
 PRIMARY KEY (id),
 FOREIGN KEY (band_id) REFERENCES bands(id)
);