cerberus-core DATABASE CHANGE : Add last_modified column in all testcase table

Do it on table : test, testcase, testcasecountry, testcasecountryproperties, testcasestep, testcasestepaction, testcasestepactioncontrol

Column in timestamp format.

Nov 28 '14 20:11 bcivel

Can it be done in steps, to try to avoid a huge time to implement the database change?

Dec 11 '14 10:12 gmoita

I reopen this issue and modify the default timestamp to 0 instead of DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP as on Mysql 5.5.xx , we cannot have two columns with defaut value CURRENT_TIMESTAMP.

Timestamp will have to be managed by the application for this column.

Jan 13 '15 13:01 bcivel

In fact we should enlarge having the 4 standard fields in all tables : Creator varchar(45) Created timestamp LastModifier varchar(45) LastModified timestamp

Apr 23 '16 11:04 vertigo17

I propose the new format in all tables (last 4 columns of all tables) : UsrCreated varchar(45) DateCreated timestamp UsrModif varchar(45) DateModif timestamp

That means for example : last_modified --> DateMod

in test, testcasecountry, testcasecountryproperty, testcasestep, testcasestepaction, testcasestepactioncontrol, LastModified --> DateMod
in testdatalib

Jul 12 '16 06:07 vertigo17

Is there any news for this one?

Mar 28 '17 15:03 abourdon

Standard is defined and all new table created since have that format. A lot of tables are still to correct.

Mar 28 '17 17:03 vertigo17