Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE testgooglemaps;
- USE testgooglemaps
- CREATE TABLE IF NOT EXISTS `poi_example` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` text NOT NULL,
- `desc` text NOT NULL,
- `lat` text NOT NULL,
- `lon` text NOT NULL,
- `complete` bool,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
- INSERT INTO `poi_example` (`id`, `name`, `desc`, `lat`, `lon`, complete) VALUES
- (1, '100 Club', 'Oxford Street, London W1<br/>3 Nov 2010 : Buster Shuffle<br/>', '51.514980', '-0.144328', 1),
- (2, '93 Feet East', '150 Brick Lane, London E1 6RU<br/>7 Dec 2010 : Jenny & Johnny<br/>', '51.521710', '-0.071737', 1),
- (3, 'Adelphi Theatre', 'The Strand, London WC2E 7NA<br/>11 Oct 2010 : Love Never Dies', '51.511010', '-0.120140',0),
- (4, 'Albany, The', '240 Gt. Portland Street, London W1W 5QU', '51.521620', '-0.143394',0),
- (5, 'Aldwych Theatre', 'Aldwych, London WC2B 4DF<br/>11 Oct 2010 : Dirty Dancing', '51.513170', '-0.117503',1),
- (6, 'Alexandra Palace', 'Wood Green, London N22<br/>30 Oct 2010 : Lynx All-Nighter', '51.596490', '-0.109514',1);
Add Comment
Please, Sign In to add comment