йЧ╨Ў/ь▓⌠ ■ ∙√ ≈≤ ≥ ⌡PAGING_CARRIERLjava/lang/String; PAGING_PINPAGING_PHONENUM_DAYS_OF_WEEKI ConstantValueMINUTES_IN_HOUR< INTERVAL_SIZE NUM_INTERVALSs_sUserTable°s_sGeneralTable² s_sUserLocale·s_sNotificationScheduleTable÷s_sSMTPTable═s_sPageTable║s_sPreferredCredentials╒s_sDfltPermsёs_sUserPrefєs_sDfltNotifyPref╔s_sPagingServersTableіs_sPagingCarriersTableїs_sDeleteInterval╗s_sInsertInterval╘s_sUserIdQuery╙s_sGetAllIntervals╚s_sUserFound╛s_sGetLocaleґs_sGetLocaleForUpdateўs_sUpdateLocaleInfo╞s_sInsertLocaleInfo╟s_sSelectPC╠s_sSelectForUpdatePC╡s_sSelectAllPCЁs_sUpdatePCЄs_sUpdatePC2╣s_sInsertPCІs_sInsertPC2Їs_sDeletePC╦s_sDeleteServicePC╧s_sSelectDP╨s_sSelectForUpdateDP╩s_sUpdateDP╪s_sInsertDPҐs_sDeleteDPЎs_sSelectAllDfltPerms©s_sSelectNPюs_sSelectForUpdateNPаs_sUpdateNPбs_sInsertNPцs_sDeleteNPдs_sSelectAllDfltNotifyPrefsеs_sSelectGeneralAttrфs_sUpdateDisplayNameгs_sSelectGeneralTableхs_sUpdateGeneralTableиs_sInsertGeneralTableйs_sSelectNotifiableUsersкs_sInsertUserPrefлs_sUpdateUserPrefмs_sSelectUserPrefнs_sSelectAllUserPrefоs_sUpdateEmailPrefsпs_sSelectEmailPagePrefsяs_sUpdatePagePrefsрs_sRetrieveEmailPagingFiltersсs_sGetDistinctCarriersтs_getPrefCredStatesу()VCodeLineNumberTable SourceFileVdvConstants.javajava/lang/StringCARRIERжвPIN NUMBERoracle/sysman/vdv/VdvConstantsjava/lang/ObjectSMP_VDV_USERSMP_VDV_GENERALSMP_VDV_USER_LOCALESMP_VDV_NOTIFICATION_SCHEDULESMP_VDV_SMTP_EMAILSMP_VDV_PAGESMP_VDV_PREFERRED_CREDENTIALSSMP_VDV_DEFAULT_PERMISSIONSSMP_VDV_USER_PREFSMP_VDV_DEFAULT_NOTIFY_PREFSSMP_VDM_PAGING_SERVER_INFOSMP_VDM_PAGING_CARRIER_INFO< DELETE FROM SMP_VDV_NOTIFICATION_SCHEDULE WHERE user_id = ?N INSERT INTO SMP_VDV_NOTIFICATION_SCHEDULE (user_id, schedule) VALUES (?, ?) 6 SELECT user_id FROM SMP_VDV_USER WHERE user_name = ?x SELECT * FROM SMP_VDV_NOTIFICATION_SCHEDULE WHERE user_id IN (SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) E SELECT COUNT(*) AS user_count FROM SMP_VDV_USER WHERE user_name = ? ┤SELECT language, country, variant FROM SMP_VDV_USER_LOCALE WHERE user_id IN ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) { SELECT * FROM SMP_VDV_USER_LOCALE WHERE user_id IN ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) FOR UPDATE ╙ UPDATE SMP_VDV_USER_LOCALE SET user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ), language = ? , country = ? , variant = ? ▀ INSERT INTO SMP_VDV_USER_LOCALE (user_id, language, country, variant) ( SELECT user_id, ?, ?, ? FROM SMP_VDV_USER WHERE user_name = ? ) SELECT user_id, service_type, service_name, credentials FROM SMP_VDV_PREFERRED_CREDENTIALS WHERE user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) AND (service_name = ? OR service_name = ?) AND service_type IN ( %s ) щ SELECT * FROM SMP_VDV_PREFERRED_CREDENTIALS WHERE user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) AND service_type = ? AND service_name = ? FOR UPDATE х SELECT user_id, service_type, service_name, credentials FROM SMP_VDV_PREFERRED_CREDENTIALS WHERE user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) UPDATE SMP_VDV_PREFERRED_CREDENTIALS SET credentials = ? WHERE user_id = (SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) AND service_type = ? AND service_name = ? UPDATE SMP_VDV_PREFERRED_CREDENTIALS SET credentials = ? WHERE user_id = (SELECT user_id FROM SMP_VDV_USER WHERE user_name = '%s' ) AND service_type = '%s' AND service_name = '%s' ё INSERT INTO SMP_VDV_PREFERRED_CREDENTIALS ( user_id, service_type, service_name, credentials) (SELECT user_id, ?, ?, ? FROM SMP_VDV_USER WHERE user_name = ? ) ґ INSERT INTO SMP_VDV_PREFERRED_CREDENTIALS ( user_id, service_type, service_name, credentials) (SELECT user_id, '%s', '%s', ? FROM SMP_VDV_USER WHERE user_name = '%s' ) о DELETE FROM SMP_VDV_PREFERRED_CREDENTIALS WHERE user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) AND service_name = ? AND service_type = ? ^ DELETE FROM SMP_VDV_PREFERRED_CREDENTIALS WHERE service_name = ? AND service_type = ? SELECT permission FROM SMP_VDV_DEFAULT_PERMISSIONS WHERE user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) AND other_user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ?) SELECT permission FROM SMP_VDV_DEFAULT_PERMISSIONS WHERE user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) AND other_user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ?) FOR UPDATE 3 UPDATE SMP_VDV_DEFAULT_PERMISSIONS SET permission = ? WHERE user_id = (SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) AND other_user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ?) б INSERT INTO SMP_VDV_DEFAULT_PERMISSIONS ( user_id, other_user_id, permission) (SELECT A.user_id, B.user_id, ? FROM SMP_VDV_USER A, SMP_VDV_USER B WHERE A.user_name = ? AND B.user_name = ? ) DELETE FROM SMP_VDV_DEFAULT_PERMISSIONS WHERE user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) AND other_user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ?) SELECT B.user_name, permission FROM SMP_VDV_DEFAULT_PERMISSIONS A ,SMP_VDV_USER B WHERE A.user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ?) AND A.other_user_id = B.user_id SELECT notify FROM SMP_VDV_DEFAULT_NOTIFY_PREFS WHERE user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) AND other_user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ?) SELECT notify FROM SMP_VDV_DEFAULT_NOTIFY_PREFS WHERE user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) AND other_user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ?) FOR UPDATE 0 UPDATE SMP_VDV_DEFAULT_NOTIFY_PREFS SET notify = ? WHERE user_id = (SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) AND other_user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ?) © INSERT INTO SMP_VDV_DEFAULT_NOTIFY_PREFS ( user_id, other_user_id, notify) (SELECT A.user_id, B.user_id, ? FROM SMP_VDV_USER A, SMP_VDV_USER B WHERE A.user_name = ? AND B.user_name = ? ) DELETE FROM SMP_VDV_DEFAULT_NOTIFY_PREFS WHERE user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) AND other_user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ?) Ъ SELECT B.user_name, notify FROM SMP_VDV_DEFAULT_NOTIFY_PREFS A ,SMP_VDV_USER B WHERE A.user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ?) AND A.other_user_id = B.user_id с SELECT user_name, display_name, advanced_features, description, time_zone, time_zone_pref FROM SMP_VDV_USER A, SMP_VDV_GENERAL B WHERE user_name = ? AND A.user_id = B.user_id ? UPDATE SMP_VDV_USER SET display_name = ? WHERE user_name = ? ╞ SELECT advanced_features, description, time_zone FROM SMP_VDV_GENERAL WHERE user_id = ( SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) FOR UPDATE К UPDATE SMP_VDV_GENERAL SET advanced_features = ?, description = ?, time_zone = ?, time_zone_pref = ? WHERE user_id = (SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) ╚ INSERT INTO SMP_VDV_GENERAL ( user_id, advanced_features, description, time_zone, time_zone_pref ) ( SELECT user_id, ?, ?, ?, ? FROM SMP_VDV_USER WHERE user_name = ? )lSELECT user_name, schedule FROM SMP_VDV_USER A, SMP_VDV_NOTIFICATION_SCHEDULE B WHERE A.user_id = B.user_id─INSERT INTO SMP_VDV_USER_PREF ( user_id, app, name, value ) (SELECT user_id, ?, ?, ? FROM SMP_VDV_USER WHERE user_name = ? ) ⌠ UPDATE SMP_VDV_USER_PREF SET value = ? WHERE app = ? AND name = ? AND user_id = (SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) ┘SELECT p.value FROM SMP_VDV_USER_PREF p, SMP_VDV_USER u WHERE u.user_name = ? AND p.user_id = u.user_id AND p.app = ? AND p.name = ?~SELECT p.name, p.value FROM SMP_VDV_USER_PREF p, SMP_VDV_USER u WHERE u.user_name = ? AND p.user_id = u.user_id AND p.app = ?,UPDATE SMP_VDV_SMTP_EMAIL SET email_address = ?, subject_prefix = ?, email_length = ?, email_filter = ?, subject_format = ?, body_header_format = ?, body_detail_format = ? where user_id = (SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) bSELECT EMAIL.email_address "EMAIL_ADDRESS", Email.subject_prefix "EMAIL_SUBJECT_PREFIX", Email.email_length "EMAIL_LENGTH", Email.email_filter "EMAIL_FILTER", Email.subject_format "EMAIL_SUBJECT_FORMAT", Email.body_header_format "EMAIL_BODY_HEADER_FORMAT", Email.body_detail_format "EMAIL_BODY_DETAIL_FORMAT", Page.is_page_to_email "IS_PAGE_TO_EMAIL", Page.carrier "CARRIER" , Page.pin "PIN", Page.page_email_id "PAGE_EMAIL_ID" , Page.page_prefix "PAGE_PREFIX", Page.page_data_length "PAGE_DATA_LENGTH", Page.page_filter "PAGE_FILTER", Page.body_header_format "PAGE_BODY_HEADER_FORMAT", Page.body_detail_format "PAGE_BODY_DETAIL_FORMAT" from SMP_VDV_SMTP_EMAIL Email, SMP_VDV_PAGE Page where Email.user_id = (SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) AND Email.user_id = Page.user_id >UPDATE SMP_VDV_PAGE SET is_page_to_email = ?, carrier = ?, pin = ?, page_email_id = ?, page_prefix = ?, page_data_length = ?, page_filter = ?, body_header_format = ?, body_detail_format = ? where user_id = (SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) "SELECT Email.email_filter "EMAIL_FILTER", Page.page_filter "PAGE_FILTER" from SMP_VDV_SMTP_EMAIL Email, SMP_VDV_PAGE Page where Email.user_id = (SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) and Page.user_id = Email.user_id *SELECT DISTINCT carrier from SMP_VDV_PAGEЎSELECT service_type, service_name from SMP_VDV_PREFERRED_CREDENTIALS where user_id = (SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) and ( %s ) (Ljava/lang/String;)V A !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~─│┌┐└┘├┤┬┴┼▀▄█▌E%╩YЇЁ╩YЇЁ╩YЇЁ╠▐┐└┘░▒