1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
SQLite format 3···@  N·N··N.4 
·
�·0·�
��
······�ytablegamesgames·CREATE TABLE games(
                game_id integer primary key autoincrement,
                h_team_id integer,
                o_team_id integer,
                h_points integer,
                o_points integer,
                date text,
                FOREIGN KEY(h_team_id) REFERENCES teams(id),
                FOREIGN KEY(o_team_id) REFERENCES teams(id)
        )P···++·Ytablesqlite_sequencesqlite_sequence·CREATE TABLE sqlite_sequence(name,seq)|······�Wtableteamsteams·CREATE TABLE teams(
            id integer primary key autoincrement,
            name text
        )
·
·
·
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX