Changes between Version 53 and Version 54 of BackwardsIncompatibleChanges

Timestamp:

Nov 29, 2005, 10:01:18 AM (18 years ago)

Author:

pb@…

Comment:

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

BackwardsIncompatibleChanges

@@ -255 +255 @@
 ==== If you want to use flatfiles ====
 
- * Execute the following SQL:
+ * If you're using PostgreSQL, execute the following:
    {{{
    ALTER TABLE flatfiles RENAME TO django_flatpages;
@@ -263 +263 @@
    UPDATE content_types SET package = 'flatpages', python_module_name = 'flatpages' WHERE package = 'core' AND python_module_name = 'flatfiles';
    UPDATE auth_permissions SET package = 'flatpages' WHERE package = 'core' AND codename IN ('add_flatfile', 'change_flatfile', 'delete_flatfile');
-   }}}
- * If you're using PostgreSQL, execute this additional SQL:
-   {{{
    ALTER TABLE flatfiles_id_seq RENAME TO django_flatpages_id_seq;
    ALTER TABLE django_flatpages ALTER COLUMN id DROP DEFAULT;
    ALTER TABLE django_flatpages ALTER COLUMN id SET DEFAULT nextval('public.django_flatpages_id_seq'::text);
+   }}}
+ * If you're using MySQL, execute the following:
+   {{{
+   ALTER TABLE flatfiles RENAME TO django_flatpages;
+   ALTER TABLE flatfiles_sites RENAME TO django_flatpages_sites;
+   ALTER TABLE django_flatpages_sites CHANGE flatfile_id flatpage_id INTEGER;
+   INSERT INTO packages (label, name) VALUES ('flatpages', 'flatpages');
+   UPDATE content_types SET package = 'flatpages', python_module_name = 'flatpages' WHERE package = 'core' AND python_module_name = 'flatfiles';
+   UPDATE auth_permissions SET package = 'flatpages' WHERE package = 'core' AND codename IN ('add_flatfile', 'change_flatfile', 'delete_flatfile');
    }}}
  * If you have a {{{flatfiles/default.html}}} template, rename it to {{{flatpages/default.html}}}.