-- 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

','

http://www.adria.si

','','','',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

','

http://www.portoroz.si

','','','',0,0,0,0,0,0,'0000-00-00','0000-00-00','0000-00-00','','','',''),(18,2,'

The Venue in Hoteli Morje

','

 

\r\n

http://www.hoteli-morje.si

\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\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
 \r\n

Departure

\r\n

Arrival

 \r\n

Change

\r\n

Travel time

\r\n

 \r\n

06:00

\r\n

08:32

 \r\n

1

\r\n

02:32

\r\n

 \r\n

09:30

\r\n

11:50

 \r\n

0

\r\n

02:20

\r\n

 \r\n

15:25

\r\n

17:58

 \r\n

0

\r\n

02:28

\r\n

 \r\n

16:45

\r\n

19:03

 \r\n

0

\r\n

02:18

\r\n\r\n\r\n\r\n
\r\n

\r\n

 

\r\n

Trains KOPER-LJUBLJANA

\r\n

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
 \r\n

Departure

\r\n

Arrival

 \r\n

Change

\r\n

Travel time

\r\n

 \r\n

05:55

\r\n

08:14

 \r\n

0

\r\n

02:19

\r\n

 \r\n

10:05

\r\n

12:36

 \r\n

0

\r\n

02:31

\r\n

 \r\n

14:55

\r\n

17:13

 \r\n

0

\r\n

02:18

\r\n

 \r\n

19:13

\r\n

21:40

 \r\n

0

\r\n

02:25

\r\n

\r\n\r\n\r\n\r\n
\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

\r\n','http://www.ophthalmology2004.org','','','',0,0,0,0,0,0,'0000-00-00','0000-00-00','0000-00-00','','','',''),(21,1,'Buses from Ljubljana to Portorož ','

06.30

\r\n

10.00

\r\n

13.45

\r\n

14.35

\r\n

15.00

\r\n

17.00

\r\n

Travel 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