root/extensions/meta/maintain.inc.php @ 3978

<?php

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

function plugin_install()
{
    global $prefixeTable;

    $q = 'CREATE TABLE ' . $prefixeTable . 'meta(
id SMALLINT( 5 ) UNSIGNED NOT NULL ,
metaname VARCHAR( 255 ) NOT NULL ,
metaval lONGTEXT NOT NULL ,
metatype VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;';
    pwg_query($q);
        
        $q = '
INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (1,"author","","name");';
    pwg_query($q);
        
        $q = '
INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (2,"keywords","","name");';
    pwg_query($q);
        
        $q = '
INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (3,"Description","","name");';
    pwg_query($q);
        
                $q = '
INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (4,"robots","follow","name");';
    pwg_query($q);

        $q = '
ALTER TABLE '. CATEGORIES_TABLE.' ADD COLUMN `metaKeywords` VARCHAR( 255 )';    
    pwg_query($q);
        
}

function plugin_uninstall()
{
    global $prefixeTable;

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

        $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="meta" LIMIT 1;';
    pwg_query($q);
        
        $q = ' ALTER TABLE '. CATEGORIES_TABLE .' DROP COLUMN `metaKeywords`';
        pwg_query( $q );
}


?>