File Manager

Editing File: /var/softaculous/redax/redax.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: `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 */;

Back to Directory File Manager