On 01/01/2011 11:27 AM, Kenneth Ballard wrote: > I apologize for not providing that initially. Here is the schema for the > three tables: > > CREATE TABLE [T3] ( > [f1] INTEGER NOT NULL CONSTRAINT [fk_T3_T2] REFERENCES [T2]([f1]) ON > DELETE CASCADE, > [f2] INTEGER NOT NULL, > [f3] INTEGER NOT NULL, > [f4] INTEGER NOT NULL, > [f5] INTEGER NOT NULL, > [f6] INTEGER NOT NULL, > CONSTRAINT [sqlite_autoindex_T3_1] PRIMARY KEY ([f1], [f2])); > > CREATE TABLE [T2] ( > [f1] INTEGER NOT NULL PRIMARY KEY, > [f2] INTEGER NOT NULL CONSTRAINT [fk_T2_T1] REFERENCES [T1](f1]) ON > DELETE CASCADE, > [f3] TEXT NOT NULL); > > CREATE TABLE [T1] ( > [f1] INTEGER NOT NULL, > [f2] NUMERIC NOT NULL, > [f3] TEXT NOT NULL);
[T1].[f1] needs to be a PRIMARY KEY or have UNIQUE. http://www.sqlite.org/foreignkeys.html#fk_indexes _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
