Skip to content
Snippets Groups Projects
Select Git revision
  • fa5a7796b4289f0cb828109af8afa227c57f1d93
  • 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_fichinter.key.sql

Blame
  • llx_fichinter.key.sql 1.25 KiB
    -- Generated from dolibarr_mysql2pgsql
    -- (c) 2004, PostgreSQL Inc.
    -- (c) 2005, Laurent Destailleur.
    
    -- ===================================================================
    -- Copyright (C) 2005 Laurent Destailleur  <eldy@users.sourceforge.net>
    --
    -- 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$
    -- $Source$
    --
    -- ===================================================================
    
    
    ALTER TABLE llx_fichinter ADD INDEX idx_fichinter_fk_soc (fk_soc);
    ALTER TABLE llx_fichinter ADD CONSTRAINT fichinter_fk_soc_idp		FOREIGN KEY (fk_soc)     REFERENCES llx_societe (idp);