
--
-- Base de données : ``
--

-- --------------------------------------------------------

--
-- Structure de la table `acp`
--

CREATE TABLE `acp` (
  `acp_id` int(6) NOT NULL,
  `acp_date` date NOT NULL COMMENT 'Date',
  `acp_compet` varchar(80) NOT NULL COMMENT 'Competition',
  `acp_tables` tinyint(1) NOT NULL COMMENT 'Tables',
  `acp_etat` varchar(8) NOT NULL COMMENT 'Etat',
  `acp_h_min` tinyint(1) NOT NULL,
  `acp_h_max` tinyint(1) NOT NULL,
  `acp_h_8` tinyint(1) NOT NULL COMMENT '8h',
  `acp_h_9` tinyint(1) NOT NULL COMMENT '9h',
  `acp_h_10` tinyint(1) NOT NULL COMMENT '10h',
  `acp_h_11` tinyint(1) NOT NULL COMMENT '11h',
  `acp_h_12` tinyint(1) NOT NULL COMMENT '12h',
  `acp_h_13` tinyint(1) NOT NULL COMMENT '13h',
  `acp_h_14` tinyint(1) NOT NULL COMMENT '14h',
  `acp_h_15` tinyint(1) NOT NULL COMMENT '15h',
  `acp_h_16` tinyint(1) NOT NULL COMMENT '16h',
  `acp_h_17` tinyint(1) NOT NULL COMMENT '17h',
  `acp_h_18` tinyint(1) NOT NULL COMMENT '18h',
  `acp_h_19` tinyint(1) NOT NULL COMMENT '19h',
  `acp_h_20` tinyint(1) NOT NULL COMMENT '20h',
  `acp_m_8` tinyint(4) NOT NULL,
  `acp_m_9` tinyint(4) NOT NULL,
  `acp_m_10` tinyint(4) NOT NULL,
  `acp_m_11` tinyint(4) NOT NULL,
  `acp_m_12` tinyint(1) NOT NULL,
  `acp_m_13` tinyint(1) NOT NULL,
  `acp_m_14` tinyint(1) NOT NULL,
  `acp_m_15` tinyint(1) NOT NULL,
  `acp_m_16` tinyint(1) NOT NULL,
  `acp_m_17` tinyint(1) NOT NULL,
  `acp_m_18` tinyint(1) NOT NULL,
  `acp_m_19` tinyint(1) NOT NULL,
  `acp_m_20` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `adh`
--

CREATE TABLE `adh` (
  `adh_id` int(6) UNSIGNED NOT NULL COMMENT 'Identifiant unique et index',
  `adh_nom` varchar(30) NOT NULL DEFAULT '' COMMENT 'Nom',
  `adh_prenom` varchar(30) NOT NULL DEFAULT '' COMMENT 'Prenom',
  `adh_genre` enum('','M.','Mme') NOT NULL COMMENT 'Homme ou Femme',
  `adh_licence` varchar(12) NOT NULL DEFAULT '' COMMENT 'Licence FFB',
  `adh_typlic` varchar(20) NOT NULL COMMENT 'Type licence',
  `adh_password` varchar(32) NOT NULL DEFAULT '' COMMENT 'Mot de passe',
  `adh_ffb_pass` varchar(32) NOT NULL COMMENT 'Passw_FFB',
  `adh_tel_dom` varchar(15) NOT NULL DEFAULT '' COMMENT 'Tel domicile',
  `adh_mobile` varchar(15) NOT NULL DEFAULT '' COMMENT 'Tel mobile',
  `adh_email` varchar(60) NOT NULL DEFAULT '' COMMENT 'Adresse de messagerie',
  `adh_verrou` enum('Actif','Er1','Er2','Verrouille','Inactif','Decede','') NOT NULL DEFAULT 'Actif' COMMENT 'Etat du compte',
  `adh_niveau` varchar(3) NOT NULL COMMENT 'Niveau (en clair)',
  `adh_iv` tinyint(3) NOT NULL COMMENT 'Niveau (en IV)',
  `adh_ic` tinyint(3) NOT NULL COMMENT 'Indice competition',
  `adh_tel_bur` varchar(15) NOT NULL DEFAULT '' COMMENT 'Tel Bureau',
  `adh_adr1` varchar(80) NOT NULL,
  `adh_adr2` varchar(80) NOT NULL,
  `adh_codep` int(5) NOT NULL,
  `adh_ville` varchar(50) NOT NULL,
  `adh_doublon` tinyint(1) NOT NULL COMMENT 'Indicateur doublon',
  `adh_groupes` tinytext NOT NULL COMMENT 'Groupes (droits)',
  `adh_date_ffb` date NOT NULL COMMENT 'Date maj FFB',
  `adh_etatlic` varchar(1) NOT NULL COMMENT 'Etat de la licence',
  `adh_club` varchar(8) NOT NULL COMMENT 'Club',
  `adh_nbtourn` int(3) NOT NULL COMMENT 'Nb_Tournois',
  `adh_credate` date NOT NULL COMMENT 'Creation',
  `adh_dnaiss` date NOT NULL COMMENT 'Date_Naissance',
  `adh_mailactif` tinyint(1) NOT NULL COMMENT 'Mail_actif',
  `adh_ann_adh` tinytext NOT NULL COMMENT 'Adhesions',
  `adh_dem_etiq` tinyint(1) NOT NULL COMMENT 'Etiquettes',
  `adh_public` tinyint(1) NOT NULL COMMENT 'Adresse publique',
  `adh_conj_id` int(6) NOT NULL COMMENT 'Conjoint',
  `adh_tik_lic` varchar(80) NOT NULL COMMENT 'Ticket licence',
  `adh_dat_lic` date NOT NULL COMMENT 'Date licence',
  `adh_ffb_lic` int(4) NOT NULL COMMENT 'Code_Licence_FFB',
  `adh_tik_adh` varchar(80) NOT NULL COMMENT 'Ticket adhesion',
  `adh_dat_adh` date NOT NULL COMMENT 'Date adhesione',
  `adh_date_mod` date NOT NULL COMMENT 'Date mod.',
  `adh_qui_mod` int(6) NOT NULL COMMENT 'Qui modifie',
  `adh_tag_mod` tinyint(1) NOT NULL COMMENT 'a ete Modifie',
  `adh_pseudo_bbo` varchar(20) NOT NULL COMMENT 'Pseudo_BBO',
  `adh_credit` decimal(6,2) NOT NULL COMMENT 'Credit',
  `adh_nordsud` tinyint(1) NOT NULL COMMENT 'Nord_Sud'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Adhérents';

-- --------------------------------------------------------

--
-- Structure de la table `art`
--

CREATE TABLE `art` (
  `art_id` int(6) NOT NULL,
  `art_far_id` int(6) NOT NULL COMMENT 'Famille',
  `art_desc` varchar(80) NOT NULL COMMENT 'Description',
  `art_cible` enum('','Jeune','Junior','Adulte','Senior') NOT NULL COMMENT 'Cible',
  `art_ffb_code` int(4) NOT NULL COMMENT 'Code_Licence_FFB',
  `art_cac_id` int(6) NOT NULL COMMENT 'Activite',
  `art_abon` enum('','Seance','Semaine','Trimestre','Annee','Forfait') NOT NULL COMMENT 'Abonnenent',
  `art_ok_lic` tinyint(1) NOT NULL COMMENT 'Licencie',
  `art_ok_sym` tinyint(1) NOT NULL COMMENT 'Sympathisant',
  `art_ok_ext` tinyint(1) NOT NULL COMMENT 'Externe',
  `art_tar_lic` decimal(6,2) NOT NULL COMMENT 'Tarif Licencie',
  `art_tar_sym` decimal(6,2) NOT NULL COMMENT 'Tarif Sympathisant',
  `art_tar_ext` decimal(6,2) NOT NULL COMMENT 'Tarif Externe',
  `art_compte` tinyint(1) NOT NULL COMMENT 'si compte',
  `art_numero` int(6) NOT NULL COMMENT 'Increment',
  `art_internet` enum('','adherent','conjoint','couple') NOT NULL COMMENT 'Achat Internet',
  `art_code_compta` int(8) NOT NULL COMMENT 'Code comptable',
  `art_credit` enum('','Oui') NOT NULL COMMENT 'Crédite adhérent'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `beq`
--

CREATE TABLE `beq` (
  `beq_id` int(6) NOT NULL COMMENT 'ID',
  `beq_date` date NOT NULL COMMENT 'Date',
  `beq_adh_id` int(6) NOT NULL COMMENT 'Adherent',
  `beq_r_part` tinyint(1) NOT NULL COMMENT 'Rech Part',
  `beq_r_equip` tinyint(1) NOT NULL COMMENT 'Rech Equip',
  `beq_t_tournoi` tinyint(1) NOT NULL COMMENT 'Pour Tournoi',
  `beq_t_compet` tinyint(1) NOT NULL COMMENT 'Pour Compet',
  `beq_j_paire` tinyint(1) NOT NULL COMMENT 'En Paire',
  `beq_j_par4` tinyint(1) NOT NULL COMMENT 'En MatchX4',
  `beq_comment` text NOT NULL COMMENT 'Annonce'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `bib`
--

CREATE TABLE `bib` (
  `bib_id` int(6) UNSIGNED NOT NULL COMMENT 'Index',
  `bib_code` varchar(15) DEFAULT NULL COMMENT 'Code',
  `bib_famille` varchar(1) NOT NULL COMMENT 'Famille',
  `bib_numero` varchar(6) NOT NULL COMMENT 'Numero',
  `bib_titre` varchar(80) DEFAULT NULL COMMENT 'Titre',
  `bib_edit` varchar(20) DEFAULT NULL COMMENT 'Editeur / Auteur',
  `bib_annee` year(4) NOT NULL COMMENT 'Annee',
  `bib_datesor` date DEFAULT '0000-00-00' COMMENT 'Sortie',
  `bib_nbsor` int(6) DEFAULT NULL COMMENT 'Nombre sorties',
  `bib_adh_id` int(6) DEFAULT NULL COMMENT 'Emprunteur',
  `bib_rappel` date NOT NULL COMMENT 'Date rappel',
  `bib_etat` enum('Sorti','Reserve','Rendu','Dispo') NOT NULL COMMENT 'Etat'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Bibliothèque';


-- --------------------------------------------------------

--
-- Structure de la table `cac`
--

CREATE TABLE `cac` (
  `cac_id` int(6) NOT NULL COMMENT 'Code',
  `cac_desc` varchar(80) NOT NULL COMMENT 'Description',
  `cac_type` enum('Cours','Entrainement','Tournoi','Partie_libre','Reunion','Competition','Accueil','Duplication') NOT NULL COMMENT 'Type',
  `cac_adh_id` int(6) NOT NULL COMMENT 'Responsable Activite',
  `cac_inscript` enum('0 : sans inscription','1 : individuelle','2 : par paire','4 : par Equipe de 4','6 : Interclub D1-D4','7 : Interclub D5') NOT NULL DEFAULT '0 : sans inscription' COMMENT 'Inscription',
  `cac_ivmin` int(2) NOT NULL DEFAULT 1 COMMENT 'IV Min',
  `cac_ivmax` int(3) NOT NULL DEFAULT 100 COMMENT 'IV Max',
  `cac_arbis` enum('Non','Oui') DEFAULT NULL COMMENT '2eme arbitre',
  `cac_orga` enum('Non','Oui') DEFAULT NULL COMMENT 'Organisateur',
  `cac_libarb` varchar(15) NOT NULL COMMENT 'Responsable Seance',
  `cac_grp_res` varchar(15) NOT NULL COMMENT 'Groupe responsable',
  `cac_grp_seg` varchar(15) NOT NULL COMMENT 'Groupe qui seconde',
  `cac_grp_org` varchar(15) NOT NULL COMMENT 'Groupe Organisateur',
  `cac_max_ins` int(3) NOT NULL COMMENT 'Max Equipes',
  `cac_surbook` tinyint(1) NOT NULL COMMENT 'Surbooking',
  `cac_res_mel` tinyint(1) NOT NULL COMMENT 'Mel Resp',
  `cac_seg_mel` tinyint(1) NOT NULL COMMENT 'Mel Adj1',
  `cac_org_mel` tinyint(1) NOT NULL COMMENT 'Mel Adj2',
  `cac_heure` time NOT NULL COMMENT 'Heure',
  `cac_duree` decimal(5,2) NOT NULL COMMENT 'Duree',
  `cac_salles` varchar(30) NOT NULL COMMENT 'Salles',
  `cac_seances` int(6) NOT NULL COMMENT 'Seances',
  `cac_derdate` date NOT NULL COMMENT 'Der_Date',
  `cac_inscrits` int(6) NOT NULL COMMENT 'Inscrits',
  `cac_couleur` varchar(6) NOT NULL COMMENT 'Couleur',
  `cac_ivmin_cap` tinyint(1) NOT NULL COMMENT 'IV min Capitaine',
  `cac_ivmax_cap` tinyint(1) NOT NULL COMMENT 'IV MAX Capitaine',
  `cac_ivmin_ins` tinyint(1) NOT NULL COMMENT 'IV min joueur',
  `cac_ivmax_ins` tinyint(1) NOT NULL COMMENT 'IV MAX joueur',
  `cac_ivmin_equ` smallint(2) NOT NULL COMMENT 'IV min Total Equipe',
  `cac_ivmax_equ` smallint(2) NOT NULL COMMENT 'IV MAX total Equipe',
  `cac_compta` decimal(6,2) NOT NULL COMMENT 'Compta',
  `cac_groupes` tinytext NOT NULL COMMENT 'Groupes',
  `cac_rappel` tinyint(1) NOT NULL COMMENT 'Rappel inscription'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Codes activités';


-- --------------------------------------------------------

--
-- Structure de la table `cbs`
--

CREATE TABLE `cbs` (
  `cbs_id` int(6) NOT NULL COMMENT 'Index',
  `cbs_date` datetime NOT NULL COMMENT 'Date',
  `cbs_adh_id` int(6) NOT NULL COMMENT 'Adherent',
  `cbs_montant` decimal(6,2) NOT NULL COMMENT 'Montant',
  `cbs_tra_id` int(6) NOT NULL COMMENT 'Remise',
  `cbs_result` varchar(20) NOT NULL COMMENT 'Resultat',
  `cbs_ercode` varchar(12) NOT NULL COMMENT 'Code erreur',
  `cbs_erdesc` varchar(80) NOT NULL COMMENT 'Erreur',
  `cbs_detail` text NOT NULL COMMENT 'Detail',
  `cbs_trans` varchar(50) NOT NULL COMMENT 'Transaction',
  `cbs_stripe` decimal(6,2) NOT NULL COMMENT 'Montant Stripe',
  `cbs_frais` decimal(6,2) NOT NULL COMMENT 'Frais',
  `cbs_taxe` decimal(6,2) NOT NULL COMMENT 'Taxe',
  `cbs_banque` decimal(6,2) NOT NULL COMMENT 'Banque',
  `cbs_status` varchar(30) NOT NULL COMMENT 'Status'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `ccf`
--

CREATE TABLE `ccf` (
  `ccf_id` int(6) NOT NULL COMMENT 'Index',
  `ccf_date` date NOT NULL COMMENT 'Date',
  `ccf_compet` varchar(80) NOT NULL COMMENT 'Competition'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `chp`
--

CREATE TABLE `chp` (
  `chp_id` int(6) NOT NULL,
  `chp_ad1_id` int(6) NOT NULL,
  `chp_ad2_id` int(6) NOT NULL,
  `chp_carnets` int(3) NOT NULL,
  `chp_bouteilles` int(3) NOT NULL,
  `chp_an_dern` int(3) NOT NULL,
  `chp_donnees` int(3) NOT NULL,
  `chp_dues` int(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `doc`
--

CREATE TABLE `doc` (
  `doc_id` int(6) NOT NULL COMMENT 'Index',
  `doc_type` enum('echo','crendu') NOT NULL,
  `doc_date` date NOT NULL COMMENT 'Date',
  `doc_sujet` varchar(80) NOT NULL COMMENT 'Sujet',
  `doc_texte` longtext NOT NULL COMMENT 'Contenu',
  `doc_etat` tinyint(1) NOT NULL COMMENT 'Etat',
  `doc_desti` varchar(80) NOT NULL COMMENT 'Destinataires',
  `doc_adh_id` int(6) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Documents';

-- --------------------------------------------------------

--
-- Structure de la table `far`
--

CREATE TABLE `far` (
  `far_id` int(6) NOT NULL COMMENT 'Identifiant',
  `far_desc` varchar(80) NOT NULL COMMENT 'Description',
  `far_ok_lic` tinyint(1) NOT NULL COMMENT 'Licencies',
  `far_ok_sym` tinyint(1) NOT NULL COMMENT 'Sympathisants',
  `far_ok_ext` tinyint(1) NOT NULL COMMENT 'Externes'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `fer`
--

CREATE TABLE `fer` (
  `fer_date` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `fil`
--

CREATE TABLE `fil` (
  `fil_id` int(6) UNSIGNED NOT NULL COMMENT 'Num',
  `fil_table` varchar(3) NOT NULL COMMENT 'Table',
  `fil_ordre` int(6) NOT NULL COMMENT 'Ordre',
  `fil_filtre` varchar(512) NOT NULL COMMENT 'Filtre',
  `fil_desc` varchar(60) NOT NULL COMMENT 'Description',
  `fil_visible` tinyint(1) NOT NULL COMMENT 'Visible',
  `fil_usage` varchar(80) NOT NULL COMMENT 'Usage',
  `fil_sujet` varchar(80) NOT NULL COMMENT 'Sujet',
  `fil_droits` tinytext NOT NULL COMMENT 'Droits'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `fou`
--

CREATE TABLE `fou` (
  `fou_code` varchar(1) NOT NULL COMMENT 'Famille',
  `fou_desc` varchar(30) NOT NULL COMMENT 'Description'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `icp`
--

CREATE TABLE `icp` (
  `icp_id` int(6) NOT NULL,
  `icp_acp_id` int(6) NOT NULL COMMENT 'WE_Compet',
  `icp_adh_id` int(6) NOT NULL COMMENT 'Adherent',
  `icp_h_min` tinyint(1) NOT NULL COMMENT 'Debut',
  `icp_h_max` tinyint(1) NOT NULL COMMENT 'Fin'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `ins`
--

CREATE TABLE `ins` (
  `ins_id` int(6) UNSIGNED NOT NULL COMMENT 'Index',
  `ins_adh_id` int(6) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Adherent',
  `ins_cac_id` int(6) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Activite',
  `ins_mode` enum('','Seance','Semaine','Trimestre','Annee','Forfait') NOT NULL COMMENT 'Abonnenent',
  `ins_tik_id` int(6) NOT NULL COMMENT 'Ticket'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Inscriptions';

-- --------------------------------------------------------

--
-- Structure de la table `ito`
--

CREATE TABLE `ito` (
  `ito_id` int(6) UNSIGNED NOT NULL COMMENT 'Index',
  `ito_adh_id` int(6) UNSIGNED NOT NULL COMMENT 'Adherent',
  `ito_capit` int(6) UNSIGNED NOT NULL COMMENT 'Capitaine',
  `ito_sea_id` int(6) UNSIGNED NOT NULL COMMENT 'Tournoi',
  `ito_licence` varchar(12) NOT NULL COMMENT 'Licence',
  `ito_nom` varchar(50) NOT NULL COMMENT 'Nom',
  `ito_prenom` varchar(50) NOT NULL COMMENT 'Prenom',
  `ito_iv` tinyint(3) NOT NULL COMMENT 'IV',
  `ito_email` varchar(60) NOT NULL COMMENT 'Email',
  `ito_cretime` int(12) NOT NULL COMMENT 'Creation'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `jch`
--

CREATE TABLE `jch` (
  `jch_id` int(6) NOT NULL COMMENT 'Destinataire',
  `jch_date` date NOT NULL COMMENT 'Date',
  `jch_chp_id` int(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `jdn`
--

CREATE TABLE `jdn` (
  `jdn_id` int(6) NOT NULL,
  `jdn_jtp_code` varchar(3) NOT NULL COMMENT 'Type_Donne',
  `jdn_jnv_code` int(1) NOT NULL COMMENT 'Niveau',
  `jdn_jte_code` varchar(3) NOT NULL COMMENT 'Code_Enchere',
  `jdn_donne` blob NOT NULL COMMENT 'Donne'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `jfi`
--

CREATE TABLE `jfi` (
  `jfi_date` datetime NOT NULL COMMENT 'Date',
  `jfi_adh_id` int(6) NOT NULL,
  `jfi_deb_id` int(6) NOT NULL,
  `jfi_sea_id` int(6) NOT NULL,
  `jfi_art_id` int(6) NOT NULL COMMENT 'Article',
  `jfi_montant` decimal(6,2) DEFAULT NULL COMMENT 'Montant',
  `jfi_credit` decimal(6,2) NOT NULL COMMENT 'Credit'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `jnv`
--

CREATE TABLE `jnv` (
  `jnv_code` int(1) NOT NULL COMMENT 'Code',
  `jnv_desc` varchar(25) NOT NULL COMMENT 'Description'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `jte`
--

CREATE TABLE `jte` (
  `jte_code` varchar(3) NOT NULL COMMENT 'Code',
  `jte_desc` varchar(80) NOT NULL COMMENT 'Description'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `jtp`
--

CREATE TABLE `jtp` (
  `jtp_code` varchar(3) NOT NULL COMMENT 'Code',
  `jtp_desc` varchar(80) NOT NULL COMMENT 'Description'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `log`
--

CREATE TABLE `log` (
  `log_quand` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Quand',
  `log_qui` varchar(50) NOT NULL COMMENT 'Qui',
  `log_quoi` varchar(30) NOT NULL COMMENT 'Quoi',
  `log_comment` varchar(255) NOT NULL COMMENT 'Commentaire',
  `log_ou` varchar(15) NOT NULL COMMENT 'Ou'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Trace des actions';

-- --------------------------------------------------------

--
-- Structure de la table `mdp`
--

CREATE TABLE `mdp` (
  `mdp_id` int(11) NOT NULL COMMENT 'Index',
  `mdp_desc` varchar(30) NOT NULL COMMENT 'Mode_paiement',
  `mdp_online` tinyint(1) NOT NULL COMMENT 'Internet',
  `mdp_special` enum('','Gratuit','Internet','Erreur') NOT NULL COMMENT 'Special'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `mel`
--

CREATE TABLE `mel` (
  `mel_id` int(6) NOT NULL COMMENT 'Index',
  `mel_date` datetime NOT NULL COMMENT 'Date',
  `mel_adh_id` int(6) NOT NULL COMMENT 'Emetteur',
  `mel_sea_id` int(6) NOT NULL COMMENT 'Sortie',
  `mel_destin` varchar(15) NOT NULL COMMENT 'Destinataires',
  `mel_sujet` varchar(80) NOT NULL COMMENT 'Sujet',
  `mel_texte` longtext NOT NULL COMMENT 'Message'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `mhc`
--

CREATE TABLE `mhc` (
  `mhc_id` int(6) UNSIGNED NOT NULL COMMENT 'Index',
  `mhc_jour` tinyint(1) NOT NULL COMMENT 'Date',
  `mhc_duree` decimal(5,2) DEFAULT NULL,
  `mhc_desc` text NOT NULL COMMENT 'Description',
  `mhc_heure` time NOT NULL DEFAULT '00:00:00' COMMENT 'Heure',
  `mhc_salles` varchar(30) NOT NULL COMMENT 'Salles',
  `mhc_adh_id` int(6) NOT NULL DEFAULT 0 COMMENT 'Arbitre',
  `mhc_cac_id` int(6) NOT NULL COMMENT 'Type',
  `mhc_arbis` int(6) UNSIGNED NOT NULL COMMENT 'Arb. ou Org.',
  `mhc_orga` int(6) UNSIGNED NOT NULL COMMENT 'Organisateur'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `mms`
--

CREATE TABLE `mms` (
  `mms_id` int(6) UNSIGNED NOT NULL COMMENT 'Index',
  `mms_sem` tinyint(1) NOT NULL,
  `mms_jour` tinyint(1) NOT NULL COMMENT 'Date',
  `mms_duree` decimal(5,2) DEFAULT NULL,
  `mms_desc` text NOT NULL COMMENT 'Description',
  `mms_heure` time NOT NULL DEFAULT '00:00:00' COMMENT 'Heure',
  `mms_salles` varchar(30) NOT NULL COMMENT 'Salles',
  `mms_adh_id` int(6) NOT NULL DEFAULT 0 COMMENT 'Arbitre',
  `mms_cac_id` int(6) NOT NULL COMMENT 'Type',
  `mms_arbis` int(6) UNSIGNED NOT NULL COMMENT 'Arb. ou Org.',
  `mms_orga` int(6) UNSIGNED NOT NULL COMMENT 'Organisateur'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `sal`
--

CREATE TABLE `sal` (
  `sal_id` int(6) UNSIGNED NOT NULL COMMENT 'Index',
  `sal_nom` varchar(30) NOT NULL COMMENT 'Nom',
  `sal_couleur` varchar(6) NOT NULL COMMENT 'Couleur'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Locaux';

-- --------------------------------------------------------

--
-- Structure de la table `sea`
--

CREATE TABLE `sea` (
  `sea_id` int(6) UNSIGNED NOT NULL COMMENT 'Index',
  `sea_date` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Date',
  `sea_duree` decimal(5,2) DEFAULT NULL COMMENT 'Duree',
  `sea_desc` text NOT NULL COMMENT 'Description',
  `sea_heure` time NOT NULL DEFAULT '00:00:00' COMMENT 'Heure',
  `sea_salles` varchar(30) NOT NULL COMMENT 'Salles',
  `sea_adh_id` int(6) NOT NULL DEFAULT 0 COMMENT 'Arbitre',
  `sea_cac_id` int(6) NOT NULL COMMENT 'Type',
  `sea_confirm` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Confirme_Resp',
  `sea_confbis` tinyint(1) NOT NULL COMMENT 'Confirme Arb_BIS',
  `sea_confter` tinyint(1) NOT NULL COMMENT 'Confirme arb_TER',
  `sea_conforg` tinyint(1) NOT NULL COMMENT 'Confirme_Org',
  `sea_arbis` int(6) NOT NULL COMMENT 'Arb. ou Org.',
  `sea_orga` int(6) NOT NULL COMMENT 'Organisateur',
  `sea_maxequip` int(6) NOT NULL COMMENT 'Max_Equipes',
  `sea_surbook` tinyint(1) NOT NULL COMMENT 'Surbooking'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `stt`
--

CREATE TABLE `stt` (
  `stt_id` smallint(6) NOT NULL,
  `stt_annee` smallint(4) DEFAULT NULL,
  `stt_mois` smallint(2) DEFAULT NULL,
  `stt_action` varchar(30) DEFAULT NULL,
  `stt_nombre` smallint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `tik`
--

CREATE TABLE `tik` (
  `tik_id` int(6) NOT NULL COMMENT 'Ticket',
  `tik_adh_id` int(6) NOT NULL COMMENT 'Bneficiaire',
  `tik_tra_id` int(6) NOT NULL COMMENT 'Transaction',
  `tik_art_id` int(6) NOT NULL COMMENT 'Article',
  `tik_art_desc` varchar(80) NOT NULL COMMENT 'Description',
  `tik_art_tar` decimal(6,2) NOT NULL COMMENT 'Prix',
  `tik_art_qte` int(6) NOT NULL COMMENT 'Quantite',
  `tik_comment` varchar(80) NOT NULL COMMENT 'Info'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `tra`
--

CREATE TABLE `tra` (
  `tra_id` int(6) NOT NULL COMMENT 'Index',
  `tra_adh_id` int(6) NOT NULL COMMENT 'Payeur',
  `tra_montant` decimal(6,2) NOT NULL COMMENT 'Montant',
  `tra_mdp_id` int(6) NOT NULL COMMENT 'Mode',
  `tra_date` datetime NOT NULL COMMENT 'Date',
  `tra_ven_id` int(6) NOT NULL COMMENT 'Vendeur'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `acp`
--
ALTER TABLE `acp`
  ADD PRIMARY KEY (`acp_id`);

--
-- Index pour la table `adh`
--
ALTER TABLE `adh`
  ADD PRIMARY KEY (`adh_id`),
  ADD KEY `nom` (`adh_nom`),
  ADD KEY `licence` (`adh_licence`);

--
-- Index pour la table `art`
--
ALTER TABLE `art`
  ADD PRIMARY KEY (`art_id`);

--
-- Index pour la table `beq`
--
ALTER TABLE `beq`
  ADD PRIMARY KEY (`beq_id`);

--
-- Index pour la table `bib`
--
ALTER TABLE `bib`
  ADD PRIMARY KEY (`bib_id`),
  ADD KEY `bib_code` (`bib_code`);

--
-- Index pour la table `cac`
--
ALTER TABLE `cac`
  ADD PRIMARY KEY (`cac_id`);

--
-- Index pour la table `cbs`
--
ALTER TABLE `cbs`
  ADD PRIMARY KEY (`cbs_id`);

--
-- Index pour la table `ccf`
--
ALTER TABLE `ccf`
  ADD PRIMARY KEY (`ccf_id`);

--
-- Index pour la table `chp`
--
ALTER TABLE `chp`
  ADD PRIMARY KEY (`chp_id`),
  ADD KEY `chp_ad1_id` (`chp_ad1_id`),
  ADD KEY `chp_ad2_id` (`chp_ad2_id`);

--
-- Index pour la table `doc`
--
ALTER TABLE `doc`
  ADD PRIMARY KEY (`doc_id`);

--
-- Index pour la table `far`
--
ALTER TABLE `far`
  ADD PRIMARY KEY (`far_id`);

--
-- Index pour la table `fer`
--
ALTER TABLE `fer`
  ADD KEY `fer_date` (`fer_date`);

--
-- Index pour la table `fil`
--
ALTER TABLE `fil`
  ADD PRIMARY KEY (`fil_id`);

--
-- Index pour la table `fou`
--
ALTER TABLE `fou`
  ADD PRIMARY KEY (`fou_code`);

--
-- Index pour la table `icp`
--
ALTER TABLE `icp`
  ADD PRIMARY KEY (`icp_id`);

--
-- Index pour la table `ins`
--
ALTER TABLE `ins`
  ADD PRIMARY KEY (`ins_id`),
  ADD KEY `ins_sor_id` (`ins_cac_id`),
  ADD KEY `ins_adh_id` (`ins_adh_id`);

--
-- Index pour la table `ito`
--
ALTER TABLE `ito`
  ADD PRIMARY KEY (`ito_id`);

--
-- Index pour la table `jch`
--
ALTER TABLE `jch`
  ADD PRIMARY KEY (`jch_id`);

--
-- Index pour la table `jdn`
--
ALTER TABLE `jdn`
  ADD PRIMARY KEY (`jdn_id`);

--
-- Index pour la table `jfi`
--
ALTER TABLE `jfi`
  ADD KEY `jfi_adh_id` (`jfi_adh_id`),
  ADD KEY `jfi_sea_id` (`jfi_sea_id`),
  ADD KEY `jfi_date` (`jfi_date`);

--
-- Index pour la table `jnv`
--
ALTER TABLE `jnv`
  ADD PRIMARY KEY (`jnv_code`);

--
-- Index pour la table `jte`
--
ALTER TABLE `jte`
  ADD PRIMARY KEY (`jte_code`);

--
-- Index pour la table `jtp`
--
ALTER TABLE `jtp`
  ADD PRIMARY KEY (`jtp_code`);

--
-- Index pour la table `log`
--
ALTER TABLE `log`
  ADD KEY `log_quand` (`log_quand`);

--
-- Index pour la table `mdp`
--
ALTER TABLE `mdp`
  ADD PRIMARY KEY (`mdp_id`);

--
-- Index pour la table `mel`
--
ALTER TABLE `mel`
  ADD PRIMARY KEY (`mel_id`),
  ADD KEY `mel_adh_id` (`mel_adh_id`);

--
-- Index pour la table `mhc`
--
ALTER TABLE `mhc`
  ADD PRIMARY KEY (`mhc_id`);

--
-- Index pour la table `mms`
--
ALTER TABLE `mms`
  ADD PRIMARY KEY (`mms_id`),
  ADD KEY `mod_jour` (`mms_jour`),
  ADD KEY `mod_sem` (`mms_sem`);

--
-- Index pour la table `sal`
--
ALTER TABLE `sal`
  ADD PRIMARY KEY (`sal_id`);

--
-- Index pour la table `sea`
--
ALTER TABLE `sea`
  ADD PRIMARY KEY (`sea_id`),
  ADD KEY `sea_date` (`sea_date`);

--
-- Index pour la table `stt`
--
ALTER TABLE `stt`
  ADD PRIMARY KEY (`stt_id`),
  ADD KEY `stt_annee` (`stt_annee`);

--
-- Index pour la table `tik`
--
ALTER TABLE `tik`
  ADD PRIMARY KEY (`tik_id`),
  ADD KEY `tik_tra_id` (`tik_tra_id`);

--
-- Index pour la table `tra`
--
ALTER TABLE `tra`
  ADD PRIMARY KEY (`tra_id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `acp`
--
ALTER TABLE `acp`
  MODIFY `acp_id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;

--
-- AUTO_INCREMENT pour la table `adh`
--
ALTER TABLE `adh`
  MODIFY `adh_id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Identifiant unique et index', AUTO_INCREMENT=2590;

--
-- AUTO_INCREMENT pour la table `art`
--
ALTER TABLE `art`
  MODIFY `art_id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;

--
-- AUTO_INCREMENT pour la table `beq`
--
ALTER TABLE `beq`
  MODIFY `beq_id` int(6) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=101;

--
-- AUTO_INCREMENT pour la table `bib`
--
ALTER TABLE `bib`
  MODIFY `bib_id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Index', AUTO_INCREMENT=217;

--
-- AUTO_INCREMENT pour la table `cac`
--
ALTER TABLE `cac`
  MODIFY `cac_id` int(6) NOT NULL AUTO_INCREMENT COMMENT 'Code', AUTO_INCREMENT=108;

--
-- AUTO_INCREMENT pour la table `cbs`
--
ALTER TABLE `cbs`
  MODIFY `cbs_id` int(6) NOT NULL AUTO_INCREMENT COMMENT 'Index';

--
-- AUTO_INCREMENT pour la table `ccf`
--
ALTER TABLE `ccf`
  MODIFY `ccf_id` int(6) NOT NULL AUTO_INCREMENT COMMENT 'Index', AUTO_INCREMENT=58;

--
-- AUTO_INCREMENT pour la table `chp`
--
ALTER TABLE `chp`
  MODIFY `chp_id` int(6) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `doc`
--
ALTER TABLE `doc`
  MODIFY `doc_id` int(6) NOT NULL AUTO_INCREMENT COMMENT 'Index', AUTO_INCREMENT=89;

--
-- AUTO_INCREMENT pour la table `far`
--
ALTER TABLE `far`
  MODIFY `far_id` int(6) NOT NULL AUTO_INCREMENT COMMENT 'Identifiant', AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT pour la table `fil`
--
ALTER TABLE `fil`
  MODIFY `fil_id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Num', AUTO_INCREMENT=69;

--
-- AUTO_INCREMENT pour la table `icp`
--
ALTER TABLE `icp`
  MODIFY `icp_id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=171;

--
-- AUTO_INCREMENT pour la table `ins`
--
ALTER TABLE `ins`
  MODIFY `ins_id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Index', AUTO_INCREMENT=4300;

--
-- AUTO_INCREMENT pour la table `ito`
--
ALTER TABLE `ito`
  MODIFY `ito_id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Index', AUTO_INCREMENT=18441;

--
-- AUTO_INCREMENT pour la table `jch`
--
ALTER TABLE `jch`
  MODIFY `jch_id` int(6) NOT NULL AUTO_INCREMENT COMMENT 'Destinataire';

--
-- AUTO_INCREMENT pour la table `jdn`
--
ALTER TABLE `jdn`
  MODIFY `jdn_id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=926;

--
-- AUTO_INCREMENT pour la table `mdp`
--
ALTER TABLE `mdp`
  MODIFY `mdp_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Index', AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT pour la table `mel`
--
ALTER TABLE `mel`
  MODIFY `mel_id` int(6) NOT NULL AUTO_INCREMENT COMMENT 'Index', AUTO_INCREMENT=3151;

--
-- AUTO_INCREMENT pour la table `mhc`
--
ALTER TABLE `mhc`
  MODIFY `mhc_id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Index', AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT pour la table `mms`
--
ALTER TABLE `mms`
  MODIFY `mms_id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Index', AUTO_INCREMENT=138;

--
-- AUTO_INCREMENT pour la table `sal`
--
ALTER TABLE `sal`
  MODIFY `sal_id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Index', AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT pour la table `sea`
--
ALTER TABLE `sea`
  MODIFY `sea_id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Index';

--
-- AUTO_INCREMENT pour la table `stt`
--
ALTER TABLE `stt`
  MODIFY `stt_id` smallint(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=631;

--
-- AUTO_INCREMENT pour la table `tik`
--
ALTER TABLE `tik`
  MODIFY `tik_id` int(6) NOT NULL AUTO_INCREMENT COMMENT 'Ticket', AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT pour la table `tra`
--
ALTER TABLE `tra`
  MODIFY `tra_id` int(6) NOT NULL AUTO_INCREMENT COMMENT 'Index', AUTO_INCREMENT=8;



