-- https://www.phpmyadmin.net/
--
-- Servidor: localhost
-- Tiempo de generación: 12-02-2025 a las 10:14:23
-- Versión del servidor: 10.4.32-MariaDB
-- Versión de PHP: 8.2.12

START TRANSACTION;



--
-- Base de datos: `dotclear`
--

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

--
-- Estructura de tabla para la tabla `dotclear_blog`
--

CREATE TABLE `dotclear_blog` (
  `blog_id` varchar(32) NOT NULL,
  `blog_uid` varchar(32) NOT NULL,
  `blog_creadt` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `blog_upddt` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `blog_url` varchar(255) NOT NULL,
  `blog_name` varchar(255) NOT NULL,
  `blog_desc` longtext DEFAULT NULL,
  `blog_status` smallint(6) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Volcado de datos para la tabla `dotclear_blog`
--

INSERT INTO `dotclear_blog` (`blog_id`, `blog_uid`, `blog_creadt`, `blog_upddt`, `blog_url`, `blog_name`, `blog_desc`, `blog_status`) VALUES
('default', 'b1f67a6d3187bcb6620c2ac08e860f78', '2025-02-10 12:35:49', '2025-02-10 12:35:49', 'http://localhost/blog/index.php?', 'My first blog', NULL, 1);

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

--
-- Estructura de tabla para la tabla `dotclear_category`
--

CREATE TABLE `dotclear_category` (
  `cat_id` bigint(20) NOT NULL,
  `blog_id` varchar(32) NOT NULL,
  `cat_title` varchar(255) NOT NULL,
  `cat_url` varchar(255) NOT NULL,
  `cat_desc` longtext DEFAULT NULL,
  `cat_position` int(11) DEFAULT 0,
  `cat_lft` int(11) DEFAULT NULL,
  `cat_rgt` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Estructura de tabla para la tabla `dotclear_comment`
--

CREATE TABLE `dotclear_comment` (
  `comment_id` bigint(20) NOT NULL,
  `post_id` bigint(20) NOT NULL,
  `comment_dt` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `comment_tz` varchar(128) NOT NULL DEFAULT 'UTC',
  `comment_upddt` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `comment_author` varchar(255) DEFAULT NULL,
  `comment_email` varchar(255) DEFAULT NULL,
  `comment_site` varchar(255) DEFAULT NULL,
  `comment_content` longtext DEFAULT NULL,
  `comment_words` longtext DEFAULT NULL,
  `comment_ip` varchar(39) DEFAULT NULL,
  `comment_status` smallint(6) DEFAULT 0,
  `comment_spam_status` varchar(128) DEFAULT '0',
  `comment_spam_filter` varchar(32) DEFAULT NULL,
  `comment_trackback` smallint(6) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Volcado de datos para la tabla `dotclear_comment`
--

INSERT INTO `dotclear_comment` (`comment_id`, `post_id`, `comment_dt`, `comment_tz`, `comment_upddt`, `comment_author`, `comment_email`, `comment_site`, `comment_content`, `comment_words`, `comment_ip`, `comment_status`, `comment_spam_status`, `comment_spam_filter`, `comment_trackback`) VALUES
(1, 1, '2025-02-10 12:35:49', 'Europe/London', '2025-02-10 12:35:49', 'Dotclear Team', 'contact@dotclear.net', 'https://dotclear.org/', '<p>This is a comment.</p>\n<p>To delete it, log in and view your blog\'s comments. Then you might remove or edit it.</p>', 'this comment delete log and view your blog comments then you might remove edit', '127.0.0.1', 1, '0', NULL, 0);

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

--
-- Estructura de tabla para la tabla `dotclear_link`
--

CREATE TABLE `dotclear_link` (
  `link_id` bigint(20) NOT NULL,
  `blog_id` varchar(32) NOT NULL,
  `link_href` varchar(255) NOT NULL,
  `link_title` varchar(255) NOT NULL,
  `link_desc` varchar(255) DEFAULT NULL,
  `link_lang` varchar(5) DEFAULT NULL,
  `link_xfn` varchar(255) DEFAULT NULL,
  `link_position` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Estructura de tabla para la tabla `dotclear_log`
--

CREATE TABLE `dotclear_log` (
  `log_id` bigint(20) NOT NULL,
  `user_id` varchar(32) DEFAULT NULL,
  `blog_id` varchar(32) DEFAULT NULL,
  `log_table` varchar(255) NOT NULL,
  `log_dt` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `log_ip` varchar(39) NOT NULL,
  `log_msg` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Estructura de tabla para la tabla `dotclear_media`
--

CREATE TABLE `dotclear_media` (
  `media_id` bigint(20) NOT NULL,
  `user_id` varchar(32) NOT NULL,
  `media_path` varchar(255) NOT NULL,
  `media_title` varchar(255) NOT NULL,
  `media_file` varchar(255) NOT NULL,
  `media_dir` varchar(255) NOT NULL DEFAULT '.',
  `media_meta` longtext DEFAULT NULL,
  `media_dt` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `media_creadt` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `media_upddt` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `media_private` smallint(6) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Estructura de tabla para la tabla `dotclear_meta`
--

CREATE TABLE `dotclear_meta` (
  `meta_id` varchar(255) NOT NULL,
  `meta_type` varchar(64) NOT NULL,
  `post_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Estructura de tabla para la tabla `dotclear_notice`
--

CREATE TABLE `dotclear_notice` (
  `notice_id` bigint(20) NOT NULL,
  `ses_id` varchar(40) NOT NULL,
  `notice_type` varchar(32) DEFAULT NULL,
  `notice_ts` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `notice_msg` longtext DEFAULT NULL,
  `notice_format` varchar(32) DEFAULT 'text',
  `notice_options` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Estructura de tabla para la tabla `dotclear_permissions`
--

CREATE TABLE `dotclear_permissions` (
  `user_id` varchar(32) NOT NULL,
  `blog_id` varchar(32) NOT NULL,
  `permissions` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Estructura de tabla para la tabla `dotclear_ping`
--

CREATE TABLE `dotclear_ping` (
  `post_id` bigint(20) NOT NULL,
  `ping_url` varchar(255) NOT NULL,
  `ping_dt` datetime NOT NULL DEFAULT '1970-01-01 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Estructura de tabla para la tabla `dotclear_post`
--

CREATE TABLE `dotclear_post` (
  `post_id` bigint(20) NOT NULL,
  `blog_id` varchar(32) NOT NULL,
  `user_id` varchar(32) NOT NULL,
  `cat_id` bigint(20) DEFAULT NULL,
  `post_dt` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `post_tz` varchar(128) NOT NULL DEFAULT 'UTC',
  `post_creadt` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `post_upddt` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `post_password` varchar(32) DEFAULT NULL,
  `post_type` varchar(32) NOT NULL DEFAULT 'post',
  `post_format` varchar(32) NOT NULL DEFAULT 'xhtml',
  `post_url` varchar(255) NOT NULL,
  `post_lang` varchar(5) DEFAULT NULL,
  `post_title` varchar(255) DEFAULT NULL,
  `post_excerpt` longtext DEFAULT NULL,
  `post_excerpt_xhtml` longtext DEFAULT NULL,
  `post_content` longtext DEFAULT NULL,
  `post_content_xhtml` longtext NOT NULL,
  `post_notes` longtext DEFAULT NULL,
  `post_meta` longtext DEFAULT NULL,
  `post_words` longtext DEFAULT NULL,
  `post_status` smallint(6) NOT NULL DEFAULT 0,
  `post_firstpub` smallint(6) NOT NULL DEFAULT 0,
  `post_selected` smallint(6) NOT NULL DEFAULT 0,
  `post_position` int(11) NOT NULL DEFAULT 0,
  `post_open_comment` smallint(6) NOT NULL DEFAULT 0,
  `post_open_tb` smallint(6) NOT NULL DEFAULT 0,
  `nb_comment` int(11) NOT NULL DEFAULT 0,
  `nb_trackback` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Volcado de datos para la tabla `dotclear_post`
--

INSERT INTO `dotclear_post` (`post_id`, `blog_id`, `user_id`, `cat_id`, `post_dt`, `post_tz`, `post_creadt`, `post_upddt`, `post_password`, `post_type`, `post_format`, `post_url`, `post_lang`, `post_title`, `post_excerpt`, `post_excerpt_xhtml`, `post_content`, `post_content_xhtml`, `post_notes`, `post_meta`, `post_words`, `post_status`, `post_firstpub`, `post_selected`, `post_position`, `post_open_comment`, `post_open_tb`, `nb_comment`, `nb_trackback`) VALUES
(1, 'default', 'administrador', NULL, '2025-02-10 12:35:00', 'Europe/London', '2025-02-10 12:35:49', '2025-02-10 12:35:49', NULL, 'post', 'xhtml', '2025/02/10/Welcome-to-Dotclear!', 'es', 'Welcome to Dotclear!', NULL, '', '<p>This is your first entry. When you\'re ready to blog, log in to edit or delete it.</p>', '<p>This is your first entry. When you\'re ready to blog, log in to edit or delete it.</p>', NULL, NULL, 'welcome dotclear this your first entry when you ready blog log edit delete', 1, 1, 0, 0, 1, 0, 1, 0),
(2, 'default', 'administrador', NULL, '2025-02-10 12:35:00', 'Europe/London', '2025-02-10 12:35:49', '2025-02-10 12:35:49', NULL, 'page', 'xhtml', '2025/02/10/My-first-page', 'es', 'My first page', '', '', '<p>This is your first page. When you\'re ready to blog, log in to edit or delete it.</p>', '<p>This is your first page. When you\'re ready to blog, log in to edit or delete it.</p>', NULL, NULL, 'first page this your first page when you ready blog log edit delete', -2, 0, 0, 0, 0, 0, 0, 0);

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

--
-- Estructura de tabla para la tabla `dotclear_post_media`
--

CREATE TABLE `dotclear_post_media` (
  `media_id` bigint(20) NOT NULL,
  `post_id` bigint(20) NOT NULL,
  `link_type` varchar(32) NOT NULL DEFAULT 'attachment'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Estructura de tabla para la tabla `dotclear_pref`
--

CREATE TABLE `dotclear_pref` (
  `pref_id` varchar(255) NOT NULL,
  `user_id` varchar(32) DEFAULT NULL,
  `pref_ws` varchar(32) NOT NULL DEFAULT 'system',
  `pref_value` longtext DEFAULT NULL,
  `pref_type` varchar(8) NOT NULL DEFAULT 'string',
  `pref_label` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Volcado de datos para la tabla `dotclear_pref`
--

INSERT INTO `dotclear_pref` (`pref_id`, `user_id`, `pref_ws`, `pref_value`, `pref_type`, `pref_label`) VALUES
('doclinks', NULL, 'dashboard', '1', 'boolean', ''),
('dcnews', NULL, 'dashboard', '1', 'boolean', ''),
('quickentry', NULL, 'dashboard', '1', 'boolean', ''),
('nodcupdate', NULL, 'dashboard', '0', 'boolean', ''),
('nodragdrop', NULL, 'accessibility', '0', 'boolean', ''),
('enhanceduploader', NULL, 'interface', '1', 'boolean', ''),
('favorites', NULL, 'dashboard', '[]', 'array', 'User favorites'),
('favorites', 'administrador', 'dashboard', '[]', 'array', NULL),
('favorites', NULL, 'dashboard', '[\"posts\",\"new_post\",\"newpage\",\"comments\",\"categories\",\"media\",\"blog_theme\",\"widgets\",\"simpleMenu\",\"prefs\",\"help\"]', 'array', NULL),
('quickentry', 'administrador', 'dashboard', '0', 'boolean', ''),
('unfolded_sections', NULL, 'toggles', '', 'string', 'Folded sections in admin'),
('unfolded_sections', 'administrador', 'toggles', 'dc_system_menu', 'string', 'Folded sections in admin');

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

--
-- Estructura de tabla para la tabla `dotclear_session`
--

CREATE TABLE `dotclear_session` (
  `ses_id` varchar(40) NOT NULL,
  `ses_time` int(11) NOT NULL DEFAULT 0,
  `ses_start` int(11) NOT NULL DEFAULT 0,
  `ses_value` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Volcado de datos para la tabla `dotclear_session`
--

INSERT INTO `dotclear_session` (`ses_id`, `ses_time`, `ses_start`, `ses_value`) VALUES
('37d218614506fdcc60120bced012b0ebc8bb2a7e', 1739192484, 1739190972, 'sess_user_id|s:13:\"administrador\";sess_browser_uid|s:40:\"1687be8c7a9c939c21f29fdfda2f8c4f130fef3c\";sess_blog_id|s:7:\"default\";'),
('6b5703cd2cd50234c5084777e07ed9f021a09a63', 1739351641, 1739351032, 'sess_user_id|s:13:\"administrador\";sess_browser_uid|s:40:\"1687be8c7a9c939c21f29fdfda2f8c4f130fef3c\";sess_blog_id|s:7:\"default\";');

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

--
-- Estructura de tabla para la tabla `dotclear_setting`
--

CREATE TABLE `dotclear_setting` (
  `setting_id` varchar(255) NOT NULL,
  `blog_id` varchar(32) DEFAULT NULL,
  `setting_ns` varchar(32) NOT NULL DEFAULT 'system',
  `setting_value` longtext DEFAULT NULL,
  `setting_type` varchar(8) NOT NULL DEFAULT 'string',
  `setting_label` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Volcado de datos para la tabla `dotclear_setting`
--

INSERT INTO `dotclear_setting` (`setting_id`, `blog_id`, `setting_ns`, `setting_value`, `setting_type`, `setting_label`) VALUES
('allow_comments', NULL, 'system', '1', 'boolean', 'Allow comments on blog'),
('allow_trackbacks', NULL, 'system', '1', 'boolean', 'Allow trackbacks on blog'),
('blog_timezone', NULL, 'system', 'Europe/London', 'string', 'Blog timezone'),
('comments_nofollow', NULL, 'system', '1', 'boolean', 'Add rel=\"nofollow\" to comments URLs'),
('comments_pub', NULL, 'system', '1', 'boolean', 'Publish comments immediately'),
('comments_ttl', NULL, 'system', '0', 'integer', 'Number of days to keep comments open (0 means no ttl)'),
('copyright_notice', NULL, 'system', '', 'string', 'Copyright notice (simple text)'),
('date_format', NULL, 'system', '%A, %B %e %Y', 'string', 'Date format. See PHP strftime function for patterns'),
('editor', NULL, 'system', '', 'string', 'Person responsible of the content'),
('enable_html_filter', NULL, 'system', '0', 'boolean', 'Enable HTML filter'),
('lang', NULL, 'system', 'en', 'string', 'Default blog language'),
('media_exclusion', NULL, 'system', '/\\.(phps?|pht(ml)?|phl|phar|.?html?|xml|js|htaccess)[0-9]*$/i', 'string', 'File name exclusion pattern in media manager. (PCRE value)'),
('media_img_m_size', NULL, 'system', '448', 'integer', 'Image medium size in media manager'),
('media_img_s_size', NULL, 'system', '240', 'integer', 'Image small size in media manager'),
('media_img_t_size', NULL, 'system', '100', 'integer', 'Image thumbnail size in media manager'),
('media_img_title_pattern', NULL, 'system', 'Title ;; Date(%b %Y) ;; separator(, )', 'string', 'Pattern to set image title when you insert it in a post'),
('media_video_width', NULL, 'system', '400', 'integer', 'Video width in media manager'),
('media_video_height', NULL, 'system', '300', 'integer', 'Video height in media manager'),
('nb_post_for_home', NULL, 'system', '20', 'integer', 'Number of entries on first home page'),
('nb_post_per_page', NULL, 'system', '20', 'integer', 'Number of entries on home pages and category pages'),
('nb_post_per_feed', NULL, 'system', '20', 'integer', 'Number of entries on feeds'),
('nb_comment_per_feed', NULL, 'system', '20', 'integer', 'Number of comments on feeds'),
('post_url_format', NULL, 'system', '{y}/{m}/{d}/{t}', 'string', 'Post URL format. {y}: year, {m}: month, {d}: day, {id}: post id, {t}: entry title'),
('public_path', NULL, 'system', 'public', 'string', 'Path to public directory, begins with a / for a full system path'),
('public_url', NULL, 'system', '/public', 'string', 'URL to public directory'),
('robots_policy', NULL, 'system', 'INDEX,FOLLOW', 'string', 'Search engines robots policy'),
('short_feed_items', NULL, 'system', '0', 'boolean', 'Display short feed items'),
('theme', NULL, 'system', 'berlin', 'string', 'Blog theme'),
('themes_path', NULL, 'system', 'themes', 'string', 'Themes root path'),
('themes_url', NULL, 'system', '/themes', 'string', 'Themes root URL'),
('time_format', NULL, 'system', '%H:%M', 'string', 'Time format. See PHP strftime function for patterns'),
('tpl_allow_php', NULL, 'system', '0', 'boolean', 'Allow PHP code in templates'),
('tpl_use_cache', NULL, 'system', '1', 'boolean', 'Use template caching'),
('trackbacks_pub', NULL, 'system', '1', 'boolean', 'Publish trackbacks immediately'),
('trackbacks_ttl', NULL, 'system', '0', 'integer', 'Number of days to keep trackbacks open (0 means no ttl)'),
('url_scan', NULL, 'system', 'query_string', 'string', 'URL handle mode (path_info or query_string)'),
('no_public_css', NULL, 'system', '0', 'boolean', 'Don\'t use generic public.css stylesheet'),
('use_smilies', NULL, 'system', '0', 'boolean', 'Show smilies on entries and comments'),
('no_search', NULL, 'system', '0', 'boolean', 'Disable search'),
('inc_subcats', NULL, 'system', '0', 'boolean', 'Include sub-categories in category page and category posts feed'),
('wiki_comments', NULL, 'system', '0', 'boolean', 'Allow commenters to use a subset of wiki syntax'),
('import_feed_url_control', NULL, 'system', '1', 'boolean', 'Control feed URL before import'),
('import_feed_no_private_ip', NULL, 'system', '1', 'boolean', 'Prevent import feed from private IP'),
('import_feed_ip_regexp', NULL, 'system', '', 'string', 'Authorize import feed only from this IP regexp'),
('import_feed_port_regexp', NULL, 'system', '/^(80|443)$/', 'string', 'Authorize import feed only from this port regexp'),
('jquery_needed', NULL, 'system', '1', 'boolean', 'Load jQuery library'),
('sleepmode_timeout', NULL, 'system', '31536000', 'integer', 'Sleep mode timeout'),
('store_plugin_url', NULL, 'system', 'https://update.dotaddict.org/dc2/plugins.xml', 'string', 'Plugins XML feed location'),
('store_theme_url', NULL, 'system', 'https://update.dotaddict.org/dc2/themes.xml', 'string', 'Themes XML feed location'),
('lang', 'default', 'system', 'es', 'string', 'Default blog language'),
('public_url', 'default', 'system', '/blog/public', 'string', 'URL to public directory'),
('themes_url', 'default', 'system', '/blog/themes', 'string', 'Themes root URL'),
('date_formats', NULL, 'system', '[\"%Y-%m-%d\",\"%m\\/%d\\/%Y\",\"%d\\/%m\\/%Y\",\"%Y\\/%m\\/%d\",\"%d.%m.%Y\",\"%b %e %Y\",\"%e %b %Y\",\"%Y %b %e\",\"%a, %Y-%m-%d\",\"%a, %m\\/%d\\/%Y\",\"%a, %d\\/%m\\/%Y\",\"%a, %Y\\/%m\\/%d\",\"%B %e, %Y\",\"%e %B, %Y\",\"%Y, %B %e\",\"%e. %B %Y\",\"%A, %B %e, %Y\",\"%A, %e %B, %Y\",\"%A, %Y, %B %e\",\"%A, %Y, %B %e\",\"%A, %e. %B %Y\"]', 'array', 'Date formats examples'),
('time_formats', NULL, 'system', '[\"%H:%M\",\"%I:%M\",\"%l:%M\",\"%Hh%M\",\"%Ih%M\",\"%lh%M\"]', 'array', 'Time formats examples'),
('csp_admin_on', NULL, 'system', '1', 'boolean', 'Send CSP header (admin)'),
('csp_admin_report_only', NULL, 'system', '0', 'boolean', 'CSP Report only violations (admin)'),
('csp_admin_default', NULL, 'system', '\'self\'', 'string', 'CSP default-src directive'),
('csp_admin_script', NULL, 'system', '\'self\' \'unsafe-eval\'', 'string', 'CSP script-src directive'),
('csp_admin_style', NULL, 'system', '\'self\' \'unsafe-inline\'', 'string', 'CSP style-src directive'),
('csp_admin_img', NULL, 'system', '\'self\' data: https://media.dotaddict.org blob:', 'string', 'CSP img-src directive'),
('firstpage', 'default', 'pages', '1', 'boolean', NULL),
('active', NULL, 'dcCKEditor', '1', 'boolean', 'dcCKEditor plugin activated?'),
('alignment_buttons', NULL, 'dcCKEditor', '1', 'boolean', 'Add alignment buttons?'),
('list_buttons', NULL, 'dcCKEditor', '1', 'boolean', 'Add list buttons?'),
('textcolor_button', NULL, 'dcCKEditor', '0', 'boolean', 'Add text color button?'),
('background_textcolor_button', NULL, 'dcCKEditor', '0', 'boolean', 'Add background text color button?'),
('cancollapse_button', NULL, 'dcCKEditor', '0', 'boolean', 'Add collapse button?'),
('format_select', NULL, 'dcCKEditor', '1', 'boolean', 'Add format selection?'),
('format_tags', NULL, 'dcCKEditor', 'p;h1;h2;h3;h4;h5;h6;pre;address', 'string', 'Custom formats'),
('table_button', NULL, 'dcCKEditor', '0', 'boolean', 'Add table button?'),
('clipboard_buttons', NULL, 'dcCKEditor', '0', 'boolean', 'Add clipboard buttons?'),
('action_buttons', NULL, 'dcCKEditor', '1', 'boolean', 'Add undo/redo buttons?'),
('disable_native_spellchecker', NULL, 'dcCKEditor', '1', 'boolean', 'Disables the built-in spell checker if the browser provides one?'),
('active', NULL, 'dcLegacyEditor', '1', 'boolean', 'dcLegacyEditor plugin activated ?'),
('pings_active', NULL, 'pings', '1', 'boolean', 'Activate pings plugin'),
('pings_auto', NULL, 'pings', '0', 'boolean', 'Auto pings on 1st publication'),
('pings_uris', NULL, 'pings', '{\"Ping-o-Matic!\":\"http:\\/\\/rpc.pingomatic.com\\/\"}', 'array', 'Pings services URIs'),
('simpleMenu', NULL, 'system', '[{\"label\":\"Home\",\"descr\":\"Recent posts\",\"url\":\"\\/blog\\/index.php?\",\"targetBlank\":false},{\"label\":\"Archives\",\"descr\":\"\",\"url\":\"\\/blog\\/index.php?archive\",\"targetBlank\":false}]', 'array', 'simpleMenu default menu'),
('simpleMenu_active', NULL, 'system', '1', 'boolean', 'Active'),
('no_direct_uninstall', NULL, 'Uninstaller', '0', 'boolean', 'Disabled uninstall actions on module deletion'),
('widgets_nav', 'default', 'widgets', '', 'string', 'Navigation widgets'),
('widgets_extra', 'default', 'widgets', '', 'string', 'Extra widgets'),
('widgets_custom', 'default', 'widgets', '', 'string', 'Custom widgets'),
('jquery_migrate_mute', 'default', 'system', '1', 'boolean', 'Mute warnings for jquery migrate plugin ?'),
('jquery_allow_old_version', NULL, 'system', '0', 'boolean', 'Allow older version of jQuery'),
('antispam_moderation_ttl', 'default', 'antispam', '0', 'integer', 'Antispam Moderation TTL (days)'),
('antispam_date_last_purge', 'default', 'antispam', '1739351014', 'integer', 'Antispam Date Last Purge (unix timestamp)');

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

--
-- Estructura de tabla para la tabla `dotclear_spamrule`
--

CREATE TABLE `dotclear_spamrule` (
  `rule_id` bigint(20) NOT NULL,
  `blog_id` varchar(32) DEFAULT NULL,
  `rule_type` varchar(16) NOT NULL DEFAULT 'word',
  `rule_content` varchar(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Volcado de datos para la tabla `dotclear_spamrule`
--

INSERT INTO `dotclear_spamrule` (`rule_id`, `blog_id`, `rule_type`, `rule_content`) VALUES
(1, NULL, 'word', '/-credit(\\s+|$)/'),
(2, NULL, 'word', '/-digest(\\s+|$)/'),
(3, NULL, 'word', '/-loan(\\s+|$)/'),
(4, NULL, 'word', '/-online(\\s+|$)/'),
(5, NULL, 'word', '4u'),
(6, NULL, 'word', 'adipex'),
(7, NULL, 'word', 'advicer'),
(8, NULL, 'word', 'ambien'),
(9, NULL, 'word', 'baccarat'),
(10, NULL, 'word', 'baccarrat'),
(11, NULL, 'word', 'blackjack'),
(12, NULL, 'word', 'bllogspot'),
(13, NULL, 'word', 'bolobomb'),
(14, NULL, 'word', 'booker'),
(15, NULL, 'word', 'byob'),
(16, NULL, 'word', 'car-rental-e-site'),
(17, NULL, 'word', 'car-rentals-e-site'),
(18, NULL, 'word', 'carisoprodol'),
(19, NULL, 'word', 'cash'),
(20, NULL, 'word', 'casino'),
(21, NULL, 'word', 'casinos'),
(22, NULL, 'word', 'chatroom'),
(23, NULL, 'word', 'cialis'),
(24, NULL, 'word', 'craps'),
(25, NULL, 'word', 'credit-card'),
(26, NULL, 'word', 'credit-report-4u'),
(27, NULL, 'word', 'cwas'),
(28, NULL, 'word', 'cyclen'),
(29, NULL, 'word', 'cyclobenzaprine'),
(30, NULL, 'word', 'dating-e-site'),
(31, NULL, 'word', 'day-trading'),
(32, NULL, 'word', 'debt'),
(33, NULL, 'word', 'digest-'),
(34, NULL, 'word', 'discount'),
(35, NULL, 'word', 'discreetordering'),
(36, NULL, 'word', 'duty-free'),
(37, NULL, 'word', 'dutyfree'),
(38, NULL, 'word', 'estate'),
(39, NULL, 'word', 'favourits'),
(40, NULL, 'word', 'fioricet'),
(41, NULL, 'word', 'flowers-leading-site'),
(42, NULL, 'word', 'freenet'),
(43, NULL, 'word', 'freenet-shopping'),
(44, NULL, 'word', 'gambling'),
(45, NULL, 'word', 'gamias'),
(46, NULL, 'word', 'health-insurancedeals-4u'),
(47, NULL, 'word', 'holdem'),
(48, NULL, 'word', 'holdempoker'),
(49, NULL, 'word', 'holdemsoftware'),
(50, NULL, 'word', 'holdemtexasturbowilson'),
(51, NULL, 'word', 'hotel-dealse-site'),
(52, NULL, 'word', 'hotele-site'),
(53, NULL, 'word', 'hotelse-site'),
(54, NULL, 'word', 'incest'),
(55, NULL, 'word', 'insurance-quotesdeals-4u'),
(56, NULL, 'word', 'insurancedeals-4u'),
(57, NULL, 'word', 'jrcreations'),
(58, NULL, 'word', 'levitra'),
(59, NULL, 'word', 'macinstruct'),
(60, NULL, 'word', 'mortgage'),
(61, NULL, 'word', 'online-gambling'),
(62, NULL, 'word', 'onlinegambling-4u'),
(63, NULL, 'word', 'ottawavalleyag'),
(64, NULL, 'word', 'ownsthis'),
(65, NULL, 'word', 'palm-texas-holdem-game'),
(66, NULL, 'word', 'paxil'),
(67, NULL, 'word', 'pharmacy'),
(68, NULL, 'word', 'phentermine'),
(69, NULL, 'word', 'pills'),
(70, NULL, 'word', 'poker'),
(71, NULL, 'word', 'poker-chip'),
(72, NULL, 'word', 'poze'),
(73, NULL, 'word', 'prescription'),
(74, NULL, 'word', 'rarehomes'),
(75, NULL, 'word', 'refund'),
(76, NULL, 'word', 'rental-car-e-site'),
(77, NULL, 'word', 'roulette'),
(78, NULL, 'word', 'shemale'),
(79, NULL, 'word', 'slot'),
(80, NULL, 'word', 'slot-machine'),
(81, NULL, 'word', 'soma'),
(82, NULL, 'word', 'taboo'),
(83, NULL, 'word', 'tamiflu'),
(84, NULL, 'word', 'texas-holdem'),
(85, NULL, 'word', 'thorcarlson'),
(86, NULL, 'word', 'top-e-site'),
(87, NULL, 'word', 'top-site'),
(88, NULL, 'word', 'tramadol'),
(89, NULL, 'word', 'trim-spa'),
(90, NULL, 'word', 'ultram'),
(91, NULL, 'word', 'v1h'),
(92, NULL, 'word', 'vacuum'),
(93, NULL, 'word', 'valeofglamorganconservatives'),
(94, NULL, 'word', 'viagra'),
(95, NULL, 'word', 'vicodin'),
(96, NULL, 'word', 'vioxx'),
(97, NULL, 'word', 'xanax'),
(98, NULL, 'word', 'zolus');

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

--
-- Estructura de tabla para la tabla `dotclear_user`
--

CREATE TABLE `dotclear_user` (
  `user_id` varchar(32) NOT NULL,
  `user_super` smallint(6) DEFAULT NULL,
  `user_status` smallint(6) NOT NULL DEFAULT 1,
  `user_pwd` varchar(255) NOT NULL,
  `user_change_pwd` smallint(6) NOT NULL DEFAULT 0,
  `user_recover_key` varchar(32) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `user_firstname` varchar(255) DEFAULT NULL,
  `user_displayname` varchar(255) DEFAULT NULL,
  `user_email` varchar(255) DEFAULT NULL,
  `user_url` varchar(255) DEFAULT NULL,
  `user_desc` longtext DEFAULT NULL,
  `user_default_blog` varchar(32) DEFAULT NULL,
  `user_options` longtext DEFAULT NULL,
  `user_lang` varchar(5) DEFAULT NULL,
  `user_tz` varchar(128) NOT NULL DEFAULT 'UTC',
  `user_post_status` smallint(6) NOT NULL DEFAULT -2,
  `user_creadt` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `user_upddt` datetime NOT NULL DEFAULT '1970-01-01 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Volcado de datos para la tabla `dotclear_user`
--

INSERT INTO `dotclear_user` (`user_id`, `user_super`, `user_status`, `user_pwd`, `user_change_pwd`, `user_recover_key`, `user_name`, `user_firstname`, `user_displayname`, `user_email`, `user_url`, `user_desc`, `user_default_blog`, `user_options`, `user_lang`, `user_tz`, `user_post_status`, `user_creadt`, `user_upddt`) VALUES
('administrador', 1, 1, '$2y$10$Ru3pAa6VjkL7cxH5R3vvzOcfLbubb3c7XF1xmwJbMNXjaapgHx.NK', 0, NULL, 'Alfonso', 'Micaela', NULL, 'malfonso@iesgadea.es', NULL, NULL, NULL, 'a:5:{s:9:\"edit_size\";i:24;s:14:\"enable_wysiwyg\";b:1;s:14:\"toolbar_bottom\";b:0;s:6:\"editor\";a:2:{s:5:\"xhtml\";s:10:\"dcCKEditor\";s:4:\"wiki\";s:14:\"dcLegacyEditor\";}s:11:\"post_format\";s:5:\"xhtml\";}', 'es', 'Europe/London', -2, '2025-02-10 12:35:49', '2025-02-10 12:35:49');

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

--
-- Estructura de tabla para la tabla `dotclear_version`
--

CREATE TABLE `dotclear_version` (
  `module` varchar(64) NOT NULL,
  `version` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Volcado de datos para la tabla `dotclear_version`
--

INSERT INTO `dotclear_version` (`module`, `version`) VALUES
('Uninstaller', '1.0'),
('aboutConfig', '1.0'),
('akismet', '2.0'),
('antispam', '2.0'),
('attachments', '2.0'),
('blogroll', '2.0'),
('breadcrumb', '1.1'),
('core', '2.28.1'),
('dcCKEditor', '2.1'),
('dcLegacyEditor', '1.1'),
('dcProxyV1', '1.0'),
('dcProxyV2', '2.0'),
('fairTrackbacks', '2.0'),
('importExport', '4.0'),
('maintenance', '2.0'),
('pages', '2.0'),
('pings', '2.0'),
('simpleMenu', '2.0'),
('tags', '2.0'),
('themeEditor', '2.0'),
('userPref', '1.0'),
('widgets', '4.0');

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `dotclear_blog`
--
ALTER TABLE `dotclear_blog`
  ADD PRIMARY KEY (`blog_id`),
  ADD KEY `dotclear_idx_blog_blog_upddt` (`blog_upddt`) USING BTREE;

--
-- Indices de la tabla `dotclear_category`
--
ALTER TABLE `dotclear_category`
  ADD PRIMARY KEY (`cat_id`),
  ADD UNIQUE KEY `dotclear_uk_cat_url` (`cat_url`,`blog_id`),
  ADD KEY `dotclear_idx_category_blog_id` (`blog_id`) USING BTREE,
  ADD KEY `dotclear_idx_category_cat_lft_blog_id` (`blog_id`,`cat_lft`) USING BTREE,
  ADD KEY `dotclear_idx_category_cat_rgt_blog_id` (`blog_id`,`cat_rgt`) USING BTREE;

--
-- Indices de la tabla `dotclear_comment`
--
ALTER TABLE `dotclear_comment`
  ADD PRIMARY KEY (`comment_id`),
  ADD KEY `dotclear_idx_comment_post_id` (`post_id`) USING BTREE,
  ADD KEY `dotclear_idx_comment_post_id_dt_status` (`post_id`,`comment_dt`,`comment_status`) USING BTREE;

--
-- Indices de la tabla `dotclear_link`
--
ALTER TABLE `dotclear_link`
  ADD PRIMARY KEY (`link_id`),
  ADD KEY `dotclear_idx_link_blog_id` (`blog_id`) USING BTREE;

--
-- Indices de la tabla `dotclear_log`
--
ALTER TABLE `dotclear_log`
  ADD PRIMARY KEY (`log_id`),
  ADD KEY `dotclear_idx_log_user_id` (`user_id`) USING BTREE,
  ADD KEY `dotclear_fk_log_blog` (`blog_id`);

--
-- Indices de la tabla `dotclear_media`
--
ALTER TABLE `dotclear_media`
  ADD PRIMARY KEY (`media_id`),
  ADD KEY `dotclear_idx_media_user_id` (`user_id`) USING BTREE;

--
-- Indices de la tabla `dotclear_meta`
--
ALTER TABLE `dotclear_meta`
  ADD PRIMARY KEY (`meta_id`,`meta_type`,`post_id`),
  ADD KEY `dotclear_idx_meta_post_id` (`post_id`) USING BTREE,
  ADD KEY `dotclear_idx_meta_meta_type` (`meta_type`) USING BTREE;

--
-- Indices de la tabla `dotclear_notice`
--
ALTER TABLE `dotclear_notice`
  ADD PRIMARY KEY (`notice_id`),
  ADD KEY `dotclear_fk_notice_session` (`ses_id`);

--
-- Indices de la tabla `dotclear_permissions`
--
ALTER TABLE `dotclear_permissions`
  ADD PRIMARY KEY (`user_id`,`blog_id`),
  ADD KEY `dotclear_idx_permissions_blog_id` (`blog_id`) USING BTREE;

--
-- Indices de la tabla `dotclear_ping`
--
ALTER TABLE `dotclear_ping`
  ADD PRIMARY KEY (`post_id`,`ping_url`);

--
-- Indices de la tabla `dotclear_post`
--
ALTER TABLE `dotclear_post`
  ADD PRIMARY KEY (`post_id`),
  ADD UNIQUE KEY `dotclear_uk_post_url` (`post_url`,`post_type`,`blog_id`),
  ADD KEY `dotclear_idx_post_cat_id` (`cat_id`) USING BTREE,
  ADD KEY `dotclear_idx_post_user_id` (`user_id`) USING BTREE,
  ADD KEY `dotclear_idx_post_blog_id` (`blog_id`) USING BTREE,
  ADD KEY `dotclear_idx_post_post_dt` (`post_dt`) USING BTREE,
  ADD KEY `dotclear_idx_post_post_dt_post_id` (`post_dt`,`post_id`) USING BTREE,
  ADD KEY `dotclear_idx_blog_post_post_dt_post_id` (`blog_id`,`post_dt`,`post_id`) USING BTREE,
  ADD KEY `dotclear_idx_blog_post_post_status` (`blog_id`,`post_status`) USING BTREE;

--
-- Indices de la tabla `dotclear_post_media`
--
ALTER TABLE `dotclear_post_media`
  ADD PRIMARY KEY (`media_id`,`post_id`,`link_type`),
  ADD KEY `dotclear_idx_post_media_post_id` (`post_id`) USING BTREE,
  ADD KEY `dotclear_idx_post_media_media_id` (`media_id`) USING BTREE;

--
-- Indices de la tabla `dotclear_pref`
--
ALTER TABLE `dotclear_pref`
  ADD UNIQUE KEY `dotclear_uk_pref` (`pref_ws`,`pref_id`,`user_id`),
  ADD KEY `dotclear_idx_pref_user_id` (`user_id`) USING BTREE;

--
-- Indices de la tabla `dotclear_session`
--
ALTER TABLE `dotclear_session`
  ADD PRIMARY KEY (`ses_id`);

--
-- Indices de la tabla `dotclear_setting`
--
ALTER TABLE `dotclear_setting`
  ADD UNIQUE KEY `dotclear_uk_setting` (`setting_ns`,`setting_id`,`blog_id`),
  ADD KEY `dotclear_idx_setting_blog_id` (`blog_id`) USING BTREE;

--
-- Indices de la tabla `dotclear_spamrule`
--
ALTER TABLE `dotclear_spamrule`
  ADD PRIMARY KEY (`rule_id`),
  ADD KEY `dotclear_idx_spamrule_blog_id` (`blog_id`) USING BTREE;

--
-- Indices de la tabla `dotclear_user`
--
ALTER TABLE `dotclear_user`
  ADD PRIMARY KEY (`user_id`),
  ADD KEY `dotclear_idx_user_user_default_blog` (`user_default_blog`) USING BTREE,
  ADD KEY `dotclear_idx_user_user_super` (`user_super`) USING BTREE;

--
-- Indices de la tabla `dotclear_version`
--
ALTER TABLE `dotclear_version`
  ADD PRIMARY KEY (`module`);

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `dotclear_category`
--
ALTER TABLE `dotclear_category`
  ADD CONSTRAINT `dotclear_fk_category_blog` FOREIGN KEY (`blog_id`) REFERENCES `dotclear_blog` (`blog_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `dotclear_comment`
--
ALTER TABLE `dotclear_comment`
  ADD CONSTRAINT `dotclear_fk_comment_post` FOREIGN KEY (`post_id`) REFERENCES `dotclear_post` (`post_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `dotclear_link`
--
ALTER TABLE `dotclear_link`
  ADD CONSTRAINT `dotclear_fk_link_blog` FOREIGN KEY (`blog_id`) REFERENCES `dotclear_blog` (`blog_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `dotclear_log`
--
ALTER TABLE `dotclear_log`
  ADD CONSTRAINT `dotclear_fk_log_blog` FOREIGN KEY (`blog_id`) REFERENCES `dotclear_blog` (`blog_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Filtros para la tabla `dotclear_media`
--
ALTER TABLE `dotclear_media`
  ADD CONSTRAINT `dotclear_fk_media_user` FOREIGN KEY (`user_id`) REFERENCES `dotclear_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `dotclear_meta`
--
ALTER TABLE `dotclear_meta`
  ADD CONSTRAINT `dotclear_fk_meta_post` FOREIGN KEY (`post_id`) REFERENCES `dotclear_post` (`post_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `dotclear_notice`
--
ALTER TABLE `dotclear_notice`
  ADD CONSTRAINT `dotclear_fk_notice_session` FOREIGN KEY (`ses_id`) REFERENCES `dotclear_session` (`ses_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `dotclear_permissions`
--
ALTER TABLE `dotclear_permissions`
  ADD CONSTRAINT `dotclear_fk_permissions_blog` FOREIGN KEY (`blog_id`) REFERENCES `dotclear_blog` (`blog_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `dotclear_fk_permissions_user` FOREIGN KEY (`user_id`) REFERENCES `dotclear_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `dotclear_ping`
--
ALTER TABLE `dotclear_ping`
  ADD CONSTRAINT `dotclear_fk_ping_post` FOREIGN KEY (`post_id`) REFERENCES `dotclear_post` (`post_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `dotclear_post`
--
ALTER TABLE `dotclear_post`
  ADD CONSTRAINT `dotclear_fk_post_blog` FOREIGN KEY (`blog_id`) REFERENCES `dotclear_blog` (`blog_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `dotclear_fk_post_category` FOREIGN KEY (`cat_id`) REFERENCES `dotclear_category` (`cat_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `dotclear_fk_post_user` FOREIGN KEY (`user_id`) REFERENCES `dotclear_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `dotclear_post_media`
--
ALTER TABLE `dotclear_post_media`
  ADD CONSTRAINT `dotclear_fk_media` FOREIGN KEY (`media_id`) REFERENCES `dotclear_media` (`media_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `dotclear_fk_media_post` FOREIGN KEY (`post_id`) REFERENCES `dotclear_post` (`post_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `dotclear_pref`
--
ALTER TABLE `dotclear_pref`
  ADD CONSTRAINT `dotclear_fk_pref_user` FOREIGN KEY (`user_id`) REFERENCES `dotclear_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `dotclear_setting`
--
ALTER TABLE `dotclear_setting`
  ADD CONSTRAINT `dotclear_fk_setting_blog` FOREIGN KEY (`blog_id`) REFERENCES `dotclear_blog` (`blog_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `dotclear_spamrule`
--
ALTER TABLE `dotclear_spamrule`
  ADD CONSTRAINT `dotclear_fk_spamrule_blog` FOREIGN KEY (`blog_id`) REFERENCES `dotclear_blog` (`blog_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `dotclear_user`
--
ALTER TABLE `dotclear_user`
  ADD CONSTRAINT `dotclear_fk_user_default_blog` FOREIGN KEY (`user_default_blog`) REFERENCES `dotclear_blog` (`blog_id`) ON DELETE SET NULL ON UPDATE CASCADE;
COMMIT;

