Changes between Version 154 and Version 155 of RemovingTheMagic

Timestamp:

Jun 6, 2006, 10:11:25 AM (19 years ago)

Author:

Rajesh Dhawan <rajesh.dhawan@…>

Comment:

Suggested fix for auth_permissions.package problem in SQLite

RemovingTheMagic

@@ -273 +273 @@
 UPDATE django_content_type SET name='group' WHERE model='groups';
 UPDATE django_content_type SET name='user' WHERE model='users';
+}}}
+
+=== SQLite: Drop Auth_permission.Package column ===
+
+'''User 'Rajesh Dhawan' notes that, in SQLite, the Foreign Key reference on column {{{package}}} from the {{{auth_permissions}}} table still causes problems after following all the above database conversions. Executing the following conversion routine eliminates the {{{package}}} column (SQLite doesn't support dropping of columns):'''
+
+{{{
+CREATE TABLE "auth_permission_new" (
+    "id" integer NOT NULL PRIMARY KEY,
+    "name" varchar(50) NOT NULL,
+    "content_type_id" integer,
+    "codename" varchar(100) NOT NULL,
+    UNIQUE ("content_type_id", "codename")
+);
+
+
+insert into auth_permission_new
+(id, name, codename)
+select id, name, codename
+from auth_permission;
+
+alter table auth_permission rename to auth_permission_old;
+alter table auth_permission_new rename to auth_permission;
+
+drop table auth_permission_old;
 }}}