--
-- Дамп данных таблицы `Module`
--

INSERT INTO `Module` (`Module_Name`, `Keyword`, `Description`, `Parameters`, `Example_URL`, `Help_URL`, `Installed`, `Number`, `Inside_Admin`, `Checked`) VALUES
('NETCAT_MODULE_FORUM2', 'forum2', 'NETCAT_MODULE_FORUM2_DESCRIPTION', 'FORUM_CLASS_ID=484\nTOPIC_CLASS_ID=485\nREPLY_CLASS_ID=486\nFORUM_RSS_CLASS_ID=75\nTOPIC_RSS_CLASS_ID=74\nREPLY_RSS_CLASS_ID=76\nFORUM_AVATAR_FIELD=ForumAvatar\nFORUM_SIGNATURE_FIELD=ForumSignature\nSUBSCRIBER_MAILER_ID=1\nTRACKING_MODE=1\n', '', '/settings/modules/forum2/', 1, '', 1, 1);

--
-- Структура таблицы `Forum_Count`
--

CREATE TABLE IF NOT EXISTS `Forum_Count` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Subdivision_ID` int(11) unsigned NOT NULL DEFAULT '0',
  `Topics` int(11) unsigned NOT NULL DEFAULT '0',
  `Replies` int(11) unsigned NOT NULL DEFAULT '0',
  `Last_Topic_ID` int(10) unsigned NOT NULL DEFAULT '0',
  `Last_Reply_ID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `Subdivision_ID` (`Subdivision_ID`),
  KEY `Last_Topic_ID` (`Last_Topic_ID`),
  KEY `Last_Reply_ID` (`Last_Reply_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `Forum_Groups`
--

CREATE TABLE IF NOT EXISTS `Forum_Groups` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Subdivision_ID` int(10) unsigned DEFAULT NULL,
  `Name` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `Priority` int(10) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `Parent_ID` (`Subdivision_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `Forum_Subdivisions`
--

CREATE TABLE IF NOT EXISTS `Forum_Subdivisions` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Subdivision_ID` int(10) unsigned NOT NULL DEFAULT '0',
  `Sub_Class_ID` int(10) unsigned NOT NULL DEFAULT '0',
  `Type` enum('parent','forum') NOT NULL DEFAULT 'parent',
  `Group_ID` int(10) unsigned NOT NULL,
  `Description` text NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Subdivision_ID` (`Subdivision_ID`),
  KEY `Sub_Class_ID` (`Sub_Class_ID`),
  KEY `Group_ID` (`Group_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `Forum_Topics`
--

CREATE TABLE IF NOT EXISTS `Forum_Topics` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Subdivision_ID` int(10) unsigned NOT NULL DEFAULT '0',
  `Topic_ID` int(10) unsigned NOT NULL DEFAULT '0',
  `Replies` int(10) unsigned NOT NULL DEFAULT '0',
  `Last_Reply_ID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `Subdivision_ID` (`Subdivision_ID`),
  KEY `Topic_ID` (`Topic_ID`),
  KEY `Last_Reply_ID` (`Last_Reply_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `Class`
--

INSERT INTO `Class` (`Class_ID`, `IsAuxiliary`, `Class_Name`, `Class_Group`, `DaysToHold`, `AllowTags`, `FormPrefix`, `FormSuffix`, `RecordTemplate`, `RecordsPerPage`, `SortBy`, `RecordTemplateFull`, `TitleTemplate`, `TitleList`, `UseAltTitle`, `AddTemplate`, `EditTemplate`, `AddActionTemplate`, `EditActionTemplate`, `SearchTemplate`, `FullSearchTemplate`, `SubscribeTemplate`, `System_Table_ID`, `Settings`, `AddCond`, `EditCond`, `SubscribeCond`, `DeleteCond`, `NL2BR`, `UseCaptcha`, `CheckActionTemplate`, `DeleteActionTemplate`, `CustomSettingsTemplate`, `ClassDescription`, `DeleteTemplate`, `ClassTemplate`, `Type`, `File_Mode`, `File_Path`, `File_Hash`) VALUES
(484, 1, 'Форум v2: Список форумов', 'Форум v2', 0, 0, '', '', '', 20, '', '', '', NULL, 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 0, 'useful', 1, '/484/', '10d8279af57288c1b855a6799fa77b0c'),
(485, 1, 'Форум v2: Топики', 'Форум v2', 0, 0, '', '', '', 20, '', '', '', NULL, 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 0, 'useful', 1, '/485/', '8924d958be2e46102625c573061bd19e'),
(486, 1, 'Форум v2: Ответы', 'Форум v2', 0, 0, '', '', '', 20, '', '', '', NULL, 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 0, 'useful', 1, '/486/', '01890f46dfcb30a5dc6ab124443a882b'),
(487, 1, 'Форум v2: Последние сообщения', 'Форум v2', 0, 0, '', '', '', 20, '', '', '', NULL, 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 0, 'useful', 1, '/487/', '289668368c0e2759acb77c233c4e1a30'),
(488, 1, 'Форум v2: Для личного кабинета', 'Форум v2', 0, 0, '', '', '', 20, '', '', '', NULL, 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 0, 'useful', 1, '/488/', '07ba3262ac27b1da8fdf7d9d02bde5aa'),
(489, 1, 'Форум v2: Список форумов', 'Шаблоны компонентов', 0, 0, '', '', '', 20, '', '', '', '', 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 484, 'responsive', 1, '/484/489/', '6c91d99839226760118683a2dfac597f'),
(490, 1, 'Форум v2: Список форумов (Мобильный)', 'Шаблоны компонентов', 0, 0, '', '', '', 20, '', '', '', '', 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 484, 'mobile', 1, '/484/490/', 'c6934480cffcb6b90b65b65dbf1364fa'),
(491, 1, 'Форум v2: Топики', 'Шаблоны компонентов', 0, 0, '', '', '', 20, '', '', '', '', 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 485, 'responsive', 1, '/485/491/', '533283e569381d61523b20d004bba608'),
(492, 1, 'Форум v2: Топики (Мобильный)', 'Шаблоны компонентов', 0, 0, '', '', '', 20, '', '', '', '', 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 485, 'mobile', 1, '/485/492/', '7d7fe44f094729b8304deb8eacc93904'),
(493, 1, 'Форум v2: Ответы', 'Шаблоны компонентов', 0, 0, '', '', '', 20, '', '', '', '', 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 486, 'responsive', 1, '/486/493/', '305d41f9516c3c9089ccf26f20e08e09'),
(495, 1, 'RSS', 'Шаблоны компонентов', 0, 0, '', '', '', 20, '', '', '', '', 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 484, 'rss', 1, '/484/495/', '99b1325518c730602c2f9f78bf744abb'),
(496, 1, 'RSS', 'Шаблоны компонентов', 0, 0, '', '', '', 20, '', '', '', '', 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 485, 'rss', 1, '/485/496/', '6623b8f8f569ad1f5875d5a58729008f'),
(497, 1, 'RSS', 'Шаблоны компонентов', 0, 0, '', '', '', 10, 'Message_ID ASC', '', '', '', 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 486, 'rss', 1, '/486/497/', 'b2248c90e688c897f6094fc350b70f4c'),
(503, 1, 'Форум v2: Ответы (Мобильный)', 'Шаблоны компонентов', 0, 0, NULL, NULL, NULL, 20, '', NULL, '', '', 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 486, 'mobile', 1, '/486/503/', 'c04afbccb1d4920fad8efe99403efbc8');

--
-- Дамп данных таблицы `Field`
--

INSERT INTO `Field` (`Field_ID`, `Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `Inheritance`, `System_Table_ID`, `Widget_Class_ID`, `TypeOfEdit_ID`, `Checked`) VALUES
(2332, 485, 'Subject', 'Заголовок топика', 1, '', 0, 0, 0, '', 0, 0, 0, 1, 1),
(2333, 485, 'Message', 'Сообщение топика', 3, '5:60;html:0;br:0;fck:0;bbcode:0;', 0, 1, 0, '', 0, 0, 0, 1, 1),
(2334, 485, 'Type', 'Тип топика', 4, 'ForumTopicType', 0, 2, 0, '', 0, 0, 0, 1, 1),
(2335, 485, 'Closed', 'Закрытый топик', 5, '', 0, 3, 0, '', 0, 0, 0, 1, 1),
(2336, 485, 'Views', 'Просмотры топика', 2, '', 0, 4, 0, '', 0, 0, 0, 1, 1),
(2337, 486, 'Subject', 'Заголовок ответа', 1, '', 0, 0, 0, '', 0, 0, 0, 1, 1),
(2338, 486, 'Message', 'Сообщение ответа', 3, '5:60;html:0;br:0;fck:0;bbcode:0;', 0, 1, 0, '', 0, 0, 0, 1, 1),
(2339, 486, 'Topic_ID', 'Идентификатор топика', 2, '', 0, 2, 0, '', 0, 0, 0, 1, 1);

--
-- Дамп данных таблицы `Classificator`
--

INSERT INTO `Classificator` (`Classificator_Name`, `Table_Name`, `System`, `Sort_Type`, `Sort_Direction`) VALUES
('Типы топиков форума', 'ForumTopicType', 0, 0, 0);

--
-- Структура таблицы `Classificator_ForumTopicType`
--

CREATE TABLE IF NOT EXISTS `Classificator_ForumTopicType` (
  `ForumTopicType_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ForumTopicType_Name` char(255) NOT NULL DEFAULT '',
  `ForumTopicType_Priority` int(11) NOT NULL,
  `Value` text,
  `Checked` int(1) DEFAULT '1',
  PRIMARY KEY (`ForumTopicType_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Дамп данных таблицы `Classificator_ForumTopicType`
--

INSERT INTO `Classificator_ForumTopicType` (`ForumTopicType_ID`, `ForumTopicType_Name`, `ForumTopicType_Priority`, `Value`, `Checked`) VALUES
(1, 'обычный', 1, NULL, 1),
(2, 'важный', 2, NULL, 1),
(3, 'объявление', 3, NULL, 1);

--
-- Структура таблицы `Message484`
--

CREATE TABLE IF NOT EXISTS `Message484` (
  `Message_ID` int(11) NOT NULL AUTO_INCREMENT,
  `User_ID` int(11) NOT NULL,
  `Subdivision_ID` int(11) NOT NULL,
  `Sub_Class_ID` int(11) NOT NULL,
  `Priority` int(11) NOT NULL DEFAULT '0',
  `Keyword` char(255) NOT NULL,
  `ncTitle` varchar(255) DEFAULT NULL,
  `ncKeywords` varchar(255) DEFAULT NULL,
  `ncDescription` text,
  `Checked` tinyint(4) NOT NULL DEFAULT '1',
  `IP` char(15) DEFAULT NULL,
  `UserAgent` char(255) DEFAULT NULL,
  `Parent_Message_ID` int(11) NOT NULL DEFAULT '0',
  `Created` datetime NOT NULL,
  `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `LastUser_ID` int(11) NOT NULL,
  `LastIP` char(15) DEFAULT NULL,
  `LastUserAgent` char(255) DEFAULT NULL,
  PRIMARY KEY (`Message_ID`),
  UNIQUE KEY `Sub_Class_ID` (`Sub_Class_ID`,`Message_ID`,`Keyword`),
  KEY `User_ID` (`User_ID`),
  KEY `LastUser_ID` (`LastUser_ID`),
  KEY `Subdivision_ID` (`Subdivision_ID`),
  KEY `Parent_Message_ID` (`Parent_Message_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `Message485`
--

CREATE TABLE IF NOT EXISTS `Message485` (
  `Message_ID` int(11) NOT NULL AUTO_INCREMENT,
  `User_ID` int(11) NOT NULL,
  `Subdivision_ID` int(11) NOT NULL,
  `Sub_Class_ID` int(11) NOT NULL,
  `Priority` int(11) NOT NULL DEFAULT '0',
  `Keyword` char(255) NOT NULL,
  `ncTitle` varchar(255) DEFAULT NULL,
  `ncKeywords` varchar(255) DEFAULT NULL,
  `ncDescription` text,
  `Checked` tinyint(4) NOT NULL DEFAULT '1',
  `IP` char(15) DEFAULT NULL,
  `UserAgent` char(255) DEFAULT NULL,
  `Parent_Message_ID` int(11) NOT NULL DEFAULT '0',
  `Created` datetime NOT NULL,
  `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `LastUser_ID` int(11) NOT NULL,
  `LastIP` char(15) DEFAULT NULL,
  `LastUserAgent` char(255) DEFAULT NULL,
  `Subject` char(255) DEFAULT NULL,
  `Message` longtext,
  `Type` int(11) DEFAULT NULL,
  `Closed` tinyint(4) DEFAULT NULL,
  `Views` int(11) DEFAULT NULL,
  PRIMARY KEY (`Message_ID`),
  UNIQUE KEY `Sub_Class_ID` (`Sub_Class_ID`,`Message_ID`,`Keyword`),
  KEY `User_ID` (`User_ID`),
  KEY `LastUser_ID` (`LastUser_ID`),
  KEY `Subdivision_ID` (`Subdivision_ID`),
  KEY `Parent_Message_ID` (`Parent_Message_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `Message486`
--

CREATE TABLE IF NOT EXISTS `Message486` (
  `Message_ID` int(11) NOT NULL AUTO_INCREMENT,
  `User_ID` int(11) NOT NULL,
  `Subdivision_ID` int(11) NOT NULL,
  `Sub_Class_ID` int(11) NOT NULL,
  `Priority` int(11) NOT NULL DEFAULT '0',
  `Keyword` char(255) NOT NULL,
  `ncTitle` varchar(255) DEFAULT NULL,
  `ncKeywords` varchar(255) DEFAULT NULL,
  `ncDescription` text,
  `Checked` tinyint(4) NOT NULL DEFAULT '1',
  `IP` char(15) DEFAULT NULL,
  `UserAgent` char(255) DEFAULT NULL,
  `Parent_Message_ID` int(11) NOT NULL DEFAULT '0',
  `Created` datetime NOT NULL,
  `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `LastUser_ID` int(11) NOT NULL,
  `LastIP` char(15) DEFAULT NULL,
  `LastUserAgent` char(255) DEFAULT NULL,
  `Subject` char(255) DEFAULT NULL,
  `Message` longtext,
  `Topic_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Message_ID`),
  UNIQUE KEY `Sub_Class_ID` (`Sub_Class_ID`,`Message_ID`,`Keyword`),
  KEY `User_ID` (`User_ID`),
  KEY `LastUser_ID` (`LastUser_ID`),
  KEY `Subdivision_ID` (`Subdivision_ID`),
  KEY `Parent_Message_ID` (`Parent_Message_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `Message487`
--

CREATE TABLE IF NOT EXISTS `Message487` (
  `Message_ID` int(11) NOT NULL AUTO_INCREMENT,
  `User_ID` int(11) NOT NULL,
  `Subdivision_ID` int(11) NOT NULL,
  `Sub_Class_ID` int(11) NOT NULL,
  `Priority` int(11) NOT NULL DEFAULT '0',
  `Keyword` char(255) NOT NULL,
  `ncTitle` varchar(255) DEFAULT NULL,
  `ncKeywords` varchar(255) DEFAULT NULL,
  `ncDescription` text,
  `Checked` tinyint(4) NOT NULL DEFAULT '1',
  `IP` char(15) DEFAULT NULL,
  `UserAgent` char(255) DEFAULT NULL,
  `Parent_Message_ID` int(11) NOT NULL DEFAULT '0',
  `Created` datetime NOT NULL,
  `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `LastUser_ID` int(11) NOT NULL,
  `LastIP` char(15) DEFAULT NULL,
  `LastUserAgent` char(255) DEFAULT NULL,
  PRIMARY KEY (`Message_ID`),
  UNIQUE KEY `Sub_Class_ID` (`Sub_Class_ID`,`Message_ID`,`Keyword`),
  KEY `User_ID` (`User_ID`),
  KEY `LastUser_ID` (`LastUser_ID`),
  KEY `Subdivision_ID` (`Subdivision_ID`),
  KEY `Parent_Message_ID` (`Parent_Message_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `Message488`
--

CREATE TABLE IF NOT EXISTS `Message488` (
  `Message_ID` int(11) NOT NULL AUTO_INCREMENT,
  `User_ID` int(11) NOT NULL,
  `Subdivision_ID` int(11) NOT NULL,
  `Sub_Class_ID` int(11) NOT NULL,
  `Priority` int(11) NOT NULL DEFAULT '0',
  `Keyword` char(255) NOT NULL,
  `ncTitle` varchar(255) DEFAULT NULL,
  `ncKeywords` varchar(255) DEFAULT NULL,
  `ncDescription` text,
  `Checked` tinyint(4) NOT NULL DEFAULT '1',
  `IP` char(15) DEFAULT NULL,
  `UserAgent` char(255) DEFAULT NULL,
  `Parent_Message_ID` int(11) NOT NULL DEFAULT '0',
  `Created` datetime NOT NULL,
  `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `LastUser_ID` int(11) NOT NULL,
  `LastIP` char(15) DEFAULT NULL,
  `LastUserAgent` char(255) DEFAULT NULL,
  PRIMARY KEY (`Message_ID`),
  UNIQUE KEY `Sub_Class_ID` (`Sub_Class_ID`,`Message_ID`,`Keyword`),
  KEY `User_ID` (`User_ID`),
  KEY `LastUser_ID` (`LastUser_ID`),
  KEY `Subdivision_ID` (`Subdivision_ID`),
  KEY `Parent_Message_ID` (`Parent_Message_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;