1-- 2-- Table: coveragefilepriority 3-- 4CREATE TABLE "coveragefilepriority" ( 5 "id" serial NOT NULL, 6 "priority" smallint NOT NULL, 7 "fullpath" character varying(255) DEFAULT '' NOT NULL, 8 "projectid" bigint NOT NULL, 9 PRIMARY KEY ("id") 10); 11CREATE INDEX "coveragefilepriority_priority" on "coveragefilepriority" ("priority"); 12CREATE INDEX "coveragefilepriority_fullpath" on "coveragefilepriority" ("fullpath"); 13CREATE INDEX "coveragefilepriority_projectid" on "coveragefilepriority" ("projectid"); 14 15-- 16-- Table: submission 17-- 18CREATE TABLE "submission" ( 19 "id" serial NOT NULL, 20 "fullpath" character varying(255) DEFAULT '' NOT NULL, 21 "projectid" bigint NOT NULL, 22 "status" smallint NOT NULL, 23 PRIMARY KEY ("id") 24); 25CREATE INDEX "submission_projectid" on "submission" ("projectid"); 26CREATE INDEX "submission_status" on "submission" ("status"); 27 28CREATE TABLE "buildtesttime" ( 29 "buildid" bigint DEFAULT '0' NOT NULL, 30 "time" numeric(7,2) DEFAULT '0.00' NOT NULL, 31 PRIMARY KEY ("buildid") 32); 33 34CREATE TABLE "blockbuild" ( 35 "id" serial NOT NULL, 36 "projectid" bigint NOT NULL, 37 "buildname" character varying(255) DEFAULT '' NOT NULL, 38 "sitename" character varying(255) DEFAULT '' NOT NULL, 39 "ipaddress" character varying(255) DEFAULT '' NOT NULL, 40 PRIMARY KEY ("id") 41); 42CREATE INDEX "blockbuild_projectid" on "blockbuild" ("projectid"); 43CREATE INDEX "blockbuild_buildname" on "blockbuild" ("buildname"); 44CREATE INDEX "blockbuild_sitename" on "blockbuild" ("sitename"); 45CREATE INDEX "blockbuild_ipaddress" on "blockbuild" ("ipaddress"); 46 47 48-- 49-- Table: client_cmake 50-- 51CREATE TABLE "client_cmake" ( 52 "id" serial NOT NULL, 53 "version" character varying(255) NOT NULL, 54 PRIMARY KEY ("id") 55); 56 57 58-- 59-- Table: client_compiler 60-- 61CREATE TABLE "client_compiler" ( 62 "id" serial NOT NULL, 63 "name" character varying(255) NOT NULL, 64 "version" character varying(255) NOT NULL, 65 PRIMARY KEY ("id") 66); 67 68 69-- 70-- Table: client_job 71-- 72CREATE TABLE "client_job" ( 73 "id" bigserial NOT NULL, 74 "scheduleid" bigint NOT NULL, 75 "osid" smallint NOT NULL, 76 "siteid" bigint DEFAULT NULL, 77 "startdate" timestamp(0) DEFAULT '1980-01-01 00:00:00' NOT NULL, 78 "enddate" timestamp(0) DEFAULT '1980-01-01 00:00:00' NOT NULL, 79 "status" bigint DEFAULT NULL, 80 "output" text, 81 "cmakeid" bigint NOT NULL, 82 "compilerid" bigint NOT NULL 83); 84CREATE INDEX "client_job_scheduleid" on "client_job" ("scheduleid"); 85CREATE INDEX "client_job_startdate" on "client_job" ("startdate"); 86CREATE INDEX "client_job_enddate" on "client_job" ("enddate"); 87CREATE INDEX "client_job_status" on "client_job" ("status"); 88 89 90-- 91-- Table: client_jobschedule 92-- 93CREATE TABLE "client_jobschedule" ( 94 "id" bigserial NOT NULL, 95 "userid" bigint DEFAULT NULL, 96 "projectid" bigint DEFAULT NULL, 97 "cmakecache" text NOT NULL, 98 "startdate" timestamp(0) DEFAULT '1980-01-01 00:00:00' NOT NULL, 99 "enddate" timestamp(0) DEFAULT '1980-01-01 00:00:00' NOT NULL, 100 "type" smallint NOT NULL, 101 "starttime" time DEFAULT '00:00:00' NOT NULL, 102 "repeattime" numeric(3,2) DEFAULT '0.00' NOT NULL, 103 "enable" smallint NOT NULL, 104 "lastrun" timestamp(0) DEFAULT '1980-01-01 00:00:00' NOT NULL, 105 "repository" character varying(512) default '', 106 "module" character varying(255) default '', 107 "buildnamesuffix" character varying(255) default '', 108 "tag" character varying(255) default '' 109); 110CREATE INDEX "client_jobschedule_userid" on "client_jobschedule" ("userid"); 111CREATE INDEX "client_jobschedule_projectid" on "client_jobschedule" ("projectid"); 112CREATE INDEX "client_jobschedule_enable" on "client_jobschedule" ("enable"); 113CREATE INDEX "client_jobschedule_starttime" on "client_jobschedule" ("starttime"); 114CREATE INDEX "client_jobschedule_repeattime" on "client_jobschedule" ("repeattime"); 115 116 117-- 118-- Table: client_jobschedule2cmake 119-- 120CREATE TABLE "client_jobschedule2cmake" ( 121 "scheduleid" bigint NOT NULL, 122 "cmakeid" bigint NOT NULL, 123 Constraint "scheduleid2" UNIQUE ("scheduleid", "cmakeid") 124); 125 126-- 127-- Table: client_jobschedule2compiler 128-- 129CREATE TABLE "client_jobschedule2compiler" ( 130 "scheduleid" bigint NOT NULL, 131 "compilerid" bigint NOT NULL, 132 Constraint "scheduleid3" UNIQUE ("scheduleid", "compilerid") 133); 134 135-- 136-- Table: client_jobschedule2library 137-- 138CREATE TABLE "client_jobschedule2library" ( 139 "scheduleid" bigint NOT NULL, 140 "libraryid" bigint NOT NULL, 141 Constraint "scheduleid4" UNIQUE ("scheduleid", "libraryid") 142); 143 144 145-- 146-- Table: client_jobschedule2os 147-- 148CREATE TABLE "client_jobschedule2os" ( 149 "scheduleid" bigint NOT NULL, 150 "osid" bigint NOT NULL, 151 Constraint "scheduleid5" UNIQUE ("scheduleid", "osid") 152); 153 154 155-- 156-- Table: client_jobschedule2site 157-- 158CREATE TABLE "client_jobschedule2site" ( 159 "scheduleid" bigint NOT NULL, 160 "siteid" bigint NOT NULL, 161 Constraint "scheduleid6" UNIQUE ("scheduleid", "siteid") 162); 163 164 165 166-- 167-- Table: client_jobschedule2toolkit 168-- 169CREATE TABLE "client_jobschedule2toolkit" ( 170 "scheduleid" bigint NOT NULL, 171 "toolkitconfigurationid" bigint NOT NULL, 172 Constraint "scheduleid7" UNIQUE ("scheduleid", "toolkitconfigurationid") 173); 174 175 176 177-- 178-- Table: client_library 179-- 180CREATE TABLE "client_library" ( 181 "id" serial NOT NULL, 182 "name" character varying(255) NOT NULL, 183 "version" character varying(255) NOT NULL, 184 PRIMARY KEY ("id") 185); 186 187 188 189-- 190-- Table: client_os 191-- 192CREATE TABLE "client_os" ( 193 "id" serial NOT NULL, 194 "name" character varying(255) NOT NULL, 195 "version" character varying(255) NOT NULL, 196 "bits" smallint DEFAULT '32' NOT NULL, 197 PRIMARY KEY ("id") 198); 199CREATE INDEX "client_os_name" on "client_os" ("name"); 200CREATE INDEX "client_os_version" on "client_os" ("version"); 201CREATE INDEX "client_os_bits" on "client_os" ("bits"); 202 203 204-- 205-- Table: client_site 206-- 207CREATE TABLE "client_site" ( 208 "id" serial NOT NULL, 209 "name" character varying(255) DEFAULT NULL, 210 "osid" bigint DEFAULT NULL, 211 "systemname" character varying(255) DEFAULT NULL, 212 "host" character varying(255) DEFAULT NULL, 213 "basedirectory" character varying(512) NOT NULL, 214 PRIMARY KEY ("id") 215); 216CREATE INDEX "client_site_name" on "client_site" ("name"); 217CREATE INDEX "client_site_system" on "client_site" ("osid"); 218 219 220-- 221-- Table: client_site2cmake 222-- 223CREATE TABLE "client_site2cmake" ( 224 "siteid" bigint DEFAULT NULL, 225 "cmakeid" bigint DEFAULT NULL, 226 "path" character varying(512) DEFAULT NULL 227); 228CREATE INDEX "client_site2cmake_siteid" on "client_site2cmake" ("siteid"); 229CREATE INDEX "client_site2cmake_version" on "client_site2cmake" ("cmakeid"); 230 231 232-- 233-- Table: client_site2compiler 234-- 235CREATE TABLE "client_site2compiler" ( 236 "siteid" bigint DEFAULT NULL, 237 "compilerid" bigint DEFAULT NULL, 238 "command" character varying(512) DEFAULT NULL, 239 "generator" character varying(255) NOT NULL 240); 241CREATE INDEX "client_site2compiler_siteid" on "client_site2compiler" ("siteid"); 242 243 244-- 245-- Table: client_site2library 246-- 247CREATE TABLE "client_site2library" ( 248 "siteid" bigint DEFAULT NULL, 249 "libraryid" bigint DEFAULT NULL, 250 "path" character varying(512) DEFAULT NULL, 251 "include" character varying(512) NOT NULL 252); 253CREATE INDEX "client_site2library_siteid" on "client_site2library" ("siteid"); 254 255-- 256-- Table: client_toolkit 257-- 258CREATE TABLE "client_toolkit" ( 259 "id" serial NOT NULL, 260 "name" character varying(255) NOT NULL, 261 "projectid" bigint DEFAULT '0' NOT NULL, 262 PRIMARY KEY ("id") 263); 264CREATE INDEX "client_toolkit_projectid" on "client_toolkit" ("projectid"); 265 266 267-- 268-- Table: client_toolkitconfiguration 269-- 270CREATE TABLE "client_toolkitconfiguration" ( 271 "id" serial NOT NULL, 272 "toolkitversionid" bigint NOT NULL, 273 "name" character varying(255) NOT NULL, 274 "cmakecache" text, 275 "environment" text, 276 "binarypath" character varying(512) NOT NULL, 277 PRIMARY KEY ("id") 278); 279CREATE INDEX "client_toolkitconfiguration_name" on "client_toolkitconfiguration" ("name"); 280CREATE INDEX "client_toolkitconfiguration_binarypath" on "client_toolkitconfiguration" ("binarypath"); 281 282 283-- 284-- Table: client_toolkitconfiguration2os 285-- 286CREATE TABLE "client_toolkitconfiguration2os" ( 287 "toolkitconfigurationid" bigint NOT NULL, 288 "osid" bigint NOT NULL 289); 290CREATE INDEX "client_toolkitconfiguration2os_toolkitconfigurationid" on "client_toolkitconfiguration2os" ("toolkitconfigurationid"); 291CREATE INDEX "client_toolkitconfiguration2os_osid" on "client_toolkitconfiguration2os" ("osid"); 292 293 294-- 295-- Table: client_toolkitversion 296-- 297CREATE TABLE "client_toolkitversion" ( 298 "id" serial NOT NULL, 299 "toolkitid" bigint NOT NULL, 300 "name" character varying(10) NOT NULL, 301 "repositoryurl" character varying(255) NOT NULL, 302 "repositorytype" smallint NOT NULL, 303 "repositorymodule" character varying(100) NOT NULL, 304 "tag" character varying(30) DEFAULT NULL, 305 "sourcepath" character varying(512) NOT NULL, 306 "ctestprojectname" character varying(50) DEFAULT NULL, 307 PRIMARY KEY ("id") 308); 309CREATE INDEX "client_toolkitversion_toolkitid" on "client_toolkitversion" ("toolkitid"); 310CREATE INDEX "client_toolkitversion_version" on "client_toolkitversion" ("name"); 311 312 313-- 314-- Table structure for table projectrobot 315-- 316CREATE TABLE "projectrobot" ( 317 "projectid" bigint NOT NULL, 318 "robotname" character varying(255) NOT NULL, 319 "authorregex" character varying(512) NOT NULL 320); 321CREATE INDEX "projectrobot_projectid" on "projectrobot" ("projectid"); 322CREATE INDEX "projectrobot_robotname" on "projectrobot" ("robotname"); 323 324-- 325-- Table structure for table `filesum` 326-- 327 328CREATE TABLE "filesum" ( 329 "id" serial NOT NULL, 330 "md5sum" character varying(32) NOT NULL, 331 "contents" bytea, 332 PRIMARY KEY ("id") 333); 334CREATE INDEX "filesum_md5sum" on "filesum" ("md5sum"); 335