| Line 1... |
Line -... |
| 1 |
# phpMyAdmin SQL Dump
|
- |
|
| 2 |
# version 2.5.6
|
- |
|
| 3 |
# http://www.phpmyadmin.net
|
- |
|
| 4 |
#
|
- |
|
| 5 |
# Serveur: localhost
|
- |
|
| 6 |
# Généré le : Jeudi 21 Juillet 2005 à 20:16
|
- |
|
| 7 |
# Version du serveur: 4.1.12
|
- |
|
| 8 |
# Version de PHP: 4.3.11
|
- |
|
| 9 |
#
|
- |
|
| 10 |
# Base de données: `educenvi`
|
- |
|
| 11 |
#
|
- |
|
| 12 |
|
- |
|
| 13 |
# --------------------------------------------------------
|
- |
|
| 14 |
|
- |
|
| 15 |
#
|
- |
|
| 16 |
# Structure de la table `annuaire`
|
- |
|
| 17 |
#
|
- |
|
| 18 |
|
- |
|
| 19 |
CREATE TABLE `annuaire` (
|
1 |
CREATE TABLE `annuaire` (
|
| 20 |
`a_id` int(11) unsigned NOT NULL default '0',
|
2 |
`a_id` int(11) unsigned NOT NULL default '0',
|
| - |
|
3 |
`a_ce_i18n` varchar(8) NOT NULL default '',
|
| 21 |
`a_nom` varchar(255) NOT NULL default '',
|
4 |
`a_nom` varchar(32) NOT NULL default '',
|
| 22 |
`a_prenom` varchar(255) NOT NULL default '',
|
5 |
`a_prenom` varchar(32) NOT NULL default '',
|
| - |
|
6 |
`a_profession` varchar(255) NOT NULL default '',
|
| 23 |
`a_mot_de_passe` varchar(32) NOT NULL default 'X X',
|
7 |
`a_mot_de_passe` varchar(32) NOT NULL default 'X X',
|
| 24 |
`a_mail` varchar(255) NOT NULL default '',
|
8 |
`a_mail` varchar(128) NOT NULL default '',
|
| 25 |
`a_nom_wikini` varchar(255) NOT NULL default '',
|
9 |
`a_nom_wikini` varchar(255) NOT NULL default '',
|
| 26 |
`a_adresse1` text,
|
10 |
`a_adresse1` text,
|
| 27 |
`a_adresse2` text,
|
11 |
`a_adresse2` text,
|
| 28 |
`a_telephone` varchar(32) NOT NULL default '',
|
12 |
`a_tel` varchar(32) NOT NULL default '',
|
| 29 |
`a_fax` varchar(32) NOT NULL default '',
|
13 |
`a_fax` varchar(32) NOT NULL default '',
|
| 30 |
`a_code_postal` varchar(32) default NULL,
|
14 |
`a_code_postal` varchar(32) default NULL,
|
| 31 |
`a_ville` varchar(255) default NULL,
|
15 |
`a_ville` varchar(255) default NULL,
|
| 32 |
`a_ce_pays` char(3) default NULL,
|
16 |
`a_pays` char(3) default NULL,
|
| 33 |
`a_site_internet` varchar(255) NOT NULL default '',
|
- |
|
| 34 |
`a_region` varchar(255) default NULL,
|
17 |
`a_region` varchar(255) default NULL,
|
| 35 |
`a_code_insee_commune` varchar(255) default NULL,
|
18 |
`a_code_insee_commune` varchar(255) default NULL,
|
| 36 |
`a_numero_dpt` int(10) unsigned default NULL,
|
19 |
`a_numero_dpt` int(10) unsigned default NULL,
|
| 37 |
`a_date_inscription` datetime NOT NULL default '0000-00-00 00:00:00',
|
20 |
`a_date_inscription` datetime NOT NULL default '0000-00-00 00:00:00',
|
| 38 |
`a_est_structure` tinyint(3) unsigned NOT NULL default '0',
|
21 |
`a_est_structure` tinyint(3) unsigned NOT NULL default '0',
|
| 39 |
`a_ce_structure` varchar(255) NOT NULL default '',
|
22 |
`a_structure` varchar(255) NOT NULL default '',
|
| 40 |
`a_appartient_structure` int(10) unsigned NOT NULL default '0',
|
23 |
`a_appartient_structure` int(10) unsigned NOT NULL default '0',
|
| 41 |
`a_sigle_structure` varchar(64) NOT NULL default '',
|
24 |
`a_sigle_structure` varchar(64) NOT NULL default '',
|
| 42 |
`a_num_agrement_fpc` varchar(255) NOT NULL default '',
|
- |
|
| 43 |
`a_voir_sur_carto` int(11) NOT NULL default '0',
|
- |
|
| 44 |
`a_lettre` tinyint(3) unsigned NOT NULL default '0',
|
25 |
`a_lettre` tinyint(3) unsigned NOT NULL default '0',
|
| 45 |
PRIMARY KEY (`a_id`)
|
26 |
PRIMARY KEY (`a_id`)
|
| 46 |
);
|
27 |
) ;
|
| 47 |
|
- |
|
| 48 |
CREATE TABLE `inscription_demande` (
|
28 |
CREATE TABLE `inscription_demande` (
|
| 49 |
`id_identifiant_session` varchar(32) NOT NULL default '',
|
29 |
`id_identifiant_session` varchar(32) NOT NULL default '',
|
| 50 |
`id_donnees` text NOT NULL,
|
30 |
`id_donnees` text NOT NULL,
|
| 51 |
`id_date` date NOT NULL default '0000-00-00',
|
31 |
`id_date` date NOT NULL default '0000-00-00',
|
| 52 |
PRIMARY KEY (`id_identifiant_session`)
|
32 |
PRIMARY KEY (`id_identifiant_session`)
|