note 54775 added to ref.sqlite

Sqlite by default allows for foreign keys, but doesn't enforce them. I found a nice article on how to enforce foreign keys at http://www.justatheory.com/computers/databases/sqlite/ It would be nice if this could be handled with a wrapper class, so that adding foreign keys is done thru a wrapper API to automate the generation of the necessary enforcement triggers. If nobody's done this by the time I start coding against SqlLite/PHP5 in 6-12 months, I'll write one myself, possibly by modifying "jon at jenseng dot com"s alter table wrapper Anyway, it's not PHP specific, but anybody using Sqlite really should know this! ---- Manual Page -- http://www.php.net/manual/en/ref.sqlite.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+54775 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+54775&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+54775&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+54775&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+54775&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+54775&report=yes&reason=non-english Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+54775&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+54775&report=yes Search -- http://master.php.net/manage/user-notes.php