SQL statements for magical.db and artists.db

gistfile1.sql

--magical.db
--01_create_wizards.sql

CREATE TABLE wizards(
  name TEXT,
  age INTEGER
);

--02_add_color_to_wizards.sql

ALTER TABLE wizards ADD COLUMN color TEXT;

-------------------------------------------------------
-------------------------------------------------------

--artists.db
--02_create_table_artists.sql

CREATE TABLE artists(
  name TEXT,
  age INTEGER,
  number_of_hit_songs INTEGER,
  most_popular_song TEXT,
  highest_billboard_ranking REAL
);

--03_alter.sql

ALTER TABLE artists ADD COLUMN hometown TEXT;
ALTER TABLE artists ADD COLUMN biggest_idol TEXT;

--04_drop_column.sql

DROP TABLE artists;
CREATE TABLE artists(
  name TEXT,
  age INTEGER,
  most_popular_song TEXT,
  highest_billboard_ranking REAL
  hometown TEXT,
  biggest_idol TEXT
);

--05_rename.sql

ALTER TABLE artists RENAME TO musicians;

--06_drop_table.sql

DROP TABLE musicians;

Download the .db files at:

https://db.tt/YpPxKWrc