Services/Sync/Server/Archived/0.5/Setup/Migration
Migrating from Weave Server 0.3 to 0.5
The following changes are required to move from 0.3 to 0.5. These changes are backwards compatible - you can continue to run 0.3 code on the 0.5 database.
You will need to add the Apache alias to enable 0.5:
Alias /0.5 <path to server>/server/0.5/index.php
Alias /user/1 <path to server>/server/user/1/index.php
Alias /misc/1/captcha_html <path to server>/server/misc/1/captcha.php
Mysql
alter table wbo add column predecessorid varbinary(64) default NULL after parentid;
alter table wbo add column payload_size int;
alter table wbo add index weightindex (`username`,`collection`,`sortindex`);
alter table wbo add index predecessorindex (`username`,`collection`,`predecessorid`);
SQLite
You will need to do this to each user's storage table, so it may be easier to delete and add a user.
alter table wbo add column predecessorid text;
alter table wbo add column payload_size int;
alter table wbo add index weightindex (`username`,`collection`,`sortindex`);