MarcWiki

A VIRER Table des statuts personne/loge

mason_statut_loge

-- Structure de la table `mason_statut_loge`

DROP TABLE IF EXISTS `mason_statut_loge`;
CREATE TABLE IF NOT EXISTS `mason_statut_loge` (
  `pid` int(11) unsigned NOT NULL auto_increment,
  `sz_middle_name` varchar(64) NOT NULL,
  `a6_name_lang` char(6) character set ascii NOT NULL default 'fr',
  `mpx_qualite` enum('M','P','X') character set ascii NOT NULL default 'X',
  PRIMARY KEY  (`pid`),
  UNIQUE KEY `lang_name` (`a6_name_lang`(3),`sz_middle_name`(32))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;

 
-- Contenu de la table `mason_statut_loge`

INSERT INTO `mason_statut_loge` (`pid`, `sz_middle_name`, `a6_name_lang`, `z_qualite`) VALUES 
(1, 'Actif', 'fr', 'M'),
(2, 'Congé', 'fr', 'M'),
(3, 'Sommeil', 'fr', 'M'),
(4, 'Suspendu', 'fr', 'M'),
(5, 'Or:.Eternel', 'fr', 'M'),
(6, 'enfant/proche', 'fr', 'P'),
(7, 'E:.A:.', 'fr', 'P'),
(8, 'veuf/veuve', 'fr', 'P'),
(9, 'relation', 'fr', 'P'),
(10, 'candidat', 'fr', 'P');