Skip to content

Instantly share code, notes, and snippets.

@zaur
Created June 17, 2013 09:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zaur/5795643 to your computer and use it in GitHub Desktop.
Save zaur/5795643 to your computer and use it in GitHub Desktop.
db.execSQL("CREATE TABLE " + RosterConstants.TABLE_ROSTER + " ("
+ RosterConstants._ID
+ " INTEGER PRIMARY KEY AUTOINCREMENT, "
+ RosterConstants.JID + " TEXT UNIQUE ON CONFLICT REPLACE, "
+ RosterConstants.ALIAS + " TEXT, "
+ RosterConstants.STATUS_MODE + " INTEGER, "
+ RosterConstants.AVATAR_160 + " TEXT, "
+ RosterConstants.GROUP + " TEXT);");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment