--
-- Tabelstructuur voor tabel `kolgu_icagenda_events`
--

CREATE TABLE IF NOT EXISTS `kolgu_icagenda_events` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `asset_id` int(10) NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL,
  `state` tinyint(1) NOT NULL DEFAULT '1',
  `approval` int(11) NOT NULL DEFAULT '0',
  `checked_out` int(11) NOT NULL,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `title` varchar(255) NOT NULL,
  `alias` varchar(255) NOT NULL,
  `access` int(10) unsigned NOT NULL DEFAULT '0',
  `language` char(7) NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int(10) unsigned NOT NULL DEFAULT '0',
  `created_by_alias` varchar(255) NOT NULL,
  `created_by_email` varchar(100) NOT NULL,
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(255) NOT NULL,
  `catid` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `displaytime` int(10) NOT NULL DEFAULT '1',
  `weekdays` varchar(255) NOT NULL DEFAULT '',
  `daystime` varchar(255) NOT NULL DEFAULT '',
  `startdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `enddate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `period` mediumtext NOT NULL,
  `dates` mediumtext NOT NULL,
  `next` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `time` varchar(255) NOT NULL,
  `place` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `coordinate` varchar(255) NOT NULL,
  `lat` float(20,16) NOT NULL,
  `lng` float(20,16) NOT NULL,
  `desc` mediumtext NOT NULL,
  `params` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;

--
-- Gegevens worden uitgevoerd voor tabel `kolgu_icagenda_events`
--

INSERT INTO `kolgu_icagenda_events` (`id`, `asset_id`, `ordering`, `state`, `approval`, `checked_out`, `checked_out_time`, `title`, `alias`, `access`, `language`, `created`, `created_by`, `created_by_alias`, `created_by_email`, `modified`, `modified_by`, `username`, `catid`, `image`, `file`, `displaytime`, `weekdays`, `daystime`, `startdate`, `enddate`, `period`, `dates`, `next`, `time`, `place`, `website`, `email`, `phone`, `name`, `city`, `country`, `address`, `coordinate`, `lat`, `lng`, `desc`, `params`) VALUES
(3, 148, 3, -2, 0, 0, '0000-00-00 00:00:00', 'Korenavond van de Onderlinge Federatie in Ransdaal', 'korenavond-van-de-onderlinge-federatie-in-ransdaal', 0, '*', '0000-00-00 00:00:00', 70, '', '', '0000-00-00 00:00:00', 0, 'Jep Vencken', 1, '', '', 1, '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'a:1:{i:0;s:16:"2013-10-12 19:30";}', '2013-10-12 19:30:00', '', 'H.Theresiakerk', '', '', '', '', 'Ransdaal', '', 'Ransdalerstraat 74, 6311 AZ Ransdaal, Nederland', '50.8651717, 5.89716169999997', 0.0000000000000000, 0.0000000000000000, '', '{"statutReg":"","typeReg":"0","maxReg":"","maxRlistGlobal":"1","maxRlist":"","atevent":""}'),
(14, 246, 14, -2, 1, 0, '0000-00-00 00:00:00', 'Deelname Culturele stoet tijdens Oogstdankfeesten', 'deelname-culturele-stoet-tijdens-oogstdankfeesten', 1, '*', '2013-03-20 14:39:20', 70, '', '', '0000-00-00 00:00:00', 0, 'Gert Uphoff', 3, '', '', 1, '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'a:1:{i:0;s:16:"2013-08-18 10:00";}', '2013-08-18 10:00:00', '', '', '', '', '', '', 'Berg a/d Maas', '', 'Nederheidestraat 44, 6129 AH Urmond, Nederland', '51.0070297734473, 5.77581218521118', 51.0070304870605500, 5.7758121490478520, '', '{"statutReg":"","accessReg":"1","typeReg":"0","maxReg":"","maxRlistGlobal":"","maxRlist":"","RegButtonText":"","atevent":""}'),
(15, 150, 15, -2, 0, 0, '0000-00-00 00:00:00', '"Meerssen in de ban van ......."', 'meerssen-in-de-ban-van', 1, '*', '2013-04-17 08:26:55', 70, 'Jeven', '', '0000-00-00 00:00:00', 0, 'Jep Vencken', 1, '', '', 1, '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'a:1:{i:0;s:16:"2013-09-15 00:00";}', '2013-09-15 00:00:00', '', 'Proosdijpark', '', '', '', '', 'Meerssen', '', '', '', 0.0000000000000000, 0.0000000000000000, '<p>Optreden Meerssens Mannenkoor om 15.00 uur.</p>', '{"statutReg":"","accessReg":"1","typeReg":"0","maxReg":"","maxRlistGlobal":"1","maxRlist":"","atevent":""}');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;