diff options
| author | Friendika <info@friendika.com> | 2011-06-23 17:56:59 -0700 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2011-06-23 17:56:59 -0700 |
| commit | 38cf37d3c3a4bc9873aa12eed5167b356282385f (patch) | |
| tree | 346398bcfbb748aa1aa3f0658af020ddb487d946 /database.sql | |
| parent | 2bc4e24da22d7a75bbdbae18e0c64575ff7fe858 (diff) | |
| download | volse-hubzilla-38cf37d3c3a4bc9873aa12eed5167b356282385f.tar.gz volse-hubzilla-38cf37d3c3a4bc9873aa12eed5167b356282385f.tar.bz2 volse-hubzilla-38cf37d3c3a4bc9873aa12eed5167b356282385f.zip | |
new item view, sort by received date - not posted date.
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/database.sql b/database.sql index 284ab0afc..b99796d83 100644 --- a/database.sql +++ b/database.sql @@ -169,9 +169,10 @@ CREATE TABLE IF NOT EXISTS `item` ( `parent-uri` char(255) NOT NULL, `extid` char(255) NOT NULL, `thr-parent` char(255) NOT NULL, - `created` datetime NOT NULL, - `edited` datetime NOT NULL, - `changed` datetime NOT NULL, + `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `edited` 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, `owner-link` char(255) NOT NULL, `owner-avatar` char(255) NOT NULL, @@ -215,6 +216,7 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `extid` (`extid`), KEY `created` (`created`), KEY `edited` (`edited`), + KEY `received` (`received`), KEY `visible` (`visible`), KEY `deleted` (`deleted`), KEY `last-child` (`last-child`), |