Added tag REL_9.02.07 for changeset 320ca1638c2b

[iserv-mod-room-reservation.git] / sql / mod_room-reservation.sql

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