Register a user account for the AS when the AS registers. Add 'sender' column to AS table.

3 files changed, 5 insertions, 2 deletions

diff --git a/synapse/storage/appservice.py b/synapse/storage/appservice.py

index 3c8bf9ad0d..eef77e737e 100644
--- a/synapse/storage/appservice.py
+++ b/synapse/storage/appservice.py
@@ -130,8 +130,9 @@ class ApplicationServiceStore(SQLBaseStore):
             return False
 
         txn.execute(
-            "UPDATE application_services SET url=?, hs_token=? WHERE id=?",
-            (service.url, service.hs_token, as_id,)
+            "UPDATE application_services SET url=?, hs_token=?, sender=? "
+            "WHERE id=?",
+            (service.url, service.hs_token, service.sender, as_id,)
         )
         # cleanup regex
         txn.execute(
diff --git a/synapse/storage/schema/application_services.sql b/synapse/storage/schema/application_services.sql

index 03b5a10c8a..e491ad5aec 100644
--- a/synapse/storage/schema/application_services.sql
+++ b/synapse/storage/schema/application_services.sql
@@ -18,6 +18,7 @@ CREATE TABLE IF NOT EXISTS application_services(
     url TEXT,
     token TEXT,
     hs_token TEXT,
+    sender TEXT,
     UNIQUE(token) ON CONFLICT ROLLBACK
 );
 
diff --git a/synapse/storage/schema/delta/v14.sql b/synapse/storage/schema/delta/v14.sql

index 03b5a10c8a..e491ad5aec 100644
--- a/synapse/storage/schema/delta/v14.sql
+++ b/synapse/storage/schema/delta/v14.sql
@@ -18,6 +18,7 @@ CREATE TABLE IF NOT EXISTS application_services(
     url TEXT,
     token TEXT,
     hs_token TEXT,
+    sender TEXT,
     UNIQUE(token) ON CONFLICT ROLLBACK
 );