[Sommaire] [Imprimer]

   1  #
   2  # Copyright (C) 2001-2002 Rodolphe Quiedeville <rodolphe@quiedeville.org>
   3  # Copyright (C) 2002-2003 Éric Seigne <erics@rycks.com>
   4  # Copyright (C) 2004 Benoit Mortier <benoit.mortier@opensides.be>
   5  #
   6  # $Id: Makefile,v 1.5 2004/07/12 19:57:30 opensides Exp $
   7  # $Source: /cvsroot/dolibarr/dolibarr/pgsql/tables/Makefile,v $
   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 2 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, write to the Free Software
  21  # Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
  22  #
  23  SQL=psql
  24  BASE=dolibarr
  25  OWNER=dolibarradm
  26  OPTIONS=-U $(OWNER) 
  27  
  28  all:    show
  29  
  30  create:    
  31      $(SQL) $(OPTIONS) $(BASE) < actioncomm.sql
  32      $(SQL) $(OPTIONS) $(BASE) < c_actioncomm.sql
  33      $(SQL) $(OPTIONS) $(BASE) < c_chargesociales.sql
  34      $(SQL) $(OPTIONS) $(BASE) < c_effectif.sql
  35      $(SQL) $(OPTIONS) $(BASE) < c_paiement.sql
  36      $(SQL) $(OPTIONS) $(BASE) < c_pays.sql
  37      $(SQL) $(OPTIONS) $(BASE) < c_propalst.sql
  38      $(SQL) $(OPTIONS) $(BASE) < c_stcomm.sql
  39      $(SQL) $(OPTIONS) $(BASE) < c_typent.sql
  40      $(SQL) $(OPTIONS) $(BASE) < llx_adherent.sql
  41      $(SQL) $(OPTIONS) $(BASE) < llx_bank.sql
  42      $(SQL) $(OPTIONS) $(BASE) < llx_bank_account.sql
  43      $(SQL) $(OPTIONS) $(BASE) < llx_bank_categ.sql
  44      $(SQL) $(OPTIONS) $(BASE) < llx_bank_class.sql
  45      $(SQL) $(OPTIONS) $(BASE) < llx_bookmark.sql
  46      $(SQL) $(OPTIONS) $(BASE) < llx_chargesociales.sql
  47      $(SQL) $(OPTIONS) $(BASE) < llx_compta.sql
  48      $(SQL) $(OPTIONS) $(BASE) < llx_compta_account.sql
  49      $(SQL) $(OPTIONS) $(BASE) < llx_cotisation.sql
  50      $(SQL) $(OPTIONS) $(BASE) < llx_don.sql
  51      $(SQL) $(OPTIONS) $(BASE) < llx_don_projet.sql
  52      $(SQL) $(OPTIONS) $(BASE) < llx_fa_pr.sql
  53      $(SQL) $(OPTIONS) $(BASE) < llx_facture.sql
  54      $(SQL) $(OPTIONS) $(BASE) < llx_facture_fourn.sql
  55      $(SQL) $(OPTIONS) $(BASE) < llx_fichinter.sql
  56      $(SQL) $(OPTIONS) $(BASE) < llx_paiement.sql
  57      $(SQL) $(OPTIONS) $(BASE) < llx_pointmort.sql
  58      $(SQL) $(OPTIONS) $(BASE) < llx_product.sql
  59      $(SQL) $(OPTIONS) $(BASE) < llx_projet.sql
  60      $(SQL) $(OPTIONS) $(BASE) < llx_propal.sql
  61      $(SQL) $(OPTIONS) $(BASE) < llx_propaldet.sql
  62      $(SQL) $(OPTIONS) $(BASE) < llx_service.sql
  63      $(SQL) $(OPTIONS) $(BASE) < llx_soc_recontact.sql
  64      $(SQL) $(OPTIONS) $(BASE) < llx_tva.sql
  65      $(SQL) $(OPTIONS) $(BASE) < llx_user.sql
  66      $(SQL) $(OPTIONS) $(BASE) < llx_ventes.sql
  67      $(SQL) $(OPTIONS) $(BASE) < llx_voyage.sql
  68      $(SQL) $(OPTIONS) $(BASE) < llx_voyage_reduc.sql
  69      $(SQL) $(OPTIONS) $(BASE) < societe.sql
  70      $(SQL) $(OPTIONS) $(BASE) < socpeople.sql
  71      $(SQL) $(OPTIONS) $(BASE) < socstatutlog.sql
  72  
  73  drop:
  74      $(SQL) $(OPTIONS) $(BASE) < drop.sql
  75  
  76  show:
  77      $(SQL) $(OPTIONS) $(BASE) -c '\d'