CREATE TABLE barn(
    bid int PRIMARY KEY,
    navn text NOT NULL,
    snill boolean NOT NULL
);

CREATE TABLE gave(
    gid int PRIMARY KEY,
    navn text NOT NULL,
    nyttig boolean NOT NULL
);

CREATE TABLE ?nskeliste(
    barn int REFERENCES barn(bid),
    gave int REFERENCES gave(gid)
);

INSERT INTO barn VALUES
(0, 'Ola', true),
(1, 'Kari', true),
(2, 'Per', false),
(3, 'Nils', true),
(4, 'Mari', false),
(5, 'Kine', false),
(6, 'Jasmin', true);

INSERT INTO gave VALUES
(0, 'Lekebil', false),
(1, 'Sokker', true),
(2, 'Sykkel', true),
(3, 'Lekepistol', false),
(4, 'Dataspill', false),
(5, 'Fuglebrett', true),
(6, 'Dukke', false),
(7, 'Bok', true);

INSERT INTO ?nskeliste VALUES
(1, 0),
(1, 6),
(0, 6),
(0, 5),
(3, 2),
(5, 1),
(5, 3),
(5, 4),
(4, 3),
(4, 0),
(6, 7);