-- phpMyAdmin SQL Dump
-- version 3.5.2
-- http://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le: Lun 22 Juillet 2013 à 19:36
-- Version du serveur: 5.1.66-0+squeeze1
-- Version de PHP: 5.3.3-7+squeeze15

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de données: `annuaire_education_nationale`
--

-- --------------------------------------------------------

--
-- Structure de la table `group`
--

CREATE TABLE IF NOT EXISTS `group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `nom` (`nom`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Structure de la table `logs`
--

CREATE TABLE IF NOT EXISTS `logs` (
  `idObject` int(11) NOT NULL,
  `action` varchar(15) NOT NULL,
  `user` varchar(15) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ipUser` varchar(15) NOT NULL,
  `host` varchar(250) NOT NULL,
  `other` varchar(250) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `object`
--

CREATE TABLE IF NOT EXISTS `object` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idParent` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `data` longtext NOT NULL,
  `extra` longtext NOT NULL,
  `ugo` varchar(3) NOT NULL,
  `owner` int(11) NOT NULL,
  `group` int(11) NOT NULL,
  `ctime` datetime NOT NULL COMMENT 'Date de creation',
  `mtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date de modification',
  `extra2` text NOT NULL,
  `extra3` text NOT NULL,
  `extra4` text NOT NULL,
  `extra5` text NOT NULL,
  `extra6` text NOT NULL,
  `extra7` text NOT NULL,
  `extra8` text NOT NULL,
  `extra9` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Structure de la table `type`
--

CREATE TABLE IF NOT EXISTS `type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) NOT NULL,
  `twig` varchar(250) NOT NULL,
  `params` longtext NOT NULL,
  `ugo` varchar(3) NOT NULL,
  `owner` int(11) NOT NULL,
  `group` int(11) NOT NULL,
  `nb_childs` int(6) NOT NULL DEFAULT '0',
  `title` varchar(50) NOT NULL,
  `accept` text NOT NULL COMMENT 'liste des type accepté([...]), ou true pour tout les type ',
  `objectField` varchar(50) NOT NULL DEFAULT '' COMMENT 'nom du champ dans paramètres qui contient les données du type',
  `contentTypeField` varchar(50) NOT NULL DEFAULT '' COMMENT 'nom du champ dans paramètres qui contient le mime type à retourné ou string contenant le mime type',
  `badge` varchar(200) NOT NULL DEFAULT '[]',
  `enable` varchar(200) NOT NULL DEFAULT 'true',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Contenu de la table `type`
--

INSERT INTO `type` (`id`, `nom`, `twig`, `params`, `ugo`, `owner`, `group`, `nb_childs`, `title`, `accept`, `objectField`, `contentTypeField`, `badge`, `enable`) VALUES
(1, 'menu', '', '{\r\n  "data":{\r\n    "label":"menu",\r\n   "type":"custom",\r\n    "require":true\r\n  }\r\n}', '777', 1, 1, 0, '', '', 'data', '"text/plain; charset=UTF-8"', '[]', 'true'),
(2, 'article', '', '{\r\n "title":{\r\n   "require":true\r\n  },\r\n  "tags":{\r\n    "require":true\r\n  },\r\n  "post":{\r\n    "require":true\r\n  },\r\n  "description":{\r\n   "require":true\r\n  },\r\n  "logo":{\r\n    "require":false\r\n }\r\n}', '777', 1, 1, 100, 'Article', '[4]', 'post', '"text/html; charset=UTF-8"', '[]', 'true'),
(3, 'dossier', '', '{"name":{"type":"text","required":true}}', '700', 0, 0, -1, 'Dossier', 'true', '', '', '[]', 'true'),
(4, 'document', '', '{\r\n  "name":{\r\n    "locales":"word.name",\r\n    "type":"text",\r\n    "require":true\r\n  },\r\n  "file":{\r\n    "type":"custom",\r\n    "require":true\r\n  },\r\n  "file-mime":{\r\n   "type":"text",\r\n    "require":true\r\n  }\r\n}', '', 0, 0, 0, '', '[4]', 'file', 'file-mime', '[]', 'true'),
(5, 'trombinoscope', '{"Gestion des agents":"trombo/gestAgents","Nouvel agent":"trombo/newAgent"}', '{\n  "nom":{"type":"text","required":true},\n  "prenom":{"type":"text","required":true},\n  "fonction":{"type":"text","required":true},\n  "matricule":{"type":"text","required":true},\n  "data":{"type":"text","required":true},\n  "desc"{"type":"text","required":true}\n}\n', '700', 0, 0, -1, 'Annuaire', 'true', 'data', '"text/html; charset=UTF-8"', '[null,"red"]', 'true'),
(6, 'evenements', '', '{"title":{"type":"text","required":true},"start":{"type":"text","required":true},"end":{"type":"text","required":true},"data":{"type":"text","required":true}}\r\n', '700', 0, 0, 0, 'Agenda', 'true', 'data', '"text/html; charset=UTF-8"', '[null,"red"]', 'true');

-- --------------------------------------------------------

--
-- Structure de la table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) NOT NULL,
  `prenom` varchar(50) NOT NULL,
  `login` varchar(20) NOT NULL,
  `pwd` varchar(50) NOT NULL,
  `other` text NOT NULL,
  `group` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `login` (`login`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Contenu de la table `user`
--

INSERT INTO `user` (`id`, `nom`, `prenom`, `login`, `pwd`, `other`, `group`) VALUES
(1, 'Administrateur', '', 'admin_education', 'c1885c32', '', 0),
(2, 'Administrateur', '', 'd350af5f', 'e51d653e63', '', 0),
(3, 'Administrateur GOL', '', 'joel.assoua', '0d059140fe9da', '', 0),
(4, 'Administrateur GOL', '', 'obi.klaise', '70cfa03ef4dbd', '', 0),
(5, 'Administrateur GOL', '', 'ulrich.badinga', 'ed7b0954953c9', '', 0),
(6, 'Administrateur GOL', '', 'achille.allogho', '27cdb6df1f46d', '', 0),
(7, 'Administrateur GOL', '', 'cedric.ndoumba', '92011103e6717', '', 0),
(8, 'Administrateur GOL', '', 'leontine.mintoo', '187683a477d41', '', 0),
(9, 'Administrateur GOL', '', 'serge.nkoussou', '3618d5114f005', '', 0),
(10, 'Administrateur GOL', '', 'maryse.madiba', 'd2720a4c1cfbc', '', 0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;