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):
18 * Run: mysqldump pithosdb public > public-table.sql
19 * mysql> drop table public;
20 * Update the codebase and run the server so the new public table is created
21 * From the sql dump above, take the row:
23 INSERT INTO `public` VALUES (...);
27 INSERT INTO `public`(`path`) VALUES (...);
29 And execute in the database
30 * Create settings.local with local setting overrides
31 * Install python-django-south
33 python manage.py syncdb
34 python manage.py migrate im 0001 --fake
35 python manage.py migrate im
39 * Reset 'policy' table in mysql (backend):
41 mysql> update policy set `value`='auto' where `key`='versioning';
45 * Add the 'X-Forwarded-Protocol' header directive in the apache configuration, as described in the admin guide
46 * Update 'attributes' table in mysql (backend):
48 mysql> CREATE TABLE `attributes_new` (
49 `serial` int(11) NOT NULL,
50 `domain` varchar(255) COLLATE utf8_bin NOT NULL,
51 `key` varchar(255) COLLATE utf8_bin NOT NULL,
52 `value` varchar(255) COLLATE utf8_bin DEFAULT NULL,
53 PRIMARY KEY (`serial`,`domain`,`key`),
54 CONSTRAINT FOREIGN KEY (`serial`) REFERENCES `versions` (`serial`) ON DELETE CASCADE ON UPDATE CASCADE
55 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
56 mysql> insert into attributes_new select `serial`, 'pithos', `key`, `value` from attributes;
57 mysql> drop table attributes;
58 mysql> alter table attributes_new rename to attributes;