CoCalc -- 0000.legacy.sql

GitHub Repository: freebsd/phabricator
Path: blob/master/resources/sql/patches/0000.legacy.sql
¹²²⁵⁰ views
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

18
USE `{$NAMESPACE}_conduit`;
19

20

21

22

23

24
DROP TABLE IF EXISTS `conduit_connectionlog`;
25
/*!40101 SET @saved_cs_client     = @@character_set_client */;
26
/*!40101 SET character_set_client = utf8 */;
27
CREATE 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

43
DROP TABLE IF EXISTS `conduit_methodcalllog`;
44
/*!40101 SET @saved_cs_client     = @@character_set_client */;
45
/*!40101 SET character_set_client = utf8 */;
46
CREATE 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

64
USE `{$NAMESPACE}_differential`;
65

66

67

68

69

70
DROP TABLE IF EXISTS `differential_changeset`;
71
/*!40101 SET @saved_cs_client     = @@character_set_client */;
72
/*!40101 SET character_set_client = utf8 */;
73
CREATE 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

96
DROP TABLE IF EXISTS `differential_changeset_parse_cache`;
97
/*!40101 SET @saved_cs_client     = @@character_set_client */;
98
/*!40101 SET character_set_client = utf8 */;
99
CREATE 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

110
DROP TABLE IF EXISTS `differential_comment`;
111
/*!40101 SET @saved_cs_client     = @@character_set_client */;
112
/*!40101 SET character_set_client = utf8 */;
113
CREATE 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

130
DROP TABLE IF EXISTS `differential_diff`;
131
/*!40101 SET @saved_cs_client     = @@character_set_client */;
132
/*!40101 SET character_set_client = utf8 */;
133
CREATE 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

160
DROP TABLE IF EXISTS `differential_diffproperty`;
161
/*!40101 SET @saved_cs_client     = @@character_set_client */;
162
/*!40101 SET character_set_client = utf8 */;
163
CREATE 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

178
DROP TABLE IF EXISTS `differential_hunk`;
179
/*!40101 SET @saved_cs_client     = @@character_set_client */;
180
/*!40101 SET character_set_client = utf8 */;
181
CREATE 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

199
DROP TABLE IF EXISTS `differential_inlinecomment`;
200
/*!40101 SET @saved_cs_client     = @@character_set_client */;
201
/*!40101 SET character_set_client = utf8 */;
202
CREATE 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

223
DROP TABLE IF EXISTS `differential_relationship`;
224
/*!40101 SET @saved_cs_client     = @@character_set_client */;
225
/*!40101 SET character_set_client = utf8 */;
226
CREATE 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

241
DROP TABLE IF EXISTS `differential_revision`;
242
/*!40101 SET @saved_cs_client     = @@character_set_client */;
243
/*!40101 SET character_set_client = utf8 */;
244
CREATE 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

270
USE `{$NAMESPACE}_draft`;
271

272

273

274

275

276
DROP TABLE IF EXISTS `draft`;
277
/*!40101 SET @saved_cs_client     = @@character_set_client */;
278
/*!40101 SET character_set_client = utf8 */;
279
CREATE 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

297
USE `{$NAMESPACE}_file`;
298

299

300

301

302

303
DROP TABLE IF EXISTS `file`;
304
/*!40101 SET @saved_cs_client     = @@character_set_client */;
305
/*!40101 SET character_set_client = utf8 */;
306
CREATE 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

325
DROP TABLE IF EXISTS `file_storageblob`;
326
/*!40101 SET @saved_cs_client     = @@character_set_client */;
327
/*!40101 SET character_set_client = utf8 */;
328
CREATE 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

343
USE `{$NAMESPACE}_metamta`;
344

345

346

347

348

349
DROP TABLE IF EXISTS `metamta_mail`;
350
/*!40101 SET @saved_cs_client     = @@character_set_client */;
351
/*!40101 SET character_set_client = utf8 */;
352
CREATE 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

