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