-- $Id: install.sql 938 2012-09-12 13:23:13Z mike007 $

CREATE TABLE `livredor` (
  `id` int(11) NOT NULL auto_increment,
  `nom` varchar(30) NOT NULL default '',
  `email` varchar(60) NOT NULL default '',
  `ip` varchar(45) NOT NULL default '',
  `date` varchar(30) NOT NULL default '',
  `contenu` text NOT NULL,
  `smileys` tinyint(1) NOT NULL default '1',
  `validation` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='Module livre d or : Liste des messages' AUTO_INCREMENT=1;

INSERT INTO `parametres` SET `nom`='nbrMessagesLivredor', `valeur`='15';

INSERT INTO `droit` SET `module`='livredor', `page`='signer', `grade`='-1', `groupe`='0', `condition`='or';
INSERT INTO `droit` SET `module`='livredor', `page`='consulter', `grade`='-1', `groupe`='0', `condition`='or';

INSERT INTO `droit_exclu` SET `module`='livredor', `page`='index', `accessible`='0';


