1CREATE TABLE addresslist (
2    id INTEGER PRIMARY KEY AUTOINCREMENT,
3    firstname TEXT NOT NULL,
4    surname TEXT NOT NULL,
5    cfunction TEXT NOT NULL,
6    tel1 TEXT NOT NULL,
7    tel2 TEXT NOT NULL,
8    fax TEXT NOT NULL,
9    email TEXT NOT NULL,
10    department TEXT NOT NULL,
11    description TEXT NOT NULL,
12    photo BLOB
13);
14