{"slug":"aistore-support-ticket","name":"Simple Support Tickets","description":"A simple support ticket system allowing users to submit tickets from the front end and admins to respond from the backend.","author":"susheelhbti","active_installs":0,"version":"1.2","wp_org_url":"https://wordpress.org/plugins/aistore-support-ticket/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"support_ticket","full_table_name":"wp_support_ticket","description":"Stores support ticket data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(100)","nullable":false,"primary_key":true},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":false,"primary_key":false},{"name":"category","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"priority","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(100)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_support_ticket ( ID int(100) NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL, description text NOT NULL, category varchar(100) NOT NULL, priority varchar(20) NOT NULL DEFAULT 'medium', user_id int(100) NOT NULL, status varchar(100) NOT NULL DEFAULT 'pending', created_at timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (ID) ) $charset;\" );"},{"table_name":"support_ticket_message","full_table_name":"wp_support_ticket_message","description":"Stores support ticket message data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(100)","nullable":false,"primary_key":true},{"name":"message","type":"text","nullable":false,"primary_key":false},{"name":"user_id","type":"int(100)","nullable":false,"primary_key":false},{"name":"ticket_id","type":"int(100)","nullable":false,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_support_ticket_message ( ID int(100) NOT NULL AUTO_INCREMENT, message text NOT NULL, user_id int(100) NOT NULL, ticket_id int(100) NOT NULL, created_at timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (ID) ) $charset;\" );"}],"table_count":2}