The HaskellDB Guide to Hacking

We hope that you have found how to generate a database. This gives examples that work on the database FARMING. The source code in sql is found here
What do you want to do?
The database FARMING 
mysql> describe farmers;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| farmer_id | int(11)     |      |     | 0       |       |
| name      | varchar(30) |      |     |         |       |
| farm_id   | int(11)     |      |     | 0       |       |
+-----------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> select * from farmers;
+-----------+----------+---------+
| farmer_id | name     | farm_id |
+-----------+----------+---------+
|         0 | John Doe |       0 |
|         1 | Jane Doe |       0 |
+-----------+----------+---------+
2 rows in set (0.00 sec)

================================================================

mysql> describe farms;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| farm_id   | int(11)     |      |     | 0       |       |
| farm_name | varchar(30) |      |     |         |       |
| size      | int(11)     |      |     | 0       |       |
| cows      | int(11)     | YES  |     | NULL    |       |
| chickens  | int(11)     | YES  |     | NULL    |       |
| est       | date        | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql> select * from farms;
+---------+-----------+------+------+----------+------------+
| farm_id | farm_name | size | cows | chickens | est        |
+---------+-----------+------+------+----------+------------+
|       1 | Emmerdale | 1002 |   10 |      106 | 1725-03-06 |
|       0 | Doebrook  |  375 |    3 |       15 | 1893-01-01 |
+---------+-----------+------+------+----------+------------+
2 rows in set (0.00 sec)

Here are all words and functions with references, in alphabetical order