{"slug":"epaka-shipping-for-woocommerce","name":"Epaka Shipping for WooCommerce","description":"WooCommerce integration with epaka.pl enabling quick creation of courier shipments directly from the store panel.","author":"epaka.pl","active_installs":90,"version":"1.7.1","wp_org_url":"https://wordpress.org/plugins/epaka-shipping-for-woocommerce/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"epaka_auth","full_table_name":"wp_epaka_auth","description":"Stores epaka auth data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"epaka_carrier","full_table_name":"wp_epaka_carrier","description":"Stores epaka carrier data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"epaka_carrier_group","full_table_name":"wp_epaka_carrier_group","description":"Stores epaka carrier group data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"color","type":"VARCHAR(7)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"zone_method_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"zone_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"shipment_type","type":"int(11)","nullable":false,"primary_key":false},{"name":"parcel_type","type":"int(11)","nullable":false,"primary_key":false},{"name":"sender_country_id","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"receiver_country_id","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"additional_options","type":"TEXT","nullable":true,"primary_key":false},{"name":"epaka_curier_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"epaka_courier_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"max_width","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"max_height","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"max_length","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"max_weight","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"is_point","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"is_deleted","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"group_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"carrier_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"company_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"first_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"last_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"country","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"street","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"house_number","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"postal_code","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"city","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"access_token","type":"TEXT","nullable":false,"primary_key":false},{"name":"expires_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"refresh_token","type":"TEXT","nullable":false,"primary_key":false},{"name":"client_id","type":"TEXT","nullable":false,"primary_key":false},{"name":"client_secret","type":"TEXT","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"ps_order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"carrier_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"tracking_number","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"is_deleted","type":"TINYINT(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_epaka_carrier_group ( id int(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, color VARCHAR(7) NOT NULL DEFAULT '#17a2b8', created_at DATETIME NOT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS wp_epaka_carrier ( id int(11) NOT NULL AUTO_INCREMENT, zone_method_id int(11) NOT NULL, zone_id int(11) NOT NULL, shipment_type int(11) NOT NULL, parcel_type int(11) NOT NULL, sender_country_id VARCHAR(10) NOT NULL, receiver_country_id VARCHAR(10) NOT NULL, additional_options TEXT DEFAULT NULL, epaka_curier_id int(11) NOT NULL, epaka_courier_name VARCHAR(255) NOT NULL, max_width DECIMAL(10,2) DEFAULT 0.00, max_height DECIMAL(10,2) DEFAULT 0.00, max_length DECIMAL(10,2) DEFAULT 0.00, max_weight DECIMAL(10,2) DEFAULT 0.00, updated_at DATETIME NOT NULL, created_at DATETIME NOT NULL, is_point TINYINT(1) NOT NULL, is_deleted TINYINT(1) NOT NULL, group_id int(11) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS wp_epaka_sender ( id int(11) NOT NULL AUTO_INCREMENT, carrier_id int(11) NOT NULL, company_name VARCHAR(255) NOT NULL, first_name VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, country VARCHAR(255) NOT NULL, street VARCHAR(255) NOT NULL, house_number VARCHAR(50) NOT NULL, postal_code VARCHAR(20) NOT NULL, city VARCHAR(255) NOT NULL, phone VARCHAR(50) NOT NULL, email VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS wp_epaka_auth ( id int(11) NOT NULL AUTO_INCREMENT, access_token TEXT NOT NULL, expires_at DATETIME NOT NULL, refresh_token TEXT NOT NULL, client_id TEXT NOT NULL, client_secret TEXT NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS wp_epaka_order ( id int(11) NOT NULL AUTO_INCREMENT, ps_order_id int(11) NOT NULL, carrier_id int(11) NOT NULL, tracking_number VARCHAR(100) DEFAULT NULL, updated_at DATETIME NOT NULL, created_at DATETIME NOT NULL, is_deleted TINYINT(1) NOT NULL, PRIMARY KEY (id), KEY ps_order_id (ps_order_id) ) ENGINE"},{"table_name":"epaka_order","full_table_name":"wp_epaka_order","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"epaka_parcel","full_table_name":"wp_epaka_parcel","description":"Stores epaka parcel data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"epaka_order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"api_order_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"message","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"order_process_result_status","type":"int(11)","nullable":true,"primary_key":false},{"name":"epaka_status","type":"int(11)","nullable":true,"primary_key":false},{"name":"courier_status","type":"int(11)","nullable":true,"primary_key":false},{"name":"waybill_number","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"is_deleted","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"epaka_placed_at","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_epaka_parcel ( id int(11) NOT NULL AUTO_INCREMENT, epaka_order_id int(11) NOT NULL, api_order_id int(11) DEFAULT NULL, message LONGTEXT DEFAULT NULL, order_process_result_status int(11) DEFAULT NULL, epaka_status int(11) DEFAULT NULL, courier_status int(11) DEFAULT NULL, waybill_number VARCHAR(255) DEFAULT NULL, is_deleted TINYINT(1) NOT NULL, epaka_placed_at DATETIME NULL, PRIMARY KEY (id), KEY epaka_order_id (epaka_order_id), KEY api_order_id (api_order_id), CONSTRAINT wp_fk_epaka_parcel_order FOREIGN KEY (epaka_order_id) REFERENCES wp_epaka_order (id) ON DELETE CASCADE ) ENGINE"},{"table_name":"epaka_sender","full_table_name":"wp_epaka_sender","description":"Stores epaka sender data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"epaka_settings","full_table_name":"wp_epaka_settings","description":"Stores epaka settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"payment_type","type":"int(11)","nullable":false,"primary_key":false},{"name":"default_label_format","type":"int(11)","nullable":false,"primary_key":false},{"name":"first_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"last_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"company_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"street","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"country","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"house_number","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"post_code","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"city","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"phone","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"email","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"free_shipping_threshold","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_epaka_settings ( id int(11) NOT NULL AUTO_INCREMENT, payment_type int(11) NOT NULL, default_label_format int(11) NOT NULL, first_name VARCHAR(255) DEFAULT NULL, last_name VARCHAR(255) DEFAULT NULL, company_name VARCHAR(255) DEFAULT NULL, street VARCHAR(255) DEFAULT NULL, country VARCHAR(100) DEFAULT 'PL', house_number VARCHAR(50) DEFAULT NULL, post_code VARCHAR(20) DEFAULT NULL, city VARCHAR(255) DEFAULT NULL, phone VARCHAR(50) DEFAULT NULL, email VARCHAR(255) DEFAULT NULL, free_shipping_threshold int(11) DEFAULT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id) ) $charset_collate;\" ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ($queries as $query) { dbDelta($query);"}],"table_count":7}