2 id integer primary key auto_increment,
8 id integer primary key auto_increment,
14 CREATE TABLE handpump (
15 id integer primary key auto_increment,
21 id integer primary key auto_increment,
32 CREATE TABLE brewery (
33 id integer primary key auto_increment,
39 CREATE TABLE drinker (
40 id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
41 person INTEGER UNSIGNED NOT NULL,
42 handle VARCHAR(20) NOT NULL,
43 created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
45 INDEX drinker_FKIndex1(person)
49 id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
50 first_name VARCHAR(50) NULL,
51 sur_name VARCHAR(50) NULL,
53 username VARCHAR(20) NULL,
54 password VARCHAR(20) NULL,
55 email VARCHAR(255) NULL,
60 id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
61 drinker INTEGER UNSIGNED NOT NULL,
62 handpump INTEGER UNSIGNED NOT NULL,
63 date_and_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,