CREATE TABLE `goldmembers` (
`ID` int(10) NOT NULL auto_increment,
`Title` text NOT NULL,
`FirstName` text NOT NULL,
`LastName` text NOT NULL,
`BuildingNumber` text NOT NULL,
`BuildingName` text NOT NULL,
`Street` text NOT NULL,
`Town` text NOT NULL,
`City` text NOT NULL,
`Postcode` text NOT NULL,
`Telephone` text NOT NULL,
`EmailAddress` text NOT NULL,
`Notes` text NOT NULL,
`SubscribedDate` DATE,
`RenewalDate` DATE,
`MembershipNumber` int(10) NOT NULL default'0',
PRIMARY KEY (id)
);