The default value of navicat for SQLite is incorrect.

When the navicat for SQLite manager operates the table structure, the default value is incorrect. After each setting is complete, it disappears. I always thought that the default value of SQLite for some fields is incorrect, according to sqlitebrowser_200_b1_win, we found that the log uses the Pragma statement instead of the sqlite_master table to view the table structure. In this case, the default value is correct. inserting a record is successful.

 

Pragma table_info (vdisk_config );
Select name, SQL from sqlite_master where type = 'index'