CREATE CUSTOM SCHEMA BY DEFAULT OTHER THAN PUBLIC

Hello Fred,
 Recently i have created hsqldb script where i found as
.
.
.
CREATE USER "RTN_TEST_NEW" PASSWORD DIGEST
'a189c633d9995e11bf8607170ec9a4b8'
ALTER USER "RTN_TEST_NEW" SET LOCAL TRUE
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE SCHEMA NEXXUS AUTHORIZATION "RTN_TEST_NEW"
SET SCHEMA PUBLIC
CREATE MEMORY TABLE *PUBLIC*.DUAL(ID VARCHAR(10))
.
.
.

default schema as public but i need RTN_TEST_NEW as default schema not
public..
by explicitly creating scheme RTN_TEST_NEW it works but i want default
schema as RTN_TEST_NEW, how could it be possible???
please help me..!!

-Deep



--
View this message in context: http://hsqldb.10974.n7.nabble.com/CREATE-CUSTOM-SCHEMA-BY-DEFAULT-OTHER-THAN-PUBLIC-tp3903.html
Sent from the HSQLDB - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1