Valentina
allora facendo controllo DB. mi fa questo errore:
Segue l'elenco delle tabelle del database che presentano una struttura diversa rispetto a quella prevista nella versione ufficiale del gestionale.
Attenzione: questa funzionalità può presentare dei risultati falsamente positivi, sulla base del contenuto del file database.json e la versione di 10.4.28 di MySQL rilevata a sistema.
Problemi impostazioni
Nome Valore attuale Valore atteso
Cifre decimali per importi list[1,2,3,4,5] list[2,3,4,5]
Cifre decimali per quantità list[1,2,3,4,5] list[0,1,2,3,4,5]
an_anagrafiche
Colonna Conflitto
idanagrafica {"type":{"current":"int(11)","expected":"int"}}
id_nazione {"type":{"current":"int(11)","expected":"int"}}
idpagamento_vendite {"type":{"current":"int(11)","expected":"int"}}
idpagamento_acquisti {"type":{"current":"int(11)","expected":"int"}}
id_piano_sconto_vendite {"type":{"current":"int(11)","expected":"int"}}
id_piano_sconto_acquisti {"type":{"current":"int(11)","expected":"int"}}
id_listino {"type":{"current":"int(11)","expected":"int"}}
idiva_vendite {"type":{"current":"int(11)","expected":"int"}}
idiva_acquisti {"type":{"current":"int(11)","expected":"int"}}
id_ritenuta_acconto_vendite {"type":{"current":"int(11)","expected":"int"}}
id_ritenuta_acconto_acquisti {"type":{"current":"int(11)","expected":"int"}}
idsede_fatturazione {"type":{"current":"int(11)","expected":"int"}}
idconto_cliente {"type":{"current":"int(11)","expected":"int"}}
idbanca_vendite {"type":{"current":"int(11)","expected":"int"}}
idbanca_acquisti {"type":{"current":"int(11)","expected":"int"}}
idconto_fornitore {"type":{"current":"int(11)","expected":"int"}}
id_settore {"type":{"current":"int(11)","expected":"int"}}
dipendenti {"type":{"current":"int(11)","expected":"int"}}
macchine {"type":{"current":"int(11)","expected":"int"}}
idagente {"type":{"current":"int(11)","expected":"int"}}
idrelazione {"type":{"current":"int(11)","expected":"int"}}
id_provenienza {"type":{"current":"int(11)","expected":"int"}}
idzona {"type":{"current":"int(11)","expected":"int"}}
created_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"","expected":"DEFAULT_GENERATED"}}
updated_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"on update current_timestamp()","expected":"DEFAULT_GENERATED on update CURRENT_TIMESTAMP"}}
idtipointervento_default {"type":{"current":"int(11)","expected":"int"}}
id_dichiarazione_intento_default {"type":{"current":"int(11)","expected":"int"}}
an_anagrafiche_agenti
Colonna Conflitto
idanagrafica {"type":{"current":"int(11)","expected":"int"}}
idagente {"type":{"current":"int(11)","expected":"int"}}
created_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"","expected":"DEFAULT_GENERATED"}}
updated_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"on update current_timestamp()","expected":"DEFAULT_GENERATED on update CURRENT_TIMESTAMP"}}
an_nazioni
Colonna Conflitto
id {"type":{"current":"int(11)","expected":"int"}}
created_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"","expected":"DEFAULT_GENERATED"}}
updated_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"on update current_timestamp()","expected":"DEFAULT_GENERATED on update CURRENT_TIMESTAMP"}}
an_mansioni
Colonna Conflitto
id {"type":{"current":"int(11)","expected":"int"}}
created_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"","expected":"DEFAULT_GENERATED"}}
updated_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"on update current_timestamp()","expected":"DEFAULT_GENERATED on update CURRENT_TIMESTAMP"}}
an_referenti
Colonna Conflitto
id {"type":{"current":"int(11)","expected":"int"}}
idanagrafica {"type":{"current":"int(11)","expected":"int"}}
idsede {"type":{"current":"int(11)","expected":"int"}}
idmansione {"type":{"current":"int(11)","expected":"int"}}
created_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"","expected":"DEFAULT_GENERATED"}}
updated_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"on update current_timestamp()","expected":"DEFAULT_GENERATED on update CURRENT_TIMESTAMP"}}
an_regioni
Colonna Conflitto
id {"type":{"current":"int(11)","expected":"int"}}
id_nazione {"type":{"current":"int(11)","expected":"int"}}
created_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"","expected":"DEFAULT_GENERATED"}}
updated_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"on update current_timestamp()","expected":"DEFAULT_GENERATED on update CURRENT_TIMESTAMP"}}
an_relazioni
Colonna Conflitto
id {"type":{"current":"int(11)","expected":"int"}}
is_bloccata {"type":{"current":"tinyint(4)","expected":"tinyint"}}
created_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"","expected":"DEFAULT_GENERATED"}}
updated_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"on update current_timestamp()","expected":"DEFAULT_GENERATED on update CURRENT_TIMESTAMP"}}
an_provenienze
Colonna Conflitto
id {"type":{"current":"int(11)","expected":"int"}}
created_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"","expected":"DEFAULT_GENERATED"}}
updated_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"on update current_timestamp()","expected":"DEFAULT_GENERATED on update CURRENT_TIMESTAMP"}}
an_settori
Colonna Conflitto
id {"type":{"current":"int(11)","expected":"int"}}
created_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"","expected":"DEFAULT_GENERATED"}}
updated_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"on update current_timestamp()","expected":"DEFAULT_GENERATED on update CURRENT_TIMESTAMP"}}
an_sedi
Colonna Conflitto
id {"type":{"current":"int(11)","expected":"int"}}
id_nazione {"type":{"current":"int(11)","expected":"int"}}
idanagrafica {"type":{"current":"int(11)","expected":"int"}}
idzona {"type":{"current":"int(11)","expected":"int"}}
created_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"","expected":"DEFAULT_GENERATED"}}
updated_at {"default":{"current":"current_timestamp()","expected":"CURRENT_TIMESTAMP"},"extra":{"current":"on update current_timestamp()","expected":"DEFAULT_GENERATED on update CURRENT_TIMESTAMP"}}
is_automezzo {"type":{"current":"tinyint(4)","expected":"tinyint"}}
