17 lines
651 B
Plaintext
17 lines
651 B
Plaintext
|
CREATE TABLE [dbo].[SensorsCAN](
|
||
|
|
[Id] [int] IDENTITY(1,1) NOT NULL,
|
||
|
|
[SensorId] [int] NOT NULL,
|
||
|
|
[IsFD] bit NOT NULL,
|
||
|
|
[ArbBaseBitrate] int NOT NULL,
|
||
|
|
[ArbBaseSJW] int NOT NULL,
|
||
|
|
[DataBitrate] int NOT NULL,
|
||
|
|
[DataSJW] int NOT NULL,
|
||
|
|
[FileType] [nvarchar](max) NOT NULL,
|
||
|
|
[LastModified] [datetime] NOT NULL,
|
||
|
|
[LastModifiedBy] [nvarchar](50) NOT NULL,
|
||
|
|
[UserTags] [varbinary](max) NOT NULL,
|
||
|
|
[DoNotUse] [bit] NULL,
|
||
|
|
[Broken] [bit] NULL
|
||
|
|
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
|
||
|
|
|
||
|
|
INSERT INTO SensorsCAN VALUES((SELECT id FROM Sensors WHERE SerialNumber = 'TSF_TestSpecific'), 1, 1000000, 8, 8000000, 1, 'asc', '20251202', 'System', 0x, 0, 0)
|