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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
