summaryrefslogblamecommitdiffstats
path: root/data_model/test_data.sql
blob: 78ece961c2e0d1fd5115908129647835ad61dc87 (plain) (tree)



















                                                                      
BEGIN TRANSACTION;
INSERT INTO "Tasks" VALUES (1,'Trash','Take out the trash.',2,5,NULL),
 (2,'Laundry','Do the Laundry',4,120,NULL),
 (3,'Pre-Workout Stretch',NULL,1,10,NULL);
INSERT INTO "TimeSlotTasks" VALUES (1,1),
 (1,2),
 (2,3);
INSERT INTO "SubTasks" VALUES (1,3,'arm circles',NULL),
 (2,3,'heel raises into toe raises',NULL),
 (3,3,'open hips',NULL),
 (4,3,'open hips (side)',NULL),
 (5,3,'karaoke',NULL),
 (6,3,'knee to chest',NULL),
 (7,3,'quad pull',NULL),
 (8,3,'frankenstein',NULL),
 (9,3,'lunge walk',NULL);
INSERT INTO "TimeSlots" VALUES (1,1,86400,88200,'Chore Block',NULL),
 (2,1,45000,48600,'Workout',NULL),
 (3,1,14000,20000,'test',NULL);
COMMIT;