tb_rules.sql

-- phpMyAdmin SQL Dump
-- version 3.4.10.1deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 30, 2012 at 12:08 PM
-- Server version: 5.5.24
-- PHP Version: 5.3.10-1ubuntu3.4

-- Notes:
-- The existence of the XRef Table allow application of the rules accross
-- multiple profiles.
-- The existence of the `rul_pri` field in the Rules Table allows for assignment
-- of priority (order of appearance/execution - in all old TBird Rules) but only
-- order of execution, letting sorted order appear in the new rules interface
-- The existence of the Actions Table allows for future capabilities where
-- Multiple rule actions can be assigned to each rule and execution in priority
-- order under that rule.

--
-- Database: `TBird_Rules`
--
DROP DATABASE IF EXISTS `TBird_Rules`;
CREATE DATABASE IF NOT EXISTS `TBird_Rules`;
USE `TBird_Rules`;

-- Table structure for table `tb_prof`
DROP TABLE IF EXISTS `tb_prof`;
CREATE TABLE IF NOT EXISTS `tb_prof` (
  `prf_idx` int(11) NOT NULL auto_increment			COMMENT 'Unique TBird Profile Record',
  `prf_cpu` varchar(32) NOT NULL							COMMENT 'TBird Profile CPU/Machine',
  `prf_lnk` varchar(222) NOT NULL						COMMENT 'TBird Profile CPU/IP Link or Network Folder',
  `prf_nam` varchar(16) NOT NULL							COMMENT 'TBird Profile Name',
  `prf_eml` varchar(32) NOT NULL							COMMENT 'TBird Profile Name',
  `prf_typ` varchar(12) NOT NULL							COMMENT 'TBird Profile Name',
  `prf_pth` varchar(222) NOT NULL						COMMENT 'TBird Profile Path',
  `prf_fil` varchar(32) NOT NULL							COMMENT 'TBird Profile File',
  PRIMARY KEY (`prf_idx`)
)																	COMMENT 'TBird Rules Profile Table';

-- Dumping data for table `tb_prof`

-- End data dump

-- Table structure for table `tb_cat`
DROP TABLE IF EXISTS `tb_cat`;
CREATE TABLE IF NOT EXISTS `tb_cat` (
  `cat_idx` int(11) NOT NULL auto_increment			COMMENT 'Unique TBird Categories Record',
  `cat_nam` varchar(22) NOT NULL							COMMENT 'TBird Category Name',
  `cat_pri` int(3) NOT NULL								COMMENT 'TBird Category Priority',
  `cat_src` varchar(222) NOT NULL						COMMENT 'TBird Category Source Dir/Folder',
  PRIMARY KEY (`cat_idx`)
)																	COMMENT 'TBird Rules Category Table';

-- Dumping data for table `tb_cat`

-- End data dump

-- Table structure for table `tb_xref`
DROP TABLE IF EXISTS `tb_xref`;
CREATE TABLE IF NOT EXISTS `tb_xref` (
  `xrf_idx` int(11) NOT NULL auto_increment			COMMENT 'Unique XRef Record',
  `xrf_cdx` int(11) NOT NULL								COMMENT 'XRef to Profiles Table',
  `xrf_pdx` int(11) NOT NULL								COMMENT 'XRef to Profiles Table',
  `xrf_rdx` int(11) NOT NULL								COMMENT 'XRef to Rules Table',
  PRIMARY KEY (`xrf_idx`,`xrf_pdx`,`xrf_rdx`)
)																	COMMENT 'TBird Rules XRef Table';

-- Dumping data for table `tb_xref`

-- End data dump

-- Table structure for table `tb_rules`
DROP TABLE IF EXISTS `tb_rules`;
CREATE TABLE IF NOT EXISTS `tb_rules` (
  `rul_idx` int(11) NOT NULL auto_increment				COMMENT 'Unique TBird Profile Record',
  `rul_pdx` int(11) NOT NULL									COMMENT 'TBird Rule Parent ID',
  `rul_nam` varchar(30) NOT NULL DEFAULT ''				COMMENT 'TBird Rule Name',
  `rul_enb` enum('Yes','No') NOT NULL DEFAULT 'Yes'	COMMENT 'TBird Rule Enabled (Yes/No)',
  `rul_fld` varchar(35) NOT NULL DEFAULT ''				COMMENT 'TBird Rule Dir/Folder Name',
  `rul_typ` int(2) NOT NULL DEFAULT 0						COMMENT 'TBird Rule Type (Number)',
  `rul_pri` varchar(12) NOT NULL DEFAULT ''				COMMENT 'TBird Rule Priority',
  PRIMARY KEY (`rul_idx`)
)																		COMMENT 'TBird Rules Table';

-- Dumping data for table `tb_rules`

-- End data dump

-- Explanation:
-- This table is designed for current and future TBird Rules capabilites
-- Field Explanations:
-- Title 		==>	Name,
-- Value 		==>	Action taken or Dir/Folder to write, copy, move email to.
-- Condition	==>	The condition that triggers the action (The actual rule).
-- Folder		==>	Rules Folder - Works with the "Parent ID" in the rules
--							table to allow rule directories and sub-directories.
-- Priority		==>	The subpriority that the action runs on when mulitple
--							actions are being run on the same rule (from the rules table).
-- Source		==>	Source Dir/Folder, allows running against non-INBOX folders
--							when rules run automatically.
-- Table structure for table `tb_acts`
DROP TABLE IF EXISTS `tb_acts`;
CREATE TABLE IF NOT EXISTS `tb_acts` (
  `act_idx` int(11) NOT NULL auto_increment				COMMENT 'Unique TBird Profile Record',
  `act_rdx` int(11) NOT NULL									COMMENT 'XRef to Rules Table',
  `act_act` varchar(36) NOT NULL DEFAULT ''				COMMENT 'TBird Action Title',
  `act_avl` varchar(255) NOT NULL DEFAULT ''			COMMENT 'TBird Action Value',
  `act_cnd` varchar(255) NOT NULL DEFAULT ''			COMMENT 'TBird Action Condition',
  `act_fld` varchar(35) NOT NULL DEFAULT ''				COMMENT 'TBird Action Dir/Folder Name',
  `act_pri` varchar(12) NOT NULL DEFAULT ''				COMMENT 'TBird Priority',
  `act_src` varchar(255) NOT NULL DEFAULT ''			COMMENT 'TBird Action Source',
  PRIMARY KEY (`act_idx`)
)																		COMMENT 'TBird Rules Action Table';

-- Dumping data for table `tb_acts`

-- End data dump