-- phpMyAdmin SQL Dump
-- version 2.11.3-rc1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 27, 2008 at 07:54 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `defiant`
--

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

--
-- Table structure for table `articles`
--

CREATE TABLE IF NOT EXISTS `articles` (
  `id` int(11) NOT NULL auto_increment,
  `posted` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `active` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` varchar(255) character set latin1 collate latin1_general_ci NOT NULL,
  `content` longtext character set latin1 collate latin1_general_ci NOT NULL,
  `userid` int(11) NOT NULL,
  `shortcut` varchar(255) NOT NULL,
  `tags` text character set latin1 collate latin1_general_ci,
  `categories` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `shortcut` (`shortcut`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cache`
--

CREATE TABLE IF NOT EXISTS `cache` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `serial` text NOT NULL,
  `updated` varchar(75) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) character set latin1 collate latin1_general_ci NOT NULL,
  `shortcut` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `shortcut` (`shortcut`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cat_relations`
--

CREATE TABLE IF NOT EXISTS `cat_relations` (
  `id` int(255) NOT NULL auto_increment,
  `article` int(255) NOT NULL,
  `category` int(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(11) NOT NULL auto_increment,
  `article_id` int(11) NOT NULL,
  `user_id` int(25) NOT NULL,
  `content` text character set latin1 collate latin1_general_ci NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `status` enum('-1','0','1') character set latin1 collate latin1_general_ci NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

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

CREATE TABLE IF NOT EXISTS `config` (
  `id` mediumint(9) NOT NULL auto_increment,
  `name` varchar(255) character set latin1 collate latin1_general_ci NOT NULL,
  `value` varchar(255) character set latin1 collate latin1_general_ci NOT NULL,
  `type` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sessions`
--

CREATE TABLE IF NOT EXISTS `sessions` (
  `session_id` varchar(255) NOT NULL,
  `user_id` int(255) NOT NULL default '0',
  `ip` varchar(15) NOT NULL,
  `useragent` varchar(255) NOT NULL,
  `start` int(255) NOT NULL,
  `expire` int(255) NOT NULL,
  PRIMARY KEY  (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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

CREATE TABLE IF NOT EXISTS `tags` (
  `id` int(11) NOT NULL auto_increment,
  `tag` varchar(255) character set latin1 collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(25) NOT NULL auto_increment,
  `username` varchar(255) character set latin1 collate latin1_general_ci NOT NULL,
  `password` varchar(40) character set latin1 collate latin1_general_ci NOT NULL,
  `salt` varchar(7) NOT NULL,
  `email` varchar(255) character set latin1 collate latin1_general_ci NOT NULL,
  `level` tinyint(2) NOT NULL default '1',
  `displayname` varchar(50) default NULL,
  `registered` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;