| 1 | delimiter //
|
|---|
| 2 |
|
|---|
| 3 | CREATE TRIGGER recorded_check_insert BEFORE INSERT ON recorded
|
|---|
| 4 | FOR EACH ROW
|
|---|
| 5 | BEGIN
|
|---|
| 6 | IF NEW.subtitle = '\0' THEN
|
|---|
| 7 | SET NEW.subtitle = '';
|
|---|
| 8 | END IF;
|
|---|
| 9 | IF NEW.description = '\0' THEN
|
|---|
| 10 | SET NEW.description = '';
|
|---|
| 11 | END IF;
|
|---|
| 12 | END;//
|
|---|
| 13 |
|
|---|
| 14 | CREATE TRIGGER recorded_check_update BEFORE UPDATE ON recorded
|
|---|
| 15 | FOR EACH ROW
|
|---|
| 16 | BEGIN
|
|---|
| 17 | IF NEW.subtitle = '\0' THEN
|
|---|
| 18 | SET NEW.subtitle = '';
|
|---|
| 19 | END IF;
|
|---|
| 20 | IF NEW.description = '\0' THEN
|
|---|
| 21 | SET NEW.description = '';
|
|---|
| 22 | END IF;
|
|---|
| 23 | END;//
|
|---|
| 24 |
|
|---|
| 25 | CREATE TRIGGER program_check_insert BEFORE INSERT ON program
|
|---|
| 26 | FOR EACH ROW
|
|---|
| 27 | BEGIN
|
|---|
| 28 | IF NEW.subtitle = '\0' THEN
|
|---|
| 29 | SET NEW.subtitle = '';
|
|---|
| 30 | END IF;
|
|---|
| 31 | IF NEW.description = '\0' THEN
|
|---|
| 32 | SET NEW.description = '';
|
|---|
| 33 | END IF;
|
|---|
| 34 | END;//
|
|---|
| 35 |
|
|---|
| 36 | CREATE TRIGGER program_check_update BEFORE UPDATE ON program
|
|---|
| 37 | FOR EACH ROW
|
|---|
| 38 | BEGIN
|
|---|
| 39 | IF NEW.subtitle = '\0' THEN
|
|---|
| 40 | SET NEW.subtitle = '';
|
|---|
| 41 | END IF;
|
|---|
| 42 | IF NEW.description = '\0' THEN
|
|---|
| 43 | SET NEW.description = '';
|
|---|
| 44 | END IF;
|
|---|
| 45 | END;//
|
|---|
| 46 |
|
|---|
| 47 | delimiter ;
|
|---|
