UPGRADE ======= 0.7.9 -> 0.7.10 --------------- * Update settings.py (BACKEND_*, SERVICE_NAME, *_EMAIL, *_TARGET, IM_*) * Update 'attributes' table in mysql (backend): mysql> update attributes set `key`='ETag' where `key`='hash'; * Upgrade 'im_user' table (im app): ALTER TABLE im_user ADD COLUMN 'password' VARCHAR(255); 0.7.10 -> 0.8.0 --------------- * Upgrade 'public' table in mysql (backend): * Run: mysqldump pithosdb public > public-table.sql * mysql> drop table public; * Update the codebase and run the server so the new public table is created * From the sql dump above, take the row: INSERT INTO `public` VALUES (...); Rewrite as: INSERT INTO `public`(`path`) VALUES (...); And execute in the database * Create settings.local with local setting overrides * Install python-django-south * Setup south: python manage.py syncdb python manage.py migrate im 0001 --fake python manage.py migrate im 0.8.0 -> 0.8.1 -------------- * Reset 'policy' table in mysql (backend): mysql> update policy set `value`='auto' where `key`='versioning'; 0.8.1 -> 0.8.2 -------------- * Add the 'X-Forwarded-Protocol' header directive in the apache configuration, as described in the admin guide * Update 'attributes' table in mysql (backend): mysql> CREATE TABLE `attributes_new` ( `serial` int(11) NOT NULL, `domain` varchar(255) COLLATE utf8_bin NOT NULL, `key` varchar(255) COLLATE utf8_bin NOT NULL, `value` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`serial`,`domain`,`key`), CONSTRAINT FOREIGN KEY (`serial`) REFERENCES `versions` (`serial`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; mysql> insert into attributes_new select `serial`, 'pithos', `key`, `value` from attributes; mysql> drop table attributes; mysql> alter table attributes_new rename to attributes; * Update 'versions' table in mysql (backend): mysql> create temporary table tmp_uuids as select distinct node, uuid() as `uuid` from versions; mysql> alter table versions add column `uuid` varchar(64) DEFAULT '' NOT NULL after `muser`; mysql> update versions v, tmp_uuids u set v.`uuid` = u.`uuid` where v.`node` = u.`node`; mysql> create index idx_versions_node_uuid on versions(uuid);