Database
Database maintenance
Currently, the tables of database are created by .sql
file.
If you want to add a new table or modify the existing table, you need to update the .sql
files which are located in the sql
directory.
Attention
- Each database corresponds to one
.sql
file, you must modify all of them if you want to update the tables in order to keep the consistency of the database. - DO NOT use
Array
Type in PostgreSQL but useJSON
instead, for compatibility with SQLite & MySQL. (JSON
<==>serde_json::Value
)