source: extensions/Comments_on_Albums/maintain.inc.php @ 17761

<?php
if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');

function plugin_install() 
{
  global $prefixeTable;

  pwg_query("
CREATE TABLE `" . $prefixeTable . "comments_categories` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `author` varchar(255) DEFAULT NULL,
  `author_id` smallint(5) DEFAULT NULL,
  `anonymous_id` varchar(45) NOT NULL,
  `content` longtext,
  `validated` enum('true','false') NOT NULL DEFAULT 'false',
  `validation_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8
;");
}

function plugin_activate()
{
  global $conf, $prefixeTable;
  
  if (isset($conf['comments_on_albums']))
  {
    pwg_query('DELETE FROM '.CONFIG_TABLE.' WHERE param="comments_on_albums" LIMIT 1;');
  }
  
  $query = 'SHOW COLUMNS FROM `' . $prefixeTable . 'comments_categories`;';
  $columns = hash_from_query($query, 'Field');
  if (!isset($columns['anonymous_id']))
  {
    pwg_query('ALTER TABLE `' . $prefixeTable . 'comments_categories` ADD `anonymous_id` VARCHAR( 45 ) DEFAULT NULL;');
  }
}

function plugin_uninstall() 
{
  global $prefixeTable;

  pwg_query("DROP TABLE `" . $prefixeTable . "comments_categories`;");
}
?>