-- MySQL dump 10.11
--
-- Host: 195.246.8.99    Database: davafitto
-- ------------------------------------------------------
-- 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,20090429135231);
/*!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 (1,'News'),(2,'Faq'),(3,'Links'),(4,'test');
/*!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 (1,'News',0),(2,'Faq',0),(3,'Links',0),(4,'test',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 (3,2,'Zakaj jelenčki vlečejo sanjke od Božićka? ','Zato, ker jim Božićek da u hlevu za jest seno. :) ','','','',0,0,0,0,0,0,'2003-12-12','2003-12-12','2003-12-12','','',''),(10,3,'<a href=\"http://www.helpic.at/\" target=\"_blank\">http://www.helpic.at</a>','HELPIC Avstrija','','','',0,0,0,0,0,0,'2004-06-17','2004-06-17','2004-06-17','','',''),(19,3,'http://www.lekarnar.com/?manufacturers_id=120','Spletna lekarna - lekarna Nove Poljane, kjer lahko kupite vse naše izdelke preko interneta.','','','',0,0,0,0,0,0,'2005-04-26','2005-04-26','2005-04-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 (3,2,'Zakaj jelenčki vlečejo sanjke od Božićka? ','Zato, ker jim Božićek da u hlevu za jest seno. :) ','','','',0,0,0,0,0,0,'2003-12-12','2003-12-12','2003-12-12','','','',0),(10,3,'<a href=\"http://www.helpic.at/\" target=\"_blank\">http://www.helpic.at</a>','HELPIC Avstrija','','','',0,0,0,0,0,0,'2004-06-17','2004-06-17','2004-06-17','','','',0),(19,3,'http://www.lekarnar.com/?manufacturers_id=120','Spletna lekarna - lekarna Nove Poljane, kjer lahko kupite vse naše izdelke preko interneta.','','','',0,0,0,0,0,0,'2005-04-26','2005-04-26','2005-04-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 */;
INSERT INTO `cmspage` VALUES (1,'AboutVarpulis');
/*!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 */;
INSERT INTO `cmspagepreview` VALUES (1,'AboutVarpulis',0);
/*!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 */;
INSERT INTO `cmssection` VALUES (1,1,'NAZIV','<P>Demonstracija delovanja aplikacije Varpulis</P>'),(2,1,'NASLOV','test'),(3,1,'TELEFON','');
/*!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 */;
INSERT INTO `cmssectionpreview` VALUES (1,1,'NAZIV','<P>Demonstracija delovanja aplikacije Varpulis</P>',0),(2,1,'NASLOV','test',0),(3,1,'TELEFON','',0);
/*!40000 ALTER TABLE `cmssectionpreview` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `company`
--

DROP TABLE IF EXISTS `company`;
CREATE TABLE `company` (
  `idcompany` bigint(20) NOT NULL auto_increment,
  `idcountry` varchar(16) 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 */;
