genenetwork3/sql, branch ci-cd-scripts GeneNetwork3 REST API for data science and machine learning http://git.genenetwork.org/genenetwork3/atom?h=ci-cd-scripts 2021-11-29T09:05:16+00:00 Add SQL statement to update json_diff 2021-11-29T09:05:16+00:00 BonfaceKilz 2021-11-24T08:46:42+00:00 urn:sha1:9ab166a0d60b4a95c52599ab51ec97c19a2fff5b sql: Add documentation extracted from within the database. 2021-08-04T06:43:30+00:00 Arun Isaac 2021-08-04T06:43:30+00:00 urn:sha1:487e50e8f8304a65e7af3759c13256f921efb8be 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. sql: Document the table Strain. 2021-08-02T11:36:50+00:00 Arun Isaac 2021-08-02T11:36:50+00:00 urn:sha1:c3fe5b77b4977c7ffe142852879fa1af9a32a929 * sql/schema.org (Strain): New section. sql: Add schema description. 2021-07-31T12:45:30+00:00 Arun Isaac 2021-07-31T12:45:30+00:00 urn:sha1:234dafc293b2a4a0f85c83cdd2253a9b9e57a74e * sql/schema.org: New file. sql: metadata_audit: Make char-set encoding explicit(utf8mb4) 2021-07-23T10:00:37+00:00 BonfaceKilz 2021-07-23T10:00:37+00:00 urn:sha1:13c4e1bbe6f30454c06235698efad146d99116dd See: https://www.eversql.com/mysql-utf8-vs-utf8mb4-whats-the-difference-between-utf8-and-utf8mb4/ Move sql updates into dir 2021-07-22T09:47:15+00:00 Pjotr Prins 2021-07-22T09:47:15+00:00 urn:sha1:086b7151295ede3aed32f29fb537bb5c6172393d sql: Add schema and schema map. 2021-07-22T08:44:55+00:00 Arun Isaac 2021-07-22T07:56:25+00:00 urn:sha1:0f8a4bb658bbea15c75dc30d590cb3818dd182eb * sql/map-database.sh, sql/schema-original.sql, sql/schema.png, sql/schema.sql, sql/schema.svg: New files. Rename json_data column to json_diff_data 2021-06-07T16:58:44+00:00 BonfaceKilz 2021-06-07T16:44:00+00:00 urn:sha1:a364496e9884e46080844bd3eddb2b52d6ed9164 sql: Add a new folder that houses sql statements for new tables 2021-06-03T18:58:31+00:00 BonfaceKilz 2021-06-03T08:30:48+00:00 urn:sha1:2bab870e5ef47b32a3356de74159e641138146c7