You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@stratos.apache.org by Imesh Gunaratne <im...@apache.org> on 2015/05/17 19:27:36 UTC

[Discuss] Database Scripts Need to be Cleaned

Hi Devs,

I see the following database scripts in the dbscripts folder of the Stratos
distribution:

├── billing-h2.sql
├── billing-mysql.sql
├── db2.sql
├── derby.sql
├── h2.sql
├── identity
│   ├── application-mgt
│   │   ├── db2.sql
│   │   ├── h2.sql
│   │   ├── informix.sql
│   │   ├── mssql.sql
│   │   ├── mysql.sql
│   │   ├── oracle.sql
│   │   ├── oracle_rac.sql
│   │   └── postgresql.sql
│   ├── db2.sql
│   ├── h2.sql
│   ├── informix.sql
│   ├── mssql.sql
│   ├── mysql.sql
│   ├── oracle.sql
│   ├── oracle_rac.sql
│   └── postgresql.sql
├── informix.sql
├── metering_h2.sql
├── metering_mysql.sql
├── migration.sql
├── mssql.sql
├── mysql.sql
├── mysql_cluster.sql
├── openedge.sql
├── oracle.sql
├── oracle_rac.sql
├── postgresql.sql
├── s2_h2.sql
├── stratos_mysql.sql
└── wso2_rss.sql

I think the following files are not used now:

stratos_mysql.sql
s2_h2.sql
metering_h2.sql
metering_mysql.sql

Thanks

-- 
Imesh Gunaratne

Senior Technical Lead, WSO2
Committer & PMC Member, Apache Stratos

Re: [Discuss] Database Scripts Need to be Cleaned

Posted by Imesh Gunaratne <im...@apache.org>.
Now it looks great! :-) Thanks Udara!

On Tue, May 19, 2015 at 10:49 AM, Udara Liyanage <ud...@wso2.com> wrote:

> Hi Imesh,
>
> I have removed those database and new db file structure is as below. Does
> this looks good?
> dbscripts/
> ├── identity
> │   ├── application-mgt
> │   │   ├── db2.sql
> │   │   ├── h2.sql
> │   │   ├── informix.sql
> │   │   ├── mssql.sql
> │   │   ├── mysql.sql
> │   │   ├── oracle_rac.sql
> │   │   ├── oracle.sql
> │   │   └── postgresql.sql
> │   ├── db2.sql
> │   ├── h2.sql
> │   ├── informix.sql
> │   ├── mssql.sql
> │   ├── mysql.sql
> │   ├── oracle_rac.sql
> │   ├── oracle.sql
> │   └── postgresql.sql
> └── registry
>     ├── db2.sql
>     ├── derby.sql
>     ├── h2.sql
>     ├── informix.sql
>     ├── mssql.sql
>     ├── mysql_cluster.sql
>     ├── mysql.sql
>     ├── openedge.sql
>     ├── oracle_rac.sql
>     ├── oracle.sql
>     └── postgresql.sql
>
>
> On Mon, May 18, 2015 at 7:53 PM, Imesh Gunaratne <im...@apache.org> wrote:
>
>> Thanks Udara, no we do not need billing and metering database scripts.
>>
>> Thanks
>>
>> On Mon, May 18, 2015 at 3:50 PM, Udara Liyanage <ud...@wso2.com> wrote:
>>
>>> Hi,
>>>
>>> Do we need below db scripts.
>>>
>>> billing-h2.sql
>>> metering_h2.sql
>>>
>>> On Mon, May 18, 2015 at 3:44 PM, Udara Liyanage <ud...@wso2.com> wrote:
>>>
>>>> Hi Imesh,
>>>>
>>>> I will do the needful.
>>>>
>>>> On Mon, May 18, 2015 at 8:32 AM, Udara Liyanage <ud...@wso2.com> wrote:
>>>>
>>>>> +1
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> Udara Liyanage
>>>> Software Engineer
>>>> WSO2, Inc.: http://wso2.com
>>>> lean. enterprise. middleware
>>>>
>>>> web: http://udaraliyanage.wordpress.com
>>>> phone: +94 71 443 6897
>>>>
>>>
>>>
>>>
>>> --
>>>
>>> Udara Liyanage
>>> Software Engineer
>>> WSO2, Inc.: http://wso2.com
>>> lean. enterprise. middleware
>>>
>>> web: http://udaraliyanage.wordpress.com
>>> phone: +94 71 443 6897
>>>
>>
>>
>>
>> --
>> Imesh Gunaratne
>>
>> Senior Technical Lead, WSO2
>> Committer & PMC Member, Apache Stratos
>>
>
>
>
> --
>
> Udara Liyanage
> Software Engineer
> WSO2, Inc.: http://wso2.com
> lean. enterprise. middleware
>
> web: http://udaraliyanage.wordpress.com
> phone: +94 71 443 6897
>



-- 
Imesh Gunaratne

Senior Technical Lead, WSO2
Committer & PMC Member, Apache Stratos

Re: [Discuss] Database Scripts Need to be Cleaned

Posted by Udara Liyanage <ud...@wso2.com>.
Hi Imesh,

I have removed those database and new db file structure is as below. Does
this looks good?
dbscripts/
├── identity
│   ├── application-mgt
│   │   ├── db2.sql
│   │   ├── h2.sql
│   │   ├── informix.sql
│   │   ├── mssql.sql
│   │   ├── mysql.sql
│   │   ├── oracle_rac.sql
│   │   ├── oracle.sql
│   │   └── postgresql.sql
│   ├── db2.sql
│   ├── h2.sql
│   ├── informix.sql
│   ├── mssql.sql
│   ├── mysql.sql
│   ├── oracle_rac.sql
│   ├── oracle.sql
│   └── postgresql.sql
└── registry
    ├── db2.sql
    ├── derby.sql
    ├── h2.sql
    ├── informix.sql
    ├── mssql.sql
    ├── mysql_cluster.sql
    ├── mysql.sql
    ├── openedge.sql
    ├── oracle_rac.sql
    ├── oracle.sql
    └── postgresql.sql


On Mon, May 18, 2015 at 7:53 PM, Imesh Gunaratne <im...@apache.org> wrote:

> Thanks Udara, no we do not need billing and metering database scripts.
>
> Thanks
>
> On Mon, May 18, 2015 at 3:50 PM, Udara Liyanage <ud...@wso2.com> wrote:
>
>> Hi,
>>
>> Do we need below db scripts.
>>
>> billing-h2.sql
>> metering_h2.sql
>>
>> On Mon, May 18, 2015 at 3:44 PM, Udara Liyanage <ud...@wso2.com> wrote:
>>
>>> Hi Imesh,
>>>
>>> I will do the needful.
>>>
>>> On Mon, May 18, 2015 at 8:32 AM, Udara Liyanage <ud...@wso2.com> wrote:
>>>
>>>> +1
>>>>
>>>
>>>
>>>
>>> --
>>>
>>> Udara Liyanage
>>> Software Engineer
>>> WSO2, Inc.: http://wso2.com
>>> lean. enterprise. middleware
>>>
>>> web: http://udaraliyanage.wordpress.com
>>> phone: +94 71 443 6897
>>>
>>
>>
>>
>> --
>>
>> Udara Liyanage
>> Software Engineer
>> WSO2, Inc.: http://wso2.com
>> lean. enterprise. middleware
>>
>> web: http://udaraliyanage.wordpress.com
>> phone: +94 71 443 6897
>>
>
>
>
> --
> Imesh Gunaratne
>
> Senior Technical Lead, WSO2
> Committer & PMC Member, Apache Stratos
>



-- 

Udara Liyanage
Software Engineer
WSO2, Inc.: http://wso2.com
lean. enterprise. middleware

web: http://udaraliyanage.wordpress.com
phone: +94 71 443 6897

Re: [Discuss] Database Scripts Need to be Cleaned

Posted by Imesh Gunaratne <im...@apache.org>.
Thanks Udara, no we do not need billing and metering database scripts.

Thanks

On Mon, May 18, 2015 at 3:50 PM, Udara Liyanage <ud...@wso2.com> wrote:

