-- MySQL dump 10.11
--
-- Host: 195.246.8.99    Database: popper
-- ------------------------------------------------------
-- 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 `accounts`
--

DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `popserver` varchar(255) default NULL,
  `poplogin` varchar(255) default NULL,
  `poppwd` varchar(255) default NULL,
  `fromname` varchar(255) default NULL,
  `replyto` varchar(255) default NULL,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `accounts`
--

LOCK TABLES `accounts` WRITE;
/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
INSERT INTO `accounts` VALUES (2,2,'house4holidays.com','ivokal','6337','Ivo Kalshoven','info@house4holidays.com','Ivo Kalshoven'),(3,4,'house4holidays.com','mazo1','aa','mazo1','','mazo1'),(4,5,'house4holidays.com','mazo','iris','mazo','krama01@hotmail.com','mazo'),(5,6,'www.intermatrade.si','rkbf2','72dk78b','Matjaz Avsic','inter.ma@intermatrade.si','inter.ma@intermatrade.si'),(6,6,'www.intermatrade.si','rkbf3','27dk87b','info Matjaz Avsic','info@intermatrade.si','info@intermatrade.si'),(7,6,'www.bnc-charter.com','mabnc','0pin003','BNC - Matjaz Avsic','info@bnc-charter.com','info@bnc-charter.com'),(8,9,'','','070170vu','VOJKO','','v-vision.net'),(9,8,'','','','k.kauric','margareta.kauric@house4holidays.com','margareta.kauric'),(10,6,'pop.siol.net','in10739','gledalec','eunet','inter.ma@eunet.si','inter.ma@eunet.si'),(13,13,'house4holidays.com','ruzica.simara','tr1276es','ruzica.simara','ruzica.simara@house4holidays.com','ruzica.simara'),(15,33,'','alberi','timothy','David Lillis','davi@dlillis.freeserve.co.uk','David Lillis');
/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `addresses`
--

DROP TABLE IF EXISTS `addresses`;
CREATE TABLE `addresses` (
  `id` int(11) NOT NULL auto_increment,
  `email` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `address1` varchar(255) default NULL,
  `address2` varchar(255) default NULL,
  `town` varchar(255) default NULL,
  `state` varchar(255) default NULL,
  `country` varchar(255) default NULL,
  `phone` varchar(255) default NULL,
  `mobile` varchar(255) default NULL,
  `homepage` varchar(255) default NULL,
  `user_id` int(11) default NULL,
  `nickname` varchar(255) default NULL,
  `lastname` varchar(255) default NULL,
  `zip` varchar(16) default NULL,
  `blocked` tinyint(4) default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `addresses`
--

LOCK TABLES `addresses` WRITE;
/*!40000 ALTER TABLE `addresses` DISABLE KEYS */;
INSERT INTO `addresses` VALUES (1,'ruzica.simara@house4holidays.com','ruzica.simara',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13,NULL,NULL,NULL,0),(2,'ruzica.simara@house4holidays.com','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13,NULL,NULL,NULL,0),(3,'ssimara@globalnet.hr','sandra',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13,NULL,NULL,NULL,0);
/*!40000 ALTER TABLE `addresses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `conf`
--

DROP TABLE IF EXISTS `conf`;
CREATE TABLE `conf` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `keep` tinyint(1) default NULL,
  `server_del` tinyint(1) default NULL,
  `auto_check` tinyint(1) default NULL,
  `signature` text,
  `app_sig` tinyint(1) default NULL,
  `send_direct` tinyint(1) default NULL,
  `add_address` tinyint(4) default NULL,
  `mail_rows` int(11) NOT NULL default '20',
  `mails_per_page` int(11) NOT NULL default '20',
  `language` varchar(20) NOT NULL default 'english',
  `subject_size` int(11) NOT NULL default '50',
  `address_size` int(11) NOT NULL default '20',
  `check_int` int(11) NOT NULL default '15',
  `view` tinyint(4) default '0',
  `mailview` tinyint(4) default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user_id` (`user_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `conf`
--

LOCK TABLES `conf` WRITE;
/*!40000 ALTER TABLE `conf` DISABLE KEYS */;
INSERT INTO `conf` VALUES (2,2,1,0,0,'',0,0,0,20,20,'english',50,20,15,0,0),(3,3,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(4,4,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(5,5,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(6,6,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(7,7,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(8,8,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(9,9,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(10,10,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(11,11,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(12,12,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(13,13,0,0,1,'',0,0,1,30,30,'english',50,30,0,0,0),(14,14,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(15,15,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(16,16,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(17,17,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(18,18,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(19,19,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(20,20,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(21,21,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(22,22,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(23,23,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(24,24,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(25,25,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(26,26,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(27,27,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(28,28,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(29,29,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(30,30,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(31,31,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(32,32,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(33,33,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(34,34,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(35,35,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(36,36,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(37,37,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0),(38,38,1,NULL,NULL,NULL,NULL,NULL,NULL,20,20,'english',50,20,15,0,0);
/*!40000 ALTER TABLE `conf` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `confirmations`
--

DROP TABLE IF EXISTS `confirmations`;
CREATE TABLE `confirmations` (
  `id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `check` char(32) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table `confirmations`
--

LOCK TABLES `confirmations` WRITE;
/*!40000 ALTER TABLE `confirmations` DISABLE KEYS */;
INSERT INTO `confirmations` VALUES (0,3,'81278216761c23c22cc21b7c59c406b3'),(0,4,'5083837d7cf28c9d8e0618ba548330eb'),(0,7,'f74bd901592f81f07b40890c5b7cc923'),(0,10,'132dcf8baeda081b17857182b4926f4b'),(0,11,'a13ca7898631732a7a95eca6c7a2136d'),(0,12,'7a956fd2dbd4628e82022599ccc139f8'),(0,14,'ea0a3f2de4eed062b0f2c7e4b8502887'),(0,17,'772b4d05bc2bc4b66abc4dd3b7eadea6'),(0,18,'2484d9a9fae88ee52baf0b05521a32a5'),(0,19,'ea4a443e06d41e745b22a06c25aff7ab'),(0,20,'d3dc22ad3ee79f300ae1c20bc9554d87'),(0,21,'1d4bf338b9f623355c3dfc9f20aa2b53'),(0,22,'5301c4d888f5204274439e6dcf5fdb54'),(0,23,'4c92d46d3b1aad8a64eb35d7312d067c'),(0,24,'e780f27306d79f9a040f90a9f042b046'),(0,29,'41f3d98bb60c1b088a1489a17d2a208d'),(0,28,'4e5df16c27f6296cb6a7def20ff66346'),(0,30,'9693098833af56fa7055d8ddb66168db'),(0,31,'bee8f08df76d1eecd8ad1130ae849ef4');
/*!40000 ALTER TABLE `confirmations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mails`
--

DROP TABLE IF EXISTS `mails`;
CREATE TABLE `mails` (
  `id` int(11) NOT NULL auto_increment,
  `folder` varchar(255) default NULL,
  `user_id` int(11) default NULL,
  `uidl` varchar(255) NOT NULL default '',
  `tos` text,
  `froms` text,
  `subject` text,
  `is_mime` tinyint(1) default NULL,
  `was_read` tinyint(1) default NULL,
  `acc_id` int(11) default NULL,
  `mail` longtext,
  `date` varchar(14) default NULL,
  `priority` tinyint(4) default '0',
  `from_name` text,
  PRIMARY KEY  (`id`),
  KEY `uidl` (`uidl`)
) TYPE=MyISAM;

--
-- Dumping data for table `mails`
--

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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `pwd` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `activated` tinyint(4) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) TYPE=MyISAM;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (2,'Ivok','p13i72','info@house4holidays.com',1),(6,'bnc','slin','info@bnc-charter.com',1),(7,'veucovic','du7224vg','vesna.ucovic@house4holidays.com',0),(5,'mazo','aa','mazo@house4holidays.com',1),(8,'margareta.kauric','GREENHEART','k.kauric@vipnet.hr',1),(9,'vurban1','070170vu','info@v-vision.net',1),(10,'andrejazonta','marcel','andrejazonta@house4holidays.com',0),(11,'zvjezdan.preden','zt2354ta','zvjezdan.preden@house4holidays.com',0),(12,'bpirna1','sold_er1','bora@email.si',0),(13,'ruzica.simara','tr1276es','ruzica.simara@house4holidays.com',1),(14,'ADRIANA','nupikoni','adriana-tours@ri.hinet.hr',0),(15,'mailvv','vv7mailv','mail@v-vision.net',1),(16,'turistagencyvv','vv7tamal','turistagency@v-vision.net',1),(17,'vojko.urbancic','vu28ma30','vojko.urbancic@house4holidays.com',0),(18,'agentvv','vv7agent','agent@v-vision.net',0),(19,'silvija','neptun','silvyl@yahoo.com',0),(20,'franjo.grzin@house4holidays.com','bp5941yl','franjo.grzin@house4holidays.com',0),(21,'vojko.urbancic@house4holidays.com','vu28ma30','vojko.urbancic@house4holidays.com',0),(22,'mgrskovi','1804955','marinko.grskovic@ri.hinet.hr',0),(23,'vesna','samsung','vesna.ucovic@house4holidays.com',0),(24,'NATALIJA','stancin','daj.rogatec@siol.net',0),(25,'DAMJAN','STARI','daj.rogatec@siol.net',1),(26,'zulicbor','skiro1','agi.nm@siol.net',1),(27,'CERIC','1491973','igor.ceric@ri.hinet.hr',1),(28,'ceric igor','1491973','igor.ceric@ri.hinet.hr',0),(29,'fragrzin','bp5941yl','franjo.grzin@house4holidays.com',0),(30,'vera','vera','vera@house4holidays.com',0),(31,'tu','tutu','ti@siol.net',0),(32,'Gabriela Dornikova MUDr.','123456','GDornikova@seznam.cz',1),(33,'alberi','timothy','davi@dlillis.freeserve.co.uk',1),(34,'kassel','EDIKA','herve.kassel@siemens.com',1),(35,'gzhui','hammer','daveemesco@yahoo.co.uk',0),(36,'melissa','benjamin','melissa_p@sify.com',0),(37,'petar.susic','es4848ui','petar.susic@house4holidays.com',0),(38,'pibelindo','melon','jojo@gmail.com',0);
/*!40000 ALTER TABLE `users` 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-09 11:24:34