Hi Viraj, If you compare the h2 script and derby script in carbon 4.2.0 release (and should be in ESB 4.8.1 and 4.9.0), the changes you have mentioned are already in the h2 script. So these changes you have found in derby scripts seems to be bug fixes.
Thanks, Maduranga On Tue, Sep 15, 2015 at 12:03 PM, Viraj Senevirathne <[email protected]> wrote: > Hi Maduranga, > > I compared derby scripts in *dbscripts* folder inside the ESB 4.8.1 [1] > and ESB4.9.0.[2] distributions. Are you suggesting that derby script in > 4.8.1 is a buggy script? > > I thought these changes are due to database changes in user management > section in two carbon versions. > > [1] > https://drive.google.com/a/wso2.com/file/d/0Byt7F9S8tb-DdmxkSDB6b0ZiUFk/view?usp=sharing > > [2] > https://drive.google.com/a/wso2.com/file/d/0Byt7F9S8tb-DZ2F0a2E2Ty0zMTQ/view?usp=sharing > > Regards, > > On Tue, Sep 15, 2015 at 11:49 AM, Maduranga Siriwardena < > [email protected]> wrote: > >> 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 >> > > > > -- > Viraj Senevirathne > Software Engineer; WSO2, Inc. > > Mobile : +94 71 958 0269 > Email : [email protected] > -- Maduranga Siriwardena Software Engineer WSO2 Inc. email: [email protected] mobile: +94718990591
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
