source: extensions/ConcoursPhoto/maintain.inc.php @ 4080

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

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


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

        $query = 'SHOW TABLES LIKE "' . $prefixeTable . 'concours"';
        $result = pwg_query($query);
        if (!mysql_fetch_row($result))
        {
        // Concours description
                $q = 'CREATE TABLE `' . $prefixeTable . 'concours` (
                                `id` smallint(5) NOT NULL,
                                `create_date` datetime NOT NULL,
                                `name` text NOT NULL,
                                `descr` varchar(255) default NULL,
                                `begin_date` datetime NOT NULL,
                                `end_date` datetime NOT NULL,
                                `category` smallint(5) default NULL,
                                `groups` varchar(255) default NULL,
                                
                                PRIMARY KEY  (`id`)
                                ) DEFAULT CHARSET=utf8;';
                pwg_query($q);

        // Concours description detail (criterias)
                $q = 'CREATE TABLE `' . $prefixeTable . 'concours_detail` (
                                `id` smallint(5) NOT NULL,
                                `id_concours` smallint(5) NOT NULL,
                                `criteria_id` smallint(5) NOT NULL,
                                `name` text NOT NULL,
                                `descr` varchar(255) default NULL,
                                `min_value` int default 0,
                                `max_value` int default 0,
                                `ponderation` int default 1,
                                `uppercriteria` smallint(5) default NULL,
                                
                                PRIMARY KEY  (`id`),
                                FOREIGN KEY (`id_concours`) REFERENCES ' . $prefixeTable . 'concours(id)
                                ) DEFAULT CHARSET=utf8;';
                pwg_query($q);


        // Concours notation (by users)
                $q = 'CREATE TABLE `' . $prefixeTable . 'concours_data` (
                                `id` smallint(5) NOT NULL,
                                `id_concours` smallint(5) NOT NULL,
                                `user_id` smallint(5) NOT NULL,
                                `create_date` datetime NOT NULL,
                                `img_id` smallint(5) NOT NULL,
                                `datas` longtext default NULL,
                                `comment` longtext default NULL,                                
                                PRIMARY KEY  (`id`)
                                ) DEFAULT CHARSET=utf8;';
                pwg_query($q);
                
        // Concours result (synthesis)
                $q = 'CREATE TABLE `' . $prefixeTable . 'concours_result` (
                                `id_concours` smallint(5) NOT NULL,
                                `img_id` smallint(5) NOT NULL,
                                `date` datetime NOT NULL,
                                `note` float default 0,
                                `datas` longtext default NULL,
                                `file_name` longtext default NULL,
                                PRIMARY KEY  (`img_id`),
                                FOREIGN KEY (`id_concours`) REFERENCES ' . $prefixeTable . 'concours(id)                                
                                ) DEFAULT CHARSET=utf8;';
                pwg_query($q);
                
        // Default values  insertion
    $q = "INSERT INTO `" . $prefixeTable . "concours` 
                                ( `id`,
                                `create_date`, 
                                `name`, 
                                `descr`, 
                                `begin_date`, 
                                `end_date`, 
                                `category`, 
                                `groups`)
                        VALUES (0, now(), 'Default', 'default values', now(), now(), NULL, NULL);";
    pwg_query($q);

    // Default values for criterias (concours_id=0)
    $q = "INSERT INTO `" . $prefixeTable . "concours_detail` 
                                (`id`,
                                `id_concours` , 
                                `criteria_id` , 
                                `name`, 
                                `descr`, 
                                `min_value`, 
                                `max_value`, 
                                `ponderation` ,
                                `uppercriteria`)
                        VALUES (1, 0, 1, 'Artistique', 'Artistique', 0, 10, 1, NULL),
                         (2, 0, 2, 'Respect du sujet', 'Sujet en rapport avec le theme', 0, 1, 1, 1),
                         (3, 0, 3, 'Sujet bien identifié', 'Sans ambiguite', 0, 2, 1, 1),
                         (4, 0, 4, 'Traitement du sujet', 'Expression/Attitude/mouvement', 0, 2, 1, 1),
                         (5, 0, 5, 'Mise en valeur du sujet', 'Cadrage/Harmonie de la composition/Esthetique de l\'image/Choix de l\'eclairage', 0, 5, 1, 1),

                         (6, 0, 6, 'Technique', 'Technique', 0, 6, 1, NULL),
                         (7, 0, 7, 'Nettete de l\'image', 'Etagement des plans/Pique de l\'image', 0, 3, 1, 6),
                         (8, 0, 8, 'Rendu des couleurs (ou gris)', 'Teintes/Staurations', 0, 1, 1, 6),
                         (9, 0, 9, 'Exposition', 'Equilibre hautes/basses lumieres', 0, 2, 1, 6),

                         (10, 0, 10, 'Coup de coeur', 'coup de coeur', 0, 4, 1, NULL),
                         (11, 0, 11, 'Emotion spontanee', 'emotion spontanee', 0, 2, 1, 10),
                         (12, 0, 12, 'Adhesion au choix artistique', 'Adhesion au choix artistique', 0, 2, 1, 10);";
                         
    pwg_query($q);

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

    pwg_query($q);
    
    
/*      
        // TEST INSERTION INTO DB (Goupe test =1)
    $q = "INSERT INTO `" . $prefixeTable . "concours` 
                                ( `id`,
                                `create_date`, 
                                `name`, 
                                `descr`, 
                                `begin_date`, 
                                `end_date`, 
                                `category`, 
                                `groups`)
                        VALUES (1, now(), 'Test', 'Test Concours', now(), '2019-09-02 18:08:00', 2, 1);";
    pwg_query($q);
        
    $q = "INSERT INTO `" . $prefixeTable . "concours_data` 
                                (`id` ,
                                `id_concours` ,
                                `user_id` ,
                                `create_date` ,
                                `img_id` ,
                                `datas` )
                        VALUES (1, 1, 3, now(), 54, \"2=1;3=1;4=2;5=3;7=1;8=0;9=0,5;11=1,5;12=2\");";
    pwg_query($q);
    $q = "INSERT INTO `" . $prefixeTable . "concours_detail` 
                                (`id`,
                                `id_concours` , 
                                `criteria_id` , 
                                `name`, 
                                `descr`, 
                                `min_value`, 
                                `max_value`, 
                                `ponderation` ,
                                `uppercriteria`)
                        VALUES (13, 1, 1, 'Artistique', 'Artistique', 0, 10, 1, NULL),
                         (14, 1, 2, 'Respect du sujet', 'Sujet en rapport avec le theme', 0, 1, 1, 1),
                         (15, 1, 3, 'Sujet bien identifié', 'Sans ambiguite', 0, 2, 1, 1),
                         (16, 1, 4, 'Traitement du sujet', 'Expression/Attitude/mouvement', 0, 2, 1, 1),
                         (17, 1, 5, 'Mise en valeur du sujet', 'Cadrage/Harmonie de la composition/Esthetique de l\'image/Choix de l\'eclairage', 0, 5, 1, 1),

                         (18, 1, 6, 'Technique', 'Technique', 0, 6, 1, NULL),
                         (19, 1, 7, 'Nettete de l\'image', 'Etagement des plans/Pique de l\'image', 0, 3, 1, 6),
                         (20, 1, 8, 'Rendu des couleurs (ou gris)', 'Teintes/Staurations', 0, 1, 1, 6),
                         (21, 1, 9, 'Exposition', 'Equilibre hautes/basses lumieres', 0, 2, 1, 6),

                         (22, 1, 10, 'Coup de coeur', 'coup de coeur', 0, 4, 1, NULL),
                         (23, 1, 11, 'Emotion spontanee', 'emotion spontanee', 0, 2, 1, 10),
                         (24, 1, 12, 'Adhesion au choix artistique', 'Adhesion au choix artistique', 0, 2, 1, 10);";
                         
    pwg_query($q);
        // END TEST INSERTION 
*/
        
        }

}

function plugin_activate()
{
  global $prefixeTable;

}

function plugin_uninstall()
{
    global $prefixeTable;

        $q = 'DROP TABLE ' . $prefixeTable . 'concours, 
        ' . $prefixeTable . 'concours_detail, 
        ' . $prefixeTable . 'concours_data,
        ' . $prefixeTable . 'concours_result    ;';
    pwg_query($q);

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

}


?>