{"slug":"ltl-freight-quotes-unishippers-edition","name":"LTL Freight Quotes – Unishippers Edition","description":"Real-time Unishippers freight quotes from Unishippers. Fifteen day free trial.","author":"enituretechnology","active_installs":50,"version":"2.5.20","wp_org_url":"https://wordpress.org/plugins/ltl-freight-quotes-unishippers-edition/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"eniture_unishippers_ltl_shipping_rules","full_table_name":"wp_eniture_unishippers_ltl_shipping_rules","description":"Stores eniture unishippers ltl shipping rules data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT(10)","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"settings","type":"TEXT","nullable":true,"primary_key":false},{"name":"is_active","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_eniture_unishippers_ltl_shipping_rules ( id INT(10) NOT NULL AUTO_INCREMENT, name VARCHAR(50) NOT NULL, type VARCHAR(30) NOT NULL, settings TEXT NULL, is_active TINYINT(1) NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) )\"; dbDelta($query);"},{"table_name":"unishippers_freight","full_table_name":"wp_unishippers_freight","description":"Stores unishippers freight data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(10)","nullable":false,"primary_key":true},{"name":"unishippers_shipmentQuoteId","type":"varchar(600)","nullable":false,"primary_key":false},{"name":"unishippers_carrierSCAC","type":"varchar(600)","nullable":false,"primary_key":false},{"name":"unishippers_carrierName","type":"varchar(600)","nullable":false,"primary_key":false},{"name":"unishippers_transitDays","type":"varchar(600)","nullable":false,"primary_key":false},{"name":"unishippers_guaranteedService","type":"varchar(600)","nullable":false,"primary_key":false},{"name":"unishippers_highCostDeliveryShipment","type":"varchar(600)","nullable":false,"primary_key":false},{"name":"unishippers_interline","type":"varchar(600)","nullable":false,"primary_key":false},{"name":"unishippers_nmfcRequired","type":"varchar(600)","nullable":false,"primary_key":false},{"name":"unishippers_carrierNotifications","type":"varchar(600)","nullable":false,"primary_key":false},{"name":"carrier_logo","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"carrier_status","type":"varchar(8)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_unishippers_freight ( `id` int(10) NOT NULL AUTO_INCREMENT, `unishippers_shipmentQuoteId` varchar(600) NOT NULL, `unishippers_carrierSCAC` varchar(600) NOT NULL, `unishippers_carrierName` varchar(600) NOT NULL, `unishippers_transitDays` varchar(600) NOT NULL, `unishippers_guaranteedService` varchar(600) NOT NULL, `unishippers_highCostDeliveryShipment` varchar(600) NOT NULL, `unishippers_interline` varchar(600) NOT NULL, `unishippers_nmfcRequired` varchar(600) NOT NULL, `unishippers_carrierNotifications` varchar(600) NOT NULL, `carrier_logo` varchar(255) NOT NULL, `carrier_status` varchar(8) NOT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"warehouse","full_table_name":"wp_warehouse","description":"Stores warehouse data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"mediumint(9)","nullable":false,"primary_key":true},{"name":"city","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"state","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"address","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"phone_instore","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"zip","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"country","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"location","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"nickname","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"enable_store_pickup","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"miles_store_pickup","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"match_postal_store_pickup","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"enable_local_delivery","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"miles_local_delivery","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"match_postal_local_delivery","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"fee_local_delivery","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"suppress_local_delivery","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"origin_markup","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"enable_residential_pickup_parcel","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"enable_residential_pickup","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"enable_liftgate_pickup","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_warehouse ( id mediumint(9) NOT NULL AUTO_INCREMENT, city varchar(200) NOT NULL, state varchar(200) NOT NULL, address varchar(255) NOT NULL, phone_instore varchar(255) NOT NULL, zip varchar(200) NOT NULL, country varchar(200) NOT NULL, location varchar(200) NOT NULL, nickname varchar(200) NOT NULL, enable_store_pickup VARCHAR(255) NOT NULL, miles_store_pickup VARCHAR(255) NOT NULL, match_postal_store_pickup VARCHAR(255) NOT NULL, checkout_desc_store_pickup VARCHAR(255) NOT NULL, enable_local_delivery VARCHAR(255) NOT NULL, miles_local_delivery VARCHAR(255) NOT NULL, match_postal_local_delivery VARCHAR(255) NOT NULL, checkout_desc_local_delivery VARCHAR(255) NOT NULL, fee_local_delivery VARCHAR(255) NOT NULL, suppress_local_delivery VARCHAR(255) NOT NULL, origin_markup VARCHAR(255), enable_residential_pickup_parcel tinyint(1) NOT NULL DEFAULT 0, enable_residential_pickup tinyint(1) NOT NULL DEFAULT 0, enable_liftgate_pickup tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (id) )\");"}],"table_count":3}