Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- use users
- go
- --run tables/DeviceConfiguration.sql script
- --move contents of mm905 table into DeviceConfiguration.
- insert into dbo.DeviceConfiguration
- (
- IPAddressNumber,
- DestinationIPAddress,
- DestinationPort,
- ExceptionTiming,
- StillTiming,
- MovingTiming,
- IgnitionHours,
- StoppedTiming,
- VoltageThreshold,
- RSSIThreshold,
- MinSpeed,
- ColdTempProbe1,
- HotTempProbe1,
- ColdTempProbe2,
- HotTempProbe2,
- ReadTimeSwitch1,
- ReadTimeSwitch2,
- ReadTimeSwitch3,
- ReadTimeSwitch4,
- ReadTimeSwitch5,
- ReadTimeSwitch6,
- ReadTimeSwitch7,
- ReadTimeSwitch8,
- InputSwitchExceptions,
- MiscIOExceptions,
- Output1,
- Output2,
- Output3,
- Output4,
- SoftwareRev,
- HardwareRev,
- GPSFirmwareRev,
- GPSType,
- IButtonConfigOptions,
- IButtonOutput1,
- IButtonOutput2,
- LastTimingUpdateDate,
- LastTemperatureUpdateDate,
- LastIOReadingUpdateDate,
- LastRevisionUpdateDate
- )
- 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
- from dbo.mm905
- where ipaddressnumber is not null
- go
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement