-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.1.41 - Source distribution
-- Server OS:                    Win32
-- HeidiSQL version:             7.0.0.4072
-- Date/time:                    2012-02-29 21:20:02
-- --------------------------------------------------------

-- Dumping structure for table me_comments
DROP TABLE IF EXISTS `me_comments`;
CREATE TABLE IF NOT EXISTS `me_comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL DEFAULT '',
  `email` varchar(250) NOT NULL DEFAULT '',
  `ip` varchar(50) NOT NULL DEFAULT '',
  `addDate` date NOT NULL DEFAULT '0000-00-00',
  `eventid` int(10) NOT NULL DEFAULT '0',
  `comments` mediumtext NOT NULL,
  `is_active` enum('0','1') NOT NULL DEFAULT '0',
  `is_approved` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Dumping structure for table me_events
DROP TABLE IF EXISTS `me_events`;
CREATE TABLE IF NOT EXISTS `me_events` (
  `id` int(7) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `fromDate` date NOT NULL DEFAULT '0000-00-00',
  `toDate` date NOT NULL DEFAULT '0000-00-00',
  `addDate` date NOT NULL DEFAULT '0000-00-00',
  `keywords` text NOT NULL,
  `description` text NOT NULL,
  `contact` enum('0','1') NOT NULL DEFAULT '0',
  `email` varchar(250) NOT NULL DEFAULT '',
  `en_comments` enum('0','1') NOT NULL DEFAULT '0',
  `finish` enum('1','2','3') NOT NULL DEFAULT '3',
  `comments` mediumtext NOT NULL,
  `is_archived` enum('0','1') NOT NULL DEFAULT '0',
  `rss_date` varchar(35) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Dumping structure for table me_pictures
DROP TABLE IF EXISTS `me_pictures`;
CREATE TABLE IF NOT EXISTS `me_pictures` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `identifier` tinyint(1) NOT NULL DEFAULT '0',
  `eventid` int(10) NOT NULL DEFAULT '0',
  `name` varchar(200) NOT NULL DEFAULT '',
  `thumb` text NOT NULL,
  `image` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Dumping structure for table me_settings
DROP TABLE IF EXISTS `me_settings`;
CREATE TABLE IF NOT EXISTS `me_settings` (
  `id` tinyint(1) NOT NULL DEFAULT '0',
  `website` varchar(250) NOT NULL DEFAULT '',
  `email` varchar(250) NOT NULL DEFAULT '',
  `folder` text NOT NULL,
  `formatdate` varchar(15) NOT NULL DEFAULT '%e %M %Y',
  `language` varchar(50) NOT NULL DEFAULT 'english.php',
  `theme` varchar(50) NOT NULL DEFAULT 'standard',
  `modr` enum('0','1') NOT NULL DEFAULT '0',
  `approve` enum('0','1') NOT NULL DEFAULT '0',
  `captcha` enum('0','1') NOT NULL DEFAULT '0',
  `dayspan` enum('0','1') NOT NULL DEFAULT '0',
  `tswitch` enum('0','1') NOT NULL DEFAULT '0',
  `meta_keys` mediumtext NOT NULL,
  `meta_desc` mediumtext NOT NULL,
  `smtp` enum('0','1') NOT NULL DEFAULT '0',
  `smtp_host` varchar(100) NOT NULL DEFAULT 'localhost',
  `smtp_user` varchar(100) NOT NULL DEFAULT '',
  `smtp_pass` varchar(100) NOT NULL DEFAULT '',
  `smtp_port` varchar(100) NOT NULL DEFAULT '25',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Dumping data for table me_settings: 1 rows

INSERT INTO `me_settings` (`id`, `website`, `email`, `folder`, `formatdate`, `language`, `theme`, `modr`, `approve`, `captcha`, `dayspan`, `tswitch`, `meta_keys`, `meta_desc`, `smtp`, `smtp_host`, `smtp_user`, `smtp_pass`, `smtp_port`) VALUES
	(1, 'My Calendar', 'you@yoursite.com', 'http://www.yoursite.co.uk/events', '%e %M %Y', 'english.php', 'standard', '0', '0', '1', '1', '0', '', '', '0', 'localhost', '', '', '25');
