SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Structure de la table `client`
--

CREATE TABLE IF NOT EXISTS `client` (
  `id` int(11) NOT NULL auto_increment,
  `cl_nom` varchar(50) NOT NULL default '',
  `cl_prenom` varchar(50) NOT NULL default '',
  `cl_adresse` varchar(150) NOT NULL default '',
  `cl_code_postal` varchar(5) NOT NULL default '',
  `cl_ville` varchar(100) NOT NULL default '',
  `cl_tel` varchar(20) NOT NULL default '',
  `cl_mail` varchar(50) NOT NULL default '',
  `cl_passwd` varchar(10) NOT NULL default '',
  `cl_date_creation` varchar(10) NOT NULL default '0',
  `cl_civilites` varchar(30) NOT NULL,
  `old_id` bigint(20) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `cl_mail` (`cl_mail`),
  KEY `cl_nom` (`cl_nom`),
  KEY `cl_code_postal` (`cl_code_postal`),
  KEY `cl_passwd` (`cl_passwd`),
  KEY `cl_date_creation` (`cl_date_creation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Structure de la table `dossier`
--

CREATE TABLE IF NOT EXISTS `dossier` (
  `id` bigint(20) NOT NULL auto_increment,
  `id_client` bigint(20) NOT NULL,
  `d_denom` varchar(100) NOT NULL,
  `d_type` varchar(30) NOT NULL,
  `d_adresse` varchar(255) NOT NULL,
  `d_code` varchar(10) NOT NULL,
  `d_ville` varchar(150) NOT NULL,
  `d_num_rcs` varchar(20) NOT NULL,
  `d_ville_rcs` varchar(150) NOT NULL,
  `d_capital` float NOT NULL,
  `d_nb_part` int(11) NOT NULL,
  `d_prix_part` float NOT NULL,
  `d_duree_soc` int(11) NOT NULL,
  `d_date_immatriculation` varchar(10) NOT NULL,
  `d_date_arret_activite` varchar(10) NOT NULL,
  `d_date_dissolution` varchar(10) NOT NULL,
  `d_date_cloture_liquidation` varchar(10) NOT NULL,
  `d_date_dossier` varchar(10) NOT NULL,
  `d_denom_change` varchar(150) NOT NULL,
  `d_adresse_change` varchar(255) NOT NULL,
  `d_code_change` varchar(10) NOT NULL,
  `d_ville_change` varchar(150) NOT NULL,
  `d_ville_rcs_change` varchar(20) NOT NULL,
  `d_capital_change` float NOT NULL,
  `chk_d_denom` tinyint(1) NOT NULL,
  `chk_d_adresse` tinyint(1) NOT NULL,
  `chk_d_ville_rcs` tinyint(1) NOT NULL,
  `chk_d_capital` tinyint(1) NOT NULL,
  `d_date_creation` varchar(10) NOT NULL,
  `d_paye` tinyint(4) NOT NULL,
  `d_date_paye` varchar(10) NOT NULL,
  `d_kbis` tinyint(4) NOT NULL,
  `d_numfact` bigint(20) NOT NULL,
  `d_activites` text NOT NULL,
  `chk_d_activites` tinyint(4) NOT NULL,
  `d_activites_change` text NOT NULL,
  `d_solde` varchar(50) NOT NULL,
  `d_etat_des_sieges` text NOT NULL,
  `etape_kbis` tinyint(4) NOT NULL,
  `etape_dpad` tinyint(4) NOT NULL,
  `date_expedition_dossier` varchar(10) NOT NULL,
  `env_al` varchar(10) NOT NULL,
  `ret_al` varchar(10) NOT NULL,
  `env_impot` varchar(10) NOT NULL,
  `ret_impot` varchar(10) NOT NULL,
  `env_greffe` varchar(10) NOT NULL,
  `ret_greffe` varchar(10) NOT NULL,
  `etape3_ok` tinyint(4) NOT NULL,
  `div_kbis` varchar(10) NOT NULL,
  `div_assemblee` varchar(10) NOT NULL,
  `div_anle` varchar(10) NOT NULL,
  `d_sigle` varchar(200) NOT NULL,
  `chk_d_sigle` tinyint(4) NOT NULL,
  `d_sigle_change` varchar(200) NOT NULL,
  `d_type_capital` varchar(100) NOT NULL,
  `d_cause` tinyint(4) NOT NULL,
  `d_siren` varchar(100) NOT NULL,
  `d_express` tinyint(4) NOT NULL,
  `d_enseigne` varchar(150) NOT NULL,
  `d_enseigne_change` varchar(150) NOT NULL,
  `chk_d_enseigne` tinyint(4) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `d_denom` (`d_denom`),
  KEY `id_client` (`id_client`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Structure de la table `participant`
--

CREATE TABLE IF NOT EXISTS `participant` (
  `id` bigint(20) NOT NULL auto_increment,
  `id_dossier` bigint(20) NOT NULL,
  `id_client` bigint(20) NOT NULL,
  `p_gerant` tinyint(4) NOT NULL,
  `p_gerant_non_associe` tinyint(4) NOT NULL,
  `p_etat_civil` varchar(30) NOT NULL,
  `p_nom` varchar(100) NOT NULL,
  `p_prenom` varchar(100) NOT NULL,
  `p_adresse` varchar(255) NOT NULL,
  `p_code` varchar(10) NOT NULL,
  `p_ville` varchar(150) NOT NULL,
  `p_date_naissance` varchar(10) NOT NULL,
  `p_lieu_naissance` varchar(150) NOT NULL,
  `p_nationalite` varchar(150) NOT NULL,
  `p_situation_famille` varchar(20) NOT NULL,
  `p_nom_jeune_fille` varchar(100) NOT NULL,
  `p_nb_part` bigint(20) NOT NULL,
  `pc_nom_naissance` varchar(150) NOT NULL,
  `pc_nom_usage` varchar(150) NOT NULL,
  `pc_prenom` varchar(150) NOT NULL,
  `pc_date_mariage` varchar(10) NOT NULL,
  `pc_lieu_mariage` varchar(150) NOT NULL,
  `pc_contrat` tinyint(4) NOT NULL,
  `pc_contrat_type` varchar(150) NOT NULL,
  `pc_changement_regime` tinyint(4) NOT NULL,
  `pc_restriction` tinyint(4) NOT NULL,
  `pc_application_loi` varchar(255) NOT NULL,
  `p_new` tinyint(4) NOT NULL,
  `p_liquidateur` tinyint(4) NOT NULL,
  `p_pere` varchar(150) NOT NULL,
  `p_mere` varchar(150) NOT NULL,
  `p_parts_cede` bigint(20) NOT NULL,
  `p_parts_recues` bigint(20) NOT NULL,
  `p_domiciliaire` tinyint(4) NOT NULL,
  `p_num_secu` varchar(15) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `id_dossier` (`id_dossier`),
  KEY `id_client` (`id_client`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Structure de la table `participant_moral`
--

CREATE TABLE IF NOT EXISTS `participant_moral` (
  `id` bigint(20) NOT NULL auto_increment,
  `id_dossier` bigint(20) NOT NULL,
  `id_client` bigint(20) NOT NULL,
  `pm_type` varchar(50) NOT NULL,
  `pm_denomination` varchar(255) NOT NULL,
  `pm_adresse` varchar(255) NOT NULL,
  `pm_code` varchar(10) NOT NULL,
  `pm_ville` varchar(150) NOT NULL,
  `pm_num_rcs` varchar(20) NOT NULL,
  `pm_ville_rcs` varchar(150) NOT NULL,
  `pm_capital` int(11) NOT NULL,
  `pm_nb_part` bigint(20) NOT NULL,
  `pm_new` tinyint(4) NOT NULL,
  `pm_parts_cede` bigint(20) NOT NULL,
  `pm_parts_recues` bigint(20) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `id_dossier` (`id_dossier`),
  KEY `id_client` (`id_client`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Structure de la table `repartition_parts`
--

CREATE TABLE IF NOT EXISTS `repartition_parts` (
  `id` bigint(20) NOT NULL auto_increment,
  `id_dossier` bigint(20) NOT NULL,
  `id_client` bigint(20) NOT NULL,
  `vendeur` varchar(100) NOT NULL,
  `nb_part_vendu` int(11) NOT NULL,
  `acheteur` varchar(100) NOT NULL,
  `prix_cession` float NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `id_dossier` (`id_dossier`),
  KEY `id_client` (`id_client`),
  KEY `vendeur` (`vendeur`),
  KEY `acheteur` (`acheteur`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;