-- MySQL dump 10.11
--
-- Host: 195.246.8.99    Database: gglas
-- ------------------------------------------------------
-- Server version	4.0.24_Debian-10sarge2-log
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

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

DROP TABLE IF EXISTS `catcategory`;
CREATE TABLE `catcategory` (
  `idCatCategory` varchar(64) NOT NULL default '',
  `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 */;
/*!40000 ALTER TABLE `catcategory` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `catentity`;
CREATE TABLE `catentity` (
  `idCatEntity` int(11) NOT NULL auto_increment,
  `idCatCategory` varchar(64) NOT NULL default '',
  `text1` text,
  `text2` text,
  `text3` text,
  `text4` text,
  `text5` text,
  `int1` int(11) default NULL,
  `int2` int(11) default NULL,
  `int3` int(11) NOT NULL default '0',
  `float1` float default NULL,
  `float2` float default NULL,
  `float3` float default NULL,
  `pic1` blob,
  `pic2` blob,
  `pic3` blob,
  `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 */;
/*!40000 ALTER TABLE `catentity` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cmspage`;
CREATE TABLE `cmspage` (
  `idCmsPage` varchar(64) NOT NULL default '',
  `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 ('','cms_test');
/*!40000 ALTER TABLE `cmspage` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cmssection`;
CREATE TABLE `cmssection` (
  `idCmsSection` varchar(64) NOT NULL default '',
  `idCmsPage` varchar(64) NOT NULL default '',
  `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 `mailgroup`
--

DROP TABLE IF EXISTS `mailgroup`;
CREATE TABLE `mailgroup` (
  `idMailGroup` int(11) NOT NULL auto_increment,
  `description` varchar(128) default NULL,
  PRIMARY KEY  (`idMailGroup`)
) TYPE=MyISAM;

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

LOCK TABLES `mailgroup` WRITE;
/*!40000 ALTER TABLE `mailgroup` DISABLE KEYS */;
INSERT INTO `mailgroup` VALUES (1,'Default');
/*!40000 ALTER TABLE `mailgroup` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `subject`;
CREATE TABLE `subject` (
  `idSubject` int(11) NOT NULL auto_increment,
  `eMailTxt` varchar(120) NOT NULL default '',
  `nameTxt` varchar(128) default NULL,
  `addressTxt` varchar(198) default NULL,
  `cityTxt` varchar(128) default NULL,
  `postalCodeTxt` varchar(10) default NULL,
  `idCountryTxt` varchar(6) default NULL,
  `TRRTxt` varchar(64) default NULL,
  `phoneTxt` varchar(32) default NULL,
  `cellularTxt` varchar(32) default NULL,
  `faxTxt` varchar(32) default NULL,
  `urlTxt` varchar(128) default NULL,
  `vatNoTxt` varchar(32) default NULL,
  `vatUserTxt` tinyint(4) default NULL,
  `idMailGroupTxt` int(11) NOT NULL default '0',
  `idRegionTxt` int(11) default NULL,
  PRIMARY KEY  (`idSubject`),
  UNIQUE KEY `idSubject_4` (`idSubject`),
  UNIQUE KEY `idSubject_3` (`idSubject`),
  UNIQUE KEY `idSubject_2` (`idSubject`),
  UNIQUE KEY `idSubject` (`idSubject`),
  UNIQUE KEY `email` (`eMailTxt`)
) TYPE=MyISAM;

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

LOCK TABLES `subject` WRITE;
/*!40000 ALTER TABLE `subject` DISABLE KEYS */;
INSERT INTO `subject` VALUES (1,'haris.hodzic@siol.net','Haris Hodzic','','','','','','','','','','',0,0,0);
/*!40000 ALTER TABLE `subject` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `uporabnik`
--

DROP TABLE IF EXISTS `uporabnik`;
CREATE TABLE `uporabnik` (
  `id_uporabnik` int(11) NOT NULL auto_increment,
  `postalCode` int(11) default NULL,
  `tip` int(11) NOT NULL default '0',
  `uporabnisko_ime` varchar(80) default NULL,
  `geslo` varchar(80) default NULL,
  `datum_registracije` date default NULL,
  `ime` varchar(80) default NULL,
  `priimek` varchar(80) default NULL,
  `naslov` varchar(150) default NULL,
  `email` varchar(80) default NULL,
  `datum_rojstva` date default NULL,
  `slika` longblob,
  PRIMARY KEY  (`id_uporabnik`),
  KEY `UporabnikTip_FK` (`tip`),
  KEY `PostalOfficeOfUporabnik_FK` (`postalCode`)
) TYPE=MyISAM;

--
-- Dumping data for table `uporabnik`
--

LOCK TABLES `uporabnik` WRITE;
/*!40000 ALTER TABLE `uporabnik` DISABLE KEYS */;
INSERT INTO `uporabnik` VALUES (1,NULL,3,'superuser','d41d8cd98f00b204e9800998ecf8427e','2003-01-01','superuser','','','','2003-01-01',''),(2,NULL,2,'admin','d41d8cd98f00b204e9800998ecf8427e','2003-01-01','admin','','','','2003-01-01',''),(3,NULL,4,'guest','d41d8cd98f00b204e9800998ecf8427e',NULL,'guest',NULL,NULL,NULL,NULL,'');
/*!40000 ALTER TABLE `uporabnik` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `uporabnik_tip`
--

DROP TABLE IF EXISTS `uporabnik_tip`;
CREATE TABLE `uporabnik_tip` (
  `id_uporabnik_tip` int(11) NOT NULL auto_increment,
  `stopnja` int(11) default NULL,
  `opis` varchar(150) default NULL,
  `ime` varchar(80) default NULL,
  PRIMARY KEY  (`id_uporabnik_tip`)
) TYPE=MyISAM;

--
-- Dumping data for table `uporabnik_tip`
--

LOCK TABLES `uporabnik_tip` WRITE;
/*!40000 ALTER TABLE `uporabnik_tip` DISABLE KEYS */;
INSERT INTO `uporabnik_tip` VALUES (1,0,'ni uporabnik','neveljavno'),(2,5,'Administrator','administrator'),(3,10,'the name says it all','superuser'),(4,1,'Guest','Guest');
/*!40000 ALTER TABLE `uporabnik_tip` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-07-14 10:46:27