| [ Index ] |
|
Code source de Dolibarr 2.0.1 |
1 -- =========================================================================== 2 -- Copyright (C) 2001-2005 Rodolphe Quiedeville <rodolphe@quiedeville.org> 3 -- 4 -- This program is free software. you can redistribute it and/or modify 5 -- it under the terms of the GNU General Public License as published by 6 -- the Free Software Foundation. either version 2 of the License, or 7 -- (at your option) any later version. 8 -- 9 -- This program is distributed in the hope that it will be useful, 10 -- but WITHOUT ANY WARRANTY. without even the implied warranty of 11 -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 12 -- GNU General Public License for more details. 13 -- 14 -- You should have received a copy of the GNU General Public License 15 -- along with this program. if not, write to the Free Software 16 -- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. 17 -- 18 -- $Id: data_dev.sql,v 1.38 2005/12/17 17:19:19 hregis Exp $ 19 -- $Source: /cvsroot/dolibarr/dolibarr/mysql/data/data_dev.sql,v $ 20 -- 21 -- Valeurs de test pour les developpements 22 -- Ne pas hésiter a compléter ce fichier avec de nouvelles valeurs, plus on a 23 -- de données, mieux on peut tester l'appli. 24 -- =========================================================================== 25 -- ; 26 delete from llx_bank_account; 27 delete from llx_chargesociales; 28 delete from llx_fichinter; 29 delete from llx_actioncomm; 30 delete from llx_propal; 31 delete from llx_propaldet; 32 delete from llx_paiement_facture; 33 delete from llx_paiement; 34 delete from llx_facturedet; 35 delete from llx_facture_tva_sum; 36 delete from llx_facture; 37 delete from llx_compta_account; 38 delete from llx_product_fournisseur_price; 39 delete from llx_product; 40 delete from llx_facture_fourn; 41 delete from llx_socpeople; 42 delete from llx_societe; 43 delete from llx_boxes; 44 delete from llx_user_rights; 45 delete from llx_user; 46 delete from llx_tva; 47 delete from llx_energie_compteur; 48 delete from llx_energie_compteur_releve; 49 delete from llx_energie_compteur_groupe; 50 delete from llx_energie_groupe; 51 52 53 DELETE FROM llx_const WHERE name = 'MAIN_NOT_INSTALLED'; 54 55 insert into llx_tva (datep, datev, amount) values ('2001-11-11','2001-10-01', 1960.00); 56 insert into llx_tva (datep, datev, amount) values ('2001-04-11','2001-01-01', 2000.00); 57 58 59 -- 60 -- Societe les fournisseurs sont sur les numéros pairs 61 -- 62 63 64 insert into llx_societe (idp,nom,address,datec,cp,ville,tel,fax, client, prefix_comm) 65 values (1,'Cumulo','3 place de la République',now(),'56610','Arradon','01 40 15 03 18','01 40 15 06 18',1,'CU'); 66 67 insert into llx_societe (idp,nom,address,datec,cp,ville,tel,fax, client, prefix_comm, fournisseur, url, fk_forme_juridique) 68 values (2,'Bolix SA','13 rue Pierre Mendès France',now(),'56350','Allaire','01 40 15 03 18','01 40 15 06 18',1,'LO',1,'www.dolibarr.com',54); 69 70 insert into llx_societe (idp,nom,address,cp,ville,tel,fax,client, prefix_comm) 71 values (10,'Doli INC.','Rue du Port','29300','Arzano','01 55 55 03 18','01 55 55 55 55',1,'DO'); 72 73 insert into llx_societe (idp,nom,address,cp,ville,tel,fax,client, prefix_comm,url, fournisseur) 74 values (3,'Foo SARL','3bis Avenue de la Liberté','22300','Ploubezre','01 55 55 03 18','01 55 55 55 55',1,'FOO','www.gnu.org', 1); 75 76 insert into llx_societe (idp,nom,address,datec,cp,ville,tel,fax, client, prefix_comm) 77 values (4,'Talphinfo','Place Dolores Ibarruri',now(),'29400','Bodilis','01 40 15 03 18','01 40 15 06 18',1,'AP'); 78 79 insert into llx_societe (idp,nom,cp,ville,tel,fax,fournisseur,prefix_comm) 80 values (20,'Bouleau','22800','Le Foeil','01 55 55 03 18','01 55 55 55 55',1,'BTP'); 81 82 insert into llx_societe (nom,datec,cp,ville,tel,fax, client, prefix_comm) 83 values ('Valphanix',now(),'29820','Bohars','01 40 15 03 18','01 40 15 06 18',2,'AL'); 84 85 insert into llx_societe (idp,nom,cp,ville,tel,fax,fournisseur,prefix_comm) 86 values (101,'Cerisier','22290','Goudelin','01 55 55 03 18','01 55 55 55 55',1,'CER'); 87 88 insert into llx_societe (nom,cp,ville,tel,fax,client,url) 89 values ('Turin','29890','Brignogan-Plage','01 55 55 03 18','01 55 55 55 55',1,'http://www.ot-brignogan-plage.fr/'); 90 91 insert into llx_societe (idp,nom,cp,ville,tel,fax,fournisseur,prefix_comm) 92 values (100,'Chêne','22330','Le Gouray','01 55 55 03 18','01 55 55 55 55',1,'DEL'); 93 94 insert into llx_societe (idp,nom,cp,ville,tel,fax,client) 95 values (5,'Yratin SA','29660','Carantec','01 55 55 03 18','01 55 55 55 55',1); 96 97 insert into llx_societe (idp,nom,cp,ville,tel,fax,client) 98 values (6,'Raggos SARL','29233','Cléder','01 55 55 03 18','01 55 55 55 55',1); 99 100 insert into llx_societe (idp,nom,cp,ville,tel,fax,client) 101 values (7,'Pruitosa','29870','Coat-Méal','01 55 55 03 18','01 55 55 55 55',2); 102 103 insert into llx_societe (idp,nom,cp,ville,tel,fax,client) 104 values (8,'Stratus','29120','Combrit','01 55 55 03 18','01 55 55 55 55',2); 105 106 insert into llx_societe (idp,nom,cp,ville,tel,fax,client,address) 107 values (9,'Nimbus','29490','Guipavas','01 55 55 03 18','01 55 55 55 55',2,'15 rue des petites écuries'); 108 109 insert into llx_societe (nom,cp,ville,tel,fax,client) 110 values ('Iono','22110','Rostrenen','01 55 55 03 18','01 55 55 55 55',2); 111 112 insert into llx_societe (nom,datec,cp,ville,tel,fax, client, prefix_comm,address) 113 values ('Bolan',now(),'29820','Bohars','01 40 15 03 18','01 40 15 06 18',2,'CAL','104 Avenue de la Marne'); 114 115 insert into llx_societe (nom,datec,cp,ville,tel,fax, client, prefix_comm,address) 116 values ('Travail Temporaire Boharssais',now(),'29820','Bohars','01 40 15 03 18','01 40 15 06 18',2,'TTBOH','125 Rue des moineaux'); 117 -- 118 -- Utilisateurs 119 -- 120 replace into llx_user (name,firstname,code,login,pass,webcal_login,datec,admin) 121 values ('demo','demo','DEMO','demo','demo','demo',sysdate(),0); 122 123 replace into llx_user (name,firstname,code,login,pass,webcal_login,datec) 124 values ('demo1','demo1','DM1','demo1','demo','demo1',sysdate()); 125 126 replace into llx_user (name,firstname,code,login,pass,webcal_login,datec) 127 values ('demo2','demo2','DM2','demo2','demo','demo2',sysdate()); 128 129 -- 130 -- Facture fournisseurs 131 -- 132 133 insert into llx_facture_fourn (facnumber, fk_soc, datec, datef, paye, amount, remise, tva, total, fk_statut, fk_user_author, fk_user_valid, note) 134 values ('LOL-509',1,'2001-05-09','2001-05-09',1,1000,0,196,1196,1,1,1,''); 135 insert into llx_facture_fourn (facnumber, fk_soc, datec, datef, paye, amount, remise, tva, total, fk_statut, fk_user_author, fk_user_valid, note) 136 values ('LOL-510',1,'2001-09-09','2001-09-09',1,100,0,19.6,119.6,1,1,1,''); 137 138 insert into llx_facture_fourn (facnumber, fk_soc, datec, datef, paye, amount, remise, tva, total, fk_statut, fk_user_author, fk_user_valid, note) 139 values ('02-1-YHGT',2,now(),'2002-01-01',1,100,0,19.6,119.6,1,NULL,NULL,''); 140 141 insert into llx_facture_fourn (facnumber, fk_soc, datec, datef, paye, amount, remise, tva, total, fk_statut, fk_user_author, fk_user_valid, note) 142 values ('02-5-YHGT',2,now(),'2002-05-01',1,1000,0,196,1196,1,NULL,NULL,''); 143 144 insert into llx_facture_fourn (facnumber, fk_soc, datec, datef, paye, amount, remise, tva, total, fk_statut, fk_user_author, fk_user_valid, note) 145 values ('02-10-YHGT',2,now(),'2002-10-01',1,1000,0,196,1196,1,NULL,NULL,''); 146 insert into llx_facture_fourn (facnumber, fk_soc, datec, datef, paye, amount, remise, tva, total, fk_statut, fk_user_author, fk_user_valid, note) 147 values ('02-11-YHGT',2,now(),'2002-11-01',1,1000,0,196,1196,1,NULL,NULL,''); 148 insert into llx_facture_fourn (facnumber, fk_soc, datec, datef, paye, amount, remise, tva, total, fk_statut, fk_user_author, fk_user_valid, note) 149 values ('02-12-YHGT',2,now(),'2002-12-01',1,1000,0,196,1196,1,NULL,NULL,''); 150 151 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_THEME', 'eldy_backoffice','chaine',1); 152 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_THEME', 'eldy','chaine',1); 153 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_THEME', 'eldy','chaine',1); 154 155 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_INFO_SOCIETE_NOM','Barridol','chaine',0); 156 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_INFO_SOCIETE_ADRESSE','10 road street','chaine',0); 157 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_INFO_SOCIETE_CP','75000','chaine',0); 158 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_INFO_SOCIETE_VILLE','BigTown','chaine',0); 159 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_INFO_SOCIETE_PAYS','1','chaine',0); 160 161 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_INFO_SOCIETE_TEL','01 02 03 04 05','chaine',0); 162 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_INFO_SOCIETE_FAX','01 02 03 04 06','chaine',0); 163 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_INFO_SOCIETE_WEB','dolibarr.jexiste.fr','chaine',0); 164 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_INFO_SOCIETE_MAIL','mycompany@mycompany.com','chaine',0); 165 166 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_INFO_TVAINTRA','12345679012345','chaine',0); 167 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_INFO_CAPITAL','15000','chaine',0); 168 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_INFO_SIREN','123456789','chaine',0); 169 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_INFO_SIRET','123456789001','chaine',0); 170 REPLACE INTO llx_const (name, value, type, visible) VALUES ('MAIN_INFO_APE','721Z','chaine',0); 171 172 173 174 175 176 177 178 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,11); 179 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,12); 180 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,13); 181 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,14); 182 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,15); 183 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,16); 184 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,17); 185 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,18); 186 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,19); 187 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,21); 188 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,22); 189 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,23); 190 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,24); 191 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,25); 192 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,26); 193 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,27); 194 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,28); 195 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,29); 196 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,31); 197 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,32); 198 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,33); 199 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,34); 200 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,35); 201 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,36); 202 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,37); 203 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,38); 204 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,39); 205 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,41); 206 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,42); 207 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,43); 208 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,44); 209 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,45); 210 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,46); 211 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,47); 212 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,48); 213 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,49); 214 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,61); 215 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,62); 216 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,63); 217 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,64); 218 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,65); 219 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,66); 220 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,67); 221 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,68); 222 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,69); 223 224 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,71); 225 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,72); 226 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,73); 227 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,74); 228 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,75); 229 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,76); 230 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,77); 231 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,78); 232 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,79); 233 234 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,81); 235 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,82); 236 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,83); 237 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,84); 238 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,85); 239 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,86); 240 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,87); 241 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,88); 242 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,89); 243 244 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,91); 245 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,92); 246 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,93); 247 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,94); 248 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,95); 249 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,96); 250 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,97); 251 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,98); 252 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,99); 253 254 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,101); 255 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,102); 256 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,103); 257 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,104); 258 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,105); 259 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,106); 260 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,107); 261 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,108); 262 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,109); 263 264 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,111); 265 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,112); 266 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,113); 267 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,114); 268 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,115); 269 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,116); 270 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,117); 271 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,118); 272 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,119); 273 274 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,121); 275 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,122); 276 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,123); 277 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,124); 278 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,125); 279 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,126); 280 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,127); 281 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,128); 282 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,129); 283 284 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,161); 285 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,162); 286 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,163); 287 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,164); 288 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,165); 289 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,166); 290 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,167); 291 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,168); 292 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,169); 293 294 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,221); 295 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,222); 296 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,223); 297 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,224); 298 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,225); 299 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,226); 300 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,227); 301 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,228); 302 INSERT INTO llx_user_rights (fk_user, fk_id) VALUES (1,229); 303 304 305 -- 306 -- Boites 307 -- 308 309 INSERT INTO `llx_boxes` VALUES (8, 1, 0, 1); 310 INSERT INTO `llx_boxes` VALUES (9, 2, 0, 2); 311 INSERT INTO `llx_boxes` VALUES (11, 4, 0, 4); 312 INSERT INTO `llx_boxes` VALUES (12, 5, 0, 5); 313 INSERT INTO `llx_boxes` VALUES (13, 6, 0, 6); 314 INSERT INTO `llx_boxes` VALUES (14, 7, 0, 7); 315 INSERT INTO `llx_boxes` VALUES (15, 14, 0, 4); 316 INSERT INTO `llx_boxes` VALUES (17, 26, 0, 11); 317 INSERT INTO `llx_boxes` VALUES (18, 22, 0, 8); 318 INSERT INTO `llx_boxes` VALUES (19, 23, 0, 9); 319 INSERT INTO `llx_boxes` VALUES (20, 24, 0, 10); 320 INSERT INTO `llx_boxes` VALUES (21, 25, 0, 7); 321 INSERT INTO `llx_boxes` VALUES (24, 20, 0, 1); 322 INSERT INTO `llx_boxes` VALUES (25, 21, 0, 2); 323 324 -- 325 -- Contact 326 -- 327 328 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email,poste) 329 values (10,1,'Maréchal','Ferdinand','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net','Administrateur système'); 330 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email) 331 values (11,5,'Pejat','Jean-Marie','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net'); 332 333 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email,poste) 334 values (12,1,'Poulossière','Paul','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net','Directeur technique'); 335 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email) 336 values (13,6,'Myriam','Isabelle','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net'); 337 338 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email) 339 values (20,2,'Corin','Arnaud','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net'); 340 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email) 341 values (30,3,'Philippine','Sagan','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net'); 342 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email) 343 values (31,3,'Marie','Jeanne','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net'); 344 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email) 345 values (41,4,'Alix','Hopper','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net'); 346 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email) 347 values (14,7,'Victoire','Renoir','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net'); 348 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email) 349 values (15,7,'Baudelaire','Matthias','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net'); 350 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email) 351 values (16,8,'Hugo','Benjamin','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net'); 352 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email) 353 values (17,9,'Rembrandt','Stéphanie','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net'); 354 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email) 355 values (18,10,'Picasso','Myriam','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net'); 356 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email) 357 values (19,1,'Beethoven','John','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net'); 358 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email) 359 values (22,6,'Dumas','Elisabeth','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net'); 360 insert into llx_socpeople (idp,fk_soc, name, firstname, phone,fax,email) 361 values (21,10,'','Joséphine','01 40 15 03 18','01 40 15 06 18','dev@lafrere.net'); 362 -- 363 -- 364 -- Produits 365 -- 366 -- 367 insert into llx_product (ref, label, description, price, tva_tx) 368 values ('RJ451MR','Câble Réseaux RJ45 1m rouge','Câble Réseaux RJ45 1m rouge',10,19.6); 369 370 insert into llx_product (ref, label, description, price, tva_tx) 371 values ('RJ454M','Câble Réseaux RJ45 4m','Câble Réseaux RJ45 4m\n couleur suivant stock',19.5,19.6); 372 373 insert into llx_product (ref, label, description, price, tva_tx) 374 values ('RJ452M','Câble Réseaux RJ45 2m','Câble Réseaux RJ45 2m',10,19.6); 375 376 insert into llx_product (ref, label, description, price, tva_tx) 377 values ('RJ458M','Câble Réseaux RJ45 8m','Câble Réseaux RJ45 8m',10,19.6); 378 379 insert into llx_product (ref, label, description, price, tva_tx) 380 values ('RJ4515M','Câble Réseaux RJ45 15m','Câble Réseaux RJ45 15m',10,19.6); 381 382 insert into llx_product (ref, label, description, price, tva_tx, fk_product_type, duration) 383 values ('HEB12MS','Hébergement serveur 12 mois','Hébergement serveur 12 mois',2400,19.6,1,'12m'); 384 385 insert into llx_product (ref, label, description, price, tva_tx, fk_product_type, duration) 386 values ('HEB03MS','Hébergement serveur 3 mois','Hébergement serveur 3 mois',600,19.6,1,'3m'); 387 388 insert into llx_product (ref, label, description, price, tva_tx, fk_product_type, duration) 389 values ('HEB06MS','Hébergement serveur 6 mois','Hébergement serveur 6 mois',1200,19.6,1,'6m'); 390 391 insert into llx_product (ref, label, description, price, tva_tx) 392 values ('SW8','Switch 8 ports 100Mbits','Switch 8 ports 100Mbits',1000,19.6); 393 394 insert into llx_product (ref, label, description, price, tva_tx) 395 values ('SER1U','Serveur 1U Serie 3W','Serveur avec 1G de RAM et 2 processeurs',9750,19.6); 396 397 insert into llx_product (ref, label, description, price, tva_tx) 398 values ('HUB8-10','Hub 8 ports 10Mbits','Hub 8 ports',750,19.6); 399 400 insert into llx_product (ref, label, description, price, tva_tx) 401 values ('PB-16','Pan. Brass. 16','Panneau de brassage extensible, incluant 1 barre de 16 prises',650,19.6); 402 403 insert into llx_product (ref, label, description, price, tva_tx) 404 values ('PB-32','Pan. Brass. 32','Panneau de brassage extensible, incluant 2 barres de 16 prises',1200,19.6); 405 406 insert into llx_product (ref, label, description, price, tva_tx) 407 values ('HB-USB1','Hub Usb 4 ports','Hub USB 4 ports avec bloc d\'alimentation indépendant',31,19.6); 408 409 -- 410 -- Liens produits fournisseurs 411 -- 412 insert into llx_product_fournisseur (datec, fk_product,fk_soc,ref_fourn,fk_user_author) 413 values (now(),1,2,'2313487',1); 414 insert into llx_product_fournisseur (datec, fk_product,fk_soc,ref_fourn,fk_user_author) 415 values (now(),2,2,'2313409',1); 416 insert into llx_product_fournisseur (datec, fk_product,fk_soc,ref_fourn,fk_user_author) 417 values (now(),3,2,'2323134',1); 418 insert into llx_product_fournisseur (datec, fk_product,fk_soc,ref_fourn,fk_user_author) 419 values (now(),3,4,'2313784',1); 420 -- 421 -- Fichinter 422 -- 423 -- 424 425 insert into llx_fichinter (fk_soc, ref, datec, date_valid, datei, fk_user_author, fk_user_valid, fk_statut, duree, note) 426 values (1, 'FI-LP-1','2001-12-05','2001-12-05','2001-12-05',1,1,1,4,'Mise à jour de la doc'); 427 -- 428 -- Actions commerciales 429 -- 430 431 insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_user_action,fk_contact) 432 values ('2002-04-06',1,1,1,1,1); 433 insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_user_action,fk_contact) 434 values ('2002-04-05',2,1,1,1,1); 435 insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_user_action,fk_contact) 436 values ('2002-04-05',1,1,1,2,1); 437 insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_user_action,fk_contact) 438 values ('2002-04-02',3,1,1,1,1); 439 insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_user_action,fk_contact) 440 values ('2002-04-02',3,1,1,1,1); 441 insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_user_action,fk_contact) 442 values ('2002-03-05',3,1,1,1,1); 443 insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_user_action,fk_contact) 444 values ('2002-03-04',1,1,1,1,1); 445 insert into llx_actioncomm (datea, fk_action,fk_soc,fk_user_author,fk_user_action,fk_contact) 446 values ('2001-03-05',1,1,1,1,1); 447 -- 448 -- 449 -- 450 -- 451 452 insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm,datec) 453 values ('Peuplier','22300','Lanmérin','01 55 55 03 18','01 55 55 55 55',1,'JP',now()); 454 455 insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm,datec) 456 values ('Poirier','22290','Lannebert','01 55 55 03 18','01 55 55 55 55',1,'PO',now()); 457 458 insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm) 459 values ('Orme','22400','Noyal','01 55 55 03 18','01 55 55 55 55',1,'ORM'); 460 461 insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm) 462 values ('Pin','22200','Pabu','01 55 55 03 18','01 55 55 55 55',1,'PIN'); 463 464 insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm) 465 values ('Merisier','22510','Penguily','01 55 55 03 18','01 55 55 55 55',1,'IKE'); 466 467 insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm) 468 values ('Hêtre','22480','Peumerit-Quintin','01 55 55 03 18','01 55 55 55 55',1,'CAS'); 469 470 insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm) 471 values ('Saule','22800','Quintin','01 55 55 03 18','01 55 55 55 55',1,'ME'); 472 473 insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm) 474 values ('Poirier','22940','Plaintel','01 55 55 03 18','01 55 55 55 55',1,'CEG'); 475 476 insert into llx_societe (nom,cp,ville,tel,fax,fournisseur,prefix_comm) 477 values ('Tek','22300','Rospez','01 55 55 03 18','01 55 55 55 55',1,'LMT'); 478 -- 479 -- 480 -- 481 -- 482 483 484 insert into llx_compta_account (datec, number, label, fk_user_author) values (now(),'431000','URSSAF',1); 485 insert into llx_compta_account (datec, number, label, fk_user_author) values (now(),'654000','Clients',1); 486 487 -- 488 -- Charges sociales 489 -- 490 491 insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values 492 ('2002-05-15',NULL,'Acompte 1er Trimestre 2002',1,120,0,'2002-1-1'); 493 494 insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values 495 ('2002-05-15',NULL,'Acompte 1er Trimestre 2002',2,200,0,'2002-1-1'); 496 497 insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values 498 ('2002-05-15',NULL,'Acompte 1er Trimestre 2002',3,170,0,'2002-1-1'); 499 500 insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values 501 ('2002-02-15','2002-02-10','Acompte 4ème Trimestre 2001',1,120,1,'2001-10-1'); 502 503 insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values 504 ('2002-02-15','2002-02-10','Acompte 4ème Trimestre 2001',2,200,1,'2001-10-1'); 505 506 insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values 507 ('2002-02-15','2002-02-10','Acompte 4ème Trimestre 2001',3,170,1,'2001-10-1'); 508 509 insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values 510 ('2001-11-15','2001-10-10','Acompte 3ème Trimestre 2001',1,70,1,'2001-7-1'); 511 512 insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values 513 ('2001-11-15','2001-10-10','Acompte 3ème Trimestre 2001',2,180,1,'2001-7-1'); 514 515 insert into llx_chargesociales (date_ech,date_pai,libelle,fk_type,amount,paye,periode) values 516 ('2001-11-15','2001-10-10','Acompte 3ème Trimestre 2001',3,150,1,'2001-7-1'); 517 518 -- MySQL dump 9.09 519 -- 520 -- Host: localhost Database: dolibarr 521 -- ------------------------------------------------------- 522 -- Server version 4.0.15-log 523 524 -- 525 -- Dumping data for table `llx_bank` 526 -- 527 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) 528 VALUES (now(),'2002-01-13','2002-01-13',4000,'Dépôt liquide',1,1,1,'DEP',200201,NULL,1,NULL,NULL); 529 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) 530 VALUES (now(),'2002-01-14','2002-01-14',-20,'Liquide',1,1,1,'CB',200201,NULL,1,NULL,NULL); 531 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) 532 VALUES (now(),'2002-02-14','2002-02-14',-23.2,'Essence',1,1,1,'CB',200201,NULL,1,NULL,NULL); 533 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) 534 VALUES (now(),'2002-02-15','2002-02-15',-53.32,'Cartouches imprimante',1,1,1,'CB',200202,NULL,0,NULL,NULL); 535 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) 536 VALUES (now(),'2002-02-17','2002-02-17',-100,'Liquide',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL); 537 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) 538 VALUES (now(),'2002-02-18','2002-02-18',-153.32,'Restaurant',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL); 539 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) 540 VALUES (now(),'2002-02-20','2002-02-20',-1532,'Réparation climatisation',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL); 541 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) 542 VALUES (now(),'2002-02-21','2002-02-21',-100,'Liquide',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL); 543 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) 544 VALUES (now(),'2002-02-22','2002-02-22',-46,'Timbres postes',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL); 545 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) 546 VALUES (now(),'2002-03-02','2002-03-02',-60,'Liquide',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL); 547 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) 548 VALUES (now(),'2002-03-02','2002-03-02',-25.66,'Essence',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL); 549 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) 550 VALUES (now(),'2002-03-03','2002-03-03',-60,'Liquide',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL); 551 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) 552 VALUES (now(),'2002-03-04','2002-03-04',-15.2,'Café',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL); 553 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) 554 VALUES (now(),'2002-03-06','2002-03-06',-12.3,'Péage',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL); 555 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) 556 VALUES (now(),'2002-03-06','2002-03-06',-25.3,'Péage',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL); 557 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) 558 VALUES (now(),'2002-03-06','2002-03-06',-9.6,'Tickets de bus',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL); 559 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) 560 VALUES (now(),'2002-03-13','2002-03-13',-10,'Liquide',1,1,NULL,'CB',NULL,NULL,0,NULL,NULL); 561 562 -- MySQL dump 9.09 563 -- 564 -- Host: localhost Database: dolibarr 565 -- ------------------------------------------------------- 566 -- Server version 4.0.15-log 567 568 -- 569 -- Dumping data for table `llx_bank_account` 570 -- 571 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); 572 573 -- 574 -- Energie 575 -- 576 INSERT INTO llx_energie_compteur VALUES (1,'EDF Vitré',1,now(),1,''); 577 INSERT INTO llx_energie_compteur VALUES (2,'Eau Vitré',2,now(),1,''); 578 INSERT INTO llx_energie_compteur VALUES (3,'Gaz Vitré',3,now(),1,''); 579 580 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-07-26',1139); 581 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-07-21',1129); 582 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-07-16',1128); 583 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-07-11',1128); 584 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-07-06',1128); 585 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-07-01',1127); 586 587 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-06-26',1127); 588 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-06-21',1126); 589 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-06-16',1116); 590 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-06-11',1107); 591 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-06-06',1097); 592 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-06-01',1087); 593 594 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-05-26',1078); 595 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-05-21',1068); 596 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-05-16',1059); 597 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-05-11',1049); 598 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-05-06',1038); 599 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-05-01',1028); 600 601 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-04-26',1013); 602 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-04-21',1003); 603 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-04-16',984); 604 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-04-11',965); 605 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-04-06',945); 606 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-04-01',926); 607 608 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-03-26',906); 609 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-03-21',884); 610 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-03-16',862); 611 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-03-11',841); 612 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-03-06',828); 613 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-03-01',807); 614 615 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-02-26',785); 616 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-02-21',760); 617 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-02-16',737); 618 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-02-11',713); 619 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-02-06',688); 620 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-02-01',662); 621 622 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-01-26',637); 623 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-01-21',605); 624 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-01-16',575); 625 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-01-11',545); 626 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-01-06',510); 627 INSERT INTO llx_energie_compteur_releve (fk_compteur, date_releve,valeur) VALUES (1,'2005-01-01',480); 628 629 630
titre
Description
Corps
titre
Description
Corps
titre
Description
Corps
titre
Corps
| Généré le : Mon Nov 26 12:29:37 2007 | par Balluche grâce à PHPXref 0.7 |
|
|