au.smali
.class public final Lcom/imo/android/imoim/util/au;
.super Landroid/database/sqlite/SQLiteOpenHelper;
.source "SourceFile"
# static fields
.field private static a:Lcom/imo/android/imoim/util/au;
# direct methods
.method constructor <init>()V
.registers 5
.line 74
invoke-static {}, Lcom/imo/android/imoim/IMO;->a()Lcom/imo/android/imoim/IMO;
move-result-object v0
const-string v1, "imofriends.db"
const/4 v2, 0x0
const/16 v3, 0xb6
invoke-direct {p0, v0, v1, v2, v3}, Landroid/database/sqlite/SQLiteOpenHelper;-><init>(Landroid/content/Context;Ljava/lang/String;Landroid/database/sqlite/SQLiteDatabase$CursorFactory;I)V
return-void
.end method
.method public static declared-synchronized a()Lcom/imo/android/imoim/util/au;
.registers 2
const-class v0, Lcom/imo/android/imoim/util/au;
monitor-enter v0
.line 63
:try_start_3
sget-object v1, Lcom/imo/android/imoim/util/au;->a:Lcom/imo/android/imoim/util/au;
if-nez v1, :cond_e
.line 64
new-instance v1, Lcom/imo/android/imoim/util/au;
invoke-direct {v1}, Lcom/imo/android/imoim/util/au;-><init>()V
sput-object v1, Lcom/imo/android/imoim/util/au;->a:Lcom/imo/android/imoim/util/au;
.line 66
:cond_e
sget-object v1, Lcom/imo/android/imoim/util/au;->a:Lcom/imo/android/imoim/util/au;
:try_end_10
.catchall {:try_start_3 .. :try_end_10} :catchall_12
monitor-exit v0
return-object v1
:catchall_12
move-exception v1
monitor-exit v0
throw v1
.end method
.method private static a(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
.registers 4
.line 1670
new-instance v0, Ljava/lang/StringBuilder;
const-string v1, "CREATE INDEX "
invoke-direct {v0, v1}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
invoke-virtual {v0, p0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v1, "_"
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v0, p1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v1, " ON "
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v0, p0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string p0, "("
invoke-virtual {v0, p0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v0, p1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string p0, ")"
invoke-virtual {v0, p0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object p0
return-object p0
.end method
.method private static varargs a([Ljava/lang/String;)Ljava/lang/String;
.registers 3
.line 934
new-instance v0, Ljava/lang/StringBuilder;
invoke-direct {v0}, Ljava/lang/StringBuilder;-><init>()V
const/4 v1, 0x0
.line 939
aget-object p0, p0, v1
invoke-virtual {v0, p0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const/4 p0, 0x1
new-array p0, p0, [Ljava/lang/Object;
.line 940
invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v0
aput-object v0, p0, v1
const-string v0, "UNIQUE (%s)"
invoke-static {v0, p0}, Ljava/lang/String;->format(Ljava/lang/String;[Ljava/lang/Object;)Ljava/lang/String;
move-result-object p0
return-object p0
.end method
.method static a(Landroid/database/Cursor;Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;)V
.registers 11
if-nez p0, :cond_3
return-void
.line 1710
:cond_3
invoke-interface {p0}, Landroid/database/Cursor;->getColumnCount()I
move-result v0
.line 50421
invoke-interface {p0}, Landroid/database/Cursor;->getColumnCount()I
move-result v1
.line 50422
invoke-interface {p0}, Landroid/database/Cursor;->getColumnNames()[Ljava/lang/String;
move-result-object v2
.line 50423
new-instance v3, Ljava/lang/StringBuilder;
const-string v4, "INSERT INTO "
invoke-direct {v3, v4}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
invoke-virtual {v3, p2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v4, "("
invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const/4 v4, 0x0
aget-object v5, v2, v4
invoke-virtual {v3, v5}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v3}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v3
const/4 v5, 0x1
const/4 v6, 0x1
:goto_2a
if-ge v6, v1, :cond_45
.line 50425
new-instance v7, Ljava/lang/StringBuilder;
invoke-direct {v7}, Ljava/lang/StringBuilder;-><init>()V
invoke-virtual {v7, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v3, ","
invoke-virtual {v7, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
aget-object v3, v2, v6
invoke-virtual {v7, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v7}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v3
add-int/lit8 v6, v6, 0x1
goto :goto_2a
.line 50428
:cond_45
new-instance v2, Ljava/lang/StringBuilder;
invoke-direct {v2}, Ljava/lang/StringBuilder;-><init>()V
invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v3, ") VALUES(?"
invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v2}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v2
const/4 v3, 0x1
:goto_57
if-ge v3, v1, :cond_6d
.line 50430
new-instance v6, Ljava/lang/StringBuilder;
invoke-direct {v6}, Ljava/lang/StringBuilder;-><init>()V
invoke-virtual {v6, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v2, ",?"
invoke-virtual {v6, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v6}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v2
add-int/lit8 v3, v3, 0x1
goto :goto_57
.line 50432
:cond_6d
new-instance v1, Ljava/lang/StringBuilder;
invoke-direct {v1}, Ljava/lang/StringBuilder;-><init>()V
invoke-virtual {v1, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v2, ")"
invoke-virtual {v1, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v1}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v1
.line 1712
invoke-virtual {p1, v1}, Landroid/database/sqlite/SQLiteDatabase;->compileStatement(Ljava/lang/String;)Landroid/database/sqlite/SQLiteStatement;
move-result-object p1
.line 1714
invoke-interface {p0}, Landroid/database/Cursor;->moveToFirst()Z
move-result v1
if-nez v1, :cond_8c
.line 1716
invoke-interface {p0}, Landroid/database/Cursor;->close()V
return-void
:cond_8c
const/4 v1, 0x0
:cond_8d
const/4 v2, 0x0
:goto_8e
if-ge v2, v0, :cond_a4
.line 1725
:try_start_90
invoke-interface {p0, v2}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;
move-result-object v3
if-nez v3, :cond_9c
add-int/lit8 v3, v2, 0x1
.line 1727
invoke-virtual {p1, v3}, Landroid/database/sqlite/SQLiteStatement;->bindNull(I)V
goto :goto_a1
:cond_9c
add-int/lit8 v6, v2, 0x1
.line 1729
invoke-virtual {p1, v6, v3}, Landroid/database/sqlite/SQLiteStatement;->bindString(ILjava/lang/String;)V
:goto_a1
add-int/lit8 v2, v2, 0x1
goto :goto_8e
.line 1731
:cond_a4
invoke-virtual {p1}, Landroid/database/sqlite/SQLiteStatement;->executeInsert()J
.line 1732
invoke-virtual {p1}, Landroid/database/sqlite/SQLiteStatement;->clearBindings()V
:try_end_aa
.catch Landroid/database/SQLException; {:try_start_90 .. :try_end_aa} :catch_ab
goto :goto_d1
:catch_ab
move-exception v2
if-nez v1, :cond_d1
.line 1742
invoke-static {v2}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object v1
const-string v3, "DbHelperDisk"
.line 50434
invoke-static {v3, v1, v5}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
.line 1744
invoke-virtual {v2}, Landroid/database/SQLException;->getMessage()Ljava/lang/String;
move-result-object v1
.line 50436
invoke-static {}, Lcom/imo/android/imoim/util/b/a$a;->a()Lcom/imo/android/imoim/util/b/a;
move-result-object v3
.line 1745
invoke-static {v1}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object v1
const-string v6, "old_move:"
invoke-virtual {v6, v1}, Ljava/lang/String;->concat(Ljava/lang/String;)Ljava/lang/String;
move-result-object v1
invoke-static {v2}, Landroid/util/Log;->getStackTraceString(Ljava/lang/Throwable;)Ljava/lang/String;
move-result-object v2
invoke-virtual {v3, p2, v1, v2}, Lcom/imo/android/imoim/util/b/a;->a(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V
const/4 v1, 0x1
.line 1749
:cond_d1
:goto_d1
invoke-interface {p0}, Landroid/database/Cursor;->moveToNext()Z
move-result v2
if-nez v2, :cond_8d
.line 1751
invoke-interface {p0}, Landroid/database/Cursor;->close()V
return-void
.end method
.method public static a(Landroid/database/sqlite/SQLiteDatabase;)V
.registers 2
const-string v0, "CREATE TABLE IF NOT EXISTS friends (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,gid TEXT,_alias_sl TEXT NOT NULL,display TEXT NOT NULL,name TEXT NOT NULL,icon TEXT,starred INTEGER,is_muted INTEGER,times_contacted INTEGER DEFAULT 0,type TEXT,last_active_times LONG NOT NULL DEFAULT 0,score INTEGER DEFAULT 0,UNIQUE (buid));"
.line 2291
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS friend_settings (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,call_muted INTEGER DEFAULT 0,chat_color INTEGER DEFAULT 0,display TEXT,story_muted INTEGER DEFAULT 0,chat_color2 TEXT,chat_background TEXT,UNIQUE (buid));"
.line 2308
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS phone_numbers (_id INTEGER PRIMARY KEY AUTOINCREMENT,uid TEXT NOT NULL,phone TEXT NOT NULL,name TEXT,type TEXT,UNIQUE (uid, phone) ON CONFLICT REPLACE);"
.line 2321
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS chats_new (_id INTEGER PRIMARY KEY AUTOINCREMENT,chat_type TEXT NOT NULL,row_type INTEGER DEFAULT 0 NOT NULL,buid TEXT NOT NULL,name TEXT NOT NULL,icon TEXT, last_message TEXT,has_unread_at_message INTEGER DEFAULT 0,timestamp INTEGER NOT NULL,active_timestamp INTEGER DEFAULT 0 NOT NULL,sticky_top_timestamp INTEGER DEFAULT 0 NOT NULL,relation_chat_source_type TEXT,is_folded INTEGER DEFAULT 0 NOT NULL);"
.line 2334
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS messages (_id INTEGER PRIMARY KEY AUTOINCREMENT,view_type INTEGER NOT NULL,buid TEXT NOT NULL,alias TEXT,icon TEXT,author TEXT,author_alias TEXT,author_icon TEXT,imdata TEXT,last_message TEXT,timestamp INTEGER,message_index INTEGER,message_type INTEGER NOT NULL,message_state INTEGER NOT NULL,message_read INTEGER NOT NULL,num_tries INTEGER DEFAULT 0,message_played INTEGER DEFAULT 0,seq_number LONG DEFAULT 0 NOT NULL,pre_ts LONG DEFAULT 0,msg_check_status INTEGER DEFAULT 0,click_num_tries INTEGER DEFAULT 0 NOT NULL,sender_timestamp_nano LONG DEFAULT 0 NOT NULL,msg_id TEXT,UNIQUE (buid, timestamp));"
.line 2368
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS video_messages (_id INTEGER PRIMARY KEY AUTOINCREMENT,view_type INTEGER NOT NULL,buid TEXT NOT NULL,alias TEXT,icon TEXT,author TEXT,author_alias TEXT,author_icon TEXT,imdata TEXT,last_message TEXT,timestamp INTEGER,message_index INTEGER,message_type INTEGER NOT NULL,message_state INTEGER NOT NULL,message_read INTEGER NOT NULL,UNIQUE (timestamp));"
.line 2393
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS phonebook_entries (_id INTEGER PRIMARY KEY AUTOINCREMENT,phone TEXT NOT NULL,normalized_phone TEXT NOT NULL,name TEXT, card INTEGER);"
.line 2411
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS tracked_invites (_id INTEGER PRIMARY KEY AUTOINCREMENT,phone TEXT NOT NULL,time INTEGER NOT NULL,success INTEGER NOT NULL, UNIQUE (phone));"
.line 2421
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS imo_phonebook (_id INTEGER PRIMARY KEY AUTOINCREMENT,phone TEXT NOT NULL, normalized TEXT NOT NULL, name TEXT,uid TEXT, incoming_calls INTEGER, outgoing_calls INTEGER, time_incoming INTEGER, time_outgoing INTEGER, num_days_calls INTEGER, incoming_sms INTEGER, outgoing_sms INTEGER, num_days_sms INTEGER, times_contacted INTEGER, starred INTEGER, score INTEGER, new_score INTEGER, last_contacted INTEGER, card INTEGER);"
.line 2457
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS calls_only (_id INTEGER PRIMARY KEY AUTOINCREMENT,chat_type TEXT NOT NULL,call_type TEXT NOT NULL,buid TEXT NOT NULL,name TEXT NOT NULL,imdata TEXT,icon TEXT, last_message TEXT,timestamp INTEGER NOT NULL,duration INTEGER,state TEXT,UNIQUE (buid, call_type, timestamp));"
.line 3352
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS cached_uploads (_id INTEGER PRIMARY KEY AUTOINCREMENT, md5_hash TEXT NOT NULL, server_id TEXT NOT NULL, upload_timestamp INTEGER);"
.line 3473
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS stories (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,message_read INTEGER NOT NULL,view_type INTEGER NOT NULL,timestamp INTEGER NOT NULL,message_liked INTEGER DEFAULT 0 NOT NULL,is_public INTEGER DEFAULT 0 NOT NULL,imdata TEXT,original_id TEXT,num_tries INTEGER DEFAULT 0,group_num INTEGER DEFAULT 0,story_push_notify INTEGER DEFAULT 0,story_intimacy_score REAL DEFAULT 0,object_id TEXT,story_album_list TEXT, UNIQUE (buid, object_id));"
.line 3485
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS album (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,imdata TEXT,album TEXT,original_id TEXT,timestamp INTEGER NOT NULL,object_id TEXT,albums_numbers INTEGER DEFAULT 0 NOT NULL, UNIQUE (buid, album, object_id));"
.line 3516
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS blist (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,blistid TEXT NOT NULL, UNIQUE (blistid, buid));"
.line 3543
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS call_timestamps (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,time INTEGER NOT NULL,UNIQUE (buid) ON CONFLICT REPLACE);"
.line 4431
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS nearby_log (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,name TEXT NOT NULL,filename TEXT NOT NULL,path TEXT NOT NULL,thumb TEXT,filesize INTEGER NOT NULL,payloadid INTEGER NOT NULL,type INTEGER NOT NULL,done INTEGER NOT NULL,time INTEGER NOT NULL);"
.line 4440
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS pixel_backup (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,view_type TEXT NOT NULL,timestamp INTEGER NOT NULL,message_state INTEGER DEFAULT 0 NOT NULL,object_id TEXT, UNIQUE (buid, object_id));"
.line 4531
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 107
invoke-static {p0}, Lcom/imo/android/imoim/util/au;->i(Landroid/database/sqlite/SQLiteDatabase;)V
const-string v0, "CREATE TABLE IF NOT EXISTS file_transfer (_id INTEGER PRIMARY KEY AUTOINCREMENT,taskid TEXT NOT NULL,buids TEXT NOT NULL,timestamp INTEGER NOT NULL,filepath TEXT NOT NULL,filename TEXT NOT NULL,filesize INTEGER NOT NULL,sha1sum TEXT,ext TEXT,url TEXT,progress INTEGER DEFAULT 0 NOT NULL,status INTEGER DEFAULT 0 NOT NULL,errorcode INTEGER DEFAULT 0 NOT NULL,type INTEGER NOT NULL,ext_data TEXT,down_type INTEGER DEFAULT 0 NOT NULL,upload_type INTEGER DEFAULT 0 NOT NULL,task_priority INTEGER DEFAULT 0 NOT NULL, UNIQUE (taskid));"
.line 4552
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS channel (_id INTEGER PRIMARY KEY AUTOINCREMENT,channel_id TEXT NOT NULL,channel_type TEXT,icon TEXT,display TEXT NOT NULL,is_muted INTEGER DEFAULT 0 NOT NULL,unsubscribe_enabled INTEGER DEFAULT 1 NOT NULL,share_enabled INTEGER DEFAULT 1 NOT NULL,certification_id TEXT,is_folded INTEGER DEFAULT 0 NOT NULL, UNIQUE (channel_id));"
.line 4575
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 110
invoke-static {p0}, Lcom/imo/android/imoim/util/au;->b(Landroid/database/sqlite/SQLiteDatabase;)V
const-string v0, "CREATE TABLE IF NOT EXISTS my_files (_id INTEGER PRIMARY KEY AUTOINCREMENT,unique_id TEXT NOT NULL,file_id TEXT,im_row_id INTEGER DEFAULT 0,uid TEXT NOT NULL,buid TEXT NOT NULL,message_ts INTERGER NOT NULL,state INTERGER NOT NULL,score INTEGER NOT NULL,imdata TEXT NOT NULL,is_sent INTEGER NOT NULL,is_local INTEGER NOT NULL,alias TEXT,task_id TEXT,url TEXT, UNIQUE (unique_id));"
.line 4667
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS account_type (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,account_type INTEGER, UNIQUE (buid));"
.line 4687
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS big_group (_id INTEGER PRIMARY KEY AUTOINCREMENT,bgid TEXT NOT NULL,name TEXT NOT NULL,is_muted INTEGER DEFAULT 0,icon TEXT,last_msg_seq INTEGER NOT NULL DEFAULT 0,last_read_msg_seq INTEGER NOT NULL DEFAULT 0,num_unread INTEGER NOT NULL DEFAULT 0,closed_announcement_id INTEGER NOT NULL DEFAULT -1,role TEXT,mills_to_promoted LONG NOT NULL DEFAULT 0,short_id TEXT,anon_id TEXT,mills_to_join LONG NOT NULL DEFAULT 0,super_short_id TEXT,group_type TEXT DEFAULT \"normal\",ex_info TEXT,moved_to_community_member INTEGER DEFAULT 0,is_folded INTEGER DEFAULT 0, UNIQUE (bgid));"
.line 4695
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS big_group_message (_id INTEGER PRIMARY KEY AUTOINCREMENT,bgid TEXT NOT NULL,anon_id TEXT NOT NULL,msg_seq INTEGER NOT NULL,at_me INTEGER DEFAULT 0,bubble_id TEXT,user_icon TEXT,user_nickname TEXT,imdata TEXT,last_message TEXT,message_state INTEGER NOT NULL,message_type INTEGER NOT NULL,imdata_type TEXT,timestamp INTEGER,user_role TEXT,active_time INTEGER,msg_id TEXT,UNIQUE (bgid, timestamp, msg_seq));"
.line 4719
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS new_friends (_id INTEGER PRIMARY KEY AUTOINCREMENT,uid TEXT NOT NULL,buid TEXT NOT NULL,timestamp INTEGER,type TEXT NOT NULL,status TEXT,tiny_profile TEXT,source TEXT,last_message TEXT,notification_read INTEGER,has_reply INTEGER,UNIQUE (buid));"
.line 5275
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 116
invoke-static {p0}, Lcom/imo/android/imoim/util/au;->c(Landroid/database/sqlite/SQLiteDatabase;)V
const-string v0, "CREATE TABLE IF NOT EXISTS forum (_id INTEGER PRIMARY KEY AUTOINCREMENT,forum_id TEXT NOT NULL,icon TEXT NOT NULL,name TEXT NOT NULL,num_unread INTEGER NOT NULL DEFAULT 0,last_timestamp INTEGER NOT NULL DEFAULT 0,last_read_timestamp INTEGER NOT NULL DEFAULT 0,UNIQUE (forum_id));"
.line 6263
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS deeplink_push (seq_id TEXT NOT NULL,msg_type TEXT,content_id TEXT,timestamp INTEGER,clicked INTEGER NOT NULL DEFAULT 0,UNIQUE (seq_id, msg_type, content_id) ON CONFLICT REPLACE);"
.line 6751
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS relationship (_id INTEGER PRIMARY KEY AUTOINCREMENT,rel_id TEXT NOT NULL,tiny_profile TEXT,source_type TEXT,source TEXT,request_status TEXT,request TEXT,timestamp INTEGER NOT NULL DEFAULT 0,has_reply INTEGER NOT NULL DEFAULT 0,UNIQUE (rel_id));"
.line 7249
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS relationship_message (_id INTEGER PRIMARY KEY AUTOINCREMENT,rel_id TEXT NOT NULL,author TEXT,last_message Text,imdata_type TEXT,imdata TEXT,timestamp INTEGER NOT NULL DEFAULT 0,msg_seq INTEGER NOT NULL,is_silent INTEGER NOT NULL,message_type INTEGER NOT NULL,message_state INTEGER NOT NULL,message_read INTEGER NOT NULL,UNIQUE (rel_id,msg_seq,timestamp));"
.line 8230
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS bubble_info (_id INTEGER PRIMARY KEY AUTOINCREMENT,bubble_id TEXT NOT NULL,bgid TEXT NOT NULL,preview_image TEXT NOT NULL,receive_image TEXT NOT NULL,send_image TEXT NOT NULL,label_image TEXT NOT NULL,text_color TEXT NOT NULL,description TEXT NOT NULL,background_color TEXT NOT NULL,tip TEXT NOT NULL,type INTEGER NOT NULL,top_floor_text_color TEXT,top_floor_mask_transparency TEXT,bubble_type TEXT,UNIQUE (bubble_id,type));"
.line 9209
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS bg_preference (_id INTEGER PRIMARY KEY AUTOINCREMENT,bgid TEXT NOT NULL,audio_message_only INTEGER NOT NULL,disable_group_card_message INTEGER NOT NULL,disable_audio_message INTEGER NOT NULL,UNIQUE (bgid));"
.line 10188
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS user_stay_stat (_id INTEGER PRIMARY KEY AUTOINCREMENT,stats_scene TEXT NOT NULL,date_time_stamp LONG NOT NULL DEFAULT 0,stay_data INTEGER NOT NULL);"
.line 10200
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS story_send_draft (_id INTEGER PRIMARY KEY AUTOINCREMENT,draft_id TEXT NOT NULL,buid TEXT NOT NULL,state INTEGER NOT NULL,timestamp INTEGER,path TEXT,overlay_path TEXT,imdata TEXT,url TEXT,view_type TEXT NOT NULL,level TEXT NOT NULL,source TEXT,send_story INTEGER,group_gid TEXT,is_front INTEGER,message_read INTEGER,is_for_feed INTEGER, UNIQUE (draft_id));"
.line 11166
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS call_out_history(_id INTEGER PRIMARY KEY AUTOINCREMENT,timestamp INTEGER NOT NULL,name TEXT NOT NULL,uid TEXT,contact_id TEXT,phone TEXT NOT NULL,normalized TEXT NOT NULL,stat TEXT,time TEXT)"
.line 11765
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS nearby_post_info(_id INTEGER PRIMARY KEY AUTOINCREMENT,post TEXT NOT NULL,num_likes LONG,num_comments LONG,num_views LONG,top_comments TEXT,is_like INTEGER DEFAULT 0 NOT NULL,is_sender INTEGER DEFAULT 0 NOT NULL,review_status TEXT,distance REAL,post_id TEXT)"
.line 11779
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS nearby_topic(_id INTEGER PRIMARY KEY AUTOINCREMENT,icon TEXT,name TEXT)"
.line 11795
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS nearby_post_not_interested(_id INTEGER PRIMARY KEY AUTOINCREMENT,post_id TEXT,time Long)"
.line 11803
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS call_intercept_record(_id INTEGER PRIMARY KEY AUTOINCREMENT,chat_type TEXT,alias TEXT,buid TEXT,icon TEXT,timestamp TEXT)"
.line 11811
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS stories_inter (_id INTEGER PRIMARY KEY AUTOINCREMENT,object_id TEXT NOT NULL,timestamp INTEGER NOT NULL,num_interact INTEGER DEFAULT 0, UNIQUE (object_id));"
.line 12506
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS channel_salat (_id INTEGER PRIMARY KEY AUTOINCREMENT,seq_id TEXT NOT NULL,channel_id TEXT NOT NULL,channel_type TEXT,icon TEXT,post_type TEXT NOT NULL,state INTEGER DEFAULT 0,record_date TEXT NOT NULL,record_count INTEGER DEFAULT 0,record_city TEXT NOT NULL, UNIQUE (channel_id, seq_id, record_date));"
.line 12611
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 132
invoke-static {p0}, Lcom/imo/android/imoim/util/au;->d(Landroid/database/sqlite/SQLiteDatabase;)V
.line 133
invoke-static {p0}, Lcom/imo/android/imoim/util/au;->f(Landroid/database/sqlite/SQLiteDatabase;)V
const-string v0, "CREATE TABLE IF NOT EXISTS channel_profile_page (_id INTEGER PRIMARY KEY AUTOINCREMENT,channel_id TEXT NOT NULL,json_result TEXT NOT NULL, UNIQUE (channel_id));"
.line 13149
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS stickers_pack (_id INTEGER PRIMARY KEY AUTOINCREMENT,pack_id TEXT NOT NULL,name TEXT,product_id TEXT,purchased INTEGER DEFAULT 0,author TEXT,num_stickers INTEGER,price INTEGER DEFAULT 0,description TEXT,in_use INTEGER DEFAULT 0,download_time INTEGER DEFAULT 0,scene INTEGER DEFAULT 0 NOT NULL,pack_type TEXT,title_img TEXT,UNIQUE (pack_id));"
.line 13626
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS sticker (_id INTEGER PRIMARY KEY AUTOINCREMENT,sticker_id TEXT NOT NULL,imdata TEXT,pack_id TEXT,timestamp INTEGER DEFAULT 0,count INTEGER DEFAULT 0,pack_type TEXT,UNIQUE (sticker_id));"
.line 13645
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS favorite_expression (_id INTEGER PRIMARY KEY AUTOINCREMENT,favorite_id TEXT NOT NULL,type TEXT NOT NULL,object TEXT NOT NULL,favorite_time INTEGER NOT NULL,UNIQUE (favorite_id, type));"
.line 13657
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 138
invoke-static {p0}, Lcom/imo/android/imoim/util/au;->f(Landroid/database/sqlite/SQLiteDatabase;)V
.line 139
invoke-static {p0}, Lcom/imo/android/imoim/util/au;->e(Landroid/database/sqlite/SQLiteDatabase;)V
const-string v0, "CREATE TABLE IF NOT EXISTS community_notice (_id INTEGER PRIMARY KEY AUTOINCREMENT,type TEXT NOT NULL,community_id TEXT NOT NULL,name TEXT,timestamp INTEGER,unread INTEGER,notice_seq INTEGER,community_activity_response TEXT,UNIQUE (community_id, type));"
.line 13863
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 141
invoke-static {p0}, Lcom/imo/android/imoim/util/au;->h(Landroid/database/sqlite/SQLiteDatabase;)V
const-string v0, "CREATE TABLE IF NOT EXISTS channel_post_detail (_id INTEGER PRIMARY KEY AUTOINCREMENT,post_id TEXT NOT NULL,channel_id TEXT NOT NULL,favorite_num INTERGER NOT NULL,view_num INTERGER NOT NULL,has_favorite INTERGER DEFAULT 0,update_time INTERGER NOT NULL,source_channel_id TEXT,source_post_id TEXT, UNIQUE (channel_id, post_id));"
.line 13907
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 143
invoke-static {p0}, Lcom/imo/android/imoim/util/au;->g(Landroid/database/sqlite/SQLiteDatabase;)V
const-string v0, "CREATE TABLE IF NOT EXISTS friend_ringback (buid TEXT NOT NULL,tone_id TEXT NOT NULL,data TEXT,uptime INTEGER,UNIQUE (buid) ON CONFLICT REPLACE);"
.line 13921
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS channel_cert_info (_id INTEGER PRIMARY KEY AUTOINCREMENT,certification_id TEXT NOT NULL,json_result TEXT NOT NULL, UNIQUE (certification_id));"
.line 14157
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
return-void
.end method
.method private static a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
.registers 5
.line 1648
:try_start_0
new-instance v0, Ljava/lang/StringBuilder;
const-string v1, "ALTER TABLE "
invoke-direct {v0, v1}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
invoke-virtual {v0, p1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string p1, " ADD COLUMN "
invoke-virtual {v0, p1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v0, p2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object p1
invoke-virtual {p0, p1}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_19
.catchall {:try_start_0 .. :try_end_19} :catchall_1a
return-void
:catchall_1a
move-exception p0
.line 1650
invoke-static {p0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object p0
const/4 p1, 0x1
const-string p2, "DbHelperDisk"
.line 50419
invoke-static {p2, p0, p1}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
return-void
.end method
.method public static declared-synchronized b()V
.registers 2
const-class v0, Lcom/imo/android/imoim/util/au;
monitor-enter v0
const/4 v1, 0x0
.line 70
:try_start_4
sput-object v1, Lcom/imo/android/imoim/util/au;->a:Lcom/imo/android/imoim/util/au;
:try_end_6
.catchall {:try_start_4 .. :try_end_6} :catchall_8
.line 71
monitor-exit v0
return-void
:catchall_8
move-exception v1
monitor-exit v0
throw v1
.end method
.method private static b(Landroid/database/sqlite/SQLiteDatabase;)V
.registers 3
.line 590
new-instance v0, Ljava/lang/StringBuilder;
const-string v1, "CREATE TABLE IF NOT EXISTS post (_id INTEGER PRIMARY KEY AUTOINCREMENT,post_id TEXT NOT NULL,channel_id TEXT NOT NULL,channel_type TEXT,icon TEXT,display TEXT NOT NULL,post_type TEXT NOT NULL,timestamp INTERGER NOT NULL,timestamp_nano INTERGER NOT NULL,state INTEGER DEFAULT 0,post_info TEXT,fake INTEGER DEFAULT 0,message_type INTEGER DEFAULT 0,new_state INTEGER DEFAULT "
invoke-direct {v0, v1}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
sget-object v1, Lcom/imo/android/imoim/publicchannel/post/ac$d;->UNKNOWN:Lcom/imo/android/imoim/publicchannel/post/ac$d;
.line 604
invoke-virtual {v1}, Lcom/imo/android/imoim/publicchannel/post/ac$d;->to()I
move-result v1
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
const-string v1, ",certification_id TEXT, UNIQUE (channel_id, post_id, timestamp));"
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v0
.line 590
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
return-void
.end method
.method private static c()V
.registers 3
.line 1675
invoke-static {}, Lcom/imo/android/imoim/IMO;->a()Lcom/imo/android/imoim/IMO;
move-result-object v0
const/4 v1, 0x0
const-string v2, "last_unread_ts"
.line 1676
invoke-virtual {v0, v2, v1}, Lcom/imo/android/imoim/IMO;->getSharedPreferences(Ljava/lang/String;I)Landroid/content/SharedPreferences;
move-result-object v0
.line 1677
invoke-interface {v0}, Landroid/content/SharedPreferences;->edit()Landroid/content/SharedPreferences$Editor;
move-result-object v0
invoke-interface {v0}, Landroid/content/SharedPreferences$Editor;->clear()Landroid/content/SharedPreferences$Editor;
move-result-object v0
invoke-interface {v0}, Landroid/content/SharedPreferences$Editor;->apply()V
.line 1679
invoke-static {}, Lcom/imo/android/imoim/IMO;->a()Lcom/imo/android/imoim/IMO;
move-result-object v0
const-string v2, "last_recv_ts"
invoke-virtual {v0, v2, v1}, Lcom/imo/android/imoim/IMO;->getSharedPreferences(Ljava/lang/String;I)Landroid/content/SharedPreferences;
move-result-object v0
.line 1681
invoke-interface {v0}, Landroid/content/SharedPreferences;->edit()Landroid/content/SharedPreferences$Editor;
move-result-object v0
invoke-interface {v0}, Landroid/content/SharedPreferences$Editor;->clear()Landroid/content/SharedPreferences$Editor;
move-result-object v0
invoke-interface {v0}, Landroid/content/SharedPreferences$Editor;->apply()V
return-void
.end method
.method private static c(Landroid/database/sqlite/SQLiteDatabase;)V
.registers 3
.line 741
new-instance v0, Ljava/lang/StringBuilder;
const-string v1, "CREATE TABLE IF NOT EXISTS hd_video (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,is_hd_video_capable INTEGER NOT NULL,is_hd_video INTEGER NOT NULL,timestamp INTEGER,"
invoke-direct {v0, v1}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
const-string v1, "buid"
filled-new-array {v1}, [Ljava/lang/String;
move-result-object v1
.line 747
invoke-static {v1}, Lcom/imo/android/imoim/util/au;->a([Ljava/lang/String;)Ljava/lang/String;
move-result-object v1
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v1, ");"
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v0
.line 741
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
return-void
.end method
.method private static d(Landroid/database/sqlite/SQLiteDatabase;)V
.registers 3
.line 822
new-instance v0, Ljava/lang/StringBuilder;
const-string v1, "CREATE TABLE IF NOT EXISTS hd_video2 (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,is_hd_video_capable INTEGER NOT NULL,is_hd_video INTEGER NOT NULL,timestamp INTEGER,"
invoke-direct {v0, v1}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
const-string v1, "buid"
filled-new-array {v1}, [Ljava/lang/String;
move-result-object v1
.line 828
invoke-static {v1}, Lcom/imo/android/imoim/util/au;->a([Ljava/lang/String;)Ljava/lang/String;
move-result-object v1
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v1, ");"
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v0
.line 822
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
return-void
.end method
.method private static e(Landroid/database/sqlite/SQLiteDatabase;)V
.registers 3
.line 832
new-instance v0, Ljava/lang/StringBuilder;
const-string v1, "CREATE TABLE IF NOT EXISTS community (_id INTEGER PRIMARY KEY AUTOINCREMENT,community_id TEXT NOT NULL,name TEXT NOT NULL,icon TEXT NOT NULL,new_message_type INTEGER DEFAULT 0 NOT NULL,badge INTEGER DEFAULT 0 NOT NULL,"
invoke-direct {v0, v1}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
const-string v1, "community_id"
filled-new-array {v1}, [Ljava/lang/String;
move-result-object v1
.line 839
invoke-static {v1}, Lcom/imo/android/imoim/util/au;->a([Ljava/lang/String;)Ljava/lang/String;
move-result-object v1
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v1, ");"
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v0
.line 832
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
return-void
.end method
.method private static f(Landroid/database/sqlite/SQLiteDatabase;)V
.registers 3
.line 844
new-instance v0, Ljava/lang/StringBuilder;
const-string v1, "CREATE TABLE IF NOT EXISTS community_recently (_id INTEGER PRIMARY KEY AUTOINCREMENT,recently_id TEXT NOT NULL,community_id TEXT NOT NULL,name TEXT,subtitle TEXT,type INTEGER,icon TEXT,open INTEGER DEFAULT 0 NOT NULL,timestamp INTEGER,unread INTEGER,atme INTEGER DEFAULT 0 NOT NULL,owner_uid TEXT,RECENTLY_EXPAND TEXT,"
invoke-direct {v0, v1}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
const-string v1, "recently_id"
filled-new-array {v1}, [Ljava/lang/String;
move-result-object v1
.line 858
invoke-static {v1}, Lcom/imo/android/imoim/util/au;->a([Ljava/lang/String;)Ljava/lang/String;
move-result-object v1
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v1, ");"
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v0
.line 844
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
return-void
.end method
.method private static g(Landroid/database/sqlite/SQLiteDatabase;)V
.registers 3
.line 876
new-instance v0, Ljava/lang/StringBuilder;
const-string v1, "CREATE TABLE IF NOT EXISTS imo_live (_id INTEGER PRIMARY KEY AUTOINCREMENT,type INTEGER DEFAULT 0 NOT NULL,roomId LONG NOT NULL,lastUpdateTime LONG NOT NULL,"
invoke-direct {v0, v1}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
const-string v1, "_id"
filled-new-array {v1}, [Ljava/lang/String;
move-result-object v1
.line 881
invoke-static {v1}, Lcom/imo/android/imoim/util/au;->a([Ljava/lang/String;)Ljava/lang/String;
move-result-object v1
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v1, ");"
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v0
.line 876
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
return-void
.end method
.method private static h(Landroid/database/sqlite/SQLiteDatabase;)V
.registers 3
.line 885
new-instance v0, Ljava/lang/StringBuilder;
const-string v1, "CREATE TABLE IF NOT EXISTS channel_post_cache (_id INTEGER PRIMARY KEY AUTOINCREMENT,post_id TEXT NOT NULL,channel_id TEXT NOT NULL,channel_type TEXT,icon TEXT,display TEXT NOT NULL,post_type TEXT NOT NULL,timestamp INTERGER NOT NULL,timestamp_nano INTERGER NOT NULL,state INTEGER DEFAULT 0,post_info TEXT,fake INTEGER DEFAULT 0,message_type INTEGER DEFAULT 0,post_insert_timestamp INTEGER DEFAULT 0,new_state INTEGER DEFAULT "
invoke-direct {v0, v1}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
sget-object v1, Lcom/imo/android/imoim/publicchannel/post/ac$d;->UNKNOWN:Lcom/imo/android/imoim/publicchannel/post/ac$d;
.line 900
invoke-virtual {v1}, Lcom/imo/android/imoim/publicchannel/post/ac$d;->to()I
move-result v1
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
const-string v1, ",certification_id TEXT, UNIQUE (channel_id, post_id, timestamp));"
invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v0
.line 885
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
return-void
.end method
.method private static i(Landroid/database/sqlite/SQLiteDatabase;)V
.registers 5
const-string v0, "uid"
const-string v1, "phone_numbers"
const-string v2, "buid"
:try_start_6
const-string v3, "messages"
.line 1656
invoke-static {v3, v2}, Lcom/imo/android/imoim/util/au;->a(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
move-result-object v3
invoke-virtual {p0, v3}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v3, "video_messages"
.line 1657
invoke-static {v3, v2}, Lcom/imo/android/imoim/util/au;->a(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
move-result-object v2
invoke-virtual {p0, v2}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v2, "phone"
.line 1659
invoke-static {v1, v2}, Lcom/imo/android/imoim/util/au;->a(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
move-result-object v2
invoke-virtual {p0, v2}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 1661
invoke-static {v1, v0}, Lcom/imo/android/imoim/util/au;->a(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
move-result-object v1
invoke-virtual {p0, v1}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v1, "imo_phonebook"
.line 1663
invoke-static {v1, v0}, Lcom/imo/android/imoim/util/au;->a(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
move-result-object v0
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_31
.catch Landroid/database/sqlite/SQLiteException; {:try_start_6 .. :try_end_31} :catch_32
return-void
:catch_32
move-exception p0
.line 1665
invoke-static {p0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object p0
const-string v0, "exception in setIndexes "
invoke-virtual {v0, p0}, Ljava/lang/String;->concat(Ljava/lang/String;)Ljava/lang/String;
move-result-object p0
const/4 v0, 0x0
const-string v1, "DbHelperDisk"
invoke-static {v1, p0, v0}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
return-void
.end method
.method private static j(Landroid/database/sqlite/SQLiteDatabase;)V
.registers 3
const-string v0, "DbHelperDisk"
const-string v1, "dropAllTables"
.line 50437
invoke-static {v0, v1}, Lcom/imo/android/imoim/util/bt;->d(Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS friends"
.line 1772
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS phone_numbers"
.line 1773
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS chats_new"
.line 1774
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS messages"
.line 1775
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS video_messages"
.line 1776
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS phonebook_entries"
.line 1777
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS sms_invites"
.line 1778
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS imo_phonebook"
.line 1779
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS calls_only"
.line 1780
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS cached_uploads"
.line 1781
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS channel"
.line 1782
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS post"
.line 1783
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS my_files"
.line 1784
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS account_type"
.line 1785
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS call_out_history"
.line 1786
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS channel_salat"
.line 1787
invoke-virtual {p0, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
return-void
.end method
.method private static k(Landroid/database/sqlite/SQLiteDatabase;)V
.registers 9
const-string v0, "DbHelperDisk"
const/4 v1, 0x1
.line 1820
:try_start_3
new-instance v2, Ljava/lang/StringBuilder;
const-string v3, "SELECT COUNT(*), buid FROM messages WHERE message_type="
invoke-direct {v2, v3}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
sget-object v3, Lcom/imo/android/imoim/data/l$b;->SENT:Lcom/imo/android/imoim/data/l$b;
.line 1822
invoke-virtual {v3}, Lcom/imo/android/imoim/data/l$b;->toInt()I
move-result v3
invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
const-string v3, " GROUP BY buid"
invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v2}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v2
const/4 v3, 0x0
.line 1823
invoke-virtual {p0, v2, v3}, Landroid/database/sqlite/SQLiteDatabase;->rawQuery(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;
move-result-object v2
.line 1824
:goto_21
invoke-interface {v2}, Landroid/database/Cursor;->moveToNext()Z
move-result v3
if-eqz v3, :cond_62
const/4 v3, 0x0
.line 1825
invoke-interface {v2, v3}, Landroid/database/Cursor;->getInt(I)I
move-result v4
.line 1826
invoke-interface {v2, v1}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;
move-result-object v5
.line 1827
new-instance v6, Ljava/lang/StringBuilder;
const-string v7, "UPDATE friends SET times_contacted="
invoke-direct {v6, v7}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
invoke-virtual {v6, v4}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
const-string v7, " WHERE buid=?"
invoke-virtual {v6, v7}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v6}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v6
new-array v7, v1, [Ljava/lang/String;
aput-object v5, v7, v3
.line 1830
invoke-virtual {p0, v6, v7}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;[Ljava/lang/Object;)V
.line 1831
new-instance v3, Ljava/lang/StringBuilder;
invoke-direct {v3}, Ljava/lang/StringBuilder;-><init>()V
invoke-virtual {v3, v5}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v5, " "
invoke-virtual {v3, v5}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
invoke-virtual {v3}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v3
.line 50439
invoke-static {v0, v3}, Lcom/imo/android/imoim/util/bt;->d(Ljava/lang/String;Ljava/lang/String;)V
goto :goto_21
.line 1833
:cond_62
invoke-interface {v2}, Landroid/database/Cursor;->close()V
:try_end_65
.catchall {:try_start_3 .. :try_end_65} :catchall_66
return-void
:catchall_66
move-exception p0
.line 1835
invoke-static {p0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object p0
.line 50441
invoke-static {v0, p0, v1}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
return-void
.end method
.method private static l(Landroid/database/sqlite/SQLiteDatabase;)V
.registers 7
const-string v0, "video_row"
const-string v1, "incoming_media"
const-string v2, "outgoing_media"
.line 1877
filled-new-array {v0, v1, v2}, [Ljava/lang/String;
move-result-object v0
const/4 v1, 0x0
const/4 v2, 0x0
:goto_c
const/4 v3, 0x3
if-ge v2, v3, :cond_20
aget-object v3, v0, v2
const/4 v4, 0x1
new-array v4, v4, [Ljava/lang/String;
aput-object v3, v4, v1
const-string v3, "chats_new"
const-string v5, "chat_type=?"
.line 1879
invoke-virtual {p0, v3, v5, v4}, Landroid/database/sqlite/SQLiteDatabase;->delete(Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)I
add-int/lit8 v2, v2, 0x1
goto :goto_c
:cond_20
return-void
.end method
.method private static m(Landroid/database/sqlite/SQLiteDatabase;)V
.registers 4
.line 1908
:try_start_0
new-instance v0, Landroid/content/ContentValues;
invoke-direct {v0}, Landroid/content/ContentValues;-><init>()V
const-string v1, "story_muted"
const/4 v2, 0x0
.line 1909
invoke-static {v2}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;
move-result-object v2
invoke-virtual {v0, v1, v2}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V
const-string v1, "friend_settings"
const/4 v2, 0x0
.line 1910
invoke-virtual {p0, v1, v0, v2, v2}, Landroid/database/sqlite/SQLiteDatabase;->update(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;)I
:try_end_15
.catch Ljava/lang/Exception; {:try_start_0 .. :try_end_15} :catch_16
return-void
:catch_16
move-exception p0
.line 1912
invoke-static {p0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object p0
const/4 v0, 0x1
const-string v1, "DbHelperDisk"
.line 50443
invoke-static {v1, p0, v0}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
return-void
.end method
# virtual methods
.method public final onCreate(Landroid/database/sqlite/SQLiteDatabase;)V
.registers 4
const-string v0, "DbHelperDisk"
const-string v1, "onCreate"
.line 2071
invoke-static {v0, v1}, Lcom/imo/android/imoim/util/bt;->d(Ljava/lang/String;Ljava/lang/String;)V
.line 86
invoke-static {p1}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;)V
return-void
.end method
.method public final onDowngrade(Landroid/database/sqlite/SQLiteDatabase;II)V
.registers 6
.line 945
new-instance v0, Ljava/lang/StringBuilder;
const-string v1, "onDowngrade from version "
invoke-direct {v0, v1}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
invoke-virtual {v0, p2}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
const-string p2, " to "
invoke-virtual {v0, p2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v0, p3}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object p2
const-string p3, "DbHelperDisk"
const/4 v0, 0x1
.line 15079
invoke-static {p3, p2, v0}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
.line 947
invoke-static {p1}, Lcom/imo/android/imoim/util/au;->j(Landroid/database/sqlite/SQLiteDatabase;)V
.line 948
invoke-virtual {p0, p1}, Lcom/imo/android/imoim/util/au;->onCreate(Landroid/database/sqlite/SQLiteDatabase;)V
.line 951
sget-object p1, Lcom/imo/android/imoim/util/df$ad;->HASH:Lcom/imo/android/imoim/util/df$ad;
invoke-static {p1}, Lcom/imo/android/imoim/util/df;->d(Ljava/lang/Enum;)V
.line 952
sget-object p1, Lcom/imo/android/imoim/util/df$ad;->CHANNEL_HASH_V5:Lcom/imo/android/imoim/util/df$ad;
invoke-static {p1}, Lcom/imo/android/imoim/util/df;->d(Ljava/lang/Enum;)V
.line 953
sget-object p1, Lcom/imo/android/imoim/util/df$ad;->LAST_UNREAD_TS:Lcom/imo/android/imoim/util/df$ad;
invoke-static {p1}, Lcom/imo/android/imoim/util/df;->d(Ljava/lang/Enum;)V
.line 954
sget-object p1, Lcom/imo/android/imoim/util/df$ad;->LAST_CHANNEL_UNREAD_TS:Lcom/imo/android/imoim/util/df$ad;
invoke-static {p1}, Lcom/imo/android/imoim/util/df;->d(Ljava/lang/Enum;)V
.line 955
sget-object p1, Lcom/imo/android/imoim/util/df$ad;->BIG_GROUP_HASH:Lcom/imo/android/imoim/util/df$ad;
invoke-static {p1}, Lcom/imo/android/imoim/util/df;->d(Ljava/lang/Enum;)V
.line 956
sget-object p1, Lcom/imo/android/imoim/util/df$ad;->RELATIONSHIP_HASH:Lcom/imo/android/imoim/util/df$ad;
invoke-static {p1}, Lcom/imo/android/imoim/util/df;->d(Ljava/lang/Enum;)V
.line 957
sget-object p1, Lcom/imo/android/imoim/util/df$ad;->COMMUNITY_HASH:Lcom/imo/android/imoim/util/df$ad;
invoke-static {p1}, Lcom/imo/android/imoim/util/df;->d(Ljava/lang/Enum;)V
return-void
.end method
.method public final onUpgrade(Landroid/database/sqlite/SQLiteDatabase;II)V
.registers 20
move-object/from16 v1, p1
move/from16 v2, p2
.line 964
new-instance v0, Ljava/lang/StringBuilder;
const-string v3, "Upgrading database from version "
invoke-direct {v0, v3}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
invoke-virtual {v0, v2}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
const-string v3, " to "
invoke-virtual {v0, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
move/from16 v3, p3
invoke-virtual {v0, v3}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v0
const-string v3, "DbHelperDisk"
.line 16075
invoke-static {v3, v0}, Lcom/imo/android/imoim/util/bt;->e(Ljava/lang/String;Ljava/lang/String;)V
const/16 v0, 0x18
if-ge v2, v0, :cond_2c
.line 968
invoke-static/range {p1 .. p1}, Lcom/imo/android/imoim/util/au;->j(Landroid/database/sqlite/SQLiteDatabase;)V
.line 969
invoke-virtual/range {p0 .. p1}, Lcom/imo/android/imoim/util/au;->onCreate(Landroid/database/sqlite/SQLiteDatabase;)V
return-void
:cond_2c
const/16 v0, 0x1c
if-ge v2, v0, :cond_35
const-string v0, "CREATE TABLE IF NOT EXISTS video_messages (_id INTEGER PRIMARY KEY AUTOINCREMENT,view_type INTEGER NOT NULL,buid TEXT NOT NULL,alias TEXT,icon TEXT,author TEXT,author_alias TEXT,author_icon TEXT,imdata TEXT,last_message TEXT,timestamp INTEGER,message_index INTEGER,message_type INTEGER NOT NULL,message_state INTEGER NOT NULL,message_read INTEGER NOT NULL,UNIQUE (timestamp));"
.line 16393
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_35
const/16 v0, 0x1d
const-string v4, "CREATE TABLE IF NOT EXISTS chats_new (_id INTEGER PRIMARY KEY AUTOINCREMENT,chat_type TEXT NOT NULL,row_type INTEGER DEFAULT 0 NOT NULL,buid TEXT NOT NULL,name TEXT NOT NULL,icon TEXT, last_message TEXT,has_unread_at_message INTEGER DEFAULT 0,timestamp INTEGER NOT NULL,active_timestamp INTEGER DEFAULT 0 NOT NULL,sticky_top_timestamp INTEGER DEFAULT 0 NOT NULL,relation_chat_source_type TEXT,is_folded INTEGER DEFAULT 0 NOT NULL);"
const-string v5, "chats_new"
const/4 v6, 0x1
if-ge v2, v0, :cond_69
.line 17334
invoke-virtual {v1, v4}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const/4 v0, 0x0
const-string v7, "SELECT * FROM chats"
.line 16688
invoke-virtual {v1, v7, v0}, Landroid/database/sqlite/SQLiteDatabase;->rawQuery(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;
move-result-object v0
.line 16690
invoke-virtual/range {p1 .. p1}, Landroid/database/sqlite/SQLiteDatabase;->beginTransaction()V
.line 16692
:try_start_4b
invoke-static {v0, v1, v5}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/Cursor;Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;)V
:try_end_4e
.catch Ljava/lang/Exception; {:try_start_4b .. :try_end_4e} :catch_4f
goto :goto_5e
:catch_4f
move-exception v0
move-object v7, v0
.line 16696
invoke-static {v7}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object v0
const-string v7, "failed to copy table old chats exception: "
invoke-virtual {v7, v0}, Ljava/lang/String;->concat(Ljava/lang/String;)Ljava/lang/String;
move-result-object v0
.line 18079
invoke-static {v3, v0, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
.line 16698
:goto_5e
invoke-virtual/range {p1 .. p1}, Landroid/database/sqlite/SQLiteDatabase;->setTransactionSuccessful()V
.line 16699
invoke-virtual/range {p1 .. p1}, Landroid/database/sqlite/SQLiteDatabase;->endTransaction()V
const-string v0, "DROP TABLE IF EXISTS chats"
.line 16701
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_69
const/16 v0, 0x21
const-string v7, "CREATE TABLE IF NOT EXISTS messages (_id INTEGER PRIMARY KEY AUTOINCREMENT,view_type INTEGER NOT NULL,buid TEXT NOT NULL,alias TEXT,icon TEXT,author TEXT,author_alias TEXT,author_icon TEXT,imdata TEXT,last_message TEXT,timestamp INTEGER,message_index INTEGER,message_type INTEGER NOT NULL,message_state INTEGER NOT NULL,message_read INTEGER NOT NULL,num_tries INTEGER DEFAULT 0,message_played INTEGER DEFAULT 0,seq_number LONG DEFAULT 0 NOT NULL,pre_ts LONG DEFAULT 0,msg_check_status INTEGER DEFAULT 0,click_num_tries INTEGER DEFAULT 0 NOT NULL,sender_timestamp_nano LONG DEFAULT 0 NOT NULL,msg_id TEXT,UNIQUE (buid, timestamp));"
const-string v8, "DROP TABLE IF EXISTS messages"
if-ge v2, v0, :cond_7a
.line 979
invoke-static {}, Lcom/imo/android/imoim/util/au;->c()V
.line 980
invoke-virtual {v1, v8}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 18368
invoke-virtual {v1, v7}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_7a
const/16 v0, 0x25
if-ge v2, v0, :cond_87
.line 984
invoke-static {}, Lcom/imo/android/imoim/util/au;->c()V
.line 985
invoke-virtual {v1, v8}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 19368
invoke-virtual {v1, v7}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_87
const/16 v9, 0x26
if-ge v2, v9, :cond_9b
if-lt v2, v0, :cond_9b
:try_start_8d
const-string v0, "ALTER TABLE messages ADD COLUMN num_tries INTEGER DEFAULT 0"
.line 19792
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_92
.catchall {:try_start_8d .. :try_end_92} :catchall_93
goto :goto_9b
:catchall_93
move-exception v0
.line 19795
invoke-static {v0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object v0
.line 20079
invoke-static {v3, v0, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
:cond_9b
:goto_9b
const/16 v0, 0x27
const-string v9, "CREATE TABLE IF NOT EXISTS phonebook_entries (_id INTEGER PRIMARY KEY AUTOINCREMENT,phone TEXT NOT NULL,normalized_phone TEXT NOT NULL,name TEXT, card INTEGER);"
if-ge v2, v0, :cond_a4
.line 20411
invoke-virtual {v1, v9}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_a4
const/16 v0, 0x29
if-ge v2, v0, :cond_b1
.line 995
invoke-static {}, Lcom/imo/android/imoim/util/au;->c()V
.line 996
invoke-virtual {v1, v8}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 21368
invoke-virtual {v1, v7}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_b1
const/16 v0, 0x2a
const-string v10, "CREATE TABLE IF NOT EXISTS imo_phonebook (_id INTEGER PRIMARY KEY AUTOINCREMENT,phone TEXT NOT NULL, normalized TEXT NOT NULL, name TEXT,uid TEXT, incoming_calls INTEGER, outgoing_calls INTEGER, time_incoming INTEGER, time_outgoing INTEGER, num_days_calls INTEGER, incoming_sms INTEGER, outgoing_sms INTEGER, num_days_sms INTEGER, times_contacted INTEGER, starred INTEGER, score INTEGER, new_score INTEGER, last_contacted INTEGER, card INTEGER);"
const-string v11, "DROP TABLE IF EXISTS phonebook_entries"
if-ge v2, v0, :cond_c2
.line 21457
invoke-virtual {v1, v10}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 1003
invoke-virtual {v1, v11}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 22411
invoke-virtual {v1, v9}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_c2
const/16 v0, 0x2b
if-ge v2, v0, :cond_d7
const-string v0, "DROP TABLE IF EXISTS imo_phonebook"
.line 1008
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 1009
invoke-virtual {v1, v11}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 23411
invoke-virtual {v1, v9}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 23457
invoke-virtual {v1, v10}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 1012
invoke-static/range {p1 .. p1}, Lcom/imo/android/imoim/util/au;->i(Landroid/database/sqlite/SQLiteDatabase;)V
:cond_d7
const/16 v0, 0x2c
if-ge v2, v0, :cond_e1
.line 1015
invoke-virtual {v1, v11}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 24411
invoke-virtual {v1, v9}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_e1
const/16 v0, 0x2d
if-ge v2, v0, :cond_ea
const-string v0, "ALTER TABLE phone_numbers ADD COLUMN name TEXT"
.line 1019
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_ea
const/16 v0, 0x2e
if-ge v2, v0, :cond_f7
.line 1023
invoke-static {}, Lcom/imo/android/imoim/util/au;->c()V
.line 1024
invoke-virtual {v1, v8}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 25368
invoke-virtual {v1, v7}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_f7
const/16 v0, 0x2f
if-ge v2, v0, :cond_117
const-string v0, "CREATE TEMP TABLE IF NOT EXISTS chats_new AS SELECT * FROM MAIN.chats_new"
.line 25841
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS MAIN.chats_new"
.line 25843
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 26334
invoke-virtual {v1, v4}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "UPDATE TEMP.chats_new SET buid = replace(buid, \'3ed1a#\', \'\') WHERE buid LIKE \'3ed1a#%\'"
.line 25845
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "INSERT INTO MAIN.chats_new SELECT * FROM TEMP.chats_new"
.line 25849
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS TEMP.chats_new"
.line 25851
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_117
const/16 v0, 0x30
const/4 v4, 0x0
if-ge v2, v0, :cond_131
.line 1031
invoke-static {}, Lcom/imo/android/imoim/IMO;->a()Lcom/imo/android/imoim/IMO;
move-result-object v0
const-string v7, "TrackInvitePrefs_v2"
invoke-virtual {v0, v7, v4}, Lcom/imo/android/imoim/IMO;->getSharedPreferences(Ljava/lang/String;I)Landroid/content/SharedPreferences;
move-result-object v0
.line 1033
invoke-interface {v0}, Landroid/content/SharedPreferences;->edit()Landroid/content/SharedPreferences$Editor;
move-result-object v0
invoke-interface {v0}, Landroid/content/SharedPreferences$Editor;->clear()Landroid/content/SharedPreferences$Editor;
move-result-object v0
invoke-interface {v0}, Landroid/content/SharedPreferences$Editor;->apply()V
:cond_131
const/16 v0, 0x31
if-ge v2, v0, :cond_195
.line 1037
invoke-static {}, Lcom/imo/android/imoim/IMO;->a()Lcom/imo/android/imoim/IMO;
move-result-object v0
invoke-static {v0}, Lcom/imo/android/imoim/util/ei;->g(Landroid/content/Context;)Ljava/io/File;
move-result-object v0
.line 1038
invoke-virtual {v0}, Ljava/io/File;->exists()Z
move-result v7
if-nez v7, :cond_146
.line 1039
invoke-virtual {v0}, Ljava/io/File;->mkdirs()Z
.line 1041
:cond_146
invoke-static {}, Lcom/imo/android/imoim/IMO;->a()Lcom/imo/android/imoim/IMO;
move-result-object v0
invoke-virtual {v0}, Lcom/imo/android/imoim/IMO;->getFilesDir()Ljava/io/File;
move-result-object v0
invoke-virtual {v0}, Ljava/io/File;->listFiles()[Ljava/io/File;
move-result-object v0
if-eqz v0, :cond_195
.line 1043
array-length v7, v0
const/4 v8, 0x0
:goto_156
if-ge v8, v7, :cond_195
aget-object v12, v0, v8
.line 1044
invoke-virtual {v12}, Ljava/io/File;->getName()Ljava/lang/String;
move-result-object v13
const-string v14, "[a-zA-Z0-9_]*\\.[0-9]{1,2}"
invoke-virtual {v13, v14}, Ljava/lang/String;->matches(Ljava/lang/String;)Z
move-result v13
if-eqz v13, :cond_192
.line 1045
new-instance v13, Ljava/io/File;
new-instance v14, Ljava/lang/StringBuilder;
invoke-direct {v14}, Ljava/lang/StringBuilder;-><init>()V
.line 1046
invoke-static {}, Lcom/imo/android/imoim/IMO;->a()Lcom/imo/android/imoim/IMO;
move-result-object v15
.line 1045
invoke-static {v15}, Lcom/imo/android/imoim/util/ei;->g(Landroid/content/Context;)Ljava/io/File;
move-result-object v15
.line 1046
invoke-virtual {v15}, Ljava/io/File;->getAbsolutePath()Ljava/lang/String;
move-result-object v15
invoke-virtual {v14, v15}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v15, "/"
invoke-virtual {v14, v15}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
.line 1047
invoke-virtual {v12}, Ljava/io/File;->getName()Ljava/lang/String;
move-result-object v15
invoke-virtual {v14, v15}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v14}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v14
invoke-direct {v13, v14}, Ljava/io/File;-><init>(Ljava/lang/String;)V
.line 1045
invoke-virtual {v12, v13}, Ljava/io/File;->renameTo(Ljava/io/File;)Z
:cond_192
add-int/lit8 v8, v8, 0x1
goto :goto_156
:cond_195
const/16 v0, 0x36
if-ge v2, v0, :cond_19e
const-string v0, "CREATE TABLE IF NOT EXISTS calls_only (_id INTEGER PRIMARY KEY AUTOINCREMENT,chat_type TEXT NOT NULL,call_type TEXT NOT NULL,buid TEXT NOT NULL,name TEXT NOT NULL,imdata TEXT,icon TEXT, last_message TEXT,timestamp INTEGER NOT NULL,duration INTEGER,state TEXT,UNIQUE (buid, call_type, timestamp));"
.line 26352
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_19e
const/16 v0, 0x39
if-ge v2, v0, :cond_1aa
const-string v0, "DROP TABLE IF EXISTS imo_phonebook"
.line 1058
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 26457
invoke-virtual {v1, v10}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_1aa
const/16 v0, 0x3a
if-ge v2, v0, :cond_1b1
.line 1062
invoke-static/range {p1 .. p1}, Lcom/imo/android/imoim/util/au;->l(Landroid/database/sqlite/SQLiteDatabase;)V
:cond_1b1
const/16 v0, 0x3d
if-ge v2, v0, :cond_1c4
const-string v0, "DROP TABLE IF EXISTS friends"
.line 1065
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS friends (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,gid TEXT,_alias_sl TEXT NOT NULL,display TEXT NOT NULL,name TEXT NOT NULL,icon TEXT,starred INTEGER,is_muted INTEGER,times_contacted INTEGER DEFAULT 0,type TEXT,last_active_times LONG NOT NULL DEFAULT 0,score INTEGER DEFAULT 0,UNIQUE (buid));"
.line 27291
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 1067
sget-object v0, Lcom/imo/android/imoim/util/df$ad;->HASH:Lcom/imo/android/imoim/util/df$ad;
invoke-static {v0}, Lcom/imo/android/imoim/util/df;->d(Ljava/lang/Enum;)V
:cond_1c4
const/16 v0, 0x3f
if-ge v2, v0, :cond_1cd
const-string v0, "CREATE TABLE IF NOT EXISTS cached_uploads (_id INTEGER PRIMARY KEY AUTOINCREMENT, md5_hash TEXT NOT NULL, server_id TEXT NOT NULL, upload_timestamp INTEGER);"
.line 27473
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_1cd
const/16 v0, 0x40
if-ge v2, v0, :cond_1ee
:try_start_1d1
const-string v0, "CREATE TABLE IF NOT EXISTS chats_new2 (_id INTEGER PRIMARY KEY AUTOINCREMENT,chat_type TEXT NOT NULL,buid TEXT NOT NULL,name TEXT NOT NULL,icon TEXT, last_message TEXT,timestamp INTEGER NOT NULL);"
.line 27856
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "INSERT INTO chats_new2 SELECT * FROM chats_new"
.line 27865
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS chats_new"
.line 27867
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "ALTER TABLE chats_new2 RENAME TO chats_new"
.line 27868
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_1e5
.catchall {:try_start_1d1 .. :try_end_1e5} :catchall_1e6
goto :goto_1ee
:catchall_1e6
move-exception v0
.line 27871
invoke-static {v0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object v0
.line 28079
invoke-static {v3, v0, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
:cond_1ee
:goto_1ee
const/16 v0, 0x41
if-ge v2, v0, :cond_1f5
.line 1077
invoke-static/range {p1 .. p1}, Lcom/imo/android/imoim/util/au;->l(Landroid/database/sqlite/SQLiteDatabase;)V
:cond_1f5
const/16 v0, 0x43
if-ge v2, v0, :cond_1fe
const-string v0, "UPDATE messages SET message_read=1 WHERE view_type=7 OR view_type=8"
.line 28894
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_1fe
const/16 v0, 0x44
if-ge v2, v0, :cond_208
.line 1083
invoke-virtual {v1, v11}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 29411
invoke-virtual {v1, v9}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_208
const/16 v0, 0x45
if-ge v2, v0, :cond_217
const/16 v0, 0x2e
if-lt v2, v0, :cond_217
:try_start_210
const-string v0, "ALTER TABLE messages ADD COLUMN message_played INTEGER DEFAULT 0"
.line 29801
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_215
.catchall {:try_start_210 .. :try_end_215} :catchall_216
goto :goto_217
:catchall_216
nop
:cond_217
:goto_217
const/16 v0, 0x46
const-string v7, "messages"
if-ge v2, v0, :cond_245
.line 29886
new-instance v0, Ljava/lang/StringBuilder;
invoke-direct {v0}, Ljava/lang/StringBuilder;-><init>()V
const-string v8, "view_type=?"
invoke-virtual {v0, v8}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v8, "OR view_type=?"
invoke-virtual {v0, v8}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v0
const/4 v8, 0x2
new-array v8, v8, [Ljava/lang/String;
const/16 v10, 0x8
.line 29888
invoke-static {v10}, Ljava/lang/Integer;->toString(I)Ljava/lang/String;
move-result-object v10
aput-object v10, v8, v4
const/4 v10, 0x7
.line 29889
invoke-static {v10}, Ljava/lang/Integer;->toString(I)Ljava/lang/String;
move-result-object v10
aput-object v10, v8, v6
.line 29890
invoke-virtual {v1, v7, v0, v8}, Landroid/database/sqlite/SQLiteDatabase;->delete(Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)I
:cond_245
const/16 v0, 0x47
if-ge v2, v0, :cond_251
:try_start_249
const-string v0, "ALTER TABLE friends ADD COLUMN times_contacted INTEGER DEFAULT 0"
.line 30810
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_24e
.catchall {:try_start_249 .. :try_end_24e} :catchall_24e
.line 1094
:catchall_24e
invoke-static/range {p1 .. p1}, Lcom/imo/android/imoim/util/au;->k(Landroid/database/sqlite/SQLiteDatabase;)V
:cond_251
const/16 v0, 0x48
if-ge v2, v0, :cond_26a
.line 1097
invoke-static {}, Lcom/imo/android/imoim/IMO;->a()Lcom/imo/android/imoim/IMO;
move-result-object v0
const-string v8, "gcm_ips"
.line 1098
invoke-virtual {v0, v8, v4}, Lcom/imo/android/imoim/IMO;->getSharedPreferences(Ljava/lang/String;I)Landroid/content/SharedPreferences;
move-result-object v0
.line 1099
invoke-interface {v0}, Landroid/content/SharedPreferences;->edit()Landroid/content/SharedPreferences$Editor;
move-result-object v0
invoke-interface {v0}, Landroid/content/SharedPreferences$Editor;->clear()Landroid/content/SharedPreferences$Editor;
move-result-object v0
invoke-interface {v0}, Landroid/content/SharedPreferences$Editor;->apply()V
:cond_26a
const/16 v0, 0x4a
if-ge v2, v0, :cond_273
const-string v0, "CREATE TABLE IF NOT EXISTS stories (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,message_read INTEGER NOT NULL,view_type INTEGER NOT NULL,timestamp INTEGER NOT NULL,message_liked INTEGER DEFAULT 0 NOT NULL,is_public INTEGER DEFAULT 0 NOT NULL,imdata TEXT,original_id TEXT,num_tries INTEGER DEFAULT 0,group_num INTEGER DEFAULT 0,story_push_notify INTEGER DEFAULT 0,story_intimacy_score REAL DEFAULT 0,object_id TEXT,story_album_list TEXT, UNIQUE (buid, object_id));"
.line 31485
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_273
const/16 v0, 0x4c
if-ge v2, v0, :cond_27a
.line 1109
invoke-static {}, Lcom/imo/android/imoim/util/v;->b()V
:cond_27a
const/16 v0, 0x4d
if-ge v2, v0, :cond_291
:try_start_27e
const-string v0, "ALTER TABLE stories ADD COLUMN view_type INTEGER DEFAULT 0 NOT NULL"
.line 1113
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "ALTER TABLE stories ADD COLUMN timestamp INTEGER DEFAULT 0 NOT NULL"
.line 1116
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_288
.catchall {:try_start_27e .. :try_end_288} :catchall_289
goto :goto_291
:catchall_289
move-exception v0
.line 1120
invoke-static {v0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object v0
.line 32079
invoke-static {v3, v0, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
:cond_291
:goto_291
const/16 v0, 0x4e
if-ge v2, v0, :cond_2a3
:try_start_295
const-string v0, "ALTER TABLE stories ADD COLUMN message_liked INTEGER DEFAULT 0 NOT NULL"
.line 1125
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_29a
.catchall {:try_start_295 .. :try_end_29a} :catchall_29b
goto :goto_2a3
:catchall_29b
move-exception v0
.line 1129
invoke-static {v0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object v0
.line 33079
invoke-static {v3, v0, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
:cond_2a3
:goto_2a3
const/16 v0, 0x4f
if-ge v2, v0, :cond_2ac
const-string v0, "CREATE TABLE IF NOT EXISTS blist (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,blistid TEXT NOT NULL, UNIQUE (blistid, buid));"
.line 33543
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_2ac
const/16 v0, 0x50
if-ge v2, v0, :cond_2c3
:try_start_2b0
const-string v0, "ALTER TABLE phone_numbers ADD COLUMN type TEXT"
.line 1137
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "ALTER TABLE friends ADD COLUMN type TEXT"
.line 1139
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_2ba
.catchall {:try_start_2b0 .. :try_end_2ba} :catchall_2bb
goto :goto_2c3
:catchall_2bb
move-exception v0
.line 1142
invoke-static {v0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object v0
.line 34079
invoke-static {v3, v0, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
:cond_2c3
:goto_2c3
const/16 v0, 0x51
if-ge v2, v0, :cond_2ca
.line 1146
invoke-static {}, Lcom/imo/android/imoim/util/v;->c()V
:cond_2ca
const/16 v0, 0x52
if-ge v2, v0, :cond_2dc
:try_start_2ce
const-string v0, "ALTER TABLE stories ADD COLUMN imdata TEXT"
.line 1150
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_2d3
.catchall {:try_start_2ce .. :try_end_2d3} :catchall_2d4
goto :goto_2dc
:catchall_2d4
move-exception v0
.line 1153
invoke-static {v0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object v0
.line 35079
invoke-static {v3, v0, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
:cond_2dc
:goto_2dc
const/16 v0, 0x53
if-ge v2, v0, :cond_2e5
const-string v0, "CREATE TABLE IF NOT EXISTS tracked_invites (_id INTEGER PRIMARY KEY AUTOINCREMENT,phone TEXT NOT NULL,time INTEGER NOT NULL,success INTEGER NOT NULL, UNIQUE (phone));"
.line 35421
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_2e5
const/16 v0, 0x54
if-ge v2, v0, :cond_2ee
const-string v0, "CREATE TABLE IF NOT EXISTS call_timestamps (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,time INTEGER NOT NULL,UNIQUE (buid) ON CONFLICT REPLACE);"
.line 35431
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_2ee
const/16 v0, 0x56
if-ge v2, v0, :cond_2fc
const-string v0, "DROP TABLE IF EXISTS nearby_log"
.line 1163
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS nearby_log (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,name TEXT NOT NULL,filename TEXT NOT NULL,path TEXT NOT NULL,thumb TEXT,filesize INTEGER NOT NULL,payloadid INTEGER NOT NULL,type INTEGER NOT NULL,done INTEGER NOT NULL,time INTEGER NOT NULL);"
.line 35440
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_2fc
const/16 v0, 0x57
if-ge v2, v0, :cond_30e
:try_start_300
const-string v0, "ALTER TABLE stories ADD COLUMN is_public INTEGER DEFAULT 0 NOT NULL"
.line 1168
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_305
.catch Ljava/lang/Exception; {:try_start_300 .. :try_end_305} :catch_306
goto :goto_30e
:catch_306
move-exception v0
.line 1172
invoke-static {v0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object v0
.line 36079
invoke-static {v3, v0, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
:cond_30e
:goto_30e
const/16 v0, 0x58
if-ge v2, v0, :cond_317
const-string v0, "CREATE TABLE IF NOT EXISTS pixel_backup (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,view_type TEXT NOT NULL,timestamp INTEGER NOT NULL,message_state INTEGER DEFAULT 0 NOT NULL,object_id TEXT, UNIQUE (buid, object_id));"
.line 36531
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_317
const/16 v0, 0x59
if-ge v2, v0, :cond_329
:try_start_31b
const-string v0, "ALTER TABLE stories ADD COLUMN num_tries INTEGER DEFAULT 0"
.line 1180
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_320
.catch Ljava/lang/Exception; {:try_start_31b .. :try_end_320} :catch_321
goto :goto_329
:catch_321
move-exception v0
.line 1183
invoke-static {v0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object v0
.line 37079
invoke-static {v3, v0, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
:cond_329
:goto_329
const/16 v0, 0x5a
if-ge v2, v0, :cond_33b
:try_start_32d
const-string v0, "ALTER TABLE stories ADD COLUMN group_num INTEGER DEFAULT 0"
.line 1188
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_332
.catch Ljava/lang/Exception; {:try_start_32d .. :try_end_332} :catch_333
goto :goto_33b
:catch_333
move-exception v0
.line 1191
invoke-static {v0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object v0
.line 38079
invoke-static {v3, v0, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
:cond_33b
:goto_33b
const/16 v0, 0x5b
if-ge v2, v0, :cond_344
const-string v0, "CREATE TABLE IF NOT EXISTS friend_settings (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,call_muted INTEGER DEFAULT 0,chat_color INTEGER DEFAULT 0,display TEXT,story_muted INTEGER DEFAULT 0,chat_color2 TEXT,chat_background TEXT,UNIQUE (buid));"
.line 38308
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_344
const/16 v0, 0x5c
if-ge v2, v0, :cond_356
:try_start_348
const-string v0, "ALTER TABLE calls_only ADD COLUMN imdata TEXT"
.line 1199
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_34d
.catchall {:try_start_348 .. :try_end_34d} :catchall_34e
goto :goto_356
:catchall_34e
move-exception v0
.line 1202
invoke-static {v0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object v0
.line 39079
invoke-static {v3, v0, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
:cond_356
:goto_356
const/16 v0, 0x5d
const-string v8, "stories"
if-ge v2, v0, :cond_361
const-string v0, "original_id TEXT"
.line 1207
invoke-static {v1, v8, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_361
const/16 v0, 0x5e
const-string v10, "friend_settings"
if-ge v2, v0, :cond_36c
const-string v0, "chat_color INTEGER DEFAULT 0"
.line 1212
invoke-static {v1, v10, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_36c
const/16 v0, 0x5f
if-ge v2, v0, :cond_37a
const-string v0, "story_muted INTEGER DEFAULT 0"
.line 1217
invoke-static {v1, v10, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "display TEXT"
.line 1219
invoke-static {v1, v10, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_37a
const/16 v0, 0x60
if-ge v2, v0, :cond_385
.line 1223
invoke-static {}, Lcom/imo/android/imoim/IMO;->a()Lcom/imo/android/imoim/IMO;
move-result-object v0
invoke-static {v0}, Lcom/imo/android/imoim/syncadapter/d;->b(Landroid/content/Context;)V
:cond_385
const/16 v0, 0x61
if-ge v2, v0, :cond_38c
.line 1226
invoke-static/range {p1 .. p1}, Lcom/imo/android/imoim/util/au;->m(Landroid/database/sqlite/SQLiteDatabase;)V
:cond_38c
const/16 v0, 0x62
if-ge v2, v0, :cond_395
const-string v0, "CREATE TABLE IF NOT EXISTS album (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,imdata TEXT,album TEXT,original_id TEXT,timestamp INTEGER NOT NULL,object_id TEXT,albums_numbers INTEGER DEFAULT 0 NOT NULL, UNIQUE (buid, album, object_id));"
.line 39516
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_395
const/16 v0, 0x63
if-ge v2, v0, :cond_3ac
.line 1234
invoke-virtual {v1, v11}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 40411
invoke-virtual {v1, v9}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS phone_numbers"
.line 1237
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS phone_numbers (_id INTEGER PRIMARY KEY AUTOINCREMENT,uid TEXT NOT NULL,phone TEXT NOT NULL,name TEXT,type TEXT,UNIQUE (uid, phone) ON CONFLICT REPLACE);"
.line 41321
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 1240
invoke-static {}, Lcom/imo/android/imoim/util/f;->c()V
:cond_3ac
const/16 v0, 0x64
if-ge v2, v0, :cond_3b5
const-string v0, "chat_color2 TEXT"
.line 1244
invoke-static {v1, v10, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_3b5
const/16 v0, 0x65
if-ge v2, v0, :cond_3bc
.line 1249
invoke-static/range {p1 .. p1}, Lcom/imo/android/imoim/util/au;->m(Landroid/database/sqlite/SQLiteDatabase;)V
:cond_3bc
const/16 v0, 0x66
if-ge v2, v0, :cond_3c5
const-string v0, "CREATE TABLE IF NOT EXISTS file_transfer (_id INTEGER PRIMARY KEY AUTOINCREMENT,taskid TEXT NOT NULL,buids TEXT NOT NULL,timestamp INTEGER NOT NULL,filepath TEXT NOT NULL,filename TEXT NOT NULL,filesize INTEGER NOT NULL,sha1sum TEXT,ext TEXT,url TEXT,progress INTEGER DEFAULT 0 NOT NULL,status INTEGER DEFAULT 0 NOT NULL,errorcode INTEGER DEFAULT 0 NOT NULL,type INTEGER NOT NULL,ext_data TEXT,down_type INTEGER DEFAULT 0 NOT NULL,upload_type INTEGER DEFAULT 0 NOT NULL,task_priority INTEGER DEFAULT 0 NOT NULL, UNIQUE (taskid));"
.line 41552
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_3c5
const/16 v0, 0x67
const-string v9, "file_transfer"
if-ge v2, v0, :cond_3d0
const-string v0, "ext_data TEXT"
.line 1257
invoke-static {v1, v9, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_3d0
const/16 v0, 0x6d
if-ge v2, v0, :cond_3ef
const-string v0, "DROP TABLE IF EXISTS post"
.line 1261
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS channel (_id INTEGER PRIMARY KEY AUTOINCREMENT,channel_id TEXT NOT NULL,channel_type TEXT,icon TEXT,display TEXT NOT NULL,is_muted INTEGER DEFAULT 0 NOT NULL,unsubscribe_enabled INTEGER DEFAULT 1 NOT NULL,share_enabled INTEGER DEFAULT 1 NOT NULL,certification_id TEXT,is_folded INTEGER DEFAULT 0 NOT NULL, UNIQUE (channel_id));"
.line 41575
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 1263
invoke-static/range {p1 .. p1}, Lcom/imo/android/imoim/util/au;->b(Landroid/database/sqlite/SQLiteDatabase;)V
:try_start_3e1
const-string v0, "ALTER TABLE chats_new ADD COLUMN row_type INTEGER DEFAULT 0 NOT NULL"
.line 1265
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_3e6
.catchall {:try_start_3e1 .. :try_end_3e6} :catchall_3e7
goto :goto_3ef
:catchall_3e7
move-exception v0
.line 1268
invoke-static {v0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object v0
.line 42079
invoke-static {v3, v0, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
:cond_3ef
:goto_3ef
const/16 v0, 0x6e
if-ge v2, v0, :cond_401
:try_start_3f3
const-string v0, "ALTER TABLE post ADD COLUMN message_type INTEGER DEFAULT 0 NOT NULL"
.line 1274
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_3f8
.catchall {:try_start_3f3 .. :try_end_3f8} :catchall_3f9
goto :goto_401
:catchall_3f9
move-exception v0
.line 1277
invoke-static {v0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;
move-result-object v0
.line 43079
invoke-static {v3, v0, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
:cond_401
:goto_401
const/16 v0, 0x6f
if-ge v2, v0, :cond_40a
const-string v0, "DROP TABLE IF EXISTS sms_invites"
.line 1282
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_40a
const/16 v0, 0x71
if-ge v2, v0, :cond_413
const-string v0, "CREATE TABLE IF NOT EXISTS my_files (_id INTEGER PRIMARY KEY AUTOINCREMENT,unique_id TEXT NOT NULL,file_id TEXT,im_row_id INTEGER DEFAULT 0,uid TEXT NOT NULL,buid TEXT NOT NULL,message_ts INTERGER NOT NULL,state INTERGER NOT NULL,score INTEGER NOT NULL,imdata TEXT NOT NULL,is_sent INTEGER NOT NULL,is_local INTEGER NOT NULL,alias TEXT,task_id TEXT,url TEXT, UNIQUE (unique_id));"
.line 43667
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_413
const/16 v0, 0x72
if-ge v2, v0, :cond_41c
const-string v0, "CREATE TABLE IF NOT EXISTS account_type (_id INTEGER PRIMARY KEY AUTOINCREMENT,buid TEXT NOT NULL,account_type INTEGER, UNIQUE (buid));"
.line 43687
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_41c
const/16 v0, 0x73
if-ge v2, v0, :cond_425
const-string v0, "down_type INTEGER DEFAULT 0 NOT NULL"
.line 1294
invoke-static {v1, v9, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_425
const/16 v0, 0x74
if-ge v2, v0, :cond_43d
const-string v0, "CREATE TABLE IF NOT EXISTS big_group (_id INTEGER PRIMARY KEY AUTOINCREMENT,bgid TEXT NOT NULL,name TEXT NOT NULL,is_muted INTEGER DEFAULT 0,icon TEXT,last_msg_seq INTEGER NOT NULL DEFAULT 0,last_read_msg_seq INTEGER NOT NULL DEFAULT 0,num_unread INTEGER NOT NULL DEFAULT 0,closed_announcement_id INTEGER NOT NULL DEFAULT -1,role TEXT,mills_to_promoted LONG NOT NULL DEFAULT 0,short_id TEXT,anon_id TEXT,mills_to_join LONG NOT NULL DEFAULT 0,super_short_id TEXT,group_type TEXT DEFAULT \"normal\",ex_info TEXT,moved_to_community_member INTEGER DEFAULT 0,is_folded INTEGER DEFAULT 0, UNIQUE (bgid));"
.line 43695
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS big_group_message (_id INTEGER PRIMARY KEY AUTOINCREMENT,bgid TEXT NOT NULL,anon_id TEXT NOT NULL,msg_seq INTEGER NOT NULL,at_me INTEGER DEFAULT 0,bubble_id TEXT,user_icon TEXT,user_nickname TEXT,imdata TEXT,last_message TEXT,message_state INTEGER NOT NULL,message_type INTEGER NOT NULL,imdata_type TEXT,timestamp INTEGER,user_role TEXT,active_time INTEGER,msg_id TEXT,UNIQUE (bgid, timestamp, msg_seq));"
.line 43719
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "upload_type INTEGER DEFAULT 0 NOT NULL"
.line 1305
invoke-static {v1, v9, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "task_priority INTEGER DEFAULT 0 NOT NULL"
.line 1306
invoke-static {v1, v9, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_43d
const/16 v0, 0x75
if-ge v2, v0, :cond_450
const-string v0, "UPDATE file_transfer SET down_type=0 where down_type is null"
.line 43917
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "UPDATE file_transfer SET upload_type=0 where upload_type is null"
.line 43918
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "UPDATE file_transfer SET task_priority=0 where task_priority is null"
.line 43919
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_450
const/16 v0, 0x76
const-string v9, "big_group"
if-ge v2, v0, :cond_45b
const-string v0, "closed_announcement_id INTEGER DEFAULT -1 NOT NULL"
.line 1328
invoke-static {v1, v9, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_45b
const/16 v0, 0x77
const-string v11, "big_group_message"
if-ge v2, v0, :cond_46b
const-string v0, "user_role TEXT"
.line 1332
invoke-static {v1, v11, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "active_time INTEGER"
.line 1333
invoke-static {v1, v11, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_46b
const/16 v0, 0x78
if-ge v2, v0, :cond_472
.line 1337
invoke-static {}, Lcom/imo/android/imoim/managers/notification/az;->d()V
:cond_472
const/16 v0, 0x79
if-ge v2, v0, :cond_479
.line 1345
invoke-static/range {p1 .. p1}, Lcom/imo/android/imoim/util/au;->c(Landroid/database/sqlite/SQLiteDatabase;)V
:cond_479
const/16 v0, 0x7a
if-ge v2, v0, :cond_482
const-string v0, "CREATE TABLE IF NOT EXISTS new_friends (_id INTEGER PRIMARY KEY AUTOINCREMENT,uid TEXT NOT NULL,buid TEXT NOT NULL,timestamp INTEGER,type TEXT NOT NULL,status TEXT,tiny_profile TEXT,source TEXT,last_message TEXT,notification_read INTEGER,has_reply INTEGER,UNIQUE (buid));"
.line 44275
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_482
const/16 v0, 0x7b
if-ge v2, v0, :cond_499
const-string v0, "active_timestamp INTEGER default 0 NOT NULL"
.line 1357
invoke-static {v1, v5, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:try_start_48b
const-string v0, "UPDATE chats_new SET active_timestamp=timestamp"
.line 1359
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_490
.catch Ljava/lang/Exception; {:try_start_48b .. :try_end_490} :catch_491
goto :goto_499
:catch_491
move-exception v0
.line 1362
invoke-virtual {v0}, Ljava/lang/Exception;->toString()Ljava/lang/String;
move-result-object v0
.line 45079
invoke-static {v3, v0, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
:cond_499
:goto_499
const/16 v0, 0x7c
if-ge v2, v0, :cond_4a0
.line 1367
invoke-static/range {p1 .. p1}, Lcom/imo/android/imoim/util/au;->c(Landroid/database/sqlite/SQLiteDatabase;)V
:cond_4a0
const/16 v0, 0x7d
if-ge v2, v0, :cond_4a9
const-string v0, "CREATE TABLE IF NOT EXISTS forum (_id INTEGER PRIMARY KEY AUTOINCREMENT,forum_id TEXT NOT NULL,icon TEXT NOT NULL,name TEXT NOT NULL,num_unread INTEGER NOT NULL DEFAULT 0,last_timestamp INTEGER NOT NULL DEFAULT 0,last_read_timestamp INTEGER NOT NULL DEFAULT 0,UNIQUE (forum_id));"
.line 45263
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_4a9
const/16 v0, 0x7e
if-ge v2, v0, :cond_4b2
const-string v0, "CREATE TABLE IF NOT EXISTS deeplink_push (seq_id TEXT NOT NULL,msg_type TEXT,content_id TEXT,timestamp INTEGER,clicked INTEGER NOT NULL DEFAULT 0,UNIQUE (seq_id, msg_type, content_id) ON CONFLICT REPLACE);"
.line 45751
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_4b2
const/16 v0, 0x7f
if-ge v2, v0, :cond_4c5
const-string v0, "CREATE TABLE IF NOT EXISTS relationship (_id INTEGER PRIMARY KEY AUTOINCREMENT,rel_id TEXT NOT NULL,tiny_profile TEXT,source_type TEXT,source TEXT,request_status TEXT,request TEXT,timestamp INTEGER NOT NULL DEFAULT 0,has_reply INTEGER NOT NULL DEFAULT 0,UNIQUE (rel_id));"
.line 46249
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS relationship_message (_id INTEGER PRIMARY KEY AUTOINCREMENT,rel_id TEXT NOT NULL,author TEXT,last_message Text,imdata_type TEXT,imdata TEXT,timestamp INTEGER NOT NULL DEFAULT 0,msg_seq INTEGER NOT NULL,is_silent INTEGER NOT NULL,message_type INTEGER NOT NULL,message_state INTEGER NOT NULL,message_read INTEGER NOT NULL,UNIQUE (rel_id,msg_seq,timestamp));"
.line 47230
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "DROP TABLE IF EXISTS new_friends"
.line 1380
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_4c5
const/16 v0, 0x80
if-ge v2, v0, :cond_521
:try_start_4c9
const-string v0, "relationship_message2"
.line 47926
new-instance v12, Ljava/lang/StringBuilder;
const-string v13, "CREATE TABLE IF NOT EXISTS "
invoke-direct {v12, v13}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
invoke-virtual {v12, v0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v13, " (_id INTEGER PRIMARY KEY AUTOINCREMENT,rel_id TEXT NOT NULL,author TEXT,last_message TEXT,imdata_type TEXT,imdata TEXT,timestamp INTEGER NOT NULL DEFAULT 0,msg_seq INTEGER NOT NULL,is_silent INTEGER NOT NULL,message_type INTEGER NOT NULL,message_state INTEGER NOT NULL,message_read INTEGER NOT NULL,UNIQUE (rel_id,msg_seq,timestamp));"
invoke-virtual {v12, v13}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v12}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v12
invoke-virtual {v1, v12}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_4e1
.catchall {:try_start_4c9 .. :try_end_4e1} :catchall_519
.line 47944
:try_start_4e1
new-instance v12, Ljava/lang/StringBuilder;
const-string v13, "INSERT INTO "
invoke-direct {v12, v13}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
invoke-virtual {v12, v0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v13, " SELECT * FROM relationship_message"
invoke-virtual {v12, v13}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v12}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v12
invoke-virtual {v1, v12}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_4f7
.catch Ljava/lang/Exception; {:try_start_4e1 .. :try_end_4f7} :catch_4f8
.catchall {:try_start_4e1 .. :try_end_4f7} :catchall_519
goto :goto_4fd
:catch_4f8
:try_start_4f8
const-string v12, "copy table failed from relationship message"
.line 48079
invoke-static {v3, v12, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
:goto_4fd
const-string v12, "DROP TABLE IF EXISTS relationship_message"
.line 47951
invoke-virtual {v1, v12}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
.line 47952
new-instance v12, Ljava/lang/StringBuilder;
const-string v13, "ALTER TABLE "
invoke-direct {v12, v13}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
invoke-virtual {v12, v0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
const-string v0, " RENAME TO relationship_message"
invoke-virtual {v12, v0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
invoke-virtual {v12}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v0
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:try_end_518
.catchall {:try_start_4f8 .. :try_end_518} :catchall_519
goto :goto_521
:catchall_519
move-exception v0
.line 47956
invoke-virtual {v0}, Ljava/lang/Throwable;->toString()Ljava/lang/String;
move-result-object v0
.line 49079
invoke-static {v3, v0, v6}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V
:cond_521
:goto_521
const/16 v0, 0x81
if-ge v2, v0, :cond_52f
const-string v0, "role TEXT"
.line 1390
invoke-static {v1, v9, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "mills_to_promoted LONG DEFAULT 0 NOT NULL"
.line 1391
invoke-static {v1, v9, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_52f
const/16 v0, 0x82
if-ge v2, v0, :cond_53d
const-string v0, "at_me INTEGER default 0"
.line 1395
invoke-static {v1, v11, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "has_unread_at_message INTEGER default 0"
.line 1396
invoke-static {v1, v5, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_53d
const/16 v0, 0x83
if-ge v2, v0, :cond_546
const-string v0, "short_id TEXT "
.line 1400
invoke-static {v1, v9, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_546
const/16 v0, 0x84
if-ge v2, v0, :cond_554
const-string v0, "bubble_id TEXT"
.line 1404
invoke-static {v1, v11, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS bubble_info (_id INTEGER PRIMARY KEY AUTOINCREMENT,bubble_id TEXT NOT NULL,bgid TEXT NOT NULL,preview_image TEXT NOT NULL,receive_image TEXT NOT NULL,send_image TEXT NOT NULL,label_image TEXT NOT NULL,text_color TEXT NOT NULL,description TEXT NOT NULL,background_color TEXT NOT NULL,tip TEXT NOT NULL,type INTEGER NOT NULL,top_floor_text_color TEXT,top_floor_mask_transparency TEXT,bubble_type TEXT,UNIQUE (bubble_id,type));"
.line 49209
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_554
const/16 v0, 0x85
if-ge v2, v0, :cond_55d
const-string v0, "msg_id TEXT"
.line 1409
invoke-static {v1, v11, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_55d
const/16 v0, 0x86
if-ge v2, v0, :cond_56b
const-string v0, "anon_id TEXT"
.line 1414
invoke-static {v1, v9, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "mills_to_join LONG DEFAULT 0 NOT NULL"
.line 1415
invoke-static {v1, v9, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_56b
const/16 v0, 0x87
if-ge v2, v0, :cond_574
const-string v0, "super_short_id TEXT "
.line 1419
invoke-static {v1, v9, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_574
const/16 v0, 0x88
if-ge v2, v0, :cond_584
const-string v0, "sticky_top_timestamp INTEGER default 0 NOT NULL"
.line 1423
invoke-static {v1, v5, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "friends"
const-string v3, "last_active_times LONG DEFAULT 0 NOT NULL "
.line 1424
invoke-static {v1, v0, v3}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_584
const/16 v0, 0x89
if-ge v2, v0, :cond_58f
const-string v0, "friends"
const-string v3, "score INTEGER DEFAULT 0"
.line 1428
invoke-static {v1, v0, v3}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_58f
const/16 v0, 0x8b
if-ge v2, v0, :cond_598
const-string v0, "CREATE TABLE IF NOT EXISTS bg_preference (_id INTEGER PRIMARY KEY AUTOINCREMENT,bgid TEXT NOT NULL,audio_message_only INTEGER NOT NULL,disable_group_card_message INTEGER NOT NULL,disable_audio_message INTEGER NOT NULL,UNIQUE (bgid));"
.line 50188
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_598
const/16 v0, 0x8c
if-ge v2, v0, :cond_5a1
const-string v0, "seq_number LONG DEFAULT 0 NOT NULL"
.line 1436
invoke-static {v1, v7, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_5a1
const/16 v0, 0x8d
if-ge v2, v0, :cond_5af
const-string v0, "DROP TABLE IF EXISTS deeplink_push"
.line 1440
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS deeplink_push (seq_id TEXT NOT NULL,msg_type TEXT,content_id TEXT,timestamp INTEGER,clicked INTEGER NOT NULL DEFAULT 0,UNIQUE (seq_id, msg_type, content_id) ON CONFLICT REPLACE);"
.line 50197
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_5af
const/16 v0, 0x8f
if-ge v2, v0, :cond_5b8
const-string v0, "CREATE TABLE IF NOT EXISTS user_stay_stat (_id INTEGER PRIMARY KEY AUTOINCREMENT,stats_scene TEXT NOT NULL,date_time_stamp LONG NOT NULL DEFAULT 0,stay_data INTEGER NOT NULL);"
.line 50209
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_5b8
const/16 v0, 0x90
if-ge v2, v0, :cond_5c1
const-string v0, "CREATE TABLE IF NOT EXISTS story_send_draft (_id INTEGER PRIMARY KEY AUTOINCREMENT,draft_id TEXT NOT NULL,buid TEXT NOT NULL,state INTEGER NOT NULL,timestamp INTEGER,path TEXT,overlay_path TEXT,imdata TEXT,url TEXT,view_type TEXT NOT NULL,level TEXT NOT NULL,source TEXT,send_story INTEGER,group_gid TEXT,is_front INTEGER,message_read INTEGER,is_for_feed INTEGER, UNIQUE (draft_id));"
.line 50216
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_5c1
const/16 v0, 0x91
if-ge v2, v0, :cond_5ca
const-string v0, "click_num_tries INTEGER DEFAULT 0 NOT NULL"
.line 1458
invoke-static {v1, v7, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_5ca
const/16 v0, 0x92
if-ge v2, v0, :cond_5d3
const-string v0, "sender_timestamp_nano LONG DEFAULT 0 NOT NULL"
.line 1462
invoke-static {v1, v7, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_5d3
const/16 v0, 0x93
if-ge v2, v0, :cond_5eb
const-string v0, "pre_ts LONG DEFAULT 0"
.line 1466
invoke-static {v1, v7, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "msg_check_status INTEGER DEFAULT 0"
.line 1467
invoke-static {v1, v7, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "msg_id TEXT"
.line 1468
invoke-static {v1, v7, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "UPDATE messages SET msg_check_status=1"
.line 50236
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_5eb
const/16 v0, 0x95
if-ge v2, v0, :cond_5f4
const-string v0, "CREATE TABLE IF NOT EXISTS call_out_history(_id INTEGER PRIMARY KEY AUTOINCREMENT,timestamp INTEGER NOT NULL,name TEXT NOT NULL,uid TEXT,contact_id TEXT,phone TEXT NOT NULL,normalized TEXT NOT NULL,stat TEXT,time TEXT)"
.line 50239
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_5f4
const/16 v0, 0x96
if-ge v2, v0, :cond_607
const-string v0, "CREATE TABLE IF NOT EXISTS nearby_post_info(_id INTEGER PRIMARY KEY AUTOINCREMENT,post TEXT NOT NULL,num_likes LONG,num_comments LONG,num_views LONG,top_comments TEXT,is_like INTEGER DEFAULT 0 NOT NULL,is_sender INTEGER DEFAULT 0 NOT NULL,review_status TEXT,distance REAL,post_id TEXT)"
.line 50251
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS nearby_topic(_id INTEGER PRIMARY KEY AUTOINCREMENT,icon TEXT,name TEXT)"
.line 50265
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS nearby_post_not_interested(_id INTEGER PRIMARY KEY AUTOINCREMENT,post_id TEXT,time Long)"
.line 50271
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_607
const/16 v0, 0x97
const-string v3, "post"
const-string v7, "channel"
if-ge v2, v0, :cond_61e
const-string v0, "CREATE TABLE IF NOT EXISTS call_intercept_record(_id INTEGER PRIMARY KEY AUTOINCREMENT,chat_type TEXT,alias TEXT,buid TEXT,icon TEXT,timestamp TEXT)"
.line 50277
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "channel_type TEXT"
.line 1493
invoke-static {v1, v7, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "channel_type TEXT"
.line 1494
invoke-static {v1, v3, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_61e
const/16 v0, 0x98
if-ge v2, v0, :cond_627
const-string v0, "CREATE TABLE IF NOT EXISTS stories_inter (_id INTEGER PRIMARY KEY AUTOINCREMENT,object_id TEXT NOT NULL,timestamp INTEGER NOT NULL,num_interact INTEGER DEFAULT 0, UNIQUE (object_id));"
.line 50286
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_627
const/16 v0, 0x99
if-ge v2, v0, :cond_64c
new-array v0, v6, [Ljava/lang/String;
.line 50295
sget-object v11, Lcom/imo/android/imoim/util/ae$b;->RELATIONSHIP:Lcom/imo/android/imoim/util/ae$b;
invoke-virtual {v11}, Lcom/imo/android/imoim/util/ae$b;->to()I
move-result v11
invoke-static {v11}, Ljava/lang/String;->valueOf(I)Ljava/lang/String;
move-result-object v11
aput-object v11, v0, v4
.line 50296
new-instance v11, Landroid/content/ContentValues;
invoke-direct {v11}, Landroid/content/ContentValues;-><init>()V
.line 50297
invoke-static {v4}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;
move-result-object v4
const-string v12, "sticky_top_timestamp"
invoke-virtual {v11, v12, v4}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V
const-string v4, "sticky_top_timestamp<0 AND row_type!=?"
.line 50298
invoke-virtual {v1, v5, v11, v4, v0}, Landroid/database/sqlite/SQLiteDatabase;->update(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;)I
:cond_64c
const/16 v0, 0x9a
if-ge v2, v0, :cond_655
const-string v0, "chat_background TEXT"
.line 1506
invoke-static {v1, v10, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_655
const/16 v0, 0x9b
if-ge v2, v0, :cond_65e
const-string v0, "CREATE TABLE IF NOT EXISTS channel_salat (_id INTEGER PRIMARY KEY AUTOINCREMENT,seq_id TEXT NOT NULL,channel_id TEXT NOT NULL,channel_type TEXT,icon TEXT,post_type TEXT NOT NULL,state INTEGER DEFAULT 0,record_date TEXT NOT NULL,record_count INTEGER DEFAULT 0,record_city TEXT NOT NULL, UNIQUE (channel_id, seq_id, record_date));"
.line 50300
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_65e
const/16 v0, 0x9c
if-ge v2, v0, :cond_66c
const-string v0, "DROP TABLE IF EXISTS stories_inter"
.line 1514
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS stories_inter (_id INTEGER PRIMARY KEY AUTOINCREMENT,object_id TEXT NOT NULL,timestamp INTEGER NOT NULL,num_interact INTEGER DEFAULT 0, UNIQUE (object_id));"
.line 50313
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_66c
const/16 v0, 0x9d
if-ge v2, v0, :cond_673
.line 1519
invoke-static/range {p1 .. p1}, Lcom/imo/android/imoim/util/au;->d(Landroid/database/sqlite/SQLiteDatabase;)V
:cond_673
const/16 v0, 0x9f
if-ge v2, v0, :cond_67a
.line 1523
invoke-static {}, Lcom/imo/android/imoim/managers/notification/az;->q()V
:cond_67a
const/16 v0, 0xa0
if-ge v2, v0, :cond_683
const-string v0, "CREATE TABLE IF NOT EXISTS channel_profile_page (_id INTEGER PRIMARY KEY AUTOINCREMENT,channel_id TEXT NOT NULL,json_result TEXT NOT NULL, UNIQUE (channel_id));"
.line 50321
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_683
const/16 v0, 0xa1
if-ge v2, v0, :cond_69f
const-string v0, "CREATE TABLE IF NOT EXISTS stickers_pack (_id INTEGER PRIMARY KEY AUTOINCREMENT,pack_id TEXT NOT NULL,name TEXT,product_id TEXT,purchased INTEGER DEFAULT 0,author TEXT,num_stickers INTEGER,price INTEGER DEFAULT 0,description TEXT,in_use INTEGER DEFAULT 0,download_time INTEGER DEFAULT 0,scene INTEGER DEFAULT 0 NOT NULL,pack_type TEXT,title_img TEXT,UNIQUE (pack_id));"
.line 50327
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS sticker (_id INTEGER PRIMARY KEY AUTOINCREMENT,sticker_id TEXT NOT NULL,imdata TEXT,pack_id TEXT,timestamp INTEGER DEFAULT 0,count INTEGER DEFAULT 0,pack_type TEXT,UNIQUE (sticker_id));"
.line 50344
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "calls_only"
const-string v4, "duration"
.line 1533
invoke-static {v1, v0, v4}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "calls_only"
const-string v4, "state"
.line 1534
invoke-static {v1, v0, v4}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_69f
const/16 v0, 0xa2
const-string v4, "bubble_info"
if-ge v2, v0, :cond_6af
const-string v0, "top_floor_text_color"
.line 1538
invoke-static {v1, v4, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "top_floor_mask_transparency"
.line 1539
invoke-static {v1, v4, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_6af
const/16 v0, 0xa3
if-ge v2, v0, :cond_6bc
.line 1543
invoke-static {}, Lcom/imo/android/imoim/util/ei;->au()I
move-result v0
if-eq v0, v6, :cond_6bc
invoke-static {}, Lcom/imo/android/imoim/util/ei;->av()I
:cond_6bc
const/16 v0, 0xa4
if-ge v2, v0, :cond_6ca
const-string v0, "unsubscribe_enabled INTEGER DEFAULT 1 NOT NULL"
.line 1549
invoke-static {v1, v7, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "share_enabled INTEGER DEFAULT 1 NOT NULL"
.line 1550
invoke-static {v1, v7, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_6ca
const/16 v0, 0xa5
if-ge v2, v0, :cond_6e3
const-string v0, "group_type TEXT DEFAULT \"normal\""
.line 1554
invoke-static {v1, v9, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "ex_info TEXT"
.line 1555
invoke-static {v1, v9, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
.line 1556
invoke-static/range {p1 .. p1}, Lcom/imo/android/imoim/util/au;->e(Landroid/database/sqlite/SQLiteDatabase;)V
.line 1557
invoke-static/range {p1 .. p1}, Lcom/imo/android/imoim/util/au;->f(Landroid/database/sqlite/SQLiteDatabase;)V
const-string v0, "CREATE TABLE IF NOT EXISTS community_notice (_id INTEGER PRIMARY KEY AUTOINCREMENT,type TEXT NOT NULL,community_id TEXT NOT NULL,name TEXT,timestamp INTEGER,unread INTEGER,notice_seq INTEGER,community_activity_response TEXT,UNIQUE (community_id, type));"
.line 50354
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_6e3
const/16 v0, 0xa6
if-ge v2, v0, :cond_6f6
const-string v0, "DROP TABLE IF EXISTS favorite_expression"
.line 1562
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS favorite_expression (_id INTEGER PRIMARY KEY AUTOINCREMENT,favorite_id TEXT NOT NULL,type TEXT NOT NULL,object TEXT NOT NULL,favorite_time INTEGER NOT NULL,UNIQUE (favorite_id, type));"
.line 50365
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "moved_to_community_member INTEGER DEFAULT 0"
.line 1564
invoke-static {v1, v9, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_6f6
const/16 v0, 0xa7
if-ge v2, v0, :cond_6fd
.line 1568
invoke-static/range {p1 .. p1}, Lcom/imo/android/imoim/util/au;->h(Landroid/database/sqlite/SQLiteDatabase;)V
:cond_6fd
const/16 v0, 0xa8
if-ge v2, v0, :cond_70b
const-string v0, "DROP TABLE IF EXISTS bubble_info"
.line 1572
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS bubble_info (_id INTEGER PRIMARY KEY AUTOINCREMENT,bubble_id TEXT NOT NULL,bgid TEXT NOT NULL,preview_image TEXT NOT NULL,receive_image TEXT NOT NULL,send_image TEXT NOT NULL,label_image TEXT NOT NULL,text_color TEXT NOT NULL,description TEXT NOT NULL,background_color TEXT NOT NULL,tip TEXT NOT NULL,type INTEGER NOT NULL,top_floor_text_color TEXT,top_floor_mask_transparency TEXT,bubble_type TEXT,UNIQUE (bubble_id,type));"
.line 50373
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_70b
const/16 v0, 0xa9
const-string v6, "stickers_pack"
if-ge v2, v0, :cond_716
const-string v0, "scene INTEGER DEFAULT 0 NOT NULL"
.line 1577
invoke-static {v1, v6, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_716
const/16 v0, 0xaa
if-ge v2, v0, :cond_735
const-string v0, "pack_type TEXT"
.line 1581
invoke-static {v1, v6, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "title_img TEXT"
.line 1582
invoke-static {v1, v6, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "sticker"
const-string v6, "pack_type TEXT"
.line 1583
invoke-static {v1, v0, v6}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "story_push_notify INTEGER DEFAULT 0"
.line 1585
invoke-static {v1, v8, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "story_intimacy_score REAL DEFAULT 0"
.line 1586
invoke-static {v1, v8, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_735
const/16 v0, 0xab
if-ge v2, v0, :cond_76e
.line 1590
new-instance v0, Ljava/lang/StringBuilder;
const-string v6, "new_state INTEGER DEFAULT "
invoke-direct {v0, v6}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
sget-object v6, Lcom/imo/android/imoim/publicchannel/post/ac$d;->UNKNOWN:Lcom/imo/android/imoim/publicchannel/post/ac$d;
invoke-virtual {v6}, Lcom/imo/android/imoim/publicchannel/post/ac$d;->to()I
move-result v6
invoke-virtual {v0, v6}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v0
invoke-static {v1, v3, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
.line 1591
new-instance v0, Ljava/lang/StringBuilder;
const-string v6, "new_state INTEGER DEFAULT "
invoke-direct {v0, v6}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V
sget-object v6, Lcom/imo/android/imoim/publicchannel/post/ac$d;->UNKNOWN:Lcom/imo/android/imoim/publicchannel/post/ac$d;
invoke-virtual {v6}, Lcom/imo/android/imoim/publicchannel/post/ac$d;->to()I
move-result v6
invoke-virtual {v0, v6}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
move-result-object v0
const-string v6, "channel_post_cache"
invoke-static {v1, v6, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS channel_post_detail (_id INTEGER PRIMARY KEY AUTOINCREMENT,post_id TEXT NOT NULL,channel_id TEXT NOT NULL,favorite_num INTERGER NOT NULL,view_num INTERGER NOT NULL,has_favorite INTERGER DEFAULT 0,update_time INTERGER NOT NULL,source_channel_id TEXT,source_post_id TEXT, UNIQUE (channel_id, post_id));"
.line 50392
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_76e
const/16 v0, 0xad
if-ge v2, v0, :cond_775
.line 1602
invoke-static/range {p1 .. p1}, Lcom/imo/android/imoim/util/au;->g(Landroid/database/sqlite/SQLiteDatabase;)V
:cond_775
const/16 v0, 0xae
if-ge v2, v0, :cond_77e
const-string v0, "bubble_type TEXT"
.line 1606
invoke-static {v1, v4, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_77e
const/16 v0, 0xaf
if-ge v2, v0, :cond_787
const-string v0, "CREATE TABLE IF NOT EXISTS friend_ringback (buid TEXT NOT NULL,tone_id TEXT NOT NULL,data TEXT,uptime INTEGER,UNIQUE (buid) ON CONFLICT REPLACE);"
.line 50404
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_787
const/16 v0, 0xb0
if-ge v2, v0, :cond_79d
const-string v0, "certification_id TEXT"
.line 1614
invoke-static {v1, v7, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
.line 1615
invoke-static {v1, v3, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v3, "channel_post_cache"
.line 1616
invoke-static {v1, v3, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "CREATE TABLE IF NOT EXISTS channel_cert_info (_id INTEGER PRIMARY KEY AUTOINCREMENT,certification_id TEXT NOT NULL,json_result TEXT NOT NULL, UNIQUE (certification_id));"
.line 50413
invoke-virtual {v1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
:cond_79d
const/16 v0, 0xb1
if-ge v2, v0, :cond_7ad
const-string v0, "album"
const-string v3, "albums_numbers INTEGER DEFAULT 0"
.line 1621
invoke-static {v1, v0, v3}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "story_album_list TEXT"
.line 1622
invoke-static {v1, v8, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_7ad
const/16 v0, 0xb3
if-ge v2, v0, :cond_7b6
const-string v0, "relation_chat_source_type TEXT"
.line 1626
invoke-static {v1, v5, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_7b6
const/16 v0, 0xb4
if-ge v2, v0, :cond_7c1
const-string v0, "community_notice"
const-string v3, "community_activity_response TEXT"
.line 1630
invoke-static {v1, v0, v3}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_7c1
const/16 v0, 0xb5
if-ge v2, v0, :cond_7cf
const-string v0, "is_folded INTEGER DEFAULT 0 NOT NULL"
.line 1635
invoke-static {v1, v7, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
const-string v0, "is_folded INTEGER DEFAULT 0 NOT NULL"
.line 1637
invoke-static {v1, v5, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_7cf
const/16 v0, 0xb6
if-ge v2, v0, :cond_7d8
const-string v0, "is_folded INTEGER DEFAULT 0"
.line 1642
invoke-static {v1, v9, v0}, Lcom/imo/android/imoim/util/au;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)V
:cond_7d8
return-void
.end method