[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_almanac.almanac_property (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    objectPHID VARBINARY(64) NOT NULL,
   4    fieldIndex BINARY(12) NOT NULL,
   5    fieldName VARCHAR(128) NOT NULL COLLATE {$COLLATE_TEXT},
   6    fieldValue LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT},
   7    UNIQUE KEY `objectPHID` (objectPHID, fieldIndex)
   8  ) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};