Advertisement
Guest User

Untitled

a guest
Apr 11th, 2017
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.81 KB | None | 0 0
  1. case 7:
  2.     addSellerLogoAndColorToTicketsTable(db);
  3.  
  4.     db.execSQL("ALTER TABLE " + Purchases.TABLE_NAME
  5.             + " ADD COLUMN " + Purchases.UPLOAD_PENDING + " TINYINT DEFAULT 0");
  6.     db.execSQL("ALTER TABLE " + Purchases.TABLE_NAME
  7.             + " ADD COLUMN " + Purchases.PRICE + " REAL");
  8.     db.execSQL("ALTER TABLE " + Purchases.TABLE_NAME
  9.             + " ADD COLUMN " + Purchases.CURRENCY_CODE + " TEXT");
  10.  
  11.     //Delete all events because ticket data is cached and we need new info
  12.     db.execSQL("DELETE FROM " + Events.TABLE_NAME);
  13. break;
  14.  
  15. private void addSellerLogoAndColorToTicketsTable(SQLiteDatabase db) {
  16.     db.execSQL("ALTER TABLE " + Tickets.TABLE_NAME
  17.             + " ADD COLUMN " + Tickets.TICKET_SELLER_LOGO + " TEXT");
  18.  
  19.     db.execSQL("ALTER TABLE " + Tickets.TABLE_NAME
  20.             + " ADD COLUMN " + Tickets.TICKET_SELLER_COLOR + " TEXT"
  21.     );
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement