View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0021799 | mantisbt | documentation | public | 2016-10-14 07:44 | 2019-12-09 04:32 |
Reporter | atrol | Assigned To | dregad | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Target Version | 2.23.0 | Fixed in Version | 2.23.0 | ||
Summary | 0021799: Wrong data types in ERD | ||||
Description | Some data types are wrong in ERD At first sight it seems that all I2 (SMALLINT on MySQL) columns (mainly used for all kind of enumerations) are wrong. They are documented as VARCHAR(32) E.g. check columns priority, severity, ... in mantis_bug_table | ||||
Tags | No tags attached. | ||||
MantisBT: master 80b88ea2 2019-08-30 07:35 Details Diff |
Fix incorrect column data types in ERD The reference database that was used to build the original diagram (MySQL Workbench reverse engineering feature) was not a fresh install. As a result, there were discrepancies in some data types (e.g. columns linked to enums were VARCHAR instead of SMALLINT). Fixes 0021799 Also added missing relationship between _bugnote_ and _bug_file_ tables (Issue 0026098). |
Affected Issues 0021799, 0026098 |
|
mod - docbook/Developers_Guide/en-US/images/erd.png | Diff File | ||
mod - docbook/erd/mantisbt.mwb | Diff File | ||
add - docbook/erd/mantisbt_2.23.0_210_erd_r2.pdf | Diff File |