From 4143680297808dd23fe03b121f28ad5183601b8b Mon Sep 17 00:00:00 2001
From: msquare <msquare@notrademark.de>
Date: Sun, 10 Dec 2017 15:02:37 +0100
Subject: remove room number and visible flag, rename pentabarf to frab and
 introduce map/c3nav integration as well as markdown description for rooms

---
 db/update.sql | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

(limited to 'db/update.sql')

diff --git a/db/update.sql b/db/update.sql
index c5187675..b36ea522 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -34,4 +34,14 @@ ALTER TABLE `LogEntries` CHANGE COLUMN `nick` `level` VARCHAR(20) NOT NULL;
 
 -- Angeltype contact update
 ALTER TABLE `AngelTypes` DROP FOREIGN KEY angeltypes_ibfk_1;
-ALTER TABLE `AngelTypes` DROP `contact_user_id`;
\ No newline at end of file
+ALTER TABLE `AngelTypes` DROP `contact_user_id`;
+
+-- Room update
+ALTER TABLE `Room` DROP `Number`;
+ALTER TABLE `Room` DROP `show`;
+ALTER TABLE `Room` DROP `Man`;
+ALTER TABLE `Room` ADD `from_frab` BOOLEAN NOT NULL AFTER `FromPentabarf`;
+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`;
-- 
cgit v1.2.3-54-g00ecf

