setting default values to support mysql strict mode