diff options
| author | Erik Johnston <erik@matrix.org> | 2015-03-18 11:18:49 +0000 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2015-03-18 11:18:49 +0000 |
| commit | 89036579ed475464ccc8619344db513042e1d792 (patch) | |
| tree | 9ad6ca439f6c9b002dcca260266dbc6d2a73654f /synapse/storage/schema/delta/13 | |
| parent | Add a DistributionMetric to HTTP request/response processing time in the server (diff) | |
| download | synapse-89036579ed475464ccc8619344db513042e1d792.tar.xz | |
Update schema to work with mariadb
Diffstat (limited to 'synapse/storage/schema/delta/13')
| -rw-r--r-- | synapse/storage/schema/delta/13/v13.sql | 19 |
1 files changed, 8 insertions, 11 deletions
diff --git a/synapse/storage/schema/delta/13/v13.sql b/synapse/storage/schema/delta/13/v13.sql index e491ad5aec..68d4ebd896 100644 --- a/synapse/storage/schema/delta/13/v13.sql +++ b/synapse/storage/schema/delta/13/v13.sql @@ -14,21 +14,18 @@ */ CREATE TABLE IF NOT EXISTS application_services( - id INTEGER PRIMARY KEY AUTOINCREMENT, - url TEXT, - token TEXT, - hs_token TEXT, - sender TEXT, - UNIQUE(token) ON CONFLICT ROLLBACK + id INTEGER PRIMARY KEY, + url VARCHAR(255), + token VARCHAR(255), + hs_token VARCHAR(255), + sender VARCHAR(255), + UNIQUE(token) ); CREATE TABLE IF NOT EXISTS application_services_regex( - id INTEGER PRIMARY KEY AUTOINCREMENT, + id INTEGER PRIMARY KEY, as_id INTEGER NOT NULL, namespace INTEGER, /* enum[room_id|room_alias|user_id] */ - regex TEXT, + regex VARCHAR(255), FOREIGN KEY(as_id) REFERENCES application_services(id) ); - - - |