fixes for bug 29982 Inconsistency between examples and tutorial

[maypole.git] / examples / fancy_example / beerdb.sql

diff --git a/examples/fancy_example/beerdb.sql b/examples/fancy_example/beerdb.sql
index 6089c942fa02888900bc8ea4d46936bd2034640f..bd1b6d6671773ba126a02274c679183a899997ec 100644 (file)
--- a/examples/fancy_example/beerdb.sql
+++ b/examples/fancy_example/beerdb.sql
@@ -1,24 +1,24 @@
 CREATE TABLE style (
-    id integer primary key auto_increment,
+    id integer UNSIGNED NOT NULL primary key auto_increment,
     name varchar(60),
     notes text
 );
 
 CREATE TABLE pub (
-    id integer primary key auto_increment,
+    id integer UNSIGNED NOT NULLprimary key auto_increment,
     name varchar(60),
     url varchar(120),
     notes text
 );
 
 CREATE TABLE handpump (
-    id integer primary key auto_increment,
+    id integer UNSIGNED NOT NULL primary key auto_increment,
     beer integer,
     pub integer
 );
 
 CREATE TABLE beer (
-    id integer primary key auto_increment,
+    id integer UNSIGNED NOT NULL primary key auto_increment,
     brewery integer,
     style integer,
     name varchar(30),
@@ -30,7 +30,7 @@ CREATE TABLE beer (
 );
 
 CREATE TABLE brewery (
-    id integer  primary key auto_increment,
+    id integer UNSIGNED NOT NULL primary key auto_increment,
     name varchar(30),
     url varchar(50),
     notes text