From 32882b6e3513fa69185ea5b3d115e70b69ea5362 Mon Sep 17 00:00:00 2001 From: "travis%sedsystems.ca" <> Date: Fri, 25 Feb 2005 07:27:08 +0000 Subject: Bug 277504 : quips migrated from quip file have an (invalid) userid of 0 Patch by Frederic Buclin r=mkanat a=myk --- checksetup.pl | 13 ++++++++++++- 1 file changed, 12 insertions(+), 1 deletion(-) (limited to 'checksetup.pl') diff --git a/checksetup.pl b/checksetup.pl index cd734a54a..8ef983d7b 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -1992,10 +1992,11 @@ $table{bug_group_map} = index(group_id)'; # 2002-07-19, davef@tetsubo.com, bug 67950: +# 2005-02-20, LpSolit@gmail.com, bug 277504 # Store quips in the db. $table{quips} = 'quipid mediumint not null auto_increment primary key, - userid mediumint not null default 0, + userid mediumint null, quip text not null, approved tinyint(1) not null default 1'; @@ -4263,6 +4264,16 @@ ChangeFieldType ('bugs', 'bug_severity', 'varchar(64) not null'); ChangeFieldType ('bugs', 'rep_platform', 'varchar(64) not null'); ChangeFieldType ('bugs', 'op_sys', 'varchar(64) not null'); + +# 2005-02-20 - LpSolit@gmail.com - Bug 277504 +# When migrating quips from the '$datadir/comments' file to the DB, +# the user ID should be NULL instead of 0 (which is an invalid user ID). +if (!GetFieldDef('quips', 'userid')->[2]) { + ChangeFieldType('quips', 'userid', 'mediumint null'); + print "Changing owner to NULL for quips where the owner is unknown...\n"; + $dbh->do('UPDATE quips SET userid = NULL WHERE userid = 0'); +} + # If you had to change the --TABLE-- definition in any way, then add your # differential change code *** A B O V E *** this comment. # -- cgit v1.2.3-24-g4f1b