// **************************************************************************
public static void createTable(DbConnection dbConn) throws Exception {
String indexName, indexName2, indexName3;
String colNamesIndex, colNamesIndex2, colNamesIndex3;
DbIndexDef indexDef, indexDef2, indexDef3;
indexName = TN + "1";
colNamesIndex = "ID";
indexName2 = TN + "2";
colNamesIndex2 = "NAME";
indexName3 = TN + "3";
colNamesIndex3 = "DEPTID";
indexDef = new DbIndexDef(indexName, colNamesIndex, true);
indexDef2 = new DbIndexDef(indexName2, colNamesIndex2, true);
indexDef3 = new DbIndexDef(indexName3, colNamesIndex3, false);
DbTableFns.createTable(dbConn, TN, ACD);
DbTableFns.createIndex(dbConn, TN, indexDef);
DbTableFns.createIndex(dbConn, TN, indexDef2);
DbTableFns.createIndex(dbConn, TN, indexDef3);
}
