MarcWiki

Tables pour les groupes, avec pointeur(s)

mason_obédience

DROP TABLE IF EXISTS `mason_obedience`;
CREATE TABLE IF NOT EXISTS `mason_obedience` (
  `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,
  `us_grade_default` tinyint(3) unsigned NOT NULL default '1',
  `us_grade_min_tenue` tinyint(3) unsigned NOT NULL default '1' COMMENT 'grade min des tenues',
  `us_grade_max_tenue` tinyint(3) unsigned NOT NULL default '33' COMMENT 'grade max des tenues',
  `us_grade_min_initiation` tinyint(3) unsigned NOT NULL default '1',
  `us_grade_max_initiation` tinyint(3) unsigned NOT NULL default '33',
  `csv_a6_languages` varchar(64) character set ascii NOT NULL,
  `csv_a3_countries` varchar(64) character set ascii NOT NULL,
  `id_physical_location` int(11) unsigned NOT NULL,
  `id_postal_location` int(11) unsigned NOT NULL,
  `url_site_web` varchar(255) character set ascii NOT NULL,
  `url_image` varchar(255) character set ascii NOT NULL,
  PRIMARY KEY  (`pid`),
  UNIQUE KEY `lang_name` (`a6_name_lang`(3),`sz_middle_name`(32)),
  KEY `id_physical_location` (`id_physical_location`),
  KEY `id_postal_location` (`id_postal_location`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

INSERT INTO `mason_obedience` (`pid`, `sz_middle_name`, `a6_name_lang`, `us_grade_default`, `us_grade_min_tenue`, `us_grade_max_tenue`, `us_grade_min_initiation`, `us_grade_max_initiation`, `csv_a6_languages`, `csv_a3_countries`, `id_physical_location`, `id_postal_location`, `url_site_web`, `url_image`) VALUES 
(1, 'DH (be)', '', 1, 1, 33, 1, 33, 'fr', 'be', 0, 0, '', ''),
(2, 'GOB', '', 1, 1, 33, 1, 33, 'fr', 'be', 0, 0, '', ''),
(3, 'GOLA (Europe)', '', 1, 1, 33, 1, 33, 'es', 'eur', 0, 0, '', ''),
(4, 'GOLA (America)', '', 1, 1, 33, 1, 33, 'es', 'lat', 0, 0, '', ''),
(5, 'GLB', '', 1, 1, 33, 1, 33, 'fr', 'be', 0, 0, '', ''),
(6, 'GLFB', '', 1, 1, 33, 1, 33, 'fr', 'be', 0, 0, '', ''),
(7, 'GLRB', '', 1, 1, 33, 1, 33, 'fr', 'be', 0, 0, '', ''),
(8, 'DH (fr)', '', 1, 1, 33, 1, 33, 'fr', 'fr', 0, 0, '', ''),
(9, 'GODF', '', 1, 1, 33, 1, 33, 'fr', 'fr', 0, 0, '', '');

mason_loge

-- Structure de la table `mason_loge`

DROP TABLE IF EXISTS `mason_loge`;
CREATE TABLE IF NOT EXISTS `mason_loge` (
  `pid` int(11) unsigned NOT NULL auto_increment,
  `idx_obedience` int(11) NOT NULL default '0' COMMENT 'pid de l''obédience (-1 si sauvage ou 0 inconnu)',
  `usx_numero` mediumint(6) NOT NULL default '0' COMMENT 'par exemple 1469 (Liberté)',
  `idx_orient` int(11) NOT NULL default '0' COMMENT '0 pour inconnu ou -1 itinérante',
  `sz_middle_name` varchar(64) NOT NULL,
  `a6_name_lang` char(6) character set ascii NOT NULL default 'fr',
  `us_grade_default_tenue` tinyint(3) unsigned NOT NULL default '1' COMMENT 'la plupart des tenues on lieu au grade de...',
  `us_grade_min_tenue` tinyint(3) unsigned NOT NULL default '1' COMMENT 'grade min des tenues',
  `us_grade_max_tenue` tinyint(3) unsigned NOT NULL default '3' COMMENT 'grade max des tenues',
  `us_grade_min_initiation` tinyint(3) unsigned NOT NULL default '1',
  `us_grade_max_initiation` tinyint(3) unsigned NOT NULL default '3',
  `csv_a6_languages` varchar(64) character set ascii NOT NULL default 'fr' COMMENT 'comma separated language codes',
  `id_default_physical_location` int(11) unsigned NOT NULL,
  `id_postal_location` int(11) unsigned NOT NULL,
  `url_site_web` varchar(255) character set ascii NOT NULL,
  `url_image` varchar(255) character set ascii NOT NULL,
  PRIMARY KEY  (`pid`),
  UNIQUE KEY `numero_loge_obedience` (`usx_numero`,`a6_name_lang`(3),`sz_middle_name`(32),`idx_obedience`),
  KEY `idx_obedience` (`idx_obedience`),
  KEY `usx_numero` (`usx_numero`),
  KEY `idx_orient` (`idx_orient`),
  KEY `id_default_physical_location` (`id_default_physical_location`),
  KEY `id_postal_location` (`id_postal_location`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- Contenu de la table `mason_loge`

INSERT INTO `mason_loge` (`pid`, `idx_obedience`, `usx_numero`, `idx_orient`, `sz_middle_name`, `a6_name_lang`, `us_grade_default_tenue`, `us_grade_min_tenue`, `us_grade_max_tenue`, `us_grade_min_initiation`, `us_grade_max_initiation`, `csv_a6_languages`, `id_default_physical_location`, `id_postal_location`, `url_site_web`, `url_image`) VALUES 
(1, 1, 1469, 1, 'Liberte', 'fr', 1, 1, 3, 1, 3, 'fr', 0, 0, 'http://www.liberte.be/', ''),
(2, 2, 32, 1, 'ACSO3', 'fr', 1, 1, 3, 1, 3, 'fr', 0, 0, '', ''),
(3, 3, 28, 2, 'Francisco de Miranda', 'fr', 1, 1, 3, 1, 3, 'es,fr,nl', 0, 0, 'http://www.franciscodemiranda.be/', '');