Changes between Version 106 and Version 107 of RemovingTheMagic

Timestamp:

Apr 23, 2006, 10:45:38 PM (19 years ago)

Author:

Ken Kennedy <kkennedy@…>

Comment:

This is NOT complete. There are data issues, and still a column change to deal with in SQLite properly.

RemovingTheMagic

@@ -47 +47 @@
 === Rename core database tables ===
 
-We've renamed a bunch of the core Django tables. To upgrade in MySQL and SQLite, execute this SQL in your database:
+We've renamed a bunch of the core Django tables. Due to functionality differences between the various database backends, the SQL to perform the necessary tasks varies slightly between engines. 
+
+To upgrade in SQLite, execute this SQL in your database (some steps are more involved because SQLite has only limited ALTER TABLE functionality. We have to instead create working tables, move the data, and then replace the old tables with the new ones:
+
+{{{
+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 sites RENAME TO django_site;
+
+CREATE TABLE "django_content_type_new"  (
+"id" integer NOT NULL PRIMARY KEY,
+"name" varchar(100) NOT NULL,
+"app_label" varchar(100) NOT NULL,
+"model" varchar(100) NOT NULL,
+UNIQUE ("app_label", "model")
+);
+
+INSERT INTO django_content_type_new
+(id,name,app_label,model)
+SELECT id,name,package,python_module_name
+FROM django_content_type;
+
+
+ALTER TABLE django_content_type rename to django_content_type_old;
+ALTER TABLE django_content_type_new rename to django_content_type; 
+
+DROP TABLE django_content_type_old; 
+
+DROP TABLE packages;
+
+
+ALTER TABLE auth_permission ADD COLUMN content_type_id INTEGER;
+}}}
+
+To upgrade in MySQL , execute this SQL in your database:
 
 {{{