Differential D20346 Diff 56284 src/server/storage/akonadidb.xml

Changeset View

Standalone View

View Options

src/server/storage/akonadidb.xml

Show First 20 Lines • Show All 61 Lines • ▼ Show 20 Line(s)
62 62​
63--> 63​-->
64<database> 64​<database>
65 65​
66 <table name="SchemaVersion"> 66​ <table name="SchemaVersion">
67 <comment>Contains the schema version of the database.</comment> 67​ <comment>Contains the schema version of the database.</comment>
68 <column name="version" type="int" default="0" allowNull="false"/> 68​ <column name="version" type="int" default="0" allowNull="false"/>
69 <column name="generation" type="int" default="0" allowNull="false" /> 69​ <column name="generation" type="int" default="0" allowNull="false" />
70 <data columns="version" values="39"/> 70​ <data columns="version" values="40"/>
71 </table> 71​ </table>
72 72​
73 <table name="Resource"> 73​ <table name="Resource">
74 <column name="id" type="qint64" allowNull="false" isAutoIncrement="true" isPrimaryKey="true"/> 74​ <column name="id" type="qint64" allowNull="false" isAutoIncrement="true" isPrimaryKey="true"/>
75 <column name="name" type="QString" allowNull="false" isUnique="true"/> 75​ <column name="name" type="QString" allowNull="false" isUnique="true"/>
76 <column name="isVirtual" type="bool" default="false"/> 76​ <column name="isVirtual" type="bool" default="false"/>
77 <reference name="collections" table="Collection" key="resourceId"/> 77​ <reference name="collections" table="Collection" key="resourceId"/>
78 <data columns="name,isVirtual" values="'akonadi_search_resource',true"/> 78​ <data columns="name,isVirtual" values="'akonadi_search_resource',true"/>
Show All 11 Lines81 <table name="Collection">
90 <column name="remoteRevision" type="QString"/> 90​ <column name="remoteRevision" type="QString"/>
91 <column name="name" type="QString" allowNull="false"/> 91​ <column name="name" type="QString" allowNull="false"/>
92 <column name="parentId" type="qint64" refTable="Collection" refColumn="id" methodName="parent"/> 92​ <column name="parentId" type="qint64" refTable="Collection" refColumn="id" methodName="parent"/>
93 <column name="resourceId" type="qint64" refTable="Resource" refColumn="id" allowNull="false"/> 93​ <column name="resourceId" type="qint64" refTable="Resource" refColumn="id" allowNull="false"/>
94 <column name="enabled" type="bool" default="true" allowNull="false"/> 94​ <column name="enabled" type="bool" default="true" allowNull="false"/>
95 <column name="syncPref" type="enum" enumType="Tristate" default="Tristate::Undefined"/> 95​ <column name="syncPref" type="enum" enumType="Tristate" default="Tristate::Undefined"/>
96 <column name="displayPref" type="enum" enumType="Tristate" default="Tristate::Undefined"/> 96​ <column name="displayPref" type="enum" enumType="Tristate" default="Tristate::Undefined"/>
97 <column name="indexPref" type="enum" enumType="Tristate" default="Tristate::Undefined"/> 97​ <column name="indexPref" type="enum" enumType="Tristate" default="Tristate::Undefined"/>
98 <column name="referenced" type="bool" default="false" allowNull="false"/> ​
99 <column name="cachePolicyInherit" type="bool" default="true" allowNull="false"/> 98​ <column name="cachePolicyInherit" type="bool" default="true" allowNull="false"/>
100 <column name="cachePolicyCheckInterval" type="int" default="-1" allowNull="false"/> 99​ <column name="cachePolicyCheckInterval" type="int" default="-1" allowNull="false"/>
101 <column name="cachePolicyCacheTimeout" type="int" default="-1" allowNull="false"/> 100​ <column name="cachePolicyCacheTimeout" type="int" default="-1" allowNull="false"/>
102 <column name="cachePolicySyncOnDemand" type="bool" default="false" allowNull="false"/> 101​ <column name="cachePolicySyncOnDemand" type="bool" default="false" allowNull="false"/>
103 <column name="cachePolicyLocalParts" type="QString"/> 102​ <column name="cachePolicyLocalParts" type="QString"/>
104 <column name="queryString" type="QString" size="32768"/> 103​ <column name="queryString" type="QString" size="32768"/>
105 <column name="queryAttributes" type="QString"/> 104​ <column name="queryAttributes" type="QString"/>
106 <column name="queryCollections" type="QString"/> 105​ <column name="queryCollections" type="QString"/>
▲ Show 20 Lines • Show All 153 Lines • Show Last 20 Lines