source: plugins/blogroll/_install.php @ 3731:3770620079d4

<?php
/**
 * @brief blogroll, a plugin for Dotclear 2
 *
 * @package Dotclear
 * @subpackage Plugins
 *
 * @copyright Olivier Meunier & Association Dotclear
 * @copyright GPL-2.0-only
 */

if (!defined('DC_CONTEXT_ADMIN')) {return;}

$version = $core->plugins->moduleInfo('blogroll', 'version');

if (version_compare($core->getVersion('blogroll'), $version, '>=')) {
    return;
}

/* Database schema
-------------------------------------------------------- */
$s = new dbStruct($core->con, $core->prefix);

$s->link
    ->link_id('bigint', 0, false)
    ->blog_id('varchar', 32, false)
    ->link_href('varchar', 255, false)
    ->link_title('varchar', 255, false)
    ->link_desc('varchar', 255, true)
    ->link_lang('varchar', 5, true)
    ->link_xfn('varchar', 255, true)
    ->link_position('integer', 0, false, 0)

    ->primary('pk_link', 'link_id')
;

$s->link->index('idx_link_blog_id', 'btree', 'blog_id');
$s->link->reference('fk_link_blog', 'blog_id', 'blog', 'blog_id', 'cascade', 'cascade');

# Schema installation
$si      = new dbStruct($core->con, $core->prefix);
$changes = $si->synchronize($s);

$core->setVersion('blogroll', $version);
return true;