From fbbea4eb5f8e72386a78c3b4639147b6e82a8535 Mon Sep 17 00:00:00 2001
From: msquare <msquare@notrademark.de>
Date: Sat, 23 Dec 2017 11:59:13 +0100
Subject: add show on dashboard flag for angeltypes

---
 db/update.sql | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'db')

diff --git a/db/update.sql b/db/update.sql
index b36ea522..6e1c6dc5 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -45,3 +45,7 @@ update Room set `from_frab`=(`FromPentabarf`='Y');
 ALTER TABLE `Room` DROP `FromPentabarf`;
 ALTER TABLE `Room` ADD `map_url` VARCHAR(300) NULL AFTER `from_frab`;
 ALTER TABLE `Room` ADD `description` TEXT NULL AFTER `map_url`;
+
+-- Dashboard
+ALTER TABLE `AngelTypes` ADD `show_on_dashboard` BOOLEAN NOT NULL AFTER `contact_email`;
+UPDATE `AngelTypes` SET `show_on_dashboard`=TRUE;
-- 
cgit v1.2.3-54-g00ecf