diff options
| author | Anton Tananaev <anton.tananaev@gmail.com> | 2016-12-16 00:28:26 +1300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-12-16 00:28:26 +1300 |
| commit | 835853422ce9f1c1fde15a6464c6f0f7eda4fed7 (patch) | |
| tree | 049fa09050caec98242a0f642d478a533cee5898 /setup | |
| parent | f76c78a68f249ddb45a2bbae11dd95dd6db743b6 (diff) | |
| parent | ef9148eea8dd404aba5707898f244a4b7bc26feb (diff) | |
| download | trackermap-server-835853422ce9f1c1fde15a6464c6f0f7eda4fed7.tar.gz trackermap-server-835853422ce9f1c1fde15a6464c6f0f7eda4fed7.tar.bz2 trackermap-server-835853422ce9f1c1fde15a6464c6f0f7eda4fed7.zip | |
Merge pull request #2686 from Abyss777/calendars
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 --> |