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 ;
|
---|