private String generateTemplateIdSQLStatement(boolean tableExists){
  StringBuffer output=new StringBuffer();
  output.append("CREATE TABLE IF NOT EXISTS " + GeneratorConstants.TABLE_TPLID_TPLNAME + " ("+ "templateId INTEGER NOT NULL AUTO_INCREMENT,"+ "templateName MEDIUMTEXT NOT NULL, "+ "PRIMARY KEY(templateId)); \r\n");
  if (!tableExists) {
    output.append("CREATE INDEX tplIdx ON " + GeneratorConstants.TABLE_TPLID_TPLNAME + "(templateId);");
    output.append("\r\n");
  }
  return output.toString();
}

private String generateTemplateIdSQLStatement ( boolean tableExists ) { StringBuffer output = new StringBuffer ( ) ; output . append ( "CREATE TABLE IF NOT EXISTS " + GeneratorConstants . TABLE_TPLID_TPLNAME + " (" + "templateId INTEGER NOT NULL AUTO_INCREMENT," + "templateName MEDIUMTEXT NOT NULL, " + "PRIMARY KEY(templateId)); \r\n" ) ; if ( ! tableExists ) { output . append ( "CREATE INDEX tplIdx ON " + GeneratorConstants . TABLE_TPLID_TPLNAME + "(templateId);" ) ; output . append ( "\r\n" ) ; } return output . toString ( ) ; }
generate sql statement for table template id - > template name
