-- MySQL dump 10.13 Distrib 5.1.48, for Win32 (ia32)
--
-- Host: localhost Database: xoops
-- ------------------------------------------------------
-- Server version 5.1.48-community
/*!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 `xoops__avatar`
--
DROP TABLE IF EXISTS `xoops__avatar`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__avatar` (
`avatar_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`avatar_file` varchar(30) NOT NULL DEFAULT '',
`avatar_name` varchar(100) NOT NULL DEFAULT '',
`avatar_mimetype` varchar(30) NOT NULL DEFAULT '',
`avatar_created` int(10) NOT NULL DEFAULT '0',
`avatar_display` tinyint(1) unsigned NOT NULL DEFAULT '0',
`avatar_weight` smallint(5) unsigned NOT NULL DEFAULT '0',
`avatar_type` char(1) NOT NULL DEFAULT '',
PRIMARY KEY (`avatar_id`),
KEY `avatar_type` (`avatar_type`,`avatar_display`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__avatar`
--
LOCK TABLES `xoops__avatar` WRITE;
/*!40000 ALTER TABLE `xoops__avatar` DISABLE KEYS */;
/*!40000 ALTER TABLE `xoops__avatar` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__avatar_user_link`
--
DROP TABLE IF EXISTS `xoops__avatar_user_link`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__avatar_user_link` (
`avatar_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
KEY `avatar_user_id` (`avatar_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__avatar_user_link`
--
LOCK TABLES `xoops__avatar_user_link` WRITE;
/*!40000 ALTER TABLE `xoops__avatar_user_link` DISABLE KEYS */;
/*!40000 ALTER TABLE `xoops__avatar_user_link` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__banner`
--
DROP TABLE IF EXISTS `xoops__banner`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__banner` (
`bid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`cid` tinyint(3) unsigned NOT NULL DEFAULT '0',
`imptotal` mediumint(8) unsigned NOT NULL DEFAULT '0',
`impmade` mediumint(8) unsigned NOT NULL DEFAULT '0',
`clicks` mediumint(8) unsigned NOT NULL DEFAULT '0',
`imageurl` varchar(255) NOT NULL DEFAULT '',
`clickurl` varchar(255) NOT NULL DEFAULT '',
`date` int(10) NOT NULL DEFAULT '0',
`htmlbanner` tinyint(1) NOT NULL DEFAULT '0',
`htmlcode` text NOT NULL,
PRIMARY KEY (`bid`),
KEY `idxbannercid` (`cid`),
KEY `idxbannerbidcid` (`bid`,`cid`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__banner`
--
LOCK TABLES `xoops__banner` WRITE;
/*!40000 ALTER TABLE `xoops__banner` DISABLE KEYS */;
INSERT INTO `xoops__banner` VALUES (1,1,0,20,0,'http://xoops.mamweb.at/html/images/banners/xoops_banner.gif','http://www.xoops.org/',1008813250,0,''),(2,1,0,16,0,'http://xoops.mamweb.at/html/images/banners/xoops_banner_2.gif','http://www.xoops.org/',1008813250,0,''),(3,1,0,16,0,'http://xoops.mamweb.at/html/images/banners/banner.swf','http://www.xoops.org/',1008813250,0,'');
/*!40000 ALTER TABLE `xoops__banner` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__bannerclient`
--
DROP TABLE IF EXISTS `xoops__bannerclient`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__bannerclient` (
`cid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(60) NOT NULL DEFAULT '',
`contact` varchar(60) NOT NULL DEFAULT '',
`email` varchar(60) NOT NULL DEFAULT '',
`login` varchar(10) NOT NULL DEFAULT '',
`passwd` varchar(10) NOT NULL DEFAULT '',
`extrainfo` text NOT NULL,
PRIMARY KEY (`cid`),
KEY `login` (`login`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__bannerclient`
--
LOCK TABLES `xoops__bannerclient` WRITE;
/*!40000 ALTER TABLE `xoops__bannerclient` DISABLE KEYS */;
INSERT INTO `xoops__bannerclient` VALUES (1,'XOOPS','XOOPS Dev Team','webmaster@xoops.org','','','');
/*!40000 ALTER TABLE `xoops__bannerclient` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__bannerfinish`
--
DROP TABLE IF EXISTS `xoops__bannerfinish`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__bannerfinish` (
`bid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`cid` smallint(5) unsigned NOT NULL DEFAULT '0',
`impressions` mediumint(8) unsigned NOT NULL DEFAULT '0',
`clicks` mediumint(8) unsigned NOT NULL DEFAULT '0',
`datestart` int(10) unsigned NOT NULL DEFAULT '0',
`dateend` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`bid`),
KEY `cid` (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__bannerfinish`
--
LOCK TABLES `xoops__bannerfinish` WRITE;
/*!40000 ALTER TABLE `xoops__bannerfinish` DISABLE KEYS */;
/*!40000 ALTER TABLE `xoops__bannerfinish` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__block_instance`
--
DROP TABLE IF EXISTS `xoops__block_instance`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__block_instance` (
`instanceid` int(12) unsigned NOT NULL AUTO_INCREMENT,
`bid` int(12) unsigned NOT NULL DEFAULT '0',
`options` text NOT NULL,
`title` varchar(255) NOT NULL DEFAULT '',
`side` tinyint(1) unsigned NOT NULL DEFAULT '0',
`weight` smallint(5) unsigned NOT NULL DEFAULT '0',
`visible` tinyint(1) unsigned NOT NULL DEFAULT '0',
`bcachetime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`instanceid`),
KEY `join` (`instanceid`,`visible`,`weight`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__block_instance`
--
LOCK TABLES `xoops__block_instance` WRITE;
/*!40000 ALTER TABLE `xoops__block_instance` DISABLE KEYS */;
INSERT INTO `xoops__block_instance` VALUES (1,1,'a:0:{}','User Menu',0,0,1,0),(2,2,'a:0:{}','Login',0,0,1,0),(3,5,'a:0:{}','Main Menu',0,0,1,0);
/*!40000 ALTER TABLE `xoops__block_instance` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__block_module_link`
--
DROP TABLE IF EXISTS `xoops__block_module_link`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__block_module_link` (
`block_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`module_id` smallint(5) NOT NULL DEFAULT '0',
`pageid` smallint(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`block_id`,`module_id`,`pageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__block_module_link`
--
LOCK TABLES `xoops__block_module_link` WRITE;
/*!40000 ALTER TABLE `xoops__block_module_link` DISABLE KEYS */;
INSERT INTO `xoops__block_module_link` VALUES (1,0,0),(2,0,0),(3,0,0);
/*!40000 ALTER TABLE `xoops__block_module_link` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__config`
--
DROP TABLE IF EXISTS `xoops__config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__config` (
`conf_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`conf_modid` smallint(5) unsigned NOT NULL DEFAULT '0',
`conf_catid` smallint(5) unsigned NOT NULL DEFAULT '0',
`conf_name` varchar(25) NOT NULL DEFAULT '',
`conf_title` varchar(30) NOT NULL DEFAULT '',
`conf_value` text NOT NULL,
`conf_desc` varchar(50) NOT NULL DEFAULT '',
`conf_formtype` varchar(15) NOT NULL DEFAULT '',
`conf_valuetype` varchar(10) NOT NULL DEFAULT '',
`conf_order` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`conf_id`),
KEY `conf_mod_cat_id` (`conf_modid`,`conf_catid`)
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__config`
--
LOCK TABLES `xoops__config` WRITE;
/*!40000 ALTER TABLE `xoops__config` DISABLE KEYS */;
INSERT INTO `xoops__config` VALUES (1,1,1,'sitename','_MD_AM_SITENAME','mamXOOPX','_MD_AM_SITENAMEDSC','textbox','text',0),(2,1,1,'slogan','_MD_AM_SLOGAN','powered by mam','_MD_AM_SLOGANDSC','textbox','text',1),(3,1,1,'adminmail','_MD_AM_ADMINML','mam@heimam.at','_MD_AM_ADMINMLDSC','textbox','text',2),(4,1,1,'language','_MD_AM_LANGUAGE','english','_MD_AM_LANGUAGEDSC','language','other',3),(5,1,1,'startpage','_MD_AM_STARTPAGE','--','_MD_AM_STARTPAGEDSC','startpage','other',4),(6,1,1,'server_TZ','_MD_AM_SERVERTZ','1','_MD_AM_SERVERTZDSC','timezone','float',5),(7,1,1,'default_TZ','_MD_AM_DEFAULTTZ','5','_MD_AM_DEFAULTTZDSC','timezone','float',6),(8,1,1,'theme_set','_MD_AM_DTHEME','default','_MD_AM_DTHEMEDSC','theme','other',7),(9,1,1,'theme_set_admin','_MD_AM_ADMINTHEME','0','_MD_AM_ADMINTHEMEDSC','theme_admin','other',8),(10,1,1,'theme_fromfile','_MD_AM_THEMEFILE','0','_MD_AM_THEMEFILEDSC','yesno','int',9),(11,1,1,'theme_set_allowed','_MD_AM_THEMEOK','a:4:{i:0;s:7:\"default\";i:1;s:7:\"phpkaox\";i:2;s:3:\"x2t\";i:3;s:3:\"xmt\";}','_MD_AM_THEMEOKDSC','theme_multi','array',10),(12,1,1,'template_set','_MD_AM_DTPLSET','default','_MD_AM_DTPLSETDSC','tplset','other',11),(13,1,1,'anonymous','_MD_AM_ANONNAME','Anonymous','_MD_AM_ANONNAMEDSC','textbox','text',12),(14,1,1,'gzip_compression','_MD_AM_USEGZIP','0','_MD_AM_USEGZIPDSC','yesno','int',13),(15,1,1,'usercookie','_MD_AM_USERCOOKIE','xoops_user','_MD_AM_USERCOOKIEDSC','textbox','text',14),(16,1,1,'use_mysession','_MD_AM_USEMYSESS','0','_MD_AM_USEMYSESSDSC','yesno','int',15),(17,1,1,'session_expire','_MD_AM_SESSEXPIRE','15','_MD_AM_SESSEXPIREDSC','textbox','int',16),(18,1,1,'session_name','_MD_AM_SESSNAME','xoops_session','_MD_AM_SESSNAMEDSC','textbox','text',17),(19,1,1,'debug_mode','_MD_AM_DEBUGMODE','a:1:{i:0;s:1:\"1\";}','_MD_AM_DEBUGMODEDSC','select_multi','array',18),(20,1,1,'banners','_MD_AM_BANNERS','1','_MD_AM_BANNERSDSC','yesno','int',19),(21,1,1,'closesite','_MD_AM_CLOSESITE','0','_MD_AM_CLOSESITEDSC','yesno','int',20),(22,1,1,'closesite_okgrp','_MD_AM_CLOSESITEOK','a:1:{i:0;s:1:\"1\";}','_MD_AM_CLOSESITEOKDSC','group_multi','array',21),(23,1,1,'closesite_text','_MD_AM_CLOSESITETXT','The site is currently closed for maintainance. Please come back later.','_MD_AM_CLOSESITETXTDSC','textarea','text',22),(24,1,1,'my_ip','_MD_AM_MYIP','127.0.0.1','_MD_AM_MYIPDSC','textbox','text',23),(25,1,1,'use_ssl','_MD_AM_USESSL','0','_MD_AM_USESSLDSC','yesno','int',24),(26,1,1,'sslpost_name','_MD_AM_SSLPOST','xoops_ssl','_MD_AM_SSLPOSTDSC','textbox','text',25),(27,1,1,'sslloginlink','_MD_AM_SSLLINK','https://','_MD_AM_SSLLINKDSC','textbox','text',26),(28,1,1,'com_mode','_MD_AM_COMMODE','nest','_MD_AM_COMMODEDSC','select','text',27),(29,1,1,'com_order','_MD_AM_COMORDER','0','_MD_AM_COMORDERDSC','select','int',28),(30,1,1,'enable_badips','_MD_AM_DOBADIPS','0','_MD_AM_DOBADIPSDSC','yesno','int',29),(31,1,1,'bad_ips','_MD_AM_BADIPS','a:1:{i:0;s:9:\"127.0.0.1\";}','_MD_AM_BADIPSDSC','textarea','array',30),(32,1,1,'module_cache','_MD_AM_MODCACHE','a:2:{i:2;s:1:\"0\";i:3;s:1:\"0\";}','_MD_AM_MODCACHEDSC','module_cache','array',31),(33,1,3,'meta_keywords','_MD_AM_METAKEY','news, technology, headlines, xoops, xoop, nuke, myphpnuke, myphp-nuke, phpnuke, SE, geek, geeks, hacker, hackers, linux, software, download, downloads, free, community, mp3, forum, forums, bulletin, board, boards, bbs, php, survey, poll, polls, kernel, comment, comments, portal, odp, open, source, opensource, FreeSoftware, gnu, gpl, license, Unix, *nix, mysql, sql, database, databases, web site, weblog, guru, module, modules, theme, themes, cms, content management','_MD_AM_METAKEYDSC','textarea','text',32),(34,1,3,'footer','_MD_AM_FOOTER','Powered by XOOPS 2.2.3 Final © 2001-2006 The XOOPS Project','_MD_AM_FOOTERDSC','textarea','text',33),(35,1,4,'censor_enable','_MD_AM_DOCENSOR','0','_MD_AM_DOCENSORDSC','yesno','int',34),(36,1,4,'censor_words','_MD_AM_CENSORWRD','a:2:{i:0;s:4:\"fuck\";i:1;s:4:\"shit\";}','_MD_AM_CENSORWRDDSC','textarea','array',35),(37,1,4,'censor_replace','_MD_AM_CENSORRPLC','#OOPS#','_MD_AM_CENSORRPLCDSC','textbox','text',36),(38,1,3,'meta_rating','_MD_AM_METARATING','general','_MD_AM_METARATINGDSC','select','text',37),(39,1,3,'meta_author','_MD_AM_METAAUTHOR','XOOPS','_MD_AM_METAAUTHORDSC','textbox','text',38),(40,1,3,'meta_copyright','_MD_AM_METACOPYR','Copyright © 2001-2006','_MD_AM_METACOPYRDSC','textbox','text',39),(41,1,3,'meta_description','_MD_AM_METADESC','XOOPS is a dynamic Object Oriented based open source portal script written in PHP.','_MD_AM_METADESCDSC','textarea','text',40),(42,1,3,'meta_robots','_MD_AM_METAROBOTS','index,follow','_MD_AM_METAROBOTSDSC','select','text',41),(43,1,5,'enable_search','_MD_AM_DOSEARCH','1','_MD_AM_DOSEARCHDSC','yesno','int',42),(44,1,5,'keyword_min','_MD_AM_MINSEARCH','5','_MD_AM_MINSEARCHDSC','textbox','int',43),(45,1,6,'mailmethod','_MD_AM_MAILERMETHOD','mail','_MD_AM_MAILERMETHODDESC','select','text',44),(46,1,6,'sendmailpath','_MD_AM_SENDMAILPATH','/usr/sbin/sendmail','_MD_AM_SENDMAILPATHDESC','textbox','text',45),(47,1,6,'smtphost','_MD_AM_SMTPHOST','','_MD_AM_SMTPHOSTDESC','textarea','text',46),(48,1,6,'smtpuser','_MD_AM_SMTPUSER','','_MD_AM_SMTPUSERDESC','textbox','text',47),(49,1,6,'smtppass','_MD_AM_SMTPPASS','','_MD_AM_SMTPPASSDESC','password','text',48),(50,1,6,'from','_MD_AM_MAILFROM','','_MD_AM_MAILFROMDESC','textbox','text',49),(51,1,6,'fromname','_MD_AM_MAILFROMNAME','','_MD_AM_MAILFROMNAMEDESC','textbox','text',50),(52,1,6,'fromuid','_MD_AM_MAILFROMUID','1','_MD_AM_MAILFROMUIDDESC','user','int',51),(53,1,7,'auth_method','_MD_AM_AUTHMETHOD','xoops','_MD_AM_AUTHMETHODDESC','select','text',52),(54,1,7,'ldap_mail_attr','_MD_AM_LDAP_MAIL_ATTR','mail','_MD_AM_LDAP_MAIL_ATTR_DESC','textbox','text',53),(55,1,7,'ldap_name_attr','_MD_AM_LDAP_NAME_ATTR','cn','_MD_AM_LDAP_NAME_ATTR_DESC','textbox','text',54),(56,1,7,'ldap_surname_attr','_MD_AM_LDAP_SURNAME_ATTR','sn','_MD_AM_LDAP_SURNAME_ATTR_DESC','textbox','text',55),(57,1,7,'ldap_givenname_attr','_MD_AM_LDAP_GIVENNAME_ATTR','givenname','_MD_AM_LDAP_GIVENNAME_ATTR_DSC','textbox','text',56),(58,1,7,'ldap_port','_MD_AM_LDAP_PORT','389','_MD_AM_LDAP_PORT','textbox','int',57),(59,1,7,'ldap_server','_MD_AM_LDAP_SERVER','your directory server','_MD_AM_LDAP_SERVER_DESC','textbox','text',58),(60,1,7,'ldap_base_dn','_MD_AM_LDAP_BASE_DN','ou=Employees,o=Company','_MD_AM_LDAP_BASE_DN_DESC','textbox','text',59),(61,1,7,'ldap_uid_attr','_MD_AM_LDAP_UID_ATTR','uid','_MD_AM_LDAP_UID_ATTR_DESC','textbox','text',60),(62,1,7,'ldap_uid_asdn','_MD_AM_LDAP_UID_ASDN','uid_asdn','_MD_AM_LDAP_UID_ASDN_DESC','yesno','int',61),(63,1,7,'ldap_manager_dn','_MD_AM_LDAP_MANAGER_DN','manager_dn','_MD_AM_LDAP_MANAGER_DN_DESC','textbox','text',62),(64,1,7,'ldap_manager_pass','_MD_AM_LDAP_MANAGER_PASS','manager_pass','_MD_AM_LDAP_MANAGER_PASS_DESC','textbox','text',63),(65,1,7,'ldap_version','_MD_AM_LDAP_VERSION','3','_MD_AM_LDAP_VERSION_DESC','textbox','text',64),(66,2,0,'perpage','_PM_MI_PERPAGE','50','_PM_MI_PERPAGE_DESC','textbox','int',0),(67,2,0,'max_save','_PM_MI_MAXSAVE','30','_PM_MI_MAXSAVE_DESC','textbox','int',1),(68,2,0,'prunesubject','_PM_MI_PRUNESUBJECT','Messages deleted during cleanup','_PM_MI_PRUNESUBJECT_DESC','textbox','text',2),(69,2,0,'prunemessage','_PM_MI_PRUNEMESSAGE','During a cleanup of the Private Messaging, we have deleted {PM_COUNT} of the messages in your inbox to save space and resources','_PM_MI_PRUNEMESSAGE_DESC','textarea','text',3),(70,3,1,'profile_search','_PROFILE_MI_PROFILE_SEARCH','1','_PROFILE_MI_PROFILE_SEARCH_DSC','yesno','int',0),(71,3,2,'max_uname','_PROFILE_MI_MAX_UNAME','30','_PROFILE_MI_MAX_UNAME_DESC','textbox','int',1),(72,3,2,'min_uname','_PROFILE_MI_MIN_UNAME','3','_PROFILE_MI_MIN_UNAME_DESC','textbox','int',2),(73,3,1,'display_disclaimer','_PROFILE_MI_DISPLAY_DISCLAIMER','0','_PROFILE_MI_DISPLAY_DISCLAIMER_DESC','yesno','int',3),(74,3,1,'disclaimer','_PROFILE_MI_DISCLAIMER','','_PROFILE_MI_DISCLAIMER_DESC','textarea','text',4),(75,3,2,'bad_unames','_PROFILE_MI_BAD_UNAMES','a:3:{i:0;s:9:\"webmaster\";i:1;s:6:\"^xoops\";i:2;s:6:\"^admin\";}','_PROFILE_MI_BAD_UNAMES_DESC','textarea','array',5),(76,3,2,'bad_emails','_PROFILE_MI_BAD_EMAILS','a:1:{i:0;s:10:\"xoops.org$\";}','_PROFILE_MI_BAD_EMAILS_DESC','textarea','array',6),(77,3,2,'minpass','_PROFILE_MI_MINPASS','3','_PROFILE_MI_MINPASS_DESC','textbox','int',7),(78,3,1,'new_user_notify','_PROFILE_MI_NEWUNOTIFY','1','_PROFILE_MI_NEWUNOTIFY_DESC','yesno','int',8),(79,3,1,'new_user_notify_group','_PROFILE_MI_NOTIFYTO','1','_PROFILE_MI_NOTIFYTO_DESC','group','int',9),(80,3,1,'activation_type','_PROFILE_MI_ACTVTYPE','0','_PROFILE_MI_ACTVTYPE_DESC','select','int',10),(81,3,1,'activation_group','_PROFILE_MI_ACTVGROUP','1','_PROFILE_MI_ACTVGROUP_DESC','group','int',11),(82,3,2,'uname_test_level','_PROFILE_MI_UNAMELVL','0','_PROFILE_MI_UNAMELVL_DESC','select','int',12),(83,3,1,'allow_register','_PROFILE_MI_ALLOWREG','1','_PROFILE_MI_ALLOWREG_DESC','yesno','int',13),(84,3,2,'avatar_allow_upload','_PROFILE_MI_AVATARALLOW','1','_PROFILE_MI_AVATARALLOW_DESC','yesno','int',14),(85,3,2,'avatar_width','_PROFILE_MI_AVATARWIDTH','80','_PROFILE_MI_AVATARWIDTH_DESC','textbox','int',15),(86,3,2,'avatar_height','_PROFILE_MI_AVATARHEIGHT','80','_PROFILE_MI_AVATARHEIGHT_DESC','textbox','int',16),(87,3,2,'avatar_maxsize','_PROFILE_MI_AVATARMAX','35000','_PROFILE_MI_AVATARMAX_DESC','textbox','int',17),(88,3,1,'self_delete','_PROFILE_MI_SELFDELETE','1','_PROFILE_MI_SELFDELETE_DESC','yesno','int',18),(89,3,2,'avatar_minposts','_PROFILE_MI_AVATARMINPOSTS','0','_PROFILE_MI_AVATARMINPOSTS_DESC','textbox','int',19),(90,3,1,'allow_chgmail','_PROFILE_MI_ALLOWCHGMAIL','1','_PROFILE_MI_ALLOWCHGMAIL_DESC','yesno','int',20),(91,3,1,'allowed_groups','_PROFILE_MI_ALLOWVIEWACC','a:2:{i:0;s:1:\"2\";i:1;s:1:\"1\";}','_PROFILE_MI_ALLOWVIEWACC_DESC','group_multi','array',21);
/*!40000 ALTER TABLE `xoops__config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__configcategory`
--
DROP TABLE IF EXISTS `xoops__configcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__configcategory` (
`confcat_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`confcat_modid` smallint(5) unsigned NOT NULL DEFAULT '0',
`confcat_name` varchar(25) NOT NULL DEFAULT '',
`confcat_order` smallint(5) unsigned NOT NULL DEFAULT '0',
`confcat_nameid` varchar(255) NOT NULL DEFAULT '',
`confcat_description` text NOT NULL,
PRIMARY KEY (`confcat_id`,`confcat_modid`),
KEY `module` (`confcat_modid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__configcategory`
--
LOCK TABLES `xoops__configcategory` WRITE;
/*!40000 ALTER TABLE `xoops__configcategory` DISABLE KEYS */;
INSERT INTO `xoops__configcategory` VALUES (1,1,'_MD_AM_GENERAL',1,'general',''),(3,1,'_MD_AM_METAFOOTER',3,'meta',''),(4,1,'_MD_AM_CENSOR',4,'censor',''),(5,1,'_MD_AM_SEARCH',5,'search',''),(6,1,'_MD_AM_MAILER',6,'mail',''),(7,1,'_MD_AM_AUTHENTICATION',7,'auth',''),(0,2,'_MD_AM_MODULEPREF',0,'xoops_default',''),(1,3,'_PROFILE_MI_CAT_SETTINGS',1,'settings','_PROFILE_MI_CAT_SETTINGS_DSC'),(2,3,'_PROFILE_MI_CAT_USER',2,'user','_PROFILE_MI_CAT_USER_DSC');
/*!40000 ALTER TABLE `xoops__configcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__configoption`
--
DROP TABLE IF EXISTS `xoops__configoption`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__configoption` (
`confop_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`confop_name` varchar(255) NOT NULL DEFAULT '',
`confop_value` varchar(255) NOT NULL DEFAULT '',
`conf_id` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`confop_id`),
KEY `conf_id` (`conf_id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__configoption`
--
LOCK TABLES `xoops__configoption` WRITE;
/*!40000 ALTER TABLE `xoops__configoption` DISABLE KEYS */;
INSERT INTO `xoops__configoption` VALUES (1,'_MD_AM_DEBUGMODE0','0',19),(2,'_MD_AM_DEBUGMODE1','1',19),(3,'_MD_AM_DEBUGMODE2','2',19),(4,'_MD_AM_DEBUGMODE3','3',19),(5,'_NESTED','nest',28),(6,'_FLAT','flat',28),(7,'_THREADED','thread',28),(8,'_OLDESTFIRST','0',29),(9,'_NEWESTFIRST','1',29),(10,'_MD_AM_METAOGEN','general',38),(11,'_MD_AM_METAO14YRS','14 years',38),(12,'_MD_AM_METAOREST','restricted',38),(13,'0','_MD_AM_METAOMAT',38),(14,'1','mature',38),(15,'_MD_AM_INDEXFOLLOW','index,follow',42),(16,'_MD_AM_NOINDEXFOLLOW','noindex,follow',42),(17,'_MD_AM_INDEXNOFOLLOW','index,nofollow',42),(18,'_MD_AM_NOINDEXNOFOLLOW','noindex,nofollow',42),(19,'PHP mail()','mail',45),(20,'sendmail','sendmail',45),(21,'SMTP','smtp',45),(22,'SMTPAuth','smtpauth',45),(23,'XOOPS','xoops',53),(24,'LDAP','ldap',53),(25,'_PROFILE_MI_USERACTV','0',80),(26,'_PROFILE_MI_AUTOACTV','1',80),(27,'_PROFILE_MI_ADMINACTV','2',80),(28,'_PROFILE_MI_STRICT','0',82),(29,'_PROFILE_MI_MEDIUM','1',82),(30,'_PROFILE_MI_LIGHT','2',82);
/*!40000 ALTER TABLE `xoops__configoption` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__group_permission`
--
DROP TABLE IF EXISTS `xoops__group_permission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__group_permission` (
`gperm_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`gperm_groupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`gperm_itemid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`gperm_modid` mediumint(5) unsigned NOT NULL DEFAULT '0',
`gperm_name` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`gperm_id`),
KEY `groupid` (`gperm_groupid`),
KEY `itemid` (`gperm_itemid`),
KEY `gperm_modid` (`gperm_modid`,`gperm_name`(10))
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__group_permission`
--
LOCK TABLES `xoops__group_permission` WRITE;
/*!40000 ALTER TABLE `xoops__group_permission` DISABLE KEYS */;
INSERT INTO `xoops__group_permission` VALUES (1,1,1,1,'module_admin'),(2,1,1,1,'module_read'),(3,2,1,1,'module_read'),(4,3,1,1,'module_read'),(5,1,1,1,'system_admin'),(6,1,2,1,'system_admin'),(7,1,3,1,'system_admin'),(8,1,4,1,'system_admin'),(9,1,5,1,'system_admin'),(10,1,6,1,'system_admin'),(11,1,7,1,'system_admin'),(12,1,8,1,'system_admin'),(13,1,9,1,'system_admin'),(14,1,10,1,'system_admin'),(15,1,11,1,'system_admin'),(16,1,12,1,'system_admin'),(17,1,13,1,'system_admin'),(18,1,14,1,'system_admin'),(19,1,15,1,'system_admin'),(20,1,1,1,'module_admin'),(21,1,1,1,'module_read'),(22,2,1,1,'module_read'),(23,3,1,1,'module_read'),(24,1,1,1,'block_read'),(25,2,1,1,'block_read'),(26,3,1,1,'block_read'),(27,1,2,1,'block_read'),(28,2,2,1,'block_read'),(29,3,2,1,'block_read'),(30,1,3,1,'block_read'),(31,2,3,1,'block_read'),(32,3,3,1,'block_read'),(33,1,2,1,'module_admin'),(34,1,2,1,'module_read'),(35,2,2,1,'module_read'),(36,3,2,1,'module_read'),(37,2,14,3,'profile_show'),(38,2,14,3,'profile_edit'),(39,2,15,3,'profile_show'),(40,2,15,3,'profile_edit'),(41,2,16,3,'profile_show'),(42,2,16,3,'profile_edit'),(43,2,17,3,'profile_show'),(44,2,17,3,'profile_edit'),(45,2,18,3,'profile_edit'),(46,2,19,3,'profile_show'),(47,2,19,3,'profile_edit'),(48,2,20,3,'profile_show'),(49,2,20,3,'profile_edit'),(50,2,21,3,'profile_show'),(51,2,21,3,'profile_edit'),(52,2,22,3,'profile_show'),(53,2,22,3,'profile_edit'),(54,2,23,3,'profile_show'),(55,2,23,3,'profile_edit'),(56,2,24,3,'profile_show'),(57,2,24,3,'profile_edit'),(58,1,3,1,'module_admin'),(59,1,3,1,'module_read'),(60,2,3,1,'module_read'),(61,3,3,1,'module_read');
/*!40000 ALTER TABLE `xoops__group_permission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__groups`
--
DROP TABLE IF EXISTS `xoops__groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__groups` (
`groupid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`description` text NOT NULL,
`group_type` varchar(10) NOT NULL DEFAULT '',
PRIMARY KEY (`groupid`),
KEY `group_type` (`group_type`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__groups`
--
LOCK TABLES `xoops__groups` WRITE;
/*!40000 ALTER TABLE `xoops__groups` DISABLE KEYS */;
INSERT INTO `xoops__groups` VALUES (1,'Webmasters','Webmasters of this site','Admin'),(2,'Registered Users','Registered Users Group','User'),(3,'Anonymous Users','Anonymous Users Group','Anonymous');
/*!40000 ALTER TABLE `xoops__groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__groups_users_link`
--
DROP TABLE IF EXISTS `xoops__groups_users_link`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__groups_users_link` (
`linkid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`groupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`linkid`),
KEY `groupid_uid` (`groupid`,`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__groups_users_link`
--
LOCK TABLES `xoops__groups_users_link` WRITE;
/*!40000 ALTER TABLE `xoops__groups_users_link` DISABLE KEYS */;
INSERT INTO `xoops__groups_users_link` VALUES (1,1,1),(2,2,1);
/*!40000 ALTER TABLE `xoops__groups_users_link` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__image`
--
DROP TABLE IF EXISTS `xoops__image`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__image` (
`image_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`image_name` varchar(30) NOT NULL DEFAULT '',
`image_nicename` varchar(255) NOT NULL DEFAULT '',
`image_mimetype` varchar(30) NOT NULL DEFAULT '',
`image_created` int(10) unsigned NOT NULL DEFAULT '0',
`image_display` tinyint(1) unsigned NOT NULL DEFAULT '0',
`image_weight` smallint(5) unsigned NOT NULL DEFAULT '0',
`imgcat_id` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`image_id`),
KEY `imgcat_id` (`imgcat_id`),
KEY `image_display` (`image_display`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__image`
--
LOCK TABLES `xoops__image` WRITE;
/*!40000 ALTER TABLE `xoops__image` DISABLE KEYS */;
/*!40000 ALTER TABLE `xoops__image` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__imagebody`
--
DROP TABLE IF EXISTS `xoops__imagebody`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__imagebody` (
`image_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`image_body` mediumblob,
KEY `image_id` (`image_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__imagebody`
--
LOCK TABLES `xoops__imagebody` WRITE;
/*!40000 ALTER TABLE `xoops__imagebody` DISABLE KEYS */;
/*!40000 ALTER TABLE `xoops__imagebody` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__imagecategory`
--
DROP TABLE IF EXISTS `xoops__imagecategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__imagecategory` (
`imgcat_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`imgcat_name` varchar(100) NOT NULL DEFAULT '',
`imgcat_maxsize` int(8) unsigned NOT NULL DEFAULT '0',
`imgcat_maxwidth` smallint(3) unsigned NOT NULL DEFAULT '0',
`imgcat_maxheight` smallint(3) unsigned NOT NULL DEFAULT '0',
`imgcat_display` tinyint(1) unsigned NOT NULL DEFAULT '0',
`imgcat_weight` smallint(3) unsigned NOT NULL DEFAULT '0',
`imgcat_type` char(1) NOT NULL DEFAULT '',
`imgcat_storetype` varchar(5) NOT NULL DEFAULT '',
PRIMARY KEY (`imgcat_id`),
KEY `imgcat_display` (`imgcat_display`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__imagecategory`
--
LOCK TABLES `xoops__imagecategory` WRITE;
/*!40000 ALTER TABLE `xoops__imagecategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `xoops__imagecategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__imgset`
--
DROP TABLE IF EXISTS `xoops__imgset`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__imgset` (
`imgset_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`imgset_name` varchar(50) NOT NULL DEFAULT '',
`imgset_refid` mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`imgset_id`),
KEY `imgset_refid` (`imgset_refid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__imgset`
--
LOCK TABLES `xoops__imgset` WRITE;
/*!40000 ALTER TABLE `xoops__imgset` DISABLE KEYS */;
INSERT INTO `xoops__imgset` VALUES (1,'default',0);
/*!40000 ALTER TABLE `xoops__imgset` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__imgset_tplset_link`
--
DROP TABLE IF EXISTS `xoops__imgset_tplset_link`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__imgset_tplset_link` (
`imgset_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`tplset_name` varchar(50) NOT NULL DEFAULT '',
KEY `tplset_name` (`tplset_name`(10))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__imgset_tplset_link`
--
LOCK TABLES `xoops__imgset_tplset_link` WRITE;
/*!40000 ALTER TABLE `xoops__imgset_tplset_link` DISABLE KEYS */;
INSERT INTO `xoops__imgset_tplset_link` VALUES (1,'default');
/*!40000 ALTER TABLE `xoops__imgset_tplset_link` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__imgsetimg`
--
DROP TABLE IF EXISTS `xoops__imgsetimg`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__imgsetimg` (
`imgsetimg_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`imgsetimg_file` varchar(50) NOT NULL DEFAULT '',
`imgsetimg_body` blob NOT NULL,
`imgsetimg_imgset` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`imgsetimg_id`),
KEY `imgsetimg_imgset` (`imgsetimg_imgset`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__imgsetimg`
--
LOCK TABLES `xoops__imgsetimg` WRITE;
/*!40000 ALTER TABLE `xoops__imgsetimg` DISABLE KEYS */;
/*!40000 ALTER TABLE `xoops__imgsetimg` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__modules`
--
DROP TABLE IF EXISTS `xoops__modules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__modules` (
`mid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL DEFAULT '',
`version` smallint(5) unsigned NOT NULL DEFAULT '100',
`last_update` int(10) unsigned NOT NULL DEFAULT '0',
`weight` smallint(3) unsigned NOT NULL DEFAULT '0',
`isactive` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dirname` varchar(25) NOT NULL DEFAULT '',
`hasmain` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hasadmin` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hassearch` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hasconfig` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hascomments` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hasnotification` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`mid`),
KEY `hasmain` (`hasmain`),
KEY `hasadmin` (`hasadmin`),
KEY `hassearch` (`hassearch`),
KEY `hasnotification` (`hasnotification`),
KEY `dirname` (`dirname`),
KEY `name` (`name`(15))
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__modules`
--
LOCK TABLES `xoops__modules` WRITE;
/*!40000 ALTER TABLE `xoops__modules` DISABLE KEYS */;
INSERT INTO `xoops__modules` VALUES (1,'System',213,1149505020,1,1,'system',0,1,0,1,0,0),(2,'Private Messaging',10,1149505033,1,1,'pm',1,1,0,1,0,0),(3,'Extended Profiles',10,1149505034,1,1,'profile',1,1,0,1,0,0);
/*!40000 ALTER TABLE `xoops__modules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__newblocks`
--
DROP TABLE IF EXISTS `xoops__newblocks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__newblocks` (
`bid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`mid` smallint(5) unsigned NOT NULL DEFAULT '0',
`options` varchar(255) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`c_type` char(1) NOT NULL DEFAULT '',
`isactive` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dirname` varchar(50) NOT NULL DEFAULT '',
`func_file` varchar(50) NOT NULL DEFAULT '',
`show_func` varchar(50) NOT NULL DEFAULT '',
`edit_func` varchar(50) NOT NULL DEFAULT '',
`template` varchar(50) NOT NULL DEFAULT '',
`last_modified` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`bid`),
KEY `mid` (`mid`),
KEY `active` (`bid`,`isactive`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__newblocks`
--
LOCK TABLES `xoops__newblocks` WRITE;
/*!40000 ALTER TABLE `xoops__newblocks` DISABLE KEYS */;
INSERT INTO `xoops__newblocks` VALUES (1,1,'a:1:{i:0;s:0:\"\";}','User Menu','',1,'system','system_blocks.php','b_system_user_show','','system_block_user.html',1149505020),(2,1,'a:1:{i:0;s:0:\"\";}','Login','',1,'system','system_blocks.php','b_system_login_show','','system_block_login.html',1149505020),(3,1,'a:1:{i:0;s:0:\"\";}','Search','',1,'system','system_blocks.php','b_system_search_show','','system_block_search.html',1149505020),(4,1,'a:1:{i:0;s:0:\"\";}','Waiting Contents','',1,'system','system_blocks.php','b_system_waiting_show','','system_block_waiting.html',1149505020),(5,1,'a:1:{i:0;s:0:\"\";}','Main Menu','',1,'system','system_blocks.php','b_system_main_show','','system_block_mainmenu.html',1149505020),(6,1,'a:4:{i:0;s:3:\"320\";i:1;s:3:\"190\";i:2;s:15:\"s_poweredby.gif\";i:3;s:1:\"1\";}','Site Info','',1,'system','system_blocks.php','b_system_info_show','b_system_info_edit','system_block_siteinfo.html',1149505020),(7,1,'a:1:{i:0;s:0:\"\";}','Who\'s Online','',1,'system','system_blocks.php','b_system_online_show','','system_block_online.html',1149505020),(8,1,'a:2:{i:0;s:2:\"10\";i:1;s:1:\"1\";}','Top Posters','',1,'system','system_blocks.php','b_system_topposters_show','b_system_topposters_edit','system_block_topusers.html',1149505020),(9,1,'a:2:{i:0;s:2:\"10\";i:1;s:1:\"1\";}','New Members','',1,'system','system_blocks.php','b_system_newmembers_show','b_system_newmembers_edit','system_block_newusers.html',1149505020),(10,1,'a:1:{i:0;s:2:\"10\";}','Recent Comments','',1,'system','system_blocks.php','b_system_comments_show','b_system_comments_edit','system_block_comments.html',1149505020),(11,1,'a:1:{i:0;s:0:\"\";}','Notification Options','',1,'system','system_blocks.php','b_system_notification_show','','system_block_notification.html',1149505020),(12,1,'a:2:{i:0;s:1:\"0\";i:1;s:2:\"80\";}','Themes','',1,'system','system_blocks.php','b_system_themes_show','b_system_themes_edit','system_block_themes.html',1149505020),(13,1,'a:2:{i:0;s:0:\"\";i:1;s:1:\"1\";}','Custom Block','',1,'system','system_blocks.php','b_system_custom_show','b_system_custom_edit','system_block_dummy.html',1149505020);
/*!40000 ALTER TABLE `xoops__newblocks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__online`
--
DROP TABLE IF EXISTS `xoops__online`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__online` (
`online_uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`online_uname` varchar(25) NOT NULL DEFAULT '',
`online_updated` int(10) unsigned NOT NULL DEFAULT '0',
`online_module` smallint(5) unsigned NOT NULL DEFAULT '0',
`online_ip` varchar(15) NOT NULL DEFAULT '',
KEY `online_module` (`online_module`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__online`
--
LOCK TABLES `xoops__online` WRITE;
/*!40000 ALTER TABLE `xoops__online` DISABLE KEYS */;
/*!40000 ALTER TABLE `xoops__online` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__priv_msgs`
--
DROP TABLE IF EXISTS `xoops__priv_msgs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__priv_msgs` (
`msg_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`msg_image` varchar(100) DEFAULT NULL,
`subject` varchar(255) NOT NULL DEFAULT '',
`from_userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`to_userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`msg_time` int(10) unsigned NOT NULL DEFAULT '0',
`msg_text` text NOT NULL,
`read_msg` tinyint(1) unsigned NOT NULL DEFAULT '0',
`from_delete` tinyint(1) unsigned NOT NULL DEFAULT '0',
`from_save` tinyint(1) unsigned NOT NULL DEFAULT '0',
`to_delete` tinyint(1) unsigned NOT NULL DEFAULT '0',
`to_save` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`msg_id`),
KEY `to_userid` (`to_userid`),
KEY `inbox` (`to_userid`,`read_msg`),
KEY `outbox` (`from_userid`,`read_msg`),
KEY `prune` (`msg_time`,`read_msg`,`from_save`,`to_delete`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__priv_msgs`
--
LOCK TABLES `xoops__priv_msgs` WRITE;
/*!40000 ALTER TABLE `xoops__priv_msgs` DISABLE KEYS */;
/*!40000 ALTER TABLE `xoops__priv_msgs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__profile_category`
--
DROP TABLE IF EXISTS `xoops__profile_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__profile_category` (
`catid` int(12) unsigned NOT NULL AUTO_INCREMENT,
`cat_title` varchar(255) NOT NULL DEFAULT '',
`cat_description` text NOT NULL,
`cat_weight` tinyint(4) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__profile_category`
--
LOCK TABLES `xoops__profile_category` WRITE;
/*!40000 ALTER TABLE `xoops__profile_category` DISABLE KEYS */;
/*!40000 ALTER TABLE `xoops__profile_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__profile_fieldcategory`
--
DROP TABLE IF EXISTS `xoops__profile_fieldcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__profile_fieldcategory` (
`fieldid` int(12) unsigned NOT NULL DEFAULT '0',
`catid` int(12) unsigned NOT NULL DEFAULT '0',
`field_weight` tinyint(6) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`fieldid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__profile_fieldcategory`
--
LOCK TABLES `xoops__profile_fieldcategory` WRITE;
/*!40000 ALTER TABLE `xoops__profile_fieldcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `xoops__profile_fieldcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__ranks`
--
DROP TABLE IF EXISTS `xoops__ranks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__ranks` (
`rank_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`rank_title` varchar(50) NOT NULL DEFAULT '',
`rank_min` mediumint(8) unsigned NOT NULL DEFAULT '0',
`rank_max` mediumint(8) unsigned NOT NULL DEFAULT '0',
`rank_special` tinyint(1) unsigned NOT NULL DEFAULT '0',
`rank_image` varchar(255) DEFAULT NULL,
PRIMARY KEY (`rank_id`),
KEY `rank_min` (`rank_min`),
KEY `rank_max` (`rank_max`),
KEY `rankminrankmaxranspecial` (`rank_min`,`rank_max`,`rank_special`),
KEY `rankspecial` (`rank_special`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__ranks`
--
LOCK TABLES `xoops__ranks` WRITE;
/*!40000 ALTER TABLE `xoops__ranks` DISABLE KEYS */;
INSERT INTO `xoops__ranks` VALUES (1,'Just popping in',0,20,0,'rank3e632f95e81ca.gif'),(2,'Not too shy to talk',21,40,0,'rank3dbf8e94a6f72.gif'),(3,'Quite a regular',41,70,0,'rank3dbf8e9e7d88d.gif'),(4,'Just can\'t stay away',71,150,0,'rank3dbf8ea81e642.gif'),(5,'Home away from home',151,10000,0,'rank3dbf8eb1a72e7.gif'),(6,'Moderator',0,0,1,'rank3dbf8edf15093.gif'),(7,'Webmaster',0,0,1,'rank3dbf8ee8681cd.gif');
/*!40000 ALTER TABLE `xoops__ranks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__session`
--
DROP TABLE IF EXISTS `xoops__session`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__session` (
`sess_id` varchar(32) NOT NULL DEFAULT '',
`sess_updated` int(10) unsigned NOT NULL DEFAULT '0',
`sess_ip` varchar(15) NOT NULL DEFAULT '',
`sess_data` mediumblob NOT NULL,
PRIMARY KEY (`sess_id`),
KEY `updated` (`sess_updated`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__session`
--
LOCK TABLES `xoops__session` WRITE;
/*!40000 ALTER TABLE `xoops__session` DISABLE KEYS */;
INSERT INTO `xoops__session` VALUES ('b98a7f997581c0790bfe29f8fdf0a659',1149511927,'62.178.39.180',''),('65db19e42030952d8bef5a1c6b8fd3c3',1162117648,'62.178.39.180','xoopsUserId|s:1:\"1\";xoopsUserGroups|a:2:{i:0;s:1:\"1\";i:1;s:1:\"2\";}xoopsUserLastLogin|s:10:\"1149505099\";'),('0f11fbae395ea7a25241b1d1ffd0e6cf',1162118336,'62.178.39.180',''),('d7388390237cf1c89732a424319e146f',1162142940,'62.178.39.180',''),('8ffefe87c25b583a72586bbe1cc97c77',1163279205,'62.178.39.180',''),('a02113ff7a44f22323573079a9becab0',1165361762,'62.178.39.180',''),('1a8ee54c7ce8a4e8002bb90dd3921545',1209532633,'84.112.198.40',''),('1467b09259528ef66ddddfe923000293',1244788863,'84.112.198.40',''),('a24ceb3bce95bf75cb0ca2f6e9d25bed',1251218548,'193.80.57.6',''),('3cc6081d62412690417d52acb48bedac',1254849042,'193.80.57.6',''),('4404c3dc5c24be1fe4e465ffc69af352',1308780561,'80.109.8.108',''),('8591d7a9095640da051e84da9e7ef2be',1310587225,'80.108.9.245',''),('d8dd89d81e35838327b836bf57dc5121',1310690816,'80.109.8.108',''),('dd5840328db98f9d80bb1155e209347d',1344320655,'80.108.9.245','');
/*!40000 ALTER TABLE `xoops__session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__smiles`
--
DROP TABLE IF EXISTS `xoops__smiles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__smiles` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(50) NOT NULL DEFAULT '',
`smile_url` varchar(100) NOT NULL DEFAULT '',
`emotion` varchar(75) NOT NULL DEFAULT '',
`display` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__smiles`
--
LOCK TABLES `xoops__smiles` WRITE;
/*!40000 ALTER TABLE `xoops__smiles` DISABLE KEYS */;
INSERT INTO `xoops__smiles` VALUES (1,':-D','smil3dbd4d4e4c4f2.gif','Very Happy',1),(2,':-)','smil3dbd4d6422f04.gif','Smile',1),(3,':-(','smil3dbd4d75edb5e.gif','Sad',1),(4,':-o','smil3dbd4d8676346.gif','Surprised',1),(5,':-?','smil3dbd4d99c6eaa.gif','Confused',1),(6,'8-)','smil3dbd4daabd491.gif','Cool',1),(7,':lol:','smil3dbd4dbc14f3f.gif','Laughing',1),(8,':-x','smil3dbd4dcd7b9f4.gif','Mad',1),(9,':-P','smil3dbd4ddd6835f.gif','Razz',1),(10,':oops:','smil3dbd4df1944ee.gif','Embaressed',0),(11,':cry:','smil3dbd4e02c5440.gif','Crying (very sad)',0),(12,':evil:','smil3dbd4e1748cc9.gif','Evil or Very Mad',0),(13,':roll:','smil3dbd4e29bbcc7.gif','Rolling Eyes',0),(14,';-)','smil3dbd4e398ff7b.gif','Wink',0),(15,':pint:','smil3dbd4e4c2e742.gif','Another pint of beer',0),(16,':hammer:','smil3dbd4e5e7563a.gif','ToolTimes at work',0),(17,':idea:','smil3dbd4e7853679.gif','I have an idea',0);
/*!40000 ALTER TABLE `xoops__smiles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__tplfile`
--
DROP TABLE IF EXISTS `xoops__tplfile`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__tplfile` (
`tpl_id` mediumint(7) unsigned NOT NULL AUTO_INCREMENT,
`tpl_refid` smallint(5) unsigned NOT NULL DEFAULT '0',
`tpl_module` varchar(25) NOT NULL DEFAULT '',
`tpl_tplset` varchar(50) NOT NULL DEFAULT '',
`tpl_file` varchar(50) NOT NULL DEFAULT '',
`tpl_desc` varchar(255) NOT NULL DEFAULT '',
`tpl_lastmodified` int(10) unsigned NOT NULL DEFAULT '0',
`tpl_lastimported` int(10) unsigned NOT NULL DEFAULT '0',
`tpl_type` varchar(20) NOT NULL DEFAULT '',
PRIMARY KEY (`tpl_id`),
KEY `tpl_refid` (`tpl_refid`,`tpl_type`),
KEY `tpl_tplset` (`tpl_tplset`,`tpl_file`(10))
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__tplfile`
--
LOCK TABLES `xoops__tplfile` WRITE;
/*!40000 ALTER TABLE `xoops__tplfile` DISABLE KEYS */;
INSERT INTO `xoops__tplfile` VALUES (1,1,'system','default','system_imagemanager.html','',1149505020,0,'module'),(2,1,'system','default','system_imagemanager2.html','',1149505020,0,'module'),(3,1,'system','default','system_userinfo.html','',1149505020,0,'module'),(4,1,'system','default','system_userform.html','',1149505020,0,'module'),(5,1,'system','default','system_rss.html','',1149505020,0,'module'),(6,1,'system','default','system_redirect.html','',1149505020,0,'module'),(7,1,'system','default','system_comment.html','',1149505020,0,'module'),(8,1,'system','default','system_comments_flat.html','',1149505020,0,'module'),(9,1,'system','default','system_comments_thread.html','',1149505020,0,'module'),(10,1,'system','default','system_comments_nest.html','',1149505020,0,'module'),(11,1,'system','default','system_siteclosed.html','',1149505020,0,'module'),(12,1,'system','default','system_dummy.html','Dummy template file for holding non-template contents. This should not be edited.',1149505020,0,'module'),(13,1,'system','default','system_notification_list.html','',1149505020,0,'module'),(14,1,'system','default','system_notification_select.html','',1149505020,0,'module'),(15,1,'system','default','system_error.html','Template for error pages',1149505020,0,'module'),(16,1,'system','default','system_plain.html','Plain template for displaying only page content (no logo, no banner, no blocks)',1149505020,0,'module'),(17,1,'system','default','system_admin_block.html','Blocks Administration Template',1149505020,0,'module'),(18,1,'system','default','system_block_user.html','Shows user block',1149505020,0,'block'),(19,2,'system','default','system_block_login.html','Shows login form',1149505020,0,'block'),(20,3,'system','default','system_block_search.html','Shows search form block',1149505020,0,'block'),(21,4,'system','default','system_block_waiting.html','Shows contents waiting for approval',1149505020,0,'block'),(22,5,'system','default','system_block_mainmenu.html','Shows the main navigation menu of the site',1149505020,0,'block'),(23,6,'system','default','system_block_siteinfo.html','Shows basic info about the site and a link to Recommend Us pop up window',1149505020,0,'block'),(24,7,'system','default','system_block_online.html','Displays users/guests currently online',1149505020,0,'block'),(25,8,'system','default','system_block_topusers.html','Top posters',1149505020,0,'block'),(26,9,'system','default','system_block_newusers.html','Shows most recent users',1149505020,0,'block'),(27,10,'system','default','system_block_comments.html','Shows most recent comments',1149505020,0,'block'),(28,11,'system','default','system_block_notification.html','Shows notification options',1149505020,0,'block'),(29,12,'system','default','system_block_themes.html','Shows theme selection box',1149505020,0,'block'),(30,13,'system','default','system_block_dummy.html','Custom block for manual content input',1149505020,0,'block'),(31,2,'pm','default','pm_pmlite.html','',1149505033,0,'module'),(32,2,'pm','default','pm_readpmsg.html','',1149505033,0,'module'),(33,2,'pm','default','pm_lookup.html','',1149505033,0,'module'),(34,2,'pm','default','pm_viewpmsg.html','',1149505033,0,'module'),(35,3,'profile','default','profile_admin_fieldlist.html','',1149505034,0,'module'),(36,3,'profile','default','profile_userinfo.html','',1149505034,0,'module'),(37,3,'profile','default','profile_admin_categorylist.html','',1149505034,0,'module'),(38,3,'profile','default','profile_search.html','',1149505034,0,'module'),(39,3,'profile','default','profile_results.html','',1149505034,0,'module');
/*!40000 ALTER TABLE `xoops__tplfile` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__tplset`
--
DROP TABLE IF EXISTS `xoops__tplset`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__tplset` (
`tplset_id` int(7) unsigned NOT NULL AUTO_INCREMENT,
`tplset_name` varchar(50) NOT NULL DEFAULT '',
`tplset_desc` varchar(255) NOT NULL DEFAULT '',
`tplset_credits` text NOT NULL,
`tplset_created` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`tplset_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__tplset`
--
LOCK TABLES `xoops__tplset` WRITE;
/*!40000 ALTER TABLE `xoops__tplset` DISABLE KEYS */;
INSERT INTO `xoops__tplset` VALUES (1,'default','XOOPS Default Template Set','',1149505020);
/*!40000 ALTER TABLE `xoops__tplset` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__tplsource`
--
DROP TABLE IF EXISTS `xoops__tplsource`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__tplsource` (
`tpl_id` mediumint(7) unsigned NOT NULL DEFAULT '0',
`tpl_source` mediumtext NOT NULL,
KEY `tpl_id` (`tpl_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__tplsource`
--
LOCK TABLES `xoops__tplsource` WRITE;
/*!40000 ALTER TABLE `xoops__tplsource` DISABLE KEYS */;
INSERT INTO `xoops__tplsource` VALUES (1,'\r\n\" lang=\"<{$xoops_langcode}>\">\r\n\r\n\" />\r\n\" />\r\n<{$sitename}> <{$lang_imgmanager}>\r\n\r\n\r\n\r\n\r\n\r\n, <{$ysize}>);\">\r\n \r\n\r\n \r\n\r\n <{if $image_total > 0}>\r\n\r\n \r\n\r\n <{/if}>\r\n\r\n <{$pagenav}>
\r\n\r\n \r\n\r\n \r\n'),(2,'\r\n\" lang=\"<{$xoops_langcode}>\">\r\n\r\n\" />\r\n\" />\r\n<{$xoops_sitename}> <{$lang_imgmanager}>\r\n<{$image_form.javascript}>\r\n\r\n\r\n\r\n, <{$ysize}>);\">\r\n \r\n\r\n \r\n\r\n \r\n\r\n\r\n \r\n\r\n \r\n'),(3,'<{if $user_ownpage == true}>\r\n\r\n\r\n\r\n
\r\n<{elseif $xoops_isadmin != false}>\r\n\r\n
\r\n\r\n\r\n\r\n
\r\n<{/if}>\r\n\r\n\r\n \r\n \r\n \r\n \r\n | <{$lang_allaboutuser}> | \r\n \r\n \r\n | <{$lang_avatar}> | \r\n ![](\"<{$user_avatarurl}) \" alt=\"Avatar\" /> | \r\n \r\n \r\n | <{$lang_realname}> | \r\n <{$user_realname}> | \r\n \r\n \r\n | <{$lang_website}> | \r\n <{$user_websiteurl}> | \r\n \r\n \r\n | <{$lang_email}> | \r\n <{$user_email}> | \r\n \r\n \r\n | <{$lang_privmsg}> | \r\n <{$user_pmlink}> | \r\n \r\n \r\n | <{$lang_icq}> | \r\n <{$user_icq}> | \r\n \r\n \r\n | <{$lang_aim}> | \r\n <{$user_aim}> | \r\n \r\n \r\n | <{$lang_yim}> | \r\n <{$user_yim}> | \r\n \r\n \r\n | <{$lang_msnm}> | \r\n <{$user_msnm}> | \r\n \r\n \r\n | <{$lang_location}> | \r\n <{$user_location}> | \r\n \r\n \r\n | <{$lang_occupation}> | \r\n <{$user_occupation}> | \r\n \r\n \r\n | <{$lang_interest}> | \r\n <{$user_interest}> | \r\n \r\n \r\n | <{$lang_extrainfo}> | \r\n <{$user_extrainfo}> | \r\n \r\n \r\n | \r\n \r\n \r\n \r\n | <{$lang_statistics}> | \r\n \r\n \r\n | <{$lang_membersince}> | \r\n <{$user_joindate}> | \r\n \r\n \r\n | <{$lang_rank}> | \r\n <{$user_rankimage}>
<{$user_ranktitle}> | \r\n \r\n \r\n | <{$lang_posts}> | \r\n <{$user_posts}> | \r\n \r\n \r\n | <{$lang_lastlogin}> | \r\n <{$user_lastlogin}> | \r\n \r\n \r\n
\r\n \r\n \r\n | <{$lang_signature}> | \r\n \r\n \r\n | <{$user_signature}> | \r\n \r\n \r\n | \r\n
\r\n
\r\n\r\n<{if $fields}>\r\n \r\n \r\n \r\n \r\n <{foreach item=field from=$fields}>\r\n \r\n | <{$field.title}> | \r\n <{$field.value}> | \r\n \r\n <{/foreach}>\r\n \r\n | \r\n
\r\n
\r\n<{/if}>\r\n\r\n\r\n<{foreach item=module from=$modules}>\r\n\r\n\r\n
<{$module.name}>
\r\n\r\n \r\n <{foreach item=result from=$module.results}>\r\n\r\n ![](\"<{$result.image})
\" alt=\"<{$module.name}>\" />\"><{$result.title}>
(<{$result.time}>)
\r\n\r\n <{/foreach}>\r\n \r\n\r\n<{$module.showall_link}>\r\n\r\n\r\n<{/foreach}>\r\n'),(4,'\r\n\r\n
\r\n\r\n\r\n
\r\n/modules/profile/activate.php\" title=\"<{$smarty.const._US_RESENDACTIVATIONMAIL}>\"><{$smarty.const._US_RESENDACTIVATIONMAIL}>'),(5,'\r\n<{if $xoops_rsscss}>\r\n \"?>\r\n<{/if}>\r\n\r\n \r\n <{$channel_title}>\r\n <{$channel_link}>\r\n <{$channel_desc}>\r\n <{$channel_lastbuild}>\r\n http://backend.userland.com/rss/\r\n <{$channel_generator}>\r\n <{$channel_category}>\r\n <{$channel_editor}>\r\n <{$channel_webmaster}>\r\n <{$channel_language}>\r\n <{if $image_url != \"\"}>\r\n \r\n <{$channel_title}>\r\n <{$image_url}>\r\n <{$channel_link}>\r\n <{$image_width}>\r\n <{$image_height}>\r\n \r\n <{/if}>\r\n <{foreach item=item from=$items}>\r\n - \r\n <{$item.title}>\r\n <{$item.link}>\r\n <{$item.description}>\r\n <{$item.pubdate}>\r\n <{$item.guid}>\r\n
\r\n <{/foreach}>\r\n \r\n'),(6,'\r\n
<{$message}>
\r\n
<{$lang_ifnotreload}>
\r\n
\r\n
\r\n
<{$comment.image}><{$comment.title}>
\r\n
\r\n \r\n
\r\n <{$lang_posted}>: <{$comment.date_posted}> <{$lang_updated}>: <{$comment.date_modified}>\r\n
\r\n\r\n <{if $comment.poster.id != 0}>\r\n
\r\n
![](\"<{$xoops_upload_url})
/<{$comment.poster.avatar}>\" alt=\"\" />
\r\n
<{$comment.poster.uname}>\r\n
/<{$comment.poster.rank_image}>\" alt=\"\" />
\r\n
<{$comment.poster.rank_title}>\r\n
<{$lang_joined}>: <{$comment.poster.regdate}>
\r\n
<{$lang_from}>: <{$comment.poster.from}>
\r\n
<{$lang_posts}>: <{$comment.poster.postnum}>
\r\n
<{$comment.poster.status}>\r\n
\r\n <{/if}>\r\n \r\n
\r\n <{$comment.text}>\r\n
\r\n\r\n
\r\n\r\n| \r\n <{foreach item=comment from=$comments}>\r\n <{include file=\"db:system_comment.html\" comment=$comment}>\r\n <{/foreach}>\r\n | \r\n
\r\n
'),(9,'<{section name=i loop=$comments}>\r\n
\r\n\r\n \r\n | \r\n <{include file=\"db:system_comment.html\" comment=$comments[i]}>\r\n | \r\n
\r\n
\r\n\r\n<{if $show_threadnav == true}>\r\n\r\n<{/if}>\r\n\r\n<{if $comments[i].show_replies == true}>\r\n\r\n
\r\n\r\n\r\n<{/if}>\r\n\r\n<{/section}>'),(10,'<{section name=i loop=$comments}>\r\n
\r\n\r\n \r\n | \r\n <{include file=\"db:system_comment.html\" comment=$comments[i]}>\r\n | \r\n
\r\n
\r\n\r\n\r\n<{foreach item=reply from=$comments[i].replies}>\r\n
\r\n\r\n \r\n | \"> | \r\n \r\n \r\n \r\n | \r\n <{include file=\"db:system_comment.html\" comment=$reply}>\r\n | \r\n \r\n \r\n | \r\n
\r\n
\r\n<{/foreach}>\r\n\r\n<{/section}>'),(11,'\r\n \r\n <{$lang_siteclosemsg}> | \r\n
\r\n
\r\n \r\n '),(12,'<{$dummy_content}>'),(13,'<{$lang_activenotifications}>
\r\n'),(14,'<{if $xoops_notification.show}>\r\n\r\n\r\n![](\"<{$xoops_url})
/themes/default/images/plus.gif\" onClick=\"toggle(\'notifs_form\');swapimage(\'swap\');\" />\r\n\r\n<{$lang_notificationoptions}>
\r\n\r\n\r\n<{/if}>'),(15,'<{$errormsg}>
'),(16,'\r\n\" lang=\"<{$xoops_langcode}>\">\r\n\r\n\" />\r\n\" />\r\n\" />\r\n\" />\r\n\" />\r\n\" />\r\n\" />\r\n\" />\r\n\r\n<{$xoops_sitename}> - <{$xoops_pagetitle}>\r\n/xoops.css\" />\r\n\" />\r\n\r\n<{$xoops_module_header}>\r\n\r\n\r\n\r\n \r\n <{$xoops_contents}>\r\n
\r\n\r\n'),(17,'<{$smarty.const._AM_BADMIN}>
\r\n\r\n\r\n \r\n
\r\n\r\n'),(18,''),(19,'\r\n/user.php#lost\"><{$block.lang_lostpass}>\r\n
\r\n/register.php\"><{$block.lang_registernow}>'),(20,'\r\n/search.php\"><{$block.lang_advsearch}>'),(21,''),(22,''),(23,'\r\n\r\n <{if $block.showgroups == true}>\r\n\r\n \r\n <{foreach item=group from=$block.groups}>\r\n \r\n | <{$group.name}> | \r\n
\r\n\r\n \r\n <{foreach item=user from=$group.users}>\r\n \r\n ![](\"<{$user.avatar}) \" alt=\"\" width=\"32\" />
/userinfo.php?uid=<{$user.id}>\"><{$user.name}> | <{$user.msglink}> | \r\n
\r\n <{/foreach}>\r\n \r\n\r\n <{/foreach}>\r\n \r\n <{/if}>\r\n
\r\n\r\n
\r\n\r\n\r\n
![](\"<{$block.logourl})
\" alt=\"\" border=\"0\" />
<{$block.recommendlink}>\r\n
<{$block.lang_members}>: <{$block.online_members}>
<{$block.lang_guests}>: <{$block.online_guests}>
<{$block.online_names}> /misc.php?action=showpopups&type=online\',\'Online\',420,350);\"><{$block.lang_more}>'),(25,'\r\n <{foreach item=user from=$block.users}>\r\n \" valign=\"middle\">\r\n | <{$user.rank}> | \r\n \r\n <{if $user.avatar != \"\"}>\r\n \" alt=\"\" width=\"32\" />
\r\n <{/if}>\r\n /userinfo.php?uid=<{$user.id}>\"><{$user.name}>\r\n | \r\n <{$user.posts}> | \r\n
\r\n <{/foreach}>\r\n
'),(26,'\r\n <{foreach item=user from=$block.users}>\r\n \" valign=\"middle\">\r\n \r\n <{if $user.avatar != \"\"}>\r\n \" alt=\"\" width=\"32\" />
\r\n <{/if}>\r\n /userinfo.php?uid=<{$user.id}>\"><{$user.name}>\r\n | \r\n <{$user.joindate}> | \r\n
\r\n <{/foreach}>\r\n
'),(27,'\r\n <{foreach item=comment from=$block.comments}>\r\n \">\r\n | /images/<{$comment.icon}>\" alt=\"\" /> | \r\n <{$comment.title}> | \r\n <{$comment.module}> | \r\n <{$comment.poster}> | \r\n <{$comment.time}> | \r\n
\r\n <{/foreach}>\r\n
'),(28,''),(29,'\r\n\r\n
'),(30,'<{$block.content}>'),(31,'<{$pmform.javascript}>\r\n'),(32,'\r\n
<{$smarty.const._PM_PRIVATEMESSAGE}>
\r\n
\r\n<{if $op==out}>\r\n <{$smarty.const._PM_OUTBOX}> \r\n<{elseif $op == \"save\"}>\r\n <{$smarty.const._PM_SAVEBOX}> \r\n<{else}>\r\n <{$smarty.const._PM_INBOX}> \r\n<{/if}>\r\n\r\n<{if $message}>\r\n »» <{$message.subject}>
\r\n \r\n<{else}>\r\n
<{$smarty.const._PM_YOUDONTHAVE}>\r\n<{/if}>'),(34,'<{$smarty.const._PM_PRIVATEMESSAGE}>
\r\n\r\n\r\n <{if $op == \"out\"}><{$smarty.const._PM_OUTBOX}>\r\n <{elseif $op == \"save\"}><{$smarty.const._PM_SAVEBOX}>\r\n <{else}><{$smarty.const._PM_INBOX}><{/if}>\r\n
\r\n
\r\n
\r\n<{if $msg}>\r\n <{$msg}>
\r\n<{/if}>\r\n<{if $errormsg}>\r\n <{$errormsg}>
\r\n<{/if}>\r\n<{if $pagenav}>\r\n\r\n<{$pagenav}>\r\n
\r\n
\r\n<{/if}>\r\n\r\n<{if $pagenav}>\r\n\r\n<{$pagenav}>\r\n
\r\n<{/if}>'),(35,'\r\n'),(36,'<{if $user_ownpage == true}>\r\n\r\n \r\n\r\n
\r\n<{elseif $xoops_isadmin != false}>\r\n\r\n
\r\n\r\n \r\n\r\n
\r\n<{/if}>\r\n\r\n<{foreach item=category from=$categories name=catcount}>\r\n <{if isset($category.fields)}>\r\n \r\n
\r\n \r\n | <{$category.cat_title}> | \r\n
\r\n <{foreach item=field from=$category.fields}>\r\n \r\n | <{$field.title}> | \r\n <{$field.value}> | \r\n
\r\n <{/foreach}>\r\n
\r\n
\r\n \r\n <{foreach item=module from=$modules}>\r\n\r\n \r\n
<{$module.name}>
\r\n\r\n \r\n <{foreach item=result from=$module.results}>\r\n\r\n \" alt=\"<{$module.name}>\" /> \"><{$result.title}>
(<{$result.time}>)
\r\n\r\n <{/foreach}>\r\n \r\n\r\n <{$module.showall_link}>\r\n \r\n\r\n <{/foreach}>\r\n \r\n<{/if}>'),(37,'\r\n'),(38,''),(39,'\r\n
\r\n<{if $users}>\r\n \r\n \r\n <{foreach item=caption from=$captions}>\r\n | <{$caption}> | \r\n <{/foreach}>\r\n
\r\n <{foreach item=user from=$users}>\r\n \">\r\n <{foreach item=fieldvalue from=$user.output}>\r\n | <{$fieldvalue}> | \r\n <{/foreach}>\r\n
\r\n <{/foreach}>\r\n
\r\n \r\n <{$nav}>\r\n<{else}>\r\n \r\n <{$smarty.const._PROFILE_MA_NOUSERSFOUND}>\r\n
\r\n<{/if}>');
/*!40000 ALTER TABLE `xoops__tplsource` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__user_profile`
--
DROP TABLE IF EXISTS `xoops__user_profile`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__user_profile` (
`profileid` int(12) unsigned NOT NULL AUTO_INCREMENT,
`umode` text NOT NULL,
`uorder` text NOT NULL,
`notify_method` text NOT NULL,
`notify_mode` text NOT NULL,
`user_regdate` int(10) NOT NULL DEFAULT '0',
`posts` int(10) NOT NULL DEFAULT '0',
`attachsig` int(1) NOT NULL DEFAULT '0',
`timezone_offset` varchar(255) NOT NULL DEFAULT '',
`user_mailok` int(1) NOT NULL DEFAULT '1',
`theme` varchar(255) NOT NULL DEFAULT '',
`actkey` varchar(255) NOT NULL DEFAULT '',
`last_login` int(10) NOT NULL DEFAULT '0',
`pm_link` text NOT NULL,
`user_aim` varchar(255) NOT NULL DEFAULT '',
`user_icq` varchar(255) NOT NULL DEFAULT '',
`user_from` varchar(255) NOT NULL DEFAULT '',
`user_sig` text NOT NULL,
`user_viewemail` int(1) NOT NULL DEFAULT '0',
`user_yim` varchar(255) NOT NULL DEFAULT '',
`user_msnm` varchar(255) NOT NULL DEFAULT '',
`bio` text NOT NULL,
`user_intrest` varchar(150) NOT NULL DEFAULT '',
`user_occ` varchar(100) NOT NULL DEFAULT '',
`url` varchar(100) NOT NULL DEFAULT '',
`newemail` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`profileid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__user_profile`
--
LOCK TABLES `xoops__user_profile` WRITE;
/*!40000 ALTER TABLE `xoops__user_profile` DISABLE KEYS */;
INSERT INTO `xoops__user_profile` VALUES (1,'','','','',1149505021,0,0,'',1,'0','',1162117425,'![\"Write](\"{X_URL}/modules/pm/images/pm.gif\")
','','','','',0,'','','','','','','');
/*!40000 ALTER TABLE `xoops__user_profile` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__user_profile_field`
--
DROP TABLE IF EXISTS `xoops__user_profile_field`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__user_profile_field` (
`fieldid` int(12) unsigned NOT NULL AUTO_INCREMENT,
`field_type` varchar(30) NOT NULL DEFAULT '',
`field_valuetype` tinyint(2) unsigned NOT NULL DEFAULT '0',
`field_name` varchar(255) NOT NULL DEFAULT '',
`field_title` varchar(255) NOT NULL DEFAULT '',
`field_description` text NOT NULL,
`field_required` tinyint(2) unsigned NOT NULL DEFAULT '0',
`field_maxlength` tinyint(6) unsigned NOT NULL DEFAULT '0',
`field_default` text NOT NULL,
`field_moduleid` int(12) unsigned NOT NULL DEFAULT '0',
`field_notnull` tinyint(2) unsigned NOT NULL DEFAULT '0',
`field_edit` tinyint(2) unsigned NOT NULL DEFAULT '0',
`field_show` tinyint(2) unsigned NOT NULL DEFAULT '0',
`field_config` tinyint(2) unsigned NOT NULL DEFAULT '0',
`field_options` text NOT NULL,
`field_register` tinyint(2) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`fieldid`),
UNIQUE KEY `field_name` (`field_name`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__user_profile_field`
--
LOCK TABLES `xoops__user_profile_field` WRITE;
/*!40000 ALTER TABLE `xoops__user_profile_field` DISABLE KEYS */;
INSERT INTO `xoops__user_profile_field` VALUES (1,'select',7,'umode','Comments Display Mode','',0,0,'',1,1,1,0,0,'a:3:{s:4:\"nest\";s:6:\"Nested\";s:4:\"flat\";s:4:\"Flat\";s:6:\"thread\";s:8:\"Threaded\";}',0),(2,'select',7,'uorder','Comments Sort Order','',0,0,'',1,1,1,0,0,'a:2:{i:0;s:12:\"Oldest First\";i:1;s:12:\"Newest First\";}',0),(3,'select',7,'notify_method','Notification Method','When you monitor e.g. a forum, how would you like to receive notifications of updates?',0,0,'',1,1,1,0,0,'a:3:{i:0;s:19:\"Temporarily Disable\";i:1;s:15:\"Private Message\";i:2;s:33:\"Email (use address in my profile)\";}',0),(4,'select',7,'notify_mode','Default Notification Mode','',0,0,'',1,1,1,0,0,'a:3:{i:0;s:33:\"Notify me of all selected updates\";i:1;s:19:\"Notify me only once\";i:2;s:48:\"Notify me once then disable until I log in again\";}',0),(5,'date',3,'user_regdate','Member Since','',0,10,'0',1,1,0,1,0,'a:0:{}',0),(6,'textbox',3,'posts','Posts','',0,10,'0',1,1,0,1,0,'a:0:{}',0),(7,'yesno',3,'attachsig','Always attach my signature','',0,1,'',1,1,1,0,0,'a:0:{}',0),(8,'timezone',1,'timezone_offset','Time Zone','',0,255,'',1,1,1,0,0,'a:0:{}',0),(9,'yesno',3,'user_mailok','Receive occasional email notices?','By enabling this, administrators and moderators are allowed to send you notices occasionally via email',0,1,'1',1,1,1,0,0,'a:0:{}',0),(10,'theme',1,'theme','Theme','',0,255,'0',1,1,1,0,0,'a:0:{}',0),(11,'textbox',1,'actkey','User activation key','',0,255,'',1,1,0,0,0,'a:0:{}',0),(12,'date',3,'last_login','Last Login','',0,10,'',1,1,0,1,0,'a:0:{}',0),(13,'autotext',2,'pm_link','PM Link','Shows a link to send a private message to the user',0,0,'',2,1,0,1,0,'a:0:{}',0),(14,'textbox',1,'user_aim','AIM','America Online Instant Messenger Client ID',0,255,'',3,1,1,1,1,'a:0:{}',0),(15,'textbox',1,'user_icq','ICQ','ICQ Instant Messenger ID',0,255,'',3,1,1,1,1,'a:0:{}',0),(16,'textbox',1,'user_from','Location','',0,255,'',3,1,1,1,1,'a:0:{}',0),(17,'dhtml',2,'user_sig','Signature','Here, you can write a signature that can be displayed in your forum posts, comments etc.',0,0,'',3,1,1,1,1,'a:0:{}',0),(18,'yesno',3,'user_viewemail','Allow other users to view my email address','',0,1,'0',3,1,1,0,0,'a:0:{}',0),(19,'textbox',1,'user_yim','YIM','Yahoo! Instant Messenger ID',0,255,'',3,1,1,1,1,'a:0:{}',0),(20,'textbox',1,'user_msnm','MSN','Microsoft Messenger ID',0,255,'',3,1,1,1,1,'a:0:{}',0),(21,'textarea',2,'bio','Extra Info','',0,0,'',3,1,1,1,1,'a:0:{}',0),(22,'textbox',1,'user_intrest','Interests','',0,150,'',3,1,1,1,1,'a:0:{}',0),(23,'textbox',1,'user_occ','Occupation','',0,100,'',3,1,1,1,1,'a:0:{}',0),(24,'textbox',1,'url','Website','',0,100,'',3,1,1,1,1,'a:0:{}',0),(25,'textbox',1,'newemail','New Email','Variable for storing a proposed new email address until confirmation comes from a mail sent to the old one. See modules/profile/changemail.php',0,100,'',3,1,0,0,0,'a:0:{}',0);
/*!40000 ALTER TABLE `xoops__user_profile_field` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__users`
--
DROP TABLE IF EXISTS `xoops__users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__users` (
`uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uname` varchar(55) NOT NULL DEFAULT '',
`loginname` varchar(25) NOT NULL DEFAULT '',
`name` varchar(75) NOT NULL DEFAULT '',
`email` varchar(60) NOT NULL DEFAULT '',
`user_avatar` varchar(30) NOT NULL DEFAULT 'blank.gif',
`pass` varchar(32) NOT NULL DEFAULT '',
`rank` smallint(5) unsigned NOT NULL DEFAULT '0',
`level` tinyint(3) NOT NULL DEFAULT '1',
PRIMARY KEY (`uid`),
KEY `uname` (`uname`),
KEY `email` (`email`),
KEY `uiduname` (`uid`,`uname`),
KEY `unamepass` (`uname`,`pass`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__users`
--
LOCK TABLES `xoops__users` WRITE;
/*!40000 ALTER TABLE `xoops__users` DISABLE KEYS */;
INSERT INTO `xoops__users` VALUES (1,'Admin','admin','','mam@heimam.at','blank.gif','5a9361b28ee51795f1e82d9054919034',7,5);
/*!40000 ALTER TABLE `xoops__users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__xoopscomments`
--
DROP TABLE IF EXISTS `xoops__xoopscomments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__xoopscomments` (
`com_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`com_pid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`com_rootid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`com_modid` smallint(5) unsigned NOT NULL DEFAULT '0',
`com_itemid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`com_icon` varchar(25) NOT NULL DEFAULT '',
`com_created` int(10) unsigned NOT NULL DEFAULT '0',
`com_modified` int(10) unsigned NOT NULL DEFAULT '0',
`com_uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`com_ip` varchar(15) NOT NULL DEFAULT '',
`com_title` varchar(255) NOT NULL DEFAULT '',
`com_text` text NOT NULL,
`com_sig` tinyint(1) unsigned NOT NULL DEFAULT '0',
`com_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`com_exparams` varchar(255) NOT NULL DEFAULT '',
`dohtml` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dosmiley` tinyint(1) unsigned NOT NULL DEFAULT '0',
`doxcode` tinyint(1) unsigned NOT NULL DEFAULT '0',
`doimage` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dobr` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`com_id`),
KEY `com_pid` (`com_pid`),
KEY `com_itemid` (`com_itemid`),
KEY `com_uid` (`com_uid`),
KEY `com_title` (`com_title`(40))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__xoopscomments`
--
LOCK TABLES `xoops__xoopscomments` WRITE;
/*!40000 ALTER TABLE `xoops__xoopscomments` DISABLE KEYS */;
/*!40000 ALTER TABLE `xoops__xoopscomments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xoops__xoopsnotifications`
--
DROP TABLE IF EXISTS `xoops__xoopsnotifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xoops__xoopsnotifications` (
`not_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`not_modid` smallint(5) unsigned NOT NULL DEFAULT '0',
`not_itemid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`not_category` varchar(30) NOT NULL DEFAULT '',
`not_event` varchar(30) NOT NULL DEFAULT '',
`not_uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`not_mode` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`not_id`),
KEY `not_modid` (`not_modid`),
KEY `not_itemid` (`not_itemid`),
KEY `not_class` (`not_category`),
KEY `not_uid` (`not_uid`),
KEY `not_event` (`not_event`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xoops__xoopsnotifications`
--
LOCK TABLES `xoops__xoopsnotifications` WRITE;
/*!40000 ALTER TABLE `xoops__xoopsnotifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `xoops__xoopsnotifications` 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 2017-01-26 8:04:13