Datafiles to be managed in a table

[gunjanmarothia]

Need to add new datafile table and datafile_links table

[gunjanmarothia]

CREATE TABLE issues (id BIGINT AUTO_INCREMENT, description VARCHAR(255) NOT NULL, status VARCHAR(255) NOT NULL, tester VARCHAR(255), project_id BIGINT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX project_id_idx (project_id), PRIMARY KEY(id)) ENGINE = INNODB; CREATE TABLE datafiles (id BIGINT AUTO_INCREMENT, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(id)) ENGINE = INNODB; CREATE TABLE datafile_issue_link (datafile_id BIGINT NOT NULL, issue_id BIGINT NOT NULL, PRIMARY KEY(datafile_id,issue_id)); ALTER TABLE issues ADD CONSTRAINT issues_project_id_project_category_id FOREIGN KEY (project_id) REFERENCES project_category(id);

[phillipsic]

Do we need this issue in Release_0.3? Seems to be linked to the ISSUES functionality we talked about.