folders

CREATE TABLE folder_groups {  id VARCHAR(64),  name VARCHAR(64),  ownerID INT   PRIMARY KEY (id));CREATE TABLE folders (   id INT NOT NULL,  folderGroupID VARCHAR(64) REFERENCES folder_groups(id),  releaseDate INT,  PRIMARY KEY (id) );CREATE TABLE records (  id INT NOT NULL,  name VARCHAR(64),  mode INT,  direction INT,  foo VARCHAR(64),  bar VARCHAR(64), /* and so on... */  PRIMARY KEY (id) );CREATE TABLE folder_records (  folderID INT REFERENCES folders(id),  recordID INT REFERENCES records(id) );INSERT INTO folders (id, folderGroupID, releaseDate) VALUES  (1, "Folder A", 20070101),  (2, "Folder B", 20070101),  (3, "Folder A", 20070601),  (4, "Folder A", 20080101);INSERT INTO records (id, name, mode, direction, foo, bar ) VALUES  (1, "Record A", 1, 1, "my foo", "my bar"),  (2, "Record B", 1, 1, "my boo", "my bar"),  (3, "Record C", 1, 1, "my coo", "my car"),  (4, "Record D", 2, 3, "other foo", "other bar"),  (5, "Record E", 2, 3, "other foo 2", "other bar 2"),  (6, "Record A", 1, 1, "my oak", "my oar");  /* note: modified for 20080101 */INSERT INTO folder_records (folderID, recordID) VALUES  (1, 1),  (1, 2),  (1, 3),  (2, 1),  (2, 4),  (2, 5);