Aktualizácia súborov v databáze

Nedele
Férie - Advent, Vianoce, Pôst a Veľká noc
Férie cez rok, cykl. I.
Férie cez rok, cykl. II.
Slávenia - 1.jan. až 31.dec.
Slávenia - spoločné
Rozličné príležitosti
Votívne

Výber kategórie

-- SQL--------------------------------------------------start------

-- Krok 1: Zmazanie stávajúcich súborov z vybranej kategórie

DELETE FROM `i_subory_spracovani` WHERE `kategoria_id` = 2;

-- Krok 2: Nahratie aktuálnych súborov v kategórií

-- kateg.: 2,
-- názov: Férie - Advent, Vianoce, Pôst a Veľká noc
-- adresár: adv_via_post_vnoc
-- súborov: 335

INSERT INTO `zalmy`.`i_subory_spracovani` (`kategoria_id`, `subor_nazov`) VALUES ('2', 'chr1okt_30dec__pf.pdf'), ('2', 'adv19dec__jk.odt'), ('2', 'post3t_6so__pf.pdf'), ('2', 'post1t_3st__pf.jpg'), ('2', 'adv02t_1po__jk.pdf'), ('2', 'post2t_1po__jk.jpg'), ('2', 'post4t_4st__pf.jpg'), ('2', 'adv21dec__pf.jpg'), ('2', 'velk5t_6so__pf.jpg'), ('2', 'chr3t_07jan_1po_po_ned3kraloch__jk.pdf'), ('2', 'velk7t_3st__pf.pdf'), ('2', 'post5t_4st__pf.jpg'), ('2', 'velk1t_2ut__jk.pdf'), ('2', 'adv03t_1po__jk.pdf'), ('2', 'velk3t_4st__ts.pdf'), ('2', 'velk6t_3st__pf.pdf'), ('2', 'post5t_5pi__pf.pdf'), ('2', 'velkXt_6so__st.pdf'), ('2', 'adv18dec.jpg'), ('2', 'velk5t_1po__jk.pdf'), ('2', 'adv22dec__st.odt'), ('2', 'post2t_4st__jh.pdf'), ('2', 'velk6t_6so__pf.jpg'), ('2', 'velk3t_2ut__jk.pdf'), ('2', 'chr3t_10jan_4st_po_ned3kraloch__jh.pdf'), ('2', 'post0t_4st__jh.pdf'), ('2', 'post0t_6so__pf.pdf'), ('2', 'adv02t_3st__pf.pdf'), ('2', 'post2t_3st__pf.jpg'), ('2', 'post5t_2ut__jk.jpg'), ('2', 'velk7t_1po__jk.pdf'), ('2', 'velk1t_4st__pf.pdf'), ('2', 'adv01t_6so__pf.jpg'), ('2', 'post1t_6so__pf.pdf'), ('2', 'adv22dec.jpg'), ('2', 'adv03t_3st__pf.pdf'), ('2', 'chr1okt_29dec__pf.jpg'), ('2', 'chr2t_2jan__jh.pdf'), ('2', 'velk6t_1po__jk.pdf'), ('2', 'post4t_2ut__jk.jpg'), ('2', 'velk7t_6so__pf.jpg'), ('2', 'velk0t_vig7c_bez_krstu.pdf'), ('2', 'velk3t_1po__jk.pdf'), ('2', 'adv17dec.jpg'), ('2', 'velk5t_5pi__pf.jpg'), ('2', 'post4t_6so__pf.pdf'), ('2', 'adv03t_4st.pdf'), ('2', 'velk7t_2ut__jk.pdf'), ('2', 'post5t_1po__jk.jpg'), ('2', 'adv03t_5pi__pf.jpg'), ('2', 'velk6t_2ut__jk.pdf'), ('2', 'adv02t_4st__pf.pdf'), ('2', 'velk0t_vig3c__jk.pdf'), ('2', 'adv20dec__jk.pdf'), ('2', 'chr2t_7jan_ak3krali_nedela__jk.pdf'), ('2', 'adv03t_5pi__jk.len_R.sib'), ('2', 'adv02t_5pi__pf.jpg'), ('2', 'velk1t_3st__pf.pdf'), ('2', 'velk3t_6so__pf.jpg'), ('2', 'post2t_5pi__pf.pdf'), ('2', 'adv02t_6so.pdf'), ('2', 'velk2t_1po__jk.pdf'), ('2', 'velk4t_6so__jh.pdf'), ('2', 'chr1okt_31dec__jk.jpg'), ('2', 'chr3t_08jan_2ut_po_ned3kraloch__jh.pdf'), ('2', 'post5t_6so__pf.pdf'), ('2', 'velk4t_5pi__pf.jpg'), ('2', 'velk1t_6so__pf.jpg'), ('2', 'post0t_5pi__pf.pdf'), ('2', 'chr3t_12jan_6so_po_ned3kraloch__pf.jpg'), ('2', 'chr3t_11jan_5pi_po_ned3kraloch__jh.pdf'), ('2', 'velk6t_5pi__pf.jpg'), ('2', 'post2t_2ut__jk.jpg'), ('2', 'adv02t_2ut__jk.pdf'), ('2', 'post1t_2ut__jk.odt'), ('2', 'velk7t_5pi__pf.jpg'), ('2', 'velk1t_1po__jk.pdf'), ('2', 'adv03t_2ut__jk.pdf'), ('2', 'post1t_5pi__pf.pdf'), ('2', 'velk5t_2ut__jk.pdf'), ('2', 'adv01t_4st__pf.pdf'), ('2', 'post1t_4st__pf.jpg'), ('2', 'velk6t_6so__jk.jpg'), ('2', 'post5t_4st__jk.odt'), ('2', 'post2t_3st__jk.jpg'), ('2', 'adv02t_3st__jk.pdf'), ('2', 'post0t_6so__jk.pdf'), ('2', 'velk1t_4st__jk.pdf'), ('2', 'velk7t_1po__pf.pdf'), ('2', 'post5t_2ut__pf.jpg'), ('2', 'adv01t_5pi.pdf'), ('2', 'chr1okt_29dec__jk.jpg'), ('2', 'adv03t_3st__jk.pdf'), ('2', 'post1t_6so__jk.pdf'), ('2', 'adv01t_6so__jk.jpg'), ('2', 'post4t_2ut__pf.jpg'), ('2', 'chr1okt_29dec__jk---old.pdf'), ('2', 'velk6t_1po__pf.pdf'), ('2', 'adv19dec__pf.jpg'), ('2', 'velk7t_6so__jk.jpg'), ('2', 'velk5t_3st__jk.pdf'), ('2', 'velk2t_4st__jk.pdf'), ('2', 'adv23dec.pdf'), ('2', 'post1t_3st__jk.jpg'), ('2', 'post3t_6so__jk.pdf'), ('2', 'chr1okt_30dec__jk.pdf'), ('2', 'post4t_4st__jk.jpg'), ('2', 'post2t_1po__pf.jpg'), ('2', 'post0t_3st__a.pdf'), ('2', 'adv02t_1po__pf.pdf'), ('2', 'velk7t_3st__jk.pdf'), ('2', 'chr3t_07jan_1po_po_ned3kraloch__pf.pdf'), ('2', 'velk5t_6so__jk.jpg'), ('2', 'adv21dec__jk.jpg'), ('2', 'adv03t_1po__pf.pdf'), ('2', 'velk1t_2ut__pf.pdf'), ('2', 'post3t_3st.jpg'), ('2', 'post5t_5pi__jk.pdf'), ('2', 'velk6t_3st__jk.pdf'), ('2', 'velk5t_1po__pf.pdf'), ('2', 'velk3t_4st__jk.pdf'), ('2', 'velk1t_1po.+aleluja.pdf'), ('2', 'chr3t_12jan_6so_po_ned3kraloch__jk.jpg'), ('2', 'adv22dec.pf.pdf'), ('2', 'velk1t_6so__jk.jpg'), ('2', 'post0t_5pi__jk.pdf'), ('2', 'velk4t_2ut__pf.pdf'), ('2', 'velk4t_2ut__pf.jk.pdf'), ('2', 'velk6t_5pi__jk.jpg'), ('2', 'velk0t_vig6c.pdf'), ('2', 'adv02t_2ut__pf.pdf'), ('2', 'post2t_2ut__pf.jpg'), ('2', 'velk7t_5pi__jk.jpg'), ('2', 'post4t_3st__jk.jpg'), ('2', 'adv23dec.pf.pdf'), ('2', 'velk7t_4st__jk.pdf'), ('2', 'adv03t_2ut__pf.pdf'), ('2', 'post1t_5pi__jk.pdf'), ('2', 'velk8t_4stB__dc.pdf'), ('2', 'post1t_4st__jk.jpg'), ('2', 'adv01t_4st__jk.pdf'), ('2', 'velk5t_2ut__pf.pdf'), ('2', 'adv01t_3st.pdf'), ('2', 'adv03t_5pi__jk.odt'), ('2', 'post1t_2ut__pf.jpg'), ('2', 'velk5t_4st__jk.pdf'), ('2', 'velk0t_vig2c.pdf'), ('2', 'velk5t_5pi__jk.jpg'), ('2', 'post4t_6so__jk.pdf'), ('2', 'post5t_1po__pf.jpg'), ('2', 'velk0t_vig1c_b.pdf'), ('2', 'velk7t_2ut__pf.pdf'), ('2', 'chr2t_7jan_ak3krali_nedela__pf.pdf'), ('2', 'adv20dec__pf.pdf'), ('2', 'adv02t_4st__jk.pdf'), ('2', 'velk6t_2ut__pf.pdf'), ('2', 'post2t_5pi__jk.pdf'), ('2', 'adv17dec.pf.jpg'), ('2', 'velk1t_3st__jk.pdf'), ('2', 'adv02t_5pi__jk.jpg'), ('2', 'velk4t_4st__jk.pdf'), ('2', 'chr1okt_31dec__pf.jpg'), ('2', 'post5t_3st__jk.odt'), ('2', 'post6t_5pi.+ev_vers.pdf'), ('2', 'velk2t_1po__pf.pdf'), ('2', 'post5t_6so__jk.pdf'), ('2', 'velk4t_5pi__jk.jpg'), ('2', 'velk8t_1po_pm__jg__skarede.jpg'), ('2', 'velk3t_2ut__jk.jpg'), ('2', 'velk6t_6so__pf.pdf'), ('2', 'velk1t_4st__pf.jpg'), ('2', 'adv22dec__st.pdf'), ('2', 'velk7t_1po__jk.jpg'), ('2', 'post5t_2ut__jk.pdf'), ('2', 'post2t_3st__pf.pdf'), ('2', 'post0t_6so__pf.jpg'), ('2', 'adv02t_3st__pf.jpg'), ('2', 'velkXt_6so__st.odt'), ('2', 'post4t_2ut__jk.pdf'), ('2', 'velk8t_4stA.pdf'), ('2', 'velk6t_1po__jk.jpg'), ('2', 'adv19dec__jk.pdf'), ('2', 'post1t_6so__pf.jpg'), ('2', 'adv22dec.pdf'), ('2', 'adv03t_3st__pf.jpg'), ('2', 'chr1okt_29dec__pf.pdf'), ('2', 'adv01t_6so__pf.pdf'), ('2', 'velk7t_6so__pf.pdf'), ('2', 'velk0t_vig1c_a.pdf'), ('2', 'post1t_3st__pf.pdf'), ('2', 'post3t_6so__pf.jpg'), ('2', 'chr1okt_30dec__pf.jpg'), ('2', 'chr3t_07jan_1po_po_ned3kraloch__jk.jpg'), ('2', 'velk7t_3st__pf.jpg'), ('2', 'adv21dec__pf.pdf'), ('2', 'velk5t_6so__pf.pdf'), ('2', 'adv01t_1po.pdf'), ('2', 'post4t_4st__pf.pdf'), ('2', 'post2t_1po__jk.pdf'), ('2', 'adv02t_1po__jk.jpg'), ('2', 'post5t_5pi__pf.jpg'), ('2', 'velk6t_3st__pf.jpg'), ('2', 'adv01t_2ut.pdf'), ('2', 'velk1t_2ut__jk.jpg'), ('2', 'adv03t_1po__jk.jpg'), ('2', 'post5t_4st__pf.pdf'), ('2', 'adv18dec.pdf'), ('2', 'velk5t_1po__jk.jpg'), ('2', 'chr3t_12jan_6so_po_ned3kraloch__pf.pdf'), ('2', 'velk0t_vig3c__jk.odt'), ('2', 'post0t_5pi__pf.jpg'), ('2', 'velk1t_6so__pf.pdf'), ('2', 'adv02t_2ut__jk.jpg'), ('2', 'post2t_2ut__jk.pdf'), ('2', 'velk0t_vig4c.pdf'), ('2', 'velk6t_5pi__pf.pdf'), ('2', 'chr2t_5jan.pdf'), ('2', 'velk1t_1po__jk.jpg'), ('2', 'adv03t_2ut__jk.jpg'), ('2', 'velk7t_5pi__pf.pdf'), ('2', 'post4t_3st__pf.pdf'), ('2', 'post1t_4st__pf.pdf'), ('2', 'adv01t_4st__pf.jpg'), ('2', 'velk5t_2ut__jk.jpg'), ('2', 'post1t_5pi__pf.jpg'), ('2', 'post0t_3st__b.pdf'), ('2', 'post4t_6so__pf.jpg'), ('2', 'velk5t_5pi__pf.pdf'), ('2', 'velk3t_1po__jk.jpg'), ('2', 'adv17dec.pdf'), ('2', 'post1t_2ut__jk.pdf'), ('2', 'adv03t_5pi__pf.pdf'), ('2', 'post5t_1po__jk.pdf'), ('2', 'velk7t_2ut__jk.jpg'), ('2', 'post2t_5pi__pf.jpg'), ('2', 'velk3t_6so__pf.pdf'), ('2', 'chr3t_09jan_3st_po_ned3kraloch__jh.pdf'), ('2', 'adv02t_5pi__pf.pdf'), ('2', 'velk1t_3st__pf.jpg'), ('2', 'chr2t_7jan_ak3krali_nedela__jk.jpg'), ('2', 'adv20dec__jk.jpg'), ('2', 'velk6t_2ut__jk.jpg'), ('2', 'velk4t_5pi__pf.pdf'), ('2', 'post5t_6so__pf.jpg'), ('2', 'chr1okt_31dec__jk.pdf'), ('2', 'velk2t_1po__jk.jpg'), ('2', 'chr1okt_30dec__jk.jpg'), ('2', 'post3t_6so__jk.jpg'), ('2', 'post1t_3st__jk.pdf'), ('2', 'adv23dec.jpg'), ('2', 'velk2t_4st__jk.jpg'), ('2', 'velk0t_vig5c.pdf'), ('2', 'velk5t_6so__jk.pdf'), ('2', 'adv21dec__jk.pdf'), ('2', 'chr2t_4jan__jh.pdf'), ('2', 'velk7t_3st__jk.jpg'), ('2', 'chr3t_07jan_1po_po_ned3kraloch__pf.jpg'), ('2', 'adv02t_1po__pf.jpg'), ('2', 'post2t_1po__pf.pdf'), ('2', 'post4t_4st__jk.pdf'), ('2', 'velk6t_3st__jk.jpg'), ('2', 'post3t_3st.pdf'), ('2', 'post5t_5pi__jk.jpg'), ('2', 'post4t_5pi.pdf'), ('2', 'post5t_4st__jk.pdf'), ('2', 'adv03t_1po__pf.jpg'), ('2', 'velk1t_2ut__pf.jpg'), ('2', 'velk0t_vig8epist.pdf'), ('2', 'velk5t_1po__pf.jpg'), ('2', 'velk0t_vig7c_s_krstom.pdf'), ('2', 'velk6t_6so__jk.pdf'), ('2', 'post5t_2ut__pf.pdf'), ('2', 'velk7t_1po__pf.jpg'), ('2', 'velk1t_4st__jk.jpg'), ('2', 'post4t_3st__sr.jpg'), ('2', 'adv02t_3st__jk.jpg'), ('2', 'post0t_6so__jk.jpg'), ('2', 'post2t_3st__jk.pdf'), ('2', 'adv19dec__pf.pdf'), ('2', 'velk6t_1po__pf.jpg'), ('2', 'post4t_2ut__pf.pdf'), ('2', 'velk8t_1po_pm__jg.pdf'), ('2', 'adv01t_6so__jk.pdf'), ('2', 'chr1okt_29dec__jk.pdf'), ('2', 'adv03t_3st__jk.jpg'), ('2', 'post1t_6so__jk.jpg'), ('2', 'velk5t_3st__jk.jpg'), ('2', 'velk7t_6so__jk.pdf'), ('2', 'post4t_6so__jk.jpg'), ('2', 'velk5t_5pi__jk.pdf'), ('2', 'post3t_5pi.pdf'), ('2', 'adv19dec__jk.len_R.sib'), ('2', 'velk5t_4st__jk.jpg'), ('2', 'post1t_2ut__pf.pdf'), ('2', 'adv24dec.pdf'), ('2', 'adv03t_5pi__jk.pdf'), ('2', 'velk7t_2ut__pf.jpg'), ('2', 'post5t_1po__pf.pdf'), ('2', 'velk1t_3st__jk.jpg'), ('2', 'adv02t_5pi__jk.pdf'), ('2', 'post2t_5pi__jk.jpg'), ('2', 'velk3t_6so__jk.pdf'), ('2', 'adv17dec.pf.pdf'), ('2', 'velk6t_2ut__pf.jpg'), ('2', 'adv20dec__pf.jpg'), ('2', 'adv02t_4st__jk.jpg'), ('2', 'chr2t_7jan_ak3krali_nedela__pf.jpg'), ('2', 'velk4t_5pi__jk.pdf'), ('2', 'velk2t_1po__pf.jpg'), ('2', 'chr1okt_31dec__pf.pdf'), ('2', 'velk4t_4st__jk.jpg'), ('2', 'velk4t_2ut__pf.jk.jpg'), ('2', 'velk8t_1po.+aleluja.pdf'), ('2', 'velk4t_2ut__pf.jpg'), ('2', 'post0t_5pi__jk.jpg'), ('2', 'velk1t_6so__jk.pdf'), ('2', 'chr3t_12jan_6so_po_ned3kraloch__jk.pdf'), ('2', 'adv22dec.pf.jpg'), ('2', 'post2t_2ut__pf.pdf'), ('2', 'post5t_6so__jk.odt'), ('2', 'adv02t_2ut__pf.jpg'), ('2', 'post6t_4st_vecer.+ev_vers.pdf'), ('2', 'velk6t_5pi__jk.pdf'), ('2', 'chr2t_3jan__jh.pdf'), ('2', 'post5t_3st__jk.pdf'), ('2', 'adv03t_2ut__pf.jpg'), ('2', 'velk7t_4st__jk.jpg'), ('2', 'adv23dec.pf.jpg'), ('2', 'post4t_3st__jk.pdf'), ('2', 'velk7t_5pi__jk.pdf'), ('2', 'chr2t_6jan_ak3krali_nedela__jh.pdf'), ('2', 'velk5t_2ut__pf.jpg'), ('2', 'adv01t_4st__jk.jpg'), ('2', 'post1t_4st__jk.pdf'), ('2', 'post1t_5pi__jk.jpg');

-- SQL--------------------------------------------------stop-------