source: extensions/SmartAlbums/maintain.inc.php @ 11333

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

function plugin_install() {
        global $prefixeTable;

  /* create table to store filters */
        pwg_query(
'CREATE TABLE IF NOT EXISTS `' . $prefixeTable . 'category_filters` (
  `category_id` smallint(5) unsigned NOT NULL,
  `type` varchar(16) NOT NULL,
  `cond` varchar(16) NULL,
  `value` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8
;');
  
  /* add a collumn to image_category_table */
  pwg_query('ALTER TABLE `' . IMAGE_CATEGORY_TABLE . '` ADD `smart` ENUM("true", "false") NOT NULL DEFAULT "false";');
      
  /* config parameter */
  // pwg_query("INSERT INTO `" . CONFIG_TABLE . "`
    // VALUES ('SmartAlbums', '', 'Configuration for SmartAlbums plugin');");
}

function plugin_uninstall() {
        global $prefixeTable;
  
  pwg_query('DROP TABLE `' . $prefixeTable . 'category_filters`;');
  pwg_query('ALTER TABLE `' . IMAGE_CATEGORY_TABLE . '` DROP `smart`;');
  pwg_query('DELETE FROM `' . CONFIG_TABLE . '` WHERE param = "SmartAlbums";');
}
?>