Hi all,

I found several changes in derby script that exists in ESB 4.8.1 to that of
4.9.0. I created the derby script [1] to upgrade the ESB 4.8.1 derby
database to 4.9.0 database. But when adding new columns to old  database
should I put them as blank or should I update that column with new data?

Table changes are given below.

*New Table Addition*
UM_SYSTEM_ROLE
UM_SYSTEM_USER_ROLE
UM_SYSTEM_USER
UM_DOMAIN

*Adding columns to Existing tables*
ALTER TABLE UM_ROLE_PERMISSION ADD COLUMN UM_DOMAIN_ID INTEGER;

ALTER TABLE UM_CLAIM ADD UM_MAPPED_ATTRIBUTE_DOMAIN VARCHAR(255);

Is it necessary to put data to these columns or keep them blanks?

Thanks,

[1]
https://drive.google.com/a/wso2.com/file/d/0Byt7F9S8tb-DeGdVTlpOXzkyYTQ/view?usp=sharing
-- 
Viraj Senevirathne
Software Engineer; WSO2, Inc.

Mobile : +94 71 958 0269
Email : [email protected]
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev

Reply via email to