Commit Graph

7 Commits

Author SHA1 Message Date
Tau
6d91659b24 Add automated schema management 2019-11-06 17:28:31 -05:00
Tau
30d42bd832 Store array colums as CSV text
This is in preparation for a transition to SQLite, which sadly does
not support array-valued columns (or indeed have much of a type
system in general).
2019-11-06 17:28:30 -05:00
Tau
6ab2112ea9 Stop using SQL namespaces ("schemas")
This is in preparation for a transition to SQLite. SQLite does have
a similar concept called "attached databases", but it's kind of a
pain to deal with if you're casually browsing a database from the
`sqlite3` CLI so we'll just use some slightly uglier explicitly
namespaced table name identifiers instead.
2019-11-06 17:28:30 -05:00
Tau
d1c3051a5e idz: Add initial team tables 2019-11-06 17:28:30 -05:00
Tau
c2b0bcabc4 idz: Remove profile ext id
Turns out (while researching team creation) the profile ext id
is just the aime id. After creating a team a profile discovery
request is immediately issued with the "profile id" in the field
that holds the aime id during initial profile load.
2019-11-06 17:28:30 -05:00
Tau
1aaae51eab Add ID generation sprocs for manual db interventions 2019-11-06 17:28:30 -05:00
Tau
a85ed40d43 Add db metadata "schema" 2019-11-06 17:28:30 -05:00