summaryrefslogtreecommitdiffstats
path: root/sql_scripts/cnprog_new_install_2009_02_28.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql_scripts/cnprog_new_install_2009_02_28.sql')
-rw-r--r--sql_scripts/cnprog_new_install_2009_02_28.sql456
1 files changed, 456 insertions, 0 deletions
diff --git a/sql_scripts/cnprog_new_install_2009_02_28.sql b/sql_scripts/cnprog_new_install_2009_02_28.sql
new file mode 100644
index 00000000..80b9fced
--- /dev/null
+++ b/sql_scripts/cnprog_new_install_2009_02_28.sql
@@ -0,0 +1,456 @@
+SET FOREIGN_KEY_CHECKS = 0;
+
+CREATE TABLE `activity` (
+ `id` int(11) NOT NULL auto_increment,
+ `user_id` int(11) NOT NULL,
+ `activity_type` smallint(6) NOT NULL,
+ `active_at` datetime NOT NULL,
+ `content_type_id` int(11) NOT NULL,
+ `object_id` int(10) unsigned NOT NULL,
+ `is_auditted` tinyint(1) default '0',
+ PRIMARY KEY (`id`),
+ KEY `activity_user_id` (`user_id`),
+ KEY `activity_content_type_id` (`content_type_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `answer` (
+ `id` int(11) NOT NULL auto_increment,
+ `question_id` int(11) NOT NULL,
+ `author_id` int(11) NOT NULL,
+ `added_at` datetime NOT NULL,
+ `wiki` tinyint(1) NOT NULL,
+ `wikified_at` datetime default NULL,
+ `accepted` tinyint(1) NOT NULL,
+ `deleted` tinyint(1) NOT NULL,
+ `deleted_by_id` int(11) default NULL,
+ `locked` tinyint(1) NOT NULL,
+ `locked_by_id` int(11) default NULL,
+ `locked_at` datetime default NULL,
+ `score` int(11) NOT NULL,
+ `comment_count` int(10) unsigned NOT NULL,
+ `offensive_flag_count` smallint(6) NOT NULL,
+ `last_edited_at` datetime default NULL,
+ `last_edited_by_id` int(11) default NULL,
+ `html` longtext NOT NULL,
+ `vote_up_count` int(11) NOT NULL,
+ `vote_down_count` int(11) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `answer_question_id` (`question_id`),
+ KEY `answer_author_id` (`author_id`),
+ KEY `answer_deleted_by_id` (`deleted_by_id`),
+ KEY `answer_locked_by_id` (`locked_by_id`),
+ KEY `answer_last_edited_by_id` (`last_edited_by_id`),
+ CONSTRAINT `author_id_refs_id_192b0170` FOREIGN KEY (`author_id`) REFERENCES `auth_user` (`id`),
+ CONSTRAINT `deleted_by_id_refs_id_192b0170` FOREIGN KEY (`deleted_by_id`) REFERENCES `auth_user` (`id`),
+ CONSTRAINT `last_edited_by_id_refs_id_192b0170` FOREIGN KEY (`last_edited_by_id`) REFERENCES `auth_user` (`id`),
+ CONSTRAINT `locked_by_id_refs_id_192b0170` FOREIGN KEY (`locked_by_id`) REFERENCES `auth_user` (`id`),
+ CONSTRAINT `question_id_refs_id_7d6550c9` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `answer_revision` (
+ `id` int(11) NOT NULL auto_increment,
+ `answer_id` int(11) NOT NULL,
+ `revision` int(10) unsigned NOT NULL,
+ `author_id` int(11) NOT NULL,
+ `revised_at` datetime NOT NULL,
+ `summary` varchar(300) collate utf8_unicode_ci NOT NULL,
+ `text` longtext collate utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `answer_revision_answer_id` (`answer_id`),
+ KEY `answer_revision_author_id` (`author_id`)
+) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
+
+
+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=utf8;
+
+
+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_5886d21f` (`permission_id`),
+ CONSTRAINT `group_id_refs_id_3cea63fe` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
+ CONSTRAINT `permission_id_refs_id_5886d21f` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
+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_650f49a6` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
+
+
+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_728de91f` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8;
+
+
+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,
+ `gold` smallint(6) NOT NULL default '0',
+ `silver` smallint(5) unsigned NOT NULL default '0',
+ `bronze` smallint(5) unsigned NOT NULL default '0',
+ `reputation` int(10) unsigned default '1',
+ `gravatar` varchar(128) default NULL,
+ `questions_per_page` smallint(5) unsigned default '10',
+ `last_seen` datetime default NULL,
+ `real_name` varchar(100) default NULL,
+ `website` varchar(200) default NULL,
+ `location` varchar(100) default NULL,
+ `date_of_birth` datetime default NULL,
+ `about` text,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `username` (`username`)
+) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8;
+
+
+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_f116770` (`group_id`),
+ CONSTRAINT `group_id_refs_id_f116770` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
+ CONSTRAINT `user_id_refs_id_7ceef80f` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
+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_67e79cb` (`permission_id`),
+ CONSTRAINT `permission_id_refs_id_67e79cb` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
+ CONSTRAINT `user_id_refs_id_dfbab7d` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `award` (
+ `id` int(11) NOT NULL auto_increment,
+ `user_id` int(11) NOT NULL,
+ `badge_id` int(11) NOT NULL,
+ `awarded_at` datetime NOT NULL,
+ `notified` tinyint(1) NOT NULL,
+ `content_type_id` int(11) default NULL,
+ `object_id` int(10) default NULL,
+ PRIMARY KEY (`id`),
+ KEY `award_user_id` (`user_id`),
+ KEY `award_badge_id` (`badge_id`),
+ CONSTRAINT `badge_id_refs_id_651af0e1` FOREIGN KEY (`badge_id`) REFERENCES `badge` (`id`),
+ CONSTRAINT `user_id_refs_id_2d83e9b6` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `badge` (
+ `id` int(11) NOT NULL auto_increment,
+ `name` varchar(50) NOT NULL,
+ `type` smallint(6) NOT NULL,
+ `slug` varchar(50) NOT NULL,
+ `description` varchar(300) NOT NULL,
+ `multiple` tinyint(1) NOT NULL,
+ `awarded_count` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `name` (`name`,`type`),
+ KEY `badge_slug` (`slug`)
+) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `comment` (
+ `id` int(11) NOT NULL auto_increment,
+ `content_type_id` int(11) NOT NULL,
+ `object_id` int(10) unsigned NOT NULL,
+ `user_id` int(11) NOT NULL,
+ `comment` varchar(300) NOT NULL,
+ `added_at` datetime NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `comment_content_type_id` (`content_type_id`),
+ KEY `comment_user_id` (`user_id`),
+ KEY `content_type_id` (`content_type_id`,`object_id`,`user_id`),
+ CONSTRAINT `content_type_id_refs_id_13a5866c` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
+ CONSTRAINT `user_id_refs_id_6be725e8` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
+
+
+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_288599e6` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
+ CONSTRAINT `user_id_refs_id_c8665aa` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `django_authopenid_association` (
+ `id` int(11) NOT NULL auto_increment,
+ `server_url` longtext NOT NULL,
+ `handle` varchar(255) NOT NULL,
+ `secret` longtext NOT NULL,
+ `issued` int(11) NOT NULL,
+ `lifetime` int(11) NOT NULL,
+ `assoc_type` longtext NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `django_authopenid_nonce` (
+ `id` int(11) NOT NULL auto_increment,
+ `server_url` varchar(255) NOT NULL,
+ `timestamp` int(11) NOT NULL,
+ `salt` varchar(40) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `django_authopenid_userassociation` (
+ `id` int(11) NOT NULL auto_increment,
+ `openid_url` varchar(255) NOT NULL,
+ `user_id` int(11) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `user_id` (`user_id`),
+ CONSTRAINT `user_id_refs_id_163d208d` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `django_authopenid_userpasswordqueue` (
+ `id` int(11) NOT NULL auto_increment,
+ `user_id` int(11) NOT NULL,
+ `new_password` varchar(30) NOT NULL,
+ `confirm_key` varchar(40) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `user_id` (`user_id`),
+ CONSTRAINT `user_id_refs_id_76bcaaa4` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
+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 AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
+
+
+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=utf8;
+
+
+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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `favorite_question` (
+ `id` int(11) NOT NULL auto_increment,
+ `question_id` int(11) NOT NULL,
+ `user_id` int(11) NOT NULL,
+ `added_at` datetime NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `favorite_question_question_id` (`question_id`),
+ KEY `favorite_question_user_id` (`user_id`),
+ CONSTRAINT `question_id_refs_id_1ebe1cc3` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`),
+ CONSTRAINT `user_id_refs_id_52853822` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `flagged_item` (
+ `id` int(11) NOT NULL auto_increment,
+ `content_type_id` int(11) NOT NULL,
+ `object_id` int(10) unsigned NOT NULL,
+ `user_id` int(11) NOT NULL,
+ `flagged_at` datetime NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `content_type_id` (`content_type_id`,`object_id`,`user_id`),
+ KEY `flagged_item_content_type_id` (`content_type_id`),
+ KEY `flagged_item_user_id` (`user_id`),
+ CONSTRAINT `content_type_id_refs_id_76e44d74` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
+ CONSTRAINT `user_id_refs_id_35e3c608` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `question` (
+ `id` int(11) NOT NULL auto_increment,
+ `title` varchar(300) NOT NULL,
+ `author_id` int(11) NOT NULL,
+ `added_at` datetime NOT NULL,
+ `wiki` tinyint(1) NOT NULL,
+ `wikified_at` datetime default NULL,
+ `answer_accepted` tinyint(1) NOT NULL,
+ `closed` tinyint(1) NOT NULL,
+ `closed_by_id` int(11) default NULL,
+ `closed_at` datetime default NULL,
+ `close_reason` smallint(6) default NULL,
+ `deleted` tinyint(1) NOT NULL,
+ `deleted_at` datetime default NULL,
+ `deleted_by_id` int(11) default NULL,
+ `locked` tinyint(1) NOT NULL,
+ `locked_by_id` int(11) default NULL,
+ `locked_at` datetime default NULL,
+ `score` int(11) NOT NULL,
+ `answer_count` int(10) unsigned NOT NULL,
+ `comment_count` int(10) unsigned NOT NULL,
+ `view_count` int(10) unsigned NOT NULL,
+ `offensive_flag_count` smallint(6) NOT NULL,
+ `favourite_count` int(10) unsigned NOT NULL,
+ `last_edited_at` datetime default NULL,
+ `last_edited_by_id` int(11) default NULL,
+ `last_activity_at` datetime NOT NULL,
+ `last_activity_by_id` int(11) NOT NULL,
+ `tagnames` varchar(125) NOT NULL,
+ `summary` varchar(180) NOT NULL,
+ `html` longtext NOT NULL,
+ `vote_up_count` int(11) NOT NULL,
+ `vote_down_count` int(11) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `question_author_id` (`author_id`),
+ KEY `question_closed_by_id` (`closed_by_id`),
+ KEY `question_deleted_by_id` (`deleted_by_id`),
+ KEY `question_locked_by_id` (`locked_by_id`),
+ KEY `question_last_edited_by_id` (`last_edited_by_id`),
+ KEY `question_last_activity_by_id` (`last_activity_by_id`),
+ CONSTRAINT `author_id_refs_id_56e9d00c` FOREIGN KEY (`author_id`) REFERENCES `auth_user` (`id`),
+ CONSTRAINT `closed_by_id_refs_id_56e9d00c` FOREIGN KEY (`closed_by_id`) REFERENCES `auth_user` (`id`),
+ CONSTRAINT `deleted_by_id_refs_id_56e9d00c` FOREIGN KEY (`deleted_by_id`) REFERENCES `auth_user` (`id`),
+ CONSTRAINT `last_activity_by_id_refs_id_56e9d00c` FOREIGN KEY (`last_activity_by_id`) REFERENCES `auth_user` (`id`),
+ CONSTRAINT `last_edited_by_id_refs_id_56e9d00c` FOREIGN KEY (`last_edited_by_id`) REFERENCES `auth_user` (`id`),
+ CONSTRAINT `locked_by_id_refs_id_56e9d00c` FOREIGN KEY (`locked_by_id`) REFERENCES `auth_user` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `question_revision` (
+ `id` int(11) NOT NULL auto_increment,
+ `question_id` int(11) NOT NULL,
+ `revision` int(10) unsigned NOT NULL,
+ `title` varchar(300) NOT NULL,
+ `author_id` int(11) NOT NULL,
+ `revised_at` datetime NOT NULL,
+ `tagnames` varchar(125) NOT NULL,
+ `summary` varchar(300) NOT NULL,
+ `text` longtext NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `question_revision_question_id` (`question_id`),
+ KEY `question_revision_author_id` (`author_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
+
+
+CREATE TABLE `question_tags` (
+ `id` int(11) NOT NULL auto_increment,
+ `question_id` int(11) NOT NULL,
+ `tag_id` int(11) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `question_id` (`question_id`,`tag_id`),
+ KEY `tag_id_refs_id_43fcb953` (`tag_id`),
+ CONSTRAINT `question_id_refs_id_266147c6` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`),
+ CONSTRAINT `tag_id_refs_id_43fcb953` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `repute` (
+ `id` int(11) NOT NULL auto_increment,
+ `user_id` int(11) NOT NULL,
+ `positive` smallint(6) NOT NULL,
+ `negative` smallint(6) NOT NULL,
+ `question_id` int(11) NOT NULL,
+ `reputed_at` datetime NOT NULL,
+ `reputation_type` smallint(6) NOT NULL,
+ `reputation` int(11) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `repute_user_id` (`user_id`),
+ KEY `repute_question_id` (`question_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `tag` (
+ `id` int(11) NOT NULL auto_increment,
+ `name` varchar(255) NOT NULL,
+ `created_by_id` int(11) NOT NULL,
+ `used_count` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `name` (`name`),
+ KEY `tag_created_by_id` (`created_by_id`),
+ CONSTRAINT `created_by_id_refs_id_47205d6d` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `user_badge` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `user_id` int(10) unsigned NOT NULL,
+ `badge_id` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `user_favorite_questions` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `user_id` int(10) unsigned NOT NULL,
+ `question_id` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `vote` (
+ `id` int(11) NOT NULL auto_increment,
+ `content_type_id` int(11) NOT NULL,
+ `object_id` int(10) unsigned NOT NULL,
+ `user_id` int(11) NOT NULL,
+ `vote` smallint(6) NOT NULL,
+ `voted_at` datetime NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `content_type_id` (`content_type_id`,`object_id`,`user_id`),
+ KEY `vote_content_type_id` (`content_type_id`),
+ KEY `vote_user_id` (`user_id`),
+ CONSTRAINT `content_type_id_refs_id_50124414` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
+ CONSTRAINT `user_id_refs_id_760a4df0` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+
+
+SET FOREIGN_KEY_CHECKS = 1;