{"slug":"webalchlab-ddt-brt","name":"WebAlchLab DDT BRT","description":"Questo plugin di permette di creare in modo rapido e veloce i DDT (documento di trasporto) per il corriere BRT dagli ordini in Woocommerce o in modali …","author":"Web Alch LAB","active_installs":10,"version":"1.0.1","wp_org_url":"https://wordpress.org/plugins/webalchlab-ddt-brt/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"ddt_brt","full_table_name":"wp_ddt_brt","description":"Stores ddt brt data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ddt_brt_mittenti","full_table_name":"wp_ddt_brt_mittenti","description":"Stores ddt brt mittenti data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"nometab","full_table_name":"wp_nometab","description":"Stores nometab data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(10) UNSIGNED","nullable":false,"primary_key":true},{"name":"n_ddt","type":"int(11)","nullable":false,"primary_key":false},{"name":"date","type":"datetime","nullable":false,"primary_key":false},{"name":"woocommerce_order","type":"int(11)","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"dest_nome","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"dest_ind_1","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"dest_ind_2","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"dest_cap","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"dest_loc","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"dest_prov","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"dest_ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"dest_ref_tel","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"dest_ref_email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"servizio","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"colli","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"peso","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"volume","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"natura","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"consegna_rich","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"chiusura","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"contrassegno","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"mod_incasso","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"val_assicurato","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"note","type":"varchar(400)","nullable":true,"primary_key":false},{"name":"mittente_nome","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"mittente_ind","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"mittente_ind2","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"mittente_cap","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"mittente_loc","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"mittente_prov","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"mittente_ref","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"mittente_ref_tel","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"tracking_code","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"mitt_nome","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"mitt_ind","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"mitt_ind_2","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"mitt_cap","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"mitt_loc","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"mitt_prov","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"mitt_ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"mitt_ref_tel","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"date","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE NOMETAB ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `n_ddt` int(11) NOT NULL, `date` datetime NOT NULL, `woocommerce_order` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `dest_nome` varchar(255) DEFAULT NULL, `dest_ind_1` varchar(255) DEFAULT NULL, `dest_ind_2` varchar(255) DEFAULT NULL, `dest_cap` varchar(255) DEFAULT NULL, `dest_loc` varchar(255) DEFAULT NULL, `dest_prov` varchar(255) DEFAULT NULL, `dest_ref` varchar(255) DEFAULT NULL, `dest_ref_tel` varchar(255) DEFAULT NULL, `dest_ref_email` varchar(255) DEFAULT NULL, `servizio` varchar(255) DEFAULT NULL, `colli` varchar(255) DEFAULT NULL, `peso` varchar(255) DEFAULT NULL, `volume` varchar(255) DEFAULT NULL, `natura` varchar(255) DEFAULT NULL, `consegna_rich` varchar(255) DEFAULT NULL, `chiusura` varchar(255) DEFAULT NULL, `contrassegno` varchar(255) DEFAULT NULL, `mod_incasso` varchar(255) DEFAULT NULL, `val_assicurato` varchar(255) DEFAULT NULL, `note` varchar(400) DEFAULT NULL, `mittente_nome` varchar(255) NOT NULL, `mittente_ind` varchar(255) NOT NULL, `mittente_ind2` varchar(255) NOT NULL, `mittente_cap` varchar(255) NOT NULL, `mittente_loc` varchar(255) NOT NULL, `mittente_prov` varchar(255) NOT NULL, `mittente_ref` varchar(255) NOT NULL, `mittente_ref_tel` varchar(255) NOT NULL, `tracking_code` varchar(255) DEFAULT NULL, PRIMARY KEY (id) ) SETCARATT'; $tablesQuery['ddt_brt_mittenti'] = 'CREATE TABLE NOMETAB ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `mitt_nome` varchar(255) DEFAULT NULL, `mitt_ind` varchar(255) DEFAULT NULL, `mitt_ind_2` varchar(255) DEFAULT NULL, `mitt_cap` varchar(255) DEFAULT NULL, `mitt_loc` varchar(255) DEFAULT NULL, `mitt_prov` varchar(255) DEFAULT NULL, `mitt_ref` varchar(255) DEFAULT NULL, `mitt_ref_tel` varchar(255) DEFAULT NULL, `date` datetime NOT NULL, PRIMARY KEY (id) ) SETCARATT'; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );"}],"table_count":3}