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}_releeph.`releeph_project` (
2 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3 `dateCreated` int(10) unsigned NOT NULL,
4 `dateModified` int(10) unsigned NOT NULL,
5 `phid` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
6 `name` varchar(255) NOT NULL,
7 `trunkBranch` varchar(255) NOT NULL,
8 `repositoryID` int(10) unsigned NOT NULL,
9 `repositoryPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
10 `arcanistProjectID` int(10) unsigned NOT NULL,
11 `createdByUserPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
12 `isActive` tinyint(1) NOT NULL DEFAULT '1',
13 `projectID` int(10) unsigned DEFAULT NULL,
14 `details` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
15 PRIMARY KEY (`id`),
16 UNIQUE KEY `projectName` (`name`)
17) ENGINE=InnoDB DEFAULT CHARSET=utf8;
18
19CREATE TABLE {$NAMESPACE}_releeph.`releeph_branch` (
20 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
21 `dateCreated` int(10) unsigned NOT NULL,
22 `dateModified` int(10) unsigned NOT NULL,
23 `basename` varchar(64) NOT NULL,
24 `releephProjectID` int(10) unsigned NOT NULL,
25 `createdByUserPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
26 `cutPointCommitIdentifier`
27 varchar(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
28 `cutPointCommitPHID`
29 varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
30 `isActive` tinyint(1) NOT NULL DEFAULT '1',
31 `symbolicName` varchar(64) DEFAULT NULL,
32 `details` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
33 `phid` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
34 `name` varchar(128) NOT NULL,
35 PRIMARY KEY (`id`),
36 UNIQUE KEY `releephProjectID_2` (`releephProjectID`,`basename`),
37 UNIQUE KEY `releephProjectID_name` (`releephProjectID`,`name`),
38 UNIQUE KEY `releephProjectID` (`releephProjectID`,`symbolicName`)
39) ENGINE=InnoDB DEFAULT CHARSET=utf8;
40
41CREATE TABLE {$NAMESPACE}_releeph.`releeph_request` (
42 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
43 `dateCreated` int(10) unsigned NOT NULL,
44 `dateModified` int(10) unsigned NOT NULL,
45 `phid` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
46 `branchID` int(10) unsigned NOT NULL,
47 `summary` longtext CHARACTER SET utf8 COLLATE utf8_bin,
48 `requestUserPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
49 `requestCommitIdentifier`
50 varchar(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
51 `requestCommitPHID`
52 varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
53 `requestCommitOrdinal` int(10) unsigned NOT NULL,
54 `commitIdentifier`
55 varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
56 `committedByUserPHID`
57 varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
58 `commitPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
59 `status` tinyint(4) DEFAULT NULL,
60 `pickStatus` tinyint(4) DEFAULT NULL,
61 `details` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
62 `userIntents` longtext CHARACTER SET utf8 COLLATE utf8_bin,
63 `inBranch` tinyint(1) NOT NULL DEFAULT '0',
64 PRIMARY KEY (`id`),
65 UNIQUE KEY `phid` (`phid`),
66 UNIQUE KEY `requestIdentifierBranch` (`requestCommitIdentifier`,`branchID`),
67 KEY `branchID` (`branchID`,`requestCommitOrdinal`)
68) ENGINE=InnoDB DEFAULT CHARSET=utf8;
69
70CREATE TABLE {$NAMESPACE}_releeph.`releeph_requestevent` (
71 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
72 `dateCreated` int(10) unsigned NOT NULL,
73 `dateModified` int(10) unsigned NOT NULL,
74 `releephRequestID` int(10) unsigned NOT NULL,
75 `actorPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
76 `details` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
77 `type` varchar(32) NOT NULL,
78 PRIMARY KEY (`id`)
79) ENGINE=InnoDB DEFAULT CHARSET=utf8;
80
81CREATE TABLE {$NAMESPACE}_releeph.`releeph_event` (
82 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
83 `dateCreated` int(10) unsigned NOT NULL,
84 `dateModified` int(10) unsigned NOT NULL,
85 `releephProjectID` int(10) unsigned NOT NULL,
86 `releephBranchID` int(10) unsigned DEFAULT NULL,
87 `type` varchar(32) NOT NULL,
88 `epoch` int(10) unsigned DEFAULT NULL,
89 `actorPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
90 `details` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
91 PRIMARY KEY (`id`)
92) ENGINE=InnoDB DEFAULT CHARSET=utf8;