Created
June 21, 2011 14:16
-
-
Save nils-werner/1037946 to your computer and use it in GitHub Desktop.
SQLite queries to enable BOB on WebOS 1.4.5
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
insert into com_palm_data_carriernetworksettings_CarrierNetworkSettings ("mcc", "mnc", "qOperatorShortName", "useThisOverrideRecord", "maxTransitUnit", "maxSegmentSize", "maxSocketIdleTime", "qOperatorLongName", "gsmNumSimPDP", "umtsNumSimPDP", "smsEmailGateway", "smsMessageSizeLimit", "isSmscNumberOnSimCard", "smscNumber", "smsValidityPeriod", "smsMaxPartsPerMessage", "smsMaxRecipients", "smsRequestDeliveryReceiptAvailable", "smsCanSendBlank", "smsHeaderSizeLimit", "smsEncoding", "smsTransportMethods", "smsNumberSecondsWaitForSegment", "useVodaphoneVoicemail", "voicemailNumber", "useGpsSettingsInCarrierDb", "gpsAllowed", "msBasedAllowed", "msAssistedAllowed", "agpsServerAddr", "msAllowedApps", "msfpTimerMin", "msfpTimerMax", "msfpTimerDefault", "msfpTimerInterval", "mmsApnId", "mmscWapGateway", "mmscUrl", "mmscPortNumber", "mmscMessageSizeLimit", "mmsMaxVideoSize", "mmsDefaultPageDuration", "mmsMaxAudioSize", "mmsMaxPictureHeight", "mmsMaxPictureWidth", "mmsMaxRecipients", "mmsProxy", "mmsAckMessageRead", "mmsEnableAutomaticDownloadWhenRoaming", "mmsVersionNumber", "mmsCanSendBlank", "mmsCcBccSupported", "mmsIsPictureResolutionLimited", "mmsIsWavSupported", "mmsRequestDeliveryReceiptAvailable", "mmsAcknowledgeMsgReceipt", "mmsSendLowResVideo", "disableAutotext", "_class_id", "_mod_num", "_flags") values ('232', '11', 'bob', '0', '0', '0', '0', 'bob', '3', '2', NULL, '160', '1', NULL, '173', '10', '20', '1', '1', '7', 'GSM 7-Bit', NULL, '0', '1', '66477', '1', '1', '1', '1', NULL, NULL, '0', '0', '0', '0', '286', '194.48.124.7', 'http://mmsc.bob.at', '8001', '300', '300', '5000', '32767', '0', '0', '20', NULL, '0', '1', '11', '0', '1', '0', '1', '1', '0', '0', '0', '2', '471', NULL); | |
insert into com_palm_data_carriernetworksettings_dataconnectionsettings ("com_palm_data_carriernetworksettings_CarrierNetworkSettings_id", "apn", "apnid", "cshnUserName", "cshnPassword", "supportedService", "serviceDefault", "regionName", "_class_id", "_mod_num", "_flags") values ('2199023255914', 'bob.at', '74', '[email protected]', 'ppp', '1', '1', 'data.bob', '1', '457', NULL); | |
SELECT * FROM com_palm_data_carriernetworksettings_carriernetworksettings WHERE id = "2199023255913"; | |
SELECT * FROM com_palm_data_carriernetworksettings_dataconnectionsettings WHERE id = "1099511628672"; |
Also, I have no idea what that two SELECT statements were for. Maybe to check that I didn't accidentally overwrite anything.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Please note that
2199023255914
in the second references the ID created by the first one.YOU HAVE TO CHANGE IT ACCORDING TO YOUR DATABASE