BEGIN TRANSACTION;
CREATE TABLE CALDAV (
                KEY text unique, VALUE text unique
            );
INSERT INTO "CALDAV" VALUES('SCHEMA_VERSION','3');
INSERT INTO "CALDAV" VALUES('TYPE','DIRECTORYSERVICE');
CREATE TABLE SERVICE (REALM text);
CREATE TABLE ACCOUNTS (
                RECORD_TYPE  text,
                SHORT_NAME   text,
                GUID         text,
                PASSWORD     text,
                NAME         text
            );
CREATE TABLE GROUPS (
                SHORT_NAME          text,
                MEMBER_RECORD_TYPE  text,
                MEMBER_SHORT_NAME   text
            );
CREATE TABLE ADDRESSES (
                ADDRESS     text unique,
                SHORT_NAME  text
            );
COMMIT;