summary refs log tree commit diff
path: root/synapse/storage/schema/delta/12
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2015-04-10 11:22:04 +0100
committerErik Johnston <erik@matrix.org>2015-04-10 11:22:04 +0100
commit7e863c51e6a6a5b6f757cb279f5d7308db1432d4 (patch)
tree2b491a2422034b63b423ba11b59df0ebaa732a9c /synapse/storage/schema/delta/12
parentSQLite wants INTEGER and not BIGINT for primary keys (diff)
downloadsynapse-7e863c51e6a6a5b6f757cb279f5d7308db1432d4.tar.xz
Use unsigned bigint
Diffstat (limited to 'synapse/storage/schema/delta/12')
-rw-r--r--synapse/storage/schema/delta/12/v12.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/synapse/storage/schema/delta/12/v12.sql b/synapse/storage/schema/delta/12/v12.sql
index 4107cba71f..1247fd175c 100644
--- a/synapse/storage/schema/delta/12/v12.sql
+++ b/synapse/storage/schema/delta/12/v12.sql
@@ -30,12 +30,12 @@ CREATE TABLE IF NOT EXISTS pushers (
   app_display_name VARCHAR(64) NOT NULL,
   device_display_name VARCHAR(128) NOT NULL,
   pushkey VARBINARY(512) NOT NULL,
-  ts BIGINT NOT NULL,
+  ts BIGINT UNSIGNED NOT NULL,
   lang VARCHAR(8),
   data BLOB,
   last_token TEXT,
-  last_success BIGINT,
-  failing_since BIGINT,
+  last_success BIGINT UNSIGNED,
+  failing_since BIGINT UNSIGNED,
   UNIQUE (app_id, pushkey)
 );
 
@@ -54,7 +54,7 @@ CREATE INDEX IF NOT EXISTS push_rules_user_name on push_rules (user_name);
 
 CREATE TABLE IF NOT EXISTS user_filters(
   user_id VARCHAR(150),
-  filter_id BIGINT,
+  filter_id BIGINT UNSIGNED,
   filter_json BLOB
 );