-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathinitial_data.sql
More file actions
25 lines (22 loc) · 1.12 KB
/
Copy pathinitial_data.sql
File metadata and controls
25 lines (22 loc) · 1.12 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
-- SkillStreak initial shared data
--
-- Apply after schema.sql (or the equivalent Django migrations). This seed is
-- idempotent: it can be run again without creating duplicate system rows.
--
-- It intentionally contains no users, passwords, schedules, completions, or
-- measurements. Accounts belong to Django's authentication flow; schedules and
-- activity belong to the individual account that creates them.
BEGIN;
INSERT INTO skills (slug, name, description, visibility)
VALUES
('exercise', 'Exercise', 'Complete any exercise activity.', 'SYSTEM'),
('eat-healthy', 'Eat Healthy', 'Make a healthy eating choice.', 'SYSTEM'),
('read', 'Read', 'Spend time reading.', 'SYSTEM'),
('learn', 'Learn', 'Spend time learning something new.', 'SYSTEM'),
('touch-grass', 'Touch Grass', 'Spend time outdoors.', 'SYSTEM'),
('go-to-gym', 'Go to Gym', 'Visit the gym.', 'SYSTEM'),
('hobby', 'Hobby', 'Spend time on a hobby.', 'SYSTEM'),
('drink-water', 'Drink Water', 'Meet your hydration intention.', 'SYSTEM'),
('sleep', 'Sleep', 'Meet your sleep intention.', 'SYSTEM')
ON CONFLICT (slug) DO NOTHING;
COMMIT;