-- MySQL dump 10.13 Distrib 5.1.49, for debian-linux-gnu (i486) -- -- Host: localhost Database: dabase -- ------------------------------------------------------ -- Server version 5.1.49-3-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 utf8 */; /*!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', `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 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `version` tinyint(3) unsigned NOT NULL DEFAULT '0', `title` varchar(255) NOT NULL DEFAULT '', `keywords` varchar(255) NOT NULL DEFAULT '', `body` mediumtext, `intro` mediumtext, `outro` mediumtext, `chapo` mediumtext NOT NULL, `subtitle` varchar(200) NOT NULL DEFAULT '', `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `update_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 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 `state_3` (`state`,`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7285 DEFAULT CHARSET=utf8; /*!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', `spec` tinyint(1) unsigned NOT NULL DEFAULT '0', `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', PRIMARY KEY (`id`), KEY `spec` (`spec`), KEY `section_parent` (`section_parent`), KEY `state` (`state`,`main`) ) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8; /*!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=utf8; /*!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=utf8; /*!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=131088 DEFAULT CHARSET=utf8; /*!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=utf8; /*!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` mediumtext 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=82124 DEFAULT CHARSET=utf8; /*!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=utf8; /*!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=utf8; /*!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=utf8; /*!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=utf8; /*!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=utf8; /*!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=utf8; /*!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 '', PRIMARY KEY (`id`), UNIQUE KEY `lang` (`country`) ) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=utf8; /*!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=52330 DEFAULT CHARSET=utf8; /*!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(255) NOT NULL DEFAULT '', `alpha` varchar(255) 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 '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 '1', `ip` varchar(8) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `title` (`title`), KEY `main` (`main`,`topic_id`) ) ENGINE=MyISAM AUTO_INCREMENT=9452 DEFAULT CHARSET=utf8; /*!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 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `title` varchar(255) NOT NULL DEFAULT '', `state` tinyint(1) NOT NULL DEFAULT '0', `topic_id` int(6) NOT NULL DEFAULT '0', `details` mediumtext 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 '0000-00-00 00:00:00', `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `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', `bug_fixed` tinyint(4) 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=4884 DEFAULT CHARSET=utf8; /*!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=utf8; /*!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=utf8; /*!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', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `events_tags_bug` -- DROP TABLE IF EXISTS `events_tags_bug`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `events_tags_bug` ( `tag` varchar(255) NOT NULL DEFAULT '', `clean_tag` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`tag`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!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` mediumtext, `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=49 DEFAULT CHARSET=utf8; /*!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` mediumtext, PRIMARY KEY (`festival_id`,`order_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!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=utf8; /*!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` mediumtext, `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=6689 DEFAULT CHARSET=utf8; /*!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', `state` tinyint(1) unsigned NOT NULL DEFAULT '0', `header` mediumtext, `content` mediumtext, `footer` mediumtext, `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, PRIMARY KEY (`id`), KEY `topic` (`topic_id`) ) ENGINE=MyISAM AUTO_INCREMENT=207 DEFAULT CHARSET=utf8; /*!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 '', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `alt` varchar(255) NOT NULL DEFAULT '', `imsection_id` int(3) NOT NULL DEFAULT '1', `path_id` int(3) NOT NULL DEFAULT '0', `state` tinyint(1) unsigned NOT NULL DEFAULT '0', `author_id` int(6) NOT NULL DEFAULT '1', `user_id` int(6) NOT NULL DEFAULT '1', `description` mediumtext NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `path_id` (`path_id`) ) ENGINE=MyISAM AUTO_INCREMENT=12414 DEFAULT CHARSET=utf8; /*!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(255) NOT NULL DEFAULT '', `tmp` int(1) NOT NULL DEFAULT '0', `state` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `path` (`path`), KEY `state` (`state`) ) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8; /*!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=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `imsections` -- DROP TABLE IF EXISTS `imsections`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `imsections` ( `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', PRIMARY KEY (`id`), UNIQUE KEY `section` (`section`), KEY `state` (`state`) ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; /*!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=utf8; /*!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=utf8 PACK_KEYS=1; /*!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 '', `body` mediumtext, `state` tinyint(1) NOT NULL DEFAULT '0', `main` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8; /*!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` mediumtext, `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=1197 DEFAULT CHARSET=utf8; /*!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=utf8; /*!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 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `title` varchar(150) NOT NULL DEFAULT '', `ip` varchar(8) NOT NULL DEFAULT '0', `body` mediumtext, `main_page` tinyint(1) unsigned NOT NULL DEFAULT '1', `insert_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `update_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 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`) ) ENGINE=MyISAM AUTO_INCREMENT=27015 DEFAULT CHARSET=utf8; /*!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` mediumtext NOT NULL, PRIMARY KEY (`id`), KEY `news_id` (`news_id`) ) ENGINE=MyISAM AUTO_INCREMENT=4402 DEFAULT CHARSET=utf8; /*!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=7760 DEFAULT CHARSET=utf8; /*!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', KEY `id` (`news_id`,`user_id`), KEY `res_type` (`res_type`,`news_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!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' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!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=utf8; /*!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(255) 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=28605 DEFAULT CHARSET=utf8; /*!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=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `old_forum_ids` -- DROP TABLE IF EXISTS `old_forum_ids`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `old_forum_ids` ( `id` int(11) NOT NULL AUTO_INCREMENT, `old_id` int(11) NOT NULL, `new_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `old_id` (`old_id`) ) ENGINE=MyISAM AUTO_INCREMENT=652 DEFAULT CHARSET=utf8; /*!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=utf8; /*!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` mediumtext 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=287 DEFAULT CHARSET=utf8; /*!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=utf8; /*!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 '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `peoples_roles` -- DROP TABLE IF EXISTS `peoples_roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `peoples_roles` ( `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `role` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; /*!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` mediumtext, PRIMARY KEY (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!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=utf8; /*!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 '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', `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', PRIMARY KEY (`id`), KEY `timestamp` (`start_timestamp`) ) ENGINE=MyISAM AUTO_INCREMENT=116 DEFAULT CHARSET=utf8; /*!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` mediumtext, `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` mediumtext, `main` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `state` (`state`,`start_timestamp`,`end_timestamp`) ) ENGINE=MyISAM AUTO_INCREMENT=193 DEFAULT CHARSET=utf8; /*!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=utf8; /*!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=512336 DEFAULT CHARSET=utf8; /*!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=380 DEFAULT CHARSET=utf8; /*!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=utf8; /*!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=3175 DEFAULT CHARSET=utf8; /*!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(255) 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=536 DEFAULT CHARSET=utf8; /*!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', `role_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `order_id` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`record_id`,`people_id`,`role_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 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=utf8; /*!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=utf8 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` mediumtext, PRIMARY KEY (`record_id`,`order_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!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', PRIMARY KEY (`res_type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!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=utf8; /*!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=utf8; /*!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=utf8; /*!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=utf8; /*!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(255) 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=utf8; /*!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=utf8; /*!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=671 DEFAULT CHARSET=utf8; /*!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=utf8; /*!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=utf8; /*!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=utf8; /*!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 '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=115 DEFAULT CHARSET=utf8; /*!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(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `tag` (`tag`) ) ENGINE=MyISAM AUTO_INCREMENT=12853 DEFAULT CHARSET=utf8; /*!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(4) 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, 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=utf8; /*!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(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `section` (`section`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; /*!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=utf8; /*!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` mediumtext 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=utf8; /*!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=utf8; /*!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(40) NOT NULL DEFAULT '', `title` varchar(255) NOT NULL DEFAULT '', `state` tinyint(1) unsigned NOT NULL DEFAULT '0', `description` varchar(255) NOT NULL DEFAULT '', `main` tinyint(1) unsigned NOT NULL DEFAULT '0', `topic_parent` int(3) NOT NULL DEFAULT '0', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `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 '0000-00-00 00:00:00', `update_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=2679 DEFAULT CHARSET=utf8; /*!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` ( `label` varchar(255) NOT NULL DEFAULT '', `topic_id` int(3) NOT NULL DEFAULT '1', `main` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`label`), KEY `topic_id` (`topic_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!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(255) 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', PRIMARY KEY (`id`), UNIQUE KEY `model` (`longname`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; /*!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` mediumtext, `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=144 DEFAULT CHARSET=utf8; /*!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, `name` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; /*!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=844850 DEFAULT CHARSET=utf8; /*!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=utf8; /*!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=utf8; /*!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', `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `sig_id` int(6) NOT NULL DEFAULT '1', `status` 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 '', PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), UNIQUE KEY `login` (`login`), KEY `lastseen2` (`lastseen`) ) ENGINE=MyISAM AUTO_INCREMENT=6600 DEFAULT CHARSET=utf8; /*!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=utf8; /*!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` mediumtext, `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=453 DEFAULT CHARSET=utf8; /*!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=utf8; /*!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` mediumtext NOT NULL, `state` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `user_id_to` (`user_id_to`) ) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8; /*!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` mediumtext NOT NULL, `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` mediumtext NOT NULL, `birth_year` mediumint(8) unsigned NOT NULL DEFAULT '0', `user_sex` char(1) NOT NULL DEFAULT '', `page_private` mediumtext NOT NULL, PRIMARY KEY (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!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` int(6) NOT NULL DEFAULT '0', `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=846 DEFAULT CHARSET=utf8; /*!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(255) 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=271 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `xspf_playlist` -- DROP TABLE IF EXISTS `xspf_playlist`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xspf_playlist` ( `artist` varchar(255) NOT NULL DEFAULT '', `annotation` varchar(255) NOT NULL DEFAULT '', `info` varchar(255) NOT NULL DEFAULT '', `location` varchar(255) NOT NULL DEFAULT '', `id` int(11) NOT NULL AUTO_INCREMENT, `vote_plus` int(11) NOT NULL DEFAULT '0', `vote_minus` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=235 DEFAULT CHARSET=utf8; /*!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 2012-02-05 5:31:12