diff options
| author | Abyss777 <abyss@fox5.ru> | 2016-12-14 17:34:34 +0500 |
|---|---|---|
| committer | Abyss777 <abyss@fox5.ru> | 2016-12-14 18:02:17 +0500 |
| commit | fff8f0c792606daff151624479d9ae9dc54187d5 (patch) | |
| tree | 97e0ab38de08aba1a7b7adf90283df82d850a3ad /setup | |
| parent | 4557cf912fada1dc249333aa05215b0116b8ebab (diff) | |
| download | trackermap-server-fff8f0c792606daff151624479d9ae9dc54187d5.tar.gz trackermap-server-fff8f0c792606daff151624479d9ae9dc54187d5.tar.bz2 trackermap-server-fff8f0c792606daff151624479d9ae9dc54187d5.zip | |
Calendars implementation
Diffstat (limited to 'setup')
| -rw-r--r-- | setup/default.xml | 38 |
1 files changed, 36 insertions, 2 deletions
diff --git a/setup/default.xml b/setup/default.xml index ad23d7bd3..aeb8fbe54 100644 --- a/setup/default.xml +++ b/setup/default.xml @@ -206,14 +206,15 @@ </entry> <entry key='database.insertGeofence'> - INSERT INTO geofences (name, description, area, attributes) - VALUES (:name, :description, :area, :attributes) + INSERT INTO geofences (name, description, calendarid, area, attributes) + VALUES (:name, :description, :calendarid, :area, :attributes) </entry> <entry key='database.updateGeofence'> UPDATE geofences SET name = :name, description = :description, + calendarid = :calendarid, area = :area, attributes = :attributes WHERE id = :id @@ -315,6 +316,39 @@ INSERT INTO statistics (captureTime, activeUsers, activeDevices, requests, messagesReceived, messagesStored, attributes) VALUES (:captureTime, :activeUsers, :activeDevices, :requests, :messagesReceived, :messagesStored, :attributes) </entry> + + <entry key='database.selectCalendarsAll'> + SELECT * FROM calendars + </entry> + + <entry key='database.insertCalendar'> + INSERT INTO calendars (name, calendarData, attributes) + VALUES (:name, :calendarData, :attributes) + </entry> + + <entry key='database.updateCalendar'> + UPDATE calendars SET + name = :name, + calendarData = :calendarData, + attributes = :attributes + WHERE id = :id + </entry> + + <entry key='database.deleteCalendar'> + DELETE FROM calendars WHERE id = :id + </entry> + + <entry key='database.selectCalendarPermissions'> + SELECT userId, calendarId FROM user_calendar + </entry> + + <entry key='database.linkCalendar'> + INSERT INTO user_calendar (userId, calendarId) VALUES (:userId, :calendarId) + </entry> + + <entry key='database.unlinkCalendar'> + DELETE FROM user_calendar WHERE userId = :userId AND calendarId = :calendarId + </entry> <!-- PROTOCOL CONFIG --> |