File: yash_data_watch.sql - Tab length: 1 2 4 8 - Lines: on off - No wrap: on off

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);