Skip to content

Instantly share code, notes, and snippets.

@hobodave

hobodave/gist:197698

Created September 30, 2009 02:43
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save hobodave/197698 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save hobodave/197698 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
mysql> use sentact_sbch
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show triggers\G
*************************** 1. row ***************************
Trigger: log_building_insert
Event: INSERT
Table: buildings
Statement: CALL update_transaction_log('buildings',NEW.id,'insert')
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 2. row ***************************
Trigger: log_building_update
Event: UPDATE
Table: buildings
Statement: CALL update_transaction_log('buildings',NEW.id,'update')
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 3. row ***************************
Trigger: log_building_delete
Event: DELETE
Table: buildings
Statement: CALL update_transaction_log('buildings',OLD.id,'delete')
Timing: BEFORE
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 4. row ***************************
Trigger: log_company_insert
Event: INSERT
Table: companies
Statement: CALL update_transaction_log('companies',NEW.id,'insert')
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 5. row ***************************
Trigger: log_company_update
Event: UPDATE
Table: companies
Statement: CALL update_transaction_log('companies',NEW.id,'update')
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 6. row ***************************
Trigger: log_company_delete
Event: DELETE
Table: companies
Statement: CALL update_transaction_log('companies',OLD.id,'delete')
Timing: BEFORE
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 7. row ***************************
Trigger: log_custom_field_insert
Event: INSERT
Table: custom_fields
Statement: BEGIN
IF NEW.classname = 'Ticket' THEN
CALL update_transaction_log('custom_fields',NEW.id,'insert');
CALL update_custom_related(NEW.id,'insert');
END IF;
END
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 8. row ***************************
Trigger: log_custom_field_update
Event: UPDATE
Table: custom_fields
Statement: BEGIN
IF NEW.classname = 'Ticket' THEN
CALL update_transaction_log('custom_fields',NEW.id,'update');
CALL update_custom_related(NEW.id,'update');
ELSEIF OLD.classname = 'Ticket' THEN
CALL update_transaction_log('custom_fields',NEW.id,'delete');
CALL update_custom_related(NEW.id,'delete');
END IF;
END
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 9. row ***************************
Trigger: log_custom_field_delete
Event: DELETE
Table: custom_fields
Statement: BEGIN
IF OLD.classname = 'Ticket' THEN
CALL update_transaction_log('custom_fields',OLD.id,'delete');
CALL update_custom_related(OLD.id,'delete');
END IF;
END
Timing: BEFORE
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 10. row ***************************
Trigger: log_custom_value_insert
Event: INSERT
Table: custom_values
Statement: BEGIN
DECLARE cname VARCHAR(255);
SELECT classname FROM custom_fields WHERE id = NEW.custom_field_id INTO cname;
IF cname = 'Ticket' THEN
CALL update_transaction_log('custom_values',NEW.custom_value_id,'insert');
END IF;
END
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 11. row ***************************
Trigger: log_custom_value_update
Event: UPDATE
Table: custom_values
Statement: BEGIN
DECLARE cname VARCHAR(255);
SELECT classname FROM custom_fields WHERE id = NEW.custom_field_id INTO cname;
IF cname = 'Ticket' THEN
CALL update_transaction_log('custom_values',NEW.custom_value_id,'update');
END IF;
END
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 12. row ***************************
Trigger: log_custom_value_delete
Event: DELETE
Table: custom_values
Statement: BEGIN
DECLARE cname VARCHAR(255);
SELECT classname FROM custom_fields WHERE id = OLD.custom_field_id INTO cname;
IF cname = 'Ticket' THEN
CALL update_transaction_log('custom_values',OLD.custom_value_id,'delete');
END IF;
END
Timing: BEFORE
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 13. row ***************************
Trigger: log_department_insert
Event: INSERT
Table: departments
Statement: CALL update_transaction_log('departments',NEW.id,'insert')
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 14. row ***************************
Trigger: log_department_update
Event: UPDATE
Table: departments
Statement: CALL update_transaction_log('departments',NEW.id,'update')
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 15. row ***************************
Trigger: log_department_delete
Event: DELETE
Table: departments
Statement: CALL update_transaction_log('departments',OLD.id,'delete')
Timing: BEFORE
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 16. row ***************************
Trigger: log_division_insert
Event: INSERT
Table: divisions
Statement: CALL update_transaction_log('divisions',NEW.id,'insert')
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 17. row ***************************
Trigger: log_division_update
Event: UPDATE
Table: divisions
Statement: CALL update_transaction_log('divisions',NEW.id,'update')
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 18. row ***************************
Trigger: log_division_delete
Event: DELETE
Table: divisions
Statement: CALL update_transaction_log('divisions',OLD.id,'delete')
Timing: BEFORE
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 19. row ***************************
Trigger: log_priority_insert
Event: INSERT
Table: priorities
Statement: CALL update_transaction_log('priorities',NEW.id,'insert')
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 20. row ***************************
Trigger: log_priority_update
Event: UPDATE
Table: priorities
Statement: CALL update_transaction_log('priorities',NEW.id,'update')
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 21. row ***************************
Trigger: log_priority_delete
Event: DELETE
Table: priorities
Statement: CALL update_transaction_log('priorities',OLD.id,'delete')
Timing: BEFORE
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 22. row ***************************
Trigger: log_problemgroup_insert
Event: INSERT
Table: problemgroups
Statement: CALL update_transaction_log('problemgroups',NEW.id,'insert')
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 23. row ***************************
Trigger: log_problemgroup_update
Event: UPDATE
Table: problemgroups
Statement: CALL update_transaction_log('problemgroups',NEW.id,'update')
Timing: AFTER
Created: NULL
sql_mode:
Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 24. row ***************************
Trigger: log_problemgroup_delete
Event: DE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment