Attachment 292118 Details for Bug 420611 – file used by install-update_db hook

file used by install-update_db hook

install-update_db.pl (text/plain), 1.69 KB, created by Tony Fu on 2008-01-18 09:26:53 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tony Fu

Created: 2008-01-18 09:26:53 UTC

Size: 1.69 KB

patch

obsolete

>use strict;
>use warnings;
>use Bugzilla;
>
># REDHAT EXTENSION START 420611
># REDHAT.  Update definitions to rh_bz_2.18
># specific table definitions
>my $dbh = Bugzilla->dbh;
>$dbh->bz_alter_column( 'groups', 'userregexp',
>    { TYPE => 'VARCHAR(2000)', DEFAULT => "''" } );
>
>$dbh->bz_alter_column( 'namedqueries', 'query_type',
>    { TYPE => 'BOOLEAN', DEFAULT => 0 } );
>
>$dbh->bz_alter_column( 'products', 'classification_id',
>    { TYPE => 'INT2', DEFAULT => '1' } );
>
>$dbh->bz_alter_column( 'profiles', 'disabledtext', { TYPE => 'MEDIUMTEXT' } );
>
>$dbh->bz_alter_column(
>    'quips', 'userid',
>    {
>        TYPE       => 'INT3',
>        NOTNULL    => 1,
>        REFERENCES => {
>            TABLE  => 'profiles',
>            COLUMN => 'userid'
>        }
>    }
>);
>
>$dbh->bz_alter_column( 'bugs', 'creation_ts',
>    { TYPE => 'DATETIME', NOTNULL => 1 } );
>
>$dbh->bz_alter_column( 'bugs', 'resolution',
>    { TYPE => 'VARCHAR(64)', DEFAULT => "''" } );
>
>$dbh->bz_alter_column( 'bugs', 'votes', { TYPE => 'INT3', DEFAULT => '0' } );
>
>$dbh->bz_alter_column( 'bugs', 'keywords',
>    { TYPE => 'MEDIUMTEXT', DEFAULT => "''" } );
>
>$dbh->bz_alter_column( 'tokens', 'userid', { TYPE => 'INT3', NOTNULL => 1 } );
>
>$dbh->bz_add_column(
>    'group_group_map',
>    'isbless',
>    {
>        TYPE    => 'BOOLEAN',
>        NOTNULL => 1,
>        DEFAULT => 'FALSE'
>    }
>);
>
>$dbh->bz_add_column( 'groups', 'last_changed',
>    { TYPE => 'DATETIME', NOTNULL => 1 }, 0 );
>
>$dbh->bz_add_column( 'profiles', 'emailflags', { TYPE => 'MEDIUMTEXT' } );
>
>$dbh->bz_add_column(
>    'profiles',
>    'refreshed_when',
>    {
>        TYPE    => 'DATETIME',
>        NOTNULL => 1,
>        DEFAULT => "'1900-01-01 00:00:00'"
>    }
>);
>
># REDHAT EXTENSION END 420611
>

Actions: View

Attachments on bug 420611: 284681 | 285731 | 285741 | 291816 | 291817 | 291818 | 292118 | 292119 | 292335 | 292336 | 292464 | 292465 | 293354 | 293546 | 293608