From dd33388777627ecfa7982657fcbcc4d9f2fb1100 Mon Sep 17 00:00:00 2001 From: Roland Haeder Date: Mon, 21 Sep 2015 12:14:26 +0200 Subject: [PATCH] =?utf8?q?updated=20jars=20+=20enabled=20own=20lib=20folde?= =?utf8?q?r=20Signed-off-by:Roland=20H=C3=A4der=20?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- PizzaService-ejb/lib/jcore-ee-logger.jar | Bin 8006 -> 8032 bytes PizzaService-ejb/lib/jcoreee.jar | Bin 18592 -> 18795 bytes PizzaService-ejb/lib/jshop-core.jar | Bin 35810 -> 36825 bytes PizzaService-ejb/lib/jshop-ee-lib.jar | Bin 6865 -> 7239 bytes PizzaService-ejb/nbproject/project.properties | 2 +- install/install.sql | 19 +++++++++++++++--- ...-modules-java-j2seproject-copylibstask.jar | Bin 0 -> 22977 bytes lib/nblibraries.properties | 4 ++++ nbproject/genfiles.properties | 2 +- nbproject/project.properties | 2 +- nbproject/project.xml | 3 +++ 11 files changed, 26 insertions(+), 6 deletions(-) create mode 100644 lib/CopyLibs/org-netbeans-modules-java-j2seproject-copylibstask.jar create mode 100644 lib/nblibraries.properties diff --git a/PizzaService-ejb/lib/jcore-ee-logger.jar b/PizzaService-ejb/lib/jcore-ee-logger.jar index 903d01684cac1cda94982d4a7c57c683c021ed75..a3e9a18a174e09d63605848180af6d80a61cb381 100644 GIT binary patch delta 985 zcmaJ=O-vI(6rSDf4_z|~wLsE^(h?FXWVaP)tE8;71R6x4A%=K^O4m)zwoBSdz{Hrw zlQ-zxOwdHRnHWt^A~y^tC3xjPG>SJ3iHRqTzL|z{t^(P3qA-Lrao}1k4*7B zb|Cp=8Iv8sCtwkiLtzwN7qU=$#}Ws-Y3X8>kCtJGd{#QzoK@wqNRk$bY*?FE`K^_L zPus?9Sd?WIlj}Cm85lVlTUgL?X)O<9k^43UKrd~>ai}<=fe|xTFbxd`hTtC{gjY;m zXCw-oHqD~f&=xggsI!<)&1>+rM6t^kt8Hkx+T$;aHNTnBZ|76RjF~%rCY2R?kf+CA z*>ZeuV4GLYFy9231ollIu2>PGD@NWsB1CSnSJdVwR(4;X+!yMVK>SjORpunA{|%h4 znb!l!366IOHTfhUU3+kC*NDExzL4iq8{@x|B(8~++C04{v3+&y%Yg4X5#L>he*pNZ z4ma8)ZU>^Ca{JkPRN6HGf(V^85<=@GH;>TO(Q7ezd~&R+F=Z)h93S$y%#K>DmzF?y zRnh&A*E_jK%I&TEnw@aX{bax0>800j@ME+55Pm+o)T3VD*Gsz&0EWq!r-dEctViOv eoh&uwa*)>^Crj@_`nLJ__Txpt}A zdUS}xMXgsc8g?}jKxMKto?-GdK4eT9-!UiX5$Dbqa~gw?1{rn=uCYg;%}&Bc_9`rJ zv4ogUU9?Je-4OTgM=oZbb+rzMPzTnyoFL{Cx(-`hf)Qbdn}Zxb2e)|>p7Em?`N~g& zCQQL)!N9A(LIgI25YDy*6C%E2yr}C2toT$(4CH5OHOpSM+`0kaOTwmax*!Gu`P8gq z*PW_mU`lF_gIDuTxlHJUb;@xX@v3#hsuo5XZt0RWV!%Kftnk6r_@jkFSK$F*@Y!?{}{}4EA6a0xx^!fy*JWikYrYsL{VdosToLVX} z>=4&Amsqkc%gj%BAuBQRl$hiV*~^0H`%DCWDeAud>a-#=r}54x)RaMb)*XyIz{ugT zK5mb8vPXLx^9%HR?*rgZ5b`((wVMZFKANB$&u(lv?!z1H<}J7vJrE~-j4i(X^Z{#- zne!M#=dK@ilr;Q~hUs-BRc4Brulxt5u@9xNW4$(yIMoDXP?_YOAV}BUP%DDsiHyQKdFgf4L5F>V9WCl5 zcJ7=z_spC#_xsK__nlempL3RfU#}<00eryogP~b}S>~m|Q1rKJ#(p>kK-wC;Kax9p zYZZp z)>nVH7UE_?`mWp6blgD(ntj;eparcCb|T_Kn?k#o9dhYZ*ySJ{Q3omLa?mX!Jr4Z( z!_xinxIb!nlSU>dOZ45`ytJgVqvItOtZobTnG&5*HmmKtdi~e*uwGZ5;5KJXLi`uO+A(UWo#OLY(^M`D1wVM=*M~lnQs7lP>c<5unxT_p_NL&t|J$D?8VxM zQdq{?gfiI1D(6}rV{PFoNwjBCfvxaD;Z0OBMl$2QhALW$?{B&a)!0Uc)NoQ2ybl@8 zRoJdjs}NGCQwS^6D>U$L@kal5O`y1u&NiA7=oS5_an8Qa9Hq7BcdcSQToTYf52nYi zJKR&BTy{I$)m{htuwUUxpS-~XayKBCL5E2lR5+BvtsZuGIg-M}ha6sxDjXBM3HlzK z@L@|ThB2b>R4Q_CQU*`SWz>hK9Wr}R;dCkra7N)7$B!rQtioA^=M={Eo!VXTfwftW z#r|1+CpT07xUO9{<`u8y%ySA8%vGUA;XG4h_PVNkou0`nO`C8ri3=QeaS@mFZ}Qsx z&*OrN7x1Esm+-O>BIjF(xy18|iz!sP_%^;{;R!vvDKEEseB#nY7t=E3ySS?Gnv3t@ znvMku{NKmxF5bYK5@AN)3~aI9(x2rA^uGfBV4YmB%oNg)E5kHgvj%De%v+j4c zH5R{9IBUgbkcJH(%q@&fuRgze7U!$2TdszVsG3;P{CKIOrpp}D)g$YEE z@{lo76(Y(MtwM(~1*;G>b=GMy%mZ}s=4%AO#!6sSfpxAo=~;_jDu`Zlx(y(On0Zl zOhr?CCOx^MqC`YdvLvH!p(+(66}`gJJ|A`~>=B~wRoF*)5T1~5x_HySAFnk_T+8Mp zDGKv0HYf}*28q_1cEH7;6vu#zLpZEoDc|8gf`cxGaMZ;y92b)LPvE4>7k$dbD4y02 z%Db#F-BQ!M$coe2S$9+avEl>k4X29;)`f&UuSWuw54 z+sJ1r$?vuy0&$@wN+X(c+Yn1M=QfG8!NC6>2^KW)|I|=S(EkZ379{#2G}}dJ4EhwB zLysyA^(MRmfBga)4B()%zmg7qhLe%+`_GT{cR zk?-%}H1`bFQsq{p!ezH6(r#xx>;yJ6B(^eE!7H6Kw_dWqBCXzi4yK z&fe$HZ5b+^YhN5mZ!fSP$VlC)+2{D6&(`Pd&8r^BjJM@MnJ%hv(^qd;=6!0LsKTPt z9quFfS0rq)#Ixk=e`Ku>I|}S^d7P{NrY6q{JSyrYuBW4EuXa<%`(mjA0o@1>~Bo<0F{AD74pX#)w)KMK-0q-TP~E6xe$MuPLzQXMI6U2!~6_i0`ySCrP9;HavX qAShbNH$j~eoPSwsHn&{X+@PUDMOT4+zj^6VzMk${oBXSYO#B~)V zTXCCLV~mezqM(pyu+cw=MhzNGjPdcmA)1)@2rAL|Knb36J2z{LO}=~2Jw4~#bMNo` z&i8%yi1zG^<{Id+SPj4qOs5)WTs5w#RAW5+YR#8p0LEsbedPg{5gQ*)P7Lp^j~;3* zZ)^xP_;&;X_4`I9hQ~*e`)7_u4{AwQ50&0FhYgP06+G;gFt^4KZ zvW2o&cc}F_TA!^Ga#}ZL|L>jEN7USCiSwL3Z285agb6WZ%O_3z<-)I?;QaXs$>*vn zN6t}u{?kR2@sTG3{p9br3G39M#u4G$54sDTBD8E~M(KqqUu47d;%NC>PI z=$5H)SNeo2uE}=-Q<_H(20ZfQf&(750-9MWM+Gz`RpK(}N?L~Huqdet)v%I0gBsMr27#j#sSG)EsC%)3Btf@w7rdya z8*3mRA8eOU0#m>z;1_5VkT12H?JG5bCXIIb10BD?R=fbkWNoFrUGxM<))CCApZF&y z9((eP6F4K2i~1&~4azma!&(E~=rOPky#jr9zMcVI4f3$wprkekY;?ehA%liZ4oZBp zLBke-t&Ac;*^MjhSmDGrTqUsGiAC7K%By)u+OgBXF02>W?W8n^1+Fn%Sc*LYdj<9h zT&rMAEp{`E`($lF{w$Pz!A^NwLFHmHyG~#~B_x1qtr?U>vwBdd~Nc^ zq;G$6WREYlH#xpx_`t#8kzKG7I^cA@*58>!+u~g#W z^k~uNnl_d0EqPCOtR-Y~0nL=T4b|yr*-p(e2B$n;UN%WeDux;Yils(e&SgVV6Pmef zNLmRmmkmh)DmE)I;UYrt)5W`S0WCzE9J=RU(MCE!d;ubGT%!7O3WSB?lE50Fcq9;0 zEQoN){7LLdAbOE`)WIg^1r+}dH`P%tu`E+YODT&kl6Ay!3(W@QcQe6%2#&0>N}sIw z%9_hu-{tPPc%FEE-Y%c1T9+6$;9+)q&}vYQ?FPasC%ejtS5Y2_-EPjJlM9U4?L?ew zD`8jsrt*?oU4!yS^^gBx_-t9ol01h&J)u@$kOIi#wX1UnOswa69W=2KL-Oa^uxk@G znAnUhCbr@VE(h0@*kRJuU2P(XopPcsVcn%6D3hIK>9cjGHEp--EjcbD_3vtLrE?m} zG{yKa0w%+FAJrA}oVbM3C{oO0i5XAVOA<4lxqlkWc;^0T#drqsBr(21f%qaZ-m5@- zf%slQATr~dnDGk4EXH>=&k~-|Lo*eCf{U5Xtk0wUf+XuyBHL+ZxVBM-SN$8Vh5nNn zxGbN|G+U#hjvf|Y$9;mObF_4dlL0b`! zHpJ`-M()^MLbYgO^$5lF$TzA}a&N$!h2W5fs*hW^Dpu;zZ4^y`<=OSk^hNH`D^23;^{2%Tp)@{1- z=Z_I@hf}G)C-qQ9&EF)G9rM;tWYqmsa%X4NZ2b+ZYyS5j-mGNmE$kqF2o3iC(m41;Q7=CCK*@I7tnHLIQKrLKC&vy zuym0!iXG+F>NFt%s&TM;?p34-E_q9*;6#^IkF4cKa-faAM{95yCeU-V>5 zDCXK9gffm%hVmt}v-Wy3n=@FJyh}O$YH)B&7E3go-z%;$@<~W)HSo!UaF;%@%lAdT z5+2p3+YH5hudh_EdZ zc7%&7D2*N0KW#bxi1>J9VeQ+iL+328!6~82j2#vjP;Ewy6}70dpdJk-$K%7$9!+XA zInFt_WJZ&OW(#(r#R3<0S+N^?w4qfS_FB<~eP--8+%asZ2PUdPBH5kJRlH;wGfXCP23I=+7UF>+Y!xHXUwq~C=*RYA6Z1%S^ zUQEXkW~r)-?UvC8p9H^*e!L+g0F`;FQbR!*M=?No$T)^UN=e2LhGiVbh>Q~$l@O9K zh7ke9E@!=S`!1Wir^9WlYH4b)x&46-C7`-(t<}yJr_HTr(B7*IxoxGkGFyF3L(MMR zMgit5wS@md#E8{HQ6tIbv*Jrbv(dPO4Rc1r1 z0Bg`+tqkf177(9P%WlQSvzCgDEG;&#+1#ZBD~5uKD!`btc7KI{wf;bt-P7;!b}M$T zzpszjCG1eV_Kuz|MGe|r-JXK&fua5&#a6pLn>Q{?2|4>KwBU`|FAZ_1$L9$Q*(*G% zQdB4)M)7H(b#XbxaP{aRm46=r2{|=26f!me=}4n$)E<#aF&!BYkjbuk6Y|#3npU1b z7L3TI5s*m>gpu?LVK{QImMk(^QO((qW?zM98aI)}W<+8OR$&{GP=*vZXrFS5UP-=H zD8LT9MkT)&O>m@}d&~LLu!ck!DiJ{TLBn!q65YegWe*xiRsJFd5JwG#ZPH@y1K=#w3`&3SmW? zxBw{*D|;7USwNzz&6w+I3(H$Xk^t8NqDsON!)_ya0V#Y;6{9+CV|C*?fMAIVT1QZ#sKfApCCM6<5qqqbsXzU}3{Y0@!bPNy?LkOi3Lm3z)R>#p! zrQAhT?4t@Ez&V6)9uv6moYz{SrHq&hBW*Zm*rc6wiD7N#psyuR@FSdS18s2_733iz zl_G0Y8#%2}MC(&TNLb4$eL^4SKRN|$r?3W8zR(cn->$9}6dvDK$JyKMdGWJ7T)`_`VuuDZ?4wmXas zoQ~n!&XKCqyQGR_7pL^)KWX`CH(!ogX=XomT3N}gu4FoAgwyAMK)BFpSZW8_g delta 1455 zcmZ8hUrbw782{aS+ur`Utc)@K6$f4U(+yZzQC66g!rD@)9o^Ul+r$EenHgE9MR9Wx zp}@9M)|g|I2h9v2+tcEfzRU;r;<5*$CO+v54`MQ(H;rb=67{?1RtTP(bAR8T-*?V; z?)kp^@VfZxCt^V~Ea}XE5!jP(e^}s@oCKbaB~|;Oio+jH71%Dp&2d?DvJWK7)=0(# z5BGjAbaE^dyYlE_(?KI!6wUeQ4vs&GK8`l2UB%p>RHNg>>$d0Pw0#0skoYY)*Tvko^+Wo-DU73UT1TI86o@!AcpGn$A zY4ohh`qUEx@WjAkheEM4W|ZIs8LdVfFhhjLh&Bt_anOtx(P8jCeI4phHLt;!^>NLJ zP8mKky3lRLA^0r_AgI22)K|!Ym(VLCEaPSNxG$Ky;139;5gCVN^a(Hr-i?o+pFEp5 zmy{7@p9X8BQk1bv6At!Ua3{$}*xy0FEu!Ek`ehtba2zKT3}8@zzBbuZn`ATHJDOyi zRB#HXX-x&MV2GAi@G4>ohB2aG6mc123dS)apoNVD_vJhxqgVnvcG8K}A<{!TLqIwE zJY3RHK{oXh01oI-0~<*Sc>z5t@f@KEyHG`pa<(2`npXKiY^V2rVzj`D1GHK@D$qfE zFEKl@8{MdbA8z_CUW71+2;~>WYv@M;Coo0lx=87(dxapA&4_Bsk*XD!DB3|-hB3;f zmNKcJW7VOaGN{DxDLAnQ5^Xbty=b76chmQ1B*}m#3M+?X{Rc%b$k->tC8Jr;>40an z<9>4MXgxR07Lr9gzokoZ?C=*_Aq55+6kayZ{CAIs^pvEY-I;Q*;Uy!xJ|^dG#|QPi z&@5+7y!>;e$&6OQH>MI=>6Kkv(KugCf5t6rXx5{4AzPl+TIuImm%0d3Qd*1kq`J9o zpSQ7_DXl5jQXy`upX=lJ-JFemG}oG!kL39gj&IIKIo_Y|<+y#}EshHd6CD3qc!T5k z`Id3H&--&+to8%U%49Ns7s&bIGWb<`{_8>_bzIBW>Mq+xfuI@uZ?C- za_YT|P0aSP^>j7=X`DZ*FzZrLwc44F8XnaBVgc0IOtB#?#nQ%)uc!QX{pej2pw8CKIIPad)}=Mx+nR(qJy{!4!BD|eA&4LJaev)yyO_@Qq|CKW3dP9@JI~;h)jyff#3rWGS$;;it^~y41v^DO z7q7RcY`0qRtrDTLJ?8&3>~t`2fC9kj1eI6=8nG5!L^pVdb>Ia634HX{!O!Ug1_6Mo z!6`=rDxEF183{2$Xd64zv0}t%0>1IMm?FcxK)hjIA(qSmVqdTk_28L`f1UV?$KD0w z6@QR!Xm5gWAe4%VOZ(d~nw9yb3G3qx?mng2ZUx_)5!?=SP>rMEM(K@8q0fqrE=|W7 z#fb}HH>H<&`h`a6&G2ao>Gh4$vYSFz>(A0|hJ15no&gB!-Q9|_G&|=d;i$)pTfYCL tY0=(X0d!R@n$~I2wLlGaH8hj>&*safRW1^Cu1Y*-ka(%#xO34InSb8L{-FQ> delta 684 zcmX?ZanY1Fz?+$ci-CcIfx)24XdEKl!gX*JNKN4lsW+#>o=|y}5YV8MxRPxY-$a zCO;L-nOrM;RELp;k%5JQm4ShQiGdAFvV#H#$OgKHfdM7BHct~_2irJ#fv5#2;3nS| zg@lQ$m_9fR{KX())g|Tx=ARey0Mk<9{$Tomxb)<9aWg185KN0m1c2#ui2$&h5#crY zs6--IN>fsrNtSi8p_Ibp|BM`y^CS(x!V7`I9qe%7ckJ?$t69WSX zy8^uf14|mKCL2hFD1g-5@CiB40+a_~510ZVy`-_0XR@J$`sCA65MTY3l4eTh2MTFS zzQD^inNv`3@_$Jouo;K|W?-;EF(XV6s6l@6Drs%7!f&_c%54BD0AVW>g~GyMg%+aX NleJ~U*rY{3vH&h1taJbX diff --git a/PizzaService-ejb/nbproject/project.properties b/PizzaService-ejb/nbproject/project.properties index 0bcb243..a80731f 100644 --- a/PizzaService-ejb/nbproject/project.properties +++ b/PizzaService-ejb/nbproject/project.properties @@ -31,7 +31,7 @@ includes=** j2ee.compile.on.save=true j2ee.deploy.on.save=true j2ee.platform=1.7 -j2ee.platform.classpath=${j2ee.server.middleware}/mq/lib/jaxm-api.jar:${j2ee.server.home}/modules/endorsed/javax.annotation-api.jar:${j2ee.server.home}/modules/endorsed/webservices-api-osgi.jar:${j2ee.server.home}/modules/endorsed/jaxb-api.jar:${j2ee.server.home}/modules/javax.batch-api.jar:${j2ee.server.home}/modules/javax.security.auth.message-api.jar:${j2ee.server.home}/modules/javax.faces.jar:${j2ee.server.home}/modules/javax.servlet.jsp.jstl-api.jar:${j2ee.server.home}/modules/javax.transaction-api.jar:${j2ee.server.home}/modules/javax.servlet.jsp.jar:${j2ee.server.home}/modules/webservices-osgi.jar:${j2ee.server.home}/modules/javax.mail.jar:${j2ee.server.home}/modules/javax.interceptor-api.jar:${j2ee.server.home}/modules/javax.inject.jar:${j2ee.server.home}/modules/javax.resource-api.jar:${j2ee.server.home}/modules/javax.enterprise.concurrent-api.jar:${j2ee.server.home}/modules/javax.el.jar:${j2ee.server.home}/modules/javax.ejb-api.jar:${j2ee.server.home}/modules/javax.xml.rpc-api.jar:${j2ee.server.home}/modules/javax.security.jacc-api.jar:${j2ee.server.home}/modules/javax.json.jar:${j2ee.server.home}/modules/javax.xml.registry-api.jar:${j2ee.server.home}/modules/javax.websocket-api.jar:${j2ee.server.home}/modules/javax.management.j2ee-api.jar:${j2ee.server.home}/modules/javax.servlet-api.jar:${j2ee.server.home}/modules/javax.jms-api.jar:${j2ee.server.home}/modules/javax.enterprise.concurrent.jar:${j2ee.server.home}/modules/javax.servlet.jsp.jstl.jar:${j2ee.server.home}/modules/javax.enterprise.deploy-api.jar:${j2ee.server.home}/modules/bean-validator.jar:${j2ee.server.home}/modules/javax.ws.rs-api.jar:${j2ee.server.home}/modules/javax.servlet.jsp-api.jar:${j2ee.server.home}/modules/jaxb-osgi.jar:${j2ee.server.home}/modules/weld-osgi-bundle.jar:${j2ee.server.home}/modules/javax.persistence.jar +j2ee.platform.classpath=${j2ee.server.middleware}/mq/lib/jaxm-api.jar:${j2ee.server.home}/modules/endorsed/javax.annotation-api.jar:${j2ee.server.home}/modules/endorsed/jaxb-api.jar:${j2ee.server.home}/modules/endorsed/webservices-api-osgi.jar:${j2ee.server.home}/modules/bean-validator.jar:${j2ee.server.home}/modules/javax.batch-api.jar:${j2ee.server.home}/modules/javax.ejb-api.jar:${j2ee.server.home}/modules/javax.el.jar:${j2ee.server.home}/modules/javax.enterprise.concurrent-api.jar:${j2ee.server.home}/modules/javax.enterprise.concurrent.jar:${j2ee.server.home}/modules/javax.enterprise.deploy-api.jar:${j2ee.server.home}/modules/javax.faces.jar:${j2ee.server.home}/modules/javax.inject.jar:${j2ee.server.home}/modules/javax.interceptor-api.jar:${j2ee.server.home}/modules/javax.jms-api.jar:${j2ee.server.home}/modules/javax.json.jar:${j2ee.server.home}/modules/javax.mail.jar:${j2ee.server.home}/modules/javax.management.j2ee-api.jar:${j2ee.server.home}/modules/javax.persistence.jar:${j2ee.server.home}/modules/javax.resource-api.jar:${j2ee.server.home}/modules/javax.security.auth.message-api.jar:${j2ee.server.home}/modules/javax.security.jacc-api.jar:${j2ee.server.home}/modules/javax.servlet-api.jar:${j2ee.server.home}/modules/javax.servlet.jsp-api.jar:${j2ee.server.home}/modules/javax.servlet.jsp.jar:${j2ee.server.home}/modules/javax.servlet.jsp.jstl-api.jar:${j2ee.server.home}/modules/javax.servlet.jsp.jstl.jar:${j2ee.server.home}/modules/javax.transaction-api.jar:${j2ee.server.home}/modules/javax.websocket-api.jar:${j2ee.server.home}/modules/javax.ws.rs-api.jar:${j2ee.server.home}/modules/javax.xml.registry-api.jar:${j2ee.server.home}/modules/javax.xml.rpc-api.jar:${j2ee.server.home}/modules/jaxb-osgi.jar:${j2ee.server.home}/modules/webservices-osgi.jar:${j2ee.server.home}/modules/weld-osgi-bundle.jar j2ee.platform.embeddableejb.classpath=${j2ee.server.home}/lib/embedded/glassfish-embedded-static-shell.jar j2ee.platform.wscompile.classpath=${j2ee.server.home}/modules/webservices-osgi.jar j2ee.platform.wsgen.classpath=${j2ee.server.home}/modules/webservices-osgi.jar:${j2ee.server.home}/modules/endorsed/webservices-api-osgi.jar:${j2ee.server.home}/modules/jaxb-osgi.jar:${j2ee.server.home}/modules/endorsed/jaxb-api.jar diff --git a/install/install.sql b/install/install.sql index 61e8e90..a5f3b14 100644 --- a/install/install.sql +++ b/install/install.sql @@ -56,12 +56,23 @@ CREATE TABLE IF NOT EXISTS `products` ( CREATE TABLE IF NOT EXISTS `orders` ( `id` bigint(20) unsigned NOT NULL COMMENT 'Primary key', + `customer_id` bigint(20) unsigned NOT NULL COMMENT 'Table reference customer', + `access_key` varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Access key to receipt', + `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Order created', + PRIMARY KEY (`id`), + UNIQUE KEY `access_key` (`access_key`), + INDEX `customer_id` (`customer_id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Customer orders'; + +CREATE TABLE IF NOT EXISTS `ordered_items` ( + `id` bigint(20) unsigned NOT NULL COMMENT 'Primary key', + `order_id` bigint(20) unsigned DEFAULT NULL COMMENT 'Table reference orders', `order_status` enum('UNCONFIRMED','CONFIRMED','DELIVERED','CANCELED') NOT NULL DEFAULT 'UNCONFIRMED' COMMENT 'Order status', - `customer_id` bigint(20) unsigned DEFAULT NULL COMMENT 'Table reference customer', `product_id` bigint(20) unsigned NOT NULL COMMENT 'Table reference products', `amount` bigint(20) unsigned NOT NULL COMMENT 'Ordered amount', `added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Record inserted', PRIMARY KEY (`id`), + INDEX `order_id` (`order_id`), INDEX `product_id` (`product_id`), INDEX `customer_product` (`customer_id`,`product_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Customer orders'; @@ -81,6 +92,9 @@ MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key'; ALTER TABLE `orders` MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key'; +ALTER TABLE `ordered_items` +MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key'; + ALTER TABLE `category` ADD FOREIGN KEY (`parent`) REFERENCES `category` (`id`) ON DELETE SET NULL; @@ -90,6 +104,5 @@ ADD FOREIGN KEY (`customer_contact_id`) REFERENCES `contacts` (`id`) ON DELETE C ALTER TABLE `products` ADD FOREIGN KEY (`category`) REFERENCES `category` (`id`) ON DELETE SET NULL; -ALTER TABLE `orders` -ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE SET NULL, +ALTER TABLE `ordered_items` ADD CONSTRAINT `orders_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE; diff --git a/lib/CopyLibs/org-netbeans-modules-java-j2seproject-copylibstask.jar b/lib/CopyLibs/org-netbeans-modules-java-j2seproject-copylibstask.jar new file mode 100644 index 0000000000000000000000000000000000000000..eaf6790a221ad1983616f4c98377bd9876bc6224 GIT binary patch literal 22977 zcmb_k4}4SA^*=XF`_eQmC0HOR`m6}0ZQ6kCdPZ)ZG3ttDwW+yXt!ZelYgL#s;m)HqgqUhZqfoes#G=gR1Apfi)tv*9gM}bs1|^H z`2t$6FS;?NM!Lpt19UaVd$gz;_VsEpwbwVOc4{LKAU_yo3i>c`!A+VP83;pXbW+-( zAO1)`v!IPXeL3bFOG(L;_<%f%F2O( zfeKTVD_HaWfk4RH-51(4uc9a38$wBRI^5aW9}ER5!6If)tdhIr1y8*5ytOSAYMaK? zrdsII8HLI`cEK)iHslL;_xrjvwL7v&i-v>YZWZF)8;r3Hg!qAbp^bM!fGJNWZ>XdW09`-07S7I4DyHi0|w`eYU(NtQW*s;O_4b0XD(_muZFOo z-Bc}052Pe9qdu$erkn?~SgIKaXtn^txw~MyMLuIJQK%$UU{iM@kE62SWWr|xOU>nOs(r}^r z`a#VXJyTuJ=7Rgma;+ORX%x;ZHcVYu*S|=#BsLe=fUg~WYDUpu7;4^Th>8j>m~&)> zEK(m1#)Bwfs5FGn;HX&_sI0Zy`on5t&>xM&24VerW94dn*k7TJCf>BVRr6KU0hSE4 z*xdD7ojB9t!OFpS>WZZgfwWpYnyjd36Z)7;N|PVf znE*r}uIcy#P*>Ri#t{;M@j>n4^|i3H(y&D^2pU^4NO{DfIUvPUL!|0rmQqw{ER!m& zu4k&4rZiH{gaMG|rJ|T+llvWrsB8?AB>F&13^c*Y`+Fj+%orr279<$b<`4D-*&6pi ziMaofKB*m`HAxMNvlPUPyws_*%o9wjwASg=f_&fsUTrhxAYFAv(Ij~URv9G1G+1<7 z^>xA&Vm4D(MFudDL@^e6w^YlYLo%;cZ>ZbQRMS|uL{F$d-l+WA=BD<#ruHRc{hbj$!>KM`Q{S*cZC=yfvZh^KQP)=6 zTHn%M-`pfK$E_(#$k~F$NKRg0pRs7sjh>VXV^xS=`E;4_VFrf$`q?h)qh7zFPGa-* z$0KZ|{Js!Y1YiMHW-8uIJ8^1Ft1QQB5azGsl!1Q^Y_4hPStg|TrSe!bF}HTI?PYfA z2FYwU6pOGb!p8EfWmqM&CMOlChCC*6Ch@jlDq+EpD-vVAFpNC+R}yGe1yQ}mUPPat zN-VpSxfQak1nm(u3Twx$nEdLBMtTiV=mipU$&=MhL`|yaeZWSgL1f(R7*UOM@P>pn~t}q^W z?=l1l_E?ucUGT90)kV3)NHsWzR@o-&Et{mFDIYVL_nG6#zK?~OZL=?fz)FS~3r5&A zLwrpcEth@KSNx_HWDt63_~m?Ph&xwHsTu@19>jp~n#&{};uX`dfVZeVH||rh!3zg` z(SU9@k|HP99bP|-`bNoMQz^n&R>?jXl(*J!@}-dwQN<9z^_*Dvjrse5A} zG?}b2X0MLfFe4Qs+y!^tarw+=ClT@gR%!3v{+eP)<-0f9u;Ny^FOGsD_TH(U=wtDMgx+)BB5BNFC4Fw$m-;-8`37|*o>u;eM&OCIAb}Um1T3mEll7MnG5OGLXan8 zwk}DT@v|Q)pmkweE(LImLTv3Nr`uRyGWSSM36<-DeLNzv++wE2^bk~<9z4l>t6Pml zAMDm$VoCkR$isaT32oB!5w^uJAodu<6T<|#m6E97MbCB^ZxEk+yjsOIkH2+sMeY=Q zjTTZalM-3R-xl>lNbzC_ss1WO($32W&=+TQ(A5S-;}Kn$pofO&y5&<%*TdX6OSwLp zSzG$L6slCHN}=Nvny1hLg-%jvp+eOPEmCN)LQ51{s?ah)1r3sOhR831n(GNt==G+N z=oyu02siTPG-MQyWG4(!M9Ep1OQs3q*u~OhYMf$LsT!NSk#dESOC@;+D_KBLSTc7c zHz${*r_9BiFe(jp{V=m?I^Tef_7p`v(3t{aAs`(2W`gx+yOn-(#$;!KUClMSmh zq9daOLZU*WBdy?~(J9=hH$zE-dzQ|or0kS2x?^^D41Q#g!pe*-XXGZExJ52f2HC)2r{5p_{L#auYfiM!|+>UWWcHs#XUG{9gp zgFyyc7@X&%cKR}dOBj5E!L?3WLtk>zX>^g3*3uUl;Bzfq!Qfj?I-Ra`QU{&S;6f*@ zql+0_&Hx$f>6;9$WAJS!oxyd_qzf2)mBFP9u5r>?oN*R?g~3$}u6NP~PTN3VbAq(5 zGq{Yw)iA-eSgOJrB@J~2%Mm8+`9x~Bf#PA%HbYb`cb5$t|X^F@RFZ6rF| z;MDU=15ZZ-{TW!wWs{8u4{tUeN%_P$$|r`BsBk(DGrnB}MV644fR*?XcxIOl(ftp| z;!gnP$i$`eB;L6KH_%8yJTaLf#YU)Xn?!a#vJ;1w{(!dcrTk$!y~CX|L_78%VVjxY z;DoHj!?dah>e z@K&ny*b{W~Rw^2%_72W-D?@Z^b@mRbOQxWtOgX+hLEpKVoaJtjpzp3VY8ICB%PpL; zg9;DdMy_(Vjlb-Rxp{YXg6?~q&aBSyqqy(~+1pQzK zIq`;s2R%6ndSJ(a1)%E2r^wC7_!UIlnV@@9EWM11!M?LdfqYEH2u;VR6jK1&p<%?j z=p^clK1npuOxeNclcQYyW z9c0hi2~0L(A+4Z1z^g(1H8hF734?JhTD=bD;#<&*>tVgNfy(XZ#f`L(Zj!xTir!2@ zjW%#P3#GGAvK#n7ozX*nV@?R<9BbsBh!Hy+W0i$eSTmzvDcyni-=8E)*PYuk>P{U7 zQ)fy$8s%oEKS(!hqe*3ZDQ}q8fG@Z0DJ^@LwxEJ38sISrqK?GcdA}DN%C|y z+Q2NR6hfo7U?p$cNb>H^NZxA5+=R&6Hj=!1LEe2J@BT5!W81{!9h;H7ts}{MC?k0* zljJQmxR=Ac+L|K9Dfu!4;oW5+BqzzI9BCYxkU1HL@y3ya3}+-{RdN{92)S`2A$vf` z<6{uQRvGJGNFy6q){{~^`OiIt&Q8$n+YEt!h;CrKLdv{pm<9a^X*SxE9yidmbo=TJ zr9}L{1_cgsE75>`MY^ZJ=5mn7K{FgQ%R$FFsMJAa4k~w$*FhBys&vpi2c77k`3_p( zppzW5&_UG>TI8U`4qD=%r4Cx=pgSG(0GO|0K4hoc#2pOwl6v+z@B?crd&xR}WS6X8 z&Z!EX^)f^8t_XG`(gSUb;gOhB)85{?p|+u>t!+a~P5UbBik7cgxw5WR(9Bxw;o)cN z3T{>d8ap0v#KtaXIRC3b>k&qNw>-ec@eTY90XVk0uyI3cPPt8%{$P;C^E~Rf<`;~cv_`b zcuo6C?@4^lA^mlF*b01={vJNT9|*!>-l^eum&xT-1oub!*DBC#Rzv-ANTKP6#)u>x zG?JK#hWfU4EZ>uvkzVICBN#TaUpz#XBGwy?X z*w_}L@SMz;%hfAU+TNVa9!2@kh-3%I*sF$3TDrY1jQ|Ie5cylHtXh1g~06Cp;za z1M1u>

xGR%?T3W3n~rG+(G6)aD{h4;X?k1Me%6Ea9&@Lo-2}{DL&F+mhXabvh^9 z{HjZDs(&sd@*u2<2boC)_^c22^~d3$(0sjm0y~P^^wo*eQ}n&V60W^lp~JUHeg|wDqNGgQaK>lh^AxTqs!{Dff2QSN(Dff zDQ04QGq{OZ9qBbprCPb?NtR8evP!XQ@Gvv4xj$}U_>4@+quOqP8#HdF7MN8`)c=!r zRi|9K1}yz4lsIK-vy88T0;Q77VH?{stCJ9h_X`Fi3b$Nkt^PFKxp9nbWuq30Ay8;3} zoJ>FrhTPMdij|*2DiP-4EEgI9DQkw>XTjeLg9Zq39N~OcFb(PEESKL517#0MY0U~n zx*?!^;GC3yhv}_`K{Q_tRYgHPaul)wDev8g84B&PFB@3+ku+HgvC>L~bs0`uxyP@t zIBhG~27@f=w5>2ZJ28j&XZWy>&gkGt`V=wa2%0^98PmTjsA^&bXC=+0po$4rN%DO{ zKJ%k8W0fvY-D+oMo)jvJL7h1Y4^FY!>u!wnXyzLEx+u*Wt9rW8Sj5E+!oS)8iGWl` zSjq&Bvh00wI(PBIVv76N+JqqaE*L5{$_DXv%n@u!`N0Q9c+t)5q^Q=5fEUXsAuHA& zV(B%GWpyUvKtRT{A>DY>=fC8M0XzCrQ=6N=MowY5NHpy`pB9Xsc5-wbhbF}k1P3B= z5u6v3M@b+$?u%k3Lg)2k0_(v5k0uzDJ)kds>{~F|Vd~j}Q-H54beTfmQ0Q`nu2ASo zg|1TQYIp<``ldqHDs-Jf-%{v$g}$xO4GL{lXq!UY6}nNOn-scPp<5KXRiOtJdPt!k zDD<#G35A9f+NIELg&t98SfNK1`k_LPVIJ0dd8EDDeH9vva~*7py+t#9ng$6dYH#aDE)aY_ngM$)Bj#+|D4hqa3v%m<+St1J_q}f43s%1EM_!jHmri?F@ z-AS8|Gn6Q^Ah8IIQPL`WjBnu>rOU?bvov*!xb6fGp{A$KbF2!*euF8gEJLS8r0Od= zdEk?NZl$lmKt$TPm61AkykoAp8P%`|{tTTJRt}9oZzwI(nAWVBj%KH3IP#GWkt0fK zM>mia>Eq3Z&pJ1Ql~(rTn@?gUDJ zee*xFp(IwzmJ~Wrk!swUku05NrkIwA9kI^NAj_j=80}{|i_NTNnM#gUJ0@{u24-+{ z%4ktaE~*w~Brfgv*EA5L+DvI;T6t5m$07vyP+8DGmSi``_;5-KBGx#!tOBmeC;5Isn z@u@EQ2^G8Ow{(n)dIj)pVlYRb$a4&SE4Z9MxjEu!7u_dN_!M$Y*<5#yi|%6ZBL+WZ@N)+1M2U;eWbicxcZs<;zZa!kqs&F;h;kQ2 z7+fm6E*cOOoKfkbuZk)c#l>+hS}Eqas7{>VqNq60ML!nvUDPTTfPdm77sbRv7orZU zxf&R|Q7m@R76vbfC7iYtp#@?YH+eDxaD0wf&Y;#sU1EicLZZ$^gJPwN`ot+N>K3bV zv6-r8a4Lh<3>uvDs%T}<#-N?S8U||_tYdHngH8s$3?dBr7{nMLg5Y<;@1)<0W(FIa z^twPm!5_rgPWq!j0KglZ@rL*UgKh@>PWlt4{aG|Q=}mE(lim`I49;W_Vi0ApnZY1~ zs~K!}(mpP?kE`ut3ib)aE9?^pZrCRfoA5V**o41xxwpkxPWlIzdske=;07nX&*Z)@ z5c=?Mfe?ugIQIk5!eGEj9}0~@7XyS%d?>a$=_7%VhX0673=qTcA8{oEL_&Pbbw3sX zCw(H$Wq@FbPXwYKJ{1Ua_*5Xw;lIqL{oKp_0&x=i1;Q})Gq3iGZB9DC83&ka2e|PA z;!-Du!p9)YAkJV5gYy_%#Nf*ezRKV-2AAj2JK}T(!94n>=wQ&3NB8fPy6QQaQyw3%_jZDD z8B^1PH8ArV0UL^8qtJ>qbOWb-AK;A6iD;VRg@c5R&v|V)M4dq;mTv{$Cs@Ao@qL`- zo1<|~wtN@idzs~XDzL&b0peUxK5cBXWJm}M7*Y#}&qHT|0zQ#m3>rWhIZKDc^QHEO z#ZB^9)27IhOydR|=bufv z%SgNd93pGzf0x8-o^k7VaZ*lCfO<#+Z5GEHEm+RD#VzveR+6cok_Ij0Whcq|zloA} z^GNb~L0%Z-MLvVPb2E~6^GNcd8Oi$!PV)6}u=edH8TDZ4+op__e}Q-fy>jYY`tY;? z)DOtF;9UAVOD}Q^?r`7_iv}|pR^Pz276Aw>7}LsjiGOXQ{L+MY&z)yah+mYJ4T%?0 zY;wymj|&i9aUlXGEX+$+L6Tx-)q|?p1||n9pvTjJGXLyNf`^c5FoT${MSZnFUb-+4%~`fzJuTsv7_4l zAdByGkNqjiV=T9A<5&${j@{FDiRY@bWr;#hwv6J?bC@`f-IMJ;EFpe2BzAISQ9|6Y zjdJ;U``Tf8qhpwU*Wt+-688)Vjxfr0PeIvg2SSY;I*n-mF7)B)gh(LlNIbNI@~d;@ zn@8JCZ+q2_9V30VJPy!4u_+jfoZI(m(= zSjUBpPDb8kP^51_k*+{Q)0K#Xyb2MQSJMJSJ1s-B)9HwIIvdeWgY<1gd|gGCBHHN+ zL_1xJXs3JWX2f&dLO-Qj>1C`S|46sfU$HX%n7%8rXa@}SU1BEPEmS;9=^jwF2g<=$Gi-FKpM-^R`>*1>1M%SGJw>YuiKg zqU~||jcqTzWP6T&Yx@PgVtWzXc$t1L4acYG`2wt&I|b%(#18rCi&RBf=tB{;z=Sx^ z%YLdC1+Zr?BmVIzl*>Uct3X#aDd>|z7lWJGpn5W$g&IzAH$qldiCpB~Mp(%c5&-t7t9W z>^9Va3AGt5%s|id@*bGXY~*pI-TSDE1+;Fd?JuGXVmxgsbo8cel%2IxG!4`KjxtE+ zKZe9#*-W}!3GvobRFE}4n~m9@i?VkjF&~L+FP@?khUs-_xDw(o?xJ1dr$gfYYUuQb z(o+4piLKWV+aX21d6Yfgy^M{cA%QJtCv4V>Z0y`HSg){^kl7AB+p*KTOT538DL#iKhRM=B>q;N=gDJ+CB)x7&fVf8HbhtP+ke;){kPf$vkoTyr8?i8&o6&Uh)1{5 zsh&Lkcw6uIZ`llf)ZvCDhjASeFD1mQhROe9hbPZq?1OCg3%s6!g!mN$gq2P<(d2vb zc8L#}?0cEpljNIc66{Z}eZI?+mk|4O`dvG#3-!;!J=K$CnrHH!rlc)|h1y$=xeyPK zg08-c7|O%w3kYxaLyG)Za^Weu#naGh63>elea3O0}^0j=8&Yw;57%j<}j{j12q z#zGM`;Sl*ER}_joSZ|v+5?{xN0`#{ER2Pa9#bmKexWy_lO|+uKS;7Nu9wFjlrZ^9! zFBV6M>xC-r5l4%MVE1>S_OO^Go)pJ|=OyCjVlKE|B3{8<@R}$C-@V{r6*%aH@KxDt zVxBEa9B(^PoG7j0Yp@DmKp6Igpbr#c>3$JxR{_0*S>p-VxO_w$o*`|V6RWwk(#GW> z3b$R_IG4BwT)YSNu|S*!d%9i}kxO(VviL&uJD(PaComHf!J=L)HersKj5fX@dZ`hZ zaW*EF)6>EU%exyhMFZA~x#C2`BEF2+Vkc5|!}3l8{ygy^=9EI%Gmm(SUJ+Aa&$8ez zIbA47gM~5|gLwNT_zw2t?bmp-NxO%bNCWQ?u)|LFBN(gE>tXSLfhtPbX#J+4>?xX6 zmJlyDV(}nVbt+z@roM$hV)5A418>=P%BW!}QCME{47(8azZz67qC&A4G%lf1v6RZi za>-#8Efj*oKSQsuIE9pPUkEkl(6iu(FljVO9gb2?c37sWe%vCbwvml$7dtJxoQZ3P{85WR$9q(XS$f3G=bd#u3^!o86X!ryG=fL?7BPlR^_e zv^gm^J$m)Ibqn`x#H`2vm!QHy9H(Q0kN67yJ?Y|Q0IG50#FAoM`Gp%_jOeT-#WJ9; zc-d0t;-kG@=Rx204ae0|M^Cz z&+4;z+Y+|T!+CoFdX8wO;FH-zO?D{xU%VUxv=STxUNac z+aX`pB*XL%@v5fJ=c1<1;hLs{x}?eL#R5ZLk}P$q_*-loB+I)+mK2-epvC%?F=5>I zu!Q3x|JO)T^DLvda?ECU5|4cz?Qoz$j2l|a_cma$wG`Kt2rTBDW8UA2rJUt2`BM`8 zHrG_uO!v8_>XqR&S=I6@6l>#*AytDtB-X#z@xe>V@oMm8tEoRMRnr%t<5lI$S5tr9 zkyXu$9L7Vzm$9b)&K?Ve48|G{&+HTuyxlM^9!q%gxSZk3T2p_oP8g>t<1G238W?$b zYpMY+_FV_D{?}uwEmygYWYfsYbW$x&ntV_#vhGQp(0?#Dvb~YN$V;_Xee^-MC(kYQ xAO2WWkEMU)7An=;N2?F2xzvWLWpy_1;;`X#(VN(TKemQ9#4R + + .\lib\nblibraries.properties + PizzaService-ejb -- 2.39.5