Blame | Last modification | View Log | RSS feed
# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# Serveur: localhost
# Généré le : Jeudi 21 Juillet 2005 à 20:16
# Version du serveur: 4.1.12
# Version de PHP: 4.3.11
#
# Base de données: `educenvi`
#
# --------------------------------------------------------
#
# Structure de la table `annuaire`
#
CREATE TABLE `annuaire` (
`a_id` int(11) unsigned NOT NULL default '0',
`a_nom` varchar(255) NOT NULL default '',
`a_prenom` varchar(255) NOT NULL default '',
`a_mot_de_passe` varchar(32) NOT NULL default 'X X',
`a_mail` varchar(255) NOT NULL default '',
`a_nom_wikini` varchar(255) NOT NULL default '',
`a_adresse1` text,
`a_adresse2` text,
`a_telephone` varchar(32) NOT NULL default '',
`a_fax` varchar(32) NOT NULL default '',
`a_code_postal` varchar(32) default NULL,
`a_ville` varchar(255) default NULL,
`a_ce_pays` char(3) default NULL,
`a_site_internet` varchar(255) NOT NULL default '',
`a_region` varchar(255) default NULL,
`a_code_insee_commune` varchar(255) default NULL,
`a_numero_dpt` int(10) unsigned default NULL,
`a_date_inscription` datetime NOT NULL default '0000-00-00 00:00:00',
`a_est_structure` tinyint(3) unsigned NOT NULL default '0',
`a_ce_structure` varchar(255) NOT NULL default '',
`a_appartient_structure` int(10) unsigned NOT NULL default '0',
`a_sigle_structure` varchar(64) NOT NULL default '',
`a_num_agrement_fpc` varchar(255) NOT NULL default '',
`a_voir_sur_carto` int(11) NOT NULL default '0',
`a_lettre` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`a_id`)
);
CREATE TABLE `inscription_demande` (
`id_identifiant_session` varchar(32) NOT NULL default '',
`id_donnees` text NOT NULL,
`id_date` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id_identifiant_session`)
) ;