data_create.sql

-- create table
CREATE TABLE directory(
    name TEXT,
    day INTEGER,
    month INTEGER,
    year INTEGER,
    id INTEGER PRIMARY KEY
);

-- insert values
INSERT INTO directory VALUES
    ("Jack",21,08,1997,1),
    ("Glen",21,11,1955,2),
    ("James",06,06,1966,3)
;