Author: damitha
Date: Wed Apr 25 03:23:35 2007
New Revision: 532297
URL: http://svn.apache.org/viewvc?view=rev&rev=532297
Log:
added mysql scripts
Added:
webservices/sandesha/trunk/c/config/clean_mysql.sh (with props)
webservices/sandesha/trunk/c/config/create_mysql.sh (with props)
webservices/sandesha/trunk/c/config/mysql_schema_client_clean.sh (with
props)
webservices/sandesha/trunk/c/config/mysql_schema_client_create.sh
webservices/sandesha/trunk/c/config/mysql_schema_svr_clean.sh
webservices/sandesha/trunk/c/config/mysql_schema_svr_create.sh (with
props)
Added: webservices/sandesha/trunk/c/config/clean_mysql.sh
URL:
http://svn.apache.org/viewvc/webservices/sandesha/trunk/c/config/clean_mysql.sh?view=auto&rev=532297
==============================================================================
--- webservices/sandesha/trunk/c/config/clean_mysql.sh (added)
+++ webservices/sandesha/trunk/c/config/clean_mysql.sh Wed Apr 25 03:23:35 2007
@@ -0,0 +1,6 @@
+#!/bin/bash
+rm -f logs/*
+mysql -u g -p < mysql_schema_svr_clean.sh
+mysql -u g -p < mysql_schema_client_clean.sh
+rm -f wsf.log
+rm -f wsf_svr.log
Propchange: webservices/sandesha/trunk/c/config/clean_mysql.sh
------------------------------------------------------------------------------
svn:executable = *
Added: webservices/sandesha/trunk/c/config/create_mysql.sh
URL:
http://svn.apache.org/viewvc/webservices/sandesha/trunk/c/config/create_mysql.sh?view=auto&rev=532297
==============================================================================
--- webservices/sandesha/trunk/c/config/create_mysql.sh (added)
+++ webservices/sandesha/trunk/c/config/create_mysql.sh Wed Apr 25 03:23:35 2007
@@ -0,0 +1,3 @@
+#!/bin/bash
+mysql -u g -p < mysql_schema_svr_create.sh
+mysql -u g -p < mysql_schema_client_create.sh
Propchange: webservices/sandesha/trunk/c/config/create_mysql.sh
------------------------------------------------------------------------------
svn:executable = *
Added: webservices/sandesha/trunk/c/config/mysql_schema_client_clean.sh
URL:
http://svn.apache.org/viewvc/webservices/sandesha/trunk/c/config/mysql_schema_client_clean.sh?view=auto&rev=532297
==============================================================================
--- webservices/sandesha/trunk/c/config/mysql_schema_client_clean.sh (added)
+++ webservices/sandesha/trunk/c/config/mysql_schema_client_clean.sh Wed Apr 25
03:23:35 2007
@@ -0,0 +1,9 @@
+#!/bin/bash
+connect sandesha2_client_db;
+delete from create_seq;
+delete from sender;
+delete from next_msg;
+delete from seq_property;
+delete from msg;
+delete from response;
+
Propchange: webservices/sandesha/trunk/c/config/mysql_schema_client_clean.sh
------------------------------------------------------------------------------
svn:executable = *
Added: webservices/sandesha/trunk/c/config/mysql_schema_client_create.sh
URL:
http://svn.apache.org/viewvc/webservices/sandesha/trunk/c/config/mysql_schema_client_create.sh?view=auto&rev=532297
==============================================================================
--- webservices/sandesha/trunk/c/config/mysql_schema_client_create.sh (added)
+++ webservices/sandesha/trunk/c/config/mysql_schema_client_create.sh Wed Apr
25 03:23:35 2007
@@ -0,0 +1,23 @@
+#!/bin/bash
+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) primary key,
+ 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;
Added: webservices/sandesha/trunk/c/config/mysql_schema_svr_clean.sh
URL:
http://svn.apache.org/viewvc/webservices/sandesha/trunk/c/config/mysql_schema_svr_clean.sh?view=auto&rev=532297
==============================================================================
--- webservices/sandesha/trunk/c/config/mysql_schema_svr_clean.sh (added)
+++ webservices/sandesha/trunk/c/config/mysql_schema_svr_clean.sh Wed Apr 25
03:23:35 2007
@@ -0,0 +1,7 @@
+#!/bin/bash
+connect sandesha2_svr_db;
+delete from create_seq;
+delete from sender;
+delete from next_msg;
+delete from seq_property;
+delete from msg;
Added: webservices/sandesha/trunk/c/config/mysql_schema_svr_create.sh
URL:
http://svn.apache.org/viewvc/webservices/sandesha/trunk/c/config/mysql_schema_svr_create.sh?view=auto&rev=532297
==============================================================================
--- webservices/sandesha/trunk/c/config/mysql_schema_svr_create.sh (added)
+++ webservices/sandesha/trunk/c/config/mysql_schema_svr_create.sh Wed Apr 25
03:23:35 2007
@@ -0,0 +1,22 @@
+#!/bin/bash
+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) primary key,
+ 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;
+
Propchange: webservices/sandesha/trunk/c/config/mysql_schema_svr_create.sh
------------------------------------------------------------------------------
svn:executable = *
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
