Subversion Repositories delphiutils

Rev

Rev 78 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
78 daniel-mar 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,
79 daniel-mar 23 
        [BEMERKUNG] [VARCHAR](100) NOT NULL,
78 daniel-mar 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