the first field in my table is a timestamp which i want automatically filled with current date/time when i add a new record, as well as modify existing record. the modify works fine, but add fills with 0s. add works ok until i use the Resync Database function in Admin. this changes default to CURRENT_TIMESTAMP and changes NOT NULL to NO. when i have NOT NULL = YES and blank default value, it works. why does resync change these properties and is there something i can put in default that will work?
)