IP : 3.145.39.183Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
softaculous/
bagisto/
../
./
dropzone/
./
../
mautic/
../
dotcl/
dotcl.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!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 */;
-- -- Dumping data for table `[[dbprefix]]comment` --
INSERT INTO `[[dbprefix]]comment` VALUES (1, 1, '[[regtime]]', 'Europe/London', '[[regtime]]', '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', '[[clientip]]', 1, '0', NULL, 0);
-- -- Table structure for table `[[dbprefix]]post` --
CREATE TABLE `[[dbprefix]]post` ( `post_id` bigint(20) NOT NULL, `blog_id` varchar(32) COLLATE utf8_bin NOT NULL, `user_id` varchar(32) COLLATE utf8_bin NOT NULL, `cat_id` bigint(20) DEFAULT NULL, `post_dt` datetime NOT NULL DEFAULT '1970-01-01 00:00:00', `post_tz` varchar(128) COLLATE utf8_bin 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) COLLATE utf8_bin DEFAULT NULL, `post_type` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT 'post', `post_format` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT 'xhtml', `post_url` varchar(255) COLLATE utf8_bin NOT NULL, `post_lang` varchar(5) COLLATE utf8_bin DEFAULT NULL, `post_title` varchar(255) COLLATE utf8_bin DEFAULT NULL, `post_excerpt` longtext COLLATE utf8_bin, `post_excerpt_xhtml` longtext COLLATE utf8_bin, `post_content` longtext COLLATE utf8_bin, `post_content_xhtml` longtext COLLATE utf8_bin NOT NULL, `post_notes` longtext COLLATE utf8_bin, `post_meta` longtext COLLATE utf8_bin, `post_words` longtext COLLATE utf8_bin, `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', PRIMARY KEY (`post_id`), UNIQUE KEY `[[dbprefix]]uk_post_url` (`post_url`,`post_type`,`blog_id`), KEY `[[dbprefix]]idx_post_cat_id` USING BTREE (`cat_id`), KEY `[[dbprefix]]idx_post_user_id` USING BTREE (`user_id`), KEY `[[dbprefix]]idx_post_blog_id` USING BTREE (`blog_id`), KEY `[[dbprefix]]idx_post_post_dt` USING BTREE (`post_dt`), KEY `[[dbprefix]]idx_post_post_dt_post_id` USING BTREE (`post_dt`,`post_id`), KEY `[[dbprefix]]idx_blog_post_post_dt_post_id` USING BTREE (`blog_id`,`post_dt`,`post_id`), KEY `[[dbprefix]]idx_blog_post_post_status` USING BTREE (`blog_id`,`post_status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- -- Dumping data for table `[[dbprefix]]post` --
INSERT INTO `[[dbprefix]]post` VALUES (1, 'default', '[[admin_username]]', NULL, '[[regtime]]', 'Europe/London', '[[regtime]]', '[[regtime]]', NULL, 'post', 'xhtml', '[[reg_time]]/Welcome-to-Dotclear!', 'en', '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', '[[admin_username]]', NULL, '[[regtime]]', 'Europe/London', '[[regtime]]', '[[regtime]]', NULL, 'page', 'xhtml', '[[reg_time]]/My-first-page', 'en', '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);
-- -- Constraints for table `[[dbprefix]]category` -- ALTER TABLE `[[dbprefix]]category` ADD CONSTRAINT `[[dbprefix]]fk_category_blog` FOREIGN KEY (`blog_id`) REFERENCES `[[dbprefix]]blog` (`blog_id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]comment` -- ALTER TABLE `[[dbprefix]]comment` ADD CONSTRAINT `[[dbprefix]]fk_comment_post` FOREIGN KEY (`post_id`) REFERENCES `[[dbprefix]]post` (`post_id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]link` -- ALTER TABLE `[[dbprefix]]link` ADD CONSTRAINT `[[dbprefix]]fk_link_blog` FOREIGN KEY (`blog_id`) REFERENCES `[[dbprefix]]blog` (`blog_id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]log` -- ALTER TABLE `[[dbprefix]]log` ADD CONSTRAINT `[[dbprefix]]fk_log_blog` FOREIGN KEY (`blog_id`) REFERENCES `[[dbprefix]]blog` (`blog_id`) ON DELETE SET NULL ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]media` -- ALTER TABLE `[[dbprefix]]media` ADD CONSTRAINT `[[dbprefix]]fk_media_user` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]meta` -- ALTER TABLE `[[dbprefix]]meta` ADD CONSTRAINT `[[dbprefix]]fk_meta_post` FOREIGN KEY (`post_id`) REFERENCES `[[dbprefix]]post` (`post_id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]notice` -- ALTER TABLE `[[dbprefix]]notice` ADD CONSTRAINT `[[dbprefix]]fk_notice_session` FOREIGN KEY (`ses_id`) REFERENCES `[[dbprefix]]session` (`ses_id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]permissions` -- ALTER TABLE `[[dbprefix]]permissions` ADD CONSTRAINT `[[dbprefix]]fk_permissions_user` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `[[dbprefix]]fk_permissions_blog` FOREIGN KEY (`blog_id`) REFERENCES `[[dbprefix]]blog` (`blog_id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]ping` -- ALTER TABLE `[[dbprefix]]ping` ADD CONSTRAINT `[[dbprefix]]fk_ping_post` FOREIGN KEY (`post_id`) REFERENCES `[[dbprefix]]post` (`post_id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]post` -- ALTER TABLE `[[dbprefix]]post` ADD CONSTRAINT `[[dbprefix]]fk_post_blog` FOREIGN KEY (`blog_id`) REFERENCES `[[dbprefix]]blog` (`blog_id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `[[dbprefix]]fk_post_category` FOREIGN KEY (`cat_id`) REFERENCES `[[dbprefix]]category` (`cat_id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `[[dbprefix]]fk_post_user` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]post_media` -- ALTER TABLE `[[dbprefix]]post_media` ADD CONSTRAINT `[[dbprefix]]fk_media_post` FOREIGN KEY (`post_id`) REFERENCES `[[dbprefix]]post` (`post_id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `[[dbprefix]]fk_media` FOREIGN KEY (`media_id`) REFERENCES `[[dbprefix]]media` (`media_id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]pref` -- ALTER TABLE `[[dbprefix]]pref` ADD CONSTRAINT `[[dbprefix]]fk_pref_user` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]setting` -- ALTER TABLE `[[dbprefix]]setting` ADD CONSTRAINT `[[dbprefix]]fk_setting_blog` FOREIGN KEY (`blog_id`) REFERENCES `[[dbprefix]]blog` (`blog_id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]spamrule` -- ALTER TABLE `[[dbprefix]]spamrule` ADD CONSTRAINT `[[dbprefix]]fk_spamrule_blog` FOREIGN KEY (`blog_id`) REFERENCES `[[dbprefix]]blog` (`blog_id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]user` -- ALTER TABLE `[[dbprefix]]user` ADD CONSTRAINT `[[dbprefix]]fk_user_default_blog` FOREIGN KEY (`user_default_blog`) REFERENCES `[[dbprefix]]blog` (`blog_id`) ON DELETE SET NULL ON UPDATE CASCADE;
/*!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 */;