131
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`servOFyear-3`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`servOFyear-3` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `servOFyear-3` AS SELECT * FROM kcson.main m where year(m.vdate) = (year(current_date())-
3);
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`servOFyear-1`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`servOFyear-1`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`servOFyear-1` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `servOFyear-1` AS SELECT * FROM kcson.main m where year(m.vdate) = (year(current_date())-
1);
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`fioOFdepBYset`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`fioOFdepBYset`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`fioOFdepBYset` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `fioOFdepBYset` AS SELECT
ufio, ufio_short,ufiobirth,ESRN,ufioDeath
FROM ufio
where id in (
select ufio.id from main
INNER JOIN ufio
ON main.ufio_id = ufio.id
INNER JOIN dep
ON main.dep_id = dep.id
where main.cr_by = GET_wID( )
);
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`dep_has_ufio_by_ripso`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`dep_has_ufio_by_ripso`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`dep_has_ufio_by_ripso` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `dep_has_ufio_by_ripso` AS
select * from ufio
where id in (
select ufio_id from contracts c inner join dep_has_ripso rod on rod.ripso_id = c.ripso_id
where rod.dep_id=GET_DEP(GET_wID())
);
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`dep_has_ufio`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`dep_has_ufio`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`dep_has_ufio` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `dep_has_ufio` AS
select * from ufio
where id in (
132
select ufio_id from contracts c
where c.dep_id=GET_DEP(GET_wID())
);
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`worker_has_dep`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`worker_has_dep`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`worker_has_dep` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `worker_has_dep` AS
SELECT
dw.dep_id, d.dep
FROM
dep_has_worker dw
INNER JOIN
dep d ON d.id = dw.dep_id
INNER JOIN
worker w ON dw.worker_id = w.id
WHERE
dw.worker_id = GET_WID()
AND dw.archive = 0;
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`dep_has_serv`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`dep_has_serv`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`dep_has_serv` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `dep_has_serv` AS select s.*
from
serv s inner join dep_has_ripso dhr
inner join ripso_has_serv rhs
on rhs.ripso_id = dhr.ripso_id
on rhs.serv_id=s.id
where dhr.dep_id = GET_DEP(GET_wID());
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`main_cprice`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`main_cprice`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`main_cprice` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `main_cprice` AS
SELECT
*, perc * uslnum * price as to_pay, perc * uslnum * price2 as to_pay2
FROM
(SELECT
m.*,
(SELECT
perc
FROM
add_info pd
WHERE
pddate <= m.vdate
AND contracts_id = m.contracts_id
ORDER BY pddate ASC
LIMIT 1) AS perc,
price,
price2,
133
price3
FROM
(main m
INNER JOIN serv ON m.serv_id = serv.id)
INNER JOIN contracts ON m.contracts_id = contracts.id) f;
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`main_NZ`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`main_NZ`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`main_NZ` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `main_NZ` AS select * from main where uslnum >0;
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`dep_total_serv`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`dep_total_serv`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`dep_total_serv` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `dep_total_serv` AS
SELECT
contracts_id,
dep_id,
serv_id,
worker_id,
SUM(uslnum),
MONTH(vdate),
YEAR(vdate)
FROM
main # main_cprice
GROUP BY contracts_id , dep_id , serv_id , worker_id;
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`dep_total_supserv1`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`dep_total_supserv1`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`dep_total_supserv1` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `dep_total_supserv1` AS
SELECT
contracts_id dep_id,
s.sub_serv worker_id,
SUM(uslnum),
mnth1,
year1
FROM
(SELECT
contracts_id,
dep_id,
serv_id,
worker_id,
SUM(uslnum) uslnum,
MONTH(vdate) mnth1,
YEAR(vdate) year1
FROM
main
GROUP BY contracts_id , dep_id , serv_id , worker_id) m
RIGHT JOIN
serv s ON m.serv_id = s.id;
134
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`exp_main`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`exp_main`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`exp_main` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `exp_main` AS
SELECT
s.id, u.ufio, s.tnum, w.worker, m.uslnum, m.vdate
FROM
main m
INNER JOIN
serv s ON m.serv_id = s.id
INNER JOIN
worker w ON m.worker_id = w.id
INNER JOIN
ufio u ON m.ufio_id = u.id
WHERE
m.dep_id = GET_DEP(GET_WID())
ORDER BY s.id;
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`view1`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`view1`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`view1` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `view1` AS
select ufio, worker
, MAX(CASE WHEN id = "C1" THEN uslnum END) "C1"
,
sum(uslnum)
from exp_main group by id, ufio, worker;
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`max_pay_in_month_50`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`max_pay_in_month_50`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`max_pay_in_month_50` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `max_pay_in_month_50` AS
SELECT
*, (sdd - (lm * 1.5)) / 2 AS max_pay
FROM
(SELECT
a.contracts_id,
c.ripso_id,
a.pddate,
a.sdd,
(SELECT
IF(a.work_livemin = 0, live_min_p, live_min_w) AS live_min
FROM
live_min
WHERE
a.pddate > lmdate
ORDER BY pddate ASC
LIMIT 1) AS lm
FROM
add_info a
135
INNER JOIN contracts c ON c.id = a.contracts_id
INNER JOIN ripso r ON r.id = c.ripso_id
WHERE
r.servform_id IN (1 , 2, 3)) t;
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`max_pay_in_month_75`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`max_pay_in_month_75`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`max_pay_in_month_75` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `max_pay_in_month_75` AS
SELECT
*, (sdd * 0.75) AS max_pay
FROM
(SELECT
a.contracts_id,
c.ripso_id,
a.pddate,
a.sdd,
(SELECT
IF(a.work_livemin = 0, live_min_p, live_min_w) AS live_min
FROM
live_min
WHERE
a.pddate > lmdate
ORDER BY pddate ASC
LIMIT 1) AS lm
FROM
add_info a
INNER JOIN contracts c ON c.id = a.contracts_id
INNER JOIN ripso r ON r.id = c.ripso_id
WHERE
r.servform_id IN (4)) t;
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`max_pay_in_month`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`max_pay_in_month`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`max_pay_in_month` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `max_pay_in_month` AS
select * from max_pay_in_month_75
union
select * from max_pay_in_month_50;
SHOW WARNINGS;
-- -----------------------------------------------------
-- View `kcson`.`total_cprice_in_month`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`total_cprice_in_month`;
SHOW WARNINGS;
DROP VIEW IF EXISTS `kcson`.`total_cprice_in_month` ;
SHOW WARNINGS;
USE `kcson`;
CREATE OR REPLACE VIEW `total_cprice_in_month` AS
SELECT
contracts_id, SUM(to_pay)
FROM
main_cprice
GROUP BY MONTH(vdate) , YEAR(vdate);
SHOW WARNINGS;
USE `kcson`;
136
DELIMITER $$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`ufio_BEFORE_INSERT` $$
SHOW WARNINGS$$
USE `kcson`$$
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`ufio_BEFORE_INSERT` BEFORE INSERT ON `ufio` FOR EACH ROW
BEGIN
set new.ufio=trim(new.ufio);
SET NEW.cr_by = get_wID();
SET NEW.upd_by = get_wID();
END$$
SHOW WARNINGS$$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`ufio_AFTER_INSERT` $$
SHOW WARNINGS$$
USE `kcson`$$
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`ufio_AFTER_INSERT` AFTER INSERT ON `ufio` FOR EACH ROW
BEGIN
insert into contracts (ufio_id,dep_id,blocked,startdate,enddate)
values (new.id, GET_DEP(GET_wID()),1,date(now()),date(now()));
# stub contract to assign fio to department
END$$
SHOW WARNINGS$$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`ufio_BEFORE_UPDATE` $$
SHOW WARNINGS$$
USE `kcson`$$
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`ufio_BEFORE_UPDATE` BEFORE UPDATE ON `ufio` FOR EACH ROW
BEGIN
set new.ufio=trim(new.ufio);
SET NEW.upd_by = get_wID();
END$$
SHOW WARNINGS$$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`contracts_BEFORE_INSERT` $$
SHOW WARNINGS$$
USE `kcson`$$
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`contracts_BEFORE_INSERT` BEFORE INSERT ON `contracts` FOR EACH
ROW
BEGIN
SET NEW.cr_by = get_wID();
IF (NEW.startdate IS NULL) THEN
SET NEW.startdate = now();
END IF;
IF (NEW.enddate IS NULL) THEN
SET NEW.enddate = now();
END IF;
END$$
SHOW WARNINGS$$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`contracts_BEFORE_UPDATE` $$
SHOW WARNINGS$$
USE `kcson`$$
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`contracts_BEFORE_UPDATE` BEFORE UPDATE ON `contracts` FOR
EACH ROW
BEGIN
SET NEW.upd_by = get_wID();
IF (NEW.startdate IS NULL) THEN
SET NEW.startdate = now();
END IF;
IF (NEW.enddate IS NULL) THEN
SET NEW.enddate = now();
137
END IF;
END$$
SHOW WARNINGS$$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`main_BEFORE_INSERT` $$
SHOW WARNINGS$$
USE `kcson`$$
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`main_BEFORE_INSERT` BEFORE INSERT ON `main` FOR EACH ROW
BEGIN
declare ovdid boolean;
INSERT INTO contracts_has_serv
SET
filled = new.uslnum,
contracts_id = new.contracts_id,
serv_id = new.serv_id
ON DUPLICATE KEY UPDATE
filled = filled + new.uslnum,
contracts_id = new.contracts_id,
serv_id = new.serv_id;
if CHECK_OVERDID(new.contracts_id, new.serv_id) < 0 then
SET NEW.overdid = True;
end if;
SET NEW.cr_by = get_wID();
END$$
SHOW WARNINGS$$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`main_BEFORE_UPDATE` $$
SHOW WARNINGS$$
USE `kcson`$$
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`main_BEFORE_UPDATE` BEFORE UPDATE ON `main` FOR EACH ROW
BEGIN
UPDATE contracts_has_serv set filled=filled+new.uslnum-old.uslnum,
contracts_id=new.contracts_id, serv_id=new.serv_id;
if CHECK_OVERDID(new.contracts_id, new.serv_id) < 0 then
SET NEW.overdid = True;
end if;
SET NEW.upd_by=get_wID();
END$$
SHOW WARNINGS$$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`main_AFTER_DELETE` $$
SHOW WARNINGS$$
USE `kcson`$$
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`main_AFTER_DELETE` AFTER DELETE ON `main` FOR EACH ROW
BEGIN
UPDATE contracts_has_serv set fill=fill-old.uslnum, contracts_id=old.contracts_id, serv_id=old.serv_id;
END$$
SHOW WARNINGS$$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`add_info_BEFORE_INSERT` $$
SHOW WARNINGS$$
USE `kcson`$$
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`add_info_BEFORE_INSERT` BEFORE INSERT ON `add_info` FOR EACH
ROW
BEGIN
SET NEW.cr_by = get_wID();
END$$
SHOW WARNINGS$$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`add_info_AFTER_INSERT` $$
SHOW WARNINGS$$
USE `kcson`$$
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`add_info_AFTER_INSERT` AFTER INSERT ON `add_info` FOR EACH
ROW
BEGIN
138
declare ripso int default 0;
set ripso = (select ripso_id from contracts where id=new.contracts_id);
if ripso > 0 then
insert into contracts_has_serv (serv_id, contracts_id, planned, archive)
select serv_id, new.contracts_id, planned,0 from ripso_has_serv where ripso_id=ripso;
# By default ippsu had all services - worker can change it later
end if;
END$$
SHOW WARNINGS$$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`add_info_BEFORE_UPDATE` $$
SHOW WARNINGS$$
USE `kcson`$$
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`add_info_BEFORE_UPDATE` BEFORE UPDATE ON `add_info` FOR
EACH ROW
BEGIN
SET NEW.upd_by = get_wID();
END$$
SHOW WARNINGS$$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`invoice_BEFORE_INSERT` $$
SHOW WARNINGS$$
USE `kcson`$$
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`invoice_BEFORE_INSERT` BEFORE INSERT ON `invoice` FOR EACH
ROW
BEGIN
SET NEW.cr_by = get_wID(CURRENT_USER);
END$$
SHOW WARNINGS$$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`invoice_BEFORE_UPDATE` $$
SHOW WARNINGS$$
USE `kcson`$$
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`invoice_BEFORE_UPDATE` BEFORE UPDATE ON `invoice` FOR EACH
ROW
BEGIN
SET NEW.upd_by = get_wID(CURRENT_USER);
END$$
SHOW WARNINGS$$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`invoice_has_payment_BEFORE_INSERT` $$
SHOW WARNINGS$$
USE `kcson`$$
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`invoice_has_payment_BEFORE_INSERT` BEFORE INSERT ON
`invoice_has_payment` FOR EACH ROW
BEGIN
declare inv int;
declare pay int;
# check duplicates
END$$
SHOW WARNINGS$$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`ufio_has_category_BEFORE_INSERT` $$
SHOW WARNINGS$$
USE `kcson`$$
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`ufio_has_category_BEFORE_INSERT` BEFORE INSERT ON
`ufio_has_category` FOR EACH ROW
BEGIN
SET NEW.upd_by = get_wID();
SET NEW.cr_by = get_wID();
END$$
SHOW WARNINGS$$
USE `kcson`$$
DROP TRIGGER IF EXISTS `kcson`.`ufio_has_category_BEFORE_UPDATE` $$
SHOW WARNINGS$$
USE `kcson`$$
139
CREATE DEFINER = CURRENT_USER TRIGGER `kcson`.`ufio_has_category_BEFORE_UPDATE` BEFORE UPDATE ON
`ufio_has_category` FOR EACH ROW
BEGIN
SET NEW.upd_by = get_wID();
END$$
SHOW WARNINGS$$
DELIMITER ;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
-- -----------------------------------------------------
-- Data for table `kcson`.`dep`
-- -----------------------------------------------------
START TRANSACTION;
USE `kcson`;
INSERT INTO `kcson`.`dep` (`id`, `dep`, `depFullName`, `note`, `archive`) VALUES (1, ' 1', ' ',
NULL, NULL);
COMMIT;
-- -----------------------------------------------------
-- Data for table `kcson`.`ufio`
-- -----------------------------------------------------
START TRANSACTION;
USE `kcson`;
INSERT INTO `kcson`.`ufio` (`id`, `ufio`, `ufio_short`, `ufioDeath`, `ufiobirth`, `ESRN`, `prim`, `phone`, `snils`, `curator`,
`create`, `ts`, `cr_by`, `upd_by`) VALUES (DEFAULT, ' ', ' ', NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kcson`.`ufio` (`id`, `ufio`, `ufio_short`, `ufioDeath`, `ufiobirth`, `ESRN`, `prim`, `phone`, `snils`, `curator`,
`create`, `ts`, `cr_by`, `upd_by`) VALUES (DEFAULT, ' 2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL);
COMMIT;
-- -----------------------------------------------------
-- Data for table `kcson`.`servform`
-- -----------------------------------------------------
START TRANSACTION;
USE `kcson`;
INSERT INTO `kcson`.`servform` (`id`, `servform`, `prim`) VALUES (1, ' ', NULL);
INSERT INTO `kcson`.`servform` (`id`, `servform`, `prim`) VALUES (2, '
', NULL);
INSERT INTO `kcson`.`servform` (`id`, `servform`, `prim`) VALUES (3, '
', NULL);
INSERT INTO `kcson`.`servform` (`id`, `servform`, `prim`) VALUES (4, '
', NULL);
COMMIT;
-- -----------------------------------------------------
-- Data for table `kcson`.`ripso`
-- -----------------------------------------------------
START TRANSACTION;
USE `kcson`;
INSERT INTO `kcson`.`ripso` (`id`, `ripso`, `year`, `archive`, `servform_id`, `months`) VALUES (1, '1', 2019, 1, 1, 12);
INSERT INTO `kcson`.`ripso` (`id`, `ripso`, `year`, `archive`, `servform_id`, `months`) VALUES (2, '2', 2019, 1, 2, 12);
INSERT INTO `kcson`.`ripso` (`id`, `ripso`, `year`, `archive`, `servform_id`, `months`) VALUES (3, '3', 2019, 1, 3, 2);
INSERT INTO `kcson`.`ripso` (`id`, `ripso`, `year`, `archive`, `servform_id`, `months`) VALUES (4, '4', 2019, 1, 4, 3);
INSERT INTO `kcson`.`ripso` (`id`, `ripso`, `year`, `archive`, `servform_id`, `months`) VALUES (5, '5', 2019, 1, 4, 12);
INSERT INTO `kcson`.`ripso` (`id`, `ripso`, `year`, `archive`, `servform_id`, `months`) VALUES (6, '6', 2019, 1, 1, 12);
INSERT INTO `kcson`.`ripso` (`id`, `ripso`, `year`, `archive`, `servform_id`, `months`) VALUES (7, '7', 2019, 1, 2, 12);
INSERT INTO `kcson`.`ripso` (`id`, `ripso`, `year`, `archive`, `servform_id`, `months`) VALUES (8, '8', 2019, 1, 3, 2);
INSERT INTO `kcson`.`ripso` (`id`, `ripso`, `year`, `archive`, `servform_id`, `months`) VALUES (9, '9', 2019, 1, 4, 3);
INSERT INTO `kcson`.`ripso` (`id`, `ripso`, `year`, `archive`, `servform_id`, `months`) VALUES (10, '14', 2019, 1, 1, 12);
INSERT INTO `kcson`.`ripso` (`id`, `ripso`, `year`, `archive`, `servform_id`, `months`) VALUES (11, '70', 2019, 1, 3, 12);
INSERT INTO `kcson`.`ripso` (`id`, `ripso`, `year`, `archive`, `servform_id`, `months`) VALUES (12, '71', 2019, 1, 3, 12);
COMMIT;
-- -----------------------------------------------------
-- Data for table `kcson`.`contracts`
-- -----------------------------------------------------
START TRANSACTION;
USE `kcson`;
140
INSERT INTO `kcson`.`contracts` (`id`, `contracts`, `ufio_id`, `dep_id`, `ripso_id`, `blocked`, `startdate`, `enddate`,
`ippsuNum`, `prim`, `create`, `ts`, `cr_by`, `upd_by`) VALUES (DEFAULT, '12312313', 1, 1, 1, 0, '2001-01-01', '2001-12-31',
NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kcson`.`contracts` (`id`, `contracts`, `ufio_id`, `dep_id`, `ripso_id`, `blocked`, `startdate`, `enddate`,
`ippsuNum`, `prim`, `create`, `ts`, `cr_by`, `upd_by`) VALUES (DEFAULT, '43434', 2, 1, 1, 0, '2001-01-01', '2001-12-31', NULL,
NULL, NULL, NULL, NULL, NULL);
COMMIT;
-- -----------------------------------------------------
-- Data for table `kcson`.`roles`
-- -----------------------------------------------------
START TRANSACTION;
USE `kcson`;
INSERT INTO `kcson`.`roles` (`id`, `role`, `prim`) VALUES (1, ' ', NULL);
COMMIT;
-- -----------------------------------------------------
-- Data for table `kcson`.`worker`
-- -----------------------------------------------------
START TRANSACTION;
USE `kcson`;
INSERT INTO `kcson`.`worker` (`id`, `worker`, `user`, `prim`, `roles_id`, `dep_id`, `archive`) VALUES (1, ' ', NULL,
NULL, DEFAULT, DEFAULT, NULL);
COMMIT;
-- -----------------------------------------------------
-- Data for table `kcson`.`holiday`
-- -----------------------------------------------------
START TRANSACTION;
USE `kcson`;
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-01-01', '');
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-01-02', '');
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-01-03', '');
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-01-04', '');
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-01-05', '');
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-01-06', '');
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-01-07', '');
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-01-08', '');
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-03-08', '');
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-05-01', '');
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-05-02', '');
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-05-03', '');
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-05-09', '');
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-05-10', '');
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-06-12', '');
INSERT INTO `kcson`.`holiday` (`holiday`, `prim`) VALUES ('2019-11-04', '');
COMMIT;
-- -----------------------------------------------------
-- Data for table `kcson`.`category`
-- -----------------------------------------------------
START TRANSACTION;
USE `kcson`;
INSERT INTO `kcson`.`category` (`id`, `category`, `archive`, `prim`, `total`, `subof`) VALUES (15, '', 0, NULL, 0, NULL);
INSERT INTO `kcson`.`category` (`id`, `category`, `archive`, `prim`, `total`, `subof`) VALUES (16, '', NULL, NULL, 0, 13);
INSERT INTO `kcson`.`category` (`id`, `category`, `archive`, `prim`, `total`, `subof`) VALUES (17, '-. ', NULL,
NULL, NULL, 14);
INSERT INTO `kcson`.`category` (`id`, `category`, `archive`, `prim`, `total`, `subof`) VALUES (18, '-. ', NULL,
NULL, NULL, 14);
INSERT INTO `kcson`.`category` (`id`, `category`, `archive`, `prim`, `total`, `subof`) VALUES (5, '', NULL, ' ',
NULL, NULL);
INSERT INTO `kcson`.`category` (`id`, `category`, `archive`, `prim`, `total`, `subof`) VALUES (6, '', NULL, '
. ', NULL, NULL);
INSERT INTO `kcson`.`category` (`id`, `category`, `archive`, `prim`, `total`, `subof`) VALUES (7, '', NULL, ' ',
NULL, 2);
INSERT INTO `kcson`.`category` (`id`, `category`, `archive`, `prim`, `total`, `subof`) VALUES (8, '', NULL, NULL, NULL, 2);
INSERT INTO `kcson`.`category` (`id`, `category`, `archive`, `prim`, `total`, `subof`) VALUES (9, '', NULL, NULL, NULL, 2);
INSERT INTO `kcson`.`category` (`id`, `category`, `archive`, `prim`, `total`, `subof`) VALUES (10, '', NULL, NULL, NULL, 2);
INSERT INTO `kcson`.`category` (`id`, `category`, `archive`, `prim`, `total`, `subof`) VALUES (13, ' ..', NULL, NULL,
NULL, 1);