-- phpMyAdmin SQL Dump
-- version 2.6.2-Debian-3sarge3
-- http://www.phpmyadmin.net
-- 
-- Serveur: localhost
-- Généré le : Mardi 27 Novembre 2007 à 18:29
-- Version du serveur: 4.0.24
-- Version de PHP: 4.3.10-21
-- 
-- Base de données: `africagrenouille`
-- 

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

-- 
-- Structure de la table `cache`
-- 

CREATE TABLE `cache` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `uri` varchar(255) NOT NULL default '',
  `content` mediumtext NOT NULL,
  `timestamp_expire` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `uri` (`uri`),
  KEY `timestamp_expire` (`timestamp_expire`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `client`
-- 

CREATE TABLE `client` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `zone_author_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(48) NOT NULL default '',
  `system` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `zone_author_id` (`zone_author_id`),
  KEY `name` (`name`),
  KEY `system` (`system`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `client_version`
-- 

CREATE TABLE `client_version` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `client_id` smallint(5) unsigned NOT NULL default '0',
  `version` double NOT NULL default '0',
  `beta` tinyint(3) unsigned NOT NULL default '0',
  `build` smallint(5) unsigned NOT NULL default '0',
  `flag_release` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `version` (`version`),
  KEY `beta` (`beta`),
  KEY `build` (`build`),
  KEY `client_id` (`client_id`),
  KEY `flag_release` (`flag_release`)
) TYPE=MyISAM PACK_KEYS=0;

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

-- 
-- Structure de la table `emailing`
-- 

CREATE TABLE `emailing` (
  `email` varchar(80) NOT NULL default '',
  UNIQUE KEY `email` (`email`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `forum`
-- 

CREATE TABLE `forum` (
  `name` varchar(32) NOT NULL default '',
  `long_name` varchar(64) NOT NULL default '',
  `flag_moderate` tinyint(3) unsigned NOT NULL default '0',
  `flag_admin` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`name`),
  KEY `long_name` (`long_name`),
  KEY `flag_admin` (`flag_admin`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `forum_member`
-- 

CREATE TABLE `forum_member` (
  `forum_name` varchar(64) NOT NULL default '',
  `member_zone_id` int(10) unsigned NOT NULL default '0',
  KEY `mailing_list_name` (`forum_name`),
  KEY `member_zone_id` (`member_zone_id`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `forum_message`
-- 

CREATE TABLE `forum_message` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `parent_id` mediumint(8) unsigned NOT NULL default '0',
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `from_zone_id` int(10) unsigned NOT NULL default '0',
  `forum_name` varchar(64) NOT NULL default '',
  `subject` varchar(200) NOT NULL default '',
  `body` text NOT NULL,
  `data` text NOT NULL,
  `status` tinyint(3) unsigned NOT NULL default '0',
  `moderator_zone_id` int(10) unsigned NOT NULL default '0',
  `nb_recipients` smallint(5) unsigned NOT NULL default '0',
  `sending_duration` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `date_time` (`date_time`),
  KEY `from_zone_id` (`from_zone_id`),
  KEY `mailing_list_name` (`forum_name`),
  KEY `nb_recipients` (`nb_recipients`),
  KEY `status` (`status`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `forum_request`
-- 

CREATE TABLE `forum_request` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_name` varchar(128) NOT NULL default '',
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `member_zone_id` int(10) unsigned NOT NULL default '0',
  `forum_long_name` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `forum_name` (`forum_name`),
  KEY `date_time` (`date_time`),
  KEY `member_zone_id` (`member_zone_id`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `gateway`
-- 

CREATE TABLE `gateway` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `name` varchar(80) NOT NULL default '',
  `ip` varchar(16) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`),
  KEY `ip` (`ip`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `http_proxy`
-- 

CREATE TABLE `http_proxy` (
  `url` varchar(255) NOT NULL default '',
  `data` mediumtext NOT NULL,
  `expiration` timestamp(14) NOT NULL,
  PRIMARY KEY  (`url`),
  KEY `expiration` (`expiration`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `indicator`
-- 

CREATE TABLE `indicator` (
  `name` varchar(32) NOT NULL default '',
  `id_zone` int(10) NOT NULL default '0',
  `value` float(10,2) NOT NULL default '0.00',
  `date` date NOT NULL default '0000-00-00'
) TYPE=MyISAM;

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

-- 
-- Structure de la table `isp_property`
-- 

CREATE TABLE `isp_property` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `unit` varchar(8) NOT NULL default '',
  `rank` smallint(5) unsigned NOT NULL default '0',
  `flag_private` tinyint(4) NOT NULL default '0',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`),
  KEY `rank` (`rank`),
  KEY `flag_private` (`flag_private`)
) TYPE=MyISAM PACK_KEYS=0;

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

-- 
-- Structure de la table `log`
-- 

CREATE TABLE `log` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `message` varchar(255) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `measure_batch`
-- 

