Skip to content
Snippets Groups Projects
Select Git revision
  • 407d4e7d0b0d7dceaff3c1d9bcbef54b58385f81
  • 3.9 default
  • develop
  • 6.0
  • 5.0
  • 4.0
  • scrutinizer-patch-4
  • scrutinizer-patch-3
  • scrutinizer-patch-2
  • scrutinizer-patch-1
  • 3.7
  • 3.8
  • 3.6
  • 3.9_backported
  • 3.8_backported
  • 3.7_backported
  • 3.5
  • 3.6_backported
  • 3.5_backported
  • 3.4
  • 3.3_backported
  • 6.0.4
  • 6.0.3
  • 5.0.7
  • 6.0.2
  • 6.0.1
  • 5.0.6
  • 6.0.0
  • 5.0.5
  • 6.0.0-rc
  • 5.0.4
  • 6.0.0-beta
  • 5.0.3
  • 4.0.6
  • 5.0.2
  • 5.0.1
  • 4.0.5
  • 5.0.0
  • 4.0.4
  • 5.0.0-rc2
  • 5.0.0-rc1
41 results

llx_commande.key.sql

Blame
  • llx_commande.key.sql 1.44 KiB
    -- ============================================================================
    -- Copyright (C) 2006 Laurent Destailleur  <eldy@users.sourceforge.net>
    -- Copyright (C) 2009 Regis Houssin        <regis@dolibarr.fr>
    --
    -- This program is free software; you can redistribute it and/or modify
    -- it under the terms of the GNU General Public License as published by
    -- the Free Software Foundation; either version 2 of the License, or
    -- (at your option) any later version.
    --
    -- This program is distributed in the hope that it will be useful,
    -- but WITHOUT ANY WARRANTY; without even the implied warranty of
    -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    -- GNU General Public License for more details.
    --
    -- You should have received a copy of the GNU General Public License
    -- along with this program; if not, write to the Free Software
    -- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
    --
    -- $Id$
    -- ============================================================================
    
    
    -- Supprimme orphelins pour permettre monte de la cl
    -- V4 DELETE llx_commande FROM llx_commande LEFT JOIN llx_societe ON llx_commande.fk_soc = llx_societe.rowid WHERE llx_societe.rowid IS NULL; 
    
    ALTER TABLE llx_commande ADD UNIQUE INDEX uk_commande_ref (ref, entity);
    
    ALTER TABLE llx_commande ADD INDEX idx_commande_fk_soc (fk_soc);
    ALTER TABLE llx_commande ADD CONSTRAINT fk_commande_fk_soc FOREIGN KEY (fk_soc) REFERENCES llx_societe (rowid);