{"slug":"email-marketing-integration-adv","name":"Email Marketing Integration Adv","description":"Integrate 4Dem.it with wordpress and woocommerce. Subscribe/Synchonize users with your 4Dem list using Single opt-in/Double opt-in email.","author":"4marketing.it","active_installs":0,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/email-marketing-integration-adv/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"adv_dem_batches","full_table_name":"wp_adv_dem_batches","description":"Stores adv dem batches data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"batch_Type","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"batch_Id","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"batch_Status","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"batch_Operations","type":"INT","nullable":false,"primary_key":false},{"name":"batch_Result","type":"TEXT","nullable":true,"primary_key":false},{"name":"batch_Start_Time","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"batch_Finish_Time","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_adv_dem_batches ( `id` INT NOT NULL AUTO_INCREMENT, `batch_Type` VARCHAR(255) NOT NULL, `batch_Id` VARCHAR(255) NOT NULL, `batch_Status` VARCHAR(255) NOT NULL, `batch_Operations` INT NOT NULL, `batch_Result` TEXT NULL, `batch_Start_Time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, `batch_Finish_Time` TIMESTAMP NULL, UNIQUE KEY id (id) )$charset_collate;\") );"},{"table_name":"adv_dem_carts","full_table_name":"wp_adv_dem_carts","description":"Stores adv dem carts data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"cart_Id","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"cart_UserId","type":"INT","nullable":false,"primary_key":false},{"name":"cart_Status","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"cart_Creation_Time","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"cart_Last_Update","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_adv_dem_carts ( `id` INT NOT NULL AUTO_INCREMENT, `cart_Id` VARCHAR(255) NOT NULL, `cart_UserId` INT NOT NULL, `cart_Status` VARCHAR(50) NOT NULL, `cart_Creation_Time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, `cart_Last_Update` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, UNIQUE KEY id (id) )$charset_collate;\") );"},{"table_name":"adv_dem_product_attributes","full_table_name":"wp_adv_dem_product_attributes","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"property_Name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"property_Wc_Id","type":"INT","nullable":false,"primary_key":false},{"name":"property_Adv_Id","type":"INT","nullable":false,"primary_key":false},{"name":"property_Last_Update","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_adv_dem_product_attributes ( `id` INT NOT NULL AUTO_INCREMENT, `property_Name` VARCHAR(255) NOT NULL, `property_Wc_Id` INT NOT NULL, `property_Adv_Id` INT NOT NULL, `property_Last_Update` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, UNIQUE KEY id (id) )$charset_collate;\") );"}],"table_count":3}