diff options
| author | mkanat%bugzilla.org <> | 2008-05-08 04:08:48 +0200 |
|---|---|---|
| committer | mkanat%bugzilla.org <> | 2008-05-08 04:08:48 +0200 |
| commit | 564065d5fc358f87c3c2e4d71eab5acb25a53749 (patch) | |
| tree | 506d7fe41d45680bb897ea0f5b1689f928c7c6ea /Bugzilla | |
| parent | 183719adf844b5497699c60625c6268e1640d9de (diff) | |
| download | bugzilla-564065d5fc358f87c3c2e4d71eab5acb25a53749.tar.gz bugzilla-564065d5fc358f87c3c2e4d71eab5acb25a53749.tar.xz | |
Bug 414292: [Oracle] Change series.query back to MEDIUMTEXT
Patch By Xiaoou Wu <xiaoou.wu@oracle.com> r=mkanat, a=mkanat
Diffstat (limited to 'Bugzilla')
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 2 | ||||
| -rw-r--r-- | Bugzilla/Install/DB.pm | 12 |
2 files changed, 9 insertions, 5 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index b8ac649b7..39f3caf20 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -1089,7 +1089,7 @@ use constant ABSTRACT_SCHEMA => { name => {TYPE => 'varchar(64)', NOTNULL => 1}, frequency => {TYPE => 'INT2', NOTNULL => 1}, last_viewed => {TYPE => 'DATETIME'}, - query => {TYPE => 'LONGTEXT', NOTNULL => 1}, + query => {TYPE => 'MEDIUMTEXT', NOTNULL => 1}, is_public => {TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 'FALSE'}, ], diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index ca011ce6c..d1f1aadb5 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -522,6 +522,10 @@ sub update_table_definitions { $dbh->bz_drop_index('longdescs', 'longdescs_thetext_idx'); _populate_bugs_fulltext(); + # 2008-01-18 xiaoou.wu@oracle.com - Bug 414292 + $dbh->bz_alter_column('series', 'query', + { TYPE => 'MEDIUMTEXT', NOTNULL => 1 }); + ################################################################ # New --TABLE-- changes should go *** A B O V E *** this point # ################################################################ @@ -2935,7 +2939,8 @@ sub _fix_attachment_modification_date { sub _change_text_types { my $dbh = Bugzilla->dbh; - return if $dbh->bz_column_info('series', 'query')->{TYPE} eq 'LONGTEXT'; + return if + $dbh->bz_column_info('namedqueries', 'query')->{TYPE} eq 'LONGTEXT'; _check_content_length('attachments', 'mimetype', 255, 'attach_id'); _check_content_length('fielddefs', 'description', 255, 'id'); _check_content_length('attachments', 'description', 255, 'attach_id'); @@ -2953,14 +2958,13 @@ sub _change_text_types { { TYPE => 'MEDIUMTEXT', NOTNULL => 1 }, ''); $dbh->bz_alter_column('fielddefs', 'description', { TYPE => 'TINYTEXT', NOTNULL => 1 }); - $dbh->bz_alter_column('namedqueries', 'query', - { TYPE => 'LONGTEXT', NOTNULL => 1 }); $dbh->bz_alter_column('groups', 'description', { TYPE => 'MEDIUMTEXT', NOTNULL => 1 }); $dbh->bz_alter_column('quips', 'quip', { TYPE => 'MEDIUMTEXT', NOTNULL => 1 }); - $dbh->bz_alter_column('series', 'query', + $dbh->bz_alter_column('namedqueries', 'query', { TYPE => 'LONGTEXT', NOTNULL => 1 }); + } sub _check_content_length { |