Skip to content

Instantly share code, notes, and snippets.

@srt32

srt32/migration

Created September 26, 2014 17:04
Show Gist options
  • Save srt32/958e19d84f076f155ff9 to your computer and use it in GitHub Desktop.
Save srt32/958e19d84f076f155ff9 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. srt32 created this gist Sep 26, 2014.
    6 changes: 6 additions & 0 deletions migration
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,6 @@
    CREATE TABLE IF NOT EXISTS users (
    email varchar PRIMARY KEY NOT NULL,
    started_on date NOT NULL
    );

    CREATE UNIQUE INDEX users_email_index ON users (email);