Skip to content

Instantly share code, notes, and snippets.

@jobscry

jobscry/gist:eff8384e751f657c955d

Last active August 29, 2015 14:16
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jobscry/eff8384e751f657c955d to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jobscry/eff8384e751f657c955d to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. jobscry revised this gist Mar 2, 2015. 1 changed file with 9 additions and 9 deletions.
    18 changes: 9 additions & 9 deletions gistfile1.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,11 +1,11 @@
    CREATE TABLE IF NOT EXISTS emails(
    id INTEGER PRIMARY KEY,
    email VARCHAR(255) UNIQUE,
    dumps VARCHAR(255),
    count INTEGER DEFAULT 1,
    fb INTEGER DEFAULT 0,
    twitter INTEGER DEFAULT 0,
    sex INTEGER DEFAULT 0,
    location INTEGER DEFAULT 0,
    tw_updates INTEGER DEFAULT 0
    id INTEGER PRIMARY KEY,
    email VARCHAR(255) UNIQUE,
    dumps VARCHAR(255),
    count INTEGER DEFAULT 1,
    fb INTEGER DEFAULT 0,
    twitter INTEGER DEFAULT 0,
    sex INTEGER DEFAULT 0,
    location INTEGER DEFAULT 0,
    tw_updates INTEGER DEFAULT 0
    )
  2. jobscry created this gist Mar 2, 2015.
    11 changes: 11 additions & 0 deletions gistfile1.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,11 @@
    CREATE TABLE IF NOT EXISTS emails(
    id INTEGER PRIMARY KEY,
    email VARCHAR(255) UNIQUE,
    dumps VARCHAR(255),
    count INTEGER DEFAULT 1,
    fb INTEGER DEFAULT 0,
    twitter INTEGER DEFAULT 0,
    sex INTEGER DEFAULT 0,
    location INTEGER DEFAULT 0,
    tw_updates INTEGER DEFAULT 0
    )