public static void createIndex(Connection conn,String schema,String table,String columnList) throws SQLException {
  init(conn);
  PreparedStatement prep=conn.prepareStatement("INSERT INTO " + SCHEMA + ".INDEXES(SCHEMA, TABLE, COLUMNS) VALUES(?, ?, ?)");
  prep.setString(1,schema);
  prep.setString(2,table);
  prep.setString(3,columnList);
  prep.execute();
  createTrigger(conn,schema,table);
  indexExistingRows(conn,schema,table);
}

public static void createIndex ( Connection conn , String schema , String table , String columnList ) throws SQLException { init ( conn ) ; PreparedStatement prep = conn . prepareStatement ( "INSERT INTO " + SCHEMA + ".INDEXES(SCHEMA, TABLE, COLUMNS) VALUES(?, ?, ?)" ) ; prep . setString ( 1 , schema ) ; prep . setString ( 2 , table ) ; prep . setString ( 3 , columnList ) ; prep . execute ( ) ; createTrigger ( conn , schema , table ) ; indexExistingRows ( conn , schema , table ) ; }
create a new full text index for a table and column list . each table may only have one index at any time .
