[Owncloud] Re: SabreDAV

[Jan-Christoph Borchardt]

Here are the handy SQL commands to repair your database, first for SQLite,
then for MySQL. Be sure to correct the prefix if you don’t use "oc_":

SQL FOR SQLITE DATABASE

DROP TABLE 'oc_locks';
CREATE TABLE IF NOT EXISTS 'oc_locks' (
  'id' int(10) NOT NULL,
  'userid' varchar(200) DEFAULT NULL,
  'owner' varchar(100) DEFAULT NULL,
  'timeout' int(10) DEFAULT NULL,
  'created' int(11) DEFAULT NULL,
  'token' varchar(100) DEFAULT NULL,
  'scope' tinyint(4) DEFAULT NULL,
  'depth' tinyint(4) DEFAULT NULL,
  'uri' text,
  PRIMARY KEY ('id')
);
DROP TABLE 'oc_properties';
CREATE TABLE IF NOT EXISTS 'oc_properties' (
  'userid' varchar(200) NOT NULL,
  'propertypath' varchar(255) NOT NULL,
  'propertyname' varchar(255) NOT NULL,
  'propertyvalue' text NOT NULL
);

###################################

SQL FOR MYSQL DATABASE

DROP TABLE 'oc_locks';
CREATE TABLE IF NOT EXISTS 'oc_locks' (
  'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
  'userid' varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  'owner' varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  'timeout' int(10) unsigned DEFAULT NULL,
  'created' int(11) DEFAULT NULL,
  'token' varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  'scope' tinyint(4) DEFAULT NULL,
  'depth' tinyint(4) DEFAULT NULL,
  'uri' text COLLATE utf8_unicode_ci,
  PRIMARY KEY ('id')
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=1 ;
DROP TABLE 'oc_properties';
CREATE TABLE IF NOT EXISTS 'oc_properties' (
  'userid' varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  'propertypath' varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  'propertyname' varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  'propertyvalue' text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



On Fri, July 22, 2011 23:45, Jakob Sack wrote:
> Hello list,
>
> I replaced HTTP_Webdav with SabreDAV. The WebDAV part of ownCloud should
> work
> much better now. To tell you some advantages of SabreDAV: it is a very
> active
> project, the developers answer questions within hours, CalDAV and CardDAV
> support are implemented and the code ownCloud needs to use SabreDAV is
> very
> small.
> On the downside I had to change the database layout. The tables "locks"
> and
> "properties" changed. If you like messing around with SQL you'll find the
> table
> definitions in docs/owncloud.sql, the rest of you might create a new
> ownCloud
> installation.
> See you at Desktop Summit,
>
> Jakob
> _______________________________________________
> Owncloud mailing list
> Owncloud at kde.org
> https://mail.kde.org/mailman/listinfo/owncloud
>