From 4143680297808dd23fe03b121f28ad5183601b8b Mon Sep 17 00:00:00 2001 From: msquare 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') 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