schema modified to insert by default localtime