From 3b8821b7e6c00a34fe71b22f011841786bb9d7e5 Mon Sep 17 00:00:00 2001
From: Evgeny Fadeev <evgeny.fadeev@gmail.com>
Date: Sat, 24 Apr 2010 19:11:05 -0400
Subject: moved some files and directories inside forum from root

---
 sql_scripts/cnprog_new_install_2009_04_09.sql | 904 --------------------------
 1 file changed, 904 deletions(-)
 delete mode 100644 sql_scripts/cnprog_new_install_2009_04_09.sql

(limited to 'sql_scripts/cnprog_new_install_2009_04_09.sql')

diff --git a/sql_scripts/cnprog_new_install_2009_04_09.sql b/sql_scripts/cnprog_new_install_2009_04_09.sql
deleted file mode 100644
index f4424852..00000000
--- a/sql_scripts/cnprog_new_install_2009_04_09.sql
+++ /dev/null
@@ -1,904 +0,0 @@
-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: [REDACTED] ***************/
-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
-- 
cgit v1.2.3-1-g7c22

