4.1
-- NetCat 4.1 Extra [0] component file, generated 2010-10-04 12:26:19
INSERT INTO `Class` SET `Class_Name` = 'Корпоративные: Корпоративные контакты', `Class_Group` = 'Корпоративные', `DaysToHold` = '0', `AllowTags` = '1', `FormPrefix` = '$f_AdminCommon\n<div class=\'nc_list nc_corp_contacts\'>', `FormSuffix` = '</div>', `RecordTemplate` = '<div class=\'nc_row\'>$f_AdminButtons\n".opt( $cc_settings[Group] && $GroupHeader=( $curGr!=$f_Department ? $curGr=$f_Department : NULL ) , "<h4 class=\'nc_group\'>$GroupHeader</h4>" )."\n<h3>$f_FIO</h3>\n".opt( $f_Department , "<div class=\'nc_item\'><span class=\'nc_title\'>Название отдела: </span><span class=\'nc_value\'>$f_Department</span></div>" )."\n".opt( $f_Post , "<div class=\'nc_item\'><span class=\'nc_title\'>Должность: </span><span class=\'nc_value\'>$f_Post</span></div>" )."\n".opt( $f_Email , "<div class=\'nc_item\'><span class=\'nc_title\'>E-mail: </span><span class=\'nc_value\'><a href=\'mailto:$f_Email\'>$f_Email</a></span></div>" )."\n".opt( $f_PhoneNumber , "<div class=\'nc_item\'><span class=\'nc_title\'>Телефон: </span><span class=\'nc_value\'>$f_PhoneNumber</span></div>" )."\n".opt( $f_Description , "<div class=\'nc_description\'>$f_Description</div>" )."\n\n</div>\n', `RecordsPerPage` = '20', `SortBy` = '', `RecordTemplateFull` = '', `TitleTemplate` = '', `AddTemplate` = '', `EditTemplate` = '', `AddActionTemplate` = '', `EditActionTemplate` = '', `SearchTemplate` = '', `FullSearchTemplate` = '', `SubscribeTemplate` = '', `System_Table_ID` = '0', `Settings` = '$query_order = ($cc_settings[\'Group\'] ? \'Department,\' : \'\' ).( $cc_settings[\'Sort\']==\'alpha\' ? \'FIO\' : \'Priority\' );\n$curGr = NULL;', `AddCond` = '', `EditCond` = '', `SubscribeCond` = '', `DeleteCond` = '', `NL2BR` = '0', `UseCaptcha` = '0', `CheckActionTemplate` = '', `DeleteActionTemplate` = '', `CustomSettingsTemplate` = '$settings_array = array(\n \'Sort\' => array(\'type\' => \'select\',\n   \'default_value\' => \'alpha\',\n   \'caption\' => \'Сортировка\',\n    \'values\' => array(\'alpha\' => \'по алфавиту\' , \'reg\' => \'по очереди\')\n ),\n  \'Group\' => array(\'type\' => \'checkbox\',\n    \'caption\' => \'Группировать по отделам\'  \n  )\n);', `ClassDescription` = 'Компонент позволяет отображать список контактных лиц \nкомпании с возможностью настройки визуализации.\n\nПоля: ФИО, название отдела, должность, e-mail, телефон, \nдополнительный текст.', `DeleteTemplate` = '', `ClassTemplate` = '0', `CacheForUser` = '0';
CREATE TABLE Message%INSERT_ID% (`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, `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, `FIO` char(255) NOT NULL, `Department` char(255) NULL, `Post` char(255) NULL, `Email` char(255) NULL, `PhoneNumber` char(255) NULL, `Description` text 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`) ) TYPE=MyISAM;
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'FIO', 'ФИО', 1, '', 1, 0, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Department', 'Название отдела', 1, '', 0, 1, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Post', 'Должность', 1, '', 0, 2, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Email', 'E-mail', 1, '', 0, 3, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'PhoneNumber', 'Телефон', 1, '', 0, 4, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Description', 'Дополнительно', 3, '4:60', 0, 5, 0, '', 1);