aboutsummaryrefslogtreecommitdiffstats
path: root/rust/migrations
Commit message (Collapse)AuthorAgeFilesLines
* Merge branch 'master' into cockroachx-attic-cockroachcockroachBryan Newbold2018-09-101-14/+14
|\ | | | | | | | | Manually resolve conflicts in: rust/migrations/2018-05-12-001226_init/up.sql
| * 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.
* | changelog ID as a sequenceBryan Newbold2018-09-092-1/+5
| | | | | | | | | | | | | | | | | | | | | | As noted elsewhere, auto-increment sequences in postgres, mysql, and cockroach can have gaps: when transactions that increment a number are rolled back, a "gap" is left. I didn't realize this, and it's problematic for the external changelog API. I'll need to re-write the changelog inserter to query for the current highest number when inserting, which is unfortunate and might slow down bulk imports.
* | Merge branch 'http-verbs' into cockroachBryan Newbold2018-09-091-0/+2
|\| | | | | | | | | | | | | | | Manually merged conflicts: rust/migrations/2018-05-12-001226_init/up.sql rust/src/api_server.rs rust/src/database_schema.rs
| * 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
| |
* | cockroach: catch remaining JSONB stuffBryan Newbold2018-08-171-7/+7
| |
* | cockroach: try JSONB over JSONBryan Newbold2018-08-141-6/+6
| |
* | revert role_val changeBryan Newbold2018-08-141-2/+2
| |
* | cockroach: rename reserved columnsBryan Newbold2018-08-141-5/+5
| |
* | cockroach: create active_editgroup_id index on editor tableBryan Newbold2018-08-141-0/+2
| |
* | cockroach: no WHERE on indexesBryan Newbold2018-08-141-14/+14
| |
* | cockroach: gen_random_uuid() not uuid_generate_v4()Bryan Newbold2018-08-141-14/+14
| |
* | disable base diesel setup (for cockroach)Bryan Newbold2018-08-142-19/+22
|/
* 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-242-7/+10
|
* 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
|
* extra_json in SQL schema and implementationBryan Newbold2018-05-241-10/+10
|
* more i64 cleanupBryan Newbold2018-05-241-2/+2
|
* WIP on API spec improvementsBryan Newbold2018-05-241-1/+1
| | | | Fixes a bunch of i64/i32/isize stuff
* move dummy data into primary migrationBryan Newbold2018-05-243-59/+62
| | | | | I couldn't come up with a "safe" way to wipe these rows (without causing larger insert PK uniqueness errors)
* unique usernames!Bryan Newbold2018-05-161-1/+1
|
* simplify SQL schema a bitBryan Newbold2018-05-161-3/+5
|
* remove all extra_json for nowBryan Newbold2018-05-151-11/+11
|
* include dummy data by defaultBryan Newbold2018-05-152-0/+59
|
* JSONB back to JSON, and skip for container_rev while debuggingBryan Newbold2018-05-151-11/+11
|
* update schemaBryan Newbold2018-05-151-8/+8
|
* set correct primary keys on many-to-many tablesBryan Newbold2018-05-151-3/+3
|
* JSONB not JSONBryan Newbold2018-05-151-11/+11
|
* diesel wants primary keysBryan Newbold2018-05-151-0/+2
|
* tweaks to SQL schemaBryan Newbold2018-05-141-3/+3
|
generated by cgit v1.2.3 (git 2.39.1) at 2024-11-24 15:24:06 +0000