[Sommaire] [Imprimer]

   1  -- ===========================================================================
   2  -- Copyright (C) 2001-2002 Rodolphe Quiedeville <rodolphe@quiedeville.org>
   3  -- Copyright (C) 2004 Benoit Mortier <benoit.mortier@opensides.be>
   4  --
   5  -- This program is free software; you can redistribute it and/or modify
   6  -- it under the terms of the GNU General Public License as published by
   7  -- the Free Software Foundation; either version 2 of the License, or
   8  -- (at your option) any later version.
   9  --
  10  -- This program is distributed in the hope that it will be useful,
  11  -- but WITHOUT ANY WARRANTY; without even the implied warranty of
  12  -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  13  -- GNU General Public License for more details.
  14  --
  15  -- You should have received a copy of the GNU General Public License
  16  -- along with this program; if not, write to the Free Software
  17  -- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
  18  --
  19  -- Valeurs de test pour les developpements
  20  -- Ne pas hésiter a compléter ce fichier avec de nouvelles valeurs, plus on a
  21  -- de données, mieux on peut tester l'appli.
  22  --
  23  -- $Id: data_dev.sql,v 1.3 2004/07/12 19:57:30 opensides Exp $
  24  -- $Source: /cvsroot/dolibarr/dolibarr/pgsql/data/data_dev.sql,v $
  25  --
  26  -- ===========================================================================
  27  
  28  delete from llx_tva;
  29  insert into llx_tva (datep, datev, amount) values ('2001-11-11','2001-10-01', 1960.00);
  30  insert into llx_tva (datep, datev, amount) values ('2001-04-11','2001-01-01', 2000.00);
  31  
  32  delete from llx_facture_fourn;
  33  
  34  insert into llx_facture_fourn (facnumber, fk_soc, datec, datef, paye, amount, remise, tva, total, fk_statut, fk_user_author, fk_user_valid, note)
  35  values ('LOL-509',1,'2001-05-09','2001-05-09',1,1000,0,196,1196,1,NULL,NULL,'');
  36  insert into llx_facture_fourn (facnumber, fk_soc, datec, datef, paye, amount, remise, tva, total, fk_statut, fk_user_author, fk_user_valid, note)
  37  values ('LOL-510',1,'2001-09-09','2001-09-09',1,100,0,19.6,119.6,1,NULL,NULL,'');
  38  
  39  insert into llx_facture_fourn (facnumber, fk_soc, datec, datef, paye, amount, remise, tva, total, fk_statut, fk_user_author, fk_user_valid, note)
  40  values ('02-1-YHGT',2,now(),'2002-01-01',1,100,0,19.6,119.6,1,NULL,NULL,'');
  41  
  42  insert into llx_facture_fourn (facnumber, fk_soc, datec, datef, paye, amount, remise, tva, total, fk_statut, fk_user_author, fk_user_valid, note)
  43  values ('02-5-YHGT',2,now(),'2002-05-01',1,1000,0,196,1196,1,NULL,NULL,'');
  44  
  45  insert into llx_facture_fourn (facnumber, fk_soc, datec, datef, paye, amount, remise, tva, total, fk_statut, fk_user_author, fk_user_valid, note)
  46  values ('02-10-YHGT',2,now(),'2002-10-01',1,1000,0,196,1196,1,NULL,NULL,'');
  47  insert into llx_facture_fourn (facnumber, fk_soc, datec, datef, paye, amount, remise, tva, total, fk_statut, fk_user_author, fk_user_valid, note)
  48  values ('02-11-YHGT',2,now(),'2002-11-01',1,1000,0,196,1196,1,NULL,NULL,'');
  49  insert into llx_facture_fourn (facnumber, fk_soc, datec, datef, paye, amount, remise, tva, total, fk_statut, fk_user_author, fk_user_valid, note)
  50  values ('02-12-YHGT',2,now(),'2002-12-01',1,1000,0,196,1196,1,NULL,NULL,'');
  51  
  52  UPDATE ONLY llx_const SET name = 'MAIN_THEME', value = 'yellow', type = 'chaine', visible = 1 WHERE name = 'MAIN_THEME';
  53  
  54  delete from llx_user;
  55  
  56  insert into llx_user (name,firstname,code,login,pass,module_comm,module_compta,webcal_login,admin)
  57  values ('demo','demo','DEMO','demo','demo',1,1,'demo',1);
  58  
  59  insert into llx_user (name,firstname,code,login,pass,module_comm,module_compta,webcal_login)
  60  values ('demo1','demo1','DM1','demo1','demo',1,1,'demo1');
  61  
  62  insert into llx_user (name,firstname,code,login,pass,module_comm,module_compta,webcal_login)
  63  values ('demo2','demo2','DM2','demo2','demo',1,1,'demo2');
  64  
  65  INSERT INTO llx_user_rights VALUES (1,11);
  66  INSERT INTO llx_user_rights VALUES (1,12);
  67  INSERT INTO llx_user_rights VALUES (1,13);
  68  INSERT INTO llx_user_rights VALUES (1,14);
  69  INSERT INTO llx_user_rights VALUES (1,15);
  70  INSERT INTO llx_user_rights VALUES (1,16);
  71  INSERT INTO llx_user_rights VALUES (1,17);
  72  INSERT INTO llx_user_rights VALUES (1,18);
  73  INSERT INTO llx_user_rights VALUES (1,19);
  74  INSERT INTO llx_user_rights VALUES (1,21);
  75  INSERT INTO llx_user_rights VALUES (1,22);
  76  INSERT INTO llx_user_rights VALUES (1,23);
  77  INSERT INTO llx_user_rights VALUES (1,24);
  78  INSERT INTO llx_user_rights VALUES (1,25);
  79  INSERT INTO llx_user_rights VALUES (1,26);
  80  INSERT INTO llx_user_rights VALUES (1,27);
  81  INSERT INTO llx_user_rights VALUES (1,28);
  82  INSERT INTO llx_user_rights VALUES (1,29);
  83  INSERT INTO llx_user_rights VALUES (1,31);
  84  INSERT INTO llx_user_rights VALUES (1,32);
  85  INSERT INTO llx_user_rights VALUES (1,33);
  86  INSERT INTO llx_user_rights VALUES (1,34);
  87  INSERT INTO llx_user_rights VALUES (1,35);
  88  INSERT INTO llx_user_rights VALUES (1,36);
  89  INSERT INTO llx_user_rights VALUES (1,37);
  90  INSERT INTO llx_user_rights VALUES (1,38);
  91  INSERT INTO llx_user_rights VALUES (1,39);
  92  INSERT INTO llx_user_rights VALUES (1,41);
  93  INSERT INTO llx_user_rights VALUES (1,42);
  94  INSERT INTO llx_user_rights VALUES (1,43);
  95  INSERT INTO llx_user_rights VALUES (1,44);
  96  INSERT INTO llx_user_rights VALUES (1,45);
  97  INSERT INTO llx_user_rights VALUES (1,46);
  98  INSERT INTO llx_user_rights VALUES (1,47);
  99  INSERT INTO llx_user_rights VALUES (1,48);
 100  INSERT INTO llx_user_rights VALUES (1,49);
 101  INSERT INTO llx_user_rights VALUES (1,61);
 102  INSERT INTO llx_user_rights VALUES (1,62);
 103  INSERT INTO llx_user_rights VALUES (1,63);
 104  INSERT INTO llx_user_rights VALUES (1,64);
 105  INSERT INTO llx_user_rights VALUES (1,65);
 106  INSERT INTO llx_user_rights VALUES (1,66);
 107  INSERT INTO llx_user_rights VALUES (1,67);
 108  INSERT INTO llx_user_rights VALUES (1,68);
 109  INSERT INTO llx_user_rights VALUES (1,69);
 110  
 111  
 112  --
 113  -- Societe les fournisseurs sont sur les numéros pairs
 114  --
 115  delete from llx_societe;
 116  
 117  insert into llx_societe (nom,datec,cp,ville,tel,fax, client, prefix_comm)
 118  values ('Cumulo',now(),'56610','Arradon','01 40 15 03 18','01 40 15 06 18',1,'CU');
 119  
 120  insert into llx_societe (nom,datec,cp,ville,tel,fax, client, prefix_comm, fournisseur)
 121  values ('Bolix SA',now(),'56350','Allaire','01 40 15 03 18','01 40 15 06 18',1,'LO',1);
 122  
 123  insert into llx_societe (nom,cp,ville,tel,fax,client, prefix_comm)
 124  values ('Doli INC.','29300','Arzano','01 55 55 03 18','01 55 55 55 55',1,'DO');
 125  
 126  insert into llx_societe (nom,cp,ville,tel,fax,client, prefix_comm,url, fournisseur)
 127  values ('Foo SARL','22300','Ploubezre','01 55 55 03 18','01 55 55 55 55',1,'FOO','www.gnu.org',1);
 128  
 129  insert into llx_societe (nom,datec,cp,ville,tel,fax, client, prefix_comm)
 130  values ('Talphinfo',now(),'29400','Bodilis','01 40 15 03 18','01 40 15 06 18',1,'AP');
 131  
 132  insert into llx_societe (idp,nom,cp,ville,tel,fax,fournisseur,prefix_comm)
 133  values (20,'Bouleau','22800','Le Foeil','01 55 55 03 18','01 55 55 55 55',1,'BTP');
 134  
 135  insert into llx_societe (nom,datec,cp,ville,tel,fax, client, prefix_comm)
 136  values ('Valphanix',now(),'29820','Bohars','01 40 15 03 18','01 40 15 06 18',1,'AL');
 137  
 138  insert into llx_societe (idp,nom,cp,ville,tel,fax,fournisseur,prefix_comm)
 139  values (101,'Cerisier','22290','Goudelin','01 55 55 03 18','01 55 55 55 55',1,'CER');
 140  
 141  insert into llx_societe (nom,cp,ville,tel,fax,client,url)
 142  values ('Turin','29890','Brignogan-Plage','01 55 55 03 18','01 55 55 55 55',1,'http://www.ot-brignogan-plage.fr/');
 143  
 144  insert into llx_societe (idp,nom,cp,ville,tel,fax,fournisseur,prefix_comm)
 145  values (100,'Chêne','22330','Le Gouray','01 55 55 03 18','01 55 55 55 55',1,'DEL');
 146  
 147  insert into llx_societe (nom,cp,ville,tel,fax,client)
 148  values ('Yratin SA','29660','Carantec','01 55 55 03 18','01 55 55 55 55',1);
 149  
 150  insert into llx_societe (nom,cp,ville,tel,fax,client)
 151  values ('Raggos SARL','29233','Cléder','01 55 55 03 18','01 55 55 55 55',1);
 152  
 153  insert into llx_societe (nom,cp,ville,tel,fax,client)
 154  values ('Pruitosa','29870','Coat-Méal','01 55 55 03 18','01 55 55 55 55',1);
 155  
 156  insert into llx_societe (nom,cp,ville,tel,fax,client)
 157  values ('Stratus','29120','Combrit','01 55 55 03 18','01 55 55 55 55',1);
 158  
 159  insert into llx_societe (nom,cp,ville,tel,fax,client)
 160  values ('Nimbus','29490','Guipavas','01 55 55 03 18','01 55 55 55 55',1);
 161  
 162  insert into llx_societe (nom,cp,ville,tel,fax,client)
 163  values ('Iono','22110','Rostrenen','01 55 55 03 18','01 55 55 55 55',1);
 164  --
 165  -- Contact
 166  --
 167  delete from llx_socpeople;
 168  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email,poste)
 169  values (10,1,'Maréchal','Ferdinand','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net','Administrateur système');
 170  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email)
 171  values (11,5,'Pejat','Jean-Marie','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net');
 172  
 173  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email,poste)
 174  values (12,1,'Poulossière','Paul','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net','Directeur technique');
 175  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email)
 176  values (13,6,'Myriam','Isabelle','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net');
 177  
 178  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email)
 179  values (20,2,'Corin','Arnaud','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net');
 180  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email)
 181  values (30,3,'Philippine','Sagan','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net');
 182  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email)
 183  values (31,3,'Marie','Jeanne','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net');
 184  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email)
 185  values (41,4,'Alix','Hopper','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net');
 186  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email)
 187  values (14,7,'Victoire','Renoir','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net');
 188  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email)
 189  values (15,7,'Baudelaire','Matthias','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net');
 190  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email)
 191  values (16,8,'Hugo','Benjamin','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net');
 192  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email)
 193  values (17,9,'Rembrandt','Stéphanie','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net');
 194  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email)
 195  values (18,10,'Picasso','Myriam','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net');
 196  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email)
 197  values (19,11,'Beethoven','John','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net');
 198  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email)
 199  values (22,11,'Dumas','Elisabeth','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net');
 200  insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email)
 201  values (21,10,'','Joséphine','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net');
 202  --
 203  --
 204  -- Produits
 205  --
 206  --
 207  insert into llx_product (ref, label, description, price, tva_tx)
 208  values ('RJ451MR','Câble Réseaux RJ45 1m rouge','Câble Réseaux RJ45 1m rouge',10,19.6);
 209  
 210  insert into llx_product (ref, label, description, price, tva_tx)
 211  values ('RJ454M','Câble Réseaux RJ45 4m','Câble Réseaux RJ45 4m\n couleur suivant stock',19.5,19.6);
 212  
 213  insert into llx_product (ref, label, description, price, tva_tx)
 214  values ('RJ452M','Câble Réseaux RJ45 2m','Câble Réseaux RJ45 2m',10,19.6);
 215  
 216  insert into llx_product (ref, label, description, price, tva_tx)
 217  values ('RJ458M','Câble Réseaux RJ45 8m','Câble Réseaux RJ45 8m',10,19.6);
 218  
 219  insert into llx_product (ref, label, description, price, tva_tx)
 220  values ('RJ4515M','Câble Réseaux RJ45 15m','Câble Réseaux RJ45 15m',10,19.6);
 221  
 222  insert into llx_product (ref, label, description, price, tva_tx, fk_product_type, duration)
 223  values ('HEB12MS','Hébergement serveur 12 mois','Hébergement serveur 12 mois',2400,19.6,1,'12m');
 224  
 225  insert into llx_product (ref, label, description, price, tva_tx, fk_product_type, duration)
 226  values ('HEB03MS','Hébergement serveur 3 mois','Hébergement serveur 3 mois',600,19.6,1,'3m');
 227  
 228  insert into llx_product (ref, label, description, price, tva_tx, fk_product_type, duration)
 229  values ('HEB06MS','Hébergement serveur 6 mois','Hébergement serveur 6 mois',1200,19.6,1,'6m');
 230  
 231  insert into llx_product (ref, label, description, price, tva_tx)
 232  values ('SW8','Switch 8 ports 100Mbits','Switch 8 ports 100Mbits',1000,19.6);
 233  
 234  insert into llx_product (ref, label, description, price, tva_tx)
 235  values ('SER1U','Serveur 1U Serie 3W','Serveur avec 1G de RAM et 2 processeurs',9750,19.6);
 236  
 237  insert into llx_product (ref, label, description, price, tva_tx)
 238  values ('HUB8-10','Hub 8 ports 10Mbits','Hub 8 ports',750,19.6);
 239  
 240  insert into llx_product (ref, label, description, price, tva_tx)
 241  values ('PB-16','Pan. Brass. 16','Panneau de brassage extensible, incluant 1 barre de 16 prises',650,19.6);
 242  
 243  insert into llx_product (ref, label, description, price, tva_tx)
 244  values ('PB-32','Pan. Brass. 32','Panneau de brassage extensible, incluant 2 barres de 16 prises',1200,19.6);
 245  
 246  insert into llx_product (ref, label, description, price, tva_tx)
 247  values ('HB-USB1','Hub Usb 4 ports','Hub USB 4 ports avec bloc d\'alimentation indépendant',31,19.6);
 248  
 249  --
 250  -- Liens produits fournisseurs
 251  --
 252  insert into llx_product_fournisseur (datec, fk_product,fk_soc,ref_fourn,fk_user_author)
 253  values (now(),1,2,'2313487',1);
 254  insert into llx_product_fournisseur (datec, fk_product,fk_soc,ref_fourn,fk_user_author)
 255  values (now(),2,2,'2313409',1);
 256  insert into llx_product_fournisseur (datec, fk_product,fk_soc,ref_fourn,fk_user_author)
 257  values (now(),3,2,'2323134',1);
 258  insert into llx_product_fournisseur (datec, fk_product,fk_soc,ref_fourn,fk_user_author)
 259  values (now(),3,4,'2313784',1);
 260  
 261  --
 262  --
 263  -- Fichinter
 264  --
 265  --
 266  delete from llx_fichinter;
 267  insert into llx_fichinter (fk_soc, ref, datec, date_valid, datei, fk_user_author, fk_user_valid, fk_statut, duree, note)
 268  values (1, 'FI-LP-1','2001-12-05','2001-12-05','2001-12-05',1,1,1,4,'Mise à jour de la doc');
 269  --
 270  -- Actions commerciales
 271  --
 272  delete from llx_actioncomm;
 273  insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_contact)
 274  values ('2002-04-06',1,1,1,1);
 275  insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_contact)
 276  values ('2002-04-05',2,1,1,1);
 277  insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_contact)
 278  values ('2002-04-05',1,1,1,1);
 279  insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_contact)
 280  values ('2002-04-02',3,1,1,1);
 281  insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_contact)
 282  values ('2002-04-02',3,1,1,1);
 283  insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_contact)
 284  values ('2002-03-05',3,1,1,1);
 285  insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_contact)
 286  values ('2002-03-04',1,1,1,1);
 287  insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_contact)
 288  values ('2001-03-05',1,1,1,1);
 289  --
 290  --
 291  --
 292  --
 293  insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm,datec)
 294  values ('Peuplier','22300','Lanmérin','01 55 55 03 18','01 55 55 55 55',1,'JP',now());
 295  
 296  insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm,datec)
 297  values ('Poirier','22290','Lannebert','01 55 55 03 18','01 55 55 55 55',1,'PO',now());
 298  
 299  insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm)
 300  values ('Orme','22400','Noyal','01 55 55 03 18','01 55 55 55 55',1,'ORM');
 301  
 302  insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm)
 303  values ('Pin','22200','Pabu','01 55 55 03 18','01 55 55 55 55',1,'PIN');
 304  
 305  insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm)
 306  values ('Merisier','22510','Penguily','01 55 55 03 18','01 55 55 55 55',1,'IKE');
 307  
 308  insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm)
 309  values ('Hêtre','22480','Peumerit-Quintin','01 55 55 03 18','01 55 55 55 55',1,'CAS');
 310  
 311  insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm)
 312  values ('Saule','22800','Quintin','01 55 55 03 18','01 55 55 55 55',1,'ME');
 313  
 314  insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm)
 315  values ('Poirier','22940','Plaintel','01 55 55 03 18','01 55 55 55 55',1,'CEG');
 316  
 317  insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm)
 318  values ('Tek','22300','Rospez','01 55 55 03 18','01 55 55 55 55',1,'LMT');
 319  --
 320  --
 321  --
 322  --
 323  
 324  delete from llx_propal;
 325  delete from llx_propaldet;
 326  delete from llx_facture;
 327  delete from llx_paiement;
 328  
 329  
 330  delete from llx_compta_account;
 331  insert into llx_compta_account (datec, number, label, fk_user_author) values (now(),'431000','URSSAF',1);
 332  insert into llx_compta_account (datec, number, label, fk_user_author) values (now(),'654000','Clients',1);
 333  --
 334  -- Charges sociales (mais non on n'en paye pas trop ;-)
 335  --
 336  delete from llx_chargesociales;
 337  insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values
 338  ('2002-05-15',NULL,'Acompte 1er Trimestre 2002',1,120,0,'2002-1-1');
 339  
 340  insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values
 341  ('2002-05-15',NULL,'Acompte 1er Trimestre 2002',2,200,0,'2002-1-1');
 342  
 343  insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values
 344  ('2002-05-15',NULL,'Acompte 1er Trimestre 2002',3,170,0,'2002-1-1');
 345  
 346  insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values
 347  ('2002-02-15','2002-02-10','Acompte 4ème Trimestre 2001',1,120,1,'2001-10-1');
 348  
 349  insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values
 350  ('2002-02-15','2002-02-10','Acompte 4ème Trimestre 2001',2,200,1,'2001-10-1');
 351  
 352  insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values
 353  ('2002-02-15','2002-02-10','Acompte 4ème Trimestre 2001',3,170,1,'2001-10-1');
 354  
 355  insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values
 356  ('2001-11-15','2001-10-10','Acompte 3ème Trimestre 2001',1,70,1,'2001-7-1');
 357  
 358  insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values
 359  ('2001-11-15','2001-10-10','Acompte 3ème Trimestre 2001',2,180,1,'2001-7-1');
 360  
 361  insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values
 362  ('2001-11-15','2001-10-10','Acompte 3ème Trimestre 2001',3,150,1,'2001-7-1');
 363  
 364  --
 365  -- Dumping data for table `llx_bank`
 366  --
 367  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 368  VALUES (now(),'2002-01-13','2002-01-13',4000,'Dépôt liquide',1,1,1,'DEP',200201,NULL,1,NULL,NULL);
 369  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 370  VALUES (now(),'2002-01-14','2002-01-14',-20,'Liquide',1,1,1,'CB',200201,NULL,1,NULL,NULL);
 371  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 372  VALUES (now(),'2002-02-14','2002-02-14',-23.2,'Essence',1,1,1,'CB',200201,NULL,1,NULL,NULL);
 373  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 374  VALUES (now(),'2002-02-15','2002-02-15',-53.32,'Cartouches imprimante',1,1,1,'CB',200202,NULL,0,NULL,NULL);
 375  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 376  VALUES (now(),'2002-02-17','2002-02-17',-100,'Liquide',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL);
 377  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 378  VALUES (now(),'2002-02-18','2002-02-18',-153.32,'Restaurant',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL);
 379  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 380  VALUES (now(),'2002-02-20','2002-02-20',-1532,'Réparation climatisation',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL);
 381  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 382  VALUES (now(),'2002-02-21','2002-02-21',-100,'Liquide',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL);
 383  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 384  VALUES (now(),'2002-02-22','2002-02-22',-46,'Timbres postes',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL);
 385  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 386  VALUES (now(),'2002-03-02','2002-03-02',-60,'Liquide',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL);
 387  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 388  VALUES (now(),'2002-03-02','2002-03-02',-25.66,'Essence',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL);
 389  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 390  VALUES (now(),'2002-03-03','2002-03-03',-60,'Liquide',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL);
 391  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 392  VALUES (now(),'2002-03-04','2002-03-04',-15.2,'Café',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL);
 393  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 394  VALUES (now(),'2002-03-06','2002-03-06',-12.3,'Péage',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL);
 395  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 396  VALUES (now(),'2002-03-06','2002-03-06',-25.3,'Péage',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL);
 397  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 398  VALUES (now(),'2002-03-06','2002-03-06',-9.6,'Tickets de bus',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL);
 399  INSERT INTO llx_bank (datec, datev, dateo, amount, label, fk_account, fk_user_author, fk_user_rappro, fk_type, num_releve, num_chq, rappro, note, author)
 400  VALUES (now(),'2002-03-13','2002-03-13',-10,'Liquide',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL);
 401  
 402  --
 403  -- Dumping data for table `llx_bank_account`
 404  --
 405  
 406  --INSERT INTO llx_bank_account (rowid, datec, tms, label, bank, code_banque, code_guichet, number, cle_rib, bic, iban_prefix, domiciliation, courant, clos) VALUES (1,'2001-01-01 13:06:11',20031014173428,'CCP','La PosteToto','','','','','','','',1,0);