3.0
INSERT INTO Class SET Class_Name = 'Корпоративные: Проекты', Class_Group = 'Корпоративные', DaysToHold = '0', AllowTags = '1', FormPrefix = '$f_AdminCommon\n<div class=\'nc_list nc_projects\'>\n".opt( $nc_clients && $totRows , "Проекты: " )."', FormSuffix = '</div>\n\n".opt( !$nc_title && $totRows>$f_RowNum , "\n<div class=\'nc_pagination\'>\n".opt($cc_settings[\'PaginationMode\']!=\'nums\',"\n <div class=\'nc_prev_next\'>\n  <span class=\'nc_prev_link\'>".opt_case($prevLink , "<a href=\'$prevLink\'>Назад</a>","Назад")."</span>\n  <span class=\'nc_next_link\'>".opt_case($nextLink, "<a href=\'$nextLink\'>Далее</a>","Далее")."</span>\n </div>\n").opt($cc_settings[\'PaginationMode\']!=\'next_prev\',"\n  <div class=\'nc_pagination\'>Страницы: ".browse_messages($cc_env, 5)."</div>\n")."</div>")."', RecordTemplate = '$f_AdminButtons\n<div class=\'nc_row\'>\n".opt_case( $nc_clients , "<div class=\'nc_item\'><a href=\'$fullLink\'>$f_Title</a></div>" , \n\nopt( $cc_settings[Group]==\'date\'&& $groupHeader=( $curDep == $f_Date_day ? NULL : $curDep=$f_Date_day ) , "<h4 class=\'nc_group\'>$groupHeader.$f_Date_month.$f_Date_year</h4>" ).\nopt( $cc_settings[Group]==\'month\'&& $groupHeader=( $curDep == $f_Date_month ? NULL : $curDep=$f_Date_month ) , "<h4 class=\'nc_group\'>$groupHeader.$f_Date_year</h4>" ).\n\nopt( $f_Title , "<h3>$f_Title</h3>" )\n.opt( $cc_settings[DateStyle]!=\'disable\' , "<div class=\'nc_datetime\'>".\nopt( $cc_settings[FullLink]==\'date\' && ($f_Text || $f_ExtLink) , "<a href=\'".opt_case($f_Text,$fullLink,$f_ExtLink)."\'>").\nopt( $cc_settings[DateStyle]!=\'time\' , "<span class=\'nc_date\'>$f_Date_day.$f_Date_month.$f_Date_year </span>" ).\nopt( $cc_settings[DateStyle]!=\'date\' , "<span class=\'nc_time\'>$f_Date_hours:$f_Date_minutes </span>" ).\nopt( $cc_settings[FullLink]==\'date\' && ($f_Text || $f_ExtLink) , "</a>" )."</div>"\n)\n.opt( $f_Description , "<div class=\'nc_description\'>$f_Description</div>" )."\n".opt( $f_File , "<a href=\'$f_File\'>Скачать файл...</a>" )."\n" )."\n</div>', RecordsPerPage = '20', SortBy = '', RecordTemplateFull = '<div class=\'nc_full nc_projects\'>\n\n\n".opt( $cc_settings[Group]==\'date\'&& $groupHeader=( $curDep == $f_Date_day ? NULL : $curDep=$f_Date_day ) , "<h3 class=\'nc_group\'>$groupHeader.$f_Date_month.$f_Date_year</h3>" ).\nopt( $cc_settings[Group]==\'month\'&& $groupHeader=( $curDep == $f_Date_month ? NULL : $curDep=$f_Date_month ) , "<h3 class=\'nc_group\'>$groupHeader.$f_Date_year</h3>" ).\n\nopt( $f_Title , "<h2>$f_Title</h2>" )\n.opt( $f_Description , "<div class=\'nc_description\'>$f_Description</div>" )."\n".opt( $f_File , "<a href=\'$f_File\'>Скачать файл...</a>" )\n.opt( $cc_settings[DateStyle]!=\'disable\' , "<div class=\'nc_datetime\'>".\nopt( $cc_settings[FullLink]==\'date\' && ($f_Text || $f_ExtLink) , "<a href=\'".opt_case($f_Text,$fullLink,$f_ExtLink)."\'>").\nopt( $cc_settings[DateStyle]!=\'time\' , "<span class=\'nc_date\'>$f_Date_day.$f_Date_month.$f_Date_year </span>" ).\nopt( $cc_settings[DateStyle]!=\'date\' , "<span class=\'nc_time\'>$f_Date_hours:$f_Date_minutes </span>" ).\nopt( $cc_settings[FullLink]==\'date\' && ($f_Text || $f_ExtLink) , "</a>" )."</div>"\n)."\n</div>', TitleTemplate = '', AddTemplate = '', EditTemplate = '', AddActionTemplate = '', EditActionTemplate = '', SearchTemplate = '', FullSearchTemplate = '', SubscribeTemplate = '', Settings = 'if($nc_clients) $query_where = \'ClientID=\'.(int)$nc_client_id;', AddCond = '', EditCond = '', SubscribeCond = '', NL2BR = '0', CheckActionTemplate = '', DeleteActionTemplate = '', CustomSettingsTemplate = '$settings_array = array(\n	\'PaginationMode\' => array(\'type\' => \'select\',\n		\'default_value\' => \'next_prev\',\n		\'caption\' => \'Листинг по страницам\',\n		\'values\' => array(\'next_prev\' => \'вперед/назад\', \'nums\' => \'по номерам страниц\', \'all\'=>\'оба варианта\')\n	),\n	\'DateStyle\' => array(\'type\' => \'select\',\n		\'default_value\' => \'dt\',\n		\'caption\' => \'Стиль вывода даты и времени объектов\',\n		\'values\' => array(\'dt\' => \'дата и время\', \'date\' => \'только дата\', \'time\' => \'только время\', \'disable\' => \'не выводить\')\n	),\n	\'Group\' => array(\'type\' => \'select\',\n		\'default_value\' => \'disable\',\n		\'caption\' => \'Группировка объектов\',\n		\'values\' => array(\'disable\' => \'не группировать\', \'date\' => \'по дате\', \'month\' => \'по месяцам\'),\n	)\n);';
CREATE TABLE Message%INSERT_ID%  (Message_ID int(11) NOT NULL auto_increment,User_ID int(11) NOT NULL default '0',Subdivision_ID int(11) NOT NULL default '0',Sub_Class_ID int(11) NOT NULL default '0',Priority int(11) NOT NULL default '0',Checked tinyint(4) NOT NULL default '1',TimeToDelete date default NULL,TimeToUncheck date default NULL,IP varchar(15) default NULL,UserAgent varchar(255) default NULL,Parent_Message_ID int(11) NOT NULL default '0',Created datetime NOT NULL default '0000-00-00 00:00:00',LastUpdated timestamp(14) NOT NULL,LastUser_ID int(11) NOT NULL default '0',LastIP varchar(15) default NULL,LastUserAgent varchar(255) default NULL,Keyword varchar(255) NOT NULL default '',Title char(255) NOT NULL,Date datetime NOT NULL,ClientID int NULL,Description text NULL,File char(255) NULL, PRIMARY KEY (Message_ID),UNIQUE KEY Sub_Class_ID_2 (Sub_Class_ID,Message_ID,Keyword),KEY User_ID (User_ID),KEY LastUser_ID (LastUser_ID),/*KEY Sub_Class_ID (Sub_Class_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%,'Title', 'Название', 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%,'Date', 'Дата', 8, 'event', 1, 1, 0, '', 1);
INSERT INTO Field (Class_ID, Field_Name, Description, TypeOfData_ID, Format, NotNull, Priority, DoSearch, DefaultState, TypeOfEdit_ID) VALUES (%INSERT_ID%,'ClientID', 'Номер клиента', 2, '', 0, 2, 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, 3, 0, '', 1);
INSERT INTO Field (Class_ID, Field_Name, Description, TypeOfData_ID, Format, NotNull, Priority, DoSearch, DefaultState, TypeOfEdit_ID) VALUES (%INSERT_ID%,'File', 'Файл', 6, '', 0, 4, 0, '', 1);