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

INSERT INTO `Module` (`Module_Name`, `Keyword`, `Description`, `Parameters`, `Example_URL`, `Help_URL`, `Installed`, `Number`, `Inside_Admin`, `Checked`) VALUES
('NETCAT_MODULE_BANNER', 'banner', 'NETCAT_MODULE_BANNER_DESCRIPTION', 'ZONE_TABLE=185\r\nSCRIPT_TABLE=186\r\nSCRIPT_EXCLUSION_TABLE=187\r\nBANNER_TABLE=188\r\nCAMPAIGN_TABLE=190\r\n', '', '/settings/modules/banner/', 1, '', 0, 1);

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

CREATE TABLE IF NOT EXISTS `Banner_CampaignBanner` (
  `Campaign_ID` int(11) NOT NULL DEFAULT '0',
  `Banner_ID` int(11) NOT NULL DEFAULT '0',
  `LastShow` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Campaign_ID`,`Banner_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `Banner_CampaignZone` (
  `Campaign_ID` int(11) NOT NULL DEFAULT '0',
  `Zone_ID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Campaign_ID`,`Zone_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `Banner_Log` (
  `Log_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `User_ID` int(11) NOT NULL DEFAULT '0',
  `IP` varchar(15) NOT NULL DEFAULT '',
  `UserAgent` varchar(255) NOT NULL DEFAULT '',
  `Code` varchar(32) NOT NULL DEFAULT '',
  `Campaign_ID` int(11) NOT NULL DEFAULT '0',
  `Zone_ID` int(11) NOT NULL DEFAULT '0',
  `Banner_ID` int(11) NOT NULL DEFAULT '0',
  `Referer` varchar(255) NOT NULL DEFAULT '',
  `Clicked` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Log_ID`),
  KEY `User_ID` (`User_ID`),
  KEY `Code` (`IP`,`UserAgent`,`Code`),
  KEY `Campaign_ID` (`Campaign_ID`),
  KEY `Zone_ID` (`Zone_ID`),
  KEY `Banner_ID` (`Banner_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `Banner_StatsBanner` (
  `Date` date NOT NULL DEFAULT '0000-00-00',
  `Hour` int(11) NOT NULL DEFAULT '0',
  `Banner_ID` int(11) NOT NULL DEFAULT '0',
  `Shows` int(11) NOT NULL DEFAULT '0',
  `Clicks` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Date`,`Hour`,`Banner_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `Banner_StatsCampaign` (
  `Date` date NOT NULL DEFAULT '0000-00-00',
  `Campaign_ID` int(11) NOT NULL DEFAULT '0',
  `Hour` int(11) NOT NULL DEFAULT '0',
  `Shows` int(11) NOT NULL DEFAULT '0',
  `Clicks` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Date`,`Hour`,`Campaign_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `Banner_StatsReferer` (
  `Date` date NOT NULL DEFAULT '0000-00-00',
  `Referer` char(255) NOT NULL DEFAULT '',
  `Shows` int(11) NOT NULL DEFAULT '0',
  `Clicks` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Date`,`Referer`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `Banner_StatsZone` (
  `Date` date NOT NULL DEFAULT '0000-00-00',
  `Zone_ID` int(11) NOT NULL DEFAULT '0',
  `Hour` int(11) NOT NULL DEFAULT '0',
  `Shows` int(11) NOT NULL DEFAULT '0',
  `Clicks` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Date`,`Hour`,`Zone_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Дамп данных таблицы `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
(185, 1, 'Баннерные зоны', 'Баннеры', 0, 0, '', '', '', 20, '', '', '', '', 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', '', '', '', 0, 'useful', 1, '/185/', '69beef2367f8a9874f240ad1a42c0e4e'),
(186, 1, 'Сценарии показов', 'Баннеры', 0, 0, '', '', '', 20, '', '', '$f_RowID. $f_Name', '', 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', '', '', '', 0, 'useful', 1, '/186/', ''),
(187, 1, 'Исключения в сценариях', 'Баннеры', 0, 0, '', '', '', 100, '', '', '', '', 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', '', '', '', 0, 'useful', 1, '/187/', ''),
(188, 1, 'Баннеры', 'Баннеры', 0, 0, '', '', '', 20, 'Message_ID', '', '', '', 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', '', '', '', 0, 'useful', 1, '/188/', ''),
(190, 1, 'Рекламные кампании', 'Баннеры', 0, 0, '', '', '', 20, '', '', '', '', 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', '', '', '', 0, 'useful', 1, '/190/', ''),
(241, 1, 'Баннеры простые', 'Баннеры', 0, 0, '', '', '', 20, '', '', '', NULL, 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', '', '', '', 0, 'useful', 1, '/241/', ''),
(394, 1, 'Для корзины удаленных объектов', 'Шаблоны компонентов', 0, 0, '', '', '', 20, '', '', NULL, NULL, 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 185, 'trash', 1, '/185/394/', 'bcc2ce3c98846eebfb02f130bd4e9180'),
(395, 1, 'Для корзины удаленных объектов', 'Шаблоны компонентов', 0, 0, '', '', '', 20, '', '', NULL, NULL, 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 186, 'trash', 1, '/186/395/', 'bcc2ce3c98846eebfb02f130bd4e9180'),
(396, 1, 'Для корзины удаленных объектов', 'Шаблоны компонентов', 0, 0, '', '', '', 20, '', '', NULL, NULL, 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 187, 'trash', 1, '/187/396/', '22b16883be8c038b4f9a688718853bdd'),
(397, 1, 'Для корзины удаленных объектов', 'Шаблоны компонентов', 0, 0, '', '', '', 20, '', '', NULL, NULL, 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 188, 'trash', 1, '/188/397/', '1bff9b2220853d4eb1fb51fed66a5661'),
(398, 1, 'Для корзины удаленных объектов', 'Шаблоны компонентов', 0, 0, '', '', '', 20, '', '', NULL, NULL, 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 190, 'trash', 1, '/190/398/', 'bcc2ce3c98846eebfb02f130bd4e9180'),
(399, 1, 'Для корзины удаленных объектов', 'Шаблоны компонентов', 0, 0, '', '', '', 20, '', '', NULL, NULL, 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', 1, 0, '', '', NULL, NULL, '', 241, 'trash', 1, '/241/399/', 'bcc2ce3c98846eebfb02f130bd4e9180');

--
-- Дамп данных таблицы `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
(1976, 185, 'Name', 'Название', 1, '', 1, 0, 0, '', 0, 0, 0, 1, 1),
(1977, 185, 'Size', 'Размер', 4, 'BannerSize', 0, 1, 0, '', 0, 0, 0, 1, 1),
(1978, 185, 'Site', 'Сайт', 2, '', 1, 2, 1, '', 0, 0, 0, 1, 1),
(1979, 185, 'Section', 'Раздел', 2, '', 0, 3, 1, '', 0, 0, 0, 1, 1),
(1980, 185, 'Class', 'Компонент в разделе', 2, '', 0, 4, 1, '', 0, 0, 0, 1, 1),
(1981, 185, 'Object', 'Объект', 2, '', 0, 5, 1, '', 0, 0, 0, 1, 1),
(1982, 185, 'BannerDivider', 'Разделитель между баннерами', 1, '', 0, 6, 0, '', 0, 0, 0, 1, 1),
(1512, 186, 'Name', 'Название', 1, '', 1, 0, 0, '', 0, 0, 0, 1, 1),
(1513, 186, 'TimeZone1', 'Время показа: 00:00 - 01:00', 5, '', 1, 1, 1, '', 0, 0, 0, 1, 1),
(1514, 186, 'TimeZone2', 'Время показа: 01:00 - 02:00', 5, '', 1, 2, 1, '', 0, 0, 0, 1, 1),
(1515, 186, 'TimeZone3', 'Время показа: 02:00 - 03:00', 5, '', 1, 3, 1, '', 0, 0, 0, 1, 1),
(1516, 186, 'TimeZone4', 'Время показа: 03:00 - 04:00', 5, '', 1, 4, 1, '', 0, 0, 0, 1, 1),
(1517, 186, 'TimeZone5', 'Время показа: 04:00 - 05:00', 5, '', 1, 5, 1, '', 0, 0, 0, 1, 1),
(1518, 186, 'TimeZone6', 'Время показа: 05:00 - 06:00', 5, '', 1, 6, 1, '', 0, 0, 0, 1, 1),
(1519, 186, 'TimeZone7', 'Время показа: 06:00 - 07:00', 5, '', 1, 7, 1, '', 0, 0, 0, 1, 1),
(1520, 186, 'TimeZone8', 'Время показа: 07:00 - 08:00', 5, '', 1, 8, 1, '', 0, 0, 0, 1, 1),
(1521, 186, 'TimeZone9', 'Время показа: 08:00 - 09:00', 5, '', 1, 9, 1, '', 0, 0, 0, 1, 1),
(1522, 186, 'TimeZone10', 'Время показа: 09:00 - 10:00', 5, '', 1, 10, 1, '', 0, 0, 0, 1, 1),
(1523, 186, 'TimeZone11', 'Время показа: 10:00 - 11:00', 5, '', 1, 11, 1, '', 0, 0, 0, 1, 1),
(1524, 186, 'TimeZone12', 'Время показа: 11:00 - 12:00', 5, '', 1, 12, 1, '', 0, 0, 0, 1, 1),
(1525, 186, 'TimeZone13', 'Время показа: 12:00 - 13:00', 5, '', 1, 13, 1, '', 0, 0, 0, 1, 1),
(1526, 186, 'TimeZone14', 'Время показа: 13:00 - 14:00', 5, '', 1, 14, 1, '', 0, 0, 0, 1, 1),
(1527, 186, 'TimeZone15', 'Время показа: 14:00 - 15:00', 5, '', 1, 15, 1, '', 0, 0, 0, 1, 1),
(1528, 186, 'TimeZone16', 'Время показа: 15:00 - 16:00', 5, '', 1, 16, 1, '', 0, 0, 0, 1, 1),
(1529, 186, 'TimeZone17', 'Время показа: 16:00 - 17:00', 5, '', 1, 17, 1, '', 0, 0, 0, 1, 1),
(1530, 186, 'TimeZone18', 'Время показа: 17:00 - 18:00', 5, '', 1, 18, 1, '', 0, 0, 0, 1, 1),
(1531, 186, 'TimeZone19', 'Время показа: 18:00 - 19:00', 5, '', 1, 19, 1, '', 0, 0, 0, 1, 1),
(1532, 186, 'TimeZone20', 'Время показа: 19:00 - 20:00', 5, '', 1, 20, 1, '', 0, 0, 0, 1, 1),
(1533, 186, 'TimeZone21', 'Время показа: 20:00 - 21:00', 5, '', 1, 21, 1, '', 0, 0, 0, 1, 1),
(1534, 186, 'TimeZone22', 'Время показа: 21:00 - 22:00', 5, '', 1, 22, 1, '', 0, 0, 0, 1, 1),
(1535, 186, 'TimeZone23', 'Время показа: 22:00 - 23:00', 5, '', 1, 23, 1, '', 0, 0, 0, 1, 1),
(1536, 186, 'TimeZone24', 'Время показа: 23:00 - 24:00', 5, '', 1, 24, 1, '', 0, 0, 0, 1, 1),
(1537, 186, 'Day1', 'Дни показа: понедельник', 5, '', 1, 25, 1, '', 0, 0, 0, 1, 1),
(1538, 186, 'Day2', 'Дни показа: вторник', 5, '', 1, 26, 1, '', 0, 0, 0, 1, 1),
(1539, 186, 'Day3', 'Дни показа: среда', 5, '', 1, 27, 1, '', 0, 0, 0, 1, 1),
(1540, 186, 'Day4', 'Дни показа: четверг', 5, '', 1, 28, 1, '', 0, 0, 0, 1, 1),
(1541, 186, 'Day5', 'Дни показа: пятница', 5, '', 1, 29, 1, '', 0, 0, 0, 1, 1),
(1542, 186, 'Day6', 'Дни показа: суббота', 5, '', 1, 30, 1, '', 0, 0, 0, 1, 1),
(1543, 186, 'Day7', 'Дни показа: воскресенье', 5, '', 1, 31, 1, '', 0, 0, 0, 1, 1),
(1544, 187, 'Script', 'Номер сценария показов', 2, '', 1, 0, 1, '', 0, 0, 0, 1, 1),
(1545, 187, 'Site', 'Сайт', 2, '', 0, 1, 1, '', 0, 0, 0, 1, 1),
(1546, 187, 'Section', 'Раздел', 2, '', 0, 2, 1, '', 0, 0, 0, 1, 1),
(1547, 187, 'Class', 'Компонент в разделе', 2, '', 0, 3, 1, '', 0, 0, 0, 1, 1),
(1548, 187, 'Object', 'Объект', 2, '', 0, 4, 1, '', 0, 0, 0, 1, 1),
(1549, 187, 'ExcludeSubsections', 'Не показывать в подразделах', 5, '', 1, 5, 0, '', 0, 0, 0, 1, 1),
(1550, 188, 'Type', 'Тип баннера', 4, 'BannerType', 1, 0, 0, '', 0, 0, 0, 1, 1),
(1551, 188, 'Size', 'Размер', 4, 'BannerSize', 0, 1, 1, '', 0, 0, 0, 1, 1),
(1552, 188, 'File', 'Файл', 6, '50000:fs3:inline', 0, 2, 0, '', 0, 0, 0, 1, 1),
(1553, 188, 'Alt', 'Alt (для GIF/JPEG)', 1, '', 0, 3, 0, '', 0, 0, 0, 1, 1),
(1554, 188, 'Text', 'Текст HTML-баннера', 3, '6:60;html:0;br:0;fck:1;bbcode:0;', 0, 4, 0, '', 0, 0, 0, 1, 1),
(1555, 188, 'Link', 'Ссылка баннера', 1, 'url', 1, 5, 0, '', 0, 0, 0, 1, 1),
(1556, 188, 'Script', 'Номер сценария показа', 2, '', 1, 6, 0, '1', 0, 0, 0, 1, 1),
(1557, 188, 'NewWindow', 'Открывать ссылку в новом окне', 5, '', 1, 7, 0, '', 0, 0, 0, 1, 1),
(1558, 188, 'Status', 'включить баннер', 5, '', 1, 8, 1, '', 0, 0, 0, 1, 1),
(1559, 190, 'Size', 'Размер баннеров', 4, 'BannerSize', 0, 0, 1, '', 0, 0, 0, 1, 1),
(1560, 190, 'Name', 'Название', 1, '', 1, 1, 0, '', 0, 0, 0, 1, 1),
(1561, 190, 'Start', 'Дата старта', 8, '', 0, 2, 1, '', 0, 0, 0, 1, 1),
(1562, 190, 'Stop', 'Дата окончания', 8, '', 0, 3, 1, '', 0, 0, 0, 1, 1),
(1563, 190, 'Shows', 'Количество показов', 2, '', 0, 4, 1, '', 0, 0, 0, 1, 1),
(1564, 190, 'Main', 'Приостановить показы баннеров', 5, '', 1, 5, 1, '', 0, 0, 0, 1, 1),
(1565, 190, 'Showed', 'Показано баннеров', 2, '', 0, 6, 1, '0', 0, 0, 0, 1, 1),
(1863, 241, 'ClickNum', 'Количество кликов', 2, '', 0, 4, 0, '0', 0, 0, 0, 1, 1),
(1862, 241, 'ShowNum', 'Количество показов', 2, '', 0, 3, 0, '0', 0, 0, 0, 1, 1),
(1861, 241, 'File', 'Файл', 6, 'fs3:inline', 1, 2, 0, '', 0, 0, 0, 1, 1),
(1860, 241, 'Link', 'Ссылка', 1, 'url', 1, 1, 0, '', 0, 0, 0, 1, 1),
(1859, 241, 'Name', 'Название', 1, '', 1, 0, 0, '', 0, 0, 0, 1, 1);

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

INSERT INTO `Classificator` (`Classificator_Name`, `Table_Name`, `System`, `Sort_Type`, `Sort_Direction`) VALUES
('Размеры баннеров', 'BannerSize', 0, 0, 0),
('Типы баннеров', 'BannerType', 0, 0, 0);

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

CREATE TABLE IF NOT EXISTS `Classificator_BannerSize` (
  `BannerSize_ID` int(11) NOT NULL AUTO_INCREMENT,
  `BannerSize_Name` char(255) NOT NULL DEFAULT '',
  `BannerSize_Priority` int(11) DEFAULT NULL,
  `Value` text,
  `Checked` int(1) DEFAULT '1',
  PRIMARY KEY (`BannerSize_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

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

INSERT INTO `Classificator_BannerSize` (`BannerSize_ID`, `BannerSize_Name`, `BannerSize_Priority`, `Value`, `Checked`) VALUES
(1, '468x60', 1, NULL, 1),
(2, '100x100', 2, NULL, 1),
(3, '120x60', 3, NULL, 1),
(4, '234x60', 4, NULL, 1),
(5, '120x600', 5, NULL, 1),
(6, '600x90', 6, NULL, 1),
(7, '200x200', 6, NULL, 1);

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

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

CREATE TABLE IF NOT EXISTS `Classificator_BannerType` (
  `BannerType_ID` int(11) NOT NULL AUTO_INCREMENT,
  `BannerType_Name` char(255) NOT NULL DEFAULT '',
  `BannerType_Priority` int(11) DEFAULT NULL,
  `Value` text,
  `Checked` int(1) DEFAULT '1',
  PRIMARY KEY (`BannerType_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

INSERT INTO `Classificator_BannerType` (`BannerType_ID`, `BannerType_Name`, `BannerType_Priority`, `Value`, `Checked`) VALUES
(1, 'GIF/JPEG', 1, NULL, 1),
(2, 'Flash', 2, NULL, 1),
(3, 'HTML/текст', 3, NULL, 1);

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

INSERT INTO `CronTasks` (`Cron_Minutes`, `Cron_Hours`, `Cron_Days`, `Cron_Months`, `Cron_Weekdays`, `Cron_Script_URL`, `Cron_Launch`) VALUES
(0, 0, 1, 0, 0, '/netcat/modules/banner/cron.php?param=test', NULL);

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

CREATE TABLE IF NOT EXISTS `Message185` (
  `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',
  `TimeToDelete` date DEFAULT NULL,
  `TimeToUncheck` date DEFAULT NULL,
  `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,
  `Name` char(255) NOT NULL,
  `Size` int(11) DEFAULT NULL,
  `Site` int(11) NOT NULL,
  `Section` int(11) DEFAULT NULL,
  `Class` int(11) DEFAULT NULL,
  `Object` int(11) DEFAULT NULL,
  `BannerDivider` 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`),
  KEY `Site` (`Site`),
  KEY `Section` (`Section`),
  KEY `Class` (`Class`),
  KEY `Object` (`Object`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `Message186` (
  `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',
  `TimeToDelete` date DEFAULT NULL,
  `TimeToUncheck` date DEFAULT NULL,
  `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,
  `Name` char(255) NOT NULL,
  `TimeZone1` tinyint(4) NOT NULL,
  `TimeZone2` tinyint(4) NOT NULL,
  `TimeZone3` tinyint(4) NOT NULL,
  `TimeZone4` tinyint(4) NOT NULL,
  `TimeZone5` tinyint(4) NOT NULL,
  `TimeZone6` tinyint(4) NOT NULL,
  `TimeZone7` tinyint(4) NOT NULL,
  `TimeZone8` tinyint(4) NOT NULL,
  `TimeZone9` tinyint(4) NOT NULL,
  `TimeZone10` tinyint(4) NOT NULL,
  `TimeZone11` tinyint(4) NOT NULL,
  `TimeZone12` tinyint(4) NOT NULL,
  `TimeZone13` tinyint(4) NOT NULL,
  `TimeZone14` tinyint(4) NOT NULL,
  `TimeZone15` tinyint(4) NOT NULL,
  `TimeZone16` tinyint(4) NOT NULL,
  `TimeZone17` tinyint(4) NOT NULL,
  `TimeZone18` tinyint(4) NOT NULL,
  `TimeZone19` tinyint(4) NOT NULL,
  `TimeZone20` tinyint(4) NOT NULL,
  `TimeZone21` tinyint(4) NOT NULL,
  `TimeZone22` tinyint(4) NOT NULL,
  `TimeZone23` tinyint(4) NOT NULL,
  `TimeZone24` tinyint(4) NOT NULL,
  `Day1` tinyint(4) NOT NULL,
  `Day2` tinyint(4) NOT NULL,
  `Day3` tinyint(4) NOT NULL,
  `Day4` tinyint(4) NOT NULL,
  `Day5` tinyint(4) NOT NULL,
  `Day6` tinyint(4) NOT NULL,
  `Day7` tinyint(4) NOT 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`),
  KEY `TimeZone1` (`TimeZone1`),
  KEY `TimeZone2` (`TimeZone2`),
  KEY `TimeZone3` (`TimeZone3`),
  KEY `TimeZone4` (`TimeZone4`),
  KEY `TimeZone5` (`TimeZone5`),
  KEY `TimeZone6` (`TimeZone6`),
  KEY `TimeZone7` (`TimeZone7`),
  KEY `TimeZone8` (`TimeZone8`),
  KEY `TimeZone9` (`TimeZone9`),
  KEY `TimeZone10` (`TimeZone10`),
  KEY `TimeZone11` (`TimeZone11`),
  KEY `TimeZone12` (`TimeZone12`),
  KEY `TimeZone13` (`TimeZone13`),
  KEY `TimeZone14` (`TimeZone14`),
  KEY `TimeZone15` (`TimeZone15`),
  KEY `TimeZone16` (`TimeZone16`),
  KEY `TimeZone17` (`TimeZone17`),
  KEY `TimeZone18` (`TimeZone18`),
  KEY `TimeZone19` (`TimeZone19`),
  KEY `TimeZone20` (`TimeZone20`),
  KEY `TimeZone21` (`TimeZone21`),
  KEY `TimeZone22` (`TimeZone22`),
  KEY `TimeZone23` (`TimeZone23`),
  KEY `TimeZone24` (`TimeZone24`),
  KEY `Day1` (`Day1`),
  KEY `Day2` (`Day2`),
  KEY `Day3` (`Day3`),
  KEY `Day4` (`Day4`),
  KEY `Day5` (`Day5`),
  KEY `Day6` (`Day6`),
  KEY `Day7` (`Day7`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `Message187` (
  `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',
  `TimeToDelete` date DEFAULT NULL,
  `TimeToUncheck` date DEFAULT NULL,
  `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,
  `Script` int(11) NOT NULL,
  `Site` int(11) DEFAULT NULL,
  `Section` int(11) DEFAULT NULL,
  `Class` int(11) DEFAULT NULL,
  `Object` int(11) DEFAULT NULL,
  `ExcludeSubsections` tinyint(4) NOT 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`),
  KEY `Script` (`Script`),
  KEY `Site` (`Site`),
  KEY `Section` (`Section`),
  KEY `Class` (`Class`),
  KEY `Object` (`Object`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `Message188` (
  `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',
  `TimeToDelete` date DEFAULT NULL,
  `TimeToUncheck` date DEFAULT NULL,
  `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,
  `Type` int(11) NOT NULL,
  `Size` int(11) DEFAULT NULL,
  `File` char(255) DEFAULT NULL,
  `Alt` char(255) DEFAULT NULL,
  `Text` longtext,
  `Link` char(255) NOT NULL,
  `Script` int(11) NOT NULL DEFAULT '1',
  `NewWindow` tinyint(4) NOT NULL,
  `Status` tinyint(4) NOT 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`),
  KEY `Size` (`Size`),
  KEY `Status` (`Status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `Message190` (
  `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',
  `TimeToDelete` date DEFAULT NULL,
  `TimeToUncheck` date DEFAULT NULL,
  `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,
  `Size` int(11) DEFAULT NULL,
  `Name` char(255) NOT NULL,
  `Start` datetime DEFAULT NULL,
  `Stop` datetime DEFAULT NULL,
  `Shows` int(11) DEFAULT NULL,
  `Main` tinyint(4) NOT NULL,
  `Showed` int(11) NOT 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`),
  KEY `Size` (`Size`),
  KEY `Start` (`Start`),
  KEY `Stop` (`Stop`),
  KEY `Shows` (`Shows`),
  KEY `Main` (`Main`),
  KEY `Showed` (`Showed`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `Message241` (
  `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',
  `TimeToDelete` date DEFAULT NULL,
  `TimeToUncheck` date DEFAULT NULL,
  `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,
  `Name` char(255) NOT NULL,
  `Link` char(255) NOT NULL,
  `File` char(255) NOT NULL,
  `ShowNum` int(11) NOT NULL DEFAULT '0',
  `ClickNum` int(11) NOT NULL DEFAULT '0',
  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 ;