{"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","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","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}],"plugin":{"slug":"epaka-shipping-for-woocommerce","name":"Epaka Shipping for WooCommerce","active_installs":90,"version":"1.7.1","wp_org_url":"https://wordpress.org/plugins/epaka-shipping-for-woocommerce/"}}