-- phpMyAdmin SQL Dump
-- version 3.3.8
-- http://www.phpmyadmin.net
--
-- Serveur: 127.0.0.1
-- G�n�r� le : Mar 27 Septembre 2011 � 23:52
-- Version du serveur: 5.1.52
-- Version de PHP: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 */;

--
-- Base de donn�es: `yash`
--

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

--
-- Structure de la table `watch_component`
--

CREATE TABLE IF NOT EXISTS `watch_component` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dimension` int(10) unsigned NOT NULL,
  `rule` int(10) unsigned NOT NULL,
  `lifetime` int(10) unsigned NOT NULL,
  `weight` float NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index` (`dimension`,`rule`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `watch_component`
--

INSERT INTO `watch_component` (`id`, `dimension`, `rule`, `lifetime`, `weight`) VALUES
(1, 1, 1, 604800, 1),
(2, 2, 1, 86400, 1);

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

--
-- Structure de la table `watch_dimension`
--

CREATE TABLE IF NOT EXISTS `watch_dimension` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` char(100) COLLATE utf8_unicode_ci NOT NULL,
  `ref_type` smallint(5) unsigned NOT NULL,
  `cb_measure` char(50) COLLATE utf8_unicode_ci NOT NULL,
  `cb_score` char(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `watch_dimension`
--

INSERT INTO `watch_dimension` (`id`, `name`, `ref_type`, `cb_measure`, `cb_score`) VALUES
(1, 'post length is lower than', 0, 'postLengthLowerThan', 'postLengthLowerThan'),
(2, 'user is a new joiner', 2, 'userIsNew', 'userIsNew');

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

--
-- Structure de la table `watch_measure`
--

CREATE TABLE IF NOT EXISTS `watch_measure` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `component` int(10) unsigned NOT NULL,
  `entry_id` int(10) unsigned NOT NULL,
  `ref_id` int(10) unsigned NOT NULL,
  `time_expire` int(10) unsigned NOT NULL,
  `time_store` int(10) unsigned NOT NULL,
  `data` char(200) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index` (`component`,`entry_id`,`ref_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `watch_measure`
--


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

--
-- Structure de la table `watch_rule`
--

CREATE TABLE IF NOT EXISTS `watch_rule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` char(100) COLLATE utf8_unicode_ci NOT NULL,
  `entry_type` smallint(5) unsigned NOT NULL,
  `decision` char(50) COLLATE utf8_unicode_ci NOT NULL,
  `limit` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `watch_rule`
--

INSERT INTO `watch_rule` (`id`, `name`, `entry_type`, `decision`, `limit`) VALUES
(1, 'user is a spammer', 2, 'userKick', 0.6);