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
|
DROP TABLE intro;
CREATE TABLE intro
(
LastUpdate DateTime (Short) (8),
Names Long Integer (4),
Ships Long Integer (4),
TitelText Text (60)
);
-- CREATE ANY INDEXES ...
DROP TABLE LANDCODE;
CREATE TABLE LANDCODE
(
CODE Text (8),
COUNTRY Text (80),
NAT Text (6)
);
-- CREATE ANY INDEXES ...
DROP TABLE Owners;
CREATE TABLE Owners
(
OwnerNR Long Integer (4),
Short Text (200),
NAT Text (6),
Description Memo/Hyperlink,
Adres Memo/Hyperlink,
Colors NR Long Integer (4)
);
-- CREATE ANY INDEXES ...
DROP TABLE tugdetails;
CREATE TABLE tugdetails
(
TugNR Long Integer (4),
Specifications Memo/Hyperlink,
Link Text (510),
WharfNR Long Integer (4)
);
-- CREATE ANY INDEXES ...
DROP TABLE Wharves;
CREATE TABLE Wharves
(
WharfNR Long Integer (4),
Short Text (200),
NAT Text (6),
Description Memo/Hyperlink,
Adres Memo/Hyperlink
);
-- CREATE ANY INDEXES ...
DROP TABLE tuglist00;
CREATE TABLE tuglist00
(
NR Long Integer (4),
NAME Text (100),
NAT Text (6),
BUILD Text (20),
SCRAP Text (20),
BRT Text (20),
PK Text (40),
YardNR Text (28),
ONAMES Text (400),
PicNR Text (20),
SITE Memo/Hyperlink,
TugNR Long Integer (4),
OwnerNR Long Integer (4),
RegNR Text (48),
EuroNR Text (48),
CallSign Text (28)
);
-- CREATE ANY INDEXES ...
-- CREATE ANY Relationships ...
relationships are not supported for access
relationships are not supported for access
relationships are not supported for access
|
