Wavetronix Command Translator (CMD-DT) - User Guide - Manual (Page 56)

CHAPTER 4 • ROUTES PAGE 55
06/15/2011 10:27:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Segments](
[Timestamp] [datetime] NOT NULL,
[RouteId] [varchar](250) NOT NULL,
[SegmentId] [varchar](250) NOT NULL,
[TravelTime] [int] NOT NULL,
[Volume] [int] NULL,
[Occupancy] [decimal](18, 0) NULL,
[DataType] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
<<<<< End Script - Copy above this line >>>>>