MarcWiki

Db/People/NoPointer

tools_people

-- Structure de la table `tools_people`

DROP TABLE IF EXISTS `tools_people`;
CREATE TABLE IF NOT EXISTS `tools_people` (
  `pid` int(11) unsigned NOT NULL auto_increment,

  `courtoisie` varchar(16) NOT NULL default 'Mme',
  `prenoms` varchar(64) NOT NULL,
  `nom_1` varchar(64) NOT NULL,
  `nom_2` varchar(64) NOT NULL,
  `surnom` varchar(64) NOT NULL,
  `nom_abrege` varchar(64) NOT NULL,

  `date_naissance` date NOT NULL,
  `date_deces` date NOT NULL,
  `sexe` enum('M','F','X') character set ascii NOT NULL,

  `sz_pseudo` varchar(16) NOT NULL 
     COMMENT 'a utiliser si meme sso pour plusieurs people (a eviter)',

  `url_image` varchar(255) character set ascii NOT NULL,
  `url_site_web` varchar(255) character set ascii NOT NULL,
  `email` varchar(128) character set ascii NOT NULL 
      COMMENT 'adresse mail de contact',

  PRIMARY KEY  (`pid`),

  KEY `nom_1` (`nom_1`),
  KEY `nom_2` (`nom_2`),
  KEY `surnom` (`surnom`)

) ENGINE=InnoDB 
  DEFAULT CHARSET=utf8 
  AUTO_INCREMENT=2 ;

-- Contenu de la table `tools_people`

INSERT INTO `tools_people` 
(`pid`, 
`courtoisie`, `prenoms`, `nom_1`, `nom_2`, `surnom`, `nom_abrege`,
`date_naissance`, `date_deces`, `sexe`,
`sz_pseudo`, 
`url_image`, `url_site_web`, `email`
) VALUES 
(1, 'Ir', 'Marc W.F.', 'Meurrens', '', '', 'Marc M.', '1945-11-16', '0000-00-00', 'M', 'marc', '', 'http://www.meurrens.org/', 'marc@meurrens.org');