Skip to content

Instantly share code, notes, and snippets.

@jobscry

jobscry/gist:eff8384e751f657c955d

Last active August 29, 2015 14:16
Show Gist options
  • Save jobscry/eff8384e751f657c955d to your computer and use it in GitHub Desktop.
Save jobscry/eff8384e751f657c955d to your computer and use it in GitHub Desktop.
Download ZIP
email table
Raw
gistfile1.sql
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
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment