Tinyint values are interpreted as bool by default and the interface does not let you edit the column type

[ArnoldHueteG]

Checklist

• [ x ] I have searched budibase discussions and github issues to check if my issue already exists
• There is closed issue similar to this one: https://github.com/Budibase/budibase/issues/9839

Hosting

• Cloud
  • Tenant ID: https://aritek.budibase.app/builder/portal/apps

Describe the bug When a SQL Server table with field of type "tinyint" is imported, it is interpreted as a boolean value and the interface does not let you to change the data type.

To Reproduce Steps to reproduce the behavior:

1. Create a table with a tinyint field in sql server, add a few values
2. Import table and see the table with all values check.

3. 

Expected behavior The field should be integer number

Screenshots The screenshots are above.

Additional context

For some reason the exported schema shows table with duplicated columns:

CREATE TABLE [TB_TesoreriaTipo] (
TipoID tinyint(1) NOT NULL,
TipoID tinyint(1) NOT NULL,
Tipo varchar(100) NULL,
Tipo varchar(100) NULL,
 CONSTRAINT [PK_TB_TesoreriaTipo] PRIMARY KEY (TipoID)
);

[linear[bot]]

BUDI-8735 Tinyint values are interpreted as bool by default and the interface does not let you edit the column type