sandcrawler/sql/migrations, branch master [no description] https://git.bnewbold.net/sandcrawler/atom?h=master 2022-04-04T22:52:02+00:00 sql: add source/created index on ingest_request table 2022-04-04T22:52:02+00:00 Bryan Newbold bnewbold@archive.org 2022-04-04T22:52:02+00:00 urn:sha1:dadb26935c4d255c5a662f1e758bcf53864f7f95 update fatcat_file SQL table schema, and add backfill notes 2021-12-08T03:10:23+00:00 Bryan Newbold bnewbold@archive.org 2021-12-02T03:06:33+00:00 urn:sha1:3f01f73563f40869c82b7ad3e21c4183fdee8206 sql: grobid_refs table JSON as 'JSON' not 'JSONB' 2021-11-05T00:19:52+00:00 Bryan Newbold bnewbold@archive.org 2021-11-02T03:05:16+00:00 urn:sha1:4315b44a93ca31725b9b0a2a55c310725ac55efe I keep flip-flopping on this, but our disk usage is really large, and if 'JSON' is smaller than 'JSONB' in postgresql at all it is worth it. add grobid_refs and crossref_with_refs to sandcrawler-db SQL schema 2021-11-05T00:19:52+00:00 Bryan Newbold bnewbold@archive.org 2021-10-30T01:38:17+00:00 urn:sha1:59af5ddd0a9587eaf53b4f6965c0d6290295ce55 sql: fixes to ingest_fileset_platform schema (from table creation) 2021-11-02T03:08:11+00:00 Bryan Newbold bnewbold@archive.org 2021-11-02T03:08:11+00:00 urn:sha1:58acf442af343b4b74f2e206cea1e95145dce744 sql fileset ingest table iteration 2021-10-16T01:15:29+00:00 Bryan Newbold bnewbold@archive.org 2021-10-16T00:14:43+00:00 urn:sha1:350a4e64aa60896391c1040d958b6b039ea3a79f sql: initial ingest fileset table 2021-10-16T01:15:20+00:00 Bryan Newbold bnewbold@archive.org 2021-10-04T19:52:04+00:00 urn:sha1:636ae0e44f6a4bc2e5325cdc8cbf7ae3a1f16d8b sql: fix typo in CHECK statement 2021-10-16T01:15:20+00:00 Bryan Newbold bnewbold@archive.org 2021-10-04T19:51:53+00:00 urn:sha1:9b47798b2fd69fcf3f318bddc896e6342e7f8580 crossref DB proposal, and include in SQL schema 2021-06-02T07:26:51+00:00 Bryan Newbold bnewbold@archive.org 2021-06-02T07:26:51+00:00 urn:sha1:87a9bb4ed81b503f03e6e77d6b082249523e67d4 tweak html_meta SQL schema 2020-11-04T00:24:16+00:00 Bryan Newbold bnewbold@archive.org 2020-11-04T00:24:16+00:00 urn:sha1:644c6abdb424a3759e06df6b2541d41fb353e95c