2 PG_MIGRATION_QUERY = """
3 SELECT id AS user_ptr_id, is_approved, email_isvalid, email_key, reputation, gravatar, gold, silver, bronze, questions_per_page, last_seen, real_name, website, location, date_of_birth, about, hide_ignored_questions, tag_filter_setting INTO forum_user FROM auth_user;
6 ADD CONSTRAINT forum_user_pkey PRIMARY KEY(user_ptr_id);
9 ADD CONSTRAINT forum_user_user_ptr_id_fkey FOREIGN KEY (user_ptr_id)
10 REFERENCES auth_user (id) MATCH SIMPLE
11 ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY DEFERRED;
13 ALTER TABLE forum_user
14 ADD CONSTRAINT forum_user_reputation_check CHECK (reputation >= 0);
16 ALTER TABLE auth_user DROP COLUMN is_approved;
17 ALTER TABLE auth_user DROP COLUMN email_isvalid;
18 ALTER TABLE auth_user DROP COLUMN email_key;
19 ALTER TABLE auth_user DROP COLUMN reputation;
20 ALTER TABLE auth_user DROP COLUMN gravatar;
21 ALTER TABLE auth_user DROP COLUMN gold;
22 ALTER TABLE auth_user DROP COLUMN silver;
23 ALTER TABLE auth_user DROP COLUMN bronze;
24 ALTER TABLE auth_user DROP COLUMN questions_per_page;
25 ALTER TABLE auth_user DROP COLUMN last_seen;
26 ALTER TABLE auth_user DROP COLUMN real_name;
27 ALTER TABLE auth_user DROP COLUMN website;
28 ALTER TABLE auth_user DROP COLUMN "location";
29 ALTER TABLE auth_user DROP COLUMN date_of_birth;
30 ALTER TABLE auth_user DROP COLUMN about;
31 ALTER TABLE auth_user DROP COLUMN hide_ignored_questions;
32 ALTER TABLE auth_user DROP COLUMN tag_filter_setting;
38 ALTER TABLE "public"."activity"
39 DROP CONSTRAINT "activity_user_id_fkey",
40 ADD CONSTRAINT "activity_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
42 ALTER TABLE "public"."answer"
43 DROP CONSTRAINT "answer_author_id_fkey",
44 ADD CONSTRAINT "answer_author_id_fkey" FOREIGN KEY ("author_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED,
45 DROP CONSTRAINT "answer_deleted_by_id_fkey",
46 ADD CONSTRAINT "answer_deleted_by_id_fkey" FOREIGN KEY ("deleted_by_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED,
47 DROP CONSTRAINT "answer_last_edited_by_id_fkey",
48 ADD CONSTRAINT "answer_last_edited_by_id_fkey" FOREIGN KEY ("last_edited_by_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED,
49 DROP CONSTRAINT "answer_locked_by_id_fkey",
50 ADD CONSTRAINT "answer_locked_by_id_fkey" FOREIGN KEY ("locked_by_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
52 ALTER TABLE "public"."answer_revision"
53 DROP CONSTRAINT "answer_revision_author_id_fkey",
54 ADD CONSTRAINT "answer_revision_author_id_fkey" FOREIGN KEY ("author_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
56 ALTER TABLE "public"."award"
57 DROP CONSTRAINT "award_user_id_fkey",
58 ADD CONSTRAINT "award_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
60 ALTER TABLE "public"."comment"
61 DROP CONSTRAINT "comment_user_id_fkey",
62 ADD CONSTRAINT "comment_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
64 ALTER TABLE "public"."favorite_question"
65 DROP CONSTRAINT "favorite_question_user_id_fkey",
66 ADD CONSTRAINT "favorite_question_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
68 ALTER TABLE "public"."flagged_item"
69 DROP CONSTRAINT "flagged_item_user_id_fkey",
70 ADD CONSTRAINT "flagged_item_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
72 ALTER TABLE "public"."forum_anonymousanswer"
73 DROP CONSTRAINT "forum_anonymousanswer_author_id_fkey",
74 ADD CONSTRAINT "forum_anonymousanswer_author_id_fkey" FOREIGN KEY ("author_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
76 ALTER TABLE "public"."forum_anonymousquestion"
77 DROP CONSTRAINT "forum_anonymousquestion_author_id_fkey",
78 ADD CONSTRAINT "forum_anonymousquestion_author_id_fkey" FOREIGN KEY ("author_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
80 ALTER TABLE "public"."forum_authkeyuserassociation"
81 DROP CONSTRAINT "forum_authkeyuserassociation_user_id_fkey",
82 ADD CONSTRAINT "forum_authkeyuserassociation_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
84 ALTER TABLE "public"."forum_markedtag"
85 DROP CONSTRAINT "forum_markedtag_user_id_fkey",
86 ADD CONSTRAINT "forum_markedtag_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
88 ALTER TABLE "public"."forum_questionsubscription"
89 DROP CONSTRAINT "forum_questionsubscription_user_id_fkey",
90 ADD CONSTRAINT "forum_questionsubscription_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
92 ALTER TABLE "public"."forum_subscriptionsettings"
93 DROP CONSTRAINT "forum_subscriptionsettings_user_id_fkey",
94 ADD CONSTRAINT "forum_subscriptionsettings_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
96 ALTER TABLE "public"."forum_validationhash"
97 DROP CONSTRAINT "forum_validationhash_user_id_fkey",
98 ADD CONSTRAINT "forum_validationhash_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
100 ALTER TABLE "public"."question"
101 DROP CONSTRAINT "question_author_id_fkey",
102 ADD CONSTRAINT "question_author_id_fkey" FOREIGN KEY ("author_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED,
103 DROP CONSTRAINT "question_closed_by_id_fkey",
104 ADD CONSTRAINT "question_closed_by_id_fkey" FOREIGN KEY ("closed_by_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED,
105 DROP CONSTRAINT "question_deleted_by_id_fkey",
106 ADD CONSTRAINT "question_deleted_by_id_fkey" FOREIGN KEY ("deleted_by_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED,
107 DROP CONSTRAINT "question_last_activity_by_id_fkey",
108 ADD CONSTRAINT "question_last_activity_by_id_fkey" FOREIGN KEY ("last_activity_by_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED,
109 DROP CONSTRAINT "question_last_edited_by_id_fkey",
110 ADD CONSTRAINT "question_last_edited_by_id_fkey" FOREIGN KEY ("last_edited_by_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED,
111 DROP CONSTRAINT "question_locked_by_id_fkey",
112 ADD CONSTRAINT "question_locked_by_id_fkey" FOREIGN KEY ("locked_by_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
114 ALTER TABLE "public"."question_followed_by"
115 DROP CONSTRAINT "question_followed_by_user_id_fkey",
116 ADD CONSTRAINT "question_followed_by_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
118 ALTER TABLE "public"."question_revision"
119 DROP CONSTRAINT "question_revision_author_id_fkey",
120 ADD CONSTRAINT "question_revision_author_id_fkey" FOREIGN KEY ("author_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
122 ALTER TABLE "public"."repute"
123 DROP CONSTRAINT "repute_user_id_fkey",
124 ADD CONSTRAINT "repute_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
126 ALTER TABLE "public"."tag"
127 DROP CONSTRAINT "tag_created_by_id_fkey",
128 ADD CONSTRAINT "tag_created_by_id_fkey" FOREIGN KEY ("created_by_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED,
129 DROP CONSTRAINT "tag_deleted_by_id_fkey",
130 ADD CONSTRAINT "tag_deleted_by_id_fkey" FOREIGN KEY ("deleted_by_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
132 ALTER TABLE "public"."vote"
133 DROP CONSTRAINT "vote_user_id_fkey",
134 ADD CONSTRAINT "vote_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."forum_user" (user_ptr_id) ON DELETE NO ACTION ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED;
138 MYSQL_MIGRATION_QUERY = """
139 CREATE TABLE `forum_user` (
140 `user_ptr_id` int(11) NOT NULL,
141 `is_approved` tinyint(1) NOT NULL,
142 `email_isvalid` tinyint(1) NOT NULL,
143 `email_key` varchar(32) DEFAULT NULL,
144 `reputation` int(10) unsigned NOT NULL,
145 `gravatar` varchar(32) NOT NULL,
146 `gold` smallint(6) NOT NULL,
147 `silver` smallint(6) NOT NULL,
148 `bronze` smallint(6) NOT NULL,
149 `questions_per_page` smallint(6) NOT NULL,
150 `last_seen` datetime NOT NULL,
151 `real_name` varchar(100) NOT NULL,
152 `website` varchar(200) NOT NULL,
153 `location` varchar(100) NOT NULL,
154 `date_of_birth` date DEFAULT NULL,
155 `about` longtext NOT NULL,
156 `hide_ignored_questions` tinyint(1) NOT NULL,
157 `tag_filter_setting` varchar(16) NOT NULL,
158 PRIMARY KEY (`user_ptr_id`),
159 CONSTRAINT `user_ptr_id_refs_id_71071d7` FOREIGN KEY (`user_ptr_id`) REFERENCES `auth_user` (`id`)
160 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
161 SELECT id AS user_ptr_id, is_approved, email_isvalid, email_key, reputation, gravatar, gold, silver, bronze, questions_per_page,
162 last_seen, real_name, website, location, date_of_birth, about, hide_ignored_questions, tag_filter_setting FROM auth_user;
164 ALTER TABLE `auth_user`
165 DROP COLUMN `is_approved`,
166 DROP COLUMN `email_isvalid`,
167 DROP COLUMN `email_key`,
168 DROP COLUMN `reputation`,
169 DROP COLUMN `gravatar`,
171 DROP COLUMN `silver`,
172 DROP COLUMN `bronze`,
173 DROP COLUMN `questions_per_page`,
174 DROP COLUMN `last_seen`,
175 DROP COLUMN `real_name`,
176 DROP COLUMN `website`,
177 DROP COLUMN `location`,
178 DROP COLUMN `date_of_birth`,
180 DROP COLUMN `hide_ignored_questions`,
181 DROP COLUMN `tag_filter_setting`;
185 MYSQL_FKEYS_QUERY = """
187 ALTER TABLE `activity` DROP FOREIGN KEY `user_id_refs_id_47c8583f`;
188 ALTER TABLE `activity` ADD CONSTRAINT `user_id_refs_user_ptr_id_62ae9785` FOREIGN KEY (`user_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
190 ALTER TABLE `answer` DROP FOREIGN KEY `author_id_refs_id_192b0170`;
191 ALTER TABLE `answer` ADD CONSTRAINT `author_id_refs_user_ptr_id_9681994` FOREIGN KEY (`author_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
192 ALTER TABLE `answer` DROP FOREIGN KEY `deleted_by_id_refs_id_192b0170`;
193 ALTER TABLE `answer` ADD CONSTRAINT `deleted_by_id_refs_user_ptr_id_9681994` FOREIGN KEY (`deleted_by_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
194 ALTER TABLE `answer` DROP FOREIGN KEY `last_edited_by_id_refs_id_192b0170`;
195 ALTER TABLE `answer` ADD CONSTRAINT `last_edited_by_id_refs_user_ptr_id_9681994` FOREIGN KEY (`last_edited_by_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
196 ALTER TABLE `answer` DROP FOREIGN KEY `locked_by_id_refs_id_192b0170`;
197 ALTER TABLE `answer` ADD CONSTRAINT `locked_by_id_refs_user_ptr_id_9681994` FOREIGN KEY (`locked_by_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
199 ALTER TABLE `answer_revision` DROP FOREIGN KEY `author_id_refs_id_3ccc055f`;
200 ALTER TABLE `answer_revision` ADD CONSTRAINT `author_id_refs_user_ptr_id_331f0123` FOREIGN KEY (`author_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
202 ALTER TABLE `award` DROP FOREIGN KEY `user_id_refs_id_2d83e9b6`;
203 ALTER TABLE `award` ADD CONSTRAINT `user_id_refs_user_ptr_id_1b2d0192` FOREIGN KEY (`user_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
205 ALTER TABLE `comment` DROP FOREIGN KEY `user_id_refs_id_6be725e8`;
206 ALTER TABLE `comment` ADD CONSTRAINT `user_id_refs_user_ptr_id_1ac2320c` FOREIGN KEY (`user_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
208 ALTER TABLE `favorite_question` DROP FOREIGN KEY `user_id_refs_id_52853822`;
209 ALTER TABLE `favorite_question` ADD CONSTRAINT `user_id_refs_user_ptr_id_3f419c1a` FOREIGN KEY (`user_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
211 ALTER TABLE `flagged_item` DROP FOREIGN KEY `user_id_refs_id_35e3c608`;
212 ALTER TABLE `flagged_item` ADD CONSTRAINT `user_id_refs_user_ptr_id_1ce834d4` FOREIGN KEY (`user_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
214 ALTER TABLE `forum_anonymousanswer` DROP FOREIGN KEY `author_id_refs_id_13fb542e`;
215 ALTER TABLE `forum_anonymousanswer` ADD CONSTRAINT `author_id_refs_user_ptr_id_6b5b476a` FOREIGN KEY (`author_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
217 ALTER TABLE `forum_anonymousquestion` DROP FOREIGN KEY `author_id_refs_id_7511a98a`;
218 ALTER TABLE `forum_anonymousquestion` ADD CONSTRAINT `author_id_refs_user_ptr_id_104edd52` FOREIGN KEY (`author_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
220 ALTER TABLE `forum_authkeyuserassociation` DROP FOREIGN KEY `user_id_refs_id_2c2a6b01`;
221 ALTER TABLE `forum_authkeyuserassociation` ADD CONSTRAINT `user_id_refs_user_ptr_id_3f0ec0c3` FOREIGN KEY (`user_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
223 ALTER TABLE `forum_markedtag` DROP FOREIGN KEY `user_id_refs_id_23b833bd`;
224 ALTER TABLE `forum_markedtag` ADD CONSTRAINT `user_id_refs_user_ptr_id_5a13f081` FOREIGN KEY (`user_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
226 ALTER TABLE `forum_questionsubscription` DROP FOREIGN KEY `user_id_refs_id_18e1489`;
227 ALTER TABLE `forum_questionsubscription` ADD CONSTRAINT `user_id_refs_user_ptr_id_521b19ad` FOREIGN KEY (`user_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
229 ALTER TABLE `forum_subscriptionsettings` DROP FOREIGN KEY `user_id_refs_id_35edacb4`;
230 ALTER TABLE `forum_subscriptionsettings` ADD CONSTRAINT `user_id_refs_user_ptr_id_1bc4fc70` FOREIGN KEY (`user_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
232 ALTER TABLE `forum_validationhash` DROP FOREIGN KEY `user_id_refs_id_2c2d214b`;
233 ALTER TABLE `forum_validationhash` ADD CONSTRAINT `user_id_refs_user_ptr_id_4e5b2d6f` FOREIGN KEY (`user_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
235 ALTER TABLE `question` DROP FOREIGN KEY `author_id_refs_id_56e9d00c`;
236 ALTER TABLE `question` ADD CONSTRAINT `author_id_refs_user_ptr_id_60d41818` FOREIGN KEY (`author_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
237 ALTER TABLE `question` DROP FOREIGN KEY `closed_by_id_refs_id_56e9d00c`;
238 ALTER TABLE `question` ADD CONSTRAINT `closed_by_id_refs_user_ptr_id_60d41818` FOREIGN KEY (`closed_by_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
239 ALTER TABLE `question` DROP FOREIGN KEY `deleted_by_id_refs_id_56e9d00c`;
240 ALTER TABLE `question` ADD CONSTRAINT `deleted_by_id_refs_user_ptr_id_60d41818` FOREIGN KEY (`deleted_by_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
241 ALTER TABLE `question` DROP FOREIGN KEY `last_activity_by_id_refs_id_56e9d00c`;
242 ALTER TABLE `question` ADD CONSTRAINT `last_activity_by_id_refs_user_ptr_id_60d41818` FOREIGN KEY (`last_activity_by_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
243 ALTER TABLE `question` DROP FOREIGN KEY `last_edited_by_id_refs_id_56e9d00c`;
244 ALTER TABLE `question` ADD CONSTRAINT `last_edited_by_id_refs_user_ptr_id_60d41818` FOREIGN KEY (`last_edited_by_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
245 ALTER TABLE `question` DROP FOREIGN KEY `locked_by_id_refs_id_56e9d00c`;
246 ALTER TABLE `question` ADD CONSTRAINT `locked_by_id_refs_user_ptr_id_60d41818` FOREIGN KEY (`locked_by_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
248 ALTER TABLE `question_followed_by` DROP FOREIGN KEY `user_id_refs_id_6d30712d`;
249 ALTER TABLE `question_followed_by` ADD CONSTRAINT `user_id_refs_user_ptr_id_615e65af` FOREIGN KEY (`user_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
251 ALTER TABLE `question_revision` DROP FOREIGN KEY `author_id_refs_id_4f88024f`;
252 ALTER TABLE `question_revision` ADD CONSTRAINT `author_id_refs_user_ptr_id_42e3d48d` FOREIGN KEY (`author_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
254 ALTER TABLE `repute` DROP FOREIGN KEY `user_id_refs_id_5a426cd`;
255 ALTER TABLE `repute` ADD CONSTRAINT `user_id_refs_user_ptr_id_5ea9540f` FOREIGN KEY (`user_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
257 ALTER TABLE `tag` DROP FOREIGN KEY `created_by_id_refs_id_47205d6d`;
258 ALTER TABLE `tag` ADD CONSTRAINT `created_by_id_refs_user_ptr_id_417f3449` FOREIGN KEY (`created_by_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
259 ALTER TABLE `tag` DROP FOREIGN KEY `deleted_by_id_refs_id_47205d6d`;
260 ALTER TABLE `tag` ADD CONSTRAINT `deleted_by_id_refs_user_ptr_id_417f3449` FOREIGN KEY (`deleted_by_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
262 ALTER TABLE `vote` DROP FOREIGN KEY `user_id_refs_id_760a4df0`;
263 ALTER TABLE `vote` ADD CONSTRAINT `user_id_refs_user_ptr_id_18723e34` FOREIGN KEY (`user_id`) REFERENCES `forum_user` (`user_ptr_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
267 from django.core.management.base import NoArgsCommand
268 from django.db import connection, transaction
269 from django.conf import settings
271 class Command(NoArgsCommand):
272 def handle_noargs(self, **options):
273 if settings.DATABASE_ENGINE in ('postgresql_psycopg2', 'postgresql', ):
274 migration_query = PG_MIGRATION_QUERY
275 fkeys_query = PG_FKEYS_QUERY
276 elif settings.DATABASE_ENGINE == 'mysql':
277 migration_query = MYSQL_MIGRATION_QUERY
278 fkeys_query = MYSQL_FKEYS_QUERY
280 raise Exception("Database backend not suported by this migration command")
282 cursor = connection.cursor()
283 cursor.execute(migration_query)
284 cursor.execute(fkeys_query)
285 transaction.commit_unless_managed()