1-- 2-- PostgreSQL database dump 3-- 4 5SET client_encoding = 'LATIN1'; 6SET check_function_bodies = false; 7 8-- 9-- TOC entry 3 (OID 17145) 10-- Name: exilog; Type: SCHEMA; Schema: -; Owner: 11-- 12 13CREATE SCHEMA exilog AUTHORIZATION exilog; 14 15 16SET SESSION AUTHORIZATION 'exilog'; 17 18SET search_path = exilog, pg_catalog; 19 20-- 21-- TOC entry 4 (OID 17181) 22-- Name: deferrals; Type: TABLE; Schema: exilog; Owner: exilog 23-- 24 25CREATE TABLE deferrals ( 26 server character varying(32) NOT NULL, 27 message_id character(16) NOT NULL, 28 "timestamp" bigint NOT NULL, 29 rcpt character varying(200) NOT NULL, 30 rcpt_intermediate character varying(200), 31 rcpt_final character varying(200) NOT NULL, 32 host_addr inet, 33 host_dns character varying(255), 34 tls_cipher character varying(128), 35 router character varying(128), 36 transport character varying(128), 37 shadow_transport character varying(128), 38 errmsg character varying(2048) 39); 40 41 42-- 43-- TOC entry 5 (OID 17194) 44-- Name: errors; Type: TABLE; Schema: exilog; Owner: exilog 45-- 46 47CREATE TABLE errors ( 48 server character varying(32) NOT NULL, 49 message_id character(16) NOT NULL, 50 "timestamp" bigint NOT NULL, 51 rcpt character varying(200) NOT NULL, 52 rcpt_intermediate character varying(200), 53 rcpt_final character varying(200) NOT NULL, 54 host_addr inet, 55 host_dns character varying(255), 56 tls_cipher character varying(128), 57 router character varying(128), 58 transport character varying(128), 59 shadow_transport character varying(128), 60 errmsg character varying(2048) 61); 62 63 64-- 65-- TOC entry 6 (OID 17207) 66-- Name: deliveries; Type: TABLE; Schema: exilog; Owner: exilog 67-- 68 69CREATE TABLE deliveries ( 70 server character varying(32) NOT NULL, 71 message_id character(16) NOT NULL, 72 "timestamp" bigint NOT NULL, 73 rcpt character varying(200) NOT NULL, 74 rcpt_intermediate character varying(200), 75 rcpt_final character varying(200) NOT NULL, 76 host_addr inet, 77 host_dns character varying(255), 78 tls_cipher character varying(128), 79 router character varying(128), 80 transport character varying(128), 81 shadow_transport character varying(128) 82); 83 84 85-- 86-- TOC entry 7 (OID 17220) 87-- Name: queue; Type: TABLE; Schema: exilog; Owner: exilog 88-- 89 90CREATE TABLE queue ( 91 server character varying(32) NOT NULL, 92 message_id character(16) NOT NULL, 93 mailfrom character varying(255), 94 "timestamp" bigint, 95 num_dsn integer, 96 frozen bigint, 97 recipients_delivered bytea, 98 recipients_pending bytea, 99 spool_path character varying(64), 100 subject character varying(255), 101 msgid character varying(255), 102 headers bytea, 103 "action" character varying(64) 104); 105 106 107-- 108-- TOC entry 8 (OID 17249) 109-- Name: unknown; Type: TABLE; Schema: exilog; Owner: exilog 110-- 111 112CREATE TABLE "unknown" ( 113 server character varying(32) NOT NULL, 114 message_id character(16) NOT NULL, 115 "timestamp" bigint NOT NULL, 116 line character varying(255) NOT NULL 117); 118 119 120-- 121-- TOC entry 9 (OID 695844) 122-- Name: messages; Type: TABLE; Schema: exilog; Owner: exilog 123-- 124 125CREATE TABLE messages ( 126 server character varying(32) NOT NULL, 127 message_id character(16) NOT NULL, 128 "timestamp" bigint, 129 msgid character varying(255), 130 completed bigint, 131 mailfrom character varying(255), 132 host_addr inet, 133 host_rdns character varying(255), 134 host_ident character varying(255), 135 host_helo character varying(255), 136 proto character varying(32), 137 size bigint, 138 tls_cipher character varying(128), 139 "user" character varying(128), 140 bounce_parent character(16) 141); 142 143 144-- 145-- TOC entry 10 (OID 695860) 146-- Name: rejects; Type: TABLE; Schema: exilog; Owner: exilog 147-- 148 149CREATE TABLE rejects ( 150 server character varying(32) NOT NULL, 151 message_id character(16), 152 "timestamp" bigint NOT NULL, 153 host_addr inet, 154 host_rdns character varying(255), 155 host_ident character varying(255), 156 host_helo character varying(255), 157 mailfrom character varying(255), 158 rcpt character varying(255), 159 errmsg character varying(255) NOT NULL 160); 161 162 163-- 164-- TOC entry 16 (OID 17188) 165-- Name: deferrals_server; Type: INDEX; Schema: exilog; Owner: exilog 166-- 167 168CREATE INDEX deferrals_server ON deferrals USING btree (server); 169 170 171-- 172-- TOC entry 12 (OID 17189) 173-- Name: deferrals_message_id; Type: INDEX; Schema: exilog; Owner: exilog 174-- 175 176CREATE INDEX deferrals_message_id ON deferrals USING btree (message_id); 177 178 179-- 180-- TOC entry 18 (OID 17190) 181-- Name: deferrals_timestamp; Type: INDEX; Schema: exilog; Owner: exilog 182-- 183 184CREATE INDEX deferrals_timestamp ON deferrals USING btree ("timestamp"); 185 186 187-- 188-- TOC entry 14 (OID 17191) 189-- Name: deferrals_rcpt; Type: INDEX; Schema: exilog; Owner: exilog 190-- 191 192CREATE INDEX deferrals_rcpt ON deferrals USING btree (rcpt); 193 194 195-- 196-- TOC entry 15 (OID 17192) 197-- Name: deferrals_rcpt_final; Type: INDEX; Schema: exilog; Owner: exilog 198-- 199 200CREATE INDEX deferrals_rcpt_final ON deferrals USING btree (rcpt_final); 201 202 203-- 204-- TOC entry 11 (OID 17193) 205-- Name: deferrals_host_addr; Type: INDEX; Schema: exilog; Owner: exilog 206-- 207 208CREATE INDEX deferrals_host_addr ON deferrals USING btree (host_addr); 209 210 211-- 212-- TOC entry 24 (OID 17199) 213-- Name: errors_server; Type: INDEX; Schema: exilog; Owner: exilog 214-- 215 216CREATE INDEX errors_server ON errors USING btree (server); 217 218 219-- 220-- TOC entry 20 (OID 17200) 221-- Name: errors_message_id; Type: INDEX; Schema: exilog; Owner: exilog 222-- 223 224CREATE INDEX errors_message_id ON errors USING btree (message_id); 225 226 227-- 228-- TOC entry 26 (OID 17201) 229-- Name: errors_timestamp; Type: INDEX; Schema: exilog; Owner: exilog 230-- 231 232CREATE INDEX errors_timestamp ON errors USING btree ("timestamp"); 233 234 235-- 236-- TOC entry 22 (OID 17202) 237-- Name: errors_rcpt; Type: INDEX; Schema: exilog; Owner: exilog 238-- 239 240CREATE INDEX errors_rcpt ON errors USING btree (rcpt); 241 242 243-- 244-- TOC entry 23 (OID 17203) 245-- Name: errors_rcpt_final; Type: INDEX; Schema: exilog; Owner: exilog 246-- 247 248CREATE INDEX errors_rcpt_final ON errors USING btree (rcpt_final); 249 250 251-- 252-- TOC entry 19 (OID 17204) 253-- Name: errors_host_addr; Type: INDEX; Schema: exilog; Owner: exilog 254-- 255 256CREATE INDEX errors_host_addr ON errors USING btree (host_addr); 257 258 259-- 260-- TOC entry 32 (OID 17212) 261-- Name: deliveries_server; Type: INDEX; Schema: exilog; Owner: exilog 262-- 263 264CREATE INDEX deliveries_server ON deliveries USING btree (server); 265 266 267-- 268-- TOC entry 28 (OID 17213) 269-- Name: deliveries_message_id; Type: INDEX; Schema: exilog; Owner: exilog 270-- 271 272CREATE INDEX deliveries_message_id ON deliveries USING btree (message_id); 273 274 275-- 276-- TOC entry 34 (OID 17214) 277-- Name: deliveries_timestamp; Type: INDEX; Schema: exilog; Owner: exilog 278-- 279 280CREATE INDEX deliveries_timestamp ON deliveries USING btree ("timestamp"); 281 282 283-- 284-- TOC entry 30 (OID 17215) 285-- Name: deliveries_rcpt; Type: INDEX; Schema: exilog; Owner: exilog 286-- 287 288CREATE INDEX deliveries_rcpt ON deliveries USING btree (rcpt); 289 290 291-- 292-- TOC entry 31 (OID 17216) 293-- Name: deliveries_rcpt_final; Type: INDEX; Schema: exilog; Owner: exilog 294-- 295 296CREATE INDEX deliveries_rcpt_final ON deliveries USING btree (rcpt_final); 297 298 299-- 300-- TOC entry 27 (OID 17217) 301-- Name: deliveries_host_addr; Type: INDEX; Schema: exilog; Owner: exilog 302-- 303 304CREATE INDEX deliveries_host_addr ON deliveries USING btree (host_addr); 305 306 307-- 308-- TOC entry 41 (OID 17241) 309-- Name: queue_server; Type: INDEX; Schema: exilog; Owner: exilog 310-- 311 312CREATE INDEX queue_server ON queue USING btree (server); 313 314 315-- 316-- TOC entry 38 (OID 17242) 317-- Name: queue_message_id; Type: INDEX; Schema: exilog; Owner: exilog 318-- 319 320CREATE INDEX queue_message_id ON queue USING btree (message_id); 321 322 323-- 324-- TOC entry 37 (OID 17243) 325-- Name: queue_mailfrom; Type: INDEX; Schema: exilog; Owner: exilog 326-- 327 328CREATE INDEX queue_mailfrom ON queue USING btree (mailfrom); 329 330 331-- 332-- TOC entry 44 (OID 17244) 333-- Name: queue_timestamp; Type: INDEX; Schema: exilog; Owner: exilog 334-- 335 336CREATE INDEX queue_timestamp ON queue USING btree ("timestamp"); 337 338 339-- 340-- TOC entry 36 (OID 17245) 341-- Name: queue_frozen; Type: INDEX; Schema: exilog; Owner: exilog 342-- 343 344CREATE INDEX queue_frozen ON queue USING btree (frozen); 345 346 347-- 348-- TOC entry 43 (OID 17246) 349-- Name: queue_spool_path; Type: INDEX; Schema: exilog; Owner: exilog 350-- 351 352CREATE INDEX queue_spool_path ON queue USING btree (spool_path); 353 354 355-- 356-- TOC entry 39 (OID 17247) 357-- Name: queue_msgid; Type: INDEX; Schema: exilog; Owner: exilog 358-- 359 360CREATE INDEX queue_msgid ON queue USING btree (msgid); 361 362 363-- 364-- TOC entry 35 (OID 17248) 365-- Name: queue_action; Type: INDEX; Schema: exilog; Owner: exilog 366-- 367 368CREATE INDEX queue_action ON queue USING btree ("action"); 369 370 371-- 372-- TOC entry 47 (OID 17253) 373-- Name: unknown_server; Type: INDEX; Schema: exilog; Owner: exilog 374-- 375 376CREATE INDEX unknown_server ON "unknown" USING btree (server); 377 378 379-- 380-- TOC entry 45 (OID 17254) 381-- Name: unknown_message_id; Type: INDEX; Schema: exilog; Owner: exilog 382-- 383 384CREATE INDEX unknown_message_id ON "unknown" USING btree (message_id); 385 386 387-- 388-- TOC entry 49 (OID 17255) 389-- Name: unknown_timestamp; Type: INDEX; Schema: exilog; Owner: exilog 390-- 391 392CREATE INDEX unknown_timestamp ON "unknown" USING btree ("timestamp"); 393 394 395-- 396-- TOC entry 17 (OID 237716) 397-- Name: deferrals_server_message_id; Type: INDEX; Schema: exilog; Owner: exilog 398-- 399 400CREATE INDEX deferrals_server_message_id ON deferrals USING btree (server, message_id); 401 402 403-- 404-- TOC entry 33 (OID 237717) 405-- Name: deliveries_server_message_id; Type: INDEX; Schema: exilog; Owner: exilog 406-- 407 408CREATE INDEX deliveries_server_message_id ON deliveries USING btree (server, message_id); 409 410 411-- 412-- TOC entry 25 (OID 237719) 413-- Name: errors_server_message_id; Type: INDEX; Schema: exilog; Owner: exilog 414-- 415 416CREATE INDEX errors_server_message_id ON errors USING btree (server, message_id); 417 418 419-- 420-- TOC entry 42 (OID 237725) 421-- Name: queue_server_message_id; Type: INDEX; Schema: exilog; Owner: exilog 422-- 423 424CREATE INDEX queue_server_message_id ON queue USING btree (server, message_id); 425 426 427-- 428-- TOC entry 48 (OID 237821) 429-- Name: unknown_server_message_id; Type: INDEX; Schema: exilog; Owner: exilog 430-- 431 432CREATE INDEX unknown_server_message_id ON "unknown" USING btree (server, message_id); 433 434 435-- 436-- TOC entry 57 (OID 695849) 437-- Name: server; Type: INDEX; Schema: exilog; Owner: exilog 438-- 439 440CREATE INDEX server ON messages USING btree (server); 441 442 443-- 444-- TOC entry 53 (OID 695850) 445-- Name: message_id; Type: INDEX; Schema: exilog; Owner: exilog 446-- 447 448CREATE INDEX message_id ON messages USING btree (message_id); 449 450 451-- 452-- TOC entry 55 (OID 695851) 453-- Name: msgid; Type: INDEX; Schema: exilog; Owner: exilog 454-- 455 456CREATE INDEX msgid ON messages USING btree (msgid); 457 458 459-- 460-- TOC entry 58 (OID 695852) 461-- Name: timestamp; Type: INDEX; Schema: exilog; Owner: exilog 462-- 463 464CREATE INDEX "timestamp" ON messages USING btree ("timestamp"); 465 466 467-- 468-- TOC entry 51 (OID 695853) 469-- Name: host_addr; Type: INDEX; Schema: exilog; Owner: exilog 470-- 471 472CREATE INDEX host_addr ON messages USING btree (host_addr); 473 474 475-- 476-- TOC entry 50 (OID 695854) 477-- Name: bounce_parent; Type: INDEX; Schema: exilog; Owner: exilog 478-- 479 480CREATE INDEX bounce_parent ON messages USING btree (bounce_parent); 481 482 483-- 484-- TOC entry 59 (OID 695855) 485-- Name: user; Type: INDEX; Schema: exilog; Owner: exilog 486-- 487 488CREATE INDEX "user" ON messages USING btree ("user"); 489 490 491-- 492-- TOC entry 52 (OID 695856) 493-- Name: mailfrom; Type: INDEX; Schema: exilog; Owner: exilog 494-- 495 496CREATE INDEX mailfrom ON messages USING btree (mailfrom); 497 498 499-- 500-- TOC entry 54 (OID 695857) 501-- Name: messages_server_message_id; Type: INDEX; Schema: exilog; Owner: exilog 502-- 503 504CREATE INDEX messages_server_message_id ON messages USING btree (server, message_id); 505 506 507-- 508-- TOC entry 64 (OID 695865) 509-- Name: rejects_server; Type: INDEX; Schema: exilog; Owner: exilog 510-- 511 512CREATE INDEX rejects_server ON rejects USING btree (server); 513 514 515-- 516-- TOC entry 66 (OID 695866) 517-- Name: rejects_timestamp; Type: INDEX; Schema: exilog; Owner: exilog 518-- 519 520CREATE INDEX rejects_timestamp ON rejects USING btree ("timestamp"); 521 522 523-- 524-- TOC entry 60 (OID 695867) 525-- Name: rejects_host_addr; Type: INDEX; Schema: exilog; Owner: exilog 526-- 527 528CREATE INDEX rejects_host_addr ON rejects USING btree (host_addr); 529 530 531-- 532-- TOC entry 61 (OID 695868) 533-- Name: rejects_mailfrom; Type: INDEX; Schema: exilog; Owner: exilog 534-- 535 536CREATE INDEX rejects_mailfrom ON rejects USING btree (mailfrom); 537 538 539-- 540-- TOC entry 63 (OID 695869) 541-- Name: rejects_rcpt; Type: INDEX; Schema: exilog; Owner: exilog 542-- 543 544CREATE INDEX rejects_rcpt ON rejects USING btree (rcpt); 545 546 547-- 548-- TOC entry 62 (OID 695870) 549-- Name: rejects_message_id; Type: INDEX; Schema: exilog; Owner: exilog 550-- 551 552CREATE INDEX rejects_message_id ON rejects USING btree (message_id); 553 554 555-- 556-- TOC entry 65 (OID 695871) 557-- Name: rejects_server_message_id; Type: INDEX; Schema: exilog; Owner: exilog 558-- 559 560CREATE INDEX rejects_server_message_id ON rejects USING btree (server, message_id); 561 562 563-- 564-- TOC entry 13 (OID 17186) 565-- Name: deferrals_primary; Type: CONSTRAINT; Schema: exilog; Owner: exilog 566-- 567 568ALTER TABLE ONLY deferrals 569 ADD CONSTRAINT deferrals_primary PRIMARY KEY (server, message_id, "timestamp", rcpt, rcpt_final); 570 571 572-- 573-- TOC entry 21 (OID 17205) 574-- Name: errors_primary; Type: CONSTRAINT; Schema: exilog; Owner: exilog 575-- 576 577ALTER TABLE ONLY errors 578 ADD CONSTRAINT errors_primary PRIMARY KEY (server, message_id, "timestamp", rcpt, rcpt_final); 579 580 581-- 582-- TOC entry 29 (OID 17218) 583-- Name: deliveries_primary; Type: CONSTRAINT; Schema: exilog; Owner: exilog 584-- 585 586ALTER TABLE ONLY deliveries 587 ADD CONSTRAINT deliveries_primary PRIMARY KEY (server, message_id, "timestamp", rcpt, rcpt_final); 588 589 590-- 591-- TOC entry 40 (OID 17239) 592-- Name: queue_primary; Type: CONSTRAINT; Schema: exilog; Owner: exilog 593-- 594 595ALTER TABLE ONLY queue 596 ADD CONSTRAINT queue_primary PRIMARY KEY (server, message_id); 597 598 599-- 600-- TOC entry 46 (OID 17251) 601-- Name: unknown_primary; Type: CONSTRAINT; Schema: exilog; Owner: exilog 602-- 603 604ALTER TABLE ONLY "unknown" 605 ADD CONSTRAINT unknown_primary PRIMARY KEY (server, message_id, "timestamp", line); 606 607 608-- 609-- TOC entry 56 (OID 695858) 610-- Name: primary; Type: CONSTRAINT; Schema: exilog; Owner: exilog 611-- 612 613ALTER TABLE ONLY messages 614 ADD CONSTRAINT "primary" PRIMARY KEY (server, message_id); 615 616 617-- 618-- TOC entry 67 (OID 695872) 619-- Name: rejects_unique; Type: CONSTRAINT; Schema: exilog; Owner: exilog 620-- 621 622ALTER TABLE ONLY rejects 623 ADD CONSTRAINT rejects_unique UNIQUE (server, "timestamp", host_addr, errmsg); 624 625