summary refs log tree commit diff
path: root/synapse/storage/schema/full_schemas (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Reorganise the database schema directories (#9932)Richard van der Hoff2021-05-071-8/+0
| | | | | The hope here is that by moving all the schema files into synapse/storage/schema, it gets a bit easier for newcomers to navigate. It certainly got easier for me to write a helpful README. There's more to do on that front, but I'll follow up with other PRs for that.
* Move storage classes into a main "data store".Erik Johnston2019-10-2119-3000/+8
| | | | | This is in preparation for having multiple data stores that offer different functionality, e.g. splitting out state or event storage.
* fix maybeAmber H. Brown2019-06-071-20/+2
|
* just user dir?Amber H. Brown2019-06-071-1/+19
|
* remove background updates that arent neededAmber H. Brown2019-06-071-33/+1
|
* add more commentsAmber Brown2019-06-061-0/+5
|
* add stuff in bg updatesAmber Brown2019-06-041-10/+62
|
* WHY IS THIS CALLED A SLIGHTLY DIFFERENT THINGAmber Brown2019-06-031-0/+1
|
* more fixAmber Brown2019-06-031-0/+38
|
* fix schemasAmber Brown2019-06-033-59/+18
|
* full schemaAmber Brown2019-06-033-0/+2315
|
* Remove unused server_tls_certificates functions (#5028)Richard van der Hoff2019-04-081-8/+3
| | | | These have been unused since #4120, and with the demise of perspectives, it is unlikely that they will ever be used again.
* drop tables listed in #1830 (#4992)Neil Johnson2019-04-0817-670/+17
| | | | | | | | | | | | | | | Tables dropped: * application_services, * application_services_regex, * transaction_id_to_pdu, * stats_reporting * current_state_resets * event_content_hashes * event_destinations * event_edge_hashes * event_signatures * feedback * room_hosts * state_forward_extremities
* Remove presence lists (#4989)Neil Johnson2019-04-031-10/+2
| | | Remove presence list support as per MSC 1819
* Add comment to schemaErik Johnston2019-03-081-0/+2
|
* Drop sent_transactionsAaron Raimist2018-12-012-38/+0
| | | | Signed-off-by: Aaron Raimist <aaron@raim.ist>
* Create the column nullableRichard van der Hoff2018-07-261-1/+6
| | | | | There's no real point in ever making the column non-nullable, and doing so breaks the sytests.
* comment on event_edgesRichard van der Hoff2018-07-261-1/+2
|
* copyrightsMatthew Hodgson2016-01-0726-26/+26
|
* pushers table requires an access_tokenErik Johnston2015-04-291-0/+1
|
* Use TEXT instead of VARCHAR(n), since PostgreSQL treats them the same except ↵Erik Johnston2015-04-2826-260/+260
| | | | for a limit
* Add unique index to room_aliases, remove duplicates on upgrade. Convert some ↵Erik Johnston2015-04-175-4/+8
| | | | columns back to TEXT from bytea
* Go back to storing JSON in TEXTErik Johnston2015-04-163-9/+9
|
* Change full_schemas/11 to work with postgresErik Johnston2015-04-1512-83/+86
|
* Add index on events (topological_ordering, stream_ordering) to help with ↵Erik Johnston2015-04-151-0/+1
| | | | ORDER BY clauses
* Rename user_ips.user -> user_idErik Johnston2015-04-141-3/+3
|
* Add support for postgres instead of mysql. Change sql accourdingly. blob + ↵Erik Johnston2015-04-1412-97/+97
| | | | varbinary -> bytea. No support for UNSIGNED or CREATE INDEX IF NOT EXISTS.
* For backwards compat, make state_groups.id have a type of int, not varcharErik Johnston2015-04-131-1/+1
|
* DROP indexes before recreating themErik Johnston2015-04-101-1/+1
|
* Use LONGBLOB and TEXT for arbitary length rowsErik Johnston2015-04-1010-31/+31
|
* Use unsigned bigintErik Johnston2015-04-1016-41/+41
|
* SQLite wants INTEGER and not BIGINT for primary keysErik Johnston2015-04-103-4/+4
|
* Update full_schemas/16 to match delta files. Add delta/16 scriptsErik Johnston2015-04-103-0/+123
|
* Fix schema againErik Johnston2015-04-102-3/+3
|
* Revert non-trivial schema changes and move them to a new schema version.Erik Johnston2015-04-1019-27/+636
|
* Remove spurious spacesErik Johnston2015-04-0912-43/+43
|
* Don't use multiple UNIQUE constraints; it will cause deadlocksErik Johnston2015-04-072-6/+8
|
* Fix unicode supportErik Johnston2015-04-0212-128/+126
|
* Make work in both Maria and SQLite. Fix testsErik Johnston2015-04-0112-48/+48
|
* Fix unicode database supportErik Johnston2015-03-253-3/+2
|
* Fix up schemas some moreErik Johnston2015-03-202-2/+2
|
* Remove redundant keyErik Johnston2015-03-191-1/+0
|
* Fix up schemas to work with mariadbErik Johnston2015-03-1912-69/+67
|
* Update schema to work with mariadbErik Johnston2015-03-1812-208/+184
|
* Actually add full_schemas dirErik Johnston2015-03-0412-0/+645