001: -- phpMyAdmin SQL Dump
002: -- version 3.3.8
003: -- http://www.phpmyadmin.net
004: --
005: -- Serveur: 127.0.0.1
006: -- G�n�r� le : Mar 27 Septembre 2011 � 23:52
007: -- Version du serveur: 5.1.52
008: -- Version de PHP: 5.3.3
009:
010: SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
011:
012:
013: /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
014: /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
015: /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
016: /*!40101 SET NAMES utf8 */;
017:
018: --
019: -- Base de donn�es: `yash`
020: --
021:
022: -- --------------------------------------------------------
023:
024: --
025: -- Structure de la table `watch_component`
026: --
027:
028: CREATE TABLE IF NOT EXISTS `watch_component` (
029: `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
030: `dimension` int(10) unsigned NOT NULL,
031: `rule` int(10) unsigned NOT NULL,
032: `lifetime` int(10) unsigned NOT NULL,
033: `weight` float NOT NULL,
034: PRIMARY KEY (`id`),
035: UNIQUE KEY `index` (`dimension`,`rule`)
036: ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
037:
038: --
039: -- Contenu de la table `watch_component`
040: --
041:
042: INSERT INTO `watch_component` (`id`, `dimension`, `rule`, `lifetime`, `weight`) VALUES
043: (1, 1, 1, 604800, 1),
044: (2, 2, 1, 86400, 1);
045:
046: -- --------------------------------------------------------
047:
048: --
049: -- Structure de la table `watch_dimension`
050: --
051:
052: CREATE TABLE IF NOT EXISTS `watch_dimension` (
053: `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
054: `name` char(100) COLLATE utf8_unicode_ci NOT NULL,
055: `ref_type` smallint(5) unsigned NOT NULL,
056: `cb_measure` char(50) COLLATE utf8_unicode_ci NOT NULL,
057: `cb_score` char(50) COLLATE utf8_unicode_ci NOT NULL,
058: PRIMARY KEY (`id`)
059: ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
060:
061: --
062: -- Contenu de la table `watch_dimension`
063: --
064:
065: INSERT INTO `watch_dimension` (`id`, `name`, `ref_type`, `cb_measure`, `cb_score`) VALUES
066: (1, 'post length is lower than', 0, 'postLengthLowerThan', 'postLengthLowerThan'),
067: (2, 'user is a new joiner', 2, 'userIsNew', 'userIsNew');
068:
069: -- --------------------------------------------------------
070:
071: --
072: -- Structure de la table `watch_measure`
073: --
074:
075: CREATE TABLE IF NOT EXISTS `watch_measure` (
076: `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
077: `component` int(10) unsigned NOT NULL,
078: `entry_id` int(10) unsigned NOT NULL,
079: `ref_id` int(10) unsigned NOT NULL,
080: `time_expire` int(10) unsigned NOT NULL,
081: `time_store` int(10) unsigned NOT NULL,
082: `data` char(200) COLLATE utf8_unicode_ci NOT NULL,
083: PRIMARY KEY (`id`),
084: UNIQUE KEY `index` (`component`,`entry_id`,`ref_id`)
085: ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
086:
087: --
088: -- Contenu de la table `watch_measure`
089: --
090:
091:
092: -- --------------------------------------------------------
093:
094: --
095: -- Structure de la table `watch_rule`
096: --
097:
098: CREATE TABLE IF NOT EXISTS `watch_rule` (
099: `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
100: `name` char(100) COLLATE utf8_unicode_ci NOT NULL,
101: `entry_type` smallint(5) unsigned NOT NULL,
102: `decision` char(50) COLLATE utf8_unicode_ci NOT NULL,
103: `limit` float NOT NULL,
104: PRIMARY KEY (`id`)
105: ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
106:
107: --
108: -- Contenu de la table `watch_rule`
109: --
110:
111: INSERT INTO `watch_rule` (`id`, `name`, `entry_type`, `decision`, `limit`) VALUES
112: (1, 'user is a spammer', 2, 'userKick', 0.6);