llx_c_actioncomm.sql 3.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. -- Copyright (C) 2001-2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
  2. -- Copyright (C) 2003 Jean-Louis Bergamo <jlb@j1b.org>
  3. -- Copyright (C) 2004-2009 Laurent Destailleur <eldy@users.sourceforge.net>
  4. -- Copyright (C) 2004 Benoit Mortier <benoit.mortier@opensides.be>
  5. -- Copyright (C) 2004 Guillaume Delecourt <guillaume.delecourt@opensides.be>
  6. -- Copyright (C) 2005-2011 Regis Houssin <regis.houssin@capnetworks.com>
  7. -- Copyright (C) 2007 Patrick Raguin <patrick.raguin@gmail.com>
  8. --
  9. -- This program is free software; you can redistribute it and/or modify
  10. -- it under the terms of the GNU General Public License as published by
  11. -- the Free Software Foundation; either version 3 of the License, or
  12. -- (at your option) any later version.
  13. --
  14. -- This program is distributed in the hope that it will be useful,
  15. -- but WITHOUT ANY WARRANTY; without even the implied warranty of
  16. -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  17. -- GNU General Public License for more details.
  18. --
  19. -- You should have received a copy of the GNU General Public License
  20. -- along with this program. If not, see <http://www.gnu.org/licenses/>.
  21. --
  22. --
  23. --
  24. -- Ne pas placer de commentaire en fin de ligne, ce fichier est parsé lors
  25. -- de l'install et tous les sigles '--' sont supprimés.
  26. --
  27. --
  28. -- Types action comm
  29. --
  30. delete from llx_c_actioncomm where id in (1,2,3,4,5,8,9,10,30,31,40,50);
  31. -- Code used from 3.3+ when type of event is used
  32. insert into llx_c_actioncomm (id, code, type, libelle, module, active, position) values ( 1,'AC_TEL','system','Phone call',NULL, 1, 2);
  33. insert into llx_c_actioncomm (id, code, type, libelle, module, active, position) values ( 2,'AC_FAX','system','Send Fax',NULL, 1, 3);
  34. insert into llx_c_actioncomm (id, code, type, libelle, module, active, position) values ( 4,'AC_EMAIL','system','Send Email',NULL, 1, 4);
  35. insert into llx_c_actioncomm (id, code, type, libelle, module, active, position) values ( 5,'AC_RDV','system','Rendez-vous',NULL, 1, 1);
  36. insert into llx_c_actioncomm (id, code, type, libelle, module, active, position) values (11,'AC_INT','system','Intervention on site',NULL, 1, 4);
  37. -- Code kept for backward compatibility < 3.3
  38. insert into llx_c_actioncomm (id, code, type, libelle, module, active, position) values ( 3,'AC_PROP','systemauto', 'Send commercial proposal by email','propal',0,10);
  39. insert into llx_c_actioncomm (id, code, type, libelle, module, active, position) values ( 8,'AC_COM','systemauto','Send customer order by email','order', 0,8);
  40. insert into llx_c_actioncomm (id, code, type, libelle, module, active, position) values ( 9,'AC_FAC','systemauto', 'Send customer invoice by email','invoice',0,6);
  41. insert into llx_c_actioncomm (id, code, type, libelle, module, active, position) values ( 10,'AC_SHIP','systemauto', 'Send shipping by email','shipping',0,11);
  42. insert into llx_c_actioncomm (id, code, type, libelle, module, active, position) values ( 30,'AC_SUP_ORD','systemauto','Send supplier order by email','order_supplier',0,9);
  43. insert into llx_c_actioncomm (id, code, type, libelle, module, active, position) values ( 31,'AC_SUP_INV','systemauto','Send supplier invoice by email','invoice_supplier',0,7);
  44. -- Code used from 3.3+ when type of event is not used
  45. insert into llx_c_actioncomm (id, code, type, libelle, module, active, position) values ( 40,'AC_OTH_AUTO','systemauto','Other (automatically inserted events)',NULL, 1, 20);
  46. insert into llx_c_actioncomm (id, code, type, libelle, module, active, position) values ( 50,'AC_OTH','system','Other (manually inserted events)',NULL, 1, 5);