update w/ time ddl in tests; and mytime fields in all tables (plus index's)