Advertisement
Guest User

Untitled

a guest
Jan 25th, 2015
171
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. private static final String CREATE_TABLE_WORKOUT_DONE = " CREATE TABLE workout_done(id INTEGER PRIMARY KEY, name TEXT, data DATETIME DEFAULT CURRENT_TIMESTAMP ) ";
  2.  
  3. private static final String CREATE_TABLE_ROUTINE_DONE = " CREATE TABLE routine_done (id INTEGER PRIMARY KEY, routine_id_fk INTEGER, workout_id_fk INTEGER," +
  4. " FOREIGN KEY( routine_id_fk) REFERENCES routine(id), FOREIGN KEY( workout_id_fk) REFERENCES workout_done(id) ) ";
  5.  
  6. private static final String CREATE_TABLE_SERIE= "CREATE TABLE serie(id INTEGER PRIMARY KEY, routine_done_id_fk INTEGER, weight INTEGER, reps INTEGER, FOREIGN KEY( routine_done_id_fk) REFERENCES routine_done(id)) ";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement