Changes between Version 24 and Version 25 of BackwardsIncompatibleChanges

Timestamp:

Oct 30, 2005, 8:48:48 AM (20 years ago)

Author:

anonymous

Comment:

sqlite < 3.2.0 doesn't support ALTER TABLE, so I added alternate instructions

BackwardsIncompatibleChanges

@@ -132 +132 @@
 
  * Execute this SQL command: {{{ALTER TABLE auth_admin_log RENAME TO django_admin_log;}}}
+ * If you're using an SQLite version older than 3.2.0 (no ALTER TABLE support), execute these SQL commands (following [http://www.sqlite.org/faq.html#q13 this pattern]):
+   {{{
+   BEGIN TRANSACTION;
+   CREATE TEMPORARY TABLE auth_backup(id, action_time, user_id, content_type_id, object_id, object_repr, action_flag, change_message);
+   INSERT INTO auth_backup SELECT id, action_time, user_id, content_type_id, object_id, object_repr, action_flag, change_message FROM auth_admin_log;
+   DROP TABLE auth_admin_log;
+   CREATE TABLE django_admin_log(id, action_time, user_id, content_type_id, object_id, object_repr, action_flag, change_message);
+   INSERT INTO django_admin_log SELECT id, action_time, user_id, content_type_id, object_id, object_repr, action_flag, change_message FROM auth_backup;
+   DROP TABLE t1_backup;
+   COMMIT; 
+   }}}
  * If you're using PostgreSQL, execute these SQL commands:
    {{{