-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathNTPLOG00.SQL
More file actions
53 lines (45 loc) · 2.2 KB
/
Copy pathNTPLOG00.SQL
File metadata and controls
53 lines (45 loc) · 2.2 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
/*-------------------------------------------------------------------*/
/* */
/* Table NTP-Logging */
/* */
/*----------------* */
/* R.Ross 05.2025 * */
/*-------------------------------------------------------------------*/
create or replace table NTPLOG00 (
Id int generated always as identity,
Date timestamp not null default '0001-01-01',
User char(10) not null default,
Program char(10) not null default,
Type smallint not null default,
Runtime dec(9, 3) not null default,
Message char(256) not null default
);
/*-------------------------------------------------------------------*/
/* Column Label */
/*-------------------------------------------------------------------*/
Label on Column NTPLOG00 (
Id is 'Id',
Date is 'Date',
User is 'User',
Program is 'Program',
Type is 'Type',
Runtime is 'Runtime',
Message is 'Message'
);
/*-------------------------------------------------------------------*/
/* Text Label */
/*-------------------------------------------------------------------*/
Label on Column NTPLOG00 (
Id text is 'Id',
Date text is 'Date',
User text is 'User',
Program text is 'Program',
Type text is 'Type',
Runtime text is 'Runtime',
Message text is 'Message'
);
/*-------------------------------------------------------------------*/
/* Label */
/*-------------------------------------------------------------------*/
Label on Table NTPLOG00 is 'Table NTP-Logging';
/*-------------------------------------------------------------------*/