From c53392cb6890c8b1fb882c8cb5a8547e0019335c Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Sun, 31 Oct 2010 20:29:08 -0600 Subject: [PATCH] changed note field in tc_accomplishment to notes --- bin/upgrade_1_1_0_to_1_1_1 | 3 +++ sql/schema.dot | 2 +- sql/tc.jpg | Bin 320790 -> 320873 bytes sql/tc.sql | 2 +- 4 files changed, 5 insertions(+), 2 deletions(-) diff --git a/bin/upgrade_1_1_0_to_1_1_1 b/bin/upgrade_1_1_0_to_1_1_1 index 0337a6e..7936a7d 100755 --- a/bin/upgrade_1_1_0_to_1_1_1 +++ b/bin/upgrade_1_1_0_to_1_1_1 @@ -90,6 +90,9 @@ $sth->execute or die "-E- DB error: $DBI::errstr\n"; $sth = $dbh->prepare("UPDATE tc_interview AS ti JOIN tc_leader AS tl SET ti.interviewer=tl.leader WHERE ti.interviewer=tl.individual"); $sth->execute or die "-E- DB error: $DBI::errstr\n"; +# rename note field in tc_accomplishment to notes +$sth = $dbh->prepare("ALTER TABLE `tc_accomplishment` CHANGE `note` `notes` VARCHAR( 128 ) NOT NULL "); +$sth->execute or die "-E- DB error: $DBI::errstr\n"; print "-> Done!\n"; diff --git a/sql/schema.dot b/sql/schema.dot index b6f961c..8641519 100644 --- a/sql/schema.dot +++ b/sql/schema.dot @@ -75,7 +75,7 @@ digraph schema { shape = "record" ]; accomplishment [ - label = "accomplishment|| accomplishment| individual| date| task| note" + label = "accomplishment|| accomplishment| individual| date| task| notes" shape = "record" ]; task [ diff --git a/sql/tc.jpg b/sql/tc.jpg index f6eef0bd807fa440b70e16b89b9ef12091362ddb..1892487724f618a6a3cfc4836c17437016f95310 100644 GIT binary patch delta 4658 zcmZ{nc{J4F_s2iXASsibEK?1UHL_)wY)MG=5kg4FGTDtHN?9^x%D#<#U$YEl4Ph`S z`u@bX!>YS9a!-z(n@Jr zh8x)d^C*BL-3G#Z>d*YSZKff>V|l5l_lMt?Ucr#K4T%II<>UCDId;W{+IyFX=j+CT z%~JN3nXlSckLc-(Cb-iZ%XI(S3(6E^g5&t_d})5MR_hy3oBvI=$q?{zJfpl4I^ojJ z?mdWEt#w^YOKU&>tA9f}w^6L39~ld|a$C=ajwwAMcC?Zd)4%QWrj4Z~ZpuTde7T+D z$NS{>-tqL?-ciB=ZWR*mYr=gxX#iv=j8RRY#Qur4v?RehH&(GGziisY!~fOS2<^4R z2tc9LVM)+WQ-CCM!ua!{jeW1L_@(yi`aySv3BGmj#0k&t`Q5uNo4Ss0;6lz>8x?G% zOi4W4`jD^*YWOA7+9fRczfJuNRc|lD9MVbl>YlJPizfy{h2)_~b_!R-4cb1Uwf~ z;#YWGKPYD}O#=)Yl+fHuX2|P7*YA;LoSz*TtX~hx-=zU>$U5cq@ju!)xtlGPnAx{Z zbOp!HZdS zpQb`M-D$vXtoz*65yGn>!X1|VWK~&4)&;Jg@kc$1z7vt^esN;i^ypo7kUYA)0L+S7 zxW<4+^@G_t;DuetBMxC2P`L%ANW?TZ1HaK+o1n|cNu>n{o6S#BV9ylgc)-((8;g*y z{@&hdk}Q*yxa0ONWPHOFyPMc0<$oWghp!jZw2PZvMw>(pxntg(YY*7EMU!8 z4EO1BU?n38?Kk#3reZMVg9z}Am)SI+7{T9s;f~jg^41`LfbOPmPFx+`vfnK`evCqh z-$wIl(6b?*gzoTe`YhQ|IJ9>E9i}(?-JVP~3TfDk(VZ!2vXt~4c7h|?-Y$lAGGK-y zTjA25afY0=@H*KB{i`~PJ*L6Kjdv!A8EuIgSbyO;KBCsRbNqclbKN*CSAK1%ilVY8 zRC!tG1Kp^nh7?M7ETB^wrPe%@-ysn$ee*#z%G-REfx2!XXopdvvKv1c?wpz{E+hFq zwYygrTC{BR`?I%Vo~-FN?fZ(6e(hbdsjFAV$mX5}Bv@DK$MmU`(!8?LqN#6nKlL~eb@#3i_9C-e2 zJYK)&dXV|I2p(+Xs7R)uHsR?~UEI@FrzOc8L+DNZTYulJ6%|)XR-`So9wbB66k}4m{CKXVwnt^Psgn2YGz1)`!e-NoZaA*UqQ=nx*bQVEWiS_1b~(XIN9y0(w#)7zA3_u{g&xPkR;+uQ7kF)LT(w@XnF!M* zo0x3U047634oN4k%T|5+WAQaS;>}L^4)?FrpFJbRd`Zs=S71y{^pVhP(p%jTvij02 z{Fg#}c}#8aVcA{R8~tS<<)Q2F_pjE~pLnAC{(xXc{-ujvR#qhBa``o>{FmE14_lh* zZE)G2n3HeAl=~ZIKx3&b$nfHzHM8B>^a#Q60DKkx5#Fb;J*wY;oNW-#e6mvAqt8nL z6hzVQoase0r*|t~FA??L9{z4f9(7+$o?Du_&!QtPAeXGH=@8PlJN^+5Wef8~D3py% z&-A%Ceq6pR!r~3`5{>z`u$+^J4)&rK1Z6X~p=tGCaqC;RUK#?dhU&$hDa3C4n6+I{ zNdGPL)JzOs?jY{mV-HR6cPK#)2U3G%=t-G$4Y4BL=I*)`HN1No`xj^@vo`m~O-%7i z7@hjh9Rt_yp1W zvqc@Cmry7%|X*Pnn<2Yhyw~Sn^O_>F6d_06{Y8c zqXzKn!#VpJy{S#`)#8Ogjl+Wj31+uZg~wZ=j^Frbz*a8h7t_gCimo|zmI#TBaJX<| zV}44}hz7{2i_3NEmsR--=Uk_tr55(3+%#!q>-A;=mhLK$TAMCMFU+%8~1@X(bRsh zG1{~bd{wLT11XUPTye=dpg7Y2%(GD%(9yIzPyUNP^+4Z18qn*Zxd;z(3wwGvIU4L; zBR)`Kud;og&(Ja{>LuOEbM)76un@}Vtv*PEHtRrL5;xT{{x3BGZ+|A!NqpV=<779+CU~(ivN0>0^nP zvFv(sHG1KKtb8Wb^z{-PHoKXL6?Yqz6niArd$%jg;hnzFQQdF7)!z@xT7x<}vF9R0 zq{k+!rx`XOqc@Sn&Vy{$wz$rbR=d0{|N4BM^NiV1a@MmsF^d{SGw-+M)VKUli#|Tc zqP0v3cj3(7`(n=bcVJZ(rYgxM+FI;ZJi#S%q@GQCiOxxg4@R#?mGJ1sfb)*7cWC1y z3QvQH9-mCxrQ{^}Lk%u9wa#mb`RW|aw?Z4|oW?+?pHowIKc{p(J&St{DV#0I z%LYurA>L_jc^f#7SX*D90a*KRPP#!4 zs?wOW4~Gfy z{g=KUuWn7{Q!{0tINMa=0@m8_72Ld>uLN8(5_K&EYK6Y~d8WncNTIy#|8Fn`0MX>5sC_$mQjra>Sv?mr&!|;ae>0KR6O|mFA8s^s#^sTKfp}0C}IClidLD zGc3dUcZK-GX2 zSM_OX{o?f(u2kBHbi(mHr>|Rh$!`sNIVT*)ix=0w_{sv54FqtB)UpW)(xGs<%1AC9 z%Mp3(^T|I`<*%?S>bHKpXvi`RiQ2wdx^Kz^qXB1znsUi={F50Ag7OpxM3+{GWcwBe zQBu8FKYrRsRn0ta)}7Ke(Z0bQOP$I-LM}Y1pTKFsz%Cbom!o?V)L+t1x1E|AeLtk| zu$J$`qRb~{0~d@%wjcg8@{DIcG9I#BzKfIyrUBk+oJbOTYV0tv;0?8HYOKq$lmNt&GH_3N4#sl18lih1l}XI#TMC@e?UVDH<_sL`ZI&Az3coj$HiBg#Zi~rb&yS= zI~VQhS5kdq3Br>K!m9RCpUyaH?oT-HRpMN+MIcOyJ7F=n;63aOom-$Im)54CI)k6d zQn*o9!UXj~qh7<%_-g41gMs`0PdX#9#HYop z=G){Dv5I;NGx{s9EO>!)fEWm(Bd}YZ60e3HHI$;3U+mzN;=x+~=RjrOBw@{?a375`^sBa#sjA9x}kwXuVo$nnV5!mI|J?`@GSD>e^YK6fAtA{b$E1o67cisLF3rkNZ)FO`nnfeNjBGRhK~C~L&+1E!ROy#Ut0k_*dT%q7 zHPQgbR?WSwqMnHwHykrCOM2XVT}RCIQq*@C7LY^)*3kmf1%VP&|IX-s1~0nU?qiEetS*&VXsz0 z+QW98`s4wjyZY4ByAis_E?H0BQZMu!_(8ivx{kBeC@~kj2u#(ws##RV-VJ-*a!h@E zjh(Gs_bnf=Gc%_F+k+55nUih+*>R(c6uU~aEMUjcfFBZfA17Q<7e>dT))gzOD>8dJ zhVRxUjCM@$d%E|qivT6TGK1j5C1cQ8{j&f>&bYSyBSM%F@VV=n?a@{QqRP zlO@kHD}T9&DGlVgXgumnlwCf^qjJkcGtEzWJvueNmOL7Oi_B)tjawaCf_dJzr*BL?sxU>WrxCYz1pp1nMoa?<52?8o})O9K1Cs90JoD?`7pmTT?CcsTZUa*D`ErfYo^WuhurC43$!F z3ZuQAZg+8Y8QhvOMq`qHP&wSYC2m_U27yP&4!hzf0`3pF@!p*KU)sArI5=dU>A4ys Wr@>F?P?1if|9g98cnJih{rV3Ty)f$l delta 4511 zcmXX}dpy(o|NqRTbYYP@+Z2-HvLx4HB)1%ma%be0ShWbv^+Rqom#}jvI_|k_ z$246f>00tlTbqF7iMUO72 z#(bz+YXUxCR~xiNwLRpmaDD2^mV7Nt5Wh;CwpM9#xLtys6k}+u3^kEXHVr5?WXe40 z6iI#f10p2AcT7)e&Ao0qS;ktY%|Sa$I+z|(Y5rtI$?MB8g=ZS7<3HFrz;HI&m`65S z?gv3WrC(Ha^tzg6Phq zZFaMG-#dgF!Wi|m=vVYH(;AGmY7lbm_>bft@;jq5a7wr{E>fOx#BH#okD_Ld9{x_n z&kjs&&9i^zTAiNnDNr|B>b|{5?`k={jwHyD`?PYyP<2XaicNJlbMD`K#(xQ=p~p+z z?-Zj_GH+sbd=g`df_>5Tfm_Rt0X{6D@#KicQZoA?9b|MKP1 ze|#BW(^~s6H=|E8#2-gI54aox^NLuC_)veNUV|K9<|C{8TcCB-sNmqd;mN*W5Q?Wd zYFm3_Jzq>lRUMc5^H&wnqnRS1;292e$?0sDCIp20*3+iJ3UYFkEvM>yTyS0VdTK}J zX`uL+(7_7~w?&q#{m>qQwRG9aU#_ungtU6wA^7wu9-j<>p0m|dfcca3?OTAm-e9DT zA0jCPqot}PNs(DtoBEZBIxQl9G5WV^V8%z3k)S0fu%h#OHLi_ro|v~cXZ6d<0w*px z>XU-%y39FUrUVF%wqEe6=cs(wZL%%eZMa=R&e1EOzOMi4L2pOW(ULUi$mFZY>``wX zgd8iv_r5Rmk?91vSE|V*;+*>}-}@hXwBO8C=DojrlLtqP9Y5*KLpWXVU!|uPWE$~i zq61uJn*u}54U130U!_0aqMo1}ZT5&OK88rIiYWDo9sM${`1f~Bq}!#12nE-npX|tWea93aASCt$%lyg^>0_Z(E_x{4 zQ|rj7Uq5;K8uhurtG9%nJvu`ou>}*|zH_w|{HauW>3+dxmJoWdbb49kWl@asLU?_C zwX@>t(=fq_y5LNSqnh(k(Au9QN4-kCCc3#f>he2hW~%d>$**V3K=wQ>)Oc?lWxKD| z)JT)*Z`toJ>)+o>&Ex`I=*ua!wo9tAuXg@YHAnzLnD%NaP6Hv0T21|H*Bhx9a0zYK z*$9*6uqraJ?;3!k@^{>CS&kSN@EAd{Eww^IvMcs@5j?;U75SOZ1(Ln?nNJBdYbehJ zK0Q_11)aFSg4;RTIw?|z3tZSlabz)EfI&yI9N|*mWDF?GJl7Y5SBu$K8vjbXYF{EZ z6%z(4&z5@!fn|ri;}emy)A~oc?Y*=e{YDuir{C*&uf-=zhoiK!>1K!HT34L%vnM|D zCGxze&hE5_z<6HKvW+|VEdCwB8suX=<^m^u@;7(Axxn+gBaUum9F@mM*HZK7Y_!_2 zsdI=`8K%QT`H%i%ca1Kj4Gr}|Ohs+}E#6Z(=kW@8{^GjDS67$siWz-YU^^;L>y`{} z%G5|=%s#328kb(0IdI-6NHXoC$wvP5IErzFMP%R$!=zi5y{gYYR_NzRtNX|%`x?Bx z&;aioAGuj6e6bv2^cJ|w52#TK`}vR%PqFQ%%ErG4EQ?=xHX55^aaW`-|$e;=dKeN7Of_S7Jyty3O z8Xm_?^Wfawy~$fs^pc4apJ$J+`17|Jm&D=^ujjq&Dh)8)HKAznd#fJm`(3>OB z4=Lr@5hMp2KP`*d36&6gZTSBFFd0B?(Rh=6d402OY{9lRZO19)*Vmms*SwXlG}9Gg zU!v98LxmDSgU1PI=$Q`d3h1TP^t_erC&6!jY-!hLZE0t?&`o5;*UK%wr(Ucqp9e%C z@Z8eTd3LaLbpD-mm$!}HsrrzEyXYXa!cZkq*kUz%>L>4?;L&csHahyDoD;=Ll5|n_ zVK@wwODg!P!o`sJe2dRg4~67q#Z-VG7)H0aKZsx$g%y zMf1%E$721CBMM7AIV{@6(tSo3GLbK zCsqRow}qLoU*T?j9F6k<$|QW+G;%WrnpqAVU5;IRS+TY__tUVAurLn+0D%7hFwd_> z)p*Hw078@#FamjfQWaB+GsOB5rJQ_(=S_oNv80bEyU(@hY|QH%y?-ur%AhKLs{ohH zz?4nC={U`s@vmEBdiOj;=2O*PFO@GG9x#9Gn7r#1Ez{l{EbTxk#b!NNvTC6=#TDLk z(;oOwu4)`nl`KuOA@yz+!3t(Y*^N&;#0A7XnhXq{2(K8y_{Bc0F|uN}`=KJENXDr# z><5I&P6LYPZ_tvFm0X31dUOXqV2cQU$JXSVnNQtrsmfS0l3@~Ci|oMo1inl_HWQ0< zW59E#=j9_7a=V|bJfMr6wLTAq91Ch^!Wd5Srb8U}ODzf$o+a>WW{Kz=+ppsm&EQfF zW6>oBfqJ+J6+tT|#fOFod{Eb_a10iP$6rLvR_*NejpzMcSHKEtYg@mp7N0rZGq#FT zmx&w^TwM9~H5e9CEv_qu|=$LVKfm0LE`g&6wtMfPgkbWNRdbvZGz) zi3@|;)XCj08-y3^qy_AXLiUmLPLp(#rjxiihd*eIa-0Y}22Vz^-*c>>0k$)t{XJhq z=eJ!@I7$uMw2%wbmm7Mpq^m>7#{^oX4#dcjn<%t;tK9QX?%W>tRZM8BiV~O_-0Z@z zj$1}#H}}(LF11+S%X&S4=$Hh@9`hsi_(}^mIQ~UoO+A?*R>=iAt-RFk#B7@xy5<)n z`(yO!D*p^L;R+Weu)d0I3+z}fkgax66Q{vGFx^sVK_U>RaV8+iedlA=O4zB~=^ab0 zZcCvNs~bF$&|R%3oGPXiE&y2Y-Ir8%{}PMuM$Qvo`EB$w(Z+5>R{m9nJcSmo)>mCe z*{mX?{5(9A@tTOhglz-mKK#Ww=cno%Pkc`7RcQll;A)5b*dJkk?a<%^m1=uCqlbm| zW&kg67-;L2<*4`;qZOH%R$$ei8rp@SCYNV+szxRH>>#dWqOtA<(MIVQvD(Bo}qY;{qL9&%;v_<}6f z9kz2zzIu|d=Qnp`x}C$tb zIo2U%A@@sQ&FIL!o~Z2uETkD}QomzXRqpEi;cK@XX7VlEa!V|Z3mkH&ei7Ls-K&&! zY5}bHISehodZC>Qv>0s{2$9ndSiTkO#NfYoSY_Ats+Eq^^se~4Y9|VFfl?wOBl@Wl zy=b55XQSMb81A)(rz{zs_}ye*5l=>K93GG=e)!l@ary^auxc4wR{OGUKy`-vl9EWLYs3>o1*(`l zFaH1Cl0dOFRn<+Id$=fn{z0{2y&0jh^$U)=(TJN{%O2*rHhr=iTtH;3G!?bh*9Edx zLV|4$DsLfW7HEu>D*v4K9^*8sc0U*R_URRkHH%pPdvVw;VDH$_NyNr*YbFDwcw#@2 zbS%yn2n7waw@5VQevnh0wd{j_F0@Q<}2N!?Z>1` z>pkJUL&ZY03{u!09Pgu-+0)7#wd~o|{%&;@+ON&aED$Op%!1QmLo479nHe<~jr|O? z=AF0zY8!C@)+UlT)95a;(Z(jEB|4p=cyFF4K|BXS&N-^>Qon!FZCDStPAhG{2BvN> zMFi&e_ujJ~r)HMkwaCY$y(T*+?OhD*{`dHP-aNv4@rwF^ihzj^ABn+FIDg`IZ|;9# zlBXftn`2J2CDQ(Frrc@X@}dSZD{g9J;d`|Vqd5iCyb8X%Kg9*u(o7UbvW*LTusLXK zdJo4q*jh32L4SYV&@D}nld7{PE)oA_e7GQc?{$?W7bu7`f@z6$f$zdfP@M2Ftd8H_ z6MqSX=o@EHE~sg>mfU2d0CwPbZ^z5Gw6x!l-P62fMGfEzLK+i@o8DFb1V(Sz`k}VF z0{4C6@m0`=^=>1VcAW04yeFu0MGCR5=e$3!G_Z(0evJWwNo4=X++DAJ<&9W?7+E%- zoQ3+^c7Gj5tQ+PWXhWO0EgUkxlMB%NDJTYgbl{wtlIi2lerD%+g?ZDaKc2Fu?ioqu zuV*c~BuPsoP-GGe)R7EdiIKUkr1i__We>4M+AlH2(ePlU>iSe68Tf`JkqbmtjyRhF zp8oDaQoX?u`IND*s?_#1cZ^0}5V%yF`7Ptaojz*o7+)xa*juD