search

hemvall / Heracles

Store your sports performances and track your progression either in the gym, running and even boxing.
https://heracle.me/
5 stars 0 forks source link

Modify Performances Schema #21

Open hemvall opened 11 months ago

hemvall commented 11 months ago

New table sets with a performanceId

hemvall commented 11 months ago

CREATE TABLE Sets ( Id INT AUTO_INCREMENT PRIMARY KEY, PerfId INT, Reps INT(10), Weight INT(10) );

hemvall commented 11 months ago

ALTER TABLE sets ADD COLUMN UserId int;

hemvall commented 11 months ago

ALTER TABLE performances ADD GoalId int; update performances set GoalId = 1

hemvall commented 10 months ago

go abandonner ça et mettre du 4x quelque chose à chaque fois !

hemvall commented 10 months ago

peut être ajouter 'isDropSet' avec

hemvall commented 9 months ago 
alter table performances add Sets int(10);
alter table performances add Reps int(10);
alter table performances add Weight int(10);