0005456: PRIMARY KEY not null error on upgrade

ID	Project	Category	View Status	Date Submitted	Last Update
0005456	mantisbt	upgrade	public	2005-04-19 08:25	2005-04-25 07:51

Reporter	gabbs	Assigned To	thraxisp
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	fixed
Product Version	1.0.0a1
Fixed in Version	1.0.0a2

Summary	0005456: PRIMARY KEY not null error on upgrade
Description	When you run an upgrade to 1.0.0a1 the upgrade script fails on "Add mantis_config_table primary key" (configdb-pk). Saying "ERROR: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead" because config_id, project_id, user_id in the config table all allow NULLS.
Tags	No tags attached.

thraxisp 2005-04-19 08:54 reporter ~0009839	project_id and user_id are not set with NOT NULL, but have defaults.

thraxisp 2005-04-19 09:51 reporter ~0009840	Fixed in CVS admin/upgrades/1_00_inc.php -> 1.1 admin/upgrades/0_19_inc.php -> 1.12 admin/upgrade.php -> 1.7