[Dev] dbscripts folder structure for BPS 3.5.0

2014-07-17 Thread Hasitha Aravinda
Hi Team,

We are going to use a separate database for activiti engine. So we will
need to ship separate database scripts for activiti engine with BPS 3.5.0.

In BPS 3.2.0 we have following structure.

dbscripts
├── bps
│  ├── derby.sql   - BPEL and HT scripts .
│  ├── 
│
├── db2.sql  - reg_um scripts
├── ...

Proposed structure for BPS 3.5.0 as follows,

dbscripts
├── bps
│   ├── bpel  - ODE and HT scripts .
│   │   ├── create
│   │   │  ├──  derby.sql
│   │   │
│   │   ├── truncate
│   │   │   ├── (to be created)
│   │   │
│   │   ├── upgrade
│   │├── 300_350
│   │├── 310_350
│   │
│   ├── bpmn- activiti related scripts.
│  ├── create
│  │  ├── activiti.db2.create.engine.sql
│  │
│  ├── drop
│  │   ├── activiti.db2.drop.engine.sql
│  │
│  ├── upgrade
│   ├── (empty since no upgrade scripts in initial
version)
│
├── db2.sql   - reg_um scripts
├── ...



Thanks
Hasitha.

-- 
Hasitha Aravinda,
Software Engineer,
WSO2 Inc.
Email: hasi...@wso2.com
Mobile: +94 71 8 210 200
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev


Re: [Dev] dbscripts folder structure for BPS 3.5.0

2014-07-17 Thread Nandika Jayawardana
Looks good to me. Lets update with this stricture. Also we need to fix and
test the -Dsetup option.

Regards
Nandika


On Thu, Jul 17, 2014 at 2:44 PM, Hasitha Aravinda hasi...@wso2.com wrote:

 Hi Team,

 We are going to use a separate database for activiti engine. So we will
 need to ship separate database scripts for activiti engine with BPS 3.5.0.

 In BPS 3.2.0 we have following structure.

 dbscripts
 ├── bps
 │  ├── derby.sql   - BPEL and HT scripts .
 │  ├── 
 │
 ├── db2.sql  - reg_um scripts
 ├── ...

 Proposed structure for BPS 3.5.0 as follows,

 dbscripts
 ├── bps
 │   ├── bpel  - ODE and HT scripts .
 │   │   ├── create
 │   │   │  ├──  derby.sql
 │   │   │
 │   │   ├── truncate
 │   │   │   ├── (to be created)
 │   │   │
 │   │   ├── upgrade
 │   │├── 300_350
 │   │├── 310_350
 │   │
 │   ├── bpmn- activiti related scripts.
 │  ├── create
 │  │  ├── activiti.db2.create.engine.sql
 │  │
 │  ├── drop
 │  │   ├── activiti.db2.drop.engine.sql
 │  │
 │  ├── upgrade
 │   ├── (empty since no upgrade scripts in initial
 version)
 │
 ├── db2.sql   - reg_um scripts
 ├── ...



 Thanks
 Hasitha.

 --
 Hasitha Aravinda,
 Software Engineer,
 WSO2 Inc.
 Email: hasi...@wso2.com
 Mobile: +94 71 8 210 200




-- 
Nandika Jayawardana
Senior Technical Lead
WSO2 Inc ; http://wso2.com
lean.enterprise.middleware
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev