{"table_name":"emplmasy_employee_sales","full_table_name":"wp_emplmasy_employee_sales","description":"Stores emplmasy employee sales data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_emplmasy_employee_sales ( id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, date date NOT NULL, amount decimal(10,2) NOT NULL, description text NOT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id), KEY date (date) ) $charset_collate;\"; dbDelta($sql);","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"employee-management-system","name":"Employee Management System","active_installs":10,"version":"1.0.3","wp_org_url":"https://wordpress.org/plugins/employee-management-system/"}}