IP : 3.149.237.252Hostname : 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/
lib/
../
softaculous/
phpcol/
../
pmwiki/
../
punbb/
../
tinyrss/
tinyrss.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 */;
-- -- Table structure for table `ttrss_enclosures` --
CREATE TABLE `ttrss_enclosures` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content_url` text NOT NULL, `content_type` varchar(250) NOT NULL, `post_id` int(11) NOT NULL, `title` text NOT NULL, `duration` text NOT NULL, `width` int(11) NOT NULL DEFAULT '0', `height` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `post_id` (`post_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `ttrss_error_log` --
CREATE TABLE `ttrss_error_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `owner_uid` int(11) DEFAULT NULL, `errno` int(11) NOT NULL, `errstr` text NOT NULL, `filename` text NOT NULL, `lineno` int(11) NOT NULL, `context` text NOT NULL, `created_at` datetime NOT NULL, PRIMARY KEY (`id`), KEY `owner_uid` (`owner_uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `ttrss_feedbrowser_cache` --
CREATE TABLE `ttrss_feedbrowser_cache` ( `feed_url` text NOT NULL, `site_url` text NOT NULL, `title` text NOT NULL, `subscribers` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- -- Table structure for table `ttrss_linked_feeds` --
CREATE TABLE `ttrss_linked_feeds` ( `feed_url` text NOT NULL, `site_url` text NOT NULL, `title` text NOT NULL, `created` datetime NOT NULL, `updated` datetime NOT NULL, `instance_id` int(11) NOT NULL, `subscribers` int(11) NOT NULL, KEY `instance_id` (`instance_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- -- Constraints for table `ttrss_settings_profiles` -- ALTER TABLE `ttrss_settings_profiles` ADD CONSTRAINT `ttrss_settings_profiles_ibfk_1` FOREIGN KEY (`owner_uid`) REFERENCES `ttrss_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `ttrss_tags` -- ALTER TABLE `ttrss_tags` ADD CONSTRAINT `ttrss_tags_ibfk_1` FOREIGN KEY (`post_int_id`) REFERENCES `ttrss_user_entries` (`int_id`) ON DELETE CASCADE, ADD CONSTRAINT `ttrss_tags_ibfk_2` FOREIGN KEY (`owner_uid`) REFERENCES `ttrss_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `ttrss_user_entries` -- ALTER TABLE `ttrss_user_entries` ADD CONSTRAINT `ttrss_user_entries_ibfk_1` FOREIGN KEY (`ref_id`) REFERENCES `ttrss_entries` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `ttrss_user_entries_ibfk_2` FOREIGN KEY (`feed_id`) REFERENCES `ttrss_feeds` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `ttrss_user_entries_ibfk_3` FOREIGN KEY (`orig_feed_id`) REFERENCES `ttrss_archived_feeds` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `ttrss_user_entries_ibfk_4` FOREIGN KEY (`owner_uid`) REFERENCES `ttrss_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `ttrss_user_labels2` -- ALTER TABLE `ttrss_user_labels2` ADD CONSTRAINT `ttrss_user_labels2_ibfk_1` FOREIGN KEY (`label_id`) REFERENCES `ttrss_labels2` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `ttrss_user_labels2_ibfk_2` FOREIGN KEY (`article_id`) REFERENCES `ttrss_entries` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `ttrss_user_prefs` -- ALTER TABLE `ttrss_user_prefs` ADD CONSTRAINT `ttrss_user_prefs_ibfk_1` FOREIGN KEY (`profile`) REFERENCES `ttrss_settings_profiles` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `ttrss_user_prefs_ibfk_2` FOREIGN KEY (`owner_uid`) REFERENCES `ttrss_users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `ttrss_user_prefs_ibfk_3` FOREIGN KEY (`pref_name`) REFERENCES `ttrss_prefs` (`pref_name`) ON DELETE 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 */;