HYTOS

CREATE TABLE IF NOT EXISTS DBTypes (

    UID  INTEGER PRIMARY KEY AUTOINCREMENT

                 NOT NULL,

    Name TEXT

);

INSERT INTO DBTypes(Name) select 'SQLite' where not exists(select 1 from DBTypes where Name='SQLite');

INSERT INTO DBTypes(Name) select 'MSSQL' where not exists(select 1 from DBTypes where Name='MSSQL');

CREATE TABLE IF NOT EXISTS DBSettings (

    UID          INTEGER PRIMARY KEY AUTOINCREMENT

                         NOT NULL,

    Projects_UID INTEGER REFERENCES Projects (Id) 

                         NOT NULL,

    DBTypes_UID  INTEGER REFERENCES DBTypes (UID) 

                         NOT NULL,

    Host         TEXT,

    User         TEXT,

    Password     TEXT,

    FilePath     TEXT,

    UNIQUE (

        Projects_UID

    )

);