CREATE TABLE person (
    id   INTEGER NOT NULL,
    name TEXT,
    PRIMARY KEY ( id )
);
CREATE TABLE friend (
    person INTEGER NOT NULL,
    friend INTEGER NOT NULL,
    PRIMARY KEY ( person, friend )
);