aboutsummaryrefslogtreecommitdiffstats
path: root/vendor/examples/sql
diff options
context:
space:
mode:
authorMario Vavti <mario@mariovavti.com>2016-05-29 10:58:11 +0200
committerMario Vavti <mario@mariovavti.com>2016-05-29 10:58:11 +0200
commitcac6cef4952e6535788c1c6db8ef1e58e88536a0 (patch)
tree574d653201c280cb082877f80d814b6899aacaf9 /vendor/examples/sql
parentaab9766c53e42c3141d0497fce78977d262efbc1 (diff)
downloadvolse-hubzilla-cac6cef4952e6535788c1c6db8ef1e58e88536a0.tar.gz
volse-hubzilla-cac6cef4952e6535788c1c6db8ef1e58e88536a0.tar.bz2
volse-hubzilla-cac6cef4952e6535788c1c6db8ef1e58e88536a0.zip
use composer to install sabre32
Diffstat (limited to 'vendor/examples/sql')
-rw-r--r--vendor/examples/sql/mysql.addressbooks.sql28
-rw-r--r--vendor/examples/sql/mysql.calendars.sql76
-rw-r--r--vendor/examples/sql/mysql.locks.sql12
-rw-r--r--vendor/examples/sql/mysql.principals.sql20
-rw-r--r--vendor/examples/sql/mysql.propertystorage.sql9
-rw-r--r--vendor/examples/sql/mysql.users.sql9
-rw-r--r--vendor/examples/sql/pgsql.addressbooks.sql44
-rw-r--r--vendor/examples/sql/pgsql.calendars.sql105
-rw-r--r--vendor/examples/sql/pgsql.locks.sql19
-rw-r--r--vendor/examples/sql/pgsql.principals.sql30
-rw-r--r--vendor/examples/sql/pgsql.propertystorage.sql13
-rw-r--r--vendor/examples/sql/pgsql.users.sql14
-rw-r--r--vendor/examples/sql/sqlite.addressbooks.sql28
-rw-r--r--vendor/examples/sql/sqlite.calendars.sql76
-rw-r--r--vendor/examples/sql/sqlite.locks.sql12
-rw-r--r--vendor/examples/sql/sqlite.principals.sql20
-rw-r--r--vendor/examples/sql/sqlite.propertystorage.sql10
-rw-r--r--vendor/examples/sql/sqlite.users.sql9
18 files changed, 0 insertions, 534 deletions
diff --git a/vendor/examples/sql/mysql.addressbooks.sql b/vendor/examples/sql/mysql.addressbooks.sql
deleted file mode 100644
index 9ec88babe..000000000
--- a/vendor/examples/sql/mysql.addressbooks.sql
+++ /dev/null
@@ -1,28 +0,0 @@
-CREATE TABLE addressbooks (
- id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
- principaluri VARBINARY(255),
- displayname VARCHAR(255),
- uri VARBINARY(200),
- description TEXT,
- synctoken INT(11) UNSIGNED NOT NULL DEFAULT '1',
- UNIQUE(principaluri(100), uri(100))
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE cards (
- id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
- addressbookid INT(11) UNSIGNED NOT NULL,
- carddata MEDIUMBLOB,
- uri VARBINARY(200),
- lastmodified INT(11) UNSIGNED,
- etag VARBINARY(32),
- size INT(11) UNSIGNED NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE addressbookchanges (
- id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
- uri VARBINARY(200) NOT NULL,
- synctoken INT(11) UNSIGNED NOT NULL,
- addressbookid INT(11) UNSIGNED NOT NULL,
- operation TINYINT(1) NOT NULL,
- INDEX addressbookid_synctoken (addressbookid, synctoken)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
diff --git a/vendor/examples/sql/mysql.calendars.sql b/vendor/examples/sql/mysql.calendars.sql
deleted file mode 100644
index 21c5bcb44..000000000
--- a/vendor/examples/sql/mysql.calendars.sql
+++ /dev/null
@@ -1,76 +0,0 @@
-CREATE TABLE calendarobjects (
- id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
- calendardata MEDIUMBLOB,
- uri VARBINARY(200),
- calendarid INTEGER UNSIGNED NOT NULL,
- lastmodified INT(11) UNSIGNED,
- etag VARBINARY(32),
- size INT(11) UNSIGNED NOT NULL,
- componenttype VARBINARY(8),
- firstoccurence INT(11) UNSIGNED,
- lastoccurence INT(11) UNSIGNED,
- uid VARBINARY(200),
- UNIQUE(calendarid, uri),
- INDEX calendarid_time (calendarid, firstoccurence)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE calendars (
- id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
- synctoken INTEGER UNSIGNED NOT NULL DEFAULT '1',
- components VARBINARY(21)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE calendarinstances (
- id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
- calendarid INTEGER UNSIGNED NOT NULL,
- principaluri VARBINARY(100),
- access TINYINT(1) NOT NULL DEFAULT '1' COMMENT '1 = owner, 2 = read, 3 = readwrite',
- displayname VARCHAR(100),
- uri VARBINARY(200),
- description TEXT,
- calendarorder INT(11) UNSIGNED NOT NULL DEFAULT '0',
- calendarcolor VARBINARY(10),
- timezone TEXT,
- transparent TINYINT(1) NOT NULL DEFAULT '0',
- share_href VARBINARY(100),
- share_displayname VARCHAR(100),
- share_invitestatus TINYINT(1) NOT NULL DEFAULT '2' COMMENT '1 = noresponse, 2 = accepted, 3 = declined, 4 = invalid',
- UNIQUE(principaluri, uri),
- UNIQUE(calendarid, principaluri),
- UNIQUE(calendarid, share_href)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE calendarchanges (
- id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
- uri VARBINARY(200) NOT NULL,
- synctoken INT(11) UNSIGNED NOT NULL,
- calendarid INT(11) UNSIGNED NOT NULL,
- operation TINYINT(1) NOT NULL,
- INDEX calendarid_synctoken (calendarid, synctoken)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE calendarsubscriptions (
- id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
- uri VARBINARY(200) NOT NULL,
- principaluri VARBINARY(100) NOT NULL,
- source TEXT,
- displayname VARCHAR(100),
- refreshrate VARCHAR(10),
- calendarorder INT(11) UNSIGNED NOT NULL DEFAULT '0',
- calendarcolor VARBINARY(10),
- striptodos TINYINT(1) NULL,
- stripalarms TINYINT(1) NULL,
- stripattachments TINYINT(1) NULL,
- lastmodified INT(11) UNSIGNED,
- UNIQUE(principaluri, uri)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE schedulingobjects (
- id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
- principaluri VARBINARY(255),
- calendardata MEDIUMBLOB,
- uri VARBINARY(200),
- lastmodified INT(11) UNSIGNED,
- etag VARBINARY(32),
- size INT(11) UNSIGNED NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
diff --git a/vendor/examples/sql/mysql.locks.sql b/vendor/examples/sql/mysql.locks.sql
deleted file mode 100644
index 96a3a88d9..000000000
--- a/vendor/examples/sql/mysql.locks.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-CREATE TABLE locks (
- id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
- owner VARCHAR(100),
- timeout INTEGER UNSIGNED,
- created INTEGER,
- token VARBINARY(100),
- scope TINYINT,
- depth TINYINT,
- uri VARBINARY(1000),
- INDEX(token),
- INDEX(uri(100))
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
diff --git a/vendor/examples/sql/mysql.principals.sql b/vendor/examples/sql/mysql.principals.sql
deleted file mode 100644
index ea0d16a27..000000000
--- a/vendor/examples/sql/mysql.principals.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-CREATE TABLE principals (
- id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
- uri VARBINARY(200) NOT NULL,
- email VARBINARY(80),
- displayname VARCHAR(80),
- UNIQUE(uri)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE groupmembers (
- id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
- principal_id INTEGER UNSIGNED NOT NULL,
- member_id INTEGER UNSIGNED NOT NULL,
- UNIQUE(principal_id, member_id)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-INSERT INTO principals (uri,email,displayname) VALUES
-('principals/admin', 'admin@example.org','Administrator'),
-('principals/admin/calendar-proxy-read', null, null),
-('principals/admin/calendar-proxy-write', null, null);
-
diff --git a/vendor/examples/sql/mysql.propertystorage.sql b/vendor/examples/sql/mysql.propertystorage.sql
deleted file mode 100644
index 1b5ca5ac6..000000000
--- a/vendor/examples/sql/mysql.propertystorage.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-CREATE TABLE propertystorage (
- id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
- path VARBINARY(1024) NOT NULL,
- name VARBINARY(100) NOT NULL,
- valuetype INT UNSIGNED,
- value MEDIUMBLOB
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE UNIQUE INDEX path_property ON propertystorage (path(600), name(100));
diff --git a/vendor/examples/sql/mysql.users.sql b/vendor/examples/sql/mysql.users.sql
deleted file mode 100644
index 22ac312d5..000000000
--- a/vendor/examples/sql/mysql.users.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-CREATE TABLE users (
- id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
- username VARBINARY(50),
- digesta1 VARBINARY(32),
- UNIQUE(username)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-INSERT INTO users (username,digesta1) VALUES
-('admin', '87fd274b7b6c01e48d7c2f965da8ddf7');
diff --git a/vendor/examples/sql/pgsql.addressbooks.sql b/vendor/examples/sql/pgsql.addressbooks.sql
deleted file mode 100644
index 98f414f42..000000000
--- a/vendor/examples/sql/pgsql.addressbooks.sql
+++ /dev/null
@@ -1,44 +0,0 @@
-CREATE TABLE addressbooks (
- id SERIAL NOT NULL,
- principaluri VARCHAR(255),
- displayname VARCHAR(255),
- uri VARCHAR(200),
- description TEXT,
- synctoken INTEGER NOT NULL DEFAULT 1
-);
-
-ALTER TABLE ONLY addressbooks
- ADD CONSTRAINT addressbooks_pkey PRIMARY KEY (id);
-
-CREATE UNIQUE INDEX addressbooks_ukey
- ON addressbooks USING btree (principaluri, uri);
-
-CREATE TABLE cards (
- id SERIAL NOT NULL,
- addressbookid INTEGER NOT NULL,
- carddata BYTEA,
- uri VARCHAR(200),
- lastmodified INTEGER,
- etag VARCHAR(32),
- size INTEGER NOT NULL
-);
-
-ALTER TABLE ONLY cards
- ADD CONSTRAINT cards_pkey PRIMARY KEY (id);
-
-CREATE UNIQUE INDEX cards_ukey
- ON cards USING btree (addressbookid, uri);
-
-CREATE TABLE addressbookchanges (
- id SERIAL NOT NULL,
- uri VARCHAR(200) NOT NULL,
- synctoken INTEGER NOT NULL,
- addressbookid INTEGER NOT NULL,
- operation SMALLINT NOT NULL
-);
-
-ALTER TABLE ONLY addressbookchanges
- ADD CONSTRAINT addressbookchanges_pkey PRIMARY KEY (id);
-
-CREATE INDEX addressbookchanges_addressbookid_synctoken_ix
- ON addressbookchanges USING btree (addressbookid, synctoken);
diff --git a/vendor/examples/sql/pgsql.calendars.sql b/vendor/examples/sql/pgsql.calendars.sql
deleted file mode 100644
index 67dc41a5a..000000000
--- a/vendor/examples/sql/pgsql.calendars.sql
+++ /dev/null
@@ -1,105 +0,0 @@
-CREATE TABLE calendarobjects (
- id SERIAL NOT NULL,
- calendardata BYTEA,
- uri VARCHAR(200),
- calendarid INTEGER NOT NULL,
- lastmodified INTEGER,
- etag VARCHAR(32),
- size INTEGER NOT NULL,
- componenttype VARCHAR(8),
- firstoccurence INTEGER,
- lastoccurence INTEGER,
- uid VARCHAR(200)
-);
-
-ALTER TABLE ONLY calendarobjects
- ADD CONSTRAINT calendarobjects_pkey PRIMARY KEY (id);
-
-CREATE UNIQUE INDEX calendarobjects_ukey
- ON calendarobjects USING btree (calendarid, uri);
-
-
-CREATE TABLE calendars (
- id SERIAL NOT NULL,
- synctoken INTEGER NOT NULL DEFAULT 1,
- components VARCHAR(21)
-);
-
-ALTER TABLE ONLY calendars
- ADD CONSTRAINT calendars_pkey PRIMARY KEY (id);
-
-
-CREATE TABLE calendarinstances (
- id SERIAL NOT NULL,
- calendarid INTEGER NOT NULL,
- principaluri VARCHAR(100),
- access SMALLINT NOT NULL DEFAULT '1', -- '1 = owner, 2 = read, 3 = readwrite'
- displayname VARCHAR(100),
- uri VARCHAR(200),
- description TEXT,
- calendarorder INTEGER NOT NULL DEFAULT 0,
- calendarcolor VARCHAR(10),
- timezone TEXT,
- transparent SMALLINT NOT NULL DEFAULT '0',
- share_href VARCHAR(100),
- share_displayname VARCHAR(100),
- share_invitestatus SMALLINT NOT NULL DEFAULT '2' -- '1 = noresponse, 2 = accepted, 3 = declined, 4 = invalid'
-);
-
-ALTER TABLE ONLY calendarinstances
- ADD CONSTRAINT calendarinstances_pkey PRIMARY KEY (id);
-
-CREATE UNIQUE INDEX calendarinstances_principaluri_uri
- ON calendarinstances USING btree (principaluri, uri);
-
-
-CREATE UNIQUE INDEX calendarinstances_principaluri_calendarid
- ON calendarinstances USING btree (principaluri, calendarid);
-
-CREATE UNIQUE INDEX calendarinstances_principaluri_share_href
- ON calendarinstances USING btree (principaluri, share_href);
-
-CREATE TABLE calendarsubscriptions (
- id SERIAL NOT NULL,
- uri VARCHAR(200) NOT NULL,
- principaluri VARCHAR(100) NOT NULL,
- source TEXT,
- displayname VARCHAR(100),
- refreshrate VARCHAR(10),
- calendarorder INTEGER NOT NULL DEFAULT 0,
- calendarcolor VARCHAR(10),
- striptodos SMALLINT NULL,
- stripalarms SMALLINT NULL,
- stripattachments SMALLINT NULL,
- lastmodified INTEGER
-);
-
-ALTER TABLE ONLY calendarsubscriptions
- ADD CONSTRAINT calendarsubscriptions_pkey PRIMARY KEY (id);
-
-CREATE UNIQUE INDEX calendarsubscriptions_ukey
- ON calendarsubscriptions USING btree (principaluri, uri);
-
-CREATE TABLE calendarchanges (
- id SERIAL NOT NULL,
- uri VARCHAR(200) NOT NULL,
- synctoken INTEGER NOT NULL,
- calendarid INTEGER NOT NULL,
- operation SMALLINT NOT NULL DEFAULT 0
-);
-
-ALTER TABLE ONLY calendarchanges
- ADD CONSTRAINT calendarchanges_pkey PRIMARY KEY (id);
-
-CREATE INDEX calendarchanges_calendarid_synctoken_ix
- ON calendarchanges USING btree (calendarid, synctoken);
-
-CREATE TABLE schedulingobjects (
- id SERIAL NOT NULL,
- principaluri VARCHAR(255),
- calendardata BYTEA,
- uri VARCHAR(200),
- lastmodified INTEGER,
- etag VARCHAR(32),
- size INTEGER NOT NULL
-);
diff --git a/vendor/examples/sql/pgsql.locks.sql b/vendor/examples/sql/pgsql.locks.sql
deleted file mode 100644
index 0290528ce..000000000
--- a/vendor/examples/sql/pgsql.locks.sql
+++ /dev/null
@@ -1,19 +0,0 @@
-CREATE TABLE locks (
- id SERIAL NOT NULL,
- owner VARCHAR(100),
- timeout INTEGER,
- created INTEGER,
- token VARCHAR(100),
- scope SMALLINT,
- depth SMALLINT,
- uri TEXT
-);
-
-ALTER TABLE ONLY locks
- ADD CONSTRAINT locks_pkey PRIMARY KEY (id);
-
-CREATE INDEX locks_token_ix
- ON locks USING btree (token);
-
-CREATE INDEX locks_uri_ix
- ON locks USING btree (uri);
diff --git a/vendor/examples/sql/pgsql.principals.sql b/vendor/examples/sql/pgsql.principals.sql
deleted file mode 100644
index 5a65260a2..000000000
--- a/vendor/examples/sql/pgsql.principals.sql
+++ /dev/null
@@ -1,30 +0,0 @@
-CREATE TABLE principals (
- id SERIAL NOT NULL,
- uri VARCHAR(200) NOT NULL,
- email VARCHAR(80),
- displayname VARCHAR(80)
-);
-
-ALTER TABLE ONLY principals
- ADD CONSTRAINT principals_pkey PRIMARY KEY (id);
-
-CREATE UNIQUE INDEX principals_ukey
- ON principals USING btree (uri);
-
-CREATE TABLE groupmembers (
- id SERIAL NOT NULL,
- principal_id INTEGER NOT NULL,
- member_id INTEGER NOT NULL
-);
-
-ALTER TABLE ONLY groupmembers
- ADD CONSTRAINT groupmembers_pkey PRIMARY KEY (id);
-
-CREATE UNIQUE INDEX groupmembers_ukey
- ON groupmembers USING btree (principal_id, member_id);
-
-INSERT INTO principals (uri,email,displayname) VALUES
-('principals/admin', 'admin@example.org','Administrator'),
-('principals/admin/calendar-proxy-read', null, null),
-('principals/admin/calendar-proxy-write', null, null);
-
diff --git a/vendor/examples/sql/pgsql.propertystorage.sql b/vendor/examples/sql/pgsql.propertystorage.sql
deleted file mode 100644
index d1463faae..000000000
--- a/vendor/examples/sql/pgsql.propertystorage.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-CREATE TABLE propertystorage (
- id SERIAL NOT NULL,
- path VARCHAR(1024) NOT NULL,
- name VARCHAR(100) NOT NULL,
- valuetype INT,
- value BYTEA
-);
-
-ALTER TABLE ONLY propertystorage
- ADD CONSTRAINT propertystorage_pkey PRIMARY KEY (id);
-
-CREATE UNIQUE INDEX propertystorage_ukey
- ON propertystorage (path, name);
diff --git a/vendor/examples/sql/pgsql.users.sql b/vendor/examples/sql/pgsql.users.sql
deleted file mode 100644
index 9d6047b8c..000000000
--- a/vendor/examples/sql/pgsql.users.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-CREATE TABLE users (
- id SERIAL NOT NULL,
- username VARCHAR(50),
- digesta1 VARCHAR(32)
-);
-
-ALTER TABLE ONLY users
- ADD CONSTRAINT users_pkey PRIMARY KEY (id);
-
-CREATE UNIQUE INDEX users_ukey
- ON users USING btree (username);
-
-INSERT INTO users (username,digesta1) VALUES
-('admin', '87fd274b7b6c01e48d7c2f965da8ddf7');
diff --git a/vendor/examples/sql/sqlite.addressbooks.sql b/vendor/examples/sql/sqlite.addressbooks.sql
deleted file mode 100644
index 0baed8bfb..000000000
--- a/vendor/examples/sql/sqlite.addressbooks.sql
+++ /dev/null
@@ -1,28 +0,0 @@
-CREATE TABLE addressbooks (
- id integer primary key asc NOT NULL,
- principaluri text NOT NULL,
- displayname text,
- uri text NOT NULL,
- description text,
- synctoken integer DEFAULT 1 NOT NULL
-);
-
-CREATE TABLE cards (
- id integer primary key asc NOT NULL,
- addressbookid integer NOT NULL,
- carddata blob,
- uri text NOT NULL,
- lastmodified integer,
- etag text,
- size integer
-);
-
-CREATE TABLE addressbookchanges (
- id integer primary key asc NOT NULL,
- uri text,
- synctoken integer NOT NULL,
- addressbookid integer NOT NULL,
- operation integer NOT NULL
-);
-
-CREATE INDEX addressbookid_synctoken ON addressbookchanges (addressbookid, synctoken);
diff --git a/vendor/examples/sql/sqlite.calendars.sql b/vendor/examples/sql/sqlite.calendars.sql
deleted file mode 100644
index 1c8070496..000000000
--- a/vendor/examples/sql/sqlite.calendars.sql
+++ /dev/null
@@ -1,76 +0,0 @@
-CREATE TABLE calendarobjects (
- id integer primary key asc NOT NULL,
- calendardata blob NOT NULL,
- uri text NOT NULL,
- calendarid integer NOT NULL,
- lastmodified integer NOT NULL,
- etag text NOT NULL,
- size integer NOT NULL,
- componenttype text,
- firstoccurence integer,
- lastoccurence integer,
- uid text
-);
-
-CREATE TABLE calendars (
- id integer primary key asc NOT NULL,
- synctoken integer DEFAULT 1 NOT NULL,
- components text NOT NULL
-);
-
-CREATE TABLE calendarinstances (
- id integer primary key asc NOT NULL,
- calendarid integer NOT NULL,
- principaluri text NULL,
- access integer COMMENT '1 = owner, 2 = read, 3 = readwrite' NOT NULL DEFAULT '1',
- displayname text,
- uri text NOT NULL,
- description text,
- calendarorder integer,
- calendarcolor text,
- timezone text,
- transparent bool,
- share_href text,
- share_displayname text,
- share_invitestatus integer DEFAULT '2',
- UNIQUE (principaluri, uri),
- UNIQUE (calendarid, principaluri),
- UNIQUE (calendarid, share_href)
-);
-
-CREATE TABLE calendarchanges (
- id integer primary key asc NOT NULL,
- uri text,
- synctoken integer NOT NULL,
- calendarid integer NOT NULL,
- operation integer NOT NULL
-);
-
-CREATE INDEX calendarid_synctoken ON calendarchanges (calendarid, synctoken);
-
-CREATE TABLE calendarsubscriptions (
- id integer primary key asc NOT NULL,
- uri text NOT NULL,
- principaluri text NOT NULL,
- source text NOT NULL,
- displayname text,
- refreshrate text,
- calendarorder integer,
- calendarcolor text,
- striptodos bool,
- stripalarms bool,
- stripattachments bool,
- lastmodified int
-);
-
-CREATE TABLE schedulingobjects (
- id integer primary key asc NOT NULL,
- principaluri text NOT NULL,
- calendardata blob,
- uri text NOT NULL,
- lastmodified integer,
- etag text NOT NULL,
- size integer NOT NULL
-);
-
-CREATE INDEX principaluri_uri ON calendarsubscriptions (principaluri, uri);
diff --git a/vendor/examples/sql/sqlite.locks.sql b/vendor/examples/sql/sqlite.locks.sql
deleted file mode 100644
index 622baea42..000000000
--- a/vendor/examples/sql/sqlite.locks.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-BEGIN TRANSACTION;
-CREATE TABLE locks (
- id integer primary key asc NOT NULL,
- owner text,
- timeout integer,
- created integer,
- token text,
- scope integer,
- depth integer,
- uri text
-);
-COMMIT;
diff --git a/vendor/examples/sql/sqlite.principals.sql b/vendor/examples/sql/sqlite.principals.sql
deleted file mode 100644
index 4105156f8..000000000
--- a/vendor/examples/sql/sqlite.principals.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-CREATE TABLE principals (
- id INTEGER PRIMARY KEY ASC NOT NULL,
- uri TEXT NOT NULL,
- email TEXT,
- displayname TEXT,
- UNIQUE(uri)
-);
-
-CREATE TABLE groupmembers (
- id INTEGER PRIMARY KEY ASC NOT NULL,
- principal_id INTEGER NOT NULL,
- member_id INTEGER NOT NULL,
- UNIQUE(principal_id, member_id)
-);
-
-
-INSERT INTO principals (uri,email,displayname) VALUES ('principals/admin', 'admin@example.org','Administrator');
-INSERT INTO principals (uri,email,displayname) VALUES ('principals/admin/calendar-proxy-read', null, null);
-INSERT INTO principals (uri,email,displayname) VALUES ('principals/admin/calendar-proxy-write', null, null);
-
diff --git a/vendor/examples/sql/sqlite.propertystorage.sql b/vendor/examples/sql/sqlite.propertystorage.sql
deleted file mode 100644
index 72e860ce3..000000000
--- a/vendor/examples/sql/sqlite.propertystorage.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-CREATE TABLE propertystorage (
- id integer primary key asc NOT NULL,
- path text NOT NULL,
- name text NOT NULL,
- valuetype integer NOT NULL,
- value string
-);
-
-
-CREATE UNIQUE INDEX path_property ON propertystorage (path, name);
diff --git a/vendor/examples/sql/sqlite.users.sql b/vendor/examples/sql/sqlite.users.sql
deleted file mode 100644
index 5597b058a..000000000
--- a/vendor/examples/sql/sqlite.users.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-CREATE TABLE users (
- id integer primary key asc NOT NULL,
- username TEXT NOT NULL,
- digesta1 TEXT NOT NULL,
- UNIQUE(username)
-);
-
-INSERT INTO users (username,digesta1) VALUES
-('admin', '87fd274b7b6c01e48d7c2f965da8ddf7');