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`)
) ;

-- Table pour faire des inscriptions avec wikini
-- OPTIONNELLE
CREATE TABLE `interwikini_users` (
  `name` varchar(80) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `motto` text NOT NULL,
  `revisioncount` int(10) unsigned NOT NULL default '20',
  `changescount` int(10) unsigned NOT NULL default '50',
  `doubleclickedit` enum('Y','N') NOT NULL default 'Y',
  `signuptime` datetime NOT NULL default '0000-00-00 00:00:00',
  `show_comments` enum('Y','N') NOT NULL default 'N',
  PRIMARY KEY  (`name`),
  KEY `idx_name` (`name`),
  KEY `idx_signuptime` (`signuptime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;