-- access to applications select @right_id:=right_id from rights where name='Document Management';; delete from grants where right_id=@right_id;; delete from rights where right_id=@right_id;; select @right_id:=right_id from rights where name='Recruiter Management';; delete from grants where right_id=@right_id;; delete from rights where right_id=@right_id;; select @right_id:=right_id from rights where name='Press Releases';; delete from grants where right_id=@right_id;; delete from rights where right_id=@right_id;; select @right_id:=right_id from rights where name='View documents';; delete from grants where right_id=@right_id;; delete from rights where right_id=@right_id;; select @right_id:=right_id from rights where name='Add/edit documents';; delete from grants where right_id=@right_id;; delete from rights where right_id=@right_id;; select @right_id:=right_id from rights where name='Delete documents';; delete from grants where right_id=@right_id;; delete from rights where right_id=@right_id;; select @right_id:=right_id from rights where name='Add/edit press releases';; delete from grants where right_id=@right_id;; delete from rights where right_id=@right_id;; select @right_id:=right_id from rights where name='Delete press releases';; delete from grants where right_id=@right_id;; delete from rights where right_id=@right_id;; select @right_id:=right_id from rights where name='Make press releases active';; delete from grants where right_id=@right_id;; delete from rights where right_id=@right_id;; select @right_id:=right_id from rights where name='Contact/Membership Management';; delete from grants where right_id=@right_id;; delete from rights where right_id=@right_id;; alter table config drop doc_dl_date, drop doc_dl_bytes;; drop table system_emails;; drop table articles;; drop table press_config;; drop table press_categories;; drop table articles_categories;; drop table articles_images;; drop table related_articles;; drop table job_categories;; drop table jobs;; drop table skills;; drop table jobs_skills;; drop table resume;; drop table resume_categories;; drop table resume_status;; drop table skillsets;; drop table resumes_jobs;; drop table resume_email_templates;; drop table resume_email_options;; drop table resume_fields;; drop table job_fields;; drop table job_config;; drop table document_categories;; drop table documents;; drop table documents_categories;; select @page_id:=page_id from pages where name='/users/articles.php' limit 1;; delete from pages where page_id=@page_id;; delete from pages_properties where page_id=@page_id;; select @page_id:=page_id from pages where name='/users/articles.php' limit 1;; delete from pages where page_id=@page_id;; delete from pages_properties where page_id=@page_id;; select @page_id:=page_id from pages where name='/users/jobs.php' limit 1;; delete from pages where page_id=@page_id;; delete from pages_properties where page_id=@page_id;; select @page_id:=page_id from pages where name='/users/jobs.php' limit 1;; delete from pages where page_id=@page_id;; delete from pages_properties where page_id=@page_id;; select @page_id:=page_id from pages where name='/users/jobsearch.php' limit 1;; delete from pages where page_id=@page_id;; delete from pages_properties where page_id=@page_id;; select @page_id:=page_id from pages where name='/users/resume.php' limit 1;; delete from pages where page_id=@page_id;; delete from pages_properties where page_id=@page_id;; select @page_id:=page_id from pages where name='/users/resume.php' limit 1;; delete from pages where page_id=@page_id;; delete from pages_properties where page_id=@page_id;; select @page_id:=page_id from pages where name='/users/resume_register.php' limit 1;; delete from pages where page_id=@page_id;; delete from pages_properties where page_id=@page_id;; select @page_id:=page_id from pages where name='/users/resume_register.php' limit 1;; delete from pages where page_id=@page_id;; delete from pages_properties where page_id=@page_id;; select @page_id:=page_id from pages where name='/users/resume_login.php' limit 1;; delete from pages where page_id=@page_id;; delete from pages_properties where page_id=@page_id;; select @page_id:=page_id from pages where name='/users/lostpassword_resume.php' limit 1;; delete from pages where page_id=@page_id;; delete from pages_properties where page_id=@page_id;; select @page_id:=page_id from pages where name='/users/lostpassword_resume.php' limit 1;; delete from pages where page_id=@page_id;; delete from pages_properties where page_id=@page_id;; alter table forms add auto_subscribe tinyint unsigned not null default 1, add gw_password varchar(255) not null after gateway_login;; alter table navlinks add topleft_img mediumblob not null after footer_align;; alter table user add test_email tinyint unsigned not null default 0;; alter table email_stats add started datetime not null;; alter table email_campaigns add allow_profile tinyint unsigned not null default 1, add notify_email varchar(255) not null, add monitor_reads tinyint unsigned not null default 1, add show_in_user_record tinyint unsigned not null default 1;; alter table forms add header_img mediumblob not null;; alter table email_stats add control tinyint unsigned not null, add processed_list mediumtext not null, modify list mediumtext not null, modify rejected mediumtext not null;; insert into payment_gateways (name) values ('VeriSign Payflow Link');; insert into payment_gateways (name) values ('VeriSign Payflow Pro');; alter table navlinks add left_img mediumblob not null after topleft_img, add topnav_color varchar(32) not null default 'light_blue' after left_img, add topnav_textcolor varchar(32) not null default 'black' after left_img, add active tinyint unsigned not null default 1;; INSERT INTO navlinks (navgroup,form_id,header,footer,topleft_img,left_img) VALUES (2,0,'\0JFIF\0\0\0d\0d\0\0\0Ducky\0\0\0\0\0F\0\0\0Adobe\0d\0\0\0\0\0\n \n\n \n \r\r \n\n\0\0a\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \n\0\0!1A\"Qaq2#Br3RCS4bcs$D5ƒTt6%dӄ\0\0\0\0!1AQaq\"2BR3#bҔrSCsDT$4\0 \0\0?\0c\Z`I˓Ex+kjfx,{f}a\r[50\n]qs>=sR\0y>of \0{-ۖ(\'g)!92n P4-b~q!m|r|d#0\\+Ο&+V0ee%bIZ*1ԝYriL+KLvM$V|T~lqk;d&{>NcOӧ/\'JT\'X ˭y*\ZXJNhRUͅNgP ؘ:i&)̍I)JP+\0JLl86ꢹEٍ3^sR388Q\\ \Zg-wDӈu9M[w5Z|\"ɹw$a!ml9n|Vg&nImYix#;ju\r.9ѧ\0P悹fR)A-F\rZʛ#i%[,%C$+pEe kz~n[kšFQ@ \0Vܖ9qw| \'L3vsʫL\nq3j9rł&tەɹ\\ZncwOU^PzDw-ƽ멋c<8QRG)ԛڦ7 9n(qZe$ -{,Q\\n\ZNcw+ٙ[Te9Fi/TK u4ҽk1|\"^.պmw7Ԩ5@8 (D\05Dd$Vyc6fmWԮBx/n+\01%ZYTfIP\nKկQ9{RP%4#yr\\\\O2;+ȅ%wÌ#Fsk{ɥO,U+׶Ƙkw@9&\01tuKaLDu6,b(f%>sXYLkFq^\\4DOpAxCRueM)aX%\0(>Q_ 0#BPJ(0\" 4bUGLtCvcN\\jcP8yq\"M%u,kRMLGؠ@8Ȟ,TD>RN|a\'RH] |tʙ6+:}>NcHZ\\с,W\0 pRURJ继4VR\Z186\n _)B_g\nIG2|.p&R)5*3VYm# Αw<1cr !.$X2[YZߔ6,86I\Z{^2[z~\r=5ʏ([IR8Ig]^]\\H hH>!֓X]vÄ4@-( VlF ~f`~r\'\Z313iEZO=Yw_XNPheD*F8ypDKa2KqyZ!%Ԧͨ[VQ}3Ulzd q%=š˳Tp5R}Xc b闗y+dڗ  ťm\"8NI•:_en.VкUOpj*aP_df*գ/8иs0 d ߞiK_h[6J=%B4D)Ӷ#Jւ*2QXTi=;M#RiiuWR\\.S(I2J\"x@%@{H,Zembq1xlњI¢_y1s$13 G1Bq^\Z8F%[ЉaR!\'m{Le \"͝;~rͦl\"H&}~n%XNZ; ?(ZJLϮM!yXimp8J76\0{:lK+VT$j5Y\"1B>.,2ک=(qڴ\'R~|نSu 0@W\n%Vڧ-p3ˉ;T/RP%Eǎd. u\r6N9$gČA>j€@5{u7fL_6*N9F2!wmUncfT$󁋅9P{V-pXˬ!W?MsCB:}>JHYьהe)O2 ^\\5x+i\\\\[Iǰ 8`K2yWR̗mޝXwt F5& $r TAH6rHIЃ47@5PLX%G*é17܉F~VOj! ~P$+/6Kx?n4ÂxFSYnprhHރ&O 0-nC 56fj,}k(M[-؀_Y ZfQIϐ\nE?-Yplr#\\^2 HA]rP.K}l46@=Gh(xW+T.mGbLzXJ^2\\8Cf+:W=8p){ib/mѤwt\0~[\\[iI:wkhgD@Z5xӽ۳\nE/:.VGmE{/l%,03U=G[[J(yzǥ[\\*\Zfy>Gy}lЛUQ6YN5MODF[~9Gy#W~ؚdik9Eӻv_$UPjX}9L!-Tꯇ`>#tB%r࿕ dJ=вA* YET XL }9^2\\x&shhe\n_ŗn! _zR)JV\n6*lTwgwQd\0}Z/b\0\"\n@_vI*sG@?Me5L\Zz†ˣ%l1&BEjQ//ȿ -.V*-,dOB}Tl\n0!j\n n kP |,OɄc\ZOe}thsWC\\on) B-A(šJo\0\n|)&Ն2*)\0N%w8`\\ewIeIW.Rk o ^d(%>Z,Nw%njޡGK>fwwKp;jZRP\0Z*@ bh;&`EE¢Jѡ{hI\' \nT@%orܥdJ\Z+\ZVS3p.uT7{\"Xc_DwrG̍$=߶upQB+W֖.P+2G?gUsWđ.4e7}-$\"*ʝ\0>3[ 9eϔiB4%2\r8. P\\JUֵ<\r8⨵5Ep1w\Zt¯I+»#FVH.R Vk:P BHf~Mڳ<B0C1\"2D%mW qFG$[ӱwJ}+#c=S0i$ɂڸmzC:qJ\\!^gZ{t,sZ_MR28ӠXO9kp(V^c,DcJ2 =ʙ{` /0EZqnB)2S\0+ \Z{5Q]F\')m`J\r YZ4;Ugb6 Io\0V`F;A\'@hgH܊\0\n=M(I,L[lH_*#K1%G6rS\0.!^-rMeN:ny6{̲MJ&ra5&xIJV#(#x9bVM+4aiyJXwijKx~`1Clr\r3߮$ҝխ<E1-yVM9Gx6,`.pGw xc:E8ʯiDC+!x1:_e2\Z¯iU|x\0Ax[ˬј:)p M\"gVP-m$)bjyJ{iL[a6m\nk+`<@pq8:YSp=On )E|H I?H;F Jk\r[膛\'%VHʸ Jxƴ҆5pYnDjW͂ xIg±wt`gxqG\0wp(17R z8ܤa\\zaA1rԙom4\Z}kʚ\\<|ha;zWWJr3&3mdtu tFn> (Il\")\0r\")&#+Y-WdžLmiw`3 49\'meӶ\\um20w: \n\'Ka;\r13Ufja(:ո Xmeemk?\\f\\$D)K (Jxq@\n6bىn\"x\03eAW~4*&0 4Xك\"-Lt׺0Pq @8YmEr,I0F|G๜,6Hu}4VU0AHHPvàXĺ(S\'#\\~_89,:l\\=aثPŸw/`v.IJ<)cr\0GPX3{iV@&>oH,PYm4d${}owR@2[k\\݇[Ro`~\Zˊxkj\nB*in*~ (Yٶjq?#Tge!5ڤ%E-RufY[Z9+SMeG/.SľLz斑PJsO-[{!h2M6}Z 9q2\\b&AIc#d\\@q82m7i%T-,E?m5W_]W\Z3[|[wmlOc!G.EWƽy(NSY{W_\nGqlsy-}T\0w8/|[*{=ړI5% \n.Ol˚\0\'O\\p$eOqsˮL ܳ6.a}n9,Tw#%I8LYsk\0;laYf(d^L;m-T$\\!:j\0[K2[c-ff $潌m-q\"C Fv8!LѤmCur`xs׆RL%\0Fj5|eY0LΣ\\4YR@NUj$i2\'}8OJDLW-!D9,i*#F!q#BS\\dI %IJȃ<=;*˷)/We,JWW>&)\Z6ٹ\\m:d4mnC>< ]j$\0;{qqtA\'l CL\0םA.Oӷ?t sc̳\\\' oV֞Kpnm?t\ryӒAl9a= ]GrQ\rlt=on;{e\"Ws]Gj{R2s*zd`j\\t̴i.ړAki{|`4#|P *ڍdaҩ@E?o5Z&#{椝=,HHoR}\"dkYP7EfMuS[ں37ca/JtElD658jԚ뒭_5>P~+Fx\rX3nVkyXs\"d\0㷷\n\\)\n.kPffq7 \r^XK9Vk򟟷I\nq+-!n|x6\nkrӐ [YS eZ9hDŽnJ3u~\\+ؠ~0@AmW%2~V a52\"+UI\n qeC3o(w\\M,<ܷӃG@㘢&c+f_ww@I7ņG}S&ܺd}:J=˩/a*O|X6r }֏3hS\"\\9Y\\cVC>PK(S`*e~r>Y\ZRUbt&BIs=A&J\\mpӴė\Z\"!DΠ8?+2O2N10A͟\0dHR|3EgV!+.\Z_%a\'F]\ZS0~[[k$cd}h!=ҩ0Ɗ c8HMrRTTϽMe\\u EO>fHgL{M[(san_\0{Pb{g!d0sH{\"˭ej8b}|3ew$VY\\Q#jxc&̀4v܎b)=pwK݉n\\.Bxٙ(}8oOgsnwcs\"ە\ZM+6]e{\Z0 \ry8\'ł 2\Z2- NuE8bs=PWKI97rAĔ\r\0\\Ţ Z\0-i24kr:c<@ l|tLe5Yo4ֆ]H~iir/&fD惎hN0ӿ=Ket677۽Uk\\mQ+1Bթ5\'a%5BL`VYT [i 쨨Kp%<8 ky_[W\\K偉M+f5ƸS`^V&<\'jn]~Ƿ[KE\"h1/)ǨVVl;V<uaoA67+H*Lyc6+H\Z@iQI\ZJ wڣVBs3,h¾cA^2}{u]lfInk|\01kۄ\0Pcw.Hvyƽ-QLo2I6fcY\rۢ#f&`&ˇ\Zz+=>8h\\݄O,Hj$z]\0FrL=*/,RO\0<\'N fk.ϡfuoW-KKCgMu95Ѝ\nv\'~\rEv\"MzrRۀA~[[,GER,N-\\ʳ>1Gؒk<5}@ZOAhO\r \\H.5\08˸T`ҰQE xsNxf͓NV{Q:¹18ulb(g{܍4Vvrpʀ&PA|) jeU:=Qq\\1F\\1.ùXC|3.j&0]5ϿZ-LNՎ +VO1%.?ᔶܠZ&\\7{g,;S8m\\l:u?w/\0ɀm a+;F9G0&C%]aX7рi0vEir$-\0f<|e&\0&I<\0F,Z,w A(ʧG7ܠe)˿@#q SF.\ZJ5\'O8Wmf֯lY\ZP{ljxCO`:o!G,(#[-P\\zŋڦ;uy@3ۥemGa 6m[F~Dũ ^NV*AefLm%`c4\0 yq rc=&߽22\'2]JGfys;w)|r0Fn&E24)R1e0\rIB.ݻsV%8 CQ\nǁ1+=\r\'ӷnA}6ۆŦcd*\\Ƕ>piP0|\'7VIvccqMӤKj,.z$/`qR9fI;ۍ˂Fy4WSO왳1HP\r5Z.3|qJ68giL;2ƻ.j\'[`{\\0*\0?0L`%}]_jZw-5B2 Ț&{?x dRO՗v 1зѹmV{`0m-hĺ(T|8ɳRUZl2ZҔg☴9T1D :)4΁.dO9{hwD.A݄]axGU;hGT}sDd\\ \0:ϥf͆W$)+.tm;^{\n!2ӳ;g>;:\\2v1o۶\\/ $2zu@x\05;>`R[g[\"5C!/4z8--j?\\1ܴ(ZQ~񙷹kwz{T*H.NkFH*8cwΔ_.*H0\0VvM\ZViYRҼ0zf)f*\n[=vrѤou:+.rX&@cbk\r5tG.~\\\rtIz:].uCc_hu\\А{\0#[A U*y5ēwDaȁHsTlÓfA}ir&\"VnSƵ>\'0ymQ^ػo>}UHD3HA\rFulY}pZ5^P&6غc}cg8c}(e\"29Ůsso1KZ#13ݯUu[^:xMa^drTfGq;uGL}pDz n׫jeC@HZ)egA±dQׯpBWVƙ`[\ZW LT\01w l..w^iCݣqcޔ$@88M}J]g0grޠT-B ZN8҇7>ZU8?Ln_RJWB>mtݷkn![X!=9XPx0\\{eQn9I,u-sz=\0p۽zZ+m!J͚Dgv&6nq}`&إz\0geޘ<}=\n X Qu- osoq!sI#\'#Qlnl`.hMAAOb0ziUJmù+ Xȩa`1oxmS\Z#i<\'{w^cq,`y W4Z[y[VSq &ˍji#J^l}=wom{nf+y4椩M*\ZN5,ĎKR\r2=3?\'Q. Wnp[k+5kنradZ\ZrƾȯΤ~%\Z=\r#ލ\\\nCa}/XWGR廅y\0?w{OVub_\0h1Ʊ{T#0w{M}[cc[Uc;ռ;MՔͦX$h\06L1WՒmjE Z^r\nO͊o.[CI\0\r쑅I\0hh\rTq y aH3Y/E/s)~(Cg><\rchV*z\'Frf26\\Ŀ$:-$i +e`/,ahB\"^\Z\Z \nz0J\"@og4a%H]e\09!H\Z2X&X\'m΍ >:C=\'c]A\'=>-T}%Qk a}sF`;iRQ\Zp:uԭ0cZi{inpT8rnwr1= :}m&mE[q( xBE@ X.o\\Νy|&2OLʽYe.:n7=dӨEto]\Z9$\"4w0\"< FXa\\7Nx-V1w6ѕsω˷ LZA{cw`vR08)y{Wm؄WbAz22^pm`\n<.Xa%◷7n؟՟P:xdlPl<9\"\n1[Vn]4E&Zv]\rnC6ؗ۞/gi#^++\'X>׺AIfy OpߧaZ+9B墐qY`h\r7?L\"6zدq|XPuFpƕ5q).ZWJT>31~%]2\Z >E_wuq4fL`89E-xQ:r@;|Xеc&\\LR^y9b#Hqm\Z.➑5\rm\0{x.lx\'V¦*$c[P38Yʠ.qL~w*׷/b (\0`!Oeݽ+5ٙ\r6wKʻ\Ze,bx^.䊕\"\\z.թ{4;1J=ń\rVl|ַ6K8LpSJP{ ; vȾ21(NZoG39\"/2v)1XoijywΝ vKj+E\Z(?⚡6ju̧&W2;H5*Yb PD,[ay\0W8\r,]`}EH%wOFp\\󳷵`~+ow<ƚA)cAM.n%waI# mGMu%Tim#B䐲Ǽjʭ˷lpvO4ջnApmU;ݠ\n\"b1\nݠ^ö;05qO>1u=kM\03tۛ\\{4(ʏly;v=/+Df_lnŰZu&s,P]K4!Gj]$eXU/e.D#JP٬޻q(Έ _柜vu3]rc5d\n)a;N˷ݕD ,psԫ ) N[jjV(k5Qmsd{*QD]^!SˏA}λh2^-դ>ay\"V\019 o\n}A/b 7|\\0o;o\0Q1 8nPL\"ʇ ZǸׇ-g!ne~%tW-_Lo\'^orHY.^\Z:xF0S3.v\"mD[x-V{1sQ:NsZ܊ib\ZmXZ(w.t(y7]͕O@F#kt=u׹;˯| cnگIp z$qzpkvK8ZwjCځ<\ZVhR/k.[^OA33aTsmG0tWk%yӛNWVZ1W}`\rv3Qaj(mmͫ*hy??D$sE\ZPKv_mZx@`d䷂Rj\Z^ӆn)jeF3Qt׹MMuYwnpp+*V1omM1eCQo[ tv{g]_ב;FbM{m3V] +UH1-[GO3z4\"㚊7{{ݮcu*cBGI1[\"_oрEz{k#_ijM ǭP #Lm7Q٣Ks+,PFyr@pB\' \'Zvf\0G/]ZyX]dU^+HC#Ix*mW쩞z}Sqznc_Y^-%E2WhItkh+^ݭӤ/6Mbi\"FiK&ByM}g%i.n}q N2,]qiM,mRݘׁ\nq폽q}[Ok6Άغ6t)0^b}F{Tbm[{g%~\0}rirڿ쟢0>؉uqnj$0{\reI_~ ~Мjd^v }:@ w\0R>17@ZeI5&Am@EkSݞ^e58<Ũ\0rx`O\Z^&<ͺلw)]b+~I\\gk|0YhiEzL#:~\0^^^Gzb,…_x??\r_FǃJ<7xA\0r\Ztx($ueH>lZLfhξc\r :d1*%YohYD٣/|Brų\"5Mb\0zr0upatg\',exO@,v\\mˑ$tj372e\'S|0WL\"q#kVm]?:NZͻդT[vI|ll\"A1aS\'xW5O\rq,ưEm6}~|pebmɬ@$WFYW#Žiw Q$w\0#.\0Qݐi_\nWجRQJMA#qaͲն\'G\ZuC\n9<\\ՙm>:XKk4{5\0d\ZKFB9=\'ܻF^!. DLsq<`>ay3--Fy4><54z)u0:O\0z}FAzLs^Kj߈ܠӤ\06֪uk cO7>nu㸮-4fiLJ\0rG (Poᢃ͍I_l{rv\r,[?Q-̉1Va8+􃧸ܕP\Z֘b͋v@Nk\"ׯݸ(Mz1y\n|>3^k67i[HշaїN]r\Z}gl;|>w-Miy(%R-ٸFx=}ow_=:2]u\0T[4*N+ع,~)_J>jQ{׈;&C+KD[rD!\r2\ZM1x=UooU%}8gOʓv63Fb:ȪPf_$Ej$yZh\0J_hEI+o\rz\Z\ZƧ\ZkZT.j[cu%;PeilwZާ $wB?{\']ro|\r̃fz֟OՃjgéDIO&Tmf?[,rj:co\\\r\0( ei.82Pi\"|6MC{ %gnJ1Xڠf2ŕ1{ Z\"R\"Wn\Z/oP!ZN^\\:X gԍĆakUZ +#Lܚm-%Iϳ *@̈ԀrղXLM1au/U40>1kO`#6{Nl8wl;aoq\0h$pZ]-M#zŐ*m;l-i] `Vu# ځ^kmfU!iGӷs:]$h\rB9#^\0\n,`WXF~5.[]J+2tHIau]Җ6TyUz yrUn\0h^\'N܆\'[p=f#ۍ[ˇ,^G1ŴbLq1`5RJkQ?w2\05akpHwyEH3mQ6rDZqד{*;:K[H:HD\nykkSf>,ts9w\\tLmɳnw\r\\ HU.fbs1mݽy]B̓mV[Sޥ.d2C#-@B^AHy͋cvn-Jp] 4KrShHe+5}Bv#=;akN:P\\Is}Vl9{45f4?2׬2.,AtyIʢom=]F&%\n=UYX-]pR=D1w}^.}b]b軎=c sOG(}#z/,X;fYkLGkLGw5QtӢEziD5TRiCF?-Cn=0{ݺtwBCש6KK۷dj\\$($:^W,[vv Rzca]p=F ^i^G tI\Z\n\\+\rC:5mkbrf]X\ZStzwgm#젖]$ uS+t*S|\0ymHI=]U].g#i\'Q݌31_4=/Twܭ4ꈻQ,*PW@uL߻~]GGZ6|;-.i\'{lo4즢}NqjSی#sޯL[f\r^ \Z2 DU7PX\\S:[bs\"R{Ͼyˣr\ZpQf,` .0.z.c /.H[YJ$D g8o6m.\nT{FdٳrHI+LzbLYn\0h%;hQ{x\\)r[rL\\:\0Zp.uKZS8@~cx.>P{9/TwgTf120H :G9\0fCgK] 0¬dD\0/bׄq\0W&Iu,1F}_RYũǑ\'GX22LoSD LCs s# _D|Xӱ hk(77ΎWw& , R\rwo\03\'zw0[`EtD-uxxU,\"-p;Ȭ(U\rF\n4ڮun[sL҇)5SQ\"ȡ,K&o@\Z0*e0;\'6FϤ<=5\'w!\\6ɥf`D}Q_YA#5Ubںwh0 ^˹r=m#%#}r(1Ȏ*3]9MĖOViѤF\0a,1U53{eM\0uM ,4ZL8MvP}8}1 -װE$YEPL${ E A=p>,>Tpt|n)lgM666[C2si\\\ZVPqㆬ)|F*})}ayuҾxRT\0vPX#[;YU&(v4XV*㳃}3N`=W=\Z46;iI!wj顸Hۛa/*GgQ$Jd+P~\'rhOjm/鶵!{[RO@8G^W\0Y\03Ķ &Pϐ55< A\0gP[~-O.\r+O(B n<ҿg1kI{Ste3`AwX\0P\0^ֻ)\n$\02V5xjx??eߍ1cw]y&60 높҃ocE+V[׿!?q)XuΏj2k\03\0iSS\0A?q/_ \0^1QwͲ>MDmE|{ߐn͕ěR(TZc|b67?ioOJ t&.S[h>pG\0Ϸ\0SsO»} ʸ/ft/\0\0ξX[\0sK\"W\0zѱ\0ocMyf~=O>õ \ZX\0X=?kR5O˷Q ,R\0\\mV=O@ypI\0?\0yxL.|+m\01pf\0Fv\\kب4 n7k\02\0[4]_B<774kH~Iݓ\'7~m0gAvۭ:;)ANo\Zj4O?ۘkڴvAyn[6\\\ZӇǞݛ\r+Y[z\'\04F= ,Bs>Ϝcs}8n݇|i@;K*?ˏGl2-H ]X*}}\\.ʌg]FjUng#\0L1E*!#K9p\0S48u\"ZkGNzW)zR~£1_]|K\Z\0[ͽ0Ǝ=n\ZKC1#Q碥ع@$eG\0Gg~ˑ [F,6.&i\0_%am4}S~O)WiDfQu,hCXPa \09K .,pȞ/َ8v) ya/r1$N\"\0xiN[H38KΞ $czu{{}ݒDd˓;=+(g#_`l%+ D֟e-dJv^NR˜huD ?G8\'u,N;0eK g -T^:Lsm3 ,VDEmJ_|f  \\XUhݱmQ@Te-\\U3FݥS]\'͙W aon] JB>2nmd]UCe@)Zp8a3}a^Js<%nӀ hE<\Z*ى_*j] ж) c´#.={{\Z3\ZҢߺNWRVw\"AqdpCVY5#\"_ٍ\rըPd%:[Qel[pkYM~`di 4NX\Zx@ZRug3MEp]\" ܲ[+A nKs#ldÉjWӖ^\"!h@oNyėvso-24GI2uhмMj0FMb1~pj\r|;9zwxN+{[vڠFii^8RX=\'}#({o;{\Z&he&i.BFV/Jy,~?=]?r/+O;6[^z\rw*!FٌnN~VO{4=ҷ,HP<+6ƒ0g+krKk$tճ\0˯2HEOӽkѶI=::AĩSg!ԊaU#A#ᾒbULIңҠ\\K\\%iTqsm;JɤZjy)#ŕtuqe9 hX4=ڠEg \0ܮ2YIUDByIaşLpٲ.#p+qD-*1$Fw$B~ j9Lr+4+()iG D04-j>*CIuuL<ywRdܗ04mVG$.^h[-\'i*w!Z=37\0c^Q\n-$6i\Z]sIHSAb(U1E),Y*0lCK\\~\0yĈc!9\0<\r\\kn %VRеN$V*M9\Z0gE}芤O ;Fϴ^Nsi,]3+Iyi\rqTřQ{ϱM=5\':{q3Kd/{)nlmYv=Oe[K1>Y-~.ø\\Q[m7ֶ}Igs)K\0\0C-]GO}2oy^VJ)*lEEn\rj-Zǽ&`PoM_>.o =BjWLF3A\0C-k)p H1J8 X.PyөGq8V儒Ya݈5[J3=Y²e)mybTf|7YU-]ŴK .ZX2u-1@KLqnޙc\\0,95 hֱBj9w\'oVPx(\'[ o%B}6s9z./Б ,iS^T <ķa[N|qĦͭ0xF1j\Z;t\0 238(oqV侞KxhN. f@ \rR 2Ί^`GvqZeZv6tK)ۍak1|\noQ!,pސؘ9L/I\\M17c=E%5<#\0,rn%YT׀ z+a\\\rS\'+?vht-!&gn1K[PawTRx\'Mʈ+ӌcrǠgrxҦGMfUZdTgqj|cyu(Fcd:/vK4UQ58p(|e5t\Z$z&SA,_0e1\"\r#U:\04\n e2d0ÏHr}+$za,ثRxCoLdL# !i \nz*pE2&mQ\0#F55/ M.Қe*G \r^DS8nEA$\0X0dn[߷qm)\0Zf1+: Z$˨;gYg)aJGG˶V U| ac~lB_ʠŽaDzjݪ\Zvc._ح@8T&M[kuֈ/+῭W([f\rH>|21&M]\\[\\Ks4@:H3iiu *Ebe:j{dK0ڸ9}(FLGA1k-6hYjWc0ջ{חܶ[Y_oꞫ,iD=ye\ZƸӷF~skaӗ5lK{Z0EvDH?8\' zs쮛=xv ظ=UCV\'M~\n70cDdV2Ԟ4p4}V$QhF^|$cȂ}QŒ8! Fd\n\',z\0&MKF۰Y=/a2xV j{0w\n{Iyr5JKM{1JGݦke:0V ?`Xckc+\nDGRjM;<ϸҶt{W/kT \\> JP[-i䛘KD04\03\\$6i\n(00٣F -Z YmvR9^u\ZA<1BO)M@TzrKw]/PEU7nԩwC\n4hZ:&概1MiHŴ.jMh\rb˕_u]pOfE100m&+s<)jt|\nգ}M}h])^Ҙm[cqsiubNqB2 \\P\r\'Y~n.`Oo{\\W#iP*\0 8Vermg<sP\":\0x\\qm/\"(8M1&P75W,/\nwn7d4Q®M&uCm&$EmIz&\newś/T\0Io.V, ?mr=r[˶\0ۇ>4<ʰv05r7GuYel?[\0K˄ֻi}W S$3m1bx?ɆZ$q)7ݿ\Z6pqQ,a;?O3ijO^>xac|g܇IUflW dsY\"/\0I`ۯCXs*?pDgϋzQVo8ipMq{M醷o\0\\={ރ `!f\0cm{y|u\'*}\rsݘiG$?bv]r~*\0|qGu:yc~Lrg6B6muiGυ߻\\V3oM{9BCɀ[|#Ç(`L{K\0Fl7:ޅq+Q_Y~\'6S>g6_&=dӹ܈\0 ˿)Ǜح~Uj\'A&f&×{ͺ?\\Q_[I\\S3^z3\n\0s؍:!}~\\l\\XX\\%m\0nbeTx\06>Q~15fm(U0F1s`AXJEqvV_kXwfی3mA/߈eُ_8wO\"3f!me/m\0]y6_T=\0gwL$~[& !Lg|-| \'Xe(ex\0db0mf`q~?. n`Ƃe46Kn|۽~>~L5Hw?6x;ȷ<2D6Ͼ`;\0I|[&O4ྪ\0`/C׋cښFk9^\\0TIm?8%ѿ2R~ʘC܆g6~$ҽ܆=\rÙ<^;t;c#y5haaɰ̬', 'GIF89a2\0\0\0NN{{{ffŸ𭭭귷RRᆆYYݭllĻXX̑bbմ⋋ttȅ͌wwɿ晙빹첲\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0!\0\0\0\0\0,\0\0\0\02\0\0@pH,\ZȤrl:ШtJZجvzxL.zn|N~ǚ  @P€*\\ȰÇ#JHʼn \n4Pc3d Cc`\0(S\\ɲ˗0cʜI͛8ܩ@V)ѣH*U*ЧPaիXjuiԯ`EJJٳ0-H˶hʝTAn߿[*wï^̘ˆ#K.ZOSe\nB\'(@uhZ-.m(g^MKڭv݁t\Z+9\0 hWA#k׎r (k\n8W@?a Rֿ?)ǂfh`%Ԕ@W0@@\0\'B\0 *ᄾ}\"9@\r\Zvaz\\\0Ac@@Xwp\Z#\nh\0\n8@d\0G^RAJ>BT@7fecJ\"()\"  `\0 0%Zh*!z.\"ngJ(@\nD d68*$0# |@\0 &\Zj⺫\n&\0FH1\'$h gW&j)]҄k6p $RN*sx(R(\0kh@\0\nl\0~ POR@$0-(o*Xhؠ{n(2M\0麼(\Zו)ڑAf磩PHcw\Zf&L(@@ c}ǹЦ#,qҢZ(@h!}m3\rn(8nA[0!n\nqxd@\0DB0Ӝ:lVw(}5J0&*@ϐ{@9MȟaK)-9~\"k)@9))KyyPG/#H#jj0k\0G)*\0v @g%0CA`] ́ 0\n1W%0<T\Z\0//s@@awH\Z\0 P Ki \0 `H2hL\ZxpH:ژxc\r(gQX>\r*\ZL\"r$?\ZIIE 1x \nNz (GIRL*WJM\04GZ̥.w^ 0Ib\ZL2f:Ќ4IjZ̦6nz 8\0;', 'GIF89aC\0\0\0\04\'S:BXz@﫼i?f石_/Y=eMOso\0\0\0\0\0\0\0\0\0!\0\0\0\0\0,\0\0\0\0C\0\0 dihlp,tmx|pH,\ZȤrl:ШtJZجvzxL.zn|N~;G(j## $#\"(# #\"$#\"\0&\'%\n\n#pE\r-T\0*`-@^ ,\0Zە1 5ZEWG0X$m{cEXR聭r~:NX~^S\Zƿm9#lu8\rӓZYoek\'9F2Uԯ̿+8`pAÄ.C M_ӏg(7\0w5o{c.峋 u@k\\(N$㱏\r&W[J1j~8_)Y&$L(!V3r$注aQ)D2\0IQJ 1ц$K7~ma~bu>6ct=m\r[#\Zj1\Z֨:ydc:+ \0r*{}z.`ݼ9H\rcFAaV㞕~>e^Kq,E^/h)X\Zߏ׎5tMo\'<ODx݇x\rh8YVg05oGB6V3/\'\\f]Ӓ7 55މ4ݡ/+BNaԱ ʉHX`#Ho.rZۛ˞K0R1YLX&᱘n $%B|L37wSJrp0qw;O≙M| ?_Ҩ=>^\0#_Ҥg1\'Gc4 [dlIµV\\\ZϏתdbH£/,=1&:V$+c;r\'\nּ=0Ժ2t5In<]ὛeHQy2\0Ul߆=SZT.Y5z}Lt*aýeŔ-RAt)zycx{V3GxbqN]0~K>1\nPۤ|GRhtч]6-lo&Pc+-18dysH )k41[z~sE\0vm\0\\ncz=g` n?e4GO̹x8{@YF\Zp͊0/3\\1p뵴^g\r#c2Z)g8|$,.1WliʽyfGOFwk@lv鄌\ZlY;I:\ZXe&<dVz.)m\rՙkiv9v)PO]184 ZM`\\V/Dv,f78vq+ZFlQ,\\MBu͸Wa\'1`I,\Z(  ͖wm宮O2=3[pL:0E)$sfwS%\Z8FrƐυ2BZ±7E=EqMqg@,-FéK^CkgY2v:XiK67+]$mBRPOdJ6W1mP6Ec+c?TfՆ\']mdڹ_q^O噝|6<åA\\-j9ױst)llnB4\rs4e(hߔ-*dũx46W[qp#ͻF69 YOD?8ex  m٬M^^H^+AlՒ:\0h憏v(5\0Lݼ\Z^IFKB~[KTi\0y?sJ\Z]bPbDW\\@]}M+31nYsDM(b̲Ƒ\rhbCY̻ {e9FOpTFKN@&͟BM.Pn)H\"< ^kv8P^ҵ6?Ž?Q4͚xn$`aQ5EJቛy1 9c\rfQt_b˃a\ZNapv7N\'Pr:U hlQ0yx&xi≈ysEkm.iS{I-( p턺Lhho.S+X԰o,m$UI•>Fχ,ƒ0~RD;97 2_{]쁓b0sM;qiy:-ߢYc/f9bZC^9n\\\rY]Ifޝ!NI v%|덜0A\"\Zɞ% Y\0\rLbG}!07u͑!W Mmo1lGS1t|5-XjmNBePv۷hlPTJHa|6(_g(R $O2~ZaQK?s}@v\Z=onԌh3+On\\c/$ݨʎu92ʟXSa#,r:Ʀd|ZԩjGRtc$6-b5)k1-7ܾ,BL\0R7e.v4‡Jn\Z8.o*DcCZ&RPB 5xJim\\vGjE})RMtt!dѴk1 Lpl>bv԰O7K&a>熥vS<…ZPGyT \rvv.k,`Z嫌0#mP\0)M61LRf&O7Tu;*V7:B()0RׇlVٷƤa\Z]]6hԵ vI@ijmmù=k֤\nR\Z50ޥ6=̛8z=bbW!e4;* 7[G5s\\,J-xj[`h/oMaN؉pA54fM.un~ZͦnArӓ,% жߛ-S7\\)˭,q:>\Z[i$lwQ-OvGˬ-қWM:浆+JFoa9df,a_noYiO 探ϕm淨*64ǦO1Ddh,6rG[NnÁ[|oix\ZiMKnZV#s6-ږՒZno/KȌT\nSɼ8]mm5 oh*Yhµա:UnB^&!*EI⶛\r=EbIv[6l6z=KQ\\mQktw*\"ۛK-\nTT2Etme(m|rh4v;r\nWjKf6/\':w.7vN0wQFL0w;)m̈tGJ;\"SjhXԡK[ B9-9مj\n.\04*ӐuUsMMڑ tUe 3uVíHص#Цյ+cK̖RF)-e@*cZȂ9X^rYCU\Z\"bшң-mo4 \06{aKVDc@%FSjn6™@@A-5 JP-er\rQMEmn(5A-3t%,@@@@@@@@A SVsږ\\3?ಚ~o8-\\?ݰ[=^vT{CmcYPyuBFB h*GAAFnFq47muJ PenTjMPf3D\n ҈3D\n ');; delete from field_types where type_id in (20,21,22,23);; update rights set object='forms' where ohject='contact_categories';; insert into pages (name,description,navgroup,mode) values ('/users/thankyou.php','Order Confirmation Page',2,'no_top');; select @unsub_id:=page_id from pages where name='/users/unsubscribe.php'; update pages_properties set header='

You have successfully un-subscribed your email.' where page_id=@unsub_id;; insert into pages (name,description,navgroup,mode) values ('/users/profile2.php','Profile Thankyou Page',2,'check_x');; alter table email_links add campaign_id mediumint unsigned not null default 0;; create index i_email_links_campaign on email_links (campaign_id);; create table email_reads ( read_id mediumint unsigned not null auto_increment, email varchar(255) not null, d datetime not null, primary key (read_id) ) comment='Stats on who and when read emails';; create index i_email_reads_email on email_reads (email);;