source: extensions/meta/maintain.inc.php @ 7532

<?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);

if (!defined('meta_img_TABLE')) define('meta_img_TABLE', $prefixeTable.'meta_img');
        $query = "CREATE TABLE IF NOT EXISTS ". meta_img_TABLE ." (
id SMALLINT( 5 ) UNSIGNED NOT NULL ,
metaKeyimg VARCHAR( 255 ) NOT NULL ,
metadesimg VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
        $result = pwg_query($query);

if (!defined('meta_cat_TABLE')) define('meta_cat_TABLE', $prefixeTable.'meta_cat');     
        $query = "CREATE TABLE IF NOT EXISTS ". meta_cat_TABLE ." (
id SMALLINT( 5 ) UNSIGNED NOT NULL ,
metaKeycat VARCHAR( 255 ) NOT NULL ,
metadescat VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
        $result = pwg_query($query);

        $majm1='meta 2.0.5';
        $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm1.'",1,"MAJ meta");';
    pwg_query($query);

        $majm2='meta 2.1.0';
        $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm2.'",1,"MAJ meta");';
    pwg_query($query);  
}

function plugin_uninstall()
{

        $majm1='meta 2.0.5';
        $majm2='meta 2.1.0';
    
        global $prefixeTable;

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

        $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="'.$majm1.'" LIMIT 1;';
    pwg_query($q);
        
        $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="'.$majm2.'" LIMIT 1;';
    pwg_query($q);
        
        $q = 'DROP TABLE ' . $prefixeTable . 'meta_img;';
    pwg_query($q);

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


?>