/*
Navicat MySQL Data Transfer

Source Server         : NET-NAS
Source Server Version : 50130
Source Host           : 192.168.213.25:3306
Source Database       : radvre

Target Server Type    : MYSQL
Target Server Version : 50130
File Encoding         : 65001

Date: 2023-10-03 21:27:49
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `audit`
-- ----------------------------
DROP TABLE IF EXISTS `audit`;
CREATE TABLE `audit` (
  `modified_by_ip` varchar(39) NOT NULL DEFAULT '',
  `modified_by_user` varchar(50) NOT NULL DEFAULT '',
  `modified_when` bigint(14) NOT NULL,
  `modified_from` bigint(14) NOT NULL,
  `modified_to` bigint(14) NOT NULL,
  `modified_why` varchar(250) NOT NULL DEFAULT '',
  `user_modified` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`modified_when`),
  UNIQUE KEY `modified_when` (`modified_when`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of audit
-- ----------------------------

-- ----------------------------
-- Table structure for `dbversion`
-- ----------------------------
DROP TABLE IF EXISTS `dbversion`;
CREATE TABLE `dbversion` (
  `dbversion` decimal(5,1) NOT NULL DEFAULT '0.0',
  PRIMARY KEY (`dbversion`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dbversion
-- ----------------------------
INSERT INTO `dbversion` VALUES ('1.4');

-- ----------------------------
-- Table structure for `employees`
-- ----------------------------
DROP TABLE IF EXISTS `employees`;
CREATE TABLE `employees` (
  `empfullname` varchar(50) NOT NULL DEFAULT '',
  `tstamp` bigint(14) DEFAULT NULL,
  `employee_passwd` varchar(25) NOT NULL DEFAULT '',
  `displayname` varchar(50) NOT NULL DEFAULT '',
  `rfid` varchar(16) DEFAULT NULL,
  `email` varchar(75) NOT NULL DEFAULT '',
  `groups` varchar(50) NOT NULL DEFAULT '',
  `office` varchar(50) NOT NULL DEFAULT '',
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `reports` tinyint(1) NOT NULL DEFAULT '0',
  `time_admin` tinyint(1) NOT NULL DEFAULT '0',
  `disabled` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`empfullname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of employees
-- ----------------------------
INSERT INTO `employees` VALUES ('admin', null, 'xy.RY2HT1QTc2', 'administrator', '012345678', 'mvkukic@gmail.com', '', '', '1', '1', '1', '0');
INSERT INTO `employees` VALUES ('Misko Kukic', '1695219291', 'xyKdVmE76cVrA', 'Misko', '123456789', 'mvkukic@gmail.com', 'Radnik', 'Servis', '1', '1', '1', '0');
INSERT INTO `employees` VALUES ('Sinisa Randjo', '1695295495', 'xyUgpohjcQlSk', 'Sinisa', '234567890', 'rasin@cacak.net', 'Radnik', 'Servis', '0', '0', '0', '0');
INSERT INTO `employees` VALUES ('Vlade Kleut', '1695217923', 'xyUgpohjcQlSk', 'Vlade', '345678901', 'kleut@cacak.net', 'Radnik', 'Servis', '0', '0', '0', '0');
INSERT INTO `employees` VALUES ('Dusko Petrovic', '1695212059', 'xyqs.1MiduVDo', 'Dusko', '456789012', 'dusko@cacak.net', 'Radnik', 'Servis', '0', '1', '1', '0');

-- ----------------------------
-- Table structure for `employees_copy`
-- ----------------------------
DROP TABLE IF EXISTS `employees_copy`;
CREATE TABLE `employees_copy` (
  `empfullname` varchar(50) NOT NULL DEFAULT '',
  `tstamp` bigint(14) DEFAULT NULL,
  `employee_passwd` varchar(25) NOT NULL DEFAULT '',
  `displayname` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(75) NOT NULL DEFAULT '',
  `groups` varchar(50) NOT NULL DEFAULT '',
  `office` varchar(50) NOT NULL DEFAULT '',
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `reports` tinyint(1) NOT NULL DEFAULT '0',
  `time_admin` tinyint(1) NOT NULL DEFAULT '0',
  `disabled` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`empfullname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of employees_copy
-- ----------------------------
INSERT INTO `employees_copy` VALUES ('admin', null, 'xy.RY2HT1QTc2', 'administrator', '', '', '', '1', '1', '1', '0');
INSERT INTO `employees_copy` VALUES ('Misko Kukic', '1694521741', 'xyKdVmE76cVrA', 'Misko', 'mvkukic@gmail.com', 'Radnik', 'Servis', '1', '1', '1', '0');
INSERT INTO `employees_copy` VALUES ('Sinisa Randjo', '1694515604', 'xyUgpohjcQlSk', 'Sinisa', 'rasin@cacak.net', 'Radnik', 'Servis', '0', '0', '0', '0');
INSERT INTO `employees_copy` VALUES ('Vlade Kleut', '1694515970', 'xyUgpohjcQlSk', 'Vlade', '', 'Radnik', 'Servis', '0', '0', '0', '0');

-- ----------------------------
-- Table structure for `groups`
-- ----------------------------
DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
  `groupname` varchar(50) NOT NULL DEFAULT '',
  `groupid` int(10) NOT NULL AUTO_INCREMENT,
  `officeid` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`groupid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of groups
-- ----------------------------
INSERT INTO `groups` VALUES ('Radnik', '1', '1');

-- ----------------------------
-- Table structure for `groups_copy`
-- ----------------------------
DROP TABLE IF EXISTS `groups_copy`;
CREATE TABLE `groups_copy` (
  `groupname` varchar(50) NOT NULL DEFAULT '',
  `groupid` int(10) NOT NULL AUTO_INCREMENT,
  `officeid` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`groupid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of groups_copy
-- ----------------------------
INSERT INTO `groups_copy` VALUES ('Radnik', '1', '1');

-- ----------------------------
-- Table structure for `info`
-- ----------------------------
DROP TABLE IF EXISTS `info`;
CREATE TABLE `info` (
  `fullname` varchar(50) NOT NULL DEFAULT '',
  `in_out` varchar(50) NOT NULL DEFAULT '',
  `timestamp` bigint(14) DEFAULT NULL,
  `notes` varchar(250) DEFAULT NULL,
  `ipaddress` varchar(39) NOT NULL DEFAULT '',
  KEY `fullname` (`fullname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of info
-- ----------------------------
INSERT INTO `info` VALUES ('Misko Kukic', 'in', '1694512745', 'dolazak', '192.168.213.36');
INSERT INTO `info` VALUES ('Sinisa Randjo', 'in', '1694512814', 'dorucak', '192.168.213.36');
INSERT INTO `info` VALUES ('Misko Kukic', 'in', '1695214635', 'proba-test', '192.168.213.34');
INSERT INTO `info` VALUES ('Misko Kukic', 'in', '1694515479', 'ulaz', '192.168.213.36');
INSERT INTO `info` VALUES ('Vlade Kleut', 'in', '1694515489', 'ulaz', '192.168.213.36');
INSERT INTO `info` VALUES ('Sinisa Randjo', 'in', '1694515495', 'ulaz', '192.168.213.36');
INSERT INTO `info` VALUES ('Sinisa Randjo', 'out', '1694515604', 'ulaz', '192.168.213.36');
INSERT INTO `info` VALUES ('Vlade Kleut', 'out', '1694515970', 'ulaz', '192.168.213.36');
INSERT INTO `info` VALUES ('Misko Kukic', 'in', '1694516099', 'ulaz', '192.168.213.36');
INSERT INTO `info` VALUES ('Misko Kukic', 'in', '1694521671', 'ulaz', '192.168.213.36');
INSERT INTO `info` VALUES ('Misko Kukic', 'break', '1694521741', 'ulaz', '192.168.213.36');
INSERT INTO `info` VALUES ('Dusko Petrovic', 'break', '1695212059', 'proba', '192.168.213.34');
INSERT INTO `info` VALUES ('Misko Kukic', 'in', '1695212440', 'rad', '192.168.213.36');
INSERT INTO `info` VALUES ('Misko Kukic', 'break', '1695212446', 'proba', '192.168.213.34');
INSERT INTO `info` VALUES ('Misko Kukic', 'in', '1695214638', 'test-rad', '192.168.213.36');
INSERT INTO `info` VALUES ('Misko Kukic', 'lunch', '1695212954', 'rucak', '192.168.213.34');
INSERT INTO `info` VALUES ('Vlade Kleut', 'in', '1695213640', 'proba 1', '192.168.213.34');
INSERT INTO `info` VALUES ('Misko Kukic', 'in', '1695213670', 'proba 2', '192.168.213.34');
INSERT INTO `info` VALUES ('Misko Kukic', 'in', '1695213940', 'test-ulaz', '192.168.213.36');
INSERT INTO `info` VALUES ('Misko Kukic', 'in', '1695214807', 'proba', '192.168.213.34');
INSERT INTO `info` VALUES ('Misko Kukic', 'private', '1695215509', 'svadba', '192.168.213.34');
INSERT INTO `info` VALUES ('Misko Kukic', 'private', '1695215632', 'rodjendan', '192.168.213.36');
INSERT INTO `info` VALUES ('Misko Kukic', 'in', '1695216933', 'test', '192.168.213.36');
INSERT INTO `info` VALUES ('Misko Kukic', 'in', '1695217825', 'test', '192.168.213.36');
INSERT INTO `info` VALUES ('Misko Kukic', 'in', '1695217893', 'test', '192.168.213.36');
INSERT INTO `info` VALUES ('Vlade Kleut', 'in', '1695217923', 'test', '192.168.213.36');
INSERT INTO `info` VALUES ('Misko Kukic', 'in', '1695219291', 'test', '192.168.213.36');
INSERT INTO `info` VALUES ('Sinisa Randjo', 'in', '1695295495', 'aerd test', '192.168.213.39');

-- ----------------------------
-- Table structure for `info_copy-v1`
-- ----------------------------
DROP TABLE IF EXISTS `info_copy-v1`;
CREATE TABLE `info_copy-v1` (
  `fullname` varchar(50) NOT NULL DEFAULT '',
  `inout` varchar(50) NOT NULL DEFAULT '',
  `timestamp` bigint(14) DEFAULT NULL,
  `notes` varchar(250) DEFAULT NULL,
  `ipaddress` varchar(39) NOT NULL DEFAULT '',
  KEY `fullname` (`fullname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of info_copy-v1
-- ----------------------------
INSERT INTO `info_copy-v1` VALUES ('Misko Kukic', 'in', '1694512745', 'dolazak', '192.168.213.36');
INSERT INTO `info_copy-v1` VALUES ('Sinisa Randjo', 'in', '1694512814', 'dorucak', '192.168.213.36');
INSERT INTO `info_copy-v1` VALUES ('Misko', 'lunch', '1694512972', 'rucak', '192.168.213.36');
INSERT INTO `info_copy-v1` VALUES ('Misko', 'in', '1694514696', '', '192.168.213.36');
INSERT INTO `info_copy-v1` VALUES ('Sinisa', 'out', '1694514711', '', '192.168.213.36');
INSERT INTO `info_copy-v1` VALUES ('Kleut', 'in', '1694514821', '', '192.168.213.36');
INSERT INTO `info_copy-v1` VALUES ('Kleut', 'break', '1694514995', '', '192.168.213.36');
INSERT INTO `info_copy-v1` VALUES ('Misko Kukic', 'in', '1694515479', '', '192.168.213.36');
INSERT INTO `info_copy-v1` VALUES ('Vlade Kleut', 'in', '1694515489', '', '192.168.213.36');
INSERT INTO `info_copy-v1` VALUES ('Sinisa Randjo', 'in', '1694515495', '', '192.168.213.36');
INSERT INTO `info_copy-v1` VALUES ('Sinisa Randjo', 'out', '1694515604', '', '192.168.213.36');
INSERT INTO `info_copy-v1` VALUES ('Vlade Kleut', 'out', '1694515970', '', '192.168.213.36');
INSERT INTO `info_copy-v1` VALUES ('Misko Kukic', 'in', '1694516099', '', '192.168.213.36');
INSERT INTO `info_copy-v1` VALUES ('Misko Kukic', 'in', '1694521671', 'ulaz', '192.168.213.36');
INSERT INTO `info_copy-v1` VALUES ('Misko Kukic', 'break', '1694521741', '', '192.168.213.36');

-- ----------------------------
-- Table structure for `logdog`
-- ----------------------------
DROP TABLE IF EXISTS `logdog`;
CREATE TABLE `logdog` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `dispname` varchar(12) NOT NULL DEFAULT '',
  `in_out` varchar(12) DEFAULT '',
  `dattim` bigint(14) DEFAULT NULL,
  `notes` varchar(32) DEFAULT NULL,
  `lokc` varchar(16) DEFAULT '',
  PRIMARY KEY (`id`,`dispname`),
  KEY `fullname` (`dispname`)
) ENGINE=MyISAM AUTO_INCREMENT=385 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of logdog
-- ----------------------------
INSERT INTO `logdog` VALUES ('1', 'Misko', 'in', '1694412745', 'dolazak', 'Cacak');
INSERT INTO `logdog` VALUES ('2', 'Sinisa', 'in', '1694512814', 'dorucak', 'Cacak');
INSERT INTO `logdog` VALUES ('4', 'Misko', 'out', '1694515479', 'ulaz', 'Cacak');
INSERT INTO `logdog` VALUES ('5', 'Vlade', 'in', '1694515489', 'ulaz', 'Cacak');
INSERT INTO `logdog` VALUES ('6', 'Sinisa', 'out', '1694515495', 'ulaz', 'Cacak');
INSERT INTO `logdog` VALUES ('8', 'Vlade', 'out', '1694515970', 'ulaz', 'Cacak');
INSERT INTO `logdog` VALUES ('9', 'Misko', 'in', '1694516099', 'ulaz', 'Cacak');
INSERT INTO `logdog` VALUES ('10', 'Misko', 'out', '1694521671', 'ulaz', 'Cacak');
INSERT INTO `logdog` VALUES ('11', 'Misko', 'break', '1694521741', 'ulaz', 'Cacak');
INSERT INTO `logdog` VALUES ('12', 'Dusko', 'in', '1695212059', 'proba', 'Kraljevo');
INSERT INTO `logdog` VALUES ('13', 'Dusko', 'out', '1695212440', 'rad', 'Kraljevo');
INSERT INTO `logdog` VALUES ('44', 'Bosko_32', 'in', '1695320100', 'test', 'Zablace');
INSERT INTO `logdog` VALUES ('16', 'Misko', 'in', '1695212954', 'rucak', 'Cacak');
INSERT INTO `logdog` VALUES ('17', 'Vlade', 'in', '1695213640', 'proba 1', 'Cacak');
INSERT INTO `logdog` VALUES ('18', 'Misko', 'out', '1695213670', 'proba 2', 'Cacak');
INSERT INTO `logdog` VALUES ('19', 'Misko', 'in', '1695213940', 'test-ulaz', 'Cacak');
INSERT INTO `logdog` VALUES ('40', 'Vlade', 'out', '1695318170', 'Izlaz', 'Cacak2');
INSERT INTO `logdog` VALUES ('21', 'Misko', 'private', '1695215509', 'svadba', 'Cacak');
INSERT INTO `logdog` VALUES ('29', 'Vlade', 'out', '1695219300', 'proba', 'Misko');
INSERT INTO `logdog` VALUES ('23', 'Misko', 'out', '1695216933', 'test', 'Cacak');
INSERT INTO `logdog` VALUES ('24', 'Misko', 'in', '1695217825', 'test', 'Cacak');
INSERT INTO `logdog` VALUES ('25', 'Misko', 'out', '1695217893', 'test', 'Cacak');
INSERT INTO `logdog` VALUES ('26', 'Sinisa', 'in', '1695217923', 'test', 'Cacak');
INSERT INTO `logdog` VALUES ('27', 'Sinisa', 'out', '1695219291', 'test', 'Cacak');
INSERT INTO `logdog` VALUES ('39', 'Vlade', 'in', '1695318124', 'Ulaz', 'Cacak 2');
INSERT INTO `logdog` VALUES ('38', 'Misko', 'out', '1695317597', 'Izlaz', 'Cacak 1');
INSERT INTO `logdog` VALUES ('36', 'Misko', 'in', '1695317359', 'test', 'Cacak 1');
INSERT INTO `logdog` VALUES ('41', 'Misko', 'in', '1695320170', 'Ulaz', 'Cacak 1');
INSERT INTO `logdog` VALUES ('42', 'Misko', 'out', '1695320194', 'Izlaz', 'Cacak 1');
INSERT INTO `logdog` VALUES ('54', 'Misko', 'out', '1695674107', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('52', 'Vlade', 'in', '1695674014', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('53', 'Misko', 'in', '1695674018', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('55', 'Vlade', 'out', '1695674111', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('56', 'Misko', 'in', '1695675254', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('57', 'Vlade', 'in', '1695675272', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('58', 'Misko', 'out', '1695675333', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('59', 'Vlade', 'out', '1695675348', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('60', 'Misko', 'in', '1695675488', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('61', 'Misko', 'out', '1695675511', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('62', 'Misko', 'in', '1695675568', 'NoName', 'Beograd 1');
INSERT INTO `logdog` VALUES ('63', 'Misko', 'out', '1695675591', 'NoName', 'Beograd 1');
INSERT INTO `logdog` VALUES ('347', 'Vlade', 'out', '1696023847', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('348', 'Vlade', 'out', '1696023850', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('349', 'Vlade', 'out', '1696023859', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('350', 'Vlade', 'out', '1696023862', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('351', 'Vlade', 'out', '1696023865', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('352', 'Misko', 'out', '1696106861', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('353', 'Vlade', 'out', '1696106876', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('354', 'Vlade', 'in', '1696106890', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('355', 'Misko', 'in', '1696106902', 'NoName', 'Cacak 1');
INSERT INTO `logdog` VALUES ('356', 'Vlade', 'out', '1696107242', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('357', 'Vlade', 'out', '1696107402', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('358', 'Vlade', 'out', '1696107705', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('359', 'Misko', 'out', '1696107849', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('360', 'Misko', 'out', '1696107856', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('361', 'Vlade', 'out', '1696107868', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('362', 'Vlade', 'out', '1696108011', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('363', 'Misko', 'out', '1696109584', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('364', 'Misko', 'out', '1696109590', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('365', 'Vlade', 'out', '1696109597', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('366', 'Vlade', 'out', '1696109605', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('367', 'Vlade', 'out', '1696109616', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('368', 'Vlade', 'out', '1696147544', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('369', 'Vlade', 'out', '1696147556', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('370', 'Vlade', 'in', '1696147574', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('371', 'Vlade', 'out', '1696148043', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('372', 'Vlade', 'sluzbeno', '1696148057', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('373', 'Vlade', 'out', '1696237627', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('374', 'Vlade', 'out', '1696237637', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('375', 'Misko', 'out', '1696237648', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('376', 'Misko', 'out', '1696237834', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('377', 'Vlade', 'out', '1696237860', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('378', 'Vlade', 'in', '1696237875', 'none', 'Cacak 1');
INSERT INTO `logdog` VALUES ('379', 'Vlade', 'out', '1696238045', 'none', 'Cacak 10');
INSERT INTO `logdog` VALUES ('380', 'Vlade', 'out', '1696238220', 'none', 'Cacak 10');
INSERT INTO `logdog` VALUES ('381', 'Vlade', 'out', '1696271763', 'none', 'Cacak 10');
INSERT INTO `logdog` VALUES ('382', 'Vlade', 'out', '1696272215', 'none', 'Cacak 10');
INSERT INTO `logdog` VALUES ('383', 'Vlade', 'out', '1696272223', 'none', 'Cacak 10');
INSERT INTO `logdog` VALUES ('384', 'Vlade', 'out', '1696272236', 'none', 'Cacak 10');

-- ----------------------------
-- Table structure for `lokac`
-- ----------------------------
DROP TABLE IF EXISTS `lokac`;
CREATE TABLE `lokac` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `rfsrno` int(5) NOT NULL,
  `lokacija` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`,`rfsrno`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lokac
-- ----------------------------
INSERT INTO `lokac` VALUES ('1', '1001', 'Cacak 10');
INSERT INTO `lokac` VALUES ('2', '1002', 'Cacak 2');
INSERT INTO `lokac` VALUES ('3', '1003', 'Kraljevo 1');
INSERT INTO `lokac` VALUES ('4', '1004', 'Kraljevo 2');
INSERT INTO `lokac` VALUES ('17', '1402', 'Slatina 1');
INSERT INTO `lokac` VALUES ('18', '1515', 'Kopaonik 1');
INSERT INTO `lokac` VALUES ('19', '1516', 'Kopaonik 2');

-- ----------------------------
-- Table structure for `metars`
-- ----------------------------
DROP TABLE IF EXISTS `metars`;
CREATE TABLE `metars` (
  `metar` varchar(255) NOT NULL DEFAULT '',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `station` varchar(4) NOT NULL DEFAULT '',
  PRIMARY KEY (`station`),
  UNIQUE KEY `station` (`station`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of metars
-- ----------------------------

-- ----------------------------
-- Table structure for `offices`
-- ----------------------------
DROP TABLE IF EXISTS `offices`;
CREATE TABLE `offices` (
  `officename` varchar(50) NOT NULL DEFAULT '',
  `officeid` int(10) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`officeid`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of offices
-- ----------------------------
INSERT INTO `offices` VALUES ('Servis', '1');
INSERT INTO `offices` VALUES ('Hala', '2');
INSERT INTO `offices` VALUES ('Radionica', '3');

-- ----------------------------
-- Table structure for `offices_copy`
-- ----------------------------
DROP TABLE IF EXISTS `offices_copy`;
CREATE TABLE `offices_copy` (
  `officename` varchar(50) NOT NULL DEFAULT '',
  `officeid` int(10) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`officeid`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of offices_copy
-- ----------------------------
INSERT INTO `offices_copy` VALUES ('Servis', '1');
INSERT INTO `offices_copy` VALUES ('Hala', '2');
INSERT INTO `offices_copy` VALUES ('Radionica', '3');

-- ----------------------------
-- Table structure for `opisio`
-- ----------------------------
DROP TABLE IF EXISTS `opisio`;
CREATE TABLE `opisio` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `idio` int(3) NOT NULL,
  `punc` varchar(50) NOT NULL DEFAULT '',
  `color` varchar(7) DEFAULT '',
  `in_or_out` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`,`idio`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of opisio
-- ----------------------------
INSERT INTO `opisio` VALUES ('1', '0', 'out', '#FF0000', '0');
INSERT INTO `opisio` VALUES ('2', '1', 'in', '#009900', '1');
INSERT INTO `opisio` VALUES ('3', '2', 'pauza', '#FF9900', '0');
INSERT INTO `opisio` VALUES ('5', '3', 'privatno', '#0000FF', '0');
INSERT INTO `opisio` VALUES ('6', '4', 'sluzbeno', '#0000FF', '0');

-- ----------------------------
-- Table structure for `prog`
-- ----------------------------
DROP TABLE IF EXISTS `prog`;
CREATE TABLE `prog` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `prfsrno` varchar(12) NOT NULL,
  `ssid` varchar(24) DEFAULT NULL,
  `pass` varchar(24) DEFAULT NULL,
  `srlink` varchar(50) DEFAULT NULL,
  `psts` int(3) DEFAULT NULL,
  PRIMARY KEY (`id`,`prfsrno`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of prog
-- ----------------------------
INSERT INTO `prog` VALUES ('1', '1001', 'NET-TIM_032', 'MK2u13qx', 'http://192.168.213.25/MyWEB/w3/radvre', '1');
INSERT INTO `prog` VALUES ('2', '1002', 'My2Home', 'MK2u13qx', 'http://192.168.213.25/MyWEB/w3/radvre', '0');
INSERT INTO `prog` VALUES ('3', '1003', 'My2Work', 'MK2u13qx', 'http://192.168.213.25/MyWEB/w3/radvre', '0');
INSERT INTO `prog` VALUES ('6', '1001', 'My2Home', 'MK2u13qx', 'http://192.168.213.25/MyWEB/w3/radvre', '0');

-- ----------------------------
-- Table structure for `punchlist`
-- ----------------------------
DROP TABLE IF EXISTS `punchlist`;
CREATE TABLE `punchlist` (
  `punchitems` varchar(50) NOT NULL DEFAULT '',
  `color` varchar(7) NOT NULL DEFAULT '',
  `in_or_out` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`punchitems`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of punchlist
-- ----------------------------
INSERT INTO `punchlist` VALUES ('in', '#009900', '1');
INSERT INTO `punchlist` VALUES ('out', '#FF0000', '0');
INSERT INTO `punchlist` VALUES ('break', '#FF9900', '0');
INSERT INTO `punchlist` VALUES ('lunch', '#0000FF', '0');
INSERT INTO `punchlist` VALUES ('private', '#0000FF', '0');

-- ----------------------------
-- Table structure for `radjed`
-- ----------------------------
DROP TABLE IF EXISTS `radjed`;
CREATE TABLE `radjed` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `officeid` int(10) NOT NULL,
  `officename` varchar(50) DEFAULT '',
  PRIMARY KEY (`id`,`officeid`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of radjed
-- ----------------------------
INSERT INTO `radjed` VALUES ('4', '101', 'Servis');
INSERT INTO `radjed` VALUES ('5', '102', 'Hala');
INSERT INTO `radjed` VALUES ('6', '103', 'Radionica');
INSERT INTO `radjed` VALUES ('7', '104', 'Magacin');
INSERT INTO `radjed` VALUES ('8', '105', 'Kontrola');

-- ----------------------------
-- Table structure for `radmes`
-- ----------------------------
DROP TABLE IF EXISTS `radmes`;
CREATE TABLE `radmes` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `groupid` int(10) NOT NULL,
  `groupname` varchar(50) DEFAULT '',
  `officeid` int(10) DEFAULT '0',
  PRIMARY KEY (`id`,`groupid`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of radmes
-- ----------------------------
INSERT INTO `radmes` VALUES ('2', '10', 'Radnik', '101');
INSERT INTO `radmes` VALUES ('3', '11', 'Grupovodja', '101');
INSERT INTO `radmes` VALUES ('4', '20', 'Vozac', '102');
INSERT INTO `radmes` VALUES ('5', '21', 'Magacioner', '102');
INSERT INTO `radmes` VALUES ('6', '25', 'Kontrolor', '105');
INSERT INTO `radmes` VALUES ('7', '26', 'Alatnicar', '105');

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `dispname` varchar(12) NOT NULL DEFAULT '',
  `fullname` varchar(32) DEFAULT '',
  `passwd` varchar(12) DEFAULT '',
  `rfid` varchar(12) DEFAULT NULL,
  `email` varchar(50) DEFAULT '',
  `groups` varchar(32) DEFAULT '',
  `office` varchar(32) DEFAULT '',
  `admin` tinyint(1) DEFAULT '0',
  `reports` tinyint(1) DEFAULT '0',
  `disabled` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`,`dispname`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'admin', 'Administrator', 'xy.RY2HT1QTc', '12345678', '', '', '', '1', '1', '0');
INSERT INTO `user` VALUES ('2', 'Misko', 'Misko Kukic', 'xyKdVmE76cVr', '3D763400', 'mvkukic@gmail.com', 'Radnik', 'Servis', '1', '1', '1');
INSERT INTO `user` VALUES ('3', 'Sinisa', 'Sinisa Randjo', 'xyUgpohjcQlS', '234567890', 'rasin@cacak.net', 'Radnik', 'Servis', '0', '0', '1');
INSERT INTO `user` VALUES ('4', 'Vlade', 'Vladimir Kleut', 'valter', 'E557C3CD', 'klesh@cacak.net', 'Upravnik', 'Servis', '0', '0', '0');
INSERT INTO `user` VALUES ('5', 'Dusko', 'Dusko Petrovic', 'xyqs.1MiduVD', '456789012', 'dusko@cacak.net', 'Radnik', 'Servis', '0', '1', '1');
INSERT INTO `user` VALUES ('6', 'Bosko_32', 'Bosko Boskic', 'boskic', '01234567', 'boskic@cacak.net', 'Radnik', 'Servis', '0', '0', '1');

-- ----------------------------
-- Table structure for `vrata`
-- ----------------------------
DROP TABLE IF EXISTS `vrata`;
CREATE TABLE `vrata` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `vrfsrno` varchar(12) NOT NULL,
  `urfid` varchar(12) NOT NULL,
  `kljuc` int(3) DEFAULT NULL,
  `prolaz` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`id`,`vrfsrno`,`urfid`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of vrata
-- ----------------------------
INSERT INTO `vrata` VALUES ('1', '1001', 'E557C3CD', '1', '07-14');
INSERT INTO `vrata` VALUES ('2', '1001', '3D763400', '0', '07-14');
INSERT INTO `vrata` VALUES ('3', '1010', '12345678', '0', '00-24');