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}_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
20CREATE 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;