Changes between Version 25 and Version 26 of BackwardsIncompatibleChanges


Ignore:
Timestamp:
Oct 30, 2005, 9:11:12 AM (19 years ago)
Author:
anonymous
Comment:

fixed (hopefully) sqlite ALTER TABLE hack

Legend:

Unmodified
Added
Removed
Modified

  • BackwardsIncompatibleChanges

    v25 v26  
    135135   {{{
    136136   BEGIN TRANSACTION;
    137    CREATE TEMPORARY TABLE auth_backup(id, action_time, user_id, content_type_id, object_id, object_repr, action_flag, change_message);
     137   CREATE TEMPORARY TABLE auth_backup (
     138    id integer NOT NULL PRIMARY KEY,
     139    action_time datetime NOT NULL,
     140    user_id integer NOT NULL REFERENCES auth_users (id),
     141    content_type_id integer NULL REFERENCES content_types (id),
     142    object_id text NULL,
     143    object_repr varchar(200) NOT NULL,
     144    action_flag smallint unsigned NOT NULL,
     145    change_message text NOT NULL
     146   );
    138147   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;
    139148   DROP TABLE auth_admin_log;
    140    CREATE TABLE django_admin_log(id, action_time, user_id, content_type_id, object_id, object_repr, action_flag, change_message);
     149   CREATE TABLE django_admin_log (
     150    id integer NOT NULL PRIMARY KEY,
     151    action_time datetime NOT NULL,
     152    user_id integer NOT NULL REFERENCES auth_users (id),
     153    content_type_id integer NULL REFERENCES content_types (id),
     154    object_id text NULL,
     155    object_repr varchar(200) NOT NULL,
     156    action_flag smallint unsigned NOT NULL,
     157    change_message text NOT NULL
     158   );
    141159   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;
    142    DROP TABLE t1_backup;
     160   DROP TABLE auth_backup;
    143161   COMMIT;
    144162   }}}
Back to Top