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}_pholio.pholio_mock (
2 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
3 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
4 name VARCHAR(128) NOT NULL COLLATE utf8_general_ci,
5 originalName VARCHAR(128) NOT NULL COLLATE utf8_general_ci,
6 description LONGTEXT NOT NULL COLLATE utf8_general_ci,
7 authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
8 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
9 coverPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
10 mailKey VARCHAR(20) NOT NULL COLLATE utf8_bin,
11 dateCreated INT UNSIGNED NOT NULL,
12 dateModified INT UNSIGNED NOT NULL,
13 UNIQUE KEY (phid),
14 KEY (authorPHID)
15) ENGINE=InnoDB, COLLATE utf8_general_ci;
16
17CREATE TABLE {$NAMESPACE}_pholio.edge (
18 src VARCHAR(64) NOT NULL COLLATE utf8_bin,
19 type VARCHAR(64) NOT NULL COLLATE utf8_bin,
20 dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
21 dateCreated INT UNSIGNED NOT NULL,
22 seq INT UNSIGNED NOT NULL,
23 dataID INT UNSIGNED,
24 PRIMARY KEY (src, type, dst),
25 KEY (src, type, dateCreated, seq)
26) ENGINE=InnoDB, COLLATE utf8_general_ci;
27
28CREATE TABLE {$NAMESPACE}_pholio.edgedata (
29 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
30 data LONGTEXT NOT NULL COLLATE utf8_bin
31) ENGINE=InnoDB, COLLATE utf8_general_ci;
32
33CREATE TABLE {$NAMESPACE}_pholio.pholio_transaction (
34 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
35 authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
36 mockID INT UNSIGNED NOT NULL,
37 transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
38 oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
39 newValue LONGTEXT NOT NULL COLLATE utf8_bin,
40 comment LONGTEXT NOT NULL COLLATE utf8_general_ci,
41 metadata LONGTEXT NOT NULL COLLATE utf8_bin,
42 contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
43 dateCreated INT UNSIGNED NOT NULL,
44 dateModified INT UNSIGNED NOT NULL
45) ENGINE=InnoDB, COLLATE utf8_general_ci;
46
47CREATE TABLE {$NAMESPACE}_pholio.pholio_image (
48 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
49 mockID INT UNSIGNED NOT NULL,
50 filePHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
51 name VARCHAR(128) NOT NULL COLLATE utf8_general_ci,
52 description LONGTEXT NOT NULL COLLATE utf8_general_ci,
53 sequence INT UNSIGNED NOT NULL,
54 dateCreated INT UNSIGNED NOT NULL,
55 dateModified INT UNSIGNED NOT NULL,
56 KEY (mockID, sequence)
57) ENGINE=InnoDB, COLLATE utf8_general_ci;
58
59CREATE TABLE {$NAMESPACE}_pholio.pholio_pixelcomment (
60 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
61 mockID INT UNSIGNED NOT NULL,
62 imageID INT UNSIGNED NOT NULL,
63 transactionID INT UNSIGNED,
64 authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
65 x INT UNSIGNED NOT NULL,
66 y INT UNSIGNED NOT NULL,
67 width INT UNSIGNED NOT NULL,
68 height INT UNSIGNED NOT NULL,
69 comment LONGTEXT NOT NULL COLLATE utf8_general_ci,
70 dateCreated INT UNSIGNED NOT NULL,
71 dateModified INT UNSIGNED NOT NULL,
72 KEY (mockID),
73 KEY (authorPHID, transactionID)
74) ENGINE=InnoDB, COLLATE utf8_general_ci;