Dépôt officiel du code source de l'ERP OpenConcerto

/*

/*

 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.

 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.

 * 

 * 

 * Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.

 * Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.

 * 

 * 

 * The contents of this file are subject to the terms of the GNU General Public License Version 3

 * The contents of this file are subject to the terms of the GNU General Public License Version 3

 * only ("GPL"). You may not use this file except in compliance with the License. You can obtain a

 * only ("GPL"). You may not use this file except in compliance with the License. You can obtain a

 * copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific

 * copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific

 * language governing permissions and limitations under the License.

 * language governing permissions and limitations under the License.

 * 

 * 

 * When distributing the software, include this License Header Notice in each file.

 * When distributing the software, include this License Header Notice in each file.

 */

 */

 package org.openconcerto.erp.config;

 package org.openconcerto.erp.config;

import org.openconcerto.erp.config.update.Updater_1_5;

import org.openconcerto.erp.config.update.Updater_1_5;

import org.openconcerto.erp.core.humanresources.payroll.report.LignePayeSimplifiee;

import org.openconcerto.erp.core.humanresources.payroll.report.LignePayeSimplifiee;

import org.openconcerto.erp.core.sales.order.ui.EtatCommandeClient;

import org.openconcerto.erp.core.sales.order.ui.EtatCommandeClient;

import org.openconcerto.erp.core.sales.quote.element.EtatDevisSQLElement;

import org.openconcerto.erp.core.sales.quote.element.EtatDevisSQLElement;

import org.openconcerto.erp.modules.ModuleManager;

import org.openconcerto.erp.modules.ModuleManager;

import org.openconcerto.erp.modules.ModuleReference;

import org.openconcerto.erp.modules.ModuleReference;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.changer.convert.AddFK;

import org.openconcerto.sql.changer.convert.AddFK;

import org.openconcerto.sql.changer.convert.ChangeIDToInt;

import org.openconcerto.sql.changer.convert.ChangeIDToInt;

import org.openconcerto.sql.changer.correct.CorrectOrder;

import org.openconcerto.sql.changer.correct.CorrectOrder;

import org.openconcerto.sql.changer.correct.FixSerial;

import org.openconcerto.sql.changer.correct.FixSerial;

import org.openconcerto.sql.element.GroupSQLComponent;

import org.openconcerto.sql.element.GroupSQLComponent;

import org.openconcerto.sql.model.AliasedTable;

import org.openconcerto.sql.model.AliasedTable;

import org.openconcerto.sql.model.DBRoot;

import org.openconcerto.sql.model.DBRoot;

import org.openconcerto.sql.model.DBSystemRoot;

import org.openconcerto.sql.model.DBSystemRoot;

import org.openconcerto.sql.model.SQLBase;

import org.openconcerto.sql.model.SQLBase;

import org.openconcerto.sql.model.SQLDataSource;

import org.openconcerto.sql.model.SQLDataSource;

import org.openconcerto.sql.model.SQLField;

import org.openconcerto.sql.model.SQLField;

import org.openconcerto.sql.model.SQLField.Properties;

import org.openconcerto.sql.model.SQLField.Properties;

import org.openconcerto.sql.model.SQLInjector;

import org.openconcerto.sql.model.SQLInjector;

import org.openconcerto.sql.model.SQLName;

import org.openconcerto.sql.model.SQLName;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowListRSH;

import org.openconcerto.sql.model.SQLRowListRSH;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.model.SQLRowValuesListFetcher;

import org.openconcerto.sql.model.SQLRowValuesListFetcher;

import org.openconcerto.sql.model.SQLSchema;

import org.openconcerto.sql.model.SQLSchema;

import org.openconcerto.sql.model.SQLSelect;

import org.openconcerto.sql.model.SQLSelect;

import org.openconcerto.sql.model.SQLSyntax;

import org.openconcerto.sql.model.SQLSyntax;

import org.openconcerto.sql.model.SQLSystem;

import org.openconcerto.sql.model.SQLSystem;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.model.Where;

import org.openconcerto.sql.model.Where;

import org.openconcerto.sql.model.graph.SQLKey;

import org.openconcerto.sql.model.graph.SQLKey;

import org.openconcerto.sql.request.Inserter;

import org.openconcerto.sql.request.Inserter;

import org.openconcerto.sql.request.Inserter.Insertion;

import org.openconcerto.sql.request.Inserter.Insertion;

import org.openconcerto.sql.request.UpdateBuilder;

import org.openconcerto.sql.request.UpdateBuilder;

import org.openconcerto.sql.sqlobject.SQLTextCombo;

import org.openconcerto.sql.sqlobject.SQLTextCombo;

import org.openconcerto.sql.users.rights.TableAllRights;

import org.openconcerto.sql.users.rights.TableAllRights;

import org.openconcerto.sql.utils.AlterTable;

import org.openconcerto.sql.utils.AlterTable;

import org.openconcerto.sql.utils.ChangeTable;

import org.openconcerto.sql.utils.ChangeTable;

import org.openconcerto.sql.utils.ChangeTable.ClauseType;

import org.openconcerto.sql.utils.ChangeTable.ClauseType;

import org.openconcerto.sql.utils.ChangeTable.DeferredClause;

import org.openconcerto.sql.utils.ChangeTable.DeferredClause;

import org.openconcerto.sql.utils.ReOrder;

import org.openconcerto.sql.utils.ReOrder;

import org.openconcerto.sql.utils.SQLCreateMoveableTable;

import org.openconcerto.sql.utils.SQLCreateMoveableTable;

import org.openconcerto.sql.utils.SQLCreateTable;

import org.openconcerto.sql.utils.SQLCreateTable;

import org.openconcerto.sql.utils.SQLUtils;

import org.openconcerto.sql.utils.SQLUtils;

import org.openconcerto.sql.utils.SQLUtils.SQLFactory;

import org.openconcerto.sql.utils.SQLUtils.SQLFactory;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.JLabelBold;

import org.openconcerto.ui.JLabelBold;

import org.openconcerto.utils.CollectionUtils;

import org.openconcerto.utils.CollectionUtils;

import org.openconcerto.utils.ExceptionHandler;

import org.openconcerto.utils.ExceptionHandler;

import org.openconcerto.utils.ProductInfo;

import org.openconcerto.utils.ProductInfo;

import org.openconcerto.utils.StringUtils;

import org.openconcerto.utils.StringUtils;

import org.openconcerto.utils.cc.ITransformer;

import org.openconcerto.utils.cc.ITransformer;

import java.awt.GridBagConstraints;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.GridBagLayout;

import java.awt.Insets;

import java.awt.Insets;

import java.awt.event.ActionEvent;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.ActionListener;

import java.io.IOException;

import java.io.IOException;

import java.math.BigDecimal;

import java.math.BigDecimal;

import java.sql.SQLException;

import java.sql.SQLException;

import java.sql.Types;

import java.sql.Types;

import java.util.ArrayList;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.Arrays;

import java.util.Collection;

import java.util.Collection;

import java.util.Collections;

import java.util.Collections;

import java.util.EnumSet;

import java.util.EnumSet;

import java.util.HashMap;

import java.util.HashMap;

import java.util.HashSet;

import java.util.HashSet;

import java.util.List;

import java.util.List;

import java.util.Map;

import java.util.Map;

import java.util.Set;

import java.util.Set;

import javax.swing.JButton;

import javax.swing.JButton;

import javax.swing.JLabel;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JPanel;

import javax.swing.JProgressBar;

import javax.swing.JProgressBar;

import javax.swing.JTextField;

import javax.swing.JTextField;

import javax.swing.SwingUtilities;

import javax.swing.SwingUtilities;

public class InstallationPanel extends JPanel {

public class InstallationPanel extends JPanel {

    private static final boolean DEBUG_FK = false;

    private static final boolean DEBUG_FK = false;

    public static void insertUndef(final SQLCreateTable ct) throws SQLException {

    public static void insertUndef(final SQLCreateTable ct) throws SQLException {

        // check that we can use insertReturnFirstField()

        // check that we can use insertReturnFirstField()

        if (ct.getPrimaryKey().size() != 1)

        if (ct.getPrimaryKey().size() != 1)

            throw new IllegalStateException("Not one and only one field in the PK : " + ct.getPrimaryKey());

            throw new IllegalStateException("Not one and only one field in the PK : " + ct.getPrimaryKey());

        final Insertion<?> insertion = new Inserter(ct).insertReturnFirstField("(" + SQLBase.quoteIdentifier(SQLSyntax.ORDER_NAME) + ") VALUES(" + ReOrder.MIN_ORDER + ")", false);

        final Insertion<?> insertion = new Inserter(ct).insertReturnFirstField("(" + SQLBase.quoteIdentifier(SQLSyntax.ORDER_NAME) + ") VALUES(" + ReOrder.MIN_ORDER + ")", false);

        assert insertion.getCount() == 1;

        assert insertion.getCount() == 1;

        if (insertion.getRows().size() != 1)

        if (insertion.getRows().size() != 1)

            throw new IllegalStateException("Missing ID " + insertion.getRows());

            throw new IllegalStateException("Missing ID " + insertion.getRows());

        SQLTable.setUndefID(ct.getRoot().getSchema(), ct.getName(), ((Number) insertion.getRows().get(0)).intValue());

        SQLTable.setUndefID(ct.getRoot().getSchema(), ct.getName(), ((Number) insertion.getRows().get(0)).intValue());

    }

    }

    private static SQLName getTableName(final SQLCreateTable ct) {

    private static SQLName getTableName(final SQLCreateTable ct) {

        return new SQLName(ct.getRoot().getName(), ct.getName());

        return new SQLName(ct.getRoot().getName(), ct.getName());

    }

    }

