-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- http://www.phpmyadmin.net
-- 
-- Serveur: localhost
-- Généré le : Dimanche 05 Mars 2006 à 09:31
-- Version du serveur: 4.1.15
-- Version de PHP: 5.0.4
-- 
-- Base de données: `galette`
-- 

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

-- 
-- Structure de la table `adherents`
-- 

CREATE TABLE `adherents` (
  `id_adh` int(10) unsigned NOT NULL auto_increment,
  `id_statut` int(10) unsigned NOT NULL default '4',
  `nom_adh` varchar(20) NOT NULL default '',
  `prenom_adh` varchar(20) default NULL,
  `pseudo_adh` varchar(20) default NULL,
  `titre_adh` tinyint(3) unsigned NOT NULL default '0',
  `ddn_adh` date default NULL,
  `adresse_adh` varchar(150) NOT NULL default '',
  `adresse2_adh` varchar(150) default NULL,
  `cp_adh` varchar(10) NOT NULL default '',
  `ville_adh` varchar(50) NOT NULL default '',
  `pays_adh` varchar(50) default NULL,
  `tel_adh` varchar(20) default NULL,
  `gsm_adh` varchar(20) default NULL,
  `email_adh` varchar(150) default NULL,
  `url_adh` varchar(200) default NULL,
  `icq_adh` varchar(20) default NULL,
  `msn_adh` varchar(150) default NULL,
  `jabber_adh` varchar(150) default NULL,
  `info_adh` text,
  `info_public_adh` text,
  `prof_adh` varchar(150) default NULL,
  `login_adh` varchar(20) NOT NULL default '',
  `mdp_adh` varchar(20) NOT NULL default '',
  `date_crea_adh` date NOT NULL default '0000-00-00',
  `activite_adh` enum('0','1') NOT NULL default '0',
  `bool_admin_adh` enum('1') default NULL,
  `bool_exempt_adh` enum('1') default NULL,
  `bool_display_info` enum('1') default NULL,
  `date_echeance` date default NULL,
  PRIMARY KEY  (`id_adh`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `adherents`
-- 


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

-- 
-- Structure de la table `cotisations`
-- 

CREATE TABLE `cotisations` (
  `id_cotis` int(10) unsigned NOT NULL auto_increment,
  `id_adh` int(10) unsigned NOT NULL default '0',
  `id_type_cotis` int(10) unsigned NOT NULL default '0',
  `montant_cotis` float unsigned default '0',
  `info_cotis` text,
  `duree_mois_cotis` tinyint(3) unsigned NOT NULL default '12',
  `date_cotis` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id_cotis`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `cotisations`
-- 


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

-- 
-- Structure de la table `logs`
-- 

CREATE TABLE `logs` (
  `id_log` int(10) unsigned NOT NULL auto_increment,
  `date_log` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip_log` varchar(30) NOT NULL default '',
  `adh_log` varchar(41) NOT NULL default '',
  `text_log` text,
  PRIMARY KEY  (`id_log`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `logs`
-- 


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

-- 
-- Structure de la table `preferences`
-- 

CREATE TABLE `preferences` (
  `id_pref` int(10) unsigned NOT NULL auto_increment,
  `nom_pref` varchar(100) NOT NULL default '',
  `val_pref` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id_pref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `preferences`
-- 

INSERT INTO `preferences` VALUES (1, 'pref_nom', 'Galette');
INSERT INTO `preferences` VALUES (2, 'pref_adresse', '-');
INSERT INTO `preferences` VALUES (3, 'pref_cp', '-');
INSERT INTO `preferences` VALUES (4, 'pref_ville', '-');
INSERT INTO `preferences` VALUES (5, 'pref_lang', 'french');
INSERT INTO `preferences` VALUES (6, 'pref_numrows', '30');
INSERT INTO `preferences` VALUES (7, 'pref_log', '2');
INSERT INTO `preferences` VALUES (8, 'pref_email_nom', 'Galette');
INSERT INTO `preferences` VALUES (9, 'pref_email', 'mail@domain.com');
INSERT INTO `preferences` VALUES (10, 'pref_etiq_marges', '10');
INSERT INTO `preferences` VALUES (11, 'pref_etiq_hspace', '10');
INSERT INTO `preferences` VALUES (12, 'pref_etiq_vspace', '5');
INSERT INTO `preferences` VALUES (13, 'pref_etiq_hsize', '90');
INSERT INTO `preferences` VALUES (14, 'pref_etiq_vsize', '35');
INSERT INTO `preferences` VALUES (15, 'pref_etiq_cols', '2');
INSERT INTO `preferences` VALUES (16, 'pref_etiq_rows', '7');
INSERT INTO `preferences` VALUES (17, 'pref_etiq_corps', '12');
INSERT INTO `preferences` VALUES (18, 'pref_admin_login', 'machin');
INSERT INTO `preferences` VALUES (19, 'pref_admin_pass', 'machin');

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

-- 
-- Structure de la table `statuts`
-- 

CREATE TABLE `statuts` (
  `id_statut` int(10) unsigned NOT NULL auto_increment,
  `libelle_statut` varchar(20) NOT NULL default '',
  `priorite_statut` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id_statut`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `statuts`
-- 

INSERT INTO `statuts` VALUES (1, 'Président', 0);
INSERT INTO `statuts` VALUES (10, 'Vice-président', 5);
INSERT INTO `statuts` VALUES (2, 'Trésorier', 10);
INSERT INTO `statuts` VALUES (4, 'Membre actif', 30);
INSERT INTO `statuts` VALUES (5, 'Membre bienfaiteur', 40);
INSERT INTO `statuts` VALUES (6, 'Membre fondateur', 50);
INSERT INTO `statuts` VALUES (3, 'Secrétaire', 20);
INSERT INTO `statuts` VALUES (7, 'Ancien', 60);
INSERT INTO `statuts` VALUES (8, 'Personne morale', 70);
INSERT INTO `statuts` VALUES (9, 'Non membre', 80);

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

-- 
-- Structure de la table `types_cotisation`
-- 

CREATE TABLE `types_cotisation` (
  `id_type_cotis` int(10) unsigned NOT NULL auto_increment,
  `libelle_type_cotis` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id_type_cotis`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `types_cotisation`
-- 

INSERT INTO `types_cotisation` VALUES (1, 'Cotisation annuelle normale');
INSERT INTO `types_cotisation` VALUES (2, 'Cotisation annuelle réduite');
INSERT INTO `types_cotisation` VALUES (3, 'Cotisation entreprise');
INSERT INTO `types_cotisation` VALUES (4, 'Donation en nature');
INSERT INTO `types_cotisation` VALUES (5, 'Donation pécunière');
INSERT INTO `types_cotisation` VALUES (6, 'Partenariat');
