"    PRIMARY KEY (\"COL_PK_1\", \"COL_PK_2\"),\n"+ "    CONSTRAINT \"testindex1\" UNIQUE (\"COL_INDEX_2\"),\n"+ "    CONSTRAINT \"testindex2\" UNIQUE (\"COL_INDEX_3\", \"COL_INDEX_1\")\n"+
"    PRIMARY KEY (\"COL_PK_1\", \"COL_PK_2\")\n"+
    public void testTableConstraints() throws Exception    {        assertEqualsIgnoringWhitespaces(            "ALTER TABLE \"table3\" DROP CONSTRAINT \"testfk\";\n"+            "ALTER TABLE \"table2\" DROP CONSTRAINT \"table2_FK_COL_FK_1_COL_FK_2_table1\";\n"+            "DROP TABLE IF EXISTS \"table3\";\n"+            "DROP TABLE IF EXISTS \"table2\";\n"+            "DROP TABLE IF EXISTS \"table1\";\n"+            "CREATE TABLE \"table1\"\n"+            "(\n"+            "    \"COL_PK_1\"    VARCHAR(32) NOT NULL,\n"+            "    \"COL_PK_2\"    INTEGER,\n"+            "    \"COL_INDEX_1\" BINARY(100) NOT NULL,\n"+            "    \"COL_INDEX_2\" DOUBLE NOT NULL,\n"+            "    \"COL_INDEX_3\" CHAR(4),\n"+            "    PRIMARY KEY (\"COL_PK_1\", \"COL_PK_2\"),\n"+            "    CONSTRAINT \"testindex1\" UNIQUE (\"COL_INDEX_2\"),\n"+            "    CONSTRAINT \"testindex2\" UNIQUE (\"COL_INDEX_3\", \"COL_INDEX_1\")\n"+            ");\n"+            "CREATE TABLE \"table2\"\n"+            "(\n"+            "    \"COL_PK\"   INTEGER,\n"+            "    \"COL_FK_1\" INTEGER,\n"+            "    \"COL_FK_2\" VARCHAR(32) NOT NULL,\n"+            "    PRIMARY KEY (\"COL_PK\")\n"+            ");\n"+            "CREATE TABLE \"table3\"\n"+            "(\n"+            "    \"COL_PK\" VARCHAR(16),\n"+            "    \"COL_FK\" INTEGER NOT NULL,\n"+            "    PRIMARY KEY (\"COL_PK\")\n"+            ");\n"+            "ALTER TABLE \"table2\" ADD CONSTRAINT \"table2_FK_COL_FK_1_COL_FK_2_table1\" FOREIGN KEY (\"COL_FK_1\", \"COL_FK_2\") REFERENCES \"table1\" (\"COL_PK_2\", \"COL_PK_1\");\n"+            "ALTER TABLE \"table3\" ADD CONSTRAINT \"testfk\" FOREIGN KEY (\"COL_FK\") REFERENCES \"table2\" (\"COL_PK\");\n",            createTestDatabase(TABLE_CONSTRAINT_TEST_SCHEMA));    }