[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_passphrase.passphrase_credential (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    name VARCHAR(255) NOT NULL,
   5    credentialType VARCHAR(64) NOT NULL COLLATE utf8_bin,
   6    providesType VARCHAR(64) NOT NULL COLLATE utf8_bin,
   7    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
   8    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
   9    description LONGTEXT NOT NULL COLLATE utf8_bin,
  10    username VARCHAR(255) NOT NULL,
  11    secretID INT UNSIGNED,
  12    isDestroyed BOOL NOT NULL,
  13    dateCreated INT UNSIGNED NOT NULL,
  14    dateModified INT UNSIGNED NOT NULL,
  15  
  16    UNIQUE KEY `key_phid` (phid),
  17    KEY `key_type` (credentialType),
  18    KEY `key_provides` (providesType),
  19    UNIQUE KEY `key_secret` (secretID)
  20  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  21  
  22  CREATE TABLE {$NAMESPACE}_passphrase.passphrase_secret (
  23    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  24    secretData LONGBLOB NOT NULL
  25  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  26  
  27  CREATE TABLE {$NAMESPACE}_passphrase.passphrase_credentialtransaction (
  28    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  29    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  30    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  31    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  32    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  33    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  34    commentPHID VARCHAR(64) COLLATE utf8_bin,
  35    commentVersion INT UNSIGNED NOT NULL,
  36    transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
  37    oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
  38    newValue LONGTEXT NOT NULL COLLATE utf8_bin,
  39    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
  40    metadata LONGTEXT NOT NULL COLLATE utf8_bin,
  41    dateCreated INT UNSIGNED NOT NULL,
  42    dateModified INT UNSIGNED NOT NULL,
  43  
  44    UNIQUE KEY `key_phid` (phid),
  45    KEY `key_object` (objectPHID)
  46  ) ENGINE=InnoDB, COLLATE utf8_general_ci;