/
Revising usage of NULL columns

Revising usage of NULL columns

Owned by Alex
Last updated: Aug 30, 2015

Imported From: http://groups.google.com/group/in-portal-dev/browse_thread/thread/c4120379706850af#

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. 

Related Tasks

INP-678 - Getting issue details... STATUS