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}_user.user_log (
2 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3 actorPHID varchar(64) BINARY,
4 key(actorPHID, dateCreated),
5 userPHID varchar(64) BINARY NOT NULL,
6 key(userPHID, dateCreated),
7 action varchar(64) NOT NULL,
8 key(action, dateCreated),
9 oldValue LONGBLOB NOT NULL,
10 newValue LONGBLOB NOT NULL,
11 details LONGBLOB NOT NULL,
12 dateCreated INT UNSIGNED NOT NULL,
13 dateModified INT UNSIGNED NOT NULL,
14 key(dateCreated)
15);
16
17ALTER TABLE {$NAMESPACE}_user.user_log
18 ADD remoteAddr varchar(16) NOT NULL;
19
20ALTER TABLE {$NAMESPACE}_user.user_log
21 ADD KEY (remoteAddr, dateCreated);
22
23ALTER TABLE {$NAMESPACE}_user.user_log
24 ADD session varchar(40);
25
26ALTER TABLE {$NAMESPACE}_user.user_log
27 ADD KEY (session, dateCreated);