{"slug":"iq-referral-program-for-woocommerce","name":"IQ Referral System for WooCommerce","description":"A productive affiliate program system that will help you motivate you to attract more customers by your users Lang: [EN/RU]","author":"LumpX","active_installs":0,"version":"1.0.3","wp_org_url":"https://wordpress.org/plugins/iq-referral-program-for-woocommerce/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"iq_rpw_actions_logs","full_table_name":"wp_iq_rpw_actions_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"uid","type":"int(20)","nullable":false,"primary_key":false},{"name":"log","type":"text(0)","nullable":false,"primary_key":false},{"name":"date","type":"int(20)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_iq_rpw_actions_logs` ( `id` int (20) NOT NULL AUTO_INCREMENT, `uid` int(20) NOT NULL DEFAULT 0, `log` text(0) NOT NULL DEFAULT '', `date` int(20) NOT NULL DEFAULT 0, PRIMARY KEY `id` (`id`) );"},{"table_name":"iq_rpw_logs","full_table_name":"wp_iq_rpw_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"uid_father","type":"int(20)","nullable":false,"primary_key":false},{"name":"uid_target","type":"int(20)","nullable":false,"primary_key":false},{"name":"sum","type":"double","nullable":true,"primary_key":false},{"name":"currency","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"up","type":"tinyint(2)","nullable":false,"primary_key":false},{"name":"date","type":"int(20)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_iq_rpw_logs` ( `id` int (20) NOT NULL AUTO_INCREMENT, `uid_father` int(20) NOT NULL DEFAULT 0, `uid_target` int(20) NOT NULL DEFAULT 0, `sum` double DEFAULT 0, `currency` varchar(32) NOT NULL DEFAULT '', `up` tinyint(2) NOT NULL DEFAULT 1, `date` int(20) NOT NULL DEFAULT 0, PRIMARY KEY `id` (`id`) );"},{"table_name":"iq_rpw_settings","full_table_name":"wp_iq_rpw_settings","description":"Stores iq rpw settings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"key","type":"varchar","nullable":false,"primary_key":false},{"name":"params_json","type":"text(0)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_iq_rpw_settings` ( `key` varchar (32) NOT NULL DEFAULT '', `params_json` text(0) NOT NULL DEFAULT '', PRIMARY KEY `key` (`key`) );"},{"table_name":"iq_rpw_users","full_table_name":"wp_iq_rpw_users","description":"Stores iq rpw users data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"uid","type":"int(20)","nullable":false,"primary_key":false},{"name":"ref_uid","type":"int(20)","nullable":false,"primary_key":false},{"name":"ref_visits","type":"int(20)","nullable":false,"primary_key":false},{"name":"ref_balance_json","type":"text(0)","nullable":true,"primary_key":false},{"name":"ref_sell","type":"int(20)","nullable":false,"primary_key":false},{"name":"turnover_json","type":"text(0)","nullable":false,"primary_key":false},{"name":"ref_shopping","type":"int(20)","nullable":false,"primary_key":false},{"name":"ref_percent","type":"tinyint(4)","nullable":false,"primary_key":false},{"name":"ref_code","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ref_father_uid","type":"int(20)","nullable":false,"primary_key":false},{"name":"ref_enable","type":"tinyint(2)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_iq_rpw_users` ( `uid` int(20) NOT NULL DEFAULT 0, `ref_uid` int(20) NOT NULL DEFAULT 0, `ref_visits` int(20) NOT NULL DEFAULT 0, `ref_balance_json` text(0) DEFAULT '[]', `ref_sell` int(20) NOT NULL DEFAULT 0, `turnover_json` text(0) NOT NULL DEFAULT '[]', `ref_shopping` int(20) NOT NULL DEFAULT 0, `ref_percent` tinyint(4) NOT NULL DEFAULT 0, `ref_code` varchar(255) NOT NULL, `ref_father_uid` int(20) NOT NULL DEFAULT 0, `ref_enable` tinyint(2) NOT NULL DEFAULT 1, PRIMARY KEY uid (`uid`) );"},{"table_name":"iq_rpw_withdraw_forms","full_table_name":"wp_iq_rpw_withdraw_forms","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"uid","type":"int(20)","nullable":false,"primary_key":false},{"name":"system_id","type":"int(5)","nullable":false,"primary_key":false},{"name":"requisites","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"sum","type":"double","nullable":true,"primary_key":false},{"name":"comission","type":"int(5)","nullable":true,"primary_key":false},{"name":"currency","type":"varchar(32)","nullable":true,"primary_key":false},{"name":"comment","type":"text(0)","nullable":true,"primary_key":false},{"name":"comment_admin","type":"text(0)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(2)","nullable":false,"primary_key":false},{"name":"date","type":"int(20)","nullable":false,"primary_key":false},{"name":"do_date","type":"int(20)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_iq_rpw_withdraw_forms` ( `id` int (20) NOT NULL AUTO_INCREMENT, `uid` int(20) NOT NULL DEFAULT 0, `system_id` int(5) NOT NULL DEFAULT 0, `requisites` varchar(100) NOT NULL DEFAULT '', `sum` double DEFAULT 0, `comission` int(5) DEFAULT 0, `currency` varchar(32) DEFAULT '', `comment` text(0) DEFAULT '', `comment_admin` text(0) DEFAULT '', `status` tinyint(2) NOT NULL DEFAULT 0, `date` int(20) NOT NULL DEFAULT 0, `do_date` int(20) NOT NULL DEFAULT 0, PRIMARY KEY `id` (`id`) );"},{"table_name":"iq_rpw_withdraw_status","full_table_name":"wp_iq_rpw_withdraw_status","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":false},{"name":"name","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"classes","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_iq_rpw_withdraw_status` ( `id` int (20) NOT NULL DEFAULT 0, `name` varchar(64) NOT NULL DEFAULT '', `classes` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY `id` (`id`) );"},{"table_name":"iq_rpw_withdraw_systems","full_table_name":"wp_iq_rpw_withdraw_systems","description":"Stores iq rpw withdraw systems data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"min","type":"double","nullable":true,"primary_key":false},{"name":"commision","type":"int(4)","nullable":true,"primary_key":false},{"name":"enable","type":"tinyint(2)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_iq_rpw_withdraw_systems` ( `id` int (20) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '', `min` double DEFAULT 0, `commision` int(4) DEFAULT 0, `enable` tinyint(2) NOT NULL DEFAULT 1, PRIMARY KEY `id` (`id`) );"}],"table_count":7}