Platon Technologies
neprihlásený Prihlásiť Registrácia
SlovakEnglish
open source software development oslavujeme 10 rokov vývoja otvoreného softvéru! Piatok, 29. marec 2024

Súbor: [Platon] / Metafox / sql / dump / mysql.sql (stiahnutie)

Revízia 1.14, Sat Feb 22 05:38:26 2014 UTC (10 years, 1 month ago) by nepto


Zmeny od 1.13: +42 -30 [lines]

Updated SQL

-- MySQL dump 10.13  Distrib 5.1.73, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: metafox
-- ------------------------------------------------------
-- Server version    5.1.73-1

/*!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 `ezin_articles`
--

DROP TABLE IF EXISTS `ezin_articles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_articles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `author_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `bind_lang` int(11) DEFAULT NULL,
  `bind_theme` int(11) DEFAULT NULL,
  `accesses_count` int(11) DEFAULT NULL,
  `sessions_count` int(11) DEFAULT NULL,
  `message_count` int(11) DEFAULT NULL,
  `status` enum('showed','partly_showed','hidden','disabled') DEFAULT NULL,
  `display` set('enabled','in_normal','in_global') DEFAULT NULL,
  `datetime` datetime DEFAULT '0000-00-00 00:00:00',
  `ghometext_wordcount` int(11) DEFAULT NULL,
  `hometext_wordcount` int(11) DEFAULT NULL,
  `bodytext_wordcount` int(11) DEFAULT NULL,
  `ghometext_flags` varchar(10) DEFAULT NULL,
  `hometext_flags` varchar(10) DEFAULT NULL,
  `bodytext_flags` varchar(10) DEFAULT NULL,
  `access_key` varchar(64) DEFAULT NULL,
  `template_key` varchar(64) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `atitle` varchar(255) DEFAULT NULL,
  `ghometext` text,
  `hometext` text,
  `bodytext` longtext,
  `calendar_flag` date DEFAULT NULL,
  `featured_articles_flag` datetime DEFAULT NULL,
  `created_id` int(10) DEFAULT NULL,
  `created_by` varchar(60) DEFAULT NULL,
  `created_dt` datetime DEFAULT NULL,
  `changed_id` int(10) DEFAULT NULL,
  `changed_by` varchar(60) DEFAULT NULL,
  `changed_dt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ezin_articles_author_id` (`author_id`),
  KEY `ezin_articles_section_id` (`section_id`),
  KEY `ezin_articles_bind_lang` (`bind_lang`),
  KEY `ezin_articles_bind_theme` (`bind_theme`),
  KEY `ezin_articles_status` (`status`),
  KEY `ezin_articles_datetime` (`datetime`),
  KEY `ezin_articles_access_key` (`access_key`),
  KEY `ezin_articles_template_key` (`template_key`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_authors`
--

DROP TABLE IF EXISTS `ezin_authors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_authors` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `type` enum('internal','external') DEFAULT NULL,
  `bind` int(11) DEFAULT NULL,
  `accesses_count` int(11) DEFAULT NULL,
  `sessions_count` int(11) DEFAULT NULL,
  `access_key` varchar(64) DEFAULT NULL,
  `template_key` varchar(64) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `position` varchar(150) DEFAULT NULL,
  `location` varchar(150) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `homepage` varchar(150) DEFAULT NULL,
  `description` text,
  `description_flags` varchar(10) DEFAULT NULL,
  `description_wordcount` int(11) DEFAULT NULL,
  `created_id` int(10) DEFAULT NULL,
  `created_by` varchar(60) DEFAULT NULL,
  `created_dt` datetime DEFAULT NULL,
  `changed_id` int(10) DEFAULT NULL,
  `changed_by` varchar(60) DEFAULT NULL,
  `changed_dt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ezin_authors_type` (`type`),
  KEY `ezin_authors_access_key` (`access_key`),
  KEY `ezin_authors_template_key` (`template_key`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_boxes`
--

DROP TABLE IF EXISTS `ezin_boxes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_boxes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `theme` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `template_key` varchar(64) DEFAULT NULL,
  `bodytext` text,
  `created_id` int(10) DEFAULT NULL,
  `created_by` varchar(60) DEFAULT NULL,
  `created_dt` datetime DEFAULT NULL,
  `changed_id` int(10) DEFAULT NULL,
  `changed_by` varchar(60) DEFAULT NULL,
  `changed_dt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `theme` (`theme`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_cache`
--

DROP TABLE IF EXISTS `ezin_cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_cache` (
  `id` varchar(64) NOT NULL DEFAULT '',
  `timestamp` int(11) DEFAULT NULL,
  `var_var` int(1) DEFAULT NULL,
  `content` longtext,
  PRIMARY KEY (`id`),
  KEY `ezin_cache_timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_config`
--

DROP TABLE IF EXISTS `ezin_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_config` (
  `a_key` varchar(32) NOT NULL DEFAULT '',
  `type` int(2) DEFAULT NULL,
  `value` text,
  PRIMARY KEY (`a_key`),
  KEY `ezin_config_type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_config_info`
--

DROP TABLE IF EXISTS `ezin_config_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_config_info` (
  `a_key` char(32) NOT NULL,
  `ord` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`a_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_counts_temp`
--

DROP TABLE IF EXISTS `ezin_counts_temp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_counts_temp` (
  `type_id` char(8) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `timestamp` int(11) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  KEY `ezin_counts_temp_type_id` (`type_id`),
  KEY `ezin_counts_temp_timestamp` (`timestamp`),
  KEY `ezin_counts_temp_ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_editorials`
--

DROP TABLE IF EXISTS `ezin_editorials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_editorials` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `section_id` int(10) DEFAULT NULL,
  `article_id` int(11) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `text_wordcount` int(11) DEFAULT NULL,
  `text_flags` varchar(10) DEFAULT NULL,
  `text` text,
  `created_id` int(10) DEFAULT NULL,
  `created_by` varchar(60) DEFAULT NULL,
  `created_dt` datetime DEFAULT NULL,
  `changed_id` int(10) DEFAULT NULL,
  `changed_by` varchar(60) DEFAULT NULL,
  `changed_dt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ezin_editorials_section_id` (`section_id`),
  KEY `ezin_editorials_datetime` (`datetime`),
  KEY `ezin_editorials_article_id` (`article_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_feedback_data`
--

DROP TABLE IF EXISTS `ezin_feedback_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_feedback_data` (
  `feedback_id` int(11) NOT NULL DEFAULT '0',
  `field` varchar(255) DEFAULT NULL,
  `data` text,
  KEY `ezin_feedback_data_feedback_id` (`feedback_id`),
  KEY `ezin_feedback_data_field` (`field`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_feedbacks`
--

DROP TABLE IF EXISTS `ezin_feedbacks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_feedbacks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section_id` int(11) NOT NULL DEFAULT '0',
  `datetime` datetime DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ezin_feedbacks_section_id` (`section_id`),
  KEY `ezin_feedbacks_datetime` (`datetime`),
  KEY `ezin_feedbacks_ip` (`ip`),
  KEY `ezin_feedbacks_user_agent` (`user_agent`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_messages`
--

DROP TABLE IF EXISTS `ezin_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_messages` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent` int(10) DEFAULT NULL,
  `article_id` int(10) DEFAULT NULL,
  `author` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `homepage` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text,
  `datetime` datetime DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ezin_messages_parent` (`parent`),
  KEY `ezin_messages_article_id` (`article_id`),
  KEY `ezin_messages_datetime` (`datetime`),
  KEY `ezin_messages_ip` (`ip`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_nl_emails`
--

DROP TABLE IF EXISTS `ezin_nl_emails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_nl_emails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section_id` int(11) NOT NULL DEFAULT '0',
  `email` varchar(255) NOT NULL DEFAULT '',
  `dt_added` datetime DEFAULT NULL,
  `dt_removed` datetime DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ezin_nl_emails_email` (`email`),
  KEY `ezin_nl_emails_section_id` (`section_id`),
  KEY `ezin_nl_emails_dt_added` (`dt_added`),
  KEY `ezin_nl_emails_dt_removed` (`dt_removed`),
  KEY `ezin_nl_emails_ip` (`ip`),
  KEY `ezin_nl_emails_user_agent` (`user_agent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_nl_message_emails`
--

DROP TABLE IF EXISTS `ezin_nl_message_emails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_nl_message_emails` (
  `email_id` int(11) NOT NULL DEFAULT '0',
  `message_id` int(11) NOT NULL DEFAULT '0',
  `dt_posted` datetime DEFAULT NULL,
  PRIMARY KEY (`email_id`,`message_id`),
  KEY `ezin_nl_message_emails_dt_posted` (`dt_posted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_nl_messages`
--

DROP TABLE IF EXISTS `ezin_nl_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_nl_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sender` varchar(255) NOT NULL DEFAULT '',
  `subject` varchar(255) NOT NULL DEFAULT '',
  `dt_created` datetime DEFAULT NULL,
  `body` text,
  PRIMARY KEY (`id`),
  KEY `ezin_nl_messages_dt_created` (`dt_created`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_poll_answers`
--

DROP TABLE IF EXISTS `ezin_poll_answers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_poll_answers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `poll_id` int(11) NOT NULL DEFAULT '0',
  `answer` varchar(255) NOT NULL DEFAULT '',
  `votes` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `ezin_poll_answers_poll_id` (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_polls`
--

DROP TABLE IF EXISTS `ezin_polls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_polls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section_id` int(11) NOT NULL DEFAULT '0',
  `dt_valid_from` datetime DEFAULT NULL,
  `dt_valid_to` datetime DEFAULT NULL,
  `votes` int(11) DEFAULT NULL,
  `answers` int(11) DEFAULT NULL,
  `question` varchar(255) NOT NULL DEFAULT '',
  `description` text,
  `created_id` int(10) DEFAULT NULL,
  `created_by` varchar(60) DEFAULT NULL,
  `created_dt` datetime DEFAULT NULL,
  `changed_id` int(10) DEFAULT NULL,
  `changed_by` varchar(60) DEFAULT NULL,
  `changed_dt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ezin_polls_section_id` (`section_id`),
  KEY `ezin_polls_dt_valid_from` (`dt_valid_from`),
  KEY `ezin_polls_dt_valid_to` (`dt_valid_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_redirects`
--

DROP TABLE IF EXISTS `ezin_redirects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_redirects` (
  `old_key` varchar(64) NOT NULL,
  `type` enum('article','section','author','print') NOT NULL,
  `id` int(11) NOT NULL,
  PRIMARY KEY (`old_key`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_roles`
--

DROP TABLE IF EXISTS `ezin_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_roles` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) DEFAULT NULL,
  `login` varchar(10) DEFAULT NULL,
  `articles` varchar(10) DEFAULT NULL,
  `authors` varchar(10) DEFAULT NULL,
  `sections` varchar(10) DEFAULT NULL,
  `editorials` varchar(10) DEFAULT NULL,
  `messages` varchar(10) DEFAULT NULL,
  `polls` varchar(10) DEFAULT NULL,
  `feedbacks` varchar(10) DEFAULT NULL,
  `newsletters` varchar(10) DEFAULT NULL,
  `sessions` varchar(10) DEFAULT NULL,
  `config` varchar(10) DEFAULT NULL,
  `users` varchar(10) DEFAULT NULL,
  `roles` varchar(10) DEFAULT NULL,
  `file_management` varchar(15) DEFAULT NULL,
  `created_id` int(10) DEFAULT NULL,
  `created_by` varchar(60) DEFAULT NULL,
  `created_dt` datetime DEFAULT NULL,
  `changed_id` int(10) DEFAULT NULL,
  `changed_by` varchar(60) DEFAULT NULL,
  `changed_dt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ezin_roles_name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_sections`
--

DROP TABLE IF EXISTS `ezin_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_sections` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `author_id` int(10) DEFAULT NULL,
  `type` enum('global','normal','hidden','hidden2','full_hidden','disabled') DEFAULT NULL,
  `type2` set('global') DEFAULT NULL,
  `display` set('in_list','articles_enabled','articles_in_normal','articles_in_global') DEFAULT NULL,
  `select` set('articles','pages','editorials') DEFAULT NULL,
  `lang` varchar(2) DEFAULT NULL,
  `bind_lang` int(11) DEFAULT NULL,
  `ord` int(10) DEFAULT '100',
  `a_limit` int(10) DEFAULT NULL,
  `accesses_count` int(11) DEFAULT NULL,
  `sessions_count` int(11) DEFAULT NULL,
  `raw_accesses_count` int(11) DEFAULT NULL,
  `raw_sessions_count` int(11) DEFAULT NULL,
  `access_key` varchar(64) DEFAULT NULL,
  `template_key` varchar(64) DEFAULT NULL,
  `name` varchar(60) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `created_id` int(10) DEFAULT NULL,
  `created_by` varchar(60) DEFAULT NULL,
  `created_dt` datetime DEFAULT NULL,
  `changed_id` int(10) DEFAULT NULL,
  `changed_by` varchar(60) DEFAULT NULL,
  `changed_dt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ezin_sections_author_id` (`author_id`),
  KEY `ezin_sections_type` (`type`),
  KEY `ezin_sections_lang` (`lang`),
  KEY `ezin_sections_bind_lang` (`bind_lang`),
  KEY `ezin_sections_ord` (`ord`),
  KEY `ezin_sections_a_limit` (`a_limit`),
  KEY `ezin_sections_access_key` (`access_key`),
  KEY `ezin_sections_template_key` (`template_key`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_sessions`
--

DROP TABLE IF EXISTS `ezin_sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_sessions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `session_id` int(11) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `login` datetime DEFAULT NULL,
  `logout` datetime DEFAULT NULL,
  `status` varchar(16) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ezin_sessions_session_id` (`session_id`),
  KEY `ezin_sessions_username` (`username`),
  KEY `ezin_sessions_password` (`password`),
  KEY `ezin_sessions_login` (`login`),
  KEY `ezin_sessions_logout` (`logout`),
  KEY `ezin_sessions_status` (`status`),
  KEY `ezin_sessions_ip` (`ip`),
  KEY `ezin_sessions_user_agent` (`user_agent`)
) ENGINE=MyISAM AUTO_INCREMENT=86 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_sources`
--

DROP TABLE IF EXISTS `ezin_sources`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_sources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `source_type` enum('rss') NOT NULL,
  `section_id` int(11) NOT NULL,
  `url` varchar(255) NOT NULL,
  `normal_refresh_time` int(11) NOT NULL,
  `fail_refresh_time` int(11) NOT NULL,
  `connection_timeout` int(11) NOT NULL,
  `created_id` int(10) DEFAULT NULL,
  `created_by` varchar(60) DEFAULT NULL,
  `created_dt` datetime DEFAULT NULL,
  `changed_id` int(10) DEFAULT NULL,
  `changed_by` varchar(60) DEFAULT NULL,
  `changed_dt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ezin_users`
--

DROP TABLE IF EXISTS `ezin_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ezin_users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `username` varchar(60) DEFAULT NULL,
  `password` varchar(60) DEFAULT NULL,
  `author_id` int(11) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `created_id` int(10) DEFAULT NULL,
  `created_by` varchar(60) DEFAULT NULL,
  `created_dt` datetime DEFAULT NULL,
  `changed_id` int(10) DEFAULT NULL,
  `changed_by` varchar(60) DEFAULT NULL,
  `changed_dt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ezin_users_username` (`username`),
  KEY `ezin_users_author_id` (`author_id`),
  KEY `ezin_users_role_id` (`role_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 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 2014-02-22  6:36:46
-- MySQL dump 10.13  Distrib 5.1.73, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: metafox
-- ------------------------------------------------------
-- Server version    5.1.73-1

/*!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 */;

