-- phpMyAdmin SQL Dump -- version 4.2.12 -- http://www.phpmyadmin.net -- -- Host: rdbms -- Generation Time: Nov 29, 2015 at 05:51 PM -- Server version: 5.5.46-log -- PHP Version: 5.5.29 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: `DB930654` -- -- -------------------------------------------------------- -- -- Table structure for table `jos_assets` -- CREATE TABLE IF NOT EXISTS `jos_assets` ( `id` int(10) unsigned NOT NULL COMMENT 'Primary Key', `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set parent.', `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.', `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.', `level` int(10) unsigned NOT NULL COMMENT 'The cached level in the nested tree.', `name` varchar(50) NOT NULL COMMENT 'The unique name for the asset.\n', `title` varchar(100) NOT NULL COMMENT 'The descriptive title for the asset.', `rules` varchar(5120) NOT NULL COMMENT 'JSON encoded access control.' ) ENGINE=MyISAM AUTO_INCREMENT=891 DEFAULT CHARSET=utf8; -- -- Dumping data for table `jos_assets` -- INSERT INTO `jos_assets` (`id`, `parent_id`, `lft`, `rgt`, `level`, `name`, `title`, `rules`) VALUES (193, 171, 178, 179, 3, 'com_content.article.79', 'Wichtige Info für alle Freunde von WHK e.V.', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'), (396, 255, 1438, 1439, 3, 'com_content.article.264', 'Der Anton "Toni" Polster spendiert uns was!', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'), (889, 171, 1290, 1291, 3, 'com_content.article.757', 'Handball der Spitzenklasse bei WhK', '{"core.delete":[],"core.edit":{"1":1},"core.edit.state":{"1":1}}'); -- -- Indexes for dumped tables -- -- -- Indexes for table `jos_assets` -- ALTER TABLE `jos_assets` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `idx_asset_name` (`name`), ADD KEY `idx_lft_rgt` (`lft`,`rgt`), ADD KEY `idx_parent_id` (`parent_id`), ADD KEY `rgt` (`rgt`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `jos_assets` -- ALTER TABLE `jos_assets` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',AUTO_INCREMENT=891; /*!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 */;