SQL: Simple create, alter, and drop tables

02_create_artists.sql

CREATE TABLE artists(
  name TEXT,
  album_count INTEGER,
  song_count INTEGER,
  worth_in_mil REAL
);

03_add_best_album.sql

ALTER TABLE artists ADD COLUMN best_album TEXT;
ALTER TABLE artists ADD COLUMN worst_album TEXT;

04_drop_worth_col.sql

-- Can't drop column in SQLite, dropping and recreating table
DROP TABLE artists;
CREATE TABLE artists(
  name TEXT,
  album_count INTEGER,
  song_count INTEGER,
  best_album TEXT,
  worst_album TEXT
);

05_rename_table.sql

ALTER TABLE artists RENAME TO musicians;

06_drop_table.sql

DROP TABLE musicians;