{"table_name":"givasso_donors","full_table_name":"wp_givasso_donors","description":"Stores givasso donors data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_givasso_donors ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, email VARCHAR(254) NOT NULL, first_name VARCHAR(100) NOT NULL DEFAULT '', last_name VARCHAR(100) NOT NULL DEFAULT '', company VARCHAR(150) DEFAULT NULL, address_line1 VARCHAR(255) DEFAULT NULL, address_line2 VARCHAR(255) DEFAULT NULL, postal_code VARCHAR(10) DEFAULT NULL, city VARCHAR(100) DEFAULT NULL, country CHAR(2) NOT NULL DEFAULT 'FR', phone VARCHAR(30) DEFAULT NULL, wp_user_id BIGINT UNSIGNED DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY uq_email (email), KEY idx_wp_user (wp_user_id) ) $charset;\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"email","type":"VARCHAR(254)","nullable":false,"primary_key":false},{"name":"first_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"last_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"company","type":"VARCHAR(150)","nullable":true,"primary_key":false},{"name":"address_line1","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"address_line2","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"postal_code","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"city","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"country","type":"CHAR(2)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"wp_user_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"givasso","name":"Givasso","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/givasso/"}}