From 32a9eaf3b6a68626580078a3302f8dd8e85eb165 Mon Sep 17 00:00:00 2001
From: Mario <mario@mariovavti.com>
Date: Fri, 17 Dec 2021 15:30:26 +0100
Subject: update db schemas

---
 install/schema_mysql.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'install/schema_mysql.sql')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 8267d17f7..054c1da03 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -37,6 +37,7 @@ CREATE TABLE IF NOT EXISTS `abook` (
   `abook_incl` text NOT NULL,
   `abook_excl` text NOT NULL,
   `abook_instance` text NOT NULL,
+  `abook_role` char(191) NOT NULL DEFAULT '',
   PRIMARY KEY (`abook_id`),
   KEY `abook_account` (`abook_account`),
   KEY `abook_channel` (`abook_channel`),
@@ -58,7 +59,8 @@ CREATE TABLE IF NOT EXISTS `abook` (
   KEY `abook_unconnected` (`abook_unconnected`),
   KEY `abook_self` (`abook_self`),
   KEY `abook_not_here` (`abook_not_here`),
-  KEY `abook_feed` (`abook_feed`)
+  KEY `abook_feed` (`abook_feed`),
+  KEY `abook_role` (`abook_role`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4;
 
 CREATE TABLE IF NOT EXISTS `account` (
-- 
cgit v1.2.3

