"    COL_INDEX_1 VARBINARY(100) NOT NULL,\n"+ "    COL_INDEX_2 FLOAT NOT NULL,\n"+
"    COL_INDEX_1 BINARY(100) NOT NULL,\n"+ "    COL_INDEX_2 DOUBLE NOT NULL,\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 VARBINARY(100) NOT NULL,\n"+            "    COL_INDEX_2 FLOAT NOT NULL,\n"+            "    COL_INDEX_3 CHAR(4),\n"+            "    PRIMARY KEY (COL_PK_1, COL_PK_2)\n"+            ");\n"+            "CREATE INDEX testindex1 ON table1 (COL_INDEX_2);\n"+            "CREATE UNIQUE INDEX testindex2 ON table1 (COL_INDEX_3, COL_INDEX_1);\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));    }