6 * Update settings.py (BACKEND_*, SERVICE_NAME, \*_EMAIL, \*_TARGET, IM_*)
7 * Update ``attributes`` table in mysql (backend)::
9 mysql> update attributes set `key`='ETag' where `key`='hash';
11 * Upgrade ``im_user`` table (im app)::
13 ALTER TABLE im_user ADD COLUMN 'password' VARCHAR(255);
17 * Upgrade ``public`` table in mysql (backend):
19 * Run: mysqldump pithosdb public > public-table.sql
20 * mysql> drop table public;
21 * Update the codebase and run the server so the new public table is created
22 * From the sql dump above, take the row::
24 INSERT INTO `public` VALUES (...);
28 INSERT INTO `public`(`path`) VALUES (...);
30 And execute in the database
32 * Create settings.local with local setting overrides
33 * Install python-django-south
36 python manage.py syncdb
37 python manage.py migrate im 0001 --fake
38 python manage.py migrate im
42 * Reset ``policy`` table in mysql (backend)::
44 mysql> update policy set `value`='auto' where `key`='versioning';
48 * Add the ``X-Forwarded-Protocol`` header directive in the apache configuration, as described in the admin guide
49 * Update ``attributes`` table in mysql (backend)::
51 mysql> CREATE TABLE `attributes_new` (
52 `serial` int(11) NOT NULL,
53 `domain` varchar(255) COLLATE utf8_bin NOT NULL,
54 `key` varchar(255) COLLATE utf8_bin NOT NULL,
55 `value` varchar(255) COLLATE utf8_bin DEFAULT NULL,
56 PRIMARY KEY (`serial`,`domain`,`key`),
57 CONSTRAINT FOREIGN KEY (`serial`) REFERENCES `versions` (`serial`) ON DELETE CASCADE ON UPDATE CASCADE
58 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
59 mysql> insert into attributes_new select `serial`, 'pithos', `key`, `value` from attributes;
60 mysql> drop table attributes;
61 mysql> alter table attributes_new rename to attributes;
63 * Update ``versions`` table in mysql (backend)::
65 mysql> create temporary table tmp_uuids as select distinct node, uuid() as `uuid` from versions;
66 mysql> alter table versions add column `uuid` varchar(64) DEFAULT '' NOT NULL after `muser`;
67 mysql> update versions v, tmp_uuids u set v.`uuid` = u.`uuid` where v.`node` = u.`node`;
68 mysql> create index idx_versions_node_uuid on versions(uuid);
72 * No upgrade path provided. Please reinstall and reconfigure.