{"slug":"woo-shipping-dpd-baltic","name":"DPD Baltic Shipping","description":"Shipping extension for WooCommerce on WordPress of DPD Baltics. Manage your national and international shipments easily.","author":"dpdbaltics","active_installs":2000,"version":"1.2.91","wp_org_url":"https://wordpress.org/plugins/woo-shipping-dpd-baltic/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"dpd_barcodes","full_table_name":"wp_dpd_barcodes","description":"Stores dpd barcodes data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"order_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"dpd_barcode","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"pdf","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"date","type":"DATE","nullable":false,"primary_key":false},{"name":"parcelshop_id","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"company","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"country","type":"varchar(2)","nullable":false,"primary_key":false},{"name":"city","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"pcode","type":"varchar(7)","nullable":false,"primary_key":false},{"name":"street","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(30)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(30)","nullable":true,"primary_key":false},{"name":"mon","type":"text","nullable":false,"primary_key":false},{"name":"tue","type":"text","nullable":false,"primary_key":false},{"name":"wed","type":"text","nullable":false,"primary_key":false},{"name":"thu","type":"text","nullable":false,"primary_key":false},{"name":"fri","type":"text","nullable":false,"primary_key":false},{"name":"sat","type":"text","nullable":false,"primary_key":false},{"name":"sun","type":"text","nullable":false,"primary_key":false},{"name":"distance","type":"int(30)","nullable":false,"primary_key":false},{"name":"longitude","type":"float","nullable":true,"primary_key":false},{"name":"latitude","type":"float","nullable":true,"primary_key":false},{"name":"cod","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"status","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_dpd_barcodes ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT UNSIGNED NOT NULL, dpd_barcode varchar(50) NOT NULL, PRIMARY KEY (id), KEY (order_id), UNIQUE KEY dpd_barcode (dpd_barcode) ) $collate; \"; $tables[] = \" CREATE TABLE IF NOT EXISTS wp_dpd_manifests ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, pdf LONGTEXT NOT NULL, date DATE NOT NULL, PRIMARY KEY (id), KEY (date) ) $collate; \"; $tables[] = \" CREATE TABLE IF NOT EXISTS wp_dpd_terminals ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, parcelshop_id varchar(20) NOT NULL DEFAULT '', company varchar(40) NOT NULL DEFAULT '', country varchar(2) NOT NULL DEFAULT '', city varchar(40) NOT NULL DEFAULT '', pcode varchar(7) NOT NULL DEFAULT '', street varchar(40) NOT NULL DEFAULT '', email varchar(30) NULL, phone varchar(30) NULL, mon text NOT NULL, tue text NOT NULL, wed text NOT NULL, thu text NOT NULL, fri text NOT NULL, sat text NOT NULL, sun text NOT NULL, distance int(30) NOT NULL DEFAULT 0, longitude float NULL, latitude float NULL, cod tinyint(1) NOT NULL DEFAULT 0, status int NOT NULL DEFAULT 1, PRIMARY KEY (id), UNIQUE KEY parcelshop_id (parcelshop_id) ) $collate; \"; foreach ( $tables as $table ) { dbDelta( $table );"},{"table_name":"dpd_manifests","full_table_name":"wp_dpd_manifests","description":"Stores dpd manifests data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"dpd_terminals","full_table_name":"wp_dpd_terminals","description":"Stores dpd terminals data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":3}