module-poll/poll/sql.php

<?php

/**
 * AVE.cms - Модуль Опросы.
 *
 * @package AVE.cms
 * @subpackage mod_poll
 * @since 1.1
 * @filesource
 */

/**
 * mySQL-запросы для установки, обновления и удаления модуля
 */

$module_sql_install = array();
$module_sql_deinstall = array();
$module_sql_update = array();

// Удаление модуля
$module_sql_deinstall[] = "DROP TABLE IF EXISTS %%PRFX%%_module_poll;";
$module_sql_deinstall[] = "DROP TABLE IF EXISTS %%PRFX%%_module_poll_comments;";
$module_sql_deinstall[] = "DROP TABLE IF EXISTS %%PRFX%%_module_poll_items;";

// Установка модуля
$module_sql_install[] = "CREATE TABLE %%PRFX%%_module_poll (
	id int(10) unsigned NOT NULL auto_increment,
	poll_title varchar(255) NOT NULL default '',
	poll_status enum('1','0') NOT NULL default '1',
	poll_can_comment enum('0','1') NOT NULL default '0',
	poll_groups_id tinytext,
	poll_start int(10) unsigned NOT NULL default '0',
	poll_end int(10) unsigned NOT NULL default '0',
	poll_users_id text NOT NULL default '',
	poll_users_ip text NOT NULL default '',
	PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";

$module_sql_install[] = "CREATE TABLE %%PRFX%%_module_poll_comments (
	id int(10) unsigned NOT NULL auto_increment,
	poll_id int(10) NOT NULL,
	poll_comment_author_id int(10) NOT NULL,
	poll_comment_author_ip text NOT NULL default '',
	poll_comment_time int(10) unsigned NOT NULL default '0',
	poll_comment_title varchar(250) NOT NULL default '',
	poll_comment_text text NOT NULL default '',
	PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";

$module_sql_install[] = "CREATE TABLE %%PRFX%%_module_poll_items (
	id int(10) unsigned NOT NULL auto_increment,
	poll_id int(10) NOT NULL,
	poll_item_title varchar(250) NOT NULL default '',
	poll_item_hits int(10) NOT NULL default '0',
	poll_item_color varchar(10) NOT NULL default '',
	poll_item_position int(2) NOT NULL,
	PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";

// Обновление модуля
$module_sql_update[] = "
	UPDATE
		`%%PRFX%%_module`
	SET
		ModuleAveTag = '" . $modul['ModuleAveTag'] . "',
		ModulePHPTag = '" . $modul['ModulePHPTag'] . "',
		ModuleVersion = '" . $modul['ModuleVersion'] . "'
	WHERE
		ModuleSysName = '" . $modul['ModuleSysName'] . "'
	LIMIT 1;
";

$module_sql_update[] = "
	RENAME TABLE
		`%%PRFX%%_modul_poll`
	TO
		`%%PRFX%%_module_poll`
";

$module_sql_update[] = "
	RENAME TABLE
		`%%PRFX%%_modul_poll_comments`
	TO
		`%%PRFX%%_module_poll_comments`
";

$module_sql_update[] = "
	RENAME TABLE
		`%%PRFX%%_modul_poll_items`
	TO
		`%%PRFX%%_module_poll_items`
";
?>