Subversion Repositories delphiutils

USE [ZEITERFASSUNG]

GO

/****** Object:  Table [dbo].[TAGE]    Script Date: 15.02.2019 15:16:14 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[TAGE](

        [TAG] [DATE] NOT NULL,

        [USERNAME] [VARCHAR](100) NOT NULL,

        [FREIER_TAG] [bit] NULL,

        [KOMMEN] [TIME](0) NULL,

        [PAUSE_START] [TIME](0) NULL,

        [PAUSE_ENDE] [TIME](0) NULL,

        [GEHEN] [TIME](0) NULL,

        [SONSTIGER_ABZUG] [TIME](0) NULL,

        [ZUHAUSE] [TIME](0) NULL,

        [ÜBERSTUNDEN] [INT] NULL,

        [ÜBERSTUNDEN_SALDO] [INT] NULL,

 CONSTRAINT [PK_KOPF] PRIMARY KEY CLUSTERED

(

        [TAG] ASC,

        [USERNAME] ASC

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

) ON [PRIMARY]

GO