commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jmitch...@apache.org
Subject cvs commit: jakarta-commons-sandbox/resources/contrib/jdbc/sql mysql.sql
Date Thu, 05 Feb 2004 03:24:08 GMT
jmitchell    2004/02/04 19:24:08

  Added:       resources/contrib/jdbc/sql mysql.sql
  Log:
  Typical sql script to create database and table for JDBC (and other)
  database implementations.
  
  Revision  Changes    Path
  1.1                  jakarta-commons-sandbox/resources/contrib/jdbc/sql/mysql.sql
  
  Index: mysql.sql
  ===================================================================
  MySql Script to create test 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


Mime
View raw message