DXR is a code search and navigation tool aimed at making sense of large projects. It supports full-text and regex searches as well as structural queries.

Mercurial (8aff676182f9)

VCS Links

Line Code
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103
--
-- Table structure for table `builders`
--

CREATE TABLE IF NOT EXISTS `builders` (
  `id` integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `branch` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `buildername` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hidden` boolean NOT NULL DEFAULT FALSE,
  UNIQUE INDEX `builders_name_idx` (`name`),
  INDEX `builders_buildername_idx` (`buildername`(255)),
  INDEX `buildername` (`buildername`(255)),
  INDEX `builders_hidden_idx` (`hidden`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `builders_history`
--

CREATE TABLE IF NOT EXISTS `builders_history` (
  `id` integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `builder_id` integer NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `action` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `who` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reason` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ip` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  INDEX `builders_history_date_idx` (`builder_id`),
  CONSTRAINT `builders_history_ibfk_1` FOREIGN KEY (`builder_id`) REFERENCES `builders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `runs`
--

CREATE TABLE IF NOT EXISTS `runs` (
  `id` integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `buildbot_id` integer NOT NULL,
  `buildername` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `slave` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `revision` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `starttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `endtime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `result` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `branch` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `log` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE INDEX `runs_buildbot_id_idx` (`buildbot_id`),
  INDEX `runs_buildername_idx` (`buildername`(255)),
  INDEX `runs_endtime_idx` (`endtime`),
  INDEX `runs_revision_branch_idx` (`revision`, `branch`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `runs_notes`
--

CREATE TABLE IF NOT EXISTS `runs_notes` (
  `id` integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `run_id` integer NOT NULL,
  `who` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `note` text COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ip` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  INDEX `runs_notes_run_id_idx` (`run_id`, `timestamp`),
  CONSTRAINT `runs_notes_ibfk_1` FOREIGN KEY (`run_id`) REFERENCES `runs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `runs_logs`
--

CREATE TABLE IF NOT EXISTS `runs_logs` (
  `id` integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `buildbot_id` integer NOT NULL,
  `type` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `content` longblob,
  UNIQUE INDEX `runs_logs_buildbot_id_type_idx` (`buildbot_id`, `type`),
  INDEX `idx_content` (`content`(1)),
  CONSTRAINT `runs_logs_ibfk_1` FOREIGN KEY (`buildbot_id`) REFERENCES `runs` (`buildbot_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bugscache`
--

CREATE TABLE IF NOT EXISTS `bugscache` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `json` text COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE INDEX `bugscache_filename_idx` (`filename`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;