6ZafY4mh

1DROP TABLE IF EXISTS objects;
2CREATE TABLE objects
3(
4    ID INT NOT NULL AUTO_INCREMENT, 
5    filename VARCHAR(200) NOT NULL,
6    objectTypeID INT NOT NULL,
7    parentID INT,
8
9    PRIMARY KEY (ID),
10    FOREIGN KEY (objectTypeID) REFERENCES objectTypes(ID)
11);