CREATE TABLE `measure_batch` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `zone_id` int(10) unsigned NOT NULL default '0',
  `timestamp` int(11) NOT NULL default '0',
  `value` float NOT NULL default '0',
  `quantity` smallint(5) unsigned NOT NULL default '0',
  `type` tinyint(3) unsigned NOT NULL default '0',
  `nb_checks` smallint(5) unsigned NOT NULL default '0',
  `next_check_timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `nb_checks` (`nb_checks`),
  KEY `next_check_timestamp` (`next_check_timestamp`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `member`
-- 

CREATE TABLE `member` (
  `zone_id` int(10) unsigned NOT NULL default '0',
  `email` varchar(40) NOT NULL default '',
  `first_name` varchar(20) NOT NULL default '',
  `last_name` varchar(32) NOT NULL default '',
  `client_version_id` smallint(5) unsigned NOT NULL default '0',
  `comment` varchar(200) NOT NULL default '',
  `date_time_create` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip` varchar(16) NOT NULL default '',
  `host` varchar(128) NOT NULL default '',
  `gateway_ip` varchar(16) NOT NULL default '',
  `gateway_id` mediumint(8) unsigned NOT NULL default '0',
  `date_time_next_dl_control` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_time_next_ul_control` datetime NOT NULL default '0000-00-00 00:00:00',
  `flag_control_failed` tinyint(4) NOT NULL default '0',
  UNIQUE KEY `zone_id` (`zone_id`),
  KEY `date_time_create` (`date_time_create`),
  KEY `client_id` (`client_version_id`),
  KEY `ip` (`ip`),
  KEY `gateway_id` (`gateway_id`),
  KEY `gateway_ip` (`gateway_ip`)
) TYPE=MyISAM PACK_KEYS=1;

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

-- 
-- Structure de la table `member_waiting`
-- 

CREATE TABLE `member_waiting` (
  `login` varchar(64) NOT NULL default '',
  `password` varchar(16) NOT NULL default '',
  `parent_id` int(10) unsigned NOT NULL default '0',
  `first_name` varchar(20) NOT NULL default '',
  `last_name` varchar(32) NOT NULL default '',
  `email` varchar(40) NOT NULL default '',
  `district` varchar(32) NOT NULL default '',
  `codeConfirm` varchar(4) NOT NULL default '',
  `statut` enum('en attente','confirme') NOT NULL default 'en attente',
  `date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`login`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `news`
-- 

CREATE TABLE `news` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `subject` varchar(80) NOT NULL default '',
  `body` text NOT NULL,
  `flag_archive` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `date_time` (`date_time`),
  KEY `flag_archive` (`flag_archive`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `property`
-- 

CREATE TABLE `property` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `unit` varchar(8) NOT NULL default '',
  `rank` smallint(5) unsigned NOT NULL default '0',
  `flag_private` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`),
  KEY `rank` (`rank`),
  KEY `flag_private` (`flag_private`)
) TYPE=MyISAM PACK_KEYS=0;

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

-- 
-- Structure de la table `zone`
-- 

CREATE TABLE `zone` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(64) NOT NULL default '',
  `name_short` varchar(64) NOT NULL default '',
  `name_rank` varchar(64) NOT NULL default '',
  `description` varchar(96) NOT NULL default '',
  `type` tinyint(3) unsigned NOT NULL default '0',
  `password` varchar(16) NOT NULL default '',
  `flag_hide` tinyint(3) unsigned NOT NULL default '0',
  `flag_external` tinyint(3) unsigned NOT NULL default '0',
  `district` varchar(64) NOT NULL default '',
  `flag_admin` tinyint(3) unsigned NOT NULL default '0',
  `date_time_last_measure` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `name` (`name`),
  KEY `type` (`type`),
  KEY `flag_hide` (`flag_hide`),
  KEY `date_time_last_measure` (`date_time_last_measure`),
  KEY `name_rank` (`name_rank`),
  KEY `flag_external` (`flag_external`)
) TYPE=MyISAM PACK_KEYS=1;

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

-- 
-- Structure de la table `zone_isp_property`
-- 

CREATE TABLE `zone_isp_property` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `zone_id` int(10) unsigned NOT NULL default '0',
  `property_id` smallint(5) unsigned NOT NULL default '0',
  `value` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `zone_id` (`zone_id`),
  KEY `property_id` (`property_id`)
) TYPE=MyISAM PACK_KEYS=0;

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

-- 
-- Structure de la table `zone_privilege`
-- 

CREATE TABLE `zone_privilege` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `zone_id` int(10) unsigned NOT NULL default '0',
  `privilege` varchar(32) NOT NULL default '',
  `level` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `zone_id` (`zone_id`),
  KEY `privilege` (`privilege`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `zone_property`
-- 

CREATE TABLE `zone_property` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `zone_id` int(10) unsigned NOT NULL default '0',
  `property_id` smallint(5) unsigned NOT NULL default '0',
  `value` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `zone_id` (`zone_id`),
  KEY `property_id` (`property_id`)
) TYPE=MyISAM PACK_KEYS=0;