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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
|
/* CreateControlTables.script 1.0 8-Mar-94 */
/* set nocount on */
print " "
go
print " "
go
use CTNControl
go
create table ApplicationEntity
( Title char(16) not null,
Node char(64) not null,
Port int null,
Comment char(80) null,
Organization char(32) not null
)
go
create unique index AE_Title_index
on ApplicationEntity(Title)
go
create index AE_Node_index
on ApplicationEntity(Node)
go
print "Created ApplicationEntity Table"
go
create table GroupNames
(
GroupName char(16) not null,
Title char(16) not null
)
go
create index GN_GroupName_index
on GroupNames(GroupName)
go
create index GN_Title_index
on GroupNames(Title)
go
print "Created GroupNames Table"
go
create table StorageAccess (
Title char(16) not null,
DbKey char(64) not null,
Owner char(16) null,
GroupName char(16) null,
Access int not null,
Comment char(80) null
)
go
create unique index SA_Title_index
on StorageAccess(Title)
go
print "Created StorageAccess Table"
go
create table StorageControl
(
RequestingTitle char(16) not null,
RespondingTitle char(16) not null,
Medium char(32) null,
Root char(255) not null,
NextDirectory char(255) null,
Access char(9) null
)
go
create index IMS_RequestingTitle_index
on StorageControl(RequestingTitle)
go
create index IMS_RespondingTitle_index
on StorageControl(RespondingTitle)
go
print "Created Storage Control Table"
go
create table SecurityMatrix
(
RequestingTitle char(16) not null,
RespondingTitle char(16) not null,
)
go
create index IMS_RequestingTitle_index
on SecurityMatrix(RequestingTitle)
go
create index IMS_RespondingTitle_index
on SecurityMatrix(RespondingTitle)
go
print "Created Security Matrix Table"
go
create table FISAccess (
Title char(16) not null,
DbKey char(64) not null,
Owner char(16) null,
GroupName char(16) null,
Access int null,
Comment char(80) null
)
go
create unique index FA_Title_index
on FISAccess(Title)
go
print "Created FISAccess Table"
go
create table PrintServerCFG
(
RequestingTitle char(16) not null,
RespondingTitle char(16) not null,
GQId int not null
)
go
print "Created PrintServerCFG Table"
go
create table VideoImageDest
(
RequestingTitle char(16) not null,
ImageType char(6) not null,
RespondingTitle char(16) not null
)
go
print "Created VideoImageDest Table"
go
print " "
go
print " "
go
|
