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:16:09 +0100
committerErik Johnston <erik@matrix.org>2015-04-10 11:16:09 +0100
commit0f12772e320291408c8c7b475a391556db4c6d2b (patch)
tree1b6697cc6b16df7b2f547cf99d43c587b785ae56 /synapse/storage/schema/delta/12
parentUpdate full_schemas/16 to match delta files. Add delta/16 scripts (diff)
downloadsynapse-0f12772e320291408c8c7b475a391556db4c6d2b.tar.xz
SQLite wants INTEGER and not BIGINT for primary keys
Diffstat (limited to 'synapse/storage/schema/delta/12')
-rw-r--r--synapse/storage/schema/delta/12/v12.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/synapse/storage/schema/delta/12/v12.sql b/synapse/storage/schema/delta/12/v12.sql
index f0d7e74b8e..4107cba71f 100644
--- a/synapse/storage/schema/delta/12/v12.sql
+++ b/synapse/storage/schema/delta/12/v12.sql
@@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS rejections(
 
 -- Push notification endpoints that users have configured
 CREATE TABLE IF NOT EXISTS pushers (
-  id BIGINT PRIMARY KEY AUTOINCREMENT,
+  id INTEGER PRIMARY KEY AUTOINCREMENT,
   user_name VARCHAR(150) NOT NULL,
   profile_tag VARCHAR(32) NOT NULL,
   kind VARCHAR(8) NOT NULL,
@@ -40,7 +40,7 @@ CREATE TABLE IF NOT EXISTS pushers (
 );
 
 CREATE TABLE IF NOT EXISTS push_rules (
-  id BIGINT PRIMARY KEY AUTOINCREMENT,
+  id INTEGER PRIMARY KEY AUTOINCREMENT,
   user_name VARCHAR(150) NOT NULL,
   rule_id VARCHAR(150) NOT NULL,
   priority_class TINYINT NOT NULL,