From: Rafael Kitover Date: Tue, 2 Feb 2010 08:36:25 +0000 (+0000) Subject: add PRAGMA foreign_keys = ON; to the DDL X-Git-Tag: v5.8005~53 X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=catagits%2FCatalyst-Manual.git;a=commitdiff_plain;h=c5b13dd3a313c85acce3bcdaf4d3f0251204c6b4;hp=e586b5f4ce4e2e39068105ed4e3cc4b8fd736569 add PRAGMA foreign_keys = ON; to the DDL --- diff --git a/lib/Catalyst/Manual/Tutorial/03_MoreCatalystBasics.pod b/lib/Catalyst/Manual/Tutorial/03_MoreCatalystBasics.pod index 46e209a..ae57b39 100644 --- a/lib/Catalyst/Manual/Tutorial/03_MoreCatalystBasics.pod +++ b/lib/Catalyst/Manual/Tutorial/03_MoreCatalystBasics.pod @@ -567,6 +567,7 @@ SQLite (L), a popular database that is lightweight and easy to use. Be sure to get at least version 3. Open C in your editor and enter: + PRAGMA foreign_keys = ON; -- -- Create a very simple database to hold book and author information -- diff --git a/lib/Catalyst/Manual/Tutorial/05_Authentication.pod b/lib/Catalyst/Manual/Tutorial/05_Authentication.pod index 62dab98..aa0c386 100644 --- a/lib/Catalyst/Manual/Tutorial/05_Authentication.pod +++ b/lib/Catalyst/Manual/Tutorial/05_Authentication.pod @@ -81,6 +81,7 @@ add the role information here although it will not be used until the authorization section, Chapter 6). Create a new SQL script file by opening C in your editor and insert: + PRAGMA foreign_keys = ON; -- -- Add user and role tables, along with a many-to-many join table --