diff options
| author | Thomas Müller <thomas.mueller@tmit.eu> | 2015-11-23 17:19:17 +0100 |
|---|---|---|
| committer | Thomas Müller <thomas.mueller@tmit.eu> | 2015-11-23 17:19:17 +0100 |
| commit | 2bffeefee1d366a82eda66b9bd8a04f04bacab77 (patch) | |
| tree | 4a234738019faec38e56c27422047388261a167a | |
| parent | 7062e6636d52cae1ef086ab1f6caa97b10df3c0b (diff) | |
| parent | 6bd343a3b755dd4065c61e1623c2d3aa1437c745 (diff) | |
| download | nextcloud-server-2bffeefee1d366a82eda66b9bd8a04f04bacab77.tar.gz nextcloud-server-2bffeefee1d366a82eda66b9bd8a04f04bacab77.zip | |
Merge pull request #20622 from owncloud/comments-dbscheme
DB scheme for Comments table, resolves #20265
| -rw-r--r-- | db_structure.xml | 151 |
1 files changed, 151 insertions, 0 deletions
diff --git a/db_structure.xml b/db_structure.xml index 8135746233e..d4e566d1d54 100644 --- a/db_structure.xml +++ b/db_structure.xml @@ -1204,5 +1204,156 @@ </table> + <table> + <!-- + default place to store comment data + --> + <name>*dbprefix*comments</name> + + <declaration> + + <field> + <name>id</name> + <type>integer</type> + <default>0</default> + <notnull>true</notnull> + <unsigned>true</unsigned> + <length>4</length> + <autoincrement>1</autoincrement> + </field> + + <field> + <name>parent_id</name> + <type>integer</type> + <default>0</default> + <notnull>true</notnull> + <unsigned>true</unsigned> + <length>4</length> + </field> + + <field> + <name>topmost_parent_id</name> + <type>integer</type> + <default>0</default> + <notnull>true</notnull> + <unsigned>true</unsigned> + <length>4</length> + </field> + + <field> + <name>children_count</name> + <type>integer</type> + <default>0</default> + <notnull>true</notnull> + <unsigned>true</unsigned> + <length>4</length> + </field> + + <field> + <name>actor_type</name> + <type>text</type> + <default></default> + <notnull>true</notnull> + <length>64</length> + </field> + + <field> + <name>actor_id</name> + <type>text</type> + <default></default> + <notnull>true</notnull> + <length>64</length> + </field> + + <field> + <name>message</name> + <type>clob</type> + <default></default> + <notnull>false</notnull> + </field> + + <field> + <name>verb</name> + <type>text</type> + <default></default> + <notnull>false</notnull> + <length>64</length> + </field> + + <field> + <name>creation_timestamp</name> + <type>timestamp</type> + <default></default> + <notnull>false</notnull> + </field> + + <field> + <name>latest_child_timestamp</name> + <type>timestamp</type> + <default></default> + <notnull>false</notnull> + </field> + + <field> + <name>object_type</name> + <type>text</type> + <default></default> + <notnull>true</notnull> + <length>64</length> + </field> + + <field> + <name>object_id</name> + <type>text</type> + <default></default> + <notnull>true</notnull> + <length>64</length> + </field> +<!-- + TODO: finalize indexes when all queries are done + <index> + <name>comments_parent_id_index</name> + <unique>false</unique> + <field> + <name>parent_id</name> + <sorting>descending</sorting> + </field> + </index> + + <index> + <name>comments_actor_index</name> + <unique>false</unique> + <field> + <name>actor_type</name> + <sorting>ascending</sorting> + </field> + <field> + <name>actor_id</name> + <sorting>ascending</sorting> + </field> + </index> + + <index> + <name>comments_object_index</name> + <unique>false</unique> + <field> + <name>object_type</name> + <sorting>ascending</sorting> + </field> + <field> + <name>object_id</name> + <sorting>ascending</sorting> + </field> + <field> + <name>creation_timestamp</name> + <sorting>descending</sorting> + </field> + </index> +--> + + </declaration> + + </table> + </database> |