summaryrefslogtreecommitdiffstats
path: root/rust/migrations/2018-05-12-001226_init/up.sql
Commit message (Collapse)AuthorAgeFilesLines
* better username constraints in SQLBryan Newbold2019-01-031-1/+3
|
* OIDC auth table, and is_active editor flagBryan Newbold2019-01-031-0/+12
|
* make admin auth_epoch old so test tokens don't expireBryan Newbold2018-12-311-4/+4
|
* sql: add index on editor usernameBryan Newbold2018-12-271-0/+1
|
* first attempt at auth in DB schemaBryan Newbold2018-12-261-1/+4
|
* schemas: editor_id as UUID (not int)Bryan Newbold2018-12-261-7/+7
|
* webcapture: status_code nullable; cdx timestamp stringBryan Newbold2018-12-261-2/+2
|
* most basic fileset/web access testsBryan Newbold2018-12-261-6/+6
|
* basic fileset/web SQL entitiesBryan Newbold2018-12-261-0/+58
|
* sql: fixes to fileset/web; *_rev_releaseBryan Newbold2018-12-261-21/+21
| | | | | Several "ENTITY_release" tables renamed to "ENTITY_rev_release" for consistency.
* sql: size_bytes (size is a keyword)Bryan Newbold2018-12-261-2/+2
|
* fileset and webcapture SQL schemasBryan Newbold2018-12-241-1/+115
|
* implement release_year (and rustfmt)Bryan Newbold2018-12-241-4/+5
|
* ident table redirect lookupsBryan Newbold2018-12-201-0/+5
|
* lookups implBryan Newbold2018-12-141-4/+4
|
* implement new controlled vocabulariesBryan Newbold2018-11-141-2/+2
|
* fix isbn13 size check (!)Bryan Newbold2018-09-221-2/+2
|
* container_name (not title), and shrink some BIGINTsBryan Newbold2018-09-221-4/+4
|
* fix CHECK clausesBryan Newbold2018-09-171-7/+7
|
* UNIQUE constraint on edits (ident per editgroup)Bryan Newbold2018-09-171-15/+10
|
* use timestamptz (not WITHOUT TIME ZONE)Bryan Newbold2018-09-171-8/+10
|
* CHAR/VARCHAR -> TEXT w/ CHECKBryan Newbold2018-09-171-15/+28
|
* update extid columns: varchar size limits, no char columnsBryan Newbold2018-09-151-15/+15
| | | | | | | | | | | | In PostgreSQL, there is no query or size differences between CHAR, VARCHAR, and TEXT: they use the same backend. CHAR will pad out with spaces and VARCHAR enforces a size limit. The enforced VARCHAR size limit seems like ok defensive programming/schema here, preventing large values from getting stored for some columns. I have some FUD concern about fixed-sized identifiers and indexes, so switching old CHARs (eg, sha1 hex encoded columns) to VARCHAR instead.
* use JSONB over JSONBryan Newbold2018-09-101-13/+13
| | | | | | Sort of an impulsive "why not" decision. From earlier tests, expect this to consume a few % more disk (but not index)... adds a lot more query flexibility if we want that in the future. Seems worth the price.
* sql: add an index from cockroach branchBryan Newbold2018-09-101-0/+2
|
* remove 'IS NOT NULL' identifier index constraintsBryan Newbold2018-09-101-14/+14
| | | | | | | | | | | These seemed to be resulting in table scans on 404s in QA with postgres 10, despite the adding "IS NOT NULL" WHERE clauses earlier. Query time was very significant, even for the creator table (1.2 seconds or so on SSD). I looked at using hash indices (which have improved in postgres 10), which could save index size (disk and RAM) and potentially be faster for these trivial exact lookups, but didn't go for it at this time.
* use index_val, not index, in SQL schemaBryan Newbold2018-08-201-4/+4
|
* add index on release_rev_abstract SHA1 columnBryan Newbold2018-08-191-0/+1
|
* add index on file_rev_url file_revBryan Newbold2018-08-191-0/+2
|
* create index on release_rev_abstractsBryan Newbold2018-08-181-0/+2
|
* add core_id to schemasBryan Newbold2018-08-141-4/+6
|
* contribs: raw -> raw_nameBryan Newbold2018-07-251-3/+3
|
* tweaks/fixes to SQL changesBryan Newbold2018-07-241-7/+7
|
* bunch of SQL updatesBryan Newbold2018-07-231-48/+105
| | | | | | | | | - file urls as a table - more external identifiers (eg, pmcid, wikidata) - release ref and contrib mostly as JSON - abstracts - timestamps - fixed size external identifiers (CHAR not TEXT)
* sql: work really an empty stubBryan Newbold2018-07-201-8/+4
|
* update schema (sql and api) for rev ids, editor_id, editgroup_idBryan Newbold2018-07-201-113/+112
|
* prep for base32 encoded identifiersBryan Newbold2018-07-201-17/+17
|
* fix problems with dummy dataBryan Newbold2018-06-301-9/+9
|
* add some container extra_json to examplesBryan Newbold2018-06-301-4/+4
|
* add a bunch of database indexesBryan Newbold2018-06-271-0/+37
|
* ISO 639-1 for language codesBryan Newbold2018-06-191-1/+1
|
* change release field order, and larger examplesBryan Newbold2018-06-171-20/+44
|
* more consistent example dataBryan Newbold2018-06-171-6/+6
|
* updates to schema(s): more complete, alignmentBryan Newbold2018-06-041-16/+27
|
* renumber dummy/example entitiesBryan Newbold2018-05-281-29/+29
|
* tweak schema (api and sql)Bryan Newbold2018-05-261-16/+23
|
* return all edits for an editgroup GETBryan Newbold2018-05-251-10/+10
|
* index for contribsBryan Newbold2018-05-251-5/+6
|
* more inserts; also fix typo around target_release_ident_idBryan Newbold2018-05-251-10/+57
|
* revision publish date as DateBryan Newbold2018-05-241-2/+3
|
generated by cgit v1.2.3 (git 2.39.1) at 2024-12-21 00:07:32 +0000