-- MySQL dump 10.10
--
-- Host: localhost    Database: opensite
-- ------------------------------------------------------
-- Server version	5.0.24a-Debian_9ubuntu0.1-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `access_log`
--

DROP TABLE IF EXISTS `access_log`;
CREATE TABLE `access_log` (
  `access_log_id` int(11) NOT NULL auto_increment,
  `editor_id` int(11) default NULL,
  `path` varchar(255) default NULL,
  `cookie` varchar(255) default NULL,
  `referer` varchar(255) default NULL,
  `user_agent` varchar(255) default NULL,
  `ip_address` varchar(255) default NULL,
  `params` text,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  KEY `access_log_id` (`access_log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `access_log`
--


/*!40000 ALTER TABLE `access_log` DISABLE KEYS */;
LOCK TABLES `access_log` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `access_log` ENABLE KEYS */;

--
-- Table structure for table `applications`
--

DROP TABLE IF EXISTS `applications`;
CREATE TABLE `applications` (
  `application_id` int(11) NOT NULL auto_increment,
  `editor_id` int(11) default NULL,
  `type` enum('newapp','request') default NULL,
  `category_id` int(11) default NULL,
  `initial_password` varchar(255) default NULL,
  `editor_name` varchar(255) default NULL,
  `full_name` varchar(255) default NULL,
  `email_address` varchar(255) default NULL,
  `validation_code` varchar(255) default NULL,
  `reason` text,
  `time_submitted` datetime default NULL,
  `langauge` int(11) default NULL,
  `verified` int(1) default '0',
  `status` enum('pending','reviewed') default 'pending',
  KEY `application_id` (`application_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `applications`
--


/*!40000 ALTER TABLE `applications` DISABLE KEYS */;
LOCK TABLES `applications` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `applications` ENABLE KEYS */;

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

DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories` (
  `category_id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) NOT NULL,
  `path` varchar(425) collate latin1_bin NOT NULL,
  `discarded` tinyint(1) NOT NULL default '0',
  `priority` enum('highest','medium','bottom') collate latin1_bin default 'bottom',
  `rank` int(2) default '0',
  `moz` int(3) default NULL,
  `published` tinyint(1) NOT NULL default '0',
  `template_id` int(11) default NULL,
  `restricted` tinyint(1) NOT NULL default '0',
  UNIQUE KEY `parent_id` (`parent_id`,`path`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

--
-- Dumping data for table `categories`
--


/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
LOCK TABLES `categories` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;

--
-- Table structure for table `editors`
--

DROP TABLE IF EXISTS `editors`;
CREATE TABLE `editors` (
  `editor_id` int(11) NOT NULL auto_increment,
  `password_id` int(11) default NULL,
  `editor_name` varchar(255) default NULL,
  `full_name` varchar(255) default NULL,
  `email_address` varchar(255) default NULL,
  `home_page` varchar(255) default NULL,
  `validation_code` varchar(255) default NULL,
  `last_login` datetime default NULL,
  `profile` text,
  `language` int(11) default NULL,
  `active` int(1) default NULL,
  `todo_list` text,
  KEY `editor_id` (`editor_id`),
  KEY `editor_name` (`editor_name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `editors`
--


/*!40000 ALTER TABLE `editors` DISABLE KEYS */;
LOCK TABLES `editors` WRITE;
INSERT INTO `editors` VALUES (1,1,'admin','Administrator',NULL,NULL,NULL,'2007-11-04 10:20:46',NULL,1,1,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `editors` ENABLE KEYS */;

--
-- Table structure for table `edits`
--

DROP TABLE IF EXISTS `edits`;
CREATE TABLE `edits` (
  `edit_id` int(11) NOT NULL auto_increment,
  `editor_id` int(11) NOT NULL,
  `item_type` varchar(255) NOT NULL,
  `item_id` varchar(255) NOT NULL,
  `category_id` int(11) NOT NULL,
  `action` varchar(255) NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `ip_address` varchar(255) default NULL,
  `description` text,
  KEY `edit_id` (`edit_id`),
  KEY `editor_id` (`editor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `edits`
--


/*!40000 ALTER TABLE `edits` DISABLE KEYS */;
LOCK TABLES `edits` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `edits` ENABLE KEYS */;

--
-- Table structure for table `email_messages`
--

DROP TABLE IF EXISTS `email_messages`;
CREATE TABLE `email_messages` (
  `message_id` int(11) NOT NULL auto_increment,
  `content` blob NOT NULL,
  KEY `message_id` (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `email_messages`
--


/*!40000 ALTER TABLE `email_messages` DISABLE KEYS */;
LOCK TABLES `email_messages` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `email_messages` ENABLE KEYS */;

--
-- Table structure for table `logs`
--

DROP TABLE IF EXISTS `logs`;
CREATE TABLE `logs` (
  `log_id` int(11) NOT NULL auto_increment,
  `editor_id` int(11) default NULL,
  `category_id` int(11) default NULL,
  `time_stamp` datetime default NULL,
  `type` enum('permission','edit') default NULL,
  `content_before` text,
  `after_content` text,
  `ip_address` varchar(255) default NULL,
  KEY `log_id` (`log_id`),
  KEY `editor_id` (`editor_id`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logs`
--


/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
LOCK TABLES `logs` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `logs` ENABLE KEYS */;

--
-- Table structure for table `meta_logs`
--

DROP TABLE IF EXISTS `meta_logs`;
CREATE TABLE `meta_logs` (
  `log_id` int(11) NOT NULL auto_increment,
  `editor_id` int(11) default NULL,
  `category_id` int(11) default NULL,
  `meta_id` int(11) default NULL,
  `application_id` int(11) default NULL,
  `action` varchar(255) default NULL,
  `description` varchar(1024) default NULL,
  `time_stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  KEY `log_id` (`log_id`),
  KEY `editor_id` (`editor_id`),
  KEY `application_id` (`application_id`),
  KEY `meta_id` (`meta_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `meta_logs`
--


/*!40000 ALTER TABLE `meta_logs` DISABLE KEYS */;
LOCK TABLES `meta_logs` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `meta_logs` ENABLE KEYS */;

--
-- Table structure for table `notes`
--

DROP TABLE IF EXISTS `notes`;
CREATE TABLE `notes` (
  `note_id` int(11) NOT NULL auto_increment,
  `editor_id` int(11) default NULL,
  `application_id` int(11) default NULL,
  `edit_id` int(11) default NULL,
  `meta_id` int(11) default NULL,
  `note` text,
  `title` varchar(255) default NULL,
  `color` varchar(255) default NULL,
  `type` enum('profile','application','edit') default NULL,
  `discarded` tinyint(1) default '0',
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  KEY `note_id` (`note_id`),
  KEY `editor_id` (`editor_id`),
  KEY `application_id` (`application_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `notes`
--


/*!40000 ALTER TABLE `notes` DISABLE KEYS */;
LOCK TABLES `notes` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `notes` ENABLE KEYS */;

--
-- Table structure for table `passwords`
--

DROP TABLE IF EXISTS `passwords`;
CREATE TABLE `passwords` (
  `editor_id` int(11) default NULL,
  `password_id` int(11) NOT NULL auto_increment,
  `password` varchar(255) default NULL,
  `type` enum('text','md5','unix_crypt') default NULL,
  KEY `password_id` (`password_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `passwords`
--


/*!40000 ALTER TABLE `passwords` DISABLE KEYS */;
LOCK TABLES `passwords` WRITE;
INSERT INTO `passwords` VALUES (1,1,'admin','text');
UNLOCK TABLES;
/*!40000 ALTER TABLE `passwords` ENABLE KEYS */;

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions` (
  `editor_id` int(11) default NULL,
  `type` enum('category','super') default NULL,
  `super_type` varchar(255) default NULL,
  `category_id` int(11) default NULL,
  KEY `editor_id` (`editor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `permissions`
--


/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
LOCK TABLES `permissions` WRITE;
INSERT INTO `permissions` VALUES (1,'super','ROOT',NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;

--
-- Table structure for table `section_data`
--

DROP TABLE IF EXISTS `section_data`;
CREATE TABLE `section_data` (
  `section_data_id` int(11) NOT NULL auto_increment,
  `section_id` int(11) NOT NULL,
  `revision` int(11) NOT NULL,
  `created` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `title` varchar(1024) default NULL,
  `content` text,
  `revert_to` int(11) default NULL,
  KEY `section_data_id` (`section_data_id`),
  KEY `section_id` (`section_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `section_data`
--


/*!40000 ALTER TABLE `section_data` DISABLE KEYS */;
LOCK TABLES `section_data` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `section_data` ENABLE KEYS */;

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

DROP TABLE IF EXISTS `sections`;
CREATE TABLE `sections` (
  `section_id` int(11) NOT NULL auto_increment,
  `category_id` int(11) NOT NULL,
  `discarded` tinyint(1) NOT NULL default '0',
  `status` enum('published','unpublished','unreviewed') default NULL,
  `rank` int(5) default NULL,
  `type` enum('default','left-template') default NULL,
  `published` int(11) default NULL,
  KEY `section_id` (`section_id`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


/*!40000 ALTER TABLE `sections` DISABLE KEYS */;
LOCK TABLES `sections` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `sections` ENABLE KEYS */;

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

DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
  `session_id` varchar(255) NOT NULL,
  `editor_id` int(11) default NULL,
  `active` int(1) default NULL,
  `created` datetime default NULL,
  `last_access` datetime default NULL,
  KEY `session_id` (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sessions`
--


/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
LOCK TABLES `sessions` WRITE;
INSERT INTO `sessions` VALUES ('15ff2aeaec5fb026d7684f80d5c97994',1,1,'2007-11-04 10:19:27','2007-11-04 10:20:46');
UNLOCK TABLES;
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;

--
-- Table structure for table `symlinks`
--

DROP TABLE IF EXISTS `symlinks`;
CREATE TABLE `symlinks` (
  `symlink_id` int(11) NOT NULL auto_increment,
  `category_id` int(11) NOT NULL,
  `link_category_id` int(11) NOT NULL,
  `path` varchar(425) NOT NULL,
  `rank` int(2) default '0',
  KEY `symlink_id` (`symlink_id`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `symlinks`
--


/*!40000 ALTER TABLE `symlinks` DISABLE KEYS */;
LOCK TABLES `symlinks` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `symlinks` ENABLE KEYS */;

--
-- Table structure for table `warnings`
--

DROP TABLE IF EXISTS `warnings`;
CREATE TABLE `warnings` (
  `warning_id` int(11) NOT NULL auto_increment,
  `editor_id` int(11) default NULL,
  `meta_id` int(11) default NULL,
  `text` text,
  `accepted` tinyint(1) default NULL,
  `issued_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `accepted_date` timestamp NOT NULL default '0000-00-00 00:00:00',
  KEY `warning_id` (`warning_id`),
  KEY `editor_id` (`editor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `warnings`
--


/*!40000 ALTER TABLE `warnings` DISABLE KEYS */;
LOCK TABLES `warnings` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `warnings` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;