diff options
| author | Ian C <ianc@noddybox.co.uk> | 2004-06-20 00:21:51 +0000 |
|---|---|---|
| committer | Ian C <ianc@noddybox.co.uk> | 2004-06-20 00:21:51 +0000 |
| commit | b620ca42fce451f8966219784ffcccb9bc917a4a (patch) | |
| tree | 56896d89a0eed24b7039f7f38c2384bc23df3545 /table.txt | |
| parent | 66467d3553d5ecc2d055c08132c15c9de98b7edd (diff) | |
This commit was generated by cvs2svn to compensate for changes in r2,
which included commits to RCS files with non-trunk default branches.
Diffstat (limited to 'table.txt')
| -rw-r--r-- | table.txt | 87 |
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 |
