Parent Directory | Revision Log | Patch
--- jakarta/commons/proper/resources/trunk/src/test/init.sql 2005/05/13 05:14:04 169943 +++ jakarta/commons/proper/resources/trunk/src/test/init.sql 2005/05/13 05:14:46 169944 @@ -1,28 +1,29 @@ --- Script to create an example database ------------------------------------- - -DROP TABLE RESOURCES; - -create table resources ( - locale varchar(10) not null, - msgKey varchar(255) not null, - val varchar(255), - Primary Key( - locale, - msgKey - ) -); - -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'); - +-- Script to create an example database +------------------------------------ + +DROP TABLE RESOURCES; + +create table resources ( + locale varchar(10) not null, + msgKey varchar(255) not null, + val varchar(255), + Primary Key( + locale, + msgKey + ) +); + +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.single', '[Base] REPLACE {0}'); +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'); +
infrastructure at apache.org | ViewVC Help |
Powered by ViewVC 1.1.26 |