[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_auth.auth_providerconfig (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    providerClass VARCHAR(128) NOT NULL COLLATE utf8_bin,
   5    providerType VARCHAR(64) NOT NULL COLLATE utf8_bin,
   6    providerDomain VARCHAR(128) NOT NULL COLLATE utf8_bin,
   7    isEnabled BOOL NOT NULL,
   8    shouldAllowLogin BOOL NOT NULL,
   9    shouldAllowRegistration BOOL NOT NULL,
  10    shouldAllowLink BOOL NOT NULL,
  11    shouldAllowUnlink BOOL NOT NULL,
  12    properties LONGTEXT NOT NULL COLLATE utf8_bin,
  13    dateCreated INT UNSIGNED NOT NULL,
  14    dateModified INT UNSIGNED NOT NULL,
  15    UNIQUE KEY `key_phid` (phid),
  16    KEY `key_class` (providerClass),
  17    UNIQUE KEY `key_provider` (providerType, providerDomain)
  18  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  19  
  20  CREATE TABLE {$NAMESPACE}_auth.auth_providerconfigtransaction (
  21    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  22    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  23    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  24    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  25    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  26    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  27    commentPHID VARCHAR(64) COLLATE utf8_bin,
  28    commentVersion INT UNSIGNED NOT NULL,
  29    transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
  30    oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
  31    newValue LONGTEXT NOT NULL COLLATE utf8_bin,
  32    metadata LONGTEXT NOT NULL COLLATE utf8_bin,
  33    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
  34    dateCreated INT UNSIGNED NOT NULL,
  35    dateModified INT UNSIGNED NOT NULL,
  36  
  37    UNIQUE KEY `key_phid` (phid),
  38    KEY `key_object` (objectPHID)
  39  
  40  ) ENGINE=InnoDB, COLLATE utf8_general_ci;