From:http://www.cnblogs.com/cyq1162/archive/2011/05/17/2049055.html
In Cyq. Data frame reverse engineering, encountered MySQL problem 2, recorded the first.
1: For the default value of time, is: Current_timestamp, does not allow a table to exist two dates are set: Current_timestamp
The solution:
It's supposed to be just one.
However, in reverse engineering, if two or more settings are encountered, the default value of the date is canceled to ensure normal data.
The 2:text/blog type does not allow default values to be set, because other database types can have default values, so the default values are also set when turned around, although default values are not allowed by default.
The workaround:
Modify the My.ini configuration file to suppress strict control of strict mode.
However, in reverse engineering data, the default value is canceled in order to avoid errors or to prompt the user to modify the configuration.
Today toss a long time, finally put a few database differences are toss good, cyq. The reverse engineering of the data framework is basically complete.
MySQL toss little two: Text/blog type does not allow to set the default value, does not allow the existence of two Current_timestamp