Hi Viraj, The tables and columns you have mentioned should be in the database to work carbon properly. db2, berby and mysql (That's what I have noticed. There may be some other incorrect database scripts) were missing some tables and they should be bugs. So ideally they are not database script changes, rather they are bug fixes. So I don't think you need to migrate those changes.
Thanks, Maduranga On Tue, Sep 15, 2015 at 11:15 AM, Viraj Senevirathne <[email protected]> wrote: > 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 > > -- Maduranga Siriwardena Software Engineer WSO2 Inc. email: [email protected] mobile: +94718990591
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
