--
-- CAS UPDATE
-- 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';

-- -- OTHERS UPDATES

-- 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/%';