1 files changed, 156 insertions, 33 deletions
diff --git a/docs/owncloud.sql b/docs/owncloud.sql
index 94e500bf004..bef528596fb 100644
--- a/docs/owncloud.sql
+++ b/docs/owncloud.sql
@@ -1,3 +1,80 @@
+-- phpMyAdmin SQL Dump
+-- version 3.3.7deb5
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Erstellungszeit: 16. April 2011 um 10:40
+-- Server Version: 5.1.49
+-- PHP-Version: 5.3.3-7+squeeze1
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+
+--
+-- Datenbank: `owncloud`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `appconfig`
+--
+
+CREATE TABLE IF NOT EXISTS `appconfig` (
+  `appid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+  `configkey` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+  `configvalue` varchar(255) COLLATE utf8_unicode_ci NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+--
+-- Daten für Tabelle `appconfig`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `groups`
+--
+
+CREATE TABLE IF NOT EXISTS `groups` (
+  `gid` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+  PRIMARY KEY (`gid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+--
+-- Daten für Tabelle `groups`
+--
+
+INSERT INTO `groups` (`gid`) VALUES
+('admin');
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `group_user`
+--
+
+CREATE TABLE IF NOT EXISTS `group_user` (
+  `gid` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+  `uid` varchar(64) COLLATE utf8_unicode_ci NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+--
+-- Daten für Tabelle `group_user`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `locks`
+--
+
 CREATE TABLE IF NOT EXISTS `locks` (
   `token` varchar(255) NOT NULL DEFAULT '',
   `path` varchar(200) NOT NULL DEFAULT '',
@@ -14,18 +91,58 @@ CREATE TABLE IF NOT EXISTS `locks` (
   KEY `path_2` (`path`),
   KEY `path_3` (`path`,`token`),
   KEY `expires` (`expires`)
-);
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Daten für Tabelle `locks`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `log`
+--
 
 CREATE TABLE IF NOT EXISTS `log` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `timestamp` int(11) NOT NULL,
-  `user` varchar(250) NOT NULL,
-  `type` int(11) NOT NULL,
-  `message` varchar(250) NOT NULL,
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `moment` datetime NOT NULL,
+  `appid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+  `user` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+  `action` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+  `info` text COLLATE utf8_unicode_ci NOT NULL,
   PRIMARY KEY (`id`)
-);
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
+
+--
+-- Daten für Tabelle `log`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `preferences`
+--
+
+CREATE TABLE IF NOT EXISTS `preferences` (
+  `userid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+  `appid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+  `configkey` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+  `configvalue` varchar(255) COLLATE utf8_unicode_ci NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+--
+-- Daten für Tabelle `preferences`
+--
 
 
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `properties`
+--
+
 CREATE TABLE IF NOT EXISTS `properties` (
   `path` varchar(255) NOT NULL DEFAULT '',
   `name` varchar(120) NOT NULL DEFAULT '',
@@ -33,29 +150,35 @@ CREATE TABLE IF NOT EXISTS `properties` (
   `value` text,
   PRIMARY KEY (`path`,`name`,`ns`),
   KEY `path` (`path`)
-);
-
-CREATE TABLE IF NOT EXISTS  `users` (
-`user_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
-`user_name` VARCHAR( 64 ) NOT NULL ,
-`user_name_clean` VARCHAR( 64 ) NOT NULL ,
-`user_password` VARCHAR( 340) NOT NULL ,
-UNIQUE (
-`user_name` ,
-`user_name_clean`
-)
-);
-
-CREATE TABLE IF NOT EXISTS  `groups` (
-`group_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
-`group_name` VARCHAR( 64 ) NOT NULL ,
-UNIQUE (
-`group_name`
-)
-);
-
-CREATE TABLE IF NOT EXISTS  `user_group` (
-`user_group_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
-`user_id` VARCHAR( 64 ) NOT NULL ,
-`group_id` VARCHAR( 64 ) NOT NULL
-)
-\ No newline at end of file
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Daten für Tabelle `properties`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `users`
+--
+
+CREATE TABLE IF NOT EXISTS `users` (
+  `uid` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+  PRIMARY KEY (`uid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+--
+-- Daten für Tabelle `users`
+--
+
+--
+-- Table structure for table `foldersize`
+--
+
+CREATE TABLE IF NOT EXISTS `foldersize` (
+  `path` varchar(512) NOT NULL,
+  `size` int(11) NOT NULL,
+  PRIMARY KEY (`path`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+\ No newline at end of file