1 5 package org.h2.test.synth; 6 7 public class Index { 8 Table table; 9 String name; 10 Column[] columns; 11 boolean unique; 12 13 Index(Table table, String name, Column[] columns, boolean unique) { 14 this.table = table; 15 this.name = name; 16 this.columns = columns; 17 this.unique = unique; 18 } 19 20 public String getName() { 21 return name; 22 } 23 24 public String getCreateSQL() { 25 String sql = "CREATE "; 26 if(unique) { 27 sql += "UNIQUE "; 28 } 29 sql += "INDEX " + name + " ON " + table.getName() + "("; 30 for(int i=0; i<columns.length; i++) { 31 if(i>0) { 32 sql += ", "; 33 } 34 sql += columns[i].getName(); 35 } 36 sql += ")"; 37 return sql; 38 } 39 40 public String getDropSQL() { 41 return "DROP INDEX " + name; 42 } 43 44 public Table getTable() { 45 return table; 46 } 47 48 } 49 | Popular Tags |