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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
drop table o_gnats;
create table o_gnats (
gnatsid char(8),
category char(16),
synopsis char(128),
confidential char(3),
severity integer,
priority integer,
respengr char(16),
gnatsstate integer,
gnatsclass integer,
customer char(16),
arrival datetime year to minute,
age interval day(5) to hour,
custcontact char(64),
release char(64)
);
create unique index o_gnats_prid
on o_gnats(gnatsid);
create index o_gnats_cat
on o_gnats(category);
create index o_gnats_resp
on o_gnats(respengr);
create index o_gnats_cust
o_gnats(customer);
revoke insert, delete, update, references, index, alter on o_gnats from public;
drop table buf_gnats;
create table buf_gnats (
gnatsid char(8),
category char(16),
synopsis char(128),
confidential char(3),
severity integer,
priority integer,
respengr char(16),
gnatsstate integer,
gnatsclass integer,
customer char(16),
arrival datetime year to minute,
age interval day(5) to hour,
custcontact char(64),
release char(64)
);
create unique index buf_gnats_prid
on buf_gnats(gnatsid);
create index buf_gnats_cat
on buf_gnats(category);
create index buf_gnats_resp
on buf_gnats(respengr);
create index buf_gnats_cust
buf_gnats(customer);
revoke insert, delete, update, references, index, alter on buf_gnats from public;
|
