Skip to content

Instantly share code, notes, and snippets.

@nils-werner
Created June 21, 2011 14:16
Show Gist options
  • Save nils-werner/1037946 to your computer and use it in GitHub Desktop.
Save nils-werner/1037946 to your computer and use it in GitHub Desktop.
SQLite queries to enable BOB on WebOS 1.4.5
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";
@nils-werner
Copy link
Author

Please note that 2199023255914 in the second references the ID created by the first one.

YOU HAVE TO CHANGE IT ACCORDING TO YOUR DATABASE

@nils-werner
Copy link
Author

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