stock CreateCalendarTable({MySQL, _}:__connection_id, days_count, const start_date[] = "CURDATE()", const direction[] = "-")
{
#define TABLE_CALENDAR_NAME_ "sys_calendar"
mysql_query(__connection_id,
"DROP TABLE IF EXISTS `"#TABLE_CALENDAR_NAME_"`", false);
mysql_query(__connection_id,
"CREATE TABLE `"#TABLE_CALENDAR_NAME_"`(`id` int(11) NOT NULL,`date` date NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;", false);
mysql_query(__connection_id,
"ALTER TABLE `"#TABLE_CALENDAR_NAME_"` ADD PRIMARY KEY (`id`);", false);
mysql_query(__connection_id,
"ALTER TABLE `"#TABLE_CALENDAR_NAME_"` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;", false);
new query_string[100+11+1];
for(new i; i < days_count; i++)
{
format(query_string
, sizeof(query_string
), "INSERT INTO "#TABLE_CALENDAR_NAME_"(date)VALUES((%s) %s INTERVAL %d DAY)", start_date, direction, i);
mysql_query(__connection_id, query_string, false);
}
"\
[MySQL] Календарь успешно создан. \
Название таблицы: \""#TABLE_CALENDAR_NAME_"\" \
[Количество дат: %d]. \
Времени затрачено: %d мс\
", days_count, GetTickCount()-tick);
#undef TABLE_CALENDAR_NAME_
}