-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.15-nt


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

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema ireland
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ ireland;
USE ireland;

--
-- Table structure for table `ireland`.`auditdetails`
--

DROP TABLE IF EXISTS `auditdetails`;
CREATE TABLE `auditdetails` (
  `AuditID` int(10) unsigned NOT NULL auto_increment,
  `Action` varchar(45) NOT NULL default '',
  `ActionDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `ActionDetails` varchar(100) default NULL,
  `AuditType` varchar(20) NOT NULL default '',
  `ActionUser` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`AuditID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`auditdetails`
--

/*!40000 ALTER TABLE `auditdetails` DISABLE KEYS */;
/*!40000 ALTER TABLE `auditdetails` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`calledfigures`
--

DROP TABLE IF EXISTS `calledfigures`;
CREATE TABLE `calledfigures` (
  `CalledID` int(10) unsigned NOT NULL auto_increment,
  `WeekNumber` int(10) unsigned NOT NULL default '0',
  `ProductID` int(10) unsigned NOT NULL default '0',
  `LicenseNumber` int(10) unsigned NOT NULL default '0',
  `CalledAmount` double default NULL,
  `Year` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`CalledID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;

--
-- Dumping data for table `ireland`.`calledfigures`
--

/*!40000 ALTER TABLE `calledfigures` DISABLE KEYS */;
INSERT INTO `calledfigures` (`CalledID`,`WeekNumber`,`ProductID`,`LicenseNumber`,`CalledAmount`,`Year`) VALUES 
 (1,32,10,2045,90,2005),
 (2,32,8,2045,7928,2005),
 (3,32,9,2045,3982,2005),
 (4,32,7,2045,4437,2005),
 (5,32,10,10890,89,2005),
 (6,32,9,10890,5839,2005),
 (7,32,8,10890,5499,2005),
 (8,32,7,10890,2005,2005),
 (10,32,10,14198,100,2005),
 (11,32,9,14198,2100,2005),
 (12,32,8,14198,3100,2005),
 (13,32,7,14198,4100,2005),
 (14,32,10,13943,41,2005),
 (15,32,9,13943,2241,2005),
 (16,32,8,13943,2641,2005),
 (17,32,7,13943,4641,2005),
 (18,32,10,12215,46,2005),
 (19,32,9,12215,1146,2005),
 (20,32,8,12215,4146,2005),
 (21,32,7,12215,3146,2005),
 (22,32,10,14360,36,2005),
 (23,32,9,14360,1236,2005),
 (24,32,8,14360,4236,2005),
 (25,32,7,14360,423,2005),
 (26,32,10,14251,43,2005),
 (27,32,9,14251,5543,2005),
 (28,32,8,14251,554,2005),
 (29,32,7,14251,1554,2005),
 (30,50,1,111,1040,2005),
 (31,50,1,111,1040,2005),
 (32,50,1,111,1040,2005),
 (33,51,2,1211,2040,2005);
/*!40000 ALTER TABLE `calledfigures` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`calledfigureshistory`
--

DROP TABLE IF EXISTS `calledfigureshistory`;
CREATE TABLE `calledfigureshistory` (
  `CalledID` int(10) unsigned NOT NULL default '0',
  `WeekNumber` int(10) unsigned NOT NULL default '0',
  `ProductID` int(10) unsigned NOT NULL default '0',
  `StaffID` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`CalledID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`calledfigureshistory`
--

/*!40000 ALTER TABLE `calledfigureshistory` DISABLE KEYS */;
/*!40000 ALTER TABLE `calledfigureshistory` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`datarules`
--

DROP TABLE IF EXISTS `datarules`;
CREATE TABLE `datarules` (
  `DivisionID` int(10) unsigned NOT NULL default '0',
  `RuleName` varchar(20) NOT NULL default '',
  `RuleOperator` varchar(10) default NULL,
  `RuleValue` varchar(45) default NULL,
  `RuleType` varchar(45) default NULL,
  `RuleOption` varchar(45) default NULL,
  PRIMARY KEY  (`DivisionID`,`RuleName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`datarules`
--

/*!40000 ALTER TABLE `datarules` DISABLE KEYS */;
INSERT INTO `datarules` (`DivisionID`,`RuleName`,`RuleOperator`,`RuleValue`,`RuleType`,`RuleOption`) VALUES 
 (1,'Bronze Score','>=','1000','',''),
 (1,'Gold Score','>=','1800','',''),
 (1,'InField','>=','65',NULL,NULL),
 (1,'Platinum Score','>=','2200','',''),
 (1,'Silver Score','>=','1500','',''),
 (1,'TotalNewSales','Sum','1,2,3,4,5','','ProductID'),
 (2,'Bronze Score','>=','1000','',''),
 (2,'Double Gold Score','>=','3000','',''),
 (2,'Gold Score','>=','1800','',''),
 (2,'InField','>=','65',NULL,NULL),
 (2,'Millennium Score','>=','2500','',''),
 (2,'Platinum Score','>=','2200','',''),
 (2,'Silver Score','>=','1500','',''),
 (2,'TotalNewSales','Sum','7,8,9',NULL,'ProductID');
/*!40000 ALTER TABLE `datarules` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`districts`
--

DROP TABLE IF EXISTS `districts`;
CREATE TABLE `districts` (
  `DistrictID` int(10) unsigned NOT NULL auto_increment,
  `DistrictName` varchar(45) NOT NULL default '',
  `DistrictRep` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`DistrictID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`districts`
--

/*!40000 ALTER TABLE `districts` DISABLE KEYS */;
INSERT INTO `districts` (`DistrictID`,`DistrictName`,`DistrictRep`) VALUES 
 (1,'Connaught Champions',0),
 (2,'Celtic Tigers',0),
 (3,'Southern Stars',0),
 (4,'Bravehearts',0),
 (5,'Commitments',0),
 (6,'Formula One\'s',0),
 (7,'Gladiators',0),
 (8,'Warriors Accident',0),
 (9,'Millenium Stars',0),
 (10,'Pioneers',0),
 (11,'The Specialists',0),
 (12,'True Champions',0),
 (13,'Diamonds Healthcare',0);
/*!40000 ALTER TABLE `districts` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`divisions`
--

DROP TABLE IF EXISTS `divisions`;
CREATE TABLE `divisions` (
  `DivisionID` int(10) unsigned NOT NULL default '0',
  `DivisionName` varchar(45) NOT NULL default '',
  `DivisionManager` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`DivisionID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`divisions`
--

/*!40000 ALTER TABLE `divisions` DISABLE KEYS */;
INSERT INTO `divisions` (`DivisionID`,`DivisionName`,`DivisionManager`) VALUES 
 (1,'Accident',0),
 (2,'Healthcare',0),
 (3,'Service Agents',0);
/*!40000 ALTER TABLE `divisions` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`divisionstatics`
--

DROP TABLE IF EXISTS `divisionstatics`;
CREATE TABLE `divisionstatics` (
  `StaticID` int(10) unsigned NOT NULL auto_increment,
  `DivisionID` int(10) unsigned NOT NULL default '0',
  `StaticName` varchar(45) NOT NULL default '',
  `StaticValue` varchar(45) NOT NULL default '',
  `StaticValue2` varchar(45) default NULL,
  PRIMARY KEY  (`StaticID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`divisionstatics`
--

/*!40000 ALTER TABLE `divisionstatics` DISABLE KEYS */;
INSERT INTO `divisionstatics` (`StaticID`,`DivisionID`,`StaticName`,`StaticValue`,`StaticValue2`) VALUES 
 (1,2,'Manpower Available Total','1420',NULL),
 (2,2,'Manpower in Field Total','1225',NULL),
 (3,2,'Winner Score','Bronze','1000'),
 (4,2,'Winner Score','Silver','1500'),
 (5,2,'Winner Score','Gold','1800'),
 (6,2,'Winner Score','Platinum','2200'),
 (7,2,'Winner Score','Millennium','2500'),
 (8,2,'Winner Score','Double Gold','3000');
/*!40000 ALTER TABLE `divisionstatics` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`products`
--

DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
  `ProductID` int(10) unsigned NOT NULL auto_increment,
  `ProductName` varchar(45) NOT NULL default '',
  `DivisionID` int(10) unsigned NOT NULL default '0',
  `SalesFactor` varchar(10) NOT NULL default '' COMMENT 'LeadCold',
  `CashPlan` varchar(10) NOT NULL default '' COMMENT 'MonthlyQuarterlySemi',
  `Commission` int(10) unsigned NOT NULL default '0' COMMENT 'Commision Level',
  PRIMARY KEY  (`ProductID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`products`
--

/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` (`ProductID`,`ProductName`,`DivisionID`,`SalesFactor`,`CashPlan`,`Commission`) VALUES 
 (1,'AHBP',1,'','Monthly',200),
 (2,'AHBP',1,'','Quarterly',30),
 (3,'AHBP',1,'','Semi Ann',30),
 (4,'ADP',1,'Lead','',30),
 (5,'ADP',1,'Cold','',150),
 (6,'Renewals',1,'','',25),
 (7,'C5',2,'','',40),
 (8,'SHIP',2,'','',50),
 (9,'HAP',2,'','',60);
/*!40000 ALTER TABLE `products` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`regions`
--

DROP TABLE IF EXISTS `regions`;
CREATE TABLE `regions` (
  `RegionID` int(10) unsigned NOT NULL auto_increment,
  `RegionName` varchar(45) NOT NULL default '',
  `RegionManager` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`RegionID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`regions`
--

/*!40000 ALTER TABLE `regions` DISABLE KEYS */;
INSERT INTO `regions` (`RegionID`,`RegionName`,`RegionManager`) VALUES 
 (1,'Diamond',0),
 (2,'Premier',0),
 (3,'Supreme',0),
 (4,'Top Performers',0),
 (5,'Supreme',0);
/*!40000 ALTER TABLE `regions` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`regionstatics`
--

DROP TABLE IF EXISTS `regionstatics`;
CREATE TABLE `regionstatics` (
  `StaticID` int(10) unsigned NOT NULL auto_increment,
  `RegionID` int(10) unsigned NOT NULL default '0',
  `StaticName` varchar(45) NOT NULL default '',
  `StaticValue` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`StaticID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`regionstatics`
--

/*!40000 ALTER TABLE `regionstatics` DISABLE KEYS */;
INSERT INTO `regionstatics` (`StaticID`,`RegionID`,`StaticName`,`StaticValue`) VALUES 
 (1,2,'Manpower in Field Total','1225'),
 (2,2,'Manpower Available Total','1400');
/*!40000 ALTER TABLE `regionstatics` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`salesdata`
--

DROP TABLE IF EXISTS `salesdata`;
CREATE TABLE `salesdata` (
  `LicenseNumber` int(10) unsigned NOT NULL default '0',
  `WeekNumber` int(10) unsigned NOT NULL default '0',
  `Year` int(10) unsigned NOT NULL default '0',
  `TotalSales` double NOT NULL default '0',
  `StringType` varchar(20) default NULL,
  `StringLevel` int(10) unsigned default '0',
  `Available` int(10) unsigned NOT NULL default '0',
  `Infield` int(10) unsigned NOT NULL default '0',
  `Commission` double NOT NULL default '0',
  `Override` int(10) unsigned NOT NULL default '0' COMMENT 'If set then some variables not calculated but are overridden\r\n',
  `WinnerScore` varchar(20) default NULL,
  `Amnesty` int(10) unsigned default '0',
  `SalesDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `YearWeek` int(10) unsigned NOT NULL default '0' COMMENT 'Combination field for search on a unique week.',
  `SalesCredit` double NOT NULL default '0',
  `OutofTerritory` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`LicenseNumber`,`WeekNumber`,`Year`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`salesdata`
--

/*!40000 ALTER TABLE `salesdata` DISABLE KEYS */;
INSERT INTO `salesdata` (`LicenseNumber`,`WeekNumber`,`Year`,`TotalSales`,`StringType`,`StringLevel`,`Available`,`Infield`,`Commission`,`Override`,`WinnerScore`,`Amnesty`,`SalesDate`,`YearWeek`,`SalesCredit`,`OutofTerritory`) VALUES 
 (12215,28,2005,1213,'Silver',1,1,1,1200,0,'Silver',0,'2005-05-22 00:00:00',200528,0,0),
 (12215,29,2005,1813,'Gold',1,1,1,1200,0,'Gold',0,'2005-05-29 00:00:00',200529,0,0),
 (12215,30,2005,1913,'Gold',2,1,1,1200,0,'Gold',0,'2005-06-06 00:00:00',200530,0,0),
 (12215,31,2005,1613,'Silver',3,1,1,1200,0,'Silver',0,'2005-06-13 00:00:00',200531,0,0),
 (12215,32,2005,1213,'Bronze',5,1,1,1200,0,'Bronze',1,'2005-06-20 00:00:00',200532,0,0),
 (12215,33,2005,1513,'Silver',1,1,1,1200,0,'Silver',0,'2005-06-27 00:00:00',200533,0,0),
 (12215,34,2005,1413,'',0,1,1,1200,0,'Silver',0,'2005-07-05 00:00:00',200534,0,0);
/*!40000 ALTER TABLE `salesdata` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`saleslocations`
--

DROP TABLE IF EXISTS `saleslocations`;
CREATE TABLE `saleslocations` (
  `WeekNumber` int(10) unsigned NOT NULL default '0',
  `Year` int(10) unsigned NOT NULL default '0',
  `DivisionID` int(10) unsigned NOT NULL default '0',
  `DivisionManager` int(10) unsigned default '0',
  `RegionID` int(10) unsigned default '0',
  `RegionManager` int(10) unsigned default '0',
  `DistrictID` int(10) unsigned default '0',
  `DistrictRep` int(10) unsigned default '0',
  `TerritoryID` int(10) unsigned default '0',
  `AreaRep` int(10) unsigned default '0',
  `TerritoryRep` int(10) unsigned default '0',
  `CalledID` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`WeekNumber`,`Year`),
  KEY `FK_saleslocations_1` (`CalledID`),
  CONSTRAINT `FK_saleslocations_1` FOREIGN KEY (`CalledID`) REFERENCES `calledfigures` (`CalledID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`saleslocations`
--

/*!40000 ALTER TABLE `saleslocations` DISABLE KEYS */;
/*!40000 ALTER TABLE `saleslocations` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`staffstartvalues`
--

DROP TABLE IF EXISTS `staffstartvalues`;
CREATE TABLE `staffstartvalues` (
  `License` int(10) unsigned NOT NULL auto_increment,
  `DataName` varchar(45) NOT NULL default '',
  `DataValue` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`License`,`DataName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`staffstartvalues`
--

/*!40000 ALTER TABLE `staffstartvalues` DISABLE KEYS */;
INSERT INTO `staffstartvalues` (`License`,`DataName`,`DataValue`) VALUES 
 (12215,'Bronze','43'),
 (12215,'Gold','10'),
 (12215,'Silver','14'),
 (12215,'StringType','Gold');
/*!40000 ALTER TABLE `staffstartvalues` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`systemstatics`
--

DROP TABLE IF EXISTS `systemstatics`;
CREATE TABLE `systemstatics` (
  `StaticID` int(10) unsigned NOT NULL auto_increment,
  `StaticName` varchar(45) NOT NULL default '',
  `StaticValue` varchar(45) NOT NULL default '',
  `StaticType` varchar(20) NOT NULL default '',
  `ModDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `ModBy` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`StaticID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`systemstatics`
--

/*!40000 ALTER TABLE `systemstatics` DISABLE KEYS */;
/*!40000 ALTER TABLE `systemstatics` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`territories`
--

DROP TABLE IF EXISTS `territories`;
CREATE TABLE `territories` (
  `TerritoryID` int(10) unsigned NOT NULL auto_increment,
  `TerritoryName` varchar(45) default NULL,
  `AreaRep` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`TerritoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`territories`
--

/*!40000 ALTER TABLE `territories` DISABLE KEYS */;
INSERT INTO `territories` (`TerritoryID`,`TerritoryName`,`AreaRep`) VALUES 
 (1,'Ireland 17',0),
 (2,'Ireland 22',0);
/*!40000 ALTER TABLE `territories` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`territoryreps`
--

DROP TABLE IF EXISTS `territoryreps`;
CREATE TABLE `territoryreps` (
  `TerritoryID` int(10) unsigned NOT NULL default '0',
  `LicenseNumber` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`TerritoryID`,`LicenseNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`territoryreps`
--

/*!40000 ALTER TABLE `territoryreps` DISABLE KEYS */;
INSERT INTO `territoryreps` (`TerritoryID`,`LicenseNumber`) VALUES 
 (1,13943),
 (1,14198),
 (2,12215),
 (2,14251),
 (2,14360);
/*!40000 ALTER TABLE `territoryreps` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`testaudt`
--

DROP TABLE IF EXISTS `testaudt`;
CREATE TABLE `testaudt` (
  `idtestAudt` int(10) unsigned NOT NULL auto_increment,
  `Msg` varchar(45) NOT NULL,
  PRIMARY KEY  (`idtestAudt`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ireland`.`testaudt`
--

/*!40000 ALTER TABLE `testaudt` DISABLE KEYS */;
INSERT INTO `testaudt` (`idtestAudt`,`Msg`) VALUES 
 (1,'Another Trigger on CalledFigures');
/*!40000 ALTER TABLE `testaudt` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`useraccess`
--

DROP TABLE IF EXISTS `useraccess`;
CREATE TABLE `useraccess` (
  `StaffID` int(10) unsigned NOT NULL default '0',
  `GroupName` varchar(20) NOT NULL default '',
  `UserName` varchar(20) NOT NULL default '',
  `Password` varchar(20) NOT NULL default '',
  `PasswordDate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`StaffID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Staff Access Details';

--
-- Dumping data for table `ireland`.`useraccess`
--

/*!40000 ALTER TABLE `useraccess` DISABLE KEYS */;
/*!40000 ALTER TABLE `useraccess` ENABLE KEYS */;


--
-- Table structure for table `ireland`.`workforce`
--

DROP TABLE IF EXISTS `workforce`;
CREATE TABLE `workforce` (
  `LicenseNumber` int(10) unsigned NOT NULL default '0',
  `Firstname` varchar(45) NOT NULL default '',
  `Surname` varchar(45) NOT NULL default '',
  `emailaddress` varchar(60) default NULL,
  `telephonenumber` varchar(15) default NULL,
  `mobilenumber` varchar(15) default NULL,
  `Address1` varchar(45) default NULL,
  `Address2` varchar(45) default NULL,
  `TownCity` varchar(25) default NULL,
  `County` varchar(25) default NULL,
  `Country` varchar(20) default NULL,
  `Postcode` varchar(10) default NULL,
  `StaffPosition` varchar(10) default NULL,
  `StaffID` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`LicenseNumber`),
  KEY `Index_2` (`StaffID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='All data relating to staff members';

--
-- Dumping data for table `ireland`.`workforce`
--

/*!40000 ALTER TABLE `workforce` DISABLE KEYS */;
INSERT INTO `workforce` (`LicenseNumber`,`Firstname`,`Surname`,`emailaddress`,`telephonenumber`,`mobilenumber`,`Address1`,`Address2`,`TownCity`,`County`,`Country`,`Postcode`,`StaffPosition`,`StaffID`) VALUES 
 (211,'Tom','Beary','TomBeary@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','RM',1),
 (267,'Tom','Butler','tb@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','RM',2),
 (312,'TJ','O\'Dea','TJ@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','RM',3),
 (346,'Linda','Joyce','Linda@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','RM',4),
 (382,'Ger','Noonan','Ger@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','RM',5),
 (545,'Micheal','Meanay','mm@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','DR',6),
 (785,'PJ','Harrington','pjh@coombined.ie','056 4455332','086 67473832',NULL,NULL,NULL,NULL,NULL,NULL,'',19),
 (2045,'Alan','Naughton','al@home.ie','078 4848458','086 484848',NULL,NULL,NULL,NULL,NULL,NULL,'',7);
INSERT INTO `workforce` (`LicenseNumber`,`Firstname`,`Surname`,`emailaddress`,`telephonenumber`,`mobilenumber`,`Address1`,`Address2`,`TownCity`,`County`,`Country`,`Postcode`,`StaffPosition`,`StaffID`) VALUES 
 (2410,'Charlie','Mernagh','mm@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','DR',8),
 (6250,'Albert','Noonan','an@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','DR',9),
 (7669,'Alan','Walker','aw@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','DR',10),
 (7771,'William','O\'Mahony','wom@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','DR',11),
 (8200,'Tom','Corcoran','tc@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','DR',12),
 (8271,'Colin','Foran','cf@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','DR',13),
 (8991,'Finbarr','O\'Mahony','fom@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','DR',14),
 (10216,'Micheal','McLaughlin','mm@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','DR',15);
INSERT INTO `workforce` (`LicenseNumber`,`Firstname`,`Surname`,`emailaddress`,`telephonenumber`,`mobilenumber`,`Address1`,`Address2`,`TownCity`,`County`,`Country`,`Postcode`,`StaffPosition`,`StaffID`) VALUES 
 (10337,'Peter','Conboy','pc@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','DR',16),
 (10890,'Rob','Doyle','rob@wdp.ie','048484848','988707','jkhjkjh','jhjkh','jhjkhk','kjjkh','kjjkh',NULL,'AR',18),
 (11066,'Aisling','Deegan','ad@Combined.ie','064 453422','086 2424564','10 Main St','','Mallow','Cork','Ireland','','DR',17),
 (12215,'Irene','Kissach','ik@coombined.ie','056 4455332','086 67473832',NULL,NULL,NULL,NULL,NULL,NULL,'',20),
 (13943,'Eamonn','Flynn','ef@coombined.ie','056 4455332','086 67473832',NULL,NULL,NULL,NULL,NULL,NULL,'',23),
 (14198,'Brendan','Molloy','bm@coombined.ie','056 4455332','086 67473832',NULL,NULL,NULL,NULL,NULL,NULL,'',24),
 (14251,'Alison','Cowan','ac@coombined.ie','056 4455332','086 67473832',NULL,NULL,NULL,NULL,NULL,NULL,'',21),
 (14360,'Heather','Bradshaw','hb@coombined.ie','056 4455332','086 67473832',NULL,NULL,NULL,NULL,NULL,NULL,'',22);
/*!40000 ALTER TABLE `workforce` ENABLE KEYS */;


--
-- View structure for view `ireland`.`testview`
--

DROP VIEW IF EXISTS `testview`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `ireland`.`testview` AS select `ireland`.`calledfigures`.`CalledID` AS `CalledID`,`ireland`.`calledfigures`.`WeekNumber` AS `WeekNumber`,`ireland`.`calledfigures`.`ProductID` AS `ProductID`,`ireland`.`calledfigures`.`LicenseNumber` AS `LicenseNumber`,`ireland`.`calledfigures`.`CalledAmount` AS `CalledAmount`,`ireland`.`calledfigures`.`Year` AS `Year` from `ireland`.`calledfigures`;

--
-- Create schema webreporter
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ webreporter;
USE webreporter;

--
-- Table structure for table `webreporter`.`databaseaudit`
--

DROP TABLE IF EXISTS `databaseaudit`;
CREATE TABLE `databaseaudit` (
  `AuditTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `DatabaseUser` varchar(45) NOT NULL default '',
  `AuditType` varchar(45) NOT NULL default '',
  `AuditFunction` varchar(45) NOT NULL default '',
  `AuditTable` varchar(45) NOT NULL default '',
  `AuditColumn` varchar(45) NOT NULL default '',
  `OldValue` varchar(200) NOT NULL default '',
  `NewValue` varchar(200) NOT NULL default ''
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;

--
-- Dumping data for table `webreporter`.`databaseaudit`
--

/*!40000 ALTER TABLE `databaseaudit` DISABLE KEYS */;
INSERT INTO `databaseaudit` (`AuditTime`,`DatabaseUser`,`AuditType`,`AuditFunction`,`AuditTable`,`AuditColumn`,`OldValue`,`NewValue`) VALUES 
 ('2005-10-27 00:00:00','root@localhost','TRIGGER','INSERT','CalledFigures','CalledID','','0'),
 ('2005-10-27 16:47:03','root@localhost','TRIGGER','INSERT','CalledFigures','CalledID','','0'),
 ('2005-10-27 16:47:03','root@localhost','TRIGGER','INSERT','CalledFigures','WeekNumber','','51'),
 ('2005-10-27 16:47:03','root@localhost','TRIGGER','INSERT','CalledFigures','ProductID','','2'),
 ('2005-10-27 16:47:03','root@localhost','TRIGGER','INSERT','CalledFigures','LicenseNumber','','1211'),
 ('2005-10-27 16:47:03','root@localhost','TRIGGER','INSERT','CalledFigures','CalledAmount','','2040'),
 ('2005-10-27 16:47:03','root@localhost','TRIGGER','INSERT','CalledFigures','Year','','2005');
/*!40000 ALTER TABLE `databaseaudit` ENABLE KEYS */;


--
-- Table structure for table `webreporter`.`sqlaudit`
--

DROP TABLE IF EXISTS `sqlaudit`;
CREATE TABLE `sqlaudit` (
  `AuditTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `AuditType` varchar(45) NOT NULL default '',
  `AuditUser` varchar(45) NOT NULL default '',
  `AuditSQL` varchar(2000) NOT NULL default '',
  `AuditMsg` varchar(200) NOT NULL default ''
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;

--
-- Dumping data for table `webreporter`.`sqlaudit`
--

/*!40000 ALTER TABLE `sqlaudit` DISABLE KEYS */;
/*!40000 ALTER TABLE `sqlaudit` ENABLE KEYS */;


--
-- Table structure for table `webreporter`.`systemaudit`
--

DROP TABLE IF EXISTS `systemaudit`;
CREATE TABLE `systemaudit` (
  `AuditTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `AuditType` varchar(20) NOT NULL default '',
  `AuditUser` varchar(45) NOT NULL default '',
  `AuditIP` varchar(15) NOT NULL default '',
  `Loglevel` int(10) unsigned NOT NULL default '0',
  `AuditFunction` varchar(45) NOT NULL default '',
  `AuditMsg` varchar(200) NOT NULL default ''
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;

--
-- Dumping data for table `webreporter`.`systemaudit`
--

/*!40000 ALTER TABLE `systemaudit` DISABLE KEYS */;
/*!40000 ALTER TABLE `systemaudit` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;