Added tag REL_8.08.03 for changeset c54c3c7d7ccab77dba44853e0519e259e7f7d615

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

diff --git a/sql/mod_room-reservation.sql b/sql/mod_room-reservation.sql
index a4cf33f..b6bfd65 100644 (file)
--- a/sql/mod_room-reservation.sql
+++ b/sql/mod_room-reservation.sql
@@ -1,5 +1,14 @@
 --\r
 --\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
 --\r
 CREATE TABLE mod_roomreservation_bookings (\r
     rrb_uid        SERIAL    NOT NULL PRIMARY KEY, -- Unique ID \r


@@ -25,3 +34,5 @@ CREATE TABLE mod_roomreservation_bookings (
 --\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
 --\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