[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_token.token_given (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   5    tokenPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   6    dateCreated INT UNSIGNED NOT NULL,
   7    dateModified INT UNSIGNED NOT NULL,
   8    UNIQUE KEY `key_all` (objectPHID, authorPHID),
   9    KEY `key_author` (authorPHID),
  10    KEY `key_token` (tokenPHID)
  11  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  12  
  13  CREATE TABLE {$NAMESPACE}_token.token_count (
  14    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  15    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  16    tokenCount INT NOT NULL,
  17    UNIQUE KEY `key_objectPHID` (objectPHID)
  18  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;