[Sommaire] [Imprimer]

   1  --
   2  -- Copyright (C) 2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
   3  --
   4  -- This program is free software; you can redistribute it and/or modify
   5  -- it under the terms of the GNU General Public License as published by
   6  -- the Free Software Foundation; either version 2 of the License, or
   7  -- (at your option) any later version.
   8  --
   9  -- This program is distributed in the hope that it will be useful,
  10  -- but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  -- GNU General Public License for more details.
  13  --
  14  -- You should have received a copy of the GNU General Public License
  15  -- along with this program; if not, write to the Free Software
  16  -- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
  17  --
  18  -- $Id: innodb.sql,v 1.1 2005/08/13 19:14:20 rodolphe Exp $
  19  -- $Source: /cvsroot/dolibarr/dolibarr/mysql/innodb.sql,v $
  20  --
  21  --
  22  -- Migration des tables au format innodb
  23  --
  24  alter table llx_co_fa type=INNODB;
  25  
  26  alter table llx_co_pr type=INNODB;
  27  
  28  alter table llx_c_actioncomm type=INNODB;
  29  
  30  alter table llx_c_chargesociales type=INNODB;
  31  
  32  alter table llx_c_effectif type=INNODB;
  33  
  34  alter table llx_c_paiement  type=INNODB;
  35  
  36  alter table llx_c_prestatype  type=INNODB;
  37  
  38  alter table llx_c_propalst  type=INNODB;
  39  
  40  alter table llx_c_stcomm type=INNODB;
  41  
  42  alter table llx_c_typent  type=INNODB;
  43  
  44  alter table llx_action_def type=INNODB;
  45  
  46  alter table llx_actioncomm type=INNODB;
  47  
  48  alter table llx_adherent type=INNODB;
  49  
  50  alter table llx_adherent_type type=INNODB;
  51  
  52  alter table llx_adherent_options type=INNODB;
  53  
  54  alter table llx_adherent_options_label type=INNODB;
  55  
  56  alter table llx_album type=INNODB;
  57  
  58  alter table llx_album_to_groupart  type=INNODB;
  59  
  60  alter table llx_appro  type=INNODB;
  61  
  62  alter table llx_auteur type=INNODB;
  63  
  64  alter table llx_bank type=INNODB;
  65  
  66  alter table llx_bank_account type=INNODB;
  67  
  68  alter table llx_bank_categ type=INNODB;
  69  
  70  alter table llx_bank_class type=INNODB;
  71  
  72  alter table llx_bank_url type=INNODB;
  73  
  74  alter table llx_birthday_alert type=INNODB;
  75  
  76  alter table llx_bookmark type=INNODB;
  77  
  78  alter table llx_boxes type=INNODB;
  79  
  80  alter table llx_boxes_def type=INNODB;
  81  
  82  alter table llx_chargesociales type=INNODB;
  83  
  84  alter table llx_commande type=INNODB;
  85  
  86  alter table llx_commandedet type=INNODB;
  87  
  88  alter table llx_commande_fournisseur type=INNODB;
  89  
  90  alter table llx_commande_fournisseur_log type=INNODB;
  91  
  92  alter table llx_commande_fournisseurdet type=INNODB;
  93  
  94  alter table llx_compta type=INNODB;
  95  
  96  alter table llx_compta_account type=INNODB;
  97  
  98  alter table llx_concert  type=INNODB;
  99  
 100  alter table llx_cond_reglement  type=INNODB;
 101  
 102  alter table llx_const type=INNODB;
 103  
 104  alter table llx_contact_facture type=INNODB;
 105  
 106  alter table llx_cotisation type=INNODB;
 107  
 108  alter table llx_deplacement type=INNODB;
 109  
 110  alter table llx_domain  type=INNODB;
 111  
 112  alter table llx_don type=INNODB;
 113  
 114  alter table llx_don_projet type=INNODB;
 115  
 116  alter table llx_editeur type=INNODB;
 117  
 118  alter table llx_entrepot type=INNODB;
 119  
 120  alter table llx_expedition type=INNODB;
 121  
 122  alter table llx_expedition_methode type=INNODB;
 123  
 124  alter table llx_expeditiondet type=INNODB;
 125  
 126  alter table llx_fa_pr type=INNODB;
 127  
 128  alter table llx_facture_rec type=INNODB;
 129  
 130  alter table llx_facturedet type=INNODB;
 131  
 132  alter table llx_facturedet_rec type=INNODB;
 133  
 134  alter table llx_facture_fourn type=INNODB;
 135  
 136  alter table llx_facture_fourn_det type=INNODB;
 137  
 138  alter table llx_fichinter type=INNODB;
 139  
 140  alter table llx_groupart type=INNODB;
 141  
 142  alter table llx_lieu_concert  type=INNODB;
 143  
 144  alter table llx_livre type=INNODB;
 145  
 146  alter table llx_livre_to_auteur  type=INNODB;
 147  
 148  alter table llx_newsletter type=INNODB;
 149  
 150  alter table llx_notify  type=INNODB;
 151  
 152  alter table llx_notify_def type=INNODB;
 153  
 154  alter table llx_paiementfourn type=INNODB;
 155  
 156  alter table llx_pointmort type=INNODB;
 157  
 158  alter table llx_product_fournisseur type=INNODB;
 159  
 160  alter table llx_product_price type=INNODB;
 161  
 162  alter table llx_product_stock type=INNODB;
 163  
 164  alter table llx_propal_model_pdf type=INNODB;
 165  
 166  alter table llx_propaldet type=INNODB;
 167  
 168  alter table llx_rights_def type=INNODB;
 169  
 170  alter table llx_service type=INNODB;
 171  
 172  alter table llx_societe_ca type=INNODB;
 173  
 174  alter table llx_societe_details type=INNODB;
 175  
 176  alter table llx_societe_prestation type=INNODB;
 177  
 178  alter table llx_societe_reference type=INNODB;
 179  
 180  alter table llx_societe_remise type=INNODB;
 181  
 182  alter table llx_societe_remise_except type=INNODB;
 183  
 184  alter table llx_societe_rib type=INNODB;
 185  
 186  alter table llx_societe_techno type=INNODB;
 187  
 188  alter table llx_socpeople type=INNODB;
 189  
 190  alter table llx_soc_events type=INNODB;
 191  
 192  alter table llx_soc_recontact type=INNODB;
 193  
 194  alter table llx_socstatutlog  type=INNODB;
 195  
 196  alter table llx_stock type=INNODB;
 197  
 198  alter table llx_stock_mouvement type=INNODB;
 199  
 200  alter table llx_sqltables type=INNODB;
 201  
 202  alter table llx_todocomm  type=INNODB;
 203  
 204  alter table llx_transaction_bplc  type=INNODB;
 205  
 206  alter table llx_tva type=INNODB;
 207  
 208  alter table llx_user_rights type=INNODB;
 209  
 210  alter table llx_ventes type=INNODB;
 211  
 212  alter table llx_voyage type=INNODB;
 213  
 214  alter table llx_voyage_reduc type=INNODB;
 215  
 216  alter table llx_facture_tva_sum type=INNODB;
 217  
 218  alter table llx_c_accountingsystem type=INNODB;
 219  
 220  alter table llx_c_ape type=INNODB;
 221  
 222  alter table llx_c_civilite type=INNODB;
 223  
 224  alter table llx_c_currencies type=INNODB;
 225  
 226  alter table llx_c_departements type=INNODB;
 227  
 228  alter table llx_c_forme_juridique type=INNODB;
 229  
 230  alter table llx_c_prestation type=INNODB;
 231  
 232  alter table llx_c_regions type=INNODB;
 233  
 234  alter table llx_c_techno type=INNODB;
 235  
 236  alter table llx_catalog_societe type=INNODB;
 237  
 238  alter table llx_catalogsoc type=INNODB;
 239  
 240  alter table llx_groupesociete type=INNODB;
 241  alter table llx_groupesociete_remise type=INNODB;
 242  alter table llx_mailing type=INNODB;
 243  alter table llx_mailing_cibles type=INNODB;
 244  alter table llx_paiement_facture type=INNODB;
 245  alter table llx_paiementcharge type=INNODB;
 246  alter table llx_so_gr type=INNODB;
 247  
 248  alter table llx_user_alert type=INNODB;
 249  alter table llx_user_param type=INNODB;
 250  
 251  alter table llx_bookmark4u_login type=INNODB;
 252  alter table llx_c_methode_commande_fournisseur type=INNODB;
 253  alter table llx_compta_compte_generaux type=INNODB;
 254  alter table llx_contratdet type=INNODB;
 255  alter table llx_contratdet_log type=INNODB;
 256  alter table llx_export_compta type=INNODB;
 257  
 258  alter table llx_prelevement_notifications type=INNODB;
 259  alter table llx_prelevement_facture type=INNODB;
 260  alter table llx_prelevement_facture_demande type=INNODB;
 261  alter table llx_prelevement_rejet type=INNODB;
 262  alter table llx_prelevement_lignes type=INNODB;
 263  alter table llx_prelevement_bons type=INNODB;
 264  alter table llx_prelevement type=INNODB;
 265  alter table llx_product_fournisseur_price type=INNODB;
 266  alter table llx_societe_commerciaux type=INNODB;
 267  alter table llx_user_clicktodial type=INNODB;
 268  alter table llx_usergroup_rights type=INNODB;
 269  alter table llx_usergroup_user type=INNODB;
 270  alter table llx_usergroup type=INNODB;
 271  
 272  
 273  alter table llx_cash type=INNODB;
 274  alter table llx_cash_account type=INNODB;
 275  alter table llx_contrat_service type=INNODB;
 276  alter table llx_telephonie_client_statistique type=INNODB;
 277  alter table llx_telephonie_client_stats type=INNODB;
 278  alter table llx_telephonie_client_stats_mensuel type=INNODB;
 279  alter table llx_telephonie_commande type=INNODB;
 280  alter table llx_telephonie_commande_retour type=INNODB;
 281  alter table llx_telephonie_communications_details type=INNODB;
 282  alter table llx_telephonie_concurrents type=INNODB;
 283  alter table llx_telephonie_contact_facture type=INNODB;
 284  alter table llx_telephonie_contrat type=INNODB;
 285  alter table llx_telephonie_contrat_contact_facture type=INNODB;
 286  alter table llx_telephonie_facture type=INNODB;
 287  alter table llx_telephonie_fournisseur type=INNODB;
 288  alter table llx_telephonie_groupe_ligne type=INNODB;
 289  alter table llx_telephonie_groupeligne type=INNODB;
 290  alter table llx_telephonie_import_cdr type=INNODB;
 291  alter table llx_telephonie_ligne_statistique type=INNODB;
 292  alter table llx_telephonie_prefix type=INNODB;
 293  alter table llx_telephonie_service type=INNODB;
 294  alter table llx_telephonie_simul type=INNODB;
 295  alter table llx_telephonie_simul_comm type=INNODB;
 296  alter table llx_telephonie_societe_ligne type=INNODB;
 297  alter table llx_telephonie_societe_ligne_remise type=INNODB;
 298  alter table llx_telephonie_societe_ligne_statut type=INNODB;
 299  alter table llx_telephonie_tarif type=INNODB;
 300  alter table llx_telephonie_tarif_client type=INNODB;
 301  alter table llx_telephonie_tarif_fournisseur type=INNODB;
 302  
 303  alter table llx_categorie_association type=INNODB;
 304  alter table llx_categorie_product type=INNODB;
 305  alter table llx_product_fournisseur_price_log type=INNODB;
 306  alter table llx_categorie type=INNODB;
 307  
 308  alter table llx_accountingsystem_det type=INNODB;
 309  
 310  alter table llx_accountingsystem type=INNODB;
 311  
 312  alter table llx_energie_compteur_releve type=INNODB;
 313  alter table llx_energie_compteur_groupe type=INNODB;
 314  alter table llx_energie_compteur type=INNODB;
 315  alter table llx_energie_groupe type=INNODB;
 316  alter table llx_dolibarr_modules type=INNODB;
 317  
 318  alter table llx_energie_compteur_groupe type=INNODB;
 319  
 320  alter table llx_energie_compteur_releve type=INNODB;
 321  
 322  alter table llx_energie_groupe type=INNODB; 
 323  
 324  alter table llx_energie_compteur type=INNODB;
 325  
 326  alter table llx_propal type=INNODB;
 327  
 328  alter table llx_product type=INNODB;
 329  
 330  alter table llx_facture type=INNODB;
 331  
 332  alter table llx_contrat type=INNODB;
 333  
 334  alter table llx_paiement type=INNODB;
 335  
 336  alter table llx_c_pays  type=INNODB;
 337  
 338  alter table llx_projet type=INNODB;
 339  
 340  alter table llx_societe type=INNODB;
 341  
 342  alter table llx_user type=INNODB;
 343  
 344  -- historique
 345  
 346  alter table c_actioncomm type=INNODB;
 347  alter table c_chargesociales type=INNODB;
 348  alter table c_effectif type=INNODB;
 349  alter table c_paiement type=INNODB;
 350  alter table c_pays type=INNODB;
 351  alter table c_propalst type=INNODB;
 352  alter table c_stcomm type=INNODB;
 353  alter table c_typent type=INNODB;