private static final String CREATE_TABLE_SQL = "create table " + CLIENT_TABLE_NAME + "(CLIENT_ID_PRIMARY_KEY char(36) primary key," + "FIRST_NAME tinytext, LAST_NAME tinytext, EMAIL_ADDRESS tinytext, PASSWORD tinytext, " + "STREET_ADDRESS tinytext, CITY tinytext, POSTAL_OR_ZIP_CODE tinytext, PROVINCE_OR_STATE tinytext, COUNTRY tinytext," + "PHONE tinytext, LANGUAGE varchar(2)," + "CREATION_TIME timestamp, LAST_UPDATE_TIME timestamp, LAST_ACCESSED_TIME timestamp);"; private static final String CREATE_TABLE_SQL = "create table OPTION_SETTING(OPTION_SETTING_PRIMARY_KEY char(36) primary key, " + "ACTIVE tinyint(1), SECURITY_LEVEL tinytext);";