DROP TABLE IF EXISTS tng_addresses;
CREATE TABLE `tng_addresses` (
  `addressID` int(11) NOT NULL AUTO_INCREMENT,
  `address1` varchar(64) NOT NULL,
  `address2` varchar(64) NOT NULL,
  `city` varchar(64) NOT NULL,
  `state` varchar(64) NOT NULL,
  `zip` varchar(10) NOT NULL,
  `country` varchar(64) NOT NULL,
  `www` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `gedcom` varchar(20) NOT NULL,
  PRIMARY KEY (`addressID`),
  KEY `address` (`gedcom`,`country`,`state`,`city`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
INSERT INTO tng_addresses (addressID,address1,address2,city,state,zip,country,www,email,phone,gedcom) VALUES
("1","Kent County Cricket Club","","","","","","","","","jennerations"),
("2","Duncan Hall School","","","","","","","","","jennerations"),
("3","Hawick and Wilton Cricket Club","","","","","","","","","jennerations"),
("4","Hull prison","","","","","","","","","jennerations"),
("5","All Saints, Lund","","","","","","","","","jennerations"),
("6","Hertford County Hospital","","","","","","","","","jennerations"),
("7","King Street","","","","","","","","","jennerations"),
("8","St Mary Milstead, Kent","","","","","","","","","jennerations"),
("9","3 Little Dean Cottage, Ayton, Berwickshire, Scotland","","","","","","","","","jennerations"),
("10","3 Little Dean Cottage, Ayton, Berwickshire, Scotland","","","","","","","","","jennerations"),
("11","Farm Cottages, Nesbit Hill, Edrom, Berwickshire, Scotland","","","","","","","","","jennerations"),
("12","Farm Cottages, Nesbit Hill, Edrom, Berwickshire, Scotland","","","","","","","","","jennerations"),
("13","St Mary\'s Church, Church Road, Kington, Herefordshire, England","","","","","","","","","jennerations"),
("14","Brilley","","","","","","","","","jennerations"),
("15","Boarder","","","","","","","","","jennerations"),
("16","St Mary [[Milstead, Kent\'\'","","","","","","","","","jennerations"),
("17","Ss Peter and Paul, Lynsted","","","","","","","","","jennerations"),
("18","St John the Baptist Doddington, Kent","","","","","","","","","jennerations"),
("19","St John the Baptist, Doddington, Kent","","","","","","","","","jennerations"),
("20","St John the Baptist Doddington, Kent","","","","","","","","","jennerations"),
("21","St John the Baptist Doddington, Kent","","","","","","","","","jennerations"),
("22","Church of Scotland","","","","","","","","","jennerations"),
("23","Kent Libraries Registration and Archives Kent History and Librar","","","","","","","","","jennerations"),
("24","The National Library of Wales","","","","","","","","","jennerations"),
("25","65 Brown Street, Glasgow","","","","","","","","","jennerations"),
("26","Salt Lake City, Utah","","","","","","","","","jennerations"),
("27","Callendar House, Callendar Park, Falkirk, Scotland, FK1 1YR","","","","","","","","","jennerations"),
("28","Unit 907, Abbeymill Business Centre, 12 Seedmill Road, Paisley, ","","","","","","","","","jennerations");