-- MySQL dump 10.11 -- -- Host: 195.246.8.99 Database: ophthalmology2004 -- ------------------------------------------------------ -- 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 `application` -- DROP TABLE IF EXISTS `application`; CREATE TABLE `application` ( `name` varchar(50) NOT NULL default '', `needRefreshing` tinyint(1) NOT NULL default '0', `defaultLanguage` varchar(6) NOT NULL default '', `ftpHost` varchar(64) default NULL, `ftpUser` varchar(64) default NULL, `ftpPassword` varchar(64) default NULL, `ftpRootDir` varchar(255) default NULL, `dbHost` varchar(64) default NULL, `dbUser` varchar(64) default NULL, `dbPassword` varchar(64) default NULL, `dbName` varchar(64) default NULL, `dbType` varchar(16) default NULL, `dbPort` int(11) default '0', `lastUpload` timestamp(14) NOT NULL, PRIMARY KEY (`name`) ) TYPE=MyISAM COMMENT='Osnovni podatki o aplikaciji'; -- -- Dumping data for table `application` -- LOCK TABLES `application` WRITE; /*!40000 ALTER TABLE `application` DISABLE KEYS */; INSERT INTO `application` VALUES ('Varpulis',0,'sl','ftp.domovanje.com','varpulis','varpulis111','/www/test','mysql2.domovanje.com','varpulis','varpulis111','varpulis','MySQL',3306,20040416015123); /*!40000 ALTER TABLE `application` ENABLE KEYS */; UNLOCK TABLES; -- -- 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,'News'),(2,'Faq'),(13,'sl_Links'),(14,'sl_News'),(15,'en_Links'),(16,'en_News'); /*!40000 ALTER TABLE `catcategory` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `catcategorypreview` -- DROP TABLE IF EXISTS `catcategorypreview`; CREATE TABLE `catcategorypreview` ( `idCatCategory` int(64) NOT NULL auto_increment, `description` varchar(128) default NULL, `status` text, PRIMARY KEY (`idCatCategory`) ) TYPE=MyISAM; -- -- Dumping data for table `catcategorypreview` -- LOCK TABLES `catcategorypreview` WRITE; /*!40000 ALTER TABLE `catcategorypreview` DISABLE KEYS */; INSERT INTO `catcategorypreview` VALUES (1,'News','ok'),(2,'Faq','ok'),(13,'sl_Links','ok'),(14,'sl_News','ok'),(15,'en_Links','ok'),(16,'en_News','ok'); /*!40000 ALTER TABLE `catcategorypreview` 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 (9,13,'

Amadeus travel search ','http://www.amadeus.net/home/new/index.htm ','','','',0,0,0,0,0,0,'2003-12-18','2003-12-18','2003-12-18','','','',''),(19,15,'

Ryanair to Ronchi airport (Trieste)

','http://www.ryanair.com/ ','','','',0,0,0,0,0,0,'2003-12-27','2003-12-27','2003-12-27','','','',''),(8,13,'

Airport transfer Ljubljana ','http://www.arnes.si/nato-anw/markun.html ','','','',0,0,0,0,0,0,'2003-12-18','2003-12-18','2003-12-18','','','',''),(10,13,'

Ryanair to Ronchi airport (Trieste) ','http://www.ryanair.com/ ','','','',0,0,0,0,0,0,'2003-12-18','2003-12-18','2003-12-18','','','',''),(20,15,'

Amadeus travel search

','http://www.amadeus.net/home/new/index.htm ','','','',0,0,0,0,0,0,'2003-12-27','2003-12-27','2003-12-27','','','',''),(21,15,'

Airport transfer Ljubljana

','

http://www.arnes.si/nato-anw/markun.html

','','','',0,0,0,0,0,0,'2003-12-27','2003-12-27','2003-12-27','','','',''),(18,15,'

Adria Airways

','http://www.adria.si','','','',0,0,0,0,0,0,'2003-12-27','2003-12-27','2003-12-27','','','',''),(15,15,'

Trains in Slovenia ','http://www.slo-zeleznice.si ','','','',0,0,0,0,0,0,'2003-12-18','2003-12-18','2003-12-18','','','',''),(17,13,'

Adria Airways ','http://www.adria.si ','','','',0,0,0,0,0,0,'2003-12-18','2003-12-18','2003-12-18','','','',''),(22,13,'

Slovenske železnice ','http://www.slo-zeleznice.si ','','','',0,0,0,0,0,0,'2003-12-27','2003-12-27','2003-12-27','','','',''),(23,13,'

Moorfields Uveitis Course

','http://www.moorfields-in-slovenia.info ','','','',0,0,0,0,0,0,'2004-04-16','2004-04-16','2004-04-16','','','',''),(24,13,'

easyJet.com the web\'s favourite airline','http://www.easyjet.com/ ','','','',0,0,0,0,0,0,'2004-04-16','2004-04-16','2004-04-16','','','',''),(25,15,'

easyJet.com the web\'s favourite airline \r\n\r\n','http://www.easyjet.com/ ','','','',0,0,0,0,0,0,'2004-04-16','2004-04-16','2004-04-16','','','',''),(26,15,'

Moorfields Uveitis Course','http://www.moorfields-in-slovenia.info','','','',0,0,0,0,0,0,'2004-04-16','2004-04-16','2004-04-16','','','',''); /*!40000 ALTER TABLE `catentity` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `catentitypreview` -- DROP TABLE IF EXISTS `catentitypreview`; CREATE TABLE `catentitypreview` ( `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 '', `status` text, PRIMARY KEY (`idCatEntity`) ) TYPE=MyISAM; -- -- Dumping data for table `catentitypreview` -- LOCK TABLES `catentitypreview` WRITE; /*!40000 ALTER TABLE `catentitypreview` DISABLE KEYS */; INSERT INTO `catentitypreview` VALUES (19,15,'

Ryanair to Ronchi airport (Trieste)

','http://www.ryanair.com/ ','','','',0,0,0,0,0,0,'2003-12-27','2003-12-27','2003-12-27','','','','','0'),(9,13,'

Amadeus travel search ','http://www.amadeus.net/home/new/index.htm ','','','',0,0,0,0,0,0,'2003-12-18','2003-12-18','2003-12-18','','','','','0'),(18,15,'

Adria Airways

','http://www.adria.si','','','',0,0,0,0,0,0,'2003-12-27','2003-12-27','2003-12-27','','','','','0'),(8,13,'

Airport transfer Ljubljana ','http://www.arnes.si/nato-anw/markun.html ','','','',0,0,0,0,0,0,'2003-12-18','2003-12-18','2003-12-18','','','','','0'),(10,13,'

Ryanair to Ronchi airport (Trieste) ','http://www.ryanair.com/ ','','','',0,0,0,0,0,0,'2003-12-18','2003-12-18','2003-12-18','','','','','0'),(22,13,'

Slovenske železnice ','http://www.slo-zeleznice.si ','','','',0,0,0,0,0,0,'2003-12-27','2003-12-27','2003-12-27','','','','','0'),(21,15,'

Airport transfer Ljubljana

','

http://www.arnes.si/nato-anw/markun.html

','','','',0,0,0,0,0,0,'2003-12-27','2003-12-27','2003-12-27','','','','','0'),(20,15,'

Amadeus travel search

','http://www.amadeus.net/home/new/index.htm ','','','',0,0,0,0,0,0,'2003-12-27','2003-12-27','2003-12-27','','','','','0'),(15,15,'

Trains in Slovenia ','http://www.slo-zeleznice.si ','','','',0,0,0,0,0,0,'2003-12-18','2003-12-18','2003-12-18','','','','','0'),(17,13,'

Adria Airways ','http://www.adria.si ','','','',0,0,0,0,0,0,'2003-12-18','2003-12-18','2003-12-18','','','','','0'),(23,13,'

Moorfields Uveitis Course

','http://www.moorfields-in-slovenia.info ','','','',0,0,0,0,0,0,'2004-04-16','2004-04-16','2004-04-16','','','','','0'),(24,13,'

easyJet.com the web\'s favourite airline','http://www.easyjet.com/ ','','','',0,0,0,0,0,0,'2004-04-16','2004-04-16','2004-04-16','','','','','0'),(25,15,'

easyJet.com the web\'s favourite airline \r\n\r\n','http://www.easyjet.com/ ','','','',0,0,0,0,0,0,'2004-04-16','2004-04-16','2004-04-16','','','','','0'),(26,15,'

Moorfields Uveitis Course','http://www.moorfields-in-slovenia.info','','','',0,0,0,0,0,0,'2004-04-16','2004-04-16','2004-04-16','','','','','0'); /*!40000 ALTER TABLE `catentitypreview` 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 (3,'cmsPrimer'),(2,'AboutVarpulis'); /*!40000 ALTER TABLE `cmspage` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmspagepreview` -- DROP TABLE IF EXISTS `cmspagepreview`; CREATE TABLE `cmspagepreview` ( `idCmsPage` int(64) NOT NULL auto_increment, `title` varchar(128) default NULL, `status` text, PRIMARY KEY (`idCmsPage`) ) TYPE=MyISAM; -- -- Dumping data for table `cmspagepreview` -- LOCK TABLES `cmspagepreview` WRITE; /*!40000 ALTER TABLE `cmspagepreview` DISABLE KEYS */; INSERT INTO `cmspagepreview` VALUES (3,'cmsPrimer','ok'),(2,'AboutVarpulis','ok'); /*!40000 ALTER TABLE `cmspagepreview` 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 */; /*!40000 ALTER TABLE `cmssection` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cmssectionpreview` -- DROP TABLE IF EXISTS `cmssectionpreview`; CREATE TABLE `cmssectionpreview` ( `idCmsSection` int(64) NOT NULL auto_increment, `idCmsPage` varchar(64) NOT NULL default '', `title` varchar(128) default NULL, `sectionCode` text, `status` text, `idLanguage` varchar(6) NOT NULL default '', PRIMARY KEY (`idCmsSection`) ) TYPE=MyISAM; -- -- Dumping data for table `cmssectionpreview` -- LOCK TABLES `cmssectionpreview` WRITE; /*!40000 ALTER TABLE `cmssectionpreview` DISABLE KEYS */; /*!40000 ALTER TABLE `cmssectionpreview` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `company` -- DROP TABLE IF EXISTS `company`; CREATE TABLE `company` ( `IdCompany` int(10) unsigned NOT NULL auto_increment, `CompanyName` varchar(30) NOT NULL default '', `CompanyAddress` varchar(30) NOT NULL default '', `IdCompanyPostalOffice` int(4) unsigned NOT NULL default '0', `IdCompanyActivity` varchar(8) default NULL, PRIMARY KEY (`IdCompany`), FULLTEXT KEY `CompanyName` (`CompanyName`), FULLTEXT KEY `IdCompanyActivity` (`IdCompanyActivity`) ) TYPE=MyISAM; -- -- Dumping data for table `company` -- LOCK TABLES `company` WRITE; /*!40000 ALTER TABLE `company` DISABLE KEYS */; /*!40000 ALTER TABLE `company` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `companyactivity` -- DROP TABLE IF EXISTS `companyactivity`; CREATE TABLE `companyactivity` ( `IdCompanyActivity` varchar(8) NOT NULL default '', `ActivityName` varchar(150) NOT NULL default '', PRIMARY KEY (`IdCompanyActivity`) ) TYPE=MyISAM; -- -- Dumping data for table `companyactivity` -- LOCK TABLES `companyactivity` WRITE; /*!40000 ALTER TABLE `companyactivity` DISABLE KEYS */; INSERT INTO `companyactivity` VALUES ('1','Internetne rešitve'); /*!40000 ALTER TABLE `companyactivity` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fmail` -- DROP TABLE IF EXISTS `fmail`; CREATE TABLE `fmail` ( `idFMail` int(11) NOT NULL auto_increment, `name` varchar(32) NOT NULL default '', `notify` tinyint(4) NOT NULL default '0', `preview` tinyint(4) NOT NULL default '0', `isText` tinyint(4) NOT NULL default '0', `subject` varchar(255) default NULL, `encoding` varchar(64) default NULL, `fromAddress` varchar(255) default NULL, `replyToAddress` varchar(255) default NULL, `notifyIsText` tinyint(4) default NULL, `notifySubject` varchar(255) default NULL, `notifyEncoding` varchar(64) default NULL, `notifyFromAddress` varchar(255) default NULL, `notifyReplyToAddress` varchar(255) default NULL, PRIMARY KEY (`idFMail`), UNIQUE KEY `name` (`name`) ) TYPE=MyISAM; -- -- Dumping data for table `fmail` -- LOCK TABLES `fmail` WRITE; /*!40000 ALTER TABLE `fmail` DISABLE KEYS */; /*!40000 ALTER TABLE `fmail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fmailreceipient` -- DROP TABLE IF EXISTS `fmailreceipient`; CREATE TABLE `fmailreceipient` ( `idFMail` int(11) NOT NULL default '0', `email` varchar(255) NOT NULL default '', PRIMARY KEY (`idFMail`,`email`) ) TYPE=MyISAM; -- -- Dumping data for table `fmailreceipient` -- LOCK TABLES `fmailreceipient` WRITE; /*!40000 ALTER TABLE `fmailreceipient` DISABLE KEYS */; /*!40000 ALTER TABLE `fmailreceipient` 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 `message` -- DROP TABLE IF EXISTS `message`; CREATE TABLE `message` ( `idMessage` int(11) NOT NULL auto_increment, `subject` text NOT NULL, `body` text NOT NULL, `folder` int(1) NOT NULL default '0', PRIMARY KEY (`idMessage`) ) TYPE=MyISAM; -- -- Dumping data for table `message` -- LOCK TABLES `message` WRITE; /*!40000 ALTER TABLE `message` DISABLE KEYS */; INSERT INTO `message` VALUES (8,'ydfsd ysdfds ddf','gdfgdsgsdfgfd',1),(7,'En mail','KAPATE BRIGA',1),(6,'Granny Hello','hellp ',0),(10,'test','test ',1); /*!40000 ALTER TABLE `message` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `photo` -- DROP TABLE IF EXISTS `photo`; CREATE TABLE `photo` ( `idPhoto` int(11) NOT NULL auto_increment, `idPhotoCategory` int(11) NOT NULL default '0', `description` text, `author` text, `date` date NOT NULL default '0000-00-00', `photo` longblob NOT NULL, `thumbnail` longblob NOT NULL, `sortOrder` int(64) default NULL, `width` int(11) NOT NULL default '0', `height` int(11) NOT NULL default '0', PRIMARY KEY (`idPhoto`) ) TYPE=MyISAM; -- -- Dumping data for table `photo` -- LOCK TABLES `photo` WRITE; /*!40000 ALTER TABLE `photo` DISABLE KEYS */; /*!40000 ALTER TABLE `photo` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `photocategory` -- DROP TABLE IF EXISTS `photocategory`; CREATE TABLE `photocategory` ( `idPhotoCategory` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` text, `author` text, `date` date NOT NULL default '0000-00-00', PRIMARY KEY (`idPhotoCategory`), UNIQUE KEY `name` (`name`) ) TYPE=MyISAM; -- -- Dumping data for table `photocategory` -- LOCK TABLES `photocategory` WRITE; /*!40000 ALTER TABLE `photocategory` DISABLE KEYS */; /*!40000 ALTER TABLE `photocategory` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `photocategorypreview` -- DROP TABLE IF EXISTS `photocategorypreview`; CREATE TABLE `photocategorypreview` ( `idPhotoCategory` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` text, `author` text, `date` date NOT NULL default '0000-00-00', `status` text, PRIMARY KEY (`idPhotoCategory`), UNIQUE KEY `name` (`name`) ) TYPE=MyISAM; -- -- Dumping data for table `photocategorypreview` -- LOCK TABLES `photocategorypreview` WRITE; /*!40000 ALTER TABLE `photocategorypreview` DISABLE KEYS */; /*!40000 ALTER TABLE `photocategorypreview` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `photopreview` -- DROP TABLE IF EXISTS `photopreview`; CREATE TABLE `photopreview` ( `idPhoto` int(11) NOT NULL auto_increment, `idPhotoCategory` int(11) NOT NULL default '0', `description` text, `author` text, `date` date NOT NULL default '0000-00-00', `photo` longblob NOT NULL, `thumbnail` longblob NOT NULL, `sortOrder` int(64) default NULL, `width` int(11) NOT NULL default '0', `height` int(11) NOT NULL default '0', `status` text NOT NULL, PRIMARY KEY (`idPhoto`) ) TYPE=MyISAM; -- -- Dumping data for table `photopreview` -- LOCK TABLES `photopreview` WRITE; /*!40000 ALTER TABLE `photopreview` DISABLE KEYS */; /*!40000 ALTER TABLE `photopreview` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `postaloffice` -- DROP TABLE IF EXISTS `postaloffice`; CREATE TABLE `postaloffice` ( `IdPostalOffice` int(4) NOT NULL default '0', `LocationName` varchar(70) NOT NULL default '', PRIMARY KEY (`IdPostalOffice`) ) TYPE=MyISAM; -- -- Dumping data for table `postaloffice` -- LOCK TABLES `postaloffice` WRITE; /*!40000 ALTER TABLE `postaloffice` DISABLE KEYS */; INSERT INTO `postaloffice` VALUES (4000,'KRANJ'),(1000,'LJUBLJANA'),(2000,'MARIBOR'); /*!40000 ALTER TABLE `postaloffice` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `profession` -- DROP TABLE IF EXISTS `profession`; CREATE TABLE `profession` ( `IdProfession` varchar(8) NOT NULL default '', `ProfessionName` varchar(150) NOT NULL default '', PRIMARY KEY (`IdProfession`) ) TYPE=MyISAM; -- -- Dumping data for table `profession` -- LOCK TABLES `profession` WRITE; /*!40000 ALTER TABLE `profession` DISABLE KEYS */; INSERT INTO `profession` VALUES ('1','Web developer'); /*!40000 ALTER TABLE `profession` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rank` -- DROP TABLE IF EXISTS `rank`; CREATE TABLE `rank` ( `IdRank` int(10) unsigned NOT NULL auto_increment, `RankName` varchar(30) NOT NULL default '', PRIMARY KEY (`IdRank`) ) TYPE=MyISAM COMMENT='Statusi kot so student, zaposlenec, upokojenec...'; -- -- Dumping data for table `rank` -- LOCK TABLES `rank` WRITE; /*!40000 ALTER TABLE `rank` DISABLE KEYS */; INSERT INTO `rank` VALUES (1,'Študent'),(2,'Zaposlen'),(3,'Upokojenec'),(4,'Drugo'); /*!40000 ALTER TABLE `rank` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subject` -- DROP TABLE IF EXISTS `subject`; CREATE TABLE `subject` ( `IdSubject` int(10) unsigned NOT NULL auto_increment, `IdCompany` int(10) unsigned default NULL, `FirstName` text NOT NULL, `LastName` text NOT NULL, `Address` text, `IdPostalOffice` int(4) unsigned default NULL, `IdProfession` int(11) default NULL, `IdRank` int(10) unsigned default NULL, `Phone` varchar(15) default NULL, `CellularPhone` varchar(15) default NULL, `EMail` varchar(255) default NULL, `NotifyMe` char(1) default NULL, PRIMARY KEY (`IdSubject`) ) TYPE=MyISAM; -- -- Dumping data for table `subject` -- LOCK TABLES `subject` WRITE; /*!40000 ALTER TABLE `subject` DISABLE KEYS */; INSERT INTO `subject` VALUES (1,12,'Matjaž','Kolenček','brezdomec',4000,1,0,'','','i1@rsklan.com','N'),(2,24,'admin','admin','Zlpolje 14cd',1000,1,2,'','','i12@rsklan.com','Y'),(4,NULL,'Andrej ','Šolinc',NULL,NULL,NULL,NULL,NULL,NULL,'andrej@hojla.com',NULL),(5,NULL,'Sandi','Bitenc',NULL,NULL,NULL,NULL,NULL,NULL,'sandi@rsklan.com',NULL),(6,NULL,'ivan','ivan',NULL,NULL,NULL,NULL,NULL,NULL,'i1@rsklan.com',NULL); /*!40000 ALTER TABLE `subject` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subjectlecture` -- DROP TABLE IF EXISTS `subjectlecture`; CREATE TABLE `subjectlecture` ( `IdSubject` int(10) unsigned NOT NULL default '0', `IdLecture` int(10) unsigned NOT NULL default '0', `SubmitDateTime` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`IdSubject`,`IdLecture`) ) TYPE=MyISAM; -- -- Dumping data for table `subjectlecture` -- LOCK TABLES `subjectlecture` WRITE; /*!40000 ALTER TABLE `subjectlecture` DISABLE KEYS */; /*!40000 ALTER TABLE `subjectlecture` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usertype` -- DROP TABLE IF EXISTS `usertype`; CREATE TABLE `usertype` ( `idUserType` int(11) NOT NULL auto_increment, `level` int(11) default NULL, `description` varchar(150) default NULL, `name` varchar(80) default NULL, PRIMARY KEY (`idUserType`) ) TYPE=MyISAM; -- -- Dumping data for table `usertype` -- LOCK TABLES `usertype` WRITE; /*!40000 ALTER TABLE `usertype` DISABLE KEYS */; INSERT INTO `usertype` VALUES (1,0,'ni uporabnik','neveljavno'),(2,5,'Administrator','administrator'),(3,10,'the name says it all','superuser'),(4,1,'Guest','Guest'),(5,3,'analiza podatkov','Analyst'),(6,4,'skoraj admin','Editor'); /*!40000 ALTER TABLE `usertype` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `var_user` -- DROP TABLE IF EXISTS `var_user`; CREATE TABLE `var_user` ( `idUser` int(11) NOT NULL auto_increment, `idSubject` int(11) NOT NULL default '0', `idUserType` int(11) NOT NULL default '0', `username` varchar(80) default NULL, `plainTextPassword` text NOT NULL, `password` varchar(80) default NULL, `registrationDate` date default NULL, `registrationTime` time NOT NULL default '00:00:00', `eMail` varchar(80) default NULL, PRIMARY KEY (`idUser`), KEY `UporabnikTip_FK` (`idUserType`) ) TYPE=MyISAM; -- -- Dumping data for table `var_user` -- LOCK TABLES `var_user` WRITE; /*!40000 ALTER TABLE `var_user` DISABLE KEYS */; INSERT INTO `var_user` VALUES (2,2,2,'admin','oph55','82b15f1bbb6d87f17c3c863aafd39188','2003-01-01','00:00:00',''); /*!40000 ALTER TABLE `var_user` 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-14 11:06:31