-- MySQL dump 10.11
--
-- Host: localhost    Database: mtvskate
-- ------------------------------------------------------
-- Server version	5.0.38-Ubuntu_0ubuntu1-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 `auth_group`
--

DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `auth_group_permissions`
--

DROP TABLE IF EXISTS `auth_group_permissions`;
CREATE TABLE `auth_group_permissions` (
  `id` int(11) NOT NULL auto_increment,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `group_id` (`group_id`,`permission_id`),
  KEY `permission_id_refs_id_4de83ca7792de1` (`permission_id`),
  CONSTRAINT `group_id_refs_id_2ccea4c93cea63fe` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `permission_id_refs_id_4de83ca7792de1` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `auth_message`
--

DROP TABLE IF EXISTS `auth_message`;
CREATE TABLE `auth_message` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `message` longtext NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `auth_message_user_id` (`user_id`),
  CONSTRAINT `user_id_refs_id_7837edc69af0b65a` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `auth_permission`
--

DROP TABLE IF EXISTS `auth_permission`;
CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `content_type_id` (`content_type_id`,`codename`),
  KEY `auth_permission_content_type_id` (`content_type_id`),
  CONSTRAINT `content_type_id_refs_id_6bc81a32728de91f` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `auth_user`
--

DROP TABLE IF EXISTS `auth_user`;
CREATE TABLE `auth_user` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(30) NOT NULL,
  `first_name` varchar(30) NOT NULL,
  `last_name` varchar(30) NOT NULL,
  `email` varchar(75) NOT NULL,
  `password` varchar(128) NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `last_login` datetime NOT NULL,
  `date_joined` datetime NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `auth_user_groups`
--

DROP TABLE IF EXISTS `auth_user_groups`;
CREATE TABLE `auth_user_groups` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user_id` (`user_id`,`group_id`),
  KEY `group_id_refs_id_321a8efef0ee9890` (`group_id`),
  CONSTRAINT `group_id_refs_id_321a8efef0ee9890` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `user_id_refs_id_1993cb70831107f1` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `auth_user_user_permissions`
--

DROP TABLE IF EXISTS `auth_user_user_permissions`;
CREATE TABLE `auth_user_user_permissions` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user_id` (`user_id`,`permission_id`),
  KEY `permission_id_refs_id_6d7fb3c2067e79cb` (`permission_id`),
  CONSTRAINT `permission_id_refs_id_6d7fb3c2067e79cb` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `user_id_refs_id_166738bf2045483` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `django_admin_log`
--

DROP TABLE IF EXISTS `django_admin_log`;
CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL auto_increment,
  `action_time` datetime NOT NULL,
  `user_id` int(11) NOT NULL,
  `content_type_id` int(11) default NULL,
  `object_id` longtext,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) unsigned NOT NULL,
  `change_message` longtext NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `django_admin_log_user_id` (`user_id`),
  KEY `django_admin_log_content_type_id` (`content_type_id`),
  CONSTRAINT `content_type_id_refs_id_5c269194288599e6` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `django_content_type`
--

