executeUpdate(conn, "DROP TABLE doFields", true); executeUpdate(conn, "DROP TABLE dcDates", true); executeUpdate(conn, "CREATE TABLE doFields (\n" + "pid VARCHAR(64) NOT NULL,\n" + "label VARCHAR(255) NOT NULL,\n" + "dcCoverage CLOB,\n" + "dcRights CLOB)", false); executeUpdate(conn, "CREATE INDEX doFields_pid ON doFields (pid)", false); executeUpdate(conn, "CREATE TABLE dcDates (\n" + "pid VARCHAR(64) NOT NULL," + "dcDate BIGINT NOT NULL)", false); executeUpdate(conn, "CREATE INDEX dcDates_pid ON dcDates (pid)", false); cPool.free(conn);