{"table_name":"ec_checkout_field","full_table_name":"wp_ec_checkout_field","description":"Stores ec checkout field data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS ec_checkout_field ( checkout_field_id int(11) NOT NULL AUTO_INCREMENT, field_key varchar(64) NOT NULL DEFAULT '', field_type varchar(32) NOT NULL DEFAULT 'text', placement varchar(32) NOT NULL DEFAULT 'order_notes', label text, settings longtext, conditions longtext, sort_order int(11) NOT NULL DEFAULT '0', status varchar(16) NOT NULL DEFAULT 'active', created_date datetime DEFAULT NULL, modified_date datetime DEFAULT NULL, PRIMARY KEY (checkout_field_id), UNIQUE KEY field_key (field_key), KEY placement_sort (placement,sort_order) ) $collate;\", 'ec_tempcart_field' => \"CREATE TABLE IF NOT EXISTS ec_tempcart_field ( tempcart_field_id int(11) NOT NULL AUTO_INCREMENT, session_id varchar(100) NOT NULL DEFAULT '', field_key varchar(64) NOT NULL DEFAULT '', field_value longtext, modified_date datetime DEFAULT NULL, PRIMARY KEY (tempcart_field_id), UNIQUE KEY session_field (session_id,field_key), KEY modified_date (modified_date) ) $collate;\", 'ec_order_field' => \"CREATE TABLE IF NOT EXISTS ec_order_field ( order_field_id int(11) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL DEFAULT '0', orderdetail_id int(11) NOT NULL DEFAULT '0', repeat_index int(11) NOT NULL DEFAULT '0', checkout_field_id int(11) NOT NULL DEFAULT '0', field_key varchar(64) NOT NULL DEFAULT '', field_type varchar(32) NOT NULL DEFAULT '', field_label text, field_value longtext, display_value longtext, show_on varchar(255) NOT NULL DEFAULT '', field_status varchar(16) NOT NULL DEFAULT '', is_personal tinyint(1) NOT NULL DEFAULT '0', sort_order int(11) NOT NULL DEFAULT '0', created_date datetime DEFAULT NULL, modified_date datetime DEFAULT NULL, PRIMARY KEY (order_field_id), KEY order_id (order_id), KEY field_key (field_key) ) $collate;\", 'ec_user_field' => \"CREATE TABLE IF NOT EXISTS ec_user_field ( user_field_id int(11) NOT NULL AUTO_INCREMENT, user_id int(11) NOT NULL DEFAULT '0', field_key varchar(64) NOT NULL DEFAULT '', field_value longtext, modified_date datetime DEFAULT NULL, PRIMARY KEY (user_field_id), UNIQUE KEY user_field (user_id,field_key) ) $collate;\", );","columns":[{"name":"field_key","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"field_type","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"placement","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"label","type":"text","nullable":true,"primary_key":false},{"name":"settings","type":"longtext","nullable":true,"primary_key":false},{"name":"conditions","type":"longtext","nullable":true,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(16)","nullable":false,"primary_key":false},{"name":"created_date","type":"datetime","nullable":true,"primary_key":false},{"name":"modified_date","type":"datetime","nullable":true,"primary_key":false},{"name":"session_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"field_key","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"field_value","type":"longtext","nullable":true,"primary_key":false},{"name":"modified_date","type":"datetime","nullable":true,"primary_key":false},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"orderdetail_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"repeat_index","type":"int(11)","nullable":false,"primary_key":false},{"name":"field_key","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"field_type","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"field_label","type":"text","nullable":true,"primary_key":false},{"name":"field_value","type":"longtext","nullable":true,"primary_key":false},{"name":"display_value","type":"longtext","nullable":true,"primary_key":false},{"name":"show_on","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"field_status","type":"varchar(16)","nullable":false,"primary_key":false},{"name":"is_personal","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"created_date","type":"datetime","nullable":true,"primary_key":false},{"name":"modified_date","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"field_key","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"field_value","type":"longtext","nullable":true,"primary_key":false},{"name":"modified_date","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/"}}