-- Warning: This deletes all the information that has been created with the plugin

DROP TABLE IF EXISTS smp_milestone_project;
DROP TABLE IF EXISTS smp_project;
DELETE FROM system WHERE name='simplemultiproject_version';

-- Insert the record in the table system

INSERT
INTO
    system
    (
        name,
        value
    )
    VALUES
    (
        'simplemultiproject_version',
        '1'
    );

-- Create tables of projects

CREATE TABLE smp_milestone_project (
    id integer PRIMARY KEY,
    milestone varchar,
    id_project integer
);

CREATE TABLE smp_project (
    id_project integer PRIMARY KEY,
    name varchar,
    description varchar
);
