[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_flag.flag (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    ownerPHID varchar(64) COLLATE utf8_bin NOT NULL,
   4    type varchar(4) COLLATE utf8_bin NOT NULL,
   5    objectPHID varchar(64) COLLATE utf8_bin NOT NULL,
   6    reasonPHID varchar(64) COLLATE utf8_bin NOT NULL,
   7    color INT UNSIGNED NOT NULL,
   8    note varchar(255) COLLATE utf8_general_ci,
   9    dateCreated INT UNSIGNED NOT NULL,
  10    dateModified INT UNSIGNED NOT NULL,
  11  
  12    UNIQUE KEY (ownerPHID, type, objectPHID),
  13    KEY (objectPHID)
  14  ) ENGINE=InnoDB;