-- MySQL dump 10.11 -- -- Host: store1.vpn Database: compta -- ------------------------------------------------------ -- Server version 5.0.42-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `invoices` -- DROP TABLE IF EXISTS `invoices`; CREATE TABLE `invoices` ( `inv_id` int(10) unsigned NOT NULL auto_increment, `inv_date` date default NULL, `inv_type` enum('received','issued') default 'received', `inv_ref` varchar(255) NOT NULL default '', `inv_supplier` varchar(255) NOT NULL, `inv_category` varchar(255) NOT NULL default '', `inv_description` varchar(255) NOT NULL, `inv_amount` decimal(10,2) default NULL, `inv_vat` decimal(10,2) default NULL, `inv_vatsrc` enum('calculation','printed') default 'calculation', `inv_preview` blob, `inv_comment` varchar(255) NOT NULL default '', `inv_updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`inv_id`) ) ENGINE=InnoDB AUTO_INCREMENT=668 DEFAULT CHARSET=utf8; -- -- Dumping data for table `invoices` -- -- WHERE: inv_id=667 LOCK TABLES `invoices` WRITE; /*!40000 ALTER TABLE `invoices` DISABLE KEYS */; INSERT INTO `invoices` VALUES (667,'2007-10-09','received','TCXMA','Infogreffe','','Achat de KBis','5.44','0.89','printed','\0JFIF\0\0\0\0\0\0\0;CREATOR: gd-jpeg v1.0 (using IJG JPEG v62), quality = 50\n\0C\0  \n\r(\Z1#%(:3=<9387@H\\N@DWE78PmQW_bghg>Mqypdx\\egc\0C/\Z\Z/cB8Bcccccccccccccccccccccccccccccccccccccccccccccccccc\0>\"\0\0\0\0\0\0\0\0\0\0\0\0 \n \0\0\0\0}\0!1AQa\"q2#BR$3br \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0\0\0\0\0\0\0\0 \n \0\0\0w\0!1AQaq\"2B #3Rbr\n$4%\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0 \0\0?\0l\ZtAA \"\'<}*O\0Oº#A?ն6R|Vpٓq6oUi՟s͛|\0G(͛|\0G+.q_ٳϔ\0ٳϔ\0vQe=Wl\'?Gl\'?]Yvm>7I\0~Q7I\0~WkE]Of\0>Rߣf\0>RߣE`q_ٳϔ\0ٳϔ\0vQe=Wl\'?Gl\'?]Yvm>7I\0~Q7I\0~WkE]Of\0>Rߣf\0>RߣE`q_ٳϔ\0ٳϔ\0vQe=Wl\'?Gl\'?]Yvm>7I\0~Q7I\0~WkE]Of\0>Rߣf\0>RߣE`q_ٳϔ\0ٳϔ\0vQe=Wl\'?Gl\'?]Yvm>7I\0~Q7I\0~WkE]Of\0>Rߣf\0>RߣE`q_ٳϔ\0ٳϔ\0vQe=Wl\'?Gl\'?]Yvm>7I\0~Q7I\0~WkE]Of\0>Rߣf\0>RߣE`q_ٳϔ\0ٳϔ\0vQe=Wl\'?Gl\'?]Yvm>7I\0~Q7I\0~WkE]Of\0>Rߣf\0>RߣE`q_ٳϔ\0ٓό\0v\Zv\Z>⿲\0?\0\n?\0?\0\nhuدi?g\r?\0~OQ?\0~OWsE]Oe\0>2ߓe\0>2ߓE`fps\0ό\0s\0ό\0w4Qu=\07\\\0\'?G\\\0\'?]]vi?g\r?\0~OQ?\0~OWsE]Oe\0>2ߓe\0>2ߓE`fps\0ό\0tU,` ҢS?g\0\\S\nTY\0BR[&G+\0\'EM*T|uu gЮq5e;,y[̽^=JdyQFr\0T77%roz pNR>)2*\" \'r3>.6LM C89Dڳ*5&YPȣ,GPQE\0QQ=&ǭ\0KE29Tr\r>\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\nU’~QEAQǩ\084qh=Mz(SG(\0qh=Mz(SEP=#A?OH\0EqO* b27IJi*ы˹5K+vC&yTKA>^3u90XVL|\Zp\"0۔mS=FforFMђON#K\0?cl ֢kXn[2j&V\r052o=A7Qe$;mb{Z.3$7?cg󶏻Q\rB\0\\厣pc[ڇƀd#ЊN&W +4l\0=@ȯ\'&ȷqEWRzF\nag;{~9II\"~2G?;>㹏w}y\rB[e*z\'N;@k4̰\"i 0pq5=\n(Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@*IJxP rJ((\0(\0(\0(\0(\0(\0(\0\"r\0)\\lT&Fi)_%Z1{cϑ:\ZǴH\'Jgw}1yS݈UP.8ҦD\'CE,\ndϐ\rs=iZO &Y ;gx^Hc9*B~/ Ą/9> eM MYHw#N{kO\rIUz~׶\Z;IqsM\"D؏2IGp}?Z\0п1Ϳvxۏj63I1uXK.AlL5u|+0-x8qtj_!AI>ހ*/{ma^1=\r,v#y\"ďw$#8]\"YqJLuԇn]yC8IA!D%Y4¾qs\'\"<6\0/?{n~\\\"Z*y][\r/c\\8\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0R\0$*\rB(((((((\nzG,\0!W*\0 ?UOdo֒UVNmrKtJ[$\rDuV#\0g8zd£!&^U*X@6T..;.$#<hN;$FV/#2edyT1iPIJ$ɷ,H*I\\TZRs~ܺ$.l܌g36B\'^g*8r{s@.4n%<+AY%v\'16\\MSY/-\'1yW^dٝdY2H\\cP\"wT#8}0r\"H2oQUqǒJ\n<=}?jqzK[YRd2xz@ɾN@ceh庚@YX*r1Zn\"3v_;T`u!az3?L+qh$\n>@YXCbClqF1\0\'ZVyۡR\0_:fa\"(6r_9UGX#,cH/#ZuKojғ\02P#9\0@Xעb\"?\'v|~]JSc4I\r€EWm#‚\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0R\0$*\rB(((((((\nzG,\0!W*\0 ?UOdo֒UyL~@\0S D\0ggqrGL][=sGW\r W׶jln\'srxv!eb]}}DVV$$sT|[{xrc\'\'N q~k ]wep8$\\hk)g8$:uiF9qc8ӊYa*z:c@\rdj>ۻ\\sPEE\'8B \0?\nO=g\\tq84ճUU*OD9_D Wy,\0ǯAS?;n|gf\05+)!z9~f@nEރ=qC\0=I&:$@u~C`߇ہ8SSUrz!F1uRFgzɝVBL=˟)O [(us\09:jżW17.sz1C\'\rr1PIr5Y\":K\0AwVrwwq})jѰSТI8\0N7 (7KOclg\'*\ZB$eY Fk1\0O9`[rNy>A*శ\0\0;FAyy:\n>o\r$0cg- $*c*?||zz|7r, ,Bz9??@VEua6\nB[;]J\\)<(]+x(6HQ-zbv 1=\'vHXZ\'\\R:d*6YN?1##8\'PQE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0%*@-(P(\0(\0(\0(\0(\0(\0(\0 ?Uʧ\"rSc3m8\\gFe[=-B11~TdдRdFKv><}8:zS.^m[ZP;8\'aSrt=-lm;!c$cͧ?ݾϏ\'1w:\\9DVr+m\n8҄q=OATkX%-۹#9#=EÔZ)[O#u}Nc>t=)ej/rЭÍ(@װrt=-lm;!c$cͧ?ݾϏ\'1w:\\9DVr+m\n8҄q=OATkX%-۹#9#=EÔZ)[O#u}Nc>t=)ej/rЭÍ(@װrt=-lm;!c$cͧ?ݾϏ\'1w:\\9DVr+m\n8҄q=OATkX%-۹#9#=EÔZ)[O#u}Nc>t=)ej/rЭÍ(@װrt=-lm;!c$cͧ?ݾϏ\'1w:\\9DVr+m\n8҄q=OATkX%-۹#9#=EÔZ)[O#u}Nc>t=)ej/rЭÍ(@װrt=-lm;!c$cͧ?ݾϏ\'1w:\\9DVr+m\n8҄q=OATkX%-۹#9#=EÔZ)[O#u}Nc>t=)ej/rЭÍ(@װrt=-lm;!c$cͧ?ݾϏ\'1w:\\9DVr+m\n8҄q=OATkX%-۹#9#=EÔZ)[O#u}Nc>t=)ej/rЭÍ(@װrt=-lm;!c$cͧ?ݾϏ\'1w:\\9DVr+m\n8҄q=OATkX%-۹#9#=EÔZ)[O#u}Nc>t=)ej/rЭÍ(@װrt=-lm;!c$cͧ?ݾϏ\'1w:\\9DVr+m\n8҄q=OATkX%-۹#9#=EÔZ)[O#u}Nc>t=)ej/rЭÍ(@װr_)X%-۹#9#=O6vB\Z\"f0F0qQEIaEPEPEPEPEPEPEP=#A?OH\0EqO* b1ҡ6]UFK\n:UMR`D%U t^ĉp@&waUV(Ip\0a}}F}Z4R!s[W䫹0ICѱ4]J&Vx\0180Co0a~eA\\ZXm\ZBfܱ9P_oZm[WB+t@ᶰmǎY/1w1 Th<޾^k?,¿jY$mی:v&\"\r)1\\y+3{v@5`]6+Y,W0dpId~ qN$Yhw1[&[$\0}\0kf}hKIU.f@K}+-M,.LJrrݻS\0cNCEg\'ztQ\ZqI4m\" QNYcy5YLՑYa.VBX\0g;G\\֌1H24p*>݌lwkop7uDy8\\KJYd\0RP)tKFN )MAƬ\'\ZAA\'\04\0_3dIlqJPOr*astA4enE2zf:Z\0S)pX@Xgr_$Xr\0cU:pP[M!L̤/,FM4۲-Q\rȨl8{,RrCǡ\rX.ḒhYm\0}AT{[{mê +I;O{O5͌P{\"?R=*T.ae)H1Ѡ\Zؗ\"PNiEnE2zR7&H\n$H ž\0鶕neX)]\\\0c<ހ&{6BTe)p`iP;*\0>,a&29ذxFQ@\Zl~O|=h7V<@\'%9ʲaӮdq%B:0pT :\n3 Pey+YH<}@;o\nsVyR42\"]؂AQ[ZKmE#bCerpsC?OReFH1@? ҹF6 $8{ߤ>\\ ݹ[.ݹUZUYYn \0I;O\0cSe=Hh*9NG@\ZtSPE.\0lrNEPEPEPEPEPEPEPEPMoiEP0(\0(\0(\0(\0(\0(\0(\0 ?Uʧ\"rSY%)t3\0 sւt/!SwD@m##ւ 巵Ϋ3<[ip\0Ϧ8xq۾yWOnF$J[ oOӭw8krg\'؞i.%#VYmm+@vuڵml& s,N8j!Y@>ue#q\rhF9ƥm*ɦL\'&\rf\0iPhEyG\'=)Ku,8Hci\r6lEPWqʜ 9G\r:X\"4\n,H[Yj\\„4ŋcI9@\"iNL 9Qu8m{[%2:[16\0*xm q֤(1*;ųO_Ɛ?%WEڂL1㏸ݩoq5qA&Ifrt$~\0RK.֩,m)o\'&@Wp?Ni@\07Ĺzz?\\Yǿ<gzwiWVo-LI)Y `\0t*>7NrIS}dЅM\"ӀӅ\Z\0~u4f\0\n~<>̴\'_9^Ii 62?ͻym9MH ŸBhJ(Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@5S[\0eQ@Š(((((((\nzG,\0!W*\0 ?UOcӥgp5&42,sFPyZ ҒY(G8TR\n9١{&K )u\0֛Aw eԉ!nF~֭.{7\r48;I&2\'wq;d]Q:$P.>UXC~Y\\sfbFӊ5 ]a\nAʑr NKUY@Pqr:Z@si4N\Z4b2 n>S.-ҧY\r1\rq%A+:ɕP<}PXC!?t$cvMzIr* 1I\\}wgQ-RH|XC̏3[sO\0\0\0N j?[0UX 4*Kzѵ@! L2IlS)12`#9秭lhK=n)N\n=m`<`v4jEԍėH#vǼ[sҬ6M l_ۀ8h+$VfdKqԃqIq}>Y F8ǷQE,TvR|bCsNdܹͥ\0,To!yZ8,2~\0fqq8 *8O98㜞A-V%vO<\0pIh%Eqs+R+5\nAɂLqx8\0KUmD9K1qמR4s1v`\0Pj_78W#ǥ/H2bF8Vp3FPo ʖ9{:~5n3WMC(iўFE*Nz4K\"LUB su~1ZSnXa)[Pʍ!UGT(\0{\'4R1t\"O:.=9ۜ~.i-# &$qǰ4ItR?Ȧ<.??i#lZ7ǵP|#zYzI90 nozRHa_+@z={օ%;Rɭe\n`;$sI*R\0(\0(\0(\0(\0(\04k}@ (QE\0QE\0QE\0QE\0QE\0QE\0QEOH\0EqO*S?g\0\\S\nBةLD\r&16g?w8Ͼ3Q-KjKrIn[pVh\0N=>Ӗ[. ;tBv@u-Yl[W\\sM̅trۇN\0:sZF^cf\'q{Yjz(%V˽2NP?FQ-ۉ.v9&B9mç@Y kXl3`?=M9`U{q SD\'hR@%{q%9$_G-t5oe6bw~~Ş\"Xn<`+ :ukeڽcnd/ۣ:t՚(\0N=>Ӗ[. ;tBv@u-Yl[W\\sM̅trۇN\0:sZF^cf\'q{Yjz(%V˽2NP?FQ-ۉ.v9&B9mç@Y kXl3`?=M9`U{q SD\'hR@%{q%9$_G-t5oe6bw~~Ş\"Xn<`+ :ukeڽcnd/ۣ:t՚(\0N=>Ӗ[. ;tBv@u-Yl[W\\sM̅trۇN\0:sZF^cf\'q{Yjz(%V˽2NP?FQ-ۉ.v9&B9mç@Y kXl3`?=M9`U{q SD\'hR@%{q%9$_G-t5oe6bw~~Ş\"Xn<`+ :ukeڽcnd/ۣ:t՚(\0N=>Ӗ[. ;tBv@u-Yl[W\\sM̅trۇN\0:sZF^cf\'q{Yjz(%V˽2NP?FQ-ۉ.v9&B9mç@Y kXl3`?=M9`U{q SD\'hR@%{q%9$_G-t5oe6bw~~Ş\"Xn<`+ :ukeڽcnd/ۣ:t՚(\0N=>Ӗ[. ;tBv@u-Yl[W\\sM̅trۇN\0:0az񏛟((((((((\nzG,\0!W*\0 ?UOaEPHQE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE+&8sNLhOǧr\Z?M\"A0U c\0.^j#]\nGZZ\"@\'+v~\"f$/ \nq>==%-\n(\n洋eVe73d`|\0#Z蕵B1v0+wK˶wWFZF\"(#`86vӴeY`$o\\(\0\0e1zUx\nLܮ I)Y6`1xcP+#̌C)#U(aYZQIslrZDx\0\0#j@Sme%߉J\0cC6z&߈|g)\n~ 9r7SmQOOYOH~$kC\0>a@\0\"O2ox C*cUSrN;\0:k<߻q*|wwdDbf\0\0?օ\0sqn#@cx̐\"+1\0(Q\0~{qWtɚfɱXF2=ZҢ\n((qhm\"$ QV[64K#\\Hܜ/{\r̙\"vFٹqڲX$$_cHvd$Eo{x gOܠ.\n(TuxƮg\"Ȍa AAVk`sGU~ *H(YdQE\"((((((((\nzG,\0!W*\0 ?UOaEPHQE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE $| \r\0qYڗ2CmslC9B-ATJW;y!%*BRحfmlR0*DpǶO=t*c=N>b˧QEPǜ\0ͿMQ\\){iQFY=@wLvYHg/\';VaIn(qgۓ[K0uh9ix Qr}I)RӉČF ($S)k3QH-ęm_+>GlҀ2˭D/ A9ִ4lV 84ⴑU*\0\0y\'-9{N{:(Š(\nR\0%+BTMRUԄ*$H5B{3q3K%f9-yI=dڽioV<\nX?&#63޴?\rKkW,g\\{aH5ɾI\"hC*bzX\"-QEQE\0QE\0QE\0QE\0QE\0QE\0QE\0QEOH\0EqO*S?g\0\\S\nBةLB@Iz_%Un(s12,~FL3zѸz(n(s12,~FL3zѸz(n(s12,~FL3zѸz(n(s12,~FL3zѸz(n(s12,~FL3zѸz(n(s12,~FL3zѸz(n(s1!C*8ڍh;MM>3iiEfFOͦEMM>.66}\\m4m4( hSL\nzG,\0!W*\0 ?UOdo֒UV \0A\0:ګmaok@$E\\|*3N)°UMҮ!P=ϖ, Q\0jK kY5MqA?ηm[fCdyy \\xZ/I9^zӸ s-&aDH>+!;zj{ ie(+(66fK(@$m>a-\"h/e$@\0\nlʰmpc\0qӌ։ZYC9Iږf۰ezNa蒬W2;\"$gӃ[3]o\Zdcb\0M%2[>KL6oX0}9gyrw+rxnGbnu)ZnŢB ==abhXAI=~!vUHIKCrO=8WRyUc̒S`s3uXbcN@?SJl-PcF0ys@Osm.Xf9kr .Pe8u@N~թUz)0C ,`bv]7le`8xnE1\Z[<T8$ڭk 2Hb02Ā=\0=Ҝm,[o%Ą\01@K(8 (͹ \nuēh]#\r0*9s)T+8$9ǵ\rmFc+m \0=>Ҁc;\\DUuS5^PY\"H7\09q[Gq%$yҒkH.X T#@$hڊG%Vm͜`~zJ!#\" @|gS^62+[}sMctlΧ\'yv;ŗ`v]6Nv-T:;3 9^OgƨUW2\rC\0 -Y,pO=\0P.bSj$o,͹ط˸/N/7B*$Tp:V$0(NT$$s4g30;0cV\0\0P(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\nJ{\rn\\+3@(\0(\0(\0(\0(\0(\0L=M\nzG,\0!W*\0 ?Ukb1MڟER2c6j6j˶ZdF\0N JI+fUYs +皦И%tnl>l>Fi+{Ifh*9n&vi#4JR=C)\ZCkaaK4NVe\Z֬H[i9`HcލBƎFY3kRFo[+j#s=aSb\'bdA_k|O\ZFU!a781ʾϕ^Z=qge^\n`tcSaa6եijnxcCPzl:F~ʈ[x\',0:P56j6j:\Z\\B]\n%שV 7&UZ<(2FA>j4vj6j\ZOg<Ѿb*@2 cϵh* ru >fl>l>( }}PS[tSh-E/o7oQSJYyM(TQp Q7dA7ƦE,ؑ*Ag뤟dSz<=\\,<yM*hӲ+$F,r^rz`|??/_oi\0<g\0h矠dhM(TQp+:hv?\";oQEoYyM(T ^t{8dϭ !Sz<\\Ӽ<5{?gh꨸YyM(TQp+FE,ؑ)Sz,\0Էt\0C5= \")ESz.DSz<=\\,< \"InT+7p r\0[m\0]\\,<~L\"?(2y]QRQ3ydߞҔ~L\"?>\0h2y]7I=o8*J(aN9)A w??:\0LqyJL&~\\ҟE\04<\npwscA$7~x kYY $ pڢ֖?Gs j%:3\rZ6*\0<,P2D9sӎJPd*1X.xs s\'N;^\0jj\Z*7 #G!,L,;\0y~Lqy@>`IL=M\nzG,\0!W*\0 ?Ukb0.Nm=(]Iqǽ\rڲD\"u3QZ{GG>k#=4wMd=1}KK$iC$܌ \nzQzQrf.lKyDET<\\96~mč(.1>zQzQpuAtQ R0v<_\0_j>\0NzQzQpoim{Tp>-dIY+J+Հt8]ҍҋtv Rvſ\\㚆I[VA&nSVFEd<LyiR\\!\0QGG,r4[v 3p?+Ohh,cFi!)r}> K1ğv5\n>TGG zQzRXeҍҋTR\0\0\0@jzRԲ8#p(Š((\0RO Ԉ\'\'&EP7]4&xCX @?O󩨢\n( \0]m\0]=5Y#i\0QE\r cHҾ?}j((,\0Էt\0C5=5Qp$$Ө\0(\0(\0m\0\ZUkI\0~~w=^yiDj$/˥!d9ϘS^yhSDj$/˥4B2>cghJ)%;9҈H_-1J\0ue3& |ҘNs@GZrn6[بcԅ9Jvr\0\'L9y[$c?.\0ai(#)0Ns6< q\nG,\0!W*\0 ?Ukb1ҝMN\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\nuy\roLYcfXn{<@2sJ\0oq^d[?{ӖhfX;ұ5-6o-2#K\0-\\jiӮF{\n\0=q; 6a; =N:\n|,{w;(ڥAx~JpQ7>R\0?83T5=RM7R緘$5I,7\0X\0 Ҁ:$ԭR}9&8ƌzw{5 Vk€̪B2703kMѵ?eh\r$c!lcy9cMc̲(yg z\0zGL=M>zY\0BU=#A?Ocӥ:)QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0PEPU?C\05Xm\0\Z&) (\0(\0(\0(\0(\0(\0)SB\0 ?Uʧ\"rةLztSS:(((((((((((((((((,rW[iRT2Oҹ{]MUT}\"l bſ)Vs:Y=n$[cg14`\rRyk4GY,q\\1I+ai9ҋ;hTd8\0SRx]$WxPOz5- p(eUُҥ8~ hoݠXzz,EMwTFw`$s[lcsv yyFjxt,Kq#֛S|)\'svi~mpmf[--ԡ}\\zM< \n!ykykp V%Q~清Ys*=OSmҢ)Y|}V)kby.9#\'g͎}^3J:astA4{na=ie(\03J8 5UdE58\n9=hEݽլ.V07zQ`:>S(@a|$I ub [y8WRAo2{zRw_*(@%.Z,Aq,#]Wvnd7)n?C\05 &) (\0(\0(\0(\0*)`[j`SR6RՒFj$W\0uW7V(‚}9,n\"7$ewSb}zNP3?y( #D:刊)dNoJf?(Rv`ޘtVN$\\3)\n2G\\a\0}}1wjȷKbyo:wtW?{sw(TeRP6I8$tL+H2 \'(fJ0],9 p3:TsԌ}x?t<F6Y >rXq9n@irb\"Is\r1omoDa4un\nqs=y#VrM$:D7r̓rM/~/ o%T`ր,as%L$jxw,W d0N0?UK9fv_/qwMnjwT٭.Zyf/&I㘖\'p۷#\0g\0KYĥ,pN9\0=?qPzi(\n*1㌇\rPqӞޔ\0 wLe<7<\0h};zl7tO<,1<BQF8S! 1VRɆ/n21@}f8.w 5\'ڭϋcmTSM[GAsrLK\"435Gu]Ga[v8q9`TSj6,$Jy0*(Ҟ*8# :rOXRXyPnIzSHu+Yyȱ#~c8\nۚY鲲AVdy5;dr#mcx8%QH(((((((((((((((((((((((\nzG,\0!W*\0 ?UOaEPHQE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QEOH\0EqO*S?g\0\\S\nBةL*b2͸ U cz}Q2$PI,R,P)Si=~dc*2O~7/8=8KGD]\"\0 |>x~t~ćO\"9ޥv\0((散+ 0!q91J`lG 63( ,,?X#Koe2j;r*sqGVΚ\"ڲFyl/UUJx™ճ+uޠ\r+*Y5&؅3L\'H0)>,-mĄܻFdMTsPi{wvg]gx~;hTIV\\^H\"Te W}k;:f3lgG%~`qr,22;R@  !ߏNU>-S@t*2zS~ƹyo(=$u?\0ӥӥmDVᱵL8ך@keh#\ZǷtBHD% #&8G€:{ԖVO6˷8)805ZKwwnDْN0~q9\Zah2BS4Xg`Ġ`zgҀ5cedGOa|Uэ dZBHY ֐\09\0*\0:u!VB۶BCn\'o(szkK%+WX[t*L$Efͨh³?2e`-GRp>^x֟\'d#B#v۱% >c< VLL\'G`l\"\'^ro\\pHz=77n\']QmsMsbX1!|ؿNtuȁKyʂ[%p$bB,n<^1ց2HRSTeqzマ:UǑFmf 2\0H#@S~m\0>ϼ_c}\0c\0x@;o}}\0\0:VHcV&P=\0 V#Ȝ\0կ\\,x}򪊸Eo\0>\0G$V\0q\0Uk[7h3*cn3z{櫕\n$V\0q\0TEo\0>\0Y#\\@|yN6#YE\'|\n#Dr?s+ ,Eo\0>\0G$V\0q\0UA\0O׭Vo& %wqcss?\0\0OJJ\0hq\0uQqm ַ\ZIf ˺۴d\0q<.UԒUI6`1yϧ?X[̎S29{1AH1E06`EH<}\nG=>cמo9]Ie$C\Z+6UTp?/\00Lrp2r}ئi eCo8w!=q̈́e%1>a峟~r{IRVY$F31\n\Z!&T8#9\0=Ń`+DeݜsǾ] >%C#ez5[r?J`%wdjW2ʬ{kHv,qE˜~<@QH(\09\0*\0\0f jQ?xny_=y\0[w߉fҝxnLnEeB2 㯵X-}xE\0|\na:=[obexj%<+̍7ךйmr2\\t%Ia=jm\0_\0/P6ZX{+doO~doٚkU*\n:qj}xE\0|\n>o\0<\"\0\0Gs G,]in!X\0{ V?!|e8OBgԪ=m\0_\0/Pdh<{h%Q 0Yjp 矦3F1Y=¶8{tAk_\0/Q[(\nB,-y#o̲ʥT ul\0 fa\'[\'9e\0\0@X\0~O&8ȱڑ7ss\ZO ^|$!8h=?q|s[(-i=%sƪkqϱm4Fod`FS{mwV~o\0<\"\0e\0\0\\ fa\'=Ky``dz=:FT-mm @pY9\'Ze\0\0@TU_\0Gm\0_ TU_\0Gm\0_ TU_\0Gm\0_ /?TB 9 ⥠a\\#aw\Z#1\'M\\U\'a5sܿZR3)!\\?}[\r4/\06G$xO#>RnrxsW>µ\0h\0_C\0l,`5̣p;\0ܜTXI3X+m9+ϵl/\06\0\0@?#G7X]rudo4-5?:\0h\0_C\0lc޿\\30I?k}~F_+l%9B27\0@?^M)JHk[9g}0(aRђ)#8#UMR/\06m:OQʇrk(ӌinS٩EU\"r\0)\\lT&QEQ@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Y\0BU=#A?-Š((\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(\0(\0(\0(\0(\0(\0(\0 ?Uʧ\"rSQEQE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0QE\0','','2007-10-09 19:45:59'); /*!40000 ALTER TABLE `invoices` ENABLE KEYS */; UNLOCK TABLES; DELIMITER ;; /*!50003 SET SESSION SQL_MODE="" */;; /*!50003 CREATE */ /*!50017 DEFINER=`root`@`localhost` */ /*!50003 TRIGGER `invoices_insert_before` BEFORE INSERT ON `invoices` FOR EACH ROW BEGIN IF NEW.inv_vat IS NULL AND NEW.inv_amount IS NOT NULL THEN SET NEW.inv_vat=ROUND(NEW.inv_amount * (1 - 1000 / 1196),2); END IF; END */;; /*!50003 SET SESSION SQL_MODE="" */;; /*!50003 CREATE */ /*!50017 DEFINER=`root`@`localhost` */ /*!50003 TRIGGER `invoices_insert_after` AFTER INSERT ON `invoices` FOR EACH ROW BEGIN INSERT INTO operations SET op_date=(NEW.inv_date + INTERVAL 10 YEAR), op_amount=(NEW.inv_amount * IF(NEW.inv_type='issued',1,-1)), op_description=NEW.inv_supplier, op_account=IF(NEW.inv_comment REGEXP '^paid by ..$', RIGHT(NEW.inv_comment,2), 'LCL'), inv_id=NEW.inv_id; END */;; /*!50003 SET SESSION SQL_MODE="" */;; /*!50003 CREATE */ /*!50017 DEFINER=`root`@`localhost` */ /*!50003 TRIGGER `invoices_update_after` AFTER UPDATE ON `invoices` FOR EACH ROW BEGIN IF NOT ( NEW.inv_amount <=> OLD.inv_amount AND NEW.inv_type <=> OLD.inv_type ) THEN UPDATE operations SET op_amount=(NEW.inv_amount * IF(NEW.inv_type='issued',1,-1)) WHERE inv_id=NEW.inv_id ; END IF; END */;; DELIMITER ; /*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2007-10-09 20:10:32