2 ## Data for language translations
6 ## version 2.6.4-pl1-Debian-1ubuntu1.1
7 ## http://www.phpmyadmin.net
10 ## Generation Time: Feb 07, 2006 at 05:39 PM
11 ## Server version: 4.1.12
12 ## PHP Version: 4.4.0-3ubuntu1
14 ## Database: `openemr`
18 ## Dumping data for table `lang_constants`
21 INSERT INTO `lang_constants` VALUES (6, 'Group');
22 INSERT INTO `lang_constants` VALUES (8, 'Username:');
23 INSERT INTO `lang_constants` VALUES (10, 'EOB Posting - Instructions');
24 INSERT INTO `lang_constants` VALUES (11, 'Zip Code');
25 INSERT INTO `lang_constants` VALUES (12, 'Last Name');
26 INSERT INTO `lang_constants` VALUES (13, 'Male');
27 INSERT INTO `lang_constants` VALUES (14, 'Female');
28 INSERT INTO `lang_constants` VALUES (15, 'Appointment Date');
29 INSERT INTO `lang_constants` VALUES (16, 'Batch Communication Tool');
30 INSERT INTO `lang_constants` VALUES (17, 'Age From:');
31 INSERT INTO `lang_constants` VALUES (18, ' Up to:');
32 INSERT INTO `lang_constants` VALUES (19, 'SSN');
33 INSERT INTO `lang_constants` VALUES (20, 'User & Group Administration');
34 INSERT INTO `lang_constants` VALUES (21, 'Logout');
35 INSERT INTO `lang_constants` VALUES (22, 'Password:');
36 INSERT INTO `lang_constants` VALUES (23, 'Login');
37 INSERT INTO `lang_constants` VALUES (24, 'Administration');
38 INSERT INTO `lang_constants` VALUES (25, 'Password');
39 INSERT INTO `lang_constants` VALUES (26, 'Reports');
40 INSERT INTO `lang_constants` VALUES (27, 'Notes');
41 INSERT INTO `lang_constants` VALUES (28, 'Billing');
42 INSERT INTO `lang_constants` VALUES (29, 'Home');
43 INSERT INTO `lang_constants` VALUES (30, 'Patient Notes');
44 INSERT INTO `lang_constants` VALUES (31, 'Authorizations');
45 INSERT INTO `lang_constants` VALUES (32, '(More)');
46 INSERT INTO `lang_constants` VALUES (33, 'Find Patient');
47 INSERT INTO `lang_constants` VALUES (34, 'New Patient');
48 INSERT INTO `lang_constants` VALUES (35, 'Name');
49 INSERT INTO `lang_constants` VALUES (36, 'ID');
50 INSERT INTO `lang_constants` VALUES (37, 'DOB');
51 INSERT INTO `lang_constants` VALUES (38, 'and');
52 INSERT INTO `lang_constants` VALUES (39, 'Patient Appointment');
53 INSERT INTO `lang_constants` VALUES (40, '(Notes and Authorizations)');
54 INSERT INTO `lang_constants` VALUES (41, 'Search');
55 INSERT INTO `lang_constants` VALUES (42, 'Category');
56 INSERT INTO `lang_constants` VALUES (43, 'Date');
57 INSERT INTO `lang_constants` VALUES (44, 'Title');
58 INSERT INTO `lang_constants` VALUES (45, 'Patient');
59 INSERT INTO `lang_constants` VALUES (46, 'Provider');
60 INSERT INTO `lang_constants` VALUES (47, 'Comments');
61 INSERT INTO `lang_constants` VALUES (48, 'duration');
62 INSERT INTO `lang_constants` VALUES (49, 'Records Found');
63 INSERT INTO `lang_constants` VALUES (50, '(New Patient)');
64 INSERT INTO `lang_constants` VALUES (51, 'All day event');
65 INSERT INTO `lang_constants` VALUES (52, 'Time');
66 INSERT INTO `lang_constants` VALUES (53, 'minutes');
67 INSERT INTO `lang_constants` VALUES (54, 'day');
68 INSERT INTO `lang_constants` VALUES (55, 'Repeats');
69 INSERT INTO `lang_constants` VALUES (56, 'until');
78 # http://www.phpmyadmin.net
81 # Generation Time: Feb 14, 2006 at 09:21 AM
82 # Server version: 4.1.12
83 # PHP Version: 4.4.0-3ubuntu1
85 # Database : `openemr`
89 # Dumping data for table `lang_definitions`
92 INSERT INTO `lang_definitions` VALUES (1, 6, 3, 'Grupo');
93 INSERT INTO `lang_definitions` VALUES (2, 8, 3, 'Usuario:');
94 INSERT INTO `lang_definitions` VALUES (5, 10, 3, 'EOB Posting - Instrucciones');
95 INSERT INTO `lang_definitions` VALUES (6, 11, 3, 'Codigo Postal');
96 INSERT INTO `lang_definitions` VALUES (7, 12, 3, 'Apellido');
97 INSERT INTO `lang_definitions` VALUES (8, 18, 3, 'Hasta:');
98 INSERT INTO `lang_definitions` VALUES (9, 17, 3, 'Edades desde:');
99 INSERT INTO `lang_definitions` VALUES (10, 15, 3, 'Fecha de Cita');
100 INSERT INTO `lang_definitions` VALUES (11, 16, 3, 'Herramienta de Comunicaciones');
101 INSERT INTO `lang_definitions` VALUES (12, 14, 3, 'Femenino');
102 INSERT INTO `lang_definitions` VALUES (13, 13, 3, 'Masculino');
103 INSERT INTO `lang_definitions` VALUES (14, 19, 3, 'Seguro Social');
104 INSERT INTO `lang_definitions` VALUES (15, 20, 3, 'Administracion de Usuarios y Grupos');
105 INSERT INTO `lang_definitions` VALUES (16, 21, 3, 'Salir');
106 INSERT INTO `lang_definitions` VALUES (17, 22, 3, 'Contrase�:');
107 INSERT INTO `lang_definitions` VALUES (18, 23, 3, 'Entrar');
108 INSERT INTO `lang_definitions` VALUES (19, 24, 3, 'Administraci�');
109 INSERT INTO `lang_definitions` VALUES (20, 25, 3, 'Contrase�');
110 INSERT INTO `lang_definitions` VALUES (21, 28, 3, 'Facturaci�');
111 INSERT INTO `lang_definitions` VALUES (22, 29, 3, 'Inicio');
112 INSERT INTO `lang_definitions` VALUES (23, 27, 3, 'Notas');
113 INSERT INTO `lang_definitions` VALUES (24, 26, 3, 'Informes');
114 INSERT INTO `lang_definitions` VALUES (25, 32, 3, '(M�)');
115 INSERT INTO `lang_definitions` VALUES (26, 31, 3, 'Autorizaci�es');
116 INSERT INTO `lang_definitions` VALUES (27, 33, 3, 'Localizar Paciente');
117 INSERT INTO `lang_definitions` VALUES (28, 30, 3, 'Notas de Paciente');
118 INSERT INTO `lang_definitions` VALUES (29, 34, 3, 'Paciente Nuevo');
119 INSERT INTO `lang_definitions` VALUES (30, 37, 3, 'Fecha Nacimiento');
120 INSERT INTO `lang_definitions` VALUES (31, 36, 3, 'Num Expediente');
121 INSERT INTO `lang_definitions` VALUES (32, 35, 3, 'Nombre');
122 INSERT INTO `lang_definitions` VALUES (33, 38, 3, 'y');
123 INSERT INTO `lang_definitions` VALUES (34, 39, 3, 'Cita(s) del Paciente');
124 INSERT INTO `lang_definitions` VALUES (35, 40, 3, '(Notas y Autorizaciones)');
125 INSERT INTO `lang_definitions` VALUES (36, 41, 3, 'Bsqueda');
126 INSERT INTO `lang_definitions` VALUES (37, 42, 3, 'Categor�');
127 INSERT INTO `lang_definitions` VALUES (38, 43, 3, 'Fecha');
128 INSERT INTO `lang_definitions` VALUES (39, 44, 3, 'T�ulo');
129 INSERT INTO `lang_definitions` VALUES (40, 45, 3, 'Paciente');
130 INSERT INTO `lang_definitions` VALUES (41, 46, 3, 'M�ico');
131 INSERT INTO `lang_definitions` VALUES (42, 47, 3, 'Notas');
132 INSERT INTO `lang_definitions` VALUES (43, 48, 3, 'Duraci�');
133 INSERT INTO `lang_definitions` VALUES (44, 49, 3, 'Expedientes Localizado');
134 INSERT INTO `lang_definitions` VALUES (45, 50, 3, '(Paciente Nuevo)');
135 INSERT INTO `lang_definitions` VALUES (46, 51, 3, 'D� completo');
136 INSERT INTO `lang_definitions` VALUES (47, 52, 3, 'Hora');
137 INSERT INTO `lang_definitions` VALUES (48, 53, 3, 'Minutos');
138 INSERT INTO `lang_definitions` VALUES (49, 54, 3, 'D�');
139 INSERT INTO `lang_definitions` VALUES (50, 55, 3, 'Repite');
140 INSERT INTO `lang_definitions` VALUES (51, 56, 3, 'Hasta');
141 INSERT INTO `lang_definitions` VALUES (52, 57, 3, 'Ver Todos');
142 INSERT INTO `lang_definitions` VALUES (53, 58, 3, 'M�');
143 INSERT INTO `lang_definitions` VALUES (54, 59, 3, 'Localizar Paciente');
144 INSERT INTO `lang_definitions` VALUES (55, 60, 3, 'Favor de ingresar datos');
145 INSERT INTO `lang_definitions` VALUES (56, 61, 3, 'Escoja Paciente');
146 INSERT INTO `lang_definitions` VALUES (57, 62, 3, 'por');
147 INSERT INTO `lang_definitions` VALUES (58, 63, 3, 'Apellido');
148 INSERT INTO `lang_definitions` VALUES (59, 64, 3, 'Volver');
149 INSERT INTO `lang_definitions` VALUES (60, 65, 3, 'Primer Nombre');
150 INSERT INTO `lang_definitions` VALUES (61, 66, 3, 'Segundo Nombre');
151 INSERT INTO `lang_definitions` VALUES (62, 67, 3, 'Nmero de Expediente');
152 INSERT INTO `lang_definitions` VALUES (63, 68, 3, 'Omitir para Autoasignaci�');
153 INSERT INTO `lang_definitions` VALUES (64, 69, 3, 'Usuario');
154 INSERT INTO `lang_definitions` VALUES (65, 70, 3, 'Informaci� de Nuevas Facilidades');
155 INSERT INTO `lang_definitions` VALUES (66, 71, 3, 'Pa�');
156 INSERT INTO `lang_definitions` VALUES (67, 72, 3, 'Direcci�');
157 INSERT INTO `lang_definitions` VALUES (69, 74, 3, 'Estado');
158 INSERT INTO `lang_definitions` VALUES (70, 75, 3, 'Ciudad');
159 INSERT INTO `lang_definitions` VALUES (71, 76, 3, 'Seguro Social Patronal');
160 INSERT INTO `lang_definitions` VALUES (72, 77, 3, 'Acepta Facturaci�');
161 INSERT INTO `lang_definitions` VALUES (73, 78, 3, 'Centro de Facturaci�');
162 INSERT INTO `lang_definitions` VALUES (74, 79, 3, 'Aplicable si es Centro de Facturaci�');
163 INSERT INTO `lang_definitions` VALUES (75, 80, 3, 'Cod�o de Lugar de Servic�');
164 INSERT INTO `lang_definitions` VALUES (76, 81, 3, 'Facturas a Nombre');
165 INSERT INTO `lang_definitions` VALUES (77, 82, 3, 'C�igo de Laboratorio Cl�ico');
166 INSERT INTO `lang_definitions` VALUES (78, 83, 3, 'Tel�ono');
167 INSERT INTO `lang_definitions` VALUES (79, 84, 3, 'como');
168 INSERT INTO `lang_definitions` VALUES (80, 85, 3, 'Editar Informaci� de Facilidades');
169 INSERT INTO `lang_definitions` VALUES (81, 86, 3, 'Informaci� de Facilidades');
170 INSERT INTO `lang_definitions` VALUES (82, 87, 3, 'Actualizar');
171 INSERT INTO `lang_definitions` VALUES (83, 88, 3, 'Administracion de Usuarios');
172 INSERT INTO `lang_definitions` VALUES (84, 89, 3, 'Usuario');
173 INSERT INTO `lang_definitions` VALUES (85, 90, 3, 'Autorizado');
174 INSERT INTO `lang_definitions` VALUES (86, 91, 3, 'Nmero de Identifcaci� Federal');
175 INSERT INTO `lang_definitions` VALUES (87, 92, 3, 'Ver Autorizaciones');
176 INSERT INTO `lang_definitions` VALUES (88, 93, 3, 'Ninguno');
177 INSERT INTO `lang_definitions` VALUES (89, 94, 3, 'Mio Solamente');
178 INSERT INTO `lang_definitions` VALUES (90, 95, 3, 'Todos');
179 INSERT INTO `lang_definitions` VALUES (91, 96, 3, 'Informaci� Addicional');
180 INSERT INTO `lang_definitions` VALUES (92, 97, 3, 'Guardar Cambios');
181 INSERT INTO `lang_definitions` VALUES (93, 98, 3, 'Dejar en Blanco para no cambiar contrase�');
182 INSERT INTO `lang_definitions` VALUES (94, 99, 3, 'Nombre de Cl�ica');
183 INSERT INTO `lang_definitions` VALUES (95, 100, 3, 'Nombre de Grupo');
184 INSERT INTO `lang_definitions` VALUES (96, 101, 3, 'Usuario Inicial');
185 INSERT INTO `lang_definitions` VALUES (97, 102, 3, 'Usuario');
186 INSERT INTO `lang_definitions` VALUES (98, 103, 3, 'Modificar');
187 INSERT INTO `lang_definitions` VALUES (99, 104, 3, 'Nombre Real');
188 INSERT INTO `lang_definitions` VALUES (100, 105, 3, 'Informaci�');
189 INSERT INTO `lang_definitions` VALUES (101, 106, 3, 'si');
190 INSERT INTO `lang_definitions` VALUES (102, 107, 3, 'Salir de Administraci�');
191 INSERT INTO `lang_definitions` VALUES (103, 108, 3, 'Ver Registro');
192 INSERT INTO `lang_definitions` VALUES (104, 109, 3, 'Registro');
193 INSERT INTO `lang_definitions` VALUES (105, 110, 3, 'Idioma');
194 INSERT INTO `lang_definitions` VALUES (106, 111, 3, 'Base de Datos');
195 INSERT INTO `lang_definitions` VALUES (107, 116, 3, 'Communicaci�');
196 INSERT INTO `lang_definitions` VALUES (108, 112, 3, 'Calendario');
197 INSERT INTO `lang_definitions` VALUES (109, 114, 3, 'Formularios');
198 INSERT INTO `lang_definitions` VALUES (110, 113, 3, 'Consultorio');
199 INSERT INTO `lang_definitions` VALUES (111, 115, 3, 'Usuarios y Grupos');
200 INSERT INTO `lang_definitions` VALUES (112, 117, 3, 'Modificar Facilidades');
201 INSERT INTO `lang_definitions` VALUES (113, 118, 3, 'Usuario Nuevo');
202 INSERT INTO `lang_definitions` VALUES (114, 119, 3, 'Grupo Nuevo');
203 INSERT INTO `lang_definitions` VALUES (115, 120, 3, 'Agrega Usuario a Grupo');
204 INSERT INTO `lang_definitions` VALUES (116, 121, 3, 'D� Laboral');
205 INSERT INTO `lang_definitions` VALUES (117, 123, 3, 'mes');
206 INSERT INTO `lang_definitions` VALUES (118, 122, 3, 'semana');
207 INSERT INTO `lang_definitions` VALUES (119, 124, 3, 'a�');
208 INSERT INTO `lang_definitions` VALUES (120, 126, 3, '2ndo');
209 INSERT INTO `lang_definitions` VALUES (121, 127, 3, '3er');
210 INSERT INTO `lang_definitions` VALUES (122, 128, 3, '4to');
211 INSERT INTO `lang_definitions` VALUES (123, 129, 3, '5to');
212 INSERT INTO `lang_definitions` VALUES (124, 130, 3, '6to');
213 INSERT INTO `lang_definitions` VALUES (125, 125, 3, 'cada');
214 INSERT INTO `lang_definitions` VALUES (126, 131, 3, 'Localizar');
215 INSERT INTO `lang_definitions` VALUES (127, 132, 3, 'Cancelar');
216 INSERT INTO `lang_definitions` VALUES (128, 133, 3, 'Guardar');
217 INSERT INTO `lang_definitions` VALUES (129, 134, 3, 'Eliminar');
218 INSERT INTO `lang_definitions` VALUES (130, 135, 3, 'Registro');
219 INSERT INTO `lang_definitions` VALUES (131, 136, 3, 'Evento');
220 INSERT INTO `lang_definitions` VALUES (132, 137, 3, 'Atenci�');
221 INSERT INTO `lang_definitions` VALUES (133, 138, 3, 'Registrado');
222 INSERT INTO `lang_definitions` VALUES (134, 139, 3, 'No Registrado');
223 INSERT INTO `lang_definitions` VALUES (135, 140, 3, 'Administraci� de Formularios');
224 INSERT INTO `lang_definitions` VALUES (136, 142, 3, 'desactivado');
225 INSERT INTO `lang_definitions` VALUES (137, 141, 3, 'activado');
226 INSERT INTO `lang_definitions` VALUES (138, 143, 3, 'Instalado');
227 INSERT INTO `lang_definitions` VALUES (139, 144, 3, 'PHP descomprimido');
228 INSERT INTO `lang_definitions` VALUES (140, 145, 3, 'Instalar');
229 INSERT INTO `lang_definitions` VALUES (141, 146, 3, 'Informe de Facturaci�');
230 INSERT INTO `lang_definitions` VALUES (142, 147, 3, 'Notas Oficiales');
231 INSERT INTO `lang_definitions` VALUES (143, 149, 3, 'Activos');
232 INSERT INTO `lang_definitions` VALUES (144, 150, 3, 'Inactivos');
233 INSERT INTO `lang_definitions` VALUES (145, 148, 3, 'Ver');
234 INSERT INTO `lang_definitions` VALUES (146, 151, 3, 'Modificar Actividad');
235 INSERT INTO `lang_definitions` VALUES (147, 152, 3, 'Agregar Nota Nueva');
236 INSERT INTO `lang_definitions` VALUES (148, 153, 3, 'Modificar Contrase�');
237 INSERT INTO `lang_definitions` VALUES (149, 154, 3, 'Al cambiar su contrase�, Re-valida.');
238 INSERT INTO `lang_definitions` VALUES (150, 155, 3, 'Nuevamente');
239 INSERT INTO `lang_definitions` VALUES (151, 156, 3, 'O');
240 INSERT INTO `lang_definitions` VALUES (152, 157, 3, 'Sexo');
241 INSERT INTO `lang_definitions` VALUES (153, 158, 3, 'Formato');
242 INSERT INTO `lang_definitions` VALUES (154, 159, 3, 'Citado entre');
243 INSERT INTO `lang_definitions` VALUES (155, 160, 3, 'Visto desde');
244 INSERT INTO `lang_definitions` VALUES (156, 161, 3, 'No visto desde');
245 INSERT INTO `lang_definitions` VALUES (157, 162, 3, 'Organizado por');
246 INSERT INTO `lang_definitions` VALUES (158, 163, 3, 'Correo Electronico por');
247 INSERT INTO `lang_definitions` VALUES (159, 164, 3, 'Tema de Correo Electronico');
248 INSERT INTO `lang_definitions` VALUES (160, 165, 3, 'Texto de Correo Electronico, Utiliza formato de Tag: ***NAME*** , eg. Saludos ***NAME***');
249 INSERT INTO `lang_definitions` VALUES (161, 166, 3, 'Processo Lento');
250 INSERT INTO `lang_definitions` VALUES (162, 167, 3, 'Solamente para uso de Correo Electronico a pacientes');
251 INSERT INTO `lang_definitions` VALUES (163, 168, 3, 'Edad desde');
252 INSERT INTO `lang_definitions` VALUES (164, 169, 3, 'Hasta');
253 INSERT INTO `lang_definitions` VALUES (165, 171, 3, 'Contacto');
254 INSERT INTO `lang_definitions` VALUES (166, 172, 3, 'No enviado por error con servidor');
255 INSERT INTO `lang_definitions` VALUES (167, 173, 3, 'Correo Electronico no enviado');
256 INSERT INTO `lang_definitions` VALUES (168, 170, 3, 'Empleo');
257 INSERT INTO `lang_definitions` VALUES (169, 174, 3, 'Ignorar HIPAA');
258 INSERT INTO `lang_definitions` VALUES (170, 175, 3, 'Archivo CSV');
259 INSERT INTO `lang_definitions` VALUES (171, 177, 3, 'Correo Electr�ico');
260 INSERT INTO `lang_definitions` VALUES (172, 176, 3, 'Lista de llamadas telef�icas');
261 INSERT INTO `lang_definitions` VALUES (173, 178, 3, 'Cualquier');
264 ## alters to categorize forms / per Mark
266 ALTER TABLE registry ADD COLUMN priority INT DEFAULT 0 AFTER date;
267 ALTER TABLE registry ADD COLUMN category VARCHAR(255) DEFAULT "category" AFTER priority;
268 ALTER TABLE registry ADD COLUMN nickname VARCHAR(255) DEFAULT '' AFTER category;
270 ALTER TABLE patient_data
271 ADD phone_pharmacy varchar(255) NOT NULL default '';
273 ## array table for storing configuration data and string lists etc...
275 CREATE TABLE `array` (
276 `array_key` varchar(255) default NULL,
277 `array_value` longtext
280 ALTER TABLE patient_data
281 ADD drivers_license varchar(255) NOT NULL default '';
283 ALTER TABLE form_vitals
284 MODIFY oxygen_saturation float(5,2) default 0;
287 drug_id int(11) NOT NULL auto_increment,
288 name varchar(255) NOT NULL DEFAULT '',
289 ndc_number varchar(20) NOT NULL DEFAULT '',
290 on_order int(11) NOT NULL DEFAULT 0,
291 reorder_point int(11) NOT NULL DEFAULT 0,
292 last_notify date NOT NULL DEFAULT '0000-00-00',
293 reactions text NOT NULL DEFAULT '',
294 form int(3) NOT NULL DEFAULT 0,
295 size int(11) NOT NULL DEFAULT 0,
296 unit int(11) NOT NULL DEFAULT 0,
297 route int(11) NOT NULL DEFAULT 0,
298 substitute int(11) NOT NULL DEFAULT 0,
299 PRIMARY KEY (drug_id)
302 CREATE TABLE drug_inventory (
303 inventory_id int(11) NOT NULL auto_increment,
304 drug_id int(11) NOT NULL,
305 lot_number varchar(20) NOT NULL DEFAULT '',
306 expiration date DEFAULT NULL,
307 manufacturer varchar(255) NOT NULL DEFAULT '',
308 on_hand int(11) NOT NULL DEFAULT 0,
309 last_notify date NOT NULL DEFAULT '0000-00-00',
310 PRIMARY KEY (inventory_id)
313 CREATE TABLE drug_sales (
314 sale_id int(11) NOT NULL auto_increment,
315 drug_id int(11) NOT NULL,
316 inventory_id int(11) NOT NULL,
317 prescription_id int(11) NOT NULL DEFAULT 0,
318 pid int(11) NOT NULL DEFAULT 0,
319 encounter int(11) NOT NULL DEFAULT 0,
320 user varchar(255) NOT NULL DEFAULT '',
321 sale_date date NOT NULL,
322 quantity int(11) NOT NULL DEFAULT 0,
323 fee decimal(7,2) NOT NULL DEFAULT 0.00,
324 PRIMARY KEY (sale_id)
327 ALTER TABLE prescriptions
328 ADD drug_id int(11) NOT NULL DEFAULT 0;
330 ALTER TABLE patient_data
331 ADD pharmacy_id int(11) NOT NULL DEFAULT 0,
332 ADD referral_source varchar(30) NOT NULL DEFAULT '';
334 #new options in lang tables
335 INSERT INTO `lang_languages` (`lang_id`, `lang_code`, `lang_description`) VALUES (4, 'de', 'German');
336 INSERT INTO `lang_languages` (`lang_id`, `lang_code`, `lang_description`) VALUES (5, 'du', 'Dutch');
337 INSERT INTO `lang_languages` (`lang_id`, `lang_code`, `lang_description`) VALUES (6, 'he', 'Hebrew');
339 ALTER TABLE openemr_postcalendar_events
340 ADD pc_prefcatid int(11) NOT NULL DEFAULT 0;
342 # Option to deal with prescriptions on the medication list
343 ALTER TABLE prescriptions
344 ADD medication int(11);
346 # Add fax to facility table
348 ADD fax varchar(30) default NULL;
350 CREATE TABLE drug_templates (
351 drug_id int(11) NOT NULL,
352 selector varchar(255) NOT NULL,
353 dosage varchar(10) NOT NULL DEFAULT '',
354 period int(11) NOT NULL DEFAULT 0,
355 quantity int(11) NOT NULL DEFAULT 0,
356 refills int(11) NOT NULL DEFAULT 0,
357 PRIMARY KEY (drug_id, selector)
360 ALTER TABLE drug_inventory
361 ADD destroy_date date DEFAULT NULL,
362 ADD destroy_method varchar(255) NOT NULL DEFAULT '',
363 ADD destroy_witness varchar(255) NOT NULL DEFAULT '',
364 ADD destroy_notes varchar(255) NOT NULL DEFAULT '';
366 ALTER TABLE prescriptions
367 MODIFY `size` float unsigned DEFAULT NULL;
370 MODIFY `size` float unsigned NOT NULL DEFAULT 0;
372 ALTER TABLE form_encounter
373 ADD sensitivity varchar(30) NOT NULL DEFAULT '';
376 ADD returndate date DEFAULT NULL;
379 ADD active tinyint(1) NOT NULL DEFAULT 1,
380 ADD npi varchar(15) NOT NULL DEFAULT '',
381 ADD specialty varchar(255) NOT NULL DEFAULT '',
382 ADD billname varchar(255) NOT NULL DEFAULT '',
383 ADD email varchar(255) NOT NULL DEFAULT '',
384 ADD url varchar(255) NOT NULL DEFAULT '',
385 ADD street varchar(60) NOT NULL DEFAULT '',
386 ADD city varchar(30) NOT NULL DEFAULT '',
387 ADD state varchar(30) NOT NULL DEFAULT '',
388 ADD zip varchar(20) NOT NULL DEFAULT '',
389 ADD phone varchar(30) NOT NULL DEFAULT '',
390 ADD fax varchar(30) NOT NULL DEFAULT '',
391 ADD title varchar(30) NOT NULL DEFAULT '',
392 ADD phonew1 varchar(30) NOT NULL DEFAULT '',
393 ADD phonew2 varchar(30) NOT NULL DEFAULT '',
394 ADD phonecell varchar(30) NOT NULL DEFAULT '',
395 ADD assistant varchar(255) NOT NULL DEFAULT '',
396 ADD street2 varchar(60) NOT NULL DEFAULT '',
397 ADD city2 varchar(30) NOT NULL DEFAULT '',
398 ADD state2 varchar(30) NOT NULL DEFAULT '',
399 ADD zip2 varchar(20) NOT NULL DEFAULT '';
401 ALTER TABLE patient_data
402 ADD `hipaa_notice` VARCHAR(3) DEFAULT 'NO' NOT NULL,
403 ADD `hipaa_message` VARCHAR(20);
405 ALTER TABLE prescriptions
406 MODIFY `dosage` varchar(100) DEFAULT NULL,
407 MODIFY `quantity` varchar(11) DEFAULT NULL;