[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_file.file_transformedfile (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    originalPHID varchar(64) COLLATE `binary` NOT NULL,
   4    transform varchar(255) COLLATE `binary` NOT NULL,
   5    unique key (originalPHID, transform),
   6    transformedPHID varchar(64) BINARY NOT NULL,
   7    key (transformedPHID),
   8    dateCreated INT UNSIGNED NOT NULL,
   9    dateModified INT UNSIGNED NOT NULL
  10  );