diff options
| author | Friendika <info@friendika.com> | 2011-09-18 19:04:11 -0700 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2011-09-18 19:04:11 -0700 |
| commit | 8bf6a29d4e05af5d461da3f01999785dc12ee7da (patch) | |
| tree | e8d52eee1c8f60fda836edebd685726be930d946 /database.sql | |
| parent | e2e29b2deafffb98d156fb3f726a3968b3492522 (diff) | |
| download | volse-hubzilla-8bf6a29d4e05af5d461da3f01999785dc12ee7da.tar.gz volse-hubzilla-8bf6a29d4e05af5d461da3f01999785dc12ee7da.tar.bz2 volse-hubzilla-8bf6a29d4e05af5d461da3f01999785dc12ee7da.zip | |
optimise the commented date view
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/database.sql b/database.sql index ff339929e..444b05faa 100644 --- a/database.sql +++ b/database.sql @@ -174,6 +174,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `thr-parent` char(255) NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `commented` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `owner-name` char(255) NOT NULL, |