-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 01, 2008 at 04:18 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `kahawa`
--

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

--
-- Table structure for table `alerts`
--

CREATE TABLE IF NOT EXISTS `alerts` (
  `id` int(11) NOT NULL auto_increment,
  `message` text NOT NULL,
  `owner` int(11) NOT NULL,
  `displayuntil` date NOT NULL,
  `level` int(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `alerts`
--


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

--
-- Table structure for table `calendar`
--

CREATE TABLE IF NOT EXISTS `calendar` (
  `id` int(32) NOT NULL auto_increment,
  `title` varchar(256) NOT NULL,
  `desc` text NOT NULL,
  `date` datetime NOT NULL,
  `category` varchar(256) NOT NULL,
  `owner` int(11) NOT NULL,
  `location` varchar(256) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `calendar`
--


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

--
-- Table structure for table `config`
--

CREATE TABLE IF NOT EXISTS `config` (
  `id` int(11) NOT NULL auto_increment,
  `option` varchar(255) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `config`
--


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

--
-- Table structure for table `eucu_aaf`
--

CREATE TABLE IF NOT EXISTS `eucu_aaf` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(256) NOT NULL,
  `email` varchar(256) NOT NULL,
  `telephone` varchar(256) NOT NULL,
  `accom` text NOT NULL,
  `course` varchar(256) NOT NULL,
  `age` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `eucu_aaf`
--


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

--
-- Table structure for table `eucu_podcasts`
--

CREATE TABLE IF NOT EXISTS `eucu_podcasts` (
  `id` int(11) NOT NULL auto_increment,
  `path` varchar(256) NOT NULL,
  `filename` varchar(256) NOT NULL,
  `title` varchar(256) NOT NULL,
  `summary` text NOT NULL,
  `datetime` datetime NOT NULL,
  `user` int(11) NOT NULL,
  `counter` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `eucu_podcasts`
--


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

--
-- Table structure for table `eventlog`
--

CREATE TABLE IF NOT EXISTS `eventlog` (
  `id` int(11) NOT NULL auto_increment,
  `category` varchar(255) NOT NULL,
  `details` text NOT NULL,
  `user` int(11) NOT NULL,
  `datetime` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `eventlog`
--


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

--
-- Table structure for table `levels`
--

CREATE TABLE IF NOT EXISTS `levels` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(256) NOT NULL,
  `level` varchar(256) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `levels`
--


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

--
-- Table structure for table `mailinglists`
--

CREATE TABLE IF NOT EXISTS `mailinglists` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `footer` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `mailinglists`
--


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

--
-- Table structure for table `mailinglistusers`
--

CREATE TABLE IF NOT EXISTS `mailinglistusers` (
  `id` int(11) NOT NULL auto_increment,
  `email` varchar(300) NOT NULL,
  `list` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `mailinglistusers`
--


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

--
-- Table structure for table `pages`
--

CREATE TABLE IF NOT EXISTS `pages` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(256) NOT NULL,
  `content` text NOT NULL,
  `section` int(11) NOT NULL,
  `owner` int(11) NOT NULL,
  `status` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `content` (`content`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `pages`
--


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

--
-- Table structure for table `sections`
--

CREATE TABLE IF NOT EXISTS `sections` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(256) NOT NULL,
  `parent` varchar(256) NOT NULL,
  `default_page` varchar(11) NOT NULL,
  `order` varchar(5) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `sections`
--


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

--
-- Table structure for table `specialpages`
--

CREATE TABLE IF NOT EXISTS `specialpages` (
  `id` int(11) NOT NULL auto_increment,
  `page` varchar(256) NOT NULL,
  `option` varchar(256) NOT NULL,
  `value` text NOT NULL,
  `title` varchar(256) NOT NULL,
  `owner` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `specialpages`
--


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

--
-- Table structure for table `spgm_galleries`
--

CREATE TABLE IF NOT EXISTS `spgm_galleries` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `safename` varchar(255) NOT NULL,
  `parent` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spgm_galleries`
--


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

--
-- Table structure for table `spgm_photos`
--

CREATE TABLE IF NOT EXISTS `spgm_photos` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(2048) NOT NULL,
  `owner` int(11) NOT NULL,
  `gallery` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spgm_photos`
--


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

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

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(16) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(64) NOT NULL,
  `level` int(11) NOT NULL default '1',
  `lastlogindate` datetime NOT NULL,
  `lastloginip` varchar(256) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `users`
--