svn commit: r533656 - in /webservices/sandesha/trunk/c/config: sandesha2_schema.bat sqlite_schema.bat

[na...@apache.org]

Author: nandika
Date: Mon Apr 30 03:03:52 2007
New Revision: 533656

URL: http://svn.apache.org/viewvc?view=rev&rev=533656
Log:
sqlite_schema.bat file added

Added:
    webservices/sandesha/trunk/c/config/sqlite_schema.bat
Removed:
    webservices/sandesha/trunk/c/config/sandesha2_schema.bat

Added: webservices/sandesha/trunk/c/config/sqlite_schema.bat
URL: http://svn.apache.org/viewvc/webservices/sandesha/trunk/c/config/sqlite_schema.bat?view=auto&rev=533656
==============================================================================
--- webservices/sandesha/trunk/c/config/sqlite_schema.bat (added)
+++ webservices/sandesha/trunk/c/config/sqlite_schema.bat Mon Apr 30 03:03:52 2007
@@ -0,0 +1,55 @@
+sqlite3 sandesha2_svr_db "drop table create_seq;"
+sqlite3 sandesha2_svr_db "drop table  invoker;"
+sqlite3 sandesha2_svr_db "drop table  sender"
+sqlite3 sandesha2_svr_db "drop table  next_msg"
+sqlite3 sandesha2_svr_db "drop table  seq_property"
+sqlite3 sandesha2_svr_db "drop table  msg"
+sqlite3 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))"
+sqlite3 sandesha2_svr_db "create table invoker(msg_ctx_ref_key varchar(100) primary key, 
+    msg_no long, seq_id varchar(200), is_invoked boolean)"
+sqlite3 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))"
+sqlite3 sandesha2_svr_db "create table next_msg(seq_id varchar(200) primary key, 
+    ref_msg_key varchar(100), polling_mode boolean, msg_no long)"
+sqlite3 sandesha2_svr_db "create table seq_property(id varchar(200) , 
+    seq_id varchar(200), name varchar(200), value varchar(200))"
+sqlite3 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))"
+
+sqlite3 sandesha2_client_db "drop table create_seq;"
+sqlite3 sandesha2_client_db "drop table  invoker;"
+sqlite3 sandesha2_client_db "drop table  sender"
+sqlite3 sandesha2_client_db "drop table  next_msg"
+sqlite3 sandesha2_client_db "drop table  seq_property"
+sqlite3 sandesha2_client_db "drop table  msg"
+sqlite3 sandesha2_client_db "drop table  response"
+sqlite3 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))"
+sqlite3 sandesha2_client_db "create table invoker(msg_ctx_ref_key varchar(100) primary key, 
+    msg_no long, seq_id varchar(200), is_invoked boolean)"
+sqlite3 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))"
+sqlite3 sandesha2_client_db "create table next_msg(seq_id varchar(200) primary key, 
+    ref_msg_key varchar(100), polling_mode boolean, msg_no long)"
+sqlite3 sandesha2_client_db "create table seq_property(id varchar(200) , 
+    seq_id varchar(200), name varchar(200), value varchar(200))"
+sqlite3 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))"
+sqlite3 sandesha2_client_db "create table response(seq_id varchar(200), 
+    response_str text, msg_no int, soap_version int)"
+



---------------------------------------------------------------------
To unsubscribe, e-mail: sandesha-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: sandesha-dev-help@ws.apache.org