SQL dump of the badges table, from Vanilla Forums w/ the Yet Another Gamification Application.

GDN_Badge.sql

-- phpMyAdmin SQL Dump
-- version 4.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 05, 2014 at 02:21 PM
-- Server version: 5.5.33a-MariaDB-1~squeeze-log
-- PHP Version: 5.4.9-4ubuntu2.3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `vanilla`
--

-- --------------------------------------------------------

--
-- Table structure for table `GDN_Badge`
--

CREATE TABLE IF NOT EXISTS `GDN_Badge` (
  `BadgeID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(140) COLLATE utf8_unicode_ci NOT NULL,
  `Description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RuleClass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `RuleCriteria` text COLLATE utf8_unicode_ci,
  `AwardValue` int(11) NOT NULL DEFAULT '0',
  `Enabled` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`BadgeID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `GDN_Badge`
--

INSERT INTO `GDN_Badge` (`BadgeID`, `Name`, `Description`, `Photo`, `RuleClass`, `RuleCriteria`, `AwardValue`, `Enabled`) VALUES
(1, 'First Comment', 'Leave a comment', NULL, 'CommentCount', 'a:2:{s:10:"Comparison";s:2:"gt";s:6:"Target";s:1:"0";}', 5, 1),
(2, 'First Discussion', 'Create your first discussion', NULL, 'DiscussionCount', 'a:2:{s:10:"Comparison";s:2:"gt";s:6:"Target";s:1:"0";}', 10, 1);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;