diff options
| author | Thomas Tanghus <thomas@tanghus.net> | 2012-10-19 13:18:57 +0200 |
|---|---|---|
| committer | Thomas Tanghus <thomas@tanghus.net> | 2012-10-19 13:18:57 +0200 |
| commit | 1c9929d44f9d826493de7222ad42ff220cfd0cab (patch) | |
| tree | 2a903e1cd76ed7d4d28dd10f15c2c2be9d930e79 /tests/data | |
| parent | 03ff614265da769cfef8ce62a535004e4346d3f0 (diff) | |
| download | nextcloud-server-1c9929d44f9d826493de7222ad42ff220cfd0cab.tar.gz nextcloud-server-1c9929d44f9d826493de7222ad42ff220cfd0cab.zip | |
Added unit tests for OC_DB::insertIfNotExist()
Diffstat (limited to 'tests/data')
| -rw-r--r-- | tests/data/db_structure.xml | 84 |
1 files changed, 84 insertions, 0 deletions
diff --git a/tests/data/db_structure.xml b/tests/data/db_structure.xml index 03d7502c441..8a80819adf2 100644 --- a/tests/data/db_structure.xml +++ b/tests/data/db_structure.xml @@ -135,4 +135,88 @@ </table> + <table> + + <name>*dbprefix*vcategory</name> + + <declaration> + + <field> + <name>id</name> + <type>integer</type> + <default>0</default> + <notnull>true</notnull> + <autoincrement>1</autoincrement> + <unsigned>true</unsigned> + <length>4</length> + </field> + + <field> + <name>uid</name> + <type>text</type> + <default></default> + <notnull>true</notnull> + <length>64</length> + </field> + + <field> + <name>type</name> + <type>text</type> + <default></default> + <notnull>true</notnull> + <length>64</length> + </field> + + <field> + <name>category</name> + <type>text</type> + <default></default> + <notnull>true</notnull> + <length>255</length> + </field> + + <index> + <name>uid_index</name> + <field> + <name>uid</name> + <sorting>ascending</sorting> + </field> + </index> + + <index> + <name>type_index</name> + <field> + <name>type</name> + <sorting>ascending</sorting> + </field> + </index> + + <index> + <name>category_index</name> + <field> + <name>category</name> + <sorting>ascending</sorting> + </field> + </index> + + <index> + <name>uid_type_category_index</name> + <unique>true</unique> + <field> + <name>uid</name> + <sorting>ascending</sorting> + </field> + <field> + <name>type</name> + <sorting>ascending</sorting> + </field> + <field> + <name>category</name> + <sorting>ascending</sorting> + </field> + </index> + + </declaration> + </table> + </database> |