Table create statements/ui should show primary key properly

[Syntex9000]

If you create a table with a primary key and use the data type integer then Sqlite will auto increment that field for you. However, when the table is recreated by right clicking on the table name and selecting "script as create" or "drop and create", it comes up as a bigint not null and primary key is a constraint at the end of the query. If you resave this, it will no longer auto-increment that field because the data type is now bigint. This is also apparent when you expand a table in the UI, and it shows the primary key as bigint. This is incorrect

-- what shows --

-- should be --

[ErikEJ]

Please provide a text based repro

[Syntex9000]

Is this what you are looking for?

CREATE TABLE [my-table] (
  [Id] INTEGER PRIMARY KEY
, [my-other-column] TEXT NOT NULL
);

1. run the above script
2. insert data using the following script
   insert into [my-table] ([my-other-column]) values ('hi')
3. right-click the table and select 'Edit top 200 rows'
4. observe that the data was added and the primary key was auto-incremented
5. expand the table name In the UI and observe that the integer column is now displayed as bigint not null
6. right-click on the table and select "Script as DROP and CREATE"
7. Table shows Id as bigint NOT NULL with a CONSTRAINT for the primary key
8. run script
9. insert data by using the following script
   insert into [my-table] ([my-other-column]) values ('hi')
10. an error is returned

ErrorCode : 19
Message   : constraint failed
NOT NULL constraint failed: my-table.Id
Result    : Constraint

[ErikEJ]

Thanks!