> Hi,
>
> Do we need below db scripts.
>
> billing-h2.sql
> metering_h2.sql
>
> On Mon, May 18, 2015 at 3:44 PM, Udara Liyanage <ud...@wso2.com> wrote:
>
>> Hi Imesh,
>>
>> I will do the needful.
>>
>> On Mon, May 18, 2015 at 8:32 AM, Udara Liyanage <ud...@wso2.com> wrote:
>>
>>> +1
>>>
>>
>>
>>
>> --
>>
>> Udara Liyanage
>> Software Engineer
>> WSO2, Inc.: http://wso2.com
>> lean. enterprise. middleware
>>
>> web: http://udaraliyanage.wordpress.com
>> phone: +94 71 443 6897
>>
>
>
>
> --
>
> Udara Liyanage
> Software Engineer
> WSO2, Inc.: http://wso2.com
> lean. enterprise. middleware
>
> web: http://udaraliyanage.wordpress.com
> phone: +94 71 443 6897
>



-- 
Imesh Gunaratne

Senior Technical Lead, WSO2
Committer & PMC Member, Apache Stratos

Re: [Discuss] Database Scripts Need to be Cleaned

Posted by Udara Liyanage <ud...@wso2.com>.
Hi,

Do we need below db scripts.

billing-h2.sql
metering_h2.sql

On Mon, May 18, 2015 at 3:44 PM, Udara Liyanage <ud...@wso2.com> wrote:

> Hi Imesh,
>
> I will do the needful.
>
> On Mon, May 18, 2015 at 8:32 AM, Udara Liyanage <ud...@wso2.com> wrote:
>
>> +1
>>
>
>
>
> --
>
> Udara Liyanage
> Software Engineer
> WSO2, Inc.: http://wso2.com
> lean. enterprise. middleware
>
> web: http://udaraliyanage.wordpress.com
> phone: +94 71 443 6897
>



-- 

Udara Liyanage
Software Engineer
WSO2, Inc.: http://wso2.com
lean. enterprise. middleware

web: http://udaraliyanage.wordpress.com
phone: +94 71 443 6897

Re: [Discuss] Database Scripts Need to be Cleaned

Posted by Udara Liyanage <ud...@wso2.com>.
Hi Imesh,

I will do the needful.

On Mon, May 18, 2015 at 8:32 AM, Udara Liyanage <ud...@wso2.com> wrote:

> +1
>



-- 

Udara Liyanage
Software Engineer
WSO2, Inc.: http://wso2.com
lean. enterprise. middleware

web: http://udaraliyanage.wordpress.com
phone: +94 71 443 6897

Re: [Discuss] Database Scripts Need to be Cleaned

Posted by Udara Liyanage <ud...@wso2.com>.
+1

Re: [Discuss] Database Scripts Need to be Cleaned

Posted by Imesh Gunaratne <im...@apache.org>.
Also the billing database scripts are also not used. Shall we move the
registry database scripts to a folder called "registry"?

Thanks

On Sun, May 17, 2015 at 10:57 PM, Imesh Gunaratne <im...@apache.org> wrote:

> Hi Devs,
>
> I see the following database scripts in the dbscripts folder of the
> Stratos distribution:
>
> ├── billing-h2.sql
> ├── billing-mysql.sql
> ├── db2.sql
> ├── derby.sql
> ├── h2.sql
> ├── identity
> │   ├── application-mgt
> │   │   ├── db2.sql
> │   │   ├── h2.sql
> │   │   ├── informix.sql
> │   │   ├── mssql.sql
> │   │   ├── mysql.sql
> │   │   ├── oracle.sql
> │   │   ├── oracle_rac.sql
> │   │   └── postgresql.sql
> │   ├── db2.sql
> │   ├── h2.sql
> │   ├── informix.sql
> │   ├── mssql.sql
> │   ├── mysql.sql
> │   ├── oracle.sql
> │   ├── oracle_rac.sql
> │   └── postgresql.sql
> ├── informix.sql
> ├── metering_h2.sql
> ├── metering_mysql.sql
> ├── migration.sql
> ├── mssql.sql
> ├── mysql.sql
> ├── mysql_cluster.sql
> ├── openedge.sql
> ├── oracle.sql
> ├── oracle_rac.sql
> ├── postgresql.sql
> ├── s2_h2.sql
> ├── stratos_mysql.sql
> └── wso2_rss.sql
>
> I think the following files are not used now:
>
> stratos_mysql.sql
> s2_h2.sql
> metering_h2.sql
> metering_mysql.sql
>
> Thanks
>
> --
> Imesh Gunaratne
>
> Senior Technical Lead, WSO2
> Committer & PMC Member, Apache Stratos
>



-- 
Imesh Gunaratne

Senior Technical Lead, WSO2
Committer & PMC Member, Apache Stratos