Add upgrade instructions.

Refs #1782

diff --git a/README.upgrade b/README.upgrade
index f7e049d..faa22e6 100644 (file)
--- a/README.upgrade
+++ b/README.upgrade
@@ -43,3 +43,16 @@ UPGRADE
 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;