Changes between Version 43 and Version 44 of RemovingTheMagic

Timestamp:

Jan 22, 2006, 9:00:04 PM (19 years ago)

Author:

Adrian Holovaty

Comment:

Added notes about database table name changes.

RemovingTheMagic

@@ -446 +446 @@
  * New: {{{from django.conf import settings}}}
 
-== Database table-name changes ==
-
-Renamed {{{core_sessions}}} table to {{{django_sessions}}}. To change, execute this SQL in your database:
-
-{{{
-ALTER TABLE core_sessions RENAME TO django_sessions;
-}}}
+== Renamed core database tables ==
+
+'''Status: Done'''
+
+Renamed a bunch of the code Django tables. To upgrade, execute this SQL in your database:
+
+{{{
+ALTER TABLE auth_groups RENAME TO auth_group;
+ALTER TABLE auth_groups_permissions RENAME TO auth_group_permissions;
+ALTER TABLE auth_messages RENAME TO auth_message;
+ALTER TABLE auth_permissions RENAME TO auth_permission;
+ALTER TABLE auth_users RENAME TO auth_user;
+ALTER TABLE auth_users_groups RENAME TO auth_user_groups;
+ALTER TABLE auth_users_user_permissions RENAME TO auth_user_user_permissions;
+ALTER TABLE content_types RENAME TO django_content_type;
+ALTER TABLE core_sessions RENAME TO django_session;
+ALTER TABLE django_flatpages RENAME TO django_flatpage;
+ALTER TABLE django_flatpages_sites RENAME TO django_flatpage_sites;
+ALTER TABLE django_redirects RENAME TO django_redirect;
+ALTER TABLE packages RENAME TO django_package;
+ALTER TABLE sites RENAME TO django_site;
+}}}
+
+== Changed database table naming scheme ==
+
+Database table names formerly were created by joining the app_label and module_name. Example: {{{polls_polls}}}.
+
+Because there's no longer any pluralization, database table names are now formed by joining the app_label and model name (singular). Example: {{{polls_poll}}}.
+
+As always, this behavior can be overridden on a per-model basis by specifying the {{{db_table}}} attribute in {{{class Meta}}} in your model.
+
+To upgrade, you'll either have to explicitly set {{{db_table}}} in your models or rename your database tables to fit the new naming scheme Django expects.
 
 == Change subclassing syntax ==