From PmWiki

V2: Upgrade

This is copied from the 'upgrade.txt' file in the project.

for CongoV2? - from working db

Populate the state table with the links from reg_associations - can be run against old data

 update reg_state set state_subscribed=true where state_rid IN (select assoc_rid from reg_associations)

Add reg_subscribed - date unknown - see if reg_subscribed exists...

 alter table reg_state add reg_subscribed boolean;

Noted somewhere around 11/1/2008 - password column too narrow for password() data.

 alter table reg_master change master_password master_password varchar(41) ;

Schema change on 11/27/2008

 alter table con_detail add con_description text;
Retrieved from http://congo.wiki.stonekeep.com/V2/Upgrade
Page last modified on November 28, 2008, at 11:12 PM