2 -- Comment Meta Language Constructs:
5 -- argument: table_name
6 -- behavior: if the table_name does not exist, the block will be executed
9 -- argument: table_name
10 -- behavior: if the table_name does exist, the block will be executed
13 -- arguments: table_name colname
14 -- behavior: if the colname in the table_name table does not exist, the block will be executed
17 -- arguments: table_name colname value
18 -- behavior: If the table table_name does not have a column colname with a data type equal to value, then the block will be executed
21 -- arguments: table_name colname value
22 -- behavior: If the table table_name does not have a row where colname = value, the block will be executed.
25 -- arguments: table_name colname value colname2 value2
26 -- behavior: If the table table_name does not have a row where colname = value AND colname2 = value2, the block will be executed.
29 -- arguments: table_name colname value colname2 value2 colname3 value3
30 -- behavior: If the table table_name does not have a row where colname = value AND colname2 = value2 AND colname3 = value3, the block will be executed.
33 -- arguments: table_name colname value colname2 value2 colname3 value3 colname4 value4
34 -- behavior: If the table table_name does not have a row where colname = value AND colname2 = value2 AND colname3 = value3 AND colname4 = value4, the block will be executed.
37 -- desc: This is a very specialized function to allow adding items to the list_options table to avoid both redundant option_id and title in each element.
38 -- arguments: table_name colname value colname2 value2 colname3 value3
39 -- behavior: The block will be executed if both statements below are true:
40 -- 1) The table table_name does not have a row where colname = value AND colname2 = value2.
41 -- 2) The table table_name does not have a row where colname = value AND colname3 = value3.
44 -- desc: This function will allow adding of indexes/keys.
45 -- arguments: table_name colname
46 -- behavior: If the index does not exist, it will be created
49 -- all blocks are terminated with and #EndIf statement.
51 #IfNotIndex lists type
52 CREATE INDEX `type` ON `lists` (`type`);
56 CREATE INDEX `pid` ON `lists` (`pid`);
59 #IfNotIndex form_vitals pid
60 CREATE INDEX `pid` ON `form_vitals` (`pid`);
64 CREATE INDEX `pid` ON `forms` (`pid`);
67 #IfNotIndex form_encounter pid
68 CREATE INDEX `pid` ON `form_encounter` (`pid`);
71 #IfNotIndex immunizations patient_id
72 CREATE INDEX `patient_id` ON `immunizations` (`patient_id`);
75 #IfNotIndex procedure_order patient_id
76 CREATE INDEX `patient_id` ON `procedure_order` (`patient_id`);
79 #IfNotIndex pnotes pid
80 CREATE INDEX `pid` ON `pnotes` (`pid`);
83 #IfNotIndex transactions pid
84 CREATE INDEX `pid` ON `transactions` (`pid`);
87 #IfNotIndex extended_log patient_id
88 CREATE INDEX `patient_id` ON `extended_log` (`patient_id`);
91 #IfNotIndex prescriptions patient_id
92 CREATE INDEX `patient_id` ON `prescriptions` (`patient_id`);
95 #IfMissingColumn version v_realpatch
96 ALTER TABLE `version` ADD COLUMN `v_realpatch` int(11) NOT NULL DEFAULT 0;