X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=examples%2Ffancy_example%2Fbeerdb.sql;h=bd1b6d6671773ba126a02274c679183a899997ec;hb=57b394571a593607a5b7a0ff4bdf9680461cd6a4;hp=6089c942fa02888900bc8ea4d46936bd2034640f;hpb=79aa8d27d124d06bf88b2fc0487ae97563b98936;p=maypole.git

diff --git a/examples/fancy_example/beerdb.sql b/examples/fancy_example/beerdb.sql
index 6089c94..bd1b6d6 100644
--- 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