diff options
| author | Tim Graham <timograham@gmail.com> | 2015-02-22 12:29:01 -0500 |
|---|---|---|
| committer | Tim Graham <timograham@gmail.com> | 2015-02-22 12:29:01 -0500 |
| commit | ff5e47e7a4a638a30424331222e0abdb60842ddd (patch) | |
| tree | 5b3c4afcc077c500b9d976e3fc3b1d0cf1a1bf36 /docs | |
| parent | 7901eccf2e591447850be00011a7bb556a3c53f2 (diff) | |
Corrected sqlmigrate output in tutorial 1.
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/intro/tutorial01.txt | 25 |
1 files changed, 11 insertions, 14 deletions
diff --git a/docs/intro/tutorial01.txt b/docs/intro/tutorial01.txt index 6baf8f3a19..6c740cb654 100644 --- a/docs/intro/tutorial01.txt +++ b/docs/intro/tutorial01.txt @@ -470,35 +470,32 @@ moment - but first, let's see what SQL that migration would run. The $ python manage.py sqlmigrate polls 0001 - You should see something similar to the following (we've reformatted it for readability): .. code-block:: sql BEGIN; - CREATE TABLE polls_question ( + CREATE TABLE "polls_choice" ( "id" serial NOT NULL PRIMARY KEY, - "question_text" varchar(200) NOT NULL, - "pub_date" timestamp with time zone NOT NULL - ); - - CREATE TABLE polls_choice ( - "id" serial NOT NULL PRIMARY KEY, - "question_id" integer NOT NULL, "choice_text" varchar(200) NOT NULL, "votes" integer NOT NULL ); - - CREATE INDEX polls_choice_7aa0f6ee ON "polls_choice" ("question_id"); - + CREATE TABLE "polls_question" ( + "id" serial NOT NULL PRIMARY KEY, + "question_text" varchar(200) NOT NULL, + "pub_date" timestamp with time zone NOT NULL + ); + ALTER TABLE "polls_choice" ADD COLUMN "question_id" integer NOT NULL; + ALTER TABLE "polls_choice" ALTER COLUMN "question_id" DROP DEFAULT; + CREATE INDEX "polls_choice_7aa0f6ee" ON "polls_choice" ("question_id"); ALTER TABLE "polls_choice" - ADD CONSTRAINT polls_choice_question_id_246c99a640fbbd72_fk_polls_question_id + ADD CONSTRAINT "polls_choice_question_id_246c99a640fbbd72_fk_polls_question_id" FOREIGN KEY ("question_id") REFERENCES "polls_question" ("id") DEFERRABLE INITIALLY DEFERRED; - COMMIT; + COMMIT; Note the following: |
