X-Git-Url: https://git.rohieb.name/iserv-mod-room-reservation.git/blobdiff_plain/c28965b6f095c30c7a9cc886d54c2a5d94304f46..d7f6a32bdc1360e056c06eb5149ef3dfc5e114a1:/sql/mod_room-reservation.sql

diff --git a/sql/mod_room-reservation.sql b/sql/mod_room-reservation.sql
index a4cf33f..b6bfd65 100644
--- 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;
