|
Last change
on this file since 20105 was 20105, checked in by maslowski, 3 years ago |
|
Added Triggers for DataOnDisk and a seperate table for auxiliary files.
|
|
File size:
310 bytes
|
| Line | |
|---|
| 1 | delimiter $$
|
|---|
| 2 | CREATE TRIGGER prop_trigger
|
|---|
| 3 | BEFORE UPDATE ON DataOnDisk
|
|---|
| 4 | FOR EACH ROW
|
|---|
| 5 | BEGIN
|
|---|
| 6 | IF NEW.header > 0 THEN
|
|---|
| 7 | SET NEW.calibration = 6;
|
|---|
| 8 | END IF;
|
|---|
| 9 | IF NEW.calibration > 0 THEN
|
|---|
| 10 | SET NEW.auxiliary = 6;
|
|---|
| 11 | SET NEW.callisto = 6;
|
|---|
| 12 | END IF;
|
|---|
| 13 | IF NEW.callisto > 0 THEN
|
|---|
| 14 | SET NEW.star = 6;
|
|---|
| 15 | END IF;
|
|---|
| 16 | END; $$
|
|---|
| 17 | delimiter ;
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
