aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2022-02-11Quote shell variables to prevent globbingFrederick Muriuki Muriithi
Quote the shell variables to prevent globbing and word splitting. Deactivate this check for the specific lines that require intentional word splitting
2021-11-29Add SQL statement to update json_diffBonfaceKilz
2021-08-04sql: Add documentation extracted from within the database.Arun Isaac
It turns out there is documentation of the database within the database itself. I have dumped that it into an org file. * sql/schema-from-in-db-documentation.org: New file.
2021-08-02sql: Document the table Strain.Arun Isaac
* sql/schema.org (Strain): New section.
2021-07-31sql: Add schema description.Arun Isaac
* sql/schema.org: New file.
2021-07-23sql: metadata_audit: Make char-set encoding explicit(utf8mb4)BonfaceKilz
See: https://www.eversql.com/mysql-utf8-vs-utf8mb4-whats-the-difference-between-utf8-and-utf8mb4/
2021-07-22Move sql updates into dirPjotr Prins
2021-07-22sql: Add schema and schema map.Arun Isaac
* sql/map-database.sh, sql/schema-original.sql, sql/schema.png, sql/schema.sql, sql/schema.svg: New files.
2021-06-07Rename json_data column to json_diff_dataBonfaceKilz
2021-06-03sql: Add a new folder that houses sql statements for new tablesBonfaceKilz