-- phpMyAdmin SQL Dump
-- version 2.8.2-Debian-0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Nov 04, 2006 at 01:35 PM
-- Server version: 5.0.24
-- PHP Version: 4.4.2-1.1
-- 
-- Database: `poff`
-- 

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

-- 
-- Table structure for table `options`
-- 

CREATE TABLE `options` (
  `section` varchar(32) NOT NULL default 'general',
  `opt` varchar(255) NOT NULL default '',
  `val` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`section`,`opt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- 
-- Table structure for table `photos`
-- 

CREATE TABLE `photos` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `ident` varchar(40) NOT NULL default '',
  `path` varchar(255) default NULL,
  `file` varchar(255) default NULL,
  `owner` int(10) unsigned NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `dt_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `dt_file` datetime NOT NULL default '0000-00-00 00:00:00',
  `dt_taken` datetime NOT NULL default '0000-00-00 00:00:00',
  `dt_mod` datetime NOT NULL default '0000-00-00 00:00:00',
  `width` int(10) unsigned NOT NULL default '0',
  `height` int(10) unsigned NOT NULL default '0',
  `lat` float default NULL,
  `lon` float default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `ident` (`ident`,`owner`),
  UNIQUE KEY `path` (`path`,`file`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='stores main image data';

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

-- 
-- Table structure for table `tags`
-- 

CREATE TABLE `tags` (
  `tag` varchar(255) NOT NULL default '',
  `id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`tag`,`id`),
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `users` (
  `uid` int(10) unsigned NOT NULL auto_increment,
  `login` varchar(32) NOT NULL default '',
  `pass` varchar(40) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `magic` varchar(40) NOT NULL default '',
  `isadmin` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`uid`),
  UNIQUE KEY `login` (`login`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='stores the users';

-- 
-- Constraints for dumped tables
-- 

-- 
-- Constraints for table `tags`
-- 
ALTER TABLE `tags`
  ADD CONSTRAINT `tags_ibfk_1` FOREIGN KEY (`id`) REFERENCES `photos` (`id`) ON DELETE CASCADE;

-- 
-- Some initial data
-- 
INSERT INTO `options` (`section`, `opt`, `val`) VALUES ('general', 'identfield', 'Iptc.SpecialInstructions');
INSERT INTO `options` (`section`, `opt`, `val`) VALUES ('general', 'title', 'PaiKiki');
INSERT INTO `options` (`section`, `opt`, `val`) VALUES ('tools', 'convert', '/usr/bin/convert');
INSERT INTO `options` (`section`, `opt`, `val`) VALUES ('tools', 'exiftran', '/usr/bin/exiftran');

INSERT INTO `users` (`uid`, `login`, `pass`, `email`, `magic`, `isadmin`) VALUES (1, 'admin', PASSWORD('admin'), 'admin@example.com', sha1( rand( ) ), 1);