From b620ca42fce451f8966219784ffcccb9bc917a4a Mon Sep 17 00:00:00 2001 From: Ian C Date: Sun, 20 Jun 2004 00:21:51 +0000 Subject: This commit was generated by cvs2svn to compensate for changes in r2, which included commits to RCS files with non-trunk default branches. --- table.txt | 87 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 87 insertions(+) create mode 100644 table.txt (limited to 'table.txt') 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 -- cgit v1.2.3