/****** Object: Table [dbo].[LOGBOOK] Script Date: 6/23/2016 2:02:33 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[LOGBOOK]( [SEQ] [int] NULL, [AID] [int] NULL, [NAME] [char](48) NULL, [MSG] [char](128) NULL, [OPR] [char](48) NULL ) ON [PRIMARY] GO /****** Object: Index [LOGBOOK_1] Script Date: 6/23/2016 2:02:33 PM ******/ CREATE NONCLUSTERED INDEX [LOGBOOK_1] ON [dbo].[LOGBOOK] ( [SEQ] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO