gistfile1.sql

[/home/ricky/dev/eighthbit] -> ./manage.py sqlall wiki
BEGIN;
CREATE TABLE "wiki_page" (
    "id" integer NOT NULL PRIMARY KEY,
    "title" varchar(200) NOT NULL,
    "revision_id" integer NOT NULL
)
;
CREATE TABLE "wiki_revision" (
    "id" integer NOT NULL PRIMARY KEY,
    "contents" text NOT NULL,
    "username_id" integer NOT NULL REFERENCES "auth_user" ("id"),
    "page_id" integer NOT NULL UNIQUE REFERENCES "wiki_page" ("id")
)
;
CREATE INDEX "wiki_page_revision_id" ON "wiki_page" ("revision_id");
CREATE INDEX "wiki_revision_username_id" ON "wiki_revision" ("username_id");
COMMIT;