jmitchell 2004/06/10 19:53:37
Added: resources/src/conf mysql.sql
Log:
Changes required to support move of JDBC and Hibernate impls.
Revision Changes Path
1.1 jakarta-commons-sandbox/resources/src/conf/mysql.sql
Index: mysql.sql
===================================================================
MySql Script to create an example database
------------------------------------
CREATE DATABASE resources;
use resources;
FLUSH PRIVILEGES;
drop table resources;
create table resources (
locale varchar(10) not null,
msgKey varchar(255) not null,
val varchar(255),
Primary Key(
locale,
msgKey
)
);
GRANT Select ON resources.* TO 'resourcesTest'@'localhost' IDENTIFIED BY
'resourcesTest';
Insert into resources (locale, msgKey, val) Values ('', 'test.base', '[Base] ONLY');
Insert into resources (locale, msgKey, val) Values ('', 'test.specific', '[Base]
SPECIFIC');
Insert into resources (locale, msgKey, val) Values ('', 'test.inherit', '[Base]
INHERIT');
Insert into resources (locale, msgKey, val) Values ('', 'test.message', '[Base]
REPLACE {0} WITH {1}');
Insert into resources (locale, msgKey, val) Values ('en', 'test.specific', '[en]
SPECIFIC');
Insert into resources (locale, msgKey, val) Values ('en', 'test.inherit', '[en]
INHERIT');
Insert into resources (locale, msgKey, val) Values ('en_US', 'test.specific',
'[en_US] SPECIFIC');
Insert into resources (locale, msgKey, val) Values ('fr', 'test.specific', '[fr]
SPECIFIC');
Insert into resources (locale, msgKey, val) Values ('fr', 'test.inherit', '[fr]
INHERIT');
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