INSERT INTO `company` VALUES (1,'1',4000,1,'RS Klan','Brez naslova','777','777','podpora@rsklan.com','podpora@rsklan.com','http://www.rsklan.com','777','777','777',7),(2,NULL,1000,1,'ELAN','d.d.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,NULL,1000,1,'Mobitel d.d.','nima',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,NULL,1000,1,'ZENIT','jhk',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,NULL,1000,1,'Lesnina','nekje',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!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 */;
INSERT INTO `companyactivity` VALUES (1,'Web Develpement');
/*!40000 ALTER TABLE `companyactivity` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
  `idcountry` varchar(16) NOT NULL default '',
  `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 */;
INSERT INTO `country` VALUES ('1','Slovenia');
/*!40000 ALTER TABLE `country` 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 (20,'Povprasevanje',0,0,0,'Davafitto - svetovanje','win-1250','','',1,'Notify test','win-1250','davafitto@siol.net','davafitto@siol.net');
/*!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 (20,'backup@spletnastran.com'),(20,'davafitto@siol.net');
/*!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` date 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 */;
INSERT INTO `mailmessage` VALUES (1,0,'test','test',NULL,NULL,NULL,NULL),(2,0,'test','test',NULL,NULL,NULL,NULL),(3,0,'test','test',NULL,NULL,NULL,NULL),(4,1,'kaka','zdraha',NULL,NULL,NULL,NULL),(5,0,'hahahaha','karolina ','2003-12-16','iso-8859-1','podpora@rsklan.com','podpora@spletnastran.com'),(6,1,'zgjh','kghjkb',NULL,'iso-8859-1','podpora@rsklan.com','podpora@spletnastran.com');
/*!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 `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 */;
INSERT INTO `photocategory` VALUES (7,'Benetke','Obisk Ivana in Judy v Benetkah','Ivan','2003-10-26'),(8,'Propagandni tabor Kokrica','Taborniki - propagandni tabor na Konrici','I1','2003-10-10'),(9,'Taborjenje 2003','','i1','2003-11-05'),(10,'Kostanjev piknik 2003','','','2003-11-05'),(11,'Močne ukane 2003','','','2003-11-05'),(12,'Brnik','','','2003-11-06'),(13,'Majanje 2003','','','2003-11-06'),(14,'Jesenovanje 2003','Jesenovanje na Davči','','2003-11-10');
/*!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 */;
INSERT INTO `photocategorypreview` VALUES (7,'Benetke','Obisk Ivana in Judy v Benetkah','Ivan','2003-10-26','ok'),(8,'Propagandni tabor Kokrica','Taborniki - propagandni tabor na Konrici','I1','2003-10-10','ok'),(9,'Taborjenje 2003','','i1','2003-11-05','ok'),(10,'Kostanjev piknik 2003','','','2003-11-05','ok'),(11,'Močne ukane 2003','','','2003-11-05','ok'),(12,'Brnik','','','2003-11-06','ok'),(13,'Majanje 2003','','','2003-11-06','ok'),(14,'Jesenovanje 2003','Jesenovanje na Davči','','2003-11-10','ok');
/*!40000 ALTER TABLE `photocategorypreview` 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 */;
INSERT INTO `postaloffice` VALUES (1000,'Ljubljana'),(4000,'Kranj');
/*!40000 ALTER TABLE `postaloffice` 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` bigint(20) default NULL,
  `idprofession` bigint(20) default NULL,
  `idcountry` varchar(16) 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,1,4000,1,1,'1','Matjaž','Kolenček','brezdomec','','','i11@rsklan.com',0,0,'1978-06-02','',0),(12,2,1000,1,1,'1','Dripac','Šilonja','nema','777','777','ivan.stojsavljevic@kiss.uni-lj.si',0,0,'2003-12-14',NULL,NULL),(13,1,1000,4,1,NULL,'primorc','ebiln','drazgoska 13','2354675','876857','scout309@hotmail.com',0,NULL,NULL,NULL,NULL),(14,1,4000,3,1,'1','Bojan','Dragić','Dražgoška cesta na Polje','444','444','ivan.stojsavljevic@siol.net',0,0,'1988-10-03',NULL,NULL),(15,4,4000,5,1,'1','Tomaž','Lonček','dsdas','333','333','nimam@poste.com',0,1,'2977-03-04',NULL,NULL),(16,4,4000,2,1,'1','Lojze','Pečen','Nekje 12','','','matija.jekovec@kiss.uni-lj.si',0,0,'1900-01-31',NULL,NULL),(20,3,4000,2,1,'1','Testni','Joža','nimam','7657','765765','i13@rsklan.com',0,0,'2002-02-02',NULL,NULL),(25,NULL,NULL,NULL,NULL,NULL,'ivan','pivan',NULL,NULL,NULL,'i1@rsklan.com',NULL,NULL,NULL,'b9e175f53dba7046bee52c9cd2f45e00',1),(26,4,4000,2,1,'1','sandi','bitenc','naslon','132412','2312321','sandi@rsklan.com',1,0,'2003-12-22',NULL,NULL),(27,NULL,NULL,NULL,NULL,NULL,'Najtaglavn','Uporabnik',NULL,NULL,NULL,'super@rsklan.com',NULL,NULL,NULL,NULL,NULL);
/*!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 */;
INSERT INTO `subprofession` VALUES (1,'Web Developer');
/*!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 */;
INSERT INTO `subrank` VALUES (1,'Študent'),(2,'Zaposlen'),(3,'Upokojenec'),(4,'Drugo');
/*!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` date default NULL,
  `email` varchar(80) default NULL,
  `activehash` varchar(32) default NULL,
  `active` smallint(6) default NULL,
  PRIMARY KEY  (`iduser`),
  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,2,'admin','1davafitto72','378bdfcb813aa98daa3920298c756c12','2003-01-01','','',1),(21,27,3,'superuser','super1','727dfbdc1a4ee249f3f08c247a5669d5','2004-07-23','super@rsklan.com','eef659aaf5722bfab0b4b39de7ffe32a',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,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 `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` bigint(20) 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  9:11:08