-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 17, 2007 at 11:38 AM
-- Server version: 4.1.15
-- PHP Version: 4.4.4-9
-- 
-- Database: `geniusdex`
-- 

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

-- 
-- Table structure for table `site_comments`
-- 

CREATE TABLE `site_comments` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `page_id` int(10) unsigned NOT NULL default '0',
  `author` varchar(64) NOT NULL default '',
  `email` varchar(128) default NULL,
  `ip` varchar(16) NOT NULL default '',
  `posted` datetime NOT NULL default '0000-00-00 00:00:00',
  `message` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `site_menu`
-- 

CREATE TABLE `site_menu` (
  `item` int(10) unsigned NOT NULL default '0',
  `position` int(10) unsigned NOT NULL default '0',
  `name` varchar(32) NOT NULL default '',
  KEY `position` (`position`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `site_pages`
-- 

CREATE TABLE `site_pages` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cat` int(10) unsigned NOT NULL default '0',
  `online` tinyint(1) NOT NULL default '0',
  `indexed` tinyint(1) NOT NULL default '0',
  `comments` tinyint(1) NOT NULL default '0',
  `changed` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` varchar(128) NOT NULL default '',
  `img` varchar(64) NOT NULL default '',
  `contents` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;