{"slug":"wp-simple-tracker","name":"WP Simple Tracker","description":"Adds a simple issue tracking system to your WordPress blog.","author":"CiaranG","active_installs":10,"version":"0.33","wp_org_url":"https://wordpress.org/plugins/wp-simple-tracker/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"it_comment","full_table_name":"wp_it_comment","description":"Stores it comment data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"comment_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"comment_issue","type":"int(11)","nullable":true,"primary_key":false},{"name":"comment_poster","type":"int(11)","nullable":true,"primary_key":false},{"name":"comment_body","type":"text","nullable":true,"primary_key":false},{"name":"comment_time","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_it_comment ( comment_id int(11) NOT NULL AUTO_INCREMENT, comment_issue int(11), comment_poster int(11), comment_body text, comment_time int(11), UNIQUE KEY comment_id (comment_id) );"},{"table_name":"it_issue","full_table_name":"wp_it_issue","description":"Stores it issue data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"issue_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"issue_tracker","type":"int(3)","nullable":true,"primary_key":false},{"name":"issue_summary","type":"varchar(256)","nullable":true,"primary_key":false},{"name":"issue_type","type":"int(3)","nullable":true,"primary_key":false},{"name":"issue_status","type":"int(3)","nullable":true,"primary_key":false},{"name":"issue_description","type":"text","nullable":true,"primary_key":false},{"name":"issue_assignee","type":"int(11)","nullable":true,"primary_key":false},{"name":"issue_reporter","type":"int(11)","nullable":true,"primary_key":false},{"name":"issue_time","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_it_issue ( issue_id int(11) NOT NULL AUTO_INCREMENT, issue_tracker int(3), issue_summary varchar(256), issue_type int(3), issue_status int(3), issue_description text, issue_assignee int(11) default 0, issue_reporter int(11), issue_time int(11), UNIQUE KEY issue_id (issue_id) );"},{"table_name":"it_starred","full_table_name":"wp_it_starred","description":"Stores it starred data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"issue_id","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_it_starred ( user_id int(11), issue_id int(11) );"},{"table_name":"it_status","full_table_name":"wp_it_status","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[{"name":"status_id","type":"int(3)","nullable":false,"primary_key":true},{"name":"status_tracker","type":"int(3)","nullable":true,"primary_key":false},{"name":"status_name","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"status_colour","type":"varchar(6)","nullable":true,"primary_key":false},{"name":"status_strike","type":"int(1)","nullable":true,"primary_key":false},{"name":"status_order","type":"int(3)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_it_status ( status_id int(3) NOT NULL AUTO_INCREMENT, status_tracker int(3), status_name varchar(64), status_colour varchar(6), status_strike int(1), status_order int(3), UNIQUE KEY status_id (status_id) );"},{"table_name":"it_tracker","full_table_name":"wp_it_tracker","description":"Stores it tracker data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"it_type","full_table_name":"wp_it_type","description":"Stores it type data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"type_id","type":"int(3)","nullable":false,"primary_key":true},{"name":"type_tracker","type":"int(3)","nullable":true,"primary_key":false},{"name":"type_name","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"type_colour","type":"varchar(6)","nullable":true,"primary_key":false},{"name":"type_order","type":"int(3)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_it_type ( type_id int(3) NOT NULL AUTO_INCREMENT, type_tracker int(3), type_name varchar(64), type_colour varchar(6), type_order int(3), UNIQUE KEY type_id (type_id) );"}],"table_count":6}