search

ondras / wwwsqldesigner

WWW SQL Designer, your online SQL diagramming tool
https://sql.toad.cz/?keyword=online_library
BSD 3-Clause "New" or "Revised" License
2.86k stars 722 forks source link

The drop down menu for 'type' does not have more than 5 options #257

Open sobopla opened 6 years ago

sobopla commented 6 years ago

I see in the video that the dropdown menu for type contains many more options such as 4 options for DATE & TIME, 4 options for NUMERIC, etc. I only see these options for type: Text, Numeric, Integer, Real, None. I'd like to be able to choose DATE Please advise using chrome, sqlite, ad block diabled

sobopla commented 6 years ago

I see that it is a chrome issue, as more of the dropdown options for type are showing in Firefox. However cookies for the site are enabled.

ondras commented 6 years ago

The data type selection is database-specific, so you will see different data types available for different database types. In your case, SQLite has only five data types (fun fact: those are not real data types; instead, SQLite uses the concept of data affinity). If you switch your DB to a different one, reload the app and start a new design, you should see a different data type set.

Sanity check: open the blank wwwsqldesigner page using a private browsing window. You should see the default (MySQL) data type selection.