From 75160b12821f7f4299cce7f0b69c83c1502ae071 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Anton=20Luka=20=C5=A0ijanec?= Date: Mon, 27 May 2024 13:08:29 +0200 Subject: 2024-02-19 upstream --- sql/1ka_clean_26-11-2021.sql | 7937 ++++++++++++++++++++++++++++++++++++++++++ sql/class.ImportDB.php | 6 +- sql/srv_help_16-4-2023.sql | 52 + sql/srv_help_new.sql | 751 ++++ sql/update2.sql | 362 +- 5 files changed, 9104 insertions(+), 4 deletions(-) create mode 100644 sql/1ka_clean_26-11-2021.sql create mode 100644 sql/srv_help_16-4-2023.sql create mode 100644 sql/srv_help_new.sql (limited to 'sql') diff --git a/sql/1ka_clean_26-11-2021.sql b/sql/1ka_clean_26-11-2021.sql new file mode 100644 index 0000000..b9875a7 --- /dev/null +++ b/sql/1ka_clean_26-11-2021.sql @@ -0,0 +1,7937 @@ +-- phpMyAdmin SQL Dump +-- version 5.1.1 +-- https://www.phpmyadmin.net/ +-- +-- Host: mysql:3306 +-- Generation Time: Mar 21, 2022 at 10:30 AM +-- Server version: 10.3.31-MariaDB-1:10.3.31+maria~focal +-- PHP Version: 7.4.20 + +SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; +START TRANSACTION; +SET time_zone = "+00:00"; + + +/*!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 utf8mb4 */; + + + +-- -------------------------------------------------------- + +-- +-- Table structure for table `aai_prenosi` +-- + +CREATE TABLE `aai_prenosi` ( + `timestamp` int(10) UNSIGNED DEFAULT NULL, + `moja` varchar(500) DEFAULT NULL, + `njegova` varchar(500) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `app_settings` +-- + +CREATE TABLE `app_settings` ( + `what` varchar(100) NOT NULL DEFAULT '', + `domain` varchar(100) NOT NULL DEFAULT '', + `value` text NOT NULL DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `app_settings` +-- + +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_limits-admin_allow_only_ip', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_limits-clicks_per_minute_limit', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_limits-invitation_count_limit', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_limits-question_count_limit', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_limits-response_count_limit', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_settings-admin_email', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_settings-app_name', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_settings-commercial_packages', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_settings-email_signature_custom', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_settings-email_signature_text', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_settings-export_type', '', 'new'); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_settings-footer_custom', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_settings-footer_survey_custom', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_settings-footer_survey_text', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_settings-footer_text', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_settings-owner', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_settings-owner_website', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_settings-survey_finish_url', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('app_settings-custom_logo', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('cebelica_api', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('confirm_registration', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('confirm_registration_admin', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('debug', '', '0'); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('email_server_fromSurvey', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('email_server_settings-SMTPAuth', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('email_server_settings-SMTPFrom', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('email_server_settings-SMTPFromNice', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('email_server_settings-SMTPHost', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('email_server_settings-SMTPPassword', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('email_server_settings-SMTPPort', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('email_server_settings-SMTPReplyTo', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('email_server_settings-SMTPSecure', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('email_server_settings-SMTPUsername', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('facebook-appid', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('facebook-appsecret', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('gdpr_admin_email', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('google-login_client_id', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('google-login_client_secret', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('google-maps_API_key', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('google-recaptcha_sitekey', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('google-secret_captcha', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('hierarhija-default_id', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('hierarhija-folder_id', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('installation_type', '', '0'); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('maza-APP_special_login_key', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('maza-FCM_server_key', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('maza-NextPinMainPassword', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('maza-NextPinMainToken', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('meta_admin_ids', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('paypal-account', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('paypal-client_id', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('paypal-secret', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('squalo-key', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('squalo-user', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('stripe-key', '', ''); +INSERT INTO `app_settings` (`what`, `domain`, `value`) VALUES('stripe-secret', '', ''); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `browser_notifications_respondents` +-- + +CREATE TABLE `browser_notifications_respondents` ( + `id` int(11) NOT NULL, + `timestamp_joined` datetime DEFAULT NULL, + `endpoint_link` varchar(255) NOT NULL, + `endpoint_key` varchar(255) NOT NULL, + `public_key` varchar(255) NOT NULL, + `auth` varchar(255) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `clan` +-- + +CREATE TABLE `clan` ( + `menu` int(10) NOT NULL DEFAULT 0, + `clan` int(10) NOT NULL DEFAULT 0 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `countries_locations` +-- + +CREATE TABLE `countries_locations` ( + `id` int(11) NOT NULL, + `country_code` varchar(3) NOT NULL, + `latitude` float(11,6) NOT NULL, + `longitude` float(11,6) NOT NULL, + `name` varchar(64) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `fb_users` +-- + +CREATE TABLE `fb_users` ( + `id` int(11) NOT NULL, + `uid` int(11) NOT NULL DEFAULT 0, + `first_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `last_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `gender` varchar(2) DEFAULT NULL, + `timezone` varchar(5) DEFAULT NULL, + `profile_link` varchar(255) DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `forum` +-- + +CREATE TABLE `forum` ( + `id` int(11) NOT NULL, + `parent` int(11) NOT NULL DEFAULT 0, + `ord` int(11) NOT NULL DEFAULT 0, + `naslov` varchar(255) NOT NULL DEFAULT '', + `opis` tinytext NOT NULL, + `display` int(11) NOT NULL DEFAULT 1, + `type` tinyint(1) NOT NULL DEFAULT 0, + `click` tinyint(1) NOT NULL DEFAULT 1, + `thread` tinyint(4) NOT NULL DEFAULT 1, + `user` int(11) NOT NULL DEFAULT 0, + `clan` int(11) NOT NULL DEFAULT 0, + `admin` int(11) NOT NULL DEFAULT 0, + `ocena` int(11) NOT NULL DEFAULT 0, + `lockedauth` int(11) NOT NULL DEFAULT 0, + `NiceLink` varchar(255) NOT NULL DEFAULT '' +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `manager` +-- + +CREATE TABLE `manager` ( + `menu` int(10) NOT NULL DEFAULT 0, + `manager` int(10) NOT NULL DEFAULT 0 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `manager_clan` +-- + +CREATE TABLE `manager_clan` ( + `manager` int(10) NOT NULL DEFAULT 0, + `clan` int(10) NOT NULL DEFAULT 0 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `maza_app_users` +-- + +CREATE TABLE `maza_app_users` ( + `id` int(11) NOT NULL, + `identifier` varchar(16) NOT NULL, + `registration_id` varchar(255) DEFAULT NULL, + `datetime_inserted` datetime DEFAULT current_timestamp(), + `datetime_last_active` datetime DEFAULT NULL, + `deviceInfo` text DEFAULT NULL, + `tracking_log` text NOT NULL, + `nextpin_password` varchar(32) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `maza_srv_activity` +-- + +CREATE TABLE `maza_srv_activity` ( + `id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL, + `activity_on` tinyint(1) DEFAULT 0, + `notif_title` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '', + `notif_message` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '', + `notif_sound` tinyint(1) DEFAULT 0, + `activity_type` varchar(30) DEFAULT 'path', + `after_seconds` int(11) DEFAULT 300 +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `maza_srv_alarms` +-- + +CREATE TABLE `maza_srv_alarms` ( + `id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL DEFAULT 0, + `alarm_on` tinyint(1) DEFAULT 0, + `alarm_notif_title` varchar(100) DEFAULT '', + `alarm_notif_message` varchar(100) DEFAULT '', + `repeat_by` varchar(30) DEFAULT 'everyday', + `alarm_notif_sound` tinyint(1) DEFAULT 0, + `time_in_day` varchar(255) DEFAULT NULL, + `day_in_week` varchar(255) DEFAULT NULL, + `every_which_day` int(3) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `maza_srv_entry` +-- + +CREATE TABLE `maza_srv_entry` ( + `id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL DEFAULT 0, + `entry_on` tinyint(1) DEFAULT 0, + `location_check` tinyint(1) DEFAULT 0 +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `maza_srv_geofences` +-- + +CREATE TABLE `maza_srv_geofences` ( + `id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL, + `geofence_on` tinyint(1) DEFAULT 0, + `lat` float(19,15) NOT NULL, + `lng` float(19,15) NOT NULL, + `radius` float(21,13) NOT NULL, + `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '', + `name` varchar(100) DEFAULT NULL, + `notif_title` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '', + `notif_message` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '', + `notif_sound` tinyint(1) DEFAULT 0, + `on_transition` varchar(30) DEFAULT 'dwell', + `after_seconds` int(11) DEFAULT 300, + `location_triggered` tinyint(1) DEFAULT 0, + `trigger_survey` datetime DEFAULT current_timestamp() +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `maza_srv_repeaters` +-- + +CREATE TABLE `maza_srv_repeaters` ( + `id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL DEFAULT 0, + `repeater_on` tinyint(1) DEFAULT 0, + `repeat_by` varchar(30) DEFAULT 'everyday', + `time_in_day` varchar(255) DEFAULT NULL, + `day_in_week` varchar(255) DEFAULT NULL, + `every_which_day` int(3) DEFAULT NULL, + `datetime_start` datetime DEFAULT NULL, + `datetime_end` datetime DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `maza_srv_tracking` +-- + +CREATE TABLE `maza_srv_tracking` ( + `id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL, + `tracking_on` tinyint(1) DEFAULT 0, + `activity_recognition` tinyint(1) DEFAULT 0, + `tracking_accuracy` varchar(30) DEFAULT 'high', + `interval_wanted` int(11) DEFAULT 30, + `interval_fastes` int(11) DEFAULT 10, + `displacement_min` int(11) DEFAULT 10, + `ar_interval_wanted` int(11) DEFAULT 30 +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `maza_srv_triggered_activities` +-- + +CREATE TABLE `maza_srv_triggered_activities` ( + `id` int(11) NOT NULL, + `act_id` int(11) NOT NULL, + `maza_user_id` int(11) NOT NULL, + `triggered_timestamp` datetime NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `maza_srv_triggered_geofences` +-- + +CREATE TABLE `maza_srv_triggered_geofences` ( + `id` int(11) NOT NULL, + `geof_id` int(11) NOT NULL, + `maza_user_id` int(11) NOT NULL, + `triggered_timestamp` datetime NOT NULL, + `enter_timestamp` datetime DEFAULT NULL, + `dwell_timestamp` datetime DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `maza_srv_users` +-- + +CREATE TABLE `maza_srv_users` ( + `maza_user_id` int(11) NOT NULL, + `srv_user_id` int(11) NOT NULL, + `srv_version_datetime` datetime DEFAULT NULL, + `loc_id` int(11) DEFAULT NULL, + `tact_id` int(11) DEFAULT NULL, + `tgeof_id` int(11) DEFAULT NULL, + `mode` varchar(20) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `maza_survey` +-- + +CREATE TABLE `maza_survey` ( + `srv_id` int(11) NOT NULL, + `srv_description` text DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `maza_user_activity_recognition` +-- + +CREATE TABLE `maza_user_activity_recognition` ( + `id` int(11) NOT NULL, + `maza_user_id` int(11) NOT NULL, + `timestamp` datetime NOT NULL, + `in_vehicle` int(3) DEFAULT 0, + `on_bicycle` int(3) DEFAULT 0, + `on_foot` int(3) DEFAULT 0, + `still` int(3) DEFAULT 0, + `unknown` int(3) DEFAULT 0, + `tilting` int(3) DEFAULT 0, + `running` int(3) DEFAULT 0, + `walking` int(3) DEFAULT 0 +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `maza_user_locations` +-- + +CREATE TABLE `maza_user_locations` ( + `id` int(11) NOT NULL, + `maza_user_id` int(11) NOT NULL, + `lat` float(19,15) NOT NULL, + `lng` float(19,15) NOT NULL, + `provider` varchar(30) DEFAULT NULL, + `timestamp` datetime NOT NULL, + `accuracy` float(10,4) DEFAULT NULL, + `altitude` float(10,4) DEFAULT NULL, + `bearing` float(7,4) DEFAULT NULL, + `speed` float(10,4) DEFAULT NULL, + `vertical_acc` float(10,4) DEFAULT NULL, + `bearing_acc` float(7,4) DEFAULT NULL, + `speed_acc` float(10,4) DEFAULT NULL, + `extras` varchar(255) DEFAULT NULL, + `is_mock` tinyint(1) DEFAULT 0, + `tgeof_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `maza_user_srv_access` +-- + +CREATE TABLE `maza_user_srv_access` ( + `maza_user_id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL, + `datetime_started` datetime DEFAULT NULL, + `nextpin_tracking_permitted` tinyint(1) DEFAULT 0, + `tracking_permitted` tinyint(1) DEFAULT NULL, + `datetime_unsubscribed` datetime DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `misc` +-- + +CREATE TABLE `misc` ( + `what` varchar(255) DEFAULT NULL, + `value` mediumtext DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `misc` +-- + +INSERT INTO `misc` (`what`, `value`) VALUES('SurveyDostop', '3'); +INSERT INTO `misc` (`what`, `value`) VALUES('CookieLife', '43200'); +INSERT INTO `misc` (`what`, `value`) VALUES('SurveyCookie', '-1'); +INSERT INTO `misc` (`what`, `value`) VALUES('SurveyForum', '0'); +INSERT INTO `misc` (`what`, `value`) VALUES('SurveyLang_admin', '1'); +INSERT INTO `misc` (`what`, `value`) VALUES('SurveyLang_resp', '1'); +INSERT INTO `misc` (`what`, `value`) VALUES('drupal version', '7.81'); +INSERT INTO `misc` (`what`, `value`) VALUES('mobileApp_version', '16.5.30'); +INSERT INTO `misc` (`what`, `value`) VALUES('drupal version', '7.81'); +INSERT INTO `misc` (`what`, `value`) VALUES('version', '21.11.16'); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `oid_users` +-- + +CREATE TABLE `oid_users` ( + `uid` int(11) DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `post` +-- + +CREATE TABLE `post` ( + `id` int(11) NOT NULL, + `fid` int(11) NOT NULL DEFAULT 0, + `tid` int(11) NOT NULL DEFAULT 0, + `parent` int(11) NOT NULL DEFAULT 0, + `naslov` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', + `naslovnica` tinyint(4) NOT NULL DEFAULT 1, + `vsebina` text CHARACTER SET utf8 NOT NULL, + `ogledov` int(11) NOT NULL DEFAULT 0, + `uid` int(11) NOT NULL DEFAULT 0, + `user` varchar(40) CHARACTER SET utf8 NOT NULL DEFAULT '', + `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `time2` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `admin` int(11) NOT NULL DEFAULT 3, + `dispauth` int(11) NOT NULL DEFAULT 0, + `dispthread` int(11) NOT NULL DEFAULT 0, + `ocena` int(11) NOT NULL DEFAULT 0, + `IP` varchar(128) NOT NULL DEFAULT 'Neznan', + `locked` tinyint(1) NOT NULL DEFAULT 0, + `NiceLink` varchar(255) NOT NULL DEFAULT '' +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `registers` +-- + +CREATE TABLE `registers` ( + `ip` varchar(64) NOT NULL DEFAULT '', + `lasttime` varchar(20) DEFAULT NULL, + `handle` varchar(255) DEFAULT NULL, + `code` varchar(80) DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `restrict_fk_srv_anketa` +-- + +CREATE TABLE `restrict_fk_srv_anketa` ( + `ank_id` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `restrict_fk_srv_anketa` +-- + +INSERT INTO `restrict_fk_srv_anketa` (`ank_id`) VALUES(-1); +INSERT INTO `restrict_fk_srv_anketa` (`ank_id`) VALUES(0); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `restrict_fk_srv_grupa` +-- + +CREATE TABLE `restrict_fk_srv_grupa` ( + `gru_id` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `restrict_fk_srv_grupa` +-- + +INSERT INTO `restrict_fk_srv_grupa` (`gru_id`) VALUES(-2); +INSERT INTO `restrict_fk_srv_grupa` (`gru_id`) VALUES(-1); +INSERT INTO `restrict_fk_srv_grupa` (`gru_id`) VALUES(0); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `restrict_fk_srv_if` +-- + +CREATE TABLE `restrict_fk_srv_if` ( + `if_id` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `restrict_fk_srv_if` +-- + +INSERT INTO `restrict_fk_srv_if` (`if_id`) VALUES(0); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `restrict_fk_srv_spremenljivka` +-- + +CREATE TABLE `restrict_fk_srv_spremenljivka` ( + `spr_id` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `restrict_fk_srv_spremenljivka` +-- + +INSERT INTO `restrict_fk_srv_spremenljivka` (`spr_id`) VALUES(-4); +INSERT INTO `restrict_fk_srv_spremenljivka` (`spr_id`) VALUES(-3); +INSERT INTO `restrict_fk_srv_spremenljivka` (`spr_id`) VALUES(-2); +INSERT INTO `restrict_fk_srv_spremenljivka` (`spr_id`) VALUES(-1); +INSERT INTO `restrict_fk_srv_spremenljivka` (`spr_id`) VALUES(0); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `restrict_fk_srv_vrednost` +-- + +CREATE TABLE `restrict_fk_srv_vrednost` ( + `vre_id` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `restrict_fk_srv_vrednost` +-- + +INSERT INTO `restrict_fk_srv_vrednost` (`vre_id`) VALUES(-4); +INSERT INTO `restrict_fk_srv_vrednost` (`vre_id`) VALUES(-3); +INSERT INTO `restrict_fk_srv_vrednost` (`vre_id`) VALUES(-2); +INSERT INTO `restrict_fk_srv_vrednost` (`vre_id`) VALUES(-1); +INSERT INTO `restrict_fk_srv_vrednost` (`vre_id`) VALUES(0); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_activity` +-- + +CREATE TABLE `srv_activity` ( + `sid` int(11) NOT NULL, + `starts` date NOT NULL, + `expire` date NOT NULL, + `uid` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_advanced_paradata_alert` +-- + +CREATE TABLE `srv_advanced_paradata_alert` ( + `id` int(11) NOT NULL, + `page_id` int(11) NOT NULL, + `time_display` datetime(3) NOT NULL, + `time_close` datetime(3) NOT NULL, + `type` varchar(50) NOT NULL DEFAULT '', + `trigger_id` int(11) NOT NULL, + `trigger_type` varchar(50) NOT NULL DEFAULT '', + `ignorable` enum('0','1') NOT NULL DEFAULT '0', + `text` varchar(200) NOT NULL DEFAULT '', + `action` varchar(50) NOT NULL DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_advanced_paradata_movement` +-- + +CREATE TABLE `srv_advanced_paradata_movement` ( + `id` int(11) NOT NULL, + `page_id` int(11) NOT NULL, + `time_start` datetime(3) NOT NULL, + `time_end` datetime(3) NOT NULL, + `pos_x_start` int(11) NOT NULL DEFAULT 0, + `pos_y_start` int(11) NOT NULL DEFAULT 0, + `pos_x_end` int(11) NOT NULL DEFAULT 0, + `pos_y_end` int(11) NOT NULL DEFAULT 0, + `distance` int(11) DEFAULT 0 +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_advanced_paradata_other` +-- + +CREATE TABLE `srv_advanced_paradata_other` ( + `id` int(11) NOT NULL, + `page_id` int(11) NOT NULL, + `time` datetime(3) NOT NULL, + `event` varchar(50) NOT NULL DEFAULT '', + `value` varchar(50) NOT NULL DEFAULT '', + `pos_x` int(11) NOT NULL DEFAULT 0, + `pos_y` int(11) NOT NULL DEFAULT 0, + `div_id` varchar(100) NOT NULL DEFAULT '', + `div_class` varchar(100) NOT NULL DEFAULT '', + `div_type` varchar(100) NOT NULL DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_advanced_paradata_page` +-- + +CREATE TABLE `srv_advanced_paradata_page` ( + `id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL, + `gru_id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `recnum` int(11) NOT NULL, + `load_time` datetime(3) NOT NULL, + `post_time` datetime(3) NOT NULL, + `user_agent` varchar(250) NOT NULL DEFAULT '', + `language` varchar(50) NOT NULL DEFAULT '', + `devicePixelRatio` decimal(4,2) NOT NULL DEFAULT 0.00, + `width` int(11) NOT NULL DEFAULT 0, + `height` int(11) NOT NULL DEFAULT 0, + `availWidth` int(11) NOT NULL DEFAULT 0, + `availHeight` int(11) NOT NULL DEFAULT 0, + `jquery_windowW` int(11) NOT NULL DEFAULT 0, + `jquery_windowH` int(11) NOT NULL DEFAULT 0, + `jquery_documentW` int(11) NOT NULL DEFAULT 0, + `jquery_documentH` int(11) NOT NULL DEFAULT 0 +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_advanced_paradata_question` +-- + +CREATE TABLE `srv_advanced_paradata_question` ( + `page_id` int(11) NOT NULL, + `spr_id` int(11) NOT NULL, + `vre_order` varchar(250) NOT NULL DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_advanced_paradata_settings` +-- + +CREATE TABLE `srv_advanced_paradata_settings` ( + `ank_id` int(11) NOT NULL, + `collect_post_time` enum('0','1') NOT NULL DEFAULT '1' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_advanced_paradata_vrednost` +-- + +CREATE TABLE `srv_advanced_paradata_vrednost` ( + `id` int(11) NOT NULL, + `page_id` int(11) NOT NULL, + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL, + `time` datetime(3) NOT NULL, + `event` varchar(50) NOT NULL DEFAULT '', + `value` varchar(50) NOT NULL DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_alert` +-- + +CREATE TABLE `srv_alert` ( + `ank_id` int(11) NOT NULL, + `finish_respondent` tinyint(1) NOT NULL DEFAULT 0, + `finish_respondent_cms` tinyint(1) NOT NULL DEFAULT 0, + `finish_author` tinyint(1) NOT NULL DEFAULT 0, + `finish_other` tinyint(1) NOT NULL DEFAULT 0, + `finish_other_emails` mediumtext NOT NULL, + `finish_subject` varchar(250) CHARACTER SET utf8 NOT NULL, + `finish_text` text CHARACTER SET utf8 NOT NULL, + `expire_days` int(11) NOT NULL DEFAULT 3, + `expire_author` tinyint(1) NOT NULL DEFAULT 0, + `expire_other` tinyint(1) NOT NULL DEFAULT 0, + `expire_other_emails` mediumtext NOT NULL, + `expire_text` text CHARACTER SET utf8 NOT NULL, + `expire_subject` varchar(250) CHARACTER SET utf8 NOT NULL, + `delete_author` tinyint(1) NOT NULL DEFAULT 0, + `delete_other` tinyint(1) NOT NULL DEFAULT 0, + `delete_other_emails` mediumtext NOT NULL, + `delete_text` text CHARACTER SET utf8 NOT NULL, + `delete_subject` varchar(250) CHARACTER SET utf8 NOT NULL, + `active_author` tinyint(1) NOT NULL DEFAULT 0, + `active_other` tinyint(1) NOT NULL DEFAULT 0, + `active_other_emails` mediumtext NOT NULL, + `active_text0` text CHARACTER SET utf8 NOT NULL, + `active_subject0` varchar(250) CHARACTER SET utf8 NOT NULL, + `active_text1` text CHARACTER SET utf8 NOT NULL, + `active_subject1` varchar(250) CHARACTER SET utf8 NOT NULL, + `finish_respondent_if` int(11) DEFAULT NULL, + `finish_respondent_cms_if` int(11) DEFAULT NULL, + `finish_other_if` int(11) DEFAULT NULL, + `reply_to` varchar(250) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `srv_alert` +-- + +INSERT INTO `srv_alert` (`ank_id`, `finish_respondent`, `finish_respondent_cms`, `finish_author`, `finish_other`, `finish_other_emails`, `finish_subject`, `finish_text`, `expire_days`, `expire_author`, `expire_other`, `expire_other_emails`, `expire_text`, `expire_subject`, `delete_author`, `delete_other`, `delete_other_emails`, `delete_text`, `delete_subject`, `active_author`, `active_other`, `active_other_emails`, `active_text0`, `active_subject0`, `active_text1`, `active_subject1`, `finish_respondent_if`, `finish_respondent_cms_if`, `finish_other_if`, `reply_to`) VALUES(0, 0, 0, 0, 0, '', '', '', 3, 1, 0, '', 'Spoštovani,

obveščamo vas, da bo anketa "[SURVEY]" potekla čez [DAYS] dni.

Povezava: [URL]

Čas aktivnosti lahko podaljšate v nastavitvah [DURATION]
\n
\n
\n1KA
\n--------
\nOrodje za spletne ankete: http://www.1ka.si', '1KA - obvestilo o izteku ankete', 0, 0, '', '', '', 0, 0, '', '', '', '', '', NULL, NULL, NULL, ''); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_alert_custom` +-- + +CREATE TABLE `srv_alert_custom` ( + `ank_id` int(11) NOT NULL, + `type` varchar(20) NOT NULL, + `uid` int(11) NOT NULL, + `subject` varchar(250) NOT NULL, + `text` text NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_analysis_archive` +-- + +CREATE TABLE `srv_analysis_archive` ( + `id` int(11) NOT NULL, + `sid` int(11) NOT NULL DEFAULT 0, + `uid` int(11) NOT NULL DEFAULT 0, + `name` varchar(200) NOT NULL, + `filename` varchar(50) NOT NULL, + `date` datetime NOT NULL, + `note` varchar(200) NOT NULL, + `access` tinyint(4) NOT NULL DEFAULT 0, + `access_password` varchar(30) DEFAULT NULL, + `type` tinyint(4) NOT NULL DEFAULT 0, + `duration` date NOT NULL, + `editid` int(11) NOT NULL DEFAULT 0, + `settings` mediumtext DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_anketa` +-- + +CREATE TABLE `srv_anketa` ( + `id` int(11) NOT NULL, + `hash` varchar(8) CHARACTER SET utf8 NOT NULL DEFAULT '', + `folder` int(11) NOT NULL DEFAULT 1, + `backup` int(11) NOT NULL, + `naslov` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `akronim` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `active` tinyint(4) NOT NULL DEFAULT 0, + `locked` tinyint(4) NOT NULL DEFAULT 0, + `db_table` tinyint(4) NOT NULL DEFAULT 0, + `starts` date NOT NULL, + `expire` date NOT NULL, + `introduction` text CHARACTER SET utf8 DEFAULT NULL, + `conclusion` text CHARACTER SET utf8 DEFAULT NULL, + `statistics` text CHARACTER SET utf8 DEFAULT NULL, + `intro_opomba` varchar(250) CHARACTER SET utf8 DEFAULT NULL, + `concl_opomba` varchar(250) CHARACTER SET utf8 DEFAULT NULL, + `show_intro` tinyint(4) NOT NULL DEFAULT 1, + `intro_static` tinyint(4) NOT NULL DEFAULT 0, + `show_concl` tinyint(4) NOT NULL DEFAULT 1, + `concl_link` int(11) NOT NULL DEFAULT 0, + `concl_back_button` tinyint(4) NOT NULL DEFAULT 1, + `concl_end_button` tinyint(4) NOT NULL DEFAULT 1, + `text` varchar(250) NOT NULL, + `url` varchar(250) NOT NULL, + `insert_uid` int(11) NOT NULL, + `insert_time` datetime NOT NULL, + `edit_uid` int(11) NOT NULL, + `edit_time` datetime NOT NULL, + `last_response_time` datetime NOT NULL, + `cookie` tinyint(4) NOT NULL DEFAULT 2, + `cookie_return` tinyint(4) NOT NULL DEFAULT 0, + `return_finished` tinyint(4) NOT NULL DEFAULT 0, + `subsequent_answers` enum('0','1') NOT NULL DEFAULT '1', + `cookie_continue` tinyint(4) NOT NULL DEFAULT 1, + `user_from_cms` int(11) NOT NULL DEFAULT 0, + `user_from_cms_email` int(11) NOT NULL DEFAULT 0, + `user_base` tinyint(4) NOT NULL DEFAULT 0, + `usercode_skip` tinyint(4) NOT NULL DEFAULT 0, + `usercode_required` tinyint(4) NOT NULL DEFAULT 0, + `usercode_text` varchar(255) NOT NULL, + `block_ip` int(11) NOT NULL DEFAULT 0, + `dostop` int(11) NOT NULL DEFAULT 3, + `dostop_admin` date NOT NULL, + `odgovarja` tinyint(4) NOT NULL DEFAULT 4, + `skin` varchar(100) NOT NULL DEFAULT '1kaBlue', + `mobile_skin` varchar(100) NOT NULL DEFAULT 'MobileBlue', + `skin_profile` int(11) NOT NULL, + `skin_profile_mobile` int(11) NOT NULL, + `skin_checkbox` tinyint(4) NOT NULL DEFAULT 0, + `branching` smallint(6) NOT NULL DEFAULT 0, + `alert_respondent` tinyint(4) NOT NULL DEFAULT 0, + `alert_avtor` tinyint(4) NOT NULL DEFAULT 0, + `alert_admin` tinyint(4) NOT NULL DEFAULT 0, + `alert_more` tinyint(1) NOT NULL DEFAULT 0, + `uporabnost_link` varchar(400) NOT NULL, + `progressbar` tinyint(4) NOT NULL DEFAULT 0, + `sidebar` tinyint(4) NOT NULL DEFAULT 1, + `collapsed_content` tinyint(4) NOT NULL DEFAULT 1, + `library` tinyint(4) NOT NULL DEFAULT 0, + `countType` tinyint(1) NOT NULL DEFAULT 0, + `survey_type` tinyint(4) NOT NULL DEFAULT 2, + `forum` int(11) NOT NULL DEFAULT 0, + `thread` int(11) NOT NULL, + `thread_intro` int(11) NOT NULL DEFAULT 0, + `thread_concl` int(11) NOT NULL DEFAULT 0, + `intro_note` text NOT NULL, + `concl_note` text NOT NULL, + `vote_limit` tinyint(4) NOT NULL DEFAULT 0, + `vote_count` int(11) NOT NULL DEFAULT 0, + `lang_admin` tinyint(4) NOT NULL DEFAULT 1, + `lang_resp` tinyint(4) NOT NULL DEFAULT 1, + `multilang` tinyint(4) NOT NULL DEFAULT 0, + `expanded` tinyint(4) NOT NULL DEFAULT 1, + `flat` tinyint(4) NOT NULL DEFAULT 0, + `toolbox` tinyint(4) NOT NULL DEFAULT 1, + `popup` tinyint(4) NOT NULL DEFAULT 1, + `missing_values_type` tinyint(4) NOT NULL DEFAULT 0, + `mass_insert` enum('0','1') NOT NULL, + `monitoring` enum('0','1') NOT NULL, + `show_email` enum('0','1') NOT NULL DEFAULT '1', + `vprasanje_tracking` enum('0','1','2','3') CHARACTER SET utf8 NOT NULL DEFAULT '0', + `parapodatki` enum('0','1') NOT NULL, + `individual_invitation` enum('0','1') NOT NULL DEFAULT '1', + `email_to_list` enum('0','1') NOT NULL DEFAULT '0', + `invisible` enum('0','1') NOT NULL DEFAULT '0', + `continue_later` enum('1','0') NOT NULL DEFAULT '0', + `js_tracking` text NOT NULL, + `concl_PDF_link` tinyint(4) NOT NULL DEFAULT 0, + `concl_return_edit` enum('0','1') NOT NULL DEFAULT '0', + `defValidProfile` tinyint(4) NOT NULL DEFAULT 2, + `showItime` tinyint(4) NOT NULL DEFAULT 0, + `showLineNumber` tinyint(4) NOT NULL DEFAULT 0, + `mobile_created` enum('0','1') NOT NULL DEFAULT '0' +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `srv_anketa` +-- + +INSERT INTO `srv_anketa` (`id`, `hash`, `folder`, `backup`, `naslov`, `akronim`, `active`, `locked`, `db_table`, `starts`, `expire`, `introduction`, `conclusion`, `statistics`, `intro_opomba`, `concl_opomba`, `show_intro`, `intro_static`, `show_concl`, `concl_link`, `concl_back_button`, `concl_end_button`, `text`, `url`, `insert_uid`, `insert_time`, `edit_uid`, `edit_time`, `last_response_time`, `cookie`, `cookie_return`, `return_finished`, `subsequent_answers`, `cookie_continue`, `user_from_cms`, `user_from_cms_email`, `user_base`, `usercode_skip`, `usercode_required`, `usercode_text`, `block_ip`, `dostop`, `dostop_admin`, `odgovarja`, `skin`, `mobile_skin`, `skin_profile`, `skin_profile_mobile`, `skin_checkbox`, `branching`, `alert_respondent`, `alert_avtor`, `alert_admin`, `alert_more`, `uporabnost_link`, `progressbar`, `sidebar`, `collapsed_content`, `library`, `countType`, `survey_type`, `forum`, `thread`, `thread_intro`, `thread_concl`, `intro_note`, `concl_note`, `vote_limit`, `vote_count`, `lang_admin`, `lang_resp`, `multilang`, `expanded`, `flat`, `toolbox`, `popup`, `missing_values_type`, `mass_insert`, `monitoring`, `show_email`, `vprasanje_tracking`, `parapodatki`, `individual_invitation`, `email_to_list`, `invisible`, `continue_later`, `js_tracking`, `concl_PDF_link`, `concl_return_edit`, `defValidProfile`, `showItime`, `showLineNumber`, `mobile_created`) VALUES(-1, '-1', 1, 0, 'system', '', 0, 0, 0, '0000-00-00', '0000-00-00', '', '', '', '', '', 1, 0, 1, 0, 1, 1, '', '', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, 0, 1, '1', 1, 0, 0, 0, 1, 0, '', 0, 3, '0000-00-00', 4, 'Modern', 'Mobile', 0, 0, 0, 1, 0, 0, 0, 0, '', 1, 1, 1, 0, 0, 2, 0, 0, 0, 0, '', '', 0, 0, 1, 1, 0, 1, 1, 1, 1, 0, '0', '0', '0', '0', '0', '1', '0', '0', '1', '', 0, '0', 2, 0, 0, '0'); +INSERT INTO `srv_anketa` (`id`, `hash`, `folder`, `backup`, `naslov`, `akronim`, `active`, `locked`, `db_table`, `starts`, `expire`, `introduction`, `conclusion`, `statistics`, `intro_opomba`, `concl_opomba`, `show_intro`, `intro_static`, `show_concl`, `concl_link`, `concl_back_button`, `concl_end_button`, `text`, `url`, `insert_uid`, `insert_time`, `edit_uid`, `edit_time`, `last_response_time`, `cookie`, `cookie_return`, `return_finished`, `subsequent_answers`, `cookie_continue`, `user_from_cms`, `user_from_cms_email`, `user_base`, `usercode_skip`, `usercode_required`, `usercode_text`, `block_ip`, `dostop`, `dostop_admin`, `odgovarja`, `skin`, `mobile_skin`, `skin_profile`, `skin_profile_mobile`, `skin_checkbox`, `branching`, `alert_respondent`, `alert_avtor`, `alert_admin`, `alert_more`, `uporabnost_link`, `progressbar`, `sidebar`, `collapsed_content`, `library`, `countType`, `survey_type`, `forum`, `thread`, `thread_intro`, `thread_concl`, `intro_note`, `concl_note`, `vote_limit`, `vote_count`, `lang_admin`, `lang_resp`, `multilang`, `expanded`, `flat`, `toolbox`, `popup`, `missing_values_type`, `mass_insert`, `monitoring`, `show_email`, `vprasanje_tracking`, `parapodatki`, `individual_invitation`, `email_to_list`, `invisible`, `continue_later`, `js_tracking`, `concl_PDF_link`, `concl_return_edit`, `defValidProfile`, `showItime`, `showLineNumber`, `mobile_created`) VALUES(0, '0', 1, 0, 'system', '', 0, 0, 0, '0000-00-00', '0000-00-00', '', '', '', '', '', 1, 0, 1, 0, 1, 1, '', '', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, 0, 1, '1', 1, 0, 0, 0, 1, 0, '', 0, 3, '0000-00-00', 4, 'Modern', 'Mobile', 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, 1, 0, 0, 2, 0, 0, 0, 0, '', '', 0, 0, 1, 1, 0, 1, 1, 1, 1, 0, '0', '0', '0', '0', '0', '1', '0', '0', '1', '', 0, '0', 2, 0, 0, '0'); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_anketa_module` +-- + +CREATE TABLE `srv_anketa_module` ( + `ank_id` int(11) NOT NULL, + `modul` varchar(100) NOT NULL DEFAULT '', + `vrednost` tinyint(4) NOT NULL DEFAULT 1 +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_anketa_template` +-- + +CREATE TABLE `srv_anketa_template` ( + `id` int(11) NOT NULL, + `kategorija` tinyint(1) DEFAULT 0, + `ank_id_slo` int(11) NOT NULL, + `naslov_slo` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '', + `desc_slo` text NOT NULL, + `ank_id_eng` int(11) NOT NULL, + `naslov_eng` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '', + `desc_eng` text NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_api_auth` +-- + +CREATE TABLE `srv_api_auth` ( + `usr_id` int(11) NOT NULL DEFAULT 0, + `identifier` text NOT NULL, + `private_key` text NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_branching` +-- + +CREATE TABLE `srv_branching` ( + `ank_id` int(11) NOT NULL, + `parent` int(11) NOT NULL, + `element_spr` int(11) NOT NULL, + `element_if` int(11) NOT NULL, + `vrstni_red` int(11) NOT NULL, + `pagebreak` tinyint(4) NOT NULL DEFAULT 0, + `timestamp` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_calculation` +-- + +CREATE TABLE `srv_calculation` ( + `id` int(11) NOT NULL, + `cnd_id` int(11) NOT NULL, + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL, + `grd_id` int(11) NOT NULL, + `operator` smallint(6) NOT NULL, + `number` int(11) NOT NULL DEFAULT 0, + `left_bracket` smallint(6) NOT NULL, + `right_bracket` smallint(6) NOT NULL, + `vrstni_red` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_call_current` +-- + +CREATE TABLE `srv_call_current` ( + `usr_id` int(11) NOT NULL, + `user_id` int(10) UNSIGNED NOT NULL, + `started_time` datetime NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_call_history` +-- + +CREATE TABLE `srv_call_history` ( + `id` int(10) UNSIGNED NOT NULL, + `survey_id` int(11) NOT NULL, + `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0, + `usr_id` int(11) NOT NULL, + `insert_time` datetime NOT NULL, + `status` enum('A','Z','N','R','T','P','U') NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_call_schedule` +-- + +CREATE TABLE `srv_call_schedule` ( + `usr_id` int(11) NOT NULL, + `call_time` datetime NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_call_setting` +-- + +CREATE TABLE `srv_call_setting` ( + `survey_id` int(11) NOT NULL, + `status_z` int(10) UNSIGNED NOT NULL DEFAULT 0, + `status_n` int(10) UNSIGNED NOT NULL DEFAULT 0, + `max_calls` int(10) UNSIGNED NOT NULL DEFAULT 0 +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_captcha` +-- + +CREATE TABLE `srv_captcha` ( + `ank_id` int(11) NOT NULL, + `spr_id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `text` char(5) NOT NULL, + `code` char(40) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_chart_skin` +-- + +CREATE TABLE `srv_chart_skin` ( + `id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL DEFAULT 0, + `name` varchar(200) NOT NULL, + `colors` varchar(200) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_chat_settings` +-- + +CREATE TABLE `srv_chat_settings` ( + `ank_id` int(11) NOT NULL, + `code` text NOT NULL, + `chat_type` enum('0','1','2') NOT NULL DEFAULT '0' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_clicks` +-- + +CREATE TABLE `srv_clicks` ( + `ank_id` int(11) NOT NULL, + `click_count` smallint(6) NOT NULL DEFAULT 0, + `click_time` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_comment_resp` +-- + +CREATE TABLE `srv_comment_resp` ( + `id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL DEFAULT 0, + `usr_id` int(11) NOT NULL DEFAULT 0, + `comment_time` datetime NOT NULL, + `comment` text NOT NULL, + `ocena` enum('0','1','2','3') NOT NULL DEFAULT '0' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_condition` +-- + +CREATE TABLE `srv_condition` ( + `id` int(11) NOT NULL, + `if_id` int(11) NOT NULL, + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL, + `grd_id` int(11) NOT NULL, + `conjunction` smallint(6) NOT NULL DEFAULT 0, + `negation` smallint(6) NOT NULL DEFAULT 0, + `operator` smallint(6) NOT NULL DEFAULT 0, + `text` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `modul` smallint(6) NOT NULL DEFAULT 2, + `ostanek` smallint(6) NOT NULL DEFAULT 0, + `left_bracket` smallint(6) NOT NULL DEFAULT 0, + `right_bracket` smallint(6) NOT NULL DEFAULT 0, + `vrstni_red` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_condition_grid` +-- + +CREATE TABLE `srv_condition_grid` ( + `cond_id` int(11) NOT NULL, + `grd_id` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_condition_profiles` +-- + +CREATE TABLE `srv_condition_profiles` ( + `id` int(11) NOT NULL, + `sid` int(11) NOT NULL, + `uid` int(11) NOT NULL, + `name` varchar(250) NOT NULL, + `if_id` int(11) NOT NULL, + `condition_label` text NOT NULL, + `condition_error` tinyint(1) NOT NULL DEFAULT 0, + `type` enum('default','inspect','zoom') NOT NULL DEFAULT 'default' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_condition_vre` +-- + +CREATE TABLE `srv_condition_vre` ( + `cond_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_custom_report` +-- + +CREATE TABLE `srv_custom_report` ( + `id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL DEFAULT 0, + `usr_id` int(11) NOT NULL DEFAULT 0, + `spr1` varchar(255) NOT NULL DEFAULT '', + `spr2` varchar(255) NOT NULL DEFAULT '', + `type` tinyint(1) NOT NULL DEFAULT 0, + `sub_type` tinyint(1) NOT NULL DEFAULT 0, + `vrstni_red` tinyint(1) NOT NULL DEFAULT 0, + `text` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `profile` int(11) NOT NULL DEFAULT 0, + `time_edit` datetime NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_custom_report_profiles` +-- + +CREATE TABLE `srv_custom_report_profiles` ( + `id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL DEFAULT 0, + `usr_id` int(11) NOT NULL DEFAULT 0, + `name` varchar(200) NOT NULL, + `time_created` datetime NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_custom_report_share` +-- + +CREATE TABLE `srv_custom_report_share` ( + `ank_id` int(11) NOT NULL DEFAULT 0, + `profile_id` int(11) NOT NULL DEFAULT 0, + `author_usr_id` int(11) NOT NULL DEFAULT 0, + `share_usr_id` int(11) NOT NULL DEFAULT 0 +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_datasetting_profile` +-- + +CREATE TABLE `srv_datasetting_profile` ( + `id` int(11) NOT NULL, + `uid` int(11) NOT NULL DEFAULT 0, + `name` varchar(200) NOT NULL, + `dsp_ndp` tinyint(4) NOT NULL DEFAULT 1, + `dsp_nda` tinyint(4) NOT NULL DEFAULT 2, + `dsp_ndd` tinyint(4) NOT NULL DEFAULT 2, + `dsp_res` tinyint(4) NOT NULL DEFAULT 3, + `dsp_sep` tinyint(4) NOT NULL DEFAULT 0, + `crossChk0` enum('0','1') NOT NULL DEFAULT '1', + `crossChk1` enum('0','1') NOT NULL DEFAULT '0', + `crossChk2` enum('0','1') NOT NULL DEFAULT '0', + `crossChk3` enum('0','1') NOT NULL DEFAULT '0', + `crossChkEC` enum('0','1') NOT NULL DEFAULT '0', + `crossChkRE` enum('0','1') NOT NULL DEFAULT '0', + `crossChkSR` enum('0','1') NOT NULL DEFAULT '0', + `crossChkAR` enum('0','1') NOT NULL DEFAULT '0', + `doColor` enum('0','1') NOT NULL DEFAULT '0', + `dovalues` enum('0','1') NOT NULL DEFAULT '1', + `showCategories` enum('0','1') NOT NULL DEFAULT '1', + `showOther` enum('0','1') NOT NULL DEFAULT '1', + `showNumbers` enum('0','1') NOT NULL DEFAULT '1', + `showText` enum('0','1') NOT NULL DEFAULT '1', + `chartNumbering` enum('0','1') NOT NULL DEFAULT '0', + `chartFP` enum('0','1') NOT NULL DEFAULT '0', + `chartTableAlign` enum('0','1') NOT NULL DEFAULT '0', + `chartTableMore` enum('0','1') NOT NULL DEFAULT '0', + `chartNumerusText` enum('0','1','2','3') NOT NULL DEFAULT '0', + `chartAvgText` enum('0','1') NOT NULL DEFAULT '1', + `chartFontSize` tinyint(4) NOT NULL DEFAULT 8, + `chartPieZeros` enum('0','1') NOT NULL DEFAULT '1', + `hideEmpty` enum('0','1') NOT NULL DEFAULT '0', + `numOpenAnswers` int(11) NOT NULL DEFAULT 10, + `dataPdfType` enum('0','1','2') NOT NULL DEFAULT '0', + `exportDataNumbering` enum('0','1') NOT NULL DEFAULT '1', + `exportDataShowIf` enum('0','1') NOT NULL DEFAULT '1', + `exportDataFontSize` tinyint(4) NOT NULL DEFAULT 10, + `exportDataShowRecnum` enum('0','1') NOT NULL DEFAULT '1', + `exportDataPB` enum('0','1') NOT NULL DEFAULT '0', + `exportDataSkipEmpty` enum('0','1') NOT NULL DEFAULT '0', + `exportDataSkipEmptySub` enum('0','1') NOT NULL DEFAULT '0', + `exportDataLandscape` enum('0','1') NOT NULL DEFAULT '0', + `exportNumbering` enum('0','1') NOT NULL DEFAULT '1', + `exportShowIf` enum('0','1') NOT NULL DEFAULT '1', + `exportFontSize` tinyint(4) NOT NULL DEFAULT 10, + `exportShowIntro` enum('0','1') NOT NULL DEFAULT '0', + `enableInspect` enum('0','1') NOT NULL DEFAULT '0', + `dataShowIcons` enum('0','1') NOT NULL DEFAULT '1', + `analysisGoTo` enum('0','1') NOT NULL DEFAULT '1', + `analiza_legenda` enum('0','1') NOT NULL DEFAULT '0', + `hideAllSystem` enum('0','1') NOT NULL DEFAULT '0' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_checkgrid_active` +-- + +CREATE TABLE `srv_data_checkgrid_active` ( + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `grd_id` int(11) NOT NULL, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_checkgrid_archive1` +-- + +CREATE TABLE `srv_data_checkgrid_archive1` ( + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `grd_id` int(11) NOT NULL, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_checkgrid_archive2` +-- + +CREATE TABLE `srv_data_checkgrid_archive2` ( + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `grd_id` int(11) NOT NULL, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_files` +-- + +CREATE TABLE `srv_data_files` ( + `sid` int(11) NOT NULL, + `head_file_time` datetime NOT NULL, + `data_file_time` datetime NOT NULL, + `collect_all_status` tinyint(4) NOT NULL DEFAULT 1, + `collect_full_meta` tinyint(4) NOT NULL DEFAULT 1, + `last_update` datetime NOT NULL, + `dashboard_file_time` int(11) UNSIGNED NOT NULL, + `dashboard_update_time` datetime NOT NULL, + `updateInProgress` enum('0','1') NOT NULL DEFAULT '0', + `updateStartTime` datetime NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_glasovanje` +-- + +CREATE TABLE `srv_data_glasovanje` ( + `spr_id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `spol` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_grid_active` +-- + +CREATE TABLE `srv_data_grid_active` ( + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `grd_id` int(11) NOT NULL, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_grid_archive1` +-- + +CREATE TABLE `srv_data_grid_archive1` ( + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `grd_id` int(11) NOT NULL, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_grid_archive2` +-- + +CREATE TABLE `srv_data_grid_archive2` ( + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `grd_id` int(11) NOT NULL, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_heatmap` +-- + +CREATE TABLE `srv_data_heatmap` ( + `id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `spr_id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL, + `loop_id` int(11) DEFAULT NULL, + `vre_id` int(11) DEFAULT NULL, + `lat` float(19,15) NOT NULL, + `lng` float(19,15) NOT NULL, + `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '', + `text` text CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `vrstni_red` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_imena` +-- + +CREATE TABLE `srv_data_imena` ( + `id` int(10) UNSIGNED NOT NULL, + `spr_id` int(11) NOT NULL DEFAULT 0, + `text` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `usr_id` int(11) NOT NULL DEFAULT 0, + `antonucci` int(1) NOT NULL DEFAULT 0, + `emotion` tinyint(1) NOT NULL DEFAULT 0, + `social` tinyint(1) NOT NULL DEFAULT 0, + `emotionINT` tinyint(1) NOT NULL DEFAULT 0, + `socialINT` tinyint(1) NOT NULL DEFAULT 0, + `countE` int(11) NOT NULL DEFAULT 0, + `countS` int(11) NOT NULL DEFAULT 0 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_map` +-- + +CREATE TABLE `srv_data_map` ( + `id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `spr_id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL, + `loop_id` int(11) DEFAULT NULL, + `vre_id` int(11) DEFAULT NULL, + `lat` float(19,15) NOT NULL, + `lng` float(19,15) NOT NULL, + `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '', + `text` text CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `vrstni_red` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_number` +-- + +CREATE TABLE `srv_data_number` ( + `spr_id` int(11) NOT NULL DEFAULT 0, + `vre_id` int(11) NOT NULL DEFAULT 0, + `usr_id` int(11) NOT NULL DEFAULT 0, + `text` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `text2` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_random_blockContent` +-- + +CREATE TABLE `srv_data_random_blockContent` ( + `id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `block_id` int(11) NOT NULL, + `vrstni_red` varchar(255) DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_random_spremenljivkaContent` +-- + +CREATE TABLE `srv_data_random_spremenljivkaContent` ( + `id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `spr_id` int(11) NOT NULL, + `vrstni_red` varchar(255) NOT NULL DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_rating` +-- + +CREATE TABLE `srv_data_rating` ( + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `vrstni_red` int(11) NOT NULL, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_textgrid_active` +-- + +CREATE TABLE `srv_data_textgrid_active` ( + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `grd_id` int(11) NOT NULL, + `text` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_textgrid_archive1` +-- + +CREATE TABLE `srv_data_textgrid_archive1` ( + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `grd_id` int(11) NOT NULL, + `text` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_textgrid_archive2` +-- + +CREATE TABLE `srv_data_textgrid_archive2` ( + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `grd_id` int(11) NOT NULL, + `text` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_text_active` +-- + +CREATE TABLE `srv_data_text_active` ( + `id` int(10) UNSIGNED NOT NULL, + `spr_id` int(11) NOT NULL DEFAULT 0, + `vre_id` int(11) NOT NULL DEFAULT 0, + `text` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `text2` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `usr_id` int(11) DEFAULT 0, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_text_archive1` +-- + +CREATE TABLE `srv_data_text_archive1` ( + `id` int(10) UNSIGNED NOT NULL, + `spr_id` int(11) NOT NULL DEFAULT 0, + `vre_id` int(11) NOT NULL DEFAULT 0, + `text` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `text2` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `usr_id` int(11) DEFAULT 0, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_text_archive2` +-- + +CREATE TABLE `srv_data_text_archive2` ( + `id` int(10) UNSIGNED NOT NULL, + `spr_id` int(11) NOT NULL DEFAULT 0, + `vre_id` int(11) NOT NULL DEFAULT 0, + `text` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `text2` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `usr_id` int(11) DEFAULT 0, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_upload` +-- + +CREATE TABLE `srv_data_upload` ( + `ank_id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `code` char(13) NOT NULL, + `filename` varchar(50) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_vrednost_active` +-- + +CREATE TABLE `srv_data_vrednost_active` ( + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL DEFAULT 0, + `usr_id` int(11) NOT NULL DEFAULT 0, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_vrednost_archive1` +-- + +CREATE TABLE `srv_data_vrednost_archive1` ( + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL DEFAULT 0, + `usr_id` int(11) NOT NULL DEFAULT 0, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_vrednost_archive2` +-- + +CREATE TABLE `srv_data_vrednost_archive2` ( + `spr_id` int(11) NOT NULL, + `vre_id` int(11) NOT NULL DEFAULT 0, + `usr_id` int(11) NOT NULL DEFAULT 0, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_data_vrednost_cond` +-- + +CREATE TABLE `srv_data_vrednost_cond` ( + `id` int(10) UNSIGNED NOT NULL, + `spr_id` int(11) NOT NULL DEFAULT 0, + `vre_id` int(11) NOT NULL DEFAULT 0, + `text` text COLLATE utf8_bin NOT NULL, + `usr_id` int(11) NOT NULL DEFAULT 0, + `loop_id` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_dostop` +-- + +CREATE TABLE `srv_dostop` ( + `ank_id` int(11) NOT NULL, + `uid` int(11) NOT NULL, + `aktiven` tinyint(4) NOT NULL DEFAULT 1, + `alert_complete` tinyint(1) NOT NULL DEFAULT 0, + `alert_expire` tinyint(1) NOT NULL DEFAULT 0, + `alert_delete` tinyint(1) NOT NULL DEFAULT 0, + `alert_active` tinyint(1) NOT NULL DEFAULT 0, + `alert_complete_if` int(11) DEFAULT NULL, + `dostop` set('edit','test','publish','data','analyse','export','link','mail','dashboard','phone','mail_server','lock') NOT NULL DEFAULT 'edit,test,publish,data,analyse,export,dashboard' +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_dostop_language` +-- + +CREATE TABLE `srv_dostop_language` ( + `ank_id` int(11) NOT NULL, + `uid` int(11) NOT NULL, + `lang_id` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_dostop_manage` +-- + +CREATE TABLE `srv_dostop_manage` ( + `manager` int(11) NOT NULL, + `user` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_evoli_landingpage_access` +-- + +CREATE TABLE `srv_evoli_landingpage_access` ( + `ank_id` int(11) NOT NULL DEFAULT 0, + `email` varchar(100) NOT NULL DEFAULT '', + `pass` varchar(100) NOT NULL DEFAULT '', + `time_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `used` enum('0','1') NOT NULL DEFAULT '0' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_evoli_teammeter` +-- + +CREATE TABLE `srv_evoli_teammeter` ( + `id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL DEFAULT 0, + `skupina_id` int(11) NOT NULL DEFAULT 0, + `email` varchar(100) DEFAULT '', + `lang_id` int(11) NOT NULL DEFAULT 1, + `url` varchar(255) DEFAULT '', + `kvota_max` int(11) NOT NULL DEFAULT 0, + `kvota_val` int(11) NOT NULL DEFAULT 0, + `date_from` date NOT NULL DEFAULT '0000-00-00', + `date_to` date NOT NULL DEFAULT '0000-00-00', + `datum_posiljanja` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_evoli_teammeter_data_department` +-- + +CREATE TABLE `srv_evoli_teammeter_data_department` ( + `department_id` int(11) NOT NULL DEFAULT 0, + `usr_id` int(11) NOT NULL DEFAULT 0 +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_evoli_teammeter_delayed` +-- + +CREATE TABLE `srv_evoli_teammeter_delayed` ( + `id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL, + `date_from` date NOT NULL DEFAULT '0000-00-00', + `tm_group` text NOT NULL, + `emails` text NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_evoli_teammeter_department` +-- + +CREATE TABLE `srv_evoli_teammeter_department` ( + `id` int(11) NOT NULL, + `tm_id` int(11) NOT NULL DEFAULT 0, + `department` varchar(255) DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_fieldwork` +-- + +CREATE TABLE `srv_fieldwork` ( + `id` int(10) UNSIGNED NOT NULL, + `terminal_id` varchar(255) DEFAULT NULL, + `sid_terminal` int(10) UNSIGNED DEFAULT NULL, + `sid_server` int(10) UNSIGNED DEFAULT NULL, + `secret` varchar(500) DEFAULT NULL, + `lastnum` int(11) NOT NULL DEFAULT 0 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_folder` +-- + +CREATE TABLE `srv_folder` ( + `id` int(11) NOT NULL, + `naslov` varchar(50) NOT NULL, + `parent` int(11) NOT NULL, + `creator_uid` int(11) NOT NULL DEFAULT 0 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `srv_folder` +-- + +INSERT INTO `srv_folder` (`id`, `naslov`, `parent`, `creator_uid`) VALUES(1, 'Moje 1KA ankete', 0, 0); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_gdpr_anketa` +-- + +CREATE TABLE `srv_gdpr_anketa` ( + `ank_id` int(11) NOT NULL, + `1ka_template` enum('0','1') NOT NULL DEFAULT '0', + `name` enum('0','1') NOT NULL DEFAULT '0', + `email` enum('0','1') NOT NULL DEFAULT '0', + `location` enum('0','1') NOT NULL DEFAULT '0', + `phone` enum('0','1') NOT NULL DEFAULT '0', + `web` enum('0','1') NOT NULL DEFAULT '0', + `other` enum('0','1') NOT NULL DEFAULT '0', + `other_text_slo` varchar(255) NOT NULL DEFAULT '', + `other_text_eng` varchar(255) NOT NULL DEFAULT '', + `about` text NOT NULL, + `expire` enum('0','1') NOT NULL DEFAULT '0', + `expire_text_slo` varchar(255) NOT NULL DEFAULT '', + `expire_text_eng` varchar(255) NOT NULL DEFAULT '', + `other_users` enum('0','1') NOT NULL DEFAULT '0', + `other_users_text_slo` varchar(255) NOT NULL DEFAULT '', + `other_users_text_eng` varchar(255) NOT NULL DEFAULT '', + `export` enum('0','1') NOT NULL DEFAULT '0', + `export_country_slo` varchar(255) NOT NULL DEFAULT '', + `export_country_eng` varchar(255) NOT NULL DEFAULT '', + `export_user_slo` varchar(255) NOT NULL DEFAULT '', + `export_user_eng` varchar(255) NOT NULL DEFAULT '', + `export_legal_slo` varchar(255) NOT NULL DEFAULT '', + `export_legal_eng` varchar(255) NOT NULL DEFAULT '', + `authorized` varchar(255) NOT NULL DEFAULT '', + `contact_email` varchar(255) NOT NULL DEFAULT '', + `note_slo` text NOT NULL DEFAULT '', + `note_eng` text NOT NULL DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_gdpr_requests` +-- + +CREATE TABLE `srv_gdpr_requests` ( + `id` int(11) NOT NULL, + `usr_id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL, + `url` varchar(200) NOT NULL DEFAULT '', + `email` varchar(100) NOT NULL DEFAULT '', + `datum` datetime NOT NULL, + `ip` varchar(100) NOT NULL DEFAULT '', + `recnum` varchar(50) NOT NULL DEFAULT '', + `text` text NOT NULL, + `status` enum('0','1') NOT NULL DEFAULT '0', + `type` tinyint(1) NOT NULL DEFAULT 0, + `comment` text NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_gdpr_user` +-- + +CREATE TABLE `srv_gdpr_user` ( + `usr_id` int(11) NOT NULL, + `type` enum('0','1') NOT NULL DEFAULT '0', + `has_dpo` enum('0','1') NOT NULL DEFAULT '0', + `organization` varchar(255) NOT NULL DEFAULT '', + `organization_maticna` varchar(255) NOT NULL DEFAULT '', + `organization_davcna` varchar(255) NOT NULL DEFAULT '', + `dpo_phone` varchar(255) NOT NULL DEFAULT '', + `dpo_email` varchar(255) NOT NULL DEFAULT '', + `dpo_lastname` varchar(255) NOT NULL DEFAULT '', + `dpo_firstname` varchar(255) NOT NULL DEFAULT '', + `firstname` varchar(50) NOT NULL DEFAULT '', + `lastname` varchar(50) NOT NULL DEFAULT '', + `email` varchar(50) NOT NULL DEFAULT '', + `phone` varchar(255) NOT NULL DEFAULT '', + `address` varchar(255) NOT NULL DEFAULT '', + `country` varchar(255) NOT NULL DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_glasovanje` +-- + +CREATE TABLE `srv_glasovanje` ( + `ank_id` int(11) NOT NULL, + `spr_id` int(11) NOT NULL, + `show_results` tinyint(4) NOT NULL DEFAULT 0, + `show_percent` tinyint(4) NOT NULL DEFAULT 1, + `show_graph` tinyint(4) NOT NULL DEFAULT 1, + `spol` tinyint(4) NOT NULL DEFAULT 0, + `stat_count` tinyint(4) NOT NULL DEFAULT 1, + `stat_time` tinyint(4) NOT NULL DEFAULT 1, + `embed` tinyint(4) NOT NULL DEFAULT 0, + `show_title` tinyint(4) NOT NULL DEFAULT 0, + `stat_archive` tinyint(4) NOT NULL DEFAULT 0, + `skin` varchar(100) NOT NULL DEFAULT 'Classic' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_grid` +-- + +CREATE TABLE `srv_grid` ( + `id` int(11) NOT NULL, + `spr_id` int(11) NOT NULL, + `naslov` varchar(250) CHARACTER SET utf8 DEFAULT NULL, + `vrstni_red` int(11) NOT NULL DEFAULT 0, + `variable` varchar(15) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `other` tinyint(4) NOT NULL DEFAULT 0, + `part` tinyint(4) NOT NULL DEFAULT 1, + `naslov_graf` varchar(255) NOT NULL DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_grid_multiple` +-- + +CREATE TABLE `srv_grid_multiple` ( + `ank_id` int(11) NOT NULL, + `parent` int(11) NOT NULL, + `spr_id` int(11) NOT NULL, + `vrstni_red` smallint(6) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_grupa` +-- + +CREATE TABLE `srv_grupa` ( + `id` int(11) NOT NULL, + `ank_id` int(11) NOT NULL DEFAULT 0, + `naslov` varchar(250) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', + `vrstni_red` int(11) NOT NULL DEFAULT 0, + `timestamp` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `srv_grupa` +-- + +INSERT INTO `srv_grupa` (`id`, `ank_id`, `naslov`, `vrstni_red`, `timestamp`) VALUES(-2, 0, 'system', 0, '2018-03-05 09:50:10'); +INSERT INTO `srv_grupa` (`id`, `ank_id`, `naslov`, `vrstni_red`, `timestamp`) VALUES(-1, 0, 'system', 0, '2018-03-05 09:50:10'); +INSERT INTO `srv_grupa` (`id`, `ank_id`, `naslov`, `vrstni_red`, `timestamp`) VALUES(0, 0, 'system', 0, '2018-03-05 09:50:10'); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_hash_url` +-- + +CREATE TABLE `srv_hash_url` ( + `hash` varchar(32) NOT NULL, + `anketa` int(11) NOT NULL DEFAULT 0, + `properties` text NOT NULL, + `comment` varchar(256) NOT NULL, + `access_password` varchar(30) DEFAULT NULL, + `refresh` int(2) NOT NULL DEFAULT 0, + `page` enum('data','analysis') DEFAULT 'data', + `add_date` datetime DEFAULT NULL, + `add_uid` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `srv_help` +-- + +CREATE TABLE `srv_help` ( + `what` varchar(50) NOT NULL, + `lang` tinyint(4) NOT NULL DEFAULT 1, + `help` text NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `srv_help` +-- + +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('DataPiping', 1, 'Če respondent pri vprašanju npr. Q1 (npr. Katero je vaše najljubše sadje) odgovori npr. \"jabolka\", lahko to vključimo v vprašanje Q2, npr. \"Kako pogosto kupujete #Q1# na tržnici?\r\n\r\nPri tem je treba upoštevati:\r\n\r\n * Vprašanje Q2, ki vključi odgovor, mora biti na naslednji strani,\r\n * Ime spremenljivke, ki se prenaša (Q1) je treba spremeniti, ker je lahko predmet avtomatskega preštevilčenja, npr. spremenimo \"Q1\" v \"SADJE\"'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('DataPiping', 2, 'if the respondent in the question e.g. Q1 (e.g. what is your favorite fruit) answers e.g. \"apples\", this can be included in question Q2, e.g. \"How often do you buy #Q1# at the market?\r\n\r\nThe following must be taken into account:\r\n\r\n * Question Q2, which includes the answer, should be on the next page,\r\n * The name of the variable to be transmitted (Q1) needs to be changed because it can be subject to automatic renumbering, e.g. change \"Q1\" to \"FRUIT\"'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('displaychart_settings', 1, 'If a respondent\'s answer from a question, i.e. Q1 (\"Which fruit is your favourite?\") is \"apple\", we can include this to a subsequent question (i.e. Q2) with the #Q1# command, i.e. \"How often do you by #Q1# at the market?\"\r\n \r\nIt should be taken into account:\r\n\r\n * Question Q2, which includes the answer, should be on the next page\r\n * The name of the variable that is being piped (Q1) should be renamed because it may be subject to automatic enumeration, i.e. change \"Q1\" to \"FRUIT\" '); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('displaydata_checkboxes', 1, '

Kadar je izbrana opcija \"Podatki\", se v tabeli prikazujejo podatki respondentov.

\r\n\r\n

Kadar je izbrana opcija \"Parapodatki\" prikazujemo meta podatke uporabnika: datum vnosa, datum popravljanja, čase po straneh, IP, JavaScript, podatke brskalnika, jezik.

\r\n

Kadar je izbrana opcija \"Identifikatorji\" prikazujemo sistemske podatke respondenta, ki so bili vnešeni preko sistema za pošiljanje vabil: ime, priimek, email itd.

'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('displaydata_checkboxes', 2, '

If you select the \"Data\" option, the data of the respondents will be displayed in the table.

\r\n\r\n

If you select the \"Para data\" option, users\" para data will be displayed in the table: insert date, edit date, time per page, IP, browser, JavaScript etc.

\r\n

If you select the \" System data\" option, the table will display respondents\" system information, such as name, surname, email etc.

'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('displaydata_data', 1, 'Kadar je opcija izbrana, se v tabeli prikažejo podatki respondentov'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('displaydata_data', 2, 'When the option is selected, the respondents\" data is displayed in the table'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('displaydata_meta', 1, 'Priakže meta podatke uporabnika: datum vnosa, datum popravljanja, čase po straneh, IP, JavaScript, podatke brskalnika'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('displaydata_meta', 2, 'Displays user meta data: entry date, correction date, times per page, IP, JavaScript, browser data'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('displaydata_pdftype', 1, 'Razširjen izpis pomeni izpis oblike, kakršne je vprašalnik, skrčen izpis pa izpiše vprašalnik z rezultati v skrajšani obliki. Preberi več'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('displaydata_pdftype', 2, 'Long display means the display in a form of the questionnaire, a short version means that questionnaire results will be presented in an abbreviated form.'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('displaydata_status', 1, '

status (6-končal anketo, 5-delno izpolnjena, 4-klik na anketo, 3-klik na nagovor, 2-epošta-napaka, 1-epošta-neodgovor, 0-epošta-ni poslana)

lurker - prazna anketa (1 = da, 0 = ne)

Zaporedna številka vnosa

'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('displaydata_status', 2, '

status (6-completed survey, 5-completed, 4-click on survey, 3-click on address, 2-email-error, 1-email-non-response, 0-email-not sent)

lurker - empty survey (1 = yes, 0 = no)

Sequence number of the entry

'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('displaydata_system', 1, 'Prikaže sistemske podatke respondenta: ime, priimek, email...'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('displaydata_system', 2, 'Displays system data of the respondent: name, surname, email ....'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('dodaj_searchbox', 1, 'V zemljevid vključi tudi iskalno okno, preko katerega lahko respondent tudi opisno poišče lokacijo na zemljevidu'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('dodaj_searchbox', 2, 'It also includes a search window in the map, through which the respondent can also search for a descriptive location on the map'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('edit_date_range', 1, 'Datum lahko navzdol omejimo z letnico, naprimer: 1951 ali kot obdobje -70, kar pomeni zadnjih 70 let. Podobno lahko omejimo datum tudi navzgor. Naprimer: 2013 ali kot obdobje +10, kar pomeni naslednjih 10 let'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('edit_date_range', 2, 'The date can be limited downward with a year, 1951 or as a period -70, which means the last 70 years. Similarly, we can also limit the date upward. For example: 2013 or as a period +10, which means the next 10 years.'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('edit_variable', 1, 'Tu lahko poljubno spremenite privzeto ime spremenljivke, kar se upošteva tudi pri kasnejšem izvozu podatkov. Paziti morate, da se imena spremenljivk ne podvajajo. '); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('edit_variable', 2, 'You can change the default variable name, which is also taken into account in the subsequent export of data. You should make sure that variable names are not duplicated.'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('exportSettings', 1, 'Kadar izberete \"Izvozi samo identifikatorje\" se bodo izvozili samo identifikatorji (sistemski podatki repondenta), brez katerikoli drugih podatkov.
Kadar pa ne izvažate identifikatorjev pa lahko izvozite posamezne para podatke respondenta.'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('help-centre', 1, '1KA center za pomoč lahko pomaga uporabnikom tudi pri konkretni anketi, vendar potrebuje začasen dostop do ankete, za kar je potrebna vaša oz. avtorjeva odobritev. Seveda pa začasen dostop velja le za tiste dele ankete, kjer se je težava pojavila, in je potreben za rešitev problema. Dostop omogočite s klikom na povezavo \"Dovoli dostop centu za pomoč\".Preberi več'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('help-centre', 2, '1KA help centre can help users with a specific survey, but need a temporary access to the survey, which requires your approval. Of course, the temporary access only applies to those parts of the survey where the problem occurred and is necessary to solve the problem. You can enable the access by clicking the \"Grant access to help centre\".Read more'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('individual_invitation', 1, 'Z individualiziranimi vabili lahko preverite, kdo iz seznama je odgovoril na anketo in kdo ne, kar je podlaga za pošiljanje opomnikov. Preberi več'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('individual_invitation', 2, 'With individualized invitations, you can check who on the list responded to the survey and who did not, which is the basis for sending reminders.Read more'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('inv_recipiens_from_system', 1, 'Prejemniki bodo dodani iz obstoječih podatkov v bazi, pri čemer mora vprašalnik vsebovati sistemsko spremenljivko email.'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('inv_recipiens_from_system', 2, 'Recipients will be added from the existing data in the database, which means, that the questionnaire must include a system variable - email.'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('marker_podvprasanje', 1, 'V oblaček markerja dodaj podvprašanje'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('naslov_podvprasanja_map', 1, 'Besedilo podvprašanja v oblačku markerja'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('naslov_podvprasanja_map', 2, 'Sub-question text in the marker bubble'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('Prevodi', 0, ''); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('spremenljivka_reminder', 1, 'V primeru, da respondent ni odgovoril na predvideno vprašanje, imamo tri možnosti:\r\n'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('spremenljivka_reminder', 2, 'If the respondent did not answer the intended question, we have three options:\r\n'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('spremenljivka_sistem', 1, 'S klikanjem na nastavitve v lahko zbiramo med dvema vrstama integracije vprašanja v anketo:\r\n\r\nV primeru uporabe email vabil preko 1KA email sistema, mora biti spremenljivka \"email\" označena kot sistemska, ne glede, če je email vnesel respondent sam ali pa ga je pred anketiranjem vnesel administrator.'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('spremenljivka_sistem', 2, 'By clicking on the settings in we can collect between two types of integration of questions into the survey:\r\n\r\nIn case of using email invitations via 1KA email system, the variable \" email \" must be marked as system, regardless of whether the email was entered by the respondent himself or by the administrator before the survey.'); +INSERT INTO `srv_help` (`what`, `lang`, `help`) VALUES('spremenljivka_visible', 1, 'S klikanjem na nastavitve vidnosti lahko zbiramo med dvema vrstama integrcije vprašanja v anketo:\r\n