Subversion Repositories delphiutils

Rev

Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed

  1. USE [ZEITERFASSUNG]
  2. GO
  3.  
  4. /****** Object:  Table [dbo].[TAGE]    Script Date: 15.02.2019 15:16:14 ******/
  5. SET ANSI_NULLS ON
  6. GO
  7.  
  8. SET QUOTED_IDENTIFIER ON
  9. GO
  10.  
  11. CREATE TABLE [dbo].[TAGE](
  12.         [TAG] [DATE] NOT NULL,
  13.         [USERNAME] [VARCHAR](100) NOT NULL,
  14.         [FREIER_TAG] [bit] NULL,
  15.         [KOMMEN] [TIME](0) NULL,
  16.         [PAUSE_START] [TIME](0) NULL,
  17.         [PAUSE_ENDE] [TIME](0) NULL,
  18.         [GEHEN] [TIME](0) NULL,
  19.         [SONSTIGER_ABZUG] [TIME](0) NULL,
  20.         [ZUHAUSE] [TIME](0) NULL,
  21.         [ÜBERSTUNDEN] [INT] NULL,
  22.         [ÜBERSTUNDEN_SALDO] [INT] NULL,
  23.  CONSTRAINT [PK_KOPF] PRIMARY KEY CLUSTERED
  24. (
  25.         [TAG] ASC,
  26.         [USERNAME] ASC
  27. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  28. ) ON [PRIMARY]
  29. GO
  30.  
  31.  
  32.