summaryrefslogtreecommitdiff
path: root/table.txt
diff options
context:
space:
mode:
Diffstat (limited to 'table.txt')
-rw-r--r--table.txt87
1 files changed, 87 insertions, 0 deletions
diff --git a/table.txt b/table.txt
new file mode 100644
index 0000000..18fddbf
--- /dev/null
+++ b/table.txt
@@ -0,0 +1,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