--
-- Dumping data for table `ezin_roles`
--

LOCK TABLES `ezin_roles` WRITE;
/*!40000 ALTER TABLE `ezin_roles` DISABLE KEYS */;
INSERT INTO `ezin_roles` VALUES (1,'0 - superuser','1','LFACPDV','LFACPDV','LFACPDV','LFACPDV','LFACPDV','LFACPDV','LC','LFACPDV','l','LC','LFACPDV','LFACPDV','LRDCErdcuves',NULL,NULL,NULL,NULL,NULL,NULL),(2,'1 - admin','1','LFACV','LFACV','LFACV','LFACV','LCV','LCV',NULL,'LCV','',NULL,'l','LV','LRCErvu',NULL,NULL,NULL,NULL,NULL,NULL),(3,'5 - editor','1','LFACV','LFV','LV','LV','LV','LV',NULL,'LV','',NULL,'l','LV','LRCErvu',NULL,NULL,NULL,NULL,NULL,NULL),(4,'6 - author','1','LFCAVP','LFcX','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL),(5,'9 - enemy','0','','','','','','',NULL,'','','','','','',NULL,NULL,NULL,NULL,NULL,NULL),(6,'8 - nobody','1','','','','','','',NULL,'','',NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL),(7,'3 - advanced editor','1','LFACV','LFACV','LV','LV','LV','LV',NULL,'LV','',NULL,'l','LV','LRCErvu',NULL,NULL,NULL,NULL,NULL,NULL),(8,'7 - visitor','1','LFV','LFV','LFV','LFV','LFV','LFV',NULL,'LFV','l','L','lFV','LFV','LEv',NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `ezin_roles` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2014-02-22  6:36:46
--
-- Default users
--
INSERT INTO ezin_users (id,username,password,author_id,role_id) VALUES
    (1,'admin','896ae34257056a6edb7643e3db85bb21',0,1);
INSERT INTO ezin_users (id,username,password,author_id,role_id) VALUES
    (2,'user', '896ae34257056a6edb7643e3db85bb21',0,3);

--
-- Default authors
--
INSERT INTO ezin_authors (id,type,name,email,homepage,description) VALUES
    (1,'internal','Admin','platon@platon.sk','http://platon.sk/','This is Admin.');
INSERT INTO ezin_authors (id,type,name,email,homepage,description) VALUES
    (2,'internal','Ondrej Jombík','nepto@platon.sk','http://nepto.sk/','This is Nepto. ;-)');

--
-- Default section
--
INSERT INTO ezin_sections
    (id, author_id, ord, a_limit,
    type2, display, `select`,
    accesses_count, sessions_count, raw_accesses_count, raw_sessions_count,
    access_key, template_key, name, link)
VALUES
    (1,0,100,10,
    'global','in_list,articles_enabled','articles',
    0,0,0,0,
    'index','','Index','');
--
-- Default article
--
INSERT INTO ezin_articles
    (id, author_id, section_id,
    accesses_count, sessions_count, message_count,
    status, display, datetime, access_key, template_key,
    title, atitle, hometext, bodytext)
VALUES (1,2,1,
    0,0,0,
    'showed','enabled','2002-09-13 16:23:00','','',
    'Default article title','Default article annotation title',
    'Default article home text (annotation)',
    'Default article body text');
--
-- Default config
--
INSERT INTO ezin_config (a_key,value) VALUES ('name','Metafox Default');
INSERT INTO ezin_config (a_key,value) VALUES ('abbreviation','dflt');
INSERT INTO ezin_config (a_key,value) VALUES ('theme','default');
INSERT INTO ezin_config (a_key,value) VALUES ('url',NULL);
INSERT INTO ezin_config (a_key,value) VALUES ('redirect_index','S1');
INSERT INTO ezin_config (a_key,value) VALUES ('redirect_other',NULL);
INSERT INTO ezin_config (a_key,value) VALUES ('admin_session_timeout',1800);


Platon Group <platon@platon.sk> http://platon.sk/
Copyright © 2002-2006 Platon Group
Stránka používa redakčný systém Metafox
Na začiatok