1CREATE TABLE number (
2    id INTEGER PRIMARY KEY AUTOINCREMENT,
3    name varchar,
4    number varchar,
5    phone_type varchar
6);
7
8CREATE TABLE bday (
9    id INTEGER PRIMARY KEY AUTOINCREMENT,
10    contact INTEGER,
11    bday date,
12    anniversary date,
13    known_since date
14);
15
16CREATE TABLE tshirt (
17    id INTEGER PRIMARY KEY AUTOINCREMENT,
18    ident varchar
19);
20
21CREATE TABLE color (
22    id INTEGER PRIMARY KEY AUTOINCREMENT,
23    ident varchar,
24    foreigner INTEGER
25);
26
27CREATE TABLE tshirt_color (
28    id INTEGER PRIMARY KEY AUTOINCREMENT,
29    tshirt INTEGER,
30    color INTEGER
31);
32CREATE TABLE tshirt_author (
33    id INTEGER PRIMARY KEY AUTOINCREMENT,
34    tshirt INTEGER,
35    author INTEGER
36);
37CREATE TABLE author (
38    id INTEGER PRIMARY KEY AUTOINCREMENT,
39    ident varchar
40);
41
42CREATE TABLE book (
43    id INTEGER PRIMARY KEY AUTOINCREMENT,
44    ident varchar
45);
46
47CREATE TABLE author_book (
48    id INTEGER PRIMARY KEY AUTOINCREMENT,
49    author INTEGER,
50    book INTEGER,
51    extra_field varchar,
52    second_extra boolean
53);
54
55INSERT INTO author_book ( author, book, extra_field )
56    VALUES ( 1, 1, 'hello' );
57
58CREATE TABLE sch.name (
59    id INTEGER PRIMARY KEY AUTOINCREMENT,
60    name varchar,
61    number varchar
62);
63
64