-- MariaDB dump 10.19  Distrib 10.11.6-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: dabase
-- ------------------------------------------------------
-- Server version	10.11.6-MariaDB-0+deb12u1-log

/*!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 utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `articles`
--

DROP TABLE IF EXISTS `articles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `articles` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `topic_id` int(3) NOT NULL DEFAULT 1,
  `section_id` int(3) NOT NULL DEFAULT 1,
  `folio_id` int(6) NOT NULL DEFAULT 0,
  `author_id` int(6) NOT NULL DEFAULT 1,
  `user_id` int(6) NOT NULL DEFAULT 1,
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `version` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `title` varchar(250) NOT NULL DEFAULT '',
  `keywords` varchar(255) NOT NULL DEFAULT '',
  `body` longtext DEFAULT NULL,
  `intro` longtext DEFAULT NULL,
  `outro` longtext DEFAULT NULL,
  `chapo` longtext NOT NULL,
  `subtitle` varchar(200) NOT NULL DEFAULT '',
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `post_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_phare` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `auto_folio` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `section` (`section_id`),
  KEY `topic` (`topic_id`),
  KEY `user_id` (`user_id`),
  KEY `state` (`state`,`section_id`,`topic_id`),
  KEY `state_2` (`state`,`timestamp`),
  KEY `title` (`title`),
  KEY `is_phare` (`is_phare`),
  KEY `state_3` (`state`,`post_timestamp`,`section_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12293 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `articles_sections`
--

DROP TABLE IF EXISTS `articles_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `articles_sections` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `section` varchar(50) NOT NULL DEFAULT '',
  `longname` varchar(50) NOT NULL DEFAULT '',
  `template` varchar(50) NOT NULL DEFAULT '',
  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `main` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `is_listed` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `rank` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `section_parent` int(3) NOT NULL DEFAULT 0,
  `has_intro` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `default_images_sections` int(11) NOT NULL DEFAULT 0,
  `phare_template` varchar(50) NOT NULL DEFAULT '',
  `phare_images_sections` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `spec` (`is_listed`),
  KEY `section_parent` (`section_parent`),
  KEY `state` (`state`,`main`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `auth_users_zones`
--

DROP TABLE IF EXISTS `auth_users_zones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_users_zones` (
  `user_id` int(6) NOT NULL DEFAULT 1,
  `zone_id` int(5) NOT NULL DEFAULT 0,
  `r_read` int(1) NOT NULL DEFAULT 0,
  `r_write` int(1) NOT NULL DEFAULT 0,
  KEY `user_id` (`user_id`,`zone_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `auth_zones`
--

DROP TABLE IF EXISTS `auth_zones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_zones` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` char(10) NOT NULL DEFAULT '',
  `state` int(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `board`
--

DROP TABLE IF EXISTS `board`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `board` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `message` varchar(255) NOT NULL DEFAULT '',
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `ip` varchar(8) NOT NULL DEFAULT '0',
  `section` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `user_id` int(6) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM AUTO_INCREMENT=169534 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `board_denied`
--

DROP TABLE IF EXISTS `board_denied`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `board_denied` (
  `user_id` int(6) DEFAULT NULL,
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `comments`
--

DROP TABLE IF EXISTS `comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) NOT NULL DEFAULT '',
  `body` longtext NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `news_id` int(6) NOT NULL DEFAULT 0,
  `user_id` int(6) NOT NULL DEFAULT 1,
  `com_parent` int(11) NOT NULL DEFAULT 0,
  `com_thread` int(11) NOT NULL DEFAULT 0,
  `ip` varchar(8) NOT NULL DEFAULT '0',
  `sig_id` int(6) NOT NULL DEFAULT 1,
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `author_id` int(6) NOT NULL DEFAULT 1,
  `send_email` tinyint(1) NOT NULL DEFAULT 0,
  `state` tinyint(4) NOT NULL DEFAULT 0,
  `section_id` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `com_parent` (`com_parent`),
  KEY `res_type` (`res_type`,`news_id`),
  KEY `score` (`state`)
) ENGINE=MyISAM AUTO_INCREMENT=89260 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `comments_abuse`
--

DROP TABLE IF EXISTS `comments_abuse`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `comments_abuse` (
  `event_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `comment_id` int(11) NOT NULL DEFAULT 0,
  `user_id` int(6) NOT NULL DEFAULT 1,
  KEY `comment_id` (`comment_id`),
  KEY `event_timestamp` (`event_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `comments_audit`
--

DROP TABLE IF EXISTS `comments_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `comments_audit` (
  `event_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `comment_id` int(11) NOT NULL DEFAULT 0,
  `user_id` int(6) NOT NULL DEFAULT 1,
  `state` tinyint(1) NOT NULL DEFAULT 0,
  KEY `comment_id` (`comment_id`),
  KEY `event_timestamp` (`event_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `comments_sections`
--

DROP TABLE IF EXISTS `comments_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `comments_sections` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `section` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `comments_states`
--

DROP TABLE IF EXISTS `comments_states`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `comments_states` (
  `id` tinyint(4) NOT NULL DEFAULT 0,
  `state` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `contents_bookmarked`
--

DROP TABLE IF EXISTS `contents_bookmarked`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contents_bookmarked` (
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `res_id` int(6) unsigned NOT NULL DEFAULT 1,
  `user_id` int(6) unsigned NOT NULL DEFAULT 1,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`res_type`,`res_id`,`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `contents_scored`
--

DROP TABLE IF EXISTS `contents_scored`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contents_scored` (
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `res_id` int(6) NOT NULL DEFAULT 1,
  `user_id` int(6) unsigned NOT NULL DEFAULT 1,
  `score` tinyint(1) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`res_type`,`res_id`,`user_id`),
  KEY `id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `countries`
--

DROP TABLE IF EXISTS `countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `countries` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `country` char(2) NOT NULL DEFAULT '',
  `description` varchar(30) NOT NULL DEFAULT '',
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lang` (`country`)
) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `dates`
--

DROP TABLE IF EXISTS `dates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dates` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `description` varchar(255) NOT NULL DEFAULT '',
  `title_id` int(5) NOT NULL DEFAULT 0,
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `user_id` int(6) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `timestamp2` (`timestamp`),
  KEY `title_id` (`title_id`)
) ENGINE=MyISAM AUTO_INCREMENT=60464 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `dates_titles`
--

DROP TABLE IF EXISTS `dates_titles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dates_titles` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL DEFAULT '',
  `alpha` varchar(250) NOT NULL DEFAULT '',
  `topic_id` int(3) NOT NULL DEFAULT 0,
  `main` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `ip` varchar(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`),
  KEY `main` (`main`,`topic_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10960 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `events`
--

DROP TABLE IF EXISTS `events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `title` varchar(255) NOT NULL DEFAULT '',
  `state` tinyint(1) NOT NULL DEFAULT 0,
  `topic_id` int(6) NOT NULL DEFAULT 0,
  `details` longtext NOT NULL,
  `section_id` int(11) NOT NULL DEFAULT 1,
  `main_page` tinyint(1) NOT NULL DEFAULT 1,
  `record_id` int(10) unsigned NOT NULL DEFAULT 0,
  `generated` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `level` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `end_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_id` int(6) NOT NULL DEFAULT 1,
  `festival_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `end_timestamp` (`end_timestamp`,`timestamp`),
  KEY `state` (`state`,`main_page`,`topic_id`,`end_timestamp`),
  KEY `state_2` (`state`,`section_id`,`timestamp`,`end_timestamp`),
  KEY `record_id` (`record_id`),
  KEY `festival_id` (`festival_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9661 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `events_default_sections`
--

DROP TABLE IF EXISTS `events_default_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `events_default_sections` (
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `section_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`res_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `events_log`
--

DROP TABLE IF EXISTS `events_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `events_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `msg` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1095 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `events_sections`
--

DROP TABLE IF EXISTS `events_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `events_sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section` varchar(100) NOT NULL DEFAULT '',
  `longname` varchar(255) NOT NULL DEFAULT '',
  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `main` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `is_dates_titles` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `festivals`
--

DROP TABLE IF EXISTS `festivals`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `festivals` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `title` varchar(255) NOT NULL DEFAULT '',
  `body` longtext DEFAULT NULL,
  `start_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `end_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `state` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `festivals_lineups`
--

DROP TABLE IF EXISTS `festivals_lineups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `festivals_lineups` (
  `festival_id` int(11) NOT NULL DEFAULT 0,
  `order_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `lineup_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `subtitle` varchar(255) NOT NULL DEFAULT '',
  `body` longtext DEFAULT NULL,
  PRIMARY KEY (`festival_id`,`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `folio_to_id`
--

DROP TABLE IF EXISTS `folio_to_id`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `folio_to_id` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `folio_id` int(6) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `folios`
--

DROP TABLE IF EXISTS `folios`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `folios` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `section_id` int(3) NOT NULL DEFAULT 1,
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `title` varchar(255) NOT NULL DEFAULT '',
  `body` longtext NOT NULL DEFAULT '',
  `chapo` longtext NOT NULL DEFAULT '',
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `post_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `from_article_id` int(6) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `section` (`section_id`),
  KEY `state` (`state`,`section_id`),
  KEY `state_2` (`state`,`timestamp`),
  KEY `title` (`title`(250)),
  KEY `state_3` (`state`,`id`),
  KEY `state_4` (`state`,`post_timestamp`)
) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `folios_sections`
--

DROP TABLE IF EXISTS `folios_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `folios_sections` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `section` varchar(50) NOT NULL DEFAULT '',
  `longname` varchar(255) NOT NULL DEFAULT '',
  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `main` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `default_images_sections` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_section` (`section`),
  KEY `state` (`state`,`main`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `forums`
--

DROP TABLE IF EXISTS `forums`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forums` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `main_page` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `is_post` tinyint(1) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `state` (`state`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `forums_data`
--

DROP TABLE IF EXISTS `forums_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forums_data` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `group_id` tinyint(4) NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL DEFAULT '',
  `body` longtext DEFAULT NULL,
  `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_id` int(6) NOT NULL DEFAULT 0,
  `author_id` int(6) NOT NULL DEFAULT 1,
  `ip` varchar(8) NOT NULL DEFAULT '',
  `is_sticky` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `is_locked` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `send_email` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `sig_id` int(6) NOT NULL DEFAULT 1,
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `group_id` (`state`,`group_id`,`is_sticky`),
  KEY `state` (`state`,`group_id`,`id`),
  KEY `user_id` (`state`,`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7250 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `galleries`
--

DROP TABLE IF EXISTS `galleries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `galleries` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `user_id` int(6) NOT NULL DEFAULT 1,
  `author_id` int(6) NOT NULL DEFAULT 1,
  `topic_id` int(4) NOT NULL DEFAULT 0,
  `folio_id` int(6) NOT NULL DEFAULT 0,
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `header` longtext DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `footer` longtext DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `topic` (`topic_id`)
) ENGINE=MyISAM AUTO_INCREMENT=253 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `geoip2_location`
--

DROP TABLE IF EXISTS `geoip2_location`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geoip2_location` (
  `geoname_id` int(11) NOT NULL,
  `locale_code` varchar(50) NOT NULL,
  `continent_code` char(2) NOT NULL,
  `continent_name` varchar(255) NOT NULL,
  `country_iso_code` char(2) DEFAULT NULL,
  `country_name` varchar(255) DEFAULT NULL,
  `is_in_european_union` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`geoname_id`,`locale_code`(5))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `geoip2_network`
--

DROP TABLE IF EXISTS `geoip2_network`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geoip2_network` (
  `network` char(18) NOT NULL,
  `network_start` int(10) unsigned NOT NULL DEFAULT 0,
  `network_end` int(10) unsigned NOT NULL DEFAULT 0,
  `geoname_id` int(11) DEFAULT NULL,
  `registered_country_geoname_id` int(11) DEFAULT NULL,
  `represented_country_geoname_id` int(11) DEFAULT NULL,
  `is_anonymous_proxy` tinyint(1) DEFAULT NULL,
  `is_satellite_provider` tinyint(1) DEFAULT NULL,
  KEY `network_start` (`network_start`),
  KEY `network_end` (`network_end`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `images`
--

DROP TABLE IF EXISTS `images`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `images` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL DEFAULT '',
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `alt` varchar(255) NOT NULL DEFAULT '',
  `section_id` int(3) NOT NULL DEFAULT 1,
  `path_id` int(3) NOT NULL DEFAULT 0,
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `author_id` int(6) NOT NULL DEFAULT 1,
  `user_id` int(6) NOT NULL DEFAULT 1,
  `description` longtext NOT NULL DEFAULT '',
  `width` smallint(5) unsigned NOT NULL DEFAULT 0,
  `height` smallint(5) unsigned NOT NULL DEFAULT 0,
  `size` mediumint(8) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `path_id` (`path_id`)
) ENGINE=MyISAM AUTO_INCREMENT=26035 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `images_path`
--

DROP TABLE IF EXISTS `images_path`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `images_path` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `path` varchar(250) NOT NULL DEFAULT '',
  `tmp` int(1) NOT NULL DEFAULT 0,
  `state` int(1) NOT NULL DEFAULT 0,
  `is_avatar` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `path` (`path`),
  KEY `state` (`state`)
) ENGINE=MyISAM AUTO_INCREMENT=121 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `images_ressources`
--

DROP TABLE IF EXISTS `images_ressources`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `images_ressources` (
  `image_id` int(11) NOT NULL DEFAULT 0,
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `res_id` int(11) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `icon` tinyint(1) unsigned NOT NULL DEFAULT 0,
  UNIQUE KEY `type_id` (`res_type`,`res_id`,`image_id`),
  KEY `image_id` (`image_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `images_sections`
--

DROP TABLE IF EXISTS `images_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `images_sections` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `section` varchar(50) NOT NULL DEFAULT '',
  `state` int(1) NOT NULL DEFAULT 1,
  `max_x` int(5) NOT NULL DEFAULT 0,
  `max_y` int(5) NOT NULL DEFAULT 0,
  `has_legend` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `longname` varchar(255) NOT NULL DEFAULT '',
  `main` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `is_avatar` tinyint(1) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `section` (`section`),
  KEY `state` (`state`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `interest`
--

DROP TABLE IF EXISTS `interest`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `interest` (
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `res_id` int(6) NOT NULL DEFAULT 0,
  `interest` int(8) NOT NULL DEFAULT 0,
  `score` int(8) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`res_type`,`res_id`),
  KEY `interest` (`interest`),
  KEY `score` (`score`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `lang`
--

DROP TABLE IF EXISTS `lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lang` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `lang` char(2) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci PACK_KEYS=1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `last_events`
--

DROP TABLE IF EXISTS `last_events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `last_events` (
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `res_id` int(10) unsigned NOT NULL DEFAULT 0,
  `section_id` tinyint(4) NOT NULL DEFAULT 1,
  `display_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `title` varchar(255) NOT NULL DEFAULT '',
  KEY `res_type` (`res_type`,`res_id`),
  KEY `display_timestamp` (`display_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `links`
--

DROP TABLE IF EXISTS `links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `title` varchar(255) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `state` tinyint(1) NOT NULL DEFAULT 0,
  `main_page` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `messages`
--

DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
  `id` int(7) NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `user_id_source` int(6) NOT NULL DEFAULT 0,
  `user_id_dest` int(6) NOT NULL DEFAULT 0,
  `state_dest` enum('0','1','2','3') NOT NULL DEFAULT '0',
  `subject` varchar(150) NOT NULL DEFAULT '0',
  `body` longtext DEFAULT NULL,
  `state_source` enum('0','1','2','3') NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `id` (`id`,`user_id_dest`,`user_id_source`,`timestamp`)
) ENGINE=MyISAM AUTO_INCREMENT=1204 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `moderator_last`
--

DROP TABLE IF EXISTS `moderator_last`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `moderator_last` (
  `user_id` int(6) NOT NULL DEFAULT 0,
  `action` varchar(255) DEFAULT NULL,
  `lastseen` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`user_id`),
  KEY `lastseen` (`lastseen`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `news`
--

DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `topic_id` int(3) NOT NULL DEFAULT 1,
  `section_id` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `author_id` int(6) NOT NULL DEFAULT 0,
  `user_id` int(6) NOT NULL DEFAULT 1,
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `title` varchar(250) NOT NULL DEFAULT '',
  `ip` varchar(8) NOT NULL DEFAULT '0',
  `body` longtext DEFAULT NULL,
  `attachement` longtext DEFAULT NULL,
  `main_page` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `is_phare` tinyint(1) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `topic` (`topic_id`),
  KEY `timestamp` (`timestamp`),
  KEY `state` (`state`,`main_page`,`topic_id`),
  KEY `state_2` (`state`,`main_page`,`timestamp`),
  KEY `is_sticky` (`is_phare`)
) ENGINE=MyISAM AUTO_INCREMENT=57412 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `news_attachements`
--

DROP TABLE IF EXISTS `news_attachements`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news_attachements` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `news_id` int(6) NOT NULL DEFAULT 0,
  `attachement` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `news_id` (`news_id`)
) ENGINE=MyISAM AUTO_INCREMENT=18796 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `news_author`
--

DROP TABLE IF EXISTS `news_author`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news_author` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL DEFAULT '',
  `contact` varchar(150) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9561 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `news_moderated`
--

DROP TABLE IF EXISTS `news_moderated`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news_moderated` (
  `news_id` int(6) NOT NULL DEFAULT 0,
  `user_id` int(6) NOT NULL DEFAULT 0,
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `is_sticky` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `is_locked` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `is_announcement` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `is_phare` tinyint(1) unsigned NOT NULL DEFAULT 0,
  KEY `id` (`news_id`,`user_id`),
  KEY `res_type` (`res_type`,`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `news_recent`
--

DROP TABLE IF EXISTS `news_recent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news_recent` (
  `id` int(6) NOT NULL DEFAULT 0,
  `title` varchar(150) DEFAULT '',
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `topic_id` int(3) NOT NULL DEFAULT 0,
  `main_page` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `is_phare` tinyint(1) unsigned NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `news_sections`
--

DROP TABLE IF EXISTS `news_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news_sections` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `section` varchar(50) DEFAULT NULL,
  `longname` varchar(255) NOT NULL DEFAULT '',
  `state` int(1) NOT NULL DEFAULT 1,
  `main` tinyint(1) unsigned NOT NULL DEFAULT 1,
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `news_urls`
--

DROP TABLE IF EXISTS `news_urls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news_urls` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `news_id` int(6) NOT NULL DEFAULT 0,
  `country_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `name` varchar(250) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `hits` int(6) NOT NULL DEFAULT 0,
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `description` varchar(255) NOT NULL DEFAULT '',
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `res_type` (`res_type`,`news_id`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=44204 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `notes`
--

DROP TABLE IF EXISTS `notes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notes` (
  `res_id` int(11) NOT NULL DEFAULT 0,
  `user_id` int(6) NOT NULL DEFAULT 1,
  `note` int(2) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  UNIQUE KEY `user_id` (`user_id`,`res_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `parameters`
--

DROP TABLE IF EXISTS `parameters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `parameters` (
  `name` varchar(100) NOT NULL DEFAULT '',
  `value` varchar(100) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pboxes`
--

DROP TABLE IF EXISTS `pboxes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pboxes` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `title` varchar(60) NOT NULL DEFAULT '',
  `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `start_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `end_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `display_counter` int(10) unsigned NOT NULL DEFAULT 0,
  `max_display` int(10) unsigned NOT NULL DEFAULT 0,
  `section_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `content_type` enum('I','H','J','L') NOT NULL DEFAULT 'I',
  `body` longtext NOT NULL,
  `max_daily_display` int(10) unsigned NOT NULL DEFAULT 0,
  `daily_display_counter` int(10) unsigned NOT NULL DEFAULT 0,
  `description` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `state` (`state`,`start_timestamp`,`end_timestamp`)
) ENGINE=MyISAM AUTO_INCREMENT=399 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pboxes_sections`
--

DROP TABLE IF EXISTS `pboxes_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pboxes_sections` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `section` varchar(100) NOT NULL DEFAULT '',
  `longname` varchar(255) NOT NULL DEFAULT '',
  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `main` tinyint(1) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `section` (`section`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `peoples`
--

DROP TABLE IF EXISTS `peoples`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `peoples` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `fname` varchar(100) NOT NULL DEFAULT '',
  `lname` varchar(100) NOT NULL DEFAULT '',
  `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `peoples_sections`
--

DROP TABLE IF EXISTS `peoples_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `peoples_sections` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `section` varchar(50) NOT NULL DEFAULT '',
  `longname` varchar(50) NOT NULL DEFAULT '',
  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `main` tinyint(1) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `playlists`
--

DROP TABLE IF EXISTS `playlists`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `playlists` (
  `user_id` int(6) NOT NULL DEFAULT 1,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `body` longtext DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `poll_answers`
--

DROP TABLE IF EXISTS `poll_answers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `poll_answers` (
  `question_id` int(6) NOT NULL DEFAULT 0,
  `answer` varchar(255) NOT NULL DEFAULT '',
  `number` int(10) NOT NULL DEFAULT 0,
  `answer_nb` int(3) NOT NULL DEFAULT 0,
  KEY `question_id` (`question_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `poll_questions`
--

DROP TABLE IF EXISTS `poll_questions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `poll_questions` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `comment` varchar(255) NOT NULL DEFAULT '',
  `state` tinyint(4) NOT NULL DEFAULT 0,
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `start_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `end_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `multiple` tinyint(1) NOT NULL DEFAULT 0,
  `main_page` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `topic_id` int(10) unsigned NOT NULL DEFAULT 1,
  `number` int(11) NOT NULL DEFAULT 0,
  `results_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `timestamp` (`start_timestamp`)
) ENGINE=MyISAM AUTO_INCREMENT=118 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `quizzes`
--

DROP TABLE IF EXISTS `quizzes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quizzes` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) NOT NULL DEFAULT '',
  `body` longtext DEFAULT NULL,
  `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `start_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `end_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `state` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `msg` longtext DEFAULT NULL,
  `main` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `state` (`state`,`start_timestamp`,`end_timestamp`)
) ENGINE=MyISAM AUTO_INCREMENT=281 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `quizzes_answers`
--

DROP TABLE IF EXISTS `quizzes_answers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quizzes_answers` (
  `quiz_form_id` int(10) NOT NULL DEFAULT 0,
  `quiz_question_id` int(5) NOT NULL DEFAULT 0,
  `text` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`quiz_form_id`,`quiz_question_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `quizzes_forms`
--

DROP TABLE IF EXISTS `quizzes_forms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quizzes_forms` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `quiz_id` int(4) NOT NULL DEFAULT 0,
  `user_id` int(6) NOT NULL DEFAULT 1,
  `name` varchar(255) NOT NULL DEFAULT '',
  `address` varchar(255) NOT NULL DEFAULT '',
  `referer` varchar(255) NOT NULL DEFAULT '',
  `ip` varchar(8) NOT NULL DEFAULT '0',
  `hostname` varchar(255) NOT NULL DEFAULT '',
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `email` varchar(100) NOT NULL DEFAULT '',
  `token` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `quiz_id` (`quiz_id`)
) ENGINE=MyISAM AUTO_INCREMENT=611368 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `quizzes_questions`
--

DROP TABLE IF EXISTS `quizzes_questions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quizzes_questions` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `quiz_id` int(4) NOT NULL DEFAULT 0,
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `text` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `quiz_id` (`quiz_id`,`state`)
) ENGINE=MyISAM AUTO_INCREMENT=487 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `quotes`
--

DROP TABLE IF EXISTS `quotes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quotes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `author` varchar(50) NOT NULL DEFAULT '',
  `quote` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `records`
--

DROP TABLE IF EXISTS `records`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `records` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `out_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `substyle_id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `label_id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `section_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL DEFAULT '',
  `amazon_asin` varchar(50) NOT NULL DEFAULT '',
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `timestamp_precision` tinyint(3) unsigned NOT NULL DEFAULT 8,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7949 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `records_labels`
--

DROP TABLE IF EXISTS `records_labels`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `records_labels` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL DEFAULT '',
  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`)
) ENGINE=MyISAM AUTO_INCREMENT=1049 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `records_peoples`
--

DROP TABLE IF EXISTS `records_peoples`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `records_peoples` (
  `record_id` int(10) unsigned NOT NULL DEFAULT 0,
  `people_id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `section_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `order_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`record_id`,`people_id`,`section_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='0..N relation records->peoples with an associated role';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `records_records_labels`
--

DROP TABLE IF EXISTS `records_records_labels`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `records_records_labels` (
  `record_id` int(10) unsigned NOT NULL DEFAULT 0,
  `records_label_id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `order_id` tinyint(3) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`record_id`,`records_label_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `records_sections`
--

DROP TABLE IF EXISTS `records_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `records_sections` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `section` varchar(100) NOT NULL DEFAULT '',
  `longname` varchar(255) NOT NULL DEFAULT '',
  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `main` tinyint(1) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='various sections for records';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `records_tracklists`
--

DROP TABLE IF EXISTS `records_tracklists`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `records_tracklists` (
  `record_id` int(10) unsigned NOT NULL DEFAULT 0,
  `order_id` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `subtitle` varchar(255) NOT NULL DEFAULT '',
  `tracklist` longtext DEFAULT NULL,
  PRIMARY KEY (`record_id`,`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ressources`
--

DROP TABLE IF EXISTS `ressources`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ressources` (
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `res_name` varchar(100) NOT NULL DEFAULT '',
  `gender` char(1) NOT NULL DEFAULT '',
  `allow_anonymous` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `comments_time` int(10) unsigned NOT NULL DEFAULT 0,
  `link_nb` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `allow_quick` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `max_linked_ressources` tinyint(4) NOT NULL DEFAULT 0,
  `allow_images` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `res_table` varchar(255) NOT NULL DEFAULT '',
  `publish_timestamp_field` varchar(255) NOT NULL DEFAULT '',
  `allow_comments` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `allow_votes` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `admin_link_res_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `has_sticky` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `has_locked` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `has_announcement` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `has_phare` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `title_field` varchar(255) NOT NULL DEFAULT '',
  `is_asset` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `allow_images_bulk` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `section_joining_table` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`res_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ressources_audit_log`
--

DROP TABLE IF EXISTS `ressources_audit_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ressources_audit_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(6) NOT NULL DEFAULT 1,
  `res_type` tinyint(4) unsigned NOT NULL DEFAULT 0,
  `res_id` int(11) unsigned NOT NULL DEFAULT 0,
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `msg` varchar(255) NOT NULL DEFAULT '',
  `usr_msg` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `res_type` (`res_type`,`res_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ressources_comments`
--

DROP TABLE IF EXISTS `ressources_comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ressources_comments` (
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `res_id` int(10) unsigned NOT NULL DEFAULT 0,
  `section_id` tinyint(4) NOT NULL DEFAULT 1,
  `comment_count` smallint(5) unsigned NOT NULL DEFAULT 0,
  `comment_last_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_last_user_id` int(11) NOT NULL DEFAULT 0,
  `comment_last_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`section_id`,`res_type`,`res_id`),
  KEY `section_id` (`section_id`,`comment_last_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ressources_max_links`
--

DROP TABLE IF EXISTS `ressources_max_links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ressources_max_links` (
  `res_type_from` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `res_section_from` int(11) NOT NULL DEFAULT 0,
  `res_type_to` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `max_linked_ressources` tinyint(3) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`res_type_from`,`res_section_from`,`res_type_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ressources_phare`
--

DROP TABLE IF EXISTS `ressources_phare`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ressources_phare` (
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `res_id` int(10) unsigned NOT NULL DEFAULT 0,
  `phare_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`res_type`,`res_id`),
  KEY `phare_timestamp` (`phare_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ressources_publish`
--

DROP TABLE IF EXISTS `ressources_publish`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ressources_publish` (
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `res_id` int(10) unsigned NOT NULL DEFAULT 0,
  `post_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`res_type`,`res_id`),
  KEY `post_timestamp` (`post_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ressources_ressources`
--

DROP TABLE IF EXISTS `ressources_ressources`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ressources_ressources` (
  `res_type_from` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `res_id_from` int(6) NOT NULL DEFAULT 0,
  `res_type_to` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `res_id_to` int(6) NOT NULL DEFAULT 0,
  `rank` tinyint(4) unsigned NOT NULL DEFAULT 0,
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  UNIQUE KEY `klink` (`res_type_from`,`res_type_to`,`res_id_from`,`res_id_to`),
  KEY `kfrom` (`res_type_from`,`res_id_from`),
  KEY `kto` (`res_type_to`,`res_id_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ressources_views`
--

DROP TABLE IF EXISTS `ressources_views`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ressources_views` (
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `res_id` int(10) unsigned NOT NULL DEFAULT 0,
  `section_id` tinyint(4) NOT NULL DEFAULT 1,
  `view_count` int(10) unsigned NOT NULL DEFAULT 0,
  `view_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`section_id`,`res_type`,`res_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ressources_votes_sessions`
--

DROP TABLE IF EXISTS `ressources_votes_sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ressources_votes_sessions` (
  `session_id` varchar(128) NOT NULL DEFAULT '',
  `expiry_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `res_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`session_id`,`res_type`,`res_id`,`expiry_timestamp`),
  KEY `expiry_timestamp` (`expiry_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sessions`
--

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sessions` (
  `id` char(32) NOT NULL DEFAULT '',
  `user_id` int(6) NOT NULL DEFAULT 0,
  `ip` char(8) NOT NULL DEFAULT '0',
  `lastseen` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `expire` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `user_id2` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
  `name` varchar(100) NOT NULL DEFAULT '',
  `value` int(6) NOT NULL DEFAULT 0,
  `min_value` int(6) NOT NULL DEFAULT 0,
  `max_value` int(6) NOT NULL DEFAULT 0,
  `default_value` int(6) NOT NULL DEFAULT 0,
  `description` varchar(255) NOT NULL DEFAULT '',
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sig`
--

DROP TABLE IF EXISTS `sig`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sig` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `sig` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=896 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `states`
--

DROP TABLE IF EXISTS `states`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `states` (
  `id` tinyint(4) NOT NULL DEFAULT 0,
  `state` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `stats_daily_guests`
--

DROP TABLE IF EXISTS `stats_daily_guests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stats_daily_guests` (
  `guest_count` int(11) NOT NULL DEFAULT 0,
  `visit_count` int(11) NOT NULL DEFAULT 0,
  `pages_count` int(11) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `stats_guests`
--

DROP TABLE IF EXISTS `stats_guests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stats_guests` (
  `guest_id` char(32) NOT NULL DEFAULT '',
  `counter` int(11) NOT NULL DEFAULT 1,
  `pages` int(11) NOT NULL DEFAULT 1,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`guest_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `substyles`
--

DROP TABLE IF EXISTS `substyles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `substyles` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=254 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tags`
--

DROP TABLE IF EXISTS `tags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag` varchar(250) NOT NULL DEFAULT '',
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tag` (`tag`)
) ENGINE=MyISAM AUTO_INCREMENT=28673 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tags_ressources`
--

DROP TABLE IF EXISTS `tags_ressources`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tags_ressources` (
  `tag_id` int(11) NOT NULL DEFAULT 0,
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `res_id` int(11) NOT NULL DEFAULT 0,
  `section_id` tinyint(4) NOT NULL DEFAULT 0,
  `rank` tinyint(4) NOT NULL DEFAULT 0,
  `last_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `is_marked` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`res_type`,`res_id`,`section_id`,`tag_id`),
  KEY `tag_id` (`tag_id`),
  KEY `res_type` (`res_type`,`section_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tags_sections`
--

DROP TABLE IF EXISTS `tags_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tags_sections` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `section` varchar(250) NOT NULL DEFAULT '',
  `longname` varchar(255) NOT NULL DEFAULT '',
  `is_listed` tinyint(1) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `section` (`section`),
  KEY `is_listed` (`is_listed`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `threads_lastseen`
--

DROP TABLE IF EXISTS `threads_lastseen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `threads_lastseen` (
  `user_id` int(6) NOT NULL DEFAULT 0,
  `thread_id` int(11) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`user_id`,`thread_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tips`
--

DROP TABLE IF EXISTS `tips`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tips` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `section_id` int(6) NOT NULL DEFAULT 0,
  `user_id` int(6) NOT NULL DEFAULT 0,
  `state` int(1) NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL DEFAULT '',
  `tip` longtext NOT NULL,
  `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tips_sections`
--

DROP TABLE IF EXISTS `tips_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tips_sections` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `tip_section_referer_id` int(6) NOT NULL DEFAULT 0,
  `longname` varchar(255) NOT NULL DEFAULT '',
  `state` int(1) NOT NULL DEFAULT 1,
  `section` varchar(255) NOT NULL DEFAULT '',
  `main` tinyint(1) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `topics`
--

DROP TABLE IF EXISTS `topics`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `topics` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `topic` varchar(250) NOT NULL DEFAULT '',
  `title` varchar(250) NOT NULL DEFAULT '',
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `description` longtext NOT NULL DEFAULT '',
  `main` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `topic_parent` int(3) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `section_id` int(11) NOT NULL DEFAULT 1,
  `substyle_id` smallint(5) unsigned NOT NULL DEFAULT 0,
  `country_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `post_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `longname` (`title`),
  UNIQUE KEY `topic` (`topic`),
  KEY `topic_parent` (`topic_parent`),
  KEY `state` (`state`,`main`)
) ENGINE=MyISAM AUTO_INCREMENT=4915 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `topics_lookup`
--

DROP TABLE IF EXISTS `topics_lookup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `topics_lookup` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(250) NOT NULL DEFAULT '',
  `topic_id` int(3) NOT NULL DEFAULT 1,
  `main` int(1) NOT NULL DEFAULT 0,
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `label` (`label`),
  KEY `topic_id` (`topic_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5693 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `topics_redirect`
--

DROP TABLE IF EXISTS `topics_redirect`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `topics_redirect` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `path` varchar(255) NOT NULL DEFAULT '',
  `topic_id` int(3) NOT NULL DEFAULT 1,
  `hits` int(6) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `path` (`path`(250))
) ENGINE=MyISAM AUTO_INCREMENT=271 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `topics_sections`
--

DROP TABLE IF EXISTS `topics_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `topics_sections` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `section` varchar(255) NOT NULL DEFAULT '',
  `longname` varchar(250) NOT NULL DEFAULT '',
  `template` varchar(50) NOT NULL DEFAULT '',
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `main` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `has_country_id` tinyint(1) NOT NULL DEFAULT 0,
  `has_substyle_id` tinyint(1) NOT NULL DEFAULT 0,
  `is_listed` tinyint(1) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `model` (`longname`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tracker`
--

DROP TABLE IF EXISTS `tracker`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tracker` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `body` longtext DEFAULT NULL,
  `sender_id` int(10) unsigned NOT NULL DEFAULT 0,
  `assign_id` int(10) unsigned NOT NULL DEFAULT 0,
  `section_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `open_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `close_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `privilege` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `update_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=306 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tracker_sections`
--

DROP TABLE IF EXISTS `tracker_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tracker_sections` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `longname` varchar(255) DEFAULT NULL,
  `section` varchar(255) NOT NULL DEFAULT '',
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `main` tinyint(1) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `turing`
--

DROP TABLE IF EXISTS `turing`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `turing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `random` char(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `random` (`random`)
) ENGINE=MyISAM AUTO_INCREMENT=1087407 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `urls_avgtime`
--

DROP TABLE IF EXISTS `urls_avgtime`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `urls_avgtime` (
  `url` varchar(250) NOT NULL DEFAULT '',
  `avgtime` float NOT NULL DEFAULT 0,
  `number` int(11) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `avgsqltime` float NOT NULL DEFAULT 0,
  UNIQUE KEY `url` (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `urls_sections`
--

DROP TABLE IF EXISTS `urls_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `urls_sections` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `section` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `lname` varchar(40) NOT NULL DEFAULT '',
  `fname` varchar(40) NOT NULL DEFAULT '',
  `login` varchar(20) NOT NULL DEFAULT '',
  `passwd` varchar(40) NOT NULL DEFAULT '',
  `email` varchar(128) NOT NULL DEFAULT '',
  `homesite` varchar(255) NOT NULL DEFAULT '',
  `level` int(20) unsigned NOT NULL DEFAULT 0,
  `param` int(10) unsigned NOT NULL DEFAULT 0,
  `insert_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `sig_id` int(6) NOT NULL DEFAULT 1,
  `state` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `lastseen` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ip` varchar(8) NOT NULL DEFAULT '0',
  `comment_count` smallint(5) unsigned NOT NULL DEFAULT 0,
  `prev_lastseen` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `nickname` varchar(255) NOT NULL DEFAULT '',
  `allow_email` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `last_passwd_change` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `login` (`login`),
  KEY `lastseen2` (`lastseen`)
) ENGINE=MyISAM AUTO_INCREMENT=7573 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `users_friends`
--

DROP TABLE IF EXISTS `users_friends`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_friends` (
  `user_id` int(11) NOT NULL DEFAULT 0,
  `friend_id` int(11) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `state` tinyint(1) NOT NULL DEFAULT 0,
  UNIQUE KEY `user_id` (`user_id`,`friend_id`),
  UNIQUE KEY `friend_id` (`friend_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `users_journal`
--

DROP TABLE IF EXISTS `users_journal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_journal` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `user_id` int(6) NOT NULL DEFAULT 0,
  `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ip` varchar(8) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `body` longtext DEFAULT NULL,
  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `last_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `state` (`state`,`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=493 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `users_lastseen`
--

DROP TABLE IF EXISTS `users_lastseen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_lastseen` (
  `user_id` int(6) NOT NULL DEFAULT 0,
  `obj_id` int(6) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `res_type` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `count` smallint(5) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`res_type`,`user_id`,`obj_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `users_shoutbox`
--

DROP TABLE IF EXISTS `users_shoutbox`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_shoutbox` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_id_from` int(11) NOT NULL DEFAULT 0,
  `user_id_to` int(11) NOT NULL DEFAULT 0,
  `body` longtext NOT NULL,
  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `user_id_to` (`user_id_to`)
) ENGINE=MyISAM AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `users_supp`
--

DROP TABLE IF EXISTS `users_supp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_supp` (
  `user_id` int(6) NOT NULL DEFAULT 0,
  `page_public` longtext NOT NULL DEFAULT '',
  `addr` varchar(255) NOT NULL DEFAULT '',
  `icq` varchar(100) NOT NULL DEFAULT '',
  `aim` varchar(100) NOT NULL DEFAULT '',
  `msn` varchar(100) NOT NULL DEFAULT '',
  `jabber` varchar(100) NOT NULL DEFAULT '',
  `audioscrobbler` varchar(30) NOT NULL DEFAULT '',
  `birth_day` tinyint(4) NOT NULL DEFAULT 0,
  `birth_month` tinyint(4) NOT NULL DEFAULT 0,
  `location` varchar(255) NOT NULL DEFAULT '',
  `about_me` longtext NOT NULL DEFAULT '',
  `birth_year` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `user_sex` char(1) NOT NULL DEFAULT '',
  `page_private` longtext NOT NULL DEFAULT '',
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `users_tempo`
--

DROP TABLE IF EXISTS `users_tempo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_tempo` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `user_id` int(6) NOT NULL DEFAULT 0,
  `email` varchar(128) NOT NULL DEFAULT '',
  `tempo_id` varchar(64) NOT NULL DEFAULT '',
  `session_id` varchar(32) NOT NULL DEFAULT '',
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `session_id` (`session_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1408 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `venues`
--

DROP TABLE IF EXISTS `venues`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `venues` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL DEFAULT '',
  `address` varchar(255) NOT NULL DEFAULT '',
  `country_id` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `phone` varchar(100) NOT NULL DEFAULT '',
  `state` tinyint(1) NOT NULL DEFAULT 0,
  `user_id` int(6) NOT NULL DEFAULT 1,
  `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `direction` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`)
) ENGINE=MyISAM AUTO_INCREMENT=424 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-04-20  2:31:46
