8273b07231
* feat: track prescription repeats and refill reminders * test: align backend and frontend suites with current prescription and UI behavior * test: update frontend and backend expectations for latest reminders and refill flow
9 lines
569 B
SQL
9 lines
569 B
SQL
ALTER TABLE `medications` ADD `prescription_enabled` integer NOT NULL DEFAULT 0;
|
|
ALTER TABLE `medications` ADD `prescription_authorized_refills` integer;
|
|
ALTER TABLE `medications` ADD `prescription_remaining_refills` integer;
|
|
ALTER TABLE `medications` ADD `prescription_low_refill_threshold` integer NOT NULL DEFAULT 1;
|
|
ALTER TABLE `medications` ADD `prescription_expiry_date` text;
|
|
|
|
ALTER TABLE `user_settings` ADD `email_prescription_reminders` integer NOT NULL DEFAULT 1;
|
|
ALTER TABLE `user_settings` ADD `shoutrrr_prescription_reminders` integer NOT NULL DEFAULT 1;
|