370
DROP TABLE IF EXISTS `metamta_mailinglist`;
371
/*!40101 SET @saved_cs_client     = @@character_set_client */;
372
/*!40101 SET character_set_client = utf8 */;
373
CREATE 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

386
DROP TABLE IF EXISTS `phid_type`;
387
/*!40101 SET @saved_cs_client     = @@character_set_client */;
388
/*!40101 SET character_set_client = utf8 */;
389
CREATE 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

407
USE `{$NAMESPACE}_user`;
408

409

410

411

412

413
DROP TABLE IF EXISTS `phabricator_session`;
414
/*!40101 SET @saved_cs_client     = @@character_set_client */;
415
/*!40101 SET character_set_client = utf8 */;
416
CREATE 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

429
DROP TABLE IF EXISTS `user`;
430
/*!40101 SET @saved_cs_client     = @@character_set_client */;
431
/*!40101 SET character_set_client = utf8 */;
432
CREATE 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

459
DROP TABLE IF EXISTS `user_profile`;
460
/*!40101 SET @saved_cs_client     = @@character_set_client */;
461
/*!40101 SET character_set_client = utf8 */;
462
CREATE 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

481
USE `{$NAMESPACE}_file`;
482

483

484

485

486

487
DROP TABLE IF EXISTS `file`;
488
/*!40101 SET @saved_cs_client     = @@character_set_client */;
489
/*!40101 SET character_set_client = utf8 */;
490
CREATE 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

509
DROP TABLE IF EXISTS `file_storageblob`;
510
/*!40101 SET @saved_cs_client     = @@character_set_client */;
511
/*!40101 SET character_set_client = utf8 */;
512
CREATE 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

527
USE `{$NAMESPACE}_repository`;
528

529

530

531

532

533
DROP TABLE IF EXISTS `repository`;
534
/*!40101 SET @saved_cs_client     = @@character_set_client */;
535
/*!40101 SET character_set_client = utf8 */;
536
CREATE 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

556
DROP TABLE IF EXISTS `repository_githubnotification`;
557
/*!40101 SET @saved_cs_client     = @@character_set_client */;
558
/*!40101 SET character_set_client = utf8 */;
559
CREATE 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

577
USE `{$NAMESPACE}_search`;
578

579

580

581

582

583
DROP TABLE IF EXISTS `search_document`;
584
/*!40101 SET @saved_cs_client     = @@character_set_client */;
585
/*!40101 SET character_set_client = utf8 */;
586
CREATE 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

600
DROP TABLE IF EXISTS `search_documentfield`;
601
/*!40101 SET @saved_cs_client     = @@character_set_client */;
602
/*!40101 SET character_set_client = utf8 */;
603
CREATE 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

618
DROP TABLE IF EXISTS `search_documentrelationship`;
619
/*!40101 SET @saved_cs_client     = @@character_set_client */;
620
/*!40101 SET character_set_client = utf8 */;
621
CREATE 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

635
DROP TABLE IF EXISTS `search_query`;
636
/*!40101 SET @saved_cs_client     = @@character_set_client */;
637
/*!40101 SET character_set_client = utf8 */;
638
CREATE 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

655
USE `{$NAMESPACE}_maniphest`;
656

657

658

659

660

661
DROP TABLE IF EXISTS `maniphest_task`;
662
/*!40101 SET @saved_cs_client     = @@character_set_client */;
663
/*!40101 SET character_set_client = utf8 */;
664
CREATE 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

685
DROP TABLE IF EXISTS `maniphest_touch`;
686
/*!40101 SET @saved_cs_client     = @@character_set_client */;
687
/*!40101 SET character_set_client = utf8 */;
688
CREATE 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

700
DROP TABLE IF EXISTS `maniphest_transaction`;
701
/*!40101 SET @saved_cs_client     = @@character_set_client */;
702
/*!40101 SET character_set_client = utf8 */;
703
CREATE 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 */;
726

727
Product

Resources

Company
