{"table_name":"ec_subscription_change","full_table_name":"wp_ec_subscription_change","description":"Stores ec subscription change data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS ec_subscription_change ( change_id int(11) NOT NULL AUTO_INCREMENT, subscription_id int(11) NOT NULL DEFAULT '0', from_product_id int(11) NOT NULL DEFAULT '0', to_product_id int(11) NOT NULL DEFAULT '0', from_quantity int(11) NOT NULL DEFAULT '1', to_quantity int(11) NOT NULL DEFAULT '1', change_when varchar(20) NOT NULL DEFAULT 'now', change_status varchar(20) NOT NULL DEFAULT 'scheduled', effective_at int(11) NOT NULL DEFAULT '0', amount double(21,3) NOT NULL DEFAULT '0.000', stripe_schedule_id varchar(255) NOT NULL DEFAULT '', stripe_price_id varchar(255) NOT NULL DEFAULT '', stripe_invoice_id varchar(255) NOT NULL DEFAULT '', change_source varchar(20) NOT NULL DEFAULT 'customer', created_at datetime DEFAULT NULL, updated_at datetime DEFAULT NULL, PRIMARY KEY (change_id), KEY subscription_id (subscription_id), KEY change_status (change_status) ) $collate;\" );","columns":[{"name":"change_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"subscription_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"from_product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"to_product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"from_quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"to_quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"change_when","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"change_status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"effective_at","type":"int(11)","nullable":false,"primary_key":false},{"name":"amount","type":"double(21,3)","nullable":false,"primary_key":false},{"name":"stripe_schedule_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"stripe_price_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"stripe_invoice_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"change_source","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-easycart","name":"WP EasyCart: Shopping Cart and eCommerce Store","active_installs":3000,"version":"6.0.5","wp_org_url":"https://wordpress.org/plugins/wp-easycart/"}}