Revision 044f4210

b/README.upgrade
56 56 
    mysql> insert into attributes_new select `serial`, 'pithos', `key`, `value` from attributes;
57 57 
    mysql> drop table attributes;
58 58 
    mysql> alter table attributes_new rename to attributes;
59 

  		





  
  60
  
    
* Update 'versions' table in mysql (backend):


  		





  
  61
  
    
    


  		





  
  62
  
    
    mysql> create temporary table tmp_uuids as select distinct node, uuid() as `uuid` from versions;


  		





  
  63
  
    
    mysql> alter table versions add column `uuid` varchar(64) DEFAULT '' NOT NULL after `muser`;


  		





  
  64
  
    
    mysql> update versions v, tmp_uuids u set v.`uuid` = u.`uuid` where v.`node` = u.`node`;


  		





  
  65
  
    
    mysql> create index idx_versions_node_uuid on versions(uuid);


  		












Also available in:
  Unified diff