SQLite Forum

'ON DELETE CASCADE' seems to not be working
Login
> declaring something both UNIQUE and a PRIMARY KEY is a doubly redundant redundancy

So is declaring PRIMARY KEY NOT NULL, but nevertheless you have to do it ;) (I know it's a bug, but you still have to do it.)