[0] Fix | Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

--

[10] Fix | Delete

-- Database: `xoops2510`

[11] Fix | Delete

--

[12] Fix | Delete

[13] Fix | Delete

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

[14] Fix | Delete

[15] Fix | Delete

--

[16] Fix | Delete

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

[17] Fix | Delete

--

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `[[dbprefix]]_avatar` (

[20] Fix | Delete

`avatar_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`avatar_file` varchar(30) NOT NULL DEFAULT '',

[22] Fix | Delete

`avatar_name` varchar(100) NOT NULL DEFAULT '',

[23] Fix | Delete

`avatar_mimetype` varchar(30) NOT NULL DEFAULT '',

[24] Fix | Delete

`avatar_created` int(10) NOT NULL DEFAULT '0',

[25] Fix | Delete

`avatar_display` tinyint(1) unsigned NOT NULL DEFAULT '0',

[26] Fix | Delete

`avatar_weight` smallint(5) unsigned NOT NULL DEFAULT '0',

[27] Fix | Delete

`avatar_type` char(1) NOT NULL DEFAULT '',

[28] Fix | Delete

PRIMARY KEY (`avatar_id`),

[29] Fix | Delete

KEY `avatar_type` (`avatar_type`,`avatar_display`)

[30] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[31] Fix | Delete

[32] Fix | Delete

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

[33] Fix | Delete

[34] Fix | Delete

--

[35] Fix | Delete

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

[36] Fix | Delete

--

[37] Fix | Delete

[38] Fix | Delete

CREATE TABLE `[[dbprefix]]_avatar_user_link` (

[39] Fix | Delete

`avatar_id` mediumint(8) unsigned NOT NULL DEFAULT '0',

[40] Fix | Delete

`user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',

[41] Fix | Delete

KEY `avatar_user_id` (`avatar_id`,`user_id`)

[42] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[43] Fix | Delete

[44] Fix | Delete

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

[45] Fix | Delete

[46] Fix | Delete

--

[47] Fix | Delete

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

[48] Fix | Delete

--

[49] Fix | Delete

[50] Fix | Delete

CREATE TABLE `[[dbprefix]]_banner` (

[51] Fix | Delete

`bid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,

[52] Fix | Delete

`cid` tinyint(3) unsigned NOT NULL DEFAULT '0',

[53] Fix | Delete

`imptotal` int(10) unsigned NOT NULL DEFAULT '0',

[54] Fix | Delete

`impmade` mediumint(8) unsigned NOT NULL DEFAULT '0',

[55] Fix | Delete

`clicks` mediumint(8) unsigned NOT NULL DEFAULT '0',

[56] Fix | Delete

`imageurl` varchar(255) NOT NULL DEFAULT '',

[57] Fix | Delete

`clickurl` varchar(255) NOT NULL DEFAULT '',

[58] Fix | Delete

`date` int(10) NOT NULL DEFAULT '0',

[59] Fix | Delete

`htmlbanner` tinyint(1) NOT NULL DEFAULT '0',

[60] Fix | Delete

`htmlcode` text,

[61] Fix | Delete

PRIMARY KEY (`bid`),

[62] Fix | Delete

KEY `idxbannercid` (`cid`),

[63] Fix | Delete

KEY `idxbannerbidcid` (`bid`,`cid`)

[64] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

[65] Fix | Delete

[66] Fix | Delete

--

[67] Fix | Delete

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

[68] Fix | Delete

--

[69] Fix | Delete

[70] Fix | Delete

INSERT INTO `[[dbprefix]]_banner` VALUES

[71] Fix | Delete

(1, 1, 0, 1, 0, '[[softurl]]/images/banners/xoops_flashbanner2.htm', 'http://www.xoops.org/', 1008813250, 1, ''),

[72] Fix | Delete

(2, 1, 0, 1, 0, '[[softurl]]/images/banners/xoops_banner_2.gif', 'http://www.xoops.org/', 1008813250, 0, ''),

[73] Fix | Delete

(3, 1, 0, 1, 0, '[[softurl]]/images/banners/banner.htm', 'http://www.xoops.org/', 1008813250, 1, ''),

[74] Fix | Delete

(4, 1, 0, 1, 0, '[[softurl]]/images/banners/xoopsifyIt.gif', 'http://www.xoops.org/', 1008813250, 1, '');

[75] Fix | Delete

[76] Fix | Delete

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

[77] Fix | Delete

[78] Fix | Delete

--

[79] Fix | Delete

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

[80] Fix | Delete

--

[81] Fix | Delete

[82] Fix | Delete

CREATE TABLE `[[dbprefix]]_bannerclient` (

[83] Fix | Delete

`cid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,

[84] Fix | Delete

`name` varchar(60) NOT NULL DEFAULT '',

[85] Fix | Delete

`contact` varchar(60) NOT NULL DEFAULT '',

[86] Fix | Delete

`email` varchar(60) NOT NULL DEFAULT '',

[87] Fix | Delete

`login` varchar(10) NOT NULL DEFAULT '',

[88] Fix | Delete

`passwd` varchar(10) NOT NULL DEFAULT '',

[89] Fix | Delete

`extrainfo` text,

[90] Fix | Delete

PRIMARY KEY (`cid`),

[91] Fix | Delete

KEY `login` (`login`)

[92] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

[93] Fix | Delete

[94] Fix | Delete

--

[95] Fix | Delete

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

[96] Fix | Delete

--

[97] Fix | Delete

[98] Fix | Delete

INSERT INTO `[[dbprefix]]_bannerclient` VALUES

[99] Fix | Delete

(1, 'XOOPS', 'XOOPS Dev Team', 'webmaster@xoops.org', '', '', '');

[100] Fix | Delete

[101] Fix | Delete

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

[102] Fix | Delete

[103] Fix | Delete

--

[104] Fix | Delete

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

[105] Fix | Delete

--

[106] Fix | Delete

[107] Fix | Delete

CREATE TABLE `[[dbprefix]]_bannerfinish` (

[108] Fix | Delete

`bid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,

[109] Fix | Delete

`cid` smallint(5) unsigned NOT NULL DEFAULT '0',

[110] Fix | Delete

`impressions` mediumint(8) unsigned NOT NULL DEFAULT '0',

[111] Fix | Delete

`clicks` mediumint(8) unsigned NOT NULL DEFAULT '0',

[112] Fix | Delete

`datestart` int(10) unsigned NOT NULL DEFAULT '0',

[113] Fix | Delete

`dateend` int(10) unsigned NOT NULL DEFAULT '0',

[114] Fix | Delete

PRIMARY KEY (`bid`),

[115] Fix | Delete

KEY `cid` (`cid`)

[116] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[117] Fix | Delete

[118] Fix | Delete

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

[119] Fix | Delete

[120] Fix | Delete

--

[121] Fix | Delete

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

[122] Fix | Delete

--

[123] Fix | Delete

[124] Fix | Delete

CREATE TABLE `[[dbprefix]]_block_module_link` (

[125] Fix | Delete

`block_id` mediumint(8) unsigned NOT NULL DEFAULT '0',

[126] Fix | Delete

`module_id` smallint(5) NOT NULL DEFAULT '0',

[127] Fix | Delete

PRIMARY KEY (`module_id`,`block_id`)

[128] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[129] Fix | Delete

[130] Fix | Delete

--

[131] Fix | Delete

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

[132] Fix | Delete

--

[133] Fix | Delete

[134] Fix | Delete

INSERT INTO `[[dbprefix]]_block_module_link` VALUES

[135] Fix | Delete

(1, 0),

[136] Fix | Delete

(2, 0),

[137] Fix | Delete

(3, 0),

[138] Fix | Delete

(4, 0),

[139] Fix | Delete

(5, 0),

[140] Fix | Delete

(6, 0),

[141] Fix | Delete

(7, 0),

[142] Fix | Delete

(8, 0),

[143] Fix | Delete

(9, 0),

[144] Fix | Delete

(10, 0),

[145] Fix | Delete

(11, 0),

[146] Fix | Delete

(12, 0);

[147] Fix | Delete

[148] Fix | Delete

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

[149] Fix | Delete

[150] Fix | Delete

--

[151] Fix | Delete

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

[152] Fix | Delete

--

[153] Fix | Delete

[154] Fix | Delete

CREATE TABLE `[[dbprefix]]_cache_model` (

[155] Fix | Delete

`cache_key` varchar(64) NOT NULL DEFAULT '',

[156] Fix | Delete

`cache_expires` int(10) unsigned NOT NULL DEFAULT '0',

[157] Fix | Delete

`cache_data` text,

[158] Fix | Delete

PRIMARY KEY (`cache_key`),

[159] Fix | Delete

KEY `cache_expires` (`cache_expires`)

[160] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[161] Fix | Delete

[162] Fix | Delete

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

[163] Fix | Delete

[164] Fix | Delete

--

[165] Fix | Delete

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

[166] Fix | Delete

--

[167] Fix | Delete

[168] Fix | Delete

CREATE TABLE `[[dbprefix]]_config` (

[169] Fix | Delete

`conf_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,

[170] Fix | Delete

`conf_modid` smallint(5) unsigned NOT NULL DEFAULT '0',

[171] Fix | Delete

`conf_catid` smallint(5) unsigned NOT NULL DEFAULT '0',

[172] Fix | Delete

`conf_name` varchar(25) NOT NULL DEFAULT '',

[173] Fix | Delete

`conf_title` varchar(255) NOT NULL DEFAULT '',

[174] Fix | Delete

`conf_value` text,

[175] Fix | Delete

`conf_desc` varchar(255) NOT NULL DEFAULT '',

[176] Fix | Delete

`conf_formtype` varchar(15) NOT NULL DEFAULT '',

[177] Fix | Delete

`conf_valuetype` varchar(10) NOT NULL DEFAULT '',

[178] Fix | Delete

`conf_order` smallint(5) unsigned NOT NULL DEFAULT '0',

[179] Fix | Delete

PRIMARY KEY (`conf_id`),

[180] Fix | Delete

KEY `conf_mod_cat_id` (`conf_modid`,`conf_catid`),

[181] Fix | Delete

KEY `conf_order` (`conf_order`)

[182] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=135 ;

[183] Fix | Delete

[184] Fix | Delete

--

[185] Fix | Delete

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

[186] Fix | Delete

--

[187] Fix | Delete

[188] Fix | Delete

INSERT INTO `[[dbprefix]]_config` VALUES

[189] Fix | Delete

(1, 0, 1, 'sitename', '_MD_AM_SITENAME', '[[site_name]]', '_MD_AM_SITENAMEDSC', 'textbox', 'text', 0),

[190] Fix | Delete

(2, 0, 1, 'slogan', '_MD_AM_SLOGAN', '[[site_desc]]', '_MD_AM_SLOGANDSC', 'textbox', 'text', 2),

[191] Fix | Delete

(3, 0, 1, 'language', '_MD_AM_LANGUAGE', 'english', '_MD_AM_LANGUAGEDSC', 'language', 'other', 4),

[192] Fix | Delete

(4, 0, 1, 'startpage', '_MD_AM_STARTPAGE', '--', '_MD_AM_STARTPAGEDSC', 'startpage', 'other', 6),

[193] Fix | Delete

(5, 0, 1, 'server_TZ', '_MD_AM_SERVERTZ', '0', '_MD_AM_SERVERTZDSC', 'timezone', 'float', 8),

[194] Fix | Delete

(6, 0, 1, 'default_TZ', '_MD_AM_DEFAULTTZ', '0', '_MD_AM_DEFAULTTZDSC', 'timezone', 'float', 10),

[195] Fix | Delete

(7, 0, 1, 'theme_set', '_MD_AM_DTHEME', 'xbootstrap', '_MD_AM_DTHEMEDSC', 'theme', 'other', 12),

[196] Fix | Delete

(8, 0, 1, 'anonymous', '_MD_AM_ANONNAME', 'Anonymous', '_MD_AM_ANONNAMEDSC', 'textbox', 'text', 15),

[197] Fix | Delete

(9, 0, 1, 'gzip_compression', '_MD_AM_USEGZIP', '0', '_MD_AM_USEGZIPDSC', 'yesno', 'int', 16),

[198] Fix | Delete

(10, 0, 1, 'usercookie', '_MD_AM_USERCOOKIE', 'xoops_user_[[usercookie]]', '_MD_AM_USERCOOKIEDSC', 'textbox', 'text', 18),

[199] Fix | Delete

(11, 0, 1, 'session_expire', '_MD_AM_SESSEXPIRE', '15', '_MD_AM_SESSEXPIREDSC', 'textbox', 'int', 22),

[200] Fix | Delete

(12, 0, 1, 'banners', '_MD_AM_BANNERS', '1', '_MD_AM_BANNERSDSC', 'yesno', 'int', 26),

[201] Fix | Delete

(13, 0, 1, 'debug_mode', '_MD_AM_DEBUGMODE', '0', '_MD_AM_DEBUGMODEDSC', 'select', 'int', 24),

[202] Fix | Delete

(14, 0, 1, 'my_ip', '_MD_AM_MYIP', '[[clientip]]', '_MD_AM_MYIPDSC', 'textbox', 'text', 29),

[203] Fix | Delete

(15, 0, 1, 'use_ssl', '_MD_AM_USESSL', '0', '_MD_AM_USESSLDSC', 'yesno', 'int', 30),

[204] Fix | Delete

(16, 0, 1, 'session_name', '_MD_AM_SESSNAME', 'xoops_session_[[usercookie]]', '_MD_AM_SESSNAMEDSC', 'textbox', 'text', 20),

[205] Fix | Delete

(17, 0, 2, 'minpass', '_MD_AM_MINPASS', '5', '_MD_AM_MINPASSDSC', 'textbox', 'int', 1),

[206] Fix | Delete

(18, 0, 2, 'minuname', '_MD_AM_MINUNAME', '3', '_MD_AM_MINUNAMEDSC', 'textbox', 'int', 2),

[207] Fix | Delete

(19, 0, 2, 'new_user_notify', '_MD_AM_NEWUNOTIFY', '1', '_MD_AM_NEWUNOTIFYDSC', 'yesno', 'int', 4),

[208] Fix | Delete

(20, 0, 2, 'new_user_notify_group', '_MD_AM_NOTIFYTO', '1', '_MD_AM_NOTIFYTODSC', 'group', 'int', 6),

[209] Fix | Delete

(21, 0, 2, 'activation_type', '_MD_AM_ACTVTYPE', '0', '_MD_AM_ACTVTYPEDSC', 'select', 'int', 8),

[210] Fix | Delete

(22, 0, 2, 'activation_group', '_MD_AM_ACTVGROUP', '1', '_MD_AM_ACTVGROUPDSC', 'group', 'int', 10),

[211] Fix | Delete

(23, 0, 2, 'uname_test_level', '_MD_AM_UNAMELVL', '0', '_MD_AM_UNAMELVLDSC', 'select', 'int', 12),

[212] Fix | Delete

(24, 0, 2, 'avatar_allow_upload', '_MD_AM_AVATARALLOW', '0', '_MD_AM_AVATARALWDSC', 'yesno', 'int', 14),

[213] Fix | Delete

(27, 0, 2, 'avatar_width', '_MD_AM_AVATARW', '128', '_MD_AM_AVATARWDSC', 'textbox', 'int', 16),

[214] Fix | Delete

(28, 0, 2, 'avatar_height', '_MD_AM_AVATARH', '128', '_MD_AM_AVATARHDSC', 'textbox', 'int', 18),

[215] Fix | Delete

(29, 0, 2, 'avatar_maxsize', '_MD_AM_AVATARMAX', '35000', '_MD_AM_AVATARMAXDSC', 'textbox', 'int', 20),

[216] Fix | Delete

(30, 0, 1, 'adminmail', '_MD_AM_ADMINML', '[[admin_email]]', '_MD_AM_ADMINMLDSC', 'textbox', 'text', 3),

[217] Fix | Delete

(31, 0, 2, 'self_delete', '_MD_AM_SELFDELETE', '0', '_MD_AM_SELFDELETEDSC', 'yesno', 'int', 22),

[218] Fix | Delete

(32, 0, 1, 'com_mode', '_MD_AM_COMMODE', 'flat', '_MD_AM_COMMODEDSC', 'select', 'text', 34),

[219] Fix | Delete

(33, 0, 1, 'com_order', '_MD_AM_COMORDER', '0', '_MD_AM_COMORDERDSC', 'select', 'int', 36),

[220] Fix | Delete

(34, 0, 2, 'bad_unames', '_MD_AM_BADUNAMES', 'a:3:{i:0;s:9:"webmaster";i:1;s:6:"^xoops";i:2;s:6:"^admin";}', '_MD_AM_BADUNAMESDSC', 'textarea', 'array', 24),

[221] Fix | Delete

(35, 0, 2, 'bad_emails', '_MD_AM_BADEMAILS', 'a:1:{i:0;s:10:"xoops.org$";}', '_MD_AM_BADEMAILSDSC', 'textarea', 'array', 26),

[222] Fix | Delete

(36, 0, 2, 'maxuname', '_MD_AM_MAXUNAME', '10', '_MD_AM_MAXUNAMEDSC', 'textbox', 'int', 3),

[223] Fix | Delete

(37, 0, 1, 'bad_ips', '_MD_AM_BADIPS', 'a:1:{i:0;s:9:"127.0.0.1";}', '_MD_AM_BADIPSDSC', 'textarea', 'array', 42),

[224] Fix | Delete

(38, 0, 3, 'meta_keywords', '_MD_AM_METAKEY', 'xoops, web application framework, cms, content management system', '_MD_AM_METAKEYDSC', 'textarea', 'text', 0),

[225] Fix | Delete

(39, 0, 3, 'footer', '_MD_AM_FOOTER', 'Powered by XOOPS &#169; 2001-2019 <a href="http://xoops.org" rel="external" title="The XOOPS Project">The XOOPS Project</a>', '_MD_AM_FOOTERDSC', 'textarea', 'text', 20),

[226] Fix | Delete

(40, 0, 4, 'censor_enable', '_MD_AM_DOCENSOR', '0', '_MD_AM_DOCENSORDSC', 'yesno', 'int', 0),

[227] Fix | Delete

(41, 0, 4, 'censor_words', '_MD_AM_CENSORWRD', 'a:2:{i:0;s:4:"fuck";i:1;s:4:"shit";}', '_MD_AM_CENSORWRDDSC', 'textarea', 'array', 1),

[228] Fix | Delete

(42, 0, 4, 'censor_replace', '_MD_AM_CENSORRPLC', '#OOPS#', '_MD_AM_CENSORRPLCDSC', 'textbox', 'text', 2),

[229] Fix | Delete

(43, 0, 3, 'meta_robots', '_MD_AM_METAROBOTS', 'index,follow', '_MD_AM_METAROBOTSDSC', 'textbox', 'text', 2),

[230] Fix | Delete

(44, 0, 5, 'enable_search', '_MD_AM_DOSEARCH', '1', '_MD_AM_DOSEARCHDSC', 'yesno', 'int', 0),

[231] Fix | Delete

(45, 0, 5, 'keyword_min', '_MD_AM_MINSEARCH', '5', '_MD_AM_MINSEARCHDSC', 'textbox', 'int', 1),

[232] Fix | Delete

(46, 0, 2, 'avatar_minposts', '_MD_AM_AVATARMP', '0', '_MD_AM_AVATARMPDSC', 'textbox', 'int', 15),

[233] Fix | Delete

(47, 0, 1, 'enable_badips', '_MD_AM_DOBADIPS', '0', '_MD_AM_DOBADIPSDSC', 'yesno', 'int', 40),

[234] Fix | Delete

(48, 0, 3, 'meta_rating', '_MD_AM_METARATING', 'general', '_MD_AM_METARATINGDSC', 'select', 'text', 4),

[235] Fix | Delete

(49, 0, 3, 'meta_author', '_MD_AM_METAAUTHOR', 'XOOPS', '_MD_AM_METAAUTHORDSC', 'textbox', 'text', 6),

[236] Fix | Delete

(50, 0, 3, 'meta_copyright', '_MD_AM_METACOPYR', 'Copyright © 2001-2019', '_MD_AM_METACOPYRDSC', 'textbox', 'text', 8),

[237] Fix | Delete

(51, 0, 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', 1),

[238] Fix | Delete

(52, 0, 2, 'allow_chgmail', '_MD_AM_ALLWCHGMAIL', '0', '_MD_AM_ALLWCHGMAILDSC', 'yesno', 'int', 3),

[239] Fix | Delete

(53, 0, 1, 'use_mysession', '_MD_AM_USEMYSESS', '1', '_MD_AM_USEMYSESSDSC', 'yesno', 'int', 19),

[240] Fix | Delete

(54, 0, 2, 'reg_dispdsclmr', '_MD_AM_DSPDSCLMR', '1', '_MD_AM_DSPDSCLMRDSC', 'yesno', 'int', 30),

[241] Fix | Delete

(55, 0, 2, 'reg_disclaimer', '_MD_AM_REGDSCLMR', 'While the administrators and moderators of this site will attempt to remove\nor edit any generally objectionable material as quickly as possible, it is\nimpossible to review every message. Therefore you acknowledge that all posts\nmade to this site express the views and opinions of the author and not the\nadministrators, moderators or webmaster (except for posts by these people)\nand hence will not be held liable.\n\nYou agree not to post any abusive, obscene, vulgar, slanderous, hateful,\nthreatening, sexually-orientated or any other material that may violate any\napplicable laws. Doing so may lead to you being immediately and permanently\nbanned (and your service provider being informed). The IP address of all\nposts is recorded to aid in enforcing these conditions. Creating multiple\naccounts for a single user is not allowed. You agree that the webmaster,\nadministrator and moderators of this site have the right to remove, edit,\nmove or close any topic at any time should they see fit. As a user you agree\nto any information you have entered above being stored in a database. While\nthis information will not be disclosed to any third party without your\nconsent the webmaster, administrator and moderators cannot be held\nresponsible for any hacking attempt that may lead to the data being\ncompromised.\n\nThis site system uses cookies to store information on your local computer.\nThese cookies do not contain any of the information you have entered above,\nthey serve only to improve your viewing pleasure. The email address is used\nonly for confirming your registration details and password (and for sending\nnew passwords should you forget your current one).\n\nBy clicking Register below you agree to be bound by these conditions.', '_MD_AM_REGDSCLMRDSC', 'textarea', 'text', 32),

[242] Fix | Delete

(56, 0, 2, 'allow_register', '_MD_AM_ALLOWREG', '1', '_MD_AM_ALLOWREGDSC', 'yesno', 'int', 0),

[243] Fix | Delete

(57, 0, 1, 'theme_fromfile', '_MD_AM_THEMEFILE', '0', '_MD_AM_THEMEFILEDSC', 'yesno', 'int', 13),

[244] Fix | Delete

(58, 0, 1, 'closesite', '_MD_AM_CLOSESITE', '0', '_MD_AM_CLOSESITEDSC', 'yesno', 'int', 26),

[245] Fix | Delete

(59, 0, 1, 'closesite_okgrp', '_MD_AM_CLOSESITEOK', 'a:1:{i:0;s:1:"1";}', '_MD_AM_CLOSESITEOKDSC', 'group_multi', 'array', 27),

[246] Fix | Delete

(60, 0, 1, 'closesite_text', '_MD_AM_CLOSESITETXT', 'The site is currently closed for maintenance. Please come back later.', '_MD_AM_CLOSESITETXTDSC', 'textarea', 'text', 28),

[247] Fix | Delete

(61, 0, 1, 'sslpost_name', '_MD_AM_SSLPOST', 'xoops_ssl', '_MD_AM_SSLPOSTDSC', 'textbox', 'text', 31),

[248] Fix | Delete

(62, 0, 1, 'module_cache', '_MD_AM_MODCACHE', '', '_MD_AM_MODCACHEDSC', 'module_cache', 'array', 50),

[249] Fix | Delete

(63, 0, 1, 'template_set', '_MD_AM_DTPLSET', 'default', '_MD_AM_DTPLSETDSC', 'tplset', 'other', 14),

[250] Fix | Delete

(64, 0, 6, 'mailmethod', '_MD_AM_MAILERMETHOD', 'mail', '_MD_AM_MAILERMETHODDESC', 'select', 'text', 4),

[251] Fix | Delete

(65, 0, 6, 'smtphost', '_MD_AM_SMTPHOST', 'a:1:{i:0;s:0:"";}', '_MD_AM_SMTPHOSTDESC', 'textarea', 'array', 6),

[252] Fix | Delete

(66, 0, 6, 'smtpuser', '_MD_AM_SMTPUSER', '', '_MD_AM_SMTPUSERDESC', 'textbox', 'text', 7),

[253] Fix | Delete

(67, 0, 6, 'smtppass', '_MD_AM_SMTPPASS', '', '_MD_AM_SMTPPASSDESC', 'password', 'text', 8),

[254] Fix | Delete

(68, 0, 6, 'sendmailpath', '_MD_AM_SENDMAILPATH', '/usr/sbin/sendmail', '_MD_AM_SENDMAILPATHDESC', 'textbox', 'text', 5),

[255] Fix | Delete

(69, 0, 6, 'from', '_MD_AM_MAILFROM', '', '_MD_AM_MAILFROMDESC', 'textbox', 'text', 1),

[256] Fix | Delete

(70, 0, 6, 'fromname', '_MD_AM_MAILFROMNAME', '', '_MD_AM_MAILFROMNAMEDESC', 'textbox', 'text', 2),

[257] Fix | Delete

(71, 0, 1, 'sslloginlink', '_MD_AM_SSLLINK', 'https://', '_MD_AM_SSLLINKDSC', 'textbox', 'text', 33),

[258] Fix | Delete

(72, 0, 1, 'theme_set_allowed', '_MD_AM_THEMEOK', 'a:1:{i:0;s:10:"xbootstrap";}', '_MD_AM_THEMEOKDSC', 'theme_multi', 'array', 13),

[259] Fix | Delete

(73, 0, 6, 'fromuid', '_MD_AM_MAILFROMUID', '1', '_MD_AM_MAILFROMUIDDESC', 'user', 'int', 3),

[260] Fix | Delete

(74, 0, 7, 'auth_method', '_MD_AM_AUTHMETHOD', 'xoops', '_MD_AM_AUTHMETHODDESC', 'select', 'text', 1),

[261] Fix | Delete

(75, 0, 7, 'ldap_port', '_MD_AM_LDAP_PORT', '389', '_MD_AM_LDAP_PORT', 'textbox', 'int', 2),

[262] Fix | Delete

(76, 0, 7, 'ldap_server', '_MD_AM_LDAP_SERVER', 'your directory server', '_MD_AM_LDAP_SERVER_DESC', 'textbox', 'text', 3),

[263] Fix | Delete

(77, 0, 7, 'ldap_base_dn', '_MD_AM_LDAP_BASE_DN', 'dc=xoops,dc=org', '_MD_AM_LDAP_BASE_DN_DESC', 'textbox', 'text', 4),

[264] Fix | Delete

(78, 0, 7, 'ldap_manager_dn', '_MD_AM_LDAP_MANAGER_DN', 'manager_dn', '_MD_AM_LDAP_MANAGER_DN_DESC', 'textbox', 'text', 5),

[265] Fix | Delete

(79, 0, 7, 'ldap_manager_pass', '_MD_AM_LDAP_MANAGER_PASS', 'manager_pass', '_MD_AM_LDAP_MANAGER_PASS_DESC', 'password', 'text', 6),

[266] Fix | Delete

(80, 0, 7, 'ldap_version', '_MD_AM_LDAP_VERSION', '3', '_MD_AM_LDAP_VERSION_DESC', 'textbox', 'text', 7),

[267] Fix | Delete

(81, 0, 7, 'ldap_users_bypass', '_MD_AM_LDAP_USERS_BYPASS', 'a:1:{i:0;s:5:"admin";}', '_MD_AM_LDAP_USERS_BYPASS_DESC', 'textarea', 'array', 8),

[268] Fix | Delete

(82, 0, 7, 'ldap_loginname_asdn', '_MD_AM_LDAP_LOGINNAME_ASDN', 'uid_asdn', '_MD_AM_LDAP_LOGINNAME_ASDN_D', 'yesno', 'int', 9),

[269] Fix | Delete

(83, 0, 7, 'ldap_loginldap_attr', '_MD_AM_LDAP_LOGINLDAP_ATTR', 'uid', '_MD_AM_LDAP_LOGINLDAP_ATTR_D', 'textbox', 'text', 10),

[270] Fix | Delete

(84, 0, 7, 'ldap_filter_person', '_MD_AM_LDAP_FILTER_PERSON', '', '_MD_AM_LDAP_FILTER_PERSON_DESC', 'textbox', 'text', 11),

[271] Fix | Delete

(85, 0, 7, 'ldap_domain_name', '_MD_AM_LDAP_DOMAIN_NAME', 'mydomain', '_MD_AM_LDAP_DOMAIN_NAME_DESC', 'textbox', 'text', 12),

[272] Fix | Delete

(86, 0, 7, 'ldap_provisionning', '_MD_AM_LDAP_PROVIS', '0', '_MD_AM_LDAP_PROVIS_DESC', 'yesno', 'int', 13),

[273] Fix | Delete

(87, 0, 7, 'ldap_provisionning_group', '_MD_AM_LDAP_PROVIS_GROUP', 'a:1:{i:0;s:1:"2";}', '_MD_AM_LDAP_PROVIS_GROUP_DSC', 'group_multi', 'array', 14),

[274] Fix | Delete

(88, 0, 7, 'ldap_mail_attr', '_MD_AM_LDAP_MAIL_ATTR', 'mail', '_MD_AM_LDAP_MAIL_ATTR_DESC', 'textbox', 'text', 15),

[275] Fix | Delete

(89, 0, 7, 'ldap_givenname_attr', '_MD_AM_LDAP_GIVENNAME_ATTR', 'givenname', '_MD_AM_LDAP_GIVENNAME_ATTR_DSC', 'textbox', 'text', 16),

[276] Fix | Delete

(90, 0, 7, 'ldap_surname_attr', '_MD_AM_LDAP_SURNAME_ATTR', 'sn', '_MD_AM_LDAP_SURNAME_ATTR_DESC', 'textbox', 'text', 17),

[277] Fix | Delete

(91, 0, 7, 'ldap_field_mapping', '_MD_AM_LDAP_FIELD_MAPPING_ATTR', 'email=mail|name=displayname', '_MD_AM_LDAP_FIELD_MAPPING_DESC', 'textarea', 'text', 18),

[278] Fix | Delete

(92, 0, 7, 'ldap_provisionning_upd', '_MD_AM_LDAP_PROVIS_UPD', '1', '_MD_AM_LDAP_PROVIS_UPD_DESC', 'yesno', 'int', 19),

[279] Fix | Delete

(93, 0, 7, 'ldap_use_TLS', '_MD_AM_LDAP_USETLS', '0', '_MD_AM_LDAP_USETLS_DESC', 'yesno', 'int', 20),

[280] Fix | Delete

(94, 0, 1, 'cpanel', '_MD_AM_CPANEL', 'transition', '_MD_AM_CPANELDSC', 'cpanel', 'other', 11),

[281] Fix | Delete

(95, 0, 2, 'welcome_type', '_MD_AM_WELCOMETYPE', '1', '_MD_AM_WELCOMETYPE_DESC', 'select', 'int', 3),

[282] Fix | Delete

(96, 1, 0, 'break1', '_MI_SYSTEM_PREFERENCE_BREAK_GENERAL', 'head', '', 'line_break', 'textbox', 0),

[283] Fix | Delete

(97, 1, 0, 'usetips', '_MI_SYSTEM_PREFERENCE_TIPS', '1', '_MI_SYSTEM_PREFERENCE_TIPS_DSC', 'yesno', 'int', 10),

[284] Fix | Delete

(98, 1, 0, 'typeicons', '_MI_SYSTEM_PREFERENCE_ICONS', 'transition', '', 'select', 'text', 20),

[285] Fix | Delete

(99, 1, 0, 'typebreadcrumb', '_MI_SYSTEM_PREFERENCE_BREADCRUMB', 'default', '', 'select', 'text', 30),

[286] Fix | Delete

(100, 1, 0, 'break2', '_MI_SYSTEM_PREFERENCE_BREAK_ACTIVE', 'head', '', 'line_break', 'textbox', 40),

[287] Fix | Delete

(101, 1, 0, 'active_avatars', '_MI_SYSTEM_PREFERENCE_ACTIVE_AVATARS', '1', '', 'yesno', 'int', 50),

[288] Fix | Delete

(102, 1, 0, 'active_banners', '_MI_SYSTEM_PREFERENCE_ACTIVE_BANNERS', '1', '', 'yesno', 'int', 60),

[289] Fix | Delete

(103, 1, 0, 'active_blocksadmin', '_MI_SYSTEM_PREFERENCE_ACTIVE_BLOCKSADMIN', '1', '', 'hidden', 'int', 70),

[290] Fix | Delete

(104, 1, 0, 'active_comments', '_MI_SYSTEM_PREFERENCE_ACTIVE_COMMENTS', '1', '', 'yesno', 'int', 80),

[291] Fix | Delete

(105, 1, 0, 'active_filemanager', '_MI_SYSTEM_PREFERENCE_ACTIVE_FILEMANAGER', '1', '', 'yesno', 'int', 90),

[292] Fix | Delete

(106, 1, 0, 'active_groups', '_MI_SYSTEM_PREFERENCE_ACTIVE_GROUPS', '1', '', 'hidden', 'int', 100),

[293] Fix | Delete

(107, 1, 0, 'active_images', '_MI_SYSTEM_PREFERENCE_ACTIVE_IMAGES', '1', '', 'yesno', 'int', 110),

[294] Fix | Delete

(108, 1, 0, 'active_mailusers', '_MI_SYSTEM_PREFERENCE_ACTIVE_MAILUSERS', '1', '', 'yesno', 'int', 120),

[295] Fix | Delete

(109, 1, 0, 'active_modulesadmin', '_MI_SYSTEM_PREFERENCE_ACTIVE_MODULESADMIN', '1', '', 'hidden', 'int', 130),

[296] Fix | Delete

(110, 1, 0, 'active_maintenance', '_MI_SYSTEM_PREFERENCE_ACTIVE_MAINTENANCE', '1', '', 'yesno', 'int', 140),

[297] Fix | Delete

(111, 1, 0, 'active_preferences', '_MI_SYSTEM_PREFERENCE_ACTIVE_PREFERENCES', '1', '', 'hidden', 'int', 150),

[298] Fix | Delete

(112, 1, 0, 'active_smilies', '_MI_SYSTEM_PREFERENCE_ACTIVE_SMILIES', '1', '', 'yesno', 'int', 160),

[299] Fix | Delete

(113, 1, 0, 'active_tplsets', '_MI_SYSTEM_PREFERENCE_ACTIVE_TPLSETS', '1', '', 'hidden', 'int', 170),

[300] Fix | Delete

(114, 1, 0, 'active_userrank', '_MI_SYSTEM_PREFERENCE_ACTIVE_USERRANK', '1', '', 'yesno', 'int', 180),

[301] Fix | Delete

(115, 1, 0, 'active_users', '_MI_SYSTEM_PREFERENCE_ACTIVE_USERS', '1', '', 'yesno', 'int', 190),

[302] Fix | Delete

(116, 1, 0, 'break3', '_MI_SYSTEM_PREFERENCE_BREAK_PAGER', 'head', '', 'line_break', 'textbox', 200),

[303] Fix | Delete

(117, 1, 0, 'avatars_pager', '_MI_SYSTEM_PREFERENCE_AVATARS_PAGER', '10', '', 'textbox', 'int', 210),

[304] Fix | Delete

(118, 1, 0, 'banners_pager', '_MI_SYSTEM_PREFERENCE_BANNERS_PAGER', '10', '', 'textbox', 'int', 220),

[305] Fix | Delete

(119, 1, 0, 'comments_pager', '_MI_SYSTEM_PREFERENCE_COMMENTS_PAGER', '20', '', 'textbox', 'int', 230),

[306] Fix | Delete

(120, 1, 0, 'groups_pager', '_MI_SYSTEM_PREFERENCE_GROUPS_PAGER', '15', '', 'textbox', 'int', 240),

[307] Fix | Delete

(121, 1, 0, 'images_pager', '_MI_SYSTEM_PREFERENCE_IMAGES_PAGER', '15', '', 'textbox', 'int', 250),

[308] Fix | Delete

(122, 1, 0, 'smilies_pager', '_MI_SYSTEM_PREFERENCE_SMILIES_PAGER', '20', '', 'textbox', 'int', 260),

[309] Fix | Delete

(123, 1, 0, 'userranks_pager', '_MI_SYSTEM_PREFERENCE_USERRANKS_PAGER', '20', '', 'textbox', 'int', 270),

[310] Fix | Delete

(124, 1, 0, 'users_pager', '_MI_SYSTEM_PREFERENCE_USERS_PAGER', '20', '', 'textbox', 'int', 280),

[311] Fix | Delete

(125, 1, 0, 'break4', '_MI_SYSTEM_PREFERENCE_BREAK_EDITOR', 'head', '', 'line_break', 'textbox', 290),

[312] Fix | Delete

(126, 1, 0, 'blocks_editor', '_MI_SYSTEM_PREFERENCE_BLOCKS_EDITOR', 'dhtmltextarea', '_MI_SYSTEM_PREFERENCE_BLOCKS_EDITOR_DSC', 'select', 'text', 300),

[313] Fix | Delete

(127, 1, 0, 'comments_editor', '_MI_SYSTEM_PREFERENCE_COMMENTS_EDITOR', 'dhtmltextarea', '_MI_SYSTEM_PREFERENCE_COMMENTS_EDITOR_DSC', 'select', 'text', 310),

[314] Fix | Delete

(128, 1, 0, 'general_editor', '_MI_SYSTEM_PREFERENCE_GENERAL_EDITOR', 'dhtmltextarea', '_MI_SYSTEM_PREFERENCE_GENERAL_EDITOR_DSC', 'select', 'text', 320),

[315] Fix | Delete

(129, 1, 0, 'redirect', '_MI_SYSTEM_PREFERENCE_REDIRECT', 'admin.php?fct=preferences', '', 'hidden', 'text', 330),

[316] Fix | Delete

(130, 1, 0, 'com_anonpost', '_MI_SYSTEM_PREFERENCE_ANONPOST', '', '', 'hidden', 'text', 340),

[317] Fix | Delete

(133, 1, 0, 'jquery_theme', '_MI_SYSTEM_PREFERENCE_JQUERY_THEME', 'base', '', 'select', 'text', 35),

[318] Fix | Delete

(134, 0, 1, 'redirect_message_ajax', '_MD_AM_CUSTOM_REDIRECT', '1', '_MD_AM_CUSTOM_REDIRECT_DESC', 'yesno', 'int', 12);

[319] Fix | Delete

[320] Fix | Delete

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

[321] Fix | Delete

[322] Fix | Delete

--

[323] Fix | Delete

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

[324] Fix | Delete

--

[325] Fix | Delete

[326] Fix | Delete

CREATE TABLE `[[dbprefix]]_configcategory` (

[327] Fix | Delete

`confcat_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,

[328] Fix | Delete

`confcat_name` varchar(255) NOT NULL DEFAULT '',

[329] Fix | Delete

`confcat_order` smallint(5) unsigned NOT NULL DEFAULT '0',

[330] Fix | Delete

PRIMARY KEY (`confcat_id`)

[331] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

[332] Fix | Delete

[333] Fix | Delete

--

[334] Fix | Delete

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

[335] Fix | Delete

--

[336] Fix | Delete

[337] Fix | Delete

INSERT INTO `[[dbprefix]]_configcategory` VALUES

[338] Fix | Delete

(1, '_MD_AM_GENERAL', 0),

[339] Fix | Delete

(2, '_MD_AM_USERSETTINGS', 0),

[340] Fix | Delete

(3, '_MD_AM_METAFOOTER', 0),

[341] Fix | Delete

(4, '_MD_AM_CENSOR', 0),

[342] Fix | Delete

(5, '_MD_AM_SEARCH', 0),

[343] Fix | Delete

(6, '_MD_AM_MAILER', 0),

[344] Fix | Delete

(7, '_MD_AM_AUTHENTICATION', 0);

[345] Fix | Delete

[346] Fix | Delete

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

[347] Fix | Delete

[348] Fix | Delete

--

[349] Fix | Delete

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

[350] Fix | Delete

--

[351] Fix | Delete

[352] Fix | Delete

CREATE TABLE `[[dbprefix]]_configoption` (

[353] Fix | Delete

`confop_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,

[354] Fix | Delete

`confop_name` varchar(255) NOT NULL DEFAULT '',

[355] Fix | Delete

`confop_value` varchar(255) NOT NULL DEFAULT '',

[356] Fix | Delete

`conf_id` smallint(5) unsigned NOT NULL DEFAULT '0',

[357] Fix | Delete

PRIMARY KEY (`confop_id`),

[358] Fix | Delete

KEY `conf_id` (`conf_id`)

[359] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=54 ;

[360] Fix | Delete

[361] Fix | Delete

--

[362] Fix | Delete

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

[363] Fix | Delete

--

[364] Fix | Delete

[365] Fix | Delete

INSERT INTO `[[dbprefix]]_configoption` VALUES

[366] Fix | Delete

(1, '_MD_AM_DEBUGMODE1', '1', 13),

[367] Fix | Delete

(2, '_MD_AM_DEBUGMODE2', '2', 13),

[368] Fix | Delete

(3, '_NESTED', 'nest', 32),

[369] Fix | Delete

(4, '_FLAT', 'flat', 32),

[370] Fix | Delete

(5, '_THREADED', 'thread', 32),

[371] Fix | Delete

(6, '_OLDESTFIRST', '0', 33),

[372] Fix | Delete

(7, '_NEWESTFIRST', '1', 33),

[373] Fix | Delete

(8, '_MD_AM_USERACTV', '0', 21),

[374] Fix | Delete

(9, '_MD_AM_AUTOACTV', '1', 21),

[375] Fix | Delete

(10, '_MD_AM_ADMINACTV', '2', 21),

[376] Fix | Delete

(11, '_MD_AM_STRICT', '0', 23),

[377] Fix | Delete

(12, '_MD_AM_MEDIUM', '1', 23),

[378] Fix | Delete

(13, '_MD_AM_LIGHT', '2', 23),

[379] Fix | Delete

(14, '_MD_AM_DEBUGMODE3', '3', 13),

[380] Fix | Delete

(15, '_MD_AM_INDEXFOLLOW', 'index,follow', 43),

[381] Fix | Delete

(16, '_MD_AM_NOINDEXFOLLOW', 'noindex,follow', 43),

[382] Fix | Delete

(17, '_MD_AM_INDEXNOFOLLOW', 'index,nofollow', 43),

[383] Fix | Delete

(18, '_MD_AM_NOINDEXNOFOLLOW', 'noindex,nofollow', 43),

[384] Fix | Delete

(19, '_MD_AM_METAOGEN', 'general', 48),

[385] Fix | Delete

(20, '_MD_AM_METAO14YRS', '14 years', 48),

[386] Fix | Delete

(21, '_MD_AM_METAOREST', 'restricted', 48),

[387] Fix | Delete

(22, '_MD_AM_METAOMAT', 'mature', 48),

[388] Fix | Delete

(23, '_MD_AM_DEBUGMODE0', '0', 13),

[389] Fix | Delete

(24, 'PHP mail()', 'mail', 64),

[390] Fix | Delete

(25, 'sendmail', 'sendmail', 64),

[391] Fix | Delete

(26, 'SMTP', 'smtp', 64),

[392] Fix | Delete

(27, 'SMTPAuth', 'smtpauth', 64),

[393] Fix | Delete

(28, '_MD_AM_AUTH_CONFOPTION_XOOPS', 'xoops', 74),

[394] Fix | Delete

(29, '_MD_AM_AUTH_CONFOPTION_LDAP', 'ldap', 74),

[395] Fix | Delete

(30, '_MD_AM_AUTH_CONFOPTION_AD', 'ads', 74),

[396] Fix | Delete

(31, '_NO', '0', 95),

[397] Fix | Delete

(32, '_MD_AM_WELCOMETYPE_EMAIL', '1', 95),

[398] Fix | Delete

(33, '_MD_AM_WELCOMETYPE_PM', '2', 95),

[399] Fix | Delete

(34, '_MD_AM_WELCOMETYPE_BOTH', '3', 95),

[400] Fix | Delete

(35, 'dhtmltextarea', 'dhtmltextarea', 126),

[401] Fix | Delete

(36, 'textarea', 'textarea', 126),

[402] Fix | Delete

(37, 'tinymce', 'tinymce', 126),

[403] Fix | Delete

(38, 'dhtmltextarea', 'dhtmltextarea', 127),

[404] Fix | Delete

(39, 'textarea', 'textarea', 127),

[405] Fix | Delete

(40, 'tinymce', 'tinymce', 127),

[406] Fix | Delete

(41, 'dhtmltextarea', 'dhtmltextarea', 128),

[407] Fix | Delete

(42, 'textarea', 'textarea', 128),

[408] Fix | Delete

(43, 'tinymce', 'tinymce', 128),

[409] Fix | Delete

(44, 'default', 'default', 98),

[410] Fix | Delete

(45, 'transition', 'transition', 98),

[411] Fix | Delete

(46, 'default', 'default', 99),

[412] Fix | Delete

(47, 'base', 'base', 133),

[413] Fix | Delete

(48, 'cupertino', 'cupertino', 133),

[414] Fix | Delete

(49, 'redmond', 'redmond', 133),

[415] Fix | Delete

(50, 'smoothness', 'smoothness', 133),

[416] Fix | Delete

(51, 'south-street', 'south-street', 133),

[417] Fix | Delete

(52, 'ui-darkness', 'ui-darkness', 133),

[418] Fix | Delete

(53, 'ui-lightness', 'ui-lightness', 133);

[419] Fix | Delete

[420] Fix | Delete

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

[421] Fix | Delete

[422] Fix | Delete

--

[423] Fix | Delete

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

[424] Fix | Delete

--

[425] Fix | Delete

[426] Fix | Delete

CREATE TABLE `[[dbprefix]]_groups` (

[427] Fix | Delete

`groupid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,

[428] Fix | Delete

`name` varchar(50) NOT NULL DEFAULT '',

[429] Fix | Delete

`description` text,

[430] Fix | Delete

`group_type` varchar(10) NOT NULL DEFAULT '',

[431] Fix | Delete

PRIMARY KEY (`groupid`),

[432] Fix | Delete

KEY `group_type` (`group_type`)

[433] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

[434] Fix | Delete

[435] Fix | Delete

--

[436] Fix | Delete

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

[437] Fix | Delete

--

[438] Fix | Delete

[439] Fix | Delete

INSERT INTO `[[dbprefix]]_groups` VALUES

[440] Fix | Delete

(1, 'Webmasters', 'Webmasters of this site', 'Admin'),

[441] Fix | Delete

(2, 'Registered Users', 'Registered Users Group', 'User'),

[442] Fix | Delete

(3, 'Anonymous Users', 'Anonymous Users Group', 'Anonymous');

[443] Fix | Delete

[444] Fix | Delete

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

[445] Fix | Delete

[446] Fix | Delete

--

[447] Fix | Delete

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

[448] Fix | Delete

--

[449] Fix | Delete

[450] Fix | Delete

CREATE TABLE `[[dbprefix]]_groups_users_link` (

[451] Fix | Delete

`linkid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,

[452] Fix | Delete

`groupid` smallint(5) unsigned NOT NULL DEFAULT '0',

[453] Fix | Delete

`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',

[454] Fix | Delete

PRIMARY KEY (`linkid`),

[455] Fix | Delete

KEY `groupid_uid` (`groupid`,`uid`),

[456] Fix | Delete

KEY `uid` (`uid`)

[457] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

[458] Fix | Delete

[459] Fix | Delete

--

[460] Fix | Delete

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

[461] Fix | Delete

--

[462] Fix | Delete

[463] Fix | Delete

INSERT INTO `[[dbprefix]]_groups_users_link` VALUES

[464] Fix | Delete

(1, 1, 1),

[465] Fix | Delete

(2, 2, 1);

[466] Fix | Delete

[467] Fix | Delete

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

[468] Fix | Delete

[469] Fix | Delete

--

[470] Fix | Delete

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

[471] Fix | Delete

--

[472] Fix | Delete

[473] Fix | Delete

CREATE TABLE `[[dbprefix]]_group_permission` (

[474] Fix | Delete

`gperm_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[475] Fix | Delete

`gperm_groupid` smallint(5) unsigned NOT NULL DEFAULT '0',

[476] Fix | Delete

`gperm_itemid` mediumint(8) unsigned NOT NULL DEFAULT '0',

[477] Fix | Delete

`gperm_modid` mediumint(5) unsigned NOT NULL DEFAULT '0',

[478] Fix | Delete

`gperm_name` varchar(50) NOT NULL DEFAULT '',

[479] Fix | Delete

PRIMARY KEY (`gperm_id`),

[480] Fix | Delete

KEY `groupid` (`gperm_groupid`),

[481] Fix | Delete

KEY `itemid` (`gperm_itemid`),

[482] Fix | Delete

KEY `gperm_modid` (`gperm_modid`,`gperm_name`(10))

[483] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=58 ;

[484] Fix | Delete

[485] Fix | Delete

--

[486] Fix | Delete

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

[487] Fix | Delete

--

[488] Fix | Delete

[489] Fix | Delete

INSERT INTO `[[dbprefix]]_group_permission` VALUES

[490] Fix | Delete

(1, 1, 1, 1, 'module_admin'),

[491] Fix | Delete

(2, 1, 1, 1, 'module_read'),

[492] Fix | Delete

(3, 2, 1, 1, 'module_read'),

[493] Fix | Delete

(4, 3, 1, 1, 'module_read'),

[494] Fix | Delete

(5, 1, 1, 1, 'system_admin'),

[495] Fix | Delete

(6, 1, 2, 1, 'system_admin'),

[496] Fix | Delete

(7, 1, 3, 1, 'system_admin'),

[497] Fix | Delete

(8, 1, 4, 1, 'system_admin'),

[498] Fix | Delete

(9, 1, 5, 1, 'system_admin'),

[499] Fix | Delete