create table system_emails ( email_id tinyint unsigned not null auto_increment, from_addr varchar(255) not null, subject varchar(255) not null default 'Resume Received', body text not null, url varchar(255) not null, descr text not null, primary key (email_id) ) comment='System-generated messages'; insert into system_emails (body,descr) values ('%firstname%, Thank you for applying for job number %jobnumber%. We have successfully received your application and we will contact you shortly','This is the email that will be sent to users when they fill out your job application. You have the choice of sending a text or html email. When you fill out the form below you must always fill out the text version in case the client does not have a html email program.'); insert into pages (name,description,mode,navgroup,buttons_no,button1,button2) values ('/users/jobs.php','After applied for a job','job2',3,3,'Header Banner', 'Footer Banner'); select @job:=last_insert_id(); insert into pages_properties (page_id) values (@job); update pages_properties set image1='\0JFIF\0\0\0d\0d\0\0\0Ducky\0\0\0\0\0_\0\0\0Adobe\0d\0\0\0\0\0\0\08K\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\n\0\0\0\0\0\0\0\0\0\0\0 \0\n \0\0\0!1AQaq\"Rғ2B#$Tb3CSDUrc4%5Est \0\0\0\0\0!1AQBRa\"2qSCb#3$%\0 \0\0?\0\0%Gp8 ;3BpAOb3@-r3ŚY:GpŎiqVW\'STψ35Ho(TIfjoe̲Ab\ZvWu^IINI$+#7 *zPN`xOڌN?.쭙qP8|uMVpfvb5iZVgk\"\ZB1{GkI>Eq5zk{r|JpQ48%\0RN|)YZP$PcoB1&VmpIaDQTZ%$\rVɀ#E1QFRVl rȭƂ QP(5F5w6$N&4)f0\n9iy)PkinPQK\\P4ϋĀh[Qjb\Z5nٶ]MfyN&\\hG&Qh.ks[Ckal!R:2[h\09J0`wMnP7q\"\\VRTT);im+&\"qi%-&vLWCaAJO0B+N[|`68Ǡ߈b0DL)LG`MP}\0\n֖hxF A:6(E;X*E*Dŀ-MQT\0ZE*N 0=HLjhzm\r>*0ꡔ`HLkIFݸuSn\0,DqU xA\":*7&eJ-U~ni]G>PeRK8~rOK{Heto4C<{(^F%xRO\0Jc(SdJS@b+(x1)//qγLJ#ȘT9L\rQdL*A<6:M|hQ*\rIr!L-|8\naGqV\0ƌHTg?N\nlx~31:.Xq2zOLu\'0Jtu\Z[m<>1WJy (TJd%?!<T%LH 2\"5>0:hAN\0E+f,Ⱥ[-Scq\0JW\'0i\r?E,cBb\n;HƁ |\\u˷WCm?ݥhJ`R2K~kyOt%՗ +B 5 \"QN\ZMuFN5i K+\r U9 @?p_wTGJ6^Ԇ Gpy%[uK\Z+3\Z1=JVI\0$n4qU~ǒfF\\\"K1JO:HY u\nYc?U\n`4CaYN)XءڎQRpSu0Ex]wO4U7k*PstTf\rCO~SXm k\r\0qJNZRQJƁThX`NY`/ڧr^j1Y9gV7b{`ri\'+3Б\'ݣOQgUgݧ\'ň,ꄱl^5UuTuB!q22mpQ:Pe{SUM\Z:vs$𑊗3\0ҩm<Co}n\\VfZNlC̶t~i;h|QIƹ9椭|FCdJC*)JӼ*qДQϐ| e1%H\\M\ZfωˇClZnOs$ï-℁)yNOߛ~|șD;ͮͿ{\ZҼ]%MN\rZPq[KM\"jvl$:w+B\Z.9mqX%ψcj@*=uroAhM9C<G|%z>򷂤Tgƨ v0 G92$_ l\r6bA4*8-^Lc 9R)G i:klB(L҆l3ٲӽuV7i̩ٳ M+\0/4ѿV_e\r@ۄ4CeZl-\n2*hH @w~uLK.GliɉjL KTTq/T!k,˷;0\ZP} $-͔A*jf`\0Y4ۉ UfjJH0ԦvCPfBHߴ\\L-_.8;70]\rmbA#eFC\\KYTs@a?~\"%GHRԝF\r9SblHapZVn\\$GbzGE3l9Vbj˲/R-Ez6ȞjjHK[)iU7\nC$u@$. -W ڵliekG#hF+JWŋU\'ICFwS\0`)ޤ\"raؤIlfZ QЧވ6\n\Z7(ºn\00u҆TG_qytkeREyNpV7SKuAE<@wZ\032=/eo[~o b\08.8MHH4W8ْ6jK{$-lԨ}p%aŭ7IrT\'2Z8e-\\ȭ7I\r\Z^U7-n^#_RG\Zss l\"`{Vr;8&gpVZS:rHW\ryP%YEw%P-8Ħ@\n$Ls6M%ӝтbp:*ZDRiXZ=ctNnUn(%\"4V倒ƶ-By*u@(WA\0`Z)|`6\nP 3/$XpI PAJE`Cö,6/ns<@\0\0\0\nP\0<&r6i҃b̀Np4ޫ+A[K\0uBKuܧSwlRObsMͣx\'8@a!<(1_g1̇nv|]2wzNR\r\0jG<\n |{Tqw)wabSڧwMSQ}|ؔ]9AMߥM~< \'p*w-8LʐZ>;P>2q^̼QSq\0PVJ}PcH6\"jDȾc4#b4waӈܙ7q䅕I!$<\n\n!Gۨq4~&-e?PTN)5 oJ[l ;x 3>\0\n`ΑbJr[+D7A_+MiWV{=ECn4q$Io\n6#݀΅ee:+ }1-\"V\"2\0 Ԋz`.\nZ&.+ja\\cP\0}hZiψLs^>@\\Nh\rdb;?29\"Ѱ^A@~\\/ĸ SpNrU-J}\nRۂ7-a P4F[@7%I$tOp<J-ٮ&52H9j$ȎLIj!ғǟ g2ACIEXeeX˳}tS$,f ҍG+{),u)˺;򋕙R[joY\0BP XϿ}Au]X{CykVڳ+6wÖĝY WG+4|.Ùգ~,6q3\"Ŷ.q[j+O%P[4PMBViغD+\'_[]{ $ιg3Hԫ檢ϭ0Wscs4qruנG\nZ;ZWsDmix(s\n\n~4m2:@A1Uk3\\\rKFSSL\nݥL[eCPѸ\"\0k҅|rPWHsJ-4D4Z5VynPnY&]kM)2d˱Qʕw*+3b-RpҝOӺE֕l!ӸG˸:6fߴYڋv.ZZk {>ii-\\R{6Gܙl[΋XXVR- \nO5L[KiEQON˿vz|\Zv+,bt(Ž2g3+p۱jn%ɺݙzXXZ׬3VځrEz\0gzy=q}N #>Է\rsό8P*(qO?:Zֳ+ ^HZ cPaJ\rq ,d;e}uS2WқtrX&BT\0u.*U@;+J;׷w\Zs. ol ~>Ԡ;úv+YGh&ZyD;f;wi֊˓R#-n,)ؒ⨡\\#շ7\Z~CM;68\0Go\Zaa#`.t9d7dhk(vp^;NOeXZ}CPiəNdB3_*Q\npƊ*\n\'uki=BPգsb,`>iUt^:S\rt |Oy;)g̽\Z͜o\"j/rZ.^O^Ɍؘ-S%#hSTwiRj֯gR2BcJ\Z\'ѣٚ SPF4 cЮكDrW웧4Kz_gh+~ʦ_[ةiq JgAq8[RhqɿiWWZĭr3u\05ƸaPMJOvf|D7\ZS\nc\n\"schzAMuT\\78HAwWfoicYWKu.&%\Zi? KEΧ%.0j[hxS?[{L.54)B)S]/?%FZib3 3(5.FVxy!ʪDA Q%ڻ˙{-4]E͡3~e\0 5ߵSCUv.Q@a̋ݹҗU8QP~_~*%4F\":X(\0},}K;C]U7\r+6є \0`U)a1$-;\rČHYG&nط-|o}\Z{\"i\0dKKdFsz^gڋ^AYZ]-7Vݺ4M@O!)5PMk%;)sl<jŪ/*ޞ͉D^]x1S:5Zc鋆ϧI,,7,AC\\;#!,g3~;,NPmWRZcdk>]n.R|Cm:H;F4a[!qL\Z*vQzS=-2q\Z\0ĒGiL莱 b䞞ݞ43oHߣ]rͷ@({i..\'zN,z3#\ZlWOm&Œ+Y\ZFT)\n߭l%sCx;4>B؆PhM>=9!pSov\\%\nv<;a370[;9 IP6ugEFv:d~\ZryHa+7r>jZj^{>! J$$[hH;yNlm#Bl%}! kj-k\nB%.\n$vo0`m\rR.@\\Y.UC}?m)Jԥ)DI~6caܮ 1LHX 滛ƱR5릇 \0y>\\japu~!gHN\ZZU\0S_3NgË@7b2wDs\\㒙\rm>?4\\uMI[xmb/ǖDƀZ҅h+g?&M^1\ng;N[M=G߬8URtKTLFLJ5y] -fF{#..+u)BꁾC4:a#/\\F›Cjs{/r_QϏϻx%]xB̏v\\ФCwaYj[efswRQn%a[\" oaE ‚K7H.;q6]۫ MrkL.՞4\'۴,kfwuӋ\Z6^cfFl̸X:4\"q$! }\'nmKwAp#\rdgF񣈩ibm4OSïG(,%sr|#\0A޼Oy\0L.C\r3*i;migSnL|(ʹq Hq=7oo\0=ik\Z75 q8uشۉYh\0=4§- _/@kg^YJn^2lfv^7IyMHHi!!;Ppk .[+]\\1nPI-#*vn#N^EďѸe19٪A\0pZ\0~gUjd|ݧg[[$x/-jYVDy=k ,)VʔRH?K4+NF\"qlRD>A(-\0=Z\\\0ZV_M@ 9r U=h>e$riz2i!ʁQĂB_v6NxKDցC?ض~`̆H&H@vGҹO@#V\0];,ƁkvS]_ё]-2Bȷ4]i[òywl%JD!$<ݗ5sU5s罹s<\nPb\0ϬZ6saR5\ZZ%r1Sw\\ uB`n:vEsٰ6z7hNy_,e|`11wk.[Oi|AC(?Hzn@g)mjHnP(Png}b]#C\"7VA\'\nQ~sǤ\0B?ˬP|{^O%Ŝmi^6lNOyޒvA3#3Zc\\餖!\\A%}ՃKn);VgfMF2CJeIq֓S}mzsR{PJ\0M0ܹ¸!KmI1ިlD\"o wzotQ2>f.>]:kYj\0<h\Z|,t*~px%&Ds**fBȿiΛQ6iwŕJ꘥+G\nց]Bq]ߑ,oVS:E#mT;*EEAq2RNaݥEC5TZ˓,n:+Z\0*m.$ P=vI\n]4̊\Z1Zo\\QM?VswPdyyP8s =s^emkɯc=f YٙZ~-0fuF[VǹNSM5Z!%,$)a(VjlimZ<5\00MU\Z[+;f9cBM1Bh;*`\0W3ΨgP䜱tZ%nKVL{N|!Ƕ!$\\٣GҪ->\"Pw\0\nyf{h\0G\rs N$6=s:m+[RjI55h*;MۃsI4Z1{GiU3d2Ce}9vCsmf ѕmӵ\Z<{B^Zp%)=\rr,[ e{0-{hI.P(*^6} \r tG\r &4\\ߤQZ-s\riq#`<k1Q&~3= s\0j-[3\0cs;Sao$%}IJԜ. p\"y[9l&=%HRAn\nT7c 01%(ڮ[b;⛡#q[&o02uga0eKHR}\'Vx_nwGFo08¡G68m\')ia-p5}\09J|0)BySagRI! ]*\\(Ȧ09~o?}Qw\"9`ٟ/vȩ}v7E_#=^q,h\0svyȨa,X߻ȿW<Twqv7|Oe7܊/0ڻ\rA#w;Y82\rw^6鑹i\'V`oѽ8!js\r]x) M+1F3QvoS*v[Acly\'\Zv)A*$\n16RVک2-H }2Ns ,6TJ]\0EQ֥$&GHO)BmN%i3cɄ#mTR/QHNߤFEc{%|m5}\09h(ef xX8S6$Aʍ+⻥5/;w0Z1NϏb]mY#Uc<&&rI5Is\'\0b*Ǵۀ3\ni~J}%ӎ(f\n~A@vθ8\nP9A1k!pe] \0QSs[r(\r#%VcӌcTvwMb-V9Nt(ɕ.5I髿\rv9R/_FWi\'Y)L2\\\0~.3S\r̪?Msr󹭒?+^i)f~Bleߴ7S\r.|%>b{\\;Qk\r1s\\@Ogb*co۽cJ1vs(My\\,ۨ p\r< /S&xJNx?_5y5\\r Np^mzA |4 z00]x=m&|j?K\rÈBJFmb߇ *Ox4\"?Ƨ?H0];V:9*Noy ݽB|̎+A -҇o {wI\r Ai\ZRq\0Day\n8MÃޗёm| M}HdR)DuyX=,\r$_e`yJ0$l5ؼW0X WFwk;pVuXu=I8,],Bά,,;PgUwN{vW{5w+iv?Ox>vZUe%P\0;OщBaYnv{_V#aʲ~ChM{?yjJ:Y7ygp҇VT/+\nu\'9BzeYJGtpww\rG(޿wg\nuGar)_a0]D|m 9Nar?Mv?8C!a2rmb7yp\\E!x9>RLgu^vw<*W\rV^LypM!w]ǑC(6Q|q]Co0]L+(Ϧ?[ty&~ȡUg\r6>daE?oэۋIF.C/))1b|^v߰(E)?F 菍`\"VRr!g\\bPʗQtύǽnyraYRaO\0c~X.ʗ\n5>DϨ{;(ue[P?Fo=ygl[11cPT\'#˅3cވ]L/,\\=e>G݊l<\n/YYo=E)e?=>\Z;y}LpQSˀ!ߨ{C6ß\0 <w#ڬ8|Xy&`lO\\OǽKejZnCW6\nz\'73.#o0X6k\nˌ/i\nDÁX%|>2?7\nz\0_w/E_8yqo7 :ygw.e.2C޳8_JK?8;~Qoȥ%ǻǗo=:y\\/< c~C#N\\1~8y\'jyO 1{)ŘC\rcyzY$R7 cyGY~z|hb7K1qQ [xT. jqc~CE<^M>\\0j\0cy&O7Ba<\"]Oh[X?PN .rGčVg=:e+MTp_uCޣu2y׶O[o=Ly\'m{t\Z\0uP軁SZG\Z_w}C޳ y5Q||ǐ\\k^|\'*S:5Q~ʬďooOF*Vǣ@mFT>wFIʟG_\0=ozhu 41M8}\0R\0떣tNS\'ssRe:Ƨ\nuR\0.?90l#)|buԑ䌧E=}ouԘ|Q8u: #)3:\Z$2\n_AIuQ=uQ$Z|\ZeMC\'\nۃo\Zèd|뀸^0\rB  ]*wx ˫7ψ^5[?O̶oA &NK+ן|A]F.W\n}gv\06Byh:u;^? A);\'WJmI :] +>8<ڥ\rdۻeVuQ /,n7dX5NXp cyQ?%ehQ3ͭz<>OV?oA3!Oowۆϔ\'婕`I\' \\2Zplׇ_]A)S@( OZ/ycu\00Ao[ɦZFiEy)~ɼ] Gw%/+TI T0?H= /`@Q_v-Bn6a/a]u;[7)e[=[Aw]IV\\pI\\9]o%s=mK?屵nP}\r=ZDZcgh\0loFddy^ei#îԠkv\Zp<\\6Y\Zy4{\0)gmgY>\ZzPg,罁\'6dj(fAlfaI \nPf*\Z>I}/RŬػťI򔤒,!Ai``ҹ i\0R3dօgz*sw.Gc@S;ې\\,#V ir|#g;Z5g,H@\Zg,\ZPY~-(rWr>% w,P/ 9*iF BBd)$O\'MD0E>K]wNNߓQ@\'\0KW@S`E,Mh#qj`NZ\r@Z|؄\\BV8tvQ@;.\"Ɔ$P<\'b6+:y0bi)CmVj:(2䷚eK*\0&V y08\Zg7 zPl.rcqPXe(upfϭ9zÓ-{ܤ9n̆6A|g,Y;<6m2(``F-2$BʎHE(3͓~5ޗf eKK\'ҁNKz29&Ȇ1AEؼ{3OpS_F0䀁0ZY-,}.&Ȳ?(m΢\rde!j,rبv\"FHU}`ŀv}\r +@T\n7{{l=[+!+Cc 5(&d[qr[ Sc8P!w(zP\'KT@/s.@\'sY&M\n)$p70(#6!&!$P/&PL6}̡8E\ZANfi\"xAу+r8}s)\'6dAGQ&ȞC%:˹ f=,). DP4IvTj40(/-6 \rP\0A\n-^H 6? @x(\0+@.t*Am͠96@shm͠96T9?Ѐئ @ \0@ \0@ ;ҁ96@shm͠ik?' where page_id=@job; create table email_stats ( stats_id mediumint unsigned not null auto_increment, email_id mediumint unsigned not null, list text not null, rejected text not null, transient_errors text not null, sent datetime not null, uniq varchar(16) not null, primary key (stats_id) ) comment='Statistics about email campaigns mailout'; alter table email_campaigns add from_addr varchar(255) not null after subject, add reply_to varchar(255) not null after subject, add return_path varchar(255) not null after reply_to, add attach1_name varchar(255) not null, add attach1 mediumblob not null, add attach2_name varchar(255) not null, add attach2 mediumblob not null, add cron_d date not null, add cron_t time not null, add cron_lock tinyint unsigned not null default 0, add use_uniq tinyint unsigned not null default 1, add uniqid varchar(32) not null; create table documents_categories ( document_id mediumint unsigned not null, category_id tinyint unsigned not null, primary key (document_id,category_id) ) comment='Multiple categories per document'; insert into documents_categories (document_id,category_id) select document_id,category_id from documents; alter table documents drop category_id; alter table config add bounce_hard varchar(32) not null default 'bounce_ignore', add hard_notify tinyint unsigned not null default 1 after bounce_hard, add hard_move mediumint unsigned not null default 0 after hard_notify, add bounce_soft varchar(32) not null default 'bounce_ignore' after hard_move, add soft_notify tinyint unsigned not null default 1 after bounce_soft, add soft_move mediumint unsigned not null default 0 after soft_notify, add bounce_success varchar(32) not null default 'bounce_ignore' after soft_move, add success_notify tinyint unsigned not null default 1 after bounce_success, add success_move mediumint unsigned not null default 0 after success_notify, add pop_server varchar(255) not null, add pop_user varchar(255) not null, add pop_password varchar(255) not null, add pop_port varchar(255) not null default '110', add pop_delmail tinyint unsigned not null default 1; alter table job_config add apply_success varchar(255) not null default 'You have successfully applied for job:', add apply_reject varchar(255) not null default 'You already applied for this job.';