@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
1/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
4/*!40101 SET NAMES utf8 */;
5/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
6/*!40103 SET TIME_ZONE='+00:00' */;
7/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
8/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
9/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
10/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
11
12
13
14
15
16
17
18USE `{$NAMESPACE}_conduit`;
19
20
21
22
23
24DROP TABLE IF EXISTS `conduit_connectionlog`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `conduit_connectionlog` (
28 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
29 `client` varchar(255) DEFAULT NULL,
30 `clientVersion` varchar(255) DEFAULT NULL,
31 `clientDescription` varchar(255) DEFAULT NULL,
32 `username` varchar(255) DEFAULT NULL,
33 `dateCreated` int(10) unsigned NOT NULL,
34 `dateModified` int(10) unsigned NOT NULL,
35 PRIMARY KEY (`id`)
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37/*!40101 SET character_set_client = @saved_cs_client */;
38
39
40
41
42
43DROP TABLE IF EXISTS `conduit_methodcalllog`;
44/*!40101 SET @saved_cs_client = @@character_set_client */;
45/*!40101 SET character_set_client = utf8 */;
46CREATE TABLE `conduit_methodcalllog` (
47 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
48 `connectionID` bigint(20) unsigned DEFAULT NULL,
49 `method` varchar(255) NOT NULL,
50 `error` varchar(255) NOT NULL,
51 `duration` bigint(20) unsigned NOT NULL,
52 `dateCreated` int(10) unsigned NOT NULL,
53 `dateModified` int(10) unsigned NOT NULL,
54 PRIMARY KEY (`id`)
55) ENGINE=InnoDB DEFAULT CHARSET=latin1;
56/*!40101 SET character_set_client = @saved_cs_client */;
57
58
59
60
61
62
63
64USE `{$NAMESPACE}_differential`;
65
66
67
68
69
70DROP TABLE IF EXISTS `differential_changeset`;
71/*!40101 SET @saved_cs_client = @@character_set_client */;
72/*!40101 SET character_set_client = utf8 */;
73CREATE TABLE `differential_changeset` (
74 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
75 `diffID` int(10) unsigned NOT NULL,
76 `oldFile` varchar(255) DEFAULT NULL,
77 `fileName` varchar(255) NOT NULL,
78 `awayPaths` longblob,
79 `changeType` int(10) unsigned NOT NULL,
80 `fileType` int(10) unsigned NOT NULL,
81 `metadata` longblob,
82 `oldProperties` longblob,
83 `newProperties` longblob,
84 `addLines` int(10) unsigned NOT NULL,
85 `delLines` int(10) unsigned NOT NULL,
86 `dateCreated` int(10) unsigned NOT NULL,
87 `dateModified` int(10) unsigned NOT NULL,
88 PRIMARY KEY (`id`)
89) ENGINE=InnoDB DEFAULT CHARSET=latin1;
90/*!40101 SET character_set_client = @saved_cs_client */;
91
92
93
94
95
96DROP TABLE IF EXISTS `differential_changeset_parse_cache`;
97/*!40101 SET @saved_cs_client = @@character_set_client */;
98/*!40101 SET character_set_client = utf8 */;
99CREATE TABLE `differential_changeset_parse_cache` (
100 `id` int(10) unsigned NOT NULL,
101 `cache` longblob NOT NULL,
102 PRIMARY KEY (`id`)
103) ENGINE=InnoDB DEFAULT CHARSET=latin1;
104/*!40101 SET character_set_client = @saved_cs_client */;
105
106
107
108
109
110DROP TABLE IF EXISTS `differential_comment`;
111/*!40101 SET @saved_cs_client = @@character_set_client */;
112/*!40101 SET character_set_client = utf8 */;
113CREATE TABLE `differential_comment` (
114 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
115 `revisionID` int(10) unsigned NOT NULL,
116 `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
117 `action` varchar(64) NOT NULL,
118 `content` longblob NOT NULL,
119 `dateCreated` int(10) unsigned NOT NULL,
120 `dateModified` int(10) unsigned NOT NULL,
121 `cache` longblob,
122 PRIMARY KEY (`id`)
123) ENGINE=InnoDB DEFAULT CHARSET=latin1;
124/*!40101 SET character_set_client = @saved_cs_client */;
125
126
127
128
129
130DROP TABLE IF EXISTS `differential_diff`;
131/*!40101 SET @saved_cs_client = @@character_set_client */;
132/*!40101 SET character_set_client = utf8 */;
133CREATE TABLE `differential_diff` (
134 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
135 `revisionID` int(10) unsigned DEFAULT NULL,
136 `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
137 `sourceMachine` varchar(255) DEFAULT NULL,
138 `sourcePath` varchar(255) DEFAULT NULL,
139 `sourceControlSystem` varchar(64) DEFAULT NULL,
140 `sourceControlBaseRevision` varchar(255) DEFAULT NULL,
141 `sourceControlpath` varchar(255) DEFAULT NULL,
142 `lintStatus` int(10) unsigned NOT NULL,
143 `unitStatus` int(10) unsigned NOT NULL,
144 `lineCount` int(10) unsigned NOT NULL,
145 `branch` varchar(255) DEFAULT NULL,
146 `parentRevisionID` int(10) unsigned DEFAULT NULL,
147 `arcanistProject` varchar(255) DEFAULT NULL,
148 `creationMethod` varchar(255) DEFAULT NULL,
149 `dateCreated` int(10) unsigned NOT NULL,
150 `dateModified` int(10) unsigned NOT NULL,
151 `description` varchar(255) DEFAULT NULL,
152 PRIMARY KEY (`id`)
153) ENGINE=InnoDB DEFAULT CHARSET=latin1;
154/*!40101 SET character_set_client = @saved_cs_client */;
155
156
157
158
159
160DROP TABLE IF EXISTS `differential_diffproperty`;
161/*!40101 SET @saved_cs_client = @@character_set_client */;
162/*!40101 SET character_set_client = utf8 */;
163CREATE TABLE `differential_diffproperty` (
164 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
165 `diffID` int(10) unsigned NOT NULL,
166 `name` varchar(255) NOT NULL,
167 `data` longblob NOT NULL,
168 `dateCreated` int(10) unsigned NOT NULL,
169 `dateModified` int(10) unsigned NOT NULL,
170 PRIMARY KEY (`id`)
171) ENGINE=InnoDB DEFAULT CHARSET=latin1;
172/*!40101 SET character_set_client = @saved_cs_client */;
173
174
175
176
177
178DROP TABLE IF EXISTS `differential_hunk`;
179/*!40101 SET @saved_cs_client = @@character_set_client */;
180/*!40101 SET character_set_client = utf8 */;
181CREATE TABLE `differential_hunk` (
182 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
183 `changesetID` int(10) unsigned NOT NULL,
184 `changes` longblob,
185 `oldOffset` int(10) unsigned NOT NULL,
186 `oldLen` int(10) unsigned NOT NULL,
187 `newOffset` int(10) unsigned NOT NULL,
188 `newLen` int(10) unsigned NOT NULL,
189 `dateCreated` int(10) unsigned NOT NULL,
190 `dateModified` int(10) unsigned NOT NULL,
191 PRIMARY KEY (`id`)
192) ENGINE=InnoDB DEFAULT CHARSET=latin1;
193/*!40101 SET character_set_client = @saved_cs_client */;
194
195
196
197
198
199DROP TABLE IF EXISTS `differential_inlinecomment`;
200/*!40101 SET @saved_cs_client = @@character_set_client */;
201/*!40101 SET character_set_client = utf8 */;
202CREATE TABLE `differential_inlinecomment` (
203 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
204 `revisionID` int(10) unsigned NOT NULL,
205 `commentID` int(10) unsigned DEFAULT NULL,
206 `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
207 `changesetID` int(10) unsigned NOT NULL,
208 `isNewFile` tinyint(1) NOT NULL,
209 `lineNumber` int(10) unsigned NOT NULL,
210 `lineLength` int(10) unsigned NOT NULL,
211 `content` longblob NOT NULL,
212 `dateCreated` int(10) unsigned NOT NULL,
213 `dateModified` int(10) unsigned NOT NULL,
214 `cache` longblob,
215 PRIMARY KEY (`id`)
216) ENGINE=InnoDB DEFAULT CHARSET=latin1;
217/*!40101 SET character_set_client = @saved_cs_client */;
218
219
220
221
222
223DROP TABLE IF EXISTS `differential_relationship`;
224/*!40101 SET @saved_cs_client = @@character_set_client */;
225/*!40101 SET character_set_client = utf8 */;
226CREATE TABLE `differential_relationship` (
227 `revisionID` int(10) unsigned NOT NULL,
228 `relation` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
229 `objectPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
230 `sequence` int(10) unsigned NOT NULL,
231 `reasonPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
232 PRIMARY KEY (`revisionID`,`relation`,`objectPHID`),
233 KEY `objectPHID` (`objectPHID`,`relation`)
234) ENGINE=InnoDB DEFAULT CHARSET=latin1;
235/*!40101 SET character_set_client = @saved_cs_client */;
236
237
238
239
240
241DROP TABLE IF EXISTS `differential_revision`;
242/*!40101 SET @saved_cs_client = @@character_set_client */;
243/*!40101 SET character_set_client = utf8 */;
244CREATE TABLE `differential_revision` (
245 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
246 `title` varchar(255) NOT NULL,
247 `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
248 `status` varchar(32) NOT NULL,
249 `summary` longtext NOT NULL,
250 `testPlan` text NOT NULL,
251 `revertPlan` text NOT NULL,
252 `blameRevision` varchar(255) NOT NULL,
253 `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
254 `dateCommitted` int(10) unsigned DEFAULT NULL,
255 `lineCount` int(10) unsigned DEFAULT NULL,
256 `dateCreated` int(10) unsigned NOT NULL,
257 `dateModified` int(10) unsigned NOT NULL,
258 `attached` longtext NOT NULL,
259 `unsubscribed` longblob NOT NULL,
260 PRIMARY KEY (`id`)
261) ENGINE=InnoDB DEFAULT CHARSET=latin1;
262/*!40101 SET character_set_client = @saved_cs_client */;
263
264
265
266
267
268
269
270USE `{$NAMESPACE}_draft`;
271
272
273
274
275
276DROP TABLE IF EXISTS `draft`;
277/*!40101 SET @saved_cs_client = @@character_set_client */;
278/*!40101 SET character_set_client = utf8 */;
279CREATE TABLE `draft` (
280 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
281 `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
282 `draftKey` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
283 `draft` longblob NOT NULL,
284 `dateCreated` int(10) unsigned NOT NULL,
285 `dateModified` int(10) unsigned NOT NULL,
286 PRIMARY KEY (`id`),
287 UNIQUE KEY `authorPHID` (`authorPHID`,`draftKey`)
288) ENGINE=InnoDB DEFAULT CHARSET=latin1;
289/*!40101 SET character_set_client = @saved_cs_client */;
290
291
292
293
294
295
296
297USE `{$NAMESPACE}_file`;
298
299
300
301
302
303DROP TABLE IF EXISTS `file`;
304/*!40101 SET @saved_cs_client = @@character_set_client */;
305/*!40101 SET character_set_client = utf8 */;
306CREATE TABLE `file` (
307 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
308 `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
309 `name` varchar(255) DEFAULT NULL,
310 `mimeType` varchar(255) DEFAULT NULL,
311 `byteSize` bigint(20) unsigned NOT NULL,
312 `storageEngine` varchar(32) NOT NULL,
313 `storageFormat` varchar(32) NOT NULL,
314 `storageHandle` varchar(255) NOT NULL,
315 `dateCreated` int(10) unsigned NOT NULL,
316 `dateModified` int(10) unsigned NOT NULL,
317 PRIMARY KEY (`id`)
318) ENGINE=InnoDB DEFAULT CHARSET=latin1;
319/*!40101 SET character_set_client = @saved_cs_client */;
320
321
322
323
324
325DROP TABLE IF EXISTS `file_storageblob`;
326/*!40101 SET @saved_cs_client = @@character_set_client */;
327/*!40101 SET character_set_client = utf8 */;
328CREATE TABLE `file_storageblob` (
329 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
330 `data` longblob NOT NULL,
331 `dateCreated` int(10) unsigned NOT NULL,
332 `dateModified` int(10) unsigned NOT NULL,
333 PRIMARY KEY (`id`)
334) ENGINE=InnoDB DEFAULT CHARSET=latin1;
335/*!40101 SET character_set_client = @saved_cs_client */;
336
337
338
339
340
341
342
343USE `{$NAMESPACE}_metamta`;
344
345
346
347
348
349DROP TABLE IF EXISTS `metamta_mail`;
350/*!40101 SET @saved_cs_client = @@character_set_client */;
351/*!40101 SET character_set_client = utf8 */;
352CREATE TABLE `metamta_mail` (
353 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
354 `parameters` longblob NOT NULL,
355 `status` varchar(255) NOT NULL,
356 `message` text,
357 `retryCount` int(10) unsigned NOT NULL,
358 `nextRetry` int(10) unsigned NOT NULL,
359 `relatedPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
360 `dateCreated` int(10) unsigned NOT NULL,
361 `dateModified` int(10) unsigned NOT NULL,
362 PRIMARY KEY (`id`)
363) ENGINE=InnoDB DEFAULT CHARSET=latin1;
364/*!40101 SET character_set_client = @saved_cs_client */;
365
366
367
368
369
370DROP TABLE IF EXISTS `metamta_mailinglist`;
371/*!40101 SET @saved_cs_client = @@character_set_client */;
372/*!40101 SET character_set_client = utf8 */;
373CREATE TABLE `metamta_mailinglist` (
374 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
375 `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
376 `name` varchar(255) NOT NULL,
377 `email` varchar(255) NOT NULL,
378 `uri` varchar(255) DEFAULT NULL,
379 `dateCreated` int(10) unsigned NOT NULL,
380 `dateModified` int(10) unsigned NOT NULL,
381 PRIMARY KEY (`id`)
382) ENGINE=InnoDB DEFAULT CHARSET=latin1;
383/*!40101 SET character_set_client = @saved_cs_client */;
384
385
386DROP TABLE IF EXISTS `phid_type`;
387/*!40101 SET @saved_cs_client = @@character_set_client */;
388/*!40101 SET character_set_client = utf8 */;
389CREATE TABLE `phid_type` (
390 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
391 `type` varchar(4) NOT NULL,
392 `name` varchar(255) NOT NULL,
393 `description` text,
394 `dateCreated` int(10) unsigned NOT NULL,
395 `dateModified` int(10) unsigned NOT NULL,
396 PRIMARY KEY (`id`),
397 UNIQUE KEY `type` (`type`)
398) ENGINE=InnoDB DEFAULT CHARSET=latin1;
399/*!40101 SET character_set_client = @saved_cs_client */;
400
401
402
403
404
405
406
407USE `{$NAMESPACE}_user`;
408
409
410
411
412
413DROP TABLE IF EXISTS `phabricator_session`;
414/*!40101 SET @saved_cs_client = @@character_set_client */;
415/*!40101 SET character_set_client = utf8 */;
416CREATE TABLE `phabricator_session` (
417 `userPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
418 `type` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
419 `sessionKey` varchar(40) NOT NULL,
420 `sessionStart` int(10) unsigned NOT NULL,
421 PRIMARY KEY (`userPHID`,`type`)
422) ENGINE=InnoDB DEFAULT CHARSET=latin1;
423/*!40101 SET character_set_client = @saved_cs_client */;
424
425
426
427
428
429DROP TABLE IF EXISTS `user`;
430/*!40101 SET @saved_cs_client = @@character_set_client */;
431/*!40101 SET character_set_client = utf8 */;
432CREATE TABLE `user` (
433 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
434 `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
435 `userName` varchar(64) NOT NULL,
436 `realName` varchar(128) NOT NULL,
437 `email` varchar(255) NOT NULL,
438 `passwordSalt` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
439 `passwordHash` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
440 `dateCreated` int(10) unsigned NOT NULL,
441 `dateModified` int(10) unsigned NOT NULL,
442 `facebookUID` bigint(20) unsigned DEFAULT NULL,
443 `profileImagePHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
444 `consoleEnabled` tinyint(1) NOT NULL,
445 `consoleVisible` tinyint(1) NOT NULL,
446 `consoleTab` varchar(64) NOT NULL,
447 `conduitCertificate` varchar(255) NOT NULL,
448 PRIMARY KEY (`id`),
449 UNIQUE KEY `userName` (`userName`),
450 UNIQUE KEY `email` (`email`),
451 UNIQUE KEY `facebookUID` (`facebookUID`)
452) ENGINE=InnoDB DEFAULT CHARSET=latin1;
453/*!40101 SET character_set_client = @saved_cs_client */;
454
455
456
457
458
459DROP TABLE IF EXISTS `user_profile`;
460/*!40101 SET @saved_cs_client = @@character_set_client */;
461/*!40101 SET character_set_client = utf8 */;
462CREATE TABLE `user_profile` (
463 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
464 `userPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
465 `title` varchar(255) NOT NULL,
466 `blurb` text NOT NULL,
467 `profileImagePHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
468 `dateCreated` int(10) unsigned NOT NULL,
469 `dateModified` int(10) unsigned NOT NULL,
470 PRIMARY KEY (`id`),
471 UNIQUE KEY `userPHID` (`userPHID`)
472) ENGINE=InnoDB DEFAULT CHARSET=latin1;
473/*!40101 SET character_set_client = @saved_cs_client */;
474
475
476
477
478
479
480
481USE `{$NAMESPACE}_file`;
482
483
484
485
486
487DROP TABLE IF EXISTS `file`;
488/*!40101 SET @saved_cs_client = @@character_set_client */;
489/*!40101 SET character_set_client = utf8 */;
490CREATE TABLE `file` (
491 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
492 `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
493 `name` varchar(255) DEFAULT NULL,
494 `mimeType` varchar(255) DEFAULT NULL,
495 `byteSize` bigint(20) unsigned NOT NULL,
496 `storageEngine` varchar(32) NOT NULL,
497 `storageFormat` varchar(32) NOT NULL,
498 `storageHandle` varchar(255) NOT NULL,
499 `dateCreated` int(10) unsigned NOT NULL,
500 `dateModified` int(10) unsigned NOT NULL,
501 PRIMARY KEY (`id`)
502) ENGINE=InnoDB DEFAULT CHARSET=latin1;
503/*!40101 SET character_set_client = @saved_cs_client */;
504
505
506
507
508
509DROP TABLE IF EXISTS `file_storageblob`;
510/*!40101 SET @saved_cs_client = @@character_set_client */;
511/*!40101 SET character_set_client = utf8 */;
512CREATE TABLE `file_storageblob` (
513 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
514 `data` longblob NOT NULL,
515 `dateCreated` int(10) unsigned NOT NULL,
516 `dateModified` int(10) unsigned NOT NULL,
517 PRIMARY KEY (`id`)
518) ENGINE=InnoDB DEFAULT CHARSET=latin1;
519/*!40101 SET character_set_client = @saved_cs_client */;
520
521
522
523
524
525
526
527USE `{$NAMESPACE}_repository`;
528
529
530
531
532
533DROP TABLE IF EXISTS `repository`;
534/*!40101 SET @saved_cs_client = @@character_set_client */;
535/*!40101 SET character_set_client = utf8 */;
536CREATE TABLE `repository` (
537 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
538 `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
539 `name` varchar(255) NOT NULL,
540 `callsign` varchar(32) NOT NULL,
541 `description` text,
542 `versionControlSystem` varchar(32) NOT NULL,
543 `details` longblob NOT NULL,
544 `dateCreated` int(10) unsigned NOT NULL,
545 `dateModified` int(10) unsigned NOT NULL,
546 PRIMARY KEY (`id`),
547 UNIQUE KEY `callsign` (`callsign`),
548 UNIQUE KEY `phid` (`phid`)
549) ENGINE=InnoDB DEFAULT CHARSET=latin1;
550/*!40101 SET character_set_client = @saved_cs_client */;
551
552
553
554
555
556DROP TABLE IF EXISTS `repository_githubnotification`;
557/*!40101 SET @saved_cs_client = @@character_set_client */;
558/*!40101 SET character_set_client = utf8 */;
559CREATE TABLE `repository_githubnotification` (
560 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
561 `repositoryPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
562 `remoteAddress` varchar(32) NOT NULL,
563 `payload` longblob NOT NULL,
564 `dateCreated` int(10) unsigned NOT NULL,
565 `dateModified` int(10) unsigned NOT NULL,
566 PRIMARY KEY (`id`),
567 KEY `repositoryPHID` (`repositoryPHID`)
568) ENGINE=InnoDB DEFAULT CHARSET=latin1;
569/*!40101 SET character_set_client = @saved_cs_client */;
570
571
572
573
574
575
576
577USE `{$NAMESPACE}_search`;
578
579
580
581
582
583DROP TABLE IF EXISTS `search_document`;
584/*!40101 SET @saved_cs_client = @@character_set_client */;
585/*!40101 SET character_set_client = utf8 */;
586CREATE TABLE `search_document` (
587 `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
588 `documentType` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
589 `documentTitle` varchar(255) NOT NULL,
590 `documentCreated` int(10) unsigned NOT NULL,
591 `documentModified` int(10) unsigned NOT NULL,
592 PRIMARY KEY (`phid`)
593) ENGINE=InnoDB DEFAULT CHARSET=latin1;
594/*!40101 SET character_set_client = @saved_cs_client */;
595
596
597
598
599
600DROP TABLE IF EXISTS `search_documentfield`;
601/*!40101 SET @saved_cs_client = @@character_set_client */;
602/*!40101 SET character_set_client = utf8 */;
603CREATE TABLE `search_documentfield` (
604 `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
605 `phidType` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
606 `field` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
607 `auxPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
608 `corpus` text,
609 KEY `phid` (`phid`),
610 FULLTEXT KEY `corpus` (`corpus`)
611) ENGINE=MyISAM DEFAULT CHARSET=latin1;
612/*!40101 SET character_set_client = @saved_cs_client */;
613
614
615
616
617
618DROP TABLE IF EXISTS `search_documentrelationship`;
619/*!40101 SET @saved_cs_client = @@character_set_client */;
620/*!40101 SET character_set_client = utf8 */;
621CREATE TABLE `search_documentrelationship` (
622 `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
623 `relatedPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
624 `relation` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
625 `relatedType` varchar(4) NOT NULL,
626 `relatedTime` int(10) unsigned NOT NULL,
627 KEY `phid` (`phid`)
628) ENGINE=InnoDB DEFAULT CHARSET=latin1;
629/*!40101 SET character_set_client = @saved_cs_client */;
630
631
632
633
634
635DROP TABLE IF EXISTS `search_query`;
636/*!40101 SET @saved_cs_client = @@character_set_client */;
637/*!40101 SET character_set_client = utf8 */;
638CREATE TABLE `search_query` (
639 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
640 `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
641 `query` varchar(255) NOT NULL,
642 `parameters` text NOT NULL,
643 `dateCreated` int(10) unsigned NOT NULL,
644 `dateModified` int(10) unsigned NOT NULL,
645 PRIMARY KEY (`id`)
646) ENGINE=InnoDB DEFAULT CHARSET=latin1;
647/*!40101 SET character_set_client = @saved_cs_client */;
648
649
650
651
652
653
654
655USE `{$NAMESPACE}_maniphest`;
656
657
658
659
660
661DROP TABLE IF EXISTS `maniphest_task`;
662/*!40101 SET @saved_cs_client = @@character_set_client */;
663/*!40101 SET character_set_client = utf8 */;
664CREATE TABLE `maniphest_task` (
665 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
666 `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
667 `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
668 `ownerPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
669 `ccPHIDs` text,
670 `attached` longtext NOT NULL,
671 `status` int(10) unsigned NOT NULL,
672 `priority` int(10) unsigned NOT NULL,
673 `title` text NOT NULL,
674 `description` longtext NOT NULL,
675 `dateCreated` int(10) unsigned NOT NULL,
676 `dateModified` int(10) unsigned NOT NULL,
677 PRIMARY KEY (`id`)
678) ENGINE=InnoDB DEFAULT CHARSET=latin1;
679/*!40101 SET character_set_client = @saved_cs_client */;
680
681
682
683
684
685DROP TABLE IF EXISTS `maniphest_touch`;
686/*!40101 SET @saved_cs_client = @@character_set_client */;
687/*!40101 SET character_set_client = utf8 */;
688CREATE TABLE `maniphest_touch` (
689 `userPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
690 `taskID` int(10) unsigned NOT NULL,
691 `touchedAt` int(10) unsigned NOT NULL,
692 PRIMARY KEY (`userPHID`,`taskID`)
693) ENGINE=InnoDB DEFAULT CHARSET=latin1;
694/*!40101 SET character_set_client = @saved_cs_client */;
695
696
697
698
699
700DROP TABLE IF EXISTS `maniphest_transaction`;
701/*!40101 SET @saved_cs_client = @@character_set_client */;
702/*!40101 SET character_set_client = utf8 */;
703CREATE TABLE `maniphest_transaction` (
704 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
705 `taskID` int(10) unsigned NOT NULL,
706 `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
707 `transactionType` varchar(16) NOT NULL,
708 `oldValue` longblob,
709 `newValue` longblob,
710 `comments` longblob,
711 `dateCreated` int(10) unsigned NOT NULL,
712 `dateModified` int(10) unsigned NOT NULL,
713 `cache` longblob,
714 PRIMARY KEY (`id`)
715) ENGINE=InnoDB DEFAULT CHARSET=latin1;
716/*!40101 SET character_set_client = @saved_cs_client */;
717/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
718
719/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
720/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
721/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
722/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
723/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
724/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
725/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;