Update upgrade instructions.

Refs #1790

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