Changeset View
Changeset View
Standalone View
Standalone View
plugins/libkolab/SQL/sqlite.initial.sql
| /** | |||||
| * libkolab database schema | |||||
| * | |||||
| * @author Thomas Bruederli | |||||
| * @licence GNU AGPL | |||||
| */ | |||||
| CREATE TABLE kolab_folders ( | CREATE TABLE kolab_folders ( | ||||
| folder_id INTEGER NOT NULL PRIMARY KEY, | folder_id INTEGER NOT NULL PRIMARY KEY, | ||||
| resource VARCHAR(255) NOT NULL, | resource VARCHAR(255) NOT NULL, | ||||
| type VARCHAR(32) NOT NULL, | type VARCHAR(32) NOT NULL, | ||||
| synclock INTEGER NOT NULL DEFAULT '0', | synclock INTEGER NOT NULL DEFAULT '0', | ||||
| ctag VARCHAR(40) DEFAULT NULL, | ctag VARCHAR(40) DEFAULT NULL, | ||||
| changed DATETIME DEFAULT NULL, | changed DATETIME DEFAULT NULL, | ||||
| objectcount INTEGER DEFAULT NULL | objectcount INTEGER DEFAULT NULL | ||||
| ▲ Show 20 Lines • Show All 135 Lines • Show Last 20 Lines | |||||