From 5b0772e4815a6804f0467d332c8beb982e1b7716 Mon Sep 17 00:00:00 2001 From: Kilian Saffran Date: Tue, 12 Mar 2019 09:28:30 +0100 Subject: [PATCH] database changes --- app_v3/defaults/profile/creorga.sqlite | Bin 73728 -> 72704 bytes db/schema.pg.sql | 0 db/{schema.sql => sqlite.schema.sql} | 284 ++++++++++++++----------- 3 files changed, 154 insertions(+), 130 deletions(-) delete mode 100644 db/schema.pg.sql rename db/{schema.sql => sqlite.schema.sql} (92%) diff --git a/app_v3/defaults/profile/creorga.sqlite b/app_v3/defaults/profile/creorga.sqlite index 1b05bab44b99fff0a53f898f41c07e4b22c57fad..1e4329bee55ee8fab930b917eb7384e0c2cfc35b 100644 GIT binary patch delta 2682 zcmdT`jdK&n72mgeI-O-({=nAB(ixrnB@0Q&vTTE~jWHk`3IPu>lR!E+!j_F%$2PKT z6FQx8G9;O{Q!pEHoqmAbri7V(*%D2Fv>}tGWjqu@$1q{iGLtlTw4f{ ze~>%mHn~Y|kUx=YL3GO6$7t_fqMyq z@=69}H)8DWu}gYBpp zXkJ_4*kln&SULK~D<#0u&#%mx{(n`L{+G%_L(wj(B#XHq=0){j7F5{@Q-#ZhS!6)3 zApA49iC%%9k{V(pMwWBqM2Q<||K$o0=!=&x8U$W^)I|fAtyH-p2^si9#3{`@{UCmJ zJ~<6qVsEC`t}Mo$Ogf&F@;i4$d%FfZ0_ibRS)W0FG&G&u!wEm+IKfQNQwZuHgAH!v z9%~W#fSDIV4to`+l>Xf+wdq9XWuG#=jB8%eLG(UfX{ zZcM)=T1`xo&Y>8~{Wu+Wm8I_5iC`lh#3L)iHqogm5whv@R1%wH+BQ{YWHF#XbCK@k z^*d%^5xYO3IP=w288D$~k>Xy!LT(en-^G1!4(&l&37j6AaPjrxg68T6B1oJivC*PN z3!wrEUp-U^>Qg&t)XvX& zlQ((6(S}GJUWv0=HMF5p^sz?w-sLG~UYBt8gi)dwlUA_N8_AD}Qe{_rvSAYYZS?n# zNp$XLK3Aj+717LN5?E>Fv8zOBwW@~AcUuTxkF3RNN!vOC>2WchW(irbSlylj$C>D0 zQod3`FWr&BL2uvrLq;htwmJc&BLaJp<8sXeTM)tc0=B^W@O~VkMAZW18e1V2-S^Ec*%3E<+Q#^f)YADYf1H19U(dR8Y1Wv zB5xB3ox;~xNu40yv{lk@TLo0;j~#8h4o0n|HS3in(~o)z1ed;ZmFq}QQ&?vMrO8Gv zD+}Y#5cv)M44=d&8QGUGZuZi^>`FoFkDRi8iMouyG+*zY&l=qyxRRB;zz-lafc#?< zrSt#cJkMo&=-{jumZZjK!=w7g!~XT^*~L%@OX;m{$)q)!^a(?s?7CdRYOig}`bS%~Y?C*Hw#k)x zaca+ayTZ?C2ant2_WPOU#q{;=Ji)Jr@`R7>9=udw_S> zF4SkiU_9L2-4W1-8r{i?p!zF-GY|3S0;7%q4cla>N+oQG46^|ZBizpX9zZXnVHWXI zyz=BSqkp-c+xhS0XD-w3wLnKRsQ;ZpsH3MRzdc{xL~+)szs`b*2e`QYgUhJ9#wdy+ zJR8vSSzps3m}>mqVMx}1P=Fhl_#T9t!GjU<5HmafX`aoL}qCGv4SUlF#q3_h&-_tQP(527mz=*~1 zpjF=5rk(uq=1uZ~Sddmt$MCos$JN9{@ zfqrA(o5{CuZo!)@j?)NVfZw9iK*?gX7wu(|cHySAbhFaPwJ49TI(*ayE2;hHFR`zM zUi!XQXeMUFCAj8SZD!yAH?L$#Ez#xsN(vg;Ub&*r2cvmu@sy6$sxuSbO94l6%^W(2 z@Ch6RiVnh#v57}W0@l%^5vgd+8uod?f@*JBy)h)0jD(}{-ss@`Dy*TeMXnR&v5@*D z0cPg8Wws=?t}%)p59|-q7nM?2l{%vk$QcfIJ`)MYmgygOK>v~c*q5VyJ-hmcVuR`n805?c4XE;5$coi+H1eywnqEa%{!P+tC)~YH)8?5U#X{_CO&q>HC zwEeYz_MZK_@16JFx##0|&b?2+COmykIAGGX5<=GCfA(k{x7F0Ql1lM#3X1gXnEYT3 z`v?0gyU%{Y?y`^B@7PUtgI!}+*d_KRJIl_nSJ@;x!H#jA&`oOu{!ZM?+b?A2rR=qX z+K`(I->!>!cZ34Ifndl#lth~7viH$mRNn4EXzM^oS0k))BjmdfT9+fZ8W2|0AT(7X zEVCil%Mg}W5G-bd)!7Kf41}ySgj5xRTDD$Ar_4fzmV%ammR%!v$Q?BCy%`h5XrOO! zZ`+K8zDHX4Ey}Ms?9@v6{helBW?!gh>8O~IWrS|0L*FP)*LGlsl8_@0Ze9Ls_-ILHMDN5FSuX+IGU;p_6okY$sfonFUS!gM-Ti-Iy_r z|NKBHWGH6+{lJI77F$y>5*2xi;^qZPW=HkPYy$yrC^nG9g^9Z%2GpV9)4US2Q(vVS zD}O{7JVDrb_yIg2pX45%@bn`%D zI65SDxm_Ny&Ar<7n5SE;s;si5isHtuj`gmtE#f-&7IBH+yW8)L1#Ak}hKGax^3-xi z#>BK9Dg{Fv7ENpuzzo?FuL$s=KnRp_-Bu%idup*I6OH;zF~$BLO?h2#YE=d~P@p?5 zXb*Z++6uxtXc&%@+oWRLmBXYO7hmg4FsWrF|5NT+CUvy%debE)ZC=4Yp1Q%L+Gd^` z{~2;rlcOR=LLbm+7=!iXalFYUc_wv>nOC1Q^FRE#P$-ciCa$|>gJQno)-P1eMwMZc zRVD_1{+^gt6mQK{8?06sZJL-;K@k+5{*?+C@Pr|gmgn%6^Jd=Y)SARN7}N%X0Y=a)J8#*5SG)7Wrc)k=ymufTp@+Tjwe=~oGt&Q%-p(lu}~%r z=W*9oGp1tu)*Eu&W~<0y!rrBq=@EDdV&pKak}Vl`>1kaBpETAks>94>NSn*la=u0w zKXo!AS|6y1jdM&5;1wqiHQsN+F z5CLb+PjT4QvlH)6xAUQsHgG16p7dh3XiL#(4-xt{cAG==DEtlE-H18fTdlafH#Zrx zC^q+iPr;VN=}r^ycQ;s>R9eG*wwG{rxqXgxE)-TuPdWJ2un5cf{qXxxg=@u9Xr2?yr?1)`XF`Gt4;M~ns`er8tm^6L}StZUb(kPRSmp=PYSGpT<1q7 zuQ92yjz`X)VNzA?M1dYAgsiM2HO=@rA&c`n@>6?wb@;9H; zQYWtnoybV1&!9*B1U`Uf($Dg7x*jHdrETK56hLz=t9WnIF(wta^0(H%h)sw*$JaRz zGO5?iEuY>tvV8pd9H9pAlXI+xd7LQ9XIli4B3KPvaI3HOry4{ zcD`-PB#R5H6PNA_Agguq!cXmKspR+En>QeoRPSLMI#o4ZLQsSYTfr zx6oY3<4x4GCms9hTpZf4tZcGm&V8}ly}4Tv1;e`{L0>@bx#HY=gWlZ%|06`+osr>i zOljitKmM{f8Yt-tMCE1R;XKj6&S2Odh{{^4XJ+E}X?Bim*ZhYyvkxJw2GaRPmZ>- zs52Am-^}xWYZlB>m!4PNECmyP?B+>W%v(GS`dnpK0wshR;UgUGlDnw+COBu;HNCv9 zY2<86%^tPF`5NT>mIdfjtGm6UGo8N)of^DDLf5QQws6R-H1~*aty;Ejzi!St69!bu z%>KV($96fl|0{Ob()pwzOOGT;rs-vZsUL-xi5@F&ALPGhvgc{yk$Josj7mKl)JZXa zadOkVG(DIcoJo_Tlb@QZv}DHDtXEdR(c~U>cGEOF%A2R$&9Z;;M(ANJ&FqmL)@x`u z>>ChUH*D~@U7bp0;_4Y29-1ZjBa5GpU#vwwR83_*DNhjy`(weKSer^~P%36epg$Ov bg-hoNXWp9;DPQ`7u}E~@EB|Ffhtd2Ov8$*b diff --git a/db/schema.pg.sql b/db/schema.pg.sql deleted file mode 100644 index e69de29..0000000 diff --git a/db/schema.sql b/db/sqlite.schema.sql similarity index 92% rename from db/schema.sql rename to db/sqlite.schema.sql index 072a78c..ad68237 100644 --- a/db/schema.sql +++ b/db/sqlite.schema.sql @@ -1,41 +1,3 @@ -CREATE TABLE "eventcalendar" ( - uuid TEXT NOT NULL, - datefrom DATE, - dateto DATE, - timefrom TEXT, - timeto TEXT, - description TEXT, - activityuuid TEXT, - staffuuid TEXT, - location TEXT, - color TEXT, - freq TEXT, - lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, - PRIMARY KEY (uuid) -); -CREATE TABLE "staffplanning" ( - eventcalendaruuid TEXT, - staffuuid TEXT, - lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, - PRIMARY KEY (eventcalendaruuid,staffuuid) -); -CREATE TABLE "expenses" ( - uuid TEXT, - expensedate DATE, - remitter TEXT, - expenseamount REAL - expensefile TEXT, - statementfile TEXT, - lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, - PRIMARY KEY (uuid) -); -CREATE TABLE "vacancy" ( - vacancydate DATE, - vacancydateto DATE, - vacancydescription TEXT, - lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, - PRIMARY KEY (vacancydate,vacancydateto) -); CREATE TABLE "accounting" ( accmonth DATE, childuuid TEXT, @@ -51,9 +13,14 @@ CREATE TABLE "accounting" ( invoicefile TEXT, benefitfile TEXT, benefitamount REAL, - extraamount REAL, - PRIMARY KEY (accmonth,childuuid) + extraamount REAL, + uuid TEXT, + PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_accounting_upd UPDATE ON accounting + BEGIN + UPDATE accounting SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "activitylog" ( uuid TEXT NOT NULL, logdatefrom DATETIME, @@ -65,6 +32,10 @@ CREATE TABLE "activitylog" ( editor TEXT, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_activitylog_upd UPDATE ON activitylog + BEGIN + UPDATE activitylog SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "cautionstatus" ( uuid TEXT NOT NULL, childuuid TEXT, @@ -74,6 +45,10 @@ CREATE TABLE "cautionstatus" ( statementnumber TEXT, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_cautionstatus_upd UPDATE ON cautionstatus + BEGIN + UPDATE cautionstatus SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "childs" ( clientnumber TEXT, prename TEXT, @@ -103,18 +78,28 @@ CREATE TABLE "childs" ( bankaccountowner TEXT, infoimportant TEXT, infolunch TEXT, - editor TEXT, + editor TEXT, + currentweekhours REAL, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_childs_upd UPDATE ON childs + BEGIN + UPDATE childs SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "childslog" ( uuid TEXT NOT NULL, logdate DATE, logmessage TEXT, childuuid TEXT, editorstaffuuid TEXT, - lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, editor TEXT, + lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, + editor TEXT, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_childslog_upd UPDATE ON childslog + BEGIN + UPDATE childslog SET lastmodified=CURRENT_TIMESTAMP WHERE uuid=NEW.uuid; + END; CREATE TABLE "costs" ( startdate DATE, costsperhour REAL, @@ -125,6 +110,10 @@ CREATE TABLE "costs" ( costperhourfallback REAL, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_costs_upd UPDATE ON costs + BEGIN + UPDATE costs SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "creche" ( crechename TEXT, adress TEXT, @@ -138,9 +127,47 @@ CREATE TABLE "creche" ( lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, editor TEXT, stafflist BOOLEAN, - dbversion TEXT, + dbversion TEXT, + idcheckservice TEXT, + PRIMARY KEY (uuid) +); +CREATE TRIGGER trg_creche_upd UPDATE ON costs + BEGIN + UPDATE creche SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; +CREATE TABLE "eventcalendar" ( + uuid TEXT NOT NULL, + datefrom DATE, + dateto DATE, + timefrom TEXT, + timeto TEXT, + description TEXT, + activityuuid TEXT, + staffuuid TEXT, + location TEXT, + color TEXT, + freq TEXT, + lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_eventcalendar_upd UPDATE ON eventcalendar + BEGIN + UPDATE eventcalendar SET lastmodified=CURRENT_TIMESTAMP WHERE uuid=NEW.uuid; + END; +CREATE TABLE "expenses" ( + uuid TEXT, + expensedate DATE, + remitter TEXT, + expenseamount REAL + expensefile TEXT, + statementfile TEXT, + lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, + PRIMARY KEY (uuid) +); +CREATE TRIGGER trg_expenses_upd UPDATE ON expenses + BEGIN + UPDATE expenses SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "groups" ( grpname TEXT, maxchilds INTEGER, @@ -152,6 +179,10 @@ CREATE TABLE "groups" ( color TEXT, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_groups_upd UPDATE ON groups + BEGIN + UPDATE groups SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "health" ( uuid TEXT NOT NULL, docname TEXT, @@ -165,6 +196,10 @@ CREATE TABLE "health" ( lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_health_upd UPDATE ON health + BEGIN + UPDATE health SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "messagelog" ( uuid TEXT NOT NULL, logdate DATETIME, @@ -175,6 +210,10 @@ CREATE TABLE "messagelog" ( editor TEXT, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_message_upd UPDATE ON messagelog + BEGIN + UPDATE messagelog SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "planning" ( datebegin DATE, dateend DATE, @@ -216,9 +255,13 @@ CREATE TABLE "planning" ( sattimeend2 TEXT, suntimebegin2 TEXT, suntimeend2 TEXT, - lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, + lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, weekhours REAL, weeklunch TEXT, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_planning_upd UPDATE ON planning + BEGIN + UPDATE planning SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "planningstaff" ( uuid TEXT NOT NULL, staffuuid TEXT NOT NULL, @@ -291,6 +334,10 @@ CREATE TABLE "planningstaff" ( lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_planningstaff_upd UPDATE ON planningstaff + BEGIN + UPDATE planningstaff SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "planningtemplate" ( uuid TEXT NOT NULL, montimebegin TEXT, @@ -332,7 +379,12 @@ CREATE TABLE "planningtemplate" ( templatename TEXT, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_planningtemplate_upd UPDATE ON planningtemplate + BEGIN + UPDATE planningtemplate SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "presence" ( + uuid TEXT, daydate DATE, lunch BOOLEAN, status INTEGER, @@ -342,9 +394,13 @@ CREATE TABLE "presence" ( endtime1 TEXT, begintime2 TEXT, endtime2 TEXT, - editor TEXT, - PRIMARY KEY (daydate,childuuid) + editor TEXT, + PRIMARY KEY (childuuid,daydate) ); +CREATE TRIGGER trg_presence_upd UPDATE ON presence + BEGIN + UPDATE presence SET lastmodified=CURRENT_TIMESTAMP WHERE daydate = NEW.daydate and childuuid = new.childuuid; + END; CREATE TABLE "refpersons" ( reftype TEXT, surname TEXT, @@ -366,6 +422,10 @@ CREATE TABLE "refpersons" ( priority INTEGER, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_refpersons_upd UPDATE ON refpersons + BEGIN + UPDATE refpersons SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "staff" ( jobtitle TEXT, prename TEXT, @@ -389,14 +449,33 @@ CREATE TABLE "staff" ( editor TEXT, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_staff_upd UPDATE ON staff + BEGIN + UPDATE staff SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "stafflog" ( uuid TEXT NOT NULL, logdate DATE, logmessage TEXT, staffuuid TEXT, - lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, editor TEXT, + lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, + editor TEXT, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_stafflog_upd UPDATE ON stafflog + BEGIN + UPDATE stafflog SET lastmodified=CURRENT_TIMESTAMP WHERE uuid=NEW.uuid; + END; +CREATE TABLE "staffplanning" ( + eventcalendaruuid TEXT, + staffuuid TEXT, + lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, + PRIMARY KEY (eventcalendaruuid,staffuuid) +); +CREATE TRIGGER trg_staffplanning_upd UPDATE ON staffplanning + BEGIN + UPDATE staffplanning SET lastmodified=CURRENT_TIMESTAMP WHERE eventcalendaruuid=NEW.eventcalendaruuid and staffuuid=NEW.staffuuid; + END; CREATE TABLE "staffvacancydays" ( staffuuid TEXT, vacancyyear INTEGER, @@ -405,6 +484,22 @@ CREATE TABLE "staffvacancydays" ( hours REAL, PRIMARY KEY (staffuuid,vacancyyear) ); +CREATE TRIGGER trg_staffvacancydays_upd UPDATE ON staffvacancydays + BEGIN + UPDATE staffvacancydays SET lastmodified=CURRENT_TIMESTAMP WHERE staffuuid = NEW.staffuuid and vacancyyear = NEW.vacancyyear; + END; +CREATE TABLE "vacancy" ( + vacancydate DATE, + vacancydateto DATE, + vacancydescription TEXT, + lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, + PRIMARY KEY (vacancydate,vacancydateto) +); +CREATE TRIGGER trg_vacancy_upd UPDATE ON vacancy + BEGIN + UPDATE vacancy SET lastmodified=CURRENT_TIMESTAMP WHERE vacancydate = NEW.vacancydate and vacancydateto = NEW.vacancydateto; + END; + CREATE TABLE "vacancycalendar" ( uuid TEXT NOT NULL, datefrom DATE, @@ -416,8 +511,13 @@ CREATE TABLE "vacancycalendar" ( lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, type INTEGER, accepted BOOLEAN DEFAULT '0', + vacyear integer, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_vacancycalendar_upd UPDATE ON vacancycalendar + BEGIN + UPDATE vacancycalendar SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "waitlist" ( uuid TEXT NOT NULL, waitdate DATE NOT NULL, @@ -430,6 +530,10 @@ CREATE TABLE "waitlist" ( editor TEXT, PRIMARY KEY (uuid) ); +CREATE TRIGGER trg_waitlist_upd UPDATE ON waitlist + BEGIN + UPDATE waitlist SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; CREATE TABLE "workinghours" ( uuid TEXT NOT NULL, datestart DATE NOT NULL, @@ -451,87 +555,7 @@ CREATE TABLE "workinghours" ( lastmodified DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (uuid) ); -CREATE TRIGGER trg_accounting_upd UPDATE ON accounting - BEGIN - UPDATE accounting SET lastmodified=CURRENT_TIMESTAMP WHERE accmonth=NEW.accmonth and childuuid=NEW.childuuid; - END; -CREATE TRIGGER trg_activitylog_upd UPDATE ON activitylog - BEGIN - UPDATE activitylog SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; - END; -CREATE TRIGGER trg_cautionstatus_upd UPDATE ON cautionstatus - BEGIN - UPDATE cautionstatus SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; - END; -CREATE TRIGGER trg_childs_upd UPDATE ON childs - BEGIN - UPDATE childs SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; - END; -CREATE TRIGGER trg_childslog_upd UPDATE ON childslog - BEGIN - UPDATE childslog SET lastmodified=CURRENT_TIMESTAMP WHERE uuid=NEW.uuid; - END; -CREATE TRIGGER trg_eventcalendar_upd UPDATE ON eventcalendar - BEGIN - UPDATE eventcalendar SET lastmodified=CURRENT_TIMESTAMP WHERE uuid=NEW.uuid; - END; -CREATE TRIGGER trg_expenses_upd UPDATE ON expenses - BEGIN - UPDATE expenses SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; - END; -CREATE TRIGGER trg_groups_upd UPDATE ON groups - BEGIN - UPDATE groups SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; - END; -CREATE TRIGGER trg_health_upd UPDATE ON health - BEGIN - UPDATE health SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; - END; -CREATE TRIGGER trg_message_upd UPDATE ON messagelog - BEGIN - UPDATE messagelog SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; - END; -CREATE TRIGGER trg_planning_upd UPDATE ON planning - BEGIN - UPDATE planning SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; - END; -CREATE TRIGGER trg_planningstaff_upd UPDATE ON planningstaff - BEGIN - UPDATE planningstaff SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; - END; -CREATE TRIGGER trg_planningtemplate_upd UPDATE ON planningtemplate - BEGIN - UPDATE planningtemplate SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; - END; -CREATE TRIGGER trg_presence_upd UPDATE ON presence - BEGIN - UPDATE presence SET lastmodified=CURRENT_TIMESTAMP WHERE daydate = NEW.daydate and childuuid = new.childuuid; - END; -CREATE TRIGGER trg_refpersons_upd UPDATE ON refpersons - BEGIN - UPDATE refpersons SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; - END; -CREATE TRIGGER trg_staff_upd UPDATE ON staff - BEGIN - UPDATE staff SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; - END; -CREATE TRIGGER trg_staffplanning_upd UPDATE ON staffplanning - BEGIN - UPDATE staffplanning SET lastmodified=CURRENT_TIMESTAMP WHERE eventcalendaruuid=NEW.eventcalendaruuid and staffuuid=NEW.staffuuid; - END; -CREATE TRIGGER trg_staffvacancydays_upd UPDATE ON staffvacancydays - BEGIN - UPDATE staffvacancydays SET lastmodified=CURRENT_TIMESTAMP WHERE staffuuid = NEW.staffuuid and vacancyyear = NEW.vacancyyear; - END; -CREATE TRIGGER trg_vacancy_upd UPDATE ON vacancy - BEGIN - UPDATE vacancy SET lastmodified=CURRENT_TIMESTAMP WHERE vacancydate = NEW.vacancydate and vacancydateto = NEW.vacancydateto; - END; -CREATE TRIGGER trg_costs_upd UPDATE ON costs - BEGIN - UPDATE costs SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; - END; -CREATE TRIGGER trg_creche_upd UPDATE ON costs +CREATE TRIGGER trg_workinghours_upd UPDATE ON waitlist BEGIN - UPDATE creche SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; - END; + UPDATE workinghours SET lastmodified=CURRENT_TIMESTAMP WHERE uuid = NEW.uuid; + END; \ No newline at end of file -- 2.39.5