/****** Object:  Index [Park_InOutData001]    Script Date: 11/01/2023 09:42:28 ******/

IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Park_InOutData]') AND name = N'Park_InOutData001')

DROP INDEX [Park_InOutData001] ON [dbo].[Park_InOutData] WITH ( ONLINE = OFF )

GO

alter table Park_InOutData

drop column CardInOutID

go

alter table Park_InOutData

drop column TempInOutID

go

alter table Park_InOutData

add CardInOutID bigint IDENTITY(1,1) NOT NULL

go

alter table Park_InOutData

add TempInOutID [bigint] NULL

go

/****** Object:  Index [Park_InOutData001]    Script Date: 11/01/2023 09:42:28 ******/

CREATE CLUSTERED INDEX [Park_InOutData001] ON [dbo].[Park_InOutData] 

(

[CardInOutID] ASC,

[CardNo] ASC,

[CardMaterial] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

GO