From bd2a8efaddacbd8d8386ae38f000b633845639ab Mon Sep 17 00:00:00 2001 From: Abyss777 <abyss@fox5.ru> Date: Tue, 21 Feb 2017 15:20:25 +0500 Subject: Implement SMS notifications with help smpp protocol --- setup/default.xml | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) (limited to 'setup') 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> -- cgit v1.2.3