{"table_name":"tbl","full_table_name":"wp_tbl","description":"Stores tbl data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE tbl (id INT)', [ 'reload' => true, 'querytype' => 'CREATE', ], ], [ 'CHECK TABLE tbl', [ 'is_maint' => true, 'querytype' => 'CHECK', ], ], [ 'DELETE FROM tbl', [ 'is_affected' => true, 'is_delete' => true, 'querytype' => 'DELETE', ], ], [ 'DROP VIEW v', [ 'reload' => true, 'querytype' => 'DROP', ], ], [ 'DROP DATABASE db', [ 'drop_database' => true, 'reload' => true, 'querytype' => 'DROP', ], ], [ 'EXPLAIN tbl', [ 'is_explain' => true, 'querytype' => 'EXPLAIN', ], ], [ 'LOAD DATA INFILE \\'/tmp/test.txt\\' INTO TABLE test', [ 'is_affected' => true, 'is_insert' => true, 'querytype' => 'LOAD', ], ], [ 'INSERT INTO tbl VALUES (1)', [ 'is_affected' => true, 'is_insert' => true, 'querytype' => 'INSERT', ], ], [ 'REPLACE INTO tbl VALUES (2)', [ 'is_affected' => true, 'is_replace' => true, 'is_insert' => true, 'querytype' => 'REPLACE', ], ], [ 'SELECT 1', [ 'is_select' => true, 'querytype' => 'SELECT', ], ], [ 'SELECT * FROM tbl', [ 'is_select' => true, 'select_from' => true, 'querytype' => 'SELECT', ], ], [ 'SELECT DISTINCT * FROM tbl LIMIT 0, 10 ORDER BY id', [ 'distinct' => true, 'is_select' => true, 'select_from' => true, 'limit' => true, 'order' => true, 'querytype' => 'SELECT', ], ], [ 'SELECT * FROM actor GROUP BY actor_id', [ 'is_group' => true, 'is_select' => true, 'select_from' => true, 'group' => true, 'querytype' => 'SELECT', ], ], [ 'SELECT col1, col2 FROM table1 PROCEDURE ANALYSE(10, 2000);","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":false}],"plugin":{"slug":"rest-routes","name":"Rest Routes – Custom Endpoints for WordPress REST API","active_installs":80,"version":"5.5.5","wp_org_url":"https://wordpress.org/plugins/rest-routes/"}}