View Issue Details

IDProjectCategoryView StatusLast Update
0023445mantisbtupgradepublic2017-10-22 18:47
ReporterPoil Assigned Todregad  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionunable to reproduce 
Product Version2.6.0 
Summary0023445: 1.2.6 to 1.3.16 to 2.6.0, SQL schema diff
Description

Hi,

After upgrading from 1.2.6 to 1.3.16 (with the fix of the insert bug) to 2.6.0, it remains a diff in the SQL Schema :
On the CREATE TABLE mantis_custom_field_table (

 --
@@ -489,7 +467,7 @@
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `name` varchar(64) NOT NULL DEFAULT '',
   `type` smallint(6) NOT NULL DEFAULT '0',
-  `possible_values` text NOT NULL,
+  `possible_values` text,
   `default_value` varchar(255) NOT NULL DEFAULT '',
   `valid_regexp` varchar(255) NOT NULL DEFAULT '',
   `access_level_r` smallint(6) NOT NULL DEFAULT '0',
@@ -498,7 +476,7 @@
   `length_max` int(11) NOT NULL DEFAULT '0',
   `require_report` tinyint(4) NOT NULL DEFAULT '0',
   `require_update` tinyint(4) NOT NULL DEFAULT '0',
-  `display_report` tinyint(4) NOT NULL DEFAULT '1',
+  `display_report` tinyint(4) NOT NULL DEFAULT '0',
   `display_update` tinyint(4) NOT NULL DEFAULT '1',
   `require_resolved` tinyint(4) NOT NULL DEFAULT '0',
   `display_resolved` tinyint(4) NOT NULL DEFAULT '0',
TagsNo tags attached.

Activities

dregad

dregad

2017-10-09 06:04

developer   ~0057913

There are no changes to custom_field table between 1.2.0 and 1.3.0 [1], and as far as I can tell the definitions for these columns have not changed since 2008 for the first one, and since the new schema was introduced in 2005 for the second.

The differences you see are probably consequences of non-standard changes.

[1] https://github.com/mantisbt/mantisbt/blob/master/admin/schema.php#L821-L885