Subversion Repositories Applications.papyrus

CREATE TABLE `annuaire` (
  `a_id` int(11) unsigned NOT NULL default '0',
  `a_ce_i18n` varchar(8) NOT NULL default '',
  `a_nom` varchar(32) NOT NULL default '',
  `a_prenom` varchar(32) NOT NULL default '',
  `a_profession` varchar(255) NOT NULL default '',
  `a_mot_de_passe` varchar(32) NOT NULL default 'X X',
  `a_mail` varchar(128) NOT NULL default '',
  `a_nom_wikini` varchar(255) NOT NULL default '',
  `a_adresse1` text,
  `a_adresse2` text,
  `a_tel` 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_pays` char(3) default NULL,
  `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_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_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`)
) ;