aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Expand)Author
2022-05-27sql: caseattributes_audit.sql: New file...Create new table that stores edits related to case-attributes. BonfaceKilz
2022-02-11sql: Remove database mapping code....These tools have been greatly improved and moved to a new home at https://git.genenetwork.org/arunisaac/dump-genenetwork-database * sql/map-database.sh, sql/schema-from-in-db-documentation.org, sql/schema-original.sql, sql/schema.png, sql/schema.sql, sql/schema.svg: New files. Arun Isaac
2022-02-11Quote shell variables to prevent globbing...Quote the shell variables to prevent globbing and word splitting. Deactivate this check for the specific lines that require intentional word splitting Frederick Muriuki Muriithi
2021-11-29Add SQL statement to update json_diffBonfaceKilz
2021-08-04sql: Add documentation extracted from within the database....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. Arun Isaac
2021-08-02sql: Document the table Strain....* sql/schema.org (Strain): New section. Arun Isaac
2021-07-31sql: Add schema description....* sql/schema.org: New file. Arun Isaac
2021-07-23sql: metadata_audit: Make char-set encoding explicit(utf8mb4)...See: https://www.eversql.com/mysql-utf8-vs-utf8mb4-whats-the-difference-between-utf8-and-utf8mb4/ BonfaceKilz
2021-07-22Move sql updates into dirPjotr Prins
2021-07-22sql: Add schema and schema map....* sql/map-database.sh, sql/schema-original.sql, sql/schema.png, sql/schema.sql, sql/schema.svg: New files. Arun Isaac
2021-06-07Rename json_data column to json_diff_dataBonfaceKilz
2021-06-03sql: Add a new folder that houses sql statements for new tablesBonfaceKilz