2 -- Created by SQL::Translator::Producer::PostgreSQL
3 -- Created on Sat Apr 15 20:14:22 2017
13 CONSTRAINT "arch_arch_key" UNIQUE ("arch")
20 CREATE TABLE "bin_pkg" (
24 CONSTRAINT "bin_pkg_pkg_key" UNIQUE ("pkg")
29 -- Table: column_comments
31 CREATE TABLE "column_comments" (
32 "table_name" text NOT NULL,
33 "column_name" text NOT NULL,
34 "comment_text" text NOT NULL,
35 CONSTRAINT "column_comments_table_name_column_name_idx" UNIQUE ("table_name", "column_name")
40 -- Table: correspondent
42 CREATE TABLE "correspondent" (
46 CONSTRAINT "correspondent_addr_idx" UNIQUE ("addr")
53 CREATE TABLE "message" (
55 "msgid" text DEFAULT '' NOT NULL,
56 "from_complete" text DEFAULT '' NOT NULL,
57 "to_complete" text DEFAULT '' NOT NULL,
58 "subject" text DEFAULT '' NOT NULL,
59 "sent_date" timestamp with time zone,
60 "refs" text DEFAULT '' NOT NULL,
61 "spam_score" double precision DEFAULT '0' NOT NULL,
62 "is_spam" boolean DEFAULT false NOT NULL,
64 CONSTRAINT "message_msgid_from_complete_to_complete_subject_idx" UNIQUE ("msgid", "from_complete", "to_complete", "subject")
66 CREATE INDEX "message_msgid_idx" on "message" ("msgid");
67 CREATE INDEX "message_subject_idx" on "message" ("subject");
73 CREATE TABLE "severity" (
75 "severity" text NOT NULL,
76 "ordering" integer DEFAULT 5 NOT NULL,
77 "strong" boolean DEFAULT false,
78 "obsolete" boolean DEFAULT false,
80 CONSTRAINT "severity_severity_idx" UNIQUE ("severity")
82 CREATE INDEX "severity_ordering_idx" on "severity" ("ordering");
88 CREATE TABLE "src_pkg" (
91 "pseduopkg" boolean DEFAULT false NOT NULL,
93 "creation" timestamp with time zone DEFAULT current_timestamp NOT NULL,
94 "disabled" timestamp with time zone DEFAULT 'infinity' NOT NULL,
95 "last_modified" timestamp with time zone DEFAULT current_timestamp NOT NULL,
96 "obsolete" boolean DEFAULT false NOT NULL,
98 CONSTRAINT "src_pkg_pkg_disabled" UNIQUE ("pkg", "disabled")
100 CREATE INDEX "src_pkg_idx_alias_of" on "src_pkg" ("alias_of");
101 CREATE INDEX "src_pkg_pkg" on "src_pkg" ("pkg");
107 CREATE TABLE "suite" (
108 "id" serial NOT NULL,
109 "codename" text NOT NULL,
112 "active" boolean DEFAULT true,
114 CONSTRAINT "suite_idx_codename" UNIQUE ("codename"),
115 CONSTRAINT "suite_idx_version" UNIQUE ("version"),
116 CONSTRAINT "suite_suite_name_key" UNIQUE ("suite_name")
121 -- Table: table_comments
123 CREATE TABLE "table_comments" (
124 "table_name" text NOT NULL,
125 "comment_text" text NOT NULL,
126 CONSTRAINT "table_comments_table_name_idx" UNIQUE ("table_name"),
127 CONSTRAINT "table_comments_table_name_key" UNIQUE ("table_name")
135 "id" serial NOT NULL,
137 "obsolete" boolean DEFAULT false,
139 CONSTRAINT "tag_tag_key" UNIQUE ("tag")
144 -- Table: correspondent_full_name
146 CREATE TABLE "correspondent_full_name" (
147 "correspondent" integer NOT NULL,
148 "full_name" text NOT NULL,
149 "last_seen" timestamp DEFAULT current_timestamp NOT NULL,
150 CONSTRAINT "correspondent_full_name_correspondent_full_name_idx" UNIQUE ("correspondent", "full_name")
152 CREATE INDEX "correspondent_full_name_idx_correspondent" on "correspondent_full_name" ("correspondent");
153 CREATE INDEX "correspondent_full_name_idx_full_name" on "correspondent_full_name" ("full_name");
154 CREATE INDEX "correspondent_full_name_idx_last_seen" on "correspondent_full_name" ("last_seen");
160 CREATE TABLE "maintainer" (
161 "id" serial NOT NULL,
162 "name" text NOT NULL,
163 "correspondent" integer NOT NULL,
164 "created" timestamp with time zone DEFAULT current_timestamp NOT NULL,
165 "modified" timestamp with time zone DEFAULT current_timestamp NOT NULL,
167 CONSTRAINT "maintainer_name_idx" UNIQUE ("name")
169 CREATE INDEX "maintainer_idx_correspondent" on "maintainer" ("correspondent");
173 -- Table: message_refs
175 CREATE TABLE "message_refs" (
176 "message" integer NOT NULL,
177 "refs" integer NOT NULL,
178 "inferred" boolean DEFAULT false,
179 "primary_ref" boolean DEFAULT false,
180 CONSTRAINT "message_refs_message_refs_idx" UNIQUE ("message", "refs")
182 CREATE INDEX "message_refs_idx_message" on "message_refs" ("message");
183 CREATE INDEX "message_refs_idx_refs" on "message_refs" ("refs");
189 CREATE TABLE "user_tag" (
190 "id" serial NOT NULL,
192 "correspondent" integer NOT NULL,
194 CONSTRAINT "user_tag_tag_correspondent" UNIQUE ("tag", "correspondent")
196 CREATE INDEX "user_tag_idx_correspondent" on "user_tag" ("correspondent");
197 CREATE INDEX "user_tag_correspondent" on "user_tag" ("correspondent");
204 "id" integer NOT NULL,
205 "creation" timestamp with time zone DEFAULT current_timestamp NOT NULL,
206 "log_modified" timestamp with time zone DEFAULT current_timestamp NOT NULL,
207 "last_modified" timestamp with time zone DEFAULT current_timestamp NOT NULL,
208 "archived" boolean DEFAULT false NOT NULL,
209 "unarchived" timestamp with time zone,
210 "forwarded" text DEFAULT '' NOT NULL,
211 "summary" text DEFAULT '' NOT NULL,
212 "outlook" text DEFAULT '' NOT NULL,
213 "subject" text NOT NULL,
214 "severity" integer NOT NULL,
216 "done_full" text DEFAULT '' NOT NULL,
218 "owner_full" text DEFAULT '' NOT NULL,
220 "submitter_full" text DEFAULT '' NOT NULL,
221 "unknown_packages" text DEFAULT '' NOT NULL,
224 CREATE INDEX "bug_idx_done" on "bug" ("done");
225 CREATE INDEX "bug_idx_owner" on "bug" ("owner");
226 CREATE INDEX "bug_idx_severity" on "bug" ("severity");
227 CREATE INDEX "bug_idx_submitter" on "bug" ("submitter");
228 CREATE INDEX "bug_idxowner" on "bug" ("owner");
229 CREATE INDEX "bug_idxsubmitter" on "bug" ("submitter");
230 CREATE INDEX "bug_idxdone" on "bug" ("done");
231 CREATE INDEX "bug_idxforwarded" on "bug" ("forwarded");
232 CREATE INDEX "bug_idxlast_modified" on "bug" ("last_modified");
233 CREATE INDEX "bug_idxseverity" on "bug" ("severity");
234 CREATE INDEX "bug_idxcreation" on "bug" ("creation");
235 CREATE INDEX "bug_idxlog_modified" on "bug" ("log_modified");
239 -- Table: message_correspondent
241 CREATE TABLE "message_correspondent" (
242 "message" integer NOT NULL,
243 "correspondent" integer NOT NULL,
244 "correspondent_type" character varying DEFAULT 'to' NOT NULL,
245 CONSTRAINT "message_correspondent_message_correspondent_correspondent_t_idx" UNIQUE ("message", "correspondent", "correspondent_type")
247 CREATE INDEX "message_correspondent_idx_correspondent" on "message_correspondent" ("correspondent");
248 CREATE INDEX "message_correspondent_idx_message" on "message_correspondent" ("message");
249 CREATE INDEX "message_correspondent_idxcorrespondent" on "message_correspondent" ("correspondent");
250 CREATE INDEX "message_correspondent_idxmessage" on "message_correspondent" ("message");
256 CREATE TABLE "bug_blocks" (
257 "id" serial NOT NULL,
258 "bug" integer NOT NULL,
259 "blocks" integer NOT NULL,
261 CONSTRAINT "bug_blocks_bug_id_blocks_idx" UNIQUE ("bug", "blocks")
263 CREATE INDEX "bug_blocks_idx_blocks" on "bug_blocks" ("blocks");
264 CREATE INDEX "bug_blocks_idx_bug" on "bug_blocks" ("bug");
265 CREATE INDEX "bug_blocks_bug_idx" on "bug_blocks" ("bug");
266 CREATE INDEX "bug_blocks_blocks_idx" on "bug_blocks" ("blocks");
272 CREATE TABLE "bug_merged" (
273 "id" serial NOT NULL,
274 "bug" integer NOT NULL,
275 "merged" integer NOT NULL,
277 CONSTRAINT "bug_merged_bug_id_merged_idx" UNIQUE ("bug", "merged")
279 CREATE INDEX "bug_merged_idx_bug" on "bug_merged" ("bug");
280 CREATE INDEX "bug_merged_idx_merged" on "bug_merged" ("merged");
281 CREATE INDEX "bug_merged_bug_idx" on "bug_merged" ("bug");
282 CREATE INDEX "bug_merged_merged_idx" on "bug_merged" ("merged");
288 CREATE TABLE "src_ver" (
289 "id" serial NOT NULL,
290 "src_pkg" integer NOT NULL,
291 "ver" debversion NOT NULL,
292 "maintainer" integer,
293 "upload_date" timestamp with time zone DEFAULT current_timestamp NOT NULL,
296 CONSTRAINT "src_ver_src_pkg_id_ver" UNIQUE ("src_pkg", "ver")
298 CREATE INDEX "src_ver_idx_based_on" on "src_ver" ("based_on");
299 CREATE INDEX "src_ver_idx_maintainer" on "src_ver" ("maintainer");
300 CREATE INDEX "src_ver_idx_src_pkg" on "src_ver" ("src_pkg");
304 -- Table: bug_affects_binpackage
306 CREATE TABLE "bug_affects_binpackage" (
307 "bug" integer NOT NULL,
308 "bin_pkg" integer NOT NULL,
309 CONSTRAINT "bug_affects_binpackage_id_pkg" UNIQUE ("bug", "bin_pkg")
311 CREATE INDEX "bug_affects_binpackage_idx_bin_pkg" on "bug_affects_binpackage" ("bin_pkg");
312 CREATE INDEX "bug_affects_binpackage_idx_bug" on "bug_affects_binpackage" ("bug");
316 -- Table: bug_affects_srcpackage
318 CREATE TABLE "bug_affects_srcpackage" (
319 "bug" integer NOT NULL,
320 "src_pkg" integer NOT NULL,
321 CONSTRAINT "bug_affects_srcpackage_id_pkg" UNIQUE ("bug", "src_pkg")
323 CREATE INDEX "bug_affects_srcpackage_idx_bug" on "bug_affects_srcpackage" ("bug");
324 CREATE INDEX "bug_affects_srcpackage_idx_src_pkg" on "bug_affects_srcpackage" ("src_pkg");
328 -- Table: bug_binpackage
330 CREATE TABLE "bug_binpackage" (
331 "bug" integer NOT NULL,
332 "bin_pkg" integer NOT NULL,
333 CONSTRAINT "bug_binpackage_id_pkg" UNIQUE ("bug", "bin_pkg")
335 CREATE INDEX "bug_binpackage_idx_bin_pkg" on "bug_binpackage" ("bin_pkg");
336 CREATE INDEX "bug_binpackage_idx_bug" on "bug_binpackage" ("bug");
337 CREATE INDEX "bug_binpackage_bin_pkg_idx" on "bug_binpackage" ("bin_pkg");
341 -- Table: bug_message
343 CREATE TABLE "bug_message" (
344 "bug" integer NOT NULL,
345 "message" integer NOT NULL,
346 "message_number" integer NOT NULL,
347 "bug_log_offset" integer,
348 "offset_valid" timestamp with time zone,
349 CONSTRAINT "bug_message_bug_message_idx" UNIQUE ("bug", "message")
351 CREATE INDEX "bug_message_idx_bug" on "bug_message" ("bug");
352 CREATE INDEX "bug_message_idx_message" on "bug_message" ("message");
353 CREATE INDEX "bug_message_idx_bug_message_number" on "bug_message" ("bug", "message_number");
357 -- Table: bug_srcpackage
359 CREATE TABLE "bug_srcpackage" (
360 "bug" integer NOT NULL,
361 "src_pkg" integer NOT NULL,
362 CONSTRAINT "bug_srcpackage_id_pkg" UNIQUE ("bug", "src_pkg")
364 CREATE INDEX "bug_srcpackage_idx_bug" on "bug_srcpackage" ("bug");
365 CREATE INDEX "bug_srcpackage_idx_src_pkg" on "bug_srcpackage" ("src_pkg");
366 CREATE INDEX "bug_srcpackage_src_pkg_idx" on "bug_srcpackage" ("src_pkg");
372 CREATE TABLE "bug_tag" (
373 "bug" integer NOT NULL,
374 "tag" integer NOT NULL,
375 CONSTRAINT "bug_tag_bug_tag" UNIQUE ("bug", "tag")
377 CREATE INDEX "bug_tag_idx_bug" on "bug_tag" ("bug");
378 CREATE INDEX "bug_tag_idx_tag" on "bug_tag" ("tag");
379 CREATE INDEX "bug_tag_tag" on "bug_tag" ("tag");
383 -- Table: bug_user_tag
385 CREATE TABLE "bug_user_tag" (
386 "bug" integer NOT NULL,
387 "user_tag" integer NOT NULL,
388 CONSTRAINT "bug_user_tag_bug_tag" UNIQUE ("bug", "user_tag")
390 CREATE INDEX "bug_user_tag_idx_bug" on "bug_user_tag" ("bug");
391 CREATE INDEX "bug_user_tag_idx_user_tag" on "bug_user_tag" ("user_tag");
392 CREATE INDEX "bug_user_tag_tag" on "bug_user_tag" ("user_tag");
396 -- Table: bug_status_cache
398 CREATE TABLE "bug_status_cache" (
399 "bug" integer NOT NULL,
402 "status" character varying NOT NULL,
403 "modified" timestamp with time zone DEFAULT current_timestamp NOT NULL,
404 "asof" timestamp with time zone DEFAULT current_timestamp NOT NULL,
405 CONSTRAINT "bug_status_cache_bug_suite_arch_idx" UNIQUE ("bug", "suite", "arch")
407 CREATE INDEX "bug_status_cache_idx_arch" on "bug_status_cache" ("arch");
408 CREATE INDEX "bug_status_cache_idx_bug" on "bug_status_cache" ("bug");
409 CREATE INDEX "bug_status_cache_idx_suite" on "bug_status_cache" ("suite");
413 -- Table: src_associations
415 CREATE TABLE "src_associations" (
416 "id" serial NOT NULL,
417 "suite" integer NOT NULL,
418 "source" integer NOT NULL,
419 "created" timestamp with time zone DEFAULT current_timestamp NOT NULL,
420 "modified" timestamp with time zone DEFAULT current_timestamp NOT NULL,
422 CONSTRAINT "src_associations_source_suite" UNIQUE ("source", "suite")
424 CREATE INDEX "src_associations_idx_source" on "src_associations" ("source");
425 CREATE INDEX "src_associations_idx_suite" on "src_associations" ("suite");
431 CREATE TABLE "bin_ver" (
432 "id" serial NOT NULL,
433 "bin_pkg" integer NOT NULL,
434 "src_ver" integer NOT NULL,
435 "arch" integer NOT NULL,
436 "ver" debversion NOT NULL,
438 CONSTRAINT "bin_ver_bin_pkg_id_arch_idx" UNIQUE ("bin_pkg", "arch", "ver")
440 CREATE INDEX "bin_ver_idx_arch" on "bin_ver" ("arch");
441 CREATE INDEX "bin_ver_idx_bin_pkg" on "bin_ver" ("bin_pkg");
442 CREATE INDEX "bin_ver_idx_src_ver" on "bin_ver" ("src_ver");
443 CREATE INDEX "bin_ver_ver_id_idx" on "bin_ver" ("ver");
444 CREATE INDEX "bin_ver_bin_pkg_id_idx" on "bin_ver" ("bin_pkg");
445 CREATE INDEX "bin_ver_src_ver_id_idx" on "bin_ver" ("src_ver");
446 CREATE INDEX "bin_ver_src_ver_id_arch_idx" on "bin_ver" ("src_ver", "arch");
452 CREATE TABLE "bug_ver" (
453 "id" serial NOT NULL,
454 "bug" integer NOT NULL,
458 "found" boolean DEFAULT true NOT NULL,
459 "creation" timestamp with time zone DEFAULT current_timestamp NOT NULL,
460 "last_modified" timestamp with time zone DEFAULT current_timestamp NOT NULL,
462 CONSTRAINT "bug_ver_bug_ver_string_found_idx" UNIQUE ("bug", "ver_string", "found")
464 CREATE INDEX "bug_ver_idx_bug" on "bug_ver" ("bug");
465 CREATE INDEX "bug_ver_idx_src_pkg" on "bug_ver" ("src_pkg");
466 CREATE INDEX "bug_ver_idx_src_ver" on "bug_ver" ("src_ver");
467 CREATE INDEX "bug_ver_src_pkg_id_idx" on "bug_ver" ("src_pkg");
468 CREATE INDEX "bug_ver_src_ver_id_idx" on "bug_ver" ("src_ver");
469 CREATE INDEX "bug_ver_src_pkg_id_src_ver_id_idx" on "bug_ver" ("src_pkg", "src_ver");
473 -- Table: bin_associations
475 CREATE TABLE "bin_associations" (
476 "id" serial NOT NULL,
477 "suite" integer NOT NULL,
478 "bin" integer NOT NULL,
479 "created" timestamp with time zone DEFAULT current_timestamp NOT NULL,
480 "modified" timestamp with time zone DEFAULT current_timestamp NOT NULL,
482 CONSTRAINT "bin_associations_bin_suite" UNIQUE ("bin", "suite")
484 CREATE INDEX "bin_associations_idx_bin" on "bin_associations" ("bin");
485 CREATE INDEX "bin_associations_idx_suite" on "bin_associations" ("suite");
489 -- View: "binary_versions"
491 CREATE VIEW "binary_versions" ( "src_pkg", "src_ver", "bin_pkg", "arch", "bin_ver", "src_ver_based_on", "src_pkg_based_on" ) AS
492 SELECT sp.pkg AS src_pkg, sv.ver AS src_ver, bp.pkg AS bin_pkg, a.arch AS arch, b.ver AS bin_ver,
493 svb.ver AS src_ver_based_on, spb.pkg AS src_pkg_based_on
494 FROM bin_ver b JOIN arch a ON b.arch = a.id
495 JOIN bin_pkg bp ON b.bin_pkg = bp.id
496 JOIN src_ver sv ON b.src_ver = sv.id
497 JOIN src_pkg sp ON sv.src_pkg = sp.id
498 LEFT OUTER JOIN src_ver svb ON sv.based_on = svb.id
499 LEFT OUTER JOIN src_pkg spb ON spb.id = svb.src_pkg;
505 -- View: "bug_package"
507 CREATE VIEW "bug_package" ( "bug", "pkg_id", "pkg_type", "package" ) AS
508 SELECT b.bug,b.bin_pkg,'binary',bp.pkg FROM bug_binpackage b JOIN bin_pkg bp ON bp.id=b.bin_pkg UNION
509 SELECT s.bug,s.src_pkg,'source',sp.pkg FROM bug_srcpackage s JOIN src_pkg sp ON sp.id=s.src_pkg;
515 -- Foreign Key Definitions
519 ALTER TABLE "src_pkg" ADD CONSTRAINT "src_pkg_fk_alias_of" FOREIGN KEY ("alias_of")
520 REFERENCES "src_pkg" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
523 ALTER TABLE "correspondent_full_name" ADD CONSTRAINT "correspondent_full_name_fk_correspondent" FOREIGN KEY ("correspondent")
524 REFERENCES "correspondent" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
527 ALTER TABLE "maintainer" ADD CONSTRAINT "maintainer_fk_correspondent" FOREIGN KEY ("correspondent")
528 REFERENCES "correspondent" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
531 ALTER TABLE "message_refs" ADD CONSTRAINT "message_refs_fk_message" FOREIGN KEY ("message")
532 REFERENCES "message" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
535 ALTER TABLE "message_refs" ADD CONSTRAINT "message_refs_fk_refs" FOREIGN KEY ("refs")
536 REFERENCES "message" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
539 ALTER TABLE "user_tag" ADD CONSTRAINT "user_tag_fk_correspondent" FOREIGN KEY ("correspondent")
540 REFERENCES "correspondent" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
543 ALTER TABLE "bug" ADD CONSTRAINT "bug_fk_done" FOREIGN KEY ("done")
544 REFERENCES "correspondent" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
547 ALTER TABLE "bug" ADD CONSTRAINT "bug_fk_owner" FOREIGN KEY ("owner")
548 REFERENCES "correspondent" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
551 ALTER TABLE "bug" ADD CONSTRAINT "bug_fk_severity" FOREIGN KEY ("severity")
552 REFERENCES "severity" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
555 ALTER TABLE "bug" ADD CONSTRAINT "bug_fk_submitter" FOREIGN KEY ("submitter")
556 REFERENCES "correspondent" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
559 ALTER TABLE "message_correspondent" ADD CONSTRAINT "message_correspondent_fk_correspondent" FOREIGN KEY ("correspondent")
560 REFERENCES "correspondent" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
563 ALTER TABLE "message_correspondent" ADD CONSTRAINT "message_correspondent_fk_message" FOREIGN KEY ("message")
564 REFERENCES "message" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
567 ALTER TABLE "bug_blocks" ADD CONSTRAINT "bug_blocks_fk_blocks" FOREIGN KEY ("blocks")
568 REFERENCES "bug" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
571 ALTER TABLE "bug_blocks" ADD CONSTRAINT "bug_blocks_fk_bug" FOREIGN KEY ("bug")
572 REFERENCES "bug" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
575 ALTER TABLE "bug_merged" ADD CONSTRAINT "bug_merged_fk_bug" FOREIGN KEY ("bug")
576 REFERENCES "bug" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
579 ALTER TABLE "bug_merged" ADD CONSTRAINT "bug_merged_fk_merged" FOREIGN KEY ("merged")
580 REFERENCES "bug" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
583 ALTER TABLE "src_ver" ADD CONSTRAINT "src_ver_fk_based_on" FOREIGN KEY ("based_on")
584 REFERENCES "src_ver" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
587 ALTER TABLE "src_ver" ADD CONSTRAINT "src_ver_fk_maintainer" FOREIGN KEY ("maintainer")
588 REFERENCES "maintainer" ("id") ON DELETE SET NULL ON UPDATE CASCADE;
591 ALTER TABLE "src_ver" ADD CONSTRAINT "src_ver_fk_src_pkg" FOREIGN KEY ("src_pkg")
592 REFERENCES "src_pkg" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
595 ALTER TABLE "bug_affects_binpackage" ADD CONSTRAINT "bug_affects_binpackage_fk_bin_pkg" FOREIGN KEY ("bin_pkg")
596 REFERENCES "bin_pkg" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
599 ALTER TABLE "bug_affects_binpackage" ADD CONSTRAINT "bug_affects_binpackage_fk_bug" FOREIGN KEY ("bug")
600 REFERENCES "bug" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
603 ALTER TABLE "bug_affects_srcpackage" ADD CONSTRAINT "bug_affects_srcpackage_fk_bug" FOREIGN KEY ("bug")
604 REFERENCES "bug" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
607 ALTER TABLE "bug_affects_srcpackage" ADD CONSTRAINT "bug_affects_srcpackage_fk_src_pkg" FOREIGN KEY ("src_pkg")
608 REFERENCES "src_pkg" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
611 ALTER TABLE "bug_binpackage" ADD CONSTRAINT "bug_binpackage_fk_bin_pkg" FOREIGN KEY ("bin_pkg")
612 REFERENCES "bin_pkg" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
615 ALTER TABLE "bug_binpackage" ADD CONSTRAINT "bug_binpackage_fk_bug" FOREIGN KEY ("bug")
616 REFERENCES "bug" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
619 ALTER TABLE "bug_message" ADD CONSTRAINT "bug_message_fk_bug" FOREIGN KEY ("bug")
620 REFERENCES "bug" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
623 ALTER TABLE "bug_message" ADD CONSTRAINT "bug_message_fk_message" FOREIGN KEY ("message")
624 REFERENCES "message" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
627 ALTER TABLE "bug_srcpackage" ADD CONSTRAINT "bug_srcpackage_fk_bug" FOREIGN KEY ("bug")
628 REFERENCES "bug" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
631 ALTER TABLE "bug_srcpackage" ADD CONSTRAINT "bug_srcpackage_fk_src_pkg" FOREIGN KEY ("src_pkg")
632 REFERENCES "src_pkg" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
635 ALTER TABLE "bug_tag" ADD CONSTRAINT "bug_tag_fk_bug" FOREIGN KEY ("bug")
636 REFERENCES "bug" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
639 ALTER TABLE "bug_tag" ADD CONSTRAINT "bug_tag_fk_tag" FOREIGN KEY ("tag")
640 REFERENCES "tag" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
643 ALTER TABLE "bug_user_tag" ADD CONSTRAINT "bug_user_tag_fk_bug" FOREIGN KEY ("bug")
644 REFERENCES "bug" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
647 ALTER TABLE "bug_user_tag" ADD CONSTRAINT "bug_user_tag_fk_user_tag" FOREIGN KEY ("user_tag")
648 REFERENCES "user_tag" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
651 ALTER TABLE "bug_status_cache" ADD CONSTRAINT "bug_status_cache_fk_arch" FOREIGN KEY ("arch")
652 REFERENCES "arch" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
655 ALTER TABLE "bug_status_cache" ADD CONSTRAINT "bug_status_cache_fk_bug" FOREIGN KEY ("bug")
656 REFERENCES "bug" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
659 ALTER TABLE "bug_status_cache" ADD CONSTRAINT "bug_status_cache_fk_suite" FOREIGN KEY ("suite")
660 REFERENCES "suite" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
663 ALTER TABLE "src_associations" ADD CONSTRAINT "src_associations_fk_source" FOREIGN KEY ("source")
664 REFERENCES "src_ver" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
667 ALTER TABLE "src_associations" ADD CONSTRAINT "src_associations_fk_suite" FOREIGN KEY ("suite")
668 REFERENCES "suite" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
671 ALTER TABLE "bin_ver" ADD CONSTRAINT "bin_ver_fk_arch" FOREIGN KEY ("arch")
672 REFERENCES "arch" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
675 ALTER TABLE "bin_ver" ADD CONSTRAINT "bin_ver_fk_bin_pkg" FOREIGN KEY ("bin_pkg")
676 REFERENCES "bin_pkg" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
679 ALTER TABLE "bin_ver" ADD CONSTRAINT "bin_ver_fk_src_ver" FOREIGN KEY ("src_ver")
680 REFERENCES "src_ver" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
683 ALTER TABLE "bug_ver" ADD CONSTRAINT "bug_ver_fk_bug" FOREIGN KEY ("bug")
684 REFERENCES "bug" ("id") ON DELETE RESTRICT ON UPDATE CASCADE;
687 ALTER TABLE "bug_ver" ADD CONSTRAINT "bug_ver_fk_src_pkg" FOREIGN KEY ("src_pkg")
688 REFERENCES "src_pkg" ("id") ON DELETE SET NULL ON UPDATE CASCADE;
691 ALTER TABLE "bug_ver" ADD CONSTRAINT "bug_ver_fk_src_ver" FOREIGN KEY ("src_ver")
692 REFERENCES "src_ver" ("id") ON DELETE SET NULL ON UPDATE CASCADE;
695 ALTER TABLE "bin_associations" ADD CONSTRAINT "bin_associations_fk_bin" FOREIGN KEY ("bin")
696 REFERENCES "bin_ver" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
699 ALTER TABLE "bin_associations" ADD CONSTRAINT "bin_associations_fk_suite" FOREIGN KEY ("suite")
700 REFERENCES "suite" ("id") ON DELETE CASCADE ON UPDATE CASCADE;