CREATE TABLE IF NOT EXISTS `llx_accountingdebcred` (
  `fk_transaction` int(11) NOT NULL default '0',
  `fk_account` int(11) NOT NULL default '0',
  `amount` double NOT NULL default '0',
  `direction` char(1) character set latin1 NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `llx_accountingsystem` (
  `pcg_version` varchar(12) character set latin1 NOT NULL default '',
  `fk_pays` int(11) NOT NULL default '0',
  `label` varchar(128) character set latin1 NOT NULL default '',
  `datec` varchar(12) character set latin1 NOT NULL default '',
  `fk_author` varchar(20) character set latin1 default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `active` smallint(6) default '0',
  PRIMARY KEY  (`pcg_version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `llx_accountingtransaction` (
  `rowid` int(11) NOT NULL auto_increment,
  `label` varchar(128) character set latin1 NOT NULL default '',
  `datec` date NOT NULL default '0000-00-00',
  `fk_author` varchar(20) character set latin1 NOT NULL default '',
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_facture` int(11) default NULL,
  `fk_facture_fourn` int(11) default NULL,
  `fk_paiement` int(11) default NULL,
  `fk_paiement_fourn` int(11) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_actioncomm` (
  `id` int(11) NOT NULL auto_increment,
  `datep` datetime default NULL,
  `datep2` datetime default NULL,
  `datea` datetime default NULL,
  `datea2` datetime default NULL,
  `fk_action` int(11) default NULL,
  `label` varchar(50) character set latin1 NOT NULL default '',
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_user_author` int(11) default NULL,
  `fk_user_mod` int(11) default NULL,
  `fk_project` int(11) default NULL,
  `fk_soc` int(11) default NULL,
  `fk_contact` int(11) default NULL,
  `fk_parent` int(11) NOT NULL default '0',
  `fk_user_action` int(11) default NULL,
  `fk_user_done` int(11) default NULL,
  `priority` smallint(6) default NULL,
  `punctual` smallint(6) NOT NULL default '1',
  `percent` smallint(6) NOT NULL default '0',
  `location` varchar(128) character set latin1 default NULL,
  `durationp` double default NULL,
  `durationa` double default NULL,
  `note` text character set latin1,
  `propalrowid` int(11) default NULL,
  `fk_commande` int(11) default NULL,
  `fk_facture` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `idx_actioncomm_datea` (`datea`),
  KEY `idx_actioncomm_fk_soc` (`fk_soc`),
  KEY `idx_actioncomm_fk_contact` (`fk_contact`),
  KEY `idx_actioncomm_fk_facture` (`fk_facture`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_action_def` (
  `rowid` int(11) NOT NULL default '0',
  `code` varchar(28) character set latin1 NOT NULL default '',
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `titre` varchar(255) character set latin1 NOT NULL default '',
  `description` text character set latin1,
  `objet_type` varchar(16) character set latin1 NOT NULL default '',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_adherent` (
  `rowid` int(11) NOT NULL auto_increment,
  `nom` varchar(50) collate utf8_unicode_ci default NULL,
  `prenom` varchar(50) collate utf8_unicode_ci default NULL,
  `login` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `pass` varchar(50) collate utf8_unicode_ci default NULL,
  `fk_adherent_type` smallint(6) default NULL,
  `morphy` varchar(3) collate utf8_unicode_ci NOT NULL default '',
  `societe` varchar(50) collate utf8_unicode_ci default NULL,
  `adresse` text collate utf8_unicode_ci,
  `cp` varchar(30) collate utf8_unicode_ci default NULL,
  `ville` varchar(50) collate utf8_unicode_ci default NULL,
  `pays` varchar(50) collate utf8_unicode_ci default NULL,
  `email` varchar(255) collate utf8_unicode_ci default NULL,
  `phone` varchar(30) collate utf8_unicode_ci default NULL,
  `phone_perso` varchar(30) collate utf8_unicode_ci default NULL,
  `phone_mobile` varchar(30) collate utf8_unicode_ci default NULL,
  `naiss` date default NULL,
  `photo` varchar(255) collate utf8_unicode_ci default NULL,
  `statut` smallint(6) NOT NULL default '0',
  `public` smallint(6) NOT NULL default '0',
  `datefin` datetime default NULL,
  `note` text collate utf8_unicode_ci,
  `datevalid` datetime default NULL,
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_user_author` int(11) NOT NULL default '0',
  `fk_user_mod` int(11) default NULL,
  `fk_user_valid` int(11) default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `login` (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_adherent_options` (
  `optid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `adhid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`optid`),
  UNIQUE KEY `adhid` (`adhid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_adherent_options_label` (
  `name` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `label` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_adherent_type` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `statut` smallint(6) NOT NULL default '0',
  `libelle` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `cotisation` varchar(3) collate utf8_unicode_ci NOT NULL default 'yes',
  `vote` varchar(3) collate utf8_unicode_ci NOT NULL default 'yes',
  `note` text collate utf8_unicode_ci,
  `mail_valid` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_adherent_type_libelle` (`libelle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_appro` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_product` int(11) NOT NULL default '0',
  `quantity` smallint(5) unsigned NOT NULL default '0',
  `price` double default NULL,
  `fk_user_author` int(11) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `llx_bank` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `datev` date default NULL,
  `dateo` date default NULL,
  `amount` double(24,8) NOT NULL default '0.00000000',
  `label` varchar(255) collate utf8_unicode_ci default NULL,
  `fk_account` int(11) default NULL,
  `fk_user_author` int(11) default NULL,
  `fk_user_rappro` int(11) default NULL,
  `fk_type` varchar(4) collate utf8_unicode_ci default NULL,
  `num_releve` varchar(50) collate utf8_unicode_ci default NULL,
  `num_chq` varchar(50) collate utf8_unicode_ci default NULL,
  `rappro` tinyint(4) default '0',
  `note` text collate utf8_unicode_ci,
  `fk_bordereau` int(11) default '0',
  `banque` varchar(255) collate utf8_unicode_ci default NULL,
  `emetteur` varchar(255) collate utf8_unicode_ci default NULL,
  `author` varchar(40) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_bank_account` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ref` varchar(12) collate utf8_unicode_ci NOT NULL default '',
  `label` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `bank` varchar(60) collate utf8_unicode_ci default NULL,
  `code_banque` varchar(7) collate utf8_unicode_ci default NULL,
  `code_guichet` varchar(6) collate utf8_unicode_ci default NULL,
  `number` varchar(255) collate utf8_unicode_ci default NULL,
  `cle_rib` varchar(5) collate utf8_unicode_ci default NULL,
  `bic` varchar(11) collate utf8_unicode_ci default NULL,
  `iban_prefix` varchar(50) collate utf8_unicode_ci default NULL,
  `country_iban` varchar(2) collate utf8_unicode_ci default NULL,
  `cle_iban` varchar(2) collate utf8_unicode_ci default NULL,
  `domiciliation` varchar(255) collate utf8_unicode_ci default NULL,
  `proprio` varchar(60) collate utf8_unicode_ci default NULL,
  `adresse_proprio` varchar(255) collate utf8_unicode_ci default NULL,
  `courant` smallint(6) NOT NULL default '0',
  `clos` smallint(6) NOT NULL default '0',
  `rappro` smallint(6) default '1',
  `url` varchar(128) collate utf8_unicode_ci default NULL,
  `account_number` varchar(8) collate utf8_unicode_ci default NULL,
  `currency_code` varchar(3) collate utf8_unicode_ci NOT NULL default '',
  `min_allowed` int(11) default '0',
  `min_desired` int(11) default '0',
  `comment` varchar(254) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_bank_account_label` (`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_bank_categ` (
  `rowid` int(11) NOT NULL auto_increment,
  `label` varchar(255) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_bank_class` (
  `lineid` int(11) NOT NULL default '0',
  `fk_categ` int(11) NOT NULL default '0',
  KEY `lineid` (`lineid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_bank_url` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_bank` int(11) default NULL,
  `url_id` int(11) default NULL,
  `url` varchar(255) collate utf8_unicode_ci default NULL,
  `label` varchar(255) collate utf8_unicode_ci default NULL,
  `type` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_bank_url` (`fk_bank`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_bookmark` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_soc` int(11) default NULL,
  `fk_user` int(11) NOT NULL default '0',
  `dateb` datetime default NULL,
  `url` varchar(128) collate utf8_unicode_ci NOT NULL default '',
  `target` varchar(16) collate utf8_unicode_ci default NULL,
  `title` varchar(64) collate utf8_unicode_ci default NULL,
  `favicon` varchar(24) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_bookmark_url` (`fk_user`,`url`),
  UNIQUE KEY `uk_bookmark_title` (`fk_user`,`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_bordereau_cheque` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_bordereau` date default NULL,
  `number` varchar(16) collate utf8_unicode_ci NOT NULL default '',
  `amount` double(24,8) NOT NULL default '0.00000000',
  `nbcheque` smallint(6) NOT NULL default '0',
  `fk_bank_account` int(11) default NULL,
  `fk_user_author` int(11) default NULL,
  `note` text collate utf8_unicode_ci,
  `statut` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_boxes` (
  `rowid` int(11) NOT NULL auto_increment,
  `box_id` int(11) NOT NULL default '0',
  `position` smallint(6) NOT NULL default '0',
  `box_order` char(3) collate utf8_unicode_ci NOT NULL default '',
  `fk_user` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_boxes` (`box_id`,`position`,`fk_user`),
  KEY `idx_boxes_boxid` (`box_id`),
  KEY `idx_boxes_fk_user` (`fk_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_boxes_def` (
  `rowid` int(11) NOT NULL auto_increment,
  `file` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_categorie` (
  `rowid` int(11) NOT NULL auto_increment,
  `label` varchar(255) collate utf8_unicode_ci default NULL,
  `description` text collate utf8_unicode_ci,
  `fk_soc` int(11) default NULL,
  `visible` tinyint(4) NOT NULL default '1',
  `type` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_categorie_ref` (`label`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_categorie_association` (
  `fk_categorie_mere` int(11) NOT NULL default '0',
  `fk_categorie_fille` int(11) NOT NULL default '0',
  KEY `idx_categorie_association_fk_categorie_mere` (`fk_categorie_mere`),
  KEY `idx_categorie_association_fk_categorie_fille` (`fk_categorie_fille`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_categorie_fournisseur` (
  `fk_categorie` int(11) NOT NULL default '0',
  `fk_societe` int(11) NOT NULL default '0',
  UNIQUE KEY `fk_categorie` (`fk_categorie`,`fk_societe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_categorie_product` (
  `fk_categorie` int(11) NOT NULL default '0',
  `fk_product` int(11) NOT NULL default '0',
  PRIMARY KEY  (`fk_categorie`,`fk_product`),
  KEY `idx_categorie_product_fk_categorie` (`fk_categorie`),
  KEY `idx_categorie_product_fk_product` (`fk_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_categorie_societe` (
  `fk_categorie` int(11) NOT NULL default '0',
  `fk_societe` int(11) NOT NULL default '0',
  PRIMARY KEY  (`fk_categorie`,`fk_societe`),
  KEY `idx_categorie_societe_fk_categorie` (`fk_categorie`),
  KEY `idx_categorie_societe_fk_societe` (`fk_societe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_chargesociales` (
  `rowid` int(11) NOT NULL auto_increment,
  `date_ech` datetime NOT NULL default '0000-00-00 00:00:00',
  `libelle` varchar(80) collate utf8_unicode_ci NOT NULL default '',
  `fk_type` int(11) NOT NULL default '0',
  `amount` double NOT NULL default '0',
  `paye` smallint(6) NOT NULL default '0',
  `periode` date default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_commande` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_soc` int(11) NOT NULL default '0',
  `fk_projet` int(11) default '0',
  `ref` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `ref_client` varchar(30) collate utf8_unicode_ci default NULL,
  `date_creation` datetime default NULL,
  `date_valid` datetime default NULL,
  `date_cloture` datetime default NULL,
  `date_commande` date default NULL,
  `fk_user_author` int(11) default NULL,
  `fk_user_valid` int(11) default NULL,
  `fk_user_cloture` int(11) default NULL,
  `source` smallint(6) default NULL,
  `fk_statut` smallint(6) default '0',
  `amount_ht` double default '0',
  `remise_percent` double default '0',
  `remise_absolue` double default '0',
  `remise` double default '0',
  `tva` double(24,8) default '0.00000000',
  `total_ht` double(24,8) default '0.00000000',
  `total_ttc` double(24,8) default '0.00000000',
  `note` text collate utf8_unicode_ci,
  `note_public` text collate utf8_unicode_ci,
  `model_pdf` varchar(50) collate utf8_unicode_ci default NULL,
  `facture` tinyint(4) default '0',
  `fk_cond_reglement` int(11) default NULL,
  `fk_mode_reglement` int(11) default NULL,
  `date_livraison` date default NULL,
  `fk_adresse_livraison` int(11) default NULL,
  `import_key` varchar(14) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  KEY `idx_commande_fk_soc` (`fk_soc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_commandedet` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_commande` int(11) default NULL,
  `fk_product` int(11) default NULL,
  `description` text collate utf8_unicode_ci,
  `tva_tx` double(6,3) default NULL,
  `qty` double default NULL,
  `remise_percent` double default '0',
  `remise` double default '0',
  `fk_remise_except` int(11) default NULL,
  `price` double default NULL,
  `subprice` double(24,8) default '0.00000000',
  `total_ht` double(24,8) default '0.00000000',
  `total_tva` double(24,8) default '0.00000000',
  `total_ttc` double(24,8) default '0.00000000',
  `date_start` datetime default NULL,
  `date_end` datetime default NULL,
  `info_bits` int(11) default '0',
  `marge_tx` double(6,3) default '0.000',
  `marque_tx` double(6,3) default '0.000',
  `special_code` tinyint(4) unsigned default '0',
  `rang` int(11) default '0',
  `import_key` varchar(14) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  KEY `idx_commandedet_fk_commande` (`fk_commande`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_commande_fournisseur` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_soc` int(11) NOT NULL default '0',
  `fk_projet` int(11) default '0',
  `ref` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `date_creation` datetime default NULL,
  `date_valid` datetime default NULL,
  `date_cloture` datetime default NULL,
  `date_commande` date default NULL,
  `fk_user_author` int(11) default NULL,
  `fk_user_valid` int(11) default NULL,
  `fk_user_cloture` int(11) default NULL,
  `source` smallint(6) NOT NULL default '0',
  `fk_statut` smallint(6) default '0',
  `amount_ht` double default '0',
  `remise_percent` double default '0',
  `remise` double default '0',
  `tva` double(24,8) default '0.00000000',
  `total_ht` double(24,8) default '0.00000000',
  `total_ttc` double(24,8) default '0.00000000',
  `note` text collate utf8_unicode_ci,
  `note_public` text collate utf8_unicode_ci,
  `model_pdf` varchar(50) collate utf8_unicode_ci default NULL,
  `fk_methode_commande` int(11) default '0',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_commande_fournisseur_ref` (`ref`,`fk_soc`),
  KEY `idx_commande_fournisseur_fk_soc` (`fk_soc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_commande_fournisseurdet` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_commande` int(11) NOT NULL default '0',
  `fk_product` int(11) default NULL,
  `ref` varchar(50) collate utf8_unicode_ci default NULL,
  `label` varchar(255) collate utf8_unicode_ci default NULL,
  `description` text collate utf8_unicode_ci,
  `tva_tx` double(6,3) default '0.000',
  `qty` double default NULL,
  `remise_percent` double default '0',
  `remise` double default '0',
  `subprice` double(24,8) default '0.00000000',
  `total_ht` double(24,8) default '0.00000000',
  `total_tva` double(24,8) default '0.00000000',
  `total_ttc` double(24,8) default '0.00000000',
  `info_bits` int(11) default '0',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `llx_commande_fournisseur_dispatch` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_commande` int(11) default NULL,
  `fk_product` int(11) default NULL,
  `qty` float default NULL,
  `fk_entrepot` int(11) default NULL,
  `fk_user` int(11) default NULL,
  `datec` datetime default NULL,
  PRIMARY KEY  (`rowid`),
  KEY `idx_commande_fournisseur_dispatch_fk_commande` (`fk_commande`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_commande_fournisseur_log` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datelog` datetime NOT NULL default '0000-00-00 00:00:00',
  `fk_commande` int(11) NOT NULL default '0',
  `fk_statut` smallint(6) NOT NULL default '0',
  `fk_user` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_compta` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `datev` date default NULL,
  `amount` double NOT NULL default '0',
  `label` varchar(255) collate utf8_unicode_ci default NULL,
  `fk_compta_account` int(11) default NULL,
  `fk_user_author` int(11) default NULL,
  `fk_user_valid` int(11) default NULL,
  `valid` tinyint(4) default '0',
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_compta_account` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `number` varchar(12) collate utf8_unicode_ci default NULL,
  `label` varchar(255) collate utf8_unicode_ci default NULL,
  `fk_user_author` int(11) default NULL,
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_compta_compte_generaux` (
  `rowid` int(11) NOT NULL auto_increment,
  `date_creation` datetime default NULL,
  `numero` varchar(50) collate utf8_unicode_ci default NULL,
  `intitule` varchar(255) collate utf8_unicode_ci default NULL,
  `fk_user_author` int(11) default NULL,
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `numero` (`numero`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_cond_reglement` (
  `rowid` int(11) NOT NULL default '0',
  `code` varchar(16) collate utf8_unicode_ci default NULL,
  `sortorder` smallint(6) default NULL,
  `active` tinyint(4) default '1',
  `libelle` varchar(255) collate utf8_unicode_ci default NULL,
  `libelle_facture` text collate utf8_unicode_ci,
  `fdm` tinyint(4) default NULL,
  `nbjour` smallint(6) default NULL,
  `decalage` smallint(6) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_const` (
  `rowid` int(11) NOT NULL auto_increment,
  `name` varchar(255) collate utf8_unicode_ci default NULL,
  `value` text collate utf8_unicode_ci,
  `type` varchar(6) collate utf8_unicode_ci default NULL,
  `visible` tinyint(4) NOT NULL default '1',
  `note` text collate utf8_unicode_ci,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=99 ; 

CREATE TABLE IF NOT EXISTS `llx_contrat` (
  `rowid` int(11) NOT NULL auto_increment,
  `ref` varchar(30) collate utf8_unicode_ci default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datec` datetime default NULL,
  `date_contrat` datetime default NULL,
  `statut` smallint(6) default '0',
  `mise_en_service` datetime default NULL,
  `fin_validite` datetime default NULL,
  `date_cloture` datetime default NULL,
  `fk_soc` int(11) NOT NULL default '0',
  `fk_projet` int(11) default NULL,
  `fk_commercial_signature` int(11) NOT NULL default '0',
  `fk_commercial_suivi` int(11) NOT NULL default '0',
  `fk_user_author` int(11) NOT NULL default '0',
  `fk_user_mise_en_service` int(11) default NULL,
  `fk_user_cloture` int(11) default NULL,
  `note` text collate utf8_unicode_ci,
  `note_public` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`),
  KEY `idx_contrat_fk_soc` (`fk_soc`),
  KEY `idx_contrat_fk_user_author` (`fk_user_author`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_contratdet` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_contrat` int(11) NOT NULL default '0',
  `fk_product` int(11) default NULL,
  `statut` smallint(6) default '0',
  `label` text collate utf8_unicode_ci,
  `description` text collate utf8_unicode_ci,
  `fk_remise_except` int(11) default NULL,
  `date_commande` datetime default NULL,
  `date_ouverture_prevue` datetime default NULL,
  `date_ouverture` datetime default NULL,
  `date_fin_validite` datetime default NULL,
  `date_cloture` datetime default NULL,
  `tva_tx` double(6,3) default '0.000',
  `qty` double NOT NULL default '0',
  `remise_percent` double default '0',
  `subprice` double(24,8) default '0.00000000',
  `price_ht` double default NULL,
  `remise` double default '0',
  `total_ht` double(24,8) default '0.00000000',
  `total_tva` double(24,8) default '0.00000000',
  `total_ttc` double(24,8) default '0.00000000',
  `info_bits` int(11) default '0',
  `fk_user_author` int(11) NOT NULL default '0',
  `fk_user_ouverture` int(11) default NULL,
  `fk_user_cloture` int(11) default NULL,
  `commentaire` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`),
  KEY `idx_contratdet_fk_contrat` (`fk_contrat`),
  KEY `idx_contratdet_fk_product` (`fk_product`),
  KEY `idx_contratdet_date_ouverture_prevue` (`date_ouverture_prevue`),
  KEY `idx_contratdet_date_ouverture` (`date_ouverture`),
  KEY `idx_contratdet_date_fin_validite` (`date_fin_validite`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_contratdet_log` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_contratdet` int(11) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `statut` smallint(6) NOT NULL default '0',
  `fk_user_author` int(11) NOT NULL default '0',
  `commentaire` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`),
  KEY `idx_contratdet_log_fk_contratdet` (`fk_contratdet`),
  KEY `idx_contratdet_log_date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_cotisation` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datec` datetime default NULL,
  `fk_adherent` int(11) default NULL,
  `dateadh` datetime default NULL,
  `datef` date default NULL,
  `cotisation` double default NULL,
  `fk_bank` int(11) default NULL,
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_cotisation` (`fk_adherent`,`dateadh`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_co_exp` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_commande` int(11) NOT NULL default '0',
  `fk_expedition` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  KEY `fk_commande` (`fk_commande`),
  KEY `fk_expedition` (`fk_expedition`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_co_fa` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_commande` int(11) NOT NULL default '0',
  `fk_facture` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  KEY `fk_commande` (`fk_commande`),
  KEY `fk_facture` (`fk_facture`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_co_liv` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_commande` int(11) NOT NULL default '0',
  `fk_livraison` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  KEY `fk_commande` (`fk_commande`),
  KEY `fk_livraison` (`fk_livraison`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_co_pr` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_commande` int(11) default NULL,
  `fk_propale` int(11) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_c_actioncomm` (
  `id` int(11) NOT NULL default '0',
  `code` varchar(12) collate utf8_unicode_ci NOT NULL default '',
  `type` varchar(10) collate utf8_unicode_ci NOT NULL default 'system',
  `libelle` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `module` varchar(16) collate utf8_unicode_ci default NULL,
  `active` tinyint(4) NOT NULL default '1',
  `todo` tinyint(4) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_c_barcode_type` (
  `rowid` int(11) NOT NULL auto_increment,
  `code` varchar(16) collate utf8_unicode_ci NOT NULL default '',
  `libelle` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `coder` varchar(16) collate utf8_unicode_ci NOT NULL default '',
  `example` varchar(16) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ; 

CREATE TABLE IF NOT EXISTS `llx_c_chargesociales` (
  `id` int(11) NOT NULL auto_increment,
  `libelle` varchar(80) collate utf8_unicode_ci default NULL,
  `deductible` smallint(6) NOT NULL default '0',
  `active` tinyint(4) NOT NULL default '1',
  `actioncompta` varchar(12) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=61 ; 

CREATE TABLE IF NOT EXISTS `llx_c_civilite` (
  `rowid` int(11) NOT NULL default '0',
  `code` varchar(6) collate utf8_unicode_ci NOT NULL default '',
  `civilite` varchar(50) collate utf8_unicode_ci default NULL,
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_c_currencies` (
  `code` varchar(2) collate utf8_unicode_ci NOT NULL default '',
  `code_iso` varchar(3) collate utf8_unicode_ci NOT NULL default '',
  `label` varchar(64) collate utf8_unicode_ci default NULL,
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`code`),
  UNIQUE KEY `uk_c_currencies_code_iso` (`code_iso`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_c_departements` (
  `rowid` int(11) NOT NULL auto_increment,
  `code_departement` varchar(6) collate utf8_unicode_ci NOT NULL default '',
  `fk_region` int(11) default NULL,
  `cheflieu` varchar(7) collate utf8_unicode_ci default NULL,
  `tncc` int(11) default NULL,
  `ncc` varchar(50) collate utf8_unicode_ci default NULL,
  `nom` varchar(50) collate utf8_unicode_ci default NULL,
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_departements` (`code_departement`,`fk_region`),
  KEY `idx_departements_fk_region` (`fk_region`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=174 ; 

CREATE TABLE IF NOT EXISTS `llx_c_ecotaxe` (
  `rowid` int(11) NOT NULL auto_increment,
  `code` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `libelle` varchar(255) collate utf8_unicode_ci default NULL,
  `price` double(24,8) default NULL,
  `organization` varchar(255) collate utf8_unicode_ci default NULL,
  `fk_pays` int(11) NOT NULL default '0',
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=39 ; 

CREATE TABLE IF NOT EXISTS `llx_c_effectif` (
  `id` int(11) NOT NULL default '0',
  `code` varchar(12) collate utf8_unicode_ci NOT NULL default '',
  `libelle` varchar(30) collate utf8_unicode_ci default NULL,
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_c_forme_juridique` (
  `rowid` int(11) NOT NULL auto_increment,
  `code` varchar(12) collate utf8_unicode_ci NOT NULL default '',
  `fk_pays` int(11) NOT NULL default '0',
  `libelle` varchar(255) collate utf8_unicode_ci default NULL,
  `isvatexempted` tinyint(4) NOT NULL default '0',
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=193 ; 

CREATE TABLE IF NOT EXISTS `llx_c_methode_commande_fournisseur` (
  `rowid` int(11) NOT NULL auto_increment,
  `code` varchar(30) collate utf8_unicode_ci default NULL,
  `libelle` varchar(60) collate utf8_unicode_ci default NULL,
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ; 

CREATE TABLE IF NOT EXISTS `llx_c_paiement` (
  `id` int(11) NOT NULL default '0',
  `code` varchar(6) collate utf8_unicode_ci NOT NULL default '',
  `libelle` varchar(30) collate utf8_unicode_ci default NULL,
  `type` smallint(6) default NULL,
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_c_paper_format` (
  `rowid` int(11) NOT NULL auto_increment,
  `code` varchar(16) collate utf8_unicode_ci NOT NULL default '',
  `label` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `width` float(6,2) default '0.00',
  `height` float(6,2) default '0.00',
  `unit` varchar(5) collate utf8_unicode_ci NOT NULL default '',
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=226 ; 

CREATE TABLE IF NOT EXISTS `llx_c_pays` (
  `rowid` int(11) NOT NULL default '0',
  `code` varchar(2) collate utf8_unicode_ci NOT NULL default '',
  `code_iso` varchar(3) collate utf8_unicode_ci default NULL,
  `libelle` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `idx_c_pays_code` (`code`),
  UNIQUE KEY `idx_c_pays_libelle` (`libelle`),
  UNIQUE KEY `idx_c_pays_code_iso` (`code_iso`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_c_propalst` (
  `id` smallint(6) NOT NULL default '0',
  `code` varchar(12) collate utf8_unicode_ci NOT NULL default '',
  `label` varchar(30) collate utf8_unicode_ci default NULL,
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_c_prospectlevel` (
  `code` varchar(12) collate utf8_unicode_ci NOT NULL default '',
  `label` varchar(30) collate utf8_unicode_ci default NULL,
  `sortorder` smallint(6) default NULL,
  `active` smallint(6) NOT NULL default '1',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_c_regions` (
  `rowid` int(11) NOT NULL auto_increment,
  `code_region` int(11) NOT NULL default '0',
  `fk_pays` int(11) NOT NULL default '0',
  `cheflieu` varchar(7) collate utf8_unicode_ci default NULL,
  `tncc` int(11) default NULL,
  `nom` varchar(50) collate utf8_unicode_ci default NULL,
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `code_region` (`code_region`),
  KEY `idx_c_regions_fk_pays` (`fk_pays`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2822 ; 

CREATE TABLE IF NOT EXISTS `llx_c_stcomm` (
  `id` int(11) NOT NULL default '0',
  `code` varchar(12) collate utf8_unicode_ci NOT NULL default '',
  `libelle` varchar(30) collate utf8_unicode_ci default NULL,
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_c_tva` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_pays` int(11) NOT NULL default '0',
  `taux` double NOT NULL default '0',
  `recuperableonly` int(11) NOT NULL default '0',
  `note` varchar(128) collate utf8_unicode_ci default NULL,
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=283 ; 

CREATE TABLE IF NOT EXISTS `llx_c_typent` (
  `id` int(11) NOT NULL default '0',
  `code` varchar(12) collate utf8_unicode_ci NOT NULL default '',
  `libelle` varchar(30) collate utf8_unicode_ci default NULL,
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_c_type_contact` (
  `rowid` int(11) NOT NULL default '0',
  `element` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `source` varchar(8) collate utf8_unicode_ci NOT NULL default 'external',
  `code` varchar(16) collate utf8_unicode_ci NOT NULL default '',
  `libelle` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `idx_c_type_contact_uk` (`element`,`source`,`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_c_type_fees` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(12) collate utf8_unicode_ci NOT NULL default '',
  `libelle` varchar(30) collate utf8_unicode_ci default NULL,
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; 

CREATE TABLE IF NOT EXISTS `llx_deplacement` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime NOT NULL default '0000-00-00 00:00:00',
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `dated` datetime default NULL,
  `fk_user` int(11) NOT NULL default '0',
  `fk_user_author` int(11) default NULL,
  `type` varchar(12) collate utf8_unicode_ci NOT NULL default '',
  `km` double default NULL,
  `fk_soc` int(11) default NULL,
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_document` (
  `rowid` int(11) NOT NULL auto_increment,
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `file_name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `file_extension` varchar(5) collate utf8_unicode_ci NOT NULL default '',
  `date_generation` datetime default NULL,
  `fk_owner` int(11) default NULL,
  `fk_group` int(11) default NULL,
  `permissions` varchar(9) collate utf8_unicode_ci default 'rw-rw-rw',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_document_generator` (
  `rowid` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `classfile` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `class` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_document_model` (
  `rowid` int(11) NOT NULL auto_increment,
  `nom` varchar(50) collate utf8_unicode_ci default NULL,
  `type` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  `libelle` varchar(255) collate utf8_unicode_ci default NULL,
  `description` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_document_model` (`nom`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_dolibarr_modules` (
  `numero` int(11) NOT NULL default '0',
  `active` tinyint(4) NOT NULL default '0',
  `active_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `active_version` varchar(25) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`numero`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_domain` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `label` varchar(255) collate utf8_unicode_ci default NULL,
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_don` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_statut` smallint(6) NOT NULL default '0',
  `datec` datetime default NULL,
  `datedon` datetime default NULL,
  `amount` double default '0',
  `fk_paiement` int(11) default NULL,
  `prenom` varchar(50) collate utf8_unicode_ci default NULL,
  `nom` varchar(50) collate utf8_unicode_ci default NULL,
  `societe` varchar(50) collate utf8_unicode_ci default NULL,
  `adresse` text collate utf8_unicode_ci,
  `cp` varchar(30) collate utf8_unicode_ci default NULL,
  `ville` varchar(50) collate utf8_unicode_ci default NULL,
  `pays` varchar(50) collate utf8_unicode_ci default NULL,
  `email` varchar(255) collate utf8_unicode_ci default NULL,
  `public` smallint(6) NOT NULL default '1',
  `fk_don_projet` int(11) default NULL,
  `fk_user_author` int(11) NOT NULL default '0',
  `fk_user_valid` int(11) default NULL,
  `note` text collate utf8_unicode_ci,
  `note_public` text collate utf8_unicode_ci,
  `model_pdf` varchar(50) collate utf8_unicode_ci default NULL,
  `import_key` varchar(14) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_don_projet` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datec` datetime default NULL,
  `libelle` varchar(255) collate utf8_unicode_ci default NULL,
  `fk_user_author` int(11) NOT NULL default '0',
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_droitpret_rapport` (
  `rowid` int(11) NOT NULL auto_increment,
  `date_envoie` datetime NOT NULL default '0000-00-00 00:00:00',
  `format` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `date_debut` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_fin` datetime NOT NULL default '0000-00-00 00:00:00',
  `fichier` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `nbfact` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_ecm_directories` (
  `rowid` int(11) NOT NULL auto_increment,
  `label` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `fk_parent` int(11) default NULL,
  `description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `cachenbofdoc` int(11) NOT NULL default '0',
  `date_c` datetime default NULL,
  `date_m` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_user_c` int(11) default NULL,
  `fk_user_m` int(11) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_ecm_document` (
  `rowid` int(11) NOT NULL auto_increment,
  `ref` varchar(16) collate utf8_unicode_ci NOT NULL default '',
  `filename` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `filesize` int(11) NOT NULL default '0',
  `filemime` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `fullpath_dol` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `fullpath_orig` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `description` text collate utf8_unicode_ci,
  `manualkeyword` text collate utf8_unicode_ci,
  `fk_create` int(11) NOT NULL default '0',
  `fk_update` int(11) default NULL,
  `date_c` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_u` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_directory` int(11) default NULL,
  `fk_status` smallint(6) default '0',
  `private` smallint(6) default '0',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_element_contact` (
  `rowid` int(11) NOT NULL auto_increment,
  `datecreate` datetime default NULL,
  `statut` smallint(6) default '5',
  `element_id` int(11) NOT NULL default '0',
  `fk_c_type_contact` int(11) NOT NULL default '0',
  `fk_socpeople` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `idx_element_contact_idx1` (`element_id`,`fk_c_type_contact`,`fk_socpeople`),
  KEY `fk_element_contact_fk_c_type_contact` (`fk_c_type_contact`),
  KEY `idx_element_contact_fk_socpeople` (`fk_socpeople`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_element_element` (
  `rowid` int(11) NOT NULL auto_increment,
  `sourceid` int(11) NOT NULL default '0',
  `sourcetype` varchar(16) collate utf8_unicode_ci NOT NULL default '',
  `targetid` int(11) NOT NULL default '0',
  `targettype` varchar(16) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `idx_element_element_idx1` (`sourceid`,`sourcetype`,`targetid`,`targettype`),
  KEY `idx_element_element_targetid` (`targetid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_energie_compteur` (
  `rowid` int(11) NOT NULL auto_increment,
  `libelle` varchar(50) collate utf8_unicode_ci default NULL,
  `fk_energie` int(11) NOT NULL default '0',
  `datec` datetime default NULL,
  `fk_user_author` int(11) NOT NULL default '0',
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_energie_compteur_groupe` (
  `fk_energie_compteur` int(11) NOT NULL default '0',
  `fk_energie_groupe` int(11) NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_energie_compteur_releve` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_compteur` int(11) NOT NULL default '0',
  `date_releve` datetime default NULL,
  `valeur` double default NULL,
  `datec` datetime default NULL,
  `fk_user_author` int(11) NOT NULL default '0',
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_energie_groupe` (
  `rowid` int(11) NOT NULL auto_increment,
  `libelle` varchar(100) collate utf8_unicode_ci default NULL,
  `datec` datetime default NULL,
  `fk_user_author` int(11) NOT NULL default '0',
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_entrepot` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `label` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `description` text collate utf8_unicode_ci,
  `lieu` varchar(64) collate utf8_unicode_ci default NULL,
  `address` varchar(255) collate utf8_unicode_ci default NULL,
  `cp` varchar(10) collate utf8_unicode_ci default NULL,
  `ville` varchar(50) collate utf8_unicode_ci default NULL,
  `fk_pays` int(11) default '0',
  `statut` tinyint(4) default '1',
  `valo_pmp` float(12,4) default NULL,
  `fk_user_author` int(11) default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `label` (`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_entrepot_valorisation` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `date_calcul` date default NULL,
  `fk_entrepot` int(10) unsigned NOT NULL default '0',
  `valo_pmp` float(12,4) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_events` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `type` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `dateevent` datetime default NULL,
  `fk_user` int(11) default NULL,
  `description` varchar(250) collate utf8_unicode_ci NOT NULL default '',
  `ip` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `fk_object` int(11) default NULL,
  PRIMARY KEY  (`rowid`),
  KEY `idx_events_dateevent` (`dateevent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_expedition` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ref` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `fk_soc` int(11) NOT NULL default '0',
  `date_creation` datetime default NULL,
  `fk_user_author` int(11) default NULL,
  `date_valid` datetime default NULL,
  `fk_user_valid` int(11) default NULL,
  `date_expedition` date default NULL,
  `fk_adresse_livraison` int(11) default NULL,
  `fk_expedition_methode` int(11) default NULL,
  `tracking_number` varchar(50) collate utf8_unicode_ci default NULL,
  `fk_statut` smallint(6) default '0',
  `height` int(11) default NULL,
  `width` int(11) default NULL,
  `size_units` int(11) default NULL,
  `size` int(11) default NULL,
  `weight_units` int(11) default NULL,
  `weight` int(11) default NULL,
  `note` text collate utf8_unicode_ci,
  `model_pdf` varchar(50) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `idx_expedition_uk_ref` (`ref`),
  KEY `idx_expedition_fk_soc` (`fk_soc`),
  KEY `idx_expedition_fk_user_author` (`fk_user_author`),
  KEY `idx_expedition_fk_user_valid` (`fk_user_valid`),
  KEY `idx_expedition_fk_adresse_livraison` (`fk_adresse_livraison`),
  KEY `idx_expedition_fk_expedition_methode` (`fk_expedition_methode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_expeditiondet` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_expedition` int(11) NOT NULL default '0',
  `fk_origin_line` int(11) default NULL,
  `fk_entrepot` int(11) default NULL,
  `qty` double default NULL,
  `rang` int(11) default '0',
  PRIMARY KEY  (`rowid`),
  KEY `idx_expeditiondet_fk_expedition` (`fk_expedition`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_expedition_methode` (
  `rowid` int(11) NOT NULL default '0',
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `code` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `libelle` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `description` text collate utf8_unicode_ci,
  `statut` tinyint(4) default '0',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_export_compta` (
  `rowid` int(11) NOT NULL auto_increment,
  `ref` varchar(12) collate utf8_unicode_ci NOT NULL default '',
  `date_export` datetime NOT NULL default '0000-00-00 00:00:00',
  `fk_user` int(11) NOT NULL default '0',
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_export_model` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_user` int(11) NOT NULL default '0',
  `label` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `type` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  `field` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_export_model` (`label`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_facture` (
  `rowid` int(11) NOT NULL auto_increment,
  `facnumber` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `type` smallint(6) NOT NULL default '0',
  `ref_client` varchar(30) collate utf8_unicode_ci default NULL,
  `increment` varchar(10) collate utf8_unicode_ci default NULL,
  `fk_soc` int(11) NOT NULL default '0',
  `datec` datetime default NULL,
  `datef` date default NULL,
  `date_valid` date default NULL,
  `paye` smallint(6) NOT NULL default '0',
  `amount` double NOT NULL default '0',
  `remise_percent` double default '0',
  `remise_absolue` double default '0',
  `remise` double default '0',
  `close_code` varchar(16) collate utf8_unicode_ci default NULL,
  `close_note` varchar(128) collate utf8_unicode_ci default NULL,
  `tva` double default '0',
  `total` double default '0',
  `total_ttc` double default '0',
  `fk_statut` smallint(6) NOT NULL default '0',
  `fk_user_author` int(11) default NULL,
  `fk_user_valid` int(11) default NULL,
  `fk_facture_source` int(11) default NULL,
  `fk_projet` int(11) default NULL,
  `fk_cond_reglement` int(11) NOT NULL default '1',
  `fk_mode_reglement` int(11) default NULL,
  `date_lim_reglement` date default NULL,
  `note` text collate utf8_unicode_ci,
  `note_public` text collate utf8_unicode_ci,
  `model_pdf` varchar(50) collate utf8_unicode_ci default NULL,
  `import_key` varchar(14) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `idx_facture_uk_facnumber` (`facnumber`),
  KEY `idx_facture_fk_soc` (`fk_soc`),
  KEY `idx_facture_fk_user_author` (`fk_user_author`),
  KEY `idx_facture_fk_user_valid` (`fk_user_valid`),
  KEY `idx_facture_fk_facture_source` (`fk_facture_source`),
  KEY `idx_facture_fk_projet` (`fk_projet`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_facturedet` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_facture` int(11) NOT NULL default '0',
  `fk_product` int(11) default NULL,
  `description` text collate utf8_unicode_ci,
  `tva_taux` double default NULL,
  `qty` double default NULL,
  `remise_percent` double default '0',
  `remise` double default '0',
  `fk_remise_except` int(11) default NULL,
  `subprice` double default NULL,
  `price` double default NULL,
  `total_ht` double default NULL,
  `total_tva` double default NULL,
  `total_ttc` double default NULL,
  `product_type` int(11) default '0',
  `date_start` datetime default NULL,
  `date_end` datetime default NULL,
  `info_bits` int(11) default '0',
  `fk_code_ventilation` int(11) NOT NULL default '0',
  `fk_export_compta` int(11) NOT NULL default '0',
  `special_code` tinyint(4) unsigned default '0',
  `rang` int(11) default '0',
  `import_key` varchar(14) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  KEY `idx_facturedet_fk_facture` (`fk_facture`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_facturedet_rec` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_facture` int(11) NOT NULL default '0',
  `fk_product` int(11) default NULL,
  `description` text collate utf8_unicode_ci,
  `tva_taux` double default '19.6',
  `qty` double default NULL,
  `remise_percent` double default '0',
  `remise` double default '0',
  `subprice` double default NULL,
  `price` double default NULL,
  `total_ht` double default NULL,
  `total_tva` double default NULL,
  `total_ttc` double default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_facture_fourn` (
  `rowid` int(11) NOT NULL auto_increment,
  `facnumber` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `type` smallint(6) NOT NULL default '0',
  `fk_soc` int(11) NOT NULL default '0',
  `datec` datetime default NULL,
  `datef` date default NULL,
  `libelle` varchar(255) collate utf8_unicode_ci default NULL,
  `paye` smallint(6) NOT NULL default '0',
  `amount` double(24,8) NOT NULL default '0.00000000',
  `remise` double(24,8) default '0.00000000',
  `tva` double(24,8) default '0.00000000',
  `total` double(24,8) default '0.00000000',
  `total_ht` double(24,8) default '0.00000000',
  `total_tva` double(24,8) default '0.00000000',
  `total_ttc` double(24,8) default '0.00000000',
  `fk_statut` smallint(6) NOT NULL default '0',
  `fk_user_author` int(11) default NULL,
  `fk_user_valid` int(11) default NULL,
  `fk_projet` int(11) default NULL,
  `fk_cond_reglement` int(11) NOT NULL default '1',
  `date_lim_reglement` date default NULL,
  `note` text collate utf8_unicode_ci,
  `note_public` text collate utf8_unicode_ci,
  `import_key` varchar(14) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_facture_fourn_ref` (`facnumber`,`fk_soc`),
  KEY `idx_facture_fourn_date_lim_reglement` (`date_lim_reglement`),
  KEY `idx_facture_fourn_fk_soc` (`fk_soc`),
  KEY `idx_facture_fourn_fk_user_author` (`fk_user_author`),
  KEY `idx_facture_fourn_fk_user_valid` (`fk_user_valid`),
  KEY `idx_facture_fourn_fk_projet` (`fk_projet`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_facture_fourn_det` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_facture_fourn` int(11) NOT NULL default '0',
  `fk_product` int(11) default NULL,
  `description` text collate utf8_unicode_ci,
  `pu_ht` double(24,8) default NULL,
  `pu_ttc` double(24,8) default NULL,
  `qty` smallint(6) default '1',
  `tva_taux` double(24,8) default '0.00000000',
  `total_ht` double(24,8) default '0.00000000',
  `tva` double(24,8) default '0.00000000',
  `total_ttc` double(24,8) default '0.00000000',
  `product_type` int(11) default '0',
  `import_key` varchar(14) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  KEY `idx_facture_fourn_det_fk_facture` (`fk_facture_fourn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_facture_rec` (
  `rowid` int(11) NOT NULL auto_increment,
  `titre` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `fk_soc` int(11) NOT NULL default '0',
  `datec` datetime default NULL,
  `amount` double NOT NULL default '0',
  `remise` double default '0',
  `remise_percent` double default '0',
  `remise_absolue` double default '0',
  `tva` double default '0',
  `total` double default '0',
  `total_ttc` double default '0',
  `fk_user_author` int(11) default NULL,
  `fk_projet` int(11) default NULL,
  `fk_cond_reglement` int(11) default '0',
  `fk_mode_reglement` int(11) default '0',
  `date_lim_reglement` date default NULL,
  `note` text collate utf8_unicode_ci,
  `note_public` text collate utf8_unicode_ci,
  `frequency` varchar(2) collate utf8_unicode_ci default NULL,
  `last_gen` varchar(7) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `idx_facture_rec_uk_titre` (`titre`),
  KEY `idx_facture_rec_fksoc` (`fk_soc`),
  KEY `idx_facture_rec_fk_soc` (`fk_soc`),
  KEY `idx_facture_rec_fk_user_author` (`fk_user_author`),
  KEY `idx_facture_rec_fk_projet` (`fk_projet`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_facture_stats` (
  `date_full` datetime default NULL,
  `date_day` date default NULL,
  `data` varchar(50) collate utf8_unicode_ci default NULL,
  `value` double default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_fa_pr` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_facture` int(11) default NULL,
  `fk_propal` int(11) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_fichinter` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_soc` int(11) NOT NULL default '0',
  `fk_projet` int(11) default '0',
  `fk_contrat` int(11) default '0',
  `ref` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datec` datetime default NULL,
  `date_valid` datetime default NULL,
  `datei` date default NULL,
  `fk_user_author` int(11) default NULL,
  `fk_user_valid` int(11) default NULL,
  `fk_statut` smallint(6) default '0',
  `duree` double default NULL,
  `description` text collate utf8_unicode_ci,
  `note_private` text collate utf8_unicode_ci,
  `note_public` text collate utf8_unicode_ci,
  `model_pdf` varchar(50) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `ref` (`ref`),
  KEY `idx_fichinter_fk_soc` (`fk_soc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_fichinterdet` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_fichinter` int(11) default NULL,
  `date` datetime default NULL,
  `description` text collate utf8_unicode_ci,
  `duree` int(11) default NULL,
  `rang` int(11) default '0',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_fournisseur_ca` (
  `fk_societe` int(11) default NULL,
  `date_calcul` datetime default NULL,
  `year` smallint(5) unsigned default NULL,
  `ca_genere` float default NULL,
  `ca_achat` float(11,2) default '0.00',
  UNIQUE KEY `fk_societe` (`fk_societe`,`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_groupesociete` (
  `rowid` int(11) NOT NULL auto_increment,
  `parent` int(11) default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datec` datetime default NULL,
  `nom` varchar(60) collate utf8_unicode_ci default NULL,
  `note` text collate utf8_unicode_ci,
  `remise` double default '0',
  `fk_user_author` int(11) default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `parent` (`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_groupesociete_remise` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_groupe` int(11) NOT NULL default '0',
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datec` datetime default NULL,
  `fk_user_author` int(11) default NULL,
  `remise` double default '0',
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_livraison` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ref` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `ref_client` varchar(30) collate utf8_unicode_ci default NULL,
  `fk_soc` int(11) NOT NULL default '0',
  `fk_expedition` int(11) default NULL,
  `date_creation` datetime default NULL,
  `fk_user_author` int(11) default NULL,
  `date_valid` datetime default NULL,
  `fk_user_valid` int(11) default NULL,
  `date_livraison` date default NULL,
  `fk_adresse_livraison` int(11) default NULL,
  `fk_statut` smallint(6) default '0',
  `total_ht` double(24,8) default '0.00000000',
  `note` text collate utf8_unicode_ci,
  `note_public` text collate utf8_unicode_ci,
  `model_pdf` varchar(50) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `idx_livraison_uk_ref` (`ref`),
  KEY `idx_livraison_fk_soc` (`fk_soc`),
  KEY `idx_livraison_fk_user_author` (`fk_user_author`),
  KEY `idx_livraison_fk_user_valid` (`fk_user_valid`),
  KEY `idx_livraison_fk_adresse_livraison` (`fk_adresse_livraison`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `llx_livraisondet` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_livraison` int(11) default NULL,
  `fk_origin_line` int(11) default NULL,
  `fk_product` int(11) default NULL,
  `description` text collate utf8_unicode_ci,
  `qty` double default NULL,
  `subprice` double(24,8) default '0.00000000',
  `total_ht` double(24,8) default '0.00000000',
  `rang` int(11) default '0',
  PRIMARY KEY  (`rowid`),
  KEY `idx_livraisondet_fk_expedition` (`fk_livraison`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_mailing` (
  `rowid` int(11) NOT NULL auto_increment,
  `statut` smallint(6) default '0',
  `titre` varchar(60) collate utf8_unicode_ci default NULL,
  `sujet` varchar(60) collate utf8_unicode_ci default NULL,
  `body` text collate utf8_unicode_ci,
  `cible` varchar(60) collate utf8_unicode_ci default NULL,
  `nbemail` int(11) default NULL,
  `email_from` varchar(160) collate utf8_unicode_ci default NULL,
  `email_replyto` varchar(160) collate utf8_unicode_ci default NULL,
  `email_errorsto` varchar(160) collate utf8_unicode_ci default NULL,
  `date_creat` datetime default NULL,
  `date_valid` datetime default NULL,
  `date_appro` datetime default NULL,
  `date_envoi` datetime default NULL,
  `fk_user_creat` int(11) default NULL,
  `fk_user_valid` int(11) default NULL,
  `fk_user_appro` int(11) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `llx_mailing_cibles` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_mailing` int(11) NOT NULL default '0',
  `fk_contact` int(11) NOT NULL default '0',
  `nom` varchar(160) collate utf8_unicode_ci default NULL,
  `prenom` varchar(160) collate utf8_unicode_ci default NULL,
  `email` varchar(160) collate utf8_unicode_ci NOT NULL default '',
  `statut` smallint(6) NOT NULL default '0',
  `url` varchar(160) collate utf8_unicode_ci default NULL,
  `date_envoi` datetime default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_mailing_cibles` (`fk_mailing`,`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_menu` (
  `rowid` int(11) NOT NULL auto_increment,
  `menu_handler` varchar(16) collate utf8_unicode_ci NOT NULL default '',
  `module` varchar(64) collate utf8_unicode_ci default NULL,
  `type` varchar(4) collate utf8_unicode_ci NOT NULL default '',
  `mainmenu` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `fk_menu` int(11) NOT NULL default '0',
  `position` int(11) NOT NULL default '0',
  `url` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `target` varchar(100) collate utf8_unicode_ci default NULL,
  `titre` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `langs` varchar(100) collate utf8_unicode_ci default NULL,
  `level` tinyint(1) default NULL,
  `leftmenu` char(1) collate utf8_unicode_ci default '1',
  `perms` varchar(255) collate utf8_unicode_ci default NULL,
  `enabled` varchar(255) collate utf8_unicode_ci default '1',
  `user` int(11) NOT NULL default '0',
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `idx_menu_uk_menu` (`menu_handler`,`fk_menu`,`url`),
  KEY `idx_menu_menuhandler_type` (`menu_handler`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_menu_const` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_menu` int(11) NOT NULL default '0',
  `fk_constraint` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_menu_const` (`fk_menu`,`fk_constraint`),
  KEY `idx_menu_const_fk_menu` (`fk_menu`),
  KEY `idx_menu_const_fk_constraint` (`fk_constraint`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_menu_constraint` (
  `rowid` int(11) NOT NULL default '0',
  `action` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_models` (
  `rowid` int(11) NOT NULL auto_increment,
  `module` varchar(32) collate utf8_unicode_ci default NULL,
  `typemodele` varchar(32) collate utf8_unicode_ci default NULL,
  `sortorder` smallint(6) default NULL,
  `private` smallint(6) NOT NULL default '0',
  `fk_user` int(11) default NULL,
  `title` varchar(128) collate utf8_unicode_ci default NULL,
  `filename` varchar(128) collate utf8_unicode_ci default NULL,
  `content` text collate utf8_unicode_ci,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_notify` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `daten` datetime default NULL,
  `fk_action` int(11) NOT NULL default '0',
  `fk_contact` int(11) NOT NULL default '0',
  `objet_type` varchar(24) collate utf8_unicode_ci NOT NULL default '',
  `objet_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_notify_def` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datec` date default NULL,
  `fk_action` int(11) NOT NULL default '0',
  `fk_soc` int(11) NOT NULL default '0',
  `fk_contact` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_osc_categories` (
  `rowid` int(11) unsigned NOT NULL auto_increment,
  `dolicatid` int(11) NOT NULL default '0',
  `osccatid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `dolicatid` (`dolicatid`),
  UNIQUE KEY `osccatid` (`osccatid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Correspondance categorie Dolibarr categorie OSC' AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_osc_customer` (
  `rowid` int(11) NOT NULL default '0',
  `datem` datetime default NULL,
  `fk_soc` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `fk_soc` (`fk_soc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Table transition client OSC - societe Dolibarr'; 

CREATE TABLE IF NOT EXISTS `llx_osc_order` (
  `rowid` int(11) NOT NULL default '0',
  `datem` datetime default NULL,
  `fk_commande` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `fk_commande` (`fk_commande`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Table transition commande OSC - commande Dolibarr'; 

CREATE TABLE IF NOT EXISTS `llx_osc_product` (
  `rowid` int(11) NOT NULL default '0',
  `datem` datetime default NULL,
  `fk_product` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `fk_product` (`fk_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Table transition produit OSC - produit Dolibarr'; 

CREATE TABLE IF NOT EXISTS `llx_paiement` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_facture` int(11) default NULL,
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datep` datetime default NULL,
  `amount` double default '0',
  `fk_paiement` int(11) NOT NULL default '0',
  `num_paiement` varchar(50) collate utf8_unicode_ci default NULL,
  `note` text collate utf8_unicode_ci,
  `fk_bank` int(11) NOT NULL default '0',
  `fk_user_creat` int(11) default NULL,
  `fk_user_modif` int(11) default NULL,
  `statut` smallint(6) NOT NULL default '0',
  `fk_export_compta` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_paiementcharge` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_charge` int(11) default NULL,
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datep` datetime default NULL,
  `amount` double default '0',
  `fk_typepaiement` int(11) NOT NULL default '0',
  `num_paiement` varchar(50) collate utf8_unicode_ci default NULL,
  `note` text collate utf8_unicode_ci,
  `fk_bank` int(11) NOT NULL default '0',
  `fk_user_creat` int(11) default NULL,
  `fk_user_modif` int(11) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_paiementfourn` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datec` datetime default NULL,
  `fk_facture_fourn` int(11) default NULL,
  `datep` datetime default NULL,
  `amount` double default '0',
  `fk_user_author` int(11) default NULL,
  `fk_paiement` int(11) NOT NULL default '0',
  `num_paiement` varchar(50) collate utf8_unicode_ci default NULL,
  `note` text collate utf8_unicode_ci,
  `fk_bank` int(11) NOT NULL default '0',
  `statut` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_paiementfourn_facturefourn` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_paiementfourn` int(11) default NULL,
  `fk_facturefourn` int(11) default NULL,
  `amount` double default '0',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_paiementfourn_facturefourn` (`fk_paiementfourn`,`fk_facturefourn`),
  KEY `idx_paiementfourn_facturefourn_fk_facture` (`fk_facturefourn`),
  KEY `idx_paiementfourn_facturefourn_fk_paiement` (`fk_paiementfourn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_paiement_facture` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_paiement` int(11) default NULL,
  `fk_facture` int(11) default NULL,
  `amount` double default '0',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_paiement_facture` (`fk_paiement`,`fk_facture`),
  KEY `idx_paiement_facture_fk_facture` (`fk_facture`),
  KEY `idx_paiement_facture_fk_paiement` (`fk_paiement`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_prelevement_bons` (
  `rowid` int(11) NOT NULL auto_increment,
  `ref` varchar(12) collate utf8_unicode_ci default NULL,
  `datec` datetime default NULL,
  `amount` double default '0',
  `statut` smallint(6) default '0',
  `credite` smallint(6) default '0',
  `note` text collate utf8_unicode_ci,
  `date_trans` datetime default NULL,
  `method_trans` smallint(6) default NULL,
  `fk_user_trans` int(11) default NULL,
  `date_credit` datetime default NULL,
  `fk_user_credit` int(11) default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `ref` (`ref`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_prelevement_facture` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_facture` int(11) NOT NULL default '0',
  `fk_prelevement_lignes` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  KEY `idx_prelevement_facture_fk_prelevement_lignes` (`fk_prelevement_lignes`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_prelevement_facture_demande` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_facture` int(11) NOT NULL default '0',
  `amount` double NOT NULL default '0',
  `date_demande` datetime NOT NULL default '0000-00-00 00:00:00',
  `traite` smallint(6) default '0',
  `date_traite` datetime default NULL,
  `fk_prelevement_bons` int(11) default NULL,
  `fk_user_demande` int(11) NOT NULL default '0',
  `code_banque` varchar(7) collate utf8_unicode_ci default NULL,
  `code_guichet` varchar(6) collate utf8_unicode_ci default NULL,
  `number` varchar(255) collate utf8_unicode_ci default NULL,
  `cle_rib` varchar(5) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_prelevement_lignes` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_prelevement_bons` int(11) default NULL,
  `fk_soc` int(11) NOT NULL default '0',
  `statut` smallint(6) default '0',
  `client_nom` varchar(255) collate utf8_unicode_ci default NULL,
  `amount` double default '0',
  `code_banque` varchar(7) collate utf8_unicode_ci default NULL,
  `code_guichet` varchar(6) collate utf8_unicode_ci default NULL,
  `number` varchar(255) collate utf8_unicode_ci default NULL,
  `cle_rib` varchar(5) collate utf8_unicode_ci default NULL,
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`),
  KEY `idx_prelevement_lignes_fk_prelevement_bons` (`fk_prelevement_bons`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_prelevement_notifications` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_user` int(11) NOT NULL default '0',
  `action` char(2) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_prelevement_rejet` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_prelevement_lignes` int(11) default NULL,
  `date_rejet` datetime default NULL,
  `motif` int(11) default NULL,
  `date_creation` datetime default NULL,
  `fk_user_creation` int(11) default NULL,
  `note` text collate utf8_unicode_ci,
  `afacturer` tinyint(4) default '0',
  `fk_facture` int(11) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_product` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ref` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `label` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `description` text collate utf8_unicode_ci,
  `note` text collate utf8_unicode_ci,
  `price` double(24,8) default '0.00000000',
  `price_ttc` double(24,8) default '0.00000000',
  `price_min` double(24,8) default '0.00000000',
  `price_min_ttc` double(24,8) default '0.00000000',
  `price_base_type` varchar(3) collate utf8_unicode_ci default 'HT',
  `tva_tx` double(6,3) default NULL,
  `fk_user_author` int(11) default NULL,
  `envente` tinyint(4) default '1',
  `fk_product_type` int(11) default '0',
  `duration` varchar(6) collate utf8_unicode_ci default NULL,
  `stock_propale` int(11) default '0',
  `stock_commande` int(11) default '0',
  `seuil_stock_alerte` int(11) default '0',
  `stock_loc` varchar(10) collate utf8_unicode_ci default NULL,
  `barcode` varchar(255) collate utf8_unicode_ci default NULL,
  `fk_barcode_type` int(11) default '0',
  `partnumber` varchar(32) collate utf8_unicode_ci default NULL,
  `weight` float default NULL,
  `weight_units` tinyint(4) default NULL,
  `volume` float default NULL,
  `volume_units` tinyint(4) default NULL,
  `canvas` varchar(15) collate utf8_unicode_ci default NULL,
  `finished` tinyint(4) default NULL,
  `import_key` varchar(14) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_product_ref` (`ref`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_product_ca` (
  `fk_product` int(11) default NULL,
  `date_calcul` datetime default NULL,
  `year` smallint(5) unsigned default NULL,
  `ca_genere` float default NULL,
  UNIQUE KEY `fk_product` (`fk_product`,`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_product_cnv_livre` (
  `rowid` int(11) NOT NULL default '0',
  `isbn` varchar(13) collate utf8_unicode_ci default NULL,
  `ean` varchar(13) collate utf8_unicode_ci default NULL,
  `format` varchar(7) collate utf8_unicode_ci default NULL,
  `px_feuillet` float(12,4) default NULL,
  `px_reliure` float(12,4) default NULL,
  `px_couverture` float(12,4) default NULL,
  `px_revient` float(12,4) default NULL,
  `stock_loc` varchar(5) collate utf8_unicode_ci default NULL,
  `pages` smallint(5) unsigned default NULL,
  `fk_couverture` int(11) default NULL,
  `fk_contrat` int(11) default NULL,
  `fk_auteur` int(11) default '0',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_product_cnv_livre_contrat` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_cnv_livre` int(11) default NULL,
  `quantite` int(11) default NULL,
  `taux` float(3,2) default NULL,
  `date_app` datetime default NULL,
  `duree` varchar(50) collate utf8_unicode_ci default NULL,
  `fk_user` int(11) default NULL,
  `locked` tinyint(4) default '0',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_product_det` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_product` int(11) NOT NULL default '0',
  `lang` varchar(5) collate utf8_unicode_ci NOT NULL default '0',
  `label` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `description` text collate utf8_unicode_ci,
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_product_fournisseur` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_product` int(11) default NULL,
  `fk_soc` int(11) default NULL,
  `ref_fourn` varchar(30) collate utf8_unicode_ci default NULL,
  `fk_user_author` int(11) default NULL,
  PRIMARY KEY  (`rowid`),
  KEY `idx_product_fourn_fk_product` (`fk_product`),
  KEY `idx_product_fourn_fk_soc` (`fk_soc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_product_fournisseur_price` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_product_fournisseur` int(11) NOT NULL default '0',
  `price` double(24,8) default '0.00000000',
  `quantity` double default NULL,
  `unitprice` double(24,8) default '0.00000000',
  `fk_user` int(11) default NULL,
  PRIMARY KEY  (`rowid`),
  KEY `idx_product_fournisseur_price_fk_user` (`fk_user`),
  KEY `idx_product_fournisseur_price_fk_product_fournisseur` (`fk_product_fournisseur`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_product_fournisseur_price_log` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `fk_product_fournisseur` int(11) NOT NULL default '0',
  `price` double(24,8) default '0.00000000',
  `quantity` double default NULL,
  `fk_user` int(11) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_product_price` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_product` int(11) NOT NULL default '0',
  `date_price` datetime NOT NULL default '0000-00-00 00:00:00',
  `price_level` tinyint(4) default '1',
  `price` double(24,8) default NULL,
  `price_ttc` double(24,8) default NULL,
  `price_min` double(24,8) default NULL,
  `price_min_ttc` double(24,8) default NULL,
  `price_base_type` char(3) collate utf8_unicode_ci default 'HT',
  `tva_tx` double(6,3) NOT NULL default '0.000',
  `fk_user_author` int(11) default NULL,
  `envente` tinyint(4) default '1',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_product_stock` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_product` int(11) NOT NULL default '0',
  `fk_entrepot` int(11) NOT NULL default '0',
  `reel` int(11) default NULL,
  PRIMARY KEY  (`rowid`),
  KEY `idx_product_stock_fk_product` (`fk_product`),
  KEY `idx_product_stock_fk_entrepot` (`fk_entrepot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_product_subproduct` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_product` int(11) NOT NULL default '0',
  `fk_product_subproduct` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `fk_product` (`fk_product`,`fk_product_subproduct`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_projet` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_soc` int(11) default NULL,
  `fk_statut` smallint(6) NOT NULL default '0',
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `dateo` date default NULL,
  `ref` varchar(50) collate utf8_unicode_ci default NULL,
  `title` varchar(255) collate utf8_unicode_ci default NULL,
  `fk_user_resp` int(11) default NULL,
  `fk_user_creat` int(11) default NULL,
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `ref` (`ref`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_projet_task` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_projet` int(11) NOT NULL default '0',
  `fk_task_parent` int(11) NOT NULL default '0',
  `title` varchar(255) collate utf8_unicode_ci default NULL,
  `duration_effective` double NOT NULL default '0',
  `fk_user_creat` int(11) default NULL,
  `statut` varchar(6) collate utf8_unicode_ci default 'open',
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_projet_task_actors` (
  `fk_projet_task` int(11) NOT NULL default '0',
  `fk_user` int(11) NOT NULL default '0',
  `role` varchar(5) collate utf8_unicode_ci default 'admin',
  UNIQUE KEY `fk_projet_task` (`fk_projet_task`,`fk_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_projet_task_time` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_task` int(11) NOT NULL default '0',
  `task_date` date default NULL,
  `task_duration` double default NULL,
  `fk_user` int(11) default NULL,
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_propal` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_soc` int(11) default NULL,
  `fk_projet` int(11) default '0',
  `ref` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `ref_client` varchar(30) collate utf8_unicode_ci default NULL,
  `datec` datetime default NULL,
  `datep` date default NULL,
  `fin_validite` datetime default NULL,
  `date_valid` datetime default NULL,
  `date_cloture` datetime default NULL,
  `fk_user_author` int(11) default NULL,
  `fk_user_valid` int(11) default NULL,
  `fk_user_cloture` int(11) default NULL,
  `fk_statut` smallint(6) NOT NULL default '0',
  `price` double default '0',
  `remise_percent` double default '0',
  `remise_absolue` double default '0',
  `remise` double default '0',
  `total_ht` double(24,8) default '0.00000000',
  `tva` double(24,8) default '0.00000000',
  `total` double(24,8) default '0.00000000',
  `fk_cond_reglement` int(11) default NULL,
  `fk_mode_reglement` int(11) default NULL,
  `note` text collate utf8_unicode_ci,
  `note_public` text collate utf8_unicode_ci,
  `model_pdf` varchar(50) collate utf8_unicode_ci default NULL,
  `date_livraison` date default NULL,
  `fk_adresse_livraison` int(11) default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `ref` (`ref`),
  KEY `idx_propal_fk_soc` (`fk_soc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_propaldet` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_propal` int(11) default NULL,
  `fk_product` int(11) default NULL,
  `description` text collate utf8_unicode_ci,
  `fk_remise_except` int(11) default NULL,
  `tva_tx` double(6,3) default '0.000',
  `qty` double default NULL,
  `remise_percent` double default '0',
  `remise` double default '0',
  `price` double default NULL,
  `subprice` double(24,8) default '0.00000000',
  `total_ht` double(24,8) default '0.00000000',
  `total_tva` double(24,8) default '0.00000000',
  `total_ttc` double(24,8) default '0.00000000',
  `info_bits` int(11) default '0',
  `pa_ht` double(24,8) default '0.00000000',
  `marge_tx` double(6,3) default '0.000',
  `marque_tx` double(6,3) default '0.000',
  `special_code` tinyint(4) unsigned default '0',
  `rang` int(11) default '0',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_pr_exp` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_propal` int(11) NOT NULL default '0',
  `fk_expedition` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  KEY `fk_propal` (`fk_propal`),
  KEY `fk_expedition` (`fk_expedition`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_pr_liv` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_propal` int(11) NOT NULL default '0',
  `fk_livraison` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  KEY `fk_propal` (`fk_propal`),
  KEY `fk_livraison` (`fk_livraison`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_rights_def` (
  `id` int(11) NOT NULL default '0',
  `libelle` varchar(255) collate utf8_unicode_ci default NULL,
  `module` varchar(12) collate utf8_unicode_ci default NULL,
  `perms` varchar(50) collate utf8_unicode_ci default NULL,
  `subperms` varchar(50) collate utf8_unicode_ci default NULL,
  `type` char(1) collate utf8_unicode_ci default NULL,
  `bydefault` tinyint(4) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_societe` (
  `rowid` int(11) NOT NULL auto_increment,
  `statut` tinyint(4) default '0',
  `parent` int(11) default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datec` datetime default NULL,
  `datea` datetime default NULL,
  `nom` varchar(60) collate utf8_unicode_ci default NULL,
  `code_client` varchar(15) collate utf8_unicode_ci default NULL,
  `code_fournisseur` varchar(15) collate utf8_unicode_ci default NULL,
  `code_compta` varchar(15) collate utf8_unicode_ci default NULL,
  `code_compta_fournisseur` varchar(15) collate utf8_unicode_ci default NULL,
  `address` varchar(255) collate utf8_unicode_ci default NULL,
  `cp` varchar(10) collate utf8_unicode_ci default NULL,
  `ville` varchar(50) collate utf8_unicode_ci default NULL,
  `fk_departement` int(11) default '0',
  `fk_pays` int(11) default '0',
  `tel` varchar(20) collate utf8_unicode_ci default NULL,
  `fax` varchar(20) collate utf8_unicode_ci default NULL,
  `url` varchar(255) collate utf8_unicode_ci default NULL,
  `email` varchar(128) collate utf8_unicode_ci default NULL,
  `fk_secteur` int(11) default '0',
  `fk_effectif` int(11) default '0',
  `fk_typent` int(11) default '0',
  `fk_forme_juridique` int(11) default '0',
  `siren` varchar(16) collate utf8_unicode_ci default NULL,
  `siret` varchar(16) collate utf8_unicode_ci default NULL,
  `ape` varchar(16) collate utf8_unicode_ci default NULL,
  `idprof4` varchar(16) collate utf8_unicode_ci default NULL,
  `tva_intra` varchar(20) collate utf8_unicode_ci default NULL,
  `capital` double default NULL,
  `description` text collate utf8_unicode_ci,
  `fk_stcomm` smallint(6) default '0',
  `note` text collate utf8_unicode_ci,
  `services` tinyint(4) default '0',
  `prefix_comm` varchar(5) collate utf8_unicode_ci default NULL,
  `client` tinyint(4) default '0',
  `fournisseur` tinyint(4) default '0',
  `supplier_account` varchar(32) collate utf8_unicode_ci default NULL,
  `fk_prospectlevel` varchar(12) collate utf8_unicode_ci default NULL,
  `customer_bad` tinyint(4) default '0',
  `customer_rate` double default '0',
  `supplier_rate` double default '0',
  `rubrique` varchar(255) collate utf8_unicode_ci default NULL,
  `fk_user_creat` int(11) default NULL,
  `fk_user_modif` int(11) default NULL,
  `remise_client` double default '0',
  `mode_reglement` tinyint(4) default NULL,
  `cond_reglement` tinyint(4) default NULL,
  `tva_assuj` tinyint(4) default '1',
  `gencod` varchar(255) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_societe_prefix_comm` (`prefix_comm`),
  UNIQUE KEY `uk_societe_code_client` (`code_client`),
  KEY `idx_societe_user_creat` (`fk_user_creat`),
  KEY `idx_societe_user_modif` (`fk_user_modif`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_societe_adresse_livraison` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `label` varchar(30) collate utf8_unicode_ci default NULL,
  `fk_societe` int(11) default '0',
  `nom` varchar(60) collate utf8_unicode_ci default NULL,
  `address` varchar(255) collate utf8_unicode_ci default NULL,
  `cp` varchar(10) collate utf8_unicode_ci default NULL,
  `ville` varchar(50) collate utf8_unicode_ci default NULL,
  `fk_pays` int(11) default '0',
  `tel` varchar(20) collate utf8_unicode_ci default NULL,
  `fax` varchar(20) collate utf8_unicode_ci default NULL,
  `note` text collate utf8_unicode_ci,
  `fk_user_creat` int(11) default NULL,
  `fk_user_modif` int(11) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_societe_commerciaux` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_soc` int(11) default NULL,
  `fk_user` int(11) default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `fk_soc` (`fk_soc`,`fk_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_societe_log` (
  `id` int(11) NOT NULL auto_increment,
  `datel` datetime default NULL,
  `fk_soc` int(11) default NULL,
  `fk_statut` int(11) default NULL,
  `fk_user` int(11) default NULL,
  `author` varchar(30) collate utf8_unicode_ci default NULL,
  `label` varchar(128) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_societe_prices` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_soc` int(11) default '0',
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datec` datetime default NULL,
  `fk_user_author` int(11) default NULL,
  `price_level` tinyint(4) default '1',
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_societe_remise` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_soc` int(11) NOT NULL default '0',
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datec` datetime default NULL,
  `fk_user_author` int(11) default NULL,
  `remise_client` double default '0',
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_societe_remise_except` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_soc` int(11) NOT NULL default '0',
  `datec` datetime default NULL,
  `amount_ht` double(24,8) NOT NULL default '0.00000000',
  `amount_tva` double(24,8) NOT NULL default '0.00000000',
  `amount_ttc` double(24,8) NOT NULL default '0.00000000',
  `tva_tx` double(6,3) NOT NULL default '0.000',
  `fk_user` int(11) NOT NULL default '0',
  `fk_facture_line` int(11) default NULL,
  `fk_facture` int(11) default NULL,
  `fk_facture_source` int(11) default NULL,
  `description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`rowid`),
  KEY `idx_societe_remise_except_fk_user` (`fk_user`),
  KEY `idx_societe_remise_except_fk_soc` (`fk_soc`),
  KEY `idx_societe_remise_except_fk_facture_line` (`fk_facture_line`),
  KEY `idx_societe_remise_except_fk_facture` (`fk_facture`),
  KEY `idx_societe_remise_except_fk_facture_source` (`fk_facture_source`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_societe_rib` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_soc` int(11) NOT NULL default '0',
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `label` varchar(30) collate utf8_unicode_ci default NULL,
  `bank` varchar(255) collate utf8_unicode_ci default NULL,
  `code_banque` varchar(7) collate utf8_unicode_ci default NULL,
  `code_guichet` varchar(6) collate utf8_unicode_ci default NULL,
  `number` varchar(255) collate utf8_unicode_ci default NULL,
  `cle_rib` varchar(5) collate utf8_unicode_ci default NULL,
  `bic` varchar(10) collate utf8_unicode_ci default NULL,
  `iban_prefix` varchar(5) collate utf8_unicode_ci default NULL,
  `domiciliation` varchar(255) collate utf8_unicode_ci default NULL,
  `proprio` varchar(60) collate utf8_unicode_ci default NULL,
  `adresse_proprio` varchar(255) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_socpeople` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `fk_soc` int(11) default NULL,
  `civilite` varchar(6) collate utf8_unicode_ci default NULL,
  `name` varchar(50) collate utf8_unicode_ci default NULL,
  `firstname` varchar(50) collate utf8_unicode_ci default NULL,
  `address` varchar(255) collate utf8_unicode_ci default NULL,
  `cp` varchar(25) collate utf8_unicode_ci default NULL,
  `ville` varchar(255) collate utf8_unicode_ci default NULL,
  `fk_pays` int(11) default '0',
  `birthday` date default NULL,
  `poste` varchar(80) collate utf8_unicode_ci default NULL,
  `phone` varchar(30) collate utf8_unicode_ci default NULL,
  `phone_perso` varchar(30) collate utf8_unicode_ci default NULL,
  `phone_mobile` varchar(30) collate utf8_unicode_ci default NULL,
  `fax` varchar(30) collate utf8_unicode_ci default NULL,
  `email` varchar(255) collate utf8_unicode_ci default NULL,
  `jabberid` varchar(255) collate utf8_unicode_ci default NULL,
  `priv` smallint(6) NOT NULL default '0',
  `fk_user_creat` int(11) default '0',
  `fk_user_modif` int(11) default NULL,
  `note` text collate utf8_unicode_ci,
  `import_key` varchar(14) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  KEY `idx_socpeople_fk_soc` (`fk_soc`),
  KEY `idx_socpeople_fk_user_creat` (`fk_user_creat`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_stock_mouvement` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datem` datetime default NULL,
  `fk_product` int(11) NOT NULL default '0',
  `fk_entrepot` int(11) NOT NULL default '0',
  `value` int(11) default NULL,
  `price` float(13,4) default '0.0000',
  `type_mouvement` smallint(6) default NULL,
  `fk_user_author` int(11) default NULL,
  PRIMARY KEY  (`rowid`),
  KEY `idx_stock_mouvement_fk_product` (`fk_product`),
  KEY `idx_stock_mouvement_fk_entrepot` (`fk_entrepot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_stock_valorisation` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `date_valo` datetime default NULL,
  `fk_product` int(11) NOT NULL default '0',
  `qty_ope` float(9,3) default NULL,
  `price_ope` float(12,4) default NULL,
  `valo_ope` float(12,4) default NULL,
  `price_pmp` float(12,4) default NULL,
  `qty_stock` float(9,3) default '0.000',
  `valo_pmp` float(12,4) default NULL,
  `fk_stock_mouvement` int(11) default NULL,
  PRIMARY KEY  (`rowid`),
  KEY `idx_stock_valorisation_fk_product` (`fk_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_surveys_answers` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_question` int(11) NOT NULL default '0',
  `ip_adresse` varchar(15) collate utf8_unicode_ci NOT NULL default '',
  `datec` date NOT NULL default '0000-00-00',
  `rep1` decimal(6,0) default NULL,
  `rep2` decimal(6,0) default NULL,
  `rep3` decimal(6,0) default NULL,
  `rep4` decimal(6,0) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_surveys_answers_summary` (
  `fk_question` int(11) NOT NULL default '0',
  `nb_rep1` decimal(10,0) NOT NULL default '0',
  `nb_rep2` decimal(10,0) default NULL,
  `nb_rep3` decimal(10,0) default NULL,
  `nb_rep4` decimal(10,0) default NULL,
  `tot_rep1` decimal(10,0) NOT NULL default '0',
  `tot_rep2` decimal(10,0) default NULL,
  `tot_rep3` decimal(10,0) default NULL,
  `tot_rep4` decimal(10,0) default NULL,
  PRIMARY KEY  (`fk_question`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_surveys_questions` (
  `rowid` int(11) NOT NULL auto_increment,
  `type_question` decimal(1,0) NOT NULL default '0',
  `group_question` varchar(16) collate utf8_unicode_ci NOT NULL default 'NONE',
  `status` decimal(1,0) NOT NULL default '0',
  `lib` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `lib_rep1` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `lib_rep2` varchar(100) collate utf8_unicode_ci default NULL,
  `lib_rep3` varchar(100) collate utf8_unicode_ci default NULL,
  `lib_rep4` varchar(100) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_transaction_bplc` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ipclient` varchar(20) collate utf8_unicode_ci default NULL,
  `num_transaction` varchar(10) collate utf8_unicode_ci default NULL,
  `date_transaction` varchar(10) collate utf8_unicode_ci default NULL,
  `heure_transaction` varchar(10) collate utf8_unicode_ci default NULL,
  `num_autorisation` varchar(10) collate utf8_unicode_ci default NULL,
  `cle_acceptation` varchar(5) collate utf8_unicode_ci default NULL,
  `code_retour` int(11) default NULL,
  `ref_commande` int(11) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_tva` (
  `rowid` int(11) NOT NULL auto_increment,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `datep` date default NULL,
  `datev` date default NULL,
  `amount` double NOT NULL default '0',
  `label` varchar(255) collate utf8_unicode_ci default NULL,
  `note` text collate utf8_unicode_ci,
  `fk_bank` int(11) default NULL,
  `fk_user_creat` int(11) default NULL,
  `fk_user_modif` int(11) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_user` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `login` varchar(24) collate utf8_unicode_ci NOT NULL default '',
  `pass` varchar(32) collate utf8_unicode_ci default NULL,
  `pass_crypted` varchar(128) collate utf8_unicode_ci default NULL,
  `pass_temp` varchar(32) collate utf8_unicode_ci default NULL,
  `name` varchar(50) collate utf8_unicode_ci default NULL,
  `firstname` varchar(50) collate utf8_unicode_ci default NULL,
  `office_phone` varchar(20) collate utf8_unicode_ci default NULL,
  `office_fax` varchar(20) collate utf8_unicode_ci default NULL,
  `user_mobile` varchar(20) collate utf8_unicode_ci default NULL,
  `email` varchar(255) collate utf8_unicode_ci default NULL,
  `admin` smallint(6) default '0',
  `webcal_login` varchar(25) collate utf8_unicode_ci default NULL,
  `phenix_login` varchar(25) collate utf8_unicode_ci default NULL,
  `phenix_pass` varchar(128) collate utf8_unicode_ci default NULL,
  `module_comm` smallint(6) default '1',
  `module_compta` smallint(6) default '1',
  `fk_societe` int(11) default NULL,
  `fk_socpeople` int(11) default NULL,
  `fk_member` int(11) default NULL,
  `note` text collate utf8_unicode_ci,
  `datelastlogin` datetime default NULL,
  `datepreviouslogin` datetime default NULL,
  `egroupware_id` int(11) default NULL,
  `ldap_sid` varchar(255) collate utf8_unicode_ci default NULL,
  `statut` tinyint(4) default '1',
  `lang` varchar(6) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_user_login` (`login`),
  UNIQUE KEY `uk_user_fk_socpeople` (`fk_socpeople`),
  UNIQUE KEY `uk_user_fk_member` (`fk_member`),
  KEY `uk_user_fk_societe` (`fk_societe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; 

CREATE TABLE IF NOT EXISTS `llx_usergroup` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `nom` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `nom` (`nom`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_usergroup_rights` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_usergroup` int(11) NOT NULL default '0',
  `fk_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `fk_usergroup` (`fk_usergroup`,`fk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_usergroup_user` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_user` int(11) NOT NULL default '0',
  `fk_usergroup` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `fk_user` (`fk_user`,`fk_usergroup`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_user_alert` (
  `rowid` int(11) NOT NULL auto_increment,
  `type` int(11) default NULL,
  `fk_contact` int(11) default NULL,
  `fk_user` int(11) default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_user_clicktodial` (
  `fk_user` int(11) NOT NULL default '0',
  `login` varchar(32) collate utf8_unicode_ci default NULL,
  `pass` varchar(64) collate utf8_unicode_ci default NULL,
  `poste` varchar(20) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`fk_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_user_entrepot` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_entrepot` int(10) unsigned default NULL,
  `fk_user` int(10) unsigned default NULL,
  `consult` tinyint(1) unsigned default NULL,
  `send` tinyint(1) unsigned default NULL,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_user_param` (
  `fk_user` int(11) NOT NULL default '0',
  `page` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `param` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `value` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  UNIQUE KEY `fk_user` (`fk_user`,`page`,`param`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

CREATE TABLE IF NOT EXISTS `llx_user_rights` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_user` int(11) NOT NULL default '0',
  `fk_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `fk_user` (`fk_user`,`fk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_voyage` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `dateo` date default NULL,
  `date_depart` datetime default NULL,
  `date_arrivee` datetime default NULL,
  `amount` double NOT NULL default '0',
  `reduction` double NOT NULL default '0',
  `depart` varchar(255) collate utf8_unicode_ci default NULL,
  `arrivee` varchar(255) collate utf8_unicode_ci default NULL,
  `fk_type` smallint(6) default NULL,
  `fk_reduc` int(11) default NULL,
  `distance` int(11) default NULL,
  `dossier` varchar(50) collate utf8_unicode_ci default NULL,
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `llx_voyage_reduc` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `datev` date default NULL,
  `date_debut` date default NULL,
  `date_fin` date default NULL,
  `amount` double NOT NULL default '0',
  `label` varchar(255) collate utf8_unicode_ci default NULL,
  `numero` varchar(255) collate utf8_unicode_ci default NULL,
  `fk_type` smallint(6) default NULL,
  `note` text collate utf8_unicode_ci,
  PRIMARY KEY  (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; 
ALTER TABLE `llx_accountingaccount`
  ADD CONSTRAINT `fk_accountingaccount_fk_pcg_version` FOREIGN KEY (`fk_pcg_version`) REFERENCES `llx_accountingsystem` (`pcg_version`); 
ALTER TABLE `llx_boxes`
  ADD CONSTRAINT `fk_boxes_box_id` FOREIGN KEY (`box_id`) REFERENCES `llx_boxes_def` (`rowid`); 
ALTER TABLE `llx_categorie_association`
  ADD CONSTRAINT `fk_categorie_asso_fk_categorie_fille` FOREIGN KEY (`fk_categorie_fille`) REFERENCES `llx_categorie` (`rowid`),
  ADD CONSTRAINT `fk_categorie_asso_fk_categorie_mere` FOREIGN KEY (`fk_categorie_mere`) REFERENCES `llx_categorie` (`rowid`); 
ALTER TABLE `llx_categorie_product`
  ADD CONSTRAINT `fk_categorie_product_categorie_rowid` FOREIGN KEY (`fk_categorie`) REFERENCES `llx_categorie` (`rowid`),
  ADD CONSTRAINT `fk_categorie_product_product_rowid` FOREIGN KEY (`fk_product`) REFERENCES `llx_product` (`rowid`); 
ALTER TABLE `llx_categorie_societe`
  ADD CONSTRAINT `fk_categorie_societe_categorie_rowid` FOREIGN KEY (`fk_categorie`) REFERENCES `llx_categorie` (`rowid`),
  ADD CONSTRAINT `fk_categorie_societe_fk_soc` FOREIGN KEY (`fk_societe`) REFERENCES `llx_societe` (`rowid`);
ALTER TABLE `llx_commande`
  ADD CONSTRAINT `fk_commande_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`); 
ALTER TABLE `llx_commandedet`
  ADD CONSTRAINT `fk_commandedet_fk_commande` FOREIGN KEY (`fk_commande`) REFERENCES `llx_commande` (`rowid`); 
ALTER TABLE `llx_commande_fournisseur`
  ADD CONSTRAINT `fk_commande_fournisseur_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`); 
ALTER TABLE `llx_contrat`
  ADD CONSTRAINT `fk_contrat_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  ADD CONSTRAINT `fk_contrat_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `llx_user` (`rowid`); 
ALTER TABLE `llx_contratdet`
  ADD CONSTRAINT `fk_contratdet_fk_contrat` FOREIGN KEY (`fk_contrat`) REFERENCES `llx_contrat` (`rowid`),
  ADD CONSTRAINT `fk_contratdet_fk_product` FOREIGN KEY (`fk_product`) REFERENCES `llx_product` (`rowid`); 
ALTER TABLE `llx_contratdet_log`
  ADD CONSTRAINT `fk_contratdet_log_fk_contratdet` FOREIGN KEY (`fk_contratdet`) REFERENCES `llx_contratdet` (`rowid`); 
ALTER TABLE `llx_c_regions`
  ADD CONSTRAINT `fk_c_regions_fk_pays` FOREIGN KEY (`fk_pays`) REFERENCES `llx_c_pays` (`rowid`); 
ALTER TABLE `llx_element_contact`
  ADD CONSTRAINT `fk_element_contact_fk_c_type_contact` FOREIGN KEY (`fk_c_type_contact`) REFERENCES `llx_c_type_contact` (`rowid`); 
ALTER TABLE `llx_expedition`
  ADD CONSTRAINT `fk_expedition_fk_adresse_livraison` FOREIGN KEY (`fk_adresse_livraison`) REFERENCES `llx_societe_adresse_livraison` (`rowid`),
  ADD CONSTRAINT `fk_expedition_fk_expedition_methode` FOREIGN KEY (`fk_expedition_methode`) REFERENCES `llx_expedition_methode` (`rowid`),
  ADD CONSTRAINT `fk_expedition_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  ADD CONSTRAINT `fk_expedition_fk_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `llx_user` (`rowid`),
  ADD CONSTRAINT `fk_expedition_fk_user_valid` FOREIGN KEY (`fk_user_valid`) REFERENCES `llx_user` (`rowid`); 
ALTER TABLE `llx_expeditiondet`
  ADD CONSTRAINT `fk_expeditiondet_fk_expedition` FOREIGN KEY (`fk_expedition`) REFERENCES `llx_expedition` (`rowid`); 
ALTER TABLE `llx_facture`
  ADD CONSTRAINT `fk_facture_fk_facture_source` FOREIGN KEY (`fk_facture_source`) REFERENCES `llx_facture` (`rowid`),
  ADD CONSTRAINT `fk_facture_fk_projet` FOREIGN KEY (`fk_projet`) REFERENCES `llx_projet` (`rowid`),
  ADD CONSTRAINT `fk_facture_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  ADD CONSTRAINT `fk_facture_fk_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `llx_user` (`rowid`),
  ADD CONSTRAINT `fk_facture_fk_user_valid` FOREIGN KEY (`fk_user_valid`) REFERENCES `llx_user` (`rowid`); 
ALTER TABLE `llx_facturedet`
  ADD CONSTRAINT `fk_facturedet_fk_facture` FOREIGN KEY (`fk_facture`) REFERENCES `llx_facture` (`rowid`); 
ALTER TABLE `llx_facture_fourn`
  ADD CONSTRAINT `fk_facture_fourn_fk_projet` FOREIGN KEY (`fk_projet`) REFERENCES `llx_projet` (`rowid`),
  ADD CONSTRAINT `fk_facture_fourn_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  ADD CONSTRAINT `fk_facture_fourn_fk_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `llx_user` (`rowid`),
  ADD CONSTRAINT `fk_facture_fourn_fk_user_valid` FOREIGN KEY (`fk_user_valid`) REFERENCES `llx_user` (`rowid`); 
ALTER TABLE `llx_facture_fourn_det`
  ADD CONSTRAINT `fk_facture_fourn_det_fk_facture` FOREIGN KEY (`fk_facture_fourn`) REFERENCES `llx_facture_fourn` (`rowid`); 
ALTER TABLE `llx_facture_rec`
  ADD CONSTRAINT `fk_facture_rec_fk_projet` FOREIGN KEY (`fk_projet`) REFERENCES `llx_projet` (`rowid`),
  ADD CONSTRAINT `fk_facture_rec_fk_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `llx_user` (`rowid`); 
ALTER TABLE `llx_fichinter`
  ADD CONSTRAINT `fk_fichinter_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`); 
ALTER TABLE `llx_livraison`
  ADD CONSTRAINT `fk_livraison_fk_adresse_livraison` FOREIGN KEY (`fk_adresse_livraison`) REFERENCES `llx_societe_adresse_livraison` (`rowid`),
  ADD CONSTRAINT `fk_livraison_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  ADD CONSTRAINT `fk_livraison_fk_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `llx_user` (`rowid`),
  ADD CONSTRAINT `fk_livraison_fk_user_valid` FOREIGN KEY (`fk_user_valid`) REFERENCES `llx_user` (`rowid`); 
ALTER TABLE `llx_livraisondet`
  ADD CONSTRAINT `fk_livraisondet_fk_livraison` FOREIGN KEY (`fk_livraison`) REFERENCES `llx_livraison` (`rowid`); 
ALTER TABLE `llx_menu_const`
  ADD CONSTRAINT `fk_menu_const_fk_constraint` FOREIGN KEY (`fk_constraint`) REFERENCES `llx_menu_constraint` (`rowid`),
  ADD CONSTRAINT `fk_menu_const_fk_menu` FOREIGN KEY (`fk_menu`) REFERENCES `llx_menu` (`rowid`); 
ALTER TABLE `llx_osc_customer`
  ADD CONSTRAINT `fk_osc_customer_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`); 
ALTER TABLE `llx_paiement_facture`
  ADD CONSTRAINT `fk_paiement_facture_fk_facture` FOREIGN KEY (`fk_facture`) REFERENCES `llx_facture` (`rowid`),
  ADD CONSTRAINT `fk_paiement_facture_fk_paiement` FOREIGN KEY (`fk_paiement`) REFERENCES `llx_paiement` (`rowid`); 
ALTER TABLE `llx_prelevement_facture`
  ADD CONSTRAINT `fk_prelevement_facture_fk_prelevement_lignes` FOREIGN KEY (`fk_prelevement_lignes`) REFERENCES `llx_prelevement_lignes` (`rowid`); 
ALTER TABLE `llx_prelevement_lignes`
  ADD CONSTRAINT `fk_prelevement_lignes_fk_prelevement_bons` FOREIGN KEY (`fk_prelevement_bons`) REFERENCES `llx_prelevement_bons` (`rowid`); 
ALTER TABLE `llx_product_fournisseur_price`
  ADD CONSTRAINT `fk_product_fournisseur_price_fk_product_fournisseur` FOREIGN KEY (`fk_product_fournisseur`) REFERENCES `llx_product_fournisseur` (`rowid`),
  ADD CONSTRAINT `fk_product_fournisseur_price_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`); 
ALTER TABLE `llx_propal`
  ADD CONSTRAINT `fk_propal_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`); 
ALTER TABLE `llx_societe_remise_except`
  ADD CONSTRAINT `fk_societe_remise_fk_facture` FOREIGN KEY (`fk_facture`) REFERENCES `llx_facture` (`rowid`),
  ADD CONSTRAINT `fk_societe_remise_fk_facture_line` FOREIGN KEY (`fk_facture_line`) REFERENCES `llx_facturedet` (`rowid`),
  ADD CONSTRAINT `fk_societe_remise_fk_facture_source` FOREIGN KEY (`fk_facture_source`) REFERENCES `llx_facture` (`rowid`),
  ADD CONSTRAINT `fk_societe_remise_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  ADD CONSTRAINT `fk_societe_remise_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`); 
ALTER TABLE `llx_socpeople`
  ADD CONSTRAINT `fk_socpeople_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  ADD CONSTRAINT `fk_socpeople_user_creat_user_rowid` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`); 
ALTER TABLE `llx_usergroup_rights`
  ADD CONSTRAINT `fk_usergroup_rights_fk_usergroup` FOREIGN KEY (`fk_usergroup`) REFERENCES `llx_usergroup` (`rowid`); 
ALTER TABLE `llx_user_rights`
  ADD CONSTRAINT `fk_user_rights_fk_user_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`);