1-- ---------------------------------------------------------- 2-- driver: postgresql 3-- ---------------------------------------------------------- 4SET standard_conforming_strings TO ON; 5DO $$ 6BEGIN 7IF NOT EXISTS ( 8 SELECT 1 9 FROM pg_constraint 10 WHERE LOWER(conname) = LOWER('FK_acl_create_by_id') 11 ) THEN 12 ALTER TABLE acl ADD CONSTRAINT FK_acl_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 13END IF; 14END$$; 15; 16DO $$ 17BEGIN 18IF NOT EXISTS ( 19 SELECT 1 20 FROM pg_constraint 21 WHERE LOWER(conname) = LOWER('FK_acl_change_by_id') 22 ) THEN 23 ALTER TABLE acl ADD CONSTRAINT FK_acl_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 24END IF; 25END$$; 26; 27DO $$ 28BEGIN 29IF NOT EXISTS ( 30 SELECT 1 31 FROM pg_constraint 32 WHERE LOWER(conname) = LOWER('FK_acl_valid_id_id') 33 ) THEN 34 ALTER TABLE acl ADD CONSTRAINT FK_acl_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 35END IF; 36END$$; 37; 38DO $$ 39BEGIN 40IF NOT EXISTS ( 41 SELECT 1 42 FROM pg_constraint 43 WHERE LOWER(conname) = LOWER('FK_valid_create_by_id') 44 ) THEN 45 ALTER TABLE valid ADD CONSTRAINT FK_valid_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 46END IF; 47END$$; 48; 49DO $$ 50BEGIN 51IF NOT EXISTS ( 52 SELECT 1 53 FROM pg_constraint 54 WHERE LOWER(conname) = LOWER('FK_valid_change_by_id') 55 ) THEN 56 ALTER TABLE valid ADD CONSTRAINT FK_valid_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 57END IF; 58END$$; 59; 60DO $$ 61BEGIN 62IF NOT EXISTS ( 63 SELECT 1 64 FROM pg_constraint 65 WHERE LOWER(conname) = LOWER('FK_users_create_by_id') 66 ) THEN 67 ALTER TABLE users ADD CONSTRAINT FK_users_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 68END IF; 69END$$; 70; 71DO $$ 72BEGIN 73IF NOT EXISTS ( 74 SELECT 1 75 FROM pg_constraint 76 WHERE LOWER(conname) = LOWER('FK_users_change_by_id') 77 ) THEN 78 ALTER TABLE users ADD CONSTRAINT FK_users_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 79END IF; 80END$$; 81; 82DO $$ 83BEGIN 84IF NOT EXISTS ( 85 SELECT 1 86 FROM pg_constraint 87 WHERE LOWER(conname) = LOWER('FK_users_valid_id_id') 88 ) THEN 89 ALTER TABLE users ADD CONSTRAINT FK_users_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 90END IF; 91END$$; 92; 93DO $$ 94BEGIN 95IF NOT EXISTS ( 96 SELECT 1 97 FROM pg_constraint 98 WHERE LOWER(conname) = LOWER('FK_user_preferences_user_id_id') 99 ) THEN 100 ALTER TABLE user_preferences ADD CONSTRAINT FK_user_preferences_user_id_id FOREIGN KEY (user_id) REFERENCES users (id); 101END IF; 102END$$; 103; 104DO $$ 105BEGIN 106IF NOT EXISTS ( 107 SELECT 1 108 FROM pg_constraint 109 WHERE LOWER(conname) = LOWER('FK_groups_create_by_id') 110 ) THEN 111 ALTER TABLE groups ADD CONSTRAINT FK_groups_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 112END IF; 113END$$; 114; 115DO $$ 116BEGIN 117IF NOT EXISTS ( 118 SELECT 1 119 FROM pg_constraint 120 WHERE LOWER(conname) = LOWER('FK_groups_change_by_id') 121 ) THEN 122 ALTER TABLE groups ADD CONSTRAINT FK_groups_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 123END IF; 124END$$; 125; 126DO $$ 127BEGIN 128IF NOT EXISTS ( 129 SELECT 1 130 FROM pg_constraint 131 WHERE LOWER(conname) = LOWER('FK_groups_valid_id_id') 132 ) THEN 133 ALTER TABLE groups ADD CONSTRAINT FK_groups_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 134END IF; 135END$$; 136; 137DO $$ 138BEGIN 139IF NOT EXISTS ( 140 SELECT 1 141 FROM pg_constraint 142 WHERE LOWER(conname) = LOWER('FK_group_user_group_id_id') 143 ) THEN 144 ALTER TABLE group_user ADD CONSTRAINT FK_group_user_group_id_id FOREIGN KEY (group_id) REFERENCES groups (id); 145END IF; 146END$$; 147; 148DO $$ 149BEGIN 150IF NOT EXISTS ( 151 SELECT 1 152 FROM pg_constraint 153 WHERE LOWER(conname) = LOWER('FK_group_user_create_by_id') 154 ) THEN 155 ALTER TABLE group_user ADD CONSTRAINT FK_group_user_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 156END IF; 157END$$; 158; 159DO $$ 160BEGIN 161IF NOT EXISTS ( 162 SELECT 1 163 FROM pg_constraint 164 WHERE LOWER(conname) = LOWER('FK_group_user_change_by_id') 165 ) THEN 166 ALTER TABLE group_user ADD CONSTRAINT FK_group_user_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 167END IF; 168END$$; 169; 170DO $$ 171BEGIN 172IF NOT EXISTS ( 173 SELECT 1 174 FROM pg_constraint 175 WHERE LOWER(conname) = LOWER('FK_group_user_user_id_id') 176 ) THEN 177 ALTER TABLE group_user ADD CONSTRAINT FK_group_user_user_id_id FOREIGN KEY (user_id) REFERENCES users (id); 178END IF; 179END$$; 180; 181DO $$ 182BEGIN 183IF NOT EXISTS ( 184 SELECT 1 185 FROM pg_constraint 186 WHERE LOWER(conname) = LOWER('FK_group_role_group_id_id') 187 ) THEN 188 ALTER TABLE group_role ADD CONSTRAINT FK_group_role_group_id_id FOREIGN KEY (group_id) REFERENCES groups (id); 189END IF; 190END$$; 191; 192DO $$ 193BEGIN 194IF NOT EXISTS ( 195 SELECT 1 196 FROM pg_constraint 197 WHERE LOWER(conname) = LOWER('FK_group_role_role_id_id') 198 ) THEN 199 ALTER TABLE group_role ADD CONSTRAINT FK_group_role_role_id_id FOREIGN KEY (role_id) REFERENCES roles (id); 200END IF; 201END$$; 202; 203DO $$ 204BEGIN 205IF NOT EXISTS ( 206 SELECT 1 207 FROM pg_constraint 208 WHERE LOWER(conname) = LOWER('FK_group_role_create_by_id') 209 ) THEN 210 ALTER TABLE group_role ADD CONSTRAINT FK_group_role_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 211END IF; 212END$$; 213; 214DO $$ 215BEGIN 216IF NOT EXISTS ( 217 SELECT 1 218 FROM pg_constraint 219 WHERE LOWER(conname) = LOWER('FK_group_role_change_by_id') 220 ) THEN 221 ALTER TABLE group_role ADD CONSTRAINT FK_group_role_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 222END IF; 223END$$; 224; 225DO $$ 226BEGIN 227IF NOT EXISTS ( 228 SELECT 1 229 FROM pg_constraint 230 WHERE LOWER(conname) = LOWER('FK_group_customer_user_group_id_id') 231 ) THEN 232 ALTER TABLE group_customer_user ADD CONSTRAINT FK_group_customer_user_group_id_id FOREIGN KEY (group_id) REFERENCES groups (id); 233END IF; 234END$$; 235; 236DO $$ 237BEGIN 238IF NOT EXISTS ( 239 SELECT 1 240 FROM pg_constraint 241 WHERE LOWER(conname) = LOWER('FK_group_customer_user_create_by_id') 242 ) THEN 243 ALTER TABLE group_customer_user ADD CONSTRAINT FK_group_customer_user_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 244END IF; 245END$$; 246; 247DO $$ 248BEGIN 249IF NOT EXISTS ( 250 SELECT 1 251 FROM pg_constraint 252 WHERE LOWER(conname) = LOWER('FK_group_customer_user_change_by_id') 253 ) THEN 254 ALTER TABLE group_customer_user ADD CONSTRAINT FK_group_customer_user_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 255END IF; 256END$$; 257; 258DO $$ 259BEGIN 260IF NOT EXISTS ( 261 SELECT 1 262 FROM pg_constraint 263 WHERE LOWER(conname) = LOWER('FK_group_customer_group_id_id') 264 ) THEN 265 ALTER TABLE group_customer ADD CONSTRAINT FK_group_customer_group_id_id FOREIGN KEY (group_id) REFERENCES groups (id); 266END IF; 267END$$; 268; 269DO $$ 270BEGIN 271IF NOT EXISTS ( 272 SELECT 1 273 FROM pg_constraint 274 WHERE LOWER(conname) = LOWER('FK_group_customer_create_by_id') 275 ) THEN 276 ALTER TABLE group_customer ADD CONSTRAINT FK_group_customer_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 277END IF; 278END$$; 279; 280DO $$ 281BEGIN 282IF NOT EXISTS ( 283 SELECT 1 284 FROM pg_constraint 285 WHERE LOWER(conname) = LOWER('FK_group_customer_change_by_id') 286 ) THEN 287 ALTER TABLE group_customer ADD CONSTRAINT FK_group_customer_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 288END IF; 289END$$; 290; 291DO $$ 292BEGIN 293IF NOT EXISTS ( 294 SELECT 1 295 FROM pg_constraint 296 WHERE LOWER(conname) = LOWER('FK_roles_create_by_id') 297 ) THEN 298 ALTER TABLE roles ADD CONSTRAINT FK_roles_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 299END IF; 300END$$; 301; 302DO $$ 303BEGIN 304IF NOT EXISTS ( 305 SELECT 1 306 FROM pg_constraint 307 WHERE LOWER(conname) = LOWER('FK_roles_change_by_id') 308 ) THEN 309 ALTER TABLE roles ADD CONSTRAINT FK_roles_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 310END IF; 311END$$; 312; 313DO $$ 314BEGIN 315IF NOT EXISTS ( 316 SELECT 1 317 FROM pg_constraint 318 WHERE LOWER(conname) = LOWER('FK_roles_valid_id_id') 319 ) THEN 320 ALTER TABLE roles ADD CONSTRAINT FK_roles_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 321END IF; 322END$$; 323; 324DO $$ 325BEGIN 326IF NOT EXISTS ( 327 SELECT 1 328 FROM pg_constraint 329 WHERE LOWER(conname) = LOWER('FK_role_user_create_by_id') 330 ) THEN 331 ALTER TABLE role_user ADD CONSTRAINT FK_role_user_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 332END IF; 333END$$; 334; 335DO $$ 336BEGIN 337IF NOT EXISTS ( 338 SELECT 1 339 FROM pg_constraint 340 WHERE LOWER(conname) = LOWER('FK_role_user_change_by_id') 341 ) THEN 342 ALTER TABLE role_user ADD CONSTRAINT FK_role_user_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 343END IF; 344END$$; 345; 346DO $$ 347BEGIN 348IF NOT EXISTS ( 349 SELECT 1 350 FROM pg_constraint 351 WHERE LOWER(conname) = LOWER('FK_role_user_user_id_id') 352 ) THEN 353 ALTER TABLE role_user ADD CONSTRAINT FK_role_user_user_id_id FOREIGN KEY (user_id) REFERENCES users (id); 354END IF; 355END$$; 356; 357DO $$ 358BEGIN 359IF NOT EXISTS ( 360 SELECT 1 361 FROM pg_constraint 362 WHERE LOWER(conname) = LOWER('FK_personal_queues_queue_id_id') 363 ) THEN 364 ALTER TABLE personal_queues ADD CONSTRAINT FK_personal_queues_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue (id); 365END IF; 366END$$; 367; 368DO $$ 369BEGIN 370IF NOT EXISTS ( 371 SELECT 1 372 FROM pg_constraint 373 WHERE LOWER(conname) = LOWER('FK_personal_queues_user_id_id') 374 ) THEN 375 ALTER TABLE personal_queues ADD CONSTRAINT FK_personal_queues_user_id_id FOREIGN KEY (user_id) REFERENCES users (id); 376END IF; 377END$$; 378; 379DO $$ 380BEGIN 381IF NOT EXISTS ( 382 SELECT 1 383 FROM pg_constraint 384 WHERE LOWER(conname) = LOWER('FK_personal_services_service_id_id') 385 ) THEN 386 ALTER TABLE personal_services ADD CONSTRAINT FK_personal_services_service_id_id FOREIGN KEY (service_id) REFERENCES service (id); 387END IF; 388END$$; 389; 390DO $$ 391BEGIN 392IF NOT EXISTS ( 393 SELECT 1 394 FROM pg_constraint 395 WHERE LOWER(conname) = LOWER('FK_personal_services_user_id_id') 396 ) THEN 397 ALTER TABLE personal_services ADD CONSTRAINT FK_personal_services_user_id_id FOREIGN KEY (user_id) REFERENCES users (id); 398END IF; 399END$$; 400; 401DO $$ 402BEGIN 403IF NOT EXISTS ( 404 SELECT 1 405 FROM pg_constraint 406 WHERE LOWER(conname) = LOWER('FK_salutation_create_by_id') 407 ) THEN 408 ALTER TABLE salutation ADD CONSTRAINT FK_salutation_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 409END IF; 410END$$; 411; 412DO $$ 413BEGIN 414IF NOT EXISTS ( 415 SELECT 1 416 FROM pg_constraint 417 WHERE LOWER(conname) = LOWER('FK_salutation_change_by_id') 418 ) THEN 419 ALTER TABLE salutation ADD CONSTRAINT FK_salutation_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 420END IF; 421END$$; 422; 423DO $$ 424BEGIN 425IF NOT EXISTS ( 426 SELECT 1 427 FROM pg_constraint 428 WHERE LOWER(conname) = LOWER('FK_salutation_valid_id_id') 429 ) THEN 430 ALTER TABLE salutation ADD CONSTRAINT FK_salutation_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 431END IF; 432END$$; 433; 434DO $$ 435BEGIN 436IF NOT EXISTS ( 437 SELECT 1 438 FROM pg_constraint 439 WHERE LOWER(conname) = LOWER('FK_signature_create_by_id') 440 ) THEN 441 ALTER TABLE signature ADD CONSTRAINT FK_signature_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 442END IF; 443END$$; 444; 445DO $$ 446BEGIN 447IF NOT EXISTS ( 448 SELECT 1 449 FROM pg_constraint 450 WHERE LOWER(conname) = LOWER('FK_signature_change_by_id') 451 ) THEN 452 ALTER TABLE signature ADD CONSTRAINT FK_signature_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 453END IF; 454END$$; 455; 456DO $$ 457BEGIN 458IF NOT EXISTS ( 459 SELECT 1 460 FROM pg_constraint 461 WHERE LOWER(conname) = LOWER('FK_signature_valid_id_id') 462 ) THEN 463 ALTER TABLE signature ADD CONSTRAINT FK_signature_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 464END IF; 465END$$; 466; 467DO $$ 468BEGIN 469IF NOT EXISTS ( 470 SELECT 1 471 FROM pg_constraint 472 WHERE LOWER(conname) = LOWER('FK_system_address_create_by_id') 473 ) THEN 474 ALTER TABLE system_address ADD CONSTRAINT FK_system_address_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 475END IF; 476END$$; 477; 478DO $$ 479BEGIN 480IF NOT EXISTS ( 481 SELECT 1 482 FROM pg_constraint 483 WHERE LOWER(conname) = LOWER('FK_system_address_change_by_id') 484 ) THEN 485 ALTER TABLE system_address ADD CONSTRAINT FK_system_address_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 486END IF; 487END$$; 488; 489DO $$ 490BEGIN 491IF NOT EXISTS ( 492 SELECT 1 493 FROM pg_constraint 494 WHERE LOWER(conname) = LOWER('FK_system_address_valid_id_id') 495 ) THEN 496 ALTER TABLE system_address ADD CONSTRAINT FK_system_address_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 497END IF; 498END$$; 499; 500DO $$ 501BEGIN 502IF NOT EXISTS ( 503 SELECT 1 504 FROM pg_constraint 505 WHERE LOWER(conname) = LOWER('FK_system_maintenance_create_by_id') 506 ) THEN 507 ALTER TABLE system_maintenance ADD CONSTRAINT FK_system_maintenance_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 508END IF; 509END$$; 510; 511DO $$ 512BEGIN 513IF NOT EXISTS ( 514 SELECT 1 515 FROM pg_constraint 516 WHERE LOWER(conname) = LOWER('FK_system_maintenance_change_by_id') 517 ) THEN 518 ALTER TABLE system_maintenance ADD CONSTRAINT FK_system_maintenance_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 519END IF; 520END$$; 521; 522DO $$ 523BEGIN 524IF NOT EXISTS ( 525 SELECT 1 526 FROM pg_constraint 527 WHERE LOWER(conname) = LOWER('FK_system_maintenance_valid_id_id') 528 ) THEN 529 ALTER TABLE system_maintenance ADD CONSTRAINT FK_system_maintenance_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 530END IF; 531END$$; 532; 533DO $$ 534BEGIN 535IF NOT EXISTS ( 536 SELECT 1 537 FROM pg_constraint 538 WHERE LOWER(conname) = LOWER('FK_follow_up_possible_create_by_id') 539 ) THEN 540 ALTER TABLE follow_up_possible ADD CONSTRAINT FK_follow_up_possible_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 541END IF; 542END$$; 543; 544DO $$ 545BEGIN 546IF NOT EXISTS ( 547 SELECT 1 548 FROM pg_constraint 549 WHERE LOWER(conname) = LOWER('FK_follow_up_possible_change_by_id') 550 ) THEN 551 ALTER TABLE follow_up_possible ADD CONSTRAINT FK_follow_up_possible_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 552END IF; 553END$$; 554; 555DO $$ 556BEGIN 557IF NOT EXISTS ( 558 SELECT 1 559 FROM pg_constraint 560 WHERE LOWER(conname) = LOWER('FK_follow_up_possible_valid_id_id') 561 ) THEN 562 ALTER TABLE follow_up_possible ADD CONSTRAINT FK_follow_up_possible_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 563END IF; 564END$$; 565; 566DO $$ 567BEGIN 568IF NOT EXISTS ( 569 SELECT 1 570 FROM pg_constraint 571 WHERE LOWER(conname) = LOWER('FK_queue_follow_up_id_id') 572 ) THEN 573 ALTER TABLE queue ADD CONSTRAINT FK_queue_follow_up_id_id FOREIGN KEY (follow_up_id) REFERENCES follow_up_possible (id); 574END IF; 575END$$; 576; 577DO $$ 578BEGIN 579IF NOT EXISTS ( 580 SELECT 1 581 FROM pg_constraint 582 WHERE LOWER(conname) = LOWER('FK_queue_group_id_id') 583 ) THEN 584 ALTER TABLE queue ADD CONSTRAINT FK_queue_group_id_id FOREIGN KEY (group_id) REFERENCES groups (id); 585END IF; 586END$$; 587; 588DO $$ 589BEGIN 590IF NOT EXISTS ( 591 SELECT 1 592 FROM pg_constraint 593 WHERE LOWER(conname) = LOWER('FK_queue_salutation_id_id') 594 ) THEN 595 ALTER TABLE queue ADD CONSTRAINT FK_queue_salutation_id_id FOREIGN KEY (salutation_id) REFERENCES salutation (id); 596END IF; 597END$$; 598; 599DO $$ 600BEGIN 601IF NOT EXISTS ( 602 SELECT 1 603 FROM pg_constraint 604 WHERE LOWER(conname) = LOWER('FK_queue_signature_id_id') 605 ) THEN 606 ALTER TABLE queue ADD CONSTRAINT FK_queue_signature_id_id FOREIGN KEY (signature_id) REFERENCES signature (id); 607END IF; 608END$$; 609; 610DO $$ 611BEGIN 612IF NOT EXISTS ( 613 SELECT 1 614 FROM pg_constraint 615 WHERE LOWER(conname) = LOWER('FK_queue_system_address_id_id') 616 ) THEN 617 ALTER TABLE queue ADD CONSTRAINT FK_queue_system_address_id_id FOREIGN KEY (system_address_id) REFERENCES system_address (id); 618END IF; 619END$$; 620; 621DO $$ 622BEGIN 623IF NOT EXISTS ( 624 SELECT 1 625 FROM pg_constraint 626 WHERE LOWER(conname) = LOWER('FK_queue_create_by_id') 627 ) THEN 628 ALTER TABLE queue ADD CONSTRAINT FK_queue_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 629END IF; 630END$$; 631; 632DO $$ 633BEGIN 634IF NOT EXISTS ( 635 SELECT 1 636 FROM pg_constraint 637 WHERE LOWER(conname) = LOWER('FK_queue_change_by_id') 638 ) THEN 639 ALTER TABLE queue ADD CONSTRAINT FK_queue_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 640END IF; 641END$$; 642; 643DO $$ 644BEGIN 645IF NOT EXISTS ( 646 SELECT 1 647 FROM pg_constraint 648 WHERE LOWER(conname) = LOWER('FK_queue_valid_id_id') 649 ) THEN 650 ALTER TABLE queue ADD CONSTRAINT FK_queue_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 651END IF; 652END$$; 653; 654DO $$ 655BEGIN 656IF NOT EXISTS ( 657 SELECT 1 658 FROM pg_constraint 659 WHERE LOWER(conname) = LOWER('FK_queue_preferences_queue_id_id') 660 ) THEN 661 ALTER TABLE queue_preferences ADD CONSTRAINT FK_queue_preferences_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue (id); 662END IF; 663END$$; 664; 665DO $$ 666BEGIN 667IF NOT EXISTS ( 668 SELECT 1 669 FROM pg_constraint 670 WHERE LOWER(conname) = LOWER('FK_ticket_priority_create_by_id') 671 ) THEN 672 ALTER TABLE ticket_priority ADD CONSTRAINT FK_ticket_priority_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 673END IF; 674END$$; 675; 676DO $$ 677BEGIN 678IF NOT EXISTS ( 679 SELECT 1 680 FROM pg_constraint 681 WHERE LOWER(conname) = LOWER('FK_ticket_priority_change_by_id') 682 ) THEN 683 ALTER TABLE ticket_priority ADD CONSTRAINT FK_ticket_priority_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 684END IF; 685END$$; 686; 687DO $$ 688BEGIN 689IF NOT EXISTS ( 690 SELECT 1 691 FROM pg_constraint 692 WHERE LOWER(conname) = LOWER('FK_ticket_type_create_by_id') 693 ) THEN 694 ALTER TABLE ticket_type ADD CONSTRAINT FK_ticket_type_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 695END IF; 696END$$; 697; 698DO $$ 699BEGIN 700IF NOT EXISTS ( 701 SELECT 1 702 FROM pg_constraint 703 WHERE LOWER(conname) = LOWER('FK_ticket_type_change_by_id') 704 ) THEN 705 ALTER TABLE ticket_type ADD CONSTRAINT FK_ticket_type_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 706END IF; 707END$$; 708; 709DO $$ 710BEGIN 711IF NOT EXISTS ( 712 SELECT 1 713 FROM pg_constraint 714 WHERE LOWER(conname) = LOWER('FK_ticket_type_valid_id_id') 715 ) THEN 716 ALTER TABLE ticket_type ADD CONSTRAINT FK_ticket_type_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 717END IF; 718END$$; 719; 720DO $$ 721BEGIN 722IF NOT EXISTS ( 723 SELECT 1 724 FROM pg_constraint 725 WHERE LOWER(conname) = LOWER('FK_ticket_lock_type_create_by_id') 726 ) THEN 727 ALTER TABLE ticket_lock_type ADD CONSTRAINT FK_ticket_lock_type_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 728END IF; 729END$$; 730; 731DO $$ 732BEGIN 733IF NOT EXISTS ( 734 SELECT 1 735 FROM pg_constraint 736 WHERE LOWER(conname) = LOWER('FK_ticket_lock_type_change_by_id') 737 ) THEN 738 ALTER TABLE ticket_lock_type ADD CONSTRAINT FK_ticket_lock_type_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 739END IF; 740END$$; 741; 742DO $$ 743BEGIN 744IF NOT EXISTS ( 745 SELECT 1 746 FROM pg_constraint 747 WHERE LOWER(conname) = LOWER('FK_ticket_lock_type_valid_id_id') 748 ) THEN 749 ALTER TABLE ticket_lock_type ADD CONSTRAINT FK_ticket_lock_type_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 750END IF; 751END$$; 752; 753DO $$ 754BEGIN 755IF NOT EXISTS ( 756 SELECT 1 757 FROM pg_constraint 758 WHERE LOWER(conname) = LOWER('FK_ticket_state_type_id_id') 759 ) THEN 760 ALTER TABLE ticket_state ADD CONSTRAINT FK_ticket_state_type_id_id FOREIGN KEY (type_id) REFERENCES ticket_state_type (id); 761END IF; 762END$$; 763; 764DO $$ 765BEGIN 766IF NOT EXISTS ( 767 SELECT 1 768 FROM pg_constraint 769 WHERE LOWER(conname) = LOWER('FK_ticket_state_create_by_id') 770 ) THEN 771 ALTER TABLE ticket_state ADD CONSTRAINT FK_ticket_state_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 772END IF; 773END$$; 774; 775DO $$ 776BEGIN 777IF NOT EXISTS ( 778 SELECT 1 779 FROM pg_constraint 780 WHERE LOWER(conname) = LOWER('FK_ticket_state_change_by_id') 781 ) THEN 782 ALTER TABLE ticket_state ADD CONSTRAINT FK_ticket_state_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 783END IF; 784END$$; 785; 786DO $$ 787BEGIN 788IF NOT EXISTS ( 789 SELECT 1 790 FROM pg_constraint 791 WHERE LOWER(conname) = LOWER('FK_ticket_state_valid_id_id') 792 ) THEN 793 ALTER TABLE ticket_state ADD CONSTRAINT FK_ticket_state_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 794END IF; 795END$$; 796; 797DO $$ 798BEGIN 799IF NOT EXISTS ( 800 SELECT 1 801 FROM pg_constraint 802 WHERE LOWER(conname) = LOWER('FK_ticket_state_type_create_by_id') 803 ) THEN 804 ALTER TABLE ticket_state_type ADD CONSTRAINT FK_ticket_state_type_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 805END IF; 806END$$; 807; 808DO $$ 809BEGIN 810IF NOT EXISTS ( 811 SELECT 1 812 FROM pg_constraint 813 WHERE LOWER(conname) = LOWER('FK_ticket_state_type_change_by_id') 814 ) THEN 815 ALTER TABLE ticket_state_type ADD CONSTRAINT FK_ticket_state_type_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 816END IF; 817END$$; 818; 819DO $$ 820BEGIN 821IF NOT EXISTS ( 822 SELECT 1 823 FROM pg_constraint 824 WHERE LOWER(conname) = LOWER('FK_ticket_queue_id_id') 825 ) THEN 826 ALTER TABLE ticket ADD CONSTRAINT FK_ticket_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue (id); 827END IF; 828END$$; 829; 830DO $$ 831BEGIN 832IF NOT EXISTS ( 833 SELECT 1 834 FROM pg_constraint 835 WHERE LOWER(conname) = LOWER('FK_ticket_service_id_id') 836 ) THEN 837 ALTER TABLE ticket ADD CONSTRAINT FK_ticket_service_id_id FOREIGN KEY (service_id) REFERENCES service (id); 838END IF; 839END$$; 840; 841DO $$ 842BEGIN 843IF NOT EXISTS ( 844 SELECT 1 845 FROM pg_constraint 846 WHERE LOWER(conname) = LOWER('FK_ticket_sla_id_id') 847 ) THEN 848 ALTER TABLE ticket ADD CONSTRAINT FK_ticket_sla_id_id FOREIGN KEY (sla_id) REFERENCES sla (id); 849END IF; 850END$$; 851; 852DO $$ 853BEGIN 854IF NOT EXISTS ( 855 SELECT 1 856 FROM pg_constraint 857 WHERE LOWER(conname) = LOWER('FK_ticket_ticket_lock_id_id') 858 ) THEN 859 ALTER TABLE ticket ADD CONSTRAINT FK_ticket_ticket_lock_id_id FOREIGN KEY (ticket_lock_id) REFERENCES ticket_lock_type (id); 860END IF; 861END$$; 862; 863DO $$ 864BEGIN 865IF NOT EXISTS ( 866 SELECT 1 867 FROM pg_constraint 868 WHERE LOWER(conname) = LOWER('FK_ticket_ticket_priority_id_id') 869 ) THEN 870 ALTER TABLE ticket ADD CONSTRAINT FK_ticket_ticket_priority_id_id FOREIGN KEY (ticket_priority_id) REFERENCES ticket_priority (id); 871END IF; 872END$$; 873; 874DO $$ 875BEGIN 876IF NOT EXISTS ( 877 SELECT 1 878 FROM pg_constraint 879 WHERE LOWER(conname) = LOWER('FK_ticket_ticket_state_id_id') 880 ) THEN 881 ALTER TABLE ticket ADD CONSTRAINT FK_ticket_ticket_state_id_id FOREIGN KEY (ticket_state_id) REFERENCES ticket_state (id); 882END IF; 883END$$; 884; 885DO $$ 886BEGIN 887IF NOT EXISTS ( 888 SELECT 1 889 FROM pg_constraint 890 WHERE LOWER(conname) = LOWER('FK_ticket_type_id_id') 891 ) THEN 892 ALTER TABLE ticket ADD CONSTRAINT FK_ticket_type_id_id FOREIGN KEY (type_id) REFERENCES ticket_type (id); 893END IF; 894END$$; 895; 896DO $$ 897BEGIN 898IF NOT EXISTS ( 899 SELECT 1 900 FROM pg_constraint 901 WHERE LOWER(conname) = LOWER('FK_ticket_create_by_id') 902 ) THEN 903 ALTER TABLE ticket ADD CONSTRAINT FK_ticket_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 904END IF; 905END$$; 906; 907DO $$ 908BEGIN 909IF NOT EXISTS ( 910 SELECT 1 911 FROM pg_constraint 912 WHERE LOWER(conname) = LOWER('FK_ticket_change_by_id') 913 ) THEN 914 ALTER TABLE ticket ADD CONSTRAINT FK_ticket_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 915END IF; 916END$$; 917; 918DO $$ 919BEGIN 920IF NOT EXISTS ( 921 SELECT 1 922 FROM pg_constraint 923 WHERE LOWER(conname) = LOWER('FK_ticket_user_id_id') 924 ) THEN 925 ALTER TABLE ticket ADD CONSTRAINT FK_ticket_user_id_id FOREIGN KEY (user_id) REFERENCES users (id); 926END IF; 927END$$; 928; 929DO $$ 930BEGIN 931IF NOT EXISTS ( 932 SELECT 1 933 FROM pg_constraint 934 WHERE LOWER(conname) = LOWER('FK_ticket_responsible_user_id_id') 935 ) THEN 936 ALTER TABLE ticket ADD CONSTRAINT FK_ticket_responsible_user_id_id FOREIGN KEY (responsible_user_id) REFERENCES users (id); 937END IF; 938END$$; 939; 940DO $$ 941BEGIN 942IF NOT EXISTS ( 943 SELECT 1 944 FROM pg_constraint 945 WHERE LOWER(conname) = LOWER('FK_ticket_flag_ticket_id_id') 946 ) THEN 947 ALTER TABLE ticket_flag ADD CONSTRAINT FK_ticket_flag_ticket_id_id FOREIGN KEY (ticket_id) REFERENCES ticket (id); 948END IF; 949END$$; 950; 951DO $$ 952BEGIN 953IF NOT EXISTS ( 954 SELECT 1 955 FROM pg_constraint 956 WHERE LOWER(conname) = LOWER('FK_ticket_flag_create_by_id') 957 ) THEN 958 ALTER TABLE ticket_flag ADD CONSTRAINT FK_ticket_flag_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 959END IF; 960END$$; 961; 962DO $$ 963BEGIN 964IF NOT EXISTS ( 965 SELECT 1 966 FROM pg_constraint 967 WHERE LOWER(conname) = LOWER('FK_ticket_history_article_id_id') 968 ) THEN 969 ALTER TABLE ticket_history ADD CONSTRAINT FK_ticket_history_article_id_id FOREIGN KEY (article_id) REFERENCES article (id); 970END IF; 971END$$; 972; 973DO $$ 974BEGIN 975IF NOT EXISTS ( 976 SELECT 1 977 FROM pg_constraint 978 WHERE LOWER(conname) = LOWER('FK_ticket_history_queue_id_id') 979 ) THEN 980 ALTER TABLE ticket_history ADD CONSTRAINT FK_ticket_history_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue (id); 981END IF; 982END$$; 983; 984DO $$ 985BEGIN 986IF NOT EXISTS ( 987 SELECT 1 988 FROM pg_constraint 989 WHERE LOWER(conname) = LOWER('FK_ticket_history_ticket_id_id') 990 ) THEN 991 ALTER TABLE ticket_history ADD CONSTRAINT FK_ticket_history_ticket_id_id FOREIGN KEY (ticket_id) REFERENCES ticket (id); 992END IF; 993END$$; 994; 995DO $$ 996BEGIN 997IF NOT EXISTS ( 998 SELECT 1 999 FROM pg_constraint 1000 WHERE LOWER(conname) = LOWER('FK_ticket_history_history_type_id_id') 1001 ) THEN 1002 ALTER TABLE ticket_history ADD CONSTRAINT FK_ticket_history_history_type_id_id FOREIGN KEY (history_type_id) REFERENCES ticket_history_type (id); 1003END IF; 1004END$$; 1005; 1006DO $$ 1007BEGIN 1008IF NOT EXISTS ( 1009 SELECT 1 1010 FROM pg_constraint 1011 WHERE LOWER(conname) = LOWER('FK_ticket_history_priority_id_id') 1012 ) THEN 1013 ALTER TABLE ticket_history ADD CONSTRAINT FK_ticket_history_priority_id_id FOREIGN KEY (priority_id) REFERENCES ticket_priority (id); 1014END IF; 1015END$$; 1016; 1017DO $$ 1018BEGIN 1019IF NOT EXISTS ( 1020 SELECT 1 1021 FROM pg_constraint 1022 WHERE LOWER(conname) = LOWER('FK_ticket_history_state_id_id') 1023 ) THEN 1024 ALTER TABLE ticket_history ADD CONSTRAINT FK_ticket_history_state_id_id FOREIGN KEY (state_id) REFERENCES ticket_state (id); 1025END IF; 1026END$$; 1027; 1028DO $$ 1029BEGIN 1030IF NOT EXISTS ( 1031 SELECT 1 1032 FROM pg_constraint 1033 WHERE LOWER(conname) = LOWER('FK_ticket_history_type_id_id') 1034 ) THEN 1035 ALTER TABLE ticket_history ADD CONSTRAINT FK_ticket_history_type_id_id FOREIGN KEY (type_id) REFERENCES ticket_type (id); 1036END IF; 1037END$$; 1038; 1039DO $$ 1040BEGIN 1041IF NOT EXISTS ( 1042 SELECT 1 1043 FROM pg_constraint 1044 WHERE LOWER(conname) = LOWER('FK_ticket_history_owner_id_id') 1045 ) THEN 1046 ALTER TABLE ticket_history ADD CONSTRAINT FK_ticket_history_owner_id_id FOREIGN KEY (owner_id) REFERENCES users (id); 1047END IF; 1048END$$; 1049; 1050DO $$ 1051BEGIN 1052IF NOT EXISTS ( 1053 SELECT 1 1054 FROM pg_constraint 1055 WHERE LOWER(conname) = LOWER('FK_ticket_history_create_by_id') 1056 ) THEN 1057 ALTER TABLE ticket_history ADD CONSTRAINT FK_ticket_history_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1058END IF; 1059END$$; 1060; 1061DO $$ 1062BEGIN 1063IF NOT EXISTS ( 1064 SELECT 1 1065 FROM pg_constraint 1066 WHERE LOWER(conname) = LOWER('FK_ticket_history_change_by_id') 1067 ) THEN 1068 ALTER TABLE ticket_history ADD CONSTRAINT FK_ticket_history_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1069END IF; 1070END$$; 1071; 1072DO $$ 1073BEGIN 1074IF NOT EXISTS ( 1075 SELECT 1 1076 FROM pg_constraint 1077 WHERE LOWER(conname) = LOWER('FK_ticket_history_type_create_by_id') 1078 ) THEN 1079 ALTER TABLE ticket_history_type ADD CONSTRAINT FK_ticket_history_type_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1080END IF; 1081END$$; 1082; 1083DO $$ 1084BEGIN 1085IF NOT EXISTS ( 1086 SELECT 1 1087 FROM pg_constraint 1088 WHERE LOWER(conname) = LOWER('FK_ticket_history_type_change_by_id') 1089 ) THEN 1090 ALTER TABLE ticket_history_type ADD CONSTRAINT FK_ticket_history_type_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1091END IF; 1092END$$; 1093; 1094DO $$ 1095BEGIN 1096IF NOT EXISTS ( 1097 SELECT 1 1098 FROM pg_constraint 1099 WHERE LOWER(conname) = LOWER('FK_ticket_history_type_valid_id_id') 1100 ) THEN 1101 ALTER TABLE ticket_history_type ADD CONSTRAINT FK_ticket_history_type_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 1102END IF; 1103END$$; 1104; 1105DO $$ 1106BEGIN 1107IF NOT EXISTS ( 1108 SELECT 1 1109 FROM pg_constraint 1110 WHERE LOWER(conname) = LOWER('FK_ticket_watcher_ticket_id_id') 1111 ) THEN 1112 ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_ticket_id_id FOREIGN KEY (ticket_id) REFERENCES ticket (id); 1113END IF; 1114END$$; 1115; 1116DO $$ 1117BEGIN 1118IF NOT EXISTS ( 1119 SELECT 1 1120 FROM pg_constraint 1121 WHERE LOWER(conname) = LOWER('FK_ticket_watcher_user_id_id') 1122 ) THEN 1123 ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_user_id_id FOREIGN KEY (user_id) REFERENCES users (id); 1124END IF; 1125END$$; 1126; 1127DO $$ 1128BEGIN 1129IF NOT EXISTS ( 1130 SELECT 1 1131 FROM pg_constraint 1132 WHERE LOWER(conname) = LOWER('FK_ticket_watcher_create_by_id') 1133 ) THEN 1134 ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1135END IF; 1136END$$; 1137; 1138DO $$ 1139BEGIN 1140IF NOT EXISTS ( 1141 SELECT 1 1142 FROM pg_constraint 1143 WHERE LOWER(conname) = LOWER('FK_ticket_watcher_change_by_id') 1144 ) THEN 1145 ALTER TABLE ticket_watcher ADD CONSTRAINT FK_ticket_watcher_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1146END IF; 1147END$$; 1148; 1149DO $$ 1150BEGIN 1151IF NOT EXISTS ( 1152 SELECT 1 1153 FROM pg_constraint 1154 WHERE LOWER(conname) = LOWER('FK_ticket_index_group_id_id') 1155 ) THEN 1156 ALTER TABLE ticket_index ADD CONSTRAINT FK_ticket_index_group_id_id FOREIGN KEY (group_id) REFERENCES groups (id); 1157END IF; 1158END$$; 1159; 1160DO $$ 1161BEGIN 1162IF NOT EXISTS ( 1163 SELECT 1 1164 FROM pg_constraint 1165 WHERE LOWER(conname) = LOWER('FK_ticket_index_queue_id_id') 1166 ) THEN 1167 ALTER TABLE ticket_index ADD CONSTRAINT FK_ticket_index_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue (id); 1168END IF; 1169END$$; 1170; 1171DO $$ 1172BEGIN 1173IF NOT EXISTS ( 1174 SELECT 1 1175 FROM pg_constraint 1176 WHERE LOWER(conname) = LOWER('FK_ticket_index_ticket_id_id') 1177 ) THEN 1178 ALTER TABLE ticket_index ADD CONSTRAINT FK_ticket_index_ticket_id_id FOREIGN KEY (ticket_id) REFERENCES ticket (id); 1179END IF; 1180END$$; 1181; 1182DO $$ 1183BEGIN 1184IF NOT EXISTS ( 1185 SELECT 1 1186 FROM pg_constraint 1187 WHERE LOWER(conname) = LOWER('FK_ticket_lock_index_ticket_id_id') 1188 ) THEN 1189 ALTER TABLE ticket_lock_index ADD CONSTRAINT FK_ticket_lock_index_ticket_id_id FOREIGN KEY (ticket_id) REFERENCES ticket (id); 1190END IF; 1191END$$; 1192; 1193DO $$ 1194BEGIN 1195IF NOT EXISTS ( 1196 SELECT 1 1197 FROM pg_constraint 1198 WHERE LOWER(conname) = LOWER('FK_article_sender_type_create_by_id') 1199 ) THEN 1200 ALTER TABLE article_sender_type ADD CONSTRAINT FK_article_sender_type_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1201END IF; 1202END$$; 1203; 1204DO $$ 1205BEGIN 1206IF NOT EXISTS ( 1207 SELECT 1 1208 FROM pg_constraint 1209 WHERE LOWER(conname) = LOWER('FK_article_sender_type_change_by_id') 1210 ) THEN 1211 ALTER TABLE article_sender_type ADD CONSTRAINT FK_article_sender_type_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1212END IF; 1213END$$; 1214; 1215DO $$ 1216BEGIN 1217IF NOT EXISTS ( 1218 SELECT 1 1219 FROM pg_constraint 1220 WHERE LOWER(conname) = LOWER('FK_article_sender_type_valid_id_id') 1221 ) THEN 1222 ALTER TABLE article_sender_type ADD CONSTRAINT FK_article_sender_type_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 1223END IF; 1224END$$; 1225; 1226DO $$ 1227BEGIN 1228IF NOT EXISTS ( 1229 SELECT 1 1230 FROM pg_constraint 1231 WHERE LOWER(conname) = LOWER('FK_article_flag_article_id_id') 1232 ) THEN 1233 ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_article_id_id FOREIGN KEY (article_id) REFERENCES article (id); 1234END IF; 1235END$$; 1236; 1237DO $$ 1238BEGIN 1239IF NOT EXISTS ( 1240 SELECT 1 1241 FROM pg_constraint 1242 WHERE LOWER(conname) = LOWER('FK_article_flag_create_by_id') 1243 ) THEN 1244 ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1245END IF; 1246END$$; 1247; 1248DO $$ 1249BEGIN 1250IF NOT EXISTS ( 1251 SELECT 1 1252 FROM pg_constraint 1253 WHERE LOWER(conname) = LOWER('FK_communication_channel_create_by_id') 1254 ) THEN 1255 ALTER TABLE communication_channel ADD CONSTRAINT FK_communication_channel_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1256END IF; 1257END$$; 1258; 1259DO $$ 1260BEGIN 1261IF NOT EXISTS ( 1262 SELECT 1 1263 FROM pg_constraint 1264 WHERE LOWER(conname) = LOWER('FK_communication_channel_change_by_id') 1265 ) THEN 1266 ALTER TABLE communication_channel ADD CONSTRAINT FK_communication_channel_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1267END IF; 1268END$$; 1269; 1270DO $$ 1271BEGIN 1272IF NOT EXISTS ( 1273 SELECT 1 1274 FROM pg_constraint 1275 WHERE LOWER(conname) = LOWER('FK_communication_channel_valid_id_id') 1276 ) THEN 1277 ALTER TABLE communication_channel ADD CONSTRAINT FK_communication_channel_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 1278END IF; 1279END$$; 1280; 1281DO $$ 1282BEGIN 1283IF NOT EXISTS ( 1284 SELECT 1 1285 FROM pg_constraint 1286 WHERE LOWER(conname) = LOWER('FK_article_article_sender_type_id_id') 1287 ) THEN 1288 ALTER TABLE article ADD CONSTRAINT FK_article_article_sender_type_id_id FOREIGN KEY (article_sender_type_id) REFERENCES article_sender_type (id); 1289END IF; 1290END$$; 1291; 1292DO $$ 1293BEGIN 1294IF NOT EXISTS ( 1295 SELECT 1 1296 FROM pg_constraint 1297 WHERE LOWER(conname) = LOWER('FK_article_communication_channel_id_id') 1298 ) THEN 1299 ALTER TABLE article ADD CONSTRAINT FK_article_communication_channel_id_id FOREIGN KEY (communication_channel_id) REFERENCES communication_channel (id); 1300END IF; 1301END$$; 1302; 1303DO $$ 1304BEGIN 1305IF NOT EXISTS ( 1306 SELECT 1 1307 FROM pg_constraint 1308 WHERE LOWER(conname) = LOWER('FK_article_ticket_id_id') 1309 ) THEN 1310 ALTER TABLE article ADD CONSTRAINT FK_article_ticket_id_id FOREIGN KEY (ticket_id) REFERENCES ticket (id); 1311END IF; 1312END$$; 1313; 1314DO $$ 1315BEGIN 1316IF NOT EXISTS ( 1317 SELECT 1 1318 FROM pg_constraint 1319 WHERE LOWER(conname) = LOWER('FK_article_create_by_id') 1320 ) THEN 1321 ALTER TABLE article ADD CONSTRAINT FK_article_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1322END IF; 1323END$$; 1324; 1325DO $$ 1326BEGIN 1327IF NOT EXISTS ( 1328 SELECT 1 1329 FROM pg_constraint 1330 WHERE LOWER(conname) = LOWER('FK_article_change_by_id') 1331 ) THEN 1332 ALTER TABLE article ADD CONSTRAINT FK_article_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1333END IF; 1334END$$; 1335; 1336DO $$ 1337BEGIN 1338IF NOT EXISTS ( 1339 SELECT 1 1340 FROM pg_constraint 1341 WHERE LOWER(conname) = LOWER('FK_article_data_mime_article_id_id') 1342 ) THEN 1343 ALTER TABLE article_data_mime ADD CONSTRAINT FK_article_data_mime_article_id_id FOREIGN KEY (article_id) REFERENCES article (id); 1344END IF; 1345END$$; 1346; 1347DO $$ 1348BEGIN 1349IF NOT EXISTS ( 1350 SELECT 1 1351 FROM pg_constraint 1352 WHERE LOWER(conname) = LOWER('FK_article_data_mime_create_by_id') 1353 ) THEN 1354 ALTER TABLE article_data_mime ADD CONSTRAINT FK_article_data_mime_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1355END IF; 1356END$$; 1357; 1358DO $$ 1359BEGIN 1360IF NOT EXISTS ( 1361 SELECT 1 1362 FROM pg_constraint 1363 WHERE LOWER(conname) = LOWER('FK_article_data_mime_change_by_id') 1364 ) THEN 1365 ALTER TABLE article_data_mime ADD CONSTRAINT FK_article_data_mime_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1366END IF; 1367END$$; 1368; 1369DO $$ 1370BEGIN 1371IF NOT EXISTS ( 1372 SELECT 1 1373 FROM pg_constraint 1374 WHERE LOWER(conname) = LOWER('FK_article_search_index_article_id_id') 1375 ) THEN 1376 ALTER TABLE article_search_index ADD CONSTRAINT FK_article_search_index_article_id_id FOREIGN KEY (article_id) REFERENCES article (id); 1377END IF; 1378END$$; 1379; 1380DO $$ 1381BEGIN 1382IF NOT EXISTS ( 1383 SELECT 1 1384 FROM pg_constraint 1385 WHERE LOWER(conname) = LOWER('FK_article_search_index_ticket_id_id') 1386 ) THEN 1387 ALTER TABLE article_search_index ADD CONSTRAINT FK_article_search_index_ticket_id_id FOREIGN KEY (ticket_id) REFERENCES ticket (id); 1388END IF; 1389END$$; 1390; 1391DO $$ 1392BEGIN 1393IF NOT EXISTS ( 1394 SELECT 1 1395 FROM pg_constraint 1396 WHERE LOWER(conname) = LOWER('FK_article_data_mime_plain_article_id_id') 1397 ) THEN 1398 ALTER TABLE article_data_mime_plain ADD CONSTRAINT FK_article_data_mime_plain_article_id_id FOREIGN KEY (article_id) REFERENCES article (id); 1399END IF; 1400END$$; 1401; 1402DO $$ 1403BEGIN 1404IF NOT EXISTS ( 1405 SELECT 1 1406 FROM pg_constraint 1407 WHERE LOWER(conname) = LOWER('FK_article_data_mime_plain_create_by_id') 1408 ) THEN 1409 ALTER TABLE article_data_mime_plain ADD CONSTRAINT FK_article_data_mime_plain_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1410END IF; 1411END$$; 1412; 1413DO $$ 1414BEGIN 1415IF NOT EXISTS ( 1416 SELECT 1 1417 FROM pg_constraint 1418 WHERE LOWER(conname) = LOWER('FK_article_data_mime_plain_change_by_id') 1419 ) THEN 1420 ALTER TABLE article_data_mime_plain ADD CONSTRAINT FK_article_data_mime_plain_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1421END IF; 1422END$$; 1423; 1424DO $$ 1425BEGIN 1426IF NOT EXISTS ( 1427 SELECT 1 1428 FROM pg_constraint 1429 WHERE LOWER(conname) = LOWER('FK_article_data_mime_attachment_article_id_id') 1430 ) THEN 1431 ALTER TABLE article_data_mime_attachment ADD CONSTRAINT FK_article_data_mime_attachment_article_id_id FOREIGN KEY (article_id) REFERENCES article (id); 1432END IF; 1433END$$; 1434; 1435DO $$ 1436BEGIN 1437IF NOT EXISTS ( 1438 SELECT 1 1439 FROM pg_constraint 1440 WHERE LOWER(conname) = LOWER('FK_article_data_mime_attachment_create_by_id') 1441 ) THEN 1442 ALTER TABLE article_data_mime_attachment ADD CONSTRAINT FK_article_data_mime_attachment_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1443END IF; 1444END$$; 1445; 1446DO $$ 1447BEGIN 1448IF NOT EXISTS ( 1449 SELECT 1 1450 FROM pg_constraint 1451 WHERE LOWER(conname) = LOWER('FK_article_data_mime_attachment_change_by_id') 1452 ) THEN 1453 ALTER TABLE article_data_mime_attachment ADD CONSTRAINT FK_article_data_mime_attachment_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1454END IF; 1455END$$; 1456; 1457DO $$ 1458BEGIN 1459IF NOT EXISTS ( 1460 SELECT 1 1461 FROM pg_constraint 1462 WHERE LOWER(conname) = LOWER('FK_article_data_mime_send_error_article_id_id') 1463 ) THEN 1464 ALTER TABLE article_data_mime_send_error ADD CONSTRAINT FK_article_data_mime_send_error_article_id_id FOREIGN KEY (article_id) REFERENCES article (id); 1465END IF; 1466END$$; 1467; 1468DO $$ 1469BEGIN 1470IF NOT EXISTS ( 1471 SELECT 1 1472 FROM pg_constraint 1473 WHERE LOWER(conname) = LOWER('FK_article_data_otrs_chat_article_id_id') 1474 ) THEN 1475 ALTER TABLE article_data_otrs_chat ADD CONSTRAINT FK_article_data_otrs_chat_article_id_id FOREIGN KEY (article_id) REFERENCES article (id); 1476END IF; 1477END$$; 1478; 1479DO $$ 1480BEGIN 1481IF NOT EXISTS ( 1482 SELECT 1 1483 FROM pg_constraint 1484 WHERE LOWER(conname) = LOWER('FK_time_accounting_article_id_id') 1485 ) THEN 1486 ALTER TABLE time_accounting ADD CONSTRAINT FK_time_accounting_article_id_id FOREIGN KEY (article_id) REFERENCES article (id); 1487END IF; 1488END$$; 1489; 1490DO $$ 1491BEGIN 1492IF NOT EXISTS ( 1493 SELECT 1 1494 FROM pg_constraint 1495 WHERE LOWER(conname) = LOWER('FK_time_accounting_ticket_id_id') 1496 ) THEN 1497 ALTER TABLE time_accounting ADD CONSTRAINT FK_time_accounting_ticket_id_id FOREIGN KEY (ticket_id) REFERENCES ticket (id); 1498END IF; 1499END$$; 1500; 1501DO $$ 1502BEGIN 1503IF NOT EXISTS ( 1504 SELECT 1 1505 FROM pg_constraint 1506 WHERE LOWER(conname) = LOWER('FK_time_accounting_create_by_id') 1507 ) THEN 1508 ALTER TABLE time_accounting ADD CONSTRAINT FK_time_accounting_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1509END IF; 1510END$$; 1511; 1512DO $$ 1513BEGIN 1514IF NOT EXISTS ( 1515 SELECT 1 1516 FROM pg_constraint 1517 WHERE LOWER(conname) = LOWER('FK_time_accounting_change_by_id') 1518 ) THEN 1519 ALTER TABLE time_accounting ADD CONSTRAINT FK_time_accounting_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1520END IF; 1521END$$; 1522; 1523DO $$ 1524BEGIN 1525IF NOT EXISTS ( 1526 SELECT 1 1527 FROM pg_constraint 1528 WHERE LOWER(conname) = LOWER('FK_standard_template_create_by_id') 1529 ) THEN 1530 ALTER TABLE standard_template ADD CONSTRAINT FK_standard_template_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1531END IF; 1532END$$; 1533; 1534DO $$ 1535BEGIN 1536IF NOT EXISTS ( 1537 SELECT 1 1538 FROM pg_constraint 1539 WHERE LOWER(conname) = LOWER('FK_standard_template_change_by_id') 1540 ) THEN 1541 ALTER TABLE standard_template ADD CONSTRAINT FK_standard_template_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1542END IF; 1543END$$; 1544; 1545DO $$ 1546BEGIN 1547IF NOT EXISTS ( 1548 SELECT 1 1549 FROM pg_constraint 1550 WHERE LOWER(conname) = LOWER('FK_standard_template_valid_id_id') 1551 ) THEN 1552 ALTER TABLE standard_template ADD CONSTRAINT FK_standard_template_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 1553END IF; 1554END$$; 1555; 1556DO $$ 1557BEGIN 1558IF NOT EXISTS ( 1559 SELECT 1 1560 FROM pg_constraint 1561 WHERE LOWER(conname) = LOWER('FK_queue_standard_template_queue_id_id') 1562 ) THEN 1563 ALTER TABLE queue_standard_template ADD CONSTRAINT FK_queue_standard_template_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue (id); 1564END IF; 1565END$$; 1566; 1567DO $$ 1568BEGIN 1569IF NOT EXISTS ( 1570 SELECT 1 1571 FROM pg_constraint 1572 WHERE LOWER(conname) = LOWER('FK_queue_standard_template_standard_template_id_id') 1573 ) THEN 1574 ALTER TABLE queue_standard_template ADD CONSTRAINT FK_queue_standard_template_standard_template_id_id FOREIGN KEY (standard_template_id) REFERENCES standard_template (id); 1575END IF; 1576END$$; 1577; 1578DO $$ 1579BEGIN 1580IF NOT EXISTS ( 1581 SELECT 1 1582 FROM pg_constraint 1583 WHERE LOWER(conname) = LOWER('FK_queue_standard_template_create_by_id') 1584 ) THEN 1585 ALTER TABLE queue_standard_template ADD CONSTRAINT FK_queue_standard_template_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1586END IF; 1587END$$; 1588; 1589DO $$ 1590BEGIN 1591IF NOT EXISTS ( 1592 SELECT 1 1593 FROM pg_constraint 1594 WHERE LOWER(conname) = LOWER('FK_queue_standard_template_change_by_id') 1595 ) THEN 1596 ALTER TABLE queue_standard_template ADD CONSTRAINT FK_queue_standard_template_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1597END IF; 1598END$$; 1599; 1600DO $$ 1601BEGIN 1602IF NOT EXISTS ( 1603 SELECT 1 1604 FROM pg_constraint 1605 WHERE LOWER(conname) = LOWER('FK_standard_attachment_create_by_id') 1606 ) THEN 1607 ALTER TABLE standard_attachment ADD CONSTRAINT FK_standard_attachment_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1608END IF; 1609END$$; 1610; 1611DO $$ 1612BEGIN 1613IF NOT EXISTS ( 1614 SELECT 1 1615 FROM pg_constraint 1616 WHERE LOWER(conname) = LOWER('FK_standard_attachment_change_by_id') 1617 ) THEN 1618 ALTER TABLE standard_attachment ADD CONSTRAINT FK_standard_attachment_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1619END IF; 1620END$$; 1621; 1622DO $$ 1623BEGIN 1624IF NOT EXISTS ( 1625 SELECT 1 1626 FROM pg_constraint 1627 WHERE LOWER(conname) = LOWER('FK_standard_attachment_valid_id_id') 1628 ) THEN 1629 ALTER TABLE standard_attachment ADD CONSTRAINT FK_standard_attachment_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 1630END IF; 1631END$$; 1632; 1633DO $$ 1634BEGIN 1635IF NOT EXISTS ( 1636 SELECT 1 1637 FROM pg_constraint 1638 WHERE LOWER(conname) = LOWER('FK_standard_template_attachment_standard_attachment_id_id') 1639 ) THEN 1640 ALTER TABLE standard_template_attachment ADD CONSTRAINT FK_standard_template_attachment_standard_attachment_id_id FOREIGN KEY (standard_attachment_id) REFERENCES standard_attachment (id); 1641END IF; 1642END$$; 1643; 1644DO $$ 1645BEGIN 1646IF NOT EXISTS ( 1647 SELECT 1 1648 FROM pg_constraint 1649 WHERE LOWER(conname) = LOWER('FK_standard_template_attachment_standard_template_id_id') 1650 ) THEN 1651 ALTER TABLE standard_template_attachment ADD CONSTRAINT FK_standard_template_attachment_standard_template_id_id FOREIGN KEY (standard_template_id) REFERENCES standard_template (id); 1652END IF; 1653END$$; 1654; 1655DO $$ 1656BEGIN 1657IF NOT EXISTS ( 1658 SELECT 1 1659 FROM pg_constraint 1660 WHERE LOWER(conname) = LOWER('FK_standard_template_attachment_create_by_id') 1661 ) THEN 1662 ALTER TABLE standard_template_attachment ADD CONSTRAINT FK_standard_template_attachment_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1663END IF; 1664END$$; 1665; 1666DO $$ 1667BEGIN 1668IF NOT EXISTS ( 1669 SELECT 1 1670 FROM pg_constraint 1671 WHERE LOWER(conname) = LOWER('FK_standard_template_attachment_change_by_id') 1672 ) THEN 1673 ALTER TABLE standard_template_attachment ADD CONSTRAINT FK_standard_template_attachment_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1674END IF; 1675END$$; 1676; 1677DO $$ 1678BEGIN 1679IF NOT EXISTS ( 1680 SELECT 1 1681 FROM pg_constraint 1682 WHERE LOWER(conname) = LOWER('FK_auto_response_type_create_by_id') 1683 ) THEN 1684 ALTER TABLE auto_response_type ADD CONSTRAINT FK_auto_response_type_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1685END IF; 1686END$$; 1687; 1688DO $$ 1689BEGIN 1690IF NOT EXISTS ( 1691 SELECT 1 1692 FROM pg_constraint 1693 WHERE LOWER(conname) = LOWER('FK_auto_response_type_change_by_id') 1694 ) THEN 1695 ALTER TABLE auto_response_type ADD CONSTRAINT FK_auto_response_type_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1696END IF; 1697END$$; 1698; 1699DO $$ 1700BEGIN 1701IF NOT EXISTS ( 1702 SELECT 1 1703 FROM pg_constraint 1704 WHERE LOWER(conname) = LOWER('FK_auto_response_type_valid_id_id') 1705 ) THEN 1706 ALTER TABLE auto_response_type ADD CONSTRAINT FK_auto_response_type_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 1707END IF; 1708END$$; 1709; 1710DO $$ 1711BEGIN 1712IF NOT EXISTS ( 1713 SELECT 1 1714 FROM pg_constraint 1715 WHERE LOWER(conname) = LOWER('FK_auto_response_type_id_id') 1716 ) THEN 1717 ALTER TABLE auto_response ADD CONSTRAINT FK_auto_response_type_id_id FOREIGN KEY (type_id) REFERENCES auto_response_type (id); 1718END IF; 1719END$$; 1720; 1721DO $$ 1722BEGIN 1723IF NOT EXISTS ( 1724 SELECT 1 1725 FROM pg_constraint 1726 WHERE LOWER(conname) = LOWER('FK_auto_response_system_address_id_id') 1727 ) THEN 1728 ALTER TABLE auto_response ADD CONSTRAINT FK_auto_response_system_address_id_id FOREIGN KEY (system_address_id) REFERENCES system_address (id); 1729END IF; 1730END$$; 1731; 1732DO $$ 1733BEGIN 1734IF NOT EXISTS ( 1735 SELECT 1 1736 FROM pg_constraint 1737 WHERE LOWER(conname) = LOWER('FK_auto_response_create_by_id') 1738 ) THEN 1739 ALTER TABLE auto_response ADD CONSTRAINT FK_auto_response_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1740END IF; 1741END$$; 1742; 1743DO $$ 1744BEGIN 1745IF NOT EXISTS ( 1746 SELECT 1 1747 FROM pg_constraint 1748 WHERE LOWER(conname) = LOWER('FK_auto_response_change_by_id') 1749 ) THEN 1750 ALTER TABLE auto_response ADD CONSTRAINT FK_auto_response_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1751END IF; 1752END$$; 1753; 1754DO $$ 1755BEGIN 1756IF NOT EXISTS ( 1757 SELECT 1 1758 FROM pg_constraint 1759 WHERE LOWER(conname) = LOWER('FK_auto_response_valid_id_id') 1760 ) THEN 1761 ALTER TABLE auto_response ADD CONSTRAINT FK_auto_response_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 1762END IF; 1763END$$; 1764; 1765DO $$ 1766BEGIN 1767IF NOT EXISTS ( 1768 SELECT 1 1769 FROM pg_constraint 1770 WHERE LOWER(conname) = LOWER('FK_queue_auto_response_auto_response_id_id') 1771 ) THEN 1772 ALTER TABLE queue_auto_response ADD CONSTRAINT FK_queue_auto_response_auto_response_id_id FOREIGN KEY (auto_response_id) REFERENCES auto_response (id); 1773END IF; 1774END$$; 1775; 1776DO $$ 1777BEGIN 1778IF NOT EXISTS ( 1779 SELECT 1 1780 FROM pg_constraint 1781 WHERE LOWER(conname) = LOWER('FK_queue_auto_response_queue_id_id') 1782 ) THEN 1783 ALTER TABLE queue_auto_response ADD CONSTRAINT FK_queue_auto_response_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue (id); 1784END IF; 1785END$$; 1786; 1787DO $$ 1788BEGIN 1789IF NOT EXISTS ( 1790 SELECT 1 1791 FROM pg_constraint 1792 WHERE LOWER(conname) = LOWER('FK_queue_auto_response_create_by_id') 1793 ) THEN 1794 ALTER TABLE queue_auto_response ADD CONSTRAINT FK_queue_auto_response_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1795END IF; 1796END$$; 1797; 1798DO $$ 1799BEGIN 1800IF NOT EXISTS ( 1801 SELECT 1 1802 FROM pg_constraint 1803 WHERE LOWER(conname) = LOWER('FK_queue_auto_response_change_by_id') 1804 ) THEN 1805 ALTER TABLE queue_auto_response ADD CONSTRAINT FK_queue_auto_response_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1806END IF; 1807END$$; 1808; 1809DO $$ 1810BEGIN 1811IF NOT EXISTS ( 1812 SELECT 1 1813 FROM pg_constraint 1814 WHERE LOWER(conname) = LOWER('FK_service_create_by_id') 1815 ) THEN 1816 ALTER TABLE service ADD CONSTRAINT FK_service_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1817END IF; 1818END$$; 1819; 1820DO $$ 1821BEGIN 1822IF NOT EXISTS ( 1823 SELECT 1 1824 FROM pg_constraint 1825 WHERE LOWER(conname) = LOWER('FK_service_change_by_id') 1826 ) THEN 1827 ALTER TABLE service ADD CONSTRAINT FK_service_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1828END IF; 1829END$$; 1830; 1831DO $$ 1832BEGIN 1833IF NOT EXISTS ( 1834 SELECT 1 1835 FROM pg_constraint 1836 WHERE LOWER(conname) = LOWER('FK_service_preferences_service_id_id') 1837 ) THEN 1838 ALTER TABLE service_preferences ADD CONSTRAINT FK_service_preferences_service_id_id FOREIGN KEY (service_id) REFERENCES service (id); 1839END IF; 1840END$$; 1841; 1842DO $$ 1843BEGIN 1844IF NOT EXISTS ( 1845 SELECT 1 1846 FROM pg_constraint 1847 WHERE LOWER(conname) = LOWER('FK_service_customer_user_service_id_id') 1848 ) THEN 1849 ALTER TABLE service_customer_user ADD CONSTRAINT FK_service_customer_user_service_id_id FOREIGN KEY (service_id) REFERENCES service (id); 1850END IF; 1851END$$; 1852; 1853DO $$ 1854BEGIN 1855IF NOT EXISTS ( 1856 SELECT 1 1857 FROM pg_constraint 1858 WHERE LOWER(conname) = LOWER('FK_service_customer_user_create_by_id') 1859 ) THEN 1860 ALTER TABLE service_customer_user ADD CONSTRAINT FK_service_customer_user_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1861END IF; 1862END$$; 1863; 1864DO $$ 1865BEGIN 1866IF NOT EXISTS ( 1867 SELECT 1 1868 FROM pg_constraint 1869 WHERE LOWER(conname) = LOWER('FK_sla_create_by_id') 1870 ) THEN 1871 ALTER TABLE sla ADD CONSTRAINT FK_sla_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1872END IF; 1873END$$; 1874; 1875DO $$ 1876BEGIN 1877IF NOT EXISTS ( 1878 SELECT 1 1879 FROM pg_constraint 1880 WHERE LOWER(conname) = LOWER('FK_sla_change_by_id') 1881 ) THEN 1882 ALTER TABLE sla ADD CONSTRAINT FK_sla_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1883END IF; 1884END$$; 1885; 1886DO $$ 1887BEGIN 1888IF NOT EXISTS ( 1889 SELECT 1 1890 FROM pg_constraint 1891 WHERE LOWER(conname) = LOWER('FK_sla_preferences_sla_id_id') 1892 ) THEN 1893 ALTER TABLE sla_preferences ADD CONSTRAINT FK_sla_preferences_sla_id_id FOREIGN KEY (sla_id) REFERENCES sla (id); 1894END IF; 1895END$$; 1896; 1897DO $$ 1898BEGIN 1899IF NOT EXISTS ( 1900 SELECT 1 1901 FROM pg_constraint 1902 WHERE LOWER(conname) = LOWER('FK_service_sla_service_id_id') 1903 ) THEN 1904 ALTER TABLE service_sla ADD CONSTRAINT FK_service_sla_service_id_id FOREIGN KEY (service_id) REFERENCES service (id); 1905END IF; 1906END$$; 1907; 1908DO $$ 1909BEGIN 1910IF NOT EXISTS ( 1911 SELECT 1 1912 FROM pg_constraint 1913 WHERE LOWER(conname) = LOWER('FK_service_sla_sla_id_id') 1914 ) THEN 1915 ALTER TABLE service_sla ADD CONSTRAINT FK_service_sla_sla_id_id FOREIGN KEY (sla_id) REFERENCES sla (id); 1916END IF; 1917END$$; 1918; 1919DO $$ 1920BEGIN 1921IF NOT EXISTS ( 1922 SELECT 1 1923 FROM pg_constraint 1924 WHERE LOWER(conname) = LOWER('FK_customer_user_create_by_id') 1925 ) THEN 1926 ALTER TABLE customer_user ADD CONSTRAINT FK_customer_user_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1927END IF; 1928END$$; 1929; 1930DO $$ 1931BEGIN 1932IF NOT EXISTS ( 1933 SELECT 1 1934 FROM pg_constraint 1935 WHERE LOWER(conname) = LOWER('FK_customer_user_change_by_id') 1936 ) THEN 1937 ALTER TABLE customer_user ADD CONSTRAINT FK_customer_user_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1938END IF; 1939END$$; 1940; 1941DO $$ 1942BEGIN 1943IF NOT EXISTS ( 1944 SELECT 1 1945 FROM pg_constraint 1946 WHERE LOWER(conname) = LOWER('FK_customer_user_valid_id_id') 1947 ) THEN 1948 ALTER TABLE customer_user ADD CONSTRAINT FK_customer_user_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 1949END IF; 1950END$$; 1951; 1952DO $$ 1953BEGIN 1954IF NOT EXISTS ( 1955 SELECT 1 1956 FROM pg_constraint 1957 WHERE LOWER(conname) = LOWER('FK_customer_user_customer_create_by_id') 1958 ) THEN 1959 ALTER TABLE customer_user_customer ADD CONSTRAINT FK_customer_user_customer_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1960END IF; 1961END$$; 1962; 1963DO $$ 1964BEGIN 1965IF NOT EXISTS ( 1966 SELECT 1 1967 FROM pg_constraint 1968 WHERE LOWER(conname) = LOWER('FK_customer_user_customer_change_by_id') 1969 ) THEN 1970 ALTER TABLE customer_user_customer ADD CONSTRAINT FK_customer_user_customer_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1971END IF; 1972END$$; 1973; 1974DO $$ 1975BEGIN 1976IF NOT EXISTS ( 1977 SELECT 1 1978 FROM pg_constraint 1979 WHERE LOWER(conname) = LOWER('FK_mail_account_create_by_id') 1980 ) THEN 1981 ALTER TABLE mail_account ADD CONSTRAINT FK_mail_account_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 1982END IF; 1983END$$; 1984; 1985DO $$ 1986BEGIN 1987IF NOT EXISTS ( 1988 SELECT 1 1989 FROM pg_constraint 1990 WHERE LOWER(conname) = LOWER('FK_mail_account_change_by_id') 1991 ) THEN 1992 ALTER TABLE mail_account ADD CONSTRAINT FK_mail_account_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 1993END IF; 1994END$$; 1995; 1996DO $$ 1997BEGIN 1998IF NOT EXISTS ( 1999 SELECT 1 2000 FROM pg_constraint 2001 WHERE LOWER(conname) = LOWER('FK_mail_account_valid_id_id') 2002 ) THEN 2003 ALTER TABLE mail_account ADD CONSTRAINT FK_mail_account_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 2004END IF; 2005END$$; 2006; 2007DO $$ 2008BEGIN 2009IF NOT EXISTS ( 2010 SELECT 1 2011 FROM pg_constraint 2012 WHERE LOWER(conname) = LOWER('FK_notification_event_create_by_id') 2013 ) THEN 2014 ALTER TABLE notification_event ADD CONSTRAINT FK_notification_event_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2015END IF; 2016END$$; 2017; 2018DO $$ 2019BEGIN 2020IF NOT EXISTS ( 2021 SELECT 1 2022 FROM pg_constraint 2023 WHERE LOWER(conname) = LOWER('FK_notification_event_change_by_id') 2024 ) THEN 2025 ALTER TABLE notification_event ADD CONSTRAINT FK_notification_event_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2026END IF; 2027END$$; 2028; 2029DO $$ 2030BEGIN 2031IF NOT EXISTS ( 2032 SELECT 1 2033 FROM pg_constraint 2034 WHERE LOWER(conname) = LOWER('FK_notification_event_valid_id_id') 2035 ) THEN 2036 ALTER TABLE notification_event ADD CONSTRAINT FK_notification_event_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 2037END IF; 2038END$$; 2039; 2040DO $$ 2041BEGIN 2042IF NOT EXISTS ( 2043 SELECT 1 2044 FROM pg_constraint 2045 WHERE LOWER(conname) = LOWER('FK_notification_event_message_notification_id_id') 2046 ) THEN 2047 ALTER TABLE notification_event_message ADD CONSTRAINT FK_notification_event_message_notification_id_id FOREIGN KEY (notification_id) REFERENCES notification_event (id); 2048END IF; 2049END$$; 2050; 2051DO $$ 2052BEGIN 2053IF NOT EXISTS ( 2054 SELECT 1 2055 FROM pg_constraint 2056 WHERE LOWER(conname) = LOWER('FK_notification_event_item_notification_id_id') 2057 ) THEN 2058 ALTER TABLE notification_event_item ADD CONSTRAINT FK_notification_event_item_notification_id_id FOREIGN KEY (notification_id) REFERENCES notification_event (id); 2059END IF; 2060END$$; 2061; 2062DO $$ 2063BEGIN 2064IF NOT EXISTS ( 2065 SELECT 1 2066 FROM pg_constraint 2067 WHERE LOWER(conname) = LOWER('FK_link_type_create_by_id') 2068 ) THEN 2069 ALTER TABLE link_type ADD CONSTRAINT FK_link_type_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2070END IF; 2071END$$; 2072; 2073DO $$ 2074BEGIN 2075IF NOT EXISTS ( 2076 SELECT 1 2077 FROM pg_constraint 2078 WHERE LOWER(conname) = LOWER('FK_link_type_change_by_id') 2079 ) THEN 2080 ALTER TABLE link_type ADD CONSTRAINT FK_link_type_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2081END IF; 2082END$$; 2083; 2084DO $$ 2085BEGIN 2086IF NOT EXISTS ( 2087 SELECT 1 2088 FROM pg_constraint 2089 WHERE LOWER(conname) = LOWER('FK_link_type_valid_id_id') 2090 ) THEN 2091 ALTER TABLE link_type ADD CONSTRAINT FK_link_type_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 2092END IF; 2093END$$; 2094; 2095DO $$ 2096BEGIN 2097IF NOT EXISTS ( 2098 SELECT 1 2099 FROM pg_constraint 2100 WHERE LOWER(conname) = LOWER('FK_link_state_create_by_id') 2101 ) THEN 2102 ALTER TABLE link_state ADD CONSTRAINT FK_link_state_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2103END IF; 2104END$$; 2105; 2106DO $$ 2107BEGIN 2108IF NOT EXISTS ( 2109 SELECT 1 2110 FROM pg_constraint 2111 WHERE LOWER(conname) = LOWER('FK_link_state_change_by_id') 2112 ) THEN 2113 ALTER TABLE link_state ADD CONSTRAINT FK_link_state_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2114END IF; 2115END$$; 2116; 2117DO $$ 2118BEGIN 2119IF NOT EXISTS ( 2120 SELECT 1 2121 FROM pg_constraint 2122 WHERE LOWER(conname) = LOWER('FK_link_state_valid_id_id') 2123 ) THEN 2124 ALTER TABLE link_state ADD CONSTRAINT FK_link_state_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 2125END IF; 2126END$$; 2127; 2128DO $$ 2129BEGIN 2130IF NOT EXISTS ( 2131 SELECT 1 2132 FROM pg_constraint 2133 WHERE LOWER(conname) = LOWER('FK_link_relation_source_object_id_id') 2134 ) THEN 2135 ALTER TABLE link_relation ADD CONSTRAINT FK_link_relation_source_object_id_id FOREIGN KEY (source_object_id) REFERENCES link_object (id); 2136END IF; 2137END$$; 2138; 2139DO $$ 2140BEGIN 2141IF NOT EXISTS ( 2142 SELECT 1 2143 FROM pg_constraint 2144 WHERE LOWER(conname) = LOWER('FK_link_relation_target_object_id_id') 2145 ) THEN 2146 ALTER TABLE link_relation ADD CONSTRAINT FK_link_relation_target_object_id_id FOREIGN KEY (target_object_id) REFERENCES link_object (id); 2147END IF; 2148END$$; 2149; 2150DO $$ 2151BEGIN 2152IF NOT EXISTS ( 2153 SELECT 1 2154 FROM pg_constraint 2155 WHERE LOWER(conname) = LOWER('FK_link_relation_state_id_id') 2156 ) THEN 2157 ALTER TABLE link_relation ADD CONSTRAINT FK_link_relation_state_id_id FOREIGN KEY (state_id) REFERENCES link_state (id); 2158END IF; 2159END$$; 2160; 2161DO $$ 2162BEGIN 2163IF NOT EXISTS ( 2164 SELECT 1 2165 FROM pg_constraint 2166 WHERE LOWER(conname) = LOWER('FK_link_relation_type_id_id') 2167 ) THEN 2168 ALTER TABLE link_relation ADD CONSTRAINT FK_link_relation_type_id_id FOREIGN KEY (type_id) REFERENCES link_type (id); 2169END IF; 2170END$$; 2171; 2172DO $$ 2173BEGIN 2174IF NOT EXISTS ( 2175 SELECT 1 2176 FROM pg_constraint 2177 WHERE LOWER(conname) = LOWER('FK_link_relation_create_by_id') 2178 ) THEN 2179 ALTER TABLE link_relation ADD CONSTRAINT FK_link_relation_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2180END IF; 2181END$$; 2182; 2183DO $$ 2184BEGIN 2185IF NOT EXISTS ( 2186 SELECT 1 2187 FROM pg_constraint 2188 WHERE LOWER(conname) = LOWER('FK_system_data_create_by_id') 2189 ) THEN 2190 ALTER TABLE system_data ADD CONSTRAINT FK_system_data_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2191END IF; 2192END$$; 2193; 2194DO $$ 2195BEGIN 2196IF NOT EXISTS ( 2197 SELECT 1 2198 FROM pg_constraint 2199 WHERE LOWER(conname) = LOWER('FK_system_data_change_by_id') 2200 ) THEN 2201 ALTER TABLE system_data ADD CONSTRAINT FK_system_data_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2202END IF; 2203END$$; 2204; 2205DO $$ 2206BEGIN 2207IF NOT EXISTS ( 2208 SELECT 1 2209 FROM pg_constraint 2210 WHERE LOWER(conname) = LOWER('FK_virtual_fs_preferences_virtual_fs_id_id') 2211 ) THEN 2212 ALTER TABLE virtual_fs_preferences ADD CONSTRAINT FK_virtual_fs_preferences_virtual_fs_id_id FOREIGN KEY (virtual_fs_id) REFERENCES virtual_fs (id); 2213END IF; 2214END$$; 2215; 2216DO $$ 2217BEGIN 2218IF NOT EXISTS ( 2219 SELECT 1 2220 FROM pg_constraint 2221 WHERE LOWER(conname) = LOWER('FK_package_repository_create_by_id') 2222 ) THEN 2223 ALTER TABLE package_repository ADD CONSTRAINT FK_package_repository_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2224END IF; 2225END$$; 2226; 2227DO $$ 2228BEGIN 2229IF NOT EXISTS ( 2230 SELECT 1 2231 FROM pg_constraint 2232 WHERE LOWER(conname) = LOWER('FK_package_repository_change_by_id') 2233 ) THEN 2234 ALTER TABLE package_repository ADD CONSTRAINT FK_package_repository_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2235END IF; 2236END$$; 2237; 2238DO $$ 2239BEGIN 2240IF NOT EXISTS ( 2241 SELECT 1 2242 FROM pg_constraint 2243 WHERE LOWER(conname) = LOWER('FK_gi_webservice_config_create_by_id') 2244 ) THEN 2245 ALTER TABLE gi_webservice_config ADD CONSTRAINT FK_gi_webservice_config_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2246END IF; 2247END$$; 2248; 2249DO $$ 2250BEGIN 2251IF NOT EXISTS ( 2252 SELECT 1 2253 FROM pg_constraint 2254 WHERE LOWER(conname) = LOWER('FK_gi_webservice_config_change_by_id') 2255 ) THEN 2256 ALTER TABLE gi_webservice_config ADD CONSTRAINT FK_gi_webservice_config_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2257END IF; 2258END$$; 2259; 2260DO $$ 2261BEGIN 2262IF NOT EXISTS ( 2263 SELECT 1 2264 FROM pg_constraint 2265 WHERE LOWER(conname) = LOWER('FK_gi_webservice_config_valid_id_id') 2266 ) THEN 2267 ALTER TABLE gi_webservice_config ADD CONSTRAINT FK_gi_webservice_config_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 2268END IF; 2269END$$; 2270; 2271DO $$ 2272BEGIN 2273IF NOT EXISTS ( 2274 SELECT 1 2275 FROM pg_constraint 2276 WHERE LOWER(conname) = LOWER('FK_gi_webservice_config_history_config_id_id') 2277 ) THEN 2278 ALTER TABLE gi_webservice_config_history ADD CONSTRAINT FK_gi_webservice_config_history_config_id_id FOREIGN KEY (config_id) REFERENCES gi_webservice_config (id); 2279END IF; 2280END$$; 2281; 2282DO $$ 2283BEGIN 2284IF NOT EXISTS ( 2285 SELECT 1 2286 FROM pg_constraint 2287 WHERE LOWER(conname) = LOWER('FK_gi_webservice_config_history_create_by_id') 2288 ) THEN 2289 ALTER TABLE gi_webservice_config_history ADD CONSTRAINT FK_gi_webservice_config_history_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2290END IF; 2291END$$; 2292; 2293DO $$ 2294BEGIN 2295IF NOT EXISTS ( 2296 SELECT 1 2297 FROM pg_constraint 2298 WHERE LOWER(conname) = LOWER('FK_gi_webservice_config_history_change_by_id') 2299 ) THEN 2300 ALTER TABLE gi_webservice_config_history ADD CONSTRAINT FK_gi_webservice_config_history_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2301END IF; 2302END$$; 2303; 2304DO $$ 2305BEGIN 2306IF NOT EXISTS ( 2307 SELECT 1 2308 FROM pg_constraint 2309 WHERE LOWER(conname) = LOWER('FK_gi_debugger_entry_webservice_id_id') 2310 ) THEN 2311 ALTER TABLE gi_debugger_entry ADD CONSTRAINT FK_gi_debugger_entry_webservice_id_id FOREIGN KEY (webservice_id) REFERENCES gi_webservice_config (id); 2312END IF; 2313END$$; 2314; 2315DO $$ 2316BEGIN 2317IF NOT EXISTS ( 2318 SELECT 1 2319 FROM pg_constraint 2320 WHERE LOWER(conname) = LOWER('FK_gi_debugger_entry_content_gi_debugger_entry_id_id') 2321 ) THEN 2322 ALTER TABLE gi_debugger_entry_content ADD CONSTRAINT FK_gi_debugger_entry_content_gi_debugger_entry_id_id FOREIGN KEY (gi_debugger_entry_id) REFERENCES gi_debugger_entry (id); 2323END IF; 2324END$$; 2325; 2326DO $$ 2327BEGIN 2328IF NOT EXISTS ( 2329 SELECT 1 2330 FROM pg_constraint 2331 WHERE LOWER(conname) = LOWER('FK_smime_signer_cert_relations_create_by_id') 2332 ) THEN 2333 ALTER TABLE smime_signer_cert_relations ADD CONSTRAINT FK_smime_signer_cert_relations_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2334END IF; 2335END$$; 2336; 2337DO $$ 2338BEGIN 2339IF NOT EXISTS ( 2340 SELECT 1 2341 FROM pg_constraint 2342 WHERE LOWER(conname) = LOWER('FK_smime_signer_cert_relations_change_by_id') 2343 ) THEN 2344 ALTER TABLE smime_signer_cert_relations ADD CONSTRAINT FK_smime_signer_cert_relations_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2345END IF; 2346END$$; 2347; 2348DO $$ 2349BEGIN 2350IF NOT EXISTS ( 2351 SELECT 1 2352 FROM pg_constraint 2353 WHERE LOWER(conname) = LOWER('FK_dynamic_field_value_field_id_id') 2354 ) THEN 2355 ALTER TABLE dynamic_field_value ADD CONSTRAINT FK_dynamic_field_value_field_id_id FOREIGN KEY (field_id) REFERENCES dynamic_field (id); 2356END IF; 2357END$$; 2358; 2359DO $$ 2360BEGIN 2361IF NOT EXISTS ( 2362 SELECT 1 2363 FROM pg_constraint 2364 WHERE LOWER(conname) = LOWER('FK_dynamic_field_create_by_id') 2365 ) THEN 2366 ALTER TABLE dynamic_field ADD CONSTRAINT FK_dynamic_field_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2367END IF; 2368END$$; 2369; 2370DO $$ 2371BEGIN 2372IF NOT EXISTS ( 2373 SELECT 1 2374 FROM pg_constraint 2375 WHERE LOWER(conname) = LOWER('FK_dynamic_field_change_by_id') 2376 ) THEN 2377 ALTER TABLE dynamic_field ADD CONSTRAINT FK_dynamic_field_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2378END IF; 2379END$$; 2380; 2381DO $$ 2382BEGIN 2383IF NOT EXISTS ( 2384 SELECT 1 2385 FROM pg_constraint 2386 WHERE LOWER(conname) = LOWER('FK_dynamic_field_valid_id_id') 2387 ) THEN 2388 ALTER TABLE dynamic_field ADD CONSTRAINT FK_dynamic_field_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 2389END IF; 2390END$$; 2391; 2392DO $$ 2393BEGIN 2394IF NOT EXISTS ( 2395 SELECT 1 2396 FROM pg_constraint 2397 WHERE LOWER(conname) = LOWER('FK_pm_process_create_by_id') 2398 ) THEN 2399 ALTER TABLE pm_process ADD CONSTRAINT FK_pm_process_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2400END IF; 2401END$$; 2402; 2403DO $$ 2404BEGIN 2405IF NOT EXISTS ( 2406 SELECT 1 2407 FROM pg_constraint 2408 WHERE LOWER(conname) = LOWER('FK_pm_process_change_by_id') 2409 ) THEN 2410 ALTER TABLE pm_process ADD CONSTRAINT FK_pm_process_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2411END IF; 2412END$$; 2413; 2414DO $$ 2415BEGIN 2416IF NOT EXISTS ( 2417 SELECT 1 2418 FROM pg_constraint 2419 WHERE LOWER(conname) = LOWER('FK_pm_activity_create_by_id') 2420 ) THEN 2421 ALTER TABLE pm_activity ADD CONSTRAINT FK_pm_activity_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2422END IF; 2423END$$; 2424; 2425DO $$ 2426BEGIN 2427IF NOT EXISTS ( 2428 SELECT 1 2429 FROM pg_constraint 2430 WHERE LOWER(conname) = LOWER('FK_pm_activity_change_by_id') 2431 ) THEN 2432 ALTER TABLE pm_activity ADD CONSTRAINT FK_pm_activity_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2433END IF; 2434END$$; 2435; 2436DO $$ 2437BEGIN 2438IF NOT EXISTS ( 2439 SELECT 1 2440 FROM pg_constraint 2441 WHERE LOWER(conname) = LOWER('FK_pm_activity_dialog_create_by_id') 2442 ) THEN 2443 ALTER TABLE pm_activity_dialog ADD CONSTRAINT FK_pm_activity_dialog_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2444END IF; 2445END$$; 2446; 2447DO $$ 2448BEGIN 2449IF NOT EXISTS ( 2450 SELECT 1 2451 FROM pg_constraint 2452 WHERE LOWER(conname) = LOWER('FK_pm_activity_dialog_change_by_id') 2453 ) THEN 2454 ALTER TABLE pm_activity_dialog ADD CONSTRAINT FK_pm_activity_dialog_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2455END IF; 2456END$$; 2457; 2458DO $$ 2459BEGIN 2460IF NOT EXISTS ( 2461 SELECT 1 2462 FROM pg_constraint 2463 WHERE LOWER(conname) = LOWER('FK_pm_transition_create_by_id') 2464 ) THEN 2465 ALTER TABLE pm_transition ADD CONSTRAINT FK_pm_transition_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2466END IF; 2467END$$; 2468; 2469DO $$ 2470BEGIN 2471IF NOT EXISTS ( 2472 SELECT 1 2473 FROM pg_constraint 2474 WHERE LOWER(conname) = LOWER('FK_pm_transition_change_by_id') 2475 ) THEN 2476 ALTER TABLE pm_transition ADD CONSTRAINT FK_pm_transition_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2477END IF; 2478END$$; 2479; 2480DO $$ 2481BEGIN 2482IF NOT EXISTS ( 2483 SELECT 1 2484 FROM pg_constraint 2485 WHERE LOWER(conname) = LOWER('FK_pm_transition_action_create_by_id') 2486 ) THEN 2487 ALTER TABLE pm_transition_action ADD CONSTRAINT FK_pm_transition_action_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2488END IF; 2489END$$; 2490; 2491DO $$ 2492BEGIN 2493IF NOT EXISTS ( 2494 SELECT 1 2495 FROM pg_constraint 2496 WHERE LOWER(conname) = LOWER('FK_pm_transition_action_change_by_id') 2497 ) THEN 2498 ALTER TABLE pm_transition_action ADD CONSTRAINT FK_pm_transition_action_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2499END IF; 2500END$$; 2501; 2502DO $$ 2503BEGIN 2504IF NOT EXISTS ( 2505 SELECT 1 2506 FROM pg_constraint 2507 WHERE LOWER(conname) = LOWER('FK_cloud_service_config_create_by_id') 2508 ) THEN 2509 ALTER TABLE cloud_service_config ADD CONSTRAINT FK_cloud_service_config_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2510END IF; 2511END$$; 2512; 2513DO $$ 2514BEGIN 2515IF NOT EXISTS ( 2516 SELECT 1 2517 FROM pg_constraint 2518 WHERE LOWER(conname) = LOWER('FK_cloud_service_config_change_by_id') 2519 ) THEN 2520 ALTER TABLE cloud_service_config ADD CONSTRAINT FK_cloud_service_config_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2521END IF; 2522END$$; 2523; 2524DO $$ 2525BEGIN 2526IF NOT EXISTS ( 2527 SELECT 1 2528 FROM pg_constraint 2529 WHERE LOWER(conname) = LOWER('FK_cloud_service_config_valid_id_id') 2530 ) THEN 2531 ALTER TABLE cloud_service_config ADD CONSTRAINT FK_cloud_service_config_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 2532END IF; 2533END$$; 2534; 2535DO $$ 2536BEGIN 2537IF NOT EXISTS ( 2538 SELECT 1 2539 FROM pg_constraint 2540 WHERE LOWER(conname) = LOWER('FK_sysconfig_default_create_by_id') 2541 ) THEN 2542 ALTER TABLE sysconfig_default ADD CONSTRAINT FK_sysconfig_default_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2543END IF; 2544END$$; 2545; 2546DO $$ 2547BEGIN 2548IF NOT EXISTS ( 2549 SELECT 1 2550 FROM pg_constraint 2551 WHERE LOWER(conname) = LOWER('FK_sysconfig_default_change_by_id') 2552 ) THEN 2553 ALTER TABLE sysconfig_default ADD CONSTRAINT FK_sysconfig_default_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2554END IF; 2555END$$; 2556; 2557DO $$ 2558BEGIN 2559IF NOT EXISTS ( 2560 SELECT 1 2561 FROM pg_constraint 2562 WHERE LOWER(conname) = LOWER('FK_sysconfig_default_exclusive_lock_user_id_id') 2563 ) THEN 2564 ALTER TABLE sysconfig_default ADD CONSTRAINT FK_sysconfig_default_exclusive_lock_user_id_id FOREIGN KEY (exclusive_lock_user_id) REFERENCES users (id); 2565END IF; 2566END$$; 2567; 2568DO $$ 2569BEGIN 2570IF NOT EXISTS ( 2571 SELECT 1 2572 FROM pg_constraint 2573 WHERE LOWER(conname) = LOWER('FK_sysconfig_default_version_sysconfig_default_id_id') 2574 ) THEN 2575 ALTER TABLE sysconfig_default_version ADD CONSTRAINT FK_sysconfig_default_version_sysconfig_default_id_id FOREIGN KEY (sysconfig_default_id) REFERENCES sysconfig_default (id); 2576END IF; 2577END$$; 2578; 2579DO $$ 2580BEGIN 2581IF NOT EXISTS ( 2582 SELECT 1 2583 FROM pg_constraint 2584 WHERE LOWER(conname) = LOWER('FK_sysconfig_default_version_create_by_id') 2585 ) THEN 2586 ALTER TABLE sysconfig_default_version ADD CONSTRAINT FK_sysconfig_default_version_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2587END IF; 2588END$$; 2589; 2590DO $$ 2591BEGIN 2592IF NOT EXISTS ( 2593 SELECT 1 2594 FROM pg_constraint 2595 WHERE LOWER(conname) = LOWER('FK_sysconfig_default_version_change_by_id') 2596 ) THEN 2597 ALTER TABLE sysconfig_default_version ADD CONSTRAINT FK_sysconfig_default_version_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2598END IF; 2599END$$; 2600; 2601DO $$ 2602BEGIN 2603IF NOT EXISTS ( 2604 SELECT 1 2605 FROM pg_constraint 2606 WHERE LOWER(conname) = LOWER('FK_sysconfig_modified_sysconfig_default_id_id') 2607 ) THEN 2608 ALTER TABLE sysconfig_modified ADD CONSTRAINT FK_sysconfig_modified_sysconfig_default_id_id FOREIGN KEY (sysconfig_default_id) REFERENCES sysconfig_default (id); 2609END IF; 2610END$$; 2611; 2612DO $$ 2613BEGIN 2614IF NOT EXISTS ( 2615 SELECT 1 2616 FROM pg_constraint 2617 WHERE LOWER(conname) = LOWER('FK_sysconfig_modified_user_id_id') 2618 ) THEN 2619 ALTER TABLE sysconfig_modified ADD CONSTRAINT FK_sysconfig_modified_user_id_id FOREIGN KEY (user_id) REFERENCES users (id); 2620END IF; 2621END$$; 2622; 2623DO $$ 2624BEGIN 2625IF NOT EXISTS ( 2626 SELECT 1 2627 FROM pg_constraint 2628 WHERE LOWER(conname) = LOWER('FK_sysconfig_modified_create_by_id') 2629 ) THEN 2630 ALTER TABLE sysconfig_modified ADD CONSTRAINT FK_sysconfig_modified_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2631END IF; 2632END$$; 2633; 2634DO $$ 2635BEGIN 2636IF NOT EXISTS ( 2637 SELECT 1 2638 FROM pg_constraint 2639 WHERE LOWER(conname) = LOWER('FK_sysconfig_modified_change_by_id') 2640 ) THEN 2641 ALTER TABLE sysconfig_modified ADD CONSTRAINT FK_sysconfig_modified_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2642END IF; 2643END$$; 2644; 2645DO $$ 2646BEGIN 2647IF NOT EXISTS ( 2648 SELECT 1 2649 FROM pg_constraint 2650 WHERE LOWER(conname) = LOWER('FK_sysconfig_modified_version_sysconfig_default_version_idaf') 2651 ) THEN 2652 ALTER TABLE sysconfig_modified_version ADD CONSTRAINT FK_sysconfig_modified_version_sysconfig_default_version_idaf FOREIGN KEY (sysconfig_default_version_id) REFERENCES sysconfig_default_version (id); 2653END IF; 2654END$$; 2655; 2656DO $$ 2657BEGIN 2658IF NOT EXISTS ( 2659 SELECT 1 2660 FROM pg_constraint 2661 WHERE LOWER(conname) = LOWER('FK_sysconfig_modified_version_user_id_id') 2662 ) THEN 2663 ALTER TABLE sysconfig_modified_version ADD CONSTRAINT FK_sysconfig_modified_version_user_id_id FOREIGN KEY (user_id) REFERENCES users (id); 2664END IF; 2665END$$; 2666; 2667DO $$ 2668BEGIN 2669IF NOT EXISTS ( 2670 SELECT 1 2671 FROM pg_constraint 2672 WHERE LOWER(conname) = LOWER('FK_sysconfig_modified_version_create_by_id') 2673 ) THEN 2674 ALTER TABLE sysconfig_modified_version ADD CONSTRAINT FK_sysconfig_modified_version_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2675END IF; 2676END$$; 2677; 2678DO $$ 2679BEGIN 2680IF NOT EXISTS ( 2681 SELECT 1 2682 FROM pg_constraint 2683 WHERE LOWER(conname) = LOWER('FK_sysconfig_modified_version_change_by_id') 2684 ) THEN 2685 ALTER TABLE sysconfig_modified_version ADD CONSTRAINT FK_sysconfig_modified_version_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2686END IF; 2687END$$; 2688; 2689DO $$ 2690BEGIN 2691IF NOT EXISTS ( 2692 SELECT 1 2693 FROM pg_constraint 2694 WHERE LOWER(conname) = LOWER('FK_sysconfig_deployment_lock_exclusive_lock_user_id_id') 2695 ) THEN 2696 ALTER TABLE sysconfig_deployment_lock ADD CONSTRAINT FK_sysconfig_deployment_lock_exclusive_lock_user_id_id FOREIGN KEY (exclusive_lock_user_id) REFERENCES users (id); 2697END IF; 2698END$$; 2699; 2700DO $$ 2701BEGIN 2702IF NOT EXISTS ( 2703 SELECT 1 2704 FROM pg_constraint 2705 WHERE LOWER(conname) = LOWER('FK_sysconfig_deployment_user_id_id') 2706 ) THEN 2707 ALTER TABLE sysconfig_deployment ADD CONSTRAINT FK_sysconfig_deployment_user_id_id FOREIGN KEY (user_id) REFERENCES users (id); 2708END IF; 2709END$$; 2710; 2711DO $$ 2712BEGIN 2713IF NOT EXISTS ( 2714 SELECT 1 2715 FROM pg_constraint 2716 WHERE LOWER(conname) = LOWER('FK_sysconfig_deployment_create_by_id') 2717 ) THEN 2718 ALTER TABLE sysconfig_deployment ADD CONSTRAINT FK_sysconfig_deployment_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2719END IF; 2720END$$; 2721; 2722DO $$ 2723BEGIN 2724IF NOT EXISTS ( 2725 SELECT 1 2726 FROM pg_constraint 2727 WHERE LOWER(conname) = LOWER('FK_calendar_group_id_id') 2728 ) THEN 2729 ALTER TABLE calendar ADD CONSTRAINT FK_calendar_group_id_id FOREIGN KEY (group_id) REFERENCES groups (id); 2730END IF; 2731END$$; 2732; 2733DO $$ 2734BEGIN 2735IF NOT EXISTS ( 2736 SELECT 1 2737 FROM pg_constraint 2738 WHERE LOWER(conname) = LOWER('FK_calendar_create_by_id') 2739 ) THEN 2740 ALTER TABLE calendar ADD CONSTRAINT FK_calendar_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2741END IF; 2742END$$; 2743; 2744DO $$ 2745BEGIN 2746IF NOT EXISTS ( 2747 SELECT 1 2748 FROM pg_constraint 2749 WHERE LOWER(conname) = LOWER('FK_calendar_change_by_id') 2750 ) THEN 2751 ALTER TABLE calendar ADD CONSTRAINT FK_calendar_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2752END IF; 2753END$$; 2754; 2755DO $$ 2756BEGIN 2757IF NOT EXISTS ( 2758 SELECT 1 2759 FROM pg_constraint 2760 WHERE LOWER(conname) = LOWER('FK_calendar_valid_id_id') 2761 ) THEN 2762 ALTER TABLE calendar ADD CONSTRAINT FK_calendar_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id); 2763END IF; 2764END$$; 2765; 2766DO $$ 2767BEGIN 2768IF NOT EXISTS ( 2769 SELECT 1 2770 FROM pg_constraint 2771 WHERE LOWER(conname) = LOWER('FK_calendar_appointment_calendar_id_id') 2772 ) THEN 2773 ALTER TABLE calendar_appointment ADD CONSTRAINT FK_calendar_appointment_calendar_id_id FOREIGN KEY (calendar_id) REFERENCES calendar (id); 2774END IF; 2775END$$; 2776; 2777DO $$ 2778BEGIN 2779IF NOT EXISTS ( 2780 SELECT 1 2781 FROM pg_constraint 2782 WHERE LOWER(conname) = LOWER('FK_calendar_appointment_parent_id_id') 2783 ) THEN 2784 ALTER TABLE calendar_appointment ADD CONSTRAINT FK_calendar_appointment_parent_id_id FOREIGN KEY (parent_id) REFERENCES calendar_appointment (id); 2785END IF; 2786END$$; 2787; 2788DO $$ 2789BEGIN 2790IF NOT EXISTS ( 2791 SELECT 1 2792 FROM pg_constraint 2793 WHERE LOWER(conname) = LOWER('FK_calendar_appointment_create_by_id') 2794 ) THEN 2795 ALTER TABLE calendar_appointment ADD CONSTRAINT FK_calendar_appointment_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2796END IF; 2797END$$; 2798; 2799DO $$ 2800BEGIN 2801IF NOT EXISTS ( 2802 SELECT 1 2803 FROM pg_constraint 2804 WHERE LOWER(conname) = LOWER('FK_calendar_appointment_change_by_id') 2805 ) THEN 2806 ALTER TABLE calendar_appointment ADD CONSTRAINT FK_calendar_appointment_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2807END IF; 2808END$$; 2809; 2810DO $$ 2811BEGIN 2812IF NOT EXISTS ( 2813 SELECT 1 2814 FROM pg_constraint 2815 WHERE LOWER(conname) = LOWER('FK_calendar_appointment_ticket_calendar_id_id') 2816 ) THEN 2817 ALTER TABLE calendar_appointment_ticket ADD CONSTRAINT FK_calendar_appointment_ticket_calendar_id_id FOREIGN KEY (calendar_id) REFERENCES calendar (id); 2818END IF; 2819END$$; 2820; 2821DO $$ 2822BEGIN 2823IF NOT EXISTS ( 2824 SELECT 1 2825 FROM pg_constraint 2826 WHERE LOWER(conname) = LOWER('FK_calendar_appointment_ticket_appointment_id_id') 2827 ) THEN 2828 ALTER TABLE calendar_appointment_ticket ADD CONSTRAINT FK_calendar_appointment_ticket_appointment_id_id FOREIGN KEY (appointment_id) REFERENCES calendar_appointment (id); 2829END IF; 2830END$$; 2831; 2832DO $$ 2833BEGIN 2834IF NOT EXISTS ( 2835 SELECT 1 2836 FROM pg_constraint 2837 WHERE LOWER(conname) = LOWER('FK_calendar_appointment_ticket_ticket_id_id') 2838 ) THEN 2839 ALTER TABLE calendar_appointment_ticket ADD CONSTRAINT FK_calendar_appointment_ticket_ticket_id_id FOREIGN KEY (ticket_id) REFERENCES ticket (id); 2840END IF; 2841END$$; 2842; 2843DO $$ 2844BEGIN 2845IF NOT EXISTS ( 2846 SELECT 1 2847 FROM pg_constraint 2848 WHERE LOWER(conname) = LOWER('FK_mail_queue_article_id_id') 2849 ) THEN 2850 ALTER TABLE mail_queue ADD CONSTRAINT FK_mail_queue_article_id_id FOREIGN KEY (article_id) REFERENCES article (id); 2851END IF; 2852END$$; 2853; 2854DO $$ 2855BEGIN 2856IF NOT EXISTS ( 2857 SELECT 1 2858 FROM pg_constraint 2859 WHERE LOWER(conname) = LOWER('FK_communication_log_object_communication_id_id') 2860 ) THEN 2861 ALTER TABLE communication_log_object ADD CONSTRAINT FK_communication_log_object_communication_id_id FOREIGN KEY (communication_id) REFERENCES communication_log (id); 2862END IF; 2863END$$; 2864; 2865DO $$ 2866BEGIN 2867IF NOT EXISTS ( 2868 SELECT 1 2869 FROM pg_constraint 2870 WHERE LOWER(conname) = LOWER('FK_communication_log_object_entry_communication_log_objectaa') 2871 ) THEN 2872 ALTER TABLE communication_log_object_entry ADD CONSTRAINT FK_communication_log_object_entry_communication_log_objectaa FOREIGN KEY (communication_log_object_id) REFERENCES communication_log_object (id); 2873END IF; 2874END$$; 2875; 2876DO $$ 2877BEGIN 2878IF NOT EXISTS ( 2879 SELECT 1 2880 FROM pg_constraint 2881 WHERE LOWER(conname) = LOWER('FK_communication_log_obj_lookup_communication_log_object_i0f') 2882 ) THEN 2883 ALTER TABLE communication_log_obj_lookup ADD CONSTRAINT FK_communication_log_obj_lookup_communication_log_object_i0f FOREIGN KEY (communication_log_object_id) REFERENCES communication_log_object (id); 2884END IF; 2885END$$; 2886; 2887DO $$ 2888BEGIN 2889IF NOT EXISTS ( 2890 SELECT 1 2891 FROM pg_constraint 2892 WHERE LOWER(conname) = LOWER('FK_form_draft_create_by_id') 2893 ) THEN 2894 ALTER TABLE form_draft ADD CONSTRAINT FK_form_draft_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); 2895END IF; 2896END$$; 2897; 2898DO $$ 2899BEGIN 2900IF NOT EXISTS ( 2901 SELECT 1 2902 FROM pg_constraint 2903 WHERE LOWER(conname) = LOWER('FK_form_draft_change_by_id') 2904 ) THEN 2905 ALTER TABLE form_draft ADD CONSTRAINT FK_form_draft_change_by_id FOREIGN KEY (change_by) REFERENCES users (id); 2906END IF; 2907END$$; 2908; 2909