-- MySQL dump 10.13 Distrib 5.6.25, for Win32 (x86) -- -- Host: localhost Database: serendipity_mamblog -- ------------------------------------------------------ -- Server version 5.6.36 /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `mamblog_access` -- DROP TABLE IF EXISTS `mamblog_access`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_access` ( `groupid` int(10) unsigned NOT NULL DEFAULT '0', `artifact_id` int(10) unsigned NOT NULL DEFAULT '0', `artifact_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `artifact_mode` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `artifact_index` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', KEY `accessgroup_idx` (`groupid`), KEY `accessgroupT_idx` (`artifact_id`,`artifact_type`,`artifact_mode`), KEY `accessforeign_idx` (`artifact_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_access` -- LOCK TABLES `mamblog_access` WRITE; /*!40000 ALTER TABLE `mamblog_access` DISABLE KEYS */; /*!40000 ALTER TABLE `mamblog_access` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_authorgroups` -- DROP TABLE IF EXISTS `mamblog_authorgroups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_authorgroups` ( `groupid` int(10) unsigned NOT NULL DEFAULT '0', `authorid` int(10) unsigned NOT NULL DEFAULT '0', KEY `authorgroup_idxA` (`groupid`), KEY `authorgroup_idxB` (`authorid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_authorgroups` -- LOCK TABLES `mamblog_authorgroups` WRITE; /*!40000 ALTER TABLE `mamblog_authorgroups` DISABLE KEYS */; INSERT INTO `mamblog_authorgroups` VALUES (3,1); /*!40000 ALTER TABLE `mamblog_authorgroups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_authors` -- DROP TABLE IF EXISTS `mamblog_authors`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_authors` ( `realname` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `username` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `password` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `authorid` int(11) NOT NULL AUTO_INCREMENT, `mail_comments` int(1) DEFAULT '1', `mail_trackbacks` int(1) DEFAULT '1', `email` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `userlevel` int(4) unsigned NOT NULL DEFAULT '0', `right_publish` int(1) DEFAULT '1', PRIMARY KEY (`authorid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_authors` -- LOCK TABLES `mamblog_authors` WRITE; /*!40000 ALTER TABLE `mamblog_authors` DISABLE KEYS */; INSERT INTO `mamblog_authors` VALUES ('Markus A. Mascelli','admin','5a9361b28ee51795f1e82d9054919034',1,1,1,'mam@heimam.at',255,1); /*!40000 ALTER TABLE `mamblog_authors` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_category` -- DROP TABLE IF EXISTS `mamblog_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_category` ( `categoryid` int(11) NOT NULL AUTO_INCREMENT, `category_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `category_icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `category_description` text COLLATE utf8_unicode_ci, `authorid` int(11) DEFAULT NULL, `category_left` int(11) DEFAULT '0', `category_right` int(11) DEFAULT '0', `parentid` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`categoryid`), KEY `categorya_idx` (`authorid`), KEY `categoryp_idx` (`parentid`), KEY `categorylr_idx` (`category_left`,`category_right`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_category` -- LOCK TABLES `mamblog_category` WRITE; /*!40000 ALTER TABLE `mamblog_category` DISABLE KEYS */; /*!40000 ALTER TABLE `mamblog_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_comments` -- DROP TABLE IF EXISTS `mamblog_comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `entry_id` int(10) unsigned NOT NULL DEFAULT '0', `parent_id` int(10) unsigned NOT NULL DEFAULT '0', `timestamp` int(10) unsigned DEFAULT NULL, `title` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL, `author` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL, `email` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `url` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `ip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `body` text COLLATE utf8_unicode_ci, `type` varchar(100) COLLATE utf8_unicode_ci DEFAULT 'regular', `subscribed` enum('true','false') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'true', `status` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `referer` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `commentry_idx` (`entry_id`), KEY `commpentry_idx` (`parent_id`), KEY `commtype_idx` (`type`), KEY `commstat_idx` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_comments` -- LOCK TABLES `mamblog_comments` WRITE; /*!40000 ALTER TABLE `mamblog_comments` DISABLE KEYS */; /*!40000 ALTER TABLE `mamblog_comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_config` -- DROP TABLE IF EXISTS `mamblog_config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_config` ( `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `value` text COLLATE utf8_unicode_ci NOT NULL, `authorid` int(11) DEFAULT '0', KEY `configauthorid_idx` (`authorid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_config` -- LOCK TABLES `mamblog_config` WRITE; /*!40000 ALTER TABLE `mamblog_config` DISABLE KEYS */; INSERT INTO `mamblog_config` VALUES ('template','default',0),('serendipityPath','C:/Program Files (x86)/Apache Software Foundation/Apache2.2/htdocs/mamBLOG/',0),('uploadPath','uploads/',0),('serendipityHTTPPath','/',0),('templatePath','templates/',0),('uploadHTTPPath','uploads/',0),('baseURL','http://mamblog.mamweb.at/',0),('autodetect_baseURL','false',0),('indexFile','index.php',0),('permalinkStructure','archives/%id%-%title%.html',0),('permalinkAuthorStructure','authors/%id%-%realname%',0),('permalinkCategoryStructure','categories/%id%-%name%',0),('permalinkFeedCategoryStructure','feeds/categories/%id%-%name%.rss',0),('permalinkFeedAuthorStructure','feeds/authors/%id%-%realname%.rss',0),('permalinkArchivesPath','archives',0),('permalinkArchivePath','archive',0),('permalinkCategoriesPath','categories',0),('permalinkAuthorsPath','authors',0),('permalinkUnsubscribePath','unsubscribe',0),('permalinkDeletePath','delete',0),('permalinkApprovePath','approve',0),('permalinkFeedsPath','feeds',0),('permalinkPluginPath','plugin',0),('permalinkAdminPath','admin',0),('permalinkSearchPath','search',0),('allowSubscriptions','true',0),('blogTitle','mamBLOG',0),('blogDescription','blog as blog can',0),('blogMail','',0),('lang','de',0),('charset','UTF-8/',0),('calendar','gregorian',0),('lang_content_negotiation','false',0),('fetchLimit','15',0),('useGzip','false',0),('wysiwyg','',0),('XHTML11','false',0),('enablePopup','false',0),('embed','false',0),('top_as_links','false',0),('blockReferer',';',0),('rewrite','none',0),('serverOffsetHours','0',0),('showFutureEntries','false',0),('enableACL','true',0),('magick','false',0),('convert','C:\\\\WINDOWS\\\\system32/convert.exe',0),('thumbSuffix','serendipityThumb',0),('thumbSize','110',0); /*!40000 ALTER TABLE `mamblog_config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_entries` -- DROP TABLE IF EXISTS `mamblog_entries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_entries` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `timestamp` int(10) unsigned DEFAULT NULL, `body` text COLLATE utf8_unicode_ci, `comments` int(4) unsigned DEFAULT '0', `trackbacks` int(4) unsigned DEFAULT '0', `extended` text COLLATE utf8_unicode_ci, `exflag` int(1) DEFAULT NULL, `author` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `authorid` int(11) DEFAULT NULL, `isdraft` enum('true','false') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'true', `allow_comments` enum('true','false') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'true', `last_modified` int(10) unsigned DEFAULT NULL, `moderate_comments` enum('true','false') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'true', PRIMARY KEY (`id`), KEY `date_idx` (`timestamp`), KEY `mod_idx` (`last_modified`), KEY `edraft_idx` (`isdraft`), KEY `eauthor_idx` (`authorid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_entries` -- LOCK TABLES `mamblog_entries` WRITE; /*!40000 ALTER TABLE `mamblog_entries` DISABLE KEYS */; /*!40000 ALTER TABLE `mamblog_entries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_entrycat` -- DROP TABLE IF EXISTS `mamblog_entrycat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_entrycat` ( `entryid` int(11) NOT NULL DEFAULT '0', `categoryid` int(11) NOT NULL DEFAULT '0', UNIQUE KEY `entryid_idx` (`entryid`,`categoryid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_entrycat` -- LOCK TABLES `mamblog_entrycat` WRITE; /*!40000 ALTER TABLE `mamblog_entrycat` DISABLE KEYS */; /*!40000 ALTER TABLE `mamblog_entrycat` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_entryproperties` -- DROP TABLE IF EXISTS `mamblog_entryproperties`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_entryproperties` ( `entryid` int(11) NOT NULL DEFAULT '0', `property` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `value` text COLLATE utf8_unicode_ci, UNIQUE KEY `prop_idx` (`entryid`,`property`), KEY `entrypropid_idx` (`entryid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_entryproperties` -- LOCK TABLES `mamblog_entryproperties` WRITE; /*!40000 ALTER TABLE `mamblog_entryproperties` DISABLE KEYS */; /*!40000 ALTER TABLE `mamblog_entryproperties` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_exits` -- DROP TABLE IF EXISTS `mamblog_exits`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_exits` ( `entry_id` int(11) NOT NULL DEFAULT '0', `day` date NOT NULL DEFAULT '0000-00-00', `count` int(11) NOT NULL DEFAULT '0', `scheme` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL, `host` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `port` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL, `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `query` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`host`,`day`,`entry_id`), KEY `exits_idx` (`entry_id`,`day`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_exits` -- LOCK TABLES `mamblog_exits` WRITE; /*!40000 ALTER TABLE `mamblog_exits` DISABLE KEYS */; /*!40000 ALTER TABLE `mamblog_exits` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_groupconfig` -- DROP TABLE IF EXISTS `mamblog_groupconfig`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_groupconfig` ( `id` int(10) unsigned NOT NULL DEFAULT '0', `property` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `value` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, KEY `groupid_idx` (`id`), KEY `groupprop_idx` (`id`,`property`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_groupconfig` -- LOCK TABLES `mamblog_groupconfig` WRITE; /*!40000 ALTER TABLE `mamblog_groupconfig` DISABLE KEYS */; INSERT INTO `mamblog_groupconfig` VALUES (1,'userlevel','0'),(1,'personalConfiguration','true'),(1,'personalConfigurationUserlevel','false'),(1,'personalConfigurationNoCreate','false'),(1,'personalConfigurationRightPublish','false'),(1,'siteConfiguration','false'),(1,'blogConfiguration','false'),(1,'adminEntries','true'),(1,'adminEntriesMaintainOthers','false'),(1,'adminImport','false'),(1,'adminCategories','true'),(1,'adminCategoriesMaintainOthers','false'),(1,'adminCategoriesDelete','false'),(1,'adminUsers','false'),(1,'adminUsersDelete','false'),(1,'adminUsersEditUserlevel','false'),(1,'adminUsersMaintainSame','false'),(1,'adminUsersMaintainOthers','false'),(1,'adminUsersCreateNew','false'),(1,'adminUsersGroups','false'),(1,'adminPlugins','false'),(1,'adminPluginsMaintainOthers','false'),(1,'adminImages','true'),(1,'adminImagesDirectories','false'),(1,'adminImagesAdd','true'),(1,'adminImagesDelete','true'),(1,'adminImagesMaintainOthers','false'),(1,'adminImagesViewOthers','true'),(1,'adminImagesView','true'),(1,'adminImagesSync','false'),(1,'adminComments','false'),(1,'adminTemplates','false'),(2,'userlevel','1'),(2,'personalConfiguration','true'),(2,'personalConfigurationUserlevel','true'),(2,'personalConfigurationNoCreate','true'),(2,'personalConfigurationRightPublish','true'),(2,'siteConfiguration','false'),(2,'blogConfiguration','true'),(2,'adminEntries','true'),(2,'adminEntriesMaintainOthers','true'),(2,'adminImport','true'),(2,'adminCategories','true'),(2,'adminCategoriesMaintainOthers','true'),(2,'adminCategoriesDelete','true'),(2,'adminUsers','true'),(2,'adminUsersDelete','true'),(2,'adminUsersEditUserlevel','true'),(2,'adminUsersMaintainSame','true'),(2,'adminUsersMaintainOthers','false'),(2,'adminUsersCreateNew','true'),(2,'adminUsersGroups','true'),(2,'adminPlugins','true'),(2,'adminPluginsMaintainOthers','false'),(2,'adminImages','true'),(2,'adminImagesDirectories','true'),(2,'adminImagesAdd','true'),(2,'adminImagesDelete','true'),(2,'adminImagesMaintainOthers','true'),(2,'adminImagesViewOthers','true'),(2,'adminImagesView','true'),(2,'adminImagesSync','true'),(2,'adminComments','true'),(2,'adminTemplates','true'),(3,'userlevel','255'),(3,'personalConfiguration','true'),(3,'personalConfigurationUserlevel','true'),(3,'personalConfigurationNoCreate','true'),(3,'personalConfigurationRightPublish','true'),(3,'siteConfiguration','true'),(3,'blogConfiguration','true'),(3,'adminEntries','true'),(3,'adminEntriesMaintainOthers','true'),(3,'adminImport','true'),(3,'adminCategories','true'),(3,'adminCategoriesMaintainOthers','true'),(3,'adminCategoriesDelete','true'),(3,'adminUsers','true'),(3,'adminUsersDelete','true'),(3,'adminUsersEditUserlevel','true'),(3,'adminUsersMaintainSame','true'),(3,'adminUsersMaintainOthers','true'),(3,'adminUsersCreateNew','true'),(3,'adminUsersGroups','true'),(3,'adminPlugins','true'),(3,'adminPluginsMaintainOthers','true'),(3,'adminImages','true'),(3,'adminImagesDirectories','true'),(3,'adminImagesAdd','true'),(3,'adminImagesDelete','true'),(3,'adminImagesMaintainOthers','true'),(3,'adminImagesViewOthers','true'),(3,'adminImagesView','true'),(3,'adminImagesSync','true'),(3,'adminComments','true'),(3,'adminTemplates','true'); /*!40000 ALTER TABLE `mamblog_groupconfig` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_groups` -- DROP TABLE IF EXISTS `mamblog_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_groups` -- LOCK TABLES `mamblog_groups` WRITE; /*!40000 ALTER TABLE `mamblog_groups` DISABLE KEYS */; INSERT INTO `mamblog_groups` VALUES (1,'USERLEVEL_EDITOR_DESC'),(2,'USERLEVEL_CHIEF_DESC'),(3,'USERLEVEL_ADMIN_DESC'); /*!40000 ALTER TABLE `mamblog_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_images` -- DROP TABLE IF EXISTS `mamblog_images`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_images` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `extension` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `mime` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `size` int(11) NOT NULL DEFAULT '0', `dimensions_width` int(11) NOT NULL DEFAULT '0', `dimensions_height` int(11) NOT NULL DEFAULT '0', `date` int(11) NOT NULL DEFAULT '0', `thumbnail_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `authorid` int(11) DEFAULT '0', `path` text COLLATE utf8_unicode_ci, `hotlink` int(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `imagesauthorid_idx` (`authorid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_images` -- LOCK TABLES `mamblog_images` WRITE; /*!40000 ALTER TABLE `mamblog_images` DISABLE KEYS */; /*!40000 ALTER TABLE `mamblog_images` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_permalinks` -- DROP TABLE IF EXISTS `mamblog_permalinks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_permalinks` ( `permalink` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `entry_id` int(10) unsigned NOT NULL DEFAULT '0', `type` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `data` text COLLATE utf8_unicode_ci, KEY `pl_idx` (`permalink`), KEY `ple_idx` (`entry_id`), KEY `plt_idx` (`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_permalinks` -- LOCK TABLES `mamblog_permalinks` WRITE; /*!40000 ALTER TABLE `mamblog_permalinks` DISABLE KEYS */; INSERT INTO `mamblog_permalinks` VALUES ('authors/1-Markus-A.-Mascelli',1,'author',NULL); /*!40000 ALTER TABLE `mamblog_permalinks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_plugincategories` -- DROP TABLE IF EXISTS `mamblog_plugincategories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_plugincategories` ( `class_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL, `category` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_plugincategories` -- LOCK TABLES `mamblog_plugincategories` WRITE; /*!40000 ALTER TABLE `mamblog_plugincategories` DISABLE KEYS */; /*!40000 ALTER TABLE `mamblog_plugincategories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_pluginlist` -- DROP TABLE IF EXISTS `mamblog_pluginlist`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_pluginlist` ( `plugin_file` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `class_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `plugin_class` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `pluginPath` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `description` text COLLATE utf8_unicode_ci NOT NULL, `version` varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `upgrade_version` varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `plugintype` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `pluginlocation` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `stackable` int(1) NOT NULL DEFAULT '0', `author` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `requirements` text COLLATE utf8_unicode_ci NOT NULL, `website` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `last_modified` int(11) NOT NULL DEFAULT '0', KEY `pluginlist_f_idx` (`plugin_file`), KEY `pluginlist_cn_idx` (`class_name`), KEY `pluginlist_pt_idx` (`plugintype`), KEY `pluginlist_pl_idx` (`pluginlocation`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_pluginlist` -- LOCK TABLES `mamblog_pluginlist` WRITE; /*!40000 ALTER TABLE `mamblog_pluginlist` DISABLE KEYS */; /*!40000 ALTER TABLE `mamblog_pluginlist` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_plugins` -- DROP TABLE IF EXISTS `mamblog_plugins`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_plugins` ( `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `placement` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'right', `sort_order` int(4) NOT NULL DEFAULT '0', `authorid` int(11) DEFAULT '0', `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`name`), KEY `pluginauthorid_idx` (`authorid`), KEY `pluginplace_idx` (`placement`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_plugins` -- LOCK TABLES `mamblog_plugins` WRITE; /*!40000 ALTER TABLE `mamblog_plugins` DISABLE KEYS */; INSERT INTO `mamblog_plugins` VALUES ('@serendipity_archives_plugin:07aeab31227f5445fd9632c338573477','right',3,0,''),('@serendipity_calendar_plugin:1c661b8bf75618917249327bf9cb0d2f','right',1,0,''),('@serendipity_categories_plugin:bc070b3fefa6febc8a02a2e126f775d9','right',4,0,''),('@serendipity_plug_plugin:efab4961c19dde9d4e9ec5825524570d','right',7,0,''),('@serendipity_quicksearch_plugin:5208c3b43db2b45e4a9c0d1c29376959','right',2,0,''),('@serendipity_superuser_plugin:d28f55f0d5d992ff3ee988ef4c8f2ce2','right',6,0,''),('@serendipity_syndication_plugin:07bf83f9770999071669834599d882a4','right',5,0,''),('serendipity_event_browsercompatibility:3489ebd55c7eaf550b836562d0ec5ed1','event',4,0,''),('serendipity_event_emoticate:ddc264a1da49fad68471e2fd639c19dc','event',2,0,''),('serendipity_event_nl2br:d1b93e8253766b17329dd5402db6c635','event',3,0,''),('serendipity_event_s9ymarkup:1c156f243d04437ca868374e2b0dd858','event',1,0,''),('serendipity_event_spamblock:b5501d1ac6366435c8ff8654941257ec','event',5,0,''); /*!40000 ALTER TABLE `mamblog_plugins` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_references` -- DROP TABLE IF EXISTS `mamblog_references`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_references` ( `id` int(11) NOT NULL AUTO_INCREMENT, `entry_id` int(10) unsigned NOT NULL DEFAULT '0', `link` text COLLATE utf8_unicode_ci, `name` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`), KEY `refentry_idx` (`entry_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_references` -- LOCK TABLES `mamblog_references` WRITE; /*!40000 ALTER TABLE `mamblog_references` DISABLE KEYS */; /*!40000 ALTER TABLE `mamblog_references` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_referrers` -- DROP TABLE IF EXISTS `mamblog_referrers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_referrers` ( `entry_id` int(11) NOT NULL DEFAULT '0', `day` date NOT NULL DEFAULT '0000-00-00', `count` int(11) NOT NULL DEFAULT '0', `scheme` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL, `host` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `port` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL, `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `query` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`host`,`day`,`entry_id`), KEY `referrers_idx` (`entry_id`,`day`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_referrers` -- LOCK TABLES `mamblog_referrers` WRITE; /*!40000 ALTER TABLE `mamblog_referrers` DISABLE KEYS */; INSERT INTO `mamblog_referrers` VALUES (0,'2020-04-03',1,'http','baidu.com','','/',''),(0,'2021-06-18',1,'http','baidu.com','','/',''),(0,'2022-08-09',1,'http','baidu.com','','/',''),(0,'2022-12-26',1,'http','baidu.com','','/',''),(0,'2023-07-31',1,'http','baidu.com','','/',''),(0,'2021-05-19',1,'http','google.de','','',''),(0,'2022-11-12',1,'http','google.de','','',''),(0,'2022-12-15',1,'http','google.de','','',''),(0,'2011-06-21',3,'http','mamweb.at','','/index_top.html',''),(0,'2011-06-22',2,'http','mamweb.at','','/index_top.html',''),(0,'2023-10-19',1,'http','mamweb.at','','/index_noframes.html',''),(0,'2011-10-09',6,'http','www.domaincrawler.com','','/mamweb.at',''),(0,'2007-09-29',2,'http','www.google.de','','/search','hl=de&q=mamblog&btnG=Suche&meta=lr%3Dlang_de'),(0,'2007-03-15',1,'http','www.mamweb.at','','/index_top.html',''),(0,'2007-08-01',1,'http','www.mamweb.at','','/index_top.html',''),(0,'2007-08-14',1,'http','www.mamweb.at','','/index_top.html',''),(0,'2008-04-30',1,'http','www.mamweb.at','','/index_top.html',''),(0,'2009-10-18',1,'http','www.mamweb.at','','/index_top.html',''),(0,'2010-04-06',2,'http','www.mamweb.at','','/index_top.html',''),(0,'2011-03-14',1,'http','www.mamweb.at','','/index_top.html',''),(0,'2020-06-07',1,'http','www.mamweb.at','','/index_top.html',''); /*!40000 ALTER TABLE `mamblog_referrers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamblog_suppress` -- DROP TABLE IF EXISTS `mamblog_suppress`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamblog_suppress` ( `ip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `scheme` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL, `host` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `port` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL, `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `query` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `last` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, KEY `url_idx` (`host`,`ip`), KEY `urllast_idx` (`last`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamblog_suppress` -- LOCK TABLES `mamblog_suppress` WRITE; /*!40000 ALTER TABLE `mamblog_suppress` DISABLE KEYS */; INSERT INTO `mamblog_suppress` VALUES ('52.212.65.14','http','mamweb.at','','/index_top.html','','2023-06-13 13:28:29'),('54.155.149.149','http','mamweb.at','','/index_top.html','','2023-06-15 22:54:29'),('211.185.121.31','https','www.bing.com','','','','2023-06-16 16:27:16'),('34.249.9.127','http','mamweb.at','','/index_top.html','','2023-06-19 17:16:44'),('83.240.221.24','https','www.bing.com','','','','2023-06-26 06:03:24'),('34.242.96.159','http','mamweb.at','','/index_top.html','','2023-06-26 21:34:38'),('18.203.58.255','http','mamweb.at','','/index_top.html','','2023-07-03 15:43:47'),('188.165.202.227','https','www.bing.com','','','','2023-07-07 09:32:33'),('99.81.52.226','http','mamweb.at','','/index_top.html','','2023-07-10 14:52:05'),('34.248.223.58','http','mamweb.at','','/index_top.html','','2023-07-18 00:54:29'),('34.242.161.83','http','mamweb.at','','/index_top.html','','2023-07-25 01:18:42'),('199.203.59.201','https','www.bing.com','','','','2023-07-29 21:08:33'),('27.115.124.109','http','baidu.com','','/','','2023-07-31 11:12:59'),('18.203.58.255','http','mamweb.at','','/index_top.html','','2023-07-31 14:41:55'),('108.128.163.92','http','mamweb.at','','/index_top.html','','2023-08-07 22:56:13'),('193.170.192.20','http','www.mamweb.at','','/index_top.html','','2023-08-08 09:07:53'),('18.200.50.252','http','mamweb.at','','/index_top.html','','2023-08-15 09:28:39'),('18.202.214.207','http','mamweb.at','','/index_top.html','','2023-08-22 08:03:15'),('54.170.249.116','http','mamweb.at','','/index_top.html','','2023-08-25 08:15:06'),('167.71.200.211','https','www.bing.com','','','','2023-08-26 13:00:23'),('108.129.63.99','http','mamweb.at','','/index_top.html','','2023-08-28 21:43:54'),('27.115.124.45','http','baidu.com','','/','','2023-08-29 15:27:42'),('123.6.49.9','http','baidu.com','','/','','2023-08-29 15:27:48'),('34.240.51.166','http','mamweb.at','','/index_top.html','','2023-09-01 02:39:18'),('54.72.77.114','http','mamweb.at','','/index_top.html','','2023-09-05 00:59:01'),('18.200.4.221','http','mamweb.at','','/index_top.html','','2023-09-12 02:31:54'),('34.251.18.201','http','mamweb.at','','/index_top.html','','2023-09-15 14:21:36'),('3.248.70.57','http','mamweb.at','','/index_top.html','','2023-09-19 22:19:26'),('108.128.234.217','http','mamweb.at','','/index_top.html','','2023-09-22 00:36:00'),('3.248.70.57','http','mamweb.at','','/index_top.html','','2023-09-26 05:54:20'),('52.213.195.203','http','mamweb.at','','/index_top.html','','2023-09-28 23:28:15'),('176.34.106.202','http','mamweb.at','','/index_top.html','','2023-10-02 16:29:05'),('52.18.205.73','http','mamweb.at','','/index_top.html','','2023-10-05 21:40:00'),('108.128.167.115','http','mamweb.at','','/index_top.html','','2023-10-09 18:17:51'),('108.128.67.152','http','mamweb.at','','/index_top.html','','2023-10-12 23:47:16'),('108.128.241.54','http','mamweb.at','','/index_top.html','','2023-10-16 22:05:25'),('85.215.229.154','http','mamweb.at','','/index_noframes.html','','2023-10-19 02:24:23'),('176.34.219.125','http','mamweb.at','','/index_top.html','','2023-10-20 05:43:16'),('3.254.27.148','http','mamweb.at','','/index_top.html','','2023-10-23 20:58:45'),('54.78.169.102','http','mamweb.at','','/index_top.html','','2023-10-27 10:05:49'),('108.128.241.54','http','mamweb.at','','/index_top.html','','2023-10-31 18:10:54'),('123.6.49.10','http','baidu.com','','/','','2023-11-03 02:49:06'),('27.115.124.109','http','baidu.com','','/','','2023-11-03 02:49:14'),('3.253.199.101','http','mamweb.at','','/index_top.html','','2023-11-03 17:28:42'),('54.217.164.151','http','mamweb.at','','/index_top.html','','2023-11-06 22:33:36'),('18.202.147.76','http','mamweb.at','','/index_top.html','','2023-11-10 08:26:27'),('69.197.158.202','https','google.com','','','','2023-11-13 19:18:37'),('3.248.72.208','http','mamweb.at','','/index_top.html','','2023-11-14 06:58:13'),('52.213.249.255','http','mamweb.at','','/index_top.html','','2023-11-16 23:12:58'),('52.36.251.200','http','mamweb.at','','','','2023-11-17 08:05:53'),('69.197.158.202','https','google.com','','','','2023-11-18 17:34:55'),('108.128.241.54','http','mamweb.at','','/index_top.html','','2023-11-21 06:05:32'),('3.254.216.230','http','mamweb.at','','/index_top.html','','2023-11-23 12:24:50'),('108.128.155.180','http','mamweb.at','','/index_top.html','','2023-11-27 18:58:08'),('3.248.167.4','http','mamweb.at','','/index_top.html','','2023-11-30 17:47:45'),('52.211.161.39','http','mamweb.at','','/index_top.html','','2023-12-05 13:51:52'),('18.202.6.17','http','mamweb.at','','/index_top.html','','2023-12-07 10:34:06'),('18.203.193.77','http','mamweb.at','','/index_top.html','','2023-12-12 05:34:19'),('108.128.241.54','http','mamweb.at','','/index_top.html','','2023-12-15 13:11:13'),('115.165.166.162','https','www.bing.com','','','','2023-12-16 04:17:47'),('176.34.219.125','http','mamweb.at','','/index_top.html','','2023-12-19 07:17:38'),('99.81.233.44','http','mamweb.at','','/index_top.html','','2023-12-21 17:36:57'),('108.128.47.248','http','mamweb.at','','/index_top.html','','2023-12-25 18:49:55'),('34.247.116.121','http','mamweb.at','','/index_top.html','','2023-12-28 17:36:02'),('108.128.198.38','http','mamweb.at','','/index_top.html','','2024-01-01 07:08:00'),('123.6.49.41','http','baidu.com','','/','','2024-01-03 12:41:38'),('123.6.49.10','http','baidu.com','','/','','2024-01-03 12:41:43'),('108.129.63.169','http','mamweb.at','','/index_top.html','','2024-01-04 22:54:37'),('18.202.203.191','http','mamweb.at','','/index_top.html','','2024-01-09 04:41:31'),('108.128.211.115','http','mamweb.at','','/index_top.html','','2024-01-11 20:23:34'),('108.128.211.115','http','mamweb.at','','/index_top.html','','2024-01-15 20:54:11'),('108.128.246.98','http','mamweb.at','','/index_top.html','','2024-01-19 13:37:28'),('176.34.171.66','http','mamweb.at','','/index_top.html','','2024-01-22 08:55:25'),('54.78.252.178','http','mamweb.at','','/index_top.html','','2024-01-25 19:41:58'),('108.128.163.92','http','mamweb.at','','/index_top.html','','2024-01-30 09:30:52'); /*!40000 ALTER TABLE `mamblog_suppress` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2024-02-01 2:00:11