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?
Subject | Author | Views | Date |
---|---|---|---|
problem with timestamp | delicia | 13346 | Aug 7, 2010, 6:27 AM |
Re: [delicia] problem with timestamp | Andy | 12988 | Aug 7, 2010, 7:00 AM |
Re: [Andy] problem with timestamp | delicia | 13010 | Aug 7, 2010, 7:51 AM |
Re: [delicia] problem with timestamp | Andy | 12990 | Aug 7, 2010, 7:53 AM |
Re: [Andy] problem with timestamp | delicia | 12931 | Aug 7, 2010, 8:10 AM |