# ************************************************************
# Sequel Pro SQL dump
# Version 4096
#
# http://www.sequelpro.com/
# http://code.google.com/p/sequel-pro/
#
# Host: 192.168.6.120 (MySQL 5.5.35-0ubuntu0.13.10.2)
# Datenbank: owncloud
# Erstellungsdauer: 2014-03-01 20:01:29 +0000
# ************************************************************


/*!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 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Export von Tabelle oc_activity
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_activity`;

CREATE TABLE `oc_activity` (
  `activity_id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL DEFAULT '0',
  `priority` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0',
  `user` varchar(255) NOT NULL,
  `affecteduser` varchar(255) NOT NULL,
  `app` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `subjectparams` varchar(255) NOT NULL,
  `message` varchar(255) DEFAULT NULL,
  `messageparams` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`activity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_appconfig
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_appconfig`;

CREATE TABLE `oc_appconfig` (
  `configvalue` text NOT NULL,
  `appid` varchar(32) NOT NULL DEFAULT '',
  `configkey` varchar(64) NOT NULL DEFAULT '',
  `rowid` int(11) DEFAULT NULL,
  PRIMARY KEY (`configvalue`(50),`appid`,`configkey`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_bookmarks
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_bookmarks`;

CREATE TABLE `oc_bookmarks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(4096) NOT NULL DEFAULT ' ',
  `title` varchar(140) NOT NULL DEFAULT ' ',
  `user_id` varchar(64) NOT NULL DEFAULT ' ',
  `description` varchar(4096) NOT NULL DEFAULT ' ',
  `public` int(11) DEFAULT '0',
  `added` int(11) DEFAULT NULL,
  `lastmodified` int(11) DEFAULT NULL,
  `clickcount` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_bookmarks_tags
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_bookmarks_tags`;

CREATE TABLE `oc_bookmarks_tags` (
  `bookmark_id` bigint(20) DEFAULT '0',
  `tag` varchar(255) NOT NULL DEFAULT ' '
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_clndr_calendars
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_clndr_calendars`;

CREATE TABLE `oc_clndr_calendars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(255) DEFAULT NULL,
  `displayname` varchar(100) DEFAULT NULL,
  `uri` varchar(255) DEFAULT NULL,
  `active` int(11) NOT NULL DEFAULT '1',
  `ctag` int(11) NOT NULL DEFAULT '0',
  `calendarorder` int(11) NOT NULL DEFAULT '0',
  `calendarcolor` varchar(10) DEFAULT NULL,
  `timezone` text,
  `components` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_clndr_objects
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_clndr_objects`;

CREATE TABLE `oc_clndr_objects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `calendarid` int(11) NOT NULL DEFAULT '0',
  `objecttype` varchar(40) NOT NULL DEFAULT ' ',
  `startdate` datetime DEFAULT '1970-01-01 00:00:00',
  `enddate` datetime DEFAULT '1970-01-01 00:00:00',
  `repeating` int(11) DEFAULT NULL,
  `summary` varchar(255) DEFAULT NULL,
  `calendardata` text,
  `uri` varchar(255) DEFAULT NULL,
  `lastmodified` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_clndr_repeat
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_clndr_repeat`;

CREATE TABLE `oc_clndr_repeat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventid` int(11) NOT NULL DEFAULT '0',
  `calid` int(11) NOT NULL DEFAULT '0',
  `startdate` datetime DEFAULT '1970-01-01 00:00:00',
  `enddate` datetime DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_clndr_share_calendar
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_clndr_share_calendar`;

CREATE TABLE `oc_clndr_share_calendar` (
  `owner` varchar(255) NOT NULL DEFAULT ' ',
  `share` varchar(255) NOT NULL DEFAULT ' ',
  `sharetype` varchar(6) NOT NULL DEFAULT ' ',
  `calendarid` varchar(255) NOT NULL DEFAULT '0',
  `permissions` int(11) NOT NULL DEFAULT '0',
  `active` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_clndr_share_event
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_clndr_share_event`;

CREATE TABLE `oc_clndr_share_event` (
  `owner` varchar(255) NOT NULL DEFAULT ' ',
  `share` varchar(255) NOT NULL DEFAULT ' ',
  `sharetype` varchar(6) NOT NULL DEFAULT ' ',
  `eventid` varchar(255) NOT NULL DEFAULT '0',
  `permissions` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_contacts_addressbooks
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_contacts_addressbooks`;

CREATE TABLE `oc_contacts_addressbooks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `displayname` varchar(255) DEFAULT NULL,
  `uri` varchar(200) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `active` int(11) NOT NULL DEFAULT '1',
  `userid` varchar(255) NOT NULL DEFAULT '',
  `ctag` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_contacts_cards
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_contacts_cards`;

CREATE TABLE `oc_contacts_cards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) DEFAULT NULL,
  `carddata` text,
  `uri` varchar(200) DEFAULT NULL,
  `addressbookid` int(11) NOT NULL DEFAULT '0',
  `lastmodified` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_contacts_cards_properties
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_contacts_cards_properties`;

CREATE TABLE `oc_contacts_cards_properties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `preferred` int(11) NOT NULL DEFAULT '1',
  `userid` varchar(255) NOT NULL DEFAULT '',
  `contactid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_file_map
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_file_map`;

CREATE TABLE `oc_file_map` (
  `logic_path` varchar(512) NOT NULL DEFAULT '',
  `logic_path_hash` varchar(32) NOT NULL DEFAULT '',
  `physic_path` varchar(512) NOT NULL DEFAULT '',
  `physic_path_hash` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`logic_path_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_filecache
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_filecache`;

CREATE TABLE `oc_filecache` (
  `fileid` int(11) NOT NULL AUTO_INCREMENT,
  `storage` int(11) NOT NULL DEFAULT '0',
  `path` varchar(512) DEFAULT NULL,
  `parent` int(11) NOT NULL DEFAULT '0',
  `name` varchar(250) DEFAULT NULL,
  `mimetype` int(11) NOT NULL DEFAULT '0',
  `mimepart` int(11) NOT NULL DEFAULT '0',
  `mtime` int(11) NOT NULL DEFAULT '0',
  `encrypted` int(11) NOT NULL DEFAULT '0',
  `etag` varchar(40) DEFAULT NULL,
  `path_hash` varchar(32) NOT NULL DEFAULT '',
  `storage_mtime` int(11) NOT NULL DEFAULT '0',
  `size` int(11) NOT NULL,
  `unencrypted_size` int(11) NOT NULL,
  PRIMARY KEY (`fileid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_files_trash
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_files_trash`;

CREATE TABLE `oc_files_trash` (
  `id` varchar(250) NOT NULL DEFAULT ' ',
  `user` varchar(64) NOT NULL DEFAULT ' ',
  `timestamp` varchar(12) NOT NULL DEFAULT ' ',
  `location` varchar(512) NOT NULL DEFAULT ' ',
  `type` varchar(4) NOT NULL DEFAULT ' ',
  `mime` varchar(30) NOT NULL DEFAULT ' '
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_files_trashsize
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_files_trashsize`;

CREATE TABLE `oc_files_trashsize` (
  `user` varchar(64) NOT NULL DEFAULT ' ',
  `size` varchar(50) NOT NULL DEFAULT ' '
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_files_versions
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_files_versions`;

CREATE TABLE `oc_files_versions` (
  `user` varchar(64) NOT NULL DEFAULT ' ',
  `size` varchar(50) NOT NULL DEFAULT ' '
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_gallery_sharing
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_gallery_sharing`;

CREATE TABLE `oc_gallery_sharing` (
  `gallery_id` int(11) NOT NULL DEFAULT '0',
  `token` varchar(64) NOT NULL,
  `recursive` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_group_admin
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_group_admin`;

CREATE TABLE `oc_group_admin` (
  `gid` varchar(64) NOT NULL DEFAULT '',
  `uid` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_group_user
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_group_user`;

CREATE TABLE `oc_group_user` (
  `gid` varchar(64) NOT NULL DEFAULT '',
  `uid` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`gid`,`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_groups
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_groups`;

CREATE TABLE `oc_groups` (
  `gid` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_jobs
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_jobs`;

CREATE TABLE `oc_jobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `class` varchar(255) NOT NULL DEFAULT '',
  `argument` varchar(256) NOT NULL DEFAULT '',
  `last_run` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_locks
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_locks`;

CREATE TABLE `oc_locks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(64) DEFAULT NULL,
  `owner` varchar(100) DEFAULT NULL,
  `token` varchar(100) DEFAULT NULL,
  `uri` text,
  `timeout` int(11) DEFAULT NULL,
  `created` int(11) DEFAULT NULL,
  `scope` int(11) DEFAULT NULL,
  `depth` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_lucene_status
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_lucene_status`;

CREATE TABLE `oc_lucene_status` (
  `fileid` int(11) NOT NULL AUTO_INCREMENT,
  `status` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`fileid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_media_albums
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_media_albums`;

CREATE TABLE `oc_media_albums` (
  `album_id` int(11) NOT NULL AUTO_INCREMENT,
  `album_name` varchar(200) NOT NULL DEFAULT ' ',
  `album_artist` int(11) NOT NULL DEFAULT '0',
  `album_art` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`album_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_media_artists
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_media_artists`;

CREATE TABLE `oc_media_artists` (
  `artist_id` int(11) NOT NULL AUTO_INCREMENT,
  `artist_name` varchar(200) NOT NULL DEFAULT ' ',
  PRIMARY KEY (`artist_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_media_sessions
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_media_sessions`;

CREATE TABLE `oc_media_sessions` (
  `session_id` int(11) NOT NULL AUTO_INCREMENT,
  `token` varchar(64) NOT NULL DEFAULT ' ',
  `user_id` varchar(64) NOT NULL DEFAULT ' ',
  `start` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_media_songs
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_media_songs`;

CREATE TABLE `oc_media_songs` (
  `song_id` int(11) NOT NULL AUTO_INCREMENT,
  `song_name` varchar(200) NOT NULL DEFAULT ' ',
  `song_artist` int(11) NOT NULL DEFAULT '0',
  `song_album` int(11) NOT NULL DEFAULT '0',
  `song_path` varchar(200) NOT NULL DEFAULT ' ',
  `song_user` varchar(64) NOT NULL DEFAULT '0',
  `song_length` int(11) NOT NULL DEFAULT '0',
  `song_track` int(11) NOT NULL DEFAULT '0',
  `song_size` int(11) NOT NULL DEFAULT '0',
  `song_playcount` int(11) NOT NULL DEFAULT '0',
  `song_lastplayed` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`song_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_media_users
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_media_users`;

CREATE TABLE `oc_media_users` (
  `user_id` varchar(64) NOT NULL DEFAULT '0',
  `user_password_sha256` varchar(64) NOT NULL DEFAULT ' '
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_mimetypes
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_mimetypes`;

CREATE TABLE `oc_mimetypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mimetype` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_permissions
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_permissions`;

CREATE TABLE `oc_permissions` (
  `fileid` int(11) NOT NULL DEFAULT '0',
  `permissions` int(11) NOT NULL DEFAULT '0',
  `user` varchar(64) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_pictures_images_cache
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_pictures_images_cache`;

CREATE TABLE `oc_pictures_images_cache` (
  `uid_owner` varchar(64) NOT NULL,
  `path` varchar(256) NOT NULL,
  `width` int(11) NOT NULL,
  `height` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_preferences
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_preferences`;

CREATE TABLE `oc_preferences` (
  `configvalue` text NOT NULL,
  `userid` varchar(64) NOT NULL DEFAULT '',
  `appid` varchar(32) NOT NULL DEFAULT '',
  `configkey` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`configvalue`(50),`userid`,`appid`,`configkey`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_privatedata
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_privatedata`;

CREATE TABLE `oc_privatedata` (
  `keyid` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(255) NOT NULL DEFAULT '',
  `app` varchar(255) NOT NULL DEFAULT '',
  `key` varchar(255) NOT NULL DEFAULT '',
  `value` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`keyid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_properties
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_properties`;

CREATE TABLE `oc_properties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(64) NOT NULL DEFAULT '',
  `propertypath` varchar(255) NOT NULL DEFAULT '',
  `propertyname` varchar(255) NOT NULL DEFAULT '',
  `propertyvalue` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_queuedtasks
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_queuedtasks`;

CREATE TABLE `oc_queuedtasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app` varchar(255) NOT NULL DEFAULT ' ',
  `klass` varchar(255) NOT NULL DEFAULT ' ',
  `method` varchar(255) NOT NULL DEFAULT ' ',
  `parameters` varchar(255) NOT NULL DEFAULT ' ',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_share
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_share`;

CREATE TABLE `oc_share` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `share_with` varchar(255) DEFAULT NULL,
  `item_source` varchar(255) DEFAULT NULL,
  `item_target` varchar(255) DEFAULT NULL,
  `file_target` varchar(512) DEFAULT NULL,
  `expiration` datetime DEFAULT NULL,
  `token` varchar(32) DEFAULT NULL,
  `uid_owner` varchar(255) NOT NULL DEFAULT '',
  `parent` int(11) DEFAULT NULL,
  `item_type` varchar(64) NOT NULL DEFAULT '',
  `file_source` int(11) DEFAULT NULL,
  `share_type` int(11) NOT NULL,
  `permissions` int(11) NOT NULL,
  `stime` int(11) NOT NULL,
  `accepted` int(11) NOT NULL,
  `mail_send` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_storages
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_storages`;

CREATE TABLE `oc_storages` (
  `numeric_id` int(11) NOT NULL AUTO_INCREMENT,
  `id` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`numeric_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_users
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_users`;

CREATE TABLE `oc_users` (
  `displayname` varchar(64) DEFAULT NULL,
  `uid` varchar(64) NOT NULL DEFAULT '',
  `password` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_vcategory
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_vcategory`;

CREATE TABLE `oc_vcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(64) NOT NULL DEFAULT '',
  `type` varchar(64) NOT NULL DEFAULT '',
  `category` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Export von Tabelle oc_vcategory_to_object
# ------------------------------------------------------------

DROP TABLE IF EXISTS `oc_vcategory_to_object`;

CREATE TABLE `oc_vcategory_to_object` (
  `categoryid` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(64) NOT NULL DEFAULT '',
  `objid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`categoryid`,`type`,`objid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;