-- MySQL dump 10.11
--
-- Host: 195.246.8.99    Database: apmsi
-- ------------------------------------------------------
-- 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(16) NOT NULL default '',
  `needrefreshing` smallint(6) NOT NULL default '0',
  `defaultlanguage` varchar(30) NOT NULL default '',
  `ftphost` varchar(80) default NULL,
  `ftpuser` varchar(80) default NULL,
  `ftppassword` varchar(80) default NULL,
  `ftprootdir` varchar(80) default NULL,
  `dbhost` varchar(80) default NULL,
  `dbuser` varchar(80) default NULL,
  `dbpassword` varchar(80) default NULL,
  `dbname` varchar(80) default NULL,
  `dbtype` varchar(80) default NULL,
  `dbport` int(11) default NULL,
  `lastupload` timestamp(14) NOT NULL,
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;

--
-- Dumping data for table `application`
--

LOCK TABLES `application` WRITE;
/*!40000 ALTER TABLE `application` DISABLE KEYS */;
INSERT INTO `application` VALUES ('Varpulis',0,'sl',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,20040826104937);
/*!40000 ALTER TABLE `application` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `catcategory`
--

DROP TABLE IF EXISTS `catcategory`;
CREATE TABLE `catcategory` (
  `idcatcategory` bigint(20) NOT NULL default '0',
  `description` varchar(80) 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 (7,'Aktualno');
/*!40000 ALTER TABLE `catcategory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `catcategorypreview`
--

DROP TABLE IF EXISTS `catcategorypreview`;
CREATE TABLE `catcategorypreview` (
  `idcatcategory` bigint(20) NOT NULL auto_increment,
  `description` varchar(80) default NULL,
  `status` smallint(6) default NULL,
  PRIMARY KEY  (`idcatcategory`)
) TYPE=MyISAM;

--
-- Dumping data for table `catcategorypreview`
--

LOCK TABLES `catcategorypreview` WRITE;
/*!40000 ALTER TABLE `catcategorypreview` DISABLE KEYS */;
INSERT INTO `catcategorypreview` VALUES (7,'Aktualno',0);
/*!40000 ALTER TABLE `catcategorypreview` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `catentity`
--

DROP TABLE IF EXISTS `catentity`;
CREATE TABLE `catentity` (
  `idcatentity` bigint(20) NOT NULL default '0',
  `idcatcategory` bigint(20) 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 NULL,
  `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,
  PRIMARY KEY  (`idcatentity`),
  KEY `cat_ent_fk` (`idcatcategory`)
) TYPE=MyISAM;

--
-- Dumping data for table `catentity`
--

LOCK TABLES `catentity` WRITE;
/*!40000 ALTER TABLE `catentity` DISABLE KEYS */;
INSERT INTO `catentity` VALUES (36,7,'ZPM Forum 2004','<br>Letošnji tradicionalni forum Slovenskega združenja za projektni management z geslom<BR>\r\n<br>\r\n<DIV class=bolded>S projekti med vodilne v Evropi!</div>\r\n<br>\r\nbo usmerjen v dva najpomembnejša cilja Slovenije v prihodnosti - doseči gospodarsko enakopravnost z donedavno višje razvitimi državami v Evropski skupnosti ter doseči prepoznavnost v tej pisani druščini različnih narodov in kultur. Člani programskega odbora foruma smo prepričani, da so prav projekti tisto orodje, ki bo našim organizacijam in državi prineslo mesto, ki si ga želimo in smo ga sposobni doseči - zadovoljiv nivo konkurenčnosti in ustrezno prepoznavnost.<br>\r\n<br>\r\nObiščite <A href=\"http://forum04.zpm-si.com\" target=_blank>http://forum04.zpm-si.com</a>','','','',0,0,0,0,0,0,'2004-08-26','2004-08-26','2004-08-26','','','');
/*!40000 ALTER TABLE `catentity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `catentitypreview`
--

DROP TABLE IF EXISTS `catentitypreview`;
CREATE TABLE `catentitypreview` (
  `idcatentity` bigint(20) NOT NULL auto_increment,
  `idcatcategory` bigint(20) 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 NULL,
  `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,
  `status` smallint(6) default NULL,
  PRIMARY KEY  (`idcatentity`),
  KEY `cat_prv_ent_fk` (`idcatcategory`)
) TYPE=MyISAM;

--
-- Dumping data for table `catentitypreview`
--

LOCK TABLES `catentitypreview` WRITE;
/*!40000 ALTER TABLE `catentitypreview` DISABLE KEYS */;
INSERT INTO `catentitypreview` VALUES (36,7,'ZPM Forum 2004','<br>Letošnji tradicionalni forum Slovenskega združenja za projektni management z geslom<BR>\r\n<br>\r\n<DIV class=bolded>S projekti med vodilne v Evropi!</div>\r\n<br>\r\nbo usmerjen v dva najpomembnejša cilja Slovenije v prihodnosti - doseči gospodarsko enakopravnost z donedavno višje razvitimi državami v Evropski skupnosti ter doseči prepoznavnost v tej pisani druščini različnih narodov in kultur. Člani programskega odbora foruma smo prepričani, da so prav projekti tisto orodje, ki bo našim organizacijam in državi prineslo mesto, ki si ga želimo in smo ga sposobni doseči - zadovoljiv nivo konkurenčnosti in ustrezno prepoznavnost.<br>\r\n<br>\r\nObiščite <A href=\"http://forum04.zpm-si.com\" target=_blank>http://forum04.zpm-si.com</a>','','','',0,0,0,0,0,0,'2004-08-26','2004-08-26','2004-08-26','','','',0);
/*!40000 ALTER TABLE `catentitypreview` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cmspage`
--

DROP TABLE IF EXISTS `cmspage`;
CREATE TABLE `cmspage` (
  `idcmspage` bigint(20) NOT NULL default '0',
  `title` varchar(80) default NULL,
  PRIMARY KEY  (`idcmspage`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmspage`
--

LOCK TABLES `cmspage` WRITE;
/*!40000 ALTER TABLE `cmspage` DISABLE KEYS */;
/*!40000 ALTER TABLE `cmspage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cmspagepreview`
--

DROP TABLE IF EXISTS `cmspagepreview`;
CREATE TABLE `cmspagepreview` (
  `idcmspage` bigint(20) NOT NULL auto_increment,
  `title` varchar(80) default NULL,
  `status` smallint(6) default NULL,
  PRIMARY KEY  (`idcmspage`)
) TYPE=MyISAM;

--
-- Dumping data for table `cmspagepreview`
--

LOCK TABLES `cmspagepreview` WRITE;
/*!40000 ALTER TABLE `cmspagepreview` DISABLE KEYS */;
/*!40000 ALTER TABLE `cmspagepreview` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cmssection`
--

DROP TABLE IF EXISTS `cmssection`;
CREATE TABLE `cmssection` (
  `idcmssection` bigint(20) NOT NULL default '0',
  `idcmspage` bigint(20) NOT NULL default '0',
  `title` varchar(80) default NULL,
  `sectioncode` text,
  PRIMARY KEY  (`idcmssection`),
  KEY `cms_sec_fk` (`idcmspage`)
) 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` bigint(20) NOT NULL auto_increment,
  `idcmspage` bigint(20) NOT NULL default '0',
  `title` varchar(80) default NULL,
  `sectioncode` text,
  `status` smallint(6) default NULL,
  PRIMARY KEY  (`idcmssection`),
  KEY `cms_prv_sec_fk` (`idcmspage`)
) 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` varchar(16) NOT NULL default '',
  `idcountry` bigint(20) default NULL,
  `idpostaloffice` bigint(20) default NULL,
  `idcompanyactivity` bigint(20) default NULL,
  `companyname` varchar(80) NOT NULL default '',
  `companyaddress` varchar(80) NOT NULL default '',
  `phone` varchar(30) default NULL,
  `phone2` varchar(30) default NULL,
  `email` varchar(80) default NULL,
  `email2` varchar(80) default NULL,
  `url` varchar(80) default NULL,
  `fax` varchar(30) default NULL,
  `taxno` varchar(30) default NULL,
  `matno` varchar(80) default NULL,
  `taxman` smallint(6) default NULL,
  PRIMARY KEY  (`idcompany`),
  KEY `relationship_16_fk` (`idcompanyactivity`),
  KEY `com_post_fk` (`idpostaloffice`),
  KEY `com_coun_fk` (`idcountry`)
) 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` bigint(20) NOT NULL auto_increment,
  `activityname` varchar(80) NOT NULL default '',
  PRIMARY KEY  (`idcompanyactivity`)
) TYPE=MyISAM;

--
-- Dumping data for table `companyactivity`
--

LOCK TABLES `companyactivity` WRITE;
/*!40000 ALTER TABLE `companyactivity` DISABLE KEYS */;
/*!40000 ALTER TABLE `companyactivity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `country`
--

DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
  `idcountry` bigint(20) NOT NULL default '0',
  `description` varchar(80) default NULL,
  PRIMARY KEY  (`idcountry`)
) TYPE=MyISAM;

--
-- Dumping data for table `country`
--

LOCK TABLES `country` WRITE;
/*!40000 ALTER TABLE `country` DISABLE KEYS */;
/*!40000 ALTER TABLE `country` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `docdocument`
--

DROP TABLE IF EXISTS `docdocument`;
CREATE TABLE `docdocument` (
  `iddocument` bigint(20) NOT NULL default '0',
  `filename` varchar(80) NOT NULL default '',
  `description` varchar(150) default NULL,
  `owner` bigint(20) NOT NULL default '0',
  `dateuploaded` date NOT NULL default '0000-00-00',
  `datemodified` date default NULL,
  PRIMARY KEY  (`iddocument`)
) TYPE=MyISAM;

--
-- Dumping data for table `docdocument`
--

LOCK TABLES `docdocument` WRITE;
/*!40000 ALTER TABLE `docdocument` DISABLE KEYS */;
/*!40000 ALTER TABLE `docdocument` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `docfolder`
--

DROP TABLE IF EXISTS `docfolder`;
CREATE TABLE `docfolder` (
  `idfolder` bigint(20) NOT NULL default '0',
  `name` varchar(80) NOT NULL default '',
  `description` varchar(150) NOT NULL default '',
  `datecreated` date NOT NULL default '0000-00-00',
  `datemodfified` date default NULL,
  PRIMARY KEY  (`idfolder`)
) TYPE=MyISAM;

--
-- Dumping data for table `docfolder`
--

LOCK TABLES `docfolder` WRITE;
/*!40000 ALTER TABLE `docfolder` DISABLE KEYS */;
/*!40000 ALTER TABLE `docfolder` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `docfolderdocument`
--

DROP TABLE IF EXISTS `docfolderdocument`;
CREATE TABLE `docfolderdocument` (
  `idfolder` bigint(20) NOT NULL default '0',
  `iddocument` bigint(20) NOT NULL default '0',
  KEY `containsdocument_fk` (`idfolder`),
  KEY `iscontainedwithinfolder_fk` (`iddocument`)
) TYPE=MyISAM;

--
-- Dumping data for table `docfolderdocument`
--

LOCK TABLES `docfolderdocument` WRITE;
/*!40000 ALTER TABLE `docfolderdocument` DISABLE KEYS */;
/*!40000 ALTER TABLE `docfolderdocument` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `docuserdocument`
--

DROP TABLE IF EXISTS `docuserdocument`;
CREATE TABLE `docuserdocument` (
  `iddocument` bigint(20) NOT NULL default '0',
  `iduser` bigint(20) NOT NULL default '0',
  `event` int(11) NOT NULL default '0',
  KEY `isbeingchangedbyuser_fk` (`iddocument`),
  KEY `changesdocument_fk` (`iduser`)
) TYPE=MyISAM;

--
-- Dumping data for table `docuserdocument`
--

LOCK TABLES `docuserdocument` WRITE;
/*!40000 ALTER TABLE `docuserdocument` DISABLE KEYS */;
/*!40000 ALTER TABLE `docuserdocument` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `docusertypefolder`
--

DROP TABLE IF EXISTS `docusertypefolder`;
CREATE TABLE `docusertypefolder` (
  `idfolder` bigint(20) NOT NULL default '0',
  `idusertype` bigint(20) NOT NULL default '0',
  `permissionread` int(11) NOT NULL default '0',
  `permissionmodify` int(11) NOT NULL default '0',
  `permissionupload` int(11) NOT NULL default '0',
  KEY `doc_usrtyp_fk` (`idfolder`),
  KEY `hasaccesstofolder_fk` (`idusertype`)
) TYPE=MyISAM;

--
-- Dumping data for table `docusertypefolder`
--

LOCK TABLES `docusertypefolder` WRITE;
/*!40000 ALTER TABLE `docusertypefolder` DISABLE KEYS */;
/*!40000 ALTER TABLE `docusertypefolder` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fmail`
--

DROP TABLE IF EXISTS `fmail`;
CREATE TABLE `fmail` (
  `idfmail` bigint(20) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL default '',
  `notify` smallint(6) NOT NULL default '0',
  `preview` smallint(6) NOT NULL default '0',
  `istext` smallint(6) NOT NULL default '0',
  `subject` varchar(150) default NULL,
  `encoding` varchar(80) default NULL,
  `fromaddress` varchar(80) default NULL,
  `replytoaddress` varchar(80) default NULL,
  `notifyistext` smallint(6) default NULL,
  `notifysubject` varchar(80) default NULL,
  `notifyencoding` varchar(80) default NULL,
  `notifyfromaddress` varchar(80) default NULL,
  `notifyreplytoaddress` varchar(80) 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 */;
