Changes between Version 28 and Version 29 of TracDev/DatabaseApi
- Timestamp:
- Feb 6, 2014, 12:32:54 PM (10 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TracDev/DatabaseApi
v28 v29 265 265 As you may know, support for SQL varies among different database systems. The requirements of Trac are relatively trivial, so we try to stick to a common subset that is supported by the majority of databases. 266 266 267 - no native `date` or `time` database types; store date and time information in seconds as `int` fields (before 0.12) or better, in microseconds and ` bigint` fields (since 0.12)267 - no native `date` or `time` database types; store date and time information in seconds as `int` fields (before 0.12) or better, in microseconds and `int64` fields (since 0.12, mapped by each `trac.db.IDatabaseConnector` to a suitable database specific type) 268 268 - no triggers 269 269 - you may use views if you feel you need them (but so far we didn't feel the need for Trac itself)