DROP TABLE IF EXISTS `sm_devices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sm_devices` (
  `smrdId` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Id of the corresponding Devices row.',
  `smrdTerminalId` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Terminal Id.  Used to identify the device within the API',
  `smrdIMEI` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'IMEI number of the device',
  `smrdModel` int(11) NOT NULL COMMENT 'Model of the device.',
  `smrdState` int(11) NOT NULL DEFAULT '1' COMMENT 'State of the device.',
  `smrdCreatedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Date and time when the row was created.',
  `smrdUpdatedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Date and time when the row was last updated.',
  `smrdDeletedAt` datetime DEFAULT NULL COMMENT 'Date and time when the row was deleted.',
  `smrdSecurityId` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Security ID of the device, unique per hardware unit.',
  PRIMARY KEY (`smrdId`),
  KEY `IXFK_Devices_DeviceModels` (`smrdModel`),
  KEY `FK_sm_devices_SMDeviceStates` (`smrdState`),
  KEY `FK_SMDevices_SMDeviceSecurityIds` (`smrdSecurityId`),
  CONSTRAINT `FK_Devices_DeviceModels` FOREIGN KEY (`smrdModel`) REFERENCES `sm_device_models` (`smdmId`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_sm_devices_SMDeviceStates` FOREIGN KEY (`smrdState`) REFERENCES `SMDeviceStates` (`smdsId`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Registered devices';
/*!40101 SET character_set_client = @saved_cs_client */;

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.

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