    JProgressBar bar = new JProgressBar();

    JProgressBar bar = new JProgressBar();

    boolean error;

    boolean error;

    public InstallationPanel(final ServerFinderPanel finderPanel) {

    public InstallationPanel(final ServerFinderPanel finderPanel) {

        super(new GridBagLayout());

        super(new GridBagLayout());

        setOpaque(false);

        setOpaque(false);

        GridBagConstraints c = new DefaultGridBagConstraints();

        GridBagConstraints c = new DefaultGridBagConstraints();

        JButton user = new JButton("Créer l'utilisateur");

        JButton user = new JButton("Créer l'utilisateur");

        user.setOpaque(false);

        user.setOpaque(false);

        // JButton bd = new JButton("Créer la base de données");

        // JButton bd = new JButton("Créer la base de données");

        final JButton up = new JButton("Mise à niveau de la base");

        final JButton up = new JButton("Mise à niveau de la base");

        up.setOpaque(false);

        up.setOpaque(false);

        up.addActionListener(new ActionListener() {

        up.addActionListener(new ActionListener() {

            @Override

            @Override

            public void actionPerformed(ActionEvent e) {

            public void actionPerformed(ActionEvent e) {

                if (finderPanel != null) {

                if (finderPanel != null) {

                    finderPanel.saveConfigFile();

                    finderPanel.saveConfigFile();

                }

                }

                bar.setIndeterminate(true);

                bar.setIndeterminate(true);

                up.setEnabled(false);

                up.setEnabled(false);

                new Thread(new Runnable() {

                new Thread(new Runnable() {

                    @Override

                    @Override

                    public void run() {

                    public void run() {

                        System.setProperty(SQLSchema.NOAUTO_CREATE_METADATA, "false");

                        System.setProperty(SQLSchema.NOAUTO_CREATE_METADATA, "false");

                        final ComptaPropsConfiguration conf = ComptaPropsConfiguration.create(true);

                        final ComptaPropsConfiguration conf = ComptaPropsConfiguration.create(true);

                        final DBSystemRoot systemRoot = conf.getSystemRoot();

                        final DBSystemRoot systemRoot = conf.getSystemRoot();

                        if (systemRoot.getChild(conf.getRootNameValue().getValue()) == null) {

                        if (systemRoot.getChild(conf.getRootNameValue().getValue()) == null) {

                            conf.destroy();

                            conf.destroy();

                            SwingUtilities.invokeLater(new Runnable() {

                            SwingUtilities.invokeLater(new Runnable() {

                                @Override

                                @Override

                                public void run() {

                                public void run() {

                                    up.setEnabled(true);

                                    up.setEnabled(true);

                                    bar.setValue(bar.getMaximum());

                                    bar.setValue(bar.getMaximum());

                                    JOptionPane.showMessageDialog(InstallationPanel.this, "Votre base de données n'est pas initialisée");

                                    JOptionPane.showMessageDialog(InstallationPanel.this, "Votre base de données n'est pas initialisée");

                                }

                                }

                            });

                            });

                            return;

                            return;

                        }

                        }

                        updateDatabase(conf);

                        updateDatabase(conf);

                        conf.destroy();

                        conf.destroy();

                        SwingUtilities.invokeLater(new Runnable() {

                        SwingUtilities.invokeLater(new Runnable() {

                            @Override

                            @Override

                            public void run() {

                            public void run() {

                                up.setEnabled(true);

                                up.setEnabled(true);

                                bar.setValue(bar.getMaximum());

                                bar.setValue(bar.getMaximum());

                                if (!error) {

                                if (!error) {

                                    JOptionPane.showMessageDialog(InstallationPanel.this, "Mise à niveau réussie");

                                    JOptionPane.showMessageDialog(InstallationPanel.this, "Mise à niveau réussie");

                                }

                                }

                            }

                            }

                        });

                        });

                        System.setProperty(SQLSchema.NOAUTO_CREATE_METADATA, "true");

                        System.setProperty(SQLSchema.NOAUTO_CREATE_METADATA, "true");

                    }

                    }

                }, "Database structure updater").start();

                }, "Database structure updater").start();

            }

            }

        });

        });

        if (finderPanel != null && finderPanel.getToken() == null) {

        if (finderPanel != null && finderPanel.getToken() == null) {

            c.weightx = 1;

            c.weightx = 1;

            c.gridwidth = GridBagConstraints.REMAINDER;

            c.gridwidth = GridBagConstraints.REMAINDER;

            this.add(new JLabelBold("Création de l'utilisateur openconcerto dans la base"), c);

            this.add(new JLabelBold("Création de l'utilisateur openconcerto dans la base"), c);

            c.gridy++;

            c.gridy++;

            c.weightx = 1;

            c.weightx = 1;

            this.add(new JLabel("Identifiant de connexion de votre base "), c);

            this.add(new JLabel("Identifiant de connexion de votre base "), c);

            c.gridy++;

            c.gridy++;

            c.gridwidth = 1;

            c.gridwidth = 1;

            c.weightx = 0;

            c.weightx = 0;

            this.add(new JLabel("Login"), c);

            this.add(new JLabel("Login"), c);

            c.gridx++;

            c.gridx++;

            final JTextField login = new JTextField();

            final JTextField login = new JTextField();

            c.weightx = 1;

            c.weightx = 1;

            this.add(login, c);

            this.add(login, c);

            c.gridx++;

            c.gridx++;

            c.weightx = 0;

            c.weightx = 0;

            this.add(new JLabel("Mot de passe"), c);

            this.add(new JLabel("Mot de passe"), c);

            c.gridx++;

            c.gridx++;

            final JTextField mdp = new JTextField();

            final JTextField mdp = new JTextField();

            c.weightx = 1;

            c.weightx = 1;

            this.add(mdp, c);

            this.add(mdp, c);

            c.gridx = 0;

            c.gridx = 0;

            c.gridy++;

            c.gridy++;

            c.weightx = 0;

            c.weightx = 0;

            c.anchor = GridBagConstraints.EAST;

            c.anchor = GridBagConstraints.EAST;

            c.gridwidth = GridBagConstraints.REMAINDER;

            c.gridwidth = GridBagConstraints.REMAINDER;

            c.fill = GridBagConstraints.NONE;

            c.fill = GridBagConstraints.NONE;

            this.add(user, c);

            this.add(user, c);

            c.anchor = GridBagConstraints.WEST;

            c.anchor = GridBagConstraints.WEST;

            c.fill = GridBagConstraints.HORIZONTAL;

            c.fill = GridBagConstraints.HORIZONTAL;

            c.gridwidth = 1;

            c.gridwidth = 1;

            user.addActionListener(new ActionListener() {

            user.addActionListener(new ActionListener() {

                @Override

                @Override

                public void actionPerformed(ActionEvent e) {

                public void actionPerformed(ActionEvent e) {

                    try {

                    try {

                        if (finderPanel.getServerConfig().createUserIfNeeded(login.getText(), mdp.getText())) {

                        if (finderPanel.getServerConfig().createUserIfNeeded(login.getText(), mdp.getText())) {

                            JOptionPane.showMessageDialog(InstallationPanel.this, "L'utilisateur openconcerto a été correctement ajouté.");

                            JOptionPane.showMessageDialog(InstallationPanel.this, "L'utilisateur openconcerto a été correctement ajouté.");

                        } else {

                        } else {

                            JOptionPane.showMessageDialog(InstallationPanel.this, "L'utilisateur openconcerto existe déjà dans la base.");

                            JOptionPane.showMessageDialog(InstallationPanel.this, "L'utilisateur openconcerto existe déjà dans la base.");

                        }

                        }

                    } catch (Exception e1) {

                    } catch (Exception e1) {

                        e1.printStackTrace();

                        e1.printStackTrace();

                        JOptionPane.showMessageDialog(InstallationPanel.this, "Une erreur est survenue pendant la connexion au serveur, vérifiez vos paramètres de connexion.");

                        JOptionPane.showMessageDialog(InstallationPanel.this, "Une erreur est survenue pendant la connexion au serveur, vérifiez vos paramètres de connexion.");

                    }

                    }

                }

                }

            });

            });

            c.gridy++;

            c.gridy++;

            c.weightx = 1;

            c.weightx = 1;

            c.gridwidth = GridBagConstraints.REMAINDER;

            c.gridwidth = GridBagConstraints.REMAINDER;

            c.insets = new Insets(10, 3, 2, 2);

            c.insets = new Insets(10, 3, 2, 2);

            this.add(new JLabelBold("Paramètrages de la base de données"), c);

            this.add(new JLabelBold("Paramètrages de la base de données"), c);

            c.gridy++;

            c.gridy++;

            c.insets = DefaultGridBagConstraints.getDefaultInsets();

            c.insets = DefaultGridBagConstraints.getDefaultInsets();

            this.add(new JLabel("Création des fonctions SQL nécessaires (plpgsql)."), c);

            this.add(new JLabel("Création des fonctions SQL nécessaires (plpgsql)."), c);

            c.gridy++;

            c.gridy++;

            c.weightx = 0;

            c.weightx = 0;

            c.anchor = GridBagConstraints.EAST;

            c.anchor = GridBagConstraints.EAST;

            c.gridwidth = GridBagConstraints.REMAINDER;

            c.gridwidth = GridBagConstraints.REMAINDER;

            c.fill = GridBagConstraints.NONE;

            c.fill = GridBagConstraints.NONE;

            JButton buttonPL = new JButton("Lancer");

            JButton buttonPL = new JButton("Lancer");

            buttonPL.setOpaque(false);

            buttonPL.setOpaque(false);

            buttonPL.addActionListener(new ActionListener() {

            buttonPL.addActionListener(new ActionListener() {

                @Override

                @Override

                public void actionPerformed(ActionEvent e) {

                public void actionPerformed(ActionEvent e) {

                    if (!finderPanel.getServerConfig().getType().equals(ServerFinderConfig.POSTGRESQL)) {

                    if (!finderPanel.getServerConfig().getType().equals(ServerFinderConfig.POSTGRESQL)) {

                    } else {

                    } else {

                        final ComptaPropsConfiguration conf = ComptaPropsConfiguration.create(true);

                        final ComptaPropsConfiguration conf = ComptaPropsConfiguration.create(true);

                        try {

                        try {

                            final SQLDataSource ds = conf.getSystemRoot().getDataSource();

                            final SQLDataSource ds = conf.getSystemRoot().getDataSource();

                            // ds.execute("CREATE FUNCTION plpgsql_call_handler() RETURNS

                            // ds.execute("CREATE FUNCTION plpgsql_call_handler() RETURNS

                            // language_handler AS '$libdir/plpgsql' LANGUAGE C;"

                            // language_handler AS '$libdir/plpgsql' LANGUAGE C;"

                            // + "\n"

                            // + "\n"

                            // +

                            // +

                            // "CREATE FUNCTION plpgsql_validator(oid) RETURNS void AS

                            // "CREATE FUNCTION plpgsql_validator(oid) RETURNS void AS

                            // '$libdir/plpgsql' LANGUAGE C;"

                            // '$libdir/plpgsql' LANGUAGE C;"

                            // + "\n"

                            // + "\n"

                            // +

                            // +

                            // "CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER

                            // "CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER

                            // plpgsql_call_handler VALIDATOR plpgsql_validator;");

                            // plpgsql_call_handler VALIDATOR plpgsql_validator;");

                            ds.execute("CREATE LANGUAGE plpgsql;");

                            ds.execute("CREATE LANGUAGE plpgsql;");

                        } catch (Exception ex) {

                        } catch (Exception ex) {

                            System.err.println("Impossible d'ajouter le langage PLPGSQL. Peut etre est il déjà installé.");

                            System.err.println("Impossible d'ajouter le langage PLPGSQL. Peut etre est il déjà installé.");

                        }

                        }

                    }

                    }

                    JOptionPane.showMessageDialog(null, "Paramètrage terminé.");

                    JOptionPane.showMessageDialog(null, "Paramètrage terminé.");

                }

                }

            });

            });

            this.add(buttonPL, c);

            this.add(buttonPL, c);

        }

        }

        c.gridy++;

        c.gridy++;

        c.gridx = 0;

        c.gridx = 0;

        c.weightx = 1;

        c.weightx = 1;

        c.fill = GridBagConstraints.HORIZONTAL;

        c.fill = GridBagConstraints.HORIZONTAL;

        c.anchor = GridBagConstraints.WEST;

        c.anchor = GridBagConstraints.WEST;

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.insets = new Insets(10, 3, 2, 2);

        c.insets = new Insets(10, 3, 2, 2);

        this.add(new JLabelBold("Mise à niveau de la base OpenConcerto"), c);

        this.add(new JLabelBold("Mise à niveau de la base OpenConcerto"), c);

        c.gridy++;

        c.gridy++;

        c.insets = DefaultGridBagConstraints.getDefaultInsets();

        c.insets = DefaultGridBagConstraints.getDefaultInsets();

        this.add(new JLabel("Cette opération est nécessaire à chaque mise à jour du logiciel."), c);

        this.add(new JLabel("Cette opération est nécessaire à chaque mise à jour du logiciel."), c);

        c.gridy++;

        c.gridy++;

        this.add(new JLabel("La mise à niveau peut prendre plusieurs minutes."), c);

        this.add(new JLabel("La mise à niveau peut prendre plusieurs minutes."), c);

        c.gridy++;

        c.gridy++;

        this.add(this.bar, c);

        this.add(this.bar, c);

        c.gridy++;

        c.gridy++;

        c.weightx = 0;

        c.weightx = 0;

        c.anchor = GridBagConstraints.EAST;

        c.anchor = GridBagConstraints.EAST;

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.fill = GridBagConstraints.NONE;

        c.fill = GridBagConstraints.NONE;

        this.add(up, c);

        this.add(up, c);

        c.anchor = GridBagConstraints.WEST;

        c.anchor = GridBagConstraints.WEST;

        c.fill = GridBagConstraints.HORIZONTAL;

        c.fill = GridBagConstraints.HORIZONTAL;

        c.weightx = 1;

        c.weightx = 1;

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.gridwidth = GridBagConstraints.REMAINDER;

        c.weighty = 1;

        c.weighty = 1;

        c.gridy++;

        c.gridy++;

        final JPanel comp = new JPanel();

        final JPanel comp = new JPanel();

        comp.setOpaque(false);

        comp.setOpaque(false);

        this.add(comp, c);

        this.add(comp, c);

    }

    }