DROP TABLE IF EXISTS `django_content_type`;
CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `app_label` (`app_label`,`model`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `django_session`
--

DROP TABLE IF EXISTS `django_session`;
CREATE TABLE `django_session` (
  `session_key` varchar(40) NOT NULL,
  `session_data` longtext NOT NULL,
  `expire_date` datetime NOT NULL,
  PRIMARY KEY  (`session_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `django_site`
--

DROP TABLE IF EXISTS `django_site`;
CREATE TABLE `django_site` (
  `id` int(11) NOT NULL auto_increment,
  `domain` varchar(100) NOT NULL,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `djangoratings_score`
--

DROP TABLE IF EXISTS `djangoratings_score`;
CREATE TABLE `djangoratings_score` (
  `id` int(11) NOT NULL auto_increment,
  `content_type_id` int(11) NOT NULL,
  `object_id` int(10) unsigned NOT NULL,
  `score` int(11) NOT NULL,
  `votes` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `content_type_id` (`content_type_id`,`object_id`),
  KEY `djangoratings_score_content_type_id` (`content_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `djangoratings_vote`
--

DROP TABLE IF EXISTS `djangoratings_vote`;
CREATE TABLE `djangoratings_vote` (
  `id` int(11) NOT NULL auto_increment,
  `content_type_id` int(11) NOT NULL,
  `object_id` int(10) unsigned NOT NULL,
  `score` int(11) NOT NULL,
  `user_id` int(11) default NULL,
  `ip_address` char(15) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `content_type_id` (`content_type_id`,`object_id`,`user_id`,`ip_address`),
  KEY `djangoratings_vote_content_type_id` (`content_type_id`),
  KEY `djangoratings_vote_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `mtvskate_badword`
--

DROP TABLE IF EXISTS `mtvskate_badword`;
CREATE TABLE `mtvskate_badword` (
  `id` int(11) NOT NULL auto_increment,
  `word` varchar(128) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Table structure for table `mtvskate_event`
--

DROP TABLE IF EXISTS `mtvskate_event`;
CREATE TABLE `mtvskate_event` (
  `id` int(11) NOT NULL auto_increment,
  `type` smallint(6) NOT NULL,
  `object_id` int(11) NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `created_on` datetime NOT NULL,
  `ip_address` char(15) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `mtvskate_event_content_type_id` (`content_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `mtvskate_feedback`
--

DROP TABLE IF EXISTS `mtvskate_feedback`;
CREATE TABLE `mtvskate_feedback` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `message` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Table structure for table `mtvskate_shop`
--

DROP TABLE IF EXISTS `mtvskate_shop`;
CREATE TABLE `mtvskate_shop` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `short_name` varchar(32) NOT NULL,
  `views` int(11) default NULL,
  `description` longtext NOT NULL,
  `editorial_comment` varchar(255) NOT NULL,
  `priority` int(11) NOT NULL,
  `created_on` datetime NOT NULL,
  `visible` tinyint(1) NOT NULL,
  `ratings_enabled` tinyint(1) NOT NULL,
  `comments_enabled` tinyint(1) NOT NULL,
  `address` varchar(128) NOT NULL,
  `address2` varchar(128) NOT NULL,
  `city` varchar(128) NOT NULL,
  `state` varchar(2) NOT NULL,
  `zip` varchar(10) NOT NULL,
  `latitudeE6` int(11) NOT NULL,
  `longitudeE6` int(11) NOT NULL,
  `thumbnail` varchar(100) NOT NULL,
  `rating_votes` int(10) unsigned NOT NULL,
  `rating_score` int(11) NOT NULL,
  `tmobile` tinyint(1) default NULL,
  `comment_count` int(11) default NULL,
  `latitude` double NOT NULL,
  `longitude` double NOT NULL,
  `external_url` varchar(200) default NULL,
  `telephone` varchar(32) default NULL,
  `owner_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `fulltext_spot` (`name`,`description`,`editorial_comment`,`city`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Table structure for table `mtvskate_shop_tags`
--

DROP TABLE IF EXISTS `mtvskate_shop_tags`;
CREATE TABLE `mtvskate_shop_tags` (
  `id` int(11) NOT NULL auto_increment,
  `shop_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `shop_id` (`shop_id`,`tag_id`),
  KEY `tag_id_refs_id_6eeb936522d0725d` (`tag_id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;

--
-- Table structure for table `mtvskate_spot`
--

DROP TABLE IF EXISTS `mtvskate_spot`;
CREATE TABLE `mtvskate_spot` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `short_name` varchar(32) NOT NULL,
  `views` int(11) default NULL,
  `thumbnail` varchar(100) NOT NULL,
  `description` varchar(255) NOT NULL,
  `editorial_comment` varchar(255) NOT NULL,
  `priority` int(11) NOT NULL,
  `created_on` datetime NOT NULL,
  `visible` tinyint(1) NOT NULL,
  `ratings_enabled` tinyint(1) NOT NULL,
  `comments_enabled` tinyint(1) NOT NULL,
  `address` varchar(128) NOT NULL,
  `address2` varchar(128) NOT NULL,
  `city` varchar(128) NOT NULL,
  `state` varchar(2) NOT NULL,
  `zip` varchar(10) NOT NULL,
  `latitudeE6` int(11) NOT NULL,
  `longitudeE6` int(11) NOT NULL,
  `reporter_id` int(11) NOT NULL,
  `rating_votes` int(10) unsigned NOT NULL,
  `rating_score` int(11) NOT NULL,
  `tmobile` tinyint(1) default NULL,
  `comment_count` int(11) default NULL,
  `latitude` double NOT NULL,
  `longitude` double NOT NULL,
  `external_url` varchar(200) default NULL,
  PRIMARY KEY  (`id`),
  KEY `mtvskate_spot_reporter_id` (`reporter_id`),
  FULLTEXT KEY `fulltext_spot` (`name`,`description`,`editorial_comment`,`city`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Table structure for table `mtvskate_spot_tags`
--

DROP TABLE IF EXISTS `mtvskate_spot_tags`;
CREATE TABLE `mtvskate_spot_tags` (
  `id` int(11) NOT NULL auto_increment,
  `spot_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `spot_id` (`spot_id`,`tag_id`),
  KEY `tag_id_refs_id_580c06234930b6c1` (`tag_id`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;

--
-- Table structure for table `mtvskate_suggestion`
--

DROP TABLE IF EXISTS `mtvskate_suggestion`;
CREATE TABLE `mtvskate_suggestion` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(4) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Table structure for table `mtvskate_tag`
--

DROP TABLE IF EXISTS `mtvskate_tag`;
CREATE TABLE `mtvskate_tag` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Table structure for table `mtvskate_userprofile`
--

DROP TABLE IF EXISTS `mtvskate_userprofile`;
CREATE TABLE `mtvskate_userprofile` (
  `id` int(11) NOT NULL auto_increment,
  `avatar` varchar(255) default NULL,
  `gender` varchar(1) default NULL,
  `city` varchar(128) NOT NULL,
  `state` varchar(2) NOT NULL,
  `zip` varchar(10) NOT NULL,
  `birthday` date default NULL,
  `slogan` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `hometown` varchar(127) default NULL,
  `deck` varchar(255) default NULL,
  `wheels` varchar(255) default NULL,
  `trucks` varchar(255) default NULL,
  `favorite_spot_1` varchar(255) default NULL,
  `favorite_spot_2` varchar(255) default NULL,
  `favorite_spot_3` varchar(255) default NULL,
  `site_1` varchar(255) default NULL,
  `site_2` varchar(255) default NULL,
  `site_3` varchar(255) default NULL,
  `picture_1` varchar(100) default NULL,
  `picture_2` varchar(100) default NULL,
  `picture_3` varchar(100) default NULL,
  `picture_4` varchar(100) default NULL,
  `picture_5` varchar(100) default NULL,
  `thumbnail` varchar(255) default NULL,
  `picture_1_thumb` varchar(255) default NULL,
  `picture_2_thumb` varchar(255) default NULL,
  `picture_3_thumb` varchar(255) default NULL,
  `picture_4_thumb` varchar(255) default NULL,
  `picture_5_thumb` varchar(255) default NULL,
  `username` varchar(30) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user_id` (`user_id`),
  UNIQUE KEY `mtvskate_userprofile_user_id` (`user_id`),
  FULLTEXT KEY `fulltext_userprofile` (`username`,`slogan`,`hometown`,`deck`,`wheels`,`trucks`)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=latin1;

--
-- Table structure for table `mtvskate_video`
--

DROP TABLE IF EXISTS `mtvskate_video`;
CREATE TABLE `mtvskate_video` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `reality_digital_id` varchar(128) NOT NULL,
  `visible` tinyint(1) default NULL,
  `created_on` datetime NOT NULL,
  `views` int(11) default NULL,
  `thumbnail` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `tmobile` tinyint(1) NOT NULL,
  `spot_id` int(11) default NULL,
  `owner_id` int(11) NOT NULL,
  `rating_votes` int(10) unsigned NOT NULL,
  `rating_score` int(11) NOT NULL,
  `comment_count` int(11) default NULL,
  `comments_enabled` tinyint(1) default NULL,
  `editorial_comment` text,
  `short_name` varchar(32) default NULL,
  `mobile_code` varchar(200) default NULL,
  `is_claimed` tinyint(1) default NULL,
  `ratings_enabled` tinyint(1) default NULL,
  `priority` int(11) default NULL,
  `flv` varchar(255) default NULL,
  `city` varchar(128) default NULL,
  `state` varchar(2) default NULL,
  PRIMARY KEY  (`id`),
  KEY `mtvskate_video_spot_id` (`spot_id`),
  KEY `mtvskate_video_owner_id` (`owner_id`),
  FULLTEXT KEY `fulltext_video` (`name`,`description`,`editorial_comment`,`city`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Table structure for table `mtvskate_video_tags`
--

DROP TABLE IF EXISTS `mtvskate_video_tags`;
CREATE TABLE `mtvskate_video_tags` (
  `id` int(11) NOT NULL auto_increment,
  `video_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `video_id` (`video_id`,`tag_id`),
  KEY `tag_id_refs_id_6a61da4458698491` (`tag_id`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;

--
-- Table structure for table `registration_registrationprofile`
--

DROP TABLE IF EXISTS `registration_registrationprofile`;
CREATE TABLE `registration_registrationprofile` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `activation_key` varchar(40) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user_id` (`user_id`),
  UNIQUE KEY `registration_registrationprofile_user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;

--
-- Table structure for table `threadedcomments_freethreadedcomment`
--

DROP TABLE IF EXISTS `threadedcomments_freethreadedcomment`;
CREATE TABLE `threadedcomments_freethreadedcomment` (
  `id` int(11) NOT NULL auto_increment,
  `content_type_id` int(11) NOT NULL,
  `object_id` int(10) unsigned NOT NULL,
  `parent_id` int(11) default NULL,
  `name` varchar(128) NOT NULL,
  `website` varchar(200) NOT NULL,
  `email` varchar(75) NOT NULL,
  `date_submitted` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `date_approved` datetime default NULL,
  `comment` longtext NOT NULL,
  `markup` int(11) default NULL,
  `is_public` tinyint(1) NOT NULL,
  `is_approved` tinyint(1) NOT NULL,
  `ip_address` char(15) default NULL,
  PRIMARY KEY  (`id`),
  KEY `threadedcomments_freethreadedcomment_content_type_id` (`content_type_id`),
  KEY `threadedcomments_freethreadedcomment_parent_id` (`parent_id`),
  CONSTRAINT `parent_id_refs_id_6663c0f98c7f0b95` FOREIGN KEY (`parent_id`) REFERENCES `threadedcomments_freethreadedcomment` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `threadedcomments_testmodel`
--

DROP TABLE IF EXISTS `threadedcomments_testmodel`;
CREATE TABLE `threadedcomments_testmodel` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(5) NOT NULL,
  `is_public` tinyint(1) NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `threadedcomments_threadedcomment`
--

DROP TABLE IF EXISTS `threadedcomments_threadedcomment`;
CREATE TABLE `threadedcomments_threadedcomment` (
  `id` int(11) NOT NULL auto_increment,
  `content_type_id` int(11) NOT NULL,
  `object_id` int(10) unsigned NOT NULL,
  `parent_id` int(11) default NULL,
  `user_id` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `date_approved` datetime default NULL,
  `comment` longtext NOT NULL,
  `markup` int(11) default NULL,
  `is_public` tinyint(1) NOT NULL,
  `is_approved` tinyint(1) NOT NULL,
  `ip_address` char(15) default NULL,
  PRIMARY KEY  (`id`),
  KEY `threadedcomments_threadedcomment_content_type_id` (`content_type_id`),
  KEY `threadedcomments_threadedcomment_parent_id` (`parent_id`),
  KEY `threadedcomments_threadedcomment_user_id` (`user_id`),
  CONSTRAINT `parent_id_refs_id_791b9bc27ef2a789` FOREIGN KEY (`parent_id`) REFERENCES `threadedcomments_threadedcomment` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 */;

-- Dump completed on 2008-07-17 19:48:40