{"table_name":"dpd_barcodes","full_table_name":"wp_dpd_barcodes","description":"Stores dpd barcodes data created by this plugin.","detection_method":"static","confidence":"high","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 );","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}],"plugin":{"slug":"woo-shipping-dpd-baltic","name":"DPD Baltic Shipping","active_installs":2000,"version":"1.2.91","wp_org_url":"https://wordpress.org/plugins/woo-shipping-dpd-baltic/"}}