-- 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_Webcati_base`
--

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

--
-- Struktura tabele `log`
--

CREATE TABLE IF NOT EXISTS `log` (
  `sql_statement` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

--
-- Struktura tabele `quota_layer`
--

CREATE TABLE IF NOT EXISTS `quota_layer` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `id_project` int(6) NOT NULL DEFAULT '0',
  `id_question` int(4) NOT NULL DEFAULT '0',
  `q_name` char(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `layer` int(6) NOT NULL DEFAULT '0',
  `source` tinyint(3) unsigned NOT NULL,
  `zap_st` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `quota_layer_addon`
--

CREATE TABLE IF NOT EXISTS `quota_layer_addon` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) NOT NULL,
  `interviewer_show` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `recode`
--

CREATE TABLE IF NOT EXISTS `recode` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `id_project` int(5) NOT NULL DEFAULT '0',
  `id_question` int(4) NOT NULL DEFAULT '0',
  `basenum` int(6) NOT NULL DEFAULT '0',
  `rangn` int(6) DEFAULT NULL,
  `reconum` int(6) NOT NULL DEFAULT '0',
  `source` tinyint(1) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_project` (`id_project`),
  KEY `id_question` (`id_question`),
  KEY `rangn` (`rangn`),
  KEY `basenum` (`basenum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `recolabel`
--

CREATE TABLE IF NOT EXISTS `recolabel` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `id_project` int(6) NOT NULL DEFAULT '0',
  `id_question` int(4) NOT NULL DEFAULT '0',
  `id_reconum` int(8) NOT NULL DEFAULT '0',
  `rec_label` char(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `main_values` char(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `source` tinyint(1) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_recode` (`id_reconum`),
  KEY `id_project` (`id_project`),
  KEY `id_question` (`id_question`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `_AsteriskConnect`
--

CREATE TABLE IF NOT EXISTS `_AsteriskConnect` (
  `intlocal` int(8) DEFAULT NULL,
  `www_ids` int(10) DEFAULT NULL,
  `channel_idx` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `channel_uniqueid` int(11) NOT NULL,
  `connect` tinyint(1) DEFAULT NULL,
  `id_tel_log` int(5) DEFAULT NULL,
  `id_tel` int(5) DEFAULT NULL,
  UNIQUE KEY `intlocal` (`intlocal`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

--
-- Struktura tabele `_DatamapAscii`
--

CREATE TABLE IF NOT EXISTS `_DatamapAscii` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_project` int(5) NOT NULL DEFAULT '0',
  `sys_name` char(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `var_name` char(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `var_type` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `start_col` int(5) NOT NULL DEFAULT '0',
  `length_col` int(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id_project` (`id_project`),
  KEY `start_col` (`start_col`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `_DatamapBinary`
--

CREATE TABLE IF NOT EXISTS `_DatamapBinary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_project` int(5) NOT NULL DEFAULT '0',
  `sys_name` char(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `var_name` char(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_cnt` int(5) NOT NULL DEFAULT '0',
  `var_value` int(5) DEFAULT NULL,
  `bin_card` int(3) NOT NULL DEFAULT '0',
  `bin_column` int(2) NOT NULL DEFAULT '0',
  `var_rec_value` char(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `bin_length` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id_project` (`id_project`),
  KEY `bin_card` (`bin_card`),
  KEY `bin_column` (`bin_column`),
  KEY `var_value` (`var_value`),
  KEY `binar` (`bin_card`,`bin_column`,`var_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `_DesignerClsPropLink`
--

CREATE TABLE IF NOT EXISTS `_DesignerClsPropLink` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_class` int(11) NOT NULL,
  `id_property` int(11) NOT NULL,
  `prop_value` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `class_id` (`id_class`,`id_property`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `_DesignerCss`
--

CREATE TABLE IF NOT EXISTS `_DesignerCss` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `id_sup` int(11) NOT NULL,
  `idLab` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `css` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `is_leaf` tinyint(1) NOT NULL,
  `orderBy` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `_DesignerCssProperties`
--

CREATE TABLE IF NOT EXISTS `_DesignerCssProperties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_sup` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `predefined` tinyint(1) NOT NULL,
  `tip` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=118 ;

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

INSERT INTO `_DesignerCssProperties` (`id`, `id_sup`, `name`, `value`, `predefined`, `tip`) VALUES
(1, 3, 'font-size', '', 0, ''),
(10, 3, 'background', '', 0, ''),
(17, 0, 'border-top-color', '', 1, ''),
(18, 0, 'border-top-style', 'none,hidden,dotted,dashed,solid,double,groove,ridge,inset,outset', 1, ''),
(19, 0, 'border-top-width', 'thin,medium,thick', 1, ''),
(20, 0, 'border-top', '', 1, ''),
(21, 0, 'border-right-color', '', 1, ''),
(22, 0, 'border-right-style', 'none,hidden,dotted,dashed,solid,double,groove,ridge,inset,outset', 1, ''),
(23, 0, 'border-right-width', 'thin,medium,thick', 1, ''),
(24, 0, 'border-right', '', 1, ''),
(25, 0, 'border-bottom-color', '', 1, ''),
(26, 0, 'border-bottom-style', 'none,hidden,dotted,dashed,solid,double,groove,ridge,inset,outset', 1, ''),
(27, 0, 'border-bottom-width', 'thin,medium,thick', 1, ''),
(28, 0, 'border-bottom', '', 1, ''),
(29, 0, 'border-left-color', '', 1, ''),
(30, 0, 'border-left-style', 'none,hidden,dotted,dashed,solid,double,groove,ridge,inset,outset', 1, ''),
(31, 0, 'border-left-width', 'thin,medium,thick', 1, ''),
(32, 0, 'border-left', '', 1, ''),
(33, 0, 'border-color', '', 1, ''),
(34, 0, 'border-style', 'none,hidden,dotted,dashed,solid,double,groove,ridge,inset,outset', 1, ''),
(35, 0, 'border-width', 'thin,medium,thick', 1, ''),
(36, 0, 'border', '', 1, ''),
(37, 0, 'clear', 'left,right,both,none', 1, ''),
(38, 0, 'cursor', 'auto,crosshair,default,pointer,move,e-resize,ne-resize,nw-resize,n-resize,se-resize,sw-resize,s-resize,w-resize,text,wait,help', 1, ''),
(39, 0, 'display', 'none,inline,block,list-item,run-in,compact,marker,table,inline-table,table-row-group,table-header-group,table-footer-group,table-row,table-column-group,table-column,table-cell,table-caption', 1, ''),
(40, 0, 'float', 'left,right,none', 1, ''),
(41, 0, 'visibility', 'visible,hidden,collapse', 1, ''),
(42, 0, 'top', '', 1, ''),
(43, 0, 'right', '', 1, ''),
(44, 0, 'bottom', '', 1, ''),
(45, 0, 'left', '', 1, ''),
(46, 0, 'position', 'static,relative,absolute,fixed', 1, ''),
(47, 0, 'clip', '', 1, ''),
(48, 0, 'overflow', 'visible,hidden,scroll,auto', 1, ''),
(49, 0, 'vertical-align', 'baseline,sub,super,top,text-top,middle,bottom,text-bottom', 1, ''),
(50, 0, 'z-index', '', 1, ''),
(51, 0, 'height', '', 1, ''),
(52, 0, 'max-height', '', 1, ''),
(53, 0, 'min-height', '', 1, ''),
(54, 0, 'width', '', 1, ''),
(55, 0, 'max-width', '', 1, ''),
(56, 0, 'min-width', '', 1, ''),
(57, 0, 'font-family', 'Arial,Verdana,sans-serif,Times New Roman,Times,serif', 1, ''),
(59, 0, 'font-size-adjust', '', 1, ''),
(60, 0, 'font-stretch', '', 1, ''),
(61, 0, 'font-style', 'normal,italic,oblique', 1, ''),
(62, 0, 'font-variant', 'normal,small-caps', 1, ''),
(63, 0, 'font-weight', 'normal,bold,bolder,lighter,100,200,300,400,500,600,700,800,900', 1, ''),
(64, 0, 'font', '', 1, ''),
(65, 0, 'list-style-type', 'disc,circle,square,decimal,decimal-leading-zero,lower-roman,upper-roman,lower-alpha,upper-alpha,lower-greek,lower-latin,upper-latin,hebrew,armenian,georgian,cjk-ideographic,hiragana,katakana,hiragana-iroha,katakana-iroha', 1, ''),
(66, 0, 'list-style-position', 'inside,outside', 1, ''),
(67, 0, 'list-style-image', '', 1, ''),
(68, 0, 'list-style', '', 1, ''),
(69, 0, 'marker-offset', '', 1, ''),
(70, 0, 'margin-top', '', 1, ''),
(71, 0, 'margin-right', '', 1, ''),
(72, 0, 'margin-bottom', '', 1, ''),
(73, 0, 'margin-left', '', 1, ''),
(74, 0, 'margin', '', 1, ''),
(75, 0, 'outline-color', '', 1, ''),
(76, 0, 'outline-style', '', 1, ''),
(77, 0, 'outline-width', '', 1, ''),
(78, 0, 'outline', '', 1, ''),
(79, 0, 'padding-top', '', 1, ''),
(80, 0, 'padding-right', '', 1, ''),
(81, 0, 'padding-bottom', '', 1, ''),
(82, 0, 'padding-left', '', 1, ''),
(83, 0, 'padding', '', 1, ''),
(84, 0, 'color', 'aqua,black,blue,fuchsia,gray,green,lime,maroon,navy,olive,purple,red,silver,teal,white,yellow', 1, ''),
(85, 0, 'direction', 'ltr,rtl', 1, ''),
(86, 0, 'line-height', '', 1, ''),
(87, 0, 'letter-spacing', '', 1, ''),
(88, 0, 'text-align', 'left,right,center,justify ', 1, ''),
(89, 0, 'text-decoration', 'none,underline,overline,line-through,blink', 1, ''),
(90, 0, 'text-indent', '', 1, ''),
(91, 0, 'text-shadow', '', 1, ''),
(92, 0, 'unicode-bidi', 'normal,embed,bidi-override', 1, ''),
(93, 0, 'white-space', 'normal,pre,nowrap', 1, ''),
(94, 0, 'word-spacing', '', 1, ''),
(95, 0, 'azimuth', 'left-side,far-left,left,center-left,center,center-right,right,far-right,right-side,behind,leftwards,rightwards', 1, ''),
(96, 0, 'cue-after', '', 1, ''),
(97, 0, 'cue-before', '', 1, ''),
(98, 0, 'cue', '', 1, ''),
(99, 0, 'elevation', 'below,level,above,higher,lower', 1, ''),
(100, 0, 'pause-after', '', 1, ''),
(101, 0, 'pause-before', '', 1, ''),
(102, 0, 'pause', '', 1, ''),
(103, 0, 'pitch', 'x-low,low,medium,high,x-high', 1, ''),
(104, 0, 'pitch-range', '', 1, ''),
(105, 0, 'play-during', '', 1, ''),
(106, 0, 'richness', '', 1, ''),
(107, 0, 'speak', 'normal,none,spell-out', 1, ''),
(108, 0, 'speak-header', 'once,always', 1, ''),
(109, 0, 'speak-numeral', 'digits,continuous', 1, ''),
(110, 0, 'speak-punctuation', 'code,none', 1, ''),
(111, 0, 'speech-rate', 'x-slow,slow,medium,fast,x-fast,faster,slower', 1, ''),
(112, 0, 'stress', '', 1, ''),
(113, 0, 'voice-family', '', 1, ''),
(114, 0, 'volume', 'silent,x-soft,soft,medium,loud,x-loud', 1, '');

-- --------------------------------------------------------
--
-- Struktura tabele `_DesignerElements`
--

CREATE TABLE IF NOT EXISTS `_DesignerElements` (
  `id` int(4) NOT NULL auto_increment,
  `id_sup` int(4) NOT NULL,
  `type` int(11) NOT NULL,
  `idLab` varchar(50) NOT NULL,
  `orderBy` int(11) NOT NULL,
  `node_img` varchar(50) NOT NULL,
  `id_template` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=53 ;

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

INSERT INTO `_DesignerElements` (`id`, `id_sup`, `type`, `idLab`, `orderBy`, `node_img`, `id_template`) VALUES
(1, 10, 1, 'Horizontal Panel', 2, 'RMicon_align_top', 0),
(2, 10, 2, 'Vertical Panel', 1, 'RMicon_align_left', 0),
(3, 12, 3, 'question', 3, 'icon-help-blue', 0),
(4, 12, 4, 'instruction', 2, 'RMicon-info-blue', 0),
(5, 10, 5, 'window', 3, 'RMicon_window', 0),
(6, 12, 6, 'answers', 4, '', 0),
(7, 12, 7, 'variable', 1, '', 0),
(8, 18, 8, 'image', 3, '', 0),
(9, 18, 9, 'video', 4, '', 0),
(10, 0, 0, 'layouts', 1, '', 0),
(11, 12, 10, 'Submit', 5, '', 0),
(12, 0, 0, 'questionnaire', 2, '', 0),
(13, 12, 11, 'back button', 6, '', 0),
(14, 12, 12, 'exit button', 7, '', 0),
(15, 12, 13, 'help button', 8, '', 0),
(16, 12, 14, 'goto start button', 9, '', 0),
(17, 12, 15, 'progress bar', 10, '', 0),
(18, 0, 0, 'questionnaire support', 3, '', 0),
(19, 18, 16, 'welocem text', 1, '', 0),
(20, 18, 17, 'thanksgiving text', 2, '', 0),
(21, 18, 18, 'sound', 5, '', 0),
(22, 18, 19, 'text', 6, '', 0),
(23, 6, 20, 'answer value', 1, '', 0),
(24, 6, 21, 'answer label', 2, '', 0),
(25, 6, 22, 'answer control', 3, '', 0),
(27, 0, 0, 'questionnaire CATI', 4, '', 0),
(28, 27, 23, 'dial button', 1, '', 0),
(29, 27, 24, 'hangup button', 2, '', 0),
(30, 27, 25, 'break start new', 3, '', 0),
(31, 27, 26, 'break-goto idle', 4, '', 0),
(32, 27, 27, 'quota display', 5, '', 0),
(33, 27, 28, 'interview ID', 7, '', 0),
(34, 27, 29, 'project ID', 8, '', 0),
(35, 27, 30, 'tel. struc. data', 11, '', 0),
(36, 27, 31, 'tel. status', 6, '', 0),
(37, 27, 32, 'language selection', 12, '', 0),
(38, 27, 33, 'appointment option', 13, '', 0),
(39, 27, 34, 'quest. confirmed', 15, '', 0),
(40, 27, 35, 'Dialer', 16, '', 0),
(43, 27, 38, 'telephone', 9, '', 0),
(44, 27, 39, 'name', 10, '', 0),
(45, 12, 40, 'leave text', 11, '', 0),
(46, 12, 41, 'Check Idle', 12, '', 0),
(47, 27, 42, 'Make appointment', 19, '', 0),
(48, 27, 43, 'Confirm-start new', 20, '', 0),
(49, 27, 44, 'Confirm-goto idle', 21, '', 0),
(50, 27, 45, 'Continue with other', 22, '', 0),
(51, 27, 46, 'Appointment komment', 14, '', 0),
(52, 0, 0, 'Templates', 5, '', 0);
-- --------------------------------------------------------

--
-- Struktura tabele `_DesignerElemPropLink`
--

CREATE TABLE IF NOT EXISTS `_DesignerElemPropLink` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `object_type` int(11) NOT NULL,
  `id_property` int(11) NOT NULL,
  `default_value` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=34 ;

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

INSERT INTO `_DesignerElemPropLink` (`id`, `object_type`, `id_property`, `default_value`) VALUES
(11, 5, 7, ''),
(10, 5, 6, ''),
(8, 1, 1, ''),
(9, 5, 5, ''),
(5, 0, 1, ''),
(6, 0, 2, ''),
(7, 0, 4, ''),
(12, 10, 8, 'Submit >>'),
(13, 11, 8, '<< Back'),
(14, 12, 8, 'Exit'),
(15, 13, 8, 'Help'),
(16, 14, 8, 'Start'),
(17, 16, 8, ''),
(18, 17, 8, ''),
(19, 19, 8, ''),
(20, 23, 8, 'Dial'),
(21, 24, 8, 'Hangup'),
(22, 25, 8, 'Break interview and start new'),
(23, 26, 8, 'Break interview and goto idle'),
(24, 27, 8, 'Quota unsuccessful!'),
(25, 23, 9, ''),
(26, 23, 10, 'top'),
(27, 24, 9, ''),
(28, 24, 10, 'top'),
(29, 31, 8, 'Status of the telephone number'),
(30, 31, 11, 'radio buttons'),
(31, 40, 8, 'Cannot leave the question'),
(32, 41, 8, 'Goto IDLE'),
(33, 42, 8, 'Make appointment');

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

--
-- Struktura tabele `_DesignerManager`
--

CREATE TABLE IF NOT EXISTS `_DesignerManager` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_template` int(11) NOT NULL,
  `id_question` int(11) NOT NULL,
  `id_type` int(11) NOT NULL,
  `id_project` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `id_qpos` int(11) NOT NULL DEFAULT '-999',
  PRIMARY KEY (`id`),
  UNIQUE KEY `Question` (`id_project`,`id_question`,`id_type`,`id_qpos`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=40 ;

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

INSERT INTO `_DesignerManager` (`id`, `id_template`, `id_question`, `id_type`, `id_project`, `id_user`, `id_qpos`) VALUES
(1, 1, 0, 0, 0, 0, -999),
(2, 2, 0, 7, 0, 0, -999),
(3, 3, 0, 8, 0, 0, -999),
(4, 4, 0, 9, 0, 0, -999),
(5, 6, 0, 0, 0, 0, -4),
(6, 5, 0, 0, 0, 0, -2);

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

--
-- Struktura tabele `_DesignerProperties`
--

CREATE TABLE IF NOT EXISTS `_DesignerProperties` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `properties_name` varchar(255) NOT NULL,
  `properties_value` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

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

INSERT INTO `_DesignerProperties` (`id`, `properties_name`, `properties_value`) VALUES
(1, 'width', ''),
(2, 'height', ''),
(3, 'border', 'TRUE,FALSE'),
(4, 'position', 'auto,relative,absolute'),
(5, 'x', ''),
(6, 'y', ''),
(7, 'zindex', ''),
(8, 'text', ''),
(9, 'src', ''),
(10, 'text_position', 'left,right,top,bottom'),
(11, 'displayAs', 'radio buttons,combobox');

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

--
-- Struktura tabele `_DesignerTemplates`
--

CREATE TABLE IF NOT EXISTS `_DesignerTemplates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_sup` int(11) NOT NULL,
  `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `template_xml` text COLLATE utf8_unicode_ci NOT NULL,
  `type` int(11) NOT NULL DEFAULT '0',
  `orderBy` int(11) NOT NULL,
  `is_leaf` BOOL NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

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

INSERT INTO `_DesignerTemplates` (`id`, `id_sup`, `name`, `template_xml`, `type`, `orderBy`,`is_leaf`) VALUES
(1, 0, 'Default', '<?xml version="1.0"?>\n<DIV id="0"><DIV id="14" type="1" width="20" height="50" position="auto"><VARIABLE id="70" type="7" width="105" height="98.33" position="auto" RMclass="7,10,8"/><INSTRUCTION id="71" type="4" width="697" height="29" position="auto" RMclass="7,8,12"/><DIV id="78" type="2" width="20" height="96.67" position="relative" RMclass="7"/></DIV><DIV id="15" type="1" width="1214" height="372" position="auto"><DIV id="17" type="2" width="6.75" height="99.74" position="relative"/><DIV id="18" type="2" width="800" height="99.74" position="absolute"><QUESTION id="20" type="3" width="99.80" height="13.00" position="relative" RMclass="4,3,9"/><ANSWER id="35" type="6" width="99.80" height="248" position="auto"><DIV id="40" type="1" name="Odd rows" height="33.33" position="relative" subType="2"><DIV id="72" type="22" width="50" height="20" position="absolute"/><DIV id="73" type="20" width="25" height="20" position="absolute"/><DIV id="74" type="21" width="318" height="20" position="auto"/></DIV><DIV id="44" type="1" name="Even rows" height="33.33" position="relative" subType="3"><DIV id="75" type="22" width="50" height="20" position="absolute"/><DIV id="76" type="20" width="25" height="20" position="absolute"/><DIV id="77" type="21" width="318" height="20" position="auto"/></DIV></ANSWER><DIV id="83" type="40" width="20" height="20" position="relative" text="Na vpra&#x161;anje niste pravilno odgovorili!" RMclass="8,11,10"/></DIV><DIV id="50" type="2" width="20" height="20" position="relative"/></DIV><DIV id="16" type="1" width="20" height="10" position="relative"><DIV id="79" type="11" width="40" height="98.25" position="relative" text="&lt;&lt; Nazaj" RMclass="8,7"/><SUBMIT id="80" type="10" width="723" height="98.25" position="auto" text="Potrdi &gt;&gt;" RMclass="8,7"/></DIV><DIV id="81" type="1" width="99.84" height="100" position="absolute"/><DIV id="82" type="1" width="99.84" height="13.12" position="relative"><DIV id="84" type="42" width="35.50" height="99.12" position="relative" text="Make appointment" RMclass="8"/><DIV id="92" type="25" width="20" height="20" position="relative" text="Break interview and start new"/><DIV id="93" type="26" width="20" height="20" position="relative" text="Break interview and go to idle"/></DIV><DIV id="90" type="28" width="20" height="20" position="auto"/><DIV id="91" type="29" width="20" height="20" position="auto"/><DIV id="94" type="38" width="20" height="20" position="relative"/></DIV>\n', 0, 0, 1),
(2, 0, 'Dialer', '<?xml version="1.0"?>\n<DIV id="0"><DIV id="2" type="35" width="99.79" height="50" position="absolute"/><DIV id="3" type="19" width="20" height="20" position="relative" text="hubabuba bela kupa"/><DIV id="4" type="30" width="20" height="20" position="relative"/><DIV id="5" type="39" width="20" height="20" position="relative"/><DIV id="6" type="38" width="20" height="20" position="relative"/><DIV id="7" type="41" width="20" height="20" position="relative" text="Goto IDLE"/></DIV>\n', 1, 0, 1),
(3, 0, 'Status', '<?xml version="1.0"?>\n<DIV id="0" RMclass="14,11"><DIV id="3" type="28" width="99.84" height="20" position="absolute"/><DIV id="4" type="29" width="99.84" height="60" position="absolute"/><DIV id="5" type="38" width="1214" height="20" position="absolute" RMclass="8,4,13"/><DIV id="6" type="39" width="99.84" height="20" position="absolute" RMclass="7"/><DIV id="7" type="30" width="99.79" height="101" position="auto" RMclass="8"/><DIV id="8" type="31" width="99.84" height="86" position="auto" text="Status of the telephone number" displayAs="radio buttons"/><DIV id="10" type="1" width="99.84" height="9.35" position="relative"><SUBMIT id="14" type="10" width="20" height="20" position="relative" text="Potrdi &gt;&gt;" RMclass="8"/><DIV id="17" type="41" width="20" height="20" position="relative" text="Goto IDLE"/></DIV></DIV>\n', 1, 0, 1),
(4, 0, 'Appointment', '<?xml version="1.0"?>\n<DIV id="0"><DIV id="1" type="19" width="99.79" height="89" position="auto" text="Make appointment"/><DIV id="2" type="33" width="99.79" height="329" position="auto"/><SUBMIT id="3" type="10" width="99.79" height="9.01" position="relative" text="Submit &gt;&gt;"/><DIV id="4" type="11" width="99.84" height="9.61" position="relative" text="&lt;&lt; Back"/><DIV id="5" type="41" width="99.84" height="10.52" position="relative" text="Goto IDLE"/></DIV>\n', 0, 0, 1),
(5, 0, 'QuotaFull', '<?xml version="1.0"?>\n<DIV id="0"><INSTRUCTION id="1" type="4" width="20" height="154" position="absolute"/><QUESTION id="2" type="3" width="20" height="154" position="absolute"/><DIV id="5" type="1" width="99.79" height="23.77" position="relative"><DIV id="9" type="2" width="50" height="99.37" position="relative"><DIV id="11" type="43" width="20" height="40" position="relative" text="Start new"/><DIV id="13" type="11" width="99.58" height="40" position="relative" text="&lt;&lt; Back"/><DIV id="14" type="45" width="20" height="20" position="relative" text="Continue with other"/></DIV><DIV id="10" type="2" width="54.47" height="99.37" position="relative"><DIV id="12" type="44" width="20" height="20" position="relative" text="Go to Idle"/></DIV></DIV></DIV>\n', 0, 0, 1),
(6, 0, 'EndConfirm', '<?xml version="1.0"?>\n<DIV id="0"><DIV id="14" type="1" width="20" height="80" position="absolute"><DIV id="66" type="40" width="37.07" height="98.33" position="relative" text="cannot leave"/><DIV id="67" type="19" width="20" height="20" position="relative" text="whatever you want" RMclass="4"/></DIV><DIV id="15" type="1" width="1214" height="400" position="auto"><DIV id="17" type="2" width="100" height="379" position="absolute"/><DIV id="18" type="2" width="82.70" height="99.83" position="relative"><VARIABLE id="19" type="7" width="99.80" height="12.27" position="relative"/><QUESTION id="20" type="3" width="99.80" height="13.00" position="relative" RMclass="4,3"/><ANSWER id="35" type="6" width="99.80" height="248" position="auto"><DIV id="36" type="1" position="relative" name="Legend row" height="33.33" subType="1"><DIV id="37" type="20" width="33.40" position="relative" height="98.21"/><DIV id="38" type="21" width="21.30" position="relative" height="98.21"/><DIV id="39" type="22" width="50" position="absolute"/></DIV><DIV id="40" type="1" name="Odd rows" height="33.33" position="relative" subType="2"><DIV id="41" type="20" width="33.33" position="relative"/><DIV id="48" type="21" width="173" height="55" position="absolute" RMclass="4"/><DIV id="49" type="22" width="315" height="55" position="absolute"/></DIV><DIV id="44" type="1" name="Even rows" height="33.33" position="relative" subType="3"><DIV id="45" type="20" width="33.33" position="relative"/><DIV id="46" type="21" width="180" position="absolute" height="55"/><DIV id="47" type="22" width="50" position="absolute" RMclass="7,3"/></DIV></ANSWER></DIV><DIV id="50" type="2" width="20" height="20" position="relative"/></DIV><DIV id="16" type="1" width="99.84" height="10.00" position="relative"><DIV id="72" type="43" width="50" height="20" position="relative" text="Start new"/><DIV id="73" type="44" width="20" height="20" position="relative" text="Go to idle"/></DIV></DIV>\n', 0, 0, 1);

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

--
-- Struktura tabele `_ExportTemplate`
--

CREATE TABLE IF NOT EXISTS `_ExportTemplate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_project` int(11) NOT NULL,
  `templateName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `variables` text 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 `_ExportTemplate`
--


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

--
-- 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(250) 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=27 ;

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

INSERT INTO `_ProgramMenu` (`id`, `id_sup`, `orderBy`, `idLab`, `node_img`) VALUES
(1, 0, 1, 'Build Questionnaire', 'webcati/_icons/BuildQuestionnaire.gif'),
(7, 24, 1, 'Basic statistics', 'webcati/_icons/Statistics.gif'),
(2, 0, 2, 'Design', 'RMicon_designer'),
(6, 0, 6, 'Export & Import', 'webcati/_icons/ExportImport.gif'),
(4, 0, 5, 'CATI options', 'webcati/_icons/CATIOptions.gif'),
(5, 0, 4, 'Quotas', 'webcati/_icons/Quotas.gif'),
(3, 0, 3, 'Make Sample', 'webcati/_icons/MakeSample.gif'),
(8, 0, 9, 'CAPI options', 'webcati/_icons/CAPIOptions.gif'),
(9, 0, 11, 'User Define Programs', 'webcati/_icons/UserPrograms.gif'),
(16, 3, 1, 'CATI', 'webcati/_icons/submenu_default.gif'),
(17, 3, 2, 'CAWI', 'webcati/_icons/submenu_default.gif'),
(18, 3, 3, 'CAPI', 'webcati/_icons/submenu_default.gif'),
(19, 0, 10, 'Live Update', 'icon_webcati_liveupdate'),
(20, 1, 3, 'Rotations', 'webcati/_icons/submenu_default.gif'),
(21, 2, 3, 'fake', ''),
(22, 1, 1, 'Properties', 'icon-options-3'),
(24, 0, 7, 'Statistics', 'webcati/_icons/Statistics.gif'),
(25, 24, 2, 'Database statistics', 'webcati/_icons/Statistics.gif'),
(26, 24, 3, 'Quota Statistic', 'webcati/_icons/Statistics.gif');

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

--
-- Struktura tabele `_Projects`
--

CREATE TABLE IF NOT EXISTS `_Projects` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `key_proj` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `proj_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `language` tinyint(2) NOT NULL DEFAULT '1',
  `naziv_proj` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `old` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `created` varchar(18) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `creat_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `modify` varchar(18) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `modi_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `print_filter` tinyint(1) NOT NULL DEFAULT '1',
  `print_jump` tinyint(1) NOT NULL DEFAULT '1',
  `print_condition` tinyint(1) NOT NULL DEFAULT '1',
  `print_answfilter` tinyint(1) NOT NULL DEFAULT '1',
  `stat_show_var` tinyint(1) NOT NULL DEFAULT '0',
  `stat_show_val` tinyint(1) NOT NULL DEFAULT '0',
  `lock_app_to_user` tinyint(1) NOT NULL DEFAULT '1',
  `rotation` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `regionopt` tinyint(1) DEFAULT NULL,
  `popup_allow_nocookie` tinyint(1) NOT NULL DEFAULT '0',
  `id_telname` int(3) DEFAULT NULL,
  `tel_reserve` int(8) NOT NULL DEFAULT '0',
  `qt_useregtel` int(1) NOT NULL DEFAULT '0',
  `qt_useactel` int(1) NOT NULL DEFAULT '0',
  `reg_strictlock` int(1) NOT NULL DEFAULT '0',
  `stat_show_scaleborder` tinyint(1) NOT NULL DEFAULT '0',
  `busy_call_delay` int(3) NOT NULL DEFAULT '20',
  `noanswer_call_delay` int(5) NOT NULL DEFAULT '120',
  `num_max_call` int(2) NOT NULL DEFAULT '3',
  `back_delete` tinyint(1) NOT NULL DEFAULT '1',
  `set_use_autodial` tinyint(1) DEFAULT NULL,
  `quota_vars` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `telselect` tinyint(1) NOT NULL DEFAULT '0',
  `proj_backup` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `strictlock_manual` tinyint(1) NOT NULL DEFAULT '0',
  `ml_showopt_www` tinyint(1) NOT NULL DEFAULT '1',
  `ml_position_www` tinyint(1) NOT NULL DEFAULT '2',
  `ml_html_www` text COLLATE utf8_unicode_ci NOT NULL,
  `forward_button_link` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `back_button_link` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `exit_button_link` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `help_button_link` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `quest_distance_buttons` int(3) DEFAULT NULL,
  `submit_where` tinyint(1) NOT NULL DEFAULT '0',
  `submit_auto` tinyint(1) NOT NULL DEFAULT '0',
  `question_over` tinyint(1) NOT NULL DEFAULT '0',
  `user_status_bar` text COLLATE utf8_unicode_ci,
  `radio_button_enable` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `radio_button_disable` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `chk_button_enable` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `chk_button_disable` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `use_img_radio` tinyint(1) NOT NULL DEFAULT '0',
  `submit_delay_press` int(4) NOT NULL DEFAULT '1',
  `exit_alert_msg` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Are you sure?',
  `forward_button_disable_link` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `back_button_disable_link` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `error_img_scale` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `start_quest_button_link` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `quest_start_alert_msg` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Are you sure?',
  `intstat_opt` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `webcapi_clear_all` tinyint(1) NOT NULL DEFAULT '0',
  `webcapi_clear_finished` tinyint(1) NOT NULL DEFAULT '0',
  `webcapi_finished` tinyint(1) NOT NULL DEFAULT '0',
  `use_special_sampling` tinyint(1) NOT NULL DEFAULT '0',
  `wh_special_sampling` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `disablebasic` tinyint(1) NOT NULL DEFAULT '0',
  `call_time_length` int(2) NOT NULL DEFAULT '25',
  `use_predictive` tinyint(1) DEFAULT '0',
  `isTemplate` tinyint(1) NOT NULL,
  `id_select_layer` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `proj_name` (`proj_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `_ProjectsTree`
--

CREATE TABLE IF NOT EXISTS `_ProjectsTree` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `id_sup` int(5) NOT NULL,
  `id_project` int(5) NOT NULL,
  `orderBy` int(5) NOT NULL,
  `idLab` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `node_img` varchar(100) COLLATE cp1250_bin NOT NULL,
  `is_leaf` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250 COLLATE=cp1250_bin AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `_QuestionRotation`
--

CREATE TABLE IF NOT EXISTS `_QuestionRotation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_project` int(11) NOT NULL,
  `id_sup` int(11) NOT NULL,
  `idLab` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `orderBy` int(11) NOT NULL,
  `id_complex` int(11) NOT NULL,
  `id_packet` int(11) NOT NULL,
  `id_question` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `_TelephoneLabelsDef`
--

CREATE TABLE IF NOT EXISTS `_TelephoneLabelsDef` (
  `id_telname` int(11) NOT NULL,
  `is_addon` tinyint(1) NOT NULL,
  `id_var` int(11) NOT NULL,
  `reg_code` int(11) NOT NULL,
  `reg_label` char(250) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_telname`,`is_addon`,`id_var`,`reg_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

--
-- Struktura tabele `_TelephoneStatus`
--

CREATE TABLE IF NOT EXISTS `_TelephoneStatus` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `orderBy` int(2) DEFAULT NULL,
  `autodial_disable` tinyint(1) NOT NULL DEFAULT '0',
  `status` int(3) NOT NULL DEFAULT '0',
  `status_rec` tinyint(1) NOT NULL DEFAULT '0',
  `opis` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `show_default` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `rec_status` (`status_rec`),
  KEY `order_num` (`orderBy`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;

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

INSERT INTO `_TelephoneStatus` (`id`, `orderBy`, `autodial_disable`, `status`, `status_rec`, `opis`, `show_default`) VALUES
(1, 1, 0, 1, 0, 'oseba je pripravljena sodelovati', 1),
(2, 4, 1, 22, 0, 'linija je zasedena', 1),
(3, 2, 0, 3, 0, 'oseba ne želi sodelovati', 1),
(4, 3, 0, 4, 0, 'oseba ne želi nikoli več sodelovati', 1),
(5, 6, 1, 5, 0, 'številka ne obstaja', 1),
(6, 7, 1, 6, 0, 'številka je bila zamenjana', 1),
(7, 8, 0, 7, 4, 'to je številka podjetja', 1),
(8, 9, 1, 9, 0, 'neznana napaka', 1),
(9, 5, 1, 25, 0, 'nihče ne dvigne telefona', 1),
(10, 10, 0, 91, 0, 'Appointment', 1);

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

--
-- Struktura tabele `_TelephoneStatusProject`
--

CREATE TABLE IF NOT EXISTS `_TelephoneStatusProject` (
  `id_project` int(11) NOT NULL,
  `id_status` int(11) NOT NULL,
  `show_status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_project`,`id_status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

--
-- Struktura tabele `_TelephoneTables`
--

CREATE TABLE IF NOT EXISTS `_TelephoneTables` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `id_sup` int(11) NOT NULL,
  `name` varchar(35) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `sts_reg` int(1) NOT NULL DEFAULT '0',
  `sts_ac` int(1) NOT NULL DEFAULT '0',
  `reserved_numbers` text COLLATE utf8_unicode_ci NOT NULL,
  `flag_sample` tinyint(1) NOT NULL DEFAULT '0',
  `orderBy` int(11) NOT NULL,
  `is_leaf` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`,`sts_reg`),
  KEY `sts_ac` (`sts_ac`),
  KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `_TelephoneTablesAddon`
--

CREATE TABLE IF NOT EXISTS `_TelephoneTablesAddon` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `id_telbaza` int(3) NOT NULL DEFAULT '0',
  `name` char(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` char(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `orderBy` int(3) NOT NULL DEFAULT '0',
  `is_leaf` tinyint(1) NOT NULL,
  `is_default` tinyint(1) NOT NULL,
  KEY `id` (`id`),
  KEY `id_telbaza` (`id_telbaza`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `_TelephoneTblAddonProject`
--

CREATE TABLE IF NOT EXISTS `_TelephoneTblAddonProject` (
  `id_var` int(11) NOT NULL,
  `is_addon` tinyint(1) NOT NULL,
  `id_project` int(11) NOT NULL,
  `show_var` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_var`,`id_project`,`is_addon`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

--
-- Struktura tabele `_TelephoneTblDefaultVar`
--

CREATE TABLE IF NOT EXISTS `_TelephoneTblDefaultVar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `use_in_index` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

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

INSERT INTO `_TelephoneTblDefaultVar` (`id`, `name`, `use_in_index`) VALUES
(1, 'oms', 1),
(2, 'telephone', 1),
(3, 'region', 1),
(4, 'address', 0),
(5, 'zip', 1),
(6, 'town', 0),
(7, 'name', 0);

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

--
-- Struktura tabele `_userStatFilters`
--

CREATE TABLE IF NOT EXISTS `_userStatFilters` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(5) unsigned NOT NULL,
  `id_project` int(10) NOT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `filter` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQUE` (`id_user`,`id_project`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `_www_ids`
--

CREATE TABLE IF NOT EXISTS `_www_ids` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `user_type` tinyint(4) NOT NULL,
  `id_project` int(11) NOT NULL,
  `id_site` int(11) NOT NULL,
  `loginSID` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `loginSID` (`loginSID`),
  UNIQUE KEY `UserProjectSite` (`id_user`,`id_project`,`id_site`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `_www_interviewer_session`
--

CREATE TABLE IF NOT EXISTS `_www_interviewer_session` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_loginSID` int(11) NOT NULL,
  `id_ascii_session` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `endDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_impression` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `variable_value` text COLLATE utf8_unicode_ci NOT NULL,
  `user_agent` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `loginSID_id` (`id_loginSID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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


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

--
-- Struktura tabele `_www_interviewer_statistics`
--

CREATE TABLE IF NOT EXISTS `_www_interviewer_statistics` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `id_project` int(11) NOT NULL,
  `id_structure` int(11) NOT NULL,
  `qStatus` tinyint(4) NOT NULL,
  `startDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `endDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `id_loginSID` int(11) NOT NULL,
  `id_sessionSID` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;


--
-- Struktura tabele `_ScriptEvents`
--

CREATE TABLE IF NOT EXISTS `_ScriptEvents` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(25) collate utf8_unicode_ci NOT NULL,
  `parser` varchar(10) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

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

INSERT INTO `_ScriptEvents` (`id`, `name`,`parser`) VALUES
(1, 'beforeload','php'),
(2, 'beforedisplay','php'),
(3, 'afterdisplay', 'js');