CREATE TABLE Packages (
    id      INTEGER PRIMARY KEY,
    package VARCHAR(100),
    maintainer VARCHAR(100),
    licence VARCHAR(100),
    summary VARCHAR(100),
    STATUS VARCHAR(30)
);

CREATE TABLE Content (
        id      INTEGER PRIMARY KEY,
    package VARCHAR(100),
    content VARCHAR(250)
);

CREATE TABLE Rundeps (
        id      INTEGER PRIMARY KEY,
    package VARCHAR(100),
    depends VARCHAR(250)
);

CREATE TABLE Buildeps (
    package VARCHAR(100),
    buildeps VARCHAR(250)
);

CREATE TABLE Optdeps (
        id      INTEGER PRIMARY KEY,
    package VARCHAR(100),
    optdeps VARCHAR(250)
);

CREATE TABLE Conflicts (
        id      INTEGER PRIMARY KEY,
    package VARCHAR(100),
    conflicts VARCHAR(250)
);