Skip to content

Instantly share code, notes, and snippets.

@sean3z

sean3z/down.sql

Last active March 18, 2018 03:53
Show Gist options
  • Save sean3z/5d74ed5208a98903c94e93324e230385 to your computer and use it in GitHub Desktop.
Save sean3z/5d74ed5208a98903c94e93324e230385 to your computer and use it in GitHub Desktop.
Download ZIP
Creating our Heroes schema
Raw
down.sql
-- This file should undo anything in `up.sql`
DROP TABLE heroes;
Raw
up.sql
CREATE TABLE heroes (
id INT(11) PRIMARY KEY AUTO_INCREMENT,
`name` VARCHAR(60) NOT NULL,
identity VARCHAR(60) NOT NULL,
hometown VARCHAR(60) NOT NULL,
age INT(11) NOT NULL
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment