Resource Menu

RE : Upgrade 1.5 to 2.0
Hello Rüdiger,

to migrate from 1.5 to 2.0 you should execute some SQL commands. We are working on a small java executable for the futur migration change. Unfortunatly we didn't had the time to make it for this release.

Have fun with the 2.0...

the script is given here

-- create the new users table
CREATE TABLE casusers_ AS SELECT username_, passworddigest_ FROM user_;

-- update the old users table ALTER TABLE user_ RENAME TO profileresource_; UPDATE node_ SET bindedresourceidentifier_ = replace(bindedresourceidentifier_ , '/User/', '/Profile/'); ALTER TABLE profileresource_ DROP COLUMN passworddigest_ ; ALTER TABLE profileresource_ ADD COLUMN infos_ bytea ; ALTER TABLE profileresource_ RENAME username_ TO id_; ALTER TABLE profileresource_ RENAME jabber_ TO jabberid_;

-- create guest profile INSERT INTO profileresource_ (id_, fullname_, email_, jabberid_) VALUES ('guest', 'Guest', '', '');

-- init users profiles UPDATE profileresource_ SET infos_ = '\\254\\355\\000\\005sr\\000\\021java.util.HashMap\\005\\007\\332\\301\\303\\026`\\321\\003\\000\\002F\\000\\012loadFactorI\\000\\011thresholdxp?@\\000\\000\\000\\000\\000\\014w\\010\\000\\000\\000\\020\\000\\000\\000\\000x';


-- public timeline ALTER TABLE timelineresource_ ADD COLUMN publicevents_ boolean; UPDATE timelineresource_ SET publicevents_ = 'f' ;

-- node creation date ALTER TABLE node_ ADD COLUMN creationdate_ timestamp; UPDATE node_ SET creationdate_ = now();

-- node update date ALTER TABLE node_ ADD COLUMN updatedate_ timestamp; UPDATE node_ SET updatedate_ = now();

-- node shortname ALTER TABLE node_ ADD COLUMN shortname_ varchar;

-- fix bug in wsconnection table UPDATE wsconnectionresource_ SET manager_ = substring(manager_ from char_length('ls://localhost:9000/') for char_length(manager_)) WHERE manager_ LIKE 'ls://localhost:9000/%';

posted by Sebastien Jourdain at Dec 13, 2006 11:28 AM