Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Fix SMS db in Android 7 after update
BEGIN TRANSACTION;
CREATE TABLE threads_1 (_id INTEGER PRIMARY KEY AUTOINCREMENT,date INTEGER DEFAULT 0,message_count INTEGER DEFAULT 0,
recipient_ids TEXT,snippet TEXT,snippet_cs INTEGER DEFAULT 0,read INTEGER DEFAULT 1,archived INTEGER DEFAULT 0,
type INTEGER DEFAULT 0,error INTEGER DEFAULT 0,has_attachment INTEGER DEFAULT 0,attachment_info TEXT,
hack_ INTEGER DEFAULT 0,notification INTEGER DEFAULT 1);
INSERT INTO threads_1 SELECT *, 1 FROM threads;
DROP TABLE threads;
ALTER TABLE threads_1 RENAME TO threads;
DROP VIEW sms_restricted;
DROP VIEW pdu_restricted;
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.