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`);