CREATE TABLE VS4TSwitchTimeGpMB
	(
	TSWMTSWGNo nvarchar(30) NOT NULL,
	TSWMLn int NOT NULL,
	TSWMTEmGCode nvarchar(30) NULL,
	TSWMFromTWPDCode nvarchar(50) NULL,
	TSWMToTWPDCode nvarchar(50) NULL,
	TSWMSwitchFromDate datetime NULL,
	TSWMSwitchToDate datetime NULL,
	TSWMPayType smallint NULL,
	TSWMType smallint NULL,
	TSWMFromTime datetime NULL,
	TSWMFromTimeAddDay smallint NULL,
	TSWMToTime datetime NULL,
	TSWMToTimeAddDay smallint NULL,
	TSWMInTime1 datetime NULL,
	TSWMInTimeAddDay1 smallint NULL,
	TSWMInLate1 datetime NULL,
	TSWMInLateAddDay1 smallint NULL,
	TSWMOutTime1 datetime NULL,
	TSWMOutTimeAddDay1 smallint NULL,
	TSWMInTime2 datetime NULL,
	TSWMInTimeAddDay2 smallint NULL,
	TSWMInLate2 datetime NULL,
	TSWMInLateAddDay2 smallint NULL,
	TSWMOutTime2 datetime NULL,
	TSWMOutTimeAddDay2 smallint NULL,
	TSWMInTime3 datetime NULL,
	TSWMInTimeAddDay3 smallint NULL,
	TSWMInLate3 datetime NULL,
	TSWMInLateAddDay3 smallint NULL,
	TSWMOutTime3 datetime NULL,
	TSWMOutTimeAddDay3 smallint NULL,
	TSWMInTime4 datetime NULL,
	TSWMInTimeAddDay4 smallint NULL,
	TSWMInLate4 datetime NULL,
	TSWMInLateAddDay4 smallint NULL,
	TSWMOutTime4 nvarchar(5) NULL,
	TSWMOutTimeAddDay4 smallint NULL,
	TSWMPayShift smallint NULL,
	TSWMPayFood smallint NULL,
	TSWMPayFood2 smallint NULL,
	TSWMPayVehicle smallint NULL,
	TSWMPayStamp smallint NULL,
	TSWMPayStamp2 smallint NULL,
	TSWMPayStamp3 smallint NULL,
	TSWMFlag1 smallint NULL,
	TSWMFlag2 smallint NULL,
	TSWMFlag3 datetime NULL
	)  ON [PRIMARY]
GO
ALTER TABLE VS4TSwitchTimeGpMB ADD CONSTRAINT
	PK_VS4TSwitchTimeGpMB PRIMARY KEY CLUSTERED 
	(
	TSWMTSWGNo,
	TSWMLn
	) ON [PRIMARY]

GO

