Paste P7811

(An Untitled Masterwork)
ActivePublic

Authored by Marostegui on Thu, Nov 15, 2:53 PM.
root@labsdb1009.eqiad.wmnet[enwiki]> show triggers\G
*************************** 1. row ***************************
Trigger: abuse_filter_log_insert
Event: INSERT
Table: abuse_filter_log
Statement: SET NEW.afl_ip = ''
Timing: BEFORE
Created: NULL
sql_mode: IGNORE_BAD_TABLE_OPTIONS
Definer: root@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: binary
*************************** 2. row ***************************
Trigger: abuse_filter_log_update
Event: UPDATE
Table: abuse_filter_log
Statement: SET NEW.afl_ip = ''
Timing: BEFORE
Created: NULL
sql_mode: IGNORE_BAD_TABLE_OPTIONS
Definer: root@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: binary
*************************** 3. row ***************************
Trigger: recentchanges_insert
Event: INSERT
Table: recentchanges
Statement: SET NEW.rc_ip = ''
Timing: BEFORE
Created: NULL
sql_mode: IGNORE_BAD_TABLE_OPTIONS
Definer: root@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: binary
*************************** 4. row ***************************
Trigger: recentchanges_update
Event: UPDATE
Table: recentchanges
Statement: SET NEW.rc_ip = ''
Timing: BEFORE
Created: NULL
sql_mode: IGNORE_BAD_TABLE_OPTIONS
Definer: root@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: binary
*************************** 5. row ***************************
Trigger: revision_insert
Event: INSERT
Table: revision
Statement: SET NEW.rev_text_id = 0
Timing: BEFORE
Created: NULL
sql_mode: IGNORE_BAD_TABLE_OPTIONS
Definer: root@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: binary
*************************** 6. row ***************************
Trigger: revision_update
Event: UPDATE
Table: revision
Statement: SET NEW.rev_text_id = 0
Timing: BEFORE
Created: NULL
sql_mode: IGNORE_BAD_TABLE_OPTIONS
Definer: root@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: binary
*************************** 7. row ***************************
Trigger: user_insert
Event: INSERT
Table: user
Statement: SET NEW.user_password = '', NEW.user_newpassword = '', NEW.user_email = '', NEW.user_options = '', NEW.user_token = '', NEW.user_email_authenticated = '', NEW.user_email_token = '', NEW.user_email_token_expires = '', NEW.user_newpass_time = ''
Timing: BEFORE
Created: NULL
sql_mode: IGNORE_BAD_TABLE_OPTIONS
Definer: root@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: binary
*************************** 8. row ***************************
Trigger: user_update
Event: UPDATE
Table: user
Statement: SET NEW.user_password = '', NEW.user_newpassword = '', NEW.user_email = '', NEW.user_options = '', NEW.user_token = '', NEW.user_email_authenticated = '', NEW.user_email_token = '', NEW.user_email_token_expires = '', NEW.user_newpass_time = ''
Timing: BEFORE
Created: NULL
sql_mode: IGNORE_BAD_TABLE_OPTIONS
Definer: root@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: binary
8 rows in set (0.00 sec)
Marostegui created this paste.Thu, Nov 15, 2:53 PM