-- phpMyAdmin SQL Dump -- version 2.9.1.1-Debian-13 -- http://www.phpmyadmin.net -- -- Serveur: localhost -- Généré le : Mercredi 24 Février 2010 à 10:56 -- Version du serveur: 5.0.32 -- Version de PHP: 4.4.4-8+etch6
MarcWiki
Le wiki de Marc Meurrens
connexion : Se connecter
(no edit access)
Dump
--
-- Structure de la table `mason_agenda_activite_reunion`
--
CREATE TABLE `mason_agenda_activite_reunion` (
`pid` int(11) unsigned NOT NULL auto_increment,
`id_reunion` int(11) unsigned NOT NULL default '0',
`numero_ordre_du_jour` tinyint(3) unsigned NOT NULL default '1',
`id_type_activite` int(11) unsigned NOT NULL default '0',
`sz_long_name` varchar(255) NOT NULL,
`a6_lang_name` char(6) character set ascii NOT NULL COMMENT 'langue des textes de ce record',
`csv_a6_langues_activite` varchar(32) character set ascii NOT NULL default ',fr,',
PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `mason_agenda_activite_reunion`
--
-- --------------------------------------------------------
--
-- Structure de la table `mason_agenda_doc_diffusion`
--
CREATE TABLE `mason_agenda_doc_diffusion` (
`value` tinyint(3) NOT NULL,
`meaning` varchar(255) NOT NULL,
PRIMARY KEY (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Contenu de la table `mason_agenda_doc_diffusion`
--
INSERT INTO `mason_agenda_doc_diffusion` (`value`, `meaning`) VALUES
(20, 'COD (soustraire read level !) voir table des charges'),
(30, 'membres at:. selon sso table'),
(40, 'les maçons identifies dans people'),
(50, '30 + 40'),
(60, 'tous les sso-id pour toutes les LL:.');
-- --------------------------------------------------------
--
-- Structure de la table `mason_agenda_doc_rituel`
--
CREATE TABLE `mason_agenda_doc_rituel` (
`value` char(1) NOT NULL,
`meaning` varchar(255) NOT NULL,
PRIMARY KEY (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Contenu de la table `mason_agenda_doc_rituel`
--
INSERT INTO `mason_agenda_doc_rituel` (`value`, `meaning`) VALUES
('B', 'rituel blanc'),
('I', 'informel'),
('Q', 'inconnu/ne sait pas'),
('R', 'rituel'),
('X', 'autre');
-- --------------------------------------------------------
--
-- Structure de la table `mason_agenda_reunion_audit`
--
CREATE TABLE `mason_agenda_reunion_audit` (
`pid` int(11) unsigned NOT NULL auto_increment COMMENT 'primary key',
`id_entry_audit` int(11) unsigned NOT NULL default '0' COMMENT 'pointeur vers table tools_entry_audit',
`id_loge_organisatrice` int(11) unsigned NOT NULL default '0',
`id_location` int(11) unsigned NOT NULL default '0',
`id_type_acces` int(11) unsigned NOT NULL default '0',
`id_type_reunion` int(11) unsigned NOT NULL default '0',
`a6_lang_titre` char(6) character set ascii NOT NULL COMMENT 'langue titre + consignes',
`sz_titre` varchar(255) NOT NULL COMMENT 'titre de l''activite',
`sz_consignes` varchar(255) NOT NULL COMMENT 'agapes, en sombre, malentendants, etc',
`mixite` enum('M','F','S') NOT NULL COMMENT 'Mixte, FF:. only, SS:. only',
`csv_a6_langues` varchar(32) character set ascii NOT NULL,
`numero_grade` tinyint(3) NOT NULL default '1',
`csv_id_statut_ordre` varchar(64) character set ascii NOT NULL,
PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `mason_agenda_reunion_audit`
--
-- --------------------------------------------------------
--
-- Structure de la table `mason_agenda_reunion_loge`
--
CREATE TABLE `mason_agenda_reunion_loge` (
`pid` int(11) unsigned NOT NULL auto_increment,
`id_loge` int(11) unsigned NOT NULL default '0',
`id_reunion` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='les loges "supplementaires" qui organisent une reunion' AUTO_INCREMENT=1 ;
--
-- Contenu de la table `mason_agenda_reunion_loge`
--
-- --------------------------------------------------------
--
-- Structure de la table `mason_agenda_type_acces`
--
CREATE TABLE `mason_agenda_type_acces` (
`pid` int(11) unsigned NOT NULL auto_increment,
`sz_long_name` varchar(128) NOT NULL,
`a6_name_lang` char(6) character set ascii NOT NULL default 'fr',
`csv_id_statut_ordre` varchar(128) character set ascii NOT NULL,
PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Contenu de la table `mason_agenda_type_acces`
--
INSERT INTO `mason_agenda_type_acces` (`pid`, `sz_long_name`, `a6_name_lang`, `csv_id_statut_ordre`) VALUES
(1, 'Autre...', 'fr', '');
-- --------------------------------------------------------
--
-- Structure de la table `mason_agenda_type_activite`
--
CREATE TABLE `mason_agenda_type_activite` (
`pid` int(11) unsigned NOT NULL auto_increment,
`sz_long_name` varchar(128) NOT NULL,
`a6_name_lang` char(6) character set ascii NOT NULL default 'fr',
PRIMARY KEY (`pid`),
UNIQUE KEY `lang_name` (`a6_name_lang`(3),`sz_long_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='genres de reunion et valeurs par defaut associees' AUTO_INCREMENT=7 ;
--
-- Contenu de la table `mason_agenda_type_activite`
--
INSERT INTO `mason_agenda_type_activite` (`pid`, `sz_long_name`, `a6_name_lang`) VALUES
(0, 'Autre...', 'fr'),
(3, 'Planche', 'fr'),
(4, '5 minutes de symbolisme', 'fr'),
(5, '5 minutes d''actualité', 'fr'),
(6, 'rapport du convent', 'fr');
-- --------------------------------------------------------
--
-- Structure de la table `mason_agenda_type_reunion`
--
CREATE TABLE `mason_agenda_type_reunion` (
`pid` int(11) unsigned NOT NULL auto_increment,
`sz_long_name` varchar(128) NOT NULL,
`a6_name_lang` char(6) character set ascii NOT NULL default 'fr',
`numero_default_grade` tinyint(3) NOT NULL default '1',
`id_default_acces` int(11) unsigned NOT NULL default '1',
PRIMARY KEY (`pid`),
UNIQUE KEY `lang_name` (`a6_name_lang`(3),`sz_long_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='genres de reunion et valeurs par defaut associees' AUTO_INCREMENT=10 ;
--
-- Contenu de la table `mason_agenda_type_reunion`
--
INSERT INTO `mason_agenda_type_reunion` (`pid`, `sz_long_name`, `a6_name_lang`, `numero_default_grade`, `id_default_acces`) VALUES
(1, 'Ten:. au gr:. d''A:. ouverte aux FF:. et SS:. des Obed:. amies', 'fr', 1, 1),
(2, 'Initiation au gr:. d''A:. ouverte aux FF:. et SS:. des Obed:. ami', 'fr', 1, 1),
(3, 'Ten:. au gr:. de C:. ouverte aux FF:. et SS:. des Obed:. amies', 'fr', 2, 1),
(4, 'Retour des CC:., ten:. au 2° ouverte aux FF:. et SS:. des Obed:.', 'fr', 2, 1),
(5, 'Passage au gr:. de C:., ten:. ouverte aux FF:. et SS:. des Obed:', 'fr', 2, 1),
(6, 'Elevation au gr:. de M:., ten:. ouverte aux FF:. et SS:. des Obe', 'fr', 3, 1),
(7, 'Ten:. gr:. de M:. ouverte aux FF:. et SS:. des Obed:. amies', 'fr', 3, 1),
(8, 'Adoption d''E:.A:. ouverte aux FF:., SS:. et E:.A:.', 'fr', 0, 2),
(9, 'Autre...', 'fr', 1, 1);
-- --------------------------------------------------------
--
-- Structure de la table `mason_charge_loge`
--
CREATE TABLE `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,
`z_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);
-- --------------------------------------------------------
--
-- Structure de la table `mason_charge_obedience`
--
CREATE TABLE `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');
-- --------------------------------------------------------
--
-- Structure de la table `mason_doc_action`
--
CREATE TABLE `mason_doc_action` (
`action` varchar(16) character set ascii NOT NULL,
`meaning` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Contenu de la table `mason_doc_action`
--
-- --------------------------------------------------------
--
-- Structure de la table `mason_grade`
--
CREATE TABLE `mason_grade` (
`numero` tinyint(3) unsigned NOT NULL default '1',
`sz_middle_name` varchar(64) NOT NULL,
`a6_name_lang` char(6) character set ascii NOT NULL,
PRIMARY KEY (`numero`),
UNIQUE KEY `lang_name` (`a6_name_lang`(3),`sz_middle_name`(32))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Contenu de la table `mason_grade`
--
INSERT INTO `mason_grade` (`numero`, `sz_middle_name`, `a6_name_lang`) VALUES
(0, 'prof:.', 'fr'),
(1, 'A:.', 'fr'),
(2, 'C:.', 'fr'),
(3, 'M:.', 'fr');
-- --------------------------------------------------------
--
-- Structure de la table `mason_initiation`
--
CREATE TABLE `mason_initiation` (
`pid` int(11) unsigned NOT NULL auto_increment,
`id_people` int(11) unsigned NOT NULL default '0',
`id_loge` int(11) unsigned NOT NULL default '0',
`numero_grade` tinyint(3) NOT NULL default '1',
`date_initiation` date NOT NULL,
PRIMARY KEY (`pid`),
UNIQUE KEY `people_grade` (`id_people`,`numero_grade`),
KEY `loge` (`id_loge`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `mason_initiation`
--
-- --------------------------------------------------------
--
-- Structure de la table `mason_loge`
--
CREATE TABLE `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/', '');
-- --------------------------------------------------------
--
-- Structure de la table `mason_loge_sso_id`
--
CREATE TABLE `mason_loge_sso_id` (
`pid` int(11) unsigned NOT NULL auto_increment,
`id_loge` int(11) unsigned NOT NULL default '0',
`sso_service` varchar(16) character set ascii NOT NULL,
`sso_id` varchar(255) character set ascii NOT NULL,
`date_debut` date NOT NULL,
`date_fin` date NOT NULL,
`id_audit` int(11) unsigned NOT NULL,
PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `mason_loge_sso_id`
--
-- --------------------------------------------------------
--
-- Structure de la table `mason_obedience`
--
CREATE TABLE `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 ;
--
-- Contenu de la table `mason_obedience`
--
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, '', '');
-- --------------------------------------------------------
--
-- Structure de la table `mason_orient`
--
CREATE TABLE `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');
-- --------------------------------------------------------
--
-- Structure de la table `mason_people_action`
--
CREATE TABLE `mason_people_action` (
`pid` int(11) unsigned NOT NULL auto_increment,
`action` varchar(16) character set ascii NOT NULL,
`id_people` int(11) unsigned NOT NULL default '0',
`parameters` varchar(255) character set ascii NOT NULL,
PRIMARY KEY (`pid`),
KEY `id_people` (`id_people`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `mason_people_action`
--
-- --------------------------------------------------------
--
-- Structure de la table `mason_people_charge_loge`
--
CREATE TABLE `mason_people_charge_loge` (
`pid` int(11) unsigned NOT NULL auto_increment,
`id_loge` int(11) unsigned NOT NULL default '0',
`id_people` int(11) unsigned NOT NULL default '0',
`id_charge_loge` int(11) unsigned NOT NULL default '0',
`z_member` enum('Y','N','Q') character set ascii NOT NULL,
`date_debut` date NOT NULL,
`date_fin` date NOT NULL,
`us_read_level` tinyint(2) NOT NULL default '5',
`us_write_level` tinyint(2) NOT NULL default '5',
PRIMARY KEY (`pid`),
KEY `loge_charge` (`id_loge`,`id_charge_loge`),
KEY `people` (`id_people`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `mason_people_charge_loge`
--
-- --------------------------------------------------------
--
-- Structure de la table `mason_people_charge_obedience`
--
CREATE TABLE `mason_people_charge_obedience` (
`pid` int(11) unsigned NOT NULL auto_increment,
`id_obedience` int(11) unsigned NOT NULL default '0',
`id_people` int(11) unsigned NOT NULL default '0',
`id_charge_obedience` int(11) unsigned NOT NULL default '0',
`date_debut` date NOT NULL,
`date_fin` date NOT NULL,
PRIMARY KEY (`pid`),
KEY `people` (`id_people`),
KEY `obedience_charge` (`id_obedience`,`id_charge_obedience`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `mason_people_charge_obedience`
--
-- --------------------------------------------------------
--
-- Structure de la table `mason_people_statut_loge`
--
CREATE TABLE `mason_people_statut_loge` (
`pid` int(11) unsigned NOT NULL auto_increment,
`id_loge` int(11) unsigned NOT NULL default '0',
`id_people` int(11) unsigned NOT NULL default '0',
`id_statut` int(11) unsigned NOT NULL default '0',
`date_debut` date NOT NULL,
`date_fin` date NOT NULL,
`date_verification` date NOT NULL,
`id_people_verificateur` int(11) unsigned NOT NULL default '0',
`matricule_dh` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`pid`),
KEY `loge_charge` (`id_loge`,`id_statut`),
KEY `people` (`id_people`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `mason_people_statut_loge`
--
-- --------------------------------------------------------
--
-- Structure de la table `mason_statut_loge`
--
CREATE TABLE `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',
`z_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=11 ;
--
-- 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');
-- --------------------------------------------------------
--
-- Structure de la table `mason_statut_ordre`
--
CREATE TABLE `mason_statut_ordre` (
`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',
`z_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_ordre`
--
INSERT INTO `mason_statut_ordre` (`pid`, `sz_middle_name`, `a6_name_lang`, `z_qualite`) VALUES
(7, 'E:.A:.', 'fr', 'P'),
(11, 'prof:. parent/proche d''un E:.A:.', 'fr', 'P'),
(12, 'prof:. invité comme conférencier', 'fr', 'P'),
(13, 'prof:. invite par le V:.M:.', 'fr', 'P'),
(14, 'prof:. dont les FF:. et SS:. repondent', 'fr', 'P'),
(15, 'prof:. (public)', 'fr', 'P'),
(16, 'Membres de l''at:.', 'fr', 'M'),
(17, 'FF:. et SS:. membres de l''Obed:.', 'fr', 'M'),
(18, 'FF:. et SS:. membres des Obed:. amies', 'fr', 'M'),
(19, 'FF:. membres des Obed:. amies', 'fr', 'M'),
(20, 'FF:. membres de l''Obed:.', 'fr', 'M'),
(21, 'SS:. membres des Obed:. amies', 'fr', 'M'),
(22, 'SS:. membres de l''Obed:.', 'fr', 'M');
-- --------------------------------------------------------
--
-- Structure de la table `tools_audit_session`
--
CREATE TABLE `tools_audit_session` (
`pid` int(11) unsigned NOT NULL auto_increment,
`unix_time` int(11) unsigned NOT NULL,
`ip` char(15) character set ascii NOT NULL,
`client_host` varchar(128) character set ascii NOT NULL,
`user_agent` varchar(255) character set ascii NOT NULL,
`referer` varchar(255) character set ascii NOT NULL,
`accept_language` varchar(255) character set ascii NOT NULL,
`accept_types` varchar(255) character set ascii NOT NULL,
`sso_service` varchar(16) character set ascii NOT NULL,
`sso_id` varchar(255) character set ascii NOT NULL,
`id_people` int(11) unsigned NOT NULL,
`applic_table` varchar(64) character set ascii NOT NULL,
PRIMARY KEY (`pid`),
KEY `id_people` (`id_people`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `tools_audit_session`
--
-- --------------------------------------------------------
--
-- Structure de la table `tools_babel`
--
CREATE TABLE `tools_babel` (
`pid` int(11) unsigned NOT NULL auto_increment COMMENT 'primary key',
`a6_lang` char(6) character set ascii NOT NULL COMMENT 'langue du texte figurant dans les tables et programmes',
`sz_short` varchar(32) NOT NULL,
`sz_middle` varchar(64) NOT NULL COMMENT 'texte dans la langue a6_lang',
`sz_long` varchar(128) NOT NULL,
`id_shared_token` int(11) unsigned NOT NULL,
PRIMARY KEY (`pid`),
UNIQUE KEY `short` (`a6_lang`,`sz_short`),
KEY `id_shared_token` (`id_shared_token`),
KEY `middle` (`a6_lang`,`sz_middle`(32))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='traductions et abbréviations' AUTO_INCREMENT=14 ;
--
-- Contenu de la table `tools_babel`
--
INSERT INTO `tools_babel` (`pid`, `a6_lang`, `sz_short`, `sz_middle`, `sz_long`, `id_shared_token`) VALUES
(1, 'fr', 'BE', 'Belgique', 'Royaume de Belgique', 1),
(3, 'fr', 'A:.', 'A:.', 'Apprenti', 2),
(4, 'fr', 'AA:.', 'AA:.', 'Apprentis', 3),
(5, 'fr', 'FF:.', 'FF:.', 'Frères', 4),
(6, 'nl', 'ZZ:.', 'ZZ:.', 'Zusters', 5),
(7, 'fr', 'FR', 'France', 'France', 6),
(8, 'nl', 'Aalst', 'Aalst', 'Aalst', 7),
(9, 'fr', 'Bxl', 'Bruxelles', 'Bruxelles', 8),
(10, 'nl', 'Bsl', 'Brussel', 'Brussel', 8),
(11, 'fr', 'SS:.', 'SS:.', 'Soeurs', 5),
(12, 'es', 'HH:.', 'HH:.', 'Hermanos', 4),
(13, 'fr', 'Alost', 'Alost', 'Alost', 7);
-- --------------------------------------------------------
--
-- Structure de la table `tools_country`
--
CREATE TABLE `tools_country` (
`a3_iso_639_country_code` char(3) character set ascii NOT NULL COMMENT 'code ISO-639 du pays en 2 caractères ou code ad-hoc',
`sz_country_middle_name` varchar(64) NOT NULL COMMENT 'nom du pays dans la langue spécifiée par a6_iso_3166_country_name',
`a6_iso_3166_country_name` char(6) character set ascii NOT NULL COMMENT 'code iso 3166 (en 2 ou 3 chars + pays?) de la langue utilisée pour le nom du pays (fr, es-CU, ast)',
PRIMARY KEY (`a3_iso_639_country_code`),
UNIQUE KEY `name` (`a6_iso_3166_country_name`,`sz_country_middle_name`(32))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='les pays par code ISO 639 (a2)';
--
-- Contenu de la table `tools_country`
--
INSERT INTO `tools_country` (`a3_iso_639_country_code`, `sz_country_middle_name`, `a6_iso_3166_country_name`) VALUES
('be', 'Belgique', 'fr'),
('es', 'Spain', 'en'),
('eur', 'Europe', 'fr'),
('fr', 'France', 'fr'),
('it', 'Italia', 'it'),
('lat', 'America Latina', 'es');
-- --------------------------------------------------------
--
-- Structure de la table `tools_doc_action`
--
CREATE TABLE `tools_doc_action` (
`action` varchar(16) character set ascii NOT NULL,
`meaning` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Contenu de la table `tools_doc_action`
--
-- --------------------------------------------------------
--
-- Structure de la table `tools_doc_entry_flag`
--
CREATE TABLE `tools_doc_entry_flag` (
`value` tinyint(3) NOT NULL,
`meaning` varchar(255) NOT NULL,
PRIMARY KEY (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Contenu de la table `tools_doc_entry_flag`
--
INSERT INTO `tools_doc_entry_flag` (`value`, `meaning`) VALUES
(1, 'le createur peut lire'),
(2, 'le createur peut modifier'),
(4, 'un redacteur peut lire'),
(8, 'un redacteur peut modifier'),
(16, 'un administrateur peut lire'),
(32, 'un administrateur peut modifier'),
(64, 'tout le monde peut lire (selon diffusion prevue)'),
(127, 'tout le monde peut ecrire (selon diffusion prevue) ');
-- --------------------------------------------------------
--
-- Structure de la table `tools_entry_audit`
--
CREATE TABLE `tools_entry_audit` (
`pid` int(11) unsigned NOT NULL auto_increment,
`id_create_session` int(11) unsigned NOT NULL default '0',
`id_last_modif_session` int(11) unsigned NOT NULL default '0',
`unix_time_begin` int(11) unsigned NOT NULL default '0',
`unix_time_end` int(11) unsigned NOT NULL default '0',
`applic_table` varchar(64) character set ascii NOT NULL,
`rw_mode` tinyint(3) unsigned NOT NULL default '51' COMMENT 'flags : 51 = 1+2+16+32',
PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `tools_entry_audit`
--
-- --------------------------------------------------------
--
-- Structure de la table `tools_language`
--
CREATE TABLE `tools_language` (
`a6_iso_3166` char(6) character set ascii NOT NULL COMMENT 'ISO 3166 code (a2/a3) + optional country code',
`sz_language_name` varchar(64) NOT NULL COMMENT 'nom de la langue, dans cette langue',
`z_active` enum('Y','N','Q') character set ascii NOT NULL default 'Q' COMMENT 'cette langue est-elle vraiment disponible dans l''interface ou les données?',
PRIMARY KEY (`a6_iso_3166`),
UNIQUE KEY `name` (`sz_language_name`(32))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='les langues possibles de l''interface et des data';
--
-- Contenu de la table `tools_language`
--
INSERT INTO `tools_language` (`a6_iso_3166`, `sz_language_name`, `z_active`) VALUES
('ast', 'Babel (Asturiano)', 'N'),
('es', 'Castillan', 'Y'),
('es-CL', 'castillano (Chili)', 'N'),
('fr', 'Français', 'Y'),
('nl', 'Nederlands', 'Y');
-- --------------------------------------------------------
--
-- Structure de la table `tools_location`
--
CREATE TABLE `tools_location` (
`pid` int(11) unsigned NOT NULL COMMENT 'primary key',
`a2_country` char(2) character set ascii NOT NULL default 'be',
`a8_zip` char(8) character set ascii NOT NULL default '1090',
`latitude` float NOT NULL default '0',
`longitude` float NOT NULL default '0',
`sz_line_1` varchar(255) NOT NULL,
`sz_line_2` varchar(255) NOT NULL,
`sz_line_3` varchar(255) NOT NULL,
`url_photo` varchar(255) character set ascii NOT NULL COMMENT 'URL d''un PNG/JPG/GIF photo associée à ce lieu',
`url_map` varchar(255) character set ascii NOT NULL COMMENT 'URL PNG/JPG/GIF d''un plan associé à ce lieu',
PRIMARY KEY (`pid`),
KEY `country_zip` (`a2_country`,`a8_zip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='lieux de réunions, adresses postales, etc (+coord for maps?)';
--
-- Contenu de la table `tools_location`
--
-- --------------------------------------------------------
--
-- Structure de la table `tools_people`
--
CREATE TABLE `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,
`sso_service` varchar(16) character set ascii NOT NULL,
`sso_id` varchar(256) character set ascii NOT NULL,
`sso_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`, `sso_service`, `sso_id`, `sso_pseudo`, `url_image`, `url_site_web`, `email`) VALUES
(1, 'Mr', 'Marc W.F.', 'Meurrens', '', '', 'Marc M.', '1945-11-16', '0000-00-00', 'M', '', '', 'marc', '', 'http://www.meurrens.org/', 'marc@meurrens.org');
-- --------------------------------------------------------
--
-- Structure de la table `tools_people_action`
--
CREATE TABLE `tools_people_action` (
`pid` int(11) unsigned NOT NULL auto_increment,
`action` varchar(16) character set ascii NOT NULL,
`id_people` int(11) unsigned NOT NULL default '0',
`parameters` varchar(255) character set ascii NOT NULL,
PRIMARY KEY (`pid`),
KEY `id_people` (`id_people`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `tools_people_action`
--
-- --------------------------------------------------------
--
-- Structure de la table `tools_sql_query`
--
CREATE TABLE `tools_sql_query` (
`pid` int(11) unsigned NOT NULL auto_increment,
`sz_application` varchar(16) character set ascii NOT NULL default 'mason',
`sz_middle_name` varchar(64) NOT NULL,
`a6_name_lang` char(6) character set ascii NOT NULL,
`query` text character set ascii NOT NULL,
PRIMARY KEY (`pid`),
UNIQUE KEY `lang_name_applic` (`a6_name_lang`(3),`sz_middle_name`(32),`sz_application`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `tools_sql_query`
--
Ajouter un commentaire
Ajouter un commentaire