Subversion Repositories delphiutils

Rev

Rev 78 | 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.         [BEMERKUNG] [VARCHAR](100) NOT NULL,
  24.  CONSTRAINT [PK_KOPF] PRIMARY KEY CLUSTERED
  25. (
  26.         [TAG] ASC,
  27.         [USERNAME] ASC
  28. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  29. ) ON [PRIMARY]
  30. GO
  31.  
  32.  
  33.