Files
training/db/load.sql
2025-05-12 10:58:23 +02:00

14 lines
675 B
SQL

insert into exercise (name) values ('Bench Press');
insert into shorthand values(currval('exercise_id_seq'), 'bp');
insert into exercise (name) values ('Abdominals');
insert into shorthand values(currval('exercise_id_seq'), 'abs');
insert into exercise (name) values ('Squat');
insert into shorthand values(currval('exercise_id_seq'), 'squat');
insert into exercise (name) values ('Biceps');
insert into shorthand values(currval('exercise_id_seq'), 'biceps');
insert into exercise (name) values ('Triceps');
insert into shorthand values(currval('exercise_id_seq'), 'triceps');
insert into account (name, login, birthdate) values ('Jakob Dalsgaard', 'jakob', '1975-03-08');