-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Nov 10, 2006 at 03:39 PM
-- Server version: 5.0.22
-- PHP Version: 5.2.0
-- 
-- Database: `images`
-- 

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

-- 
-- Table structure for table `image_folders`
-- 

CREATE TABLE `image_folders` (
  `id` int(3) NOT NULL auto_increment,
  `caption` varchar(255) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- 
-- Dumping data for table `image_folders`
-- 

INSERT INTO `image_folders` (`id`, `caption`) VALUES 
(2, 'People'),
(3, 'Other'),
(4, 'Misc'),
(5, 'Buildings'),
(6, 'Logos'),
(7, 'Animals'),
(8, 'System');

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

-- 
-- Table structure for table `images`
-- 

CREATE TABLE `images` (
  `id` int(5) NOT NULL auto_increment,
  `caption` varchar(255) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `alttext` varchar(255) NOT NULL,
  `folder` int(3) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- 
-- Dumping data for table `images`
-- 

INSERT INTO `images` (`id`, `caption`, `filename`, `alttext`, `folder`) VALUES 
(1, 'Hills', '1.jpg', '', 0),
(2, 'Sunset', '2.jpg', '', 0),
(3, 'Flowers', '3.jpg', '', 0),
(4, 'Something Else', '4.jpg', '', 0),
(8, 'tower.jpg', '1163156864.jpg', '', 5);