-- MySQL dump 10.11 -- -- Host: 195.246.8.99 Database: uveitis -- ------------------------------------------------------ -- Server version 4.0.24_Debian-10sarge2-log /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `catcategory` -- DROP TABLE IF EXISTS `catcategory`; CREATE TABLE `catcategory` ( `idCatCategory` int(64) NOT NULL auto_increment, `description` varchar(128) default NULL, PRIMARY KEY (`idCatCategory`) ) TYPE=MyISAM; -- -- Dumping data for table `catcategory` -- LOCK TABLES `catcategory` WRITE; /*!40000 ALTER TABLE `catcategory` DISABLE KEYS */; INSERT INTO `catcategory` VALUES (1,'novice'),(2,'links'); /*!40000 ALTER TABLE `catcategory` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `catentity` -- DROP TABLE IF EXISTS `catentity`; CREATE TABLE `catentity` ( `idCatEntity` int(11) NOT NULL auto_increment, `idCatCategory` int(64) NOT NULL default '0', `text1` text, `text2` text, `text3` text, `text4` text, `text5` text, `integer1` int(11) default NULL, `integer2` int(11) default NULL, `integer3` int(11) default '0', `float1` float default NULL, `float2` float default NULL, `float3` float default NULL, `date1` date default NULL, `date2` date default NULL, `date3` date default NULL, `pic1` longblob, `pic2` longblob, `pic3` longblob, `idLanguage` varchar(6) NOT NULL default '', PRIMARY KEY (`idCatEntity`) ) TYPE=MyISAM; -- -- Dumping data for table `catentity` -- LOCK TABLES `catentity` WRITE; /*!40000 ALTER TABLE `catentity` DISABLE KEYS */; INSERT INTO `catentity` VALUES (10,2,'
Trains to Koper (30 min from Portorož)
','http://www.slo-zeleznice.si ','','','',0,0,0,0,0,0,'0000-00-00','0000-00-00','0000-00-00','','','',''),(11,2,'Adria Airways
','','','','',0,0,0,0,0,0,'0000-00-00','0000-00-00','0000-00-00','','','',''),(12,2,'Airport transfer Ljubljana
','http://www.arnes.si/nato-anw/markun.html','','','',0,0,0,0,0,0,'0000-00-00','0000-00-00','0000-00-00','','','',''),(13,2,'Amadeus travel search','http://www.amadeus.net/home/new/index.htm','','','',0,0,0,0,0,0,'0000-00-00','0000-00-00','0000-00-00','','','',''),(14,2,'Buses to Portorož','http://www.ap-ljubljana.si/','','','',0,0,0,0,0,0,'0000-00-00','0000-00-00','0000-00-00','','','',''),(15,2,'Ryanair to Ronchi airport (Trieste)','http://www.ryanair.com/','','','',0,0,0,0,0,0,'0000-00-00','0000-00-00','0000-00-00','','','',''),(16,2,'Boat tours to Venice','http://www.rosetour.si/prince/','','','',0,0,0,0,0,0,'0000-00-00','0000-00-00','0000-00-00','','','',''),(17,2,'All about Portoroz
','','','','',0,0,0,0,0,0,'0000-00-00','0000-00-00','0000-00-00','','','',''),(18,2,'The Venue in Hoteli Morje
','\r\n\r\n
','','','',0,0,0,0,0,0,'0000-00-00','0000-00-00','0000-00-00','','','',''),(19,2,'Trieste airport','http://www.aeroporto.fvg.it/UK/index_uk.html','','','',0,0,0,0,0,0,'0000-00-00','0000-00-00','0000-00-00','','','',''),(20,1,'Trains Timetable ','\r\n
Trains LJUBLJANA-KOPER
\r\n\r\n\r\n | \r\n Departure | \r\n\r\n Arrival | \r\n\r\n | \r\n Change | \r\n\r\n Travel time |
\r\n | |||||
\r\n | \r\n 06:00 | \r\n\r\n 08:32 | \r\n\r\n | \r\n 1 | \r\n\r\n 02:32 |
\r\n | |||||
\r\n | \r\n 09:30 | \r\n\r\n 11:50 | \r\n\r\n | \r\n 0 | \r\n\r\n 02:20 |
\r\n | |||||
\r\n | \r\n 15:25 | \r\n\r\n 17:58 | \r\n\r\n | \r\n 0 | \r\n\r\n 02:28 |
\r\n | |||||
\r\n | \r\n 16:45 | \r\n\r\n 19:03 | \r\n\r\n | \r\n 0 | \r\n\r\n 02:18 |
\r\n |
\r\n
Trains KOPER-LJUBLJANA
\r\n\r\n\r\n | \r\n Departure | \r\n\r\n Arrival | \r\n\r\n | \r\n Change | \r\n\r\n Travel time |
\r\n | |||||
\r\n | \r\n 05:55 | \r\n\r\n 08:14 | \r\n\r\n | \r\n 0 | \r\n\r\n 02:19 |
\r\n | |||||
\r\n | \r\n 10:05 | \r\n\r\n 12:36 | \r\n\r\n | \r\n 0 | \r\n\r\n 02:31 |
\r\n | |||||
\r\n | \r\n 14:55 | \r\n\r\n 17:13 | \r\n\r\n | \r\n 0 | \r\n\r\n 02:18 |
\r\n | |||||
\r\n | \r\n 19:13 | \r\n\r\n 21:40 | \r\n\r\n | \r\n 0 | \r\n\r\n 02:25 |
\r\n |
\r\n |
','','','',0,0,0,0,0,0,'2004-07-27','0000-00-00','0000-00-00','','','',''),(29,2,'
5th Slovenian Congress of Ophthalmology
\r\n28th Symposium of Ophthalmology of Slovenia and Croatia
06.30
\r\n10.00
\r\n13.45
\r\n14.35
\r\n15.00
\r\n17.00
\r\nTravel time: 2.27h-2.55h, depending on the intinerary
\r\n','','','',0,0,0,0,0,0,'2004-07-27','0000-00-00','0000-00-00','','','',''),(28,2,'
easyJet.com the web\'s favourite airline
','http://www.easyjet.com/ ','','','',0,0,0,0,0,0,'0000-00-00','0000-00-00','0000-00-00','','','',''); /*!40000 ALTER TABLE `catentity` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmspage` -- DROP TABLE IF EXISTS `cmspage`; CREATE TABLE `cmspage` ( `idCmsPage` int(64) NOT NULL auto_increment, `title` varchar(128) default NULL, PRIMARY KEY (`idCmsPage`) ) TYPE=MyISAM; -- -- Dumping data for table `cmspage` -- LOCK TABLES `cmspage` WRITE; /*!40000 ALTER TABLE `cmspage` DISABLE KEYS */; INSERT INTO `cmspage` VALUES (1,'cmsPrimer'); /*!40000 ALTER TABLE `cmspage` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmssection` -- DROP TABLE IF EXISTS `cmssection`; CREATE TABLE `cmssection` ( `idCmsSection` int(64) NOT NULL auto_increment, `idCmsPage` varchar(64) NOT NULL default '', `title` varchar(128) default NULL, `sectionCode` text, `idLanguage` varchar(6) NOT NULL default '', PRIMARY KEY (`idCmsSection`) ) TYPE=MyISAM; -- -- Dumping data for table `cmssection` -- LOCK TABLES `cmssection` WRITE; /*!40000 ALTER TABLE `cmssection` DISABLE KEYS */; INSERT INTO `cmssection` VALUES (1,'1','NAZIV','VALPURIS d.o.o.
',''),(2,'1','NASLOV','Nekje pri neki cesti 133a',''),(3,'1','TELEFON','041 445 445',''); /*!40000 ALTER TABLE `cmssection` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mailgroup` -- DROP TABLE IF EXISTS `mailgroup`; CREATE TABLE `mailgroup` ( `idMailGroup` int(11) NOT NULL auto_increment, `description` varchar(128) default NULL, PRIMARY KEY (`idMailGroup`) ) TYPE=MyISAM; -- -- Dumping data for table `mailgroup` -- LOCK TABLES `mailgroup` WRITE; /*!40000 ALTER TABLE `mailgroup` DISABLE KEYS */; INSERT INTO `mailgroup` VALUES (1,'Default'); /*!40000 ALTER TABLE `mailgroup` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subject` -- DROP TABLE IF EXISTS `subject`; CREATE TABLE `subject` ( `idSubject` int(11) NOT NULL auto_increment, `eMailTxt` varchar(120) NOT NULL default '', `nameTxt` varchar(128) default NULL, `addressTxt` varchar(198) default NULL, `cityTxt` varchar(128) default NULL, `postalCodeTxt` varchar(10) default NULL, `idCountryTxt` varchar(6) default NULL, `TRRTxt` varchar(64) default NULL, `phoneTxt` varchar(32) default NULL, `cellularTxt` varchar(32) default NULL, `faxTxt` varchar(32) default NULL, `urlTxt` varchar(128) default NULL, `vatNoTxt` varchar(32) default NULL, `vatUserTxt` tinyint(4) default NULL, `idMailGroupTxt` int(11) NOT NULL default '0', `idRegionTxt` int(11) default NULL, PRIMARY KEY (`idSubject`), UNIQUE KEY `email` (`eMailTxt`), UNIQUE KEY `idSubject` (`idSubject`), UNIQUE KEY `idSubject_2` (`idSubject`), UNIQUE KEY `idSubject_3` (`idSubject`), UNIQUE KEY `idSubject_4` (`idSubject`) ) TYPE=MyISAM; -- -- Dumping data for table `subject` -- LOCK TABLES `subject` WRITE; /*!40000 ALTER TABLE `subject` DISABLE KEYS */; INSERT INTO `subject` VALUES (24,'karmen.loncarek@ri.tel.hr','Loncarek Karmen','','','','','','','','','','',0,0,0),(23,'andrej.verk@guest.arnes.si','Andrej Verk','','','','','','','','','','',0,0,0),(22,'backup@moorfields-in-slovenia.info','Backup','','','','','','','','','','',0,0,0),(25,'giorgiasanguinetti@yahoo.it','Giorgia Sanguinetti MD','','','','','','','','','','',0,0,0),(26,'rok.vrhovec@siol.net','Marko Vrhovec','','','','','','','','','','',0,0,0),(27,'manca.tekavcic-pompe@guest.arnes.si','Manca Tekavcic-Pompe','','','','','','','','','','',0,0,0),(28,'matej_beltram@yahoo.com','Matej Beltram','','','','','','','','','','',0,0,0),(29,'kresimir.macan@email.si','Krešimir Macan','','','','','','','','','','',0,0,0),(30,'sint.solar@siol.net','tajana solar','','','','','','','','','','',0,0,0),(31,'mojca.hlebec@guest.arnes.si','Mojca Urbancic','','','','','','','','','','',0,0,0),(32,'somfaigm@szem2.sote.hu','Dr. Gabor Mark Somfai','','','','','','','','','','',0,0,0),(33,'marija.schwarzbartl@kclj.si','Marija Ana Schwarzbartl Pfeifer','','','','','','','','','','',0,0,0),(34,'b.delic@eunet.yu','Dobrila Delic','','','','','','','','','','',0,0,0),(35,'tatjana.krzisnik@zzd.si','Nada Čulafić- Popović','','','','','','','','','','',0,0,0),(36,'anaoros@eunet.yu','Ana Oros','','','','','','','','','','',0,0,0),(37,'bosnjakm2002@yahoo.com','Bosnjakovski Martin','','','','','','','','','','',0,0,0),(38,'em_post@hotmail.com','Dr.Elisabeth Müller-Vanderspruit','','','','','','','','','','',0,0,0),(39,'zala_kalan@yahoo.com','Anda Kalan','','','','','','','','','','',0,0,0),(40,'oko-optika@ri.htnet.hr','Bernard Mrak dr','','','','','','','','','','',0,0,0),(41,'irena.brovet-zupani@siol.net','Irena Brovet Zupančič','','','','','','','','','','',0,0,0),(42,'maja.stular@email.si','maja štular','','','','','','','','','','',0,0,0),(43,'polona.jaki@guest.arnes.si','Polona Jaki Mekjavic','','','','','','','','','','',0,0,0),(45,'kisicb@teol.net','Dr Kisic Gordana','','','','','','','','','','',0,0,0),(46,'slavica.podgorsek@guest.arnes.si','Podgoršek Slavica','','','','','','','','','','',0,0,0),(47,'dr.kocmut@medicentsalzburg.com','Jurij Komcut MD, OPhth','','','','','','','','','','',0,0,0),(48,'szaman@axelero.hu','Dr. Anna Szamosi','','','','','','','','','','',0,0,0),(49,'brrankko@yahoo.com','Branko Vrlic','','','','','','','','','','',0,0,0),(50,'rerc@soog.azm.nl','Roel Erckens','','','','','','','','','','',0,0,0),(51,'Mall.Parik@kliinikum.ee','Mall Parik','','','','','','','','','','',0,0,0),(52,'Reet.Kuiv@kliinikum.ee','Reet Kuiv','','','','','','','','','','',0,0,0),(53,'marjan@irman.si','Mrjan Irman','','','','','','','','','','',0,0,0),(54,'mc_nistor@hotmail.com','Marius Cristian Nistor','','','','','','','','','','',0,0,0),(55,'manuela.panzitt@netway.at','Manuela Panzitt','','','','','','','','','','',0,0,0),(56,'tvrtka.benasic@os.t-com.hr','Tvrtka Benašić','','','','','','','','','','',0,0,0); /*!40000 ALTER TABLE `subject` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `uporabnik` -- DROP TABLE IF EXISTS `uporabnik`; CREATE TABLE `uporabnik` ( `id_uporabnik` int(11) NOT NULL auto_increment, `postalCode` int(11) default NULL, `tip` int(11) NOT NULL default '0', `uporabnisko_ime` varchar(80) default NULL, `geslo` varchar(80) default NULL, `datum_registracije` date default NULL, `ime` varchar(80) default NULL, `priimek` varchar(80) default NULL, `naslov` varchar(150) default NULL, `email` varchar(80) default NULL, `datum_rojstva` date default NULL, `slika` longblob, PRIMARY KEY (`id_uporabnik`), KEY `UporabnikTip_FK` (`tip`), KEY `PostalOfficeOfUporabnik_FK` (`postalCode`) ) TYPE=MyISAM; -- -- Dumping data for table `uporabnik` -- LOCK TABLES `uporabnik` WRITE; /*!40000 ALTER TABLE `uporabnik` DISABLE KEYS */; INSERT INTO `uporabnik` VALUES (1,NULL,3,'superuser','0baea2f0ae20150db78f58cddac442a9','2003-01-01','superuser','','','','2003-01-01',''),(2,NULL,2,'admin','d113d9ba1a9ccba5c2913d290609a2ef','2003-01-01','admin','','','','2003-01-01',''); /*!40000 ALTER TABLE `uporabnik` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `uporabnik_tip` -- DROP TABLE IF EXISTS `uporabnik_tip`; CREATE TABLE `uporabnik_tip` ( `id_uporabnik_tip` int(11) NOT NULL auto_increment, `stopnja` int(11) default NULL, `opis` varchar(150) default NULL, `ime` varchar(80) default NULL, PRIMARY KEY (`id_uporabnik_tip`) ) TYPE=MyISAM; -- -- Dumping data for table `uporabnik_tip` -- LOCK TABLES `uporabnik_tip` WRITE; /*!40000 ALTER TABLE `uporabnik_tip` DISABLE KEYS */; INSERT INTO `uporabnik_tip` VALUES (1,0,'ni uporabnik','neveljavno'),(2,5,'Administrator','administrator'),(3,10,'the name says it all','superuser'),(4,1,'Guest','Guest'); /*!40000 ALTER TABLE `uporabnik_tip` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2009-07-15 7:20:30