/*
Navicat MySQL Data Transfer
Source Server : 127.0.0.1
Source Server Version : 50144
Source Host : 127.0.0.1:3306
Source Database : prazdna
Target Server Type : MYSQL
Target Server Version : 50144
File Encoding : 65001
Date: 2010-08-25 18:04:53
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `cards`
-- ----------------------------
DROP TABLE IF EXISTS `cards`;
CREATE TABLE `cards` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`card_id` varchar(20) DEFAULT NULL,
`id_doch` varchar(8) DEFAULT NULL,
`EnrollTime` varchar(14) DEFAULT NULL,
`fy` int(5) DEFAULT NULL,
`pozn` varchar(255) DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of cards
-- ----------------------------
-- ----------------------------
-- Table structure for `clovek`
-- ----------------------------
DROP TABLE IF EXISTS `clovek`;
CREATE TABLE `clovek` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`fy` int(5) NOT NULL DEFAULT '0',
`id_doch` varchar(8) NOT NULL DEFAULT '',
`meno` varchar(255) NOT NULL DEFAULT '',
`priez` varchar(255) NOT NULL DEFAULT '',
`oddelenie` int(10) NOT NULL DEFAULT '0',
`heslo` varchar(10) NOT NULL DEFAULT '',
`email` varchar(255) NOT NULL DEFAULT '',
`titl` varchar(50) DEFAULT '',
`zam_od` varchar(8) DEFAULT '20000101',
`zam_do` varchar(8) DEFAULT '20991231',
`admin` int(8) DEFAULT '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=297 DEFAULT CHARSET=cp1250 COMMENT='Databáza zamestnancov';
-- ----------------------------
-- Records of clovek
-- ----------------------------
-- ----------------------------
-- Table structure for `clovek_prirad`
-- ----------------------------
DROP TABLE IF EXISTS `clovek_prirad`;
CREATE TABLE `clovek_prirad` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`id_doch` varchar(8) NOT NULL DEFAULT '',
`terminal_id` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `index` (`id_doch`,`terminal_id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of clovek_prirad
-- ----------------------------
-- ----------------------------
-- Table structure for `faces`
-- ----------------------------
DROP TABLE IF EXISTS `faces`;
CREATE TABLE `faces` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`Features` longblob,
`FaceID` varchar(8) CHARACTER SET latin1 DEFAULT NULL,
`Picture` longblob,
`EnrollTime` varchar(14) CHARACTER SET latin1 DEFAULT NULL,
`fy` int(5) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of faces
-- ----------------------------
-- ----------------------------
-- Table structure for `fingers`
-- ----------------------------
DROP TABLE IF EXISTS `fingers`;
CREATE TABLE `fingers` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`Template` longblob,
`id_doch` varchar(8) CHARACTER SET latin1 DEFAULT NULL,
`Picture` longblob,
`EnrollTime` varchar(14) CHARACTER SET latin1 DEFAULT NULL,
`Finger` int(1) DEFAULT NULL,
`fy` int(5) DEFAULT NULL,
`Length` varchar(11) CHARACTER SET latin1 DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of fingers
-- ----------------------------
-- ----------------------------
-- Table structure for `fond`
-- ----------------------------
DROP TABLE IF EXISTS `fond`;
CREATE TABLE `fond` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`id_doch` varchar(8) NOT NULL,
`datum` varchar(8) NOT NULL,
`fond` int(10) NOT NULL,
`fy` int(5) NOT NULL,
`popis` varchar(255) NOT NULL DEFAULT ' ',
`plus` float NOT NULL DEFAULT '0',
`minus` float NOT NULL DEFAULT '0',
`manual` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index` (`id_doch`,`datum`,`fond`,`fy`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of fond
-- ----------------------------
-- ----------------------------
-- Table structure for `fond_setup`
-- ----------------------------
DROP TABLE IF EXISTS `fond_setup`;
CREATE TABLE `fond_setup` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`nazov` varchar(255) NOT NULL,
`typ` int(1) NOT NULL DEFAULT '0',
`prerusenie` int(2) NOT NULL DEFAULT '0',
`fy` int(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of fond_setup
-- ----------------------------
INSERT INTO `fond_setup` VALUES ('1', 'Dovolenka', '0', '9', '5');
INSERT INTO `fond_setup` VALUES ('5', 'Lekár', '1', '4', '5');
INSERT INTO `fond_setup` VALUES ('6', 'Lekár doprovod', '1', '12', '5');
INSERT INTO `fond_setup` VALUES ('7', 'PN', '0', '15', '5');
-- ----------------------------
-- Table structure for `fronta`
-- ----------------------------
DROP TABLE IF EXISTS `fronta`;
CREATE TABLE `fronta` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`fy` int(5) NOT NULL,
`id_doch` varchar(8) NOT NULL,
`datum` varchar(8) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`fy`,`id_doch`,`datum`)
) ENGINE=InnoDB AUTO_INCREMENT=30884 DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of fronta
-- ----------------------------
INSERT INTO `fronta` VALUES ('30882', '5', '00000011', '20090305');
-- ----------------------------
-- Table structure for `fy`
-- ----------------------------
DROP TABLE IF EXISTS `fy`;
CREATE TABLE `fy` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nazov` varchar(255) NOT NULL DEFAULT '',
`smtp` varchar(255) NOT NULL DEFAULT '',
`port` varchar(5) NOT NULL DEFAULT '',
`email` varchar(255) DEFAULT NULL,
`hash` varchar(32) NOT NULL DEFAULT '',
`smtp_name` varchar(255) NOT NULL DEFAULT '',
`smtp_pass` varchar(255) NOT NULL DEFAULT '',
`vendor` varchar(1) DEFAULT 'D',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=cp1250 COMMENT='Zoznam firiem';
-- ----------------------------
-- Records of fy
-- ----------------------------
INSERT INTO `fy` VALUES ('5', 'NOVA FIRMA', '', '', '', '', '', '', 'G');
-- ----------------------------
-- Table structure for `history`
-- ----------------------------
DROP TABLE IF EXISTS `history`;
CREATE TABLE `history` (
`id` int(25) NOT NULL AUTO_INCREMENT,
`id_doch` varchar(8) NOT NULL DEFAULT '',
`pr` int(2) NOT NULL DEFAULT '0',
`typ` int(1) NOT NULL DEFAULT '0',
`datum` varchar(14) NOT NULL DEFAULT '',
`fy` int(5) NOT NULL DEFAULT '0',
`vlozil` varchar(31) NOT NULL DEFAULT '',
`pozn` varchar(150) NOT NULL DEFAULT '',
`manual` tinyint(1) DEFAULT '1',
`picture` longblob,
UNIQUE KEY `id` (`id`),
KEY `datum` (`datum`),
KEY `id_doch` (`id_doch`),
KEY `ostatne` (`pr`,`typ`,`fy`)
) ENGINE=MyISAM AUTO_INCREMENT=63384 DEFAULT CHARSET=cp1250 COMMENT='História dochádzky';
-- ----------------------------
-- Records of history
-- ----------------------------
-- ----------------------------
-- Table structure for `history_arch`
-- ----------------------------
DROP TABLE IF EXISTS `history_arch`;
CREATE TABLE `history_arch` (
`id` int(25) NOT NULL AUTO_INCREMENT,
`id_doch` varchar(8) NOT NULL DEFAULT '',
`pr` int(2) NOT NULL DEFAULT '0',
`typ` int(1) NOT NULL DEFAULT '0',
`datum` varchar(14) NOT NULL DEFAULT '',
`fy` int(5) NOT NULL DEFAULT '0',
`vlozil` varchar(31) NOT NULL DEFAULT '',
`pozn` varchar(150) NOT NULL DEFAULT '',
`manual` tinyint(1) DEFAULT '1',
`picture` longblob,
UNIQUE KEY `id` (`id`),
KEY `datum` (`datum`),
KEY `id_doch` (`id_doch`),
KEY `ostatne` (`pr`,`typ`,`fy`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of history_arch
-- ----------------------------
-- ----------------------------
-- Table structure for `history_old`
-- ----------------------------
DROP TABLE IF EXISTS `history_old`;
CREATE TABLE `history_old` (
`id` int(25) NOT NULL AUTO_INCREMENT,
`id_doch` varchar(8) NOT NULL DEFAULT '',
`pr` int(2) NOT NULL DEFAULT '0',
`typ` int(1) NOT NULL DEFAULT '0',
`datum` varchar(14) NOT NULL DEFAULT '',
`fy` int(5) NOT NULL DEFAULT '0',
`vlozil` varchar(31) NOT NULL DEFAULT '',
`pozn` varchar(150) NOT NULL DEFAULT '',
`manual` tinyint(1) DEFAULT '1',
`zmazane` datetime DEFAULT NULL,
UNIQUE KEY `id` (`id`),
KEY `datum` (`datum`),
KEY `id_doch` (`id_doch`),
KEY `fy` (`fy`)
) ENGINE=MyISAM AUTO_INCREMENT=60743 DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of history_old
-- ----------------------------
INSERT INTO `history_old` VALUES ('60742', '00000011', '1', '0', '20090305092955', '5', '[6413] dvere BioStation', '', '0', '2010-08-25 18:04:38');
-- ----------------------------
-- Table structure for `iclock`
-- ----------------------------
DROP TABLE IF EXISTS `iclock`;
CREATE TABLE `iclock` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(15) DEFAULT '192.168.1.201',
`port` varchar(5) DEFAULT '4370',
`pass` varchar(15) DEFAULT '0',
`popis` varchar(100) DEFAULT '',
`card` varchar(3) DEFAULT 'EM',
PRIMARY KEY (`id`),
KEY `index` (`ip`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of iclock
-- ----------------------------
-- ----------------------------
-- Table structure for `intercom_akcie`
-- ----------------------------
DROP TABLE IF EXISTS `intercom_akcie`;
CREATE TABLE `intercom_akcie` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_doch` varchar(8) DEFAULT NULL,
`terminal` varchar(255) DEFAULT NULL,
`ip` varchar(15) DEFAULT NULL,
`pridane` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`akcia` varchar(255) DEFAULT NULL,
`vykonane` int(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index` (`terminal`,`pridane`,`vykonane`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of intercom_akcie
-- ----------------------------
-- ----------------------------
-- Table structure for `intercom_client`
-- ----------------------------
DROP TABLE IF EXISTS `intercom_client`;
CREATE TABLE `intercom_client` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_doch` varchar(8) DEFAULT NULL,
`nazov` varchar(255) DEFAULT NULL,
`ip` varchar(15) DEFAULT NULL,
`pridane` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of intercom_client
-- ----------------------------
-- ----------------------------
-- Table structure for `intercom_terminal`
-- ----------------------------
DROP TABLE IF EXISTS `intercom_terminal`;
CREATE TABLE `intercom_terminal` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nazov` varchar(255) DEFAULT NULL,
`pridane` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`picture` longblob,
`terminal_id` varchar(100) DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of intercom_terminal
-- ----------------------------
-- ----------------------------
-- Table structure for `intercom_volania`
-- ----------------------------
DROP TABLE IF EXISTS `intercom_volania`;
CREATE TABLE `intercom_volania` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_doch` varchar(8) DEFAULT NULL,
`terminal` varchar(255) DEFAULT NULL,
`pridane` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`vykonane` int(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index` (`terminal`,`pridane`,`vykonane`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of intercom_volania
-- ----------------------------
-- ----------------------------
-- Table structure for `licencia`
-- ----------------------------
DROP TABLE IF EXISTS `licencia`;
CREATE TABLE `licencia` (
`id` int(3) NOT NULL AUTO_INCREMENT,
`pocet_usr` int(3) NOT NULL DEFAULT '0',
`pocet_zam` int(5) NOT NULL,
`moduly` text NOT NULL,
`platnost` varchar(8) NOT NULL,
`support` varchar(8) NOT NULL,
`install` varchar(32) NOT NULL,
`protihodnota` varchar(32) NOT NULL,
`verzia` varchar(20) NOT NULL DEFAULT '1.0.0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of licencia
-- ----------------------------
INSERT INTO `licencia` VALUES ('23', '1', '1', '', '20110101', '20110101', '', '', '1.6.07');
-- ----------------------------
-- Table structure for `nadcas`
-- ----------------------------
DROP TABLE IF EXISTS `nadcas`;
CREATE TABLE `nadcas` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`datum` varchar(8) NOT NULL,
`id_doch` varchar(8) NOT NULL,
`fy` int(5) NOT NULL,
`preplatene` int(5) NOT NULL DEFAULT '0',
`prenos` int(5) NOT NULL DEFAULT '0',
`zrusene` int(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index` (`datum`,`id_doch`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of nadcas
-- ----------------------------
-- ----------------------------
-- Table structure for `nastaveniesmeny`
-- ----------------------------
DROP TABLE IF EXISTS `nastaveniesmeny`;
CREATE TABLE `nastaveniesmeny` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`oddelenie` int(10) NOT NULL,
`den` int(1) NOT NULL,
`pohod` varchar(4) NOT NULL,
`pevod` varchar(4) NOT NULL,
`pevdo` varchar(4) NOT NULL,
`pohdo` varchar(4) NOT NULL,
`fond` float(4,2) NOT NULL COMMENT 'Nastavenia zmeny',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of nastaveniesmeny
-- ----------------------------
-- ----------------------------
-- Table structure for `obed_hlavne`
-- ----------------------------
DROP TABLE IF EXISTS `obed_hlavne`;
CREATE TABLE `obed_hlavne` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`fy` int(5) NOT NULL,
`nazov` varchar(255) NOT NULL,
`popis` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of obed_hlavne
-- ----------------------------
-- ----------------------------
-- Table structure for `obed_listok`
-- ----------------------------
DROP TABLE IF EXISTS `obed_listok`;
CREATE TABLE `obed_listok` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`fy` int(5) NOT NULL,
`datum` varchar(8) NOT NULL,
`polievka1` int(5) NOT NULL DEFAULT '0',
`polievka2` int(5) NOT NULL DEFAULT '0',
`jedlo1` int(5) NOT NULL DEFAULT '0',
`jedlo2` int(5) NOT NULL DEFAULT '0',
`jedlo3` int(5) NOT NULL DEFAULT '0',
`jedlo4` int(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of obed_listok
-- ----------------------------
-- ----------------------------
-- Table structure for `obed_orazene`
-- ----------------------------
DROP TABLE IF EXISTS `obed_orazene`;
CREATE TABLE `obed_orazene` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`fy` int(5) NOT NULL,
`polievka` int(1) NOT NULL DEFAULT '0',
`jedlo` int(1) NOT NULL DEFAULT '0',
`id_doch` varchar(8) NOT NULL,
`datum` varchar(14) NOT NULL,
PRIMARY KEY (`id`),
KEY `datum` (`datum`),
KEY `fy` (`fy`),
KEY `id_doch` (`id_doch`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of obed_orazene
-- ----------------------------
-- ----------------------------
-- Table structure for `obed_polievky`
-- ----------------------------
DROP TABLE IF EXISTS `obed_polievky`;
CREATE TABLE `obed_polievky` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`fy` int(5) NOT NULL,
`nazov` varchar(255) NOT NULL,
`popis` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of obed_polievky
-- ----------------------------
-- ----------------------------
-- Table structure for `oddelenie`
-- ----------------------------
DROP TABLE IF EXISTS `oddelenie`;
CREATE TABLE `oddelenie` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`fy` int(5) NOT NULL DEFAULT '0',
`nazov` varchar(255) NOT NULL DEFAULT '',
`prac_doba` float NOT NULL DEFAULT '7.5',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=cp1250 COMMENT='Zoznam oddeleni firiem';
-- ----------------------------
-- Records of oddelenie
-- ----------------------------
-- ----------------------------
-- Table structure for `poznamky`
-- ----------------------------
DROP TABLE IF EXISTS `poznamky`;
CREATE TABLE `poznamky` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`id_doch` varchar(8) DEFAULT '',
`datum` varchar(8) DEFAULT '',
`vlozil` varchar(30) DEFAULT '',
`vlozil_cas` varchar(14) DEFAULT '',
`poznamka` varchar(255) DEFAULT '',
PRIMARY KEY (`id`),
KEY `index` (`id_doch`,`id`,`datum`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of poznamky
-- ----------------------------
-- ----------------------------
-- Table structure for `prava`
-- ----------------------------
DROP TABLE IF EXISTS `prava`;
CREATE TABLE `prava` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`nazov` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of prava
-- ----------------------------
INSERT INTO `prava` VALUES ('1', 'Administrátor');
INSERT INTO `prava` VALUES ('2', 'Prezeranie/Úprava');
INSERT INTO `prava` VALUES ('3', 'Prezeranie');
INSERT INTO `prava` VALUES ('4', 'Kuchár');
INSERT INTO `prava` VALUES ('5', 'Správca objektu');
-- ----------------------------
-- Table structure for `prava_setup`
-- ----------------------------
DROP TABLE IF EXISTS `prava_setup`;
CREATE TABLE `prava_setup` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`prava_id` int(15) NOT NULL,
`pravo` int(1) NOT NULL DEFAULT '0',
`polozka` int(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `indexi` (`id`,`prava_id`,`pravo`,`polozka`)
) ENGINE=InnoDB AUTO_INCREMENT=161 DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of prava_setup
-- ----------------------------
INSERT INTO `prava_setup` VALUES ('1', '1', '2', '1');
INSERT INTO `prava_setup` VALUES ('2', '1', '2', '2');
INSERT INTO `prava_setup` VALUES ('3', '1', '2', '3');
INSERT INTO `prava_setup` VALUES ('4', '1', '2', '4');
INSERT INTO `prava_setup` VALUES ('5', '1', '2', '5');
INSERT INTO `prava_setup` VALUES ('6', '1', '2', '6');
INSERT INTO `prava_setup` VALUES ('7', '1', '2', '7');
INSERT INTO `prava_setup` VALUES ('8', '1', '2', '8');
INSERT INTO `prava_setup` VALUES ('9', '1', '2', '9');
INSERT INTO `prava_setup` VALUES ('10', '1', '2', '10');
INSERT INTO `prava_setup` VALUES ('11', '1', '2', '11');
INSERT INTO `prava_setup` VALUES ('12', '1', '2', '12');
INSERT INTO `prava_setup` VALUES ('13', '1', '2', '13');
INSERT INTO `prava_setup` VALUES ('14', '1', '2', '14');
INSERT INTO `prava_setup` VALUES ('15', '1', '2', '15');
INSERT INTO `prava_setup` VALUES ('16', '1', '2', '16');
INSERT INTO `prava_setup` VALUES ('17', '1', '2', '17');
INSERT INTO `prava_setup` VALUES ('18', '1', '2', '18');
INSERT INTO `prava_setup` VALUES ('19', '1', '2', '19');
INSERT INTO `prava_setup` VALUES ('20', '1', '2', '20');
INSERT INTO `prava_setup` VALUES ('21', '1', '2', '21');
INSERT INTO `prava_setup` VALUES ('22', '1', '2', '22');
INSERT INTO `prava_setup` VALUES ('23', '1', '2', '23');
INSERT INTO `prava_setup` VALUES ('24', '1', '2', '24');
INSERT INTO `prava_setup` VALUES ('25', '1', '2', '25');
INSERT INTO `prava_setup` VALUES ('26', '1', '2', '26');
INSERT INTO `prava_setup` VALUES ('27', '1', '2', '27');
INSERT INTO `prava_setup` VALUES ('28', '2', '2', '1');
INSERT INTO `prava_setup` VALUES ('29', '2', '2', '2');
INSERT INTO `prava_setup` VALUES ('30', '2', '2', '3');
INSERT INTO `prava_setup` VALUES ('31', '2', '2', '4');
INSERT INTO `prava_setup` VALUES ('32', '2', '2', '5');
INSERT INTO `prava_setup` VALUES ('33', '2', '2', '6');
INSERT INTO `prava_setup` VALUES ('34', '2', '0', '7');
INSERT INTO `prava_setup` VALUES ('35', '2', '2', '8');
INSERT INTO `prava_setup` VALUES ('36', '2', '1', '9');
INSERT INTO `prava_setup` VALUES ('37', '2', '2', '10');
INSERT INTO `prava_setup` VALUES ('38', '2', '2', '11');
INSERT INTO `prava_setup` VALUES ('39', '2', '2', '12');
INSERT INTO `prava_setup` VALUES ('40', '2', '2', '13');
INSERT INTO `prava_setup` VALUES ('41', '2', '2', '14');
INSERT INTO `prava_setup` VALUES ('42', '2', '2', '15');
INSERT INTO `prava_setup` VALUES ('43', '2', '2', '16');
INSERT INTO `prava_setup` VALUES ('44', '2', '2', '17');
INSERT INTO `prava_setup` VALUES ('45', '2', '2', '18');
INSERT INTO `prava_setup` VALUES ('46', '2', '2', '19');
INSERT INTO `prava_setup` VALUES ('47', '2', '2', '20');
INSERT INTO `prava_setup` VALUES ('48', '2', '2', '21');
INSERT INTO `prava_setup` VALUES ('49', '2', '1', '22');
INSERT INTO `prava_setup` VALUES ('50', '2', '2', '23');
INSERT INTO `prava_setup` VALUES ('51', '2', '2', '24');
INSERT INTO `prava_setup` VALUES ('52', '2', '2', '25');
INSERT INTO `prava_setup` VALUES ('53', '2', '2', '26');
INSERT INTO `prava_setup` VALUES ('54', '2', '1', '27');
INSERT INTO `prava_setup` VALUES ('55', '3', '1', '1');
INSERT INTO `prava_setup` VALUES ('56', '3', '1', '2');
INSERT INTO `prava_setup` VALUES ('57', '3', '1', '3');
INSERT INTO `prava_setup` VALUES ('58', '3', '1', '4');
INSERT INTO `prava_setup` VALUES ('59', '3', '1', '5');
INSERT INTO `prava_setup` VALUES ('60', '3', '1', '6');
INSERT INTO `prava_setup` VALUES ('61', '3', '0', '7');
INSERT INTO `prava_setup` VALUES ('62', '3', '1', '8');
INSERT INTO `prava_setup` VALUES ('63', '3', '1', '9');
INSERT INTO `prava_setup` VALUES ('64', '3', '1', '10');
INSERT INTO `prava_setup` VALUES ('65', '3', '1', '11');
INSERT INTO `prava_setup` VALUES ('66', '3', '1', '12');
INSERT INTO `prava_setup` VALUES ('67', '3', '1', '13');
INSERT INTO `prava_setup` VALUES ('68', '3', '1', '14');
INSERT INTO `prava_setup` VALUES ('69', '3', '1', '15');
INSERT INTO `prava_setup` VALUES ('70', '3', '1', '16');
INSERT INTO `prava_setup` VALUES ('71', '3', '1', '17');
INSERT INTO `prava_setup` VALUES ('72', '3', '1', '18');
INSERT INTO `prava_setup` VALUES ('73', '3', '1', '19');
INSERT INTO `prava_setup` VALUES ('74', '3', '1', '20');
INSERT INTO `prava_setup` VALUES ('75', '3', '1', '21');
INSERT INTO `prava_setup` VALUES ('76', '3', '1', '22');
INSERT INTO `prava_setup` VALUES ('77', '3', '1', '23');
INSERT INTO `prava_setup` VALUES ('78', '3', '1', '24');
INSERT INTO `prava_setup` VALUES ('79', '3', '1', '25');
INSERT INTO `prava_setup` VALUES ('80', '3', '1', '26');
INSERT INTO `prava_setup` VALUES ('81', '3', '1', '27');
INSERT INTO `prava_setup` VALUES ('82', '4', '0', '1');
INSERT INTO `prava_setup` VALUES ('83', '4', '0', '2');
INSERT INTO `prava_setup` VALUES ('84', '4', '0', '3');
INSERT INTO `prava_setup` VALUES ('85', '4', '0', '4');
INSERT INTO `prava_setup` VALUES ('86', '4', '0', '5');
INSERT INTO `prava_setup` VALUES ('87', '4', '0', '6');
INSERT INTO `prava_setup` VALUES ('88', '4', '0', '7');
INSERT INTO `prava_setup` VALUES ('89', '4', '0', '8');
INSERT INTO `prava_setup` VALUES ('90', '4', '0', '9');
INSERT INTO `prava_setup` VALUES ('91', '4', '0', '10');
INSERT INTO `prava_setup` VALUES ('92', '4', '0', '11');
INSERT INTO `prava_setup` VALUES ('93', '4', '0', '12');
INSERT INTO `prava_setup` VALUES ('94', '4', '0', '13');
INSERT INTO `prava_setup` VALUES ('95', '4', '0', '14');
INSERT INTO `prava_setup` VALUES ('96', '4', '0', '15');
INSERT INTO `prava_setup` VALUES ('97', '4', '0', '16');
INSERT INTO `prava_setup` VALUES ('98', '4', '0', '17');
INSERT INTO `prava_setup` VALUES ('99', '4', '0', '18');
INSERT INTO `prava_setup` VALUES ('100', '4', '0', '19');
INSERT INTO `prava_setup` VALUES ('101', '4', '0', '20');
INSERT INTO `prava_setup` VALUES ('102', '4', '2', '21');
INSERT INTO `prava_setup` VALUES ('103', '4', '0', '22');
INSERT INTO `prava_setup` VALUES ('104', '4', '0', '23');
INSERT INTO `prava_setup` VALUES ('105', '4', '1', '24');
INSERT INTO `prava_setup` VALUES ('106', '4', '0', '25');
INSERT INTO `prava_setup` VALUES ('107', '4', '0', '26');
INSERT INTO `prava_setup` VALUES ('108', '4', '0', '27');
INSERT INTO `prava_setup` VALUES ('109', '5', '0', '1');
INSERT INTO `prava_setup` VALUES ('110', '5', '0', '2');
INSERT INTO `prava_setup` VALUES ('111', '5', '0', '3');
INSERT INTO `prava_setup` VALUES ('112', '5', '0', '4');
INSERT INTO `prava_setup` VALUES ('113', '5', '0', '5');
INSERT INTO `prava_setup` VALUES ('114', '5', '0', '6');
INSERT INTO `prava_setup` VALUES ('115', '5', '0', '7');
INSERT INTO `prava_setup` VALUES ('116', '5', '0', '8');
INSERT INTO `prava_setup` VALUES ('117', '5', '0', '9');
INSERT INTO `prava_setup` VALUES ('118', '5', '0', '10');
INSERT INTO `prava_setup` VALUES ('119', '5', '0', '11');
INSERT INTO `prava_setup` VALUES ('120', '5', '0', '12');
INSERT INTO `prava_setup` VALUES ('121', '5', '0', '13');
INSERT INTO `prava_setup` VALUES ('122', '5', '0', '14');
INSERT INTO `prava_setup` VALUES ('123', '5', '0', '15');
INSERT INTO `prava_setup` VALUES ('124', '5', '1', '16');
INSERT INTO `prava_setup` VALUES ('125', '5', '0', '17');
INSERT INTO `prava_setup` VALUES ('126', '5', '0', '18');
INSERT INTO `prava_setup` VALUES ('127', '5', '0', '19');
INSERT INTO `prava_setup` VALUES ('128', '5', '0', '20');
INSERT INTO `prava_setup` VALUES ('129', '5', '0', '21');
INSERT INTO `prava_setup` VALUES ('130', '5', '0', '22');
INSERT INTO `prava_setup` VALUES ('131', '5', '0', '23');
INSERT INTO `prava_setup` VALUES ('132', '5', '0', '24');
INSERT INTO `prava_setup` VALUES ('133', '5', '0', '25');
INSERT INTO `prava_setup` VALUES ('134', '5', '0', '26');
INSERT INTO `prava_setup` VALUES ('135', '5', '0', '27');
INSERT INTO `prava_setup` VALUES ('136', '1', '2', '28');
INSERT INTO `prava_setup` VALUES ('137', '2', '2', '28');
INSERT INTO `prava_setup` VALUES ('138', '3', '1', '28');
INSERT INTO `prava_setup` VALUES ('139', '1', '2', '29');
INSERT INTO `prava_setup` VALUES ('140', '1', '2', '30');
INSERT INTO `prava_setup` VALUES ('141', '2', '2', '30');
INSERT INTO `prava_setup` VALUES ('142', '3', '2', '30');
INSERT INTO `prava_setup` VALUES ('143', '1', '2', '31');
INSERT INTO `prava_setup` VALUES ('144', '2', '2', '31');
INSERT INTO `prava_setup` VALUES ('145', '3', '2', '31');
INSERT INTO `prava_setup` VALUES ('146', '1', '2', '32');
INSERT INTO `prava_setup` VALUES ('147', '2', '2', '32');
INSERT INTO `prava_setup` VALUES ('148', '3', '1', '32');
INSERT INTO `prava_setup` VALUES ('149', '1', '2', '33');
INSERT INTO `prava_setup` VALUES ('150', '2', '2', '33');
INSERT INTO `prava_setup` VALUES ('151', '3', '1', '33');
INSERT INTO `prava_setup` VALUES ('152', '1', '2', '34');
INSERT INTO `prava_setup` VALUES ('153', '2', '2', '34');
INSERT INTO `prava_setup` VALUES ('154', '3', '1', '34');
INSERT INTO `prava_setup` VALUES ('155', '1', '2', '35');
INSERT INTO `prava_setup` VALUES ('156', '2', '2', '35');
INSERT INTO `prava_setup` VALUES ('157', '3', '1', '35');
INSERT INTO `prava_setup` VALUES ('158', '1', '2', '36');
INSERT INTO `prava_setup` VALUES ('159', '2', '2', '36');
INSERT INTO `prava_setup` VALUES ('160', '3', '1', '36');
-- ----------------------------
-- Table structure for `premenne`
-- ----------------------------
DROP TABLE IF EXISTS `premenne`;
CREATE TABLE `premenne` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`nazov` varchar(31) DEFAULT '',
`popis` varchar(255) DEFAULT '',
`hodnota` varchar(255) DEFAULT '',
`uzivatel` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index` (`nazov`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of premenne
-- ----------------------------
INSERT INTO `premenne` VALUES ('1', 'DelPicAfter', 'Mazat obrazky starsie ako', '365', '0');
INSERT INTO `premenne` VALUES ('2', 'PrichodOdchodRozdiel', '', '45', '1');
INSERT INTO `premenne` VALUES ('3', 'VetaNaKoniec', '', 'Zamestnanec svojim podpisom potvrdzuje správnosť vyššie uvedených údajov a prejav vlastnej vôle s odpracovanými smenami, hodinami, vrátane nadčasových hodín.', '0');
-- ----------------------------
-- Table structure for `prerusenia`
-- ----------------------------
DROP TABLE IF EXISTS `prerusenia`;
CREATE TABLE `prerusenia` (
`id` int(2) NOT NULL DEFAULT '0',
`nazov` varchar(25) NOT NULL DEFAULT '',
`skr` varchar(9) NOT NULL DEFAULT '',
`prac` int(1) NOT NULL DEFAULT '0',
`dozaciatku` int(1) NOT NULL DEFAULT '1',
`zaciatokplus` float(3,2) NOT NULL DEFAULT '0.00',
`dokonca` int(1) NOT NULL DEFAULT '1',
`dokoncaplus` float(3,2) NOT NULL DEFAULT '0.00',
`priznak` int(1) NOT NULL DEFAULT '1',
`priznakpodla` int(1) NOT NULL DEFAULT '0',
`saldo` int(1) NOT NULL DEFAULT '0',
`zaok` int(3) DEFAULT '0',
`drzat_weekend` int(1) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=cp1250 COMMENT='kody preruseni';
-- ----------------------------
-- Records of prerusenia
-- ----------------------------
INSERT INTO `prerusenia` VALUES ('0', 'Práca', 'P', '0', '0', '0.00', '0', '0.00', '0', '0', '0', '0', '0');
INSERT INTO `prerusenia` VALUES ('1', 'Služobne', 'SL', '1', '1', '0.00', '1', '0.00', '1', '0', '0', '0', '0');
INSERT INTO `prerusenia` VALUES ('2', 'Služobná cesta', 'SLC', '1', '1', '0.00', '1', '0.00', '1', '0', '0', '0', '0');
INSERT INTO `prerusenia` VALUES ('3', 'Súkromne', 'SU', '0', '0', '0.00', '0', '0.00', '0', '0', '0', '0', '0');
INSERT INTO `prerusenia` VALUES ('4', 'Lekár', 'L', '0', '1', '0.00', '1', '0.00', '1', '0', '1', '0', '0');
INSERT INTO `prerusenia` VALUES ('5', 'Platené voľno', 'PV', '1', '1', '0.00', '2', '0.00', '1', '0', '0', '0', '0');
INSERT INTO `prerusenia` VALUES ('6', 'Študijné voľno', 'STUD', '0', '0', '0.00', '0', '0.00', '1', '0', '0', '0', '0');
INSERT INTO `prerusenia` VALUES ('7', 'Verejný záujem', 'VZ', '0', '0', '0.00', '0', '0.00', '0', '0', '0', '0', '0');
INSERT INTO `prerusenia` VALUES ('8', '§ Paragraf', '§', '0', '0', '0.00', '0', '0.00', '0', '0', '1', '0', '0');
INSERT INTO `prerusenia` VALUES ('9', 'Dovolenka', 'D', '0', '1', '0.00', '1', '0.00', '1', '0', '1', '0', '0');
INSERT INTO `prerusenia` VALUES ('10', 'Obed', 'O', '0', '0', '0.00', '0', '0.00', '0', '0', '0', '0', '0');
INSERT INTO `prerusenia` VALUES ('11', 'Fajčenie', 'F', '0', '0', '0.00', '0', '0.00', '0', '0', '0', '0', '0');
INSERT INTO `prerusenia` VALUES ('12', 'Lekár doprovod', 'LD', '0', '1', '0.00', '1', '0.00', '1', '0', '1', '0', '0');
INSERT INTO `prerusenia` VALUES ('13', 'Príchod/Odchod', '', '1', '0', '0.00', '0', '0.00', '0', '0', '0', '0', '0');
INSERT INTO `prerusenia` VALUES ('14', 'OČR', 'OČR', '0', '1', '0.00', '0', '0.00', '1', '0', '1', '0', '0');
INSERT INTO `prerusenia` VALUES ('15', 'PN', 'PN', '0', '0', '0.00', '0', '0.00', '1', '0', '1', '0', '0');
-- ----------------------------
-- Table structure for `priestor`
-- ----------------------------
DROP TABLE IF EXISTS `priestor`;
CREATE TABLE `priestor` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`nazov` varchar(25) DEFAULT '',
`parent` int(8) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index` (`parent`,`id`,`nazov`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of priestor
-- ----------------------------
-- ----------------------------
-- Table structure for `proddelenie`
-- ----------------------------
DROP TABLE IF EXISTS `proddelenie`;
CREATE TABLE `proddelenie` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`id_pr` int(2) NOT NULL DEFAULT '0',
`id_oddelenie` int(10) NOT NULL DEFAULT '0',
`prac` int(1) NOT NULL DEFAULT '0',
`dozaciatku` int(1) NOT NULL DEFAULT '1',
`zaciatokplus` float(3,2) NOT NULL DEFAULT '0.00',
`dokonca` int(1) NOT NULL DEFAULT '1',
`dokoncaplus` float(3,2) NOT NULL DEFAULT '0.00',
`priznak` int(1) NOT NULL DEFAULT '1',
`priznakpodla` int(1) NOT NULL DEFAULT '0',
`saldo` int(1) NOT NULL DEFAULT '0',
`zaok` int(3) DEFAULT '0',
`drzat_weekend` int(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `indexi` (`id_pr`,`id_oddelenie`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of proddelenie
-- ----------------------------
-- ----------------------------
-- Table structure for `setup`
-- ----------------------------
DROP TABLE IF EXISTS `setup`;
CREATE TABLE `setup` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`fy` int(5) NOT NULL DEFAULT '0',
`oddelenie` int(10) NOT NULL DEFAULT '0',
`sm1_od` varchar(4) NOT NULL DEFAULT '0600',
`sm1_do` varchar(4) NOT NULL DEFAULT '1400',
`sm2_od` varchar(4) NOT NULL DEFAULT '1400',
`sm2_do` varchar(4) NOT NULL DEFAULT '2200',
`sm3_od` varchar(4) NOT NULL DEFAULT '2200',
`sm3_do` varchar(4) NOT NULL DEFAULT '0600',
`sm2` int(1) NOT NULL DEFAULT '0',
`sm3` int(1) NOT NULL DEFAULT '0',
`obed_auto` char(1) NOT NULL DEFAULT '0',
`obed_od` float NOT NULL DEFAULT '4',
`obed_cas` int(3) NOT NULL DEFAULT '30',
`sm4_od` varchar(4) NOT NULL DEFAULT '',
`sm4_do` varchar(4) NOT NULL DEFAULT '',
`sm4` int(1) NOT NULL DEFAULT '0',
`zaok` int(1) NOT NULL DEFAULT '1',
`nocne` int(1) NOT NULL DEFAULT '0',
`ibavramci` int(2) DEFAULT '0',
`sm1_obed_od` varchar(4) NOT NULL DEFAULT '1100',
`sm1_obed_do` varchar(4) NOT NULL DEFAULT '1300',
`prenos_nadcas_week` int(1) NOT NULL DEFAULT '1',
`ibavramcipred` int(2) DEFAULT '0',
`dovolenka` int(1) NOT NULL DEFAULT '0',
`max_v_praci` int(2) NOT NULL DEFAULT '14',
`nocna_zobrazenie` int(1) NOT NULL DEFAULT '0',
`neuznat_prvych` int(8) DEFAULT '0',
`stahovat_za` int(8) DEFAULT '0',
`stahovat_kolko` int(8) DEFAULT '0',
`nocna_presun` int(1) DEFAULT '0',
`stahovat_max` int(5) DEFAULT '600',
`nozmena` int(1) NOT NULL DEFAULT '0',
`nocna_prestavky` int(1) NOT NULL DEFAULT '0',
`odratat_odpr` int(5) DEFAULT '0',
`zaokpo` int(1) DEFAULT '1',
`prenos_nadcas` int(1) DEFAULT '0',
`obed_od2` float DEFAULT '20',
`obed_pokuta` int(5) NOT NULL DEFAULT '0',
`prenos_nadcas_typ` int(1) NOT NULL DEFAULT '0',
`vzdy_zmena1` int(1) DEFAULT '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=cp1250 COMMENT='Nastavenia dochádzky';
-- ----------------------------
-- Records of setup
-- ----------------------------
INSERT INTO `setup` VALUES ('40', '0', '0', '0600', '1400', '1400', '2200', '2200', '0600', '0', '0', '0', '4', '30', '', '', '0', '1', '0', '0', '1100', '1300', '1', '0', '0', '14', '0', '0', '0', '0', '0', '600', '0', '0', '0', '1', '0', '20', '0', '0', '0');
-- ----------------------------
-- Table structure for `smeny`
-- ----------------------------
DROP TABLE IF EXISTS `smeny`;
CREATE TABLE `smeny` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`fy` int(5) NOT NULL,
`id_doch` varchar(8) NOT NULL,
`nazov` varchar(255) NOT NULL,
`prac_doba` float NOT NULL,
`sm_od` varchar(4) DEFAULT NULL,
`sm_do` varchar(4) DEFAULT NULL,
`sm_pohod` varchar(4) DEFAULT NULL,
`sm_pohdo` varchar(4) DEFAULT NULL,
`datum` varchar(8) DEFAULT NULL,
`typ_dna` varchar(1) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `datum` (`datum`),
KEY `id_doch` (`id_doch`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of smeny
-- ----------------------------
-- ----------------------------
-- Table structure for `snimace`
-- ----------------------------
DROP TABLE IF EXISTS `snimace`;
CREATE TABLE `snimace` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`nazov` varchar(31) DEFAULT '',
`vstup` int(8) DEFAULT '0',
`vystup` int(8) DEFAULT '0',
`ignorovat` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index` (`vstup`,`id`,`vystup`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of snimace
-- ----------------------------
-- ----------------------------
-- Table structure for `spravy`
-- ----------------------------
DROP TABLE IF EXISTS `spravy`;
CREATE TABLE `spravy` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`odkoho` varchar(255) DEFAULT NULL,
`sprava` text,
`id_doch` varchar(8) DEFAULT NULL,
`odoslane` varchar(14) NOT NULL DEFAULT '',
`precitane` varchar(14) DEFAULT NULL,
`fy` int(5) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of spravy
-- ----------------------------
-- ----------------------------
-- Table structure for `sviatok`
-- ----------------------------
DROP TABLE IF EXISTS `sviatok`;
CREATE TABLE `sviatok` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`fy` int(5) NOT NULL DEFAULT '0',
`datum` varchar(8) NOT NULL DEFAULT '',
`nazov` varchar(255) NOT NULL DEFAULT '',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=147 DEFAULT CHARSET=cp1250 COMMENT='Zoznam sviatkov';
-- ----------------------------
-- Records of sviatok
-- ----------------------------
INSERT INTO `sviatok` VALUES ('2', '4', '20070101', 'Deň vzniku Slovenskej Republiky');
INSERT INTO `sviatok` VALUES ('3', '4', '20070106', 'Zjavenie pána');
INSERT INTO `sviatok` VALUES ('4', '4', '20070406', 'Veľký piatok');
INSERT INTO `sviatok` VALUES ('5', '4', '20070409', 'Veľkonočný pondelok');
INSERT INTO `sviatok` VALUES ('6', '4', '20070501', 'Sviatok práce');
INSERT INTO `sviatok` VALUES ('7', '4', '20070508', 'Deň víťaztva nad fašizmom');
INSERT INTO `sviatok` VALUES ('8', '4', '20070705', 'Sviatok svätého Cyrila a svätého Metoda');
INSERT INTO `sviatok` VALUES ('9', '4', '20070829', 'Výročie SNP');
INSERT INTO `sviatok` VALUES ('10', '4', '20070901', 'Deň ústavy Slovenskej Republiky');
INSERT INTO `sviatok` VALUES ('11', '4', '20070915', 'Sedembolestná Panna Mária');
INSERT INTO `sviatok` VALUES ('12', '4', '20071101', 'Sviatok všetkých svätých');
INSERT INTO `sviatok` VALUES ('13', '4', '20071117', 'Deň boja za slobodu a demokraciu');
INSERT INTO `sviatok` VALUES ('14', '4', '20071224', 'Štedrý deň');
INSERT INTO `sviatok` VALUES ('15', '4', '20071225', 'Prvý sviatok vianočný');
INSERT INTO `sviatok` VALUES ('16', '4', '20071226', 'Druhý sviatok vianočný');
INSERT INTO `sviatok` VALUES ('17', '4', '20080101', 'Deň vzniku Slovenskej Republiky');
INSERT INTO `sviatok` VALUES ('139', '5', '20100829', 'Výročie Slovenského národného povstania');
INSERT INTO `sviatok` VALUES ('138', '5', '20100705', 'Sviatok svätého Cyrila a Metoda');
INSERT INTO `sviatok` VALUES ('136', '5', '20100501', 'Sviatok práce');
INSERT INTO `sviatok` VALUES ('24', '1', '20070411', 'test s1');
INSERT INTO `sviatok` VALUES ('25', '4', '20080106', 'Traja králi');
INSERT INTO `sviatok` VALUES ('26', '4', '20080321', 'Veľký piatok');
INSERT INTO `sviatok` VALUES ('27', '4', '20080323', 'Veľkonočná nedeľa');
INSERT INTO `sviatok` VALUES ('28', '4', '20080324', 'Veľkonočný pondelok');
INSERT INTO `sviatok` VALUES ('29', '4', '20080501', 'Sviatok práce');
INSERT INTO `sviatok` VALUES ('30', '4', '20080508', 'Deň víťazstva nad fašizmom');
INSERT INTO `sviatok` VALUES ('31', '4', '20080705', 'Sviatok sv. Cyrila a sv. Metoda');
INSERT INTO `sviatok` VALUES ('32', '4', '20080829', 'Výročie SNP (1944)');
INSERT INTO `sviatok` VALUES ('33', '4', '20080901', 'Deň Ústavy SR');
INSERT INTO `sviatok` VALUES ('34', '4', '20080915', 'Sedembolestná Panna Mária');
INSERT INTO `sviatok` VALUES ('35', '4', '20081101', 'Sviatok všetkých svätých');
INSERT INTO `sviatok` VALUES ('36', '4', '20081117', 'Deň boja za slobodu a demokraciu');
INSERT INTO `sviatok` VALUES ('37', '4', '20081224', 'Štedrý deň');
INSERT INTO `sviatok` VALUES ('38', '4', '20081225', '1. sviatok vianočný');
INSERT INTO `sviatok` VALUES ('39', '4', '20081226', '2. sviatok vianočný');
INSERT INTO `sviatok` VALUES ('40', '4', '20090101', 'Nový rok, Deň vzniku SR');
INSERT INTO `sviatok` VALUES ('137', '5', '20100508', 'Deň víťazstva nad fašizmom');
INSERT INTO `sviatok` VALUES ('135', '5', '20100405', 'Marec Veľkonočný pondelok');
INSERT INTO `sviatok` VALUES ('134', '5', '20100402', 'Marec Veľký piatok');
INSERT INTO `sviatok` VALUES ('133', '5', '20100106', 'Zjavenie Pána');
INSERT INTO `sviatok` VALUES ('132', '5', '20100101', 'Deň vzniku Slovenskej republiky');
INSERT INTO `sviatok` VALUES ('131', '5', '20091226', 'December Druhý sviatok vianočný');
INSERT INTO `sviatok` VALUES ('129', '5', '20091224', 'December Štedrý deň');
INSERT INTO `sviatok` VALUES ('130', '5', '20091225', 'December Prvý sviatok vianočný');
INSERT INTO `sviatok` VALUES ('128', '5', '20091117', 'Deň boja za slobodu a demokraciu');
INSERT INTO `sviatok` VALUES ('127', '5', '20091101', 'Sviatok všetkých svätých');
INSERT INTO `sviatok` VALUES ('126', '5', '20090915', 'Sedembolestná Panna Mária');
INSERT INTO `sviatok` VALUES ('125', '5', '20090901', 'Deň ústavy Slovenskej republiky');
INSERT INTO `sviatok` VALUES ('124', '5', '20090829', 'Výročie Slovenského národného povstania');
INSERT INTO `sviatok` VALUES ('123', '5', '20090705', 'Sviatok svätého Cyrila a Metoda');
INSERT INTO `sviatok` VALUES ('122', '5', '20090508', 'Deň víťazstva nad fašizmom');
INSERT INTO `sviatok` VALUES ('121', '5', '20090501', 'Sviatok práce');
INSERT INTO `sviatok` VALUES ('120', '5', '20090413', 'Marec Veľkonočný pondelok');
INSERT INTO `sviatok` VALUES ('119', '5', '20090410', 'Marec Veľký piatok');
INSERT INTO `sviatok` VALUES ('118', '5', '20090106', 'Zjavenie Pána');
INSERT INTO `sviatok` VALUES ('117', '5', '20090101', 'Deň vzniku Slovenskej republiky');
INSERT INTO `sviatok` VALUES ('116', '5', '20081226', 'December Druhý sviatok vianočný');
INSERT INTO `sviatok` VALUES ('115', '5', '20081225', 'December Prvý sviatok vianočný');
INSERT INTO `sviatok` VALUES ('114', '5', '20081224', 'December Štedrý deň');
INSERT INTO `sviatok` VALUES ('113', '5', '20081117', 'Deň boja za slobodu a demokraciu');
INSERT INTO `sviatok` VALUES ('112', '5', '20081101', 'Sviatok všetkých svätých');
INSERT INTO `sviatok` VALUES ('111', '5', '20080915', 'Sedembolestná Panna Mária');
INSERT INTO `sviatok` VALUES ('110', '5', '20080901', 'Deň ústavy Slovenskej republiky');
INSERT INTO `sviatok` VALUES ('109', '5', '20080829', 'Výročie Slovenského národného povstania');
INSERT INTO `sviatok` VALUES ('108', '5', '20080705', 'Sviatok svätého Cyrila a Metoda');
INSERT INTO `sviatok` VALUES ('107', '5', '20080508', 'Deň víťazstva nad fašizmom');
INSERT INTO `sviatok` VALUES ('106', '5', '20080501', 'Sviatok práce');
INSERT INTO `sviatok` VALUES ('105', '5', '20080324', 'Marec Veľkonočný pondelok');
INSERT INTO `sviatok` VALUES ('104', '5', '20080321', 'Marec Veľký piatok');
INSERT INTO `sviatok` VALUES ('103', '5', '20080106', 'Zjavenie Pána');
INSERT INTO `sviatok` VALUES ('102', '5', '20080101', 'Deň vzniku Slovenskej republiky');
INSERT INTO `sviatok` VALUES ('140', '5', '20100901', 'Deň ústavy Slovenskej republiky');
INSERT INTO `sviatok` VALUES ('141', '5', '20100915', 'Sedembolestná Panna Mária');
INSERT INTO `sviatok` VALUES ('142', '5', '20101101', 'Sviatok všetkých svätých');
INSERT INTO `sviatok` VALUES ('143', '5', '20101117', 'Deň boja za slobodu a demokraciu');
INSERT INTO `sviatok` VALUES ('144', '5', '20101224', 'December Štedrý deň');
INSERT INTO `sviatok` VALUES ('145', '5', '20101225', 'December Prvý sviatok vianočný');
INSERT INTO `sviatok` VALUES ('146', '5', '20101226', 'December Druhý sviatok vianočný');
-- ----------------------------
-- Table structure for `terminal`
-- ----------------------------
DROP TABLE IF EXISTS `terminal`;
CREATE TABLE `terminal` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nazov` varchar(255) DEFAULT NULL,
`pridane` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`terminal_id` varchar(255) DEFAULT NULL,
`mac` varchar(12) DEFAULT NULL,
`jazyk` varchar(20) NOT NULL DEFAULT 'Slovak',
`predvolene` varchar(255) DEFAULT 'C',
`nastavenia` varchar(255) DEFAULT '',
`povolene` varchar(255) DEFAULT '-C-;C+Fa;C+Fi;-Fa-;-Fi-',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of terminal
-- ----------------------------
-- ----------------------------
-- Table structure for `uzivatelia`
-- ----------------------------
DROP TABLE IF EXISTS `uzivatelia`;
CREATE TABLE `uzivatelia` (
`uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fy` varchar(5) NOT NULL DEFAULT '',
`login` varchar(15) NOT NULL DEFAULT '',
`heslo` varchar(15) NOT NULL DEFAULT '',
`md5hash` varchar(32) NOT NULL DEFAULT '',
`meno` varchar(15) NOT NULL DEFAULT '',
`priez` varchar(15) NOT NULL DEFAULT '',
`prava` int(3) NOT NULL DEFAULT '3',
`oddelenie` varchar(255) DEFAULT '0',
UNIQUE KEY `uid` (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of uzivatelia
-- ----------------------------
INSERT INTO `uzivatelia` VALUES ('1', '5', 'admin', '', '21232f297a57a5a743894a0e4a801fc3', 'Admin', 'Admin', '1', '0');
-- ----------------------------
-- Table structure for `vratnica`
-- ----------------------------
DROP TABLE IF EXISTS `vratnica`;
CREATE TABLE `vratnica` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`nazov` varchar(255) DEFAULT NULL,
`pridane` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of vratnica
-- ----------------------------
-- ----------------------------
-- Table structure for `vratnica_link`
-- ----------------------------
DROP TABLE IF EXISTS `vratnica_link`;
CREATE TABLE `vratnica_link` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`voz` int(11) NOT NULL,
`oso` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `index` (`voz`,`oso`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of vratnica_link
-- ----------------------------
-- ----------------------------
-- Table structure for `vratnica_obch`
-- ----------------------------
DROP TABLE IF EXISTS `vratnica_obch`;
CREATE TABLE `vratnica_obch` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`datum` varchar(14) DEFAULT '',
`bod` varchar(25) DEFAULT '',
`oso` varchar(25) DEFAULT '',
PRIMARY KEY (`id`),
KEY `index` (`datum`,`oso`,`id`,`bod`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of vratnica_obch
-- ----------------------------
-- ----------------------------
-- Table structure for `vratnica_obch_nazov`
-- ----------------------------
DROP TABLE IF EXISTS `vratnica_obch_nazov`;
CREATE TABLE `vratnica_obch_nazov` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bod` varchar(25) DEFAULT '',
`nazov` varchar(25) DEFAULT '',
PRIMARY KEY (`id`),
KEY `index` (`bod`,`id`,`nazov`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of vratnica_obch_nazov
-- ----------------------------
-- ----------------------------
-- Table structure for `vratnica_oso`
-- ----------------------------
DROP TABLE IF EXISTS `vratnica_oso`;
CREATE TABLE `vratnica_oso` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`titl` varchar(25) DEFAULT '',
`meno` varchar(25) DEFAULT '',
`priez` varchar(25) DEFAULT '',
`cd` varchar(25) DEFAULT '',
`typd` varchar(3) DEFAULT '',
`zakym` varchar(25) DEFAULT '',
`id_doch` varchar(8) DEFAULT '',
`dovod` int(1) DEFAULT '0',
`doprovod` int(2) DEFAULT '0',
`poznamka` text,
`ec` varchar(25) DEFAULT '',
`vpustil` varchar(25) DEFAULT '',
`vpustil_cas` varchar(14) DEFAULT '',
`vpustil_vratnica` varchar(25) DEFAULT '',
`vypustil` varchar(25) DEFAULT '',
`vypustil_cas` varchar(14) DEFAULT '',
`vypustil_vratnica` varchar(25) DEFAULT '',
PRIMARY KEY (`id`),
KEY `index` (`priez`,`cd`,`id`,`ec`,`vpustil_cas`,`vypustil_cas`,`dovod`,`zakym`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of vratnica_oso
-- ----------------------------
-- ----------------------------
-- Table structure for `vratnica_voz`
-- ----------------------------
DROP TABLE IF EXISTS `vratnica_voz`;
CREATE TABLE `vratnica_voz` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ec` varchar(10) DEFAULT '',
`stat` varchar(2) DEFAULT '',
`druh` varchar(25) DEFAULT '',
`znacka` varchar(25) DEFAULT '',
`model` varchar(25) DEFAULT NULL,
`farba` varchar(25) DEFAULT '',
`poznamka` text,
`vpustil` varchar(25) DEFAULT '',
`vpustil_cas` varchar(14) DEFAULT '',
`vpustil_vratnica` varchar(25) DEFAULT '',
`vypustil` varchar(25) DEFAULT '',
`vypustil_cas` varchar(14) DEFAULT '',
`vypustil_vratnica` varchar(25) DEFAULT '',
PRIMARY KEY (`id`),
KEY `index` (`id`,`ec`,`vpustil_cas`,`vypustil_cas`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of vratnica_voz
-- ----------------------------
-- ----------------------------
-- Table structure for `vypocitane`
-- ----------------------------
DROP TABLE IF EXISTS `vypocitane`;
CREATE TABLE `vypocitane` (
`id` int(25) NOT NULL AUTO_INCREMENT,
`id_doch` varchar(8) NOT NULL,
`datum` varchar(8) NOT NULL,
`pr0` time DEFAULT NULL,
`pr1` time DEFAULT NULL,
`pr2` time DEFAULT NULL,
`pr3` time DEFAULT NULL,
`pr4` time DEFAULT NULL,
`pr5` time DEFAULT NULL,
`pr6` time DEFAULT NULL,
`pr7` time DEFAULT NULL,
`pr8` time DEFAULT NULL,
`pr9` time DEFAULT NULL,
`pr10` time DEFAULT NULL,
`pr11` time DEFAULT NULL,
`pr12` time DEFAULT NULL,
`pr13` time DEFAULT NULL,
`pr14` time DEFAULT NULL,
`pr15` time DEFAULT NULL,
`obed` int(1) DEFAULT NULL,
`obednarok` int(1) DEFAULT NULL,
`prichod` datetime DEFAULT NULL,
`odchod` datetime DEFAULT NULL,
`celkom` time DEFAULT NULL,
`odpracovane` time DEFAULT NULL,
`nadcas` time DEFAULT NULL,
`nocna` time DEFAULT NULL,
`smena` varchar(10) DEFAULT NULL,
`fy` int(5) DEFAULT NULL,
`farba` varchar(10) NOT NULL DEFAULT '',
`typdna` varchar(1) NOT NULL DEFAULT '',
`denvtyzdni` varchar(10) NOT NULL DEFAULT '',
`stavdna` varchar(10) NOT NULL DEFAULT '',
`prerusenia_string` varchar(255) DEFAULT '',
`pr0p` int(1) NOT NULL DEFAULT '0',
`pr1p` int(1) NOT NULL DEFAULT '0',
`pr2p` int(1) NOT NULL DEFAULT '0',
`pr3p` int(1) NOT NULL DEFAULT '0',
`pr4p` int(1) NOT NULL DEFAULT '0',
`pr5p` int(1) NOT NULL DEFAULT '0',
`pr6p` int(1) NOT NULL DEFAULT '0',
`pr7p` int(1) NOT NULL DEFAULT '0',
`pr8p` int(1) NOT NULL DEFAULT '0',
`pr9p` int(1) NOT NULL DEFAULT '0',
`pr10p` int(1) NOT NULL DEFAULT '0',
`pr11p` int(1) NOT NULL DEFAULT '0',
`pr12p` int(1) NOT NULL DEFAULT '0',
`pr13p` int(1) NOT NULL DEFAULT '0',
`pr14p` int(1) NOT NULL DEFAULT '0',
`pr15p` int(1) NOT NULL DEFAULT '0',
`nocna_prenos` time DEFAULT NULL,
`upravil` varchar(100) DEFAULT '',
`prichod_skutocny` datetime DEFAULT '0001-01-01 00:00:00',
`odchod_skutocny` datetime DEFAULT '0001-01-01 00:00:00',
`skontrolovane` varchar(50) NOT NULL DEFAULT '',
`uzamknute` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `index` (`id_doch`,`datum`,`fy`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of vypocitane
-- ----------------------------
-- ----------------------------
-- Table structure for `zoznam_smien`
-- ----------------------------
DROP TABLE IF EXISTS `zoznam_smien`;
CREATE TABLE `zoznam_smien` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`fy` int(5) NOT NULL,
`id_zoznam_smien_nazov` int(15) NOT NULL,
`nazov` varchar(255) NOT NULL,
`prac_doba` float NOT NULL,
`sm_od` varchar(4) DEFAULT NULL,
`sm_do` varchar(4) DEFAULT NULL,
`sm_pohod` varchar(4) DEFAULT NULL,
`sm_pohdo` varchar(4) DEFAULT NULL,
`den` int(2) DEFAULT NULL,
`typ_dna` varchar(1) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of zoznam_smien
-- ----------------------------
-- ----------------------------
-- Table structure for `zoznam_smien_nazov`
-- ----------------------------
DROP TABLE IF EXISTS `zoznam_smien_nazov`;
CREATE TABLE `zoznam_smien_nazov` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`fy` int(5) NOT NULL,
`nazov` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1250;
-- ----------------------------
-- Records of zoznam_smien_nazov
-- ----------------------------
DELIMITER ;;
CREATE TRIGGER `t_insert` AFTER INSERT ON `history` FOR EACH ROW BEGIN INSERT INTO fronta SET fy=new.fy, id_doch=new.id_doch, datum=SUBSTRING(new.datum, 1, 8) ON DUPLICATE KEY UPDATE fy=new.fy;END
;;
DELIMITER ;
DELIMITER ;;
CREATE TRIGGER `t_update_before` BEFORE UPDATE ON `history` FOR EACH ROW BEGIN INSERT INTO fronta SET fy=old.fy, id_doch=old.id_doch, datum=SUBSTRING(old.datum, 1, 8) ON DUPLICATE KEY UPDATE fy=old.fy;END
;;
DELIMITER ;
DELIMITER ;;
CREATE TRIGGER `t_update_after` AFTER UPDATE ON `history` FOR EACH ROW BEGIN INSERT INTO fronta SET fy=new.fy, id_doch=new.id_doch, datum=SUBSTRING(new.datum, 1, 8) ON DUPLICATE KEY UPDATE fy=new.fy;END
;;
DELIMITER ;
DELIMITER ;;
CREATE TRIGGER `t_delete_v2` BEFORE DELETE ON `history` FOR EACH ROW BEGIN INSERT INTO fronta SET fy=old.fy, id_doch=old.id_doch, datum=SUBSTRING(old.datum, 1, 8) ON DUPLICATE KEY UPDATE fy=old.fy; INSERT INTO history_old SET id_doch=old.id_doch, pr=old.pr, typ=old.typ, datum=old.datum, fy=old.fy, vlozil=old.vlozil, pozn=old.pozn, manual=old.manual, zmazane=NOW();END
;;
DELIMITER ;