{"slug":"rest-routes","name":"Rest Routes – Custom Endpoints for WordPress REST API","description":"Rest Routes is the ultimate solution for adding custom endpoints to your WordPress REST API effortlessly.","author":"Rest Routes","active_installs":80,"version":"5.5.5","wp_org_url":"https://wordpress.org/plugins/rest-routes/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"aa","full_table_name":"wp_aa","description":"Stores aa data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `aa` (\\n\" . \" `id` int(11) NOT NULL,\\n\" . \" `rTime` timestamp(3) NOT NULL DEFAULT '0000-00-00 00:00:00.000' ON UPDATE CURRENT_TIMESTAMP(3),\\n\" . \" PRIMARY KEY (`id`)\\n\" . ') ENGINE"},{"table_name":"actor","full_table_name":"wp_actor","description":"Stores actor data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"actor_id","type":"smallint(5) unsigned","nullable":false,"primary_key":true},{"name":"first_name","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"last_name","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"last_update","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `actor` ( `actor_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(45) NOT NULL, `last_name` varchar(45) NOT NULL, `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`actor_id`), KEY `idx_actor_last_name` (`last_name`) ) ENGINE"},{"table_name":"address","full_table_name":"wp_address","description":"Stores address data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"address_id","type":"smallint(5) unsigned","nullable":false,"primary_key":true},{"name":"address","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"address2","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"district","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"city_id","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"postal_code","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"last_update","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `address` ( `address_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `address` varchar(50) NOT NULL, `address2` varchar(50) DEFAULT NULL, `district` varchar(20) NOT NULL, `city_id` smallint(5) unsigned NOT NULL, `postal_code` varchar(10) DEFAULT NULL, `phone` varchar(20) NOT NULL, `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`address_id`), KEY `idx_fk_city_id` (`city_id`), CONSTRAINT `fk_address_city` FOREIGN KEY (`city_id`) REFERENCES `city` (`city_id`) ON UPDATE CASCADE ) ENGINE"},{"table_name":"audio","full_table_name":"wp_audio","description":"Stores audio data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_audio` (' . \" `somedata` int(11) DEFAULT NULL COMMENT 'ma data', \" . \" `someinfo` int(11) DEFAULT NULL COMMENT 'ma info' \" . ' )' );"},{"table_name":"entries","full_table_name":"wp_entries","description":"Stores entries data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"fk_ug_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(10,2)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `entries` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fk_ug_id` int(11) DEFAULT NULL, `amount` decimal(10,2) DEFAULT NULL, PRIMARY KEY (`id`), KEY `entries__ug` (`fk_ug_id` DESC), KEY `entries__ug2` (`fk_ug_id` ASC), KEY `33` (`id` ASC, `fk_ug_id` DESC) ) /*!50100 TABLESPACE `innodb_system` */ ENGINE=InnoDB AUTO_INCREMENT=4465 DEFAULT CHARSET=utf8 SQL );"},{"table_name":"jos_core_acl_aro","full_table_name":"wp_jos_core_acl_aro","description":"Stores jos core acl aro data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `jos_core_acl_aro` (\\n\" . \" `id` int(11) NOT NULL,\\n\" . \" `section_value` varchar(240) NOT NULL DEFAULT '0',\\n\" . \" `value` varchar(240) NOT NULL DEFAULT '',\\n\" . \" `order_value` int(11) NOT NULL DEFAULT '0',\\n\" . \" `name` varchar(255) NOT NULL DEFAULT '',\\n\" . \" `hidden` int(11) NOT NULL DEFAULT '0',\\n\" . \" PRIMARY KEY (`id`),\\n\" . \" UNIQUE KEY `jos_section_value_value_aro` (`section_value`(100),`value`(15)) USING BTREE,\\n\" . \" KEY `jos_gacl_hidden_aro` (`hidden`)\\n\" . ') ENGINE"},{"table_name":"page_rebuild_control","full_table_name":"wp_page_rebuild_control","description":"Stores page rebuild control data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `page_rebuild_control` ( `proc_row_number` int DEFAULT NULL, `place_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `place_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `place_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `waterway_id` varchar(20) COLLATE"},{"table_name":"payment","full_table_name":"wp_payment","description":"Stores payment data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"payment_id","type":"smallint(5) unsigned","nullable":false,"primary_key":true},{"name":"customer_id","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"staff_id","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"rental_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(5,2)","nullable":false,"primary_key":false},{"name":"payment_date","type":"datetime","nullable":false,"primary_key":false},{"name":"last_update","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `payment` ( `payment_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `customer_id` smallint(5) unsigned NOT NULL, `staff_id` tinyint(3) unsigned NOT NULL, `rental_id` int(11) DEFAULT NULL, `amount` decimal(5,2) NOT NULL, `payment_date` datetime NOT NULL, `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`payment_id`), KEY `idx_fk_staff_id` (`staff_id`), KEY `idx_fk_customer_id` (`customer_id`), KEY `fk_payment_rental` (`rental_id`), CONSTRAINT `fk_payment_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`customer_id`) ON UPDATE CASCADE, CONSTRAINT `fk_payment_rental` FOREIGN KEY (`rental_id`) REFERENCES `rental` (`rental_id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `fk_payment_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`staff_id`) ON UPDATE CASCADE ) ENGINE"},{"table_name":"pma__bookmark","full_table_name":"wp_pma__bookmark","description":"Stores pma  bookmark data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"create table if not exists `pma__bookmark` (' . \"\\n\" . '`id` int(11) not null auto_increment,' . \"\\n\" . '`dbase` varchar(255) not null default \"\",' . \"\\n\" . '`user` varchar(255) not null default \"\",' . \"\\n\" . '`label` varchar(255) collate"},{"table_name":"pma_test","full_table_name":"wp_pma_test","description":"Stores pma test data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `pma_test` (' . \"\\n\" . ' `test_id` int(32) NOT NULL,' . \"\\n\" . ' `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP' . \"\\n\" . ') ENGINE"},{"table_name":"ptest","full_table_name":"wp_ptest","description":"Stores ptest data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"event_date","type":"date","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE ptest ( `event_date` date NOT NULL ) ENGINE"},{"table_name":"searches","full_table_name":"wp_searches","description":"Stores searches data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `searches` (' . ' `id` int(10) unsigned NOT NULL AUTO_INCREMENT,' . ' `name` varchar(255) COLLATE"},{"table_name":"t1","full_table_name":"wp_t1","description":"Stores t1 data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE IF NOT EXISTS t1 (' . \" c1 int(11) NOT NULL DEFAULT '0' COMMENT 'xxx'\" . ') ENGINE"},{"table_name":"tbl","full_table_name":"wp_tbl","description":"Stores tbl data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":false}],"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);"},{"table_name":"test","full_table_name":"wp_test","description":"Stores test data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `test` (\\n\" . \" `txt` varchar(10)\\n\" . \");"},{"table_name":"ts","full_table_name":"wp_ts","description":"Stores ts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE ts (' . \"\\n\" . ' `id` int,' . \"\\n\" . ' `purchased` date' . \"\\n\" . ') ' . \"\\n\" . 'PARTITION BY RANGE(YEAR(purchased))' . \"\\n\" . 'PARTITIONS 3' . \"\\n\" . 'SUBPARTITION BY HASH(TO_DAYS(purchased))' . \"\\n\" . 'SUBPARTITIONS 2' . \"\\n\" . '(' . \"\\n\" . 'PARTITION p0 VALUES LESS THAN (1990) (' . \"\\n\" . 'SUBPARTITION s0,' . \"\\n\" . 'SUBPARTITION s1' . \"\\n\" . '),' . \"\\n\" . 'PARTITION p1 VALUES LESS THAN (2000) (' . \"\\n\" . 'SUBPARTITION s2,' . \"\\n\" . 'SUBPARTITION s3' . \"\\n\" . '),' . \"\\n\" . 'PARTITION p2 VALUES LESS THAN MAXVALUE (' . \"\\n\" . 'SUBPARTITION s4,' . \"\\n\" . 'SUBPARTITION s5' . \"\\n\" . ')' . \"\\n\" . ')'; $parser = new Parser($query);"}],"table_count":16}