{"slug":"giveasap","name":"Simple Giveaways – Grow your business, email lists and traffic with contests","description":"Create a Simple Giveaway or Giveaways and grow your email list. Embed them in a post or in a sidebar to increase the conversion.","author":"Igor Benic","active_installs":400,"version":"2.50.0","wp_org_url":"https://wordpress.org/plugins/giveasap/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"giveasap_actions","full_table_name":"wp_giveasap_actions","description":"Stores giveasap actions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_giveasap_actions` (\\n  `id` bigint NOT NULL AUTO_INCREMENT,\\n  `subscriber_id` bigint NOT NULL,\\n  `giveaway_id` bigint NOT NULL,\\n  `instance` bigint NOT NULL,\\n  `entries` bigint NOT NULL DEFAULT '1',\\n  `action` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'invalid',\\n  `data` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `datetime` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"giveasap_entries","full_table_name":"wp_giveasap_entries","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_giveasap_entries` (\\n  `id` bigint NOT NULL AUTO_INCREMENT,\\n  `post_id` bigint NOT NULL,\\n  `email` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `entries` bigint NOT NULL DEFAULT '1',\\n  `ref_id` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `active` tinyint NOT NULL DEFAULT '0',\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'active',\\n  `date` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"giveasap_meta","full_table_name":"wp_giveasap_meta","description":"Stores additional metadata (key-value pairs) for giveasap records.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_giveasap_meta` (\\n  `meta_id` bigint NOT NULL AUTO_INCREMENT,\\n  `giveasap_id` bigint NOT NULL,\\n  `meta_key` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,\\n  PRIMARY KEY (`meta_id`),\\n  KEY `giveasap_id` (`giveasap_id`),\\n  KEY `meta_key` (`meta_key`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":3}