summaryrefslogtreecommitdiffstats
path: root/sql_scripts
diff options
context:
space:
mode:
Diffstat (limited to 'sql_scripts')
-rw-r--r--sql_scripts/100108_upgrade_ef.sql4
-rw-r--r--sql_scripts/badges.sql37
2 files changed, 41 insertions, 0 deletions
diff --git a/sql_scripts/100108_upgrade_ef.sql b/sql_scripts/100108_upgrade_ef.sql
new file mode 100644
index 00000000..1c9a5c1c
--- /dev/null
+++ b/sql_scripts/100108_upgrade_ef.sql
@@ -0,0 +1,4 @@
+alter table auth_user add column hide_ignored_questions tinyint(1) not NULL;
+update auth_user set hide_ignored_questions=0;
+alter table auth_user add column tag_filter_setting varchar(16) not NULL;
+update auth_user set tag_filter_setting='ignored';
diff --git a/sql_scripts/badges.sql b/sql_scripts/badges.sql
new file mode 100644
index 00000000..f47e067a
--- /dev/null
+++ b/sql_scripts/badges.sql
@@ -0,0 +1,37 @@
+INSERT INTO `badge` ( `id`, `name`, `type`, `slug`, `description`, `multiple`, `awarded_count`) VALUES
+(1, 'Disciplined', 3, 'disciplined', 'Deleted own post with score of 3 or higher', 1, 0),
+(2, 'Peer Pressure', 3, 'peer-pressure', 'Deleted own post with score of -3 or lower', 1, 0),
+(3, 'Nice answer', 3, 'nice-answer', 'Answer voted up 10 times', 1, 0),
+(4, 'Nice Question', 3, 'nice-question', 'Question voted up 10 times', 1, 0),
+(5, 'Pundit', 3, 'pundit', 'Left 10 comments with score of 10 or more', 0, 0),
+(6, 'Popular Question', 3, 'popular-question', 'Asked a question with 1,000 views', 1, 0),
+(7, 'Citizen patrol', 3, 'citizen-patrol', 'First flagged post', 0, 0),
+(8, 'Cleanup', 3, 'cleanup', 'First rollback', 0, 0),
+(9, 'Critic', 3, 'critic', 'First down vote', 0, 0),
+(10, 'Editor', 3, 'editor', 'First edit', 0, 0),
+(11, 'Organizer', 3, 'organizer', 'First retag', 0, 0),
+(12, 'Scholar', 3, 'scholar', 'First accepted answer on your own question', 0, 0),
+(13, 'Student', 3, 'student', 'Asked first question with at least one up vote', 0, 0),
+(14, 'Supporter', 3, 'supporter', 'First up vote', 0, 0),
+(15, 'Teacher', 3, 'teacher', 'Answered first question with at least one up vote', 0, 0),
+(16, 'Autobiographer', 3, 'autobiographer', 'Completed all user profile fields', 0, 0),
+(17, 'Self-Learner', 3, 'self-learner', 'Answered your own question with at least 3 up votes', 1, 0),
+(18, 'Great Answer', 1, 'great-answer', 'Answer voted up 100 times', 1, 0),
+(19, 'Great Question', 1, 'great-question', 'Question voted up 100 times', 1, 0),
+(20, 'Stellar Question', 1, 'stellar-question', 'Question favorited by 100 users', 1, 0),
+(21, 'Famous question', 1, 'famous-question', 'Asked a question with 10,000 views', 1, 0),
+(22, 'Alpha', 2, 'alpha', 'Actively participated in the private alpha', 0, 0),
+(23, 'Good Answer', 2, 'good-answer', 'Answer voted up 25 times', 1, 0),
+(24, 'Good Question', 2, 'good-question', 'Question voted up 25 times', 1, 0),
+(25, 'Favorite Question', 2, 'favorite-question', 'Question favorited by 25 users', 1, 0),
+(26, 'Civic duty', 2, 'civic-duty', 'Voted 300 times', 0, 0),
+(27, 'Strunk & White', 2, 'strunk-and-white', 'Edited 100 entries', 0, 0),
+(28, 'Generalist', 2, 'generalist', 'Active in many different tags', 0, 0),
+(29, 'Expert', 2, 'export', 'Very active in one tag', 0, 0),
+(30, 'Yearling', 2, 'yearling', 'Active member for a year', 0, 0),
+(31, 'Notable Question', 2, 'notable-question', 'Asked a question with 2,500 views', 1, 0),
+(32, 'Enlightened', 2, 'enlightened', 'First answer was accepted with at least 10 up votes', 0, 0),
+(33, 'Beta', 2, 'beta', 'Actively participated in the private beta', 0, 0),
+(34, 'Guru', 2, 'guru', 'Accepted answer and voted up 40 times', 1, 0),
+(35, 'Necromancer', 2, 'necromancer', 'Answered a question more than 60 days later with at least 5 votes', 1, 0),
+(36, 'Taxonomist', 2, 'taxonomist', 'Created a tag used by 50 questions', 1, 0);