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}_maniphest.edge (
2 src VARCHAR(64) NOT NULL COLLATE utf8_bin,
3 type VARCHAR(64) NOT NULL COLLATE utf8_bin,
4 dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
5 dateCreated INT UNSIGNED NOT NULL,
6 seq INT UNSIGNED NOT NULL,
7 dataID INT UNSIGNED,
8 PRIMARY KEY (src, type, dst),
9 KEY (src, type, dateCreated, seq)
10) ENGINE=InnoDB, COLLATE utf8_general_ci;
11
12CREATE TABLE {$NAMESPACE}_maniphest.edgedata (
13 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
14 data LONGTEXT NOT NULL COLLATE utf8_bin
15) ENGINE=InnoDB, COLLATE utf8_general_ci;
16
17
18
19CREATE TABLE {$NAMESPACE}_repository.edge (
20 src VARCHAR(64) NOT NULL COLLATE utf8_bin,
21 type VARCHAR(64) NOT NULL COLLATE utf8_bin,
22 dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
23 dateCreated INT UNSIGNED NOT NULL,
24 seq INT UNSIGNED NOT NULL,
25 dataID INT UNSIGNED,
26 PRIMARY KEY (src, type, dst),
27 KEY (src, type, dateCreated, seq)
28) ENGINE=InnoDB, COLLATE utf8_general_ci;
29
30CREATE TABLE {$NAMESPACE}_repository.edgedata (
31 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
32 data LONGTEXT NOT NULL COLLATE utf8_bin
33) ENGINE=InnoDB, COLLATE utf8_general_ci;
34
35
36
37CREATE TABLE {$NAMESPACE}_differential.edge (
38 src VARCHAR(64) NOT NULL COLLATE utf8_bin,
39 type VARCHAR(64) NOT NULL COLLATE utf8_bin,
40 dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
41 dateCreated INT UNSIGNED NOT NULL,
42 seq INT UNSIGNED NOT NULL,
43 dataID INT UNSIGNED,
44 PRIMARY KEY (src, type, dst),
45 KEY (src, type, dateCreated, seq)
46) ENGINE=InnoDB, COLLATE utf8_general_ci;
47
48CREATE TABLE {$NAMESPACE}_differential.edgedata (
49 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
50 data LONGTEXT NOT NULL COLLATE utf8_bin
51) ENGINE=InnoDB, COLLATE utf8_general_ci;
52
53
54
55CREATE TABLE {$NAMESPACE}_file.edge (
56 src VARCHAR(64) NOT NULL COLLATE utf8_bin,
57 type VARCHAR(64) NOT NULL COLLATE utf8_bin,
58 dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
59 dateCreated INT UNSIGNED NOT NULL,
60 seq INT UNSIGNED NOT NULL,
61 dataID INT UNSIGNED,
62 PRIMARY KEY (src, type, dst),
63 KEY (src, type, dateCreated, seq)
64) ENGINE=InnoDB, COLLATE utf8_general_ci;
65
66CREATE TABLE {$NAMESPACE}_file.edgedata (
67 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
68 data LONGTEXT NOT NULL COLLATE utf8_bin
69) ENGINE=InnoDB, COLLATE utf8_general_ci;
70
71
72
73CREATE TABLE {$NAMESPACE}_user.edge (
74 src VARCHAR(64) NOT NULL COLLATE utf8_bin,
75 type VARCHAR(64) NOT NULL COLLATE utf8_bin,
76 dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
77 dateCreated INT UNSIGNED NOT NULL,
78 seq INT UNSIGNED NOT NULL,
79 dataID INT UNSIGNED,
80 PRIMARY KEY (src, type, dst),
81 KEY (src, type, dateCreated, seq)
82) ENGINE=InnoDB, COLLATE utf8_general_ci;
83
84CREATE TABLE {$NAMESPACE}_user.edgedata (
85 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
86 data LONGTEXT NOT NULL COLLATE utf8_bin
87) ENGINE=InnoDB, COLLATE utf8_general_ci;
88
89
90
91CREATE TABLE {$NAMESPACE}_project.edge (
92 src VARCHAR(64) NOT NULL COLLATE utf8_bin,
93 type VARCHAR(64) NOT NULL COLLATE utf8_bin,
94 dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
95 dateCreated INT UNSIGNED NOT NULL,
96 seq INT UNSIGNED NOT NULL,
97 dataID INT UNSIGNED,
98 PRIMARY KEY (src, type, dst),
99 KEY (src, type, dateCreated, seq)
100) ENGINE=InnoDB, COLLATE utf8_general_ci;
101
102CREATE TABLE {$NAMESPACE}_project.edgedata (
103 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
104 data LONGTEXT NOT NULL COLLATE utf8_bin
105) ENGINE=InnoDB, COLLATE utf8_general_ci;
106
107
108
109CREATE TABLE {$NAMESPACE}_metamta.edge (
110 src VARCHAR(64) NOT NULL COLLATE utf8_bin,
111 type VARCHAR(64) NOT NULL COLLATE utf8_bin,
112 dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
113 dateCreated INT UNSIGNED NOT NULL,
114 seq INT UNSIGNED NOT NULL,
115 dataID INT UNSIGNED,
116 PRIMARY KEY (src, type, dst),
117 KEY (src, type, dateCreated, seq)
118) ENGINE=InnoDB, COLLATE utf8_general_ci;
119
120CREATE TABLE {$NAMESPACE}_metamta.edgedata (
121 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
122 data LONGTEXT NOT NULL COLLATE utf8_bin
123) ENGINE=InnoDB, COLLATE utf8_general_ci;