From f1ab2f022fdc780aca0944d90e9a0e844a0820d7 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Anton=20Luka=20=C5=A0ijanec?= Date: Mon, 27 May 2024 13:12:17 +0200 Subject: =?UTF-8?q?2024-02-19:=20popravljen=20(prej=C5=A1nji=20commit=20je?= =?UTF-8?q?=20napa=C4=8Den)?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- sql/1ka_clean_27-9-2018_orig.sql | 6119 -------------------------------------- 1 file changed, 6119 deletions(-) delete mode 100644 sql/1ka_clean_27-9-2018_orig.sql (limited to 'sql/1ka_clean_27-9-2018_orig.sql') diff --git a/sql/1ka_clean_27-9-2018_orig.sql b/sql/1ka_clean_27-9-2018_orig.sql deleted file mode 100644 index 801d2cf..0000000 --- a/sql/1ka_clean_27-9-2018_orig.sql +++ /dev/null @@ -1,6119 +0,0 @@ --- MySQL dump 10.13 Distrib 5.7.11, for Win64 (x86_64) --- --- Host: localhost Database: 1ka_clean --- ------------------------------------------------------ --- Server version 5.7.11 - -/*!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 */; -/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; -/*!40103 SET TIME_ZONE='+00:00' */; -/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; -/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; -/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; - --- --- Table structure for table `aai_prenosi` --- - -DROP TABLE IF EXISTS `aai_prenosi`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `aai_prenosi` --- - -LOCK TABLES `aai_prenosi` WRITE; -/*!40000 ALTER TABLE `aai_prenosi` DISABLE KEYS */; -/*!40000 ALTER TABLE `aai_prenosi` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `clan` --- - -DROP TABLE IF EXISTS `clan`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `clan` ( - `menu` int(10) NOT NULL DEFAULT '0', - `clan` int(10) NOT NULL DEFAULT '0' -) ENGINE=MyISAM DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `clan` --- - -LOCK TABLES `clan` WRITE; -/*!40000 ALTER TABLE `clan` DISABLE KEYS */; -/*!40000 ALTER TABLE `clan` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `fb_users` --- - -DROP TABLE IF EXISTS `fb_users`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `fb_users` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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, - KEY `id` (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `fb_users` --- - -LOCK TABLES `fb_users` WRITE; -/*!40000 ALTER TABLE `fb_users` DISABLE KEYS */; -/*!40000 ALTER TABLE `fb_users` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `forum` --- - -DROP TABLE IF EXISTS `forum`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `forum` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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 '', - PRIMARY KEY (`id`), - KEY `admin_index` (`admin`), - KEY `user_index` (`user`), - FULLTEXT KEY `naslov` (`naslov`), - FULLTEXT KEY `NiceLink` (`NiceLink`), - FULLTEXT KEY `NiceLink_2` (`NiceLink`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `forum` --- - -LOCK TABLES `forum` WRITE; -/*!40000 ALTER TABLE `forum` DISABLE KEYS */; -/*!40000 ALTER TABLE `forum` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `manager` --- - -DROP TABLE IF EXISTS `manager`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `manager` ( - `menu` int(10) NOT NULL DEFAULT '0', - `manager` int(10) NOT NULL DEFAULT '0' -) ENGINE=MyISAM DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `manager` --- - -LOCK TABLES `manager` WRITE; -/*!40000 ALTER TABLE `manager` DISABLE KEYS */; -/*!40000 ALTER TABLE `manager` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `manager_clan` --- - -DROP TABLE IF EXISTS `manager_clan`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `manager_clan` ( - `manager` int(10) NOT NULL DEFAULT '0', - `clan` int(10) NOT NULL DEFAULT '0' -) ENGINE=MyISAM DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `manager_clan` --- - -LOCK TABLES `manager_clan` WRITE; -/*!40000 ALTER TABLE `manager_clan` DISABLE KEYS */; -/*!40000 ALTER TABLE `manager_clan` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `maza_app_users` --- - -DROP TABLE IF EXISTS `maza_app_users`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `maza_app_users` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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, - `tracking_log` text NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `maza_app_users` --- - -LOCK TABLES `maza_app_users` WRITE; -/*!40000 ALTER TABLE `maza_app_users` DISABLE KEYS */; -/*!40000 ALTER TABLE `maza_app_users` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `maza_srv_activity` --- - -DROP TABLE IF EXISTS `maza_srv_activity`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `maza_srv_activity` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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', - PRIMARY KEY (`id`), - KEY `fk_maza_activity_srv_ank_id` (`ank_id`), - CONSTRAINT `fk_maza_activity_srv_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `maza_srv_activity` --- - -LOCK TABLES `maza_srv_activity` WRITE; -/*!40000 ALTER TABLE `maza_srv_activity` DISABLE KEYS */; -/*!40000 ALTER TABLE `maza_srv_activity` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `maza_srv_alarms` --- - -DROP TABLE IF EXISTS `maza_srv_alarms`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `maza_srv_alarms` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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, - PRIMARY KEY (`id`), - KEY `fk_maza_srv_ank_id` (`ank_id`), - CONSTRAINT `fk_maza_srv_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `maza_srv_alarms` --- - -LOCK TABLES `maza_srv_alarms` WRITE; -/*!40000 ALTER TABLE `maza_srv_alarms` DISABLE KEYS */; -/*!40000 ALTER TABLE `maza_srv_alarms` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `maza_srv_geofences` --- - -DROP TABLE IF EXISTS `maza_srv_geofences`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `maza_srv_geofences` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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 '', - `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', - PRIMARY KEY (`id`), - KEY `ank_id` (`ank_id`), - CONSTRAINT `fk_maza_geofences_srv_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `maza_srv_geofences` --- - -LOCK TABLES `maza_srv_geofences` WRITE; -/*!40000 ALTER TABLE `maza_srv_geofences` DISABLE KEYS */; -/*!40000 ALTER TABLE `maza_srv_geofences` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `maza_srv_repeaters` --- - -DROP TABLE IF EXISTS `maza_srv_repeaters`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `maza_srv_repeaters` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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, - PRIMARY KEY (`id`), - KEY `fk_maza_repeater_srv_ank_id` (`ank_id`), - CONSTRAINT `fk_maza_repeater_srv_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `maza_srv_repeaters` --- - -LOCK TABLES `maza_srv_repeaters` WRITE; -/*!40000 ALTER TABLE `maza_srv_repeaters` DISABLE KEYS */; -/*!40000 ALTER TABLE `maza_srv_repeaters` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `maza_srv_triggered_geofences` --- - -DROP TABLE IF EXISTS `maza_srv_triggered_geofences`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `maza_srv_triggered_geofences` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `geof_id` int(11) NOT NULL, - `maza_user_id` int(11) NOT NULL, - `triggered_timestamp` datetime NOT NULL, - PRIMARY KEY (`id`), - KEY `geof_id` (`geof_id`), - KEY `maza_user_id` (`maza_user_id`), - CONSTRAINT `fk_maza_srv_triggered_geofences_geof_id` FOREIGN KEY (`geof_id`) REFERENCES `maza_srv_geofences` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_maza_srv_triggered_geofences_maza_user_id` FOREIGN KEY (`maza_user_id`) REFERENCES `maza_app_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `maza_srv_triggered_geofences` --- - -LOCK TABLES `maza_srv_triggered_geofences` WRITE; -/*!40000 ALTER TABLE `maza_srv_triggered_geofences` DISABLE KEYS */; -/*!40000 ALTER TABLE `maza_srv_triggered_geofences` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `maza_srv_users` --- - -DROP TABLE IF EXISTS `maza_srv_users`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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, - `geof_id` int(11) DEFAULT NULL, - `activity_id` int(11) DEFAULT NULL, - KEY `fk_maza_app_users_maza_srv_users` (`maza_user_id`), - KEY `fk_srv_user_maza_srv_users` (`srv_user_id`), - KEY `fk_maza_srv_users_geof_id` (`geof_id`), - KEY `fk_maza_srv_users_activity_id` (`activity_id`), - CONSTRAINT `fk_maza_app_users_maza_srv_users` FOREIGN KEY (`maza_user_id`) REFERENCES `maza_app_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_maza_srv_users_activity_id` FOREIGN KEY (`activity_id`) REFERENCES `maza_srv_activity` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_maza_srv_users_geof_id` FOREIGN KEY (`geof_id`) REFERENCES `maza_srv_geofences` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_user_maza_srv_users` FOREIGN KEY (`srv_user_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `maza_srv_users` --- - -LOCK TABLES `maza_srv_users` WRITE; -/*!40000 ALTER TABLE `maza_srv_users` DISABLE KEYS */; -/*!40000 ALTER TABLE `maza_srv_users` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `maza_user_srv_access` --- - -DROP TABLE IF EXISTS `maza_user_srv_access`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `maza_user_srv_access` ( - `maza_user_id` int(11) NOT NULL, - `ank_id` int(11) NOT NULL, - `datetime_started` datetime DEFAULT NULL, - KEY `fk_maza_app_users_maza_user_srv_access` (`ank_id`), - KEY `fk_srv_anketa_maza_user_srv_access` (`maza_user_id`), - CONSTRAINT `fk_maza_app_users_maza_user_srv_access` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_anketa_maza_user_srv_access` FOREIGN KEY (`maza_user_id`) REFERENCES `maza_app_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `maza_user_srv_access` --- - -LOCK TABLES `maza_user_srv_access` WRITE; -/*!40000 ALTER TABLE `maza_user_srv_access` DISABLE KEYS */; -/*!40000 ALTER TABLE `maza_user_srv_access` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `misc` --- - -DROP TABLE IF EXISTS `misc`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `misc` ( - `what` varchar(255) DEFAULT NULL, - `value` mediumtext -) ENGINE=MyISAM DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `misc` --- - -LOCK TABLES `misc` WRITE; -/*!40000 ALTER TABLE `misc` DISABLE KEYS */; -INSERT INTO `misc` VALUES ('FS','15'),('active','1'),('confirm','0'),('obisk','0'),('active','1'),('confirm','0'),('obisk','0'),('active','1'),('confirm','0'),('name','1ka'),('keywords','web survey software, internet survey, online survey, web questionaires'),('RegSurname','0'),('description','1KA je na eni strani spletno mesto, ki podaja pregled nad tehnologijo in metodologijo spletnih anket, hkrati pa je tudi on-line platforma, kjer je mogoèe izdelovati spletne ankete.'),('m2w2all','0'),('UserDataReply','info@1ka.si'),('AfterNews','

Dear SFNAME,
\r\n
\r\nhere are the news from SFPAGENAME on SFINT:
\r\n

\r\n
\r\nSFNEWS
\r\n
\r\nSincerely,
\r\n
\r\nSFPAGENAME team
\r\n
\r\n
\r\nEmail has been sent to SFMAIL
\r\nTo unsubscribe click SFOUT here SFEND.
\r\nTo change/edit your profile click SFCHANGE here SFEND.

'),('BeforeNews','xx SFINT xx SFMAIL xx

aaaasadadsasfff'),('underline','0'),('showsender','1'),('BeforeName','xHi,'),('m2w2all','0'),('AlertFrom','info@1ka.si'),('AlertSubject','News from SFPAGENAME'),('m2w2all','0'),('UserDataFrom','info@1ka.si'),('AlertReply','info@1ka.si'),('AlertFrom','info@1ka.si'),('AlertSubject','News from SFPAGENAME'),('AlertReply','info@1ka.si'),('UserDataReply','info@1ka.si'),('NewUserSubject',''),('ChangedUserSubject',''),('M2WNotAllowedSubject',''),('LostPasswordSubject',''),('HelloNewUser',''),('NewUserMail',''),('ChangedUserMail',''),('M2WNotAllowed',''),('LostPasswordMail',''),('PageName','1ka'),('OKNewUser',''),('OKByeUser','

Dear colleague,
\r\n
\r\non SFPAGENAME site we have included some publicly available information on your bibliography related to Web survey methodology.
\r\n
\r\nRecently we received the below-enclosed inquiry from a visitor  for more information about one of your specific bibliographic unit.
\r\n
\r\nWe are also highly interested to include more of your work on our site.
\r\n
\r\nSincerely,
\r\n
\r\nSFPAGENAME team
\r\n
\r\n*****************************************************************************

'),('ByeEmail','

Spoštovani,

Uspešno ste se odjavili iz spletnega mesta www.1ka.si.

Veseli nas, da ste preizkusili orodje 1ka.

SFPAGENAME ekipa

'),('ByeWarning',''),('OKEdited',''),('CommonError',''),('ByeEmailSubject','Uspe¹na odjava'),('LoginError',''),('showsearch','5'),('showlogin','1'),('keywordssi','spletne ankete, spletno anketiranje, internetne ankete, sloven¹èina, slovenski jezik, software, softver, programska oprema, orodje za spletne ankete, internetno anketiranje, online vpra¹alniki'),('keywordsde',''),('author','CMI, FDV'),('abstract','1KA je orodje za spletne ankete'),('SurveyDostop','3'),('FinCurrency','SIT'),('publisher',''),('copyright','CMI, FDV'),('audience','splo¹na populacija'),('pagetopic','spletne aplikacije'),('revisit','7'),('a.hover','11'),('a.active','3'),('a.visited','4'),('a.memberhover','11'),('a.membervisited','9'),('a.memberactive','8'),('a.userhover','11'),('a.uservisited','7'),('a.useractive','5'),('a.adminhover','11'),('a.adminvisited','10'),('a.adminactive','11'),('a.adminbhover','11'),('a.adminbvisited','10'),('a.adminbactive','11'),('a.bold','0'),('a.underline',''),('a.italic','0'),('a.hoverbold',''),('a.hoverunderline','1'),('a.hoveritalic',''),('a.visitedbold',''),('a.visitedunderline',''),('a.visiteditalic',''),('a.activebold',''),('a.activeunderline','1'),('a.activeitalic',''),('a.userbold',''),('a.userunderline',''),('a.useritalic',''),('a.userhoverbold',''),('a.userhoverunderline','1'),('a.userhoveritalic',''),('a.uservisitedbold',''),('a.uservisitedunderline',''),('a.uservisiteditalic',''),('a.useractivebold',''),('a.useractiveunderline','1'),('a.useractiveitalic',''),('a.memberbold',''),('a.memberunderline',''),('a.memberitalic',''),('a.memberhoverbold',''),('a.memberhoverunderline','1'),('a.memberhoveritalic',''),('a.membervisitedbold',''),('a.membervisitedunderline',''),('a.membervisiteditalic',''),('a.memberactivebold',''),('a.memberactiveunderline','1'),('a.memberactiveitalic',''),('a.adminbold',''),('a.adminunderline',''),('a.adminitalic',''),('a.adminhoverbold',''),('a.adminhoverunderline','1'),('a.adminhoveritalic',''),('a.adminvisitedbold',''),('a.adminvisitedunderline',''),('a.adminvisiteditalic',''),('a.adminactivebold',''),('a.adminactiveunderline','1'),('a.adminactiveitalic',''),('a.adminbbold',''),('a.adminbunderline',''),('a.adminbitalic',''),('a.adminbhoverbold',''),('a.adminbhoverunderline','1'),('a.adminbhoveritalic',''),('a.adminbvisitedbold',''),('a.adminbvisitedunderline',''),('a.adminbvisiteditalic',''),('a.adminbactivebold',''),('a.adminbactiveunderline','1'),('a.adminbactiveitalic',''),('forum_alert','2010-09-30 09:58:24'),('thread_alert','2010-09-30 09:58:24'),('ShowRubrikeAdmin','0'),('ForumSubject','New forum post on SFPAGENAME'),('ForumAlert','

Dear SFNAME,

\r\n

on SFPAGENAME there is a new post in the thread you are subscribed to.

\r\n

SFNEWS

\r\n

Sincerely,

\r\n

SFPAGENAME

\r\n
\r\n

Email has been sent to SFMAIL.
\r\nTo unsubscribe click SFOUT here SFEND.
\r\nTo change/edit your profile click SFCHANGE here SFEND.

'),('Skin','1ka-new'),('adminskin','Default'),('SendToAuthorExplain',''),('NoviceChars','100'),('ShowSearchMenu','0'),('ShowTracking','0'),('UploadDummy','1'),('FullPageView','0'),('AuthorCC','

Dear visitor,
\r\n
\r\nThank you for your interest; your message to the author has been sent.
\r\n
\r\nMessage you sent is attached at the bottom of email.

'),('RegName','1'),('RegPass','1'),('RegAlert','0'),('RegAlertOptions','0'),('RegEmailOptions','0'),('ToBasicUser','

Dear SFPAGENAME user,
\r\n
\r\nanother user from our website sent you notification.
\r\nEmail of that user and message follows:

'),('AdminRememberIP','193.2.85.52'),('ForumMenus','0'),('RegEditorOn','0'),('RegEditorName','Details'),('RegTextBoxOn','0'),('RegTextBoxName','Affiliation'),('NoNUExplain','

This web page is closed-type so you can not register without invitation

'),('BadWords','fuck'),('BadWords','kurac'),('BadWords','pizda'),('BadWords','pussy'),('BadWordsReplacement','***'),('DefaultRootSearch','0'),('RegAddArticle','-1'),('SendToAuthorSpeech','

By filling out this form, you will send e-mail to the requested author.

'),('RegAvatarEnable','1'),('NewChars','100'),('SendToForumSpeech','

By filling out this form, you will send e-mail to the requested author.

'),('ArticleDateType','0'),('AdminNoBotherIP','0'),('RelatedDropdown','http://www.sisplet.org,Sisplet CMS'),('RelatedDropdownActive','0'),('ForumAccessMode','1'),('MenuTriangles','0'),('BreadCrumbs','0'),('BlindEmail','info@1ka.si'),('ShowOnline','1'),('ForumColumns','0'),('TimeLink','0'),('CreateForum','0'),('CreateNavigation','-1'),('NoNUExplain','

This web page is closed-type so you can not register without invitation

'),('BadWords','fuck'),('BadWords','kurac'),('BadWords','pizda'),('BadWords','pussy'),('BadWordsReplacement','***'),('DefaultRootSearch','0'),('ProfileMenus','0'),('NewsColumns','6040'),('CookieLife','43200'),('ShowCountMenu','1'),('ShowCountRub','1'),('ForumLongAuthor','1'),('ProfileLink','0'),('ForumTopTxt','1'),('forum_display_column','1'),('forum_display_settings',''),('AdminContent','0'),('RegPassDefault','0'),('gridopt','1'),('BreadCrumbsNoFirst','0'),('BreadCrumbsNoLast','0'),('BreadCrumbsNoClick','0'),('ForumHourDisplay','1'),('ForumMarkDisplay','0'),('ForumEditPost','0'),('MembersFastEdit','0'),('Financial','0'),('TimeTables','0'),('SurveyCookie','-1'),('CalendarSubject','New forum post on SFPAGENAME'),('CalendarAlert',''),('ip_yes',''),('ip_no',''),('favicon',''),('preslikavaKAM','2'),('preslikavaOSTALI','0'),('zavzamemenu','1'),('AfterReg','http://www.1ka.si/admin/survey/index.php'),('AfterReg','http://www.1ka.si/admin/survey/index.php'),('srv_sistemske','5'),('SurveyMetaOnly','0'),('hour_insertproject','1'),('register_auto_t','0'),('hour_insertproject','1'),('register_auto_t','0'),('SurveyMetaOnly','0'),('ShowBookmarks','1'),('DefaultShowPrintWordPdf','1'),('DefaultShowDigg','1'),('DefaultShowPrintWordPdf','1'),('DefaultShowDigg','1'),('RegShowInterval','1'),('RegShowGroups','1'),('RegShowColumns','1'),('RegShowN','1'),('RegShowInterval','1'),('RegShowGroups','1'),('RegShowColumns','1'),('RegShowN','1'),('WhenSendCustomMail','never / nikoli'),('SurveyExport','3'),('utrack_acc','0'),('RegEmailActivate','1'),('analitics','<script type="text/javascript">\r\nvar gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");\r\ndocument.write(unescape("%3Cscript src=\'" + gaJsHost + "google-analytics.com/ga.js\' type=\'text/javascript\'%3E%3C/script%3E"));\r\n</script>\r\n<script type="text/javascript">\r\ntry {\r\nvar pageTracker = _gat._getTracker("UA-12079719-1");\r\npageTracker._trackPageview();\r\n} catch(err) {}</script>'),('user_see_hour_views','0'),('ShortPageName',''),('SurveyForum','0'),('user_see_hour_views_meta','0'),('user_see_forum_views','0'),('ForumNewInicialke','0'),('SurveyLang_admin','1'),('SurveyLang_resp','1'),('RegCustomGroupsText',''),('RegAgreement',''),('DefaultShowLike','0'),('srv_maxDashboardChacheFiles','200'),('DefaultShowLikeAbove','0'),('RegLang','0'),('invitationTrackingStarted','2014-07-19 14:45:40'),('UnregisterEmbed',''),('drupal version','7.59'),('mobileApp_version','16.5.30'),('drupal version','7.59'),('version','18.09.17'); -/*!40000 ALTER TABLE `misc` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `oid_users` --- - -DROP TABLE IF EXISTS `oid_users`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `oid_users` ( - `uid` int(11) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `oid_users` --- - -LOCK TABLES `oid_users` WRITE; -/*!40000 ALTER TABLE `oid_users` DISABLE KEYS */; -/*!40000 ALTER TABLE `oid_users` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `post` --- - -DROP TABLE IF EXISTS `post`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `post` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `fid` int(11) NOT NULL DEFAULT '0', - `tid` int(11) NOT NULL DEFAULT '0', - `parent` int(11) NOT NULL DEFAULT '0', - `naslov` varchar(255) NOT NULL DEFAULT '', - `naslovnica` tinyint(4) NOT NULL DEFAULT '1', - `vsebina` text NOT NULL, - `ogledov` int(11) NOT NULL DEFAULT '0', - `uid` int(11) NOT NULL DEFAULT '0', - `user` varchar(40) 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 '', - PRIMARY KEY (`id`), - KEY `fid_index` (`fid`), - KEY `tid_index` (`tid`), - KEY `admin_index` (`admin`), - KEY `time2_index` (`time2`), - FULLTEXT KEY `naslov` (`naslov`), - FULLTEXT KEY `naslov_2` (`naslov`), - FULLTEXT KEY `user_2` (`user`), - FULLTEXT KEY `vsebina_2` (`vsebina`), - FULLTEXT KEY `NiceLink` (`NiceLink`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `post` --- - -LOCK TABLES `post` WRITE; -/*!40000 ALTER TABLE `post` DISABLE KEYS */; -/*!40000 ALTER TABLE `post` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `registers` --- - -DROP TABLE IF EXISTS `registers`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `registers` --- - -LOCK TABLES `registers` WRITE; -/*!40000 ALTER TABLE `registers` DISABLE KEYS */; -/*!40000 ALTER TABLE `registers` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_activity` --- - -DROP TABLE IF EXISTS `srv_activity`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_activity` ( - `sid` int(11) NOT NULL, - `starts` date NOT NULL, - `expire` date NOT NULL, - `uid` int(11) NOT NULL, - UNIQUE KEY `sid` (`sid`,`starts`,`expire`,`uid`), - CONSTRAINT `fk_srv_activity_sid` FOREIGN KEY (`sid`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_activity` --- - -LOCK TABLES `srv_activity` WRITE; -/*!40000 ALTER TABLE `srv_activity` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_activity` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_alert` --- - -DROP TABLE IF EXISTS `srv_alert`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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) DEFAULT NULL, - `finish_text` text 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 NOT NULL, - `expire_subject` varchar(250) 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 NOT NULL, - `delete_subject` varchar(250) 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 NOT NULL, - `active_subject0` varchar(250) NOT NULL, - `active_text1` text NOT NULL, - `active_subject1` varchar(250) 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, - PRIMARY KEY (`ank_id`), - KEY `finish_respondent_if` (`finish_respondent_if`), - KEY `finish_respondent_cms_if` (`finish_respondent_cms_if`), - KEY `finish_other_if` (`finish_other_if`), - CONSTRAINT `fk_srv_alert_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `srv_alert_ibfk_1` FOREIGN KEY (`finish_respondent_if`) REFERENCES `srv_if` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, - CONSTRAINT `srv_alert_ibfk_2` FOREIGN KEY (`finish_respondent_cms_if`) REFERENCES `srv_if` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, - CONSTRAINT `srv_alert_ibfk_3` FOREIGN KEY (`finish_other_if`) REFERENCES `srv_if` (`id`) ON DELETE SET NULL ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_alert` --- - -LOCK TABLES `srv_alert` WRITE; -/*!40000 ALTER TABLE `srv_alert` DISABLE KEYS */; -INSERT INTO `srv_alert` VALUES (0,0,0,0,0,'',NULL,'',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,''); -/*!40000 ALTER TABLE `srv_alert` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_alert_custom` --- - -DROP TABLE IF EXISTS `srv_alert_custom`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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, - UNIQUE KEY `ank_id` (`ank_id`,`type`,`uid`), - CONSTRAINT `srv_alert_custom_ibfk_1` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_alert_custom` --- - -LOCK TABLES `srv_alert_custom` WRITE; -/*!40000 ALTER TABLE `srv_alert_custom` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_alert_custom` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_analysis_archive` --- - -DROP TABLE IF EXISTS `srv_analysis_archive`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_analysis_archive` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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, - PRIMARY KEY (`id`,`sid`), - KEY `fk_srv_analysis_archive_sid` (`sid`), - CONSTRAINT `fk_srv_analysis_archive_sid` FOREIGN KEY (`sid`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_analysis_archive` --- - -LOCK TABLES `srv_analysis_archive` WRITE; -/*!40000 ALTER TABLE `srv_analysis_archive` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_analysis_archive` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_anketa` --- - -DROP TABLE IF EXISTS `srv_anketa`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_anketa` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `folder` int(11) NOT NULL DEFAULT '1', - `backup` int(11) NOT NULL, - `naslov` varchar(40) NOT NULL, - `akronim` varchar(100) 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 NOT NULL, - `conclusion` text NOT NULL, - `statistics` text NOT NULL, - `intro_opomba` varchar(250) NOT NULL, - `concl_opomba` varchar(250) NOT 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, - `cookie` tinyint(4) NOT NULL DEFAULT '2', - `cookie_return` tinyint(4) NOT NULL DEFAULT '0', - `return_finished` tinyint(4) NOT NULL DEFAULT '0', - `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 'Default', - `mobile_skin` varchar(100) NOT NULL DEFAULT 'Mobile', - `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', - `old_email_style` enum('0','1') NOT NULL DEFAULT '0', - `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', - PRIMARY KEY (`id`), - KEY `fk_srv_anketa_folder` (`folder`), - KEY `active` (`active`), - CONSTRAINT `fk_srv_anketa_folder` FOREIGN KEY (`folder`) REFERENCES `srv_folder` (`id`) ON UPDATE CASCADE -) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_anketa` --- - -LOCK TABLES `srv_anketa` WRITE; -/*!40000 ALTER TABLE `srv_anketa` DISABLE KEYS */; -INSERT INTO `srv_anketa` VALUES (-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',2,0,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','1','0','0','1','0','0','1','',0,'0',2,0,0,'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',2,0,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','1','0','0','1','0','0','1','',0,'0',2,0,0,'0'); -/*!40000 ALTER TABLE `srv_anketa` ENABLE KEYS */; -UNLOCK TABLES; -/*!50003 SET @saved_cs_client = @@character_set_client */ ; -/*!50003 SET @saved_cs_results = @@character_set_results */ ; -/*!50003 SET @saved_col_connection = @@collation_connection */ ; -/*!50003 SET character_set_client = utf8mb4 */ ; -/*!50003 SET character_set_results = utf8mb4 */ ; -/*!50003 SET collation_connection = utf8mb4_general_ci */ ; -/*!50003 SET @saved_sql_mode = @@sql_mode */ ; -/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; -DELIMITER ;; -/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `srv_anketa_zero` BEFORE DELETE ON `srv_anketa` FOR EACH ROW BEGIN -DECLARE dummy INTEGER; -IF OLD.id <= 0 THEN -SELECT Cannot_delete_IDs_smaller_than_zero INTO dummy FROM srv_anketa; -END IF; -END */;; -DELIMITER ; -/*!50003 SET sql_mode = @saved_sql_mode */ ; -/*!50003 SET character_set_client = @saved_cs_client */ ; -/*!50003 SET character_set_results = @saved_cs_results */ ; -/*!50003 SET collation_connection = @saved_col_connection */ ; - --- --- Table structure for table `srv_anketa_module` --- - -DROP TABLE IF EXISTS `srv_anketa_module`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_anketa_module` ( - `ank_id` int(11) NOT NULL, - `modul` varchar(100) NOT NULL DEFAULT '', - `vrednost` tinyint(4) NOT NULL DEFAULT '1', - PRIMARY KEY (`ank_id`,`modul`), - CONSTRAINT `fk_srv_anketa_module_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_anketa_module` --- - -LOCK TABLES `srv_anketa_module` WRITE; -/*!40000 ALTER TABLE `srv_anketa_module` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_anketa_module` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_anketa_template` --- - -DROP TABLE IF EXISTS `srv_anketa_template`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_anketa_template` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_anketa_template` --- - -LOCK TABLES `srv_anketa_template` WRITE; -/*!40000 ALTER TABLE `srv_anketa_template` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_anketa_template` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_api_auth` --- - -DROP TABLE IF EXISTS `srv_api_auth`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_api_auth` ( - `usr_id` int(11) NOT NULL DEFAULT '0', - `identifier` text NOT NULL, - `private_key` text NOT NULL, - PRIMARY KEY (`usr_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_api_auth` --- - -LOCK TABLES `srv_api_auth` WRITE; -/*!40000 ALTER TABLE `srv_api_auth` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_api_auth` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_branching` --- - -DROP TABLE IF EXISTS `srv_branching`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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, - PRIMARY KEY (`ank_id`,`parent`,`element_spr`,`element_if`), - KEY `element_spr` (`element_spr`), - KEY `element_spr_if` (`element_spr`,`element_if`), - KEY `parent` (`parent`), - KEY `element_if` (`element_if`), - CONSTRAINT `fk_srv_branching_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_branching` --- - -LOCK TABLES `srv_branching` WRITE; -/*!40000 ALTER TABLE `srv_branching` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_branching` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_calculation` --- - -DROP TABLE IF EXISTS `srv_calculation`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_calculation` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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, - PRIMARY KEY (`id`), - KEY `cnd_id` (`cnd_id`), - KEY `spr_id` (`spr_id`,`vre_id`), - KEY `fk_srv_calculation_vre_id` (`vre_id`), - CONSTRAINT `fk_srv_calculation_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_calculation_vre_id` FOREIGN KEY (`vre_id`) REFERENCES `srv_vrednost` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_calculation` --- - -LOCK TABLES `srv_calculation` WRITE; -/*!40000 ALTER TABLE `srv_calculation` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_calculation` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_call_current` --- - -DROP TABLE IF EXISTS `srv_call_current`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_call_current` ( - `usr_id` int(11) NOT NULL, - `user_id` int(10) unsigned NOT NULL, - `started_time` datetime NOT NULL, - PRIMARY KEY (`usr_id`), - KEY `user_id` (`user_id`), - KEY `started_time` (`started_time`), - CONSTRAINT `fk_srv_call_current_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_call_current` --- - -LOCK TABLES `srv_call_current` WRITE; -/*!40000 ALTER TABLE `srv_call_current` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_call_current` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_call_history` --- - -DROP TABLE IF EXISTS `srv_call_history`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_call_history` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `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, - PRIMARY KEY (`id`), - KEY `phone_id` (`usr_id`), - KEY `time` (`insert_time`), - KEY `status` (`status`), - KEY `survey_id` (`survey_id`), - KEY `user_id` (`user_id`), - CONSTRAINT `fk_srv_call_history_survey_id` FOREIGN KEY (`survey_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_call_history_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_call_history` --- - -LOCK TABLES `srv_call_history` WRITE; -/*!40000 ALTER TABLE `srv_call_history` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_call_history` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_call_schedule` --- - -DROP TABLE IF EXISTS `srv_call_schedule`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_call_schedule` ( - `usr_id` int(11) NOT NULL, - `call_time` datetime NOT NULL, - PRIMARY KEY (`usr_id`), - CONSTRAINT `fk_srv_call_schedule_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_call_schedule` --- - -LOCK TABLES `srv_call_schedule` WRITE; -/*!40000 ALTER TABLE `srv_call_schedule` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_call_schedule` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_call_setting` --- - -DROP TABLE IF EXISTS `srv_call_setting`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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', - PRIMARY KEY (`survey_id`), - CONSTRAINT `fk_srv_call_setting_survey_id` FOREIGN KEY (`survey_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_call_setting` --- - -LOCK TABLES `srv_call_setting` WRITE; -/*!40000 ALTER TABLE `srv_call_setting` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_call_setting` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_captcha` --- - -DROP TABLE IF EXISTS `srv_captcha`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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, - PRIMARY KEY (`ank_id`,`spr_id`,`usr_id`), - KEY `srv_captcha_usr_id` (`usr_id`), - KEY `srv_captcha_spr_id` (`spr_id`), - CONSTRAINT `srv_captcha_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `srv_captcha_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `srv_captcha_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_captcha` --- - -LOCK TABLES `srv_captcha` WRITE; -/*!40000 ALTER TABLE `srv_captcha` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_captcha` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_chart_skin` --- - -DROP TABLE IF EXISTS `srv_chart_skin`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_chart_skin` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `usr_id` int(11) NOT NULL DEFAULT '0', - `name` varchar(200) NOT NULL, - `colors` varchar(200) NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_chart_skin` --- - -LOCK TABLES `srv_chart_skin` WRITE; -/*!40000 ALTER TABLE `srv_chart_skin` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_chart_skin` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_chat_settings` --- - -DROP TABLE IF EXISTS `srv_chat_settings`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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', - PRIMARY KEY (`ank_id`), - CONSTRAINT `fk_srv_chat_settings_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_chat_settings` --- - -LOCK TABLES `srv_chat_settings` WRITE; -/*!40000 ALTER TABLE `srv_chat_settings` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_chat_settings` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_comment_resp` --- - -DROP TABLE IF EXISTS `srv_comment_resp`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_comment_resp` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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', - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_comment_resp` --- - -LOCK TABLES `srv_comment_resp` WRITE; -/*!40000 ALTER TABLE `srv_comment_resp` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_comment_resp` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_condition` --- - -DROP TABLE IF EXISTS `srv_condition`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_condition` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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, - PRIMARY KEY (`id`), - KEY `if_id` (`if_id`), - KEY `spr_id` (`spr_id`,`vre_id`), - KEY `fk_srv_condition_vre_id` (`vre_id`), - CONSTRAINT `fk_srv_condition_if_id` FOREIGN KEY (`if_id`) REFERENCES `srv_if` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_condition_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_condition_vre_id` FOREIGN KEY (`vre_id`) REFERENCES `srv_vrednost` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_condition` --- - -LOCK TABLES `srv_condition` WRITE; -/*!40000 ALTER TABLE `srv_condition` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_condition` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_condition_grid` --- - -DROP TABLE IF EXISTS `srv_condition_grid`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_condition_grid` ( - `cond_id` int(11) NOT NULL, - `grd_id` int(11) NOT NULL, - PRIMARY KEY (`cond_id`,`grd_id`), - CONSTRAINT `fk_srv_condition_grid_cond_id` FOREIGN KEY (`cond_id`) REFERENCES `srv_condition` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_condition_grid` --- - -LOCK TABLES `srv_condition_grid` WRITE; -/*!40000 ALTER TABLE `srv_condition_grid` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_condition_grid` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_condition_profiles` --- - -DROP TABLE IF EXISTS `srv_condition_profiles`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_condition_profiles` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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', - PRIMARY KEY (`id`), - UNIQUE KEY `sid` (`sid`,`uid`,`if_id`), - KEY `if_id` (`if_id`), - CONSTRAINT `srv_condition_profiles_ibfk_1` FOREIGN KEY (`sid`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `srv_condition_profiles_ibfk_2` FOREIGN KEY (`if_id`) REFERENCES `srv_if` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_condition_profiles` --- - -LOCK TABLES `srv_condition_profiles` WRITE; -/*!40000 ALTER TABLE `srv_condition_profiles` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_condition_profiles` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_condition_vre` --- - -DROP TABLE IF EXISTS `srv_condition_vre`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_condition_vre` ( - `cond_id` int(11) NOT NULL, - `vre_id` int(11) NOT NULL, - PRIMARY KEY (`cond_id`,`vre_id`), - KEY `fk_srv_condition_vre_vre_id` (`vre_id`), - CONSTRAINT `fk_srv_condition_vre_cond_id` FOREIGN KEY (`cond_id`) REFERENCES `srv_condition` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_condition_vre_vre_id` FOREIGN KEY (`vre_id`) REFERENCES `srv_vrednost` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_condition_vre` --- - -LOCK TABLES `srv_condition_vre` WRITE; -/*!40000 ALTER TABLE `srv_condition_vre` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_condition_vre` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_custom_report` --- - -DROP TABLE IF EXISTS `srv_custom_report`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_custom_report` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_custom_report` --- - -LOCK TABLES `srv_custom_report` WRITE; -/*!40000 ALTER TABLE `srv_custom_report` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_custom_report` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_custom_report_profiles` --- - -DROP TABLE IF EXISTS `srv_custom_report_profiles`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_custom_report_profiles` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_custom_report_profiles` --- - -LOCK TABLES `srv_custom_report_profiles` WRITE; -/*!40000 ALTER TABLE `srv_custom_report_profiles` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_custom_report_profiles` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_custom_report_share` --- - -DROP TABLE IF EXISTS `srv_custom_report_share`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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', - PRIMARY KEY (`ank_id`,`profile_id`,`author_usr_id`,`share_usr_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_custom_report_share` --- - -LOCK TABLES `srv_custom_report_share` WRITE; -/*!40000 ALTER TABLE `srv_custom_report_share` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_custom_report_share` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_checkgrid` --- - -DROP TABLE IF EXISTS `srv_data_checkgrid`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_data_checkgrid` ( - `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, - UNIQUE KEY `spr_id` (`spr_id`,`vre_id`,`usr_id`,`grd_id`,`loop_id`), - KEY `fk_srv_data_checkgrid_usr_id` (`usr_id`), - KEY `fk_srv_data_checkgrid_vre_id` (`vre_id`), - KEY `fk_srv_data_checkgrid_loop_id` (`loop_id`), - CONSTRAINT `fk_srv_data_checkgrid_loop_id` FOREIGN KEY (`loop_id`) REFERENCES `srv_loop_data` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_checkgrid_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_checkgrid_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_checkgrid_vre_id` FOREIGN KEY (`vre_id`) REFERENCES `srv_vrednost` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_checkgrid` --- - -LOCK TABLES `srv_data_checkgrid` WRITE; -/*!40000 ALTER TABLE `srv_data_checkgrid` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_checkgrid` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_checkgrid_active` --- - -DROP TABLE IF EXISTS `srv_data_checkgrid_active`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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, - UNIQUE KEY `spr_id` (`spr_id`,`vre_id`,`usr_id`,`grd_id`,`loop_id`), - KEY `fk_srv_data_checkgrid_usr_id` (`usr_id`), - KEY `fk_srv_data_checkgrid_vre_id` (`vre_id`), - KEY `fk_srv_data_checkgrid_loop_id` (`loop_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_checkgrid_active` --- - -LOCK TABLES `srv_data_checkgrid_active` WRITE; -/*!40000 ALTER TABLE `srv_data_checkgrid_active` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_checkgrid_active` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_files` --- - -DROP TABLE IF EXISTS `srv_data_files`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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, - PRIMARY KEY (`sid`), - UNIQUE KEY `sid` (`sid`), - CONSTRAINT `fk_srv_data_files_sid` FOREIGN KEY (`sid`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_files` --- - -LOCK TABLES `srv_data_files` WRITE; -/*!40000 ALTER TABLE `srv_data_files` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_files` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_glasovanje` --- - -DROP TABLE IF EXISTS `srv_data_glasovanje`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_data_glasovanje` ( - `spr_id` int(11) NOT NULL, - `usr_id` int(11) NOT NULL, - `spol` int(11) NOT NULL, - PRIMARY KEY (`spr_id`,`usr_id`), - KEY `fk_srv_data_glasovanje_usr_id` (`usr_id`), - CONSTRAINT `fk_srv_data_glasovanje_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_glasovanje_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_glasovanje` --- - -LOCK TABLES `srv_data_glasovanje` WRITE; -/*!40000 ALTER TABLE `srv_data_glasovanje` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_glasovanje` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_grid` --- - -DROP TABLE IF EXISTS `srv_data_grid`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_data_grid` ( - `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, - UNIQUE KEY `spr_id` (`spr_id`,`vre_id`,`usr_id`,`loop_id`), - KEY `vre_id` (`vre_id`,`usr_id`), - KEY `usr_id` (`usr_id`), - KEY `fk_srv_data_grid_loop_id` (`loop_id`), - CONSTRAINT `fk_srv_data_grid_loop_id` FOREIGN KEY (`loop_id`) REFERENCES `srv_loop_data` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_grid_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_grid_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_grid` --- - -LOCK TABLES `srv_data_grid` WRITE; -/*!40000 ALTER TABLE `srv_data_grid` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_grid` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_grid_active` --- - -DROP TABLE IF EXISTS `srv_data_grid_active`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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, - UNIQUE KEY `spr_id` (`spr_id`,`vre_id`,`usr_id`,`loop_id`), - KEY `vre_id` (`vre_id`,`usr_id`), - KEY `usr_id` (`usr_id`), - KEY `fk_srv_data_grid_active_loop_id` (`loop_id`), - CONSTRAINT `fk_srv_data_grid_active_loop_id` FOREIGN KEY (`loop_id`) REFERENCES `srv_loop_data` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_grid_active_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_grid_active_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_grid_active` --- - -LOCK TABLES `srv_data_grid_active` WRITE; -/*!40000 ALTER TABLE `srv_data_grid_active` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_grid_active` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_heatmap` --- - -DROP TABLE IF EXISTS `srv_data_heatmap`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_data_heatmap` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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, - `vrstni_red` int(11) DEFAULT NULL, - PRIMARY KEY (`id`), - KEY `usr_id` (`usr_id`), - KEY `loop_id` (`loop_id`), - KEY `ank_id` (`ank_id`), - KEY `spr_id` (`spr_id`), - KEY `vre_id` (`vre_id`), - CONSTRAINT `fk_srv_data_heatmap_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_heatmap_loop_id` FOREIGN KEY (`loop_id`) REFERENCES `srv_loop_data` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_heatmap_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_heatmap_vre_id` FOREIGN KEY (`vre_id`) REFERENCES `srv_vrednost` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_heatmap` --- - -LOCK TABLES `srv_data_heatmap` WRITE; -/*!40000 ALTER TABLE `srv_data_heatmap` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_heatmap` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_imena` --- - -DROP TABLE IF EXISTS `srv_data_imena`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_data_imena` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `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', - PRIMARY KEY (`id`), - KEY `fk_srv_data_imena_usr_id` (`usr_id`), - KEY `fk_srv_data_imena_spr_id` (`spr_id`), - CONSTRAINT `fk_srv_data_imena_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_imena_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_imena` --- - -LOCK TABLES `srv_data_imena` WRITE; -/*!40000 ALTER TABLE `srv_data_imena` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_imena` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_map` --- - -DROP TABLE IF EXISTS `srv_data_map`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_data_map` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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, - `vrstni_red` int(11) DEFAULT NULL, - PRIMARY KEY (`id`), - KEY `usr_id` (`usr_id`), - KEY `loop_id` (`loop_id`), - KEY `ank_id` (`ank_id`), - KEY `spr_id` (`spr_id`), - KEY `vre_id` (`vre_id`), - CONSTRAINT `fk_srv_data_map_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_map_loop_id` FOREIGN KEY (`loop_id`) REFERENCES `srv_loop_data` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_map_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_map_vre_id` FOREIGN KEY (`vre_id`) REFERENCES `srv_vrednost` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_map` --- - -LOCK TABLES `srv_data_map` WRITE; -/*!40000 ALTER TABLE `srv_data_map` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_map` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_number` --- - -DROP TABLE IF EXISTS `srv_data_number`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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, - UNIQUE KEY `spr_id` (`spr_id`,`vre_id`,`usr_id`,`loop_id`), - KEY `fk_srv_data_number_usr_id` (`usr_id`), - KEY `fk_srv_data_number_vre_id` (`vre_id`), - KEY `fk_srv_data_number_loop_id` (`loop_id`), - CONSTRAINT `fk_srv_data_number_loop_id` FOREIGN KEY (`loop_id`) REFERENCES `srv_loop_data` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_number_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_number_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_number_vre_id` FOREIGN KEY (`vre_id`) REFERENCES `srv_vrednost` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_number` --- - -LOCK TABLES `srv_data_number` WRITE; -/*!40000 ALTER TABLE `srv_data_number` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_number` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_rating` --- - -DROP TABLE IF EXISTS `srv_data_rating`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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, - UNIQUE KEY `spr_id` (`spr_id`,`vre_id`,`usr_id`,`loop_id`), - KEY `fk_srv_data_rating_usr_id` (`usr_id`), - KEY `fk_srv_data_rating_loop_id` (`loop_id`), - CONSTRAINT `fk_srv_data_rating_loop_id` FOREIGN KEY (`loop_id`) REFERENCES `srv_loop_data` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_rating_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_rating_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_rating` --- - -LOCK TABLES `srv_data_rating` WRITE; -/*!40000 ALTER TABLE `srv_data_rating` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_rating` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_text` --- - -DROP TABLE IF EXISTS `srv_data_text`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_data_text` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `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, - PRIMARY KEY (`id`), - UNIQUE KEY `spr_id` (`spr_id`,`vre_id`,`usr_id`,`loop_id`), - KEY `usr_id` (`usr_id`), - KEY `fk_srv_data_text_vre_id` (`vre_id`), - KEY `fk_srv_data_text_loop_id` (`loop_id`), - CONSTRAINT `fk_srv_data_text_loop_id` FOREIGN KEY (`loop_id`) REFERENCES `srv_loop_data` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_text_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_text_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_text` --- - -LOCK TABLES `srv_data_text` WRITE; -/*!40000 ALTER TABLE `srv_data_text` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_text` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_text_active` --- - -DROP TABLE IF EXISTS `srv_data_text_active`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_data_text_active` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `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, - PRIMARY KEY (`id`), - UNIQUE KEY `spr_id` (`spr_id`,`vre_id`,`usr_id`,`loop_id`), - KEY `usr_id` (`usr_id`), - KEY `fk_srv_data_text_vre_id` (`vre_id`), - KEY `fk_srv_data_text_loop_id` (`loop_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_text_active` --- - -LOCK TABLES `srv_data_text_active` WRITE; -/*!40000 ALTER TABLE `srv_data_text_active` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_text_active` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_textgrid` --- - -DROP TABLE IF EXISTS `srv_data_textgrid`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_data_textgrid` ( - `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, - UNIQUE KEY `spr_id` (`spr_id`,`vre_id`,`usr_id`,`grd_id`,`loop_id`), - KEY `fk_srv_data_textgrid_usr_id` (`usr_id`), - KEY `fk_srv_data_textgrid_vre_id` (`vre_id`), - KEY `fk_srv_data_textgrid_loop_id` (`loop_id`), - CONSTRAINT `fk_srv_data_textgrid_loop_id` FOREIGN KEY (`loop_id`) REFERENCES `srv_loop_data` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_textgrid_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_textgrid_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_textgrid_vre_id` FOREIGN KEY (`vre_id`) REFERENCES `srv_vrednost` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_textgrid` --- - -LOCK TABLES `srv_data_textgrid` WRITE; -/*!40000 ALTER TABLE `srv_data_textgrid` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_textgrid` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_textgrid_active` --- - -DROP TABLE IF EXISTS `srv_data_textgrid_active`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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, - UNIQUE KEY `spr_id` (`spr_id`,`vre_id`,`usr_id`,`grd_id`,`loop_id`), - KEY `fk_srv_data_textgrid_usr_id` (`usr_id`), - KEY `fk_srv_data_textgrid_vre_id` (`vre_id`), - KEY `fk_srv_data_textgrid_loop_id` (`loop_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_textgrid_active` --- - -LOCK TABLES `srv_data_textgrid_active` WRITE; -/*!40000 ALTER TABLE `srv_data_textgrid_active` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_textgrid_active` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_upload` --- - -DROP TABLE IF EXISTS `srv_data_upload`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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, - KEY `srv_data_upload_ank_id` (`ank_id`), - KEY `srv_data_upload_usr_id` (`usr_id`), - CONSTRAINT `srv_data_upload_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `srv_data_upload_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_upload` --- - -LOCK TABLES `srv_data_upload` WRITE; -/*!40000 ALTER TABLE `srv_data_upload` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_upload` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_vrednost` --- - -DROP TABLE IF EXISTS `srv_data_vrednost`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_data_vrednost` ( - `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, - UNIQUE KEY `spr_id_2` (`spr_id`,`vre_id`,`usr_id`,`loop_id`), - KEY `spr_id` (`spr_id`,`usr_id`), - KEY `vre_usr` (`vre_id`,`usr_id`), - KEY `usr_id` (`usr_id`), - KEY `fk_srv_data_vrednost_loop_id` (`loop_id`), - CONSTRAINT `fk_srv_data_vrednost_loop_id` FOREIGN KEY (`loop_id`) REFERENCES `srv_loop_data` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_vrednost_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_vrednost_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_vrednost_vre_id` FOREIGN KEY (`vre_id`) REFERENCES `srv_vrednost` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_vrednost` --- - -LOCK TABLES `srv_data_vrednost` WRITE; -/*!40000 ALTER TABLE `srv_data_vrednost` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_vrednost` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_vrednost_active` --- - -DROP TABLE IF EXISTS `srv_data_vrednost_active`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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, - UNIQUE KEY `spr_id_2` (`spr_id`,`vre_id`,`usr_id`,`loop_id`), - KEY `spr_id` (`spr_id`,`usr_id`), - KEY `vre_usr` (`vre_id`,`usr_id`), - KEY `usr_id` (`usr_id`), - KEY `fk_srv_data_vrednost_active_loop_id` (`loop_id`), - CONSTRAINT `fk_srv_data_vrednost_active_loop_id` FOREIGN KEY (`loop_id`) REFERENCES `srv_loop_data` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_vrednost_active_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_vrednost_active_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_vrednost_active_vre_id` FOREIGN KEY (`vre_id`) REFERENCES `srv_vrednost` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_vrednost_active` --- - -LOCK TABLES `srv_data_vrednost_active` WRITE; -/*!40000 ALTER TABLE `srv_data_vrednost_active` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_vrednost_active` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_data_vrednost_cond` --- - -DROP TABLE IF EXISTS `srv_data_vrednost_cond`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_data_vrednost_cond` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `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, - PRIMARY KEY (`id`), - UNIQUE KEY `spr_id` (`spr_id`,`vre_id`,`usr_id`,`loop_id`), - KEY `usr_id` (`usr_id`), - KEY `fk_srv_data_vrednost_cond_id` (`vre_id`), - KEY `fk_srv_data_vrednost_cond_loop_id` (`loop_id`), - CONSTRAINT `fk_srv_data_vrednost_cond_loop_id` FOREIGN KEY (`loop_id`) REFERENCES `srv_loop_data` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_vrednost_cond_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_data_vrednost_cond_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_data_vrednost_cond` --- - -LOCK TABLES `srv_data_vrednost_cond` WRITE; -/*!40000 ALTER TABLE `srv_data_vrednost_cond` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_data_vrednost_cond` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_datasetting_profile` --- - -DROP TABLE IF EXISTS `srv_datasetting_profile`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_datasetting_profile` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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', - PRIMARY KEY (`id`,`uid`), - UNIQUE KEY `id` (`id`,`uid`,`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_datasetting_profile` --- - -LOCK TABLES `srv_datasetting_profile` WRITE; -/*!40000 ALTER TABLE `srv_datasetting_profile` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_datasetting_profile` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_dostop` --- - -DROP TABLE IF EXISTS `srv_dostop`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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', - PRIMARY KEY (`ank_id`,`uid`), - KEY `alert_complete_if` (`alert_complete_if`), - CONSTRAINT `fk_srv_dostop_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `srv_dostop_ibfk_1` FOREIGN KEY (`alert_complete_if`) REFERENCES `srv_if` (`id`) ON DELETE SET NULL ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_dostop` --- - -LOCK TABLES `srv_dostop` WRITE; -/*!40000 ALTER TABLE `srv_dostop` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_dostop` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_dostop_language` --- - -DROP TABLE IF EXISTS `srv_dostop_language`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_dostop_language` ( - `ank_id` int(11) NOT NULL, - `uid` int(11) NOT NULL, - `lang_id` int(11) NOT NULL, - PRIMARY KEY (`ank_id`,`uid`,`lang_id`), - KEY `fk_srv_dostop_language_ank_id_lang_id` (`ank_id`,`lang_id`), - CONSTRAINT `fk_srv_dostop_language_ank_id_lang_id` FOREIGN KEY (`ank_id`, `lang_id`) REFERENCES `srv_language` (`ank_id`, `lang_id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_dostop_language_ank_id_uid` FOREIGN KEY (`ank_id`, `uid`) REFERENCES `srv_dostop` (`ank_id`, `uid`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_dostop_language` --- - -LOCK TABLES `srv_dostop_language` WRITE; -/*!40000 ALTER TABLE `srv_dostop_language` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_dostop_language` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_dostop_manage` --- - -DROP TABLE IF EXISTS `srv_dostop_manage`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_dostop_manage` ( - `manager` int(11) NOT NULL, - `user` int(11) NOT NULL, - PRIMARY KEY (`manager`,`user`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_dostop_manage` --- - -LOCK TABLES `srv_dostop_manage` WRITE; -/*!40000 ALTER TABLE `srv_dostop_manage` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_dostop_manage` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_evoli_landingpage_access` --- - -DROP TABLE IF EXISTS `srv_evoli_landingpage_access`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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', - PRIMARY KEY (`ank_id`,`email`,`pass`), - CONSTRAINT `fk_srv_evoli_landingPage_access_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_evoli_landingpage_access` --- - -LOCK TABLES `srv_evoli_landingpage_access` WRITE; -/*!40000 ALTER TABLE `srv_evoli_landingpage_access` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_evoli_landingpage_access` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_evoli_teammeter` --- - -DROP TABLE IF EXISTS `srv_evoli_teammeter`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_evoli_teammeter` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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', - PRIMARY KEY (`id`), - KEY `fk_srv_evoli_teammeter_ank_id` (`ank_id`), - KEY `fk_srv_evoli_teammeter_skupina_id` (`skupina_id`), - CONSTRAINT `fk_srv_evoli_teammeter_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_evoli_teammeter_skupina_id` FOREIGN KEY (`skupina_id`) REFERENCES `srv_vrednost` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_evoli_teammeter` --- - -LOCK TABLES `srv_evoli_teammeter` WRITE; -/*!40000 ALTER TABLE `srv_evoli_teammeter` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_evoli_teammeter` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_evoli_teammeter_data_department` --- - -DROP TABLE IF EXISTS `srv_evoli_teammeter_data_department`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_evoli_teammeter_data_department` ( - `department_id` int(11) NOT NULL DEFAULT '0', - `usr_id` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`department_id`,`usr_id`), - KEY `fk_srv_evoli_data_department_usr_id` (`usr_id`), - CONSTRAINT `fk_srv_evoli_data_department_department_id` FOREIGN KEY (`department_id`) REFERENCES `srv_evoli_teammeter_department` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_evoli_data_department_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `srv_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_evoli_teammeter_data_department` --- - -LOCK TABLES `srv_evoli_teammeter_data_department` WRITE; -/*!40000 ALTER TABLE `srv_evoli_teammeter_data_department` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_evoli_teammeter_data_department` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_evoli_teammeter_department` --- - -DROP TABLE IF EXISTS `srv_evoli_teammeter_department`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_evoli_teammeter_department` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `tm_id` int(11) NOT NULL DEFAULT '0', - `department` varchar(255) DEFAULT '', - PRIMARY KEY (`id`), - KEY `fk_srv_evoli_teammeter_department_tm_id` (`tm_id`), - CONSTRAINT `fk_srv_evoli_teammeter_department_tm_id` FOREIGN KEY (`tm_id`) REFERENCES `srv_evoli_teammeter` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_evoli_teammeter_department` --- - -LOCK TABLES `srv_evoli_teammeter_department` WRITE; -/*!40000 ALTER TABLE `srv_evoli_teammeter_department` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_evoli_teammeter_department` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_fieldwork` --- - -DROP TABLE IF EXISTS `srv_fieldwork`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_fieldwork` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `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', - PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_fieldwork` --- - -LOCK TABLES `srv_fieldwork` WRITE; -/*!40000 ALTER TABLE `srv_fieldwork` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_fieldwork` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_folder` --- - -DROP TABLE IF EXISTS `srv_folder`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_folder` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `naslov` varchar(50) NOT NULL, - `parent` int(11) NOT NULL, - `creator_uid` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`id`), - KEY `parent` (`parent`) -) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_folder` --- - -LOCK TABLES `srv_folder` WRITE; -/*!40000 ALTER TABLE `srv_folder` DISABLE KEYS */; -INSERT INTO `srv_folder` VALUES (1,'Moje 1KA ankete',0,0); -/*!40000 ALTER TABLE `srv_folder` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_gdpr_anketa` --- - -DROP TABLE IF EXISTS `srv_gdpr_anketa`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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', - `about` text NOT NULL, - PRIMARY KEY (`ank_id`), - CONSTRAINT `fk_srv_gdpr_anketa_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_gdpr_anketa` --- - -LOCK TABLES `srv_gdpr_anketa` WRITE; -/*!40000 ALTER TABLE `srv_gdpr_anketa` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_gdpr_anketa` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_gdpr_requests` --- - -DROP TABLE IF EXISTS `srv_gdpr_requests`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_gdpr_requests` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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, - PRIMARY KEY (`id`), - KEY `fk_srv_gdpr_requests_usr_id` (`usr_id`), - KEY `fk_srv_gdpr_requests_ank_id` (`ank_id`), - CONSTRAINT `fk_srv_gdpr_requests_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE, - CONSTRAINT `fk_srv_gdpr_requests_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `users` (`id`) ON DELETE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_gdpr_requests` --- - -LOCK TABLES `srv_gdpr_requests` WRITE; -/*!40000 ALTER TABLE `srv_gdpr_requests` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_gdpr_requests` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_gdpr_user` --- - -DROP TABLE IF EXISTS `srv_gdpr_user`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_gdpr_user` ( - `usr_id` int(11) NOT NULL, - `type` enum('0','1') NOT NULL DEFAULT '0', - `organization` 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 '', - PRIMARY KEY (`usr_id`), - CONSTRAINT `fk_srv_gdpr_user_usr_id` FOREIGN KEY (`usr_id`) REFERENCES `users` (`id`) ON DELETE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_gdpr_user` --- - -LOCK TABLES `srv_gdpr_user` WRITE; -/*!40000 ALTER TABLE `srv_gdpr_user` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_gdpr_user` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_glasovanje` --- - -DROP TABLE IF EXISTS `srv_glasovanje`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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', - PRIMARY KEY (`ank_id`,`spr_id`), - KEY `fk_srv_glasovanje_spr_id` (`spr_id`), - CONSTRAINT `fk_srv_glasovanje_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `fk_srv_glasovanje_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_glasovanje` --- - -LOCK TABLES `srv_glasovanje` WRITE; -/*!40000 ALTER TABLE `srv_glasovanje` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_glasovanje` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_grid` --- - -DROP TABLE IF EXISTS `srv_grid`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_grid` ( - `id` int(11) NOT NULL, - `spr_id` int(11) NOT NULL, - `naslov` varchar(250) NOT 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 '', - PRIMARY KEY (`id`,`spr_id`), - KEY `spr_id` (`spr_id`), - CONSTRAINT `fk_srv_grid_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_grid` --- - -LOCK TABLES `srv_grid` WRITE; -/*!40000 ALTER TABLE `srv_grid` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_grid` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_grid_multiple` --- - -DROP TABLE IF EXISTS `srv_grid_multiple`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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, - KEY `srv_grid_multiple_ank_id` (`ank_id`), - KEY `srv_grid_multiple_parent` (`parent`), - KEY `srv_grid_multiple_spr_id` (`spr_id`), - CONSTRAINT `srv_grid_multiple_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `srv_grid_multiple_parent` FOREIGN KEY (`parent`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `srv_grid_multiple_spr_id` FOREIGN KEY (`spr_id`) REFERENCES `srv_spremenljivka` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_grid_multiple` --- - -LOCK TABLES `srv_grid_multiple` WRITE; -/*!40000 ALTER TABLE `srv_grid_multiple` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_grid_multiple` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_grupa` --- - -DROP TABLE IF EXISTS `srv_grupa`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_grupa` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `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, - PRIMARY KEY (`id`), - KEY `ank_id` (`ank_id`), - KEY `ank_id_2` (`ank_id`,`vrstni_red`), - CONSTRAINT `fk_srv_grupa_ank_id` FOREIGN KEY (`ank_id`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_grupa` --- - -LOCK TABLES `srv_grupa` WRITE; -/*!40000 ALTER TABLE `srv_grupa` DISABLE KEYS */; -INSERT INTO `srv_grupa` VALUES (-2,0,'system',0,'2018-03-05 09:50:10'),(-1,0,'system',0,'2018-03-05 09:50:10'),(0,0,'system',0,'2018-03-05 09:50:10'); -/*!40000 ALTER TABLE `srv_grupa` ENABLE KEYS */; -UNLOCK TABLES; -/*!50003 SET @saved_cs_client = @@character_set_client */ ; -/*!50003 SET @saved_cs_results = @@character_set_results */ ; -/*!50003 SET @saved_col_connection = @@collation_connection */ ; -/*!50003 SET character_set_client = utf8mb4 */ ; -/*!50003 SET character_set_results = utf8mb4 */ ; -/*!50003 SET collation_connection = utf8mb4_general_ci */ ; -/*!50003 SET @saved_sql_mode = @@sql_mode */ ; -/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; -DELIMITER ;; -/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `srv_grupa_zero` BEFORE DELETE ON `srv_grupa` FOR EACH ROW BEGIN -DECLARE dummy INTEGER; -IF OLD.id <= 0 THEN -SELECT Cannot_delete_IDs_smaller_than_zero INTO dummy FROM srv_grupa; -END IF; -END */;; -DELIMITER ; -/*!50003 SET sql_mode = @saved_sql_mode */ ; -/*!50003 SET character_set_client = @saved_cs_client */ ; -/*!50003 SET character_set_results = @saved_cs_results */ ; -/*!50003 SET collation_connection = @saved_col_connection */ ; - --- --- Table structure for table `srv_hash_url` --- - -DROP TABLE IF EXISTS `srv_hash_url`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -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, - PRIMARY KEY (`hash`), - UNIQUE KEY `hash` (`hash`,`anketa`), - KEY `FK_srv_hash_url` (`anketa`), - CONSTRAINT `FK_srv_hash_url` FOREIGN KEY (`anketa`) REFERENCES `srv_anketa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_hash_url` --- - -LOCK TABLES `srv_hash_url` WRITE; -/*!40000 ALTER TABLE `srv_hash_url` DISABLE KEYS */; -/*!40000 ALTER TABLE `srv_hash_url` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `srv_help` --- - -DROP TABLE IF EXISTS `srv_help`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `srv_help` ( - `what` varchar(50) NOT NULL, - `lang` tinyint(4) NOT NULL DEFAULT '1', - `help` text NOT NULL, - PRIMARY KEY (`what`,`lang`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `srv_help` --- - -LOCK TABLES `srv_help` WRITE; -/*!40000 ALTER TABLE `srv_help` DISABLE KEYS */; -INSERT INTO `srv_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?\n\nPri tem je treba upoÅ¡tevati:\n\n * VpraÅ¡anje Q2, ki vključi odgovor, mora biti na naslednji strani,\n * Ime spremenljivke, ki se prenaÅ¡a (Q1) je treba spremeniti, ker je lahko predmet avtomatskega preÅ¡tevilčenja, npr. spremenimo »Q1« v »SADJE«'),('displaychart_settings',1,'Če želite urediti manjkajoče vrednosti ali za grafe prilagoditi text vprašanja, potem to spremenite v naprednih nastavitvah.'),('displaydata_checkboxes',1,''),('displaydata_data',1,'Kadar je opcija izbrana, se v tabeli prikažejo podatki respondentov'),('displaydata_meta',1,'Priakže meta podatke uporabnika: datum vnosa, datum popravljanja, čase po straneh, IP, JavaScript, podatke brskalnika'),('displaydata_pdftype',1,'Dolg izpis pomeni izpis oblike kakršne je vprašalnik, krajši izpis pa izpiše vprašalnik z rezultati v skrajšani obliki.'),('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'),('displaydata_system',1,'Prikaže sistemske podatke respondenta: ime, priimek, email....'),('dodaj_searchbox',1,'V zemljevid vključi tudi iskalno okno, preko katerega lahko respondent tudi opisno poišče lokacijo na zemljevidu'),('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'),('edit_variable',1,'Urejanje variable'),('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.'),('fieldwork_devices',1,'blablabla'),('fieldwork_devices',2,'blablabla'),('individual_invitation',1,'Individualiziran URL'),('inv_recipiens_from_system',1,'Prejemniki bodo dodani iz obstoječih podatkov v bazi, pri čemer mora vpraÅ¡alnik vsebovati sistemsko spremenljivko email'),('marker_podvprasanje',1,'V oblaček markerja dodaj podvprašanje'),('naslov_podvprasanja_map',1,'Besedilo podvprašanja v oblačku markerja'),('spremenljivka_reminder',1,'V primeru, da respondent ni odgovoril na predvideno vpraÅ¡anje, imamo tri možnosti:\n'),('spremenljivka_sistem',1,'S klikanjem na nastavitve v lahko zbiramo med dvema vrstama integracije vpraÅ¡anja v anketo:\n\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.'),('spremenljivka_visible',1,'S klikanjem na nastavitve vidnosti lahko zbiramo med dvema vrstama integrcije vpraÅ¡anja v anketo:\n