CREATE TABLE Assets (
  ID VARCHAR(36) NOT NULL,
  MetadataID VARCHAR(36) NOT NULL,  
  Type TINYINT DEFAULT NULL,
  Name VARCHAR(64) DEFAULT NULL,
  Description VARCHAR(64) DEFAULT NULL,
  Local BIT DEFAULT NULL,
  Temporary BIT DEFAULT NULL,
  Data BLOB,
  PRIMARY KEY (ID)
);