INSERT INTO `fmail` VALUES (4,'Prijavnica',0,1,0,'APM - prijavnica','win-1250','root@zpm-si.com','',0,'','win-1250','','');
/*!40000 ALTER TABLE `fmail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fmailreceipient`
--

DROP TABLE IF EXISTS `fmailreceipient`;
CREATE TABLE `fmailreceipient` (
  `idfmail` bigint(20) NOT NULL default '0',
  `email` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`idfmail`,`email`),
  KEY `fml_rec_fk` (`idfmail`)
) TYPE=MyISAM;

--
-- Dumping data for table `fmailreceipient`
--

LOCK TABLES `fmailreceipient` WRITE;
/*!40000 ALTER TABLE `fmailreceipient` DISABLE KEYS */;
INSERT INTO `fmailreceipient` VALUES (4,'roma@rsklan.com'),(4,'uros.cimzar@rsklan.com');
/*!40000 ALTER TABLE `fmailreceipient` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mailfolder`
--

DROP TABLE IF EXISTS `mailfolder`;
CREATE TABLE `mailfolder` (
  `idfolder` bigint(20) NOT NULL auto_increment,
  `description` varchar(80) default NULL,
  PRIMARY KEY  (`idfolder`)
) TYPE=MyISAM;

--
-- Dumping data for table `mailfolder`
--

LOCK TABLES `mailfolder` WRITE;
/*!40000 ALTER TABLE `mailfolder` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailfolder` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mailgroup`
--

DROP TABLE IF EXISTS `mailgroup`;
CREATE TABLE `mailgroup` (
  `idmailgroup` bigint(20) NOT NULL auto_increment,
  `idmailgrouptype` bigint(20) NOT NULL default '0',
  `description` varchar(80) default NULL,
  PRIMARY KEY  (`idmailgroup`),
  KEY `mgt_mg_fk` (`idmailgrouptype`)
) TYPE=MyISAM;

--
-- Dumping data for table `mailgroup`
--

LOCK TABLES `mailgroup` WRITE;
/*!40000 ALTER TABLE `mailgroup` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailgroup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mailgroupdynamic`
--

DROP TABLE IF EXISTS `mailgroupdynamic`;
CREATE TABLE `mailgroupdynamic` (
  `idmailgroup` bigint(20) NOT NULL default '0',
  `query` text,
  PRIMARY KEY  (`idmailgroup`)
) TYPE=MyISAM;

--
-- Dumping data for table `mailgroupdynamic`
--

LOCK TABLES `mailgroupdynamic` WRITE;
/*!40000 ALTER TABLE `mailgroupdynamic` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailgroupdynamic` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mailgroupreceipient`
--

DROP TABLE IF EXISTS `mailgroupreceipient`;
CREATE TABLE `mailgroupreceipient` (
  `idmessage` bigint(20) NOT NULL default '0',
  `idmailgroup` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`idmessage`,`idmailgroup`),
  KEY `mess_mgr_fk` (`idmessage`),
  KEY `mgr_mg_fk` (`idmailgroup`)
) TYPE=MyISAM;

--
-- Dumping data for table `mailgroupreceipient`
--

LOCK TABLES `mailgroupreceipient` WRITE;
/*!40000 ALTER TABLE `mailgroupreceipient` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailgroupreceipient` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mailgroupstatic`
--

DROP TABLE IF EXISTS `mailgroupstatic`;
CREATE TABLE `mailgroupstatic` (
  `idmailgroup` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`idmailgroup`)
) TYPE=MyISAM;

--
-- Dumping data for table `mailgroupstatic`
--

LOCK TABLES `mailgroupstatic` WRITE;
/*!40000 ALTER TABLE `mailgroupstatic` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailgroupstatic` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mailgroupsubject`
--

DROP TABLE IF EXISTS `mailgroupsubject`;
CREATE TABLE `mailgroupsubject` (
  `idmailgroup` bigint(20) NOT NULL default '0',
  `idsubject` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`idmailgroup`,`idsubject`),
  KEY `mg_sub_fk` (`idmailgroup`),
  KEY `sub_mg_fk` (`idsubject`)
) TYPE=MyISAM;

--
-- Dumping data for table `mailgroupsubject`
--

LOCK TABLES `mailgroupsubject` WRITE;
/*!40000 ALTER TABLE `mailgroupsubject` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailgroupsubject` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mailgrouptype`
--

DROP TABLE IF EXISTS `mailgrouptype`;
CREATE TABLE `mailgrouptype` (
  `idmailgrouptype` bigint(20) NOT NULL auto_increment,
  `description` varchar(80) default NULL,
  PRIMARY KEY  (`idmailgrouptype`)
) TYPE=MyISAM;

--
-- Dumping data for table `mailgrouptype`
--

LOCK TABLES `mailgrouptype` WRITE;
/*!40000 ALTER TABLE `mailgrouptype` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailgrouptype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mailmessage`
--

DROP TABLE IF EXISTS `mailmessage`;
CREATE TABLE `mailmessage` (
  `idmessage` bigint(20) NOT NULL auto_increment,
  `idfolder` bigint(20) NOT NULL default '0',
  `subject` varchar(150) default NULL,
  `body` text,
  `datesent` datetime default NULL,
  `encoding` varchar(80) default NULL,
  `replyto` varchar(80) default NULL,
  `sendfrom` varchar(80) default NULL,
  PRIMARY KEY  (`idmessage`),
  KEY `mfol_mess_fk` (`idfolder`)
) TYPE=MyISAM;

--
-- Dumping data for table `mailmessage`
--

LOCK TABLES `mailmessage` WRITE;
/*!40000 ALTER TABLE `mailmessage` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailmessage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mailsubjectreceipient`
--

DROP TABLE IF EXISTS `mailsubjectreceipient`;
CREATE TABLE `mailsubjectreceipient` (
  `idmessage` bigint(20) NOT NULL default '0',
  `idsubject` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`idmessage`,`idsubject`),
  KEY `mess_msr_fk` (`idmessage`),
  KEY `msr_sub_fk` (`idsubject`)
) TYPE=MyISAM;

--
-- Dumping data for table `mailsubjectreceipient`
--

LOCK TABLES `mailsubjectreceipient` WRITE;
/*!40000 ALTER TABLE `mailsubjectreceipient` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailsubjectreceipient` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `photo`
--

DROP TABLE IF EXISTS `photo`;
CREATE TABLE `photo` (
  `idphoto` bigint(20) NOT NULL default '0',
  `idphotocategory` bigint(20) NOT NULL default '0',
  `description` varchar(80) default NULL,
  `author` varchar(150) default NULL,
  `date` datetime default NULL,
  `photo` longblob NOT NULL,
  `thumbnail` longblob NOT NULL,
  `sortorder` int(11) default NULL,
  `width` int(11) NOT NULL default '0',
  `height` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idphoto`),
  KEY `cat_pht_fk` (`idphotocategory`)
) 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` bigint(20) NOT NULL default '0',
  `name` varchar(30) NOT NULL default '',
  `description` varchar(80) default NULL,
  `author` varchar(150) default NULL,
  `date` datetime default NULL,
  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` bigint(20) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `description` varchar(80) default NULL,
  `author` varchar(150) default NULL,
  `date` datetime default NULL,
  `status` smallint(6) default NULL,
  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` bigint(20) NOT NULL auto_increment,
  `idphotocategory` bigint(20) NOT NULL default '0',
  `description` varchar(80) default NULL,
  `author` varchar(150) default NULL,
  `date` datetime default NULL,
  `photo` longblob NOT NULL,
  `thumbnail` longblob NOT NULL,
  `sortorder` int(11) default NULL,
  `width` int(11) NOT NULL default '0',
  `height` int(11) NOT NULL default '0',
  `status` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`idphoto`),
  KEY `cat_prv_pht_fk` (`idphotocategory`)
) 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` bigint(20) NOT NULL auto_increment,
  `locationname` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`idpostaloffice`),
  KEY `sub_post_fk` (`idpostaloffice`)
) TYPE=MyISAM;

--
-- Dumping data for table `postaloffice`
--

LOCK TABLES `postaloffice` WRITE;
/*!40000 ALTER TABLE `postaloffice` DISABLE KEYS */;
/*!40000 ALTER TABLE `postaloffice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `seminar`
--

DROP TABLE IF EXISTS `seminar`;
CREATE TABLE `seminar` (
  `idSeminar` int(11) NOT NULL auto_increment,
  `idSeminarCategory` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `author` varchar(255) NOT NULL default '',
  `points` int(11) default NULL,
  `date1From` date default NULL,
  `date1To` date default NULL,
  `date2From` date default NULL,
  `date2To` date default NULL,
  `days` smallint(6) default '1',
  `price` int(11) default NULL,
  PRIMARY KEY  (`idSeminar`)
) TYPE=MyISAM;

--
-- Dumping data for table `seminar`
--

LOCK TABLES `seminar` WRITE;
/*!40000 ALTER TABLE `seminar` DISABLE KEYS */;
INSERT INTO `seminar` VALUES (1,1,'ABC PROJEKTNEGA MANAGEMENTA','dr. Anton Hauc, mag. Igor Vrečko',10,'2004-02-26',NULL,'2004-09-09',NULL,1,52500),(2,1,'PROJEKTNA ORGANIZACIJA IN PROJEKTNO TIMSKO DELO','dr. Jure Kovač, dr. Andrej Škarabot',10,'2004-02-27',NULL,'2004-09-10',NULL,1,52500),(3,1,'ZAGON IN NAČRTOVANJE PROJEKTOV','Andrej A. Česen, PMP',10,'2004-03-04',NULL,'2004-09-16',NULL,1,52500),(4,1,'ORODJA ZA USPEŠNO IZVEDBO PROJEKTOV','dr. Brane Semolič, dr. Jure Kovač',10,'2004-03-05',NULL,'2004-09-17',NULL,1,52500),(5,1,'EKONOMIKA IN NAČRTOVANJE VREDNOSTI PROJEKTOV','dr. Brane Semolič',10,'2004-03-11',NULL,'2004-09-23',NULL,1,52500),(6,1,'PRAVNI VIDIKI OBVLADOVANJA PROJEKTOV','Tomaž Čad',10,'2004-03-18',NULL,'2004-09-30',NULL,1,52500),(7,1,'PROJEKTNI INFORMACIJSKI SISTEMI','Marko Nemec Pečjak, CPM, mag. Andrej Kerin',10,'2004-03-25',NULL,'2004-10-07',NULL,1,52500),(8,1,'OBVLADOVANJE KAKOVOSTI PROJEKTOV','dr. Andrej Škarabot',10,'2004-03-26',NULL,'2004-10-08',NULL,1,52500),(9,1,'VODENJE PROJEKTOV S POMOČJO MS-Project 2003','Anton Žličar, Denis Premec',20,'2004-04-01','2004-04-02','2004-10-14','2004-10-15',2,76500),(10,1,'PRIPRAVA NA CERTIFICIRANJE','dr. Brane Semolič, dr. Anton Hauc, dr. Andrej Škarabot',10,'2004-04-15',NULL,'2004-10-21',NULL,1,52500),(11,1,'IZPIT SLO-CERT, nivo D','',10,'2004-04-22',NULL,'2004-10-28',NULL,1,52500),(12,2,'USPEŠNO, UČINKOVITO IN ZABAVNO VODENJE PROJEKTOV MIND MANAGER','Mark Stemberger',10,'2004-04-07',NULL,NULL,NULL,1,52500),(13,2,'UVAJANJE PROJEKTNEGA MANAGEMENTA V PODJETJA','Renato Golob',10,'2004-04-16',NULL,NULL,NULL,1,52500),(14,2,'POGODBE IN DRUGI PRAVNI VIDIKI PRI PROJEKTNEM MANAGEMENTU','Tomaž Čad',10,'2004-04-20',NULL,NULL,NULL,1,52500),(15,2,'MANAGEMENT TVEGANOSTI PROJEKTOV','mag. Aljaž Stare, mag. Iza Šušteršič',10,'2004-05-06',NULL,NULL,NULL,1,52500),(16,2,'KOMUNICIRANJE IN MOTIVIRANJE PRI VODENJU PROJEKTA','mag. Aljaž Stare',10,'2004-05-07',NULL,NULL,NULL,1,52500),(17,2,'NADZOR IZVEDBE PROJEKTOV','Andrej A. Česen, PMP',10,'2004-05-13',NULL,NULL,NULL,1,52500),(18,2,'ORGANIZIRANJE IN UVEDBA PROJEKTNE PISARNE','Marko Nemec Pečjak',10,'2004-05-14',NULL,NULL,NULL,1,52500),(19,2,'PROJEKTNI MANAGEMENT V PODJETNIŠTVU','dr. Jordan Berginc',10,'2004-05-19',NULL,NULL,NULL,1,52500),(20,2,'KRIZNI MANAGEMENT NA PROJEKTNI NAČIN','mag. Igor Vrečko',10,'2004-05-27',NULL,NULL,NULL,1,52500),(21,2,'RAČUNOVODSTVO V PROJEKTNEM MANAGEMENTU','mag. Robi Horvat, mag. Nadja Zorko',10,'2004-06-03',NULL,NULL,NULL,1,52500),(22,2,'FINANCIRANJE PROJEKTNEGA PORTFELJA','Aleš Hauc',10,'2004-06-04',NULL,NULL,NULL,1,52500),(23,2,'PROJEKTNI MANAGEMENT V MREŽNIH ORGANIZACIJAH','dr. Brane Semolič',10,'2004-06-11',NULL,NULL,NULL,1,52500),(24,2,'PRIPRAVA NA CERTIFICIRANJE','dr. Brane Semolič, dr. Anton Hauc, dr. Andrej Škarabot',10,'2004-06-17',NULL,NULL,NULL,1,52500),(25,3,'PODROBEN PREGLED PROGRAMOV EU','Saša Keney, Mateja Stanič Rudolf, Andrej Vozlič, Mojca Zajec',30,'2004-02-23',NULL,NULL,NULL,1,52500),(26,3,'PRIDOBIVANJE SREDSTEV ZA RAZVOJNO-RAZISKOVALNE PROJEKTE V OKVIRNEM PROGRAMU: PRIMER PROJEKT','Saša Keney, Mateja Stanič Rudolf, Andrej Vozlič, Mojca Zajec',20,'2004-03-02','2004-03-03',NULL,NULL,2,76500),(27,3,'VIRI FINANCIRANJA PROJEKTOV V EVROPSKI UNIJI','Bojana Omersel',20,'2004-03-01','2004-03-02',NULL,NULL,2,76500),(28,3,'LOGIČNI OKVIR KOT ORODJE PRI PRIPRAVI PREPRIČLJIVIH RAZVOJNIH PROJEKTOV','Bojana Omersel',30,'2004-03-08','2004-03-10',NULL,NULL,3,76500),(29,3,'PRIPRAVA NA CERTIFICIRANJE','dr. Brane Semolič, dr. Anton Hauc, dr. Andrej Škarabot',10,'2004-04-15',NULL,NULL,NULL,1,52500),(30,3,'IZPIT SLO-CERT, nivo D','',NULL,'2004-04-22',NULL,NULL,NULL,1,52500),(31,4,'PROJEKTI REGIONALNEGA RAZVOJA','Bojana Omersel, dr. Brane Semolič',10,NULL,NULL,NULL,NULL,1,52500),(32,4,'PROJEKTI RAZVOJA NOVIH IZDELKOV','mag. Aljaž Stare',10,NULL,NULL,NULL,NULL,1,52500),(33,4,'PROJEKTNI MANAGEMENT V JAVNIH ZAVODIH','dr. Anton Hauc, dr. Andrej Škarabot in sodelavci',10,NULL,NULL,NULL,NULL,1,52500),(34,4,'PROJEKTNI MANAGEMENT V PROJEKTNO USMERJENIH ORGANIZACIJAH IN NAROČNIŠKI PROIZVODNJI','Anton Žličar',10,NULL,NULL,NULL,NULL,1,52500),(35,4,'PROJEKTNI MANAGEMENT PRI MEDNARODNIH PROJEKTIH','dr. Sonja Treven',10,NULL,NULL,NULL,NULL,1,52500),(36,4,'PRENOVA POSLOVNIH PROCESOV S PROJEKTNIM MANAGEMENTOM','Mark Stemberger',10,NULL,NULL,NULL,NULL,1,52500),(37,4,'PROJEKTNI MANAGEMENT V MALIH IN SREDNJIH PODJETJIH','Jordan Berginc',10,NULL,NULL,NULL,NULL,1,52500),(38,5,'INFORMACIJSKI SISTEM V PROJEKTNO USMERJENIH PODJETJIH','mag. Andrej Kerin',10,NULL,NULL,NULL,NULL,1,52500),(39,5,'PODPORA PROJEKTNI ORAGANIZACIJI Z INFORMACIJSKO REŠITVIJO MS Project Server 2002','Denis Premec',10,NULL,NULL,NULL,NULL,1,52500),(40,5,'PROJEKTNI IS: PROJEKTNA PISARNA 3.0','Bogdan Trček',10,NULL,NULL,NULL,NULL,1,52500),(41,5,'VODENJE PROJEKTOV S PRIMAVERA ENTERPRISE','Davor Delič',20,NULL,NULL,NULL,NULL,1,76500),(42,5,'VODENJE ZAHTEVNIH PROJEKTOV RAZVOJA INFORMACIJSKIH SISTEMOV','Mitja Kožman, Vasja Kolšek',10,NULL,NULL,NULL,NULL,1,52500),(43,5,'VODENJE E-PROJEKTOV','Anton Žličar',10,NULL,NULL,NULL,NULL,1,52500);
/*!40000 ALTER TABLE `seminar` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `seminarcategory`
--

DROP TABLE IF EXISTS `seminarcategory`;
CREATE TABLE `seminarcategory` (
  `idSeminarCategory` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`idSeminarCategory`)
) TYPE=MyISAM;

--
-- Dumping data for table `seminarcategory`
--

LOCK TABLES `seminarcategory` WRITE;
/*!40000 ALTER TABLE `seminarcategory` DISABLE KEYS */;
INSERT INTO `seminarcategory` VALUES (1,'Osnovni modul'),(2,'Nadaljevalni modul'),(3,'Modul Projekti EU'),(4,'Tematski modul'),(5,'Modul Projektni informacijski sistemi');
/*!40000 ALTER TABLE `seminarcategory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `statmenuitemclick`
--

DROP TABLE IF EXISTS `statmenuitemclick`;
CREATE TABLE `statmenuitemclick` (
  `idmenuitemclick` bigint(20) NOT NULL auto_increment,
  `menuitemname` varchar(16) NOT NULL default '',
  `hitspublic` int(11) default NULL,
  `hitsusers` int(11) default NULL,
  PRIMARY KEY  (`idmenuitemclick`)
) TYPE=MyISAM;

--
-- Dumping data for table `statmenuitemclick`
--

LOCK TABLES `statmenuitemclick` WRITE;
/*!40000 ALTER TABLE `statmenuitemclick` DISABLE KEYS */;
INSERT INTO `statmenuitemclick` VALUES (69,'PrvaStran',127,NULL),(70,'Prijavnica',262,NULL),(71,'Kontakt',1115,NULL),(72,'Program',358,NULL),(73,'ProgramOsnM',6739,NULL),(74,'ProgramNadM',591,NULL),(75,'ProgramIzbM',496,NULL),(76,'PravnaOp',482,NULL),(77,'Avtorji',541,NULL),(78,'ProjSola',656,NULL),(79,'MednCert',682,NULL),(80,'ProgramDod',286,NULL),(81,'ProgramSloCert',418,NULL),(82,'ProgramInfoPrija',1,NULL),(83,'ProgramInfoPrija',1,NULL),(84,'ProgramInfoPrija',1,NULL),(85,'ProgramInfoPrija',1,NULL),(86,'ProgramInfoPrija',1,NULL),(87,'ProgramInfoPrija',1,NULL),(88,'ProgramInfoPrija',1,NULL),(89,'ProgramInfoPrija',1,NULL),(90,'ProgramInfoPrija',1,NULL),(91,'ProgramInfoPrija',1,NULL),(92,'ProgramInfoPrija',1,NULL),(93,'ProgramInfoPrija',1,NULL),(94,'ProgramInfoPrija',1,NULL),(95,'ProgramInfoPrija',1,NULL),(96,'ProgramInfoPrija',1,NULL),(97,'ProgramInfoPrija',1,NULL),(98,'ProgramInfoPrija',1,NULL),(99,'ProgramInfoPrija',1,NULL),(100,'ProgramInfoPrija',1,NULL),(101,'ProgramInfoPrija',1,NULL),(102,'ProgramInfoPrija',1,NULL),(103,'ProgramInfoPrija',1,NULL),(104,'ProgramInfoPrija',1,NULL),(105,'ProgramInfoPrija',1,NULL),(106,'ProgramInfoPrija',1,NULL),(107,'ProgramInfoPrija',1,NULL),(108,'ProgramInfoPrija',1,NULL),(109,'ProgramInfoPrija',1,NULL),(110,'ProgramInfoPrija',1,NULL),(111,'ProgramInfoPrija',1,NULL),(112,'ProgramInfoPrija',1,NULL),(113,'ProgramInfoPrija',1,NULL),(114,'ProgramInfoPrija',1,NULL),(115,'ProgramInfoPrija',1,NULL),(116,'ProgramInfoPrija',1,NULL),(117,'ProgramInfoDod',329,NULL),(118,'ProgramInfoPrija',1,NULL),(119,'CategoryAdmin',3,NULL),(120,'Aktualno',1596,NULL),(121,'ProgramInfoPrija',1,NULL),(122,'ProgramInfoPrija',1,NULL),(123,'ProgramInfoPrija',1,NULL),(124,'ProgramInfoPrija',1,NULL),(125,'ProgramInfoPrija',1,NULL),(126,'ProgramInfoPrija',1,NULL),(127,'ProgramInfoPrija',1,NULL),(128,'ProgramInfoPrija',1,NULL),(129,'ProgramInfoPrija',1,NULL),(130,'ProgramInfoPrija',1,NULL),(131,'ProgramInfoPrija',1,NULL),(132,'ProgramInfoPrija',1,NULL),(133,'ProgramInfoPrija',1,NULL),(134,'ProgramInfoPrija',1,NULL),(135,'ProgramInfoPrija',1,NULL),(136,'ProgramInfoPrija',1,NULL),(137,'ProgramInfoPrija',1,NULL),(138,'ProgramInfoPrija',1,NULL),(139,'ProgramInfoPrija',1,NULL),(140,'ProgramInfoPrija',1,NULL),(141,'ProgramInfoPrija',1,NULL),(142,'ProgramInfoPrija',1,NULL),(143,'ProgramInfoPrija',1,NULL),(144,'ProgramInfoPrija',1,NULL),(145,'ProgramInfoPrija',1,NULL),(146,'ProgramInfoPrija',1,NULL),(147,'ProgramInfoPrija',1,NULL),(148,'ProgramInfoPrija',1,NULL),(149,'ProgramInfoPrija',1,NULL),(150,'ProgramInfoPrija',1,NULL),(151,'ProgramInfoPrija',1,NULL),(152,'ProgramInfoPrija',1,NULL),(153,'ProgramInfoPrija',1,NULL),(154,'ProgramInfoPrija',1,NULL),(155,'ProgramInfoPrija',1,NULL),(156,'ProgramInfoPrija',1,NULL),(157,'ProgramInfoPrija',1,NULL),(158,'ProgramInfoPrija',1,NULL),(159,'ProgramInfoPrija',1,NULL),(160,'ProgramInfoPrija',1,NULL),(161,'ProgramInfoPrija',1,NULL),(162,'ProgramInfoPrija',1,NULL),(163,'ProgramInfoPrija',1,NULL),(164,'ProgramInfoPrija',1,NULL),(165,'ProgramInfoPrija',1,NULL),(166,'ProgramInfoPrija',1,NULL),(167,'ProgramInfoPrija',1,NULL),(168,'ProgramInfoPrija',1,NULL),(169,'ProgramInfoPrija',1,NULL),(170,'ProgramInfoPrija',1,NULL),(171,'ProgramInfoPrija',1,NULL),(172,'ProgramInfoPrija',1,NULL),(173,'ProgramInfoPrija',1,NULL),(174,'ProgramInfoPrija',1,NULL),(175,'ProgramInfoPrija',1,NULL),(176,'ProgramInfoPrija',1,NULL),(177,'ProgramInfoPrija',1,NULL),(178,'ProgramInfoPrija',1,NULL),(179,'ProgramInfoPrija',1,NULL),(180,'ProgramInfoPrija',1,NULL),(181,'ProgramInfoPrija',1,NULL),(182,'ProgramInfoPrija',1,NULL),(183,'ProgramInfoPrija',1,NULL),(184,'ProgramInfoPrija',1,NULL),(185,'ProgramInfoPrija',1,NULL),(186,'ProgramInfoPrija',1,NULL),(187,'ProgramInfoPrija',1,NULL),(188,'ProgramInfoPrija',1,NULL),(189,'ProgramInfoPrija',1,NULL),(190,'ProgramInfoPrija',1,NULL),(191,'ProgramInfoPrija',1,NULL),(192,'ProgramInfoPrija',1,NULL),(193,'ProgramInfoPrija',1,NULL),(194,'ProgramInfoPrija',1,NULL),(195,'ProgramInfoPrija',1,NULL),(196,'ProgramInfoPrija',1,NULL),(197,'ProgramInfoPrija',1,NULL),(198,'ProgramInfoPrija',1,NULL),(199,'ProgramInfoPrija',1,NULL),(200,'ProgramInfoPrija',1,NULL),(201,'ProgramInfoPrija',1,NULL),(202,'ProgramInfoPrija',1,NULL),(203,'ProgramInfoPrija',1,NULL),(204,'ProgramInfoPrija',1,NULL),(205,'ProgramInfoPrija',1,NULL),(206,'ProgramInfoPrija',1,NULL),(207,'ProgramInfoPrija',1,NULL),(208,'ProgramInfoPrija',1,NULL),(209,'ProgramInfoPrija',1,NULL),(210,'ProgramInfoPrija',1,NULL),(211,'ProgramInfoPrija',1,NULL),(212,'ProgramInfoPrija',1,NULL),(213,'ProgramInfoPrija',1,NULL),(214,'ProgramInfoPrija',1,NULL),(215,'ProgramInfoPrija',1,NULL),(216,'ProgramInfoPrija',1,NULL),(217,'ProgramInfoPrija',1,NULL),(218,'ProgramInfoPrija',1,NULL),(219,'ProgramInfoPrija',1,NULL),(220,'ProgramInfoPrija',1,NULL),(221,'ProgramInfoPrija',1,NULL),(222,'ProgramInfoPrija',1,NULL),(223,'ProgramInfoPrija',1,NULL),(224,'ProgramInfoPrija',1,NULL),(225,'ProgramInfoPrija',1,NULL),(226,'ProgramInfoPrija',1,NULL),(227,'ProgramInfoPrija',1,NULL),(228,'ProgramInfoPrija',1,NULL),(229,'ProgramInfoPrija',1,NULL),(230,'ProgramInfoPrija',1,NULL),(231,'ProgramInfoPrija',1,NULL),(232,'ProgramInfoPrija',1,NULL),(233,'ProgramInfoPrija',1,NULL),(234,'ProgramInfoPrija',1,NULL),(235,'ProgramInfoPrija',1,NULL),(236,'ProgramInfoPrija',1,NULL),(237,'ProgramInfoPrija',1,NULL),(238,'ProgramInfoPrija',1,NULL),(239,'ProgramInfoPrija',1,NULL),(240,'ProgramInfoPrija',1,NULL),(241,'ProgramInfoPrija',1,NULL),(242,'ProgramInfoPrija',1,NULL),(243,'ProgramInfoPrija',1,NULL),(244,'ProgramInfoPrija',1,NULL),(245,'ProgramInfoPrija',1,NULL),(246,'ProgramInfoPrija',1,NULL),(247,'ProgramInfoPrija',1,NULL),(248,'ProgramInfoPrija',1,NULL),(249,'ProgramInfoPrija',1,NULL),(250,'ProgramInfoPrija',1,NULL),(251,'ProgramInfoPrija',1,NULL),(252,'ProgramInfoPrija',1,NULL),(253,'ProgramInfoPrija',1,NULL),(254,'ProgramInfoPrija',1,NULL),(255,'ProgramInfoPrija',1,NULL),(256,'ProgramInfoPrija',1,NULL),(257,'ProgramInfoPrija',1,NULL),(258,'ProgramInfoPrija',1,NULL),(259,'ProgramInfoPrija',1,NULL),(260,'ProgramInfoPrija',1,NULL),(261,'ProgramInfoPrija',1,NULL),(262,'ProgramInfoPrija',1,NULL),(263,'ProgramInfoPrija',1,NULL),(264,'ProgramInfoPrija',1,NULL),(265,'ProgramInfoPrija',1,NULL),(266,'ProgramInfoPrija',1,NULL),(267,'ProgramInfoPrija',1,NULL),(268,'ProgramInfoPrija',1,NULL),(269,'ProgramInfoPrija',1,NULL),(270,'ProgramInfoPrija',1,NULL),(271,'ProgramInfoPrija',1,NULL),(272,'ProgramInfoPrija',1,NULL),(273,'ProgramInfoPrija',1,NULL),(274,'ProgramInfoPrija',1,NULL),(275,'ProgramInfoPrija',1,NULL),(276,'ProgramInfoPrija',1,NULL),(277,'ProgramInfoPrija',1,NULL),(278,'ProgramInfoPrija',1,NULL),(279,'ProgramInfoPrija',1,NULL),(280,'ProgramInfoPrija',1,NULL),(281,'ProgramInfoPrija',1,NULL),(282,'ProgramInfoPrija',1,NULL),(283,'ProgramInfoPrija',1,NULL),(284,'ProgramInfoPrija',1,NULL),(285,'ProgramInfoPrija',1,NULL),(286,'ProgramInfoPrija',1,NULL),(287,'ProgramInfoPrija',1,NULL),(288,'ProgramInfoPrija',1,NULL),(289,'ProgramInfoPrija',1,NULL),(290,'ProgramInfoPrija',1,NULL),(291,'ProgramInfoPrija',1,NULL),(292,'ProgramInfoPrija',1,NULL),(293,'ProgramInfoPrija',1,NULL),(294,'ProgramInfoPrija',1,NULL),(295,'ProgramInfoPrija',1,NULL),(296,'ProgramInfoPrija',1,NULL),(297,'ProgramInfoPrija',1,NULL),(298,'ProgramInfoPrija',1,NULL),(299,'ProgramInfoPrija',1,NULL),(300,'ProgramInfoPrija',1,NULL),(301,'ProgramInfoPrija',1,NULL),(302,'ProgramInfoPrija',1,NULL),(303,'ProgramInfoPrija',1,NULL),(304,'ProgramInfoPrija',1,NULL),(305,'ProgramInfoPrija',1,NULL),(306,'ProgramInfoPrija',1,NULL),(307,'ProgramInfoPrija',1,NULL),(308,'ProgramInfoPrija',1,NULL),(309,'ProgramInfoPrija',1,NULL),(310,'ProgramInfoPrija',1,NULL),(311,'ProgramInfoPrija',1,NULL),(312,'ProgramInfoPrija',1,NULL),(313,'ProgramInfoPrija',1,NULL),(314,'ProgramInfoPrija',1,NULL),(315,'ProgramInfoPrija',1,NULL),(316,'ProgramInfoPrija',1,NULL),(317,'ProgramInfoPrija',1,NULL),(318,'ProgramInfoPrija',1,NULL),(319,'ProgramInfoPrija',1,NULL),(320,'ProgramInfoPrija',1,NULL),(321,'ProgramInfoPrija',1,NULL),(322,'ProgramInfoPrija',1,NULL),(323,'ProgramInfoPrija',1,NULL),(324,'ProgramInfoPrija',1,NULL),(325,'ProgramInfoPrija',1,NULL),(326,'ProgramInfoPrija',1,NULL),(327,'ProgramInfoPrija',1,NULL),(328,'ProgramInfoPrija',1,NULL),(329,'ProgramInfoPrija',1,NULL),(330,'ProgramInfoPrija',1,NULL),(331,'ProgramInfoPrija',1,NULL),(332,'ProgramInfoPrija',1,NULL),(333,'ProgramInfoPrija',1,NULL),(334,'ProgramInfoPrija',1,NULL),(335,'ProgramInfoPrija',1,NULL),(336,'ProgramInfoPrija',1,NULL),(337,'ProgramInfoPrija',1,NULL),(338,'ProgramInfoPrija',1,NULL),(339,'ProgramInfoPrija',1,NULL),(340,'ProgramInfoPrija',1,NULL),(341,'ProgramInfoPrija',1,NULL),(342,'ProgramInfoPrija',1,NULL),(343,'ProgramInfoPrija',1,NULL),(344,'ProgramInfoPrija',1,NULL),(345,'ProgramInfoPrija',1,NULL),(346,'ProgramInfoPrija',1,NULL),(347,'ProgramInfoPrija',1,NULL),(348,'ProgramInfoPrija',1,NULL),(349,'ProgramInfoPrija',1,NULL),(350,'ProgramInfoPrija',1,NULL),(351,'ProgramInfoPrija',1,NULL),(352,'ProgramInfoPrija',1,NULL),(353,'ProgramInfoPrija',1,NULL),(354,'ProgramInfoPrija',1,NULL),(355,'ProgramInfoPrija',1,NULL),(356,'ProgramInfoPrija',1,NULL),(357,'ProgramInfoPrija',1,NULL),(358,'ProgramInfoPrija',1,NULL),(359,'ProgramInfoPrija',1,NULL),(360,'ProgramInfoPrija',1,NULL),(361,'ProgramInfoPrija',1,NULL),(362,'ProgramInfoPrija',1,NULL),(363,'ProgramInfoPrija',1,NULL),(364,'ProgramInfoPrija',1,NULL),(365,'ProgramInfoPrija',1,NULL),(366,'ProgramInfoPrija',1,NULL),(367,'ProgramInfoPrija',1,NULL),(368,'ProgramInfoPrija',1,NULL),(369,'ProgramInfoPrija',1,NULL),(370,'ProgramInfoPrija',1,NULL),(371,'ProgramInfoPrija',1,NULL),(372,'ProgramInfoPrija',1,NULL),(373,'ProgramInfoPrija',1,NULL),(374,'ProgramInfoPrija',1,NULL),(375,'ProgramInfoPrija',1,NULL),(376,'ProgramInfoPrija',1,NULL),(377,'ProgramInfoPrija',1,NULL),(378,'ProgramInfoPrija',1,NULL),(379,'ProgramInfoPrija',1,NULL),(380,'ProgramInfoPrija',1,NULL),(381,'ProgramInfoPrija',1,NULL),(382,'ProgramInfoPrija',1,NULL),(383,'ProgramInfoPrija',1,NULL),(384,'ProgramInfoPrija',1,NULL),(385,'ProgramInfoPrija',1,NULL),(386,'ProgramInfoPrija',1,NULL),(387,'ProgramInfoPrija',1,NULL),(388,'ProgramInfoPrija',1,NULL),(389,'ProgramInfoPrija',1,NULL),(390,'ProgramInfoPrija',1,NULL),(391,'ProgramInfoPrija',1,NULL),(392,'ProgramInfoPrija',1,NULL),(393,'ProgramInfoPrija',1,NULL),(394,'ProgramInfoPrija',1,NULL),(395,'ProgramInfoPrija',1,NULL),(396,'ProgramInfoPrija',1,NULL),(397,'ProgramInfoPrija',1,NULL),(398,'ProgramInfoPrija',1,NULL),(399,'ProgramInfoPrija',1,NULL),(400,'ProgramInfoPrija',1,NULL),(401,'ProgramInfoPrija',1,NULL),(402,'ProgramInfoPrija',1,NULL),(403,'ProgramInfoPrija',1,NULL),(404,'ProgramInfoPrija',1,NULL),(405,'ProgramInfoPrija',1,NULL),(406,'ProgramInfoPrija',1,NULL),(407,'ProgramInfoPrija',1,NULL),(408,'ProgramInfoPrija',1,NULL),(409,'ProgramInfoPrija',1,NULL),(410,'ProgramInfoPrija',1,NULL),(411,'ProgramInfoPrija',1,NULL),(412,'ProgramInfoPrija',1,NULL),(413,'ProgramInfoPrija',1,NULL),(414,'ProgramInfoPrija',1,NULL),(415,'ProgramInfoPrija',1,NULL),(416,'ProgramInfoPrija',1,NULL),(417,'ProgramInfoPrija',1,NULL),(418,'ProgramInfoPrija',1,NULL),(419,'ProgramInfoPrija',1,NULL),(420,'ProgramInfoPrija',1,NULL),(421,'ProgramInfoPrija',1,NULL),(422,'ProgramInfoPrija',1,NULL),(423,'ProgramInfoPrija',1,NULL),(424,'ProgramInfoPrija',1,NULL),(425,'ProgramInfoPrija',1,NULL),(426,'ProgramInfoPrija',1,NULL),(427,'ProgramInfoPrija',1,NULL),(428,'ProgramInfoPrija',1,NULL),(429,'ProgramInfoPrija',1,NULL),(430,'ProgramInfoPrija',1,NULL),(431,'ProgramInfoPrija',1,NULL),(432,'ProgramInfoPrija',1,NULL),(433,'ProgramInfoPrija',1,NULL),(434,'ProgramInfoPrija',1,NULL),(435,'ProgramInfoPrija',1,NULL),(436,'ProgramInfoPrija',1,NULL),(437,'ProgramInfoPrija',1,NULL),(438,'ProgramInfoPrija',1,NULL),(439,'ProgramInfoPrija',1,NULL),(440,'ProgramInfoPrija',1,NULL),(441,'ProgramInfoPrija',1,NULL),(442,'ProgramInfoPrija',1,NULL),(443,'ProgramInfoPrija',1,NULL),(444,'ProgramInfoPrija',1,NULL),(445,'ProgramInfoPrija',1,NULL),(446,'ProgramInfoPrija',1,NULL),(447,'ProgramInfoPrija',1,NULL),(448,'ProgramInfoPrija',1,NULL),(449,'ProgramInfoPrija',1,NULL),(450,'ProgramInfoPrija',1,NULL),(451,'ProgramInfoPrija',1,NULL),(452,'ProgramInfoPrija',1,NULL),(453,'ProgramInfoPrija',1,NULL),(454,'ProgramInfoPrija',1,NULL),(455,'ProgramInfoPrija',1,NULL),(456,'ProgramInfoPrija',1,NULL),(457,'ProgramInfoPrija',1,NULL),(458,'ProgramInfoPrija',1,NULL),(459,'ProgramInfoPrija',1,NULL),(460,'ProgramInfoPrija',1,NULL),(461,'ProgramInfoPrija',1,NULL),(462,'ProgramInfoPrija',1,NULL),(463,'ProgramInfoPrija',1,NULL),(464,'ProgramInfoPrija',1,NULL),(465,'ProgramInfoPrija',1,NULL),(466,'ProgramInfoPrija',1,NULL),(467,'ProgramInfoPrija',1,NULL),(468,'ProgramInfoPrija',1,NULL),(469,'ProgramInfoPrija',1,NULL),(470,'ProgramInfoPrija',1,NULL),(471,'ProgramInfoPrija',1,NULL),(472,'ProgramInfoPrija',1,NULL),(473,'ProgramInfoPrija',1,NULL),(474,'ProgramInfoPrija',1,NULL),(475,'ProgramInfoPrija',1,NULL),(476,'ProgramInfoPrija',1,NULL),(477,'ProgramInfoPrija',1,NULL),(478,'ProgramInfoPrija',1,NULL),(479,'ProgramInfoPrija',1,NULL),(480,'ProgramInfoPrija',1,NULL),(481,'ProgramInfoPrija',1,NULL),(482,'ProgramInfoPrija',1,NULL),(483,'ProgramInfoPrija',1,NULL),(484,'ProgramInfoPrija',1,NULL),(485,'ProgramInfoPrija',1,NULL),(486,'ProgramInfoPrija',1,NULL),(487,'ProgramInfoPrija',1,NULL),(488,'ProgramInfoPrija',1,NULL),(489,'ProgramInfoPrija',1,NULL),(490,'ProgramInfoPrija',1,NULL),(491,'ProgramInfoPrija',1,NULL),(492,'ProgramInfoPrija',1,NULL),(493,'ProgramInfoPrija',1,NULL),(494,'ProgramInfoPrija',1,NULL),(495,'ProgramInfoPrija',1,NULL),(496,'ProgramInfoPrija',1,NULL),(497,'ProgramInfoPrija',1,NULL),(498,'ProgramInfoPrija',1,NULL),(499,'ProgramInfoPrija',1,NULL),(500,'ProgramInfoPrija',1,NULL),(501,'ProgramInfoPrija',1,NULL),(502,'ProgramInfoPrija',1,NULL),(503,'ProgramInfoPrija',1,NULL),(504,'ProgramInfoPrija',1,NULL),(505,'ProgramInfoPrija',1,NULL),(506,'ProgramInfoPrija',1,NULL),(507,'ProgramInfoPrija',1,NULL),(508,'ProgramInfoPrija',1,NULL),(509,'ProgramInfoPrija',1,NULL),(510,'ProgramInfoPrija',1,NULL),(511,'ProgramInfoPrija',1,NULL),(512,'ProgramInfoPrija',1,NULL),(513,'ProgramInfoPrija',1,NULL),(514,'ProgramInfoPrija',1,NULL),(515,'ProgramInfoPrija',1,NULL),(516,'ProgramInfoPrija',1,NULL),(517,'ProgramInfoPrija',1,NULL),(518,'ProgramInfoPrija',1,NULL),(519,'ProgramInfoPrija',1,NULL),(520,'ProgramInfoPrija',1,NULL),(521,'ProgramInfoPrija',1,NULL),(522,'ProgramInfoPrija',1,NULL),(523,'ProgramInfoPrija',1,NULL),(524,'ProgramInfoPrija',1,NULL),(525,'ProgramInfoPrija',1,NULL),(526,'ProgramInfoPrija',1,NULL),(527,'ProgramInfoPrija',1,NULL),(528,'ProgramInfoPrija',1,NULL),(529,'ProgramInfoPrija',1,NULL),(530,'ProgramInfoPrija',1,NULL),(531,'ProgramInfoPrija',1,NULL),(532,'ProgramInfoPrija',1,NULL),(533,'ProgramInfoPrija',1,NULL),(534,'ProgramInfoPrija',1,NULL),(535,'ProgramInfoPrija',1,NULL),(536,'ProgramInfoPrija',1,NULL),(537,'ProgramInfoPrija',1,NULL),(538,'ProgramInfoPrija',1,NULL),(539,'ProgramInfoPrija',1,NULL),(540,'ProgramInfoPrija',1,NULL),(541,'ProgramInfoPrija',1,NULL),(542,'ProgramInfoPrija',1,NULL),(543,'ProgramInfoPrija',1,NULL),(544,'ProgramInfoPrija',1,NULL),(545,'ProgramInfoPrija',1,NULL),(546,'ProgramInfoPrija',1,NULL),(547,'ProgramInfoPrija',1,NULL),(548,'ProgramInfoPrija',1,NULL),(549,'ProgramInfoPrija',1,NULL),(550,'ProgramInfoPrija',1,NULL),(551,'ProgramInfoPrija',1,NULL),(552,'ProgramInfoPrija',1,NULL),(553,'ProgramInfoPrija',1,NULL),(554,'ProgramInfoPrija',1,NULL),(555,'ProgramInfoPrija',1,NULL),(556,'ProgramInfoPrija',1,NULL),(557,'ProgramInfoPrija',1,NULL),(558,'ProgramInfoPrija',1,NULL),(559,'ProgramInfoPrija',1,NULL),(560,'ProgramInfoPrija',1,NULL),(561,'ProgramInfoPrija',1,NULL),(562,'ProgramInfoPrija',1,NULL),(563,'ProgramInfoPrija',1,NULL),(564,'ProgramInfoPrija',1,NULL),(565,'ProgramInfoPrija',1,NULL),(566,'ProgramInfoPrija',1,NULL),(567,'ProgramInfoPrija',1,NULL),(568,'ProgramInfoPrija',1,NULL),(569,'ProgramInfoPrija',1,NULL),(570,'ProgramInfoPrija',1,NULL),(571,'ProgramInfoPrija',1,NULL),(572,'ProgramInfoPrija',1,NULL),(573,'ProgramInfoPrija',1,NULL),(574,'ProgramInfoPrija',1,NULL),(575,'ProgramInfoPrija',1,NULL),(576,'ProgramInfoPrija',1,NULL),(577,'ProgramInfoPrija',1,NULL),(578,'ProgramInfoPrija',1,NULL),(579,'ProgramInfoPrija',1,NULL),(580,'ProgramInfoPrija',1,NULL),(581,'ProgramInfoPrija',1,NULL),(582,'ProgramInfoPrija',1,NULL),(583,'ProgramInfoPrija',1,NULL),(584,'ProgramInfoPrija',1,NULL),(585,'ProgramInfoPrija',1,NULL),(586,'ProgramInfoPrija',1,NULL),(587,'ProgramInfoPrija',1,NULL),(588,'ProgramInfoPrija',1,NULL),(589,'ProgramInfoPrija',1,NULL),(590,'ProgramInfoPrija',1,NULL),(591,'ProgramInfoPrija',1,NULL),(592,'ProgramInfoPrija',1,NULL),(593,'ProgramInfoPrija',1,NULL),(594,'ProgramInfoPrija',1,NULL),(595,'ProgramInfoPrija',1,NULL),(596,'ProgramInfoPrija',1,NULL),(597,'ProgramInfoPrija',1,NULL),(598,'ProgramInfoPrija',1,NULL),(599,'ProgramInfoPrija',1,NULL),(600,'ProgramInfoPrija',1,NULL),(601,'ProgramInfoPrija',1,NULL),(602,'ProgramInfoPrija',1,NULL),(603,'ProgramInfoPrija',1,NULL),(604,'ProgramInfoPrija',1,NULL),(605,'ProgramInfoPrija',1,NULL),(606,'ProgramInfoPrija',1,NULL),(607,'ProgramInfoPrija',1,NULL),(608,'ProgramInfoPrija',1,NULL),(609,'ProgramInfoPrija',1,NULL),(610,'ProgramInfoPrija',1,NULL),(611,'ProgramInfoPrija',1,NULL),(612,'ProgramInfoPrija',1,NULL),(613,'ProgramInfoPrija',1,NULL),(614,'ProgramInfoPrija',1,NULL),(615,'ProgramInfoPrija',1,NULL),(616,'ProgramInfoPrija',1,NULL),(617,'ProgramInfoPrija',1,NULL),(618,'ProgramInfoPrija',1,NULL),(619,'ProgramInfoPrija',1,NULL),(620,'ProgramInfoPrija',1,NULL),(621,'ProgramInfoPrija',1,NULL),(622,'ProgramInfoPrija',1,NULL),(623,'ProgramInfoPrija',1,NULL),(624,'ProgramInfoPrija',1,NULL),(625,'ProgramInfoPrija',1,NULL),(626,'ProgramInfoPrija',1,NULL),(627,'ProgramInfoPrija',1,NULL),(628,'ProgramInfoPrija',1,NULL),(629,'ProgramInfoPrija',1,NULL),(630,'ProgramInfoPrija',1,NULL),(631,'ProgramInfoPrija',1,NULL),(632,'ProgramInfoPrija',1,NULL),(633,'ProgramInfoPrija',1,NULL),(634,'ProgramInfoPrija',1,NULL),(635,'ProgramInfoPrija',1,NULL),(636,'ProgramInfoPrija',1,NULL),(637,'ProgramInfoPrija',1,NULL),(638,'ProgramInfoPrija',1,NULL),(639,'ProgramInfoPrija',1,NULL),(640,'ProgramInfoPrija',1,NULL),(641,'ProgramInfoPrija',1,NULL),(642,'ProgramInfoPrija',1,NULL),(643,'ProgramInfoPrija',1,NULL),(644,'ProgramInfoPrija',1,NULL),(645,'ProgramInfoPrija',1,NULL),(646,'ProgramInfoPrija',1,NULL),(647,'ProgramInfoPrija',1,NULL),(648,'ProgramInfoPrija',1,NULL),(649,'ProgramInfoPrija',1,NULL),(650,'ProgramInfoPrija',1,NULL),(651,'ProgramInfoPrija',1,NULL),(652,'ProgramInfoPrija',1,NULL),(653,'ProgramInfoPrija',1,NULL),(654,'ProgramInfoPrija',1,NULL),(655,'ProgramInfoPrija',1,NULL),(656,'ProgramInfoPrija',1,NULL),(657,'ProgramInfoPrija',1,NULL),(658,'ProgramInfoPrija',1,NULL),(659,'ProgramInfoPrija',1,NULL),(660,'ProgramInfoPrija',1,NULL),(661,'ProgramInfoPrija',1,NULL),(662,'ProgramInfoPrija',1,NULL),(663,'ProgramInfoPrija',1,NULL),(664,'ProgramInfoPrija',1,NULL),(665,'ProgramInfoPrija',1,NULL),(666,'ProgramInfoPrija',1,NULL),(667,'ProgramInfoPrija',1,NULL),(668,'ProgramInfoPrija',1,NULL),(669,'ProgramInfoPrija',1,NULL),(670,'ProgramInfoPrija',1,NULL),(671,'ProgramInfoPrija',1,NULL),(672,'ProgramInfoPrija',1,NULL),(673,'ProgramInfoPrija',1,NULL),(674,'ProgramInfoPrija',1,NULL),(675,'ProgramInfoPrija',1,NULL),(676,'ProgramInfoPrija',1,NULL),(677,'ProgramInfoPrija',1,NULL),(678,'ProgramInfoPrija',1,NULL),(679,'ProgramInfoPrija',1,NULL),(680,'ProgramInfoPrija',1,NULL),(681,'ProgramInfoPrija',1,NULL),(682,'ProgramInfoPrija',1,NULL),(683,'ProgramInfoPrija',1,NULL),(684,'ProgramInfoPrija',1,NULL),(685,'ProgramInfoPrija',1,NULL),(686,'ProgramInfoPrija',1,NULL),(687,'ProgramInfoPrija',1,NULL),(688,'ProgramInfoPrija',1,NULL),(689,'ProgramInfoPrija',1,NULL),(690,'ProgramInfoPrija',1,NULL),(691,'ProgramInfoPrija',1,NULL),(692,'ProgramInfoPrija',1,NULL),(693,'ProgramInfoPrija',1,NULL),(694,'ProgramInfoPrija',1,NULL),(695,'ProgramInfoPrija',1,NULL),(696,'ProgramInfoPrija',1,NULL),(697,'ProgramInfoPrija',1,NULL),(698,'ProgramInfoPrija',1,NULL),(699,'ProgramInfoPrija',1,NULL),(700,'ProgramInfoPrija',1,NULL),(701,'ProgramInfoPrija',1,NULL),(702,'ProgramInfoPrija',1,NULL),(703,'ProgramInfoPrija',1,NULL),(704,'ProgramInfoPrija',1,NULL),(705,'ProgramInfoPrija',1,NULL),(706,'ProgramInfoPrija',1,NULL),(707,'ProgramInfoPrija',1,NULL),(708,'ProgramInfoPrija',1,NULL),(709,'ProgramInfoPrija',1,NULL),(710,'ProgramInfoPrija',1,NULL),(711,'ProgramInfoPrija',1,NULL),(712,'ProgramInfoPrija',1,NULL),(713,'ProgramInfoPrija',1,NULL),(714,'ProgramInfoPrija',1,NULL),(715,'ProgramInfoPrija',1,NULL),(716,'ProgramInfoPrija',1,NULL),(717,'ProgramInfoPrija',1,NULL),(718,'ProgramInfoPrija',1,NULL),(719,'ProgramInfoPrija',1,NULL),(720,'ProgramInfoPrija',1,NULL),(721,'ProgramInfoPrija',1,NULL),(722,'ProgramInfoPrija',1,NULL),(723,'ProgramInfoPrija',1,NULL),(724,'ProgramInfoPrija',1,NULL),(725,'ProgramInfoPrija',1,NULL),(726,'ProgramInfoPrija',1,NULL),(727,'ProgramInfoPrija',1,NULL),(728,'ProgramInfoPrija',1,NULL),(729,'ProgramInfoPrija',1,NULL),(730,'ProgramInfoPrija',1,NULL),(731,'ProgramInfoPrija',1,NULL),(732,'ProgramInfoPrija',1,NULL),(733,'ProgramInfoPrija',1,NULL),(734,'ProgramInfoPrija',1,NULL),(735,'ProgramInfoPrija',1,NULL),(736,'ProgramInfoPrija',1,NULL),(737,'ProgramInfoPrija',1,NULL),(738,'ProgramInfoPrija',1,NULL),(739,'ProgramInfoPrija',1,NULL),(740,'ProgramInfoPrija',1,NULL),(741,'ProgramInfoPrija',1,NULL),(742,'ProgramInfoPrija',1,NULL),(743,'ProgramInfoPrija',1,NULL),(744,'ProgramInfoPrija',1,NULL),(745,'ProgramInfoPrija',1,NULL),(746,'ProgramInfoPrija',1,NULL),(747,'ProgramInfoPrija',1,NULL),(748,'ProgramInfoPrija',1,NULL),(749,'ProgramInfoPrija',1,NULL),(750,'ProgramInfoPrija',1,NULL),(751,'ProgramInfoPrija',1,NULL),(752,'ProgramInfoPrija',1,NULL),(753,'ProgramInfoPrija',1,NULL),(754,'ProgramInfoPrija',1,NULL),(755,'ProgramInfoPrija',1,NULL),(756,'ProgramInfoPrija',1,NULL),(757,'ProgramInfoPrija',1,NULL),(758,'ProgramInfoPrija',1,NULL),(759,'ProgramInfoPrija',1,NULL),(760,'ProgramInfoPrija',1,NULL),(761,'ProgramInfoPrija',1,NULL),(762,'ProgramInfoPrija',1,NULL),(763,'ProgramInfoPrija',1,NULL),(764,'ProgramInfoPrija',1,NULL),(765,'ProgramInfoPrija',1,NULL),(766,'ProgramInfoPrija',1,NULL),(767,'ProgramInfoPrija',1,NULL),(768,'ProgramInfoPrija',1,NULL),(769,'ProgramInfoPrija',1,NULL),(770,'ProgramInfoPrija',1,NULL),(771,'ProgramInfoPrija',1,NULL),(772,'ProgramInfoPrija',1,NULL),(773,'ProgramInfoPrija',1,NULL),(774,'ProgramInfoPrija',1,NULL),(775,'ProgramInfoPrija',1,NULL),(776,'ProgramInfoPrija',1,NULL),(777,'ProgramInfoPrija',1,NULL),(778,'ProgramInfoPrija',1,NULL),(779,'ProgramInfoPrija',1,NULL),(780,'ProgramInfoPrija',1,NULL),(781,'ProgramInfoPrija',1,NULL),(782,'ProgramInfoPrija',1,NULL),(783,'ProgramInfoPrija',1,NULL),(784,'ProgramInfoPrija',1,NULL),(785,'ProgramInfoPrija',1,NULL),(786,'ProgramInfoPrija',1,NULL),(787,'ProgramInfoPrija',1,NULL),(788,'ProgramInfoPrija',1,NULL),(789,'ProgramInfoPrija',1,NULL),(790,'ProgramInfoPrija',1,NULL),(791,'ProgramInfoPrija',1,NULL),(792,'ProgramInfoPrija',1,NULL),(793,'ProgramInfoPrija',1,NULL),(794,'ProgramInfoPrija',1,NULL),(795,'ProgramInfoPrija',1,NULL),(796,'ProgramInfoPrija',1,NULL),(797,'ProgramInfoPrija',1,NULL),(798,'ProgramInfoPrija',1,NULL),(799,'ProgramInfoPrija',1,NULL),(800,'ProgramInfoPrija',1,NULL),(801,'ProgramInfoPrija',1,NULL),(802,'ProgramInfoPrija',1,NULL),(803,'ProgramInfoPrija',1,NULL),(804,'ProgramInfoPrija',1,NULL),(805,'ProgramInfoPrija',1,NULL),(806,'ProgramInfoPrija',1,NULL),(807,'ProgramInfoPrija',1,NULL),(808,'ProgramInfoPrija',1,NULL),(809,'ProgramInfoPrija',1,NULL);
/*!40000 ALTER TABLE `statmenuitemclick` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subject`
--

DROP TABLE IF EXISTS `subject`;
CREATE TABLE `subject` (
  `idsubject` bigint(20) NOT NULL auto_increment,
  `idrank` bigint(20) default NULL,
  `idpostaloffice` bigint(20) default NULL,
  `idcompany` varchar(16) default NULL,
  `idprofession` bigint(20) default NULL,
  `idcountry` bigint(20) default NULL,
  `firstname` varchar(80) NOT NULL default '',
  `lastname` varchar(80) NOT NULL default '',
  `address` varchar(150) default NULL,
  `phone` varchar(80) default NULL,
  `cellularphone` varchar(80) default NULL,
  `email` varchar(80) default NULL,
  `notifyme` smallint(6) default NULL,
  `gender` smallint(6) default NULL,
  `birthdate` date default NULL,
  `activehash` varchar(32) default NULL,
  `active` smallint(6) default NULL,
  PRIMARY KEY  (`idsubject`),
  KEY `com_sub_fk` (`idcompany`),
  KEY `sub_pro_fk` (`idprofession`),
  KEY `sub_rank_fk` (`idrank`),
  KEY `sub_coun_fk` (`idcountry`)
) TYPE=MyISAM;

--
-- Dumping data for table `subject`
--

LOCK TABLES `subject` WRITE;
/*!40000 ALTER TABLE `subject` DISABLE KEYS */;
INSERT INTO `subject` VALUES (1,2,NULL,NULL,NULL,NULL,'Martin','Romih',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
/*!40000 ALTER TABLE `subject` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subprofession`
--

DROP TABLE IF EXISTS `subprofession`;
CREATE TABLE `subprofession` (
  `idprofession` bigint(20) NOT NULL auto_increment,
  `professionname` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`idprofession`)
) TYPE=MyISAM;

--
-- Dumping data for table `subprofession`
--

LOCK TABLES `subprofession` WRITE;
/*!40000 ALTER TABLE `subprofession` DISABLE KEYS */;
/*!40000 ALTER TABLE `subprofession` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subrank`
--

DROP TABLE IF EXISTS `subrank`;
CREATE TABLE `subrank` (
  `idrank` bigint(20) NOT NULL auto_increment,
  `rankname` varchar(80) NOT NULL default '',
  PRIMARY KEY  (`idrank`)
) TYPE=MyISAM;

--
-- Dumping data for table `subrank`
--

LOCK TABLES `subrank` WRITE;
/*!40000 ALTER TABLE `subrank` DISABLE KEYS */;
/*!40000 ALTER TABLE `subrank` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `usruser`
--

DROP TABLE IF EXISTS `usruser`;
CREATE TABLE `usruser` (
  `iduser` bigint(20) NOT NULL auto_increment,
  `idsubject` bigint(20) default NULL,
  `idusertype` bigint(20) NOT NULL default '0',
  `username` varchar(30) default NULL,
  `plaintextpassword` varchar(30) default NULL,
  `password` varchar(32) default NULL,
  `registrationdate` datetime default NULL,
  `email` varchar(80) default NULL,
  `activehash` varchar(32) default NULL,
  `active` smallint(6) default NULL,
  PRIMARY KEY  (`iduser`),
  KEY `usr_typ_fk` (`idusertype`),
  KEY `sub_usr2_fk` (`idsubject`)
) TYPE=MyISAM;

--
-- Dumping data for table `usruser`
--

LOCK TABLES `usruser` WRITE;
/*!40000 ALTER TABLE `usruser` DISABLE KEYS */;
INSERT INTO `usruser` VALUES (1,1,1,'admin','admin1','e00cf25ad42683b3df678c61f42c6bda','2004-02-12 00:06:29',NULL,'',1);
/*!40000 ALTER TABLE `usruser` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `usrusertype`
--

DROP TABLE IF EXISTS `usrusertype`;
CREATE TABLE `usrusertype` (
  `idusertype` bigint(20) NOT NULL auto_increment,
  `level` int(11) default NULL,
  `description` varchar(80) default NULL,
  `name` varchar(80) default NULL,
  PRIMARY KEY  (`idusertype`)
) TYPE=MyISAM;

--
-- Dumping data for table `usrusertype`
--

LOCK TABLES `usrusertype` WRITE;
/*!40000 ALTER TABLE `usrusertype` DISABLE KEYS */;
INSERT INTO `usrusertype` VALUES (1,5,'Administrator',NULL);
/*!40000 ALTER TABLE `usrusertype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wscategory`
--

DROP TABLE IF EXISTS `wscategory`;
CREATE TABLE `wscategory` (
  `idcategory` bigint(20) NOT NULL auto_increment,
  `description` varchar(80) default NULL,
  `name` varchar(16) default NULL,
  PRIMARY KEY  (`idcategory`)
) TYPE=MyISAM;

--
-- Dumping data for table `wscategory`
--

LOCK TABLES `wscategory` WRITE;
/*!40000 ALTER TABLE `wscategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `wscategory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wscategorystructure`
--

DROP TABLE IF EXISTS `wscategorystructure`;
CREATE TABLE `wscategorystructure` (
  `idcategory` bigint(20) NOT NULL default '0',
  `wsc_idcategory` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`idcategory`,`wsc_idcategory`),
  KEY `cat_is_par_fk` (`idcategory`),
  KEY `cat_is_chld_fk` (`wsc_idcategory`)
) TYPE=MyISAM;

--
-- Dumping data for table `wscategorystructure`
--

LOCK TABLES `wscategorystructure` WRITE;
/*!40000 ALTER TABLE `wscategorystructure` DISABLE KEYS */;
/*!40000 ALTER TABLE `wscategorystructure` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wsorder`
--

DROP TABLE IF EXISTS `wsorder`;
CREATE TABLE `wsorder` (
  `idorder` bigint(20) NOT NULL auto_increment,
  `idsubject` bigint(20) NOT NULL default '0',
  `odate` timestamp(14) NOT NULL,
  PRIMARY KEY  (`idorder`),
  KEY `sub_ord_fk` (`idsubject`)
) TYPE=MyISAM;

--
-- Dumping data for table `wsorder`
--

LOCK TABLES `wsorder` WRITE;
/*!40000 ALTER TABLE `wsorder` DISABLE KEYS */;
/*!40000 ALTER TABLE `wsorder` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wsorderrow`
--

DROP TABLE IF EXISTS `wsorderrow`;
CREATE TABLE `wsorderrow` (
  `idorder` bigint(20) NOT NULL default '0',
  `idproduct` bigint(20) NOT NULL default '0',
  `qty` int(11) default NULL,
  PRIMARY KEY  (`idorder`,`idproduct`),
  KEY `ord_row_fk` (`idorder`),
  KEY `prod_row_fk` (`idproduct`)
) TYPE=MyISAM;

--
-- Dumping data for table `wsorderrow`
--

LOCK TABLES `wsorderrow` WRITE;
/*!40000 ALTER TABLE `wsorderrow` DISABLE KEYS */;
/*!40000 ALTER TABLE `wsorderrow` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wsproduct`
--

DROP TABLE IF EXISTS `wsproduct`;
CREATE TABLE `wsproduct` (
  `idproduct` bigint(20) NOT NULL auto_increment,
  `idcompany` varchar(16) default NULL,
  `idcategory` bigint(20) NOT NULL default '0',
  `description` varchar(80) default NULL,
  `price` float(8,2) default NULL,
  `name` varchar(16) default NULL,
  `specialprice` float(8,2) default NULL,
  `tax` float default NULL,
  `timeadded` timestamp(14) NOT NULL,
  `timemodified` timestamp(14) NOT NULL default '00000000000000',
  `picture1` longblob,
  `picture2` longblob,
  `picture3` longblob,
  PRIMARY KEY  (`idproduct`),
  KEY `prod_in_cat_fk` (`idcategory`),
  KEY `com_prod_fk` (`idcompany`)
) TYPE=MyISAM;

--
-- Dumping data for table `wsproduct`
--

LOCK TABLES `wsproduct` WRITE;
/*!40000 ALTER TABLE `wsproduct` DISABLE KEYS */;
/*!40000 ALTER TABLE `wsproduct` 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  8:47:05