aboutsummaryrefslogtreecommitdiffstats
path: root/rust/migrations/2018-05-12-001226_init/up.sql
Commit message (Collapse)AuthorAgeFilesLines
* changelog ID as a sequenceBryan Newbold2018-09-091-1/+3
| | | | | | | | | | | 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
|/
* 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
|
* 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-241-0/+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
|
* 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
|
* flesh out SQL schemaBryan Newbold2018-05-141-0/+140
|
* add scratch rust stuffBryan Newbold2018-05-131-0/+61