diff options
| -rw-r--r-- | docs/owncloud.sql | 175 | ||||
| -rw-r--r-- | lib/log.php | 14 |
2 files changed, 182 insertions, 7 deletions
diff --git a/docs/owncloud.sql b/docs/owncloud.sql new file mode 100644 index 00000000000..3f96a4540eb --- /dev/null +++ b/docs/owncloud.sql @@ -0,0 +1,175 @@ +-- 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, + `key` varchar(255) COLLATE utf8_unicode_ci NOT NULL, + `value` 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 '', + `created` int(11) NOT NULL DEFAULT '0', + `modified` int(11) NOT NULL DEFAULT '0', + `expires` int(11) NOT NULL DEFAULT '0', + `owner` varchar(200) DEFAULT NULL, + `recursive` int(11) DEFAULT '0', + `writelock` int(11) DEFAULT '0', + `exclusivelock` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`token`), + UNIQUE KEY `token` (`token`), + KEY `path` (`path`), + 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(10) unsigned NOT NULL AUTO_INCREMENT, + `timestamp` 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, + `key` varchar(255) COLLATE utf8_unicode_ci NOT NULL, + `value` 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 '', + `ns` varchar(120) NOT NULL DEFAULT 'DAV:', + `value` text, + PRIMARY KEY (`path`,`name`,`ns`), + KEY `path` (`path`) +) 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, + `name` varchar(255) 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` +-- diff --git a/lib/log.php b/lib/log.php index 289ab18faba..3626849f578 100644 --- a/lib/log.php +++ b/lib/log.php @@ -25,14 +25,14 @@ * The following SQL statement is just a help for developers and will not be * executed! * - * CREATE TABLE `log` ( - * `id` INT PRIMARY KEY AUTO INCREMENT, - * `timestamp` DATETIME NOT NULL, + * CREATE TABLE `log` ( + * `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , + * `timestamp` DATETIME NOT NULL , * `appid` VARCHAR( 255 ) NOT NULL , - * `subject` VARCHAR( 255 ), - * `predicate` VARCHAR( 255 ), - * `object` TEXT - * ) + * `user` VARCHAR( 255 ) NOT NULL , + * `action` VARCHAR( 255 ) NOT NULL , + * `info` TEXT NOT NULL + * ) ENGINE = MYISAM ; * */ |