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:39 -0500 |
| commit | 576c1096d2689ea71132ddec6c9a84590c1da022 (patch) | |
| tree | 66d975b470e2de75e66a224fe6f7194a41243a82 /docs | |
| parent | fbddd946adf1ae0efc90f022df3c6f6d3b1abfa1 (diff) | |
[1.8.x] Corrected sqlmigrate output in tutorial 1.
Backport of ff5e47e7a4a638a30424331222e0abdb60842ddd from master
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 0840826106..1e85461d21 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: |
