Changeset View
Changeset View
Standalone View
Standalone View
plugins/libkolab/SQL/oracle.initial.sql
| /** | |||||
| * libkolab database schema | |||||
| * | |||||
| * @author Aleksander Machniak | |||||
| * @licence GNU AGPL | |||||
| */ | |||||
| CREATE TABLE "kolab_folders" ( | CREATE TABLE "kolab_folders" ( | ||||
| "folder_id" number NOT NULL PRIMARY KEY, | "folder_id" number 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 DEFAULT 0 NOT NULL, | "synclock" integer DEFAULT 0 NOT NULL, | ||||
| "ctag" VARCHAR(40) DEFAULT NULL, | "ctag" VARCHAR(40) DEFAULT NULL, | ||||
| "changed" timestamp DEFAULT NULL, | "changed" timestamp DEFAULT NULL, | ||||
| "objectcount" number DEFAULT NULL | "objectcount" number DEFAULT NULL | ||||
| ▲ Show 20 Lines • Show All 161 Lines • Show Last 20 Lines | |||||