"    \"COL_INDEX_2\" NUMBER(38) NOT NULL,\n"+
"    \"COL_INDEX_2\" DOUBLE PRECISION NOT NULL,\n"+
    public void testTableConstraints() throws Exception    {        assertEqualsIgnoringWhitespaces(            "DROP TABLE \"table3\" CASCADE CONSTRAINTS;\n"+            "DROP TABLE \"table2\" CASCADE CONSTRAINTS;\n"+            "DROP TABLE \"table1\" CASCADE CONSTRAINTS;\n"+            "CREATE TABLE \"table1\"\n"+            "(\n"+            "    \"COL_PK_1\"    VARCHAR2(32) NOT NULL,\n"+            "    \"COL_PK_2\"    NUMBER(20,0),\n"+            "    \"COL_INDEX_1\" RAW(100) NOT NULL,\n"+            "    \"COL_INDEX_2\" NUMBER(38) 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\"   NUMBER(20,0),\n"+            "    \"COL_FK_1\" NUMBER(20,0),\n"+            "    \"COL_FK_2\" VARCHAR2(32) NOT NULL,\n"+            "    PRIMARY KEY (\"COL_PK\")\n"+            ");\n"+            "CREATE TABLE \"table3\"\n"+            "(\n"+            "    \"COL_PK\" VARCHAR2(16),\n"+            "    \"COL_FK\" NUMBER(20,0) NOT NULL,\n"+            "    PRIMARY KEY (\"COL_PK\")\n"+            ");\n"+            "ALTER TABLE \"table2\" ADD CONSTRAINT \"table2_FK_COL_F_OL_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));    }