aboutsummaryrefslogtreecommitdiff
path: root/setup
diff options
context:
space:
mode:
authorAbyss777 <abyss@fox5.ru>2017-02-21 15:20:25 +0500
committerAbyss777 <abyss@fox5.ru>2017-02-21 15:20:25 +0500
commitbd2a8efaddacbd8d8386ae38f000b633845639ab (patch)
tree80d4454311d9656fe79850ebcdb4131e3cc32634 /setup
parentb6af1e997c125336e2ce9f5056d9502743f22034 (diff)
downloadtraccar-server-bd2a8efaddacbd8d8386ae38f000b633845639ab.tar.gz
traccar-server-bd2a8efaddacbd8d8386ae38f000b633845639ab.tar.bz2
traccar-server-bd2a8efaddacbd8d8386ae38f000b633845639ab.zip
Implement SMS notifications with help smpp protocol
Diffstat (limited to 'setup')
-rw-r--r--setup/default.xml10
1 files changed, 6 insertions, 4 deletions
diff --git a/setup/default.xml b/setup/default.xml
index 7cbf9dab6..b5bc4202a 100644
--- a/setup/default.xml
+++ b/setup/default.xml
@@ -64,14 +64,15 @@
</entry>
<entry key='database.insertUser'>
- INSERT INTO users (name, email, hashedPassword, salt, readonly, admin, map, distanceUnit, speedUnit, latitude, longitude, zoom, twelveHourFormat, coordinateFormat, disabled, expirationTime, deviceLimit, userLimit, deviceReadonly, token, attributes)
- VALUES (:name, :email, :hashedPassword, :salt, :readonly, :admin, :map, :distanceUnit, :speedUnit, :latitude, :longitude, :zoom, :twelveHourFormat, :coordinateFormat, :disabled, :expirationTime, :deviceLimit, :userLimit, :deviceReadonly, :token, :attributes)
+ INSERT INTO users (name, email, phone, hashedPassword, salt, readonly, admin, map, distanceUnit, speedUnit, latitude, longitude, zoom, twelveHourFormat, coordinateFormat, disabled, expirationTime, deviceLimit, userLimit, deviceReadonly, token, attributes)
+ VALUES (:name, :email, :phone, :hashedPassword, :salt, :readonly, :admin, :map, :distanceUnit, :speedUnit, :latitude, :longitude, :zoom, :twelveHourFormat, :coordinateFormat, :disabled, :expirationTime, :deviceLimit, :userLimit, :deviceReadonly, :token, :attributes)
</entry>
<entry key='database.updateUser'>
UPDATE users SET
name = :name,
email = :email,
+ phone = :phone,
readonly = :readonly,
admin = :admin,
map = :map,
@@ -268,8 +269,8 @@
</entry>
<entry key='database.insertNotification'>
- INSERT INTO notifications (userId, type, web, mail, attributes)
- VALUES (:userId, :type, :web, :mail, :attributes)
+ INSERT INTO notifications (userId, type, web, mail, sms, attributes)
+ VALUES (:userId, :type, :web, :mail, :sms, :attributes)
</entry>
<entry key='database.updateNotification'>
@@ -278,6 +279,7 @@
type = :type,
web = :web,
mail = :mail,
+ sms = :sms,
attributes = :attributes
WHERE id = :id
</entry>