USE users
go

--run tables/DeviceConfiguration.sql script

--move contents of mm905 table into DeviceConfiguration.

SELECT
        ipAddressNumber,
        destIpAddress,
        destPort,
        exceptionTiming,
        stillTiming,
        movingTiming,
        ignitionHours,
        stoppedTiming,
        voltageThreshold,
        rssiThreshold,
        minSpeed,
        coldTempProbe1,
        hotTempProbe1,
        coldTempProbe2,
        hotTempProbe2,
        readTimeSw1,
        readTimeSw2,
        readTimeSw3,
        readTimeSw4,
        readTimeSw5,
        readTimeSw6,
        readTimeSw7,
        readTimeSw8,
        inputSwExceptions,
        miscIOExceptions,
        output1,
        output2,
        output3,
        output4,
        swRev,
        hwRev,
        gpsFirmwareRev
        gpsType,
        iButtonConfigOptions,
        iButtonOutput1,
        iButtonOutput2,
        timingCmdUpdate,
        temperatureCmdUpdate,
        ioCmdUpdate,
        revisionCmdUpdate
INTO dbo.DeviceConfiguration
FROM dbo.mm905
WHERE ipaddressnumber IS not null