Home Explore Help
Register Sign In
URBANMS
/
EXCELIA_DBARR
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: dff609cf58
Branches Tags
EXCELIA_DBARR
/
install
/
mysql
/
data
/
llx_c_ecotaxe.sql

llx_c_ecotaxe.sql 4.5 KB
History Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152 
  1. -- Copyright (C) 2001-2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
    2. 

  2. -- Copyright (C) 2003      Jean-Louis Bergamo   <jlb@j1b.org>
    3. 

  3. -- Copyright (C) 2004-2009 Laurent Destailleur  <eldy@users.sourceforge.net>
    4. 

  4. -- Copyright (C) 2004      Benoit Mortier       <benoit.mortier@opensides.be>
    5. 

  5. -- Copyright (C) 2004      Guillaume Delecourt  <guillaume.delecourt@opensides.be>
    6. 

  6. -- Copyright (C) 2005-2018 Regis Houssin        <regis.houssin@inodbox.com>
    7. 

  7. -- Copyright (C) 2007 	   Patrick Raguin       <patrick.raguin@gmail.com>
    8. 

  8. --
    9. 

  9. -- This program is free software; you can redistribute it and/or modify
    10. 

  10. -- it under the terms of the GNU General Public License as published by
    11. 

  11. -- the Free Software Foundation; either version 3 of the License, or
    12. 

  12. -- (at your option) any later version.
    13. 

  13. --
    14. 

  14. -- This program is distributed in the hope that it will be useful,
    15. 

  15. -- but WITHOUT ANY WARRANTY; without even the implied warranty of
    16. 

  16. -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    17. 

  17. -- GNU General Public License for more details.
    18. 

  18. --
    19. 

  19. -- You should have received a copy of the GNU General Public License
    20. 

  20. -- along with this program. If not, see <https://www.gnu.org/licenses/>.
    21. 

  21. --
    22. 

  22. --
    23. 

  23. 

  24. --
    25. 

  25. -- Ne pas placer de commentaire en fin de ligne, ce fichier est parsé lors
    26. 

  26. -- de l'install et tous les sigles '--' sont supprimés.
    27. 

  27. --
    28. 

  28. 

  29. --
    30. 

  30. -- Eco-Taxes
    31. 

  31. --
    32. 

  32. 

  33. -- France (Organisme Eco-systèmes)
    34. 

  34. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (1, '25040', 'PETIT APPAREILS MENAGERS', 0.25000000, 'Eco-systèmes', 1, 1);
    35. 

  35. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (2, '25050', 'TRES PETIT APPAREILS MENAGERS', 0.08000000, 'Eco-systèmes', 1, 1);
    36. 

  36. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (3, '32070', 'ECRAN POIDS < 5 KG', 2.08000000, 'Eco-systèmes', 1, 1);
    37. 

  37. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (4, '32080', 'ECRAN POIDS > 5 KG', 1.25000000, 'Eco-systèmes', 1, 1);
    38. 

  38. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (5, '32051', 'ORDINATEUR PORTABLE', 0.42000000, 'Eco-systèmes', 1, 1);
    39. 

  39. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (6, '32061', 'TABLETTE INFORMATIQUE', 0.84000000, 'Eco-systèmes', 1, 1);
    40. 

  40. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (7, '36011', 'ORDINATEUR FIXE (UC)', 1.15000000, 'Eco-systèmes', 1, 1);
    41. 

  41. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (8, '36021', 'IMPRIMANTES', 0.83000000, 'Eco-systèmes', 1, 1);
    42. 

  42. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (9, '36030', 'IT (INFORMATIQUE ET TELECOMS)', 0.83000000, 'Eco-systèmes', 1, 1);
    43. 

  43. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (10, '36040', 'PETIT IT (CLAVIERS / SOURIS)', 0.08000000, 'Eco-systèmes', 1, 1);
    44. 

  44. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (11, '36050', 'TELEPHONIE MOBILE', 0.02000000, 'Eco-systèmes', 1, 1);
    45. 

  45. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (12, '36060', 'CONNECTIQUE CABLES', 0.02000000, 'Eco-systèmes', 1, 1);
    46. 

  46. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (13, '45010', 'GROS MATERIEL GRAND PUBLIC (TELEAGRANDISSEURS)', 1.67000000, 'Eco-systèmes', 1, 1);
    47. 

  47. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (14, '45020', 'MOYEN MATERIEL GRAND PUBLIC (LOUPES ELECTRONIQUES)', 0.42000000, 'Eco-systèmes', 1, 1);
    48. 

  48. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (15, '45030', 'PETIT MATERIEL GRAND PUBLIC (VIE QUOTIDIENNE)', 0.08000000, 'Eco-systèmes', 1, 1);
    49. 

  49. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (16, '75030', 'JOUETS < 0,5 KG', 0.08000000, 'Eco-systèmes', 1, 1);
    50. 

  50. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (17, '75040', 'JOUETS ENTRE 0,5 KG ET 10 KG', 0.17000000, 'Eco-systèmes', 1, 1);
    51. 

  51. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (18, '74050', 'JOUETS > 10 KG', 1.67000000, 'Eco-systèmes', 1, 1);
    52. 

  52. INSERT INTO llx_c_ecotaxe (rowid, code, label, price, organization, fk_pays, active) VALUES (19, '85010', 'EQUIPEMENT MEDICAL < 0,5 KG', 0.08000000, 'Eco-systèmes', 1, 1);
    53.