You are viewing a plain text version of this content. The canonical link for it is here.
Posted to sandesha-dev@ws.apache.org by da...@apache.org on 2007/04/27 10:04:27 UTC
svn commit: r533006 - in /webservices/sandesha/trunk/c/config:
create_mysql_user.sh mysql_schema.sh
Author: damitha
Date: Fri Apr 27 01:04:25 2007
New Revision: 533006
URL: http://svn.apache.org/viewvc?view=rev&rev=533006
Log:
updated scripts
Modified:
webservices/sandesha/trunk/c/config/create_mysql_user.sh
webservices/sandesha/trunk/c/config/mysql_schema.sh
Modified: webservices/sandesha/trunk/c/config/create_mysql_user.sh
URL: http://svn.apache.org/viewvc/webservices/sandesha/trunk/c/config/create_mysql_user.sh?view=diff&rev=533006&r1=533005&r2=533006
==============================================================================
--- webservices/sandesha/trunk/c/config/create_mysql_user.sh (original)
+++ webservices/sandesha/trunk/c/config/create_mysql_user.sh Fri Apr 27 01:04:25 2007
@@ -1,2 +1,5 @@
+Connect to mysql as root user
+mysql -u root -p
+Then execute
grant all privileges on *.* TO 'g'@'localhost' identified by 'g' with grant option;
grant all privileges on *.* TO 'g'@'%' identified by 'g' with grant option;
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=533006&r1=533005&r2=533006
==============================================================================
--- webservices/sandesha/trunk/c/config/mysql_schema.sh (original)
+++ webservices/sandesha/trunk/c/config/mysql_schema.sh Fri Apr 27 01:04:25 2007
@@ -16,7 +16,7 @@
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,
+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),
@@ -37,7 +37,7 @@
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,
+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),
---------------------------------------------------------------------
To unsubscribe, e-mail: sandesha-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: sandesha-dev-help@ws.apache.org