X-Git-Url: https://git.rohieb.name/iserv-mod-room-reservation.git/blobdiff_plain/6df989565d1017673acc2ee4c8006a08c89648e8..be23fcdb636deb4967ef0392ca8a67c0657d82cc:/sql/mod_room-reservation.sql?ds=sidebyside

diff --git a/sql/mod_room-reservation.sql b/sql/mod_room-reservation.sql
old mode 100755
new mode 100644
index a4cf33f..b6bfd65
--- a/sql/mod_room-reservation.sql
+++ b/sql/mod_room-reservation.sql
@@ -1,5 +1,14 @@
 --
--- Table with bookings for module iserv-room-reservation
+-- Table with rooms allowed for booking
+-- 
+CREATE TABLE mod_roomreservation_roomswhitelist (
+		rrr_name			 TEXT			 UNIQUE REFERENCES rooms(name)
+                             ON DELETE CASCADE
+                             ON UPDATE CASCADE
+);
+
+--
+-- Table with bookings
 --
 CREATE TABLE mod_roomreservation_bookings (
     rrb_uid        SERIAL    NOT NULL PRIMARY KEY, -- Unique ID 
@@ -25,3 +34,5 @@ CREATE TABLE mod_roomreservation_bookings (
 --
 GRANT SELECT, INSERT, UPDATE, DELETE ON mod_roomreservation_bookings, mod_roomreservation_bookings_rrb_uid_seq TO webusr;
 GRANT SELECT, INSERT, UPDATE, DELETE ON mod_roomreservation_bookings, mod_roomreservation_bookings_rrb_uid_seq TO webadm;
+GRANT SELECT ON mod_roomreservation_roomswhitelist TO webusr;
+GRANT SELECT, INSERT, UPDATE, DELETE ON mod_roomreservation_roomswhitelist TO webadm;