-
Notifications
You must be signed in to change notification settings - Fork 4
Expand file tree
/
Copy pathscript.sql
More file actions
15 lines (11 loc) · 1.54 KB
/
script.sql
File metadata and controls
15 lines (11 loc) · 1.54 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
ALTER TABLE `aefis` ADD `webradr_ref` VARCHAR(255) NULL DEFAULT NULL AFTER `vigiflow_date`, ADD `webradr_date` DATETIME NULL DEFAULT NULL AFTER `webradr_ref`,ADD `webradr_message` VARCHAR(255) NULL DEFAULT NULL AFTER `webradr_date`;
ALTER TABLE `sadrs` ADD `webradr_ref` VARCHAR(255) NULL DEFAULT NULL AFTER `vigiflow_date`, ADD `webradr_date` DATETIME NULL DEFAULT NULL AFTER `webradr_ref`,ADD `webradr_message` VARCHAR(255) NULL DEFAULT NULL AFTER `webradr_date`, ADD `submitted_date` DATETIME NULL DEFAULT NULL AFTER `webradr_date`;
ALTER TABLE `aefis` ADD `webradr_ref` VARCHAR(255) NULL DEFAULT NULL AFTER `vigiflow_date`, ADD `webradr_date` DATETIME NULL DEFAULT NULL AFTER `webradr_ref`,ADD `webradr_message` VARCHAR(255) NULL DEFAULT NULL AFTER `webradr_date`, ADD `submitted_date` DATETIME NULL DEFAULT NULL AFTER `webradr_date`;
ALTER TABLE `sadrs` ADD `submitted_date` DATETIME NULL DEFAULT NULL AFTER `webradr_date`;
ALTER TABLE `pqmps` ADD `submitted_date` DATETIME NULL DEFAULT NULL AFTER `submitted`;
ALTER TABLE `transfusions` ADD `submitted_date` DATETIME NULL DEFAULT NULL AFTER `submitted`;
ALTER TABLE `medications` ADD `submitted_date` DATETIME NULL DEFAULT NULL AFTER `submitted`;
ALTER TABLE `devices` ADD `submitted_date` DATETIME NULL DEFAULT NULL AFTER `submitted`;
ALTER TABLE `aefis` ADD `submitted_date` DATETIME NULL DEFAULT NULL AFTER `submitted`;
ALTER TABLE `padrs` ADD `submitted_date` DATETIME NULL DEFAULT NULL AFTER `submitted`;
ALTER TABLE `saes` ADD `submitted_date` DATETIME NULL DEFAULT NULL AFTER `report_date`;