cvs commit: jakarta-commons-sandbox/resources/src/conf mysql.sql

[jm...@apache.org]

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: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org