diff options
| author | Friendika <info@friendika.com> | 2010-12-04 23:16:16 -0800 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2010-12-04 23:16:16 -0800 |
| commit | e9a1abd133aa3db62d17ef8bdc91e8a75f4004d3 (patch) | |
| tree | d48e62fd2589c56d02844249e65168e7198f3029 /database.sql | |
| parent | 4507a571d3bea1fd32337565d05230ed2b2119a9 (diff) | |
| download | volse-hubzilla-e9a1abd133aa3db62d17ef8bdc91e8a75f4004d3.tar.gz volse-hubzilla-e9a1abd133aa3db62d17ef8bdc91e8a75f4004d3.tar.bz2 volse-hubzilla-e9a1abd133aa3db62d17ef8bdc91e8a75f4004d3.zip | |
flatten conversation hierarchy to one level on import but preserve all thread info
in case somebody wants to write a plugin to display as multi-level thread
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/database.sql b/database.sql index 41d256d73..be0671bb1 100644 --- a/database.sql +++ b/database.sql @@ -153,14 +153,15 @@ CREATE TABLE IF NOT EXISTS `intro` ( CREATE TABLE IF NOT EXISTS `item` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `uri` char(255) CHARACTER SET ascii NOT NULL, + `uri` char(255) NOT NULL, `uid` int(10) unsigned NOT NULL DEFAULT '0', `contact-id` int(10) unsigned NOT NULL DEFAULT '0', `type` char(255) NOT NULL, `wall` tinyint(1) NOT NULL DEFAULT '0', `gravity` tinyint(1) NOT NULL DEFAULT '0', `parent` int(10) unsigned NOT NULL DEFAULT '0', - `parent-uri` char(255) CHARACTER SET ascii NOT NULL, + `parent-uri` char(255) NOT NULL, + `thr-parent` char(255) NOT NULL, `created` datetime NOT NULL, `edited` datetime NOT NULL, `changed` datetime NOT NULL, |