{"table_name":"erp_holidays_indv","full_table_name":"wp_erp_holidays_indv","description":"Stores erp holidays indv data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS `wp_erp_holidays_indv` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `holiday_id` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_user_leaves` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `request_id` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $table_schema as $table ) { dbDelta( $table );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"holiday_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"request_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"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":"erp","name":"ERP: Complete HR, Recruitment, Accounting & CRM Suite with WooCommerce CRM Support","active_installs":5000,"version":"1.17.5","wp_org_url":"https://wordpress.org/plugins/erp/"}}