MarcWiki

Tables sans pointeur pour la gestion des 'groupes'

mason_orient

-- Structure de la table `mason_orient`

DROP TABLE IF EXISTS `mason_orient`;
CREATE TABLE IF NOT EXISTS `mason_orient` (
  `pid` int(11) unsigned NOT NULL auto_increment,
  `sz_middle_name` varchar(64) NOT NULL,
  `a6_name_language` char(6) character set ascii NOT NULL,
  `a3_country` char(3) character set ascii NOT NULL,
  PRIMARY KEY  (`pid`),
  UNIQUE KEY `lang_name_country` (`a6_name_language`(3),`sz_middle_name`(32),`a3_country`),
  KEY `a3_country` (`a3_country`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- Contenu de la table `mason_orient`

INSERT INTO `mason_orient` (`pid`, `sz_middle_name`, `a6_name_language`, `a3_country`) VALUES 
(1, 'Bruxelles', 'fr', 'be'),
(2, 'Aalst', 'nl', 'be'),
(3, 'Antwerpen', 'nl', 'be'),
(4, 'Charleroi', 'fr', 'be');

mason_charge_loge

• mason_charge_loge

-- Structure de la table `mason_charge_loge`

DROP TABLE IF EXISTS `mason_charge_loge`;
CREATE TABLE IF NOT EXISTS `mason_charge_loge` (
  `pid` int(11) unsigned NOT NULL auto_increment,
  `sz_middle_name` varchar(64) NOT NULL,
  `a6_name_language` char(6) character set ascii NOT NULL,
  `ynq_member` enum('Y','N','Q') character set ascii NOT NULL default 'Q',
  `us_default_read_level` tinyint(2) unsigned NOT NULL default '5' COMMENT '(0 à 9) (pour edition des data)',
  `us_default_write_level` tinyint(2) unsigned NOT NULL default '5',
  PRIMARY KEY  (`pid`),
  UNIQUE KEY `lang_name` (`a6_name_language`(3),`sz_middle_name`(32))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- Contenu de la table `mason_charge_loge`

INSERT INTO `mason_charge_loge` (`pid`, `sz_middle_name`, `a6_name_language`, `z_member`, `us_default_read_level`, `us_default_write_level`) VALUES 
(1, 'V:.M:.', 'fr', 'Y', 5, 5),
(2, 'Responsable Sécurité', 'fr', 'N', 5, 5);

mason_charge_obedience

• mason_charge_obedience

• mason_charge_obedience

-- Structure de la table `mason_charge_obedience`

DROP TABLE IF EXISTS `mason_charge_obedience`;
CREATE TABLE IF NOT EXISTS `mason_charge_obedience` (
  `pid` int(11) unsigned NOT NULL auto_increment,
  `sz_middle_name` varchar(64) NOT NULL,
  `a6_name_language` char(6) character set ascii NOT NULL,
  PRIMARY KEY  (`pid`),
  UNIQUE KEY `lang_name` (`a6_name_language`(3),`sz_middle_name`(32))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- Contenu de la table `mason_charge_obedience`

INSERT INTO `mason_charge_obedience` (`pid`, `sz_middle_name`, `a6_name_language`) VALUES 
(1, 'T:.P:.G:.C:.', 'fr'),
(2, 'G:.M:.N:.', 'fr');