The following SQL create table statement is accepted:
CREATE TABLE CST_PAGE_z ( PAGE_ID INTEGER PRIMARY KEY, PAGE_MASTER INTEGER NOT NULL, PAGE_DETAIL INTEGER NOT NULL, PAGE_HIDDEN BOOLEAN NOT NULL DEFAULT 0, FOREIGN KEY(PAGE_MASTER) REFERENCES CST_TABLE(TABLE_ID) ON DELETE CASCADE ON UPDATE RESTRICT FOREIGN KEY(PAGE_DETAIL) REFERENCES CST_TABLE(TABLE_ID) ON DELETE CASCADE ON UPDATE RESTRICT UNIQUE(PAGE_MASTER, PAGE_DETAIL) ); Notice the absent of the comma's separating the table constraints. According to the documentation (https://www.sqlite.org/lang_createtable.html) these comma's are not optional. An external SQL parser based on the SQLite official documentation complaints about this. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
