{"slug":"hizzle-downloads","name":"Simple Download Manager – Hizzle Downloads","description":"Easily add, restrict, and track digital downloads in WordPress — protect files with passwords, user roles, IPs, or subscriber access.","author":"Noptin Newsletter Team","active_installs":10,"version":"1.3.0","wp_org_url":"https://wordpress.org/plugins/hizzle-downloads/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"hizzle_download_files","full_table_name":"wp_hizzle_download_files","description":"Stores hizzle download files data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_hizzle_download_files` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `file_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `file_url` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `git_url` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `category` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `download_count` bigint unsigned NOT NULL DEFAULT '0',\\n  `menu_order` bigint unsigned NOT NULL DEFAULT '0',\\n  `metadata` text COLLATE utf8mb4_unicode_520_ci,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `file_name` (`file_name`(191)),\\n  UNIQUE KEY `git_url` (`git_url`(191))\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"hizzle_download_logs","full_table_name":"wp_hizzle_download_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_hizzle_download_logs` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `timestamp` datetime NOT NULL,\\n  `file_id` bigint unsigned NOT NULL,\\n  `user_id` bigint unsigned DEFAULT NULL,\\n  `user_ip_address` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `file_id` (`file_id`),\\n  KEY `timestamp` (`timestamp`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"hizzle_log","full_table_name":"wp_hizzle_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"log_id","type":"bigint UNSIGNED","nullable":false,"primary_key":true},{"name":"timestamp","type":"datetime","nullable":false,"primary_key":false},{"name":"level","type":"smallint(4)","nullable":false,"primary_key":false},{"name":"source","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"message","type":"longtext","nullable":false,"primary_key":false},{"name":"context","type":"longtext","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_hizzle_log ( log_id bigint UNSIGNED NOT NULL AUTO_INCREMENT, timestamp datetime NOT NULL, level smallint(4) NOT NULL, source varchar(200) NOT NULL, message longtext NOT NULL, context longtext NULL, PRIMARY KEY (log_id), KEY level (level) ) $collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );"}],"table_count":3}