USE internationaliser;
/**
 * projects
 */
DROP TABLE IF EXISTS projects;
CREATE TABLE projects (
   /**
    * short 8-char name for project. All lower case
    */
   uniqueProjectID VARCHAR( 8 ) NOT NULL,
   /**
    * long name for project
    */
   projectName VARCHAR( 30 ) NOT NULL,
   /**
    * A regular expression (see http://mindprod.com/jgloss/regex.html)
    * that is used to validate translationKeys used in Java source code
    * for the entire project
    * By default all possible non-empty Strings are considered valid.
    * To allow only upper case, colon, underscore and dot use [A-Z\\:\\_\\.]++
    */
   translationKeyRegex VARCHAR( 200 )  NOT NULL,
   /**
    * We look up projects by uniqueProjectID
    * We also use uniqueProjectID to link in other tables
    * to link to this information.
    */
   PRIMARY KEY( uniqueProjectID )
   );