source: plugins/dcRevisions/_install.php @ 338:2d7dcf33cd6f

<?php
# -- BEGIN LICENSE BLOCK ----------------------------------
# This file is part of dcRevisions, a plugin for Dotclear.
#
# Copyright (c) 2010 Tomtom and contributors
# http://blog.zenstyle.fr/
#
# Licensed under the GPL version 2.0 license.
# A copy of this license is available in LICENSE file or at
# http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
# -- END LICENSE BLOCK ------------------------------------

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

$m_version = $core->plugins->moduleInfo('dcRevisions','version');
$i_version = $core->getVersion('dcrevisions');

if (version_compare($i_version,$m_version,'>=')) {
     return;
}

$core->blog->settings->addNamespace('dcrevisions');
$core->blog->settings->dcrevisions->put(
     'enable',
     false,
     'boolean','Enable revisions',false,true
);

# --INSTALL AND UPDATE PROCEDURES--
$s = new dbStruct($core->con,$core->prefix);

$s->revision
     ->revision_id                 ('bigint',0,false)
     ->post_id                     ('bigint',0,false)
     ->user_id                     ('varchar',32,false)
     ->blog_id                     ('varchar',32,false)
     ->revision_dt                 ('timestamp',0,false,'now()')
     ->revision_tz                 ('varchar',128,false,"'UTC'")
     ->revision_type               ('varchar',50,true,null)
     ->revision_excerpt_diff       ('text',0,true,null)
     ->revision_excerpt_xhtml_diff ('text',0,true,null)
     ->revision_content_diff       ('text',0,true,null)
     ->revision_content_xhtml_diff ('text',0,true,null)
     ;

$s->revision->primary('pk_revision','revision_id');

$s->revision->index('idx_revision_post_id','btree','post_id');

$s->revision->reference('fk_revision_post','post_id','post','post_id','cascade','cascade');
$s->revision->reference('fk_revision_blog','blog_id','blog','blog_id','cascade','cascade');

$si = new dbStruct($core->con,$core->prefix);

try {
     $changes = $si->synchronize($s);
} catch (Exception $e) {
     $core->error->add($e);
}

$core->setVersion('dcrevisions',$m_version);

return true;

?>