Versions Compared

Old Version 4

changes.mady.by.user Alexandre MUNSCH

Saved on

compared with

New Version Current

changes.mady.by.user Alexandre MUNSCH

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
docker cp database:dump.sql dump.sql

Change the table names and columns and maybe the admin password…

Some tables have been renamed when moving to the new version of the product. In particular SMDevices changed into sm_devices and SMDeviceModels changed into sm_device_models. The dump.sql file need to be updated to reflect that change. This can be done either manually using a proper file editor or with some Linux-style commands such as:

...

The modification only consists in the addition of lines 13 and 17.

Then, for each device insertion, make sure to add a NULL value at the end.

Note

Careful:

  • The deletedAt field might not be present in the devices dump → add it if missing to match the number of columns or the injection is going to fail.

  • The deleteAt field might have a date in it → if you want to use that device, set the field to NULL.

Warning

For some reasons, the default admin password in the dump file is the same as the dev user. Please replace it by correct value.

Loading the old database content into the new one

...