Author: dushshantha
Date: Mon Jul 2 23:47:21 2007
New Revision: 552692
URL: http://svn.apache.org/viewvc?view=rev&rev=552692
Log:
added if exist
Modified:
webservices/sandesha/trunk/c/config/mysql_schema.sh
webservices/sandesha/trunk/c/config/sqlite_schema.sh
Modified: webservices/sandesha/trunk/c/config/mysql_schema.sh
URL:
http://svn.apache.org/viewvc/webservices/sandesha/trunk/c/config/mysql_schema.sh?view=diff&rev=552692&r1=552691&r2=552692
==============================================================================
--- webservices/sandesha/trunk/c/config/mysql_schema.sh (original)
+++ webservices/sandesha/trunk/c/config/mysql_schema.sh Mon Jul 2 23:47:21 2007
@@ -1,49 +1,49 @@
-#!/bin/bash
-drop database sandesha2_svr_db;
-drop database sandesha2_client_db;
-create database sandesha2_svr_db;
-create database sandesha2_client_db;
-
-connect sandesha2_svr_db;
-create table create_seq(create_seq_msg_id varchar(100) primary key,
- internal_seq_id varchar(200), seq_id varchar(200),
create_seq_msg_store_key varchar(100),
- ref_msg_store_key varchar(100)) engine=InnoDB;
-create table invoker(msg_ctx_ref_key varchar(100) primary key,
- msg_no long, seq_id varchar(200), is_invoked boolean) engine=InnoDB;
-create table sender(msg_id varchar(100) primary key,
- msg_ctx_ref_key varchar(100), internal_seq_id varchar(200), sent_count
int,
- msg_no long, send boolean, resend boolean, time_to_send long, msg_type
int,
- seq_id varchar(200), wsrm_anon_uri varchar(100), to_address varchar(100))
engine=InnoDB;
-create table next_msg(seq_id varchar(200) primary key,
- ref_msg_key varchar(100), polling_mode boolean, msg_no long) engine=InnoDB;
-create table seq_property(id varchar(200) ,
- seq_id varchar(200), name varchar(200), value varchar(200)) engine=InnoDB;
-create table msg(stored_key varchar(200) primary key,
- msg_id varchar(200), soap_env_str text, soap_version int, transport_out
varchar(100),
- op varchar(100), svc varchar(100), svc_grp varchar(100), op_mep
varchar(100), to_url varchar(200),
- reply_to varchar(200), transport_to varchar(200), execution_chain_str
varchar(200), flow int,
- msg_recv_str varchar(200), svr_side boolean, in_msg_store_key
varchar(200), prop_str varchar(8192),
- action varchar(200)) engine=InnoDB;
-
-connect sandesha2_client_db;
-create table create_seq(create_seq_msg_id varchar(100) primary key,
- internal_seq_id varchar(200), seq_id varchar(200),
create_seq_msg_store_key varchar(100),
- ref_msg_store_key varchar(100)) engine=InnoDB;
-create table invoker(msg_ctx_ref_key varchar(100) primary key,
- msg_no long, seq_id varchar(200), is_invoked boolean) engine=InnoDB;
-create table sender(msg_id varchar(100) primary key,
- msg_ctx_ref_key varchar(100), internal_seq_id varchar(200), sent_count
int,
- msg_no long, send boolean, resend boolean, time_to_send long, msg_type
int,
- seq_id varchar(200), wsrm_anon_uri varchar(100), to_address varchar(100))
engine=InnoDB;
-create table next_msg(seq_id varchar(200) primary key,
- ref_msg_key varchar(100), polling_mode boolean, msg_no long) engine=InnoDB;
-create table seq_property(id varchar(200) ,
- seq_id varchar(200), name varchar(200), value varchar(200)) engine=InnoDB;
-create table msg(stored_key varchar(200) primary key,
- msg_id varchar(200), soap_env_str text, soap_version int, transport_out
varchar(100),
- op varchar(100), svc varchar(100), svc_grp varchar(100), op_mep
varchar(100), to_url varchar(200),
- reply_to varchar(200), transport_to varchar(200), execution_chain_str
varchar(200), flow int,
- msg_recv_str varchar(200), svr_side boolean, in_msg_store_key
varchar(200), prop_str varchar(8192),
- action varchar(200)) engine=InnoDB;
-create table response(seq_id varchar(200),
- response_str text, msg_no int, soap_version int) engine=InnoDB;
+#!/bin/bash
+drop database IF EXISTS sandesha2_svr_db;
+drop database IF EXISTS sandesha2_client_db;
+create database sandesha2_svr_db;
+create database sandesha2_client_db;
+
+connect sandesha2_svr_db;
+create table create_seq(create_seq_msg_id varchar(100) primary key,
+ internal_seq_id varchar(200), seq_id varchar(200),
create_seq_msg_store_key varchar(100),
+ ref_msg_store_key varchar(100)) engine=InnoDB;
+create table invoker(msg_ctx_ref_key varchar(100) primary key,
+ msg_no long, seq_id varchar(200), is_invoked boolean) engine=InnoDB;
+create table sender(msg_id varchar(100) primary key,
+ msg_ctx_ref_key varchar(100), internal_seq_id varchar(200), sent_count
int,
+ msg_no long, send boolean, resend boolean, time_to_send long, msg_type
int,
+ seq_id varchar(200), wsrm_anon_uri varchar(100), to_address varchar(100))
engine=InnoDB;
+create table next_msg(seq_id varchar(200) primary key,
+ ref_msg_key varchar(100), polling_mode boolean, msg_no long) engine=InnoDB;
+create table seq_property(id varchar(200) ,
+ seq_id varchar(200), name varchar(200), value varchar(200)) engine=InnoDB;
+create table msg(stored_key varchar(200) primary key,
+ msg_id varchar(200), soap_env_str text, soap_version int, transport_out
varchar(100),
+ op varchar(100), svc varchar(100), svc_grp varchar(100), op_mep
varchar(100), to_url varchar(200),
+ reply_to varchar(200), transport_to varchar(200), execution_chain_str
varchar(200), flow int,
+ msg_recv_str varchar(200), svr_side boolean, in_msg_store_key
varchar(200), prop_str varchar(8192),
+ action varchar(200)) engine=InnoDB;
+
+connect sandesha2_client_db;
+create table create_seq(create_seq_msg_id varchar(100) primary key,
+ internal_seq_id varchar(200), seq_id varchar(200),
create_seq_msg_store_key varchar(100),
+ ref_msg_store_key varchar(100)) engine=InnoDB;
+create table invoker(msg_ctx_ref_key varchar(100) primary key,
+ msg_no long, seq_id varchar(200), is_invoked boolean) engine=InnoDB;
+create table sender(msg_id varchar(100) primary key,
+ msg_ctx_ref_key varchar(100), internal_seq_id varchar(200), sent_count
int,
+ msg_no long, send boolean, resend boolean, time_to_send long, msg_type
int,
+ seq_id varchar(200), wsrm_anon_uri varchar(100), to_address varchar(100))
engine=InnoDB;
+create table next_msg(seq_id varchar(200) primary key,
+ ref_msg_key varchar(100), polling_mode boolean, msg_no long) engine=InnoDB;
+create table seq_property(id varchar(200) ,
+ seq_id varchar(200), name varchar(200), value varchar(200)) engine=InnoDB;
+create table msg(stored_key varchar(200) primary key,
+ msg_id varchar(200), soap_env_str text, soap_version int, transport_out
varchar(100),
+ op varchar(100), svc varchar(100), svc_grp varchar(100), op_mep
varchar(100), to_url varchar(200),
+ reply_to varchar(200), transport_to varchar(200), execution_chain_str
varchar(200), flow int,
+ msg_recv_str varchar(200), svr_side boolean, in_msg_store_key
varchar(200), prop_str varchar(8192),
+ action varchar(200)) engine=InnoDB;
+create table response(seq_id varchar(200),
+ response_str text, msg_no int, soap_version int) engine=InnoDB;
Modified: webservices/sandesha/trunk/c/config/sqlite_schema.sh
URL:
http://svn.apache.org/viewvc/webservices/sandesha/trunk/c/config/sqlite_schema.sh?view=diff&rev=552692&r1=552691&r2=552692
==============================================================================
--- webservices/sandesha/trunk/c/config/sqlite_schema.sh (original)
+++ webservices/sandesha/trunk/c/config/sqlite_schema.sh Mon Jul 2 23:47:21
2007
@@ -1,56 +1,56 @@
-#!/bin/bash
-sqlite sandesha2_svr_db "drop table create_seq;"
-sqlite sandesha2_svr_db "drop table invoker;"
-sqlite sandesha2_svr_db "drop table sender"
-sqlite sandesha2_svr_db "drop table next_msg"
-sqlite sandesha2_svr_db "drop table seq_property"
-sqlite sandesha2_svr_db "drop table msg"
-sqlite sandesha2_svr_db "create table create_seq(create_seq_msg_id
varchar(100) primary key,
- internal_seq_id varchar(200), seq_id varchar(200),
create_seq_msg_store_key varchar(100),
- ref_msg_store_key varchar(100))"
-sqlite sandesha2_svr_db "create table invoker(msg_ctx_ref_key varchar(100)
primary key,
- msg_no long, seq_id varchar(200), is_invoked boolean)"
-sqlite sandesha2_svr_db "create table sender(msg_id varchar(100) primary key,
- msg_ctx_ref_key varchar(100), internal_seq_id varchar(200), sent_count
int,
- msg_no long, send boolean, resend boolean, time_to_send long, msg_type
int,
- seq_id varchar(200), wsrm_anon_uri varchar(100), to_address varchar(100))"
-sqlite sandesha2_svr_db "create table next_msg(seq_id varchar(200) primary
key,
- ref_msg_key varchar(100), polling_mode boolean, msg_no long)"
-sqlite sandesha2_svr_db "create table seq_property(id varchar(200) ,
- seq_id varchar(200), name varchar(200), value varchar(200))"
-sqlite sandesha2_svr_db "create table msg(stored_key varchar(200) primary key,
- msg_id varchar(200), soap_env_str text, soap_version int, transport_out
varchar(100),
- op varchar(100), svc varchar(100), svc_grp varchar(100), op_mep
varchar(100), to_url varchar(200),
- reply_to varchar(200), transport_to varchar(200), execution_chain_str
varchar(200), flow int,
- msg_recv_str varchar(200), svr_side boolean, in_msg_store_key
varchar(200), prop_str varchar(8192),
- action varchar(200))"
-
-sqlite sandesha2_client_db "drop table create_seq;"
-sqlite sandesha2_client_db "drop table invoker;"
-sqlite sandesha2_client_db "drop table sender"
-sqlite sandesha2_client_db "drop table next_msg"
-sqlite sandesha2_client_db "drop table seq_property"
-sqlite sandesha2_client_db "drop table msg"
-sqlite sandesha2_client_db "drop table response"
-sqlite sandesha2_client_db "create table create_seq(create_seq_msg_id
varchar(100) primary key,
- internal_seq_id varchar(200), seq_id varchar(200),
create_seq_msg_store_key varchar(100),
- ref_msg_store_key varchar(100))"
-sqlite sandesha2_client_db "create table invoker(msg_ctx_ref_key varchar(100)
primary key,
- msg_no long, seq_id varchar(200), is_invoked boolean)"
-sqlite sandesha2_client_db "create table sender(msg_id varchar(100) primary
key,
- msg_ctx_ref_key varchar(100), internal_seq_id varchar(200), sent_count
int,
- msg_no long, send boolean, resend boolean, time_to_send long, msg_type
int,
- seq_id varchar(200), wsrm_anon_uri varchar(100), to_address varchar(100))"
-sqlite sandesha2_client_db "create table next_msg(seq_id varchar(200) primary
key,
- ref_msg_key varchar(100), polling_mode boolean, msg_no long)"
-sqlite sandesha2_client_db "create table seq_property(id varchar(200) ,
- seq_id varchar(200), name varchar(200), value varchar(200))"
-sqlite sandesha2_client_db "create table msg(stored_key varchar(200) primary
key,
- msg_id varchar(200), soap_env_str text, soap_version int, transport_out
varchar(100),
- op varchar(100), svc varchar(100), svc_grp varchar(100), op_mep
varchar(100), to_url varchar(200),
- reply_to varchar(200), transport_to varchar(200), execution_chain_str
varchar(200), flow int,
- msg_recv_str varchar(200), svr_side boolean, in_msg_store_key
varchar(200), prop_str varchar(8192),
- action varchar(200))"
-sqlite sandesha2_client_db "create table response(seq_id varchar(200),
- response_str text, msg_no int, soap_version int)"
-
+#!/bin/bash
+sqlite sandesha2_svr_db "drop table if exists create_seq;"
+sqlite sandesha2_svr_db "drop table if exists invoker;"
+sqlite sandesha2_svr_db "drop table if exists sender"
+sqlite sandesha2_svr_db "drop table if exists next_msg"
+sqlite sandesha2_svr_db "drop table if exists seq_property"
+sqlite sandesha2_svr_db "drop table if exists msg"
+sqlite sandesha2_svr_db "create table create_seq(create_seq_msg_id
varchar(100) primary key,
+ internal_seq_id varchar(200), seq_id varchar(200),
create_seq_msg_store_key varchar(100),
+ ref_msg_store_key varchar(100))"
+sqlite sandesha2_svr_db "create table invoker(msg_ctx_ref_key varchar(100)
primary key,
+ msg_no long, seq_id varchar(200), is_invoked boolean)"
+sqlite sandesha2_svr_db "create table sender(msg_id varchar(100) primary key,
+ msg_ctx_ref_key varchar(100), internal_seq_id varchar(200), sent_count
int,
+ msg_no long, send boolean, resend boolean, time_to_send long, msg_type
int,
+ seq_id varchar(200), wsrm_anon_uri varchar(100), to_address varchar(100))"
+sqlite sandesha2_svr_db "create table next_msg(seq_id varchar(200) primary
key,
+ ref_msg_key varchar(100), polling_mode boolean, msg_no long)"
+sqlite sandesha2_svr_db "create table seq_property(id varchar(200) ,
+ seq_id varchar(200), name varchar(200), value varchar(200))"
+sqlite sandesha2_svr_db "create table msg(stored_key varchar(200) primary key,
+ msg_id varchar(200), soap_env_str text, soap_version int, transport_out
varchar(100),
+ op varchar(100), svc varchar(100), svc_grp varchar(100), op_mep
varchar(100), to_url varchar(200),
+ reply_to varchar(200), transport_to varchar(200), execution_chain_str
varchar(200), flow int,
+ msg_recv_str varchar(200), svr_side boolean, in_msg_store_key
varchar(200), prop_str varchar(8192),
+ action varchar(200))"
+
+sqlite sandesha2_client_db "drop table if exists create_seq;"
+sqlite sandesha2_client_db "drop table if exists invoker;"
+sqlite sandesha2_client_db "drop table if exists sender"
+sqlite sandesha2_client_db "drop table if exists next_msg"
+sqlite sandesha2_client_db "drop table if exists seq_property"
+sqlite sandesha2_client_db "drop table if exists msg"
+sqlite sandesha2_client_db "drop table if exists response"
+sqlite sandesha2_client_db "create table create_seq(create_seq_msg_id
varchar(100) primary key,
+ internal_seq_id varchar(200), seq_id varchar(200),
create_seq_msg_store_key varchar(100),
+ ref_msg_store_key varchar(100))"
+sqlite sandesha2_client_db "create table invoker(msg_ctx_ref_key varchar(100)
primary key,
+ msg_no long, seq_id varchar(200), is_invoked boolean)"
+sqlite sandesha2_client_db "create table sender(msg_id varchar(100) primary
key,
+ msg_ctx_ref_key varchar(100), internal_seq_id varchar(200), sent_count
int,
+ msg_no long, send boolean, resend boolean, time_to_send long, msg_type
int,
+ seq_id varchar(200), wsrm_anon_uri varchar(100), to_address varchar(100))"
+sqlite sandesha2_client_db "create table next_msg(seq_id varchar(200) primary
key,
+ ref_msg_key varchar(100), polling_mode boolean, msg_no long)"
+sqlite sandesha2_client_db "create table seq_property(id varchar(200) ,
+ seq_id varchar(200), name varchar(200), value varchar(200))"
+sqlite sandesha2_client_db "create table msg(stored_key varchar(200) primary
key,
+ msg_id varchar(200), soap_env_str text, soap_version int, transport_out
varchar(100),
+ op varchar(100), svc varchar(100), svc_grp varchar(100), op_mep
varchar(100), to_url varchar(200),
+ reply_to varchar(200), transport_to varchar(200), execution_chain_str
varchar(200), flow int,
+ msg_recv_str varchar(200), svr_side boolean, in_msg_store_key
varchar(200), prop_str varchar(8192),
+ action varchar(200))"
+sqlite sandesha2_client_db "create table response(seq_id varchar(200),
+ response_str text, msg_no int, soap_version int)"
+
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
