Created
July 13, 2009 08:17
-
-
Save beniwohli/145995 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $ ./manage.py syncdb | |
| /var/lib/python-support/python2.6/MySQLdb/__init__.py:34: DeprecationWarning: the sets module is deprecated | |
| from sets import ImmutableSet | |
| Syncing... | |
| Creating table auth_permission | |
| Creating table auth_group | |
| Creating table auth_user | |
| Creating table auth_message | |
| Creating table django_content_type | |
| Creating table django_session | |
| Creating table django_admin_log | |
| Creating table django_site | |
| Creating table south_migrationhistory | |
| Creating table cmsplugin_store | |
| Creating table store_storeitem | |
| Creating table cmsplugin_storepublic | |
| Creating table store_storeitempublic | |
| You just installed Django's auth system, which means you don't have any superusers defined. | |
| Would you like to create one now? (yes/no): no | |
| Installing index for auth.Permission model | |
| Installing index for auth.Message model | |
| Installing index for admin.LogEntry model | |
| Installing index for store.StoreItem model | |
| Installing index for store.StoreItemPublic model | |
| Synced: | |
| > django.contrib.auth | |
| > django.contrib.contenttypes | |
| > django.contrib.sessions | |
| > django.contrib.admin | |
| > django.contrib.sites | |
| > mptt | |
| > south | |
| > sampleapp | |
| > store | |
| > publisher | |
| Not synced (use migrations): | |
| - cms | |
| - cms.plugins.text | |
| - cms.plugins.picture | |
| - cms.plugins.file | |
| - cms.plugins.flash | |
| - cms.plugins.link | |
| - cms.plugins.snippet | |
| - cms.plugins.googlemap | |
| - cms.plugins.teaser | |
| (use ./manage.py migrate to migrate these) | |
| $ ./manage.py migrate | |
| /var/lib/python-support/python2.6/MySQLdb/__init__.py:34: DeprecationWarning: the sets module is deprecated | |
| from sets import ImmutableSet | |
| Running migrations for cms: | |
| - Migrating forwards to 0020_advanced_permissions. | |
| > cms: 0001_initial | |
| = CREATE TABLE `cms_cmsplugin` (`language` varchar(3) NOT NULL, `page_id` integer NOT NULL, `position` smallint UNSIGNED NOT NULL DEFAULT 0, `creation_date` datetime NOT NULL DEFAULT '2009-07-13 03:18:00.820455', `placeholder` varchar(50) NOT NULL, `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `plugin_type` varchar(50) NOT NULL); [] | |
| = CREATE TABLE `cms_title` (`language` varchar(3) NOT NULL, `title` varchar(255) NOT NULL, `page_id` integer NOT NULL, `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `path` varchar(255) NOT NULL, `creation_date` datetime NOT NULL DEFAULT '2009-07-13 03:18:00.840214', `slug` varchar(255) NOT NULL); [] | |
| = CREATE TABLE `cms_pagepermission` (`everybody` bool NOT NULL DEFAULT False, `can_edit` bool NOT NULL DEFAULT True, `group_id` integer NULL, `can_publish` bool NOT NULL DEFAULT True, `page_id` integer NULL, `user_id` integer NULL, `type` integer NOT NULL DEFAULT 0, `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `can_change_softroot` bool NOT NULL DEFAULT False); [] | |
| = CREATE TABLE `cms_page` (`status` integer NOT NULL DEFAULT 0, `rght` integer UNSIGNED NOT NULL, `level` integer UNSIGNED NOT NULL, `navigation_extenders` varchar(80) NULL, `has_url_overwrite` bool NOT NULL DEFAULT False, `url_overwrite` varchar(80) NULL, `parent_id` integer NULL, `author_id` integer NOT NULL, `reverse_id` varchar(40) NULL, `login_required` bool NOT NULL DEFAULT False, `soft_root` bool NOT NULL DEFAULT False, `creation_date` datetime NOT NULL DEFAULT '2009-07-13 03:18:00.846623', `lft` integer UNSIGNED NOT NULL, `publication_end_date` datetime NULL, `template` varchar(100) NOT NULL, `tree_id` integer UNSIGNED NOT NULL, `publication_date` datetime NULL, `in_navigation` bool NOT NULL DEFAULT True, `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY); [] | |
| = CREATE TABLE `cms_placeholder` (`body` longtext NULL, `language` varchar(3) NOT NULL, `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `name` varchar(50) NOT NULL, `page_id` integer NOT NULL); [] | |
| = CREATE TABLE `cms_page_sites` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `page_id` integer NOT NULL, `site_id` integer NOT NULL); [] | |
| = CREATE INDEX `cms_cmsplugin_language` ON `cms_cmsplugin` (`language`); [] | |
| = ALTER TABLE `cms_cmsplugin` ADD CONSTRAINT `page_id_refs_id_a9b9f07acd5bfb9` FOREIGN KEY (`page_id`) REFERENCES `cms_page` (`id`); [] | |
| = CREATE INDEX `cms_cmsplugin_page_id` ON `cms_cmsplugin` (`page_id`); [] | |
| = CREATE INDEX `cms_cmsplugin_placeholder` ON `cms_cmsplugin` (`placeholder`); [] | |
| = CREATE INDEX `cms_cmsplugin_plugin_type` ON `cms_cmsplugin` (`plugin_type`); [] | |
| = CREATE INDEX `cms_title_language` ON `cms_title` (`language`); [] | |
| = ALTER TABLE `cms_title` ADD CONSTRAINT `page_id_refs_id_772ba48efc98665f` FOREIGN KEY (`page_id`) REFERENCES `cms_page` (`id`); [] | |
| = CREATE INDEX `cms_title_page_id` ON `cms_title` (`page_id`); [] | |
| = CREATE INDEX `cms_title_path` ON `cms_title` (`path`); [] | |
| = CREATE INDEX `cms_title_slug` ON `cms_title` (`slug`); [] | |
| = ALTER TABLE `cms_pagepermission` ADD CONSTRAINT `group_id_refs_id_4b6b4203d3639033` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`); [] | |
| = CREATE INDEX `cms_pagepermission_group_id` ON `cms_pagepermission` (`group_id`); [] | |
| = ALTER TABLE `cms_pagepermission` ADD CONSTRAINT `page_id_refs_id_77f67714d31a36ca` FOREIGN KEY (`page_id`) REFERENCES `cms_page` (`id`); [] | |
| = CREATE INDEX `cms_pagepermission_page_id` ON `cms_pagepermission` (`page_id`); [] | |
| = ALTER TABLE `cms_pagepermission` ADD CONSTRAINT `user_id_refs_id_280a94e34f0ab76c` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); [] | |
| = CREATE INDEX `cms_pagepermission_user_id` ON `cms_pagepermission` (`user_id`); [] | |
| = CREATE INDEX `cms_page_status` ON `cms_page` (`status`); [] | |
| = CREATE INDEX `cms_page_rght` ON `cms_page` (`rght`); [] | |
| = CREATE INDEX `cms_page_level` ON `cms_page` (`level`); [] | |
| = CREATE INDEX `cms_page_navigation_extenders` ON `cms_page` (`navigation_extenders`); [] | |
| = CREATE INDEX `cms_page_has_url_overwrite` ON `cms_page` (`has_url_overwrite`); [] | |
| = CREATE INDEX `cms_page_url_overwrite` ON `cms_page` (`url_overwrite`); [] | |
| = ALTER TABLE `cms_page` ADD CONSTRAINT `parent_id_refs_id_122ab180653a773` FOREIGN KEY (`parent_id`) REFERENCES `cms_page` (`id`); [] | |
| = CREATE INDEX `cms_page_parent_id` ON `cms_page` (`parent_id`); [] | |
| = ALTER TABLE `cms_page` ADD CONSTRAINT `author_id_refs_id_30ed19c7430a69ef` FOREIGN KEY (`author_id`) REFERENCES `auth_user` (`id`); [] | |
| = CREATE INDEX `cms_page_author_id` ON `cms_page` (`author_id`); [] | |
| = CREATE INDEX `cms_page_reverse_id` ON `cms_page` (`reverse_id`); [] | |
| = CREATE INDEX `cms_page_soft_root` ON `cms_page` (`soft_root`); [] | |
| = CREATE INDEX `cms_page_lft` ON `cms_page` (`lft`); [] | |
| = CREATE INDEX `cms_page_publication_end_date` ON `cms_page` (`publication_end_date`); [] | |
| = CREATE INDEX `cms_page_tree_id` ON `cms_page` (`tree_id`); [] | |
| = CREATE INDEX `cms_page_publication_date` ON `cms_page` (`publication_date`); [] | |
| = CREATE INDEX `cms_page_in_navigation` ON `cms_page` (`in_navigation`); [] | |
| = CREATE INDEX `cms_placeholder_language` ON `cms_placeholder` (`language`); [] | |
| = CREATE INDEX `cms_placeholder_name` ON `cms_placeholder` (`name`); [] | |
| = ALTER TABLE `cms_placeholder` ADD CONSTRAINT `page_id_refs_id_5527b13f4450cc54` FOREIGN KEY (`page_id`) REFERENCES `cms_page` (`id`); [] | |
| = CREATE INDEX `cms_placeholder_page_id` ON `cms_placeholder` (`page_id`); [] | |
| = ALTER TABLE `cms_page_sites` ADD CONSTRAINT `page_id_refs_id_382605665febd886` FOREIGN KEY (`page_id`) REFERENCES `cms_page` (`id`); [] | |
| = CREATE INDEX `cms_page_sites_page_id` ON `cms_page_sites` (`page_id`); [] | |
| = ALTER TABLE `cms_page_sites` ADD CONSTRAINT `site_id_refs_id_57aa8d80b2133507` FOREIGN KEY (`site_id`) REFERENCES `django_site` (`id`); [] | |
| = CREATE INDEX `cms_page_sites_site_id` ON `cms_page_sites` (`site_id`); [] | |
| > cms: 0002_auto_start | |
| > cms: 0003_remove_placeholder | |
| = DROP TABLE `cms_placeholder` CASCADE; [] | |
| > cms: 0004_textobjects | |
| = ALTER TABLE `cms_cmsplugin` ; [] | |
| = ALTER TABLE `cms_cmsplugin` ALTER COLUMN `position` DROP DEFAULT; [] | |
| = ALTER TABLE `cms_cmsplugin` MODIFY `position` smallint NULL;; [] | |
| = ALTER TABLE `cms_cmsplugin` ADD COLUMN `parent_id` integer NULL; [] | |
| = ALTER TABLE `cms_cmsplugin` ADD CONSTRAINT `parent_id_refs_id_4f240e19e0b32a03` FOREIGN KEY (`parent_id`) REFERENCES `cms_cmsplugin` (`id`); [] | |
| = CREATE INDEX `cms_cmsplugin_parent_id` ON `cms_cmsplugin` (`parent_id`); [] | |
| > cms: 0005_mptt_added_to_plugins | |
| = ALTER TABLE `cms_cmsplugin` ADD COLUMN `tree_id` integer UNSIGNED NOT NULL; [] | |
| = ALTER TABLE `cms_cmsplugin` ADD COLUMN `lft` integer UNSIGNED NOT NULL; [] | |
| = ALTER TABLE `cms_cmsplugin` ADD COLUMN `rght` integer UNSIGNED NOT NULL; [] | |
| = ALTER TABLE `cms_cmsplugin` ADD COLUMN `level` integer UNSIGNED NOT NULL; [] | |
| = CREATE INDEX `cms_cmsplugin_tree_id` ON `cms_cmsplugin` (`tree_id`); [] | |
| = CREATE INDEX `cms_cmsplugin_lft` ON `cms_cmsplugin` (`lft`); [] | |
| = CREATE INDEX `cms_cmsplugin_rght` ON `cms_cmsplugin` (`rght`); [] | |
| = CREATE INDEX `cms_cmsplugin_level` ON `cms_cmsplugin` (`level`); [] | |
| > cms: 0006_apphook | |
| = ALTER TABLE `cms_title` ADD COLUMN `has_url_overwrite` bool NOT NULL DEFAULT False; [] | |
| = ALTER TABLE `cms_title` ADD COLUMN `application_urls` varchar(32) NULL; [] | |
| = ALTER TABLE `cms_page` DROP COLUMN `has_url_overwrite` CASCADE; [] | |
| = ALTER TABLE `cms_page` DROP COLUMN `url_overwrite` CASCADE; [] | |
| = ALTER TABLE `cms_page` ; [] | |
| = ALTER TABLE `cms_page` ALTER COLUMN `status` SET DEFAULT %s ; [0] | |
| = ALTER TABLE `cms_page` MODIFY `status` integer NOT NULL;; [] | |
| = ALTER TABLE `cms_page` ; [] | |
| = ALTER TABLE `cms_page` ALTER COLUMN `reverse_id` DROP DEFAULT; [] | |
| = ALTER TABLE `cms_page` MODIFY `reverse_id` varchar(40) NULL;; [] | |
| = CREATE INDEX `cms_title_has_url_overwrite` ON `cms_title` (`has_url_overwrite`); [] | |
| = CREATE INDEX `cms_title_application_urls` ON `cms_title` (`application_urls`); [] | |
| > cms: 0007_apphook_longer | |
| = ALTER TABLE `cms_title` ; [] | |
| = ALTER TABLE `cms_title` ALTER COLUMN `application_urls` DROP DEFAULT; [] | |
| = ALTER TABLE `cms_title` MODIFY `application_urls` varchar(200) NULL;; [] | |
| > cms: 0008_redirects | |
| = ALTER TABLE `cms_title` ADD COLUMN `redirect` varchar(255) NULL; [] | |
| > cms: 0009_added_meta_fields | |
| = ALTER TABLE `cms_title` ADD COLUMN `meta_keywords` varchar(255) NULL; [] | |
| = ALTER TABLE `cms_title` ADD COLUMN `meta_description` longtext NULL; [] | |
| > cms: 0010_5char_language | |
| = ALTER TABLE `cms_title` ; [] | |
| = ALTER TABLE `cms_title` ALTER COLUMN `language` DROP DEFAULT; [] | |
| = ALTER TABLE `cms_title` MODIFY `language` varchar(5) NOT NULL;; [] | |
| = ALTER TABLE `cms_cmsplugin` ; [] | |
| = ALTER TABLE `cms_cmsplugin` ALTER COLUMN `language` DROP DEFAULT; [] | |
| = ALTER TABLE `cms_cmsplugin` MODIFY `language` varchar(5) NOT NULL;; [] | |
| > cms: 0011_title_overwrites | |
| = ALTER TABLE `cms_title` ADD COLUMN `page_title` varchar(255) NULL; [] | |
| = ALTER TABLE `cms_title` ADD COLUMN `menu_title` varchar(255) NULL; [] | |
| > cms: 0012_publisher | |
| = CREATE TABLE `cms_publiccmsplugin` (`rght` integer UNSIGNED NOT NULL, `parent_id` integer NULL, `language` varchar(5) NOT NULL, `level` integer UNSIGNED NOT NULL, `mark_delete` bool NOT NULL DEFAULT False, `page_id` integer NOT NULL, `lft` integer UNSIGNED NOT NULL, `tree_id` integer UNSIGNED NOT NULL, `position` smallint UNSIGNED NULL, `creation_date` datetime NOT NULL DEFAULT '2009-06-29 09:02:15.178714', `placeholder` varchar(50) NOT NULL, `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `plugin_type` varchar(50) NOT NULL); [] | |
| = CREATE TABLE `cms_pageuser` (`user_ptr_id` integer NOT NULL PRIMARY KEY, `created_by_id` integer NOT NULL); [] | |
| = CREATE TABLE `cms_publictitle` (`menu_title` varchar(255) NULL, `redirect` varchar(255) NULL, `meta_keywords` varchar(255) NULL, `page_title` varchar(255) NULL, `language` varchar(5) NOT NULL, `title` varchar(255) NOT NULL, `has_url_overwrite` bool NOT NULL DEFAULT False, `application_urls` varchar(200) NULL, `creation_date` datetime NOT NULL DEFAULT '2009-06-29 09:02:15.525211', `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `path` varchar(255) NOT NULL, `meta_description` longtext NULL, `slug` varchar(255) NOT NULL, `mark_delete` bool NOT NULL DEFAULT False, `page_id` integer NOT NULL); [] | |
| = CREATE TABLE `cms_globalpagepermission` (`can_publish` bool NOT NULL DEFAULT True, `group_id` integer NULL, `can_moderate` bool NOT NULL DEFAULT True, `can_change` bool NOT NULL DEFAULT True, `can_change_permissions` bool NOT NULL DEFAULT False, `can_recover_page` bool NOT NULL DEFAULT True, `can_add` bool NOT NULL DEFAULT True, `user_id` integer NULL, `can_delete` bool NOT NULL DEFAULT True, `can_move_page` bool NOT NULL DEFAULT True, `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `can_change_softroot` bool NOT NULL DEFAULT False); [] | |
| = CREATE TABLE `cms_publicpage` (`rght` integer UNSIGNED NOT NULL, `level` integer UNSIGNED NOT NULL, `navigation_extenders` varchar(80) NULL, `parent_id` integer NULL, `author_id` integer NOT NULL, `reverse_id` varchar(40) NULL, `login_required` bool NOT NULL DEFAULT False, `mark_delete` bool NOT NULL DEFAULT False, `site_id` integer NOT NULL, `soft_root` bool NOT NULL DEFAULT False, `creation_date` datetime NOT NULL DEFAULT '2009-06-29 09:02:16.369082', `lft` integer UNSIGNED NOT NULL, `publication_end_date` datetime NULL, `moderator_state` smallint NOT NULL DEFAULT 1, `template` varchar(100) NOT NULL, `published` bool NOT NULL DEFAULT False, `tree_id` integer UNSIGNED NOT NULL, `publication_date` datetime NULL, `in_navigation` bool NOT NULL DEFAULT True, `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY); [] | |
| = CREATE TABLE `cms_pagemoderator` (`moderate_page` bool NOT NULL DEFAULT False, `moderate_children` bool NOT NULL DEFAULT False, `page_id` integer NOT NULL, `user_id` integer NOT NULL, `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `moderate_descendants` bool NOT NULL DEFAULT False); [] | |
| = CREATE TABLE `cms_pagemoderatorstate` (`created` datetime NOT NULL, `page_id` integer NOT NULL, `user_id` integer NULL, `action` varchar(3) NULL, `message` longtext NULL, `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY); [] | |
| = CREATE TABLE `cms_pageusergroup` (`group_ptr_id` integer NOT NULL PRIMARY KEY, `created_by_id` integer NOT NULL); [] | |
| = ALTER TABLE `cms_pagepermission` ADD COLUMN `can_delete` bool NOT NULL DEFAULT True; [] | |
| = ALTER TABLE `cms_page` ADD COLUMN `moderator_state` smallint NOT NULL DEFAULT 1; [] | |
| = ALTER TABLE `cms_page` ADD COLUMN `published` bool NOT NULL DEFAULT False; [] | |
| = ALTER TABLE `cms_page` ADD COLUMN `site_id` integer NOT NULL; [] | |
| = ALTER TABLE `cms_cmsplugin` ADD COLUMN `inherited_public_id` integer NULL UNIQUE; [] | |
| = ALTER TABLE `cms_pagepermission` ADD COLUMN `can_change_permissions` bool NOT NULL DEFAULT False; [] | |
| = ALTER TABLE `cms_pagepermission` ADD COLUMN `can_moderate` bool NOT NULL DEFAULT True; [] | |
| = ALTER TABLE `cms_pagepermission` ADD COLUMN `can_add` bool NOT NULL DEFAULT True; [] | |
| = ALTER TABLE `cms_page` ADD COLUMN `public_id` integer NULL UNIQUE; [] | |
| = ALTER TABLE `cms_pagepermission` ADD COLUMN `grant_on` integer NOT NULL DEFAULT 5; [] | |
| = ALTER TABLE `cms_pagepermission` ADD COLUMN `can_move_page` bool NOT NULL DEFAULT True; [] | |
| = ALTER TABLE `cms_title` ADD COLUMN `public_id` integer NULL UNIQUE; [] | |
| = ALTER TABLE `cms_pagepermission` ADD COLUMN `can_change` bool NOT NULL DEFAULT True; [] | |
| = ALTER TABLE `cms_pagepermission` DROP COLUMN `everybody` CASCADE; [] | |
| = ALTER TABLE `cms_pagepermission` DROP COLUMN `type` CASCADE; [] | |
| = ALTER TABLE `cms_page` DROP COLUMN `status` CASCADE; [] | |
| = ALTER TABLE `cms_pagepermission` DROP COLUMN `can_edit` CASCADE; [] | |
| = ALTER TABLE `cms_publictitle` ADD CONSTRAINT `cms_publictitle_language_9f6427dde8710c6` UNIQUE (`language`, `page_id`) [] | |
| = CREATE INDEX `cms_publiccmsplugin_rght` ON `cms_publiccmsplugin` (`rght`); [] | |
| = ALTER TABLE `cms_publiccmsplugin` ADD CONSTRAINT `parent_id_refs_id_63b4d88ea318ac67` FOREIGN KEY (`parent_id`) REFERENCES `cms_publiccmsplugin` (`id`); [] | |
| = CREATE INDEX `cms_publiccmsplugin_parent_id` ON `cms_publiccmsplugin` (`parent_id`); [] | |
| = CREATE INDEX `cms_publiccmsplugin_language` ON `cms_publiccmsplugin` (`language`); [] | |
| = CREATE INDEX `cms_publiccmsplugin_level` ON `cms_publiccmsplugin` (`level`); [] | |
| = ALTER TABLE `cms_publiccmsplugin` ADD CONSTRAINT `page_id_refs_id_43d4908c0735fbaf` FOREIGN KEY (`page_id`) REFERENCES `cms_publicpage` (`id`); [] | |
| = CREATE INDEX `cms_publiccmsplugin_page_id` ON `cms_publiccmsplugin` (`page_id`); [] | |
| = CREATE INDEX `cms_publiccmsplugin_lft` ON `cms_publiccmsplugin` (`lft`); [] | |
| = CREATE INDEX `cms_publiccmsplugin_tree_id` ON `cms_publiccmsplugin` (`tree_id`); [] | |
| = CREATE INDEX `cms_publiccmsplugin_placeholder` ON `cms_publiccmsplugin` (`placeholder`); [] | |
| = CREATE INDEX `cms_publiccmsplugin_plugin_type` ON `cms_publiccmsplugin` (`plugin_type`); [] | |
| = ALTER TABLE `cms_pageuser` ADD CONSTRAINT `user_ptr_id_refs_id_23321fd516b8b1ea` FOREIGN KEY (`user_ptr_id`) REFERENCES `auth_user` (`id`); [] | |
| = ALTER TABLE `cms_pageuser` ADD CONSTRAINT `created_by_id_refs_id_23321fd516b8b1ea` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`); [] | |
| = CREATE INDEX `cms_pageuser_created_by_id` ON `cms_pageuser` (`created_by_id`); [] | |
| = CREATE INDEX `cms_publictitle_language` ON `cms_publictitle` (`language`); [] | |
| = CREATE INDEX `cms_publictitle_has_url_overwrite` ON `cms_publictitle` (`has_url_overwrite`); [] | |
| = CREATE INDEX `cms_publictitle_application_urls` ON `cms_publictitle` (`application_urls`); [] | |
| = CREATE INDEX `cms_publictitle_path` ON `cms_publictitle` (`path`); [] | |
| = CREATE INDEX `cms_publictitle_slug` ON `cms_publictitle` (`slug`); [] | |
| = ALTER TABLE `cms_publictitle` ADD CONSTRAINT `page_id_refs_id_75c25ee9226944c7` FOREIGN KEY (`page_id`) REFERENCES `cms_publicpage` (`id`); [] | |
| = CREATE INDEX `cms_publictitle_page_id` ON `cms_publictitle` (`page_id`); [] | |
| = ALTER TABLE `cms_globalpagepermission` ADD CONSTRAINT `group_id_refs_id_4f6f13d5b12278f8` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`); [] | |
| = CREATE INDEX `cms_globalpagepermission_group_id` ON `cms_globalpagepermission` (`group_id`); [] | |
| = ALTER TABLE `cms_globalpagepermission` ADD CONSTRAINT `user_id_refs_id_447e6e76f5365069` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); [] | |
| = CREATE INDEX `cms_globalpagepermission_user_id` ON `cms_globalpagepermission` (`user_id`); [] | |
| = CREATE INDEX `cms_publicpage_rght` ON `cms_publicpage` (`rght`); [] | |
| = CREATE INDEX `cms_publicpage_level` ON `cms_publicpage` (`level`); [] | |
| = CREATE INDEX `cms_publicpage_navigation_extenders` ON `cms_publicpage` (`navigation_extenders`); [] | |
| = ALTER TABLE `cms_publicpage` ADD CONSTRAINT `parent_id_refs_id_342c04c3d4458e77` FOREIGN KEY (`parent_id`) REFERENCES `cms_publicpage` (`id`); [] | |
| = CREATE INDEX `cms_publicpage_parent_id` ON `cms_publicpage` (`parent_id`); [] | |
| = ALTER TABLE `cms_publicpage` ADD CONSTRAINT `author_id_refs_id_2206d0fb466c4cba` FOREIGN KEY (`author_id`) REFERENCES `auth_user` (`id`); [] | |
| = CREATE INDEX `cms_publicpage_author_id` ON `cms_publicpage` (`author_id`); [] | |
| = CREATE INDEX `cms_publicpage_reverse_id` ON `cms_publicpage` (`reverse_id`); [] | |
| = ALTER TABLE `cms_publicpage` ADD CONSTRAINT `site_id_refs_id_74f4f96c9d9f0f3d` FOREIGN KEY (`site_id`) REFERENCES `django_site` (`id`); [] | |
| = CREATE INDEX `cms_publicpage_site_id` ON `cms_publicpage` (`site_id`); [] | |
| = CREATE INDEX `cms_publicpage_soft_root` ON `cms_publicpage` (`soft_root`); [] | |
| = CREATE INDEX `cms_publicpage_lft` ON `cms_publicpage` (`lft`); [] | |
| = CREATE INDEX `cms_publicpage_publication_end_date` ON `cms_publicpage` (`publication_end_date`); [] | |
| = CREATE INDEX `cms_publicpage_tree_id` ON `cms_publicpage` (`tree_id`); [] | |
| = CREATE INDEX `cms_publicpage_publication_date` ON `cms_publicpage` (`publication_date`); [] | |
| = CREATE INDEX `cms_publicpage_in_navigation` ON `cms_publicpage` (`in_navigation`); [] | |
| = ALTER TABLE `cms_pagemoderator` ADD CONSTRAINT `page_id_refs_id_5d795dd492bc8605` FOREIGN KEY (`page_id`) REFERENCES `cms_page` (`id`); [] | |
| = CREATE INDEX `cms_pagemoderator_page_id` ON `cms_pagemoderator` (`page_id`); [] | |
| = ALTER TABLE `cms_pagemoderator` ADD CONSTRAINT `user_id_refs_id_4cbb99dfc574e281` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); [] | |
| = CREATE INDEX `cms_pagemoderator_user_id` ON `cms_pagemoderator` (`user_id`); [] | |
| = ALTER TABLE `cms_pagemoderatorstate` ADD CONSTRAINT `page_id_refs_id_3cff375bf4dc9e9d` FOREIGN KEY (`page_id`) REFERENCES `cms_page` (`id`); [] | |
| = CREATE INDEX `cms_pagemoderatorstate_page_id` ON `cms_pagemoderatorstate` (`page_id`); [] | |
| = ALTER TABLE `cms_pagemoderatorstate` ADD CONSTRAINT `user_id_refs_id_210628e22808fb19` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); [] | |
| = CREATE INDEX `cms_pagemoderatorstate_user_id` ON `cms_pagemoderatorstate` (`user_id`); [] | |
| = ALTER TABLE `cms_pageusergroup` ADD CONSTRAINT `group_ptr_id_refs_id_49e243cc99e5e357` FOREIGN KEY (`group_ptr_id`) REFERENCES `auth_group` (`id`); [] | |
| = ALTER TABLE `cms_pageusergroup` ADD CONSTRAINT `created_by_id_refs_id_47ce3c433dc63396` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`); [] | |
| = CREATE INDEX `cms_pageusergroup_created_by_id` ON `cms_pageusergroup` (`created_by_id`); [] | |
| = ALTER TABLE `cms_page` ADD CONSTRAINT `site_id_refs_id_104217d4ed70f71a` FOREIGN KEY (`site_id`) REFERENCES `django_site` (`id`); [] | |
| = CREATE INDEX `cms_page_site_id` ON `cms_page` (`site_id`); [] | |
| = ALTER TABLE `cms_cmsplugin` ADD CONSTRAINT `inherited_public_id_refs_id_1064c8c1d3fe7278` FOREIGN KEY (`inherited_public_id`) REFERENCES `cms_publiccmsplugin` (`id`); [] | |
| = ALTER TABLE `cms_page` ADD CONSTRAINT `public_id_refs_id_7844850a7cf317ce` FOREIGN KEY (`public_id`) REFERENCES `cms_publicpage` (`id`); [] | |
| = ALTER TABLE `cms_title` ADD CONSTRAINT `public_id_refs_id_5bc6cb8c03cbecb8` FOREIGN KEY (`public_id`) REFERENCES `cms_publictitle` (`id`); [] | |
| > cms: 0013_site_copy | |
| > cms: 0014_sites_removed | |
| = DROP TABLE `cms_page_sites` CASCADE; [] | |
| > cms: 0015_modified_by_added | |
| = ALTER TABLE `cms_publicpage` ADD COLUMN `changed_by` varchar(70) NOT NULL; [] | |
| = ALTER TABLE `cms_page` ADD COLUMN `changed_by` varchar(70) NOT NULL; [] | |
| = ALTER TABLE `cms_publicpage` ADD COLUMN `created_by` varchar(70) NOT NULL; [] | |
| = ALTER TABLE `cms_page` ADD COLUMN `created_by` varchar(70) NOT NULL; [] | |
| > cms: 0016_author_copy | |
| > cms: 0017_author_removed | |
| = ALTER TABLE `cms_publicpage` DROP COLUMN `author_id` CASCADE; [] | |
| = ALTER TABLE `cms_page` DROP COLUMN `author_id` CASCADE; [] | |
| > cms: 0018_site_permissions | |
| = CREATE TABLE `cms_globalpagepermission_sites` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `globalpagepermission_id` integer NOT NULL, `site_id` integer NOT NULL); [] | |
| = ALTER TABLE `cms_globalpagepermission_sites` ADD CONSTRAINT `globalpagepermission_id_refs_id_2d0cf4fc2c730e06` FOREIGN KEY (`globalpagepermission_id`) REFERENCES `cms_globalpagepermission` (`id`); [] | |
| = CREATE INDEX `cms_globalpagepermission_sites_globalpagepermission_id` ON `cms_globalpagepermission_sites` (`globalpagepermission_id`); [] | |
| = ALTER TABLE `cms_globalpagepermission_sites` ADD CONSTRAINT `site_id_refs_id_70c81e4a38dfe611` FOREIGN KEY (`site_id`) REFERENCES `django_site` (`id`); [] | |
| = CREATE INDEX `cms_globalpagepermission_sites_site_id` ON `cms_globalpagepermission_sites` (`site_id`); [] | |
| > cms: 0019_public_table_renames | |
| = RENAME TABLE `cms_publicpage` TO `cms_pagepublic`; [] | |
| = RENAME TABLE `cms_publictitle` TO `cms_titlepublic`; [] | |
| = RENAME TABLE `cms_publiccmsplugin` TO `cms_cmspluginpublic`; [] | |
| = ALTER TABLE `cms_cmsplugin` ; [] | |
| = ALTER TABLE `cms_cmsplugin` ALTER COLUMN `inherited_public_id` DROP DEFAULT; [] | |
| = ALTER TABLE `cms_cmsplugin` MODIFY `inherited_public_id` integer NULL;; [] | |
| = ALTER TABLE `cms_title` ; [] | |
| = ALTER TABLE `cms_title` ALTER COLUMN `public_id` DROP DEFAULT; [] | |
| = ALTER TABLE `cms_title` MODIFY `public_id` integer NULL;; [] | |
| = ALTER TABLE `cms_page` ; [] | |
| = ALTER TABLE `cms_page` ALTER COLUMN `public_id` DROP DEFAULT; [] | |
| = ALTER TABLE `cms_page` MODIFY `public_id` integer NULL;; [] | |
| = ALTER TABLE `cms_titlepublic` ADD CONSTRAINT `cms_titlepublic_language_4ffdfcc47ae5b738` UNIQUE (`language`, `page_id`) [] | |
| > cms: 0020_advanced_permissions | |
| = ALTER TABLE `cms_pagepermission` ADD COLUMN `can_change_advanced_settings` bool NOT NULL DEFAULT False; [] | |
| = ALTER TABLE `cms_globalpagepermission` ADD COLUMN `can_change_advanced_settings` bool NOT NULL DEFAULT False; [] | |
| = ALTER TABLE `cms_globalpagepermission` DROP COLUMN `can_change_softroot` CASCADE; [] | |
| = ALTER TABLE `cms_pagepermission` DROP COLUMN `can_change_softroot` CASCADE; [] | |
| - Sending post_syncdb signal for cms: ['CMSPlugin'] | |
| - Sending post_syncdb signal for cms: ['Title'] | |
| - Sending post_syncdb signal for cms: ['PagePermission'] | |
| - Sending post_syncdb signal for cms: ['Page'] | |
| - Sending post_syncdb signal for cms: ['Placeholder'] | |
| - Sending post_syncdb signal for cms: ['CMSPlugin'] | |
| - Sending post_syncdb signal for cms: ['Title'] | |
| - Sending post_syncdb signal for cms: ['PagePermission'] | |
| - Sending post_syncdb signal for cms: ['Page'] | |
| - Sending post_syncdb signal for cms: ['Placeholder'] | |
| - Sending post_syncdb signal for cms: ['PublicCMSPlugin'] | |
| - Sending post_syncdb signal for cms: ['PageUser'] | |
| - Sending post_syncdb signal for cms: ['PublicTitle'] | |
| - Sending post_syncdb signal for cms: ['GlobalPagePermission'] | |
| - Sending post_syncdb signal for cms: ['PublicPage'] | |
| - Sending post_syncdb signal for cms: ['PageModerator'] | |
| - Sending post_syncdb signal for cms: ['PageModeratorState'] | |
| - Sending post_syncdb signal for cms: ['PageUserGroup'] | |
| - Sending post_syncdb signal for cms: ['PublicCMSPlugin'] | |
| - Sending post_syncdb signal for cms: ['PageUser'] | |
| - Sending post_syncdb signal for cms: ['PublicTitle'] | |
| - Sending post_syncdb signal for cms: ['GlobalPagePermission'] | |
| - Sending post_syncdb signal for cms: ['PublicPage'] | |
| - Sending post_syncdb signal for cms: ['PageModerator'] | |
| - Sending post_syncdb signal for cms: ['PageModeratorState'] | |
| - Sending post_syncdb signal for cms: ['PageUserGroup'] | |
| - Loading initial data for cms. | |
| Running migrations for text: | |
| - Migrating forwards to 0004_table_rename. | |
| > text: 0001_initial | |
| = CREATE TABLE `text_text` (`body` longtext NULL, `cmsplugin_ptr_id` integer NOT NULL UNIQUE); [] | |
| = ALTER TABLE `text_text` ADD CONSTRAINT `cmsplugin_ptr_id_refs_id_344c4334bf9780bc` FOREIGN KEY (`cmsplugin_ptr_id`) REFERENCES `cms_cmsplugin` (`id`); [] | |
| > text: 0002_freeze | |
| > text: 0003_publisher | |
| = CREATE TABLE `text_publictext` (`body` longtext NULL, `mark_delete` bool NOT NULL DEFAULT False, `publiccmsplugin_ptr_id` integer NOT NULL PRIMARY KEY); [] | |
| = ALTER TABLE `text_text` ADD COLUMN `public_id` integer NULL UNIQUE; [] | |
| = ALTER TABLE `text_publictext` ADD CONSTRAINT `publiccmsplugin_ptr_id_refs_id_1e156954d1c94d78` FOREIGN KEY (`publiccmsplugin_ptr_id`) REFERENCES `cms_publiccmsplugin` (`id`); [] | |
| Traceback (most recent call last): | |
| File "/home/benjamin/cmstest/lib/python2.6/site-packages/South-0.6_pre-py2.6.egg/south/migration.py", line 316, in run_migrations | |
| db.execute_deferred_sql() | |
| File "/home/benjamin/cmstest/lib/python2.6/site-packages/South-0.6_pre-py2.6.egg/south/db/generic.py", line 104, in execute_deferred_sql | |
| self.execute(sql) | |
| File "/home/benjamin/cmstest/lib/python2.6/site-packages/South-0.6_pre-py2.6.egg/south/db/mysql.py", line 29, in execute | |
| return generic.DatabaseOperations.execute(self, sql, params) | |
| File "/home/benjamin/cmstest/lib/python2.6/site-packages/South-0.6_pre-py2.6.egg/south/db/generic.py", line 70, in execute | |
| cursor.execute(sql, params) | |
| File "/home/benjamin/cmstest/lib/python2.6/site-packages/django/db/backends/util.py", line 19, in execute | |
| return self.cursor.execute(sql, params) | |
| File "/home/benjamin/cmstest/lib/python2.6/site-packages/django/db/backends/mysql/base.py", line 84, in execute | |
| return self.cursor.execute(query, args) | |
| File "/var/lib/python-support/python2.6/MySQLdb/cursors.py", line 166, in execute | |
| self.errorhandler(self, exc, value) | |
| File "/var/lib/python-support/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler | |
| raise errorclass, errorvalue | |
| OperationalError: (1005, "Can't create table 'kofcms.#sql-74c4_2ef8' (errno: 150)") | |
| ! Error found during real run of migration! Aborting. | |
| ! Since you have a database that does not support running | |
| ! schema-altering statements in transactions, we have had to | |
| ! leave it in an interim state between migrations. | |
| ! You *might* be able to recover with: | |
| = DROP TABLE `text_publictext` CASCADE; [] | |
| = ALTER TABLE `text_text` DROP COLUMN `public_id` CASCADE; [] | |
| ! The South developers regret this has happened, and would | |
| ! like to gently persuade you to consider a slightly | |
| ! easier-to-deal-with DBMS. | |
| - Sending post_syncdb signal for text: ['Text'] | |
| - Sending post_syncdb signal for text: ['Text'] | |
| - Sending post_syncdb signal for text: ['PublicText'] | |
| - Sending post_syncdb signal for text: ['PublicText'] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment