9j63zvt3

1CREATE TABLE `zamestnanci` (
2  `r_cislo` varchar(11) NOT NULL,
3  `login` varchar(32) NOT NULL,
4  `pass` varchar(32) NOT NULL,
5  `meno` varchar(20) NOT NULL,
6  `priezvisko` varchar(20) NOT NULL,
7  `ulica` varchar(30) DEFAULT NULL,
8  `cislo` int(11) DEFAULT NULL,
9  `mesto` varchar(30) DEFAULT NULL,
10  `psc` char(5) DEFAULT NULL,
11  `plat` int(11) NOT NULL,
12  `veduci` bit(1) NOT NULL DEFAULT b'0'
13) ENGINE=InnoDB DEFAULT CHARSET=utf8;
14
15delimiter //
16
17DROP TRIGGER IF EXISTS triggerRC //
18
19CREATE TRIGGER triggerRC
20BEFORE INSERT ON zamestnanci
21FOR EACH ROW
22BEGIN
23    DECLARE RC varchar(11);
24    DECLARE TMP int;
25    DECLARE MESIAC int;
26    DECLARE DAT date;
27
28    SET RC = NEW.r_cislo;
29    SET MESIAC = TO_NUMBER(SUBSTR(RC, 3, 2));
30    SET TMP = TO_NUMBER(SUBSTR(RC, 1, 6));
31    IF (MESIAC > 12) THEN
32        SET TMP = TMP - 5000;
33    END IF;
34    SET DAT = TO_DATE( TMP , 'YYMMDD');
35    
36END triggerRC;
37//
38
39delimiter ;