Services/Sync/Server/Archived/0.5/Setup/Migration: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
[/Labs/Weave/0.5/Setup/Storage Full setup instructions] | [https://wiki.mozilla.org/Labs/Weave/0.5/Setup/Storage Full setup instructions] | ||
= Migrating from Weave Server 0.3 to 0.5 = | = Migrating from Weave Server 0.3 to 0.5 = | ||
Revision as of 20:18, 27 August 2009
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`);