rendered paste body-- 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;