From 55303308437e527b3e48cca65ca162bac39437c7 Mon Sep 17 00:00:00 2001 From: Rick Ross Date: Sun, 31 Jan 2010 14:07:28 -0500 Subject: Updated to populate badge table in a way that is compatible with boy MySQL and PostgreSQL --- sql_scripts/badges.sql | 74 +++++++++++++++++++++++++------------------------- 1 file changed, 37 insertions(+), 37 deletions(-) (limited to 'sql_scripts') diff --git a/sql_scripts/badges.sql b/sql_scripts/badges.sql index f47e067a..5fd03d18 100644 --- a/sql_scripts/badges.sql +++ b/sql_scripts/badges.sql @@ -1,37 +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); +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', TRUE, 0), +(2, 'Peer Pressure', 3, 'peer-pressure', 'Deleted own post with score of -3 or lower', TRUE, 0), +(3, 'Nice answer', 3, 'nice-answer', 'Answer voted up 10 times', TRUE, 0), +(4, 'Nice Question', 3, 'nice-question', 'Question voted up 10 times', TRUE, 0), +(5, 'Pundit', 3, 'pundit', 'Left 10 comments with score of 10 or more', FALSE, 0), +(6, 'Popular Question', 3, 'popular-question', 'Asked a question with 1,000 views', TRUE, 0), +(7, 'Citizen patrol', 3, 'citizen-patrol', 'First flagged post', FALSE, 0), +(8, 'Cleanup', 3, 'cleanup', 'First rollback', FALSE, 0), +(9, 'Critic', 3, 'critic', 'First down vote', FALSE, 0), +(10, 'Editor', 3, 'editor', 'First edit', FALSE, 0), +(11, 'Organizer', 3, 'organizer', 'First retag', FALSE, 0), +(12, 'Scholar', 3, 'scholar', 'First accepted answer on your own question', FALSE, 0), +(13, 'Student', 3, 'student', 'Asked first question with at least one up vote', FALSE, 0), +(14, 'Supporter', 3, 'supporter', 'First up vote', FALSE, 0), +(15, 'Teacher', 3, 'teacher', 'Answered first question with at least one up vote', FALSE, 0), +(16, 'Autobiographer', 3, 'autobiographer', 'Completed all user profile fields', FALSE, 0), +(17, 'Self-Learner', 3, 'self-learner', 'Answered your own question with at least 3 up votes', TRUE, 0), +(18, 'Great Answer', 1, 'great-answer', 'Answer voted up 100 times', TRUE, 0), +(19, 'Great Question', 1, 'great-question', 'Question voted up 100 times', TRUE, 0), +(20, 'Stellar Question', 1, 'stellar-question', 'Question favorited by 100 users', TRUE, 0), +(21, 'Famous question', 1, 'famous-question', 'Asked a question with 10,000 views', TRUE, 0), +(22, 'Alpha', 2, 'alpha', 'Actively participated in the private alpha', FALSE, 0), +(23, 'Good Answer', 2, 'good-answer', 'Answer voted up 25 times', TRUE, 0), +(24, 'Good Question', 2, 'good-question', 'Question voted up 25 times', TRUE, 0), +(25, 'Favorite Question', 2, 'favorite-question', 'Question favorited by 25 users', TRUE, 0), +(26, 'Civic duty', 2, 'civic-duty', 'Voted 300 times', FALSE, 0), +(27, 'Strunk & White', 2, 'strunk-and-white', 'Edited 100 entries', FALSE, 0), +(28, 'Generalist', 2, 'generalist', 'Active in many different tags', FALSE, 0), +(29, 'Expert', 2, 'export', 'Very active in one tag', FALSE, 0), +(30, 'Yearling', 2, 'yearling', 'Active member for a year', FALSE, 0), +(31, 'Notable Question', 2, 'notable-question', 'Asked a question with 2,500 views', TRUE, 0), +(32, 'Enlightened', 2, 'enlightened', 'First answer was accepted with at least 10 up votes', FALSE, 0), +(33, 'Beta', 2, 'beta', 'Actively participated in the private beta', FALSE, 0), +(34, 'Guru', 2, 'guru', 'Accepted answer and voted up 40 times', TRUE, 0), +(35, 'Necromancer', 2, 'necromancer', 'Answered a question more than 60 days later with at least 5 votes', TRUE, 0), +(36, 'Taxonomist', 2, 'taxonomist', 'Created a tag used by 50 questions', TRUE, 0); -- cgit v1.2.3-1-g7c22