-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathinserts.sql
More file actions
55 lines (55 loc) · 17.7 KB
/
inserts.sql
File metadata and controls
55 lines (55 loc) · 17.7 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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
INSERT INTO care_tasks (id, pet_id, task_type, title, frequency, scheduled_time, is_completed, gamification_points, notes, created_at, updated_at) VALUES
('f1a30ed7-8ce7-40f7-97d9-6c755b0d33aa', 'ca2ffad9-b18f-498d-b609-10d5e7a60b1e', 'feeding', 'Morning Feeding', 'daily', '08:00', false, 10, 'Provide a measured portion of appropriate dog food due to low activity level to prevent weight gain.', '2026-05-22T01:35:32.676252Z', '2026-05-22T01:35:32.676252Z'),
('da01e380-aa55-47ad-9ee1-c24531e9044a', 'ca2ffad9-b18f-498d-b609-10d5e7a60b1e', 'walk', 'Short Leash Walk', 'daily', '16:00', false, 8, 'A short, slow walk is beneficial for low-energy dogs for bathroom breaks and mental stimulation.', '2026-05-22T01:35:32.676252Z', '2026-05-22T01:35:32.676252Z'),
('1f6788a9-03b0-4b15-a51f-7eac4ee41e00', 'ca2ffad9-b18f-498d-b609-10d5e7a60b1e', 'grooming', 'Brushing', 'daily', NULL, false, 5, 'Regular brushing helps manage shedding and keeps the coat healthy, especially important for mixed breeds.', '2026-05-22T01:35:32.676252Z', '2026-05-22T01:35:32.676252Z'),
('10f09bdc-a49c-41c7-8d0d-20769b8720b6', 'ca2ffad9-b18f-498d-b609-10d5e7a60b1e', 'other', 'Mental Enrichment', 'daily', '19:00', false, 12, 'Offer puzzle toys or gentle interaction to provide mental stimulation given the low activity level.', '2026-05-22T01:35:32.676252Z', '2026-05-22T01:35:32.676252Z'),
('4887113c-84ff-42f0-977c-f7984bed81b5', 'a1000001-0001-4000-8000-000000000002', 'feeding', 'Morning Hay & Pellets', 'daily', '08:00', false, 10, 'Holland Lops benefit from constant access to fresh hay for digestive health. Provide a measured amount of pellets as recommended by your vet.', '2026-05-22T01:35:54.667648Z', '2026-05-22T01:35:54.667648Z'),
('0cd9463b-64ba-418b-a8b4-c0e8bf4169d6', 'a1000001-0001-4000-8000-000000000002', 'grooming', 'Daily Brush', 'daily', '18:00', false, 8, 'Regular brushing helps prevent matting, especially important for Holland Lops with longer fur. Low activity levels mean they need help staying clean.', '2026-05-22T01:35:54.667648Z', '2026-05-22T01:35:54.667648Z'),
('dd8647d7-4e88-4fea-8498-3d4060bdd9ad', 'a1000001-0001-4000-8000-000000000002', 'other', 'Spot Clean Litter Box', 'daily', '09:00', false, 5, 'Maintaining a clean litter box is crucial for hygiene and preventing ammonia buildup. Daily spot cleaning is sufficient for a low-activity rabbit.', '2026-05-22T01:35:54.667648Z', '2026-05-22T01:35:54.667648Z'),
('f01072e9-debe-4dcc-9c96-b9321ac841c2', 'a1000001-0001-4000-8000-000000000002', 'playtime', 'Evening Enrichment', 'daily', '19:00', false, 15, 'Even low-energy rabbits need mental stimulation. Offer a chew toy or a simple puzzle to prevent boredom.', '2026-05-22T01:35:54.667648Z', '2026-05-22T01:35:54.667648Z'),
('88c45ac2-5a9a-4535-871b-dae5db939574', 'a1000001-0001-4000-8000-000000000003', 'feeding', 'Morning Seed & Pellets', 'daily', '08:00', false, 10, 'Provide a mix of high-quality birdseed and formulated pellets for balanced nutrition, crucial for a long-lived cockatiel.', '2026-05-22T01:36:16.833376Z', '2026-05-22T01:36:16.833376Z'),
('4d91aa5d-6c2b-43a8-95b1-ce71e8f7743a', 'a1000001-0001-4000-8000-000000000003', 'playtime', 'Interactive Play Session', 'daily', NULL, false, 20, 'Cockatiels are intelligent and need mental stimulation. Offer toys like swings, ladders, and foraging toys to prevent boredom and promote physical activity.', '2026-05-22T01:36:16.833376Z', '2026-05-22T01:36:16.833376Z'),
('e431b4a9-be3c-4dfc-9a1c-0bae3d735fcc', 'a1000001-0001-4000-8000-000000000003', 'grooming', 'Wing Clipping Check & Preening Support', 'daily', NULL, false, 5, 'Regularly check wing clips for regrowth and provide a safe environment for natural preening. This helps maintain feather health and prevents feather plucking.', '2026-05-22T01:36:16.833376Z', '2026-05-22T01:36:16.833376Z'),
('49c333f1-4ef3-4673-bf7c-0d45195de926', 'a1000001-0001-4000-8000-000000000003', 'vet_visit', 'Annual Check-up', 'as_needed', NULL, false, 15, 'Given the bird''s age, annual vet check-ups are vital for early detection of age-related health issues and preventative care.', '2026-05-22T01:36:16.833376Z', '2026-05-22T01:36:16.833376Z'),
('c92d9b33-87cd-44ab-876e-4277ff39e57d', 'a1000001-0001-4000-8000-000000000005', 'feeding', 'Morning Insect & Veggie Meal', 'daily', '09:00', false, 25, 'Bearded dragons at this age benefit from a balanced diet of insects and vegetables. Offer a variety of insects (crickets, dubia roaches) and leafy greens (collard greens, mustard greens).', '2026-05-22T01:36:40.079444Z', '2026-05-22T01:36:40.079444Z'),
('7a8d4d0a-e5d3-4c1a-a44f-561ee89b2e08', 'a1000001-0001-4000-8000-000000000005', 'other', 'UVB/Heat Lamp Check', 'daily', '10:00', false, 10, 'Ensure proper UVB and heat lamp functionality for optimal calcium absorption and thermoregulation. Monitor temperature gradients within the enclosure.', '2026-05-22T01:36:40.079444Z', '2026-05-22T01:36:40.079444Z'),
('39fa5091-730b-4a71-857f-46fa4589e1b2', 'a1000001-0001-4000-8000-000000000005', 'grooming', 'Shed Monitoring', 'as_needed', NULL, false, 15, 'Monitor for signs of shedding and provide assistance if needed. A healthy shed is crucial for skin health.', '2026-05-22T01:36:40.079444Z', '2026-05-22T01:36:40.079444Z'),
('e151cb34-9b1f-49a9-b50a-64eb84c575bc', 'a1000001-0001-4000-8000-000000000005', 'other', 'Enclosure Spot Cleaning', 'daily', '18:00', false, 12, 'Remove any waste or uneaten food from the enclosure to maintain a clean and healthy environment.', '2026-05-22T01:36:40.079444Z', '2026-05-22T01:36:40.079444Z'),
('b1aebb03-0e21-4b15-ae4e-4d6ba198e03b', 'a1000001-0001-4000-8000-000000000006', 'feeding', 'Morning Hay & Pellets', 'daily', '08:00', false, 10, 'Provide unlimited fresh hay and a measured portion of high-quality rabbit pellets for optimal digestion and dental health. Mini Rex rabbits are prone to dental issues.', '2026-05-22T01:37:03.807800Z', '2026-05-22T01:37:03.807800Z'),
('84115f98-ca63-40c0-ad29-ec705ab41ceb', 'a1000001-0001-4000-8000-000000000006', 'playtime', 'Interactive Play Session', 'daily', NULL, false, 20, 'Engage in at least 30 minutes of interactive playtime with toys like cardboard tubes, balls, or puzzle toys to stimulate mental and physical well-being, given moderate activity level.', '2026-05-22T01:37:03.807800Z', '2026-05-22T01:37:03.807800Z'),
('05a9d41f-3736-40d7-8115-cc30f0e760e3', 'a1000001-0001-4000-8000-000000000006', 'grooming', 'Brush & Check Coat', 'daily', '18:00', false, 8, 'Mini Rex rabbits have a dense, velvety coat that requires daily brushing to prevent matting and hairballs. Check for any skin issues.', '2026-05-22T01:37:03.807800Z', '2026-05-22T01:37:03.807800Z'),
('7685dc1a-4f7e-4283-aa7d-d079dc2d8f9a', 'a1000001-0001-4000-8000-000000000006', 'other', 'Litter Box Cleaning', 'daily', '20:00', false, 5, 'Clean the litter box daily to maintain a hygienic environment and prevent ammonia buildup, crucial for rabbit health.', '2026-05-22T01:37:03.807800Z', '2026-05-22T01:37:03.807800Z'),
('fdf1f999-9d35-4a71-83a3-36f322d669a3', 'a1000001-0001-4000-8000-000000000007', 'feeding', 'Morning Seed & Pellet Mix', 'daily', '08:00', false, 10, 'Provide a balanced mix of seeds and pellets for optimal nutrition. Ensure fresh water is always available.', '2026-05-22T01:37:24.785227Z', '2026-05-22T01:37:24.785227Z'),
('e1acf639-c526-4934-9d11-94dc277955bb', 'a1000001-0001-4000-8000-000000000007', 'playtime', 'Interactive Play Session', 'daily', NULL, false, 20, 'Budgerigars are active! A 15-30 minute play session with toys like swings, ladders, and foraging toys stimulates mental and physical health.', '2026-05-22T01:37:24.785227Z', '2026-05-22T01:37:24.785227Z'),
('666697ab-599d-412c-a484-6860b784ce3b', 'a1000001-0001-4000-8000-000000000007', 'grooming', 'Preening & Wing Check', 'daily', NULL, false, 5, 'Budgies preen regularly, but a quick check for feather health and signs of parasites is important. Offer a shallow dish of water for bathing.', '2026-05-22T01:37:24.785227Z', '2026-05-22T01:37:24.785227Z'),
('d63e3734-e950-46d6-b548-e628c37a974e', 'a1000001-0001-4000-8000-000000000007', 'training', 'Recall Training', 'twice_daily', '17:00', false, 15, 'Reinforce recall with positive reinforcement (treats). This strengthens the bond and can be helpful if the bird escapes.', '2026-05-22T01:37:24.785227Z', '2026-05-22T01:37:24.785227Z'),
('dc5974a8-bcdc-4f81-8584-37cf235f1863', '4271d48b-1b75-4dfd-8bcf-176d68f8565e', 'feeding', 'Morning Feeding', 'daily', '08:00', false, 10, 'Persians benefit from smaller, more frequent meals to prevent digestive issues. Ensure fresh food and water are available.', '2026-05-22T01:37:44.488059Z', '2026-05-22T01:37:44.488059Z'),
('22f135b1-2c0e-4c7d-89f2-2651a3792678', '4271d48b-1b75-4dfd-8bcf-176d68f8565e', 'grooming', 'Daily Brushing', 'daily', '18:00', false, 15, 'Persians have long coats prone to matting. Daily brushing is crucial to prevent painful mats and skin issues.', '2026-05-22T01:37:44.488059Z', '2026-05-22T01:37:44.488059Z'),
('889ba1bb-354f-451b-86a2-b6f70aa9efcb', '4271d48b-1b75-4dfd-8bcf-176d68f8565e', 'playtime', 'Interactive Play', 'daily', NULL, false, 20, 'Moderate activity level requires mental and physical stimulation. Interactive play helps prevent boredom and obesity.', '2026-05-22T01:37:44.488059Z', '2026-05-22T01:37:44.488059Z'),
('9a558c6a-8255-4673-b40b-1899406acf96', '4271d48b-1b75-4dfd-8bcf-176d68f8565e', 'dental', 'Dental Check & Brushing', 'daily', '19:00', false, 12, 'Dental hygiene is important for Persian cats. Daily brushing or dental treats help prevent dental disease.', '2026-05-22T01:37:44.488059Z', '2026-05-22T01:37:44.488059Z'),
('39808d29-9f02-49b2-98f9-aa99e5a34bf9', 'a1000001-0001-4000-8000-000000000009', 'walk', 'Morning Power Walk', 'daily', '07:00', false, 25, 'Border Collies need significant daily exercise. A brisk walk helps burn energy and prevents boredom.', '2026-05-22T01:38:04.013283Z', '2026-05-22T01:38:04.013283Z'),
('cc6a85bc-0c14-4626-a038-fe23e4afd2fb', 'a1000001-0001-4000-8000-000000000009', 'training', 'Mental Stimulation Training', 'daily', '18:00', false, 20, 'High activity levels require mental stimulation. Training sessions (obedience, tricks) are crucial to channel energy positively.', '2026-05-22T01:38:04.013283Z', '2026-05-22T01:38:04.013283Z'),
('7c9eebe8-697e-4ce6-bc0b-8cf02e25804f', 'a1000001-0001-4000-8000-000000000009', 'playtime', 'Interactive Play Session', 'daily', '19:00', false, 22, 'Border Collies thrive on play. Interactive games like fetch or frisbee are essential for physical and mental well-being.', '2026-05-22T01:38:04.013283Z', '2026-05-22T01:38:04.013283Z'),
('703dc3ed-e816-4cc4-8f68-2107065c383e', 'a1000001-0001-4000-8000-000000000009', 'feeding', 'Evening Feeding', 'twice_daily', '12:00', false, 10, 'Maintain consistent feeding schedule for digestive health and energy levels.', '2026-05-22T01:38:04.013283Z', '2026-05-22T01:38:04.013283Z'),
('55db6d1b-e2cc-483a-90a6-c3fb89e0a94b', 'a1000001-0001-4000-8000-000000000001', 'walk', 'Morning Exercise Walk', 'daily', '07:00', false, 25, 'Labrador Retrievers are high energy and need a substantial morning walk to burn energy and maintain physical and mental well-being.', '2026-05-22T01:38:24.805874Z', '2026-05-22T01:38:24.805874Z'),
('8797eaab-c952-40f8-b5b5-49467e9e2eb6', 'a1000001-0001-4000-8000-000000000001', 'feeding', 'Breakfast & Dinner', 'twice_daily', '07:30', false, 10, 'Provide a balanced diet appropriate for a large, active breed. Portion control is important to prevent weight gain.', '2026-05-22T01:38:24.805874Z', '2026-05-22T01:38:24.805874Z'),
('37ae5aa7-78b1-45c0-8b23-b35b4e6185e1', 'a1000001-0001-4000-8000-000000000001', 'playtime', 'Afternoon Play Session', 'daily', NULL, false, 20, 'Engage in interactive play (fetch, tug-of-war) for at least 30 minutes to satisfy their retrieving instincts and provide mental stimulation.', '2026-05-22T01:38:24.805874Z', '2026-05-22T01:38:24.805874Z'),
('2941e3f5-fc98-4be7-8835-26cc12b361ce', 'a1000001-0001-4000-8000-000000000001', 'grooming', 'Brushing', 'daily', '18:00', false, 5, 'Regular brushing helps manage shedding and keeps their coat healthy, especially important for a double-coated breed.', '2026-05-22T01:38:24.805874Z', '2026-05-22T01:38:24.805874Z'),
('227f2ec4-f656-4de2-b09b-01924ed10489', 'a1000001-0001-4000-8000-000000000004', 'feeding', 'Morning Feeding', 'daily', '07:00', false, 10, 'Betta fish are small and have small stomachs. Offer 2-3 small pellets. Overfeeding can lead to health problems.', '2026-05-22T01:38:42.181143Z', '2026-05-22T01:38:42.181143Z'),
('aa734617-9ce6-454e-a188-70540e6810e4', 'a1000001-0001-4000-8000-000000000004', 'other', 'Water Quality Check', 'daily', '18:00', false, 15, 'Monitor water temperature (78-82°F) and pH levels. Perform a small water change (25%) if needed to maintain optimal conditions for a sedentary Betta.', '2026-05-22T01:38:42.181143Z', '2026-05-22T01:38:42.181143Z'),
('4a53c3ca-2cb5-4e42-a1e4-8e8154b4a506', 'a1000001-0001-4000-8000-000000000004', 'playtime', 'Visual Stimulation', 'daily', NULL, false, 8, 'Betta fish enjoy observing their surroundings. Ensure the tank has adequate hiding places and visual interest to reduce stress, even with a sedentary nature.', '2026-05-22T01:38:42.181143Z', '2026-05-22T01:38:42.181143Z'),
('6ce197f5-d169-439a-b530-ac97723260c3', 'a1000001-0001-4000-8000-000000000008', 'feeding', 'Morning Feeding', 'daily', '08:00', false, 10, 'Provide a measured portion of high-quality dry food appropriate for a senior cat with a low activity level to maintain weight and health.', '2026-05-22T01:39:03.089519Z', '2026-05-22T01:39:03.089519Z'),
('e03710c9-c101-48c5-8199-e389592f9483', 'a1000001-0001-4000-8000-000000000008', 'feeding', 'Evening Feeding', 'daily', '18:00', false, 10, 'Offer a smaller portion of wet food in the evening to supplement dry food and encourage hydration, suitable for a senior cat.', '2026-05-22T01:39:03.089519Z', '2026-05-22T01:39:03.089519Z'),
('fabfb4c1-37e3-4b36-8c17-0ef30ce4a719', 'a1000001-0001-4000-8000-000000000008', 'grooming', 'Brushing', 'daily', NULL, false, 5, 'Gentle daily brushing helps remove loose fur, prevents hairballs, and stimulates circulation, important for a cat with a low activity level.', '2026-05-22T01:39:03.089519Z', '2026-05-22T01:39:03.089519Z'),
('cfccde21-620c-4dbe-8a85-b729f0dc9b2a', 'a1000001-0001-4000-8000-000000000008', 'other', 'Litter Box Cleaning', 'daily', '09:00', false, 5, 'Maintain a clean litter box to encourage consistent use and prevent urinary tract issues, especially important for a senior cat.', '2026-05-22T01:39:03.089519Z', '2026-05-22T01:39:03.089519Z'),
('05949bab-67d4-4728-b11e-a16c0bc2033f', 'a1000001-0001-4000-8000-000000000010', 'feeding', 'Morning Insect Meal', 'daily', '10:00', false, 20, 'Leopard geckos are insectivores. Provide a gut-loaded and dusted meal of crickets or mealworms.', '2026-05-22T01:39:19.224575Z', '2026-05-22T01:39:19.224575Z'),
('ca0f49f7-3c32-4545-bad3-7a4d9d4cebbe', 'a1000001-0001-4000-8000-000000000010', 'other', 'Substrate Spot Cleaning', 'daily', '18:00', false, 10, 'Remove any soiled substrate from the enclosure to maintain hygiene and prevent bacterial growth, especially given the sedentary nature.', '2026-05-22T01:39:19.224575Z', '2026-05-22T01:39:19.224575Z'),
('da77784a-8c2f-457c-9fb7-d867edeaeead', 'a1000001-0001-4000-8000-000000000010', 'other', 'Water Bowl Refresh', 'daily', NULL, false, 5, 'Ensure a shallow dish of fresh water is always available for hydration. Leopard geckos drink from the surface.', '2026-05-22T01:39:19.224575Z', '2026-05-22T01:39:19.224575Z'),
('7f8627ba-ff4e-4596-ba9b-883b9d19083f', 'e23b4fa6-34ed-4c89-a9ff-7efb661d6141', 'walk', 'Morning Walk', 'daily', '07:00', false, 25, 'Golden Retrievers need regular exercise. A morning walk helps burn energy and provides mental stimulation.', '2026-05-22T01:39:39.221229Z', '2026-05-22T01:39:39.221229Z'),
('82618a0a-af6b-4378-b5c6-684f146c6c1a', 'e23b4fa6-34ed-4c89-a9ff-7efb661d6141', 'feeding', 'Breakfast Feeding', 'twice_daily', '07:30', false, 10, 'Maintain a consistent feeding schedule for digestive health. Moderate activity level requires appropriate caloric intake.', '2026-05-22T01:39:39.221229Z', '2026-05-22T01:39:39.221229Z'),
('26f9e6a6-847e-4fe9-881b-fcec2aafd36b', 'e23b4fa6-34ed-4c89-a9ff-7efb661d6141', 'playtime', 'Afternoon Play', 'daily', '17:00', false, 20, 'Golden Retrievers thrive on interaction. A playtime session helps reduce boredom and strengthens the bond.', '2026-05-22T01:39:39.221229Z', '2026-05-22T01:39:39.221229Z'),
('8be7510a-580a-4313-b1ad-e560d8b9aaff', 'e23b4fa6-34ed-4c89-a9ff-7efb661d6141', 'grooming', 'Brushing', 'daily', '19:00', false, 15, 'Regular brushing helps prevent matting and reduces shedding, important for a long-haired breed.', '2026-05-22T01:39:39.221229Z', '2026-05-22T01:39:39.221229Z'),
('0d13b696-440a-44a7-9fce-0e9198d8ad6e', '5c1412a0-52ae-4ccb-b1ba-493fbb80fc69', 'walk', 'Morning Exercise Walk', 'daily', '07:00', false, 25, 'Labrador Retrievers need significant daily exercise. A brisk walk helps burn energy and maintain physical health.', '2026-05-22T01:39:59.173059Z', '2026-05-22T01:39:59.173059Z'),
('70860271-24f3-438a-86c0-8d2d7471ff9c', '5c1412a0-52ae-4ccb-b1ba-493fbb80fc69', 'feeding', 'Breakfast Feeding', 'twice_daily', '07:30', false, 10, 'High activity level requires a balanced diet. Split daily food allowance into two meals.', '2026-05-22T01:39:59.173059Z', '2026-05-22T01:39:59.173059Z'),
('efea6783-78ab-4696-9963-33470a7205a3', '5c1412a0-52ae-4ccb-b1ba-493fbb80fc69', 'playtime', 'Afternoon Play Session', 'daily', '17:00', false, 20, 'Mental stimulation is crucial. A play session helps prevent boredom and destructive behaviors.', '2026-05-22T01:39:59.173059Z', '2026-05-22T01:39:59.173059Z'),
('93be2d62-dd4b-4294-8f3d-710a7e8f186f', '5c1412a0-52ae-4ccb-b1ba-493fbb80fc69', 'grooming', 'Brushing', 'daily', '19:00', false, 5, 'Labradors have a double coat that requires regular brushing to prevent matting and shedding.', '2026-05-22T01:39:59.173059Z', '2026-05-22T01:39:59.173059Z');