Skip to content

Instantly share code, notes, and snippets.

@phretor

phretor/gist:749376

Created December 21, 2010 02:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save phretor/749376 to your computer and use it in GitHub Desktop.
Save phretor/749376 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
sqlite> .schema people_person
CREATE TABLE "people_person" ("picture" varchar(200), "first_name" varchar(64), "last_name" varchar(64), "description" text, "web_page" varchar(200), "visitor" bool NOT NULL DEFAULT False, "e_mail" varchar(75), "rank_id" integer, "current" bool, "public" bool, "mid_name" varchar(64), "id" integer PRIMARY KEY);
sqlite> select 'production',visitor from people_person;
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
production|False
sqlite> .schema people_person
CREATE TABLE "people_person" ("picture" varchar(200), "first_name" varchar(64), "last_name" varchar(64), "description" text, "web_page" varchar(200), "visitor" bool NOT NULL DEFAULT False, "e_mail" varchar(75), "rank_id" integer, "id" integer PRIMARY KEY, "current" bool, "mid_name" varchar(64), "public" bool);
sqlite> select 'dev', visitor from people_person;
dev|0
dev|0
dev|0
dev|0
dev|0
dev|0
dev|0
dev|0
dev|0
dev|1
dev|0
dev|0
dev|0
dev|0
dev|0
dev|0
dev|0
dev|0
dev|0
dev|0
dev|1
dev|0
dev|0
dev|1
dev|0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment