# Sequel Pro dump
# Version 663
# http://code.google.com/p/sequel-pro
#
# Host: localhost (MySQL 5.1.33)
# Database: character_sorter
# Generation Time: 2009-07-27 17:08:26 -0700
# ************************************************************

/*!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 */;
/*!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 */;


# Dump of table admin_content
# ------------------------------------------------------------

DROP TABLE IF EXISTS `admin_content`;

CREATE TABLE `admin_content` (
  `content_id` int(11) NOT NULL AUTO_INCREMENT,
  `page_id` int(11) DEFAULT NULL,
  `var_ids` text,
  `var_content` text,
  PRIMARY KEY (`content_id`),
  KEY `page_id_key` (`page_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;



# Dump of table admin_pages
# ------------------------------------------------------------

DROP TABLE IF EXISTS `admin_pages`;

CREATE TABLE `admin_pages` (
  `pages_id` int(11) NOT NULL AUTO_INCREMENT,
  `access_level` tinyint(2) DEFAULT NULL,
  `editable_page` enum('y','n') DEFAULT 'y',
  `file_path` text,
  `page_name` text,
  `page_link_name` text,
  `main_menu` enum('y','n') DEFAULT NULL,
  `template_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`pages_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;



# Dump of table admin_templates
# ------------------------------------------------------------

DROP TABLE IF EXISTS `admin_templates`;

CREATE TABLE `admin_templates` (
  `template_id` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(255) DEFAULT NULL,
  `template_path` varchar(255) DEFAULT NULL,
  `master_template_file` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;



# Dump of table article_categories
# ------------------------------------------------------------

DROP TABLE IF EXISTS `article_categories`;

CREATE TABLE `article_categories` (
  `article_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `article_category_name` varchar(255) DEFAULT NULL,
  `article_category_description` varchar(3000) DEFAULT NULL,
  PRIMARY KEY (`article_category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table articles
# ------------------------------------------------------------

DROP TABLE IF EXISTS `articles`;

CREATE TABLE `articles` (
  `article_id` int(11) NOT NULL AUTO_INCREMENT,
  `article_title` varchar(255) DEFAULT NULL,
  `article_description` varchar(1000) DEFAULT NULL,
  `article_content` text,
  `article_category` int(11) DEFAULT NULL,
  `article_keywords` varchar(255) DEFAULT NULL,
  `date_written` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `owner_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`article_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;



# Dump of table content
# ------------------------------------------------------------

DROP TABLE IF EXISTS `content`;

CREATE TABLE `content` (
  `content_id` int(11) NOT NULL AUTO_INCREMENT,
  `page_id` int(11) DEFAULT NULL,
  `var_ids` text,
  `var_content` text,
  PRIMARY KEY (`content_id`),
  KEY `page_id_key` (`page_id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

LOCK TABLES `content` WRITE;
/*!40000 ALTER TABLE `content` DISABLE KEYS */;
INSERT INTO `content` (`content_id`,`page_id`,`var_ids`,`var_content`)
VALUES
	(21,59,'17!@#$%^&*()18!@#$%^&*()19','Test!@#$%^&*()Test!@#$%^&*()Test');

/*!40000 ALTER TABLE `content` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table content_update_scheduler
# ------------------------------------------------------------

DROP TABLE IF EXISTS `content_update_scheduler`;

CREATE TABLE `content_update_scheduler` (
  `content_update_scheduler_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `page_id` int(11) DEFAULT NULL,
  `variable_id` int(11) DEFAULT NULL,
  `new_value` text,
  `when_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`content_update_scheduler_id`),
  KEY `user_id_key` (`user_id`),
  KEY `page_id_key` (`page_id`),
  KEY `variable_id_key` (`variable_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table hit_counter
# ------------------------------------------------------------

DROP TABLE IF EXISTS `hit_counter`;

CREATE TABLE `hit_counter` (
  `hit_id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `related_id` int(11) DEFAULT NULL,
  `type` enum('page','resource') DEFAULT NULL,
  `ip` varchar(15) DEFAULT NULL,
  `referrer` varchar(500) DEFAULT NULL,
  `info_dump` text,
  PRIMARY KEY (`hit_id`),
  KEY `related_id_key` (`related_id`),
  KEY `type_key` (`type`),
  KEY `ip_key` (`ip`),
  KEY `referrer_key` (`referrer`),
  KEY `timestamp_key` (`timestamp`)
) ENGINE=MyISAM AUTO_INCREMENT=1397 DEFAULT CHARSET=latin1;



# Dump of table hit_counter_archive
# ------------------------------------------------------------

DROP TABLE IF EXISTS `hit_counter_archive`;

CREATE TABLE `hit_counter_archive` (
  `hit_id_archive` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `related_id` int(11) DEFAULT NULL,
  `type` enum('page','resource') DEFAULT NULL,
  `ip` varchar(15) DEFAULT NULL,
  `referrer` varchar(500) DEFAULT NULL,
  `info_dump` text,
  PRIMARY KEY (`hit_id_archive`),
  KEY `related_id_key` (`related_id`),
  KEY `type_key` (`type`),
  KEY `ip_key` (`ip`),
  KEY `referrer_key` (`referrer`),
  KEY `timestamp_key` (`timestamp`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;



# Dump of table nomenclature
# ------------------------------------------------------------

DROP TABLE IF EXISTS `nomenclature`;

CREATE TABLE `nomenclature` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(255) DEFAULT NULL,
  `keys` varchar(1000) DEFAULT NULL,
  `values` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `label` (`label`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;



# Dump of table page_audit
# ------------------------------------------------------------

DROP TABLE IF EXISTS `page_audit`;

CREATE TABLE `page_audit` (
  `page_audit_id` int(11) NOT NULL AUTO_INCREMENT,
  `time_changed` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `changed_by` int(11) DEFAULT NULL,
  `page_id` int(11) DEFAULT NULL,
  `variables` text,
  `variables_old_content` text,
  `variables_new_content` text,
  `action` enum('new','edit','delete') DEFAULT 'edit',
  `variables_old` text,
  PRIMARY KEY (`page_audit_id`),
  KEY `changed_by_key` (`changed_by`),
  KEY `page_id_key` (`page_id`),
  KEY `time_changed_key` (`time_changed`)
) ENGINE=MyISAM AUTO_INCREMENT=94 DEFAULT CHARSET=latin1;



# Dump of table page_audit_archive
# ------------------------------------------------------------

DROP TABLE IF EXISTS `page_audit_archive`;

CREATE TABLE `page_audit_archive` (
  `page_audit_id_archive` int(11) NOT NULL AUTO_INCREMENT,
  `time_changed` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `changed_by` int(11) DEFAULT NULL,
  `page_id` int(11) DEFAULT NULL,
  `variables` text,
  `variables_old_content` text,
  `variables_new_content` text,
  `variable_added` enum('y','n') DEFAULT 'n',
  `variable_removed` enum('y','n') DEFAULT 'n',
  PRIMARY KEY (`page_audit_id_archive`),
  KEY `changed_by_key` (`changed_by`),
  KEY `page_id_key` (`page_id`),
  KEY `time_changed_key` (`time_changed`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table pages
# ------------------------------------------------------------

DROP TABLE IF EXISTS `pages`;

CREATE TABLE `pages` (
  `pages_id` int(11) NOT NULL AUTO_INCREMENT,
  `access_level` tinyint(2) DEFAULT NULL,
  `total_hits` int(11) DEFAULT NULL,
  `unique_hits` int(11) DEFAULT NULL,
  `editable_page` enum('y','n') DEFAULT 'y',
  `file_path` text,
  `page_name` text,
  `page_link_name` text,
  `searchable_content` text,
  `last_updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `template_id` int(11) DEFAULT NULL,
  `parent` int(11) DEFAULT '0',
  `mainorder` int(11) DEFAULT NULL,
  `display_page` enum('y','n') DEFAULT 'n',
  `show_on_main_nav` enum('y','n') DEFAULT 'n',
  PRIMARY KEY (`pages_id`),
  FULLTEXT KEY `search_info` (`searchable_content`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;

LOCK TABLES `pages` WRITE;
/*!40000 ALTER TABLE `pages` DISABLE KEYS */;
INSERT INTO `pages` (`pages_id`,`access_level`,`total_hits`,`unique_hits`,`editable_page`,`file_path`,`page_name`,`page_link_name`,`searchable_content`,`last_updated`,`template_id`,`parent`,`mainorder`,`display_page`,`show_on_main_nav`)
VALUES
	(59,0,NULL,NULL,'y','index.php','Home Page','Home',NULL,'0000-00-00 00:00:00',NULL,0,NULL,'n','n');

/*!40000 ALTER TABLE `pages` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table resources
# ------------------------------------------------------------

DROP TABLE IF EXISTS `resources`;

CREATE TABLE `resources` (
  `resource_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `filetype` varchar(75) DEFAULT NULL,
  `category` int(11) DEFAULT NULL,
  `public_visible` enum('y','n') DEFAULT 'n',
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`resource_id`),
  KEY `name_key` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;



# Dump of table resources_categories
# ------------------------------------------------------------

DROP TABLE IF EXISTS `resources_categories`;

CREATE TABLE `resources_categories` (
  `resource_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent` int(11) DEFAULT '0',
  `category_name` varchar(50) DEFAULT NULL,
  `system_category` enum('y','n') DEFAULT 'y',
  `public_visible` enum('y','n') DEFAULT 'n',
  PRIMARY KEY (`resource_category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;



# Dump of table sessions
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sessions`;

CREATE TABLE `sessions` (
  `ses_id` varchar(32) NOT NULL DEFAULT '',
  `ses_time` int(11) DEFAULT NULL,
  `ses_start` int(11) DEFAULT NULL,
  `ses_value` text,
  PRIMARY KEY (`ses_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` (`ses_id`,`ses_time`,`ses_start`,`ses_value`)
VALUES
	('aecf969b5b7501d049a18eff49492ddf',1247100223,1247099573,'');

/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table templates
# ------------------------------------------------------------

DROP TABLE IF EXISTS `templates`;

CREATE TABLE `templates` (
  `template_id` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(100) DEFAULT NULL,
  `template_root` varchar(100) DEFAULT NULL,
  `master_template_file` varchar(50) DEFAULT NULL,
  `master_admin_template_file` varchar(50) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_updated_by` int(11) DEFAULT NULL,
  `admin_template_subdir` varchar(100) DEFAULT 'admin',
  PRIMARY KEY (`template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

LOCK TABLES `templates` WRITE;
/*!40000 ALTER TABLE `templates` DISABLE KEYS */;
INSERT INTO `templates` (`template_id`,`template_name`,`template_root`,`master_template_file`,`master_admin_template_file`,`last_updated`,`last_updated_by`,`admin_template_subdir`)
VALUES
	(4,'Default','default','index.tpl',NULL,'0000-00-00 00:00:00',NULL,'admin');

/*!40000 ALTER TABLE `templates` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table users
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(25) DEFAULT NULL,
  `pw` varchar(32) DEFAULT NULL,
  `real_name` varchar(32) DEFAULT NULL,
  `extra_info` varchar(100) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `tmp_mail` varchar(50) DEFAULT NULL,
  `access_level` tinyint(4) DEFAULT NULL,
  `active` enum('y','n','b') DEFAULT 'n',
  `unique_permissions` enum('y','n') DEFAULT 'n',
  `primary_group` int(11) DEFAULT '1',
  `admin_template` int(11) DEFAULT NULL,
  `vendor` enum('y','n') DEFAULT 'n',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user` (`login`),
  UNIQUE KEY `mail` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;



# Dump of table users_groups
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users_groups`;

CREATE TABLE `users_groups` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_members` text,
  `group_name` text,
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;



# Dump of table users_permissions
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users_permissions`;

CREATE TABLE `users_permissions` (
  `permissions_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_group` enum('user','group') DEFAULT NULL,
  `admin_pages` enum('y','n') DEFAULT 'n',
  `admin_add_pages` enum('y','n') DEFAULT 'n',
  `admin_templates` enum('y','n') DEFAULT 'n',
  `admin_add_templates` enum('y','n') DEFAULT 'n',
  `admin_users` enum('y','n') DEFAULT 'n',
  `admin_add_users` enum('y','n') DEFAULT 'n',
  `related_id` int(11) DEFAULT NULL,
  `admin_variables` enum('y','n') DEFAULT 'n',
  `admin_cron` enum('y','n') DEFAULT 'n',
  `admin_sitestats` enum('y','n') DEFAULT 'n',
  `admin_delete_pages` enum('y','n') DEFAULT 'n',
  `admin_delete_templates` enum('y','n') DEFAULT 'n',
  `admin_delete_users` enum('y','n') DEFAULT 'n',
  `admin_delete_variables` enum('y','n') DEFAULT 'n',
  `admin_add_variables` enum('y','n') DEFAULT 'n',
  PRIMARY KEY (`permissions_id`),
  KEY `related_id_index` (`related_id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;



# Dump of table variables
# ------------------------------------------------------------

DROP TABLE IF EXISTS `variables`;

CREATE TABLE `variables` (
  `variable_id` int(11) NOT NULL AUTO_INCREMENT,
  `variable_name` varchar(50) DEFAULT NULL,
  `variable_class` enum('global','private','page-specific') DEFAULT 'private',
  `type_id` int(11) DEFAULT NULL,
  `admin_edit` enum('y','n') DEFAULT 'n',
  `searchable` enum('y','n') DEFAULT 'y',
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `related_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`variable_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

LOCK TABLES `variables` WRITE;
/*!40000 ALTER TABLE `variables` DISABLE KEYS */;
INSERT INTO `variables` (`variable_id`,`variable_name`,`variable_class`,`type_id`,`admin_edit`,`searchable`,`date_added`,`related_id`)
VALUES
	(17,'Body','global',15,'y','y','2009-07-08 17:16:48',NULL),
	(18,'Navigation','global',19,'y','y','2009-07-08 17:17:03',NULL),
	(19,'Header','global',15,'y','n','2009-07-08 17:17:16',NULL);

/*!40000 ALTER TABLE `variables` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table variables_types
# ------------------------------------------------------------

DROP TABLE IF EXISTS `variables_types`;

CREATE TABLE `variables_types` (
  `variable_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `core_include` enum('y','n') DEFAULT 'n',
  `variable_type_name` varchar(50) DEFAULT NULL,
  `variable_type_path` varchar(100) DEFAULT NULL,
  `variable_type_method` enum('raw','serialized') DEFAULT 'raw',
  PRIMARY KEY (`variable_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

LOCK TABLES `variables_types` WRITE;
/*!40000 ALTER TABLE `variables_types` DISABLE KEYS */;
INSERT INTO `variables_types` (`variable_type_id`,`core_include`,`variable_type_name`,`variable_type_path`,`variable_type_method`)
VALUES
	(15,'y','HTML','html.php','raw'),
	(16,'y','update_content','update_content.php','serialized'),
	(17,'y','Image','image.php','serialized'),
	(18,'y','admin_pages','admin_pages.php','serialized'),
	(19,'y','Navigation','navigation.php','raw'),
	(20,'y','Button Navigation','button_navigation','serialized');

/*!40000 ALTER TABLE `variables_types` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table videos
# ------------------------------------------------------------

DROP TABLE IF EXISTS `videos`;

CREATE TABLE `videos` (
  `video_id` int(11) NOT NULL AUTO_INCREMENT,
  `video_description` varchar(1000) DEFAULT NULL,
  `owner_id` int(11) DEFAULT NULL,
  `tagged_puppy` int(11) DEFAULT NULL,
  `video_keywords` varchar(1000) DEFAULT NULL,
  `video_title` varchar(255) DEFAULT NULL,
  `current_rating` decimal(10,0) DEFAULT NULL,
  `times_rated` int(11) DEFAULT NULL,
  `times_viewed` int(11) DEFAULT '0',
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `video_thumb_path` varchar(255) DEFAULT 'video_thumb.jpg',
  `duration` varchar(10) DEFAULT NULL,
  `file_name` varchar(255) NOT NULL,
  `rating` decimal(10,0) NOT NULL,
  `who_rated` text NOT NULL,
  PRIMARY KEY (`video_id`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;






/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!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 */;