Menu

Commit [r9210]  Maximize  Restore  History

db: Converted all timestamp columns for resource tables from seconds to microseconds.

* Ticket comments can now be added with a shorter interval than one second.
* Conversions of datetime objects from / to microsecond timestamps should be done exclusively throught the new `from_utimestamp()` and `to_utimestamp()` functions.

'''This changeset requires a database upgrade.'''

Closes #6466.

rblank 2010-02-20

1 2 > >> (Page 1 of 2)
changed /trunk/trac/attachment.py
changed /trunk/trac/db/api.py
changed /trunk/trac/db/mysql_backend.py
changed /trunk/trac/db/postgres_backend.py
changed /trunk/trac/db/sqlite_backend.py
changed /trunk/trac/db/tests/__init__.py
changed /trunk/trac/db/tests/postgres_test.py
changed /trunk/trac/db_default.py
changed /trunk/trac/ticket/model.py
changed /trunk/trac/ticket/query.py
changed /trunk/trac/ticket/roadmap.py
changed /trunk/trac/ticket/templates/report.rss
changed /trunk/trac/ticket/templates/report_view.html
changed /trunk/trac/ticket/tests/model.py
changed /trunk/trac/ticket/tests/query.py
changed /trunk/trac/ticket/web_ui.py
changed /trunk/trac/timeline/web_ui.py
changed /trunk/trac/upgrades/db15.py
changed /trunk/trac/upgrades/db17.py
changed /trunk/trac/upgrades/db18.py
changed /trunk/trac/upgrades/db19.py
changed /trunk/trac/upgrades/db22.py
changed /trunk/trac/util/datefmt.py
changed /trunk/trac/util/tests/datefmt.py
changed /trunk/trac/versioncontrol/cache.py
/trunk/trac/attachment.py Diff Switch to side-by-side view
Loading...
/trunk/trac/db/api.py Diff Switch to side-by-side view
Loading...
/trunk/trac/db/mysql_backend.py Diff Switch to side-by-side view
Loading...
/trunk/trac/db/postgres_backend.py Diff Switch to side-by-side view
Loading...
/trunk/trac/db/sqlite_backend.py Diff Switch to side-by-side view
Loading...
/trunk/trac/db/tests/__init__.py Diff Switch to side-by-side view
Loading...
/trunk/trac/db/tests/postgres_test.py Diff Switch to side-by-side view
Loading...
/trunk/trac/db_default.py Diff Switch to side-by-side view
Loading...
/trunk/trac/ticket/model.py Diff Switch to side-by-side view
Loading...
/trunk/trac/ticket/query.py Diff Switch to side-by-side view
Loading...
/trunk/trac/ticket/roadmap.py Diff Switch to side-by-side view
Loading...
/trunk/trac/ticket/templates/report.rss Diff Switch to side-by-side view
Loading...
/trunk/trac/ticket/templates/report_view.html Diff Switch to side-by-side view
Loading...
/trunk/trac/ticket/tests/model.py Diff Switch to side-by-side view
Loading...
/trunk/trac/ticket/tests/query.py Diff Switch to side-by-side view
Loading...
/trunk/trac/ticket/web_ui.py Diff Switch to side-by-side view
Loading...
/trunk/trac/timeline/web_ui.py Diff Switch to side-by-side view
Loading...
/trunk/trac/upgrades/db15.py Diff Switch to side-by-side view
Loading...
/trunk/trac/upgrades/db17.py Diff Switch to side-by-side view
Loading...
/trunk/trac/upgrades/db18.py Diff Switch to side-by-side view
Loading...
/trunk/trac/upgrades/db19.py Diff Switch to side-by-side view
Loading...
/trunk/trac/upgrades/db22.py Diff Switch to side-by-side view
Loading...
/trunk/trac/util/datefmt.py Diff Switch to side-by-side view
Loading...
/trunk/trac/util/tests/datefmt.py Diff Switch to side-by-side view
Loading...
/trunk/trac/versioncontrol/cache.py Diff Switch to side-by-side view
Loading...
1 2 > >> (Page 1 of 2)
MongoDB Logo MongoDB