X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=catagits%2FCatalyst-Manual.git;a=blobdiff_plain;f=lib%2FCatalyst%2FManual%2FTutorial%2F10_Appendices.pod;fp=lib%2FCatalyst%2FManual%2FTutorial%2F10_Appendices.pod;h=9d088d1ee5f174fc2306c2992b223d635697bddd;hp=84c5d6a7dc83bf37598ba7719275c897da229cfc;hb=02bb2b5a140dc22d7d002fcdce868656d704676a;hpb=388f66e0214312ffa77b48128d2fa2e1932b4669 diff --git a/lib/Catalyst/Manual/Tutorial/10_Appendices.pod b/lib/Catalyst/Manual/Tutorial/10_Appendices.pod index 84c5d6a..9d088d1 100644 --- a/lib/Catalyst/Manual/Tutorial/10_Appendices.pod +++ b/lib/Catalyst/Manual/Tutorial/10_Appendices.pod @@ -2,7 +2,6 @@ Catalyst::Manual::Tutorial::10_Appendices - Catalyst Tutorial - Chapter 10: Appendices - =head1 OVERVIEW This is B for the Catalyst tutorial. @@ -616,23 +615,23 @@ Open the F in your editor and enter: -- Create a very simple database to hold book and author information -- CREATE TABLE IF NOT EXISTS `books` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `title` text CHARACTER SET utf8, - `rating` int(11) DEFAULT NULL, - PRIMARY KEY (`id`) + `id` int(11) NOT NULL AUTO_INCREMENT, + `title` text CHARACTER SET utf8, + `rating` int(11) DEFAULT NULL, + PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 'book_authors' is a many-to-many join table between books & authors CREATE TABLE IF NOT EXISTS `book_authors` ( - `book_id` int(11) NOT NULL DEFAULT '0', - `author_id` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`book_id`,`author_id`), - KEY `author_id` (`author_id`) + `book_id` int(11) NOT NULL DEFAULT '0', + `author_id` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`book_id`,`author_id`), + KEY `author_id` (`author_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `authors` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `first_name` text CHARACTER SET utf8, - `last_name` text CHARACTER SET utf8, - PRIMARY KEY (`id`) + `id` int(11) NOT NULL AUTO_INCREMENT, + `first_name` text CHARACTER SET utf8, + `last_name` text CHARACTER SET utf8, + PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- --- Load some sample data @@ -751,25 +750,25 @@ Open F in your editor and enter: -- Add users and roles tables, along with a many-to-many join table -- CREATE TABLE IF NOT EXISTS `roles` ( - `id` int(11) NOT NULL, - `role` text CHARACTER SET utf8, - PRIMARY KEY (`id`) + `id` int(11) NOT NULL, + `role` text CHARACTER SET utf8, + PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `users` ( - `id` int(11) NOT NULL, - `username` text CHARACTER SET utf8, - `password` text CHARACTER SET utf8, - `email_address` text CHARACTER SET utf8, - `first_name` text CHARACTER SET utf8, - `last_name` text CHARACTER SET utf8, - `active` int(11) DEFAULT NULL, - PRIMARY KEY (`id`) + `id` int(11) NOT NULL, + `username` text CHARACTER SET utf8, + `password` text CHARACTER SET utf8, + `email_address` text CHARACTER SET utf8, + `first_name` text CHARACTER SET utf8, + `last_name` text CHARACTER SET utf8, + `active` int(11) DEFAULT NULL, + PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `user_roles` ( - `user_id` int(11) NOT NULL DEFAULT '0', - `role_id` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`user_id`,`role_id`), - KEY `role_id` (`role_id`) + `user_id` int(11) NOT NULL DEFAULT '0', + `role_id` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`user_id`,`role_id`), + KEY `role_id` (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Load up some initial test data