-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jun 26, 2007 at 05:17 PM
-- Server version: 5.0.42
-- PHP Version: 5.2.2-pl1-gentoo

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `xdi`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `fileChecksums`
-- 

CREATE TABLE `fileChecksums` (
  `id` bigint(20) NOT NULL,
  `md5sum` varchar(32) collate utf8_unicode_ci NOT NULL,
  `sha1sum` varchar(40) collate utf8_unicode_ci NOT NULL,
  `sha256sum` varchar(64) collate utf8_unicode_ci NOT NULL,
  `crc` varchar(8) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `fileIndex`
-- 

CREATE TABLE `fileIndex` (
  `id` bigint(20) NOT NULL,
  `host` varchar(64) collate utf8_unicode_ci NOT NULL,
  `path` varchar(2048) collate utf8_unicode_ci NOT NULL,
  `filename` varchar(64) collate utf8_unicode_ci NOT NULL,
  `mimeType` varchar(128) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `fileInfo`
-- 

CREATE TABLE `fileInfo` (
  `id` bigint(20) NOT NULL,
  `size` bigint(20) NOT NULL,
  `dateModified` datetime NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dataOpened` datetime NOT NULL,
  `owner` varchar(32) collate utf8_unicode_ci NOT NULL,
  `permissions` bigint(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `genericMeta`
-- 

CREATE TABLE `genericMeta` (
  `id` bigint(20) NOT NULL,
  `description` longtext collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `imageMeta`
-- 

CREATE TABLE `imageMeta` (
  `id` bigint(20) NOT NULL,
  `title` varchar(128) collate utf8_unicode_ci NOT NULL,
  `caption` text collate utf8_unicode_ci NOT NULL,
  `artist` varchar(128) collate utf8_unicode_ci NOT NULL,
  `thumbnail` blob NOT NULL,
  `hResolution` int(11) NOT NULL,
  `vResolution` int(11) NOT NULL,
  `colourDepth` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `musicMeta`
-- 

CREATE TABLE `musicMeta` (
  `id` bigint(20) NOT NULL,
  `title` varchar(128) collate utf8_unicode_ci NOT NULL,
  `artist` varchar(128) collate utf8_unicode_ci NOT NULL,
  `album` varchar(128) collate utf8_unicode_ci NOT NULL,
  `other` text collate utf8_unicode_ci NOT NULL,
  `bitrate` float NOT NULL,
  `codec` varchar(64) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `textMeta`
-- 

CREATE TABLE `textMeta` (
  `id` bigint(20) NOT NULL,
  `title` varchar(128) collate utf8_unicode_ci NOT NULL,
  `caption` text collate utf8_unicode_ci NOT NULL,
  `snippet` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `users`
-- 

CREATE TABLE `users` (
  `userId` int(11) NOT NULL,
  `name` varchar(64) collate utf8_unicode_ci NOT NULL,
  `password` varchar(40) collate utf8_unicode_ci NOT NULL,
  `rank` tinyint(4) NOT NULL,
  PRIMARY KEY  (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `videoMeta`
-- 

CREATE TABLE `videoMeta` (
  `id` bigint(20) NOT NULL,
  `title` varchar(128) collate utf8_unicode_ci NOT NULL,
  `videoCodec` varchar(64) collate utf8_unicode_ci NOT NULL,
  `audioCodec` varchar(64) collate utf8_unicode_ci NOT NULL,
  `videoBitrate` float NOT NULL,
  `audioBitrate` float NOT NULL,
  `hResolution` int(11) NOT NULL,
  `vResolution` int(11) NOT NULL,
  `comments` text collate utf8_unicode_ci NOT NULL,
  `externalURL` varchar(512) collate utf8_unicode_ci NOT NULL,
  `thumbmail` blob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;