Viewing Issue Simple Details |
ID |
Category |
Type |
Reproducibility |
Date Submitted |
Last Update |
0000845 |
[In-Portal CMS] Optimization |
task |
N/A |
2010-08-31 13:21 |
2010-11-30 12:48 |
|
Reporter |
alex |
View Status |
public |
|
Assigned To |
Dmitry |
Priority |
normal |
Resolution |
fixed |
|
Status |
closed |
|
|
|
|
Summary |
0000845: Revising usage of NULL columns |
Description |
I think, that we should review how we use NULL columns in system.
For example we INT field can't have empty value unless it is NULL. VARCHAR fields can have empty value and in most cases are NOT NULL.
What I propose is at least to convert all columns, that contain DATE and USER_ID in them to NULL. We also have ModifiedById field for topics set to 0 in database, but to -1 (root) in unit config, which will make topic always modified by "root", once it is created on front-end. |
Additional Information |
To detect all places, needs to be changed unit config validator needs to altered to search for such inconsistencies. This will save time, when we need to look at each table field to detect, that it's need to be changed. |