diff options
| author | Mark Haines <mark.haines@matrix.org> | 2014-10-17 17:31:48 +0100 |
|---|---|---|
| committer | Mark Haines <mark.haines@matrix.org> | 2014-10-17 17:31:48 +0100 |
| commit | 82c582076782f180c9f69a523953c3a36b57b3ac (patch) | |
| tree | 00a79bdfe56a139cbe427ecc28bad852bdc3663d /synapse/storage/schema | |
| parent | SPEC-7: Rename 'ts' to 'origin_server_ts' (diff) | |
| download | synapse-82c582076782f180c9f69a523953c3a36b57b3ac.tar.xz | |
keep 'origin_server_ts' as 'ts' in the database to avoid needlessly updating schema
Diffstat (limited to 'synapse/storage/schema')
| -rw-r--r-- | synapse/storage/schema/pdu.sql | 2 | ||||
| -rw-r--r-- | synapse/storage/schema/transactions.sql | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/synapse/storage/schema/pdu.sql b/synapse/storage/schema/pdu.sql index 5cc8669912..16e111a56c 100644 --- a/synapse/storage/schema/pdu.sql +++ b/synapse/storage/schema/pdu.sql @@ -18,7 +18,7 @@ CREATE TABLE IF NOT EXISTS pdus( origin TEXT, context TEXT, pdu_type TEXT, - origin_server_ts INTEGER, + ts INTEGER, depth INTEGER DEFAULT 0 NOT NULL, is_state BOOL, content_json TEXT, diff --git a/synapse/storage/schema/transactions.sql b/synapse/storage/schema/transactions.sql index 5f8d01327a..88e3e4e04d 100644 --- a/synapse/storage/schema/transactions.sql +++ b/synapse/storage/schema/transactions.sql @@ -16,7 +16,7 @@ CREATE TABLE IF NOT EXISTS received_transactions( transaction_id TEXT, origin TEXT, - origin_server_ts INTEGER, + ts INTEGER, response_code INTEGER, response_json TEXT, has_been_referenced BOOL default 0, -- Whether thishas been referenced by a prev_tx @@ -35,7 +35,7 @@ CREATE TABLE IF NOT EXISTS sent_transactions( destination TEXT, response_code INTEGER DEFAULT 0, response_json TEXT, - origin_server_ts INTEGER + ts INTEGER ); CREATE INDEX IF NOT EXISTS sent_transaction_dest ON sent_transactions(destination); |