Changes between Version 152 and Version 153 of RemovingTheMagic

Timestamp:

May 30, 2006, 9:46:26 AM (18 years ago)

Author:

Adrian Holovaty

Comment:

Added "Changes to the SQL for the comments app" section

RemovingTheMagic

@@ -211 +211 @@
 }}}
 
+=== Changes to the SQL for the comments app ===
+
+The comments app, still undocumented, also requires some database changes.
+
+In PostgreSQL:
+{{{
+BEGIN;
+ALTER TABLE comments RENAME TO comments_comment;
+ALTER TABLE comments_id_seq RENAME TO comments_comment_id_seq;
+
+ALTER TABLE comments_karma RENAME TO comments_karmascore;
+ALTER TABLE comments_karma_id_seq RENAME TO comments_karmascore_id_seq;
+
+ALTER TABLE comments_free RENAME TO comments_freecomment;
+ALTER TABLE comments_free_id_seq RENAME TO comments_freecomment_id_seq;
+
+ALTER TABLE comments_moderator_deletions RENAME TO comments_moderatordeletion;
+ALTER TABLE comments_moderator_deletions_id_seq RENAME TO comments_moderatordeletion_id_seq;
+
+ALTER TABLE comments_user_flags RENAME TO comments_userflag;
+ALTER TABLE comments_user_flags_id_seq RENAME TO comments_userflag_id_seq;
+
+COMMIT;
+}}}
+
+In other databases:
+{{{
+ALTER TABLE comments RENAME TO comments_comment;
+ALTER TABLE comments_karma RENAME TO comments_karmascore;
+ALTER TABLE comments_free RENAME TO comments_freecomment;
+ALTER TABLE comments_moderator_deletions RENAME TO comments_moderatordeletion;
+ALTER TABLE comments_user_flags RENAME TO comments_userflag;
+}}}
+
 === Auth_permissions case changes ===
 
@@ -240 +274 @@
 UPDATE django_content_type SET name='user' WHERE model='users';
 }}}
-
-'''User 'garthk' also found some problem with the {{{.module}}}/{{{.model}}} renaming stuff above, which he fixed manually, and followed up with some fixes for the Django comments system in case you're getting exceptions telling you that "Table appname.comments_comment does not exist".'''
-
-{{{
-ALTER TABLE comments RENAME TO comments_comment;
-ALTER TABLE comments_karma RENAME TO comments_karmascore;
-ALTER TABLE comments_free RENAME TO comments_freecomment;
-ALTER TABLE comments_moderator_deletions RENAME TO comments_moderatordeletion;
-ALTER TABLE comments_user_flags RENAME TO comments_userflag;
-}}}
-
 
 === Database table-naming scheme has been changed ===