github.com/dolthub/go-mysql-server@v0.18.0/enginetest/scriptgen/setup/scripts/integration_test (about) 1 exec 2 create table T52LX ( 3 id varchar(24) not null, 4 DZLIM varchar(100) not null, 5 F3YUE varchar(1000), 6 PRIMARY KEY (id), 7 UNIQUE KEY VAEXO (DZLIM) 8 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 9 ---- 10 11 exec 12 create table YYBCX ( 13 id varchar(24) not null, 14 ESFVY varchar(100) not null, 15 SL76B varchar(100) not null, 16 GE5EL double, 17 F7A4Q double, 18 TUV25 double, 19 YKSSU varchar(1000), 20 FHCYT varchar(1000), 21 PRIMARY KEY (id), 22 UNIQUE KEY WITSV (ESFVY), 23 UNIQUE KEY CEAF3 (SL76B) 24 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 25 ---- 26 27 exec 28 create table XGSJM ( 29 id varchar(24) not null, 30 DZLIM varchar(100) not null, 31 F3YUE varchar(1000), 32 PRIMARY KEY (id), 33 UNIQUE KEY CQIIE (DZLIM) 34 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 35 ---- 36 37 exec 38 create table WE72E ( 39 id varchar(24) not null, 40 QZ7E7 varchar(100) not null, 41 SSHPJ varchar(100) not null, 42 FHCYT varchar(1000), 43 PRIMARY KEY (id), 44 UNIQUE KEY SOCSM (SSHPJ), 45 UNIQUE KEY LOW5B (QZ7E7) 46 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 47 ---- 48 49 exec 50 create table TNMXI ( 51 id varchar(24) not null, 52 DZLIM varchar(100) not null, 53 F3YUE varchar(1000), 54 PRIMARY KEY (id), 55 UNIQUE KEY TCKRP (DZLIM) 56 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 57 ---- 58 59 exec 60 create table F35MI ( 61 id varchar(24) not null, 62 DZLIM varchar(100) not null, 63 F3YUE varchar(1000), 64 PRIMARY KEY (id), 65 UNIQUE KEY FTWOK (DZLIM) 66 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 67 ---- 68 69 exec 70 create table E2I7U ( 71 id varchar(24) not null, 72 DKCAJ varchar(24) not null, 73 KNG7T varchar(24), 74 TW55N varchar(100) not null, 75 QRQXW double not null, 76 ECXAJ double not null, 77 FGG57 varchar(100), 78 ZH72S varchar(100), 79 FSK67 varchar(100) not null, 80 XQDYT varchar(24) not null, 81 TCE7A double, 82 IWV2H double, 83 HPCMS varchar(24) not null, 84 N5CC2 varchar(1000), 85 FHCYT varchar(1000), 86 ETAQ7 double, 87 A75X7 double, 88 PRIMARY KEY (id), 89 KEY XQDYT (XQDYT), 90 KEY KNG7T (KNG7T), 91 KEY URBSA (ZH72S), 92 KEY HPCMS (HPCMS), 93 KEY DKCAJ (DKCAJ), 94 UNIQUE KEY TKKOQ (FGG57), 95 UNIQUE KEY SFMWS (TW55N), 96 constraint NEPLHKGH foreign key (XQDYT) references XGSJM (id) on delete cascade on update cascade, 97 constraint ZANIGGZJ foreign key (KNG7T) references WE72E (id) on delete cascade on update cascade, 98 constraint GYIuPKNP foreign key (HPCMS) references TNMXI (id) on delete cascade on update cascade, 99 constraint VOLFAYOL foreign key (DKCAJ) references F35MI (id) on delete cascade on update cascade 100 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 101 ---- 102 103 exec 104 create table IIISV ( 105 id varchar(24) not null, 106 DZLIM varchar(100) not null, 107 F3YUE varchar(1000), 108 PRIMARY KEY (id), 109 UNIQUE KEY PGYTV (DZLIM) 110 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 111 ---- 112 113 exec 114 create table ARLV5 ( 115 id varchar(24) not null, 116 LUEVY varchar(24) not null, 117 F6NSZ varchar(24) not null, 118 PRIMARY KEY (id), 119 KEY F6NSZ (F6NSZ), 120 KEY LUEVY (LUEVY), 121 UNIQUE KEY G3AVB (LUEVY, F6NSZ), 122 constraint MPYOIDMG foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade, 123 constraint RMWuWBGS foreign key (F6NSZ) references IIISV (id) on delete cascade on update cascade 124 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 125 ---- 126 127 exec 128 create table EPZU6 ( 129 id varchar(24) not null, 130 TOFPN varchar(100) not null, 131 SJYN2 varchar(100) not null, 132 BTXC5 varchar(100) not null, 133 FVUCX varchar(100) not null, 134 SWCQV int not null, 135 YKSSU varchar(1000), 136 FHCYT varchar(1000), 137 PRIMARY KEY (id), 138 KEY EUOFY (BTXC5), 139 KEY SZ5IY (TOFPN), 140 KEY LJD63 (SJYN2), 141 KEY LP75T (FVUCX) 142 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 143 ---- 144 145 exec 146 create table S3FQX ( 147 id varchar(24) not null, 148 ADWYM tinyint not null, 149 FPUYA tinyint not null, 150 PRIMARY KEY (id) 151 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 152 ---- 153 154 exec 155 create table RLOHD ( 156 id varchar(24) not null, 157 LUEVY varchar(24) not null, 158 LIILR double, 159 KSFXH double, 160 KLMAU double, 161 ecm double, 162 RQI4M varchar(1000), 163 FHCYT varchar(1000), 164 PRIMARY KEY (id), 165 UNIQUE KEY HVHB5 (LUEVY), 166 constraint BPWTWuWC foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade 167 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 168 ---- 169 170 exec 171 create table SFEGG ( 172 id varchar(24) not null, 173 NO52D varchar(100) not null, 174 VYO5E varchar(100), 175 DKCAJ varchar(24) not null, 176 ADURZ int not null, 177 FHCYT varchar(1000), 178 PRIMARY KEY (id), 179 UNIQUE KEY DKRQA (NO52D, VYO5E, DKCAJ), 180 KEY DKCAJ (DKCAJ), 181 constraint TLBCIFRR foreign key (DKCAJ) references F35MI (id) on delete cascade on update cascade 182 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 183 ---- 184 185 exec 186 create table OUBDL ( 187 id varchar(24) not null, 188 FTQLQ varchar(100), 189 ZH72S varchar(200), 190 SFJ6L varchar(2500), 191 V5DPX varchar(100), 192 LJLUM varchar(100), 193 IDPK7 varchar(100), 194 NO52D varchar(100), 195 ZRV3B varchar(100), 196 VYO5E varchar(100), 197 YKSSU text, 198 FHCYT text, 199 QZ6VT varchar(1000), 200 PRIMARY KEY (id), 201 KEY IRMAC (NO52D), 202 KEY SVIT7 (FTQLQ), 203 KEY CZWS6 (V5DPX), 204 KEY JFRPY (ZH72S) 205 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 206 ---- 207 208 exec 209 create table SISUT ( 210 id varchar(24) not null, 211 T4IBQ varchar(100), 212 ZH72S varchar(100), 213 AMYXQ varchar(100), 214 KTNZ2 varchar(100), 215 HIID2 varchar(100), 216 DN3OQ varchar(100), 217 VVKNB varchar(100), 218 SH7TP varchar(100), 219 SRZZO varchar(100), 220 QZ6VT varchar(100), 221 PRIMARY KEY (id), 222 KEY TTQYJ (T4IBQ), 223 KEY Z7LT5 (ZH72S) 224 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 225 ---- 226 227 exec 228 create table NZKPM ( 229 id varchar(24) not null, 230 T4IBQ varchar(100), 231 FGG57 varchar(100), 232 SSHPJ varchar(100), 233 NLA6O varchar(100), 234 SFJ6L varchar(100), 235 TJPT7 varchar(100), 236 ARN5P varchar(200), 237 SYPKF varchar(100), 238 IVFMK varchar(100), 239 IDE43 varchar(500), 240 AZ6SP varchar(500), 241 FSDY2 varchar(100), 242 XOSD4 varchar(200), 243 HMW4H varchar(100), 244 S76OM varchar(100), 245 vaf varchar(100), 246 ZROH6 varchar(100), 247 QCGTS varchar(100), 248 LNFM6 varchar(100), 249 TVAWL varchar(100), 250 HDLCL varchar(100), 251 BHHW6 varchar(100), 252 FHCYT varchar(1000), 253 QZ6VT varchar(1000), 254 PRIMARY KEY (id), 255 KEY UFF3F (T4IBQ), 256 KEY FXQHW (FGG57) 257 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 258 ---- 259 260 exec 261 create table JMRQL ( 262 id varchar(24) not null, 263 DZLIM varchar(100) not null, 264 F3YUE varchar(1000), 265 PRIMARY KEY (id), 266 UNIQUE KEY LYX3G (DZLIM) 267 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 268 ---- 269 270 exec 271 create table SZW6V ( 272 id varchar(24) not null, 273 T4IBQ varchar(100) not null, 274 V7UFH varchar(100) not null, 275 SYPKF varchar(100) not null, 276 H4DMT varchar(100) not null, 277 SWCQV int not null, 278 YKSSU varchar(1000), 279 FHCYT varchar(1000), 280 PRIMARY KEY (id), 281 KEY SPZMU (T4IBQ), 282 KEY GGI5L (SYPKF), 283 KEY UTKLA (V7UFH), 284 KEY EMW6Y (H4DMT) 285 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 286 ---- 287 288 exec 289 create table XOAOP ( 290 id varchar(24) not null, 291 DZLIM varchar(100) not null, 292 F3YUE varchar(1000), 293 PRIMARY KEY (id), 294 UNIQUE KEY THCUL (DZLIM) 295 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 296 ---- 297 298 exec 299 create table JJGQT ( 300 id varchar(24) not null, 301 CH3FR varchar(24) not null, 302 LUEVY varchar(24) not null, 303 PRIMARY KEY (id), 304 KEY CH3FR (CH3FR), 305 UNIQUE KEY QHY76 (LUEVY), 306 constraint DRBJBJAI foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade, 307 constraint HZHLDWSR foreign key (CH3FR) references XOAOP (id) on delete cascade on update cascade 308 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 309 ---- 310 311 exec 312 create table TPXHZ ( 313 id varchar(24) not null, 314 SVAZ4 varchar(100) not null, 315 PRIMARY KEY (id), 316 UNIQUE KEY SVAZ4 (SVAZ4) 317 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 318 ---- 319 320 exec 321 create table YK2GW ( 322 id varchar(24) not null, 323 FTQLQ varchar(100) not null, 324 TUXML varchar(100), 325 PAEF5 varchar(100), 326 RUCY4 varchar(100), 327 TPNJ6 varchar(100) not null, 328 LBL53 varchar(100), 329 NB3QS varchar(100), 330 EO7IV varchar(100), 331 MUHJF varchar(100), 332 FM34L text, 333 TY5RF text, 334 ZHTLH text, 335 NPB7W text, 336 SX3HH text, 337 ISBNF text, 338 YA7YB text, 339 C5YKB text, 340 QK7KT text, 341 FFGE6 text, 342 FIIGJ text, 343 SH3NC text, 344 NTENA text, 345 M4AUB text, 346 X5AIR text, 347 SAB6M text, 348 G5QI5 text, 349 ZVQVD text, 350 YKSSU varchar(1000), 351 FHCYT varchar(1000), 352 PRIMARY KEY (id), 353 KEY TU5AX (LBL53), 354 KEY C7DFM (NB3QS), 355 KEY NFJNB (EO7IV), 356 KEY TWFWA (MUHJF), 357 UNIQUE KEY FEGLT (PAEF5), 358 UNIQUE KEY T3X5H (TUXML), 359 UNIQUE KEY EZCTT (FTQLQ) 360 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 361 ---- 362 363 exec 364 create table IJLXP ( 365 id varchar(24) not null, 366 WZP3R varchar(100) not null, 367 IXUXU varchar(24) not null, 368 PRIMARY KEY (id), 369 KEY IXUXU (IXUXU), 370 UNIQUE KEY IFQUF (WZP3R, IXUXU), 371 constraint YWSOXPJG foreign key (IXUXU) references YK2GW (id) on delete cascade on update cascade 372 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 373 ---- 374 375 exec 376 create table HU5A5 ( 377 id varchar(24) not null, 378 TOFPN varchar(100) not null, 379 I3VTA varchar(200) not null, 380 SFJ6L varchar(2500), 381 V5DPX varchar(100) not null, 382 LJLUM varchar(100) not null, 383 IDPK7 varchar(100) not null, 384 NO52D varchar(100) not null, 385 ZRV3B varchar(100) not null, 386 VYO5E varchar(100), 387 SWCQV int not null, 388 YKSSU varchar(1000), 389 FHCYT varchar(1000), 390 PRIMARY KEY (id), 391 KEY UYQR2 (TOFPN), 392 KEY Z2WXS (I3VTA) 393 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 394 ---- 395 396 exec 397 create table JDLNA ( 398 id varchar(24) not null, 399 FTQLQ varchar(100) not null, 400 FWWIQ varchar(100), 401 O3QXW varchar(100), 402 FHCYT text, 403 PRIMARY KEY (id), 404 UNIQUE KEY XDW7Z (FTQLQ) 405 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 406 ---- 407 408 exec 409 create table FCBVZ ( 410 id varchar(24) not null, 411 FZ2R5 varchar(24) not null, 412 J6B7H double not null, 413 BMNNY double not null, 414 PRIMARY KEY (id), 415 UNIQUE KEY IC4BT (FZ2R5), 416 constraint XDGOFPLT foreign key (FZ2R5) references JDLNA (id) on delete cascade on update cascade 417 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 418 ---- 419 420 exec 421 create table IMJ6V ( 422 id varchar(24) not null, 423 FTQLQ varchar(100), 424 BACOW varchar(100), 425 PRIMARY KEY (id), 426 KEY EUAEL (BACOW), 427 KEY C7XE4 (FTQLQ) 428 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 429 ---- 430 431 exec 432 create table TPXBU ( 433 id varchar(24) not null, 434 BTXC5 varchar(100), 435 FHCYT varchar(1000), 436 PRIMARY KEY (id), 437 UNIQUE KEY UZ6GK (BTXC5) 438 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 439 ---- 440 441 exec 442 create table THNTS ( 443 id varchar(24) not null, 444 NFRYN varchar(24) not null, 445 IXUXU varchar(24), 446 FHCYT varchar(1000), 447 PRIMARY KEY (id), 448 KEY NFRYN (NFRYN), 449 KEY IXUXU (IXUXU), 450 constraint PVRKLKKQ foreign key (NFRYN) references JMRQL (id) on delete cascade on update cascade, 451 constraint uIRGWEWQ foreign key (IXUXU) references YK2GW (id) on delete cascade on update cascade 452 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 453 ---- 454 455 exec 456 create table HGMQ6 ( 457 id varchar(24) not null, 458 GXLUB varchar(24) not null, 459 LUEVY varchar(24) not null, 460 M22QN varchar(24) not null, 461 TJPT7 varchar(100) not null, 462 ARN5P varchar(200) not null, 463 XOSD4 varchar(200) not null, 464 IDE43 varchar(500), 465 HMW4H varchar(100), 466 ZBT6R int, 467 FSDY2 varchar(100) not null, 468 LT7K6 double, 469 SPPYD double, 470 QCGTS double, 471 TEUJA varchar(24), 472 QQV4M varchar(24), 473 FHCYT varchar(1000), 474 PRIMARY KEY (id), 475 KEY M22QN (M22QN), 476 KEY GXLUB (GXLUB), 477 KEY QQV4M (QQV4M), 478 KEY LUEVY (LUEVY), 479 KEY TEUJA (TEUJA), 480 constraint ZTDIWKIu foreign key (TEUJA) references NZKPM (id) on delete cascade on update cascade, 481 constraint OPENAEGM foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade, 482 constraint GRXCIZOK foreign key (QQV4M) references SZW6V (id) on delete cascade on update cascade, 483 constraint VMJAAVNQ foreign key (M22QN) references TPXBU (id) on delete cascade on update cascade, 484 constraint XOVPPACH foreign key (GXLUB) references THNTS (id) on delete cascade on update cascade 485 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 486 ---- 487 488 exec 489 create table D34QP ( 490 id varchar(24) not null, 491 TWMSR varchar(100) not null, 492 QHMGE varchar(1000), 493 MLNPU varchar(100) not null, 494 FI3GA varchar(100) not null, 495 ZNP4P varchar(100) not null, 496 PRIMARY KEY (id), 497 UNIQUE KEY LZLGJ (FI3GA), 498 UNIQUE KEY F2C6B (TWMSR) 499 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 500 ---- 501 502 exec 503 create table SEQS3 ( 504 id varchar(24) not null, 505 Z7CP5 varchar(24) not null, 506 YH4XB varchar(24) not null, 507 PRIMARY KEY (id), 508 KEY Z7CP5 (Z7CP5), 509 UNIQUE KEY SQKGT (Z7CP5, YH4XB), 510 KEY YH4XB (YH4XB), 511 constraint OCPWMCFX foreign key (YH4XB) references D34QP (id) on delete cascade on update cascade, 512 constraint CROMXATM foreign key (Z7CP5) references HGMQ6 (id) on delete cascade on update cascade 513 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 514 ---- 515 516 exec 517 create table FEVH4 ( 518 id varchar(24) not null, 519 DZLIM varchar(100) not null, 520 F3YUE varchar(1000), 521 PRIMARY KEY (id), 522 UNIQUE KEY QPADP (DZLIM) 523 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 524 ---- 525 526 exec 527 create table NOXN3 ( 528 id varchar(24) not null, 529 BRQP2 varchar(24) not null, 530 FFTBJ varchar(24) not null, 531 A7XO2 varchar(24), 532 KBO7R double not null, 533 ECDKM double, 534 NUMK2 int not null, 535 LETOE int not null, 536 YKSSU varchar(1000), 537 FHCYT varchar(1000), 538 PRIMARY KEY (id), 539 KEY A7XO2 (A7XO2), 540 KEY BRQP2 (BRQP2), 541 KEY FFTBJ (FFTBJ), 542 constraint YHuJBJOA foreign key (BRQP2) references E2I7U (id) on delete cascade on update cascade, 543 constraint MZZLFWKV foreign key (FFTBJ) references E2I7U (id) on delete cascade on update cascade, 544 constraint OOIIJMRS foreign key (A7XO2) references FEVH4 (id) on delete cascade on update cascade 545 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 546 ---- 547 548 exec 549 create table FLQLP ( 550 id varchar(24) not null, 551 FZ2R5 varchar(24) not null, 552 LUEVY varchar(24) not null, 553 M22QN varchar(24) not null, 554 OVE3E varchar(24) not null, 555 NRURT varchar(24), 556 OCA7E varchar(24), 557 XMM6Q varchar(24), 558 V5DPX varchar(100) not null, 559 S3Q3Y double not null, 560 ZRV3B varchar(100) not null, 561 FHCYT text, 562 PRIMARY KEY (id), 563 KEY M22QN (M22QN), 564 KEY XMM6Q (XMM6Q), 565 KEY OCA7E (OCA7E), 566 KEY OVE3E (OVE3E), 567 KEY FZ2R5 (FZ2R5), 568 KEY LUEVY (LUEVY), 569 KEY NRURT (NRURT), 570 constraint RSSVKRQV foreign key (OVE3E) references SFEGG (id) on delete cascade on update cascade, 571 constraint EXBYRKVB foreign key (XMM6Q) references HU5A5 (id) on delete cascade on update cascade, 572 constraint HCEKFTJK foreign key (M22QN) references TPXBU (id) on delete cascade on update cascade, 573 constraint KWNRRXuP foreign key (NRURT) references OUBDL (id) on delete cascade on update cascade, 574 constraint RQuDOGQu foreign key (OCA7E) references EPZU6 (id) on delete cascade on update cascade, 575 constraint uIRDRBRV foreign key (FZ2R5) references JDLNA (id) on delete cascade on update cascade, 576 constraint MSMuETPN foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade 577 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 578 ---- 579 580 exec 581 create table AMYXQ ( 582 id varchar(24) not null, 583 GXLUB varchar(24) not null, 584 LUEVY varchar(24) not null, 585 XQDYT varchar(24) not null, 586 AMYXQ double not null, 587 OZTQF double not null, 588 Z35GY double not null, 589 KKGN5 varchar(24), 590 PRIMARY KEY (id), 591 KEY GXLUB (GXLUB), 592 KEY XQDYT (XQDYT), 593 KEY LUEVY (LUEVY), 594 UNIQUE KEY VN3QP (GXLUB, LUEVY), 595 KEY KKGN5 (KKGN5), 596 constraint AVDTHRGA foreign key (XQDYT) references XGSJM (id) on delete cascade on update cascade, 597 constraint TTJXJHYD foreign key (GXLUB) references THNTS (id) on delete cascade on update cascade, 598 constraint uVMOASBI foreign key (KKGN5) references SISUT (id) on delete cascade on update cascade, 599 constraint RYPGYAZH foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade 600 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 601 ---- 602 603 exec 604 create table ZTFET ( 605 id varchar(24) not null, 606 CYZU6 varchar(200) not null, 607 AERTL varchar(200) not null, 608 PMM7A tinyint not null, 609 SIJCN varchar(200) not null, 610 RTLWN varchar(200) not null, 611 ZMABC varchar(200) not null, 612 W3GHO text not null, 613 U7IJ3 text, 614 PRIMARY KEY (id), 615 UNIQUE KEY CIMX7 (CYZU6, AERTL), 616 KEY BRPXE (CYZU6), 617 KEY SSO2T (AERTL) 618 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 619 ---- 620 621 exec 622 create table WRZVO ( 623 id varchar(24) not null, 624 TVNW2 varchar(100), 625 ZHITY varchar(100), 626 SYPKF varchar(100), 627 IDUT2 varchar(200), 628 O6QJ3 varchar(1000), 629 NO2JA varchar(1000), 630 YKSSU text, 631 FHCYT text, 632 QZ6VT varchar(1000), 633 PRIMARY KEY (id), 634 KEY QKJKS (SYPKF), 635 KEY GAG3S (TVNW2), 636 KEY JH666 (ZHITY) 637 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 638 ---- 639 640 exec 641 create table WGSDC ( 642 id varchar(24) not null, 643 NOHHR varchar(100) not null, 644 AVPYF varchar(100) not null, 645 SYPKF varchar(100) not null, 646 IDUT2 varchar(200) not null, 647 FZXV5 varchar(100), 648 DQYGV varchar(100), 649 SWCQV int not null, 650 YKSSU varchar(1000), 651 FHCYT varchar(1000), 652 PRIMARY KEY (id), 653 KEY X6K5N (IDUT2), 654 KEY M5B5R (SYPKF), 655 KEY XW5IP (NOHHR), 656 KEY F7H3Y (AVPYF), 657 KEY T65YI (FZXV5), 658 KEY XRKQ4 (DQYGV) 659 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 660 ---- 661 662 exec 663 create table HDDVB ( 664 id varchar(24) not null, 665 FV24E varchar(24) not null, 666 UJ6XY varchar(24) not null, 667 M22QN varchar(24) not null, 668 NZ4MQ varchar(24) not null, 669 ETPQV varchar(24), 670 PRUV2 varchar(24), 671 YKSSU varchar(1000), 672 FHCYT varchar(1000), 673 PRIMARY KEY (id), 674 KEY M22QN (M22QN), 675 KEY PRUV2 (PRUV2), 676 KEY NZ4MQ (NZ4MQ), 677 KEY FV24E (FV24E), 678 KEY UJ6XY (UJ6XY), 679 KEY ETPQV (ETPQV), 680 constraint XDHAOISE foreign key (NZ4MQ) references YYBCX (id) on delete cascade on update cascade, 681 constraint CYXIDCXY foreign key (FV24E) references E2I7U (id) on delete cascade on update cascade, 682 constraint ZKROQGGX foreign key (ETPQV) references WRZVO (id) on delete cascade on update cascade, 683 constraint NTEDELZZ foreign key (PRUV2) references WGSDC (id) on delete cascade on update cascade, 684 constraint QCVKLYAS foreign key (UJ6XY) references E2I7U (id) on delete cascade on update cascade, 685 constraint LOQSITZQ foreign key (M22QN) references TPXBU (id) on delete cascade on update cascade 686 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 687 ---- 688 689 exec 690 create table PG27A ( 691 id varchar(24) not null, 692 DZLIM varchar(100) not null, 693 F3YUE varchar(1000), 694 PRIMARY KEY (id), 695 UNIQUE KEY S4YPB (DZLIM) 696 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 697 ---- 698 699 exec 700 create table NPCYY ( 701 id varchar(24) not null, 702 CH3FR varchar(24) not null, 703 XVSBH varchar(24), 704 B5OUF int, 705 PRIMARY KEY (id), 706 KEY CH3FR (CH3FR), 707 KEY XVSBH (XVSBH), 708 UNIQUE KEY S2DGA (CH3FR, XVSBH), 709 constraint LKKuNSTQ foreign key (CH3FR) references XOAOP (id) on delete cascade on update cascade, 710 constraint ZDHFJuOJ foreign key (XVSBH) references PG27A (id) on delete cascade on update cascade 711 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 712 ---- 713 714 exec 715 create table SR2I6 ( 716 id varchar(24) not null, 717 A7XO2 varchar(24) not null, 718 SSWZH varchar(24) not null, 719 PRIMARY KEY (id), 720 KEY SSWZH (SSWZH), 721 KEY A7XO2 (A7XO2), 722 UNIQUE KEY ZKOHZ (A7XO2, SSWZH), 723 constraint LXOBZQWX foreign key (A7XO2) references FEVH4 (id) on delete cascade on update cascade, 724 constraint PDDMDJJW foreign key (SSWZH) references T52LX (id) on delete cascade on update cascade 725 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 726 ---- 727 728 exec 729 create table TTGWX ( 730 id varchar(24) not null, 731 LUEVY varchar(24) not null, 732 CBVKT varchar(100) not null, 733 PRIMARY KEY (id), 734 KEY F7YYM (LUEVY), 735 UNIQUE KEY GKL7R (CBVKT), 736 constraint GWWPGJWX foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade 737 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 738 ---- 739 740 exec 741 create table TDRVG ( 742 id varchar(24) not null, 743 FGG57 varchar(100) not null, 744 SSHPJ varchar(100) not null, 745 SFJ6L varchar(100) not null, 746 ZH72S varchar(100) not null, 747 PRIMARY KEY (id), 748 KEY P62K5 (SSHPJ), 749 KEY XEGEF (SFJ6L), 750 KEY WJM3Z (ZH72S), 751 UNIQUE KEY TK2R2 (FGG57) 752 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 753 ---- 754 755 exec 756 create table ZYGMF ( 757 id varchar(24) not null, 758 DZLIM varchar(100) not null, 759 F3YUE varchar(1000), 760 PRIMARY KEY (id), 761 UNIQUE KEY JVSQT (DZLIM) 762 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 763 ---- 764 765 exec 766 create table FG26Y ( 767 id varchar(24) not null, 768 T4IBQ varchar(100), 769 ner varchar(100), 770 ber varchar(100), 771 hr varchar(100), 772 mmr varchar(100), 773 QZ6VT varchar(1000), 774 PRIMARY KEY (id), 775 KEY SPAIF (T4IBQ) 776 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 777 ---- 778 779 exec 780 create table SZQWJ ( 781 id varchar(24) not null, 782 GXLUB varchar(24) not null, 783 CH3FR varchar(24) not null, 784 D237E int not null, 785 JOGI6 varchar(24), 786 PRIMARY KEY (id), 787 KEY GXLUB (GXLUB), 788 KEY CH3FR (CH3FR), 789 UNIQUE KEY ZRLKW (GXLUB, CH3FR), 790 KEY JOGI6 (JOGI6), 791 constraint TJNEMQOD foreign key (GXLUB) references THNTS (id) on delete cascade on update cascade, 792 constraint HWEBZOML foreign key (CH3FR) references XOAOP (id) on delete cascade on update cascade, 793 constraint XVMMFQXM foreign key (JOGI6) references FG26Y (id) on delete cascade on update cascade 794 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 795 ---- 796 797 exec 798 create table QYWQD ( 799 id varchar(24) not null, 800 WNUNU varchar(24) not null, 801 HHVLX varchar(24) not null, 802 HVHRZ double not null, 803 YKSSU varchar(1000), 804 FHCYT varchar(1000), 805 PRIMARY KEY (id), 806 KEY HHVLX (HHVLX), 807 KEY WNUNU (WNUNU), 808 constraint DSGZOCYH foreign key (HHVLX) references NOXN3 (id) on delete cascade on update cascade, 809 constraint ZWNuDBuB foreign key (WNUNU) references NOXN3 (id) on delete cascade on update cascade 810 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 811 ---- 812 813 exec 814 create table I66GN ( 815 id varchar(24) not null, 816 FZ2R5 varchar(24), 817 GJBJC varchar(24), 818 PRIMARY KEY (id), 819 KEY FZ2R5 (FZ2R5), 820 UNIQUE KEY TBOZS (FZ2R5, GJBJC), 821 KEY GJBJC (GJBJC), 822 constraint RHXJuQZJ foreign key (FZ2R5) references JDLNA (id) on delete cascade on update cascade, 823 constraint OOTILHEG foreign key (GJBJC) references ZYGMF (id) on delete cascade on update cascade 824 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 825 ---- 826 827 exec 828 create table BACOW ( 829 id varchar(24) not null, 830 WZP3R varchar(100) not null, 831 FZ2R5 varchar(24) not null, 832 PRIMARY KEY (id), 833 KEY FZ2R5 (FZ2R5), 834 UNIQUE KEY CYVZQ (WZP3R), 835 constraint NDCWQFVN foreign key (FZ2R5) references JDLNA (id) on delete cascade on update cascade 836 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 837 ---- 838 839 exec 840 create table moa ( 841 id varchar(24) not null, 842 DZLIM varchar(100) not null, 843 F3YUE varchar(1000), 844 PRIMARY KEY (id), 845 UNIQUE KEY TTHMB (DZLIM) 846 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 847 ---- 848 849 exec 850 create table TA5EB ( 851 id varchar(24) not null, 852 V34C7 varchar(24) not null, 853 GJBJC varchar(24) not null, 854 PRIMARY KEY (id), 855 KEY V34C7 (V34C7), 856 KEY GJBJC (GJBJC), 857 UNIQUE KEY B3QPZ (V34C7, GJBJC), 858 constraint HBCXAVLB foreign key (GJBJC) references ZYGMF (id) on delete cascade on update cascade, 859 constraint ZLSVFLDM foreign key (V34C7) references moa (id) on delete cascade on update cascade 860 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 861 ---- 862 863 exec 864 create table NMYH3 ( 865 id varchar(24) not null, 866 FTQLQ varchar(100), 867 RCRDD varchar(100), 868 FWWIQ varchar(100), 869 O3QXW varchar(100), 870 FHCYT text, 871 PRIMARY KEY (id), 872 KEY DQQLF (FTQLQ) 873 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 874 ---- 875 876 exec 877 create table FEIOE ( 878 id varchar(24) not null, 879 LUEVY varchar(24) not null, 880 GMSGA varchar(24) not null, 881 FVGD2 int not null, 882 YP2CR int not null, 883 TQ7W3 int not null, 884 PRIMARY KEY (id), 885 KEY LUEVY (LUEVY), 886 KEY GMSGA (GMSGA), 887 UNIQUE KEY A7XUS (LUEVY, GMSGA), 888 constraint ILKPBIJV foreign key (GMSGA) references NPCYY (id) on delete cascade on update cascade, 889 constraint GDBYYSTF foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade 890 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 891 ---- 892 893 exec 894 create table FBPKL ( 895 id varchar(24) not null, 896 V34C7 varchar(24) not null, 897 CH3FR varchar(24) not null, 898 PRIMARY KEY (id), 899 KEY V34C7 (V34C7), 900 KEY CH3FR (CH3FR), 901 UNIQUE KEY ANGG7 (V34C7, CH3FR), 902 constraint AJZVSJXW foreign key (CH3FR) references XOAOP (id) on delete cascade on update cascade, 903 constraint ZFEIKGRF foreign key (V34C7) references moa (id) on delete cascade on update cascade 904 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin; 905 ---- 906 907 exec 908 analyze table TPXBU update histogram on (id) using data '{"row_count": 123867}'; 909 ---- 910 911 exec 912 analyze table THNTS update histogram on (id) using data '{"row_count": 2498}'; 913 ---- 914 915 exec 916 analyze table JMRQL update histogram on (id) using data '{"row_count": 3}'; 917 ---- 918 919 exec 920 analyze table YK2GW update histogram on (id) using data '{"row_count": 2498}'; 921 ---- 922 923 exec 924 analyze table IJLXP update histogram on (id) using data '{"row_count": 5661}'; 925 ---- 926 927 exec 928 analyze table HU5A5 update histogram on (id) using data '{"row_count": 34}'; 929 ---- 930 931 exec 932 analyze table EPZU6 update histogram on (id) using data '{"row_count": 213}'; 933 ---- 934 935 exec 936 analyze table WGSDC update histogram on (id) using data '{"row_count": 68}'; 937 ---- 938 939 exec 940 analyze table SZW6V update histogram on (id) using data '{"row_count": 1}'; 941 ---- 942 943 exec 944 analyze table SFEGG update histogram on (id) using data '{"row_count": 380}'; 945 ---- 946 947 exec 948 analyze table JDLNA update histogram on (id) using data '{"row_count": 399}'; 949 ---- 950 951 exec 952 analyze table I66GN update histogram on (id) using data '{"row_count": 239}'; 953 ---- 954 955 exec 956 analyze table BACOW update histogram on (id) using data '{"row_count": 5148}'; 957 ---- 958 959 exec 960 analyze table FLQLP update histogram on (id) using data '{"row_count": 14781}'; 961 ---- 962 963 exec 964 analyze table S3FQX update histogram on (id) using data '{"row_count": 1}'; 965 ---- 966 967 exec 968 analyze table JJGQT update histogram on (id) using data '{"row_count": 6}'; 969 ---- 970 971 exec 972 analyze table AMYXQ update histogram on (id) using data '{"row_count": 4786678}'; 973 ---- 974 975 exec 976 analyze table XGSJM update histogram on (id) using data '{"row_count": 5}'; 977 ---- 978 979 exec 980 analyze table WE72E update histogram on (id) using data '{"row_count": 3181}'; 981 ---- 982 983 exec 984 analyze table FCBVZ update histogram on (id) using data '{"row_count": 0}'; 985 ---- 986 987 exec 988 analyze table RLOHD update histogram on (id) using data '{"row_count": 226}'; 989 ---- 990 991 exec 992 analyze table T52LX update histogram on (id) using data '{"row_count": 10}'; 993 ---- 994 995 exec 996 analyze table HDDVB update histogram on (id) using data '{"row_count": 1112}'; 997 ---- 998 999 exec 1000 analyze table YYBCX update histogram on (id) using data '{"row_count": 12}'; 1001 ---- 1002 1003 exec 1004 analyze table FEVH4 update histogram on (id) using data '{"row_count": 56}'; 1005 ---- 1006 1007 exec 1008 analyze table SR2I6 update histogram on (id) using data '{"row_count": 71}'; 1009 ---- 1010 1011 exec 1012 analyze table NMYH3 update histogram on (id) using data '{"row_count": 415}'; 1013 ---- 1014 1015 exec 1016 analyze table IMJ6V update histogram on (id) using data '{"row_count": 6140}'; 1017 ---- 1018 1019 exec 1020 analyze table TDRVG update histogram on (id) using data '{"row_count": 47285}'; 1021 ---- 1022 1023 exec 1024 analyze table IIISV update histogram on (id) using data '{"row_count": 13}'; 1025 ---- 1026 1027 exec 1028 analyze table moa update histogram on (id) using data '{"row_count": 36}'; 1029 ---- 1030 1031 exec 1032 analyze table FBPKL update histogram on (id) using data '{"row_count": 60}'; 1033 ---- 1034 1035 exec 1036 analyze table TA5EB update histogram on (id) using data '{"row_count": 70}'; 1037 ---- 1038 1039 exec 1040 analyze table HGMQ6 update histogram on (id) using data '{"row_count": 511969}'; 1041 ---- 1042 1043 exec 1044 analyze table SEQS3 update histogram on (id) using data '{"row_count": 535843}'; 1045 ---- 1046 1047 exec 1048 analyze table SZQWJ update histogram on (id) using data '{"row_count": 3936}'; 1049 ---- 1050 1051 exec 1052 analyze table E2I7U update histogram on (id) using data '{"row_count": 3842}'; 1053 ---- 1054 1055 exec 1056 analyze table ARLV5 update histogram on (id) using data '{"row_count": 291}'; 1057 ---- 1058 1059 exec 1060 analyze table FEIOE update histogram on (id) using data '{"row_count": 6367}'; 1061 ---- 1062 1063 exec 1064 analyze table TNMXI update histogram on (id) using data '{"row_count": 5}'; 1065 ---- 1066 1067 exec 1068 analyze table F35MI update histogram on (id) using data '{"row_count": 5}'; 1069 ---- 1070 1071 exec 1072 analyze table XOAOP update histogram on (id) using data '{"row_count": 74}'; 1073 ---- 1074 1075 exec 1076 analyze table PG27A update histogram on (id) using data '{"row_count": 11}'; 1077 ---- 1078 1079 exec 1080 analyze table NPCYY update histogram on (id) using data '{"row_count": 89}'; 1081 ---- 1082 1083 exec 1084 analyze table TTGWX update histogram on (id) using data '{"row_count": 3}'; 1085 ---- 1086 1087 exec 1088 analyze table QYWQD update histogram on (id) using data '{"row_count": 70692}'; 1089 ---- 1090 1091 exec 1092 analyze table NOXN3 update histogram on (id) using data '{"row_count": 11813}'; 1093 ---- 1094 1095 exec 1096 analyze table ZYGMF update histogram on (id) using data '{"row_count": 81}'; 1097 ---- 1098 1099 exec 1100 analyze table TPXHZ update histogram on (id) using data '{"row_count": 16}'; 1101 ---- 1102 1103 exec 1104 analyze table OUBDL update histogram on (id) using data '{"row_count": 18395}'; 1105 ---- 1106 1107 exec 1108 analyze table SISUT update histogram on (id) using data '{"row_count": 103907130}'; 1109 ---- 1110 1111 exec 1112 analyze table WRZVO update histogram on (id) using data '{"row_count": 39091}'; 1113 ---- 1114 1115 exec 1116 analyze table NZKPM update histogram on (id) using data '{"row_count": 18779716}'; 1117 ---- 1118 1119 exec 1120 analyze table FG26Y update histogram on (id) using data '{"row_count": 1001}'; 1121 ---- 1122 1123 exec 1124 analyze table D34QP update histogram on (id) using data '{"row_count": 36}'; 1125 ---- 1126 1127 exec 1128 analyze table ZTFET update histogram on (id) using data '{"row_count": 64}'; 1129 ---- 1130 1131 exec 1132 CREATE TRIGGER SZW6V_on_insert BEFORE INSERT ON SZW6V 1133 FOR EACH ROW 1134 BEGIN 1135 IF 1136 NEW.T4IBQ IN (SELECT SVAZ4 FROM TPXHZ) 1137 OR 1138 NEW.V7UFH IN (SELECT SVAZ4 FROM TPXHZ) 1139 OR 1140 NEW.SYPKF IN (SELECT SVAZ4 FROM TPXHZ) 1141 OR 1142 NEW.H4DMT IN (SELECT SVAZ4 FROM TPXHZ) 1143 THEN 1144 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1145 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1146 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1147 END IF; 1148 IF NEW.SWCQV NOT IN (0, 1) 1149 THEN 1150 -- SET @custom_error_message = 'The SWCQV field is an int boolean (0/1) meaning if record is fully SWCQV.'; 1151 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1152 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The SWCQV field is an int boolean (0/1) meaning if fully SWCQV.'; 1153 END IF; 1154 UPDATE S3FQX SET ADWYM = 1; 1155 END// 1156 ---- 1157 1158 exec 1159 CREATE TRIGGER SZW6V_on_update BEFORE UPDATE ON SZW6V 1160 FOR EACH ROW 1161 BEGIN 1162 IF 1163 NEW.T4IBQ IS NOT NULL AND (NEW.T4IBQ <> OLD.T4IBQ) 1164 OR 1165 NEW.V7UFH IS NOT NULL AND (NEW.V7UFH <> OLD.V7UFH) 1166 OR 1167 NEW.SYPKF IS NOT NULL AND (NEW.SYPKF <> OLD.SYPKF) 1168 THEN 1169 -- SET @custom_error_message = 'The fields identifying what to override can not be changed! Please use the ignore field and create new one if necessary.'; 1170 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1171 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The fields identifying what to override can not be changed! Please use the ignore field and create new one if necessary.'; 1172 END IF; 1173 IF 1174 NEW.H4DMT IN (SELECT SVAZ4 FROM TPXHZ) 1175 THEN 1176 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1177 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1178 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1179 END IF; 1180 IF NEW.SWCQV NOT IN (0, 1) 1181 THEN 1182 -- SET @custom_error_message = 'The SWCQV field is an int boolean (0/1) meaning if record is fully SWCQV.'; 1183 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1184 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The SWCQV field is an int boolean (0/1) meaning if fully SWCQV.'; 1185 END IF; 1186 UPDATE S3FQX SET ADWYM = 1; 1187 END// 1188 ---- 1189 1190 exec 1191 CREATE TRIGGER SZW6V_on_delete BEFORE DELETE ON SZW6V 1192 FOR EACH ROW 1193 BEGIN 1194 -- SET @custom_error_message = 'Deletion is forbidden from override and additional tables. Please use the SWCQV field instead.'; 1195 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1196 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Deletion is forbidden from override and additional tables. Please use the SWCQV field instead.'; 1197 END// 1198 ---- 1199 1200 exec 1201 CREATE TRIGGER WGSDC_on_insert BEFORE INSERT ON WGSDC 1202 FOR EACH ROW 1203 BEGIN 1204 IF 1205 NEW.NOHHR IN (SELECT SVAZ4 FROM TPXHZ) 1206 OR 1207 NEW.AVPYF IN (SELECT SVAZ4 FROM TPXHZ) 1208 OR 1209 NEW.SYPKF IN (SELECT SVAZ4 FROM TPXHZ) 1210 OR 1211 NEW.IDUT2 IN (SELECT SVAZ4 FROM TPXHZ) 1212 OR 1213 NEW.FZXV5 IN (SELECT SVAZ4 FROM TPXHZ) 1214 OR 1215 NEW.DQYGV IN (SELECT SVAZ4 FROM TPXHZ) 1216 THEN 1217 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1218 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1219 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1220 END IF; 1221 IF NEW.SWCQV NOT IN (0, 1) 1222 THEN 1223 -- SET @custom_error_message = 'The SWCQV field is an int boolean (0/1) meaning if record is fully SWCQV.'; 1224 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1225 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The SWCQV field is an int boolean (0/1) meaning if fully SWCQV.'; 1226 END IF; 1227 IF NEW.FZXV5 IS NULL AND NEW.DQYGV IS NULL 1228 THEN 1229 -- SET @custom_error_message = 'Either the mutant or partner overridden field must have value!'; 1230 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1231 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Either the mutant or partner overridden field must have value!'; 1232 END IF; 1233 IF NEW.FZXV5 IS NOT NULL AND NEW.DQYGV IS NOT NULL 1234 THEN 1235 -- SET @custom_error_message = 'Only one of the mutant or partner overridden field can have value!'; 1236 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1237 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Only one of the mutant or partner overridden field can have value!'; 1238 END IF; 1239 UPDATE S3FQX SET ADWYM = 1; 1240 END// 1241 ---- 1242 1243 exec 1244 CREATE TRIGGER WGSDC_on_update BEFORE UPDATE ON WGSDC 1245 FOR EACH ROW 1246 BEGIN 1247 IF 1248 NEW.NOHHR IS NOT NULL AND (NEW.NOHHR <> OLD.NOHHR) 1249 OR 1250 NEW.AVPYF IS NOT NULL AND (NEW.AVPYF <> OLD.AVPYF) 1251 OR 1252 NEW.SYPKF IS NOT NULL AND (NEW.SYPKF <> OLD.SYPKF) 1253 OR 1254 NEW.IDUT2 IS NOT NULL AND (NEW.IDUT2 <> OLD.IDUT2) 1255 THEN 1256 -- SET @custom_error_message = 'The fields identifying what to override can not be changed! Please use the ignore field and create new one if necessary.'; 1257 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1258 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The fields identifying what to override can not be changed! Please use the ignore field and create new one if necessary.'; 1259 END IF; 1260 IF 1261 NEW.FZXV5 IN (SELECT SVAZ4 FROM TPXHZ) 1262 OR 1263 NEW.DQYGV IN (SELECT SVAZ4 FROM TPXHZ) 1264 THEN 1265 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1266 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1267 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1268 END IF; 1269 IF NEW.SWCQV NOT IN (0, 1) 1270 THEN 1271 -- SET @custom_error_message = 'The SWCQV field is an int boolean (0/1) meaning if record is fully SWCQV.'; 1272 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1273 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The SWCQV field is an int boolean (0/1) meaning if fully SWCQV.'; 1274 END IF; 1275 IF NEW.FZXV5 IS NULL AND NEW.DQYGV IS NULL 1276 THEN 1277 -- SET @custom_error_message = 'Either the mutant or partner overridden field must have value!'; 1278 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1279 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Either the mutant or partner overridden field must have value!'; 1280 END IF; 1281 IF NEW.FZXV5 IS NOT NULL AND NEW.DQYGV IS NOT NULL 1282 THEN 1283 -- SET @custom_error_message = 'Only one of the mutant or partner overridden field can have value!'; 1284 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1285 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Only one of the mutant or partner overridden field can have value!'; 1286 END IF; 1287 UPDATE S3FQX SET ADWYM = 1; 1288 END// 1289 ---- 1290 1291 exec 1292 CREATE TRIGGER WGSDC_on_delete BEFORE DELETE ON WGSDC 1293 FOR EACH ROW 1294 BEGIN 1295 -- SET @custom_error_message = 'Deletion is forbidden from override and additional tables. Please use the SWCQV field instead.'; 1296 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1297 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Deletion is forbidden from override and additional tables. Please use the SWCQV field instead.'; 1298 END// 1299 ---- 1300 1301 exec 1302 CREATE TRIGGER EPZU6_on_insert BEFORE INSERT ON EPZU6 1303 FOR EACH ROW 1304 BEGIN 1305 IF 1306 NEW.TOFPN IN (SELECT SVAZ4 FROM TPXHZ) 1307 OR 1308 NEW.SJYN2 IN (SELECT SVAZ4 FROM TPXHZ) 1309 OR 1310 NEW.FVUCX IN (SELECT SVAZ4 FROM TPXHZ) 1311 OR 1312 NEW.BTXC5 IN (SELECT SVAZ4 FROM TPXHZ) 1313 THEN 1314 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1315 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1316 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1317 END IF; 1318 IF NEW.SWCQV NOT IN (0, 1) 1319 THEN 1320 -- SET @custom_error_message = 'The SWCQV field is an int boolean (0/1) meaning if record is fully SWCQV.'; 1321 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1322 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The SWCQV field is an int boolean (0/1) meaning if fully SWCQV.'; 1323 END IF; 1324 UPDATE S3FQX SET ADWYM = 1; 1325 END// 1326 ---- 1327 1328 exec 1329 CREATE TRIGGER EPZU6_on_update BEFORE UPDATE ON EPZU6 1330 FOR EACH ROW 1331 BEGIN 1332 IF 1333 NEW.TOFPN IS NOT NULL AND (NEW.TOFPN <> OLD.TOFPN) 1334 OR 1335 NEW.SJYN2 IS NOT NULL AND (NEW.SJYN2 <> OLD.SJYN2) 1336 OR 1337 NEW.BTXC5 IS NOT NULL AND (NEW.BTXC5 <> OLD.BTXC5) 1338 THEN 1339 -- SET @custom_error_message = 'The fields identifying what to override can not be changed! Please use the ignore field and create new one if necessary.'; 1340 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1341 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The fields identifying what to override can not be changed! Please use the ignore field and create new one if necessary.'; 1342 END IF; 1343 IF 1344 NEW.FVUCX IN (SELECT SVAZ4 FROM TPXHZ) 1345 THEN 1346 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1347 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1348 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1349 END IF; 1350 IF NEW.SWCQV NOT IN (0, 1) 1351 THEN 1352 -- SET @custom_error_message = 'The SWCQV field is an int boolean (0/1) meaning if record is fully SWCQV.'; 1353 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1354 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The SWCQV field is an int boolean (0/1) meaning if fully SWCQV.'; 1355 END IF; 1356 UPDATE S3FQX SET ADWYM = 1; 1357 END// 1358 ---- 1359 1360 exec 1361 CREATE TRIGGER EPZU6_on_delete BEFORE DELETE ON EPZU6 1362 FOR EACH ROW 1363 BEGIN 1364 -- SET @custom_error_message = 'Deletion is forbidden from override and additional tables. Please use the SWCQV field instead.'; 1365 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1366 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Deletion is forbidden from override and additional tables. Please use the SWCQV field instead.'; 1367 END// 1368 ---- 1369 1370 exec 1371 CREATE TRIGGER HU5A5_on_insert BEFORE INSERT ON HU5A5 1372 FOR EACH ROW 1373 BEGIN 1374 IF 1375 NEW.TOFPN IN (SELECT SVAZ4 FROM TPXHZ) 1376 OR 1377 NEW.I3VTA IN (SELECT SVAZ4 FROM TPXHZ) 1378 OR 1379 NEW.SFJ6L IN (SELECT SVAZ4 FROM TPXHZ) 1380 OR 1381 NEW.V5DPX IN (SELECT SVAZ4 FROM TPXHZ) 1382 OR 1383 NEW.LJLUM IN (SELECT SVAZ4 FROM TPXHZ) 1384 OR 1385 NEW.IDPK7 IN (SELECT SVAZ4 FROM TPXHZ) 1386 OR 1387 NEW.NO52D IN (SELECT SVAZ4 FROM TPXHZ) 1388 OR 1389 NEW.ZRV3B IN (SELECT SVAZ4 FROM TPXHZ) 1390 OR 1391 NEW.VYO5E IN (SELECT SVAZ4 FROM TPXHZ) 1392 THEN 1393 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1394 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1395 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1396 END IF; 1397 IF NEW.SWCQV NOT IN (0, 1) 1398 THEN 1399 -- SET @custom_error_message = 'The SWCQV field is an int boolean (0/1) meaning if record is fully SWCQV.'; 1400 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1401 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The SWCQV field is an int boolean (0/1) meaning if fully SWCQV.'; 1402 END IF; 1403 UPDATE S3FQX SET ADWYM = 1; 1404 END// 1405 ---- 1406 1407 exec 1408 CREATE TRIGGER HU5A5_on_update BEFORE UPDATE ON HU5A5 1409 FOR EACH ROW 1410 BEGIN 1411 IF 1412 NEW.TOFPN IS NOT NULL AND (NEW.TOFPN <> OLD.TOFPN) 1413 OR 1414 NEW.I3VTA IS NOT NULL AND (NEW.I3VTA <> OLD.I3VTA) 1415 OR 1416 NEW.V5DPX IS NOT NULL AND (NEW.V5DPX <> OLD.V5DPX) 1417 OR 1418 NEW.LJLUM IS NOT NULL AND (NEW.LJLUM <> OLD.LJLUM) 1419 OR 1420 NEW.IDPK7 IS NOT NULL AND (NEW.IDPK7 <> OLD.IDPK7) 1421 OR 1422 NEW.NO52D IS NOT NULL AND (NEW.NO52D <> OLD.NO52D) 1423 OR 1424 NEW.ZRV3B IS NOT NULL AND (NEW.ZRV3B <> OLD.ZRV3B) 1425 OR 1426 NEW.VYO5E IS NOT NULL AND (NEW.VYO5E <> OLD.VYO5E) 1427 THEN 1428 -- SET @custom_error_message = 'Only the SWCQV, SFJ6L, YKSSU and user RNVLS field can be changed of additionals. Please use that field and add a new one if necessary.'; 1429 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1430 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Only the SWCQV and non functional fields can be changed of additionals.'; 1431 END IF; 1432 IF 1433 NEW.SFJ6L IN (SELECT SVAZ4 FROM TPXHZ) 1434 THEN 1435 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1436 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1437 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1438 END IF; 1439 IF NEW.SWCQV NOT IN (0, 1) 1440 THEN 1441 -- SET @custom_error_message = 'The SWCQV field is an int boolean (0/1) meaning if record is fully SWCQV.'; 1442 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1443 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The SWCQV field is an int boolean (0/1) meaning if fully SWCQV.'; 1444 END IF; 1445 UPDATE S3FQX SET ADWYM = 1; 1446 END// 1447 ---- 1448 1449 exec 1450 CREATE TRIGGER HU5A5_on_delete BEFORE DELETE ON HU5A5 1451 FOR EACH ROW 1452 BEGIN 1453 -- SET @custom_error_message = 'Deletion is forbidden from override and additional tables. Please use the SWCQV field instead.'; 1454 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1455 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Deletion is forbidden from override and additional tables. Please use the SWCQV field instead.'; 1456 END// 1457 ---- 1458 1459 exec 1460 CREATE TRIGGER WE72E_on_insert BEFORE INSERT ON WE72E 1461 FOR EACH ROW 1462 BEGIN 1463 IF 1464 NEW.QZ7E7 IN (SELECT SVAZ4 FROM TPXHZ) 1465 OR 1466 NEW.SSHPJ IN (SELECT SVAZ4 FROM TPXHZ) 1467 THEN 1468 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1469 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1470 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1471 END IF; 1472 END// 1473 ---- 1474 1475 exec 1476 CREATE TRIGGER WE72E_on_update BEFORE UPDATE ON WE72E 1477 FOR EACH ROW 1478 BEGIN 1479 IF 1480 NEW.QZ7E7 IN (SELECT SVAZ4 FROM TPXHZ) 1481 OR 1482 NEW.SSHPJ IN (SELECT SVAZ4 FROM TPXHZ) 1483 THEN 1484 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1485 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1486 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1487 END IF; 1488 END// 1489 ---- 1490 1491 exec 1492 CREATE TRIGGER WE72E_on_delete BEFORE DELETE ON WE72E 1493 FOR EACH ROW 1494 BEGIN 1495 -- SET @custom_error_message = 'A WE72E can not be deleted now. If it is a use-case please contact platform team.'; 1496 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1497 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'A WE72E can not be deleted now. If it is a use-case please contact platform team.'; 1498 END// 1499 ---- 1500 1501 exec 1502 CREATE TRIGGER F35MI_on_insert BEFORE INSERT ON F35MI 1503 FOR EACH ROW 1504 BEGIN 1505 IF 1506 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 1507 OR 1508 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 1509 THEN 1510 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1511 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1512 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1513 END IF; 1514 END// 1515 ---- 1516 1517 exec 1518 CREATE TRIGGER F35MI_on_update BEFORE UPDATE ON F35MI 1519 FOR EACH ROW 1520 BEGIN 1521 IF 1522 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 1523 OR 1524 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 1525 THEN 1526 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1527 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1528 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1529 END IF; 1530 END// 1531 ---- 1532 1533 exec 1534 CREATE TRIGGER F35MI_on_delete BEFORE DELETE ON F35MI 1535 FOR EACH ROW 1536 BEGIN 1537 -- SET @custom_error_message = 'A F35MI can not be deleted now. If it is a use-case please contact platform team.'; 1538 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1539 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'A F35MI can not be deleted now. If it is a use-case please contact platform team.'; 1540 END// 1541 ---- 1542 1543 exec 1544 CREATE TRIGGER TNMXI_on_insert BEFORE INSERT ON TNMXI 1545 FOR EACH ROW 1546 BEGIN 1547 IF 1548 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 1549 OR 1550 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 1551 THEN 1552 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1553 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1554 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1555 END IF; 1556 END// 1557 ---- 1558 1559 exec 1560 CREATE TRIGGER TNMXI_on_update BEFORE UPDATE ON TNMXI 1561 FOR EACH ROW 1562 BEGIN 1563 IF 1564 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 1565 OR 1566 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 1567 THEN 1568 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1569 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1570 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1571 END IF; 1572 END// 1573 ---- 1574 1575 exec 1576 CREATE TRIGGER TNMXI_on_delete BEFORE DELETE ON TNMXI 1577 FOR EACH ROW 1578 BEGIN 1579 -- SET @custom_error_message = 'A TNMXI can not be deleted now. If it is a use-case please contact platform team.'; 1580 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1581 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'A TNMXI can not be deleted now. If it is a use-case please contact platform team.'; 1582 END// 1583 ---- 1584 1585 exec 1586 CREATE TRIGGER XGSJM_on_insert BEFORE INSERT ON XGSJM 1587 FOR EACH ROW 1588 BEGIN 1589 IF 1590 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 1591 OR 1592 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 1593 THEN 1594 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1595 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1596 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1597 END IF; 1598 END// 1599 ---- 1600 1601 exec 1602 CREATE TRIGGER XGSJM_on_update BEFORE UPDATE ON XGSJM 1603 FOR EACH ROW 1604 BEGIN 1605 IF 1606 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 1607 OR 1608 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 1609 THEN 1610 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1611 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1612 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1613 END IF; 1614 END// 1615 ---- 1616 1617 exec 1618 CREATE TRIGGER XGSJM_on_delete BEFORE DELETE ON XGSJM 1619 FOR EACH ROW 1620 BEGIN 1621 -- SET @custom_error_message = 'A XGSJM can not be deleted now. If it is a use-case please contact platform team.'; 1622 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1623 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'A XGSJM can not be deleted now. If it is a use-case please contact platform team.'; 1624 END// 1625 ---- 1626 1627 exec 1628 CREATE TRIGGER IIISV_on_insert BEFORE INSERT ON IIISV 1629 FOR EACH ROW 1630 BEGIN 1631 IF 1632 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 1633 OR 1634 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 1635 THEN 1636 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1637 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1638 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1639 END IF; 1640 END// 1641 ---- 1642 1643 exec 1644 CREATE TRIGGER IIISV_on_update BEFORE UPDATE ON IIISV 1645 FOR EACH ROW 1646 BEGIN 1647 IF 1648 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 1649 OR 1650 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 1651 THEN 1652 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1653 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1654 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1655 END IF; 1656 END// 1657 ---- 1658 1659 exec 1660 CREATE TRIGGER TTGWX_on_insert BEFORE INSERT ON TTGWX 1661 FOR EACH ROW 1662 BEGIN 1663 IF 1664 NEW.CBVKT IN (SELECT SVAZ4 FROM TPXHZ) 1665 THEN 1666 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1667 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1668 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1669 END IF; 1670 END// 1671 ---- 1672 1673 exec 1674 CREATE TRIGGER TTGWX_on_update BEFORE UPDATE ON TTGWX 1675 FOR EACH ROW 1676 BEGIN 1677 IF 1678 NEW.CBVKT IN (SELECT SVAZ4 FROM TPXHZ) 1679 THEN 1680 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1681 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1682 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1683 END IF; 1684 END// 1685 ---- 1686 1687 exec 1688 CREATE TRIGGER FEVH4_on_insert BEFORE INSERT ON FEVH4 1689 FOR EACH ROW 1690 BEGIN 1691 IF 1692 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 1693 OR 1694 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 1695 THEN 1696 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1697 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1698 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1699 END IF; 1700 END// 1701 ---- 1702 1703 exec 1704 CREATE TRIGGER FEVH4_on_update BEFORE UPDATE ON FEVH4 1705 FOR EACH ROW 1706 BEGIN 1707 IF 1708 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 1709 OR 1710 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 1711 THEN 1712 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1713 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1714 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1715 END IF; 1716 END// 1717 ---- 1718 1719 exec 1720 CREATE TRIGGER FEVH4_on_delete BEFORE DELETE ON FEVH4 1721 FOR EACH ROW 1722 BEGIN 1723 -- SET @custom_error_message = 'An FEVH4 can not be deleted now. If it is a use-case please contact platform team.'; 1724 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1725 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'An FEVH4 can not be deleted now. If it is a use-case please contact platform team.'; 1726 END// 1727 ---- 1728 1729 exec 1730 CREATE TRIGGER T52LX_on_insert BEFORE INSERT ON T52LX 1731 FOR EACH ROW 1732 BEGIN 1733 IF 1734 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 1735 OR 1736 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 1737 THEN 1738 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1739 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1740 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1741 END IF; 1742 END// 1743 ---- 1744 1745 exec 1746 CREATE TRIGGER T52LX_on_update BEFORE UPDATE ON T52LX 1747 FOR EACH ROW 1748 BEGIN 1749 IF 1750 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 1751 OR 1752 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 1753 THEN 1754 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1755 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1756 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1757 END IF; 1758 END// 1759 ---- 1760 1761 exec 1762 CREATE TRIGGER NOXN3_on_insert BEFORE INSERT ON NOXN3 1763 FOR EACH ROW 1764 BEGIN 1765 IF 1766 NEW.NUMK2 = 1 AND NEW.ECDKM IS NOT NULL 1767 THEN 1768 -- SET @custom_error_message = 'If the edge TAFAX is activity (1), ECDKM must be NULL.'; 1769 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1770 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'If the edge TAFAX is activity (1), ECDKM must be NULL.'; 1771 END IF; 1772 IF 1773 NEW.NUMK2 <> 1 AND NEW.ECDKM IS NULL 1774 THEN 1775 -- SET @custom_error_message = 'If the edge TAFAX is not activity (1), ECDKM must have value.'; 1776 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1777 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'If the edge TAFAX is not activity (1), ECDKM must have value.'; 1778 END IF; 1779 UPDATE S3FQX SET ADWYM = 1; 1780 END// 1781 ---- 1782 1783 exec 1784 CREATE TRIGGER NOXN3_on_update BEFORE UPDATE ON NOXN3 1785 FOR EACH ROW 1786 BEGIN 1787 IF 1788 NEW.NUMK2 = 1 AND NEW.ECDKM IS NOT NULL 1789 THEN 1790 -- SET @custom_error_message = 'If the edge TAFAX is activity (1), ECDKM must be NULL.'; 1791 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1792 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'If the edge TAFAX is activity (1), ECDKM must be NULL.'; 1793 END IF; 1794 IF 1795 NEW.NUMK2 <> 1 AND NEW.ECDKM IS NULL 1796 THEN 1797 -- SET @custom_error_message = 'If the edge TAFAX is not activity (1), ECDKM must have value.'; 1798 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1799 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'If the edge TAFAX is not activity (1), ECDKM must have value.'; 1800 END IF; 1801 IF 1802 NEW.BRQP2 IS NOT NULL AND (NEW.BRQP2 <> OLD.BRQP2) 1803 OR 1804 NEW.FFTBJ IS NOT NULL AND (NEW.FFTBJ <> OLD.FFTBJ) 1805 OR 1806 (NEW.NUMK2 IS NOT NULL) AND (NEW.NUMK2 <> OLD.NUMK2) AND (NEW.NUMK2 = 1 OR OLD.NUMK2 = 1) 1807 THEN 1808 UPDATE S3FQX SET ADWYM = 1; 1809 END IF; 1810 END// 1811 ---- 1812 1813 exec 1814 CREATE TRIGGER QYWQD_on_insert BEFORE INSERT ON QYWQD 1815 FOR EACH ROW 1816 BEGIN 1817 IF 1818 (SELECT FFTBJ FROM NOXN3 WHERE id = NEW.WNUNU) <> (SELECT BRQP2 FROM NOXN3 WHERE id = NEW.HHVLX) 1819 THEN 1820 -- SET @custom_error_message = 'The target UWBAI of the upstream edge must be the same as the source UWBAI of the downstream edge (the enzyme UWBAI).'; 1821 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1822 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The target UWBAI of the upstream edge must be the same as the source UWBAI of the downstream edge (the enzyme UWBAI).'; 1823 END IF; 1824 END// 1825 ---- 1826 1827 exec 1828 CREATE TRIGGER QYWQD_on_update BEFORE UPDATE ON QYWQD 1829 FOR EACH ROW 1830 BEGIN 1831 IF 1832 (SELECT FFTBJ FROM NOXN3 WHERE id = NEW.WNUNU) <> (SELECT BRQP2 FROM NOXN3 WHERE id = NEW.HHVLX) 1833 THEN 1834 -- SET @custom_error_message = 'The target UWBAI of the upstream edge must be the same as the source UWBAI of the downstream edge (the enzyme UWBAI).'; 1835 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1836 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The target UWBAI of the upstream edge must be the same as the source UWBAI of the downstream edge (the enzyme UWBAI).'; 1837 END IF; 1838 END// 1839 ---- 1840 1841 exec 1842 CREATE TRIGGER RLOHD_on_insert BEFORE INSERT ON RLOHD 1843 FOR EACH ROW 1844 BEGIN 1845 IF 1846 (SELECT DKCAJ FROM E2I7U WHERE id = NEW.LUEVY) NOT IN (SELECT id FROM F35MI WHERE DZLIM = 'extra_cellular' OR DZLIM = 'OROPK') 1847 THEN 1848 -- SET @custom_error_message = 'The choosen UWBAI is not TAFAX of extra_cellular or OROPK. Input layer is only defined for these.'; 1849 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1850 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The choosen UWBAI is not TAFAX of extra_cellular or OROPK. Input layer is only defined for these.'; 1851 END IF; 1852 IF 1853 NEW.KLMAU IS NULL AND NEW.ecm IS NULL 1854 THEN 1855 -- SET @custom_error_message = 'Either KLMAU or ecm must be set.'; 1856 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1857 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Either KLMAU or ecm must be set.'; 1858 END IF; 1859 END// 1860 ---- 1861 1862 exec 1863 CREATE TRIGGER RLOHD_on_update BEFORE UPDATE ON RLOHD 1864 FOR EACH ROW 1865 BEGIN 1866 IF 1867 (SELECT DKCAJ FROM E2I7U WHERE id = NEW.LUEVY) NOT IN (SELECT id FROM F35MI WHERE DZLIM = 'extra_cellular' OR DZLIM = 'OROPK') 1868 THEN 1869 -- SET @custom_error_message = 'The choosen UWBAI is not TAFAX of extra_cellular or OROPK. Input layer is only defined for these.'; 1870 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1871 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The choosen UWBAI is not TAFAX of extra_cellular or OROPK. Input layer is only defined for these.'; 1872 END IF; 1873 IF 1874 NEW.KLMAU IS NULL AND NEW.ecm IS NULL 1875 THEN 1876 -- SET @custom_error_message = 'Either KLMAU or ecm must be set.'; 1877 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1878 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Either KLMAU or ecm must be set.'; 1879 END IF; 1880 END// 1881 ---- 1882 1883 exec 1884 CREATE TRIGGER YK2GW_on_insert BEFORE INSERT ON YK2GW 1885 FOR EACH ROW 1886 BEGIN 1887 IF 1888 NEW.FTQLQ IN (SELECT SVAZ4 FROM TPXHZ) 1889 OR 1890 NEW.TUXML IN (SELECT SVAZ4 FROM TPXHZ) 1891 OR 1892 NEW.PAEF5 IN (SELECT SVAZ4 FROM TPXHZ) 1893 OR 1894 NEW.RUCY4 IN (SELECT SVAZ4 FROM TPXHZ) 1895 OR 1896 NEW.TPNJ6 IN (SELECT SVAZ4 FROM TPXHZ) 1897 THEN 1898 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1899 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1900 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1901 END IF; 1902 UPDATE S3FQX SET ADWYM = 1, FPUYA = 1; 1903 END// 1904 ---- 1905 1906 exec 1907 CREATE TRIGGER YK2GW_on_update BEFORE UPDATE ON YK2GW 1908 FOR EACH ROW 1909 BEGIN 1910 IF 1911 NEW.FTQLQ IS NOT NULL AND (NEW.FTQLQ <> OLD.FTQLQ) 1912 THEN 1913 -- SET @custom_error_message = 'The FTQLQ of a cell line can not be modified. Delete and re-add if necessary.'; 1914 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1915 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The FTQLQ of a cell line can not be modified. Delete and re-add if necessary.'; 1916 END IF; 1917 IF 1918 NEW.FTQLQ IN (SELECT SVAZ4 FROM TPXHZ) 1919 OR 1920 NEW.TUXML IN (SELECT SVAZ4 FROM TPXHZ) 1921 OR 1922 NEW.PAEF5 IN (SELECT SVAZ4 FROM TPXHZ) 1923 OR 1924 NEW.RUCY4 IN (SELECT SVAZ4 FROM TPXHZ) 1925 OR 1926 NEW.TPNJ6 IN (SELECT SVAZ4 FROM TPXHZ) 1927 THEN 1928 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1929 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1930 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1931 END IF; 1932 END// 1933 ---- 1934 1935 exec 1936 CREATE TRIGGER IJLXP_on_insert BEFORE INSERT ON IJLXP 1937 FOR EACH ROW 1938 BEGIN 1939 IF 1940 NEW.WZP3R IN (SELECT SVAZ4 FROM TPXHZ) 1941 THEN 1942 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1943 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1944 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1945 END IF; 1946 END// 1947 ---- 1948 1949 exec 1950 CREATE TRIGGER IJLXP_on_update BEFORE UPDATE ON IJLXP 1951 FOR EACH ROW 1952 BEGIN 1953 IF 1954 NEW.WZP3R IN (SELECT SVAZ4 FROM TPXHZ) 1955 THEN 1956 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1957 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1958 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1959 END IF; 1960 END// 1961 ---- 1962 1963 exec 1964 CREATE TRIGGER JMRQL_on_insert BEFORE INSERT ON JMRQL 1965 FOR EACH ROW 1966 BEGIN 1967 IF 1968 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 1969 OR 1970 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 1971 THEN 1972 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1973 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1974 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1975 END IF; 1976 END// 1977 ---- 1978 1979 exec 1980 CREATE TRIGGER JMRQL_on_update BEFORE UPDATE ON JMRQL 1981 FOR EACH ROW 1982 BEGIN 1983 IF 1984 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 1985 OR 1986 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 1987 THEN 1988 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 1989 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 1990 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 1991 END IF; 1992 END// 1993 ---- 1994 1995 exec 1996 CREATE TRIGGER JMRQL_on_delete BEFORE DELETE ON JMRQL 1997 FOR EACH ROW 1998 BEGIN 1999 -- SET @custom_error_message = 'A JMRQL can not be deleted now. If it is a use-case please contact platform team.'; 2000 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2001 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'A JMRQL can not be deleted now. If it is a use-case please contact platform team.'; 2002 END// 2003 ---- 2004 2005 exec 2006 CREATE TRIGGER AMYXQ_on_insert BEFORE INSERT ON AMYXQ 2007 FOR EACH ROW 2008 BEGIN 2009 IF 2010 (SELECT FGG57 FROM E2I7U WHERE id = NEW.LUEVY) IS NULL 2011 THEN 2012 -- SET @custom_error_message = 'The given UWBAI can not be connected to a AMYXQ record as it does not have IYDZV.'; 2013 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2014 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The given UWBAI can not be connected to a AMYXQ record as it does not have IYDZV.'; 2015 END IF; 2016 IF 2017 NEW.AMYXQ < 0 OR NEW.OZTQF < 0 OR NEW.Z35GY < 0 2018 THEN 2019 -- SET @custom_error_message = 'All values in AMYXQ must ne non-negative.'; 2020 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2021 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'All values in AMYXQ must ne non-negative.'; 2022 END IF; 2023 END// 2024 ---- 2025 2026 exec 2027 CREATE TRIGGER AMYXQ_on_update BEFORE UPDATE ON AMYXQ 2028 FOR EACH ROW 2029 BEGIN 2030 IF 2031 NEW.GXLUB IS NOT NULL AND (NEW.GXLUB <> OLD.GXLUB) 2032 OR 2033 NEW.LUEVY IS NOT NULL AND (NEW.LUEVY <> OLD.LUEVY) 2034 OR 2035 NEW.KKGN5 IS NOT NULL AND (NEW.KKGN5 <> OLD.KKGN5) 2036 THEN 2037 -- SET @custom_error_message = 'For a built-in table, fields identifying where to apply and from where it originates can not be changed!'; 2038 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2039 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'For a built-in table, fields identifying where to apply and from where it originates can not be changed!'; 2040 END IF; 2041 IF 2042 NEW.AMYXQ < 0 OR NEW.OZTQF < 0 OR NEW.Z35GY < 0 2043 THEN 2044 -- SET @custom_error_message = 'All values in AMYXQ must ne non-negative.'; 2045 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2046 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'All values in AMYXQ must ne non-negative.'; 2047 END IF; 2048 END// 2049 ---- 2050 2051 exec 2052 CREATE TRIGGER D34QP_on_insert BEFORE INSERT ON D34QP 2053 FOR EACH ROW 2054 BEGIN 2055 IF 2056 NEW.TWMSR IN (SELECT SVAZ4 FROM TPXHZ) 2057 OR 2058 NEW.QHMGE IN (SELECT SVAZ4 FROM TPXHZ) 2059 OR 2060 NEW.MLNPU IN (SELECT SVAZ4 FROM TPXHZ) 2061 OR 2062 NEW.FI3GA IN (SELECT SVAZ4 FROM TPXHZ) 2063 OR 2064 NEW.ZNP4P IN (SELECT SVAZ4 FROM TPXHZ) 2065 THEN 2066 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2067 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2068 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2069 END IF; 2070 END// 2071 ---- 2072 2073 exec 2074 CREATE TRIGGER D34QP_on_update BEFORE UPDATE ON D34QP 2075 FOR EACH ROW 2076 BEGIN 2077 IF 2078 NEW.TWMSR IN (SELECT SVAZ4 FROM TPXHZ) 2079 OR 2080 NEW.QHMGE IN (SELECT SVAZ4 FROM TPXHZ) 2081 OR 2082 NEW.MLNPU IN (SELECT SVAZ4 FROM TPXHZ) 2083 OR 2084 NEW.FI3GA IN (SELECT SVAZ4 FROM TPXHZ) 2085 OR 2086 NEW.ZNP4P IN (SELECT SVAZ4 FROM TPXHZ) 2087 THEN 2088 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2089 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2090 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2091 END IF; 2092 END// 2093 ---- 2094 2095 exec 2096 CREATE TRIGGER HGMQ6_on_insert BEFORE INSERT ON HGMQ6 2097 FOR EACH ROW 2098 BEGIN 2099 IF 2100 NEW.TJPT7 IN (SELECT SVAZ4 FROM TPXHZ) 2101 OR 2102 NEW.ARN5P IN (SELECT SVAZ4 FROM TPXHZ) 2103 OR 2104 NEW.XOSD4 IN (SELECT SVAZ4 FROM TPXHZ) 2105 OR 2106 NEW.IDE43 IN (SELECT SVAZ4 FROM TPXHZ) 2107 OR 2108 NEW.HMW4H IN (SELECT SVAZ4 FROM TPXHZ) 2109 THEN 2110 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2111 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2112 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2113 END IF; 2114 IF 2115 NEW.FSDY2 NOT IN ('benign', 'VUS', 'SRARY', 'UBQWG') 2116 THEN 2117 -- SET @custom_error_message = 'FSDY2 must be either ''benign'', ''VUS'', ''SRARY'' or ''UBQWG''.'; 2118 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2119 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'FSDY2 must be either ''benign'', ''VUS'', ''SRARY'' or ''UBQWG''.'; 2120 END IF; 2121 IF NEW.LT7K6 IS NOT NULL AND NEW.SPPYD IS NOT NULL 2122 THEN 2123 -- SET @custom_error_message = 'If LT7K6 has value, SPPYD must be NULL.'; 2124 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2125 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'If LT7K6 has value, SPPYD must be NULL.'; 2126 END IF; 2127 IF NEW.LT7K6 IS NULL AND (NEW.SPPYD IS NULL OR NEW.SPPYD <> 0.5) 2128 THEN 2129 -- SET @custom_error_message = 'If LT7K6 does not have value, SPPYD must be 0.5.'; 2130 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2131 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'If LT7K6 does not have value, SPPYD must be 0.5.'; 2132 END IF; 2133 END// 2134 ---- 2135 2136 exec 2137 CREATE TRIGGER HGMQ6_on_update BEFORE UPDATE ON HGMQ6 2138 FOR EACH ROW 2139 BEGIN 2140 IF 2141 NEW.GXLUB IS NOT NULL AND (NEW.GXLUB <> OLD.GXLUB) 2142 OR 2143 NEW.LUEVY IS NOT NULL AND (NEW.LUEVY <> OLD.LUEVY) 2144 OR 2145 NEW.M22QN IS NOT NULL AND (NEW.M22QN <> OLD.M22QN) 2146 OR 2147 NEW.TEUJA IS NOT NULL AND (NEW.TEUJA <> OLD.TEUJA) 2148 OR 2149 NEW.QQV4M IS NOT NULL AND (NEW.QQV4M <> OLD.QQV4M) 2150 THEN 2151 -- SET @custom_error_message = 'For a built-in table, fields identifying where to apply and from where it originates can not be changed!'; 2152 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2153 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'For a built-in table, fields identifying where to apply and from where it originates can not be changed!'; 2154 END IF; 2155 IF 2156 NEW.TJPT7 IN (SELECT SVAZ4 FROM TPXHZ) 2157 OR 2158 NEW.ARN5P IN (SELECT SVAZ4 FROM TPXHZ) 2159 OR 2160 NEW.XOSD4 IN (SELECT SVAZ4 FROM TPXHZ) 2161 OR 2162 NEW.IDE43 IN (SELECT SVAZ4 FROM TPXHZ) 2163 OR 2164 NEW.HMW4H IN (SELECT SVAZ4 FROM TPXHZ) 2165 THEN 2166 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2167 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2168 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2169 END IF; 2170 IF 2171 NEW.FSDY2 NOT IN ('benign', 'VUS', 'SRARY', 'UBQWG') 2172 THEN 2173 -- SET @custom_error_message = 'FSDY2 must be either ''benign'', ''VUS'', ''SRARY'' or ''UBQWG''.'; 2174 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2175 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'FSDY2 must be either ''benign'', ''VUS'', ''SRARY'' or ''UBQWG''.'; 2176 END IF; 2177 IF NEW.LT7K6 IS NOT NULL AND NEW.SPPYD IS NOT NULL 2178 THEN 2179 -- SET @custom_error_message = 'If LT7K6 has value, SPPYD must be NULL.'; 2180 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2181 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'If LT7K6 has value, SPPYD must be NULL.'; 2182 END IF; 2183 IF NEW.LT7K6 IS NULL AND (NEW.SPPYD IS NULL OR NEW.SPPYD <> 0.5) 2184 THEN 2185 -- SET @custom_error_message = 'If LT7K6 does not have value, SPPYD must be 0.5.'; 2186 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2187 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'If LT7K6 does not have value, SPPYD must be 0.5.'; 2188 END IF; 2189 END// 2190 ---- 2191 2192 exec 2193 CREATE TRIGGER TPXBU_on_insert BEFORE INSERT ON TPXBU 2194 FOR EACH ROW 2195 BEGIN 2196 IF 2197 NEW.BTXC5 IN (SELECT SVAZ4 FROM TPXHZ) 2198 THEN 2199 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2200 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2201 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2202 END IF; 2203 END// 2204 ---- 2205 2206 exec 2207 CREATE TRIGGER TPXBU_on_update BEFORE UPDATE ON TPXBU 2208 FOR EACH ROW 2209 BEGIN 2210 IF 2211 NEW.BTXC5 IN (SELECT SVAZ4 FROM TPXHZ) 2212 THEN 2213 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2214 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2215 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2216 END IF; 2217 END// 2218 ---- 2219 2220 exec 2221 CREATE TRIGGER YYBCX_on_insert BEFORE INSERT ON YYBCX 2222 FOR EACH ROW 2223 BEGIN 2224 IF 2225 NEW.ESFVY IN (SELECT SVAZ4 FROM TPXHZ) 2226 OR 2227 NEW.SL76B IN (SELECT SVAZ4 FROM TPXHZ) 2228 THEN 2229 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2230 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2231 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2232 END IF; 2233 END// 2234 ---- 2235 2236 exec 2237 CREATE TRIGGER YYBCX_on_update BEFORE UPDATE ON YYBCX 2238 FOR EACH ROW 2239 BEGIN 2240 IF 2241 NEW.ESFVY IN (SELECT SVAZ4 FROM TPXHZ) 2242 OR 2243 NEW.SL76B IN (SELECT SVAZ4 FROM TPXHZ) 2244 THEN 2245 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2246 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2247 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2248 END IF; 2249 END// 2250 ---- 2251 2252 exec 2253 CREATE TRIGGER YYBCX_on_delete BEFORE DELETE ON YYBCX 2254 FOR EACH ROW 2255 BEGIN 2256 -- SET @custom_error_message = 'An YYBCX can not be deleted now. If it is a use-case please contact platform team.'; 2257 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2258 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'An YYBCX can not be deleted now. If it is a use-case please contact platform team.'; 2259 END// 2260 ---- 2261 2262 exec 2263 CREATE TRIGGER HDDVB_on_update BEFORE UPDATE ON HDDVB 2264 FOR EACH ROW 2265 BEGIN 2266 IF 2267 NEW.FV24E IS NOT NULL AND (NEW.FV24E <> OLD.FV24E) 2268 OR 2269 NEW.UJ6XY IS NOT NULL AND (NEW.UJ6XY <> OLD.UJ6XY) 2270 OR 2271 NEW.M22QN IS NOT NULL AND (NEW.M22QN <> OLD.M22QN) 2272 OR 2273 NEW.ETPQV IS NOT NULL AND (NEW.ETPQV <> OLD.ETPQV) 2274 OR 2275 NEW.PRUV2 IS NOT NULL AND (NEW.PRUV2 <> OLD.PRUV2) 2276 THEN 2277 -- SET @custom_error_message = 'For a built-in table, fields identifying where to apply and from where it originates can not be changed!'; 2278 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2279 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'For a built-in table, fields identifying where to apply and from where it originates can not be changed!'; 2280 END IF; 2281 END// 2282 ---- 2283 2284 exec 2285 CREATE TRIGGER ZYGMF_on_insert BEFORE INSERT ON ZYGMF 2286 FOR EACH ROW 2287 BEGIN 2288 IF 2289 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 2290 OR 2291 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 2292 THEN 2293 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2294 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2295 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2296 END IF; 2297 END// 2298 ---- 2299 2300 exec 2301 CREATE TRIGGER ZYGMF_on_update BEFORE UPDATE ON ZYGMF 2302 FOR EACH ROW 2303 BEGIN 2304 IF 2305 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 2306 OR 2307 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 2308 THEN 2309 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2310 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2311 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2312 END IF; 2313 END// 2314 ---- 2315 2316 exec 2317 CREATE TRIGGER ZYGMF_on_delete BEFORE DELETE ON ZYGMF 2318 FOR EACH ROW 2319 BEGIN 2320 -- SET @custom_error_message = 'A ZYGMF can not be deleted now. If it is a use-case please contact platform team.'; 2321 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2322 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'A ZYGMF can not be deleted now. If it is a use-case please contact platform team.'; 2323 END// 2324 ---- 2325 2326 exec 2327 CREATE TRIGGER JDLNA_on_insert BEFORE INSERT ON JDLNA 2328 FOR EACH ROW 2329 BEGIN 2330 IF 2331 NEW.FTQLQ IN (SELECT SVAZ4 FROM TPXHZ) 2332 OR 2333 NEW.FWWIQ IN (SELECT SVAZ4 FROM TPXHZ) 2334 OR 2335 NEW.O3QXW IN (SELECT SVAZ4 FROM TPXHZ) 2336 THEN 2337 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2338 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2339 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2340 END IF; 2341 UPDATE S3FQX SET ADWYM = 1; 2342 END// 2343 ---- 2344 2345 exec 2346 CREATE TRIGGER JDLNA_on_update BEFORE UPDATE ON JDLNA 2347 FOR EACH ROW 2348 BEGIN 2349 IF 2350 NEW.FTQLQ IS NOT NULL AND (NEW.FTQLQ <> OLD.FTQLQ) 2351 THEN 2352 -- SET @custom_error_message = 'The FTQLQ of a VCGT3 can not be modified. Delete and re-add if necessary.'; 2353 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2354 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The FTQLQ of a VCGT3 can not be modified. Delete and re-add if necessary.'; 2355 END IF; 2356 IF 2357 NEW.FTQLQ IN (SELECT SVAZ4 FROM TPXHZ) 2358 OR 2359 NEW.FWWIQ IN (SELECT SVAZ4 FROM TPXHZ) 2360 OR 2361 NEW.O3QXW IN (SELECT SVAZ4 FROM TPXHZ) 2362 THEN 2363 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2364 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2365 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2366 END IF; 2367 END// 2368 ---- 2369 2370 exec 2371 CREATE TRIGGER BACOW_on_insert BEFORE INSERT ON BACOW 2372 FOR EACH ROW 2373 BEGIN 2374 IF 2375 NEW.WZP3R IN (SELECT SVAZ4 FROM TPXHZ) 2376 THEN 2377 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2378 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2379 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2380 END IF; 2381 END// 2382 ---- 2383 2384 exec 2385 CREATE TRIGGER BACOW_on_update BEFORE UPDATE ON BACOW 2386 FOR EACH ROW 2387 BEGIN 2388 IF 2389 NEW.WZP3R IN (SELECT SVAZ4 FROM TPXHZ) 2390 THEN 2391 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2392 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2393 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2394 END IF; 2395 END// 2396 ---- 2397 2398 exec 2399 CREATE TRIGGER SFEGG_on_insert BEFORE INSERT ON SFEGG 2400 FOR EACH ROW 2401 BEGIN 2402 IF 2403 NEW.NO52D IN (SELECT SVAZ4 FROM TPXHZ) 2404 OR NEW.VYO5E IN (SELECT SVAZ4 FROM TPXHZ) 2405 THEN 2406 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2407 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2408 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2409 END IF; 2410 IF 2411 NEW.ADURZ <= 0 2412 THEN 2413 -- SET @custom_error_message = 'ADURZ must be positive.'; 2414 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2415 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'ADURZ must be positive.'; 2416 END IF; 2417 END// 2418 ---- 2419 2420 exec 2421 CREATE TRIGGER SFEGG_on_update BEFORE UPDATE ON SFEGG 2422 FOR EACH ROW 2423 BEGIN 2424 IF 2425 NEW.NO52D IN (SELECT SVAZ4 FROM TPXHZ) 2426 OR NEW.VYO5E IN (SELECT SVAZ4 FROM TPXHZ) 2427 THEN 2428 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2429 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2430 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2431 END IF; 2432 IF 2433 NEW.ADURZ <= 0 2434 THEN 2435 -- SET @custom_error_message = 'ADURZ must be positive.'; 2436 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2437 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'ADURZ must be positive.'; 2438 END IF; 2439 END// 2440 ---- 2441 2442 exec 2443 CREATE TRIGGER FLQLP_on_insert BEFORE INSERT ON FLQLP 2444 FOR EACH ROW 2445 BEGIN 2446 IF 2447 NEW.V5DPX IN (SELECT SVAZ4 FROM TPXHZ) 2448 THEN 2449 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2450 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2451 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2452 END IF; 2453 IF 2454 NEW.ZRV3B NOT IN ('=', '<=', '>=', '<', '>') 2455 THEN 2456 -- SET @custom_error_message = 'The ZRV3B must be on of the following: ''='', ''<='', ''>='', ''<'', ''>''.'; 2457 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2458 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The ZRV3B must be on of the following: ''='', ''<='', ''>='', ''<'', ''>''.'; 2459 END IF; 2460 END// 2461 ---- 2462 2463 exec 2464 CREATE TRIGGER FLQLP_on_update BEFORE UPDATE ON FLQLP 2465 FOR EACH ROW 2466 BEGIN 2467 IF 2468 NEW.FZ2R5 IS NOT NULL AND (NEW.FZ2R5 <> OLD.FZ2R5) 2469 OR 2470 NEW.LUEVY IS NOT NULL AND (NEW.LUEVY <> OLD.LUEVY) 2471 OR 2472 NEW.M22QN IS NOT NULL AND (NEW.M22QN <> OLD.M22QN) 2473 OR 2474 NEW.NRURT IS NOT NULL AND (NEW.NRURT <> OLD.NRURT) 2475 OR 2476 NEW.OCA7E IS NOT NULL AND (NEW.OCA7E <> OLD.OCA7E) 2477 OR 2478 NEW.XMM6Q IS NOT NULL AND (NEW.XMM6Q <> OLD.XMM6Q) 2479 THEN 2480 -- SET @custom_error_message = 'For a built-in table, fields identifying where to apply and from where it originates can not be changed!'; 2481 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2482 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'For a built-in table, fields identifying where to apply and from where it originates can not be changed!'; 2483 END IF; 2484 IF 2485 NEW.V5DPX IN (SELECT SVAZ4 FROM TPXHZ) 2486 THEN 2487 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2488 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2489 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2490 END IF; 2491 IF 2492 NEW.ZRV3B NOT IN ('=', '<=', '>=', '<', '>') 2493 THEN 2494 -- SET @custom_error_message = 'The ZRV3B must be on of the following: ''='', ''<='', ''>='', ''<'', ''>''.'; 2495 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2496 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The ZRV3B must be on of the following: ''='', ''<='', ''>='', ''<'', ''>''.'; 2497 END IF; 2498 END// 2499 ---- 2500 2501 exec 2502 CREATE TRIGGER XOAOP_on_insert BEFORE INSERT ON XOAOP 2503 FOR EACH ROW 2504 BEGIN 2505 IF 2506 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 2507 OR 2508 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 2509 THEN 2510 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2511 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2512 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2513 END IF; 2514 END// 2515 ---- 2516 2517 exec 2518 CREATE TRIGGER XOAOP_on_update BEFORE UPDATE ON XOAOP 2519 FOR EACH ROW 2520 BEGIN 2521 IF 2522 OLD.DZLIM = 'NER' AND NEW.DZLIM <> 'NER' 2523 OR 2524 OLD.DZLIM = 'BER' AND NEW.DZLIM <> 'BER' 2525 OR 2526 OLD.DZLIM = 'HR' AND NEW.DZLIM <> 'HR' 2527 OR 2528 OLD.DZLIM = 'MMR' AND NEW.DZLIM <> 'MMR' 2529 THEN 2530 -- SET @custom_error_message = 'NER, BER, HR and MMR ECUWUs can not be modified to another PV2SV.'; 2531 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2532 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'NER, BER, HR and MMR ECUWUs can not be modified to another PV2SV.'; 2533 END IF; 2534 IF 2535 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 2536 OR 2537 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 2538 THEN 2539 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2540 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2541 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2542 END IF; 2543 END// 2544 ---- 2545 2546 exec 2547 CREATE TRIGGER XOAOP_on_delete BEFORE DELETE ON XOAOP 2548 FOR EACH ROW 2549 BEGIN 2550 IF 2551 OLD.DZLIM IN ('NER', 'BER', 'HR', 'MMR') 2552 THEN 2553 -- SET @custom_error_message = 'NER, BER, HR and MMR ECUWUs can not be deleted.'; 2554 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2555 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'NER, BER, HR and MMR ECUWUs can not be deleted.'; 2556 END IF; 2557 END// 2558 ---- 2559 2560 exec 2561 CREATE TRIGGER PG27A_on_insert BEFORE INSERT ON PG27A 2562 FOR EACH ROW 2563 BEGIN 2564 IF 2565 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 2566 OR 2567 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 2568 THEN 2569 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2570 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2571 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2572 END IF; 2573 END// 2574 ---- 2575 2576 exec 2577 CREATE TRIGGER PG27A_on_update BEFORE UPDATE ON PG27A 2578 FOR EACH ROW 2579 BEGIN 2580 IF 2581 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 2582 OR 2583 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 2584 THEN 2585 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2586 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2587 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2588 END IF; 2589 END// 2590 ---- 2591 2592 exec 2593 CREATE TRIGGER NPCYY_on_insert BEFORE INSERT ON NPCYY 2594 FOR EACH ROW 2595 BEGIN 2596 IF 2597 NEW.B5OUF <= 0 2598 THEN 2599 -- SET @custom_error_message = 'B5OUF must be positive.'; 2600 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2601 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'B5OUF must be positive.'; 2602 END IF; 2603 END// 2604 ---- 2605 2606 exec 2607 CREATE TRIGGER NPCYY_on_update BEFORE UPDATE ON NPCYY 2608 FOR EACH ROW 2609 BEGIN 2610 IF 2611 NEW.B5OUF <= 0 2612 THEN 2613 -- SET @custom_error_message = 'B5OUF must be positive.'; 2614 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2615 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'B5OUF must be positive.'; 2616 END IF; 2617 END// 2618 ---- 2619 2620 exec 2621 CREATE TRIGGER FEIOE_on_insert BEFORE INSERT ON FEIOE 2622 FOR EACH ROW 2623 BEGIN 2624 IF 2625 NEW.FVGD2 NOT IN (0, 1) 2626 OR 2627 NEW.YP2CR NOT IN (0, 1) 2628 OR 2629 NEW.TQ7W3 NOT IN (0, 1) 2630 THEN 2631 -- SET @custom_error_message = 'FVGD2, YP2CR, and TQ7W3 fields must be either 0 or 1.'; 2632 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2633 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'FVGD2, YP2CR, and TQ7W3 fields must be either 0 or 1.'; 2634 END IF; 2635 END// 2636 ---- 2637 2638 exec 2639 CREATE TRIGGER FEIOE_on_update BEFORE UPDATE ON FEIOE 2640 FOR EACH ROW 2641 BEGIN 2642 IF 2643 NEW.FVGD2 NOT IN (0, 1) 2644 OR 2645 NEW.YP2CR NOT IN (0, 1) 2646 OR 2647 NEW.TQ7W3 NOT IN (0, 1) 2648 THEN 2649 -- SET @custom_error_message = 'FVGD2, YP2CR, and TQ7W3 fields must be either 0 or 1.'; 2650 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2651 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'FVGD2, YP2CR, and TQ7W3 fields must be either 0 or 1.'; 2652 END IF; 2653 END// 2654 ---- 2655 2656 exec 2657 CREATE TRIGGER SZQWJ_on_insert BEFORE INSERT ON SZQWJ 2658 FOR EACH ROW 2659 BEGIN 2660 IF 2661 (SELECT DZLIM FROM XOAOP WHERE id = NEW.CH3FR) NOT IN ('NER', 'BER', 'HR', 'MMR') 2662 THEN 2663 -- SET @custom_error_message = 'The ECUWU must be one of the following: ''NER'', ''BER'', ''HR'', ''MMR''.'; 2664 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2665 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The ECUWU must be one of the following: ''NER'', ''BER'', ''HR'', ''MMR''.'; 2666 END IF; 2667 IF 2668 NEW.D237E NOT IN (0, 1) 2669 THEN 2670 -- SET @custom_error_message = 'The D237E field must be either 0 or 1.'; 2671 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2672 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The D237E field must be either 0 or 1.'; 2673 END IF; 2674 END// 2675 ---- 2676 2677 exec 2678 CREATE TRIGGER SZQWJ_on_update BEFORE UPDATE ON SZQWJ 2679 FOR EACH ROW 2680 BEGIN 2681 IF 2682 NEW.CH3FR IS NOT NULL AND (NEW.CH3FR <> OLD.CH3FR) 2683 OR 2684 NEW.GXLUB IS NOT NULL AND (NEW.GXLUB <> OLD.GXLUB) 2685 OR 2686 NEW.JOGI6 IS NOT NULL AND (NEW.JOGI6 <> OLD.JOGI6) 2687 THEN 2688 -- SET @custom_error_message = 'For a built-in table, fields identifying where to apply and from where it originates can not be changed!'; 2689 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2690 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'For a built-in table, fields identifying where to apply and from where it originates can not be changed!'; 2691 END IF; 2692 IF 2693 (SELECT DZLIM FROM XOAOP WHERE id = NEW.CH3FR) NOT IN ('NER', 'BER', 'HR', 'MMR') 2694 THEN 2695 -- SET @custom_error_message = 'The ECUWU must be one of the following: ''NER'', ''BER'', ''HR'', ''MMR''.'; 2696 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2697 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The ECUWU must be one of the following: ''NER'', ''BER'', ''HR'', ''MMR''.'; 2698 END IF; 2699 IF 2700 NEW.D237E NOT IN (0, 1) 2701 THEN 2702 -- SET @custom_error_message = 'The D237E field must be either 0 or 1.'; 2703 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2704 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The D237E field must be either 0 or 1.'; 2705 END IF; 2706 END// 2707 ---- 2708 2709 exec 2710 CREATE TRIGGER JJGQT_on_insert BEFORE INSERT ON JJGQT 2711 FOR EACH ROW 2712 BEGIN 2713 IF 2714 (SELECT DZLIM FROM XOAOP WHERE id = NEW.CH3FR) NOT IN ('NER', 'BER', 'HR', 'MMR') 2715 THEN 2716 -- SET @custom_error_message = 'The ECUWU must be one of the following: ''NER'', ''BER'', ''HR'', ''MMR''.'; 2717 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2718 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The ECUWU must be one of the following: ''NER'', ''BER'', ''HR'', ''MMR''.'; 2719 END IF; 2720 END// 2721 ---- 2722 2723 exec 2724 CREATE TRIGGER JJGQT_on_update BEFORE UPDATE ON JJGQT 2725 FOR EACH ROW 2726 BEGIN 2727 IF 2728 (SELECT DZLIM FROM XOAOP WHERE id = NEW.CH3FR) NOT IN ('NER', 'BER', 'HR', 'MMR') 2729 THEN 2730 -- SET @custom_error_message = 'The ECUWU must be one of the following: ''NER'', ''BER'', ''HR'', ''MMR''.'; 2731 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2732 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The ECUWU must be one of the following: ''NER'', ''BER'', ''HR'', ''MMR''.'; 2733 END IF; 2734 END// 2735 ---- 2736 2737 exec 2738 CREATE TRIGGER moa_on_insert BEFORE INSERT ON moa 2739 FOR EACH ROW 2740 BEGIN 2741 IF 2742 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 2743 OR 2744 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 2745 THEN 2746 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2747 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2748 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2749 END IF; 2750 END// 2751 ---- 2752 2753 exec 2754 CREATE TRIGGER moa_on_update BEFORE UPDATE ON moa 2755 FOR EACH ROW 2756 BEGIN 2757 IF 2758 NEW.DZLIM IN (SELECT SVAZ4 FROM TPXHZ) 2759 OR 2760 NEW.F3YUE IN (SELECT SVAZ4 FROM TPXHZ) 2761 THEN 2762 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2763 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2764 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2765 END IF; 2766 END// 2767 ---- 2768 2769 exec 2770 CREATE TRIGGER ZTFET_on_insert BEFORE INSERT ON ZTFET 2771 FOR EACH ROW 2772 BEGIN 2773 IF 2774 NEW.CYZU6 IN (SELECT SVAZ4 FROM TPXHZ) 2775 OR 2776 NEW.AERTL IN (SELECT SVAZ4 FROM TPXHZ) 2777 OR 2778 NEW.SIJCN IN (SELECT SVAZ4 FROM TPXHZ) 2779 OR 2780 NEW.RTLWN IN (SELECT SVAZ4 FROM TPXHZ) 2781 OR 2782 NEW.ZMABC IN (SELECT SVAZ4 FROM TPXHZ) 2783 THEN 2784 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2785 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2786 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2787 END IF; 2788 END// 2789 ---- 2790 2791 exec 2792 CREATE TRIGGER ZTFET_on_update BEFORE UPDATE ON ZTFET 2793 FOR EACH ROW 2794 BEGIN 2795 IF 2796 NEW.CYZU6 IN (SELECT SVAZ4 FROM TPXHZ) 2797 OR 2798 NEW.AERTL IN (SELECT SVAZ4 FROM TPXHZ) 2799 OR 2800 NEW.SIJCN IN (SELECT SVAZ4 FROM TPXHZ) 2801 OR 2802 NEW.RTLWN IN (SELECT SVAZ4 FROM TPXHZ) 2803 OR 2804 NEW.ZMABC IN (SELECT SVAZ4 FROM TPXHZ) 2805 THEN 2806 -- SET @custom_error_message = (SELECT error_message FROM trigger_helper_error_message WHERE DZLIM = 'SVAZ4'); 2807 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2808 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2809 END IF; 2810 END// 2811 ---- 2812 2813 exec 2814 CREATE TRIGGER S3FQX_on_insert BEFORE INSERT ON S3FQX 2815 FOR EACH ROW 2816 BEGIN 2817 -- SET @custom_error_message = 'Insertion is forbidden to S3FQX.'; 2818 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2819 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Insertion is forbidden to S3FQX.'; 2820 END// 2821 ---- 2822 2823 exec 2824 CREATE TRIGGER S3FQX_on_update BEFORE UPDATE ON S3FQX 2825 FOR EACH ROW 2826 BEGIN 2827 IF NEW.ADWYM NOT IN (0, 1) 2828 THEN 2829 -- SET @custom_error_message = 'The ADWYM field is an int boolean (0/1).'; 2830 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2831 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The ADWYM field is an int boolean (0/1).'; 2832 END IF; 2833 IF NEW.FPUYA NOT IN (0, 1) 2834 THEN 2835 -- SET @custom_error_message = 'The FPUYA field is an int boolean (0/1).'; 2836 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2837 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The FPUYA field is an int boolean (0/1).'; 2838 END IF; 2839 END// 2840 ---- 2841 2842 exec 2843 CREATE TRIGGER S3FQX_on_delete BEFORE DELETE ON S3FQX 2844 FOR EACH ROW 2845 BEGIN 2846 -- SET @custom_error_message = 'Deletion is forbidden from S3FQX.'; 2847 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2848 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Deletion is forbidden from S3FQX.'; 2849 END// 2850 ---- 2851 2852 exec 2853 CREATE TRIGGER TPXBU_on_delete BEFORE DELETE ON TPXBU 2854 FOR EACH ROW 2855 BEGIN 2856 -- SET @custom_error_message = 'An TPXBU can not be deleted now. If it is a use-case please contact platform team.'; 2857 -- SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = @custom_error_message; 2858 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'An TPXBU can not be deleted now. If it is a use-case please contact platform team.'; 2859 END// 2860 ---- 2861 2862 exec 2863 CREATE TRIGGER THNTS_on_insert BEFORE INSERT ON THNTS 2864 FOR EACH ROW 2865 BEGIN 2866 IF 2867 NEW.IXUXU IS NULL 2868 THEN 2869 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The IXUXU field is mandatory.'; 2870 END IF; 2871 END// 2872 ---- 2873 2874 exec 2875 CREATE TRIGGER THNTS_on_update BEFORE UPDATE ON THNTS 2876 FOR EACH ROW 2877 BEGIN 2878 IF 2879 NEW.IXUXU IS NULL 2880 THEN 2881 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'The IXUXU field is mandatory.'; 2882 END IF; 2883 END// 2884 ---- 2885 2886 exec 2887 CREATE TRIGGER E2I7U_on_insert BEFORE INSERT ON E2I7U 2888 FOR EACH ROW 2889 BEGIN 2890 IF 2891 NEW.TW55N IN (SELECT SVAZ4 FROM TPXHZ) 2892 OR 2893 NEW.FGG57 IS NOT NULL AND NEW.FGG57 IN (SELECT SVAZ4 FROM TPXHZ) 2894 OR 2895 NEW.ZH72S IS NOT NULL AND NEW.ZH72S IN (SELECT SVAZ4 FROM TPXHZ) 2896 THEN 2897 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2898 END IF; 2899 IF 2900 NEW.FSK67 NOT IN ('zero_based', 'one_based', 'O7VZD') 2901 THEN 2902 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'FSK67 must be either zero_based, one_based, or O7VZD.'; 2903 END IF; 2904 IF 2905 NEW.FGG57 IS NOT NULL AND NEW.DKCAJ NOT IN (SELECT id FROM F35MI WHERE DZLIM = 'protein' OR DZLIM = 'micro_rna') 2906 THEN 2907 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Only protein or micro_rna TAFAX UWBAIs can have IYDZV.'; 2908 END IF; 2909 IF 2910 NEW.ZH72S IS NOT NULL AND NEW.DKCAJ NOT IN (SELECT id FROM F35MI WHERE DZLIM = 'protein') 2911 THEN 2912 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Only protein TAFAX UWBAIs can have ZH72S.'; 2913 END IF; 2914 IF 2915 NEW.FGG57 IS NOT NULL AND NEW.TCE7A IS NULL 2916 THEN 2917 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'TCE7A is mandatory if UWBAI has IYDZV.'; 2918 END IF; 2919 IF 2920 NEW.KNG7T IS NOT NULL 2921 THEN 2922 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'On insertion KNG7T must be null. The build-in process will find a correspondig for it.'; 2923 END IF; 2924 IF 2925 NEW.FGG57 IS NOT NULL OR NEW.ZH72S IS NOT NULL 2926 THEN 2927 UPDATE S3FQX SET ADWYM = 1, FPUYA = 1; 2928 END IF; 2929 END// 2930 ---- 2931 2932 exec 2933 CREATE TRIGGER E2I7U_on_update BEFORE UPDATE ON E2I7U 2934 FOR EACH ROW 2935 BEGIN 2936 IF 2937 NEW.TW55N IN (SELECT SVAZ4 FROM TPXHZ) 2938 OR 2939 NEW.FGG57 IS NOT NULL AND NEW.FGG57 IN (SELECT SVAZ4 FROM TPXHZ) 2940 OR 2941 NEW.ZH72S IS NOT NULL AND NEW.ZH72S IN (SELECT SVAZ4 FROM TPXHZ) 2942 THEN 2943 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'String field contains invalid value, like empty string, ''none'', ''null'', ''n/a'', ''nan'' etc.'; 2944 END IF; 2945 IF 2946 NEW.FSK67 NOT IN ('zero_based', 'one_based', 'O7VZD') 2947 THEN 2948 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'FSK67 must be either zero_based, one_based, or O7VZD.'; 2949 END IF; 2950 IF 2951 NEW.FGG57 IS NOT NULL AND NEW.DKCAJ NOT IN (SELECT id FROM F35MI WHERE DZLIM = 'protein' OR DZLIM = 'micro_rna') 2952 THEN 2953 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Only protein or micro_rna TAFAX UWBAIs can have IYDZV.'; 2954 END IF; 2955 IF 2956 NEW.ZH72S IS NOT NULL AND NEW.DKCAJ NOT IN (SELECT id FROM F35MI WHERE DZLIM = 'protein') 2957 THEN 2958 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Only protein TAFAX UWBAIs can have ZH72S.'; 2959 END IF; 2960 IF 2961 NEW.FGG57 IS NOT NULL AND NEW.TCE7A IS NULL 2962 THEN 2963 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'TCE7A is mandatory if UWBAI has IYDZV.'; 2964 END IF; 2965 END// 2966 ----