Changeset View
Changeset View
Standalone View
Standalone View
src/server/storage/akonadidb.xml
| Show First 20 Lines • Show All 124 Lines • ▼ Show 20 Line(s) | 64 | <database> | |||
|---|---|---|---|---|---|
| 125 | <table name="PimItem"> | 125 | <table name="PimItem"> | ||
| 126 | <column name="id" type="qint64" allowNull="false" isAutoIncrement="true" isPrimaryKey="true"/> | 126 | <column name="id" type="qint64" allowNull="false" isAutoIncrement="true" isPrimaryKey="true"/> | ||
| 127 | <column name="rev" type="int" default="0" allowNull="false"/> | 127 | <column name="rev" type="int" default="0" allowNull="false"/> | ||
| 128 | <column name="remoteId" type="QString"/> | 128 | <column name="remoteId" type="QString"/> | ||
| 129 | <column name="remoteRevision" type="QString"/> | 129 | <column name="remoteRevision" type="QString"/> | ||
| 130 | <column name="gid" type="QString"/> | 130 | <column name="gid" type="QString"/> | ||
| 131 | <column name="collectionId" type="qint64" refTable="Collection" refColumn="id"/> | 131 | <column name="collectionId" type="qint64" refTable="Collection" refColumn="id"/> | ||
| 132 | <column name="mimeTypeId" type="qint64" refTable="MimeType" refColumn="id" onDelete="Restrict"/> | 132 | <column name="mimeTypeId" type="qint64" refTable="MimeType" refColumn="id" onDelete="Restrict"/> | ||
| 133 | <column name="datetime" type="QDateTime" default="QDateTime::currentDateTime()"> | 133 | <column name="datetime" type="QDateTime" default="QDateTime::currentDateTimeUtc()"> | ||
| 134 | <comment>create/modified time</comment> | 134 | <comment>create/modified time</comment> | ||
| 135 | </column> | 135 | </column> | ||
| 136 | <column name="atime" type="QDateTime" default="QDateTime::currentDateTime()"> | 136 | <column name="atime" type="QDateTime" default="QDateTime::currentDateTimeUtc()"> | ||
| 137 | <comment>read access time</comment> | 137 | <comment>read access time</comment> | ||
| 138 | </column> | 138 | </column> | ||
| 139 | <column name="dirty" type="bool"> | 139 | <column name="dirty" type="bool"> | ||
| 140 | <comment>Indicates that this item has unsaved changes.</comment> | 140 | <comment>Indicates that this item has unsaved changes.</comment> | ||
| 141 | </column> | 141 | </column> | ||
| 142 | <column name="size" type="qint64" default="0" allowNull="false"/> | 142 | <column name="size" type="qint64" default="0" allowNull="false"/> | ||
| 143 | <index name="collectionIndex" columns="collectionId" unique="false"/> | 143 | <index name="collectionIndex" columns="collectionId" unique="false"/> | ||
| 144 | <index name="gidIndex" columns="gid" unique="false"/> | 144 | <index name="gidIndex" columns="gid" unique="false"/> | ||
| ▲ Show 20 Lines • Show All 104 Lines • Show Last 20 Lines | |||||