createDB.sql

CREATE TABLE fileMapping (userID INTEGER NOT NULL, externalFilename VARCHAR(256) NOT NULL, internalFilename CHAR(32) NOT NULL, PRIMARY KEY (userID, externalFilename))
CREATE TABLE results (agentName VARCHAR (256), agentType VARCHAR (256), options VARCHAR (256), dataFile VARCHAR (50), testFile VARCHAR (50), errorRate DOUBLE)
CREATE VIEW filemetadata AS SELECT userid, filemapping.internalfilename, filemapping.externalfilename, defaulttask, attributetype, numberofattributes, numberofinstances, missingvalues FROM filemapping JOIN metadata ON filemapping.internalfilename = metadata.internalfilename
CREATE TRIGGER prepareMetadata AFTER INSERT ON filemapping REFERENCING NEW ROW AS newrow FOR EACH ROW INSERT INTO metadata (internalfilename, externalfilename) VALUES (newrow.internalfilename, newrow.externalfilename)