TrxShell [ www.teamrobin.teacherslex.site ]

Name	Size	Permission
images	[ DIR ]	drwxr-xr-x
php53	[ DIR ]	drwxr-xr-x
php56	[ DIR ]	drwxr-xr-x
php71	[ DIR ]	drwxr-xr-x
php81	[ DIR ]	drwxr-xr-x
php82	[ DIR ]	drwxr-xr-x
.htaccess	4.69 KB	-rwxr-xr-x
clone.php	4.04 KB	-rwxr-xr-x
config.ini	959 B	-rwxr-xr-x
edit.php	3.49 KB	-rwxr-xr-x
edit.xml	433 B	-rwxr-xr-x
fileindex.php	116 B	-rwxr-xr-x
import.php	3.56 KB	-rwxr-xr-x
info.xml	2.17 KB	-rwxr-xr-x
install.js	924 B	-rwxr-xr-x
install.php	4.48 KB	-rwxr-xr-x
install.xml	775 B	-rwxr-xr-x
md5	7.52 KB	-rwxr-xr-x
notes.txt	761 B	-rwxr-xr-x
selfoss.sql	3.1 KB	-rwxr-xr-x
selfoss.zip	5.47 MB	-rwxr-xr-x
upgrade.php	11.78 KB	-rwxr-xr-x
upgrade.xml	511 B	-rwxr-xr-x

Code Editor : selfoss.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 */;

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

${this.title}

Code Editor : selfoss.sql