    private void addArticleFournisseur(DBRoot root) {

    private void addArticleFournisseur(DBRoot root) {

        if (!root.contains("ARTICLE_FOURNISSEUR")) {

        if (!root.contains("ARTICLE_FOURNISSEUR")) {

            SQLCreateTable createBaseFamille = new SQLCreateTable(root, "FAMILLE_ARTICLE_FOURNISSEUR");

            SQLCreateTable createBaseFamille = new SQLCreateTable(root, "FAMILLE_ARTICLE_FOURNISSEUR");

            createBaseFamille.addVarCharColumn("CODE", 45);

            createBaseFamille.addVarCharColumn("CODE", 45);

            createBaseFamille.addVarCharColumn("NOM", 2048);

            createBaseFamille.addVarCharColumn("NOM", 2048);

            createBaseFamille.addForeignColumn("ID_FAMILLE_ARTICLE_FOURNISSEUR_PERE", createBaseFamille);

            createBaseFamille.addForeignColumn("ID_FAMILLE_ARTICLE_FOURNISSEUR_PERE", createBaseFamille);

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            try {

            try {

                ds.execute(createBaseFamille.asString());

                ds.execute(createBaseFamille.asString());

                insertUndef(createBaseFamille);

                insertUndef(createBaseFamille);

                root.refetchTable("FAMILLE_ARTICLE_FOURNISSEUR");

                root.refetchTable("FAMILLE_ARTICLE_FOURNISSEUR");

                root.getSchema().updateVersion();

                root.getSchema().updateVersion();

            } catch (SQLException ex) {

            } catch (SQLException ex) {

                throw new IllegalStateException("Erreur lors de la création de la table FAMILLE_ARTICLE_FOURNISSEUR", ex);

                throw new IllegalStateException("Erreur lors de la création de la table FAMILLE_ARTICLE_FOURNISSEUR", ex);

            }

            }

            SQLCreateTable createBase = new SQLCreateTable(root, "ARTICLE_FOURNISSEUR");

            SQLCreateTable createBase = new SQLCreateTable(root, "ARTICLE_FOURNISSEUR");

            createBase.addVarCharColumn("CODE", 45);

            createBase.addVarCharColumn("CODE", 45);

            createBase.addVarCharColumn("CODE_BARRE", 45);

            createBase.addVarCharColumn("CODE_BARRE", 45);

            createBase.addVarCharColumn("CODE_DOUANIER", 45);

            createBase.addVarCharColumn("CODE_DOUANIER", 45);

            createBase.addVarCharColumn("NOM", 2048);

            createBase.addVarCharColumn("NOM", 2048);

            createBase.addVarCharColumn("DESCRIPTIF", 2048);

            createBase.addVarCharColumn("DESCRIPTIF", 2048);

            createBase.addVarCharColumn("INFOS", 2048);

            createBase.addVarCharColumn("INFOS", 2048);

            createBase.addColumn("PRIX_METRIQUE_HA_1", "numeric (16,6) DEFAULT 0");

            createBase.addColumn("PRIX_METRIQUE_HA_1", "numeric (16,6) DEFAULT 0");

            createBase.addColumn("PRIX_METRIQUE_HA_2", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PRIX_METRIQUE_HA_2", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PRIX_METRIQUE_HA_3", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PRIX_METRIQUE_HA_3", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PRIX_METRIQUE_VT_1", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PRIX_METRIQUE_VT_1", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PRIX_METRIQUE_VT_2", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PRIX_METRIQUE_VT_2", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PRIX_METRIQUE_VT_3", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PRIX_METRIQUE_VT_3", "numeric (16,8) DEFAULT 0");

            createBase.addForeignColumn("ID_METRIQUE_1", root.findTable("METRIQUE", true));

            createBase.addForeignColumn("ID_METRIQUE_1", root.findTable("METRIQUE", true));

            createBase.addForeignColumn("ID_METRIQUE_2", root.findTable("METRIQUE", true));

            createBase.addForeignColumn("ID_METRIQUE_2", root.findTable("METRIQUE", true));

            createBase.addForeignColumn("ID_METRIQUE_3", root.findTable("METRIQUE", true));

            createBase.addForeignColumn("ID_METRIQUE_3", root.findTable("METRIQUE", true));

            createBase.addColumn("PA_DEVISE", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PA_DEVISE", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PV_U_DEVISE", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PV_U_DEVISE", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PA_HT", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PA_HT", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PV_HT", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PV_HT", "numeric (16,8) DEFAULT 0");

            createBase.addColumn("PV_TTC", "numeric (16,2) DEFAULT 0");

            createBase.addColumn("PV_TTC", "numeric (16,2) DEFAULT 0");

            createBase.addForeignColumn("ID_TAXE", root.findTable("TAXE", true));

            createBase.addForeignColumn("ID_TAXE", root.findTable("TAXE", true));

            createBase.addForeignColumn("ID_FAMILLE_ARTICLE_FOURNISSEUR", root.findTable("FAMILLE_ARTICLE_FOURNISSEUR", true));

            createBase.addForeignColumn("ID_FAMILLE_ARTICLE_FOURNISSEUR", root.findTable("FAMILLE_ARTICLE_FOURNISSEUR", true));

            createBase.addForeignColumn("ID_MODE_VENTE_ARTICLE", root.findTable("MODE_VENTE_ARTICLE", true));

            createBase.addForeignColumn("ID_MODE_VENTE_ARTICLE", root.findTable("MODE_VENTE_ARTICLE", true));

            createBase.addForeignColumn("ID_FOURNISSEUR", root.findTable("FOURNISSEUR", true));

            createBase.addForeignColumn("ID_FOURNISSEUR", root.findTable("FOURNISSEUR", true));

            createBase.addForeignColumn("ID_PAYS", root.findTable("PAYS", true));

            createBase.addForeignColumn("ID_PAYS", root.findTable("PAYS", true));

            createBase.addForeignColumn("ID_DEVISE", root.findTable("DEVISE", true));

            createBase.addForeignColumn("ID_DEVISE", root.findTable("DEVISE", true));

            createBase.addForeignColumn("ID_DEVISE_HA", root.findTable("DEVISE", true));

            createBase.addForeignColumn("ID_DEVISE_HA", root.findTable("DEVISE", true));

            createBase.addForeignColumn("ID_UNITE_VENTE", root.findTable("UNITE_VENTE", true));

            createBase.addForeignColumn("ID_UNITE_VENTE", root.findTable("UNITE_VENTE", true));

            createBase.addForeignColumn("ID_COMPTE_PCE", root.findTable("COMPTE_PCE", true));

            createBase.addForeignColumn("ID_COMPTE_PCE", root.findTable("COMPTE_PCE", true));

            createBase.addForeignColumn("ID_COMPTE_PCE_ACHAT", root.findTable("COMPTE_PCE", true));

            createBase.addForeignColumn("ID_COMPTE_PCE_ACHAT", root.findTable("COMPTE_PCE", true));

            createBase.addForeignColumn("ID_ARTICLE", root.findTable("ARTICLE", true));

            createBase.addForeignColumn("ID_ARTICLE", root.findTable("ARTICLE", true));

            createBase.addColumn("POIDS", "real DEFAULT 0");

            createBase.addColumn("POIDS", "real DEFAULT 0");

            createBase.addColumn("VALEUR_METRIQUE_1", "real DEFAULT 0");

            createBase.addColumn("VALEUR_METRIQUE_1", "real DEFAULT 0");

            createBase.addColumn("VALEUR_METRIQUE_2", "real DEFAULT 0");

            createBase.addColumn("VALEUR_METRIQUE_2", "real DEFAULT 0");

            createBase.addColumn("VALEUR_METRIQUE_3", "real DEFAULT 0");

            createBase.addColumn("VALEUR_METRIQUE_3", "real DEFAULT 0");

            createBase.addBooleanColumn("SERVICE", Boolean.FALSE, false);

            createBase.addBooleanColumn("SERVICE", Boolean.FALSE, false);

            createBase.addBooleanColumn("OBSOLETE", Boolean.FALSE, false);

            createBase.addBooleanColumn("OBSOLETE", Boolean.FALSE, false);

            createBase.addBooleanColumn("GESTION_STOCK", Boolean.FALSE, false);

            createBase.addBooleanColumn("GESTION_STOCK", Boolean.FALSE, false);

            createBase.addIntegerColumn("QTE_ACHAT", 1);

            createBase.addIntegerColumn("QTE_ACHAT", 1);

            createBase.addIntegerColumn("QTE_MIN", 1);

            createBase.addIntegerColumn("QTE_MIN", 1);

            try {

            try {

                ds.execute(createBase.asString());

                ds.execute(createBase.asString());

                insertUndef(createBase);

                insertUndef(createBase);

                root.refetchTable("ARTICLE_FOURNISSEUR");

                root.refetchTable("ARTICLE_FOURNISSEUR");

                root.getSchema().updateVersion();

                root.getSchema().updateVersion();

            } catch (SQLException ex) {

            } catch (SQLException ex) {

                throw new IllegalStateException("Erreur lors de la création de la table ARTICLE_FOURNISSEUR", ex);

                throw new IllegalStateException("Erreur lors de la création de la table ARTICLE_FOURNISSEUR", ex);

            }

            }

        }

        }

    }

    }

    private void addContact(DBRoot root) throws SQLException {

    private void addContact(DBRoot root) throws SQLException {

        List<String> tables = Arrays.asList("AVOIR_CLIENT", "DEVIS", "BON_DE_LIVRAISON", "COMMANDE_CLIENT", "SAISIE_VENTE_FACTURE");

        List<String> tables = Arrays.asList("AVOIR_CLIENT", "DEVIS", "BON_DE_LIVRAISON", "COMMANDE_CLIENT", "SAISIE_VENTE_FACTURE");

        final SQLTable tableContact = root.findTable("CONTACT");

        final SQLTable tableContact = root.findTable("CONTACT");

        final SQLTable tableDpt = root.findTable("CLIENT_DEPARTEMENT");

        final SQLTable tableDpt = root.findTable("CLIENT_DEPARTEMENT");

        final SQLDataSource dataSource = root.getDBSystemRoot().getDataSource();

        final SQLDataSource dataSource = root.getDBSystemRoot().getDataSource();

        for (String tableName : tables) {

        for (String tableName : tables) {

            boolean update = false;

            boolean update = false;

            final SQLTable table = root.getTable(tableName);

            final SQLTable table = root.getTable(tableName);

            final AlterTable alterEcheance = new AlterTable(table);

            final AlterTable alterEcheance = new AlterTable(table);

            if (!table.contains("ID_CONTACT")) {

            if (!table.contains("ID_CONTACT")) {

                alterEcheance.addForeignColumn("ID_CONTACT", tableContact);

                alterEcheance.addForeignColumn("ID_CONTACT", tableContact);

                update = true;

                update = true;

            }

            }

            if (!table.contains("ID_CLIENT_DEPARTEMENT")) {

            if (!table.contains("ID_CLIENT_DEPARTEMENT")) {

                alterEcheance.addForeignColumn("ID_CLIENT_DEPARTEMENT", tableDpt);

                alterEcheance.addForeignColumn("ID_CLIENT_DEPARTEMENT", tableDpt);

                update = true;

                update = true;

            }

            }

            if (update) {

            if (update) {

                dataSource.execute(alterEcheance.asString());

                dataSource.execute(alterEcheance.asString());

                table.getSchema().updateVersion();

                table.getSchema().updateVersion();

            }

            }

        }

        }

    }

    }

    private void addForeignKeyFactureOnEcheance(DBRoot root) {

    private void addForeignKeyFactureOnEcheance(DBRoot root) {

        final SQLTable tableEch = root.getTable("ECHEANCE_CLIENT");

        final SQLTable tableEch = root.getTable("ECHEANCE_CLIENT");

        if (!tableEch.contains("ID_SAISIE_VENTE_FACTURE")) {

        if (!tableEch.contains("ID_SAISIE_VENTE_FACTURE")) {

            final SQLTable tableFacture = root.getTable("SAISIE_VENTE_FACTURE");

            final SQLTable tableFacture = root.getTable("SAISIE_VENTE_FACTURE");

            final SQLTable tableMvt = root.getTable("MOUVEMENT");

            final SQLTable tableMvt = root.getTable("MOUVEMENT");

            String query = "no query";

            String query = "no query";

            try {

            try {

                final SQLDataSource dataSource = root.getDBSystemRoot().getDataSource();

                final SQLDataSource dataSource = root.getDBSystemRoot().getDataSource();

                final AlterTable alterEcheance = new AlterTable(tableEch);

                final AlterTable alterEcheance = new AlterTable(tableEch);

                alterEcheance.addForeignColumn("ID_SAISIE_VENTE_FACTURE", tableFacture);

                alterEcheance.addForeignColumn("ID_SAISIE_VENTE_FACTURE", tableFacture);

                dataSource.execute(alterEcheance.asString());

                dataSource.execute(alterEcheance.asString());

                tableEch.getSchema().updateVersion();

                tableEch.getSchema().updateVersion();

                tableEch.fetchFields();

                tableEch.fetchFields();

                // select MOUVEMENT whose parent has a source FACTURE

                // select MOUVEMENT whose parent has a source FACTURE

                final SQLSelect selMvt = new SQLSelect();

                final SQLSelect selMvt = new SQLSelect();

                final AliasedTable refChild = new AliasedTable(tableMvt, "m1");

                final AliasedTable refChild = new AliasedTable(tableMvt, "m1");

                final AliasedTable refParent = new AliasedTable(tableMvt, "m2");

                final AliasedTable refParent = new AliasedTable(tableMvt, "m2");

                selMvt.addSelect(refParent.getField("IDSOURCE"));

                selMvt.addSelect(refParent.getField("IDSOURCE"));

                selMvt.addBackwardJoin("INNER", refChild.getField("ID_MOUVEMENT_PERE"), refParent.getAlias());

                selMvt.addBackwardJoin("INNER", refChild.getField("ID_MOUVEMENT_PERE"), refParent.getAlias());

                selMvt.addSelect(refChild.getKey());

                selMvt.addSelect(refChild.getKey());

                selMvt.setWhere(new Where(refParent.getField("SOURCE"), "=", tableFacture.getName()));

                selMvt.setWhere(new Where(refParent.getField("SOURCE"), "=", tableFacture.getName()));

                final UpdateBuilder build = new UpdateBuilder(tableEch);

                final UpdateBuilder build = new UpdateBuilder(tableEch);

                build.addVirtualJoin("( " + selMvt.asString() + " )", "mvt", false, tableMvt.getKey().getName(), "ID_MOUVEMENT");

                build.addVirtualJoin("( " + selMvt.asString() + " )", "mvt", false, tableMvt.getKey().getName(), "ID_MOUVEMENT");

                build.setFromVirtualJoinField("ID_SAISIE_VENTE_FACTURE", "mvt", "IDSOURCE");

                build.setFromVirtualJoinField("ID_SAISIE_VENTE_FACTURE", "mvt", "IDSOURCE");

                query = build.asString();

                query = build.asString();

                dataSource.execute(query);

                dataSource.execute(query);

            } catch (SQLException ex) {

            } catch (SQLException ex) {

                Log.get().severe("Error on query :" + query);

                Log.get().severe("Error on query :" + query);

                throw new IllegalStateException("Erreur lors de l'ajout des champs sur la table ECHEANCE_CLIENT", ex);

                throw new IllegalStateException("Erreur lors de l'ajout des champs sur la table ECHEANCE_CLIENT", ex);

            }

            }

        }

        }

    }

    }

    private void addFieldForPartialInvoice(DBRoot root) throws SQLException {

    private void addFieldForPartialInvoice(DBRoot root) throws SQLException {

        final SQLTable tableVF = root.getTable("SAISIE_VENTE_FACTURE");

        final SQLTable tableVF = root.getTable("SAISIE_VENTE_FACTURE");

        AlterTable alter = new AlterTable(tableVF);

        AlterTable alter = new AlterTable(tableVF);

        boolean doAlter = false;

        boolean doAlter = false;

        if (!tableVF.contains("POURCENT_FACTURABLE")) {

        if (!tableVF.contains("POURCENT_FACTURABLE")) {

            alter.addColumn("POURCENT_FACTURABLE", "numeric (16,8)");

            alter.addColumn("POURCENT_FACTURABLE", "numeric (16,8)");

            doAlter = true;

            doAlter = true;

        }

        }

        if (!tableVF.contains("MONTANT_FACTURABLE")) {

        if (!tableVF.contains("MONTANT_FACTURABLE")) {

            alter.addColumn("MONTANT_FACTURABLE", "numeric (16,8)");

            alter.addColumn("MONTANT_FACTURABLE", "numeric (16,8)");

            doAlter = true;

            doAlter = true;

        }

        }

        if (!tableVF.contains("SOLDE")) {

        if (!tableVF.contains("SOLDE")) {

            alter.addColumn("SOLDE", "boolean DEFAULT false");

            alter.addColumn("SOLDE", "boolean DEFAULT false");

            doAlter = true;

            doAlter = true;

        }

        }

        if (!tableVF.contains("PARTIAL")) {

        if (!tableVF.contains("PARTIAL")) {

            alter.addColumn("PARTIAL", "boolean DEFAULT false");

            alter.addColumn("PARTIAL", "boolean DEFAULT false");

            doAlter = true;

            doAlter = true;

        }

        }

        if (doAlter) {

        if (doAlter) {

            root.getDBSystemRoot().getDataSource().execute(alter.asString());

            root.getDBSystemRoot().getDataSource().execute(alter.asString());

            root.refetchTable(tableVF.getName());

            root.refetchTable(tableVF.getName());

        }

        }

        // ELT

        // ELT

        final SQLTable tableVFElt = root.getTable("SAISIE_VENTE_FACTURE_ELEMENT");

        final SQLTable tableVFElt = root.getTable("SAISIE_VENTE_FACTURE_ELEMENT");

        AlterTable alterElt = new AlterTable(tableVFElt);

        AlterTable alterElt = new AlterTable(tableVFElt);

        boolean doAlterElt = false;

        boolean doAlterElt = false;

        if (!tableVFElt.contains("MONTANT_FACTURABLE")) {

        if (!tableVFElt.contains("MONTANT_FACTURABLE")) {

            alterElt.addColumn("MONTANT_FACTURABLE", "numeric (16,8)");

            alterElt.addColumn("MONTANT_FACTURABLE", "numeric (16,8)");

            doAlterElt = true;

            doAlterElt = true;

        }

        }

        if (!tableVFElt.contains("POURCENT_FACTURABLE")) {

        if (!tableVFElt.contains("POURCENT_FACTURABLE")) {

            alterElt.addColumn("POURCENT_FACTURABLE", "numeric (16,8)");

            alterElt.addColumn("POURCENT_FACTURABLE", "numeric (16,8)");

            doAlterElt = true;

            doAlterElt = true;

        }

        }

        if (doAlterElt) {

        if (doAlterElt) {

            root.getDBSystemRoot().getDataSource().execute(alterElt.asString());

            root.getDBSystemRoot().getDataSource().execute(alterElt.asString());

            root.refetchTable(tableVFElt.getName());

            root.refetchTable(tableVFElt.getName());

        }

        }

    }

    }

    private void createAssocAnalytique(DBRoot root, ComptaPropsConfiguration conf) {

    private void createAssocAnalytique(DBRoot root, ComptaPropsConfiguration conf) {

        if (!root.contains("ASSOCIATION_ANALYTIQUE")) {

        if (!root.contains("ASSOCIATION_ANALYTIQUE")) {

            SQLCreateTable createAssoc = new SQLCreateTable(root, "ASSOCIATION_ANALYTIQUE");

            SQLCreateTable createAssoc = new SQLCreateTable(root, "ASSOCIATION_ANALYTIQUE");

            createAssoc.addForeignColumn("ID_ECRITURE", root.findTable("ECRITURE", true));

            createAssoc.addForeignColumn("ID_ECRITURE", root.findTable("ECRITURE", true));

            createAssoc.addForeignColumn("ID_SAISIE_KM_ELEMENT", root.findTable("SAISIE_KM_ELEMENT", true));

            createAssoc.addForeignColumn("ID_SAISIE_KM_ELEMENT", root.findTable("SAISIE_KM_ELEMENT", true));

            createAssoc.addForeignColumn("ID_POSTE_ANALYTIQUE", root.findTable("POSTE_ANALYTIQUE", true));

            createAssoc.addForeignColumn("ID_POSTE_ANALYTIQUE", root.findTable("POSTE_ANALYTIQUE", true));

            createAssoc.addColumn("POURCENT", "numeric (16,8) DEFAULT 100");

            createAssoc.addColumn("POURCENT", "numeric (16,8) DEFAULT 100");

            createAssoc.addColumn("MONTANT", "bigInt DEFAULT 0");

            createAssoc.addColumn("MONTANT", "bigInt DEFAULT 0");

            createAssoc.addBooleanColumn("GESTION_AUTO", false, false);

            createAssoc.addBooleanColumn("GESTION_AUTO", false, false);

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            try {

            try {

                ds.execute(createAssoc.asString());

                ds.execute(createAssoc.asString());

                insertUndef(createAssoc);

                insertUndef(createAssoc);

                root.refetchTable("ASSOCIATION_ANALYTIQUE");

                root.refetchTable("ASSOCIATION_ANALYTIQUE");

                root.getSchema().updateVersion();

                root.getSchema().updateVersion();

            } catch (SQLException ex) {

            } catch (SQLException ex) {

                throw new IllegalStateException("Erreur lors de la création de la table ASSOCIATION_ANALYTIQUE", ex);

                throw new IllegalStateException("Erreur lors de la création de la table ASSOCIATION_ANALYTIQUE", ex);

            }

            }

        }

        }

        SQLTable tablePoste = root.getTable("POSTE_ANALYTIQUE");

        SQLTable tablePoste = root.getTable("POSTE_ANALYTIQUE");

        if (!tablePoste.contains("DEFAULT")) {

        if (!tablePoste.contains("DEFAULT")) {

            AlterTable a = new AlterTable(tablePoste);

            AlterTable a = new AlterTable(tablePoste);

            a.addBooleanColumn("DEFAULT", Boolean.FALSE, false);

            a.addBooleanColumn("DEFAULT", Boolean.FALSE, false);

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            try {

            try {

                ds.execute(a.asString());

                ds.execute(a.asString());

                root.refetchTable("POSTE_ANALYTIQUE");

                root.refetchTable("POSTE_ANALYTIQUE");

                root.getSchema().updateVersion();

                root.getSchema().updateVersion();

            } catch (SQLException ex) {

            } catch (SQLException ex) {

                throw new IllegalStateException("Erreur lors de la création du DEFAULT sur la table POSTE_ANALYTIQUE", ex);

                throw new IllegalStateException("Erreur lors de la création du DEFAULT sur la table POSTE_ANALYTIQUE", ex);

            }

            }

        }

        }

    }

    }

    private void updateStock(DBRoot root) throws SQLException {

    private void updateStock(DBRoot root) throws SQLException {

        final SQLTable tableStock = root.getTable("STOCK");

        final SQLTable tableStock = root.getTable("STOCK");

        final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

        final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

        if (!tableStock.contains("QTE_RECEPT_ATTENTE")) {

        if (!tableStock.contains("QTE_RECEPT_ATTENTE")) {

            try {

            try {

                AlterTable alterElt = new AlterTable(root.getTable("STOCK"));

                AlterTable alterElt = new AlterTable(root.getTable("STOCK"));

                alterElt.addColumn("QTE_RECEPT_ATTENTE", "real DEFAULT 0");

                alterElt.addColumn("QTE_RECEPT_ATTENTE", "real DEFAULT 0");

                alterElt.addColumn("QTE_LIV_ATTENTE", "real DEFAULT 0");

                alterElt.addColumn("QTE_LIV_ATTENTE", "real DEFAULT 0");

                ds.execute(alterElt.asString());

                ds.execute(alterElt.asString());

                AlterTable alterMvt = new AlterTable(root.getTable("MOUVEMENT_STOCK"));

                AlterTable alterMvt = new AlterTable(root.getTable("MOUVEMENT_STOCK"));

                alterMvt.addBooleanColumn("REEL", Boolean.TRUE, false);

                alterMvt.addBooleanColumn("REEL", Boolean.TRUE, false);

                ds.execute(alterMvt.asString());

                ds.execute(alterMvt.asString());

                root.getSchema().updateVersion();

                root.getSchema().updateVersion();

            } catch (SQLException ex) {

            } catch (SQLException ex) {

                throw new IllegalStateException("Erreur lors de la mise à jour des tables de stock", ex);

                throw new IllegalStateException("Erreur lors de la mise à jour des tables de stock", ex);

            }

            }

        }

        }

        // if (!root.contains("ARTICLE_ELEMENT")) {

        // if (!root.contains("ARTICLE_ELEMENT")) {

        // final SQLCreateTable createTable = new SQLCreateTable(root, "ARTICLE_ELEMENT");

        // final SQLCreateTable createTable = new SQLCreateTable(root, "ARTICLE_ELEMENT");

        // createTable.addForeignColumn("ARTICLE");

        // createTable.addForeignColumn("ARTICLE");

        // createTable.addForeignColumn("ID_ARTICLE_PARENT", root.getTable("ARTICLE"));

        // createTable.addForeignColumn("ID_ARTICLE_PARENT", root.getTable("ARTICLE"));

        // createTable.addIntegerColumn("QTE", 1);

        // createTable.addIntegerColumn("QTE", 1);

        // createTable.addDecimalColumn("QTE_UNITAIRE", 16, 6, BigDecimal.valueOf(1), false);

        // createTable.addDecimalColumn("QTE_UNITAIRE", 16, 6, BigDecimal.valueOf(1), false);

        // createTable.addForeignColumn("UNITE_VENTE");

        // createTable.addForeignColumn("UNITE_VENTE");

        // insertUndef(createTable);

        // insertUndef(createTable);

        // ds.execute(createTable.asString());

        // ds.execute(createTable.asString());

        //

        //

        // root.getSchema().updateVersion();

        // root.getSchema().updateVersion();

        // root.refetchTable("ARTICLE_ELEMENT");

        // root.refetchTable("ARTICLE_ELEMENT");

        //

        //

        // }

        // }

        //

        //

        // if (!root.getTable("ARTICLE").contains("COMPOSED")) {

        // if (!root.getTable("ARTICLE").contains("COMPOSED")) {

        // AlterTable alterMvt = new AlterTable(root.getTable("ARTICLE"));

        // AlterTable alterMvt = new AlterTable(root.getTable("ARTICLE"));

        // alterMvt.addBooleanColumn("COMPOSED", Boolean.FALSE, false);

        // alterMvt.addBooleanColumn("COMPOSED", Boolean.FALSE, false);

        //

        //

        // ds.execute(alterMvt.asString());

        // ds.execute(alterMvt.asString());

        //

        //

        // root.getSchema().updateVersion();

        // root.getSchema().updateVersion();

        // }

        // }

    }

    }

    private void createBanque(DBRoot root) throws SQLException {

    private void createBanque(DBRoot root) throws SQLException {

        // Création de la table

        // Création de la table

        if (!root.contains("BANQUE") && !root.contains("BANQUE_POLE_PRODUIT")) {

        if (!root.contains("BANQUE") && !root.contains("BANQUE_POLE_PRODUIT")) {

            SQLCreateTable createBanque = new SQLCreateTable(root, "BANQUE");

            SQLCreateTable createBanque = new SQLCreateTable(root, "BANQUE");

            createBanque.addForeignColumn("ID_JOURNAL", root.findTable("JOURNAL", true));

            createBanque.addForeignColumn("ID_JOURNAL", root.findTable("JOURNAL", true));

            createBanque.addVarCharColumn("INFOS", 2048);

            createBanque.addVarCharColumn("INFOS", 2048);

            createBanque.addVarCharColumn("NUMERO_RUE", 45);

            createBanque.addVarCharColumn("NUMERO_RUE", 45);

            createBanque.addVarCharColumn("RUE", 256);

            createBanque.addVarCharColumn("RUE", 256);

            createBanque.addVarCharColumn("IBAN", 256);

            createBanque.addVarCharColumn("IBAN", 256);

            createBanque.addVarCharColumn("BIC", 256);

            createBanque.addVarCharColumn("BIC", 256);

            createBanque.addVarCharColumn("VOIE", 256);

            createBanque.addVarCharColumn("VOIE", 256);

            createBanque.addVarCharColumn("VILLE", 256);

            createBanque.addVarCharColumn("VILLE", 256);

            createBanque.addVarCharColumn("NOM", 256);

            createBanque.addVarCharColumn("NOM", 256);

            createBanque.addVarCharColumn("DOMICILIATION", 256);

            createBanque.addVarCharColumn("DOMICILIATION", 256);

            createBanque.addVarCharColumn("CODE", 256);

            createBanque.addVarCharColumn("CODE", 256);

            createBanque.addBooleanColumn("AFFACTURAGE", Boolean.FALSE, false);

            createBanque.addBooleanColumn("AFFACTURAGE", Boolean.FALSE, false);

            createBanque.addForeignColumn("ID_COMPTE_PCE", root.findTable("COMPTE_PCE", true));

            createBanque.addForeignColumn("ID_COMPTE_PCE", root.findTable("COMPTE_PCE", true));

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            try {

            try {

                ds.execute(createBanque.asString());

                ds.execute(createBanque.asString());

                insertUndef(createBanque);

                insertUndef(createBanque);

                root.refetchTable("BANQUE");

                root.refetchTable("BANQUE");

                root.getSchema().updateVersion();

                root.getSchema().updateVersion();

            } catch (SQLException ex) {

            } catch (SQLException ex) {

                throw new IllegalStateException("Erreur lors de la création de la table BANQUE", ex);

                throw new IllegalStateException("Erreur lors de la création de la table BANQUE", ex);

            }

            }

        }

        }

        // Création des foreignkeys

        // Création des foreignkeys

        {

        {

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            List<String> tablesWithBanque = Arrays.asList("MODE_REGLEMENT", "CHEQUE_A_ENCAISSER", "CHEQUE_FOURNISSEUR");

            List<String> tablesWithBanque = Arrays.asList("MODE_REGLEMENT", "CHEQUE_A_ENCAISSER", "CHEQUE_FOURNISSEUR");

            for (String string : tablesWithBanque) {

            for (String string : tablesWithBanque) {

                final SQLTable table = root.getTable(string);

                final SQLTable table = root.getTable(string);

                if (!table.contains("ID_BANQUE") && !table.contains("ID_BANQUE_POLE_PRODUIT")) {

                if (!table.contains("ID_BANQUE") && !table.contains("ID_BANQUE_POLE_PRODUIT")) {

                    String tableName = (table.contains("ID_BANQUE_PRODUIT")) ? "BANQUE_POLE_PRODUIT" : "BANQUE";

                    String tableName = (table.contains("ID_BANQUE_PRODUIT")) ? "BANQUE_POLE_PRODUIT" : "BANQUE";

                    AlterTable alterElt = new AlterTable(table);

                    AlterTable alterElt = new AlterTable(table);

                    alterElt.addForeignColumn("ID_" + tableName, root.getTable(tableName));

                    alterElt.addForeignColumn("ID_" + tableName, root.getTable(tableName));

                    ds.execute(alterElt.asString());

                    ds.execute(alterElt.asString());

                    root.refetchTable(string);

                    root.refetchTable(string);

                    root.getSchema().updateVersion();

                    root.getSchema().updateVersion();

                }

                }

            }

            }

        }

        }

    }

    }

    private void createFactureFournisseur(DBRoot root) throws SQLException {

    private void createFactureFournisseur(DBRoot root) throws SQLException {

        boolean refetchRoot = false;

        boolean refetchRoot = false;

        if (!root.contains("FACTURE_FOURNISSEUR")) {

        if (!root.contains("FACTURE_FOURNISSEUR")) {

            SQLCreateTable createFactureF = new SQLCreateTable(root, "FACTURE_FOURNISSEUR");

            SQLCreateTable createFactureF = new SQLCreateTable(root, "FACTURE_FOURNISSEUR");

            createFactureF.addVarCharColumn("NOM", 256);

            createFactureF.addVarCharColumn("NOM", 256);

            createFactureF.addVarCharColumn("NUMERO", 45);

            createFactureF.addVarCharColumn("NUMERO", 45);

            createFactureF.addVarCharColumn("INFOS", 2048);

            createFactureF.addVarCharColumn("INFOS", 2048);

            createFactureF.addColumn("DATE", "date");

            createFactureF.addColumn("DATE", "date");

            createFactureF.addForeignColumn("FOURNISSEUR");

            createFactureF.addForeignColumn("FOURNISSEUR");

            createFactureF.addForeignColumn("AVOIR_FOURNISSEUR");

            createFactureF.addForeignColumn("AVOIR_FOURNISSEUR");

            createFactureF.addForeignColumn("COMPTE_PCE");

            createFactureF.addForeignColumn("COMPTE_PCE");

            createFactureF.addForeignColumn("COMMERCIAL");

            createFactureF.addForeignColumn("COMMERCIAL");

            createFactureF.addForeignColumn("MODE_REGLEMENT");

            createFactureF.addForeignColumn("MODE_REGLEMENT");

            createFactureF.addForeignColumn("MOUVEMENT");

            createFactureF.addForeignColumn("MOUVEMENT");

            createFactureF.addForeignColumn("ID_DEVISE", root.findTable("DEVISE", true));

            createFactureF.addForeignColumn("ID_DEVISE", root.findTable("DEVISE", true));

            createFactureF.addColumn("T_HT", "bigint DEFAULT 0");

            createFactureF.addColumn("T_HT", "bigint DEFAULT 0");

            createFactureF.addColumn("T_TVA", "bigint DEFAULT 0");

            createFactureF.addColumn("T_TVA", "bigint DEFAULT 0");

            createFactureF.addColumn("T_TTC", "bigint DEFAULT 0");

            createFactureF.addColumn("T_TTC", "bigint DEFAULT 0");

            createFactureF.addColumn("T_SERVICE", "bigint DEFAULT 0");

            createFactureF.addColumn("T_SERVICE", "bigint DEFAULT 0");

            createFactureF.addColumn("T_DEVISE", "bigint DEFAULT 0");

            createFactureF.addColumn("T_DEVISE", "bigint DEFAULT 0");

            createFactureF.addColumn("T_POIDS", "real DEFAULT 0");

            createFactureF.addColumn("T_POIDS", "real DEFAULT 0");

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            try {

            try {

                ds.execute(createFactureF.asString());

                ds.execute(createFactureF.asString());

                insertUndef(createFactureF);

                insertUndef(createFactureF);

                root.getSchema().updateVersion();

                root.getSchema().updateVersion();

                root.refetchTable("FACTURE_FOURNISSEUR");

                root.refetchTable("FACTURE_FOURNISSEUR");

                refetchRoot = true;

                refetchRoot = true;

            } catch (SQLException ex) {

            } catch (SQLException ex) {

                throw new IllegalStateException("Erreur lors de la création de la table FACTURE_FOURNISSEUR", ex);

                throw new IllegalStateException("Erreur lors de la création de la table FACTURE_FOURNISSEUR", ex);

            }

            }

        }

        }

        if (!root.contains("FACTURE_FOURNISSEUR_ELEMENT")) {

        if (!root.contains("FACTURE_FOURNISSEUR_ELEMENT")) {

            SQLCreateTable createFactureF = new SQLCreateTable(root, "FACTURE_FOURNISSEUR_ELEMENT");

            SQLCreateTable createFactureF = new SQLCreateTable(root, "FACTURE_FOURNISSEUR_ELEMENT");

            createFactureF.addDecimalColumn("PRIX_METRIQUE_HA_1", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PRIX_METRIQUE_HA_1", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PRIX_METRIQUE_HA_2", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PRIX_METRIQUE_HA_2", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PRIX_METRIQUE_HA_3", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PRIX_METRIQUE_HA_3", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PRIX_METRIQUE_VT_1", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PRIX_METRIQUE_VT_1", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PRIX_METRIQUE_VT_2", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PRIX_METRIQUE_VT_2", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PRIX_METRIQUE_VT_3", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PRIX_METRIQUE_VT_3", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("T_PV_HT", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("T_PV_HT", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("T_PA_HT", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("T_PA_HT", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PV_HT", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PV_HT", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PA_HT", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PA_HT", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("T_PV_TTC", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("T_PV_TTC", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("T_PA_TTC", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("T_PA_TTC", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("QTE_UNITAIRE", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("QTE_UNITAIRE", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PA_DEVISE_T", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PA_DEVISE_T", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PA_DEVISE", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addDecimalColumn("PA_DEVISE", 16, 6, BigDecimal.ZERO, false);

            createFactureF.addIntegerColumn("QTE", 1);

            createFactureF.addIntegerColumn("QTE", 1);

            createFactureF.addIntegerColumn("QTE_ACHAT", 1);

            createFactureF.addIntegerColumn("QTE_ACHAT", 1);

            createFactureF.addColumn("VALEUR_METRIQUE_1", "real DEFAULT 0");

            createFactureF.addColumn("VALEUR_METRIQUE_1", "real DEFAULT 0");

            createFactureF.addColumn("VALEUR_METRIQUE_2", "real DEFAULT 0");

            createFactureF.addColumn("VALEUR_METRIQUE_2", "real DEFAULT 0");

            createFactureF.addColumn("VALEUR_METRIQUE_3", "real DEFAULT 0");

            createFactureF.addColumn("VALEUR_METRIQUE_3", "real DEFAULT 0");

            createFactureF.addColumn("T_POIDS", "real DEFAULT 0");

            createFactureF.addColumn("T_POIDS", "real DEFAULT 0");

            createFactureF.addColumn("POIDS", "real DEFAULT 0");

            createFactureF.addColumn("POIDS", "real DEFAULT 0");

            createFactureF.addBooleanColumn("SERVICE", Boolean.FALSE, true);

            createFactureF.addBooleanColumn("SERVICE", Boolean.FALSE, true);

            createFactureF.addVarCharColumn("CODE", 45);

            createFactureF.addVarCharColumn("CODE", 45);

            createFactureF.addVarCharColumn("NOM", 256);

            createFactureF.addVarCharColumn("NOM", 256);

            createFactureF.addColumn("DATE", "date");

            createFactureF.addColumn("DATE", "date");

            createFactureF.addForeignColumn("STYLE");

            createFactureF.addForeignColumn("STYLE");

            createFactureF.addForeignColumn("METRIQUE", "3");

            createFactureF.addForeignColumn("METRIQUE", "3");

            createFactureF.addForeignColumn("METRIQUE", "2");

            createFactureF.addForeignColumn("METRIQUE", "2");

            createFactureF.addForeignColumn("METRIQUE", "1");

            createFactureF.addForeignColumn("METRIQUE", "1");

            createFactureF.addForeignColumn("FACTURE_FOURNISSEUR");

            createFactureF.addForeignColumn("FACTURE_FOURNISSEUR");

            createFactureF.addForeignColumn("TAXE");

            createFactureF.addForeignColumn("TAXE");

            createFactureF.addForeignColumn("ID_MODE_VENTE_ARTICLE", root.findTable("MODE_VENTE_ARTICLE").getSQLName(), "ID", "5");

            createFactureF.addForeignColumn("ID_MODE_VENTE_ARTICLE", root.findTable("MODE_VENTE_ARTICLE").getSQLName(), "ID", "5");

            createFactureF.addForeignColumn("UNITE_VENTE");

            createFactureF.addForeignColumn("UNITE_VENTE");

            createFactureF.addForeignColumn("ARTICLE");

            createFactureF.addForeignColumn("ARTICLE");

            createFactureF.addForeignColumn("ID_DEVISE", root.findTable("DEVISE", true));

            createFactureF.addForeignColumn("ID_DEVISE", root.findTable("DEVISE", true));

            createFactureF.addForeignColumn("CODE_FOURNISSEUR");

            createFactureF.addForeignColumn("CODE_FOURNISSEUR");

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            try {

            try {

                ds.execute(createFactureF.asString());

                ds.execute(createFactureF.asString());

                insertUndef(createFactureF);

                insertUndef(createFactureF);

                root.getSchema().updateVersion();

                root.getSchema().updateVersion();

                refetchRoot = true;

                refetchRoot = true;

            } catch (SQLException ex) {

            } catch (SQLException ex) {

                throw new IllegalStateException("Erreur lors de la création de la table FACTURE_FOURNISSEUR_ELEMENT", ex);

                throw new IllegalStateException("Erreur lors de la création de la table FACTURE_FOURNISSEUR_ELEMENT", ex);

            }

            }

        }

        }

        if (root.contains("FACTURE_FOURNISSEUR_ELEMENT")) {

        if (root.contains("FACTURE_FOURNISSEUR_ELEMENT")) {

            addHAElementField(root.getTable("FACTURE_FOURNISSEUR_ELEMENT"), root);

            addHAElementField(root.getTable("FACTURE_FOURNISSEUR_ELEMENT"), root);

        }

        }

        if (!root.contains("REGLER_MONTANT_ELEMENT")) {

        if (!root.contains("REGLER_MONTANT_ELEMENT")) {

            SQLCreateTable createReglerElt = new SQLCreateTable(root, "REGLER_MONTANT_ELEMENT");

            SQLCreateTable createReglerElt = new SQLCreateTable(root, "REGLER_MONTANT_ELEMENT");

            createReglerElt.addForeignColumn("ECHEANCE_FOURNISSEUR");

            createReglerElt.addForeignColumn("ECHEANCE_FOURNISSEUR");

            createReglerElt.addForeignColumn("REGLER_MONTANT");

            createReglerElt.addForeignColumn("REGLER_MONTANT");

            createReglerElt.addForeignColumn("MOUVEMENT", "ECHEANCE");

            createReglerElt.addForeignColumn("MOUVEMENT", "ECHEANCE");

            createReglerElt.addColumn("DATE", "date");

            createReglerElt.addColumn("DATE", "date");

            createReglerElt.addColumn("MONTANT_REGLE", "bigint DEFAULT 0");

            createReglerElt.addColumn("MONTANT_REGLE", "bigint DEFAULT 0");

            createReglerElt.addColumn("MONTANT_A_REGLER", "bigint DEFAULT 0");

            createReglerElt.addColumn("MONTANT_A_REGLER", "bigint DEFAULT 0");

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            final SQLDataSource ds = root.getDBSystemRoot().getDataSource();

            try {

            try {

                ds.execute(createReglerElt.asString());

                ds.execute(createReglerElt.asString());

                insertUndef(createReglerElt);

                insertUndef(createReglerElt);

                root.getSchema().updateVersion();

                root.getSchema().updateVersion();

                root.refetchTable("REGLER_MONTANT_ELEMENT");

                root.refetchTable("REGLER_MONTANT_ELEMENT");

                refetchRoot = true;

                refetchRoot = true;

            } catch (SQLException ex) {

            } catch (SQLException ex) {

                throw new IllegalStateException("Erreur lors de la création de la table REGLER_MONTANT_ELEMENT", ex);

                throw new IllegalStateException("Erreur lors de la création de la table REGLER_MONTANT_ELEMENT", ex);

            }

            }

        }

        }

        final SQLTable tableReglerMontant = root.getTable("REGLER_MONTANT");

        final SQLTable tableReglerMontant = root.getTable("REGLER_MONTANT");

        boolean updateRegler = false;

        boolean updateRegler = false;

        AlterTable alterElt = new AlterTable(tableReglerMontant);

        AlterTable alterElt = new AlterTable(tableReglerMontant);

        if (!tableReglerMontant.contains("ID_FOURNISSEUR")) {

        if (!tableReglerMontant.contains("ID_FOURNISSEUR")) {

            alterElt.addForeignColumn("ID_FOURNISSEUR", root.getTable("FOURNISSEUR"));

            alterElt.addForeignColumn("ID_FOURNISSEUR", root.getTable("FOURNISSEUR"));

            updateRegler = true;

            updateRegler = true;

        }

        }

        if (!tableReglerMontant.contains("NOM")) {

        if (!tableReglerMontant.contains("NOM")) {

            alterElt.addVarCharColumn("NOM", 256);

            alterElt.addVarCharColumn("NOM", 256);

            updateRegler = true;

            updateRegler = true;

        }

        }

        if (updateRegler) {

        if (updateRegler) {

            root.getDBSystemRoot().getDataSource().execute(alterElt.asString());

            root.getDBSystemRoot().getDataSource().execute(alterElt.asString());

            root.refetchTable(tableReglerMontant.getName());

            root.refetchTable(tableReglerMontant.getName());

        }

        }

        if (refetchRoot) {

        if (refetchRoot) {

            root.refetch();

            root.refetch();

        }

        }

    }

    }

    private void fixUnboundedNumeric(DBRoot root) throws SQLException {

    private void fixUnboundedNumeric(DBRoot root) throws SQLException {

        final List<AlterTable> alters = new ArrayList<AlterTable>();

        final List<AlterTable> alters = new ArrayList<AlterTable>();

        final List<UpdateBuilder> builds = new ArrayList<UpdateBuilder>();

        final List<UpdateBuilder> builds = new ArrayList<UpdateBuilder>();

        {

        {

            SQLTable tableAvoir = root.getTable("AVOIR_CLIENT_ELEMENT");

            SQLTable tableAvoir = root.getTable("AVOIR_CLIENT_ELEMENT");

            final AlterTable alter = new AlterTable(tableAvoir);

            final AlterTable alter = new AlterTable(tableAvoir);

            if (tableAvoir.contains("POURCENT_ACOMPTE")) {

            if (tableAvoir.contains("POURCENT_ACOMPTE")) {

                SQLField fieldAcompteAvoir = tableAvoir.getField("POURCENT_ACOMPTE");

                SQLField fieldAcompteAvoir = tableAvoir.getField("POURCENT_ACOMPTE");

                if (fieldAcompteAvoir.getType().getSize() > 500) {

                if (fieldAcompteAvoir.getType().getSize() > 500) {

                    final String fName = fieldAcompteAvoir.getName();

                    final String fName = fieldAcompteAvoir.getName();

                    alter.alterColumn(fName, EnumSet.allOf(Properties.class), "numeric(6,2)", "100", false);

                    alter.alterColumn(fName, EnumSet.allOf(Properties.class), "numeric(6,2)", "100", false);

                    UpdateBuilder build = new UpdateBuilder(tableAvoir);

                    UpdateBuilder build = new UpdateBuilder(tableAvoir);

                    build.set(fieldAcompteAvoir.getName(), "100");

                    build.set(fieldAcompteAvoir.getName(), "100");

                    build.setWhere(new Where(fieldAcompteAvoir, "=", (Object) null));

                    build.setWhere(new Where(fieldAcompteAvoir, "=", (Object) null));

                    builds.add(build);

                    builds.add(build);

                }

                }

            }

            }

            if (tableAvoir.contains("POURCENT_REMISE")) {

            if (tableAvoir.contains("POURCENT_REMISE")) {

                SQLField fieldRemiseAvoir = tableAvoir.getField("POURCENT_REMISE");

                SQLField fieldRemiseAvoir = tableAvoir.getField("POURCENT_REMISE");

                if (fieldRemiseAvoir.getType().getSize() > 500) {

                if (fieldRemiseAvoir.getType().getSize() > 500) {

                    final String fName = fieldRemiseAvoir.getName();

                    final String fName = fieldRemiseAvoir.getName();

                    alter.alterColumn(fName, EnumSet.allOf(Properties.class), "numeric(6,2)", "0", false);

                    alter.alterColumn(fName, EnumSet.allOf(Properties.class), "numeric(6,2)", "0", false);

                    UpdateBuilder build = new UpdateBuilder(tableAvoir);

                    UpdateBuilder build = new UpdateBuilder(tableAvoir);

                    build.set(fieldRemiseAvoir.getName(), "0");

                    build.set(fieldRemiseAvoir.getName(), "0");

                    build.setWhere(new Where(fieldRemiseAvoir, "=", (Object) null));

                    build.setWhere(new Where(fieldRemiseAvoir, "=", (Object) null));

                    builds.add(build);

                    builds.add(build);

                }

                }

            }

            }

            if (!alter.isEmpty())

            if (!alter.isEmpty())

                alters.add(alter);

                alters.add(alter);

        }

        }

        {

        {

            SQLTable tableFacture = root.getTable("SAISIE_VENTE_FACTURE_ELEMENT");

            SQLTable tableFacture = root.getTable("SAISIE_VENTE_FACTURE_ELEMENT");

            final AlterTable alter = new AlterTable(tableFacture);

            final AlterTable alter = new AlterTable(tableFacture);

            if (tableFacture.contains("POURCENT_ACOMPTE")) {

            if (tableFacture.contains("POURCENT_ACOMPTE")) {

                SQLField fieldAcompteFacture = tableFacture.getField("POURCENT_ACOMPTE");

                SQLField fieldAcompteFacture = tableFacture.getField("POURCENT_ACOMPTE");

                if (fieldAcompteFacture.getType().getSize() > 500) {

                if (fieldAcompteFacture.getType().getSize() > 500) {

                    final String fName = fieldAcompteFacture.getName();

                    final String fName = fieldAcompteFacture.getName();

                    alter.alterColumn(fName, EnumSet.allOf(Properties.class), "numeric(6,2)", "100", false);

                    alter.alterColumn(fName, EnumSet.allOf(Properties.class), "numeric(6,2)", "100", false);

                    UpdateBuilder build = new UpdateBuilder(tableFacture);

                    UpdateBuilder build = new UpdateBuilder(tableFacture);

                    build.set(fieldAcompteFacture.getName(), "100");

                    build.set(fieldAcompteFacture.getName(), "100");

                    build.setWhere(new Where(fieldAcompteFacture, "=", (Object) null));

                    build.setWhere(new Where(fieldAcompteFacture, "=", (Object) null));

                    builds.add(build);

                    builds.add(build);

                }

                }

            }

            }

            if (tableFacture.contains("POURCENT_REMISE")) {

            if (tableFacture.contains("POURCENT_REMISE")) {

                SQLField fieldRemiseFacture = tableFacture.getField("POURCENT_REMISE");

                SQLField fieldRemiseFacture = tableFacture.getField("POURCENT_REMISE");

                if (fieldRemiseFacture.getType().getSize() > 500) {

                if (fieldRemiseFacture.getType().getSize() > 500) {

                    final String fName = fieldRemiseFacture.getName();

                    final String fName = fieldRemiseFacture.getName();

                    alter.alterColumn(fName, EnumSet.allOf(Properties.class), "numeric(6,2)", "0", false);

                    alter.alterColumn(fName, EnumSet.allOf(Properties.class), "numeric(6,2)", "0", false);

                    UpdateBuilder build = new UpdateBuilder(tableFacture);

                    UpdateBuilder build = new UpdateBuilder(tableFacture);

                    build.set(fieldRemiseFacture.getName(), "0");

                    build.set(fieldRemiseFacture.getName(), "0");

                    build.setWhere(new Where(fieldRemiseFacture, "=", (Object) null));

                    build.setWhere(new Where(fieldRemiseFacture, "=", (Object) null));

                    builds.add(build);

                    builds.add(build);

                }

                }

            }

            }

            if (tableFacture.getFieldsName().contains("REPARTITION_POURCENT")) {

            if (tableFacture.getFieldsName().contains("REPARTITION_POURCENT")) {

                SQLField fieldRepFacture = tableFacture.getField("REPARTITION_POURCENT");

                SQLField fieldRepFacture = tableFacture.getField("REPARTITION_POURCENT");

                if (fieldRepFacture.getType().getSize() > 500) {

                if (fieldRepFacture.getType().getSize() > 500) {

                    final String fName = fieldRepFacture.getName();

                    final String fName = fieldRepFacture.getName();

                    alter.alterColumn(fName, EnumSet.allOf(Properties.class), "numeric(6,2)", "0", false);

                    alter.alterColumn(fName, EnumSet.allOf(Properties.class), "numeric(6,2)", "0", false);

                    UpdateBuilder build = new UpdateBuilder(tableFacture);

                    UpdateBuilder build = new UpdateBuilder(tableFacture);

                    build.set(fieldRepFacture.getName(), "0");

                    build.set(fieldRepFacture.getName(), "0");

                    build.setWhere(new Where(fieldRepFacture, "=", (Object) null));

                    build.setWhere(new Where(fieldRepFacture, "=", (Object) null));

                    builds.add(build);

                    builds.add(build);

                }

                }

            }

            }

            if (!alter.isEmpty())

            if (!alter.isEmpty())

                alters.add(alter);

                alters.add(alter);

        }

        }