adding all files again

1 files changed, 904 insertions, 0 deletions

diff --git a/sql_scripts/cnprog_new_install_2009_04_09.sql b/sql_scripts/cnprog_new_install_2009_04_09.sql
new file mode 100644
index 00000000..f4424852
--- /dev/null
+++ b/sql_scripts/cnprog_new_install_2009_04_09.sql
@@ -0,0 +1,904 @@
+USE cnprog;
+
+
+/************ Update: Tables ***************/
+
+/******************** Add Table: activity ************************/
+
+/* Build Table Structure */
+CREATE TABLE activity
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	user_id INTEGER NOT NULL,
+	activity_type SMALLINT NOT NULL,
+	active_at DATETIME NOT NULL,
+	content_type_id INTEGER NOT NULL,
+	object_id INTEGER UNSIGNED NOT NULL,
+	is_auditted TINYINT NULL DEFAULT 0
+) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=latin1;
+
+/* Table Items: activity */
+
+/* Add Indexes for: activity */
+CREATE INDEX activity_content_type_id ON activity (content_type_id);
+CREATE INDEX activity_user_id ON activity (user_id);
+
+/******************** Add Table: answer ************************/
+
+/* Build Table Structure */
+CREATE TABLE answer
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	question_id INTEGER NOT NULL,
+	author_id INTEGER NOT NULL,
+	added_at DATETIME NOT NULL,
+	wiki TINYINT NOT NULL,
+	wikified_at DATETIME NULL,
+	accepted TINYINT NOT NULL,
+	deleted TINYINT NOT NULL,
+	deleted_by_id INTEGER NULL,
+	locked TINYINT NOT NULL,
+	locked_by_id INTEGER NULL,
+	locked_at DATETIME NULL,
+	score INTEGER NOT NULL,
+	comment_count INTEGER UNSIGNED NOT NULL,
+	offensive_flag_count SMALLINT NOT NULL,
+	last_edited_at DATETIME NULL,
+	last_edited_by_id INTEGER NULL,
+	html LONGTEXT NOT NULL,
+	vote_up_count INTEGER NOT NULL,
+	vote_down_count INTEGER NOT NULL,
+	accepted_at DATETIME NULL
+) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
+
+/* Table Items: answer */
+
+/* Add Indexes for: answer */
+CREATE INDEX answer_author_id ON answer (author_id);
+CREATE INDEX answer_deleted_by_id ON answer (deleted_by_id);
+CREATE INDEX answer_last_edited_by_id ON answer (last_edited_by_id);
+CREATE INDEX answer_locked_by_id ON answer (locked_by_id);
+CREATE INDEX answer_question_id ON answer (question_id);
+
+/******************** Add Table: answer_revision ************************/
+
+/* Build Table Structure */
+CREATE TABLE answer_revision
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	answer_id INTEGER NOT NULL,
+	revision INTEGER UNSIGNED NOT NULL,
+	author_id INTEGER NOT NULL,
+	revised_at DATETIME NOT NULL,
+	summary TEXT NOT NULL,
+	`text` LONGTEXT NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+/* Table Items: answer_revision */
+
+/* Add Indexes for: answer_revision */
+CREATE INDEX answer_revision_answer_id ON answer_revision (answer_id);
+CREATE INDEX answer_revision_author_id ON answer_revision (author_id);
+
+/******************** Add Table: auth_group ************************/
+
+/* Build Table Structure */
+CREATE TABLE auth_group
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	name VARCHAR(80) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/* Table Items: auth_group */
+
+/* Add Indexes for: auth_group */
+CREATE UNIQUE INDEX name ON auth_group (name);
+
+/******************** Add Table: auth_group_permissions ************************/
+
+/* Build Table Structure */
+CREATE TABLE auth_group_permissions
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	group_id INTEGER NOT NULL,
+	permission_id INTEGER NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/* Table Items: auth_group_permissions */
+
+/* Add Indexes for: auth_group_permissions */
+CREATE UNIQUE INDEX group_id ON auth_group_permissions (group_id, permission_id);
+CREATE INDEX permission_id_refs_id_5886d21f ON auth_group_permissions (permission_id);
+
+/******************** Add Table: auth_message ************************/
+
+/* Build Table Structure */
+CREATE TABLE auth_message
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	user_id INTEGER NOT NULL,
+	message LONGTEXT NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
+
+/* Table Items: auth_message */
+
+/* Add Indexes for: auth_message */
+CREATE INDEX auth_message_user_id ON auth_message (user_id);
+
+/******************** Add Table: auth_permission ************************/
+
+/* Build Table Structure */
+CREATE TABLE auth_permission
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	name VARCHAR(50) NOT NULL,
+	content_type_id INTEGER NOT NULL,
+	codename VARCHAR(100) NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8;
+
+/* Table Items: auth_permission */
+
+/* Add Indexes for: auth_permission */
+CREATE INDEX auth_permission_content_type_id ON auth_permission (content_type_id);
+CREATE UNIQUE INDEX content_type_id ON auth_permission (content_type_id, codename);
+
+/******************** Add Table: auth_user ************************/
+
+/* Build Table Structure */
+CREATE TABLE auth_user
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	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 NOT NULL,
+	is_active TINYINT NOT NULL,
+	is_superuser TINYINT NOT NULL,
+	last_login DATETIME NOT NULL,
+	date_joined DATETIME NOT NULL,
+	gold SMALLINT NOT NULL DEFAULT 0,
+	silver SMALLINT UNSIGNED NOT NULL DEFAULT 0,
+	bronze SMALLINT UNSIGNED NOT NULL DEFAULT 0,
+	reputation INTEGER UNSIGNED NULL DEFAULT 1,
+	gravatar VARCHAR(128) NULL,
+	questions_per_page SMALLINT UNSIGNED NULL DEFAULT 10,
+	last_seen DATETIME NULL,
+	real_name VARCHAR(100) NULL,
+	website VARCHAR(200) NULL,
+	location VARCHAR(100) NULL,
+	date_of_birth DATETIME NULL,
+	about TEXT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8;
+
+/* Table Items: auth_user */
+
+/* Add Indexes for: auth_user */
+CREATE UNIQUE INDEX username ON auth_user (username);
+
+/******************** Add Table: auth_user_groups ************************/
+
+/* Build Table Structure */
+CREATE TABLE auth_user_groups
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	user_id INTEGER NOT NULL,
+	group_id INTEGER NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/* Table Items: auth_user_groups */
+
+/* Add Indexes for: auth_user_groups */
+CREATE INDEX group_id_refs_id_f116770 ON auth_user_groups (group_id);
+CREATE UNIQUE INDEX user_id ON auth_user_groups (user_id, group_id);
+
+/******************** Add Table: auth_user_user_permissions ************************/
+
+/* Build Table Structure */
+CREATE TABLE auth_user_user_permissions
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	user_id INTEGER NOT NULL,
+	permission_id INTEGER NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/* Table Items: auth_user_user_permissions */
+
+/* Add Indexes for: auth_user_user_permissions */
+CREATE INDEX permission_id_refs_id_67e79cb ON auth_user_user_permissions (permission_id);
+CREATE UNIQUE INDEX user_id ON auth_user_user_permissions (user_id, permission_id);
+
+/******************** Add Table: award ************************/
+
+/* Build Table Structure */
+CREATE TABLE award
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	user_id INTEGER NOT NULL,
+	badge_id INTEGER NOT NULL,
+	awarded_at DATETIME NOT NULL,
+	notified TINYINT NOT NULL,
+	content_type_id INTEGER NULL,
+	object_id INTEGER NULL
+) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
+
+/* Table Items: award */
+
+/* Add Indexes for: award */
+CREATE INDEX award_badge_id ON award (badge_id);
+CREATE INDEX award_user_id ON award (user_id);
+
+/******************** Add Table: badge ************************/
+
+/* Build Table Structure */
+CREATE TABLE badge
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	name VARCHAR(50) NOT NULL,
+	`type` SMALLINT NOT NULL,
+	slug VARCHAR(50) NOT NULL,
+	description TEXT NOT NULL,
+	multiple TINYINT NOT NULL,
+	awarded_count INTEGER UNSIGNED NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
+
+/* Table Items: badge */
+
+/* Add Indexes for: badge */
+CREATE INDEX badge_slug ON badge (slug);
+CREATE UNIQUE INDEX name ON badge (name, `type`);
+
+/******************** Add Table: book ************************/
+
+/* Build Table Structure */
+CREATE TABLE book
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	title VARCHAR(255) NOT NULL,
+	short_name VARCHAR(255) NOT NULL,
+	author VARCHAR(255) NOT NULL,
+	user_id INTEGER NULL,
+	price DECIMAL(10, 2) NULL,
+	pages SMALLINT NULL,
+	published_at DATE NOT NULL,
+	publication VARCHAR(255) NOT NULL,
+	cover_img VARCHAR(255) NULL,
+	tagnames VARCHAR(125) NULL,
+	added_at DATETIME NOT NULL,
+	last_edited_at DATETIME NOT NULL
+) TYPE=InnoDB;
+
+/* Table Items: book */
+
+/* Add Indexes for: book */
+CREATE UNIQUE INDEX book_short_name_Idx ON book (short_name);
+CREATE INDEX fk_books_auth_user ON book (user_id);
+
+/******************** Add Table: book_author_info ************************/
+
+/* Build Table Structure */
+CREATE TABLE book_author_info
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	blog_url VARCHAR(255) NULL,
+	user_id INTEGER NOT NULL,
+	added_at DATETIME NOT NULL,
+	last_edited_at DATETIME NOT NULL,
+	book_id INTEGER NOT NULL
+) TYPE=InnoDB;
+
+/* Table Items: book_author_info */
+
+/* Add Indexes for: book_author_info */
+CREATE INDEX fk_book_author_info_auth_user ON book_author_info (user_id);
+CREATE INDEX fk_book_author_info_book ON book_author_info (book_id);
+
+/******************** Add Table: book_author_rss ************************/
+
+/* Build Table Structure */
+CREATE TABLE book_author_rss
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	title VARCHAR(255) NOT NULL,
+	url VARCHAR(255) NOT NULL,
+	rss_created_at DATETIME NOT NULL,
+	user_id INTEGER NOT NULL,
+	added_at DATETIME NOT NULL,
+	book_id INTEGER NOT NULL
+) TYPE=InnoDB;
+
+/* Table Items: book_author_rss */
+
+/* Add Indexes for: book_author_rss */
+CREATE INDEX fk_book_author_rss_auth_user ON book_author_rss (user_id);
+CREATE INDEX fk_book_author_rss_book ON book_author_rss (book_id);
+
+/******************** Add Table: book_question ************************/
+
+/* Build Table Structure */
+CREATE TABLE book_question
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	book_id INTEGER NOT NULL,
+	question_id INTEGER NOT NULL
+) TYPE=InnoDB;
+
+/* Table Items: book_question */
+
+/* Add Indexes for: book_question */
+CREATE INDEX fk_book_question_book ON book_question (book_id);
+CREATE INDEX fk_book_question_question ON book_question (question_id);
+
+/******************** Add Table: `comment` ************************/
+
+/* Build Table Structure */
+CREATE TABLE `comment`
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	content_type_id INTEGER NOT NULL,
+	object_id INTEGER UNSIGNED NOT NULL,
+	user_id INTEGER NOT NULL,
+	`comment` TEXT NOT NULL,
+	added_at DATETIME NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
+
+/* Table Items: `comment` */
+
+/* Add Indexes for: comment */
+CREATE INDEX comment_content_type_id ON `comment` (content_type_id);
+CREATE INDEX comment_user_id ON `comment` (user_id);
+CREATE INDEX content_type_id ON `comment` (content_type_id, object_id, user_id);
+
+/******************** Add Table: django_admin_log ************************/
+
+/* Build Table Structure */
+CREATE TABLE django_admin_log
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	action_time DATETIME NOT NULL,
+	user_id INTEGER NOT NULL,
+	content_type_id INTEGER NULL,
+	object_id LONGTEXT NULL,
+	object_repr VARCHAR(200) NOT NULL,
+	action_flag SMALLINT UNSIGNED NOT NULL,
+	change_message LONGTEXT NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+
+/* Table Items: django_admin_log */
+
+/* Add Indexes for: django_admin_log */
+CREATE INDEX django_admin_log_content_type_id ON django_admin_log (content_type_id);
+CREATE INDEX django_admin_log_user_id ON django_admin_log (user_id);
+
+/******************** Add Table: django_authopenid_association ************************/
+
+/* Build Table Structure */
+CREATE TABLE django_authopenid_association
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	server_url LONGTEXT NOT NULL,
+	handle VARCHAR(255) NOT NULL,
+	secret LONGTEXT NOT NULL,
+	issued INTEGER NOT NULL,
+	lifetime INTEGER NOT NULL,
+	assoc_type LONGTEXT NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
+
+/******************** Add Table: django_authopenid_nonce ************************/
+
+/* Build Table Structure */
+CREATE TABLE django_authopenid_nonce
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	server_url VARCHAR(255) NOT NULL,
+	`timestamp` INTEGER NOT NULL,
+	salt VARCHAR(40) NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
+
+/******************** Add Table: django_authopenid_userassociation ************************/
+
+/* Build Table Structure */
+CREATE TABLE django_authopenid_userassociation
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	openid_url VARCHAR(255) NOT NULL,
+	user_id INTEGER NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
+
+/* Table Items: django_authopenid_userassociation */
+
+/* Add Indexes for: django_authopenid_userassociation */
+CREATE UNIQUE INDEX user_id ON django_authopenid_userassociation (user_id);
+
+/******************** Add Table: django_authopenid_userpasswordqueue ************************/
+
+/* Build Table Structure */
+CREATE TABLE django_authopenid_userpasswordqueue
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	user_id INTEGER NOT NULL,
+	new_password VARCHAR(30) NOT NULL,
+	confirm_key VARCHAR(40) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/* Table Items: django_authopenid_userpasswordqueue */
+
+/* Add Indexes for: django_authopenid_userpasswordqueue */
+CREATE UNIQUE INDEX user_id ON django_authopenid_userpasswordqueue (user_id);
+
+/******************** Add Table: django_content_type ************************/
+
+/* Build Table Structure */
+CREATE TABLE django_content_type
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	name VARCHAR(100) NOT NULL,
+	app_label VARCHAR(100) NOT NULL,
+	model VARCHAR(100) NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
+
+/* Table Items: django_content_type */
+
+/* Add Indexes for: django_content_type */
+CREATE UNIQUE INDEX app_label ON django_content_type (app_label, model);
+
+/******************** Add Table: django_session ************************/
+
+/* Build Table Structure */
+CREATE TABLE django_session
+(
+	session_key VARCHAR(40) NOT NULL,
+	session_data LONGTEXT NOT NULL,
+	expire_date DATETIME NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/* Table Items: django_session */
+ALTER TABLE django_session ADD CONSTRAINT pkdjango_session
+	PRIMARY KEY (session_key);
+
+/******************** Add Table: django_site ************************/
+
+/* Build Table Structure */
+CREATE TABLE django_site
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	domain VARCHAR(100) NOT NULL,
+	name VARCHAR(50) NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+
+/******************** Add Table: favorite_question ************************/
+
+/* Build Table Structure */
+CREATE TABLE favorite_question
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	question_id INTEGER NOT NULL,
+	user_id INTEGER NOT NULL,
+	added_at DATETIME NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
+
+/* Table Items: favorite_question */
+
+/* Add Indexes for: favorite_question */
+CREATE INDEX favorite_question_question_id ON favorite_question (question_id);
+CREATE INDEX favorite_question_user_id ON favorite_question (user_id);
+
+/******************** Add Table: flagged_item ************************/
+
+/* Build Table Structure */
+CREATE TABLE flagged_item
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	content_type_id INTEGER NOT NULL,
+	object_id INTEGER UNSIGNED NOT NULL,
+	user_id INTEGER NOT NULL,
+	flagged_at DATETIME NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
+
+/* Table Items: flagged_item */
+
+/* Add Indexes for: flagged_item */
+CREATE UNIQUE INDEX content_type_id ON flagged_item (content_type_id, object_id, user_id);
+CREATE INDEX flagged_item_content_type_id ON flagged_item (content_type_id);
+CREATE INDEX flagged_item_user_id ON flagged_item (user_id);
+
+/******************** Add Table: question ************************/
+
+/* Build Table Structure */
+CREATE TABLE question
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	title TEXT NOT NULL,
+	author_id INTEGER NOT NULL,
+	added_at DATETIME NOT NULL,
+	wiki TINYINT NOT NULL,
+	wikified_at DATETIME NULL,
+	answer_accepted TINYINT NOT NULL,
+	closed TINYINT NOT NULL,
+	closed_by_id INTEGER NULL,
+	closed_at DATETIME NULL,
+	close_reason SMALLINT NULL,
+	deleted TINYINT NOT NULL,
+	deleted_at DATETIME NULL,
+	deleted_by_id INTEGER NULL,
+	locked TINYINT NOT NULL,
+	locked_by_id INTEGER NULL,
+	locked_at DATETIME NULL,
+	score INTEGER NOT NULL,
+	answer_count INTEGER UNSIGNED NOT NULL,
+	comment_count INTEGER UNSIGNED NOT NULL,
+	view_count INTEGER UNSIGNED NOT NULL,
+	offensive_flag_count SMALLINT NOT NULL,
+	favourite_count INTEGER UNSIGNED NOT NULL,
+	last_edited_at DATETIME NULL,
+	last_edited_by_id INTEGER NULL,
+	last_activity_at DATETIME NOT NULL,
+	last_activity_by_id INTEGER NOT NULL,
+	tagnames VARCHAR(125) NOT NULL,
+	summary VARCHAR(180) NOT NULL,
+	html LONGTEXT NOT NULL,
+	vote_up_count INTEGER NOT NULL,
+	vote_down_count INTEGER NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
+
+/* Table Items: question */
+
+/* Add Indexes for: question */
+CREATE INDEX question_author_id ON question (author_id);
+CREATE INDEX question_closed_by_id ON question (closed_by_id);
+CREATE INDEX question_deleted_by_id ON question (deleted_by_id);
+CREATE INDEX question_last_activity_by_id ON question (last_activity_by_id);
+CREATE INDEX question_last_edited_by_id ON question (last_edited_by_id);
+CREATE INDEX question_locked_by_id ON question (locked_by_id);
+
+/******************** Add Table: question_revision ************************/
+
+/* Build Table Structure */
+CREATE TABLE question_revision
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	question_id INTEGER NOT NULL,
+	revision INTEGER UNSIGNED NOT NULL,
+	title TEXT NOT NULL,
+	author_id INTEGER NOT NULL,
+	revised_at DATETIME NOT NULL,
+	tagnames VARCHAR(125) NOT NULL,
+	summary TEXT NOT NULL,
+	`text` LONGTEXT NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
+
+/* Table Items: question_revision */
+
+/* Add Indexes for: question_revision */
+CREATE INDEX question_revision_author_id ON question_revision (author_id);
+CREATE INDEX question_revision_question_id ON question_revision (question_id);
+
+/******************** Add Table: question_tags ************************/
+
+/* Build Table Structure */
+CREATE TABLE question_tags
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	question_id INTEGER NOT NULL,
+	tag_id INTEGER NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
+
+/* Table Items: question_tags */
+
+/* Add Indexes for: question_tags */
+CREATE UNIQUE INDEX question_id ON question_tags (question_id, tag_id);
+CREATE INDEX tag_id_refs_id_43fcb953 ON question_tags (tag_id);
+
+/******************** Add Table: repute ************************/
+
+/* Build Table Structure */
+CREATE TABLE repute
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	user_id INTEGER NOT NULL,
+	positive SMALLINT NOT NULL,
+	negative SMALLINT NOT NULL,
+	question_id INTEGER NOT NULL,
+	reputed_at DATETIME NOT NULL,
+	reputation_type SMALLINT NOT NULL,
+	reputation INTEGER NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
+
+/* Table Items: repute */
+
+/* Add Indexes for: repute */
+CREATE INDEX repute_question_id ON repute (question_id);
+CREATE INDEX repute_user_id ON repute (user_id);
+
+/******************** Add Table: tag ************************/
+
+/* Build Table Structure */
+CREATE TABLE tag
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	name VARCHAR(255) NOT NULL,
+	created_by_id INTEGER NOT NULL,
+	used_count INTEGER UNSIGNED NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
+
+/* Table Items: tag */
+
+/* Add Indexes for: tag */
+CREATE UNIQUE INDEX name ON tag (name);
+CREATE INDEX tag_created_by_id ON tag (created_by_id);
+
+/******************** Add Table: user_badge ************************/
+
+/* Build Table Structure */
+CREATE TABLE user_badge
+(
+	id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	user_id INTEGER NOT NULL,
+	badge_id INTEGER NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/* Table Items: user_badge */
+
+/* Add Indexes for: user_badge */
+CREATE INDEX fk_user_badge_auth_user ON user_badge (user_id);
+CREATE INDEX fk_user_badge_badge ON user_badge (badge_id);
+
+/******************** Add Table: user_favorite_questions ************************/
+
+/* Build Table Structure */
+CREATE TABLE user_favorite_questions
+(
+	id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	user_id INTEGER NOT NULL,
+	question_id INTEGER NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/* Table Items: user_favorite_questions */
+
+/* Add Indexes for: user_favorite_questions */
+CREATE INDEX fk_user_favorite_questions_auth_user ON user_favorite_questions (user_id);
+CREATE INDEX fk_user_favorite_questions_question ON user_favorite_questions (question_id);
+
+/******************** Add Table: vote ************************/
+
+/* Build Table Structure */
+CREATE TABLE vote
+(
+	id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	content_type_id INTEGER NOT NULL,
+	object_id INTEGER UNSIGNED NOT NULL,
+	user_id INTEGER NOT NULL,
+	vote SMALLINT NOT NULL,
+	voted_at DATETIME NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+
+/* Table Items: vote */
+
+/* Add Indexes for: vote */
+CREATE UNIQUE INDEX content_type_id ON vote (content_type_id, object_id, user_id);
+CREATE INDEX vote_content_type_id ON vote (content_type_id);
+CREATE INDEX vote_user_id ON vote (user_id);
+
+
+/************ Add Foreign Keys to Database ***************/
+/*-----------------------------------------------------------
+Warning: Versions of MySQL prior to 4.1.2 require indexes on all columns involved in a foreign key. The following indexes may be required: 
+fk_auth_group_permissions_auth_group may require an index on table: auth_group_permissions, column: group_id
+fk_auth_user_groups_auth_user may require an index on table: auth_user_groups, column: user_id
+fk_auth_user_user_permissions_auth_user may require an index on table: auth_user_user_permissions, column: user_id
+fk_question_tags_question may require an index on table: question_tags, column: question_id
+-----------------------------------------------------------
+*/
+
+/************ Foreign Key: fk_activity_auth_user ***************/
+ALTER TABLE activity ADD CONSTRAINT fk_activity_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: deleted_by_id_refs_id_192b0170 ***************/
+ALTER TABLE answer ADD CONSTRAINT deleted_by_id_refs_id_192b0170
+	FOREIGN KEY (deleted_by_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_answer_auth_user ***************/
+ALTER TABLE answer ADD CONSTRAINT fk_answer_auth_user
+	FOREIGN KEY (author_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_answer_question ***************/
+ALTER TABLE answer ADD CONSTRAINT fk_answer_question
+	FOREIGN KEY (question_id) REFERENCES question (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: last_edited_by_id_refs_id_192b0170 ***************/
+ALTER TABLE answer ADD CONSTRAINT last_edited_by_id_refs_id_192b0170
+	FOREIGN KEY (last_edited_by_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: locked_by_id_refs_id_192b0170 ***************/
+ALTER TABLE answer ADD CONSTRAINT locked_by_id_refs_id_192b0170
+	FOREIGN KEY (locked_by_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_answer_revision_auth_user ***************/
+ALTER TABLE answer_revision ADD CONSTRAINT fk_answer_revision_auth_user
+	FOREIGN KEY (author_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_auth_group_permissions_auth_group ***************/
+ALTER TABLE auth_group_permissions ADD CONSTRAINT fk_auth_group_permissions_auth_group
+	FOREIGN KEY (group_id) REFERENCES auth_group (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_auth_group_permissions_auth_permission ***************/
+ALTER TABLE auth_group_permissions ADD CONSTRAINT fk_auth_group_permissions_auth_permission
+	FOREIGN KEY (permission_id) REFERENCES auth_permission (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_auth_message_auth_user ***************/
+ALTER TABLE auth_message ADD CONSTRAINT fk_auth_message_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_auth_permission_django_content_type ***************/
+ALTER TABLE auth_permission ADD CONSTRAINT fk_auth_permission_django_content_type
+	FOREIGN KEY (content_type_id) REFERENCES django_content_type (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_auth_user_groups_auth_group ***************/
+ALTER TABLE auth_user_groups ADD CONSTRAINT fk_auth_user_groups_auth_group
+	FOREIGN KEY (group_id) REFERENCES auth_group (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_auth_user_groups_auth_user ***************/
+ALTER TABLE auth_user_groups ADD CONSTRAINT fk_auth_user_groups_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_auth_user_user_permissions_auth_permission ***************/
+ALTER TABLE auth_user_user_permissions ADD CONSTRAINT fk_auth_user_user_permissions_auth_permission
+	FOREIGN KEY (permission_id) REFERENCES auth_permission (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_auth_user_user_permissions_auth_user ***************/
+ALTER TABLE auth_user_user_permissions ADD CONSTRAINT fk_auth_user_user_permissions_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_award_auth_user ***************/
+ALTER TABLE award ADD CONSTRAINT fk_award_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_award_badge ***************/
+ALTER TABLE award ADD CONSTRAINT fk_award_badge
+	FOREIGN KEY (badge_id) REFERENCES badge (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_books_auth_user ***************/
+ALTER TABLE book ADD CONSTRAINT fk_books_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_book_author_info_auth_user ***************/
+ALTER TABLE book_author_info ADD CONSTRAINT fk_book_author_info_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_book_author_info_book ***************/
+ALTER TABLE book_author_info ADD CONSTRAINT fk_book_author_info_book
+	FOREIGN KEY (book_id) REFERENCES book (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_book_author_rss_auth_user ***************/
+ALTER TABLE book_author_rss ADD CONSTRAINT fk_book_author_rss_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_book_author_rss_book ***************/
+ALTER TABLE book_author_rss ADD CONSTRAINT fk_book_author_rss_book
+	FOREIGN KEY (book_id) REFERENCES book (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_book_question_book ***************/
+ALTER TABLE book_question ADD CONSTRAINT fk_book_question_book
+	FOREIGN KEY (book_id) REFERENCES book (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_book_question_question ***************/
+ALTER TABLE book_question ADD CONSTRAINT fk_book_question_question
+	FOREIGN KEY (question_id) REFERENCES question (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_comment_auth_user ***************/
+ALTER TABLE `comment` ADD CONSTRAINT fk_comment_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_comment_django_content_type ***************/
+ALTER TABLE `comment` ADD CONSTRAINT fk_comment_django_content_type
+	FOREIGN KEY (content_type_id) REFERENCES django_content_type (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_django_admin_log_auth_user ***************/
+ALTER TABLE django_admin_log ADD CONSTRAINT fk_django_admin_log_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_django_admin_log_django_content_type ***************/
+ALTER TABLE django_admin_log ADD CONSTRAINT fk_django_admin_log_django_content_type
+	FOREIGN KEY (content_type_id) REFERENCES django_content_type (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_django_authopenid_userassociation_auth_user ***************/
+ALTER TABLE django_authopenid_userassociation ADD CONSTRAINT fk_django_authopenid_userassociation_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_django_authopenid_userpasswordqueue_auth_user ***************/
+ALTER TABLE django_authopenid_userpasswordqueue ADD CONSTRAINT fk_django_authopenid_userpasswordqueue_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_favorite_question_auth_user ***************/
+ALTER TABLE favorite_question ADD CONSTRAINT fk_favorite_question_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_favorite_question_question ***************/
+ALTER TABLE favorite_question ADD CONSTRAINT fk_favorite_question_question
+	FOREIGN KEY (question_id) REFERENCES question (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_flagged_item_auth_user ***************/
+ALTER TABLE flagged_item ADD CONSTRAINT fk_flagged_item_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_flagged_item_django_content_type ***************/
+ALTER TABLE flagged_item ADD CONSTRAINT fk_flagged_item_django_content_type
+	FOREIGN KEY (content_type_id) REFERENCES django_content_type (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: closed_by_id_refs_id_56e9d00c ***************/
+ALTER TABLE question ADD CONSTRAINT closed_by_id_refs_id_56e9d00c
+	FOREIGN KEY (closed_by_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: deleted_by_id_refs_id_56e9d00c ***************/
+ALTER TABLE question ADD CONSTRAINT deleted_by_id_refs_id_56e9d00c
+	FOREIGN KEY (deleted_by_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_question_auth_user ***************/
+ALTER TABLE question ADD CONSTRAINT fk_question_auth_user
+	FOREIGN KEY (author_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: last_activity_by_id_refs_id_56e9d00c ***************/
+ALTER TABLE question ADD CONSTRAINT last_activity_by_id_refs_id_56e9d00c
+	FOREIGN KEY (last_activity_by_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: last_edited_by_id_refs_id_56e9d00c ***************/
+ALTER TABLE question ADD CONSTRAINT last_edited_by_id_refs_id_56e9d00c
+	FOREIGN KEY (last_edited_by_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: locked_by_id_refs_id_56e9d00c ***************/
+ALTER TABLE question ADD CONSTRAINT locked_by_id_refs_id_56e9d00c
+	FOREIGN KEY (locked_by_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_question_revision_auth_user ***************/
+ALTER TABLE question_revision ADD CONSTRAINT fk_question_revision_auth_user
+	FOREIGN KEY (author_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_question_revision_question ***************/
+ALTER TABLE question_revision ADD CONSTRAINT fk_question_revision_question
+	FOREIGN KEY (question_id) REFERENCES question (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_question_tags_question ***************/
+ALTER TABLE question_tags ADD CONSTRAINT fk_question_tags_question
+	FOREIGN KEY (question_id) REFERENCES question (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_question_tags_tag ***************/
+ALTER TABLE question_tags ADD CONSTRAINT fk_question_tags_tag
+	FOREIGN KEY (tag_id) REFERENCES tag (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_repute_auth_user ***************/
+ALTER TABLE repute ADD CONSTRAINT fk_repute_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_repute_question ***************/
+ALTER TABLE repute ADD CONSTRAINT fk_repute_question
+	FOREIGN KEY (question_id) REFERENCES question (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_tag_auth_user ***************/
+ALTER TABLE tag ADD CONSTRAINT fk_tag_auth_user
+	FOREIGN KEY (created_by_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_user_badge_auth_user ***************/
+ALTER TABLE user_badge ADD CONSTRAINT fk_user_badge_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_user_badge_badge ***************/
+ALTER TABLE user_badge ADD CONSTRAINT fk_user_badge_badge
+	FOREIGN KEY (badge_id) REFERENCES badge (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_user_favorite_questions_auth_user ***************/
+ALTER TABLE user_favorite_questions ADD CONSTRAINT fk_user_favorite_questions_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_user_favorite_questions_question ***************/
+ALTER TABLE user_favorite_questions ADD CONSTRAINT fk_user_favorite_questions_question
+	FOREIGN KEY (question_id) REFERENCES question (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_vote_auth_user ***************/
+ALTER TABLE vote ADD CONSTRAINT fk_vote_auth_user
+	FOREIGN KEY (user_id) REFERENCES auth_user (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/************ Foreign Key: fk_vote_django_content_type ***************/
+ALTER TABLE vote ADD CONSTRAINT fk_vote_django_content_type
+	FOREIGN KEY (content_type_id) REFERENCES django_content_type (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
\ No newline at end of file