Changes between Version 53 and Version 54 of BackwardsIncompatibleChanges


Ignore:
Timestamp:
11/29/2005 10:01:18 AM (9 years ago)
Author:
pb@…
Comment:

corrected "if you want to use flatfiles" for MySQL users

Legend:

Unmodified
Added
Removed
Modified
  • BackwardsIncompatibleChanges

    v53 v54  
    255255==== If you want to use flatfiles ====
    256256
    257  * Execute the following SQL:
     257 * If you're using PostgreSQL, execute the following:
    258258   {{{
    259259   ALTER TABLE flatfiles RENAME TO django_flatpages;
     
    263263   UPDATE content_types SET package = 'flatpages', python_module_name = 'flatpages' WHERE package = 'core' AND python_module_name = 'flatfiles';
    264264   UPDATE auth_permissions SET package = 'flatpages' WHERE package = 'core' AND codename IN ('add_flatfile', 'change_flatfile', 'delete_flatfile');
    265    }}}
    266  * If you're using PostgreSQL, execute this additional SQL:
    267    {{{
    268265   ALTER TABLE flatfiles_id_seq RENAME TO django_flatpages_id_seq;
    269266   ALTER TABLE django_flatpages ALTER COLUMN id DROP DEFAULT;
    270267   ALTER TABLE django_flatpages ALTER COLUMN id SET DEFAULT nextval('public.django_flatpages_id_seq'::text);
     268   }}}
     269 * If you're using MySQL, execute the following:
     270   {{{
     271   ALTER TABLE flatfiles RENAME TO django_flatpages;
     272   ALTER TABLE flatfiles_sites RENAME TO django_flatpages_sites;
     273   ALTER TABLE django_flatpages_sites CHANGE flatfile_id flatpage_id INTEGER;
     274   INSERT INTO packages (label, name) VALUES ('flatpages', 'flatpages');
     275   UPDATE content_types SET package = 'flatpages', python_module_name = 'flatpages' WHERE package = 'core' AND python_module_name = 'flatfiles';
     276   UPDATE auth_permissions SET package = 'flatpages' WHERE package = 'core' AND codename IN ('add_flatfile', 'change_flatfile', 'delete_flatfile');
    271277   }}}
    272278 * If you have a {{{flatfiles/default.html}}} template, rename it to {{{flatpages/default.html}}}.
Back to Top