It is an hour later and the record count is up to 367425 in the uuid registry table.
In the attached file, the last table to be added was list. The list table has 35093 records. The uuid registry has 35094 entries.
I am looking at the 5_0_2-to-6_0_0_upgrade.sql file and it seems the next table to get UUID’s is the documents table that has 27519 records in it.
In between these two entries, I downloaded the rel 600 and applied that code to openemr folder and restarted the upgrade from where the previous attempt was halted. I was expecting the system to fly through the rest. It did not.
@mdsupport where can I find a list of tables that will be getting the UUID columns. This is what I came up with. Is it right?
patient data ALTER TABLE `patient_data` ADD `uuid` binary(16) DEFAULT NULL; CREATE UNIQUE INDEX `uuid` ON `patient_data` (`uuid`);
form_encounter ALTER TABLE `form_encounter` ADD `uuid` binary(16) DEFAULT NULL; CREATE UNIQUE INDEX `uuid` ON `form_encounter` (`uuid`);
users ALTER TABLE `users` ADD `uuid` binary(16) DEFAULT NULL; CREATE UNIQUE INDEX `uuid` ON `users` (`uuid`);
facility ALTER TABLE `facility` ADD `uuid` binary(16) DEFAULT NULL; CREATE UNIQUE INDEX `uuid` ON `facility` (`uuid`);
immunizations ALTER TABLE `immunizations` ADD `uuid` binary(16) DEFAULT NULL; CREATE UNIQUE INDEX `uuid` ON `immunizations` (`uuid`);
lists ALTER TABLE `lists` ADD `uuid` binary(16) DEFAULT NULL; CREATE UNIQUE INDEX `uuid` ON `lists` (`uuid`);
ccda ALTER TABLE `ccda` ADD `uuid` binary(16) DEFAULT NULL; CREATE UNIQUE INDEX `uuid` ON `ccda` (`uuid`);
document ALTER TABLE `documents` ADD `drive_uuid` binary(16) DEFAULT NULL; CREATE UNIQUE INDEX `drive_uuid` ON `documents` (`drive_uuid`);
facility_user_ids ALTER TABLE `facility_user_ids` ADD `uuid` binary(16) DEFAULT NULL; CREATE INDEX `uuid` ON `facility_user_ids` (`uuid`);
drugs ALTER TABLE `drugs` ADD `uuid` binary(16) DEFAULT NULL; CREATE UNIQUE INDEX `uuid` ON `drugs` (`uuid`);
prescriptions ALTER TABLE `prescriptions` ADD `uuid` binary(16) DEFAULT NULL; CREATE UNIQUE INDEX `uuid` ON `prescriptions` (`uuid`);
procedure_order ALTER TABLE `procedure_order` ADD `uuid` binary(16) DEFAULT NULL; CREATE UNIQUE INDEX `uuid` ON `procedure_order` (`uuid`);
procedure_results ALTER TABLE `procedure_result` ADD `uuid` binary(16) DEFAULT NULL;
BTW, the graphical interface does not work. I am counting on service to continue to run even though the interface is not.
database_reading.txt (2.3 KB)