recaptime.dev
@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.)
hq.recaptime.dev/wiki/Phorge
phorge
phabricator
1CREATE 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
14CREATE 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
26CREATE 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
38CREATE 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;