diff options
author | Mario Vavti <mario@mariovavti.com> | 2016-05-29 00:33:28 +0200 |
---|---|---|
committer | Mario Vavti <mario@mariovavti.com> | 2016-05-29 00:33:28 +0200 |
commit | aab9766c53e42c3141d0497fce78977d262efbc1 (patch) | |
tree | f633ad641d818d6229ea7d14e72de42e739196de /vendor/sabre/dav/examples/sql/mysql.addressbook.sql | |
parent | 66effbfe0827fc61fff6d248797a894213ad20d6 (diff) | |
download | volse-hubzilla-aab9766c53e42c3141d0497fce78977d262efbc1.tar.gz volse-hubzilla-aab9766c53e42c3141d0497fce78977d262efbc1.tar.bz2 volse-hubzilla-aab9766c53e42c3141d0497fce78977d262efbc1.zip |
missed some files
Diffstat (limited to 'vendor/sabre/dav/examples/sql/mysql.addressbook.sql')
-rw-r--r-- | vendor/sabre/dav/examples/sql/mysql.addressbook.sql | 28 |
1 files changed, 0 insertions, 28 deletions
diff --git a/vendor/sabre/dav/examples/sql/mysql.addressbook.sql b/vendor/sabre/dav/examples/sql/mysql.addressbook.sql deleted file mode 100644 index 5ec8428a7..000000000 --- a/vendor/sabre/dav/examples/sql/mysql.addressbook.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=utf8 COLLATE=utf8_unicode_ci; - -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=utf8 COLLATE=utf8_unicode_ci; - -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=utf8 COLLATE=utf8_unicode_ci; |