| Server IP : 217.18.85.50 / Your IP : 3.139.86.53 Web Server : LiteSpeed System : Linux server50.tr85.dhs.com.tr 3.10.0-962.3.2.lve1.5.85.el7.x86_64 #1 SMP Thu Apr 18 15:18:36 UTC 2024 x86_64 User : ferhatgenc ( ) PHP Version : 7.2.34 Disable Function : restore_ini,mail,openbasedir,f_open,system,dl,array_compare,array_user_key_compare,passthru,cat,exec,popen,proc_close,proc_get_status,proc_nice,proc_open,escapeshellcmd,escapeshellarg,show_source,posix_mkfifo,ini_restore,mysql_list_dbs,getmyuid,pconnect,link,symlink,fin,passthruexec,fileread,shell_exec,pcntl_exec,ini_alter,leak,apache_child_terminate,chown,posix_kill,posix_setpgid,posix_setsid,posix_setuid,proc_terminate,syslog,allow_url_fopen,fpassthru,execute,shell,chgrp,passthru,socket_select,socket_create,socket_create_listen,socket_create_pair,socket_listen,socket_accept,socket_bind,foreach,socket_strerror,pcntl_fork,pcntl_signal,pcntl_waitpid,pcntl_wexitstatus,pcntl_wifexited,pcntl_wifsignaled,pcntl_wifstopped,pcntl_wstopsig,pcntl_wtermsig,openlog,apache_get_version,apache_getenv,apache_note,apache_setenv,virtualal MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /var/softaculous/selfoss/ |
Upload File : |
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 */;
--
-- Database: `selfoss219`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]items`
--
CREATE TABLE `[[dbprefix]]items` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`datetime` datetime NOT NULL,
`title` text NOT NULL,
`content` longtext NOT NULL,
`thumbnail` text,
`icon` text,
`unread` tinyint(1) NOT NULL,
`starred` tinyint(1) NOT NULL,
`source` int(11) NOT NULL,
`uid` varchar(255) NOT NULL,
`link` text NOT NULL,
`updatetime` datetime NOT NULL,
`author` varchar(255) DEFAULT NULL,
`shared` tinyint(1) DEFAULT NULL,
`lastseen` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `source` (`source`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]sources`
--
CREATE TABLE `[[dbprefix]]sources` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`tags` text,
`spout` text NOT NULL,
`params` text NOT NULL,
`filter` text,
`error` text,
`lastupdate` int(11) DEFAULT NULL,
`lastentry` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]tags`
--
CREATE TABLE `[[dbprefix]]tags` (
`tag` text NOT NULL,
`color` varchar(7) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]version`
--
CREATE TABLE `[[dbprefix]]version` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `[[dbprefix]]version`
--
INSERT INTO `[[dbprefix]]version` VALUES
(8),
(9),
(10),
(11),
(12),
(13),
(14);
--
-- Triggers `[[dbprefix]]items`
--
DROP TRIGGER IF EXISTS `[[dbprefix]]items_insert_trigger`;
DELIMITER //
CREATE TRIGGER `[[dbprefix]]items_insert_trigger` BEFORE INSERT ON `[[dbprefix]]items`
FOR EACH ROW BEGIN
SET NEW.updatetime = NOW();
SET NEW.lastseen = NOW();
END
//
DELIMITER ;
DROP TRIGGER IF EXISTS `[[dbprefix]]items_update_trigger`;
DELIMITER //
CREATE TRIGGER `[[dbprefix]]items_update_trigger` BEFORE UPDATE ON `[[dbprefix]]items`
FOR EACH ROW BEGIN
IF (
OLD.unread <> NEW.unread OR
OLD.starred <> NEW.starred
) THEN
SET NEW.updatetime = NOW();
END IF;
END
//
DELIMITER ;
/*!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 */;