-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 13, 2008 at 06:54 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `earthify`
--

-- --------------------------------------------------------

--
-- Table structure for table `errors`
--

CREATE TABLE IF NOT EXISTS `errors` (
  `id` int(9) NOT NULL auto_increment,
  `date_of_error` datetime NOT NULL,
  `file` char(255) NOT NULL,
  `line` char(100) NOT NULL,
  `code` mediumtext NOT NULL,
  `user_agent` char(255) default NULL,
  `remote_addr` char(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;


-- --------------------------------------------------------

--
-- Table structure for table `placemarks`
--

CREATE TABLE IF NOT EXISTS `placemarks` (
  `id` int(5) NOT NULL auto_increment,
  `url` varchar(255) NOT NULL,
  `city` varchar(255) default NULL,
  `title` varchar(255) default NULL,
  `location` varchar(255) default NULL,
  `coords` varchar(20) default NULL,
  `images` longtext NOT NULL,
  `email` char(255) default NULL,
  `phone` varchar(30) default NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `url` (`url`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=679497691 ;