FM / redax

/var/softaculous/redax

Name	Size	Mode	Actions
images/	-	0755	rm
php53/	-	0755	rm
php56/	-	0755	rm
php71/	-	0755	rm
php81/	-	0755	rm
php82/	-	0755	rm
clone.php	3208	0644	edit dl rm
config.php	223	0644	edit dl rm
edit.php	5555	0644	edit dl rm
edit.xml	433	0644	edit dl rm
fileindex.php	144	0644	edit dl rm
import.php	4432	0644	edit dl rm
info.xml	2659	0644	edit dl rm
install.js	924	0644	edit dl rm
install.php	5040	0644	edit dl rm
install.xml	1457	0644	edit dl rm
md5	3838	0644	edit dl rm
notes.txt	813	0644	edit dl rm
redax.sql	13921	0644	edit dl rm
redax.zip	406660	0644	edit dl rm
update_pass.php	290	0644	edit dl rm
_upgrade.php	4790	0644	edit dl rm
_upgrade.xml	315	0644	edit dl rm

Edit: /var/softaculous/redax/redax.sql (13921B)

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: `redax500`
--

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

--
-- Table structure for table `[[dbprefix]]articles`
--

CREATE TABLE `[[dbprefix]]articles` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `robots` int(1) DEFAULT NULL,
  `text` longtext COLLATE utf8_unicode_ci,
  `language` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `template` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sibling` int(10) DEFAULT NULL,
  `category` int(10) DEFAULT NULL,
  `headline` int(1) DEFAULT '1',
  `byline` int(1) DEFAULT '1',
  `comments` int(1) DEFAULT '0',
  `status` int(1) DEFAULT '1',
  `rank` int(10) DEFAULT NULL,
  `access` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` int(15) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]articles`
--

INSERT INTO `[[dbprefix]]articles` VALUES
(1, 'Welcome', 'welcome', '[[admin_username]]', NULL, NULL, NULL, '<blockquote class="rs-quote-default">Congratulations! Redaxscript has been successfully installed.</blockquote>\n\n<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>\n\n<svg viewbox="0 0 1200 400" class="rs-image-default">\n	<rect height="400" width="1200" />\n</svg>\n\n<p>At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore.</p>\n\n<rs-more>\n\n\n<h3 class="rs-title-content-sub">Duo dolores</h3>\n\n<ul>\n	<li>Lorem ipsum dolor sit ame</li>\n	<li>At vero eos et accusam</li>\n	<li>Consetetur sadipscing elitr</li>\n	<li>Dolores et ea rebum</li>\n</ul>\n', NULL, NULL, NULL, 1, 1, 1, 1, 1, 1, NULL, [[timestamp]]);

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

--
-- Table structure for table `[[dbprefix]]categories`
--

CREATE TABLE `[[dbprefix]]categories` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `robots` int(1) DEFAULT NULL,
  `language` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `template` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sibling` int(10) DEFAULT NULL,
  `parent` int(10) DEFAULT NULL,
  `status` int(1) DEFAULT '1',
  `rank` int(10) DEFAULT NULL,
  `access` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` int(15) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]categories`
--

INSERT INTO `[[dbprefix]]categories` VALUES
(1, 'Home', 'home', '[[admin_username]]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, [[timestamp]]);

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

--
-- Table structure for table `[[dbprefix]]comments`
--

CREATE TABLE `[[dbprefix]]comments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `text` longtext COLLATE utf8_unicode_ci,
  `language` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `article` int(10) DEFAULT NULL,
  `status` int(1) DEFAULT '1',
  `rank` int(10) DEFAULT NULL,
  `access` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` int(15) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]comments`
--

INSERT INTO `[[dbprefix]]comments` VALUES
(1, '[[admin_username]]', '[[admin_email]]', NULL, 'At vero eos et accusam et justo duo.', NULL, 1, 1, 1, NULL, [[timestamp]]);

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

--
-- Table structure for table `[[dbprefix]]extras`
--

CREATE TABLE `[[dbprefix]]extras` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `text` longtext COLLATE utf8_unicode_ci,
  `language` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sibling` int(10) DEFAULT NULL,
  `category` int(10) DEFAULT NULL,
  `article` int(10) DEFAULT NULL,
  `headline` int(1) DEFAULT '1',
  `status` int(1) DEFAULT '1',
  `rank` int(10) DEFAULT NULL,
  `access` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` int(15) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

--
-- Dumping data for table `[[dbprefix]]extras`
--

INSERT INTO `[[dbprefix]]extras` VALUES
(1, 'Categories', 'categories', '[[admin_username]]', '<rs-template>\n{\n	"navigation":\n	{\n		"type": "categories",\n		"optionArray":\n		{\n			"className":\n			{\n				"list": "rs-list-sidebar",\n				"children": "rs-list-children",\n				"active": "rs-item-active"\n			},\n			"limit": 5\n		}\n	}\n}\n</rs-template>\n', NULL, NULL, NULL, NULL, 1, 1, 1, NULL, [[timestamp]]),
(2, 'Articles', 'articles', '[[admin_username]]', '<rs-template>\n{\n	"navigation":\n	{\n		"type": "articles",\n		"optionArray":\n		{\n			"className":\n			{\n				"list": "rs-list-sidebar",\n				"active": "rs-item-active"\n			},\n			"limit": 5\n		}\n	}\n}\n</rs-template>\n', NULL, NULL, NULL, NULL, 1, 1, 2, NULL, [[timestamp]]),
(3, 'Comments', 'comments', '[[admin_username]]', '<rs-template>\n{\n	"navigation":\n	{\n		"type": "comments",\n		"optionArray":\n		{\n			"className":\n			{\n				"list": "rs-list-sidebar",\n				"active": "rs-item-active"\n			},\n			"limit": 5\n		}\n	}\n}\n</rs-template>\n', NULL, NULL, NULL, NULL, 1, 1, 3, NULL, [[timestamp]]),
(4, 'Languages', 'languages', '[[admin_username]]', '<rs-template>\n{\n	"navigation":\n	{\n		"type": "languages",\n		"optionArray":\n		{\n			"className":\n			{\n				"list": "rs-list-sidebar",\n				"active": "rs-item-active"\n			}\n		}\n	}\n}\n</rs-template>\n', NULL, NULL, NULL, NULL, 1, 0, 4, NULL, [[timestamp]]),
(5, 'Templates', 'templates', '[[admin_username]]', '<rs-template>\n{\n	"navigation":\n	{\n		"type": "templates",\n		"optionArray":\n		{\n			"className":\n			{\n				"list": "rs-list-sidebar",\n				"active": "rs-item-active"\n			}\n		}\n	}\n}\n</rs-template>\n', NULL, NULL, NULL, NULL, 1, 0, 5, NULL, [[timestamp]]),
(6, 'Teaser', 'teaser', '[[admin_username]]', '<div id="teaser" class="rs-component-teaser">\n	<section class="rs-wrapper">\n		<h3 class="rs-title-teaser">\n			Create a beautiful <strong>website</strong> <span class="rs-is-break">today</span> to share your <strong>thoughts</strong> and <strong>feelings</strong>\n		</h3>\n	</section>\n</div>', NULL, NULL, 1, NULL, 0, 0, 6, NULL, [[timestamp]]);

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

--
-- Table structure for table `[[dbprefix]]groups`
--

CREATE TABLE `[[dbprefix]]groups` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `categories` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `articles` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `extras` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comments` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `groups` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `users` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `modules` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `settings` int(1) DEFAULT NULL,
  `filter` int(1) DEFAULT '1',
  `status` int(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `[[dbprefix]]groups`
--

INSERT INTO `[[dbprefix]]groups` VALUES
(1, 'Administrators', 'administrators', 'Unlimited access', '[1, 2, 3]', '[1, 2, 3]', '[1, 2, 3]', '[1, 2, 3]', '[1, 2, 3]', '[1, 2, 3]', '[1, 2, 3]', 1, 0, 1),
(2, 'Members', 'members', 'Default members group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1);

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

--
-- Table structure for table `[[dbprefix]]modules`
--

CREATE TABLE `[[dbprefix]]modules` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `version` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `license` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT '1',
  `access` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;

--
-- Dumping data for table `[[dbprefix]]modules`
--

INSERT INTO `[[dbprefix]]modules` VALUES
(1, 'Alias Generator', 'AliasGenerator', 'Redaxmedia', 'Generate user friendly URL fragments', '5.0.0', 'MIT', 1, NULL),
(2, 'Call Home', 'CallHome', 'Redaxmedia', 'Get version updates and latest news', '5.0.0', 'MIT', 1, NULL),
(3, 'Dialog', 'Dialog', 'Redaxmedia', 'Shared module to replace alert, confirm and prompt', '5.0.0', 'MIT', 1, NULL),
(4, 'Confirm Action', 'ConfirmAction', 'Redaxmedia', 'Implement a confirmation for critical action', '5.0.0', 'MIT', 1, NULL),
(5, 'Form Validator', 'FormValidator', 'Redaxmedia', 'Validate using the constraint validation API', '5.0.0', 'MIT', 1, NULL),
(6, 'Rank Sorter', 'RankSorter', 'Redaxmedia', 'Adjust the rank with draggable table rows', '5.0.0', 'MIT', 1, NULL),
(7, 'Textarea Resizer', 'TextareaResizer', 'Redaxmedia', 'Resize textarea height to content', '5.0.0', 'MIT', 1, NULL),
(8, 'Unmask Password', 'UnmaskPassword', 'Redaxmedia', 'Unmask focused password fields', '5.0.0', 'MIT', 1, NULL);

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

--
-- Table structure for table `[[dbprefix]]settings`
--

CREATE TABLE `[[dbprefix]]settings` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=29 ;

--
-- Dumping data for table `[[dbprefix]]settings`
--

INSERT INTO `[[dbprefix]]settings` VALUES
(1, 'language', NULL),
(2, 'template', NULL),
(3, 'title', '[[site_name]]'),
(4, 'author', '[[admin_realname]]'),
(5, 'copyright', NULL),
(6, 'description', '[[site_desc]]'),
(7, 'keywords', NULL),
(8, 'robots', '1'),
(9, 'email', '[[admin_email]]'),
(10, 'smtp', NULL),
(11, 'subject', 'Redaxscript'),
(12, 'notification', '0'),
(13, 'charset', 'UTF-8'),
(14, 'locale', 'en_US'),
(15, 'divider', ' - '),
(16, 'zone', 'America/New_York'),
(17, 'time', 'H:i'),
(18, 'date', 'd.m.Y'),
(19, 'homepage', '0'),
(20, 'limit', '10'),
(21, 'order', 'asc'),
(22, 'pagination', '1'),
(23, 'registration', '0'),
(24, 'verification', '0'),
(25, 'recovery', '1'),
(26, 'moderation', '0'),
(27, 'captcha', '0'),
(28, 'version', '5.0.0');

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

--
-- Table structure for table `[[dbprefix]]users`
--

CREATE TABLE `[[dbprefix]]users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT '1',
  `groups` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `first` int(15) DEFAULT NULL,
  `last` int(15) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]users`
--

INSERT INTO `[[dbprefix]]users` VALUES
(1, '[[admin_realname]]', '[[admin_username]]', 'God admin', '[[admin_pass]]', '[[admin_email]]', NULL, 1, '[1]', NULL, NULL);

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

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: `redax500` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]articles` -- CREATE TABLE `[[dbprefix]]articles` ( `id` int(10) NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `robots` int(1) DEFAULT NULL, `text` longtext COLLATE utf8_unicode_ci, `language` char(2) COLLATE utf8_unicode_ci DEFAULT NULL, `template` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `sibling` int(10) DEFAULT NULL, `category` int(10) DEFAULT NULL, `headline` int(1) DEFAULT '1', `byline` int(1) DEFAULT '1', `comments` int(1) DEFAULT '0', `status` int(1) DEFAULT '1', `rank` int(10) DEFAULT NULL, `access` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `date` int(15) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]articles` -- INSERT INTO `[[dbprefix]]articles` VALUES (1, 'Welcome', 'welcome', '[[admin_username]]', NULL, NULL, NULL, '

Congratulations! Redaxscript has been successfully installed.

\n\n

Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.

\n\n\n\n

At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore.

\n\n\n\n\n

Duo dolores

\n\n

Lorem ipsum dolor sit ame
At vero eos et accusam
Consetetur sadipscing elitr
Dolores et ea rebum

\n', NULL, NULL, NULL, 1, 1, 1, 1, 1, 1, NULL, [[timestamp]]); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]categories` -- CREATE TABLE `[[dbprefix]]categories` ( `id` int(10) NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `robots` int(1) DEFAULT NULL, `language` char(2) COLLATE utf8_unicode_ci DEFAULT NULL, `template` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `sibling` int(10) DEFAULT NULL, `parent` int(10) DEFAULT NULL, `status` int(1) DEFAULT '1', `rank` int(10) DEFAULT NULL, `access` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `date` int(15) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]categories` -- INSERT INTO `[[dbprefix]]categories` VALUES (1, 'Home', 'home', '[[admin_username]]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, [[timestamp]]); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]comments` -- CREATE TABLE `[[dbprefix]]comments` ( `id` int(10) NOT NULL AUTO_INCREMENT, `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `text` longtext COLLATE utf8_unicode_ci, `language` char(2) COLLATE utf8_unicode_ci DEFAULT NULL, `article` int(10) DEFAULT NULL, `status` int(1) DEFAULT '1', `rank` int(10) DEFAULT NULL, `access` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `date` int(15) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]comments` -- INSERT INTO `[[dbprefix]]comments` VALUES (1, '[[admin_username]]', '[[admin_email]]', NULL, 'At vero eos et accusam et justo duo.', NULL, 1, 1, 1, NULL, [[timestamp]]); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]extras` -- CREATE TABLE `[[dbprefix]]extras` ( `id` int(10) NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `text` longtext COLLATE utf8_unicode_ci, `language` char(2) COLLATE utf8_unicode_ci DEFAULT NULL, `sibling` int(10) DEFAULT NULL, `category` int(10) DEFAULT NULL, `article` int(10) DEFAULT NULL, `headline` int(1) DEFAULT '1', `status` int(1) DEFAULT '1', `rank` int(10) DEFAULT NULL, `access` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `date` int(15) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ; -- -- Dumping data for table `[[dbprefix]]extras` -- INSERT INTO `[[dbprefix]]extras` VALUES (1, 'Categories', 'categories', '[[admin_username]]', '\n{\n "navigation":\n {\n "type": "categories",\n "optionArray":\n {\n "className":\n {\n "list": "rs-list-sidebar",\n "children": "rs-list-children",\n "active": "rs-item-active"\n },\n "limit": 5\n }\n }\n}\n\n', NULL, NULL, NULL, NULL, 1, 1, 1, NULL, [[timestamp]]), (2, 'Articles', 'articles', '[[admin_username]]', '\n{\n "navigation":\n {\n "type": "articles",\n "optionArray":\n {\n "className":\n {\n "list": "rs-list-sidebar",\n "active": "rs-item-active"\n },\n "limit": 5\n }\n }\n}\n\n', NULL, NULL, NULL, NULL, 1, 1, 2, NULL, [[timestamp]]), (3, 'Comments', 'comments', '[[admin_username]]', '\n{\n "navigation":\n {\n "type": "comments",\n "optionArray":\n {\n "className":\n {\n "list": "rs-list-sidebar",\n "active": "rs-item-active"\n },\n "limit": 5\n }\n }\n}\n\n', NULL, NULL, NULL, NULL, 1, 1, 3, NULL, [[timestamp]]), (4, 'Languages', 'languages', '[[admin_username]]', '\n{\n "navigation":\n {\n "type": "languages",\n "optionArray":\n {\n "className":\n {\n "list": "rs-list-sidebar",\n "active": "rs-item-active"\n }\n }\n }\n}\n\n', NULL, NULL, NULL, NULL, 1, 0, 4, NULL, [[timestamp]]), (5, 'Templates', 'templates', '[[admin_username]]', '\n{\n "navigation":\n {\n "type": "templates",\n "optionArray":\n {\n "className":\n {\n "list": "rs-list-sidebar",\n "active": "rs-item-active"\n }\n }\n }\n}\n\n', NULL, NULL, NULL, NULL, 1, 0, 5, NULL, [[timestamp]]), (6, 'Teaser', 'teaser', '[[admin_username]]', '

\n Create a beautiful website today to share your thoughts and feelings\n

', NULL, NULL, 1, NULL, 0, 0, 6, NULL, [[timestamp]]); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]groups` -- CREATE TABLE `[[dbprefix]]groups` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `categories` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `articles` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `extras` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `comments` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `groups` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `users` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `modules` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `settings` int(1) DEFAULT NULL, `filter` int(1) DEFAULT '1', `status` int(1) DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ; -- -- Dumping data for table `[[dbprefix]]groups` -- INSERT INTO `[[dbprefix]]groups` VALUES (1, 'Administrators', 'administrators', 'Unlimited access', '[1, 2, 3]', '[1, 2, 3]', '[1, 2, 3]', '[1, 2, 3]', '[1, 2, 3]', '[1, 2, 3]', '[1, 2, 3]', 1, 0, 1), (2, 'Members', 'members', 'Default members group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]modules` -- CREATE TABLE `[[dbprefix]]modules` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `version` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `license` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `status` int(1) DEFAULT '1', `access` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ; -- -- Dumping data for table `[[dbprefix]]modules` -- INSERT INTO `[[dbprefix]]modules` VALUES (1, 'Alias Generator', 'AliasGenerator', 'Redaxmedia', 'Generate user friendly URL fragments', '5.0.0', 'MIT', 1, NULL), (2, 'Call Home', 'CallHome', 'Redaxmedia', 'Get version updates and latest news', '5.0.0', 'MIT', 1, NULL), (3, 'Dialog', 'Dialog', 'Redaxmedia', 'Shared module to replace alert, confirm and prompt', '5.0.0', 'MIT', 1, NULL), (4, 'Confirm Action', 'ConfirmAction', 'Redaxmedia', 'Implement a confirmation for critical action', '5.0.0', 'MIT', 1, NULL), (5, 'Form Validator', 'FormValidator', 'Redaxmedia', 'Validate using the constraint validation API', '5.0.0', 'MIT', 1, NULL), (6, 'Rank Sorter', 'RankSorter', 'Redaxmedia', 'Adjust the rank with draggable table rows', '5.0.0', 'MIT', 1, NULL), (7, 'Textarea Resizer', 'TextareaResizer', 'Redaxmedia', 'Resize textarea height to content', '5.0.0', 'MIT', 1, NULL), (8, 'Unmask Password', 'UnmaskPassword', 'Redaxmedia', 'Unmask focused password fields', '5.0.0', 'MIT', 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]settings` -- CREATE TABLE `[[dbprefix]]settings` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=29 ; -- -- Dumping data for table `[[dbprefix]]settings` -- INSERT INTO `[[dbprefix]]settings` VALUES (1, 'language', NULL), (2, 'template', NULL), (3, 'title', '[[site_name]]'), (4, 'author', '[[admin_realname]]'), (5, 'copyright', NULL), (6, 'description', '[[site_desc]]'), (7, 'keywords', NULL), (8, 'robots', '1'), (9, 'email', '[[admin_email]]'), (10, 'smtp', NULL), (11, 'subject', 'Redaxscript'), (12, 'notification', '0'), (13, 'charset', 'UTF-8'), (14, 'locale', 'en_US'), (15, 'divider', ' - '), (16, 'zone', 'America/New_York'), (17, 'time', 'H:i'), (18, 'date', 'd.m.Y'), (19, 'homepage', '0'), (20, 'limit', '10'), (21, 'order', 'asc'), (22, 'pagination', '1'), (23, 'registration', '0'), (24, 'verification', '0'), (25, 'recovery', '1'), (26, 'moderation', '0'), (27, 'captcha', '0'), (28, 'version', '5.0.0'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]users` -- CREATE TABLE `[[dbprefix]]users` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `user` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `language` char(2) COLLATE utf8_unicode_ci DEFAULT NULL, `status` int(1) DEFAULT '1', `groups` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `first` int(15) DEFAULT NULL, `last` int(15) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]users` -- INSERT INTO `[[dbprefix]]users` VALUES (1, '[[admin_realname]]', '[[admin_username]]', 'God admin', '[[admin_pass]]', '[[admin_email]]', NULL, 1, '[1]', NULL, NULL); /*!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 */;