Guest User

Untitled

a guest
Apr 20th, 2018
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. const val SQL_CREATE_PERSONS =
  2. "CREATE TABLE " + "PERSONS" + "(" +
  3. "ID" + " TEXT(100) PRIMARY KEY, " +
  4. "NAME" + " TEXT(50)
  5. "); "
  6.  
  7. const val SQL_CREATE_FACES =
  8. "CREATE TABLE " + "FACES" + "(" +
  9. "ID" + " TEXT(100) PRIMARY KEY, " +
  10. "PERSON_ID " + "TEXT(100), " +
  11. "FOREIGN KEY " + "(PERSON_ID)" + " REFERENCES " +
  12. "PERSONS" + "(" +
  13. "ID" + ") "+
  14. "ON DELETE CASCADE " +
  15. "); "
  16.  
  17. override fun onCreate(db: SQLiteDatabase?) {
  18. db?.execSQL("PRAGMA foreign_keys=ON;")
  19. db?.execSQL(SQL_CREATE_PERSONS)
  20. db?.execSQL(SQL_CREATE_FACES)
  21. }
Add Comment
Please, Sign In to add comment