[Summary view] [Print] [Text view]

   1  CREATE TABLE `{$NAMESPACE}_oauth_server`.`oauth_server_oauthserverclient` (
   2    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   3    `phid` varchar(64) BINARY NOT NULL,
   4    `name` varchar(255) NOT NULL,
   5    `secret` varchar(32) NOT NULL,
   6    `redirectURI` varchar(255) NOT NULL,
   7    `creatorPHID` varchar(64) BINARY NOT NULL,
   8    `dateCreated` int(10) unsigned NOT NULL,
   9    `dateModified` int(10) unsigned NOT NULL,
  10    PRIMARY KEY (`id`),
  11    UNIQUE KEY `phid` (`phid`)
  12  ) ENGINE=InnoDB;
  13  
  14  CREATE TABLE `{$NAMESPACE}_oauth_server`.`oauth_server_oauthclientauthorization` (
  15    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  16    `phid` varchar(64) BINARY NOT NULL,
  17    `userPHID` varchar(64) BINARY NOT NULL,
  18    `clientPHID` varchar(64) BINARY NOT NULL,
  19    `dateCreated` int(10) unsigned NOT NULL,
  20    `dateModified` int(10) unsigned NOT NULL,
  21    PRIMARY KEY (`id`),
  22    UNIQUE KEY `phid` (`phid`),
  23    UNIQUE KEY `userPHID` (`userPHID`,`clientPHID`)
  24  ) ENGINE=InnoDB;
  25  
  26  CREATE TABLE `{$NAMESPACE}_oauth_server`.`oauth_server_oauthserverauthorizationcode` (
  27    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  28    `code` varchar(32) NOT NULL,
  29    `clientPHID` varchar(64) BINARY NOT NULL,
  30    `clientSecret` varchar(32) NOT NULL,
  31    `userPHID` varchar(64) BINARY NOT NULL,
  32    `dateCreated` int(10) unsigned NOT NULL,
  33    `dateModified` int(10) unsigned NOT NULL,
  34    PRIMARY KEY (`id`),
  35    UNIQUE KEY `code` (`code`)
  36  ) ENGINE=InnoDB;
  37  
  38  CREATE TABLE `{$NAMESPACE}_oauth_server`.`oauth_server_oauthserveraccesstoken` (
  39    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  40    `token` varchar(32) NOT NULL,
  41    `userPHID` varchar(64) BINARY NOT NULL,
  42    `clientPHID` varchar(64) BINARY NOT NULL,
  43    `dateExpires` int(10) unsigned NOT NULL,
  44    `dateCreated` int(10) unsigned NOT NULL,
  45    `dateModified` int(10) unsigned NOT NULL,
  46    PRIMARY KEY (`id`),
  47    UNIQUE KEY `token` (`token`)
  48  ) ENGINE=InnoDB;