-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Gostitelj: localhost
-- Čas nastanka: 29 Dec 2010 ob 10:11 AM
-- Različica strežnika: 5.1.41
-- Različica PHP: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Podatkovna baza: `WarpitPanel_Webuserspool`
--

-- --------------------------------------------------------

--
-- Struktura tabele `user_input_labels`
--

CREATE TABLE IF NOT EXISTS `user_input_labels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `language` tinyint(2) NOT NULL DEFAULT '0',
  `lab_field` int(50) NOT NULL DEFAULT '0',
  `lab_code` int(5) NOT NULL,
  `lab_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `lab_position` tinyint(4) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQUE_KEY` (`language`,`lab_field`,`lab_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Odloži podatke za tabelo `user_input_labels`
--


-- --------------------------------------------------------

--
-- Struktura tabele `web_cati_structure`
--

CREATE TABLE IF NOT EXISTS `web_cati_structure` (
  `counter` int(3) NOT NULL AUTO_INCREMENT,
  `field_name` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_text` varchar(150) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_type` tinyint(2) NOT NULL DEFAULT '0',
  `field_options` text COLLATE utf8_unicode_ci NOT NULL,
  `field_size` char(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_order` smallint(4) NOT NULL DEFAULT '900',
  `field_hidden` tinyint(1) NOT NULL,
  PRIMARY KEY (`counter`),
  KEY `counter` (`counter`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Odloži podatke za tabelo `web_cati_structure`
--


-- --------------------------------------------------------

--
-- Struktura tabele `_Emails`
--

CREATE TABLE IF NOT EXISTS `_Emails` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `id_sup` int(5) NOT NULL,
  `orderBy` tinyint(3) NOT NULL,
  `idLab` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `node_img` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `mail_from` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `mail_from_label` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `subject` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `is_leaf` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Odloži podatke za tabelo `_Emails`
--


-- --------------------------------------------------------

--
-- Struktura tabele `_groups`
--

CREATE TABLE IF NOT EXISTS `_groups` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `id_sup` int(5) NOT NULL,
  `orderBy` tinyint(3) NOT NULL,
  `idLab` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `node_img` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `is_leaf` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Odloži podatke za tabelo `_groups`
--

-- --------------------------------------------------------

--
-- Struktura tabele `_group_link`
--

CREATE TABLE IF NOT EXISTS `_group_link` (
  `id_group` int(5) NOT NULL DEFAULT '0',
  `id` int(8) NOT NULL DEFAULT '0',
  UNIQUE KEY `id_group` (`id_group`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Odloži podatke za tabelo `_group_link`
--

-- --------------------------------------------------------

--
-- Struktura tabele `_Interviewer`
--

CREATE TABLE IF NOT EXISTS `_Interviewer` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `podjetje` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `priimek` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `title_` tinyint(1) NOT NULL,
  `kraj` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `naslov` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `postna` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `ime` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `nagovor` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `naziv` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `drzava` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `telefon1` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `mobitel1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `komentar` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `telefon2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mobitel2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `polozaj` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `faks` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `soulTest` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `soulTest_7` int(11) NOT NULL,
  `soulTest_1` int(11) NOT NULL,
  `soulTest_2` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '2',
  `soulTest_3` int(11) NOT NULL,
  `igor` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Email_unique` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Odloži podatke za tabelo `_Interviewer`
--

-- --------------------------------------------------------

--
-- Struktura tabele `_InterviewerFieldOrder`
--

CREATE TABLE IF NOT EXISTS `_InterviewerFieldOrder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `field_id` int(11) NOT NULL,
  `orderBy` int(11) NOT NULL,
  `is_hidden` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Odloži podatke za tabelo `_InterviewerFieldOrder`
--


-- --------------------------------------------------------

--
-- Struktura tabele `_InterviewerStructure`
--

CREATE TABLE IF NOT EXISTS `_InterviewerStructure` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `id_sup` int(5) NOT NULL,
  `field_name` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_text` varchar(150) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_type` tinyint(2) NOT NULL DEFAULT '0',
  `data_type` tinyint(4) NOT NULL,
  `field_options` text COLLATE utf8_unicode_ci NOT NULL,
  `field_size` char(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `orderBy` int(5) NOT NULL,
  `field_order` smallint(4) NOT NULL DEFAULT '900',
  `field_hidden` tinyint(1) NOT NULL,
  `is_leaf` tinyint(1) NOT NULL,
  `field_opt1` int(11) NOT NULL,
  `field_defaultValue` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `field_cb_checked` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Odloži podatke za tabelo `_InterviewerStructure`
--


-- --------------------------------------------------------

--
-- Struktura tabele `_MailAttachments`
--

CREATE TABLE IF NOT EXISTS `_MailAttachments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `template_id` smallint(11) unsigned NOT NULL,
  `filePath` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `fileName` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `fileSize` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `template_id` (`template_id`,`filePath`,`fileName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Odloži podatke za tabelo `_MailAttachments`
--


-- --------------------------------------------------------

--
-- Struktura tabele `_MailCatcher`
--

CREATE TABLE IF NOT EXISTS `_MailCatcher` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `mail_id` varchar(100) NOT NULL,
  `is_report` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(8) NOT NULL,
  `checked_user` tinyint(1) NOT NULL,
  `send_mail_id` varchar(100) NOT NULL,
  `mail_address` varchar(100) NOT NULL,
  `send_subject` varchar(200) NOT NULL,
  `arrival_date` datetime NOT NULL,
  `send_date` datetime NOT NULL,
  `mail_date` datetime NOT NULL,
  `sendStatistic_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1250 AUTO_INCREMENT=1 ;

--
-- Odloži podatke za tabelo `_MailCatcher`
--


-- --------------------------------------------------------

--
-- Struktura tabele `_MailStatistic`
--

CREATE TABLE IF NOT EXISTS `_MailStatistic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mail_set` int(11) NOT NULL,
  `interviewer_id` int(11) NOT NULL DEFAULT '0',
  `mail_address` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `date_sent` datetime NOT NULL,
  `mail_status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Odloži podatke za tabelo `_MailStatistic`
--


-- --------------------------------------------------------

--
-- Struktura tabele `_MailTemplates`
--

CREATE TABLE IF NOT EXISTS `_MailTemplates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `subject` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `mail_from` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Odloži podatke za tabelo `_MailTemplates`
--


-- --------------------------------------------------------

--
-- Struktura tabele `_ProgramMenu`
--

CREATE TABLE IF NOT EXISTS `_ProgramMenu` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `id_sup` int(5) NOT NULL,
  `orderBy` tinyint(3) NOT NULL,
  `idLab` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `node_img` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=16 ;

--
-- Odloži podatke za tabelo `_ProgramMenu`
--

INSERT INTO `_ProgramMenu` (`id`, `id_sup`, `orderBy`, `idLab`, `node_img`) VALUES
(1, 0, 1, 'Interviewer', 'webuserspool/_icons/interviewer.gif'),
(2, 1, 1, 'Add', 'webcati/_icons/submenu_default.gif'),
(3, 1, 2, 'Import', 'webcati/_icons/submenu_default.gif'),
(5, 0, 3, 'SQL', 'webuserspool/_icons/sql.gif'),
(6, 0, 4, 'Groups', 'webuserspool/_icons/groups.gif'),
(7, 0, 5, 'Mail', 'webuserspool/_icons/mail.gif'),
(8, 0, 6, 'Cati Tools', ''),
(9, 4, 1, 'Add/Edit', ''),
(10, 5, 1, 'Add/Edit', ''),
(11, 7, 1, 'Accounts', ''),
(12, 7, 2, 'Send', ''),
(13, 7, 3, 'Statistics', ''),
(14, 8, 1, 'Merge with project', ''),
(15, 6, 1, 'Edit', ''),
(4, 0, 2, 'Fields', 'webuserspool/_icons/fields.gif');

-- --------------------------------------------------------

--
-- Struktura tabele `_QueryMachineConstruction`
--

CREATE TABLE IF NOT EXISTS `_QueryMachineConstruction` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `id_template` int(5) NOT NULL,
  `orderBy` int(5) NOT NULL,
  `conditionField` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `field_id` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `operation` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `valueField` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `openBracket` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `closeBracket` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Odloži podatke za tabelo `_QueryMachineConstruction`
--


-- --------------------------------------------------------

--
-- Struktura tabele `_QueryMachineFields`
--

CREATE TABLE IF NOT EXISTS `_QueryMachineFields` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `id_sup` int(5) NOT NULL,
  `idLab` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `orderBy` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;

--
-- Odloži podatke za tabelo `_QueryMachineFields`
--

INSERT INTO `_QueryMachineFields` (`id`, `id_sup`, `idLab`, `orderBy`) VALUES
(1, 0, 'Pool & Groups', 1),
(2, 0, 'PERSONAL INFORMATION', 2),
(3, 1, 'Groups', 1),
(8, 1, 'Interviewer', 3),
(7, 1, 'Projects', 2),
(9, 1, 'email', 4);

-- --------------------------------------------------------

--
-- Struktura tabele `_QueryMachineTemplates`
--

CREATE TABLE IF NOT EXISTS `_QueryMachineTemplates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_sup` int(11) NOT NULL,
  `idLab` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `orderBy` int(11) NOT NULL,
  `is_leaf` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Odloži podatke za tabelo `_QueryMachineTemplates`
--


-- --------------------------------------------------------

--
-- Struktura tabele `_SendMailSet`
--

CREATE TABLE IF NOT EXISTS `_SendMailSet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_queue` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_schedule` datetime NOT NULL,
  `project_id` int(11) NOT NULL,
  `template_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `numSend` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Odloži podatke za tabelo `_SendMailSet`
--


-- --------------------------------------------------------

--
-- Struktura tabele `_SMTP_accounts`
--

CREATE TABLE IF NOT EXISTS `_SMTP_accounts` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `host` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `port` smallint(6) NOT NULL,
  `helo_message` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `askPassword` tinyint(4) NOT NULL DEFAULT '0',
  `active` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Odloži podatke za tabelo `_SMTP_accounts`
--


-- --------------------------------------------------------

--
-- Struktura tabele `_TestMails`
--

CREATE TABLE IF NOT EXISTS `_TestMails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `interViewerId` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Odloži podatke za tabelo `_TestMails`
--

