code: private String generateTemplateIdSQLStatement(boolean tableExists)
  	{
  		StringBuffer output = new StringBuffer();
  
  		// Statement creates table for Template Id -> Template Name
  		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();
  
  	}
docs: Generate sql statement for table template id -> template name
  
  @param tableExists
  if this table does not exists create index
  @return sql statement