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