-- $Id: install.sql 949 2012-12-05 15:24:12Z mike007 $

CREATE TABLE `ajash00t` (
  `id` int(11) NOT NULL auto_increment,
  `ref` int(5) UNSIGNED NOT NULL default '1',
  `pseudo` varchar(150) NOT NULL default '',
  `message` varchar(250) NOT NULL default '',
  `date` int(12) NOT NULL default '0',
  `ip` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `date` (`date`),
  FULLTEXT KEY `message` (`message`)
) TYPE=MyISAM COMMENT='Module ajash00t : Liste des messages' AUTO_INCREMENT=1 ;

INSERT INTO `parametres` SET `nom`='ajash00t_options', `valeur`='a:2:{i:0;a:11:{s:5:"titre";s:17:"Sh00t Maintenance";s:3:"sep";s:9:"-=-=-=-=-";s:6:"NbMess";i:30;s:7:"rafresh";i:30;s:4:"join";s:3:"oui";s:6:"avatar";i:0;s:3:"son";s:3:"oui";s:13:"desactivation";s:3:"oui";s:6:"timing";i:1800;s:8:"LastTime";i:0;s:4:"smil";a:0:{}}i:1;a:11:{s:5:"titre";s:8:"ajash00t";s:3:"sep";s:9:"-=-=-=-=-";s:6:"NbMess";i:30;s:7:"rafresh";i:30;s:4:"join";s:3:"oui";s:6:"avatar";i:0;s:3:"son";s:3:"oui";s:13:"desactivation";s:3:"oui";s:6:"timing";i:1800;s:8:"LastTime";i:0;s:4:"smil";a:0:{}}}';
INSERT INTO `parametres` SET `nom`='ajash00t_messages', `valeur`='a:1:{i:1;a:2:{s:4:"name";s:5:"Robot";s:9:"urlavatar";s:31:"modules/espion/images/robot.png";}}';

INSERT INTO `droit` SET `module`='ajash00t', `page`='id0_lecture', `grade`='-2', `groupe`='0', `condition`='or';
INSERT INTO `droit` SET `module`='ajash00t', `page`='id0_ecriture', `grade`='-2', `groupe`='0', `condition`='or';
INSERT INTO `droit` SET `module`='ajash00t', `page`='id0_SupMess', `grade`='3', `groupe`='0', `condition`='and';
INSERT INTO `droit` SET `module`='ajash00t', `page`='id1_lecture', `grade`='-1', `groupe`='0', `condition`='or';
INSERT INTO `droit` SET `module`='ajash00t', `page`='id1_ecriture', `grade`='-1', `groupe`='0', `condition`='or';
INSERT INTO `droit` SET `module`='ajash00t', `page`='id1_SupMess', `grade`='3', `groupe`='0', `condition`='and';

INSERT INTO `droit_exclu` SET `module`='ajash00t', `page`='bloc', `accessible`='0';
INSERT INTO `droit_exclu` SET `module`='ajash00t', `page`='fonctions_cssjs', `accessible`='0';
INSERT INTO `droit_exclu` SET `module`='ajash00t', `page`='index', `accessible`='0';
INSERT INTO `droit_exclu` SET `module`='ajash00t', `page`='robot', `accessible`='0';
INSERT INTO `droit_exclu` SET `module`='ajash00t', `page`='xml', `accessible`='0';