-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	4.1.15-nt


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

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema calamaris
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ calamaris;
USE calamaris;

--
-- Table structure for table `calamaris`.`aard`
--

DROP TABLE IF EXISTS `aard`;
CREATE TABLE `aard` (
  `aard_id` int(11) NOT NULL default '0',
  `aard_naam` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `calamaris`.`aard`
--

/*!40000 ALTER TABLE `aard` DISABLE KEYS */;
INSERT INTO `aard` (`aard_id`,`aard_naam`) VALUES 
 (1,'Dodelijk'),
 (2,'Levensbedreigend'),
 (3,'Irritant');
/*!40000 ALTER TABLE `aard` ENABLE KEYS */;


--
-- Table structure for table `calamaris`.`calamiteiten`
--

DROP TABLE IF EXISTS `calamiteiten`;
CREATE TABLE `calamiteiten` (
  `calid` int(11) NOT NULL auto_increment,
  `caltitel` varchar(255) NOT NULL default '',
  `caldate` datetime default '0000-00-00 00:00:00',
  `caldatetype` varchar(20) NOT NULL default '',
  `calx` int(11) NOT NULL default '0',
  `caly` int(11) NOT NULL default '0',
  `calnaamcoord` varchar(255) NOT NULL default '',
  `calaard` varchar(255) NOT NULL default '0',
  `calcode` varchar(100) NOT NULL default '',
  `calopm` text NOT NULL,
  `actueel` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`calid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `calamaris`.`calamiteiten`
--

/*!40000 ALTER TABLE `calamiteiten` DISABLE KEYS */;
INSERT INTO `calamiteiten` (`calid`,`caltitel`,`caldate`,`caldatetype`,`calx`,`caly`,`calnaamcoord`,`calaard`,`calcode`,`calopm`,`actueel`) VALUES 
 (162,'','0000-00-00 00:00:00','',33219,669433,'','0','','',1),
 (160,'','0000-00-00 00:00:00','',-452425,913701,'','0','','',1),
 (161,'','0000-00-00 00:00:00','',28883,691114,'','0','','',1),
 (159,'','0000-00-00 00:00:00','',184983,665097,'','0','','',0),
 (155,'CALTEST','2005-12-01 16:17:00','UTC',66463,776391,'Haenen','TEST','CAL-0001','Testlocatie ',0),
 (156,'','0000-00-00 00:00:00','',72244,709904,'','0','','',0),
 (157,'','0000-00-00 00:00:00','',-452425,913701,'','0','','',0),
 (154,'test','2005-12-14 00:00:00','UTC',79471,654979,'thijs','0','12','',0),
 (153,'TESTLOCATIE','2005-12-10 16:34:02','UTC',73545,515742,'Haenen','Teststof','Infrawebcode','',1);
/*!40000 ALTER TABLE `calamiteiten` ENABLE KEYS */;


--
-- Table structure for table `calamaris`.`gebruikerrollen`
--

DROP TABLE IF EXISTS `gebruikerrollen`;
CREATE TABLE `gebruikerrollen` (
  `nummer` int(10) NOT NULL auto_increment,
  `gebruiker` int(10) NOT NULL default '0',
  `rol` int(8) NOT NULL default '0',
  PRIMARY KEY  (`nummer`),
  UNIQUE KEY `gebruiker` (`gebruiker`,`rol`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `calamaris`.`gebruikerrollen`
--

/*!40000 ALTER TABLE `gebruikerrollen` DISABLE KEYS */;
INSERT INTO `gebruikerrollen` (`nummer`,`gebruiker`,`rol`) VALUES 
 (12,9,1),
 (2,2,1),
 (3,3,2),
 (4,4,3),
 (5,5,4),
 (41,6,2),
 (11,1,2),
 (9,1,3),
 (13,9,3),
 (42,6,3),
 (40,6,1),
 (43,6,4),
 (47,10,4),
 (46,10,3),
 (45,10,2),
 (44,10,1),
 (72,11,1),
 (73,11,2),
 (74,11,3),
 (75,11,4),
 (76,14,3),
 (77,14,4),
 (78,15,1),
 (79,15,2),
 (80,15,3),
 (81,15,4);
/*!40000 ALTER TABLE `gebruikerrollen` ENABLE KEYS */;


--
-- Table structure for table `calamaris`.`gebruikers`
--

DROP TABLE IF EXISTS `gebruikers`;
CREATE TABLE `gebruikers` (
  `volgnummer` int(10) unsigned zerofill NOT NULL auto_increment,
  `gebruikersnaam` varchar(32) NOT NULL default '',
  `wachtwoord` varchar(16) NOT NULL default '',
  `organisatie` varchar(100) NOT NULL default '',
  `titel` varchar(32) default NULL,
  `voorletters` varchar(8) NOT NULL default '',
  `tussenvoegsel` varchar(16) default NULL,
  `achternaam` varchar(100) NOT NULL default '',
  `telefoon` varchar(20) default NULL,
  `mobiel` varchar(20) default NULL,
  `fax` varchar(20) default NULL,
  `email` varchar(129) default NULL,
  `contactpersoon` varchar(100) default NULL,
  `datum_invoer` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`volgnummer`),
  UNIQUE KEY `gebruikersnaam` (`gebruikersnaam`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `calamaris`.`gebruikers`
--

/*!40000 ALTER TABLE `gebruikers` DISABLE KEYS */;
INSERT INTO `gebruikers` (`volgnummer`,`gebruikersnaam`,`wachtwoord`,`organisatie`,`titel`,`voorletters`,`tussenvoegsel`,`achternaam`,`telefoon`,`mobiel`,`fax`,`email`,`contactpersoon`,`datum_invoer`) VALUES 
 (0000000001,'serge','serge','Evers Automatisering b.v.','ir.','S.A.','','Evers','0317 422864','06 53960916','','serge@markevers.nl','','0000-00-00'),
 (0000000002,'gebruiker','gebruiker','Nieuwland',NULL,'g.',NULL,'ebruiker',NULL,NULL,NULL,NULL,NULL,'0000-00-00'),
 (0000000003,'modelleur','modelleur','Nieuwland',NULL,'m.',NULL,'odelleur',NULL,NULL,NULL,NULL,NULL,'0000-00-00'),
 (0000000004,'beheerder','beheerder','Nieuwland',NULL,'b.',NULL,'eheerder',NULL,NULL,NULL,NULL,NULL,'0000-00-00'),
 (0000000005,'coordinator','coordinator','Nieuwland',NULL,'c.',NULL,'oordinator',NULL,NULL,NULL,NULL,NULL,'0000-00-00'),
 (0000000006,'jan','jan','Nieuwland','Ir.','J.','','Jansen','0317421711','','','','','0000-00-00'),
 (0000000009,'test','test','','','','','','','','','','','0000-00-00'),
 (0000000010,'thijs','thijs','AGI','drs','T.','van','Menen','015-2757123','','','t.g.vmenen@agi.rws.minvenw.nl','','0000-00-00'),
 (0000000011,'boy','boy','RIKZ','','C.P.L.','','Haenen','070-3114215','06-22808046','070-3114500','c.p.l.haenen@rikz.rws.minvenw.nl','[wat betekent dit veld]','0000-00-00');
INSERT INTO `gebruikers` (`volgnummer`,`gebruikersnaam`,`wachtwoord`,`organisatie`,`titel`,`voorletters`,`tussenvoegsel`,`achternaam`,`telefoon`,`mobiel`,`fax`,`email`,`contactpersoon`,`datum_invoer`) VALUES 
 (0000000013,'piet','piet','','','','','','','','','','','0000-00-00');
/*!40000 ALTER TABLE `gebruikers` ENABLE KEYS */;


--
-- Table structure for table `calamaris`.`rollen`
--

DROP TABLE IF EXISTS `rollen`;
CREATE TABLE `rollen` (
  `rolnummer` int(8) NOT NULL auto_increment,
  `rolnaam` varchar(20) NOT NULL default '',
  `htmlpagina` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`rolnummer`),
  UNIQUE KEY `rolnaam` (`rolnaam`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `calamaris`.`rollen`
--

/*!40000 ALTER TABLE `rollen` DISABLE KEYS */;
INSERT INTO `rollen` (`rolnummer`,`rolnaam`,`htmlpagina`) VALUES 
 (1,'gebruiker','calamarisgebruiker.html'),
 (2,'modelleur','calamarismodelleur.html'),
 (3,'beheerder','calamarisbeheerder.html'),
 (4,'co?rdinator','calamariscoordinator.html');
/*!40000 ALTER TABLE `rollen` ENABLE KEYS */;


--
-- Table structure for table `calamaris`.`verspreidingskaarten`
--

DROP TABLE IF EXISTS `verspreidingskaarten`;
CREATE TABLE `verspreidingskaarten` (
  `verspr_id` int(11) NOT NULL auto_increment,
  `verspr_organisatie` varchar(255) NOT NULL default '',
  `verspr_coordinator` varchar(255) NOT NULL default '',
  `verspr_stofnaam` varchar(255) NOT NULL default '',
  `verspr_datumbegin` datetime NOT NULL default '0000-00-00 00:00:00',
  `verspr_datumeind` datetime NOT NULL default '0000-00-00 00:00:00',
  `verspr_datetype` varchar(20) NOT NULL default '',
  `verspr_calcode` varchar(255) NOT NULL default '',
  `verspr_infrawebcode` varchar(255) NOT NULL default '',
  `verspr_opmerking` longtext NOT NULL,
  `verspr_layername` varchar(255) NOT NULL default '',
  `verspr_datalayer` varchar(255) NOT NULL default '',
  `verspr_wmslayergroup` varchar(255) NOT NULL default '',
  `verspr_showinmap` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`verspr_id`),
  UNIQUE KEY `verspr_layername` (`verspr_layername`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `calamaris`.`verspreidingskaarten`
--

/*!40000 ALTER TABLE `verspreidingskaarten` DISABLE KEYS */;
INSERT INTO `verspreidingskaarten` (`verspr_id`,`verspr_organisatie`,`verspr_coordinator`,`verspr_stofnaam`,`verspr_datumbegin`,`verspr_datumeind`,`verspr_datetype`,`verspr_calcode`,`verspr_infrawebcode`,`verspr_opmerking`,`verspr_layername`,`verspr_datalayer`,`verspr_wmslayergroup`,`verspr_showinmap`) VALUES 
 (42,'agi','wim','polynogiets','0000-00-00 00:00:00','0000-00-00 00:00:00','UTC','4326','34234efr','','15112005uncertainty','15112005uncertainty','/Verspreiding/4326',1),
 (41,'agi','wim','polynogiets','2005-12-06 00:00:00','2005-12-06 00:00:00','UTC','7657','34234efr','','15112005_forecast_pak','15112005_forecast_pak','/Verspreiding/7657',1),
 (43,'RWS-RIKZ','K. Robaczewska','Olie','2005-12-14 12:00:00','2005-12-15 13:00:00','GMT','Infrawebcode','Infrawebcode','Dit betreft een testrun van GNOME','gn_fc_14122005','forecast','/Verspreiding/Infrawebcode',1),
 (44,'agi','thijs','olie','2005-12-14 01:01:00','2005-12-14 01:02:00','UTC','CAL-0001','666','','thijs','thijs','/Verspreiding/CAL-0001',1),
 (45,'RWS-RIKZ','KR','geen','2005-12-15 11:40:00','2005-12-15 20:10:00','UTC','Infrawebcode','INFRA-TESTCODE','','forecast1512','forecast1512','/Verspreiding/Infrawebcode',1);
/*!40000 ALTER TABLE `verspreidingskaarten` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;