MsaW23Vc

1CREATE TABLE IF NOT EXISTS `dsapp_reminderemailmessage` (
2 `id` INT NOT NULL auto_increment,
3 `practice_id` INT NOT NULL,
4 `patient_id` INT NOT NULL,
5 `create_dt` DATETIME NOT NULL DEFAULT now(),
6 `email_template_name` varchar(60) NOT NULL,
7 `to_email` varchar(60) NOT NULL,
8 `out_log` longtext NOT NULL,
9 `in_queue`  bool NOT NULL DEFAULT TRUE,
10 `with_error` longtext NOT NULL,
11 `retries` INT NOT NULL DEFAULT 0,
12 `sender_id` varchar(30) NULL,
13 PRIMARY KEY (`id`),
14 CONSTRAINT `fk_reminderemailmessage_to_practice` FOREIGN KEY (`practice_id`) REFERENCES `dsapp_practice` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
15 CONSTRAINT `fk_reminderemailmessage_to_patient` FOREIGN KEY (`patient_id`) REFERENCES `dsapp_user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION);
16
17CREATE TABLE IF NOT EXISTS `dsapp_remindersmsmessage` (
18 `id` INT NOT NULL auto_increment,
19 `create_dt` DATETIME NOT NULL DEFAULT now(),
20 `practice_id` INT NOT NULL,
21 `cell` varchar(20) NOT NULL,
22 `out_log` longtext NOT NULL,
23 `reason` varchar(30) NULL,
24 `number_sms_template` INT NOT NULL,
25 `in_queue`  bool NOT NULL DEFAULT TRUE,
26 `with_error` longtext NOT NULL,
27 `retries` INT NOT NULL DEFAULT 0,
28 `sender_id` varchar(30) NULL,
29 PRIMARY KEY (`id`),
30 CONSTRAINT `fk_remindersmsmessage_to_practice` FOREIGN KEY (`practice_id`) REFERENCES `dsapp_practice` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION);
31