source: extensions/Piwecard/maintain.inc.php @ 16022

<?php
/*
 * Plugin Name: Piwecard
 * File :  maintain.inc.php  
 */

if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');


function plugin_install()
{
        global $prefixeTable, $conf;

        $query = 'SHOW TABLES LIKE "' . $prefixeTable . 'ecard"';
        $result = pwg_query($query);
        if (!mysql_fetch_row($result))
        {

        // ecard description
                $q = 'CREATE TABLE `' . $prefixeTable . 'ecard` (
                                          `numero` CHAR(15) not null,
                                          `nomexp` CHAR(100) not null,
                                          `nomdest` CHAR(100) not null,
                                          `adrexp` CHAR(100) not null,
                                          `adrdest` CHAR(100) not null,
                                          `sujet` CHAR(100) not null,
                                          `message` TEXT not null,
                                          `image` smallint(5) not null,
                                          `date` datetime NOT NULL,
                                          `duration` smallint(5) not null default 10,
                                          PRIMARY KEY (`numero`),
                                          UNIQUE (`numero`)
                                        ) DEFAULT CHARSET=utf8;';
                pwg_query($q);

    $q = '
    INSERT INTO '.CONFIG_TABLE.' (param,value,comment)
    VALUES ("ecard","","Configuration ecard")
    ;';

    pwg_query($q);
    

        
        }

}

function plugin_activate()
{
 
}

function plugin_uninstall()
{
    global $prefixeTable;

        $q = 'DROP TABLE ' . $prefixeTable . 'ecard;';
    pwg_query($q);

    $q = '
      DELETE FROM '.CONFIG_TABLE.'
      WHERE param="ecard" LIMIT 1
    ;';
    pwg_query($q);

}


?>