{"table_name":"ec_package","full_table_name":"wp_ec_package","description":"Stores ec package data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS ec_package ( package_id int(11) NOT NULL AUTO_INCREMENT, label varchar(100) NOT NULL DEFAULT '', package_type varchar(20) NOT NULL DEFAULT 'box', length float(15,3) NOT NULL DEFAULT '0.000', width float(15,3) NOT NULL DEFAULT '0.000', height float(15,3) NOT NULL DEFAULT '0.000', box_weight float(15,3) NOT NULL DEFAULT '0.000', max_weight float(15,3) NOT NULL DEFAULT '0.000', carrier_template varchar(100) NOT NULL DEFAULT '', is_default tinyint(1) NOT NULL DEFAULT '0', is_active tinyint(1) NOT NULL DEFAULT '1', sort_order int(11) NOT NULL DEFAULT '0', PRIMARY KEY (package_id) ) $collate;\", 'ec_order_shipment' => \"CREATE TABLE IF NOT EXISTS ec_order_shipment ( shipment_id int(11) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL DEFAULT '0', sort_order int(11) NOT NULL DEFAULT '0', package_id int(11) NOT NULL DEFAULT '0', package_name varchar(100) NOT NULL DEFAULT '', length float(15,3) NOT NULL DEFAULT '0.000', width float(15,3) NOT NULL DEFAULT '0.000', height float(15,3) NOT NULL DEFAULT '0.000', weight float(15,3) NOT NULL DEFAULT '0.000', items text, status varchar(20) NOT NULL DEFAULT 'packed', is_return tinyint(1) NOT NULL DEFAULT '0', carrier varchar(100) NOT NULL DEFAULT '', service varchar(255) NOT NULL DEFAULT '', service_code varchar(100) NOT NULL DEFAULT '', tracking_number varchar(255) NOT NULL DEFAULT '', tracking_url text, tracking_status varchar(40) NOT NULL DEFAULT '', tracking_detail varchar(255) NOT NULL DEFAULT '', tracking_updated datetime DEFAULT NULL, label_url text, label_format varchar(20) NOT NULL DEFAULT '', cost float(15,3) NOT NULL DEFAULT '0.000', currency varchar(3) NOT NULL DEFAULT '', provider varchar(40) NOT NULL DEFAULT '', provider_ref varchar(100) NOT NULL DEFAULT '', meta longtext, created_at datetime DEFAULT NULL, updated_at datetime DEFAULT NULL, shipped_at datetime DEFAULT NULL, delivered_at datetime DEFAULT NULL, PRIMARY KEY (shipment_id), KEY order_id (order_id), KEY provider_ref (provider,provider_ref), KEY tracking_number (tracking_number(64)) ) $collate;\", );","columns":[{"name":"package_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"label","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"package_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"length","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"width","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"height","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"box_weight","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"max_weight","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"carrier_template","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"is_default","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"package_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"package_name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"length","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"width","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"height","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"weight","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"items","type":"text","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"is_return","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"carrier","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"service","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"service_code","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"tracking_number","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"tracking_url","type":"text","nullable":true,"primary_key":false},{"name":"tracking_status","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"tracking_detail","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"tracking_updated","type":"datetime","nullable":true,"primary_key":false},{"name":"label_url","type":"text","nullable":true,"primary_key":false},{"name":"label_format","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"cost","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(3)","nullable":false,"primary_key":false},{"name":"provider","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"provider_ref","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"meta","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"shipped_at","type":"datetime","nullable":true,"primary_key":false},{"name":"delivered_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/"}}