-- phpMyAdmin SQL Dump
-- version 3.2.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 30, 2010 at 03:50 PM
-- Server version: 5.1.43
-- PHP Version: 5.3.1

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

--
-- Database: `moprofiles`
--

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

--
-- Table structure for table `opm_design`
--

CREATE TABLE IF NOT EXISTS `opm_design` (
  `design_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `design_name` varchar(100) CHARACTER SET utf8 NOT NULL,
  `design_content` text CHARACTER SET utf8 NOT NULL,
  `design_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`design_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `opm_design`
--

INSERT INTO `opm_design` (`design_id`, `design_name`, `design_content`, `design_modified`) VALUES
(1, 'New design', '<div class="spacer ui-droppable">DROP PAGE HERE</div><div class="page active">\n	<div id="logo">temp. logo will go here</div>\n\n	<header class="small">\n		<h1 style="" class="editable GENTICS_editable" contenteditable="true">New page</h1>\n		<h2>BRIEFING</h2>\n	</header>\n\n	<aside>\n\n		<time>SEPT 2010</time>\n\n		<p class="link"><strong>For more Briefings visit<br>\n		www.mourantozannes.com</strong></p>\n\n		<p>\n			The information contained in this client information release is intended as a general guide only.\n			The contents are not intended as a substitute for formal legal advice and should be interpreted accordingly.\n		</p>\n		<p>\n			Formal legal advice in all relevant areas should be sought before relying on any of the information contained in this release.\n		</p>\n\n	</aside>\n\n	<section style="" class="glossary editable GENTICS_editable context" contenteditable="true">\n		<dl>\n			<dt>A title<br></dt>\n			<dd>this is the descriot<br>dsjk fsdjfoisa jfasCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg df<br>Copysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg df</dd>\n			<hr class="clearfix">\n		<dt>Another item<br></dt><dd>Description Copysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg df</dd><hr class="clearfix"><dt>hmmm</dt><dd>Descriptionf ds ds gd gdfs<br></dd><hr class="clearfix"></dl>\n	</section>\n\n	<footer>\n		<p class="url"><strong>mourantozannes.com</strong></p>\n		<p class="locations">Cayman Guernsey Jersey London</p>\n	</footer>\n\n</div><div class="spacer ui-droppable">DROP PAGE HERE</div><div class="page">\n\n	<div id="logo">temp. logo will go here</div>\n\n	<header class="small">\n		<h1 style="" class="editable GENTICS_editable" contenteditable="true">New page</h1>\n		<h2>BRIEFING</h2>\n	</header>\n\n	<aside>\n\n		<time>SEPT 2010</time>\n\n		<p class="link"><strong>For more Briefings visit<br>\n		www.mourantozannes.com</strong></p>\n\n		<p>\n			The information contained in this client information release is intended as a general guide only.\n			The contents are not intended as a substitute for formal legal advice and should be interpreted accordingly.\n		</p>\n		<p>\n			Formal legal advice in all relevant areas should be sought before relying on any of the information contained in this release.\n		</p>\n\n	</aside>\n\n	<section style="height: 614px;" class="columns main editable GENTICS_editable" contenteditable="true">\n		<p>Copysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg dfCopysdfh sdu fs fhsf hskjd hfjsd hfjsdh&nbsp; dhfjsd hfjsdh jsdhfsdfj s dhfjshfsd hfasg df</p>\n	</section>\n\n	<section style="" class="footnote editable GENTICS_editable" contenteditable="true">\n		<p>Footnote</p>\n	</section>\n\n	<footer>\n		<p class="url"><strong>mourantozannes.com</strong></p>\n\n		<p class="locations">Cayman Guernsey Jersey London</p>\n	</footer>\n</div><div class="spacer ui-droppable">DROP PAGE HERE</div><div class="page">\n	<div id="logo">temp. logo will go here</div>\n\n	<header class="small">\n		<h1 style="" class="editable GENTICS_editable" contenteditable="true">New page yay<br></h1>\n		<h2>BRIEFING</h2>\n	</header>\n\n	<aside>\n\n		<time>SEPT 2010</time>\n\n		<p class="link"><strong>For more Briefings visit<br>\n		www.mourantozannes.com</strong></p>\n\n		<p>\n			The information contained in this client information release is intended as a general guide only.\n			The contents are not intended as a substitute for formal legal advice and should be interpreted accordingly.\n		</p>\n		<p>\n			Formal legal advice in all relevant areas should be sought before relying on any of the information contained in this release.\n		</p>\n\n	</aside>\n\n	<section class="profiles ui-sortable">\n	<li style="display: inline-block;" id="85" class="profile clearfix ui-draggable"><img src="images/portraits/Alison-Wood.jpg" width="60" height="68">Alison Wood Private Client <a href="#" class="delete noprint">Remove</a></li><li style="display: inline-block;" id="103" class="profile clearfix ui-draggable"><img src="images/portraits/Andrea-Holford.jpg" width="60" height="68">Andrea Holford Litigation <a href="#" class="delete noprint">Remove</a></li><li style="display: inline-block;" id="35" class="profile clearfix ui-draggable"><img src="images/portraits/Andrew-Bridgeford.jpg" width="60" height="68">Andrew Bridgeford Corporate  <a href="#" class="delete noprint">Remove</a></li><li style="display: inline-block;" id="35" class="profile clearfix ui-draggable"><img src="images/portraits/Andrew-Bridgeford.jpg" width="60" height="68">Andrew Bridgeford Corporate  <a href="#" class="delete noprint">Remove</a></li></section>\n\n	<footer>\n		<p class="url"><strong>mourantozannes.com</strong></p>\n		<p class="locations">Cayman Guernsey Jersey London</p>\n	</footer>\n\n</div><div class="spacer ui-droppable">DROP PAGE HERE</div>', '2010-08-30 15:37:23'),
(2, 'New design', '<div class="spacer ui-droppable">DROP PAGE HERE</div><div class="page">\n	<div id="logo">temp. logo will go here</div>\n\n	<header class="tall">\n		<h1 style="" class="editable GENTICS_editable GENTICS_editable_highlight" contenteditable="true">New pageg dfgd<br></h1>\n		<h2>BRIEFING</h2>\n	</header>\n\n	<aside>\n\n		<time>SEPT 2010</time>\n\n		<p class="link"><strong>For more Briefings visit<br>\n		www.mourantozannes.com</strong></p>\n\n		<p>\n			The information contained in this client information release is intended as a general guide only.\n			The contents are not intended as a substitute for formal legal advice and should be interpreted accordingly.\n		</p>\n		<p>\n			Formal legal advice in all relevant areas should be sought before relying on any of the information contained in this release.\n		</p>\n\n	</aside>\n\n	<section style="" class="glossary editable GENTICS_editable GENTICS_editable_highlight" contenteditable="true">\n		<dl>\n			<dt><b>Titlesdfsd </b>f<br></dt>\n			<dd>Descriptiondf sfsd<br></dd>\n			<hr class="clearfix">\n		<dt>Titlesd fsdfsdf <br></dt><dd>Descriptionfsd f<br><br>sd<br>f<br>sdf<br>sd<br>fsd<br>f<br>dfsf<br></dd><hr class="clearfix"><dt>Title</dt><dd>Descriptiong <b>dfgdf</b><br></dd><hr class="clearfix"></dl>\n	</section>\n\n	<footer>\n		<p class="url"><strong>mourantozannes.com</strong></p>\n		<p class="locations">Cayman Guernsey Jersey London</p>\n	</footer>\n\n</div><div class="spacer ui-droppable">DROP PAGE HERE</div><div class="page active">\n	<div id="logo">temp. logo will go here</div>\n\n	<header class="small">\n		<h1 style="" class="editable GENTICS_editable GENTICS_editable_highlight" contenteditable="true">New page</h1>\n		<h2>BRIEFING</h2>\n	</header>\n\n	<aside>\n\n		<time>SEPT 2010</time>\n\n		<p class="link"><strong>For more Briefings visit<br>\n		www.mourantozannes.com</strong></p>\n\n		<p>\n			The information contained in this client information release is intended as a general guide only.\n			The contents are not intended as a substitute for formal legal advice and should be interpreted accordingly.\n		</p>\n		<p>\n			Formal legal advice in all relevant areas should be sought before relying on any of the information contained in this release.\n		</p>\n\n	</aside>\n\n	<section class="profiles context ui-sortable">\n	<li style="display: inline-block;" id="94" class="profile clearfix ui-draggable"><img src="images/portraits/Abel-Lyall.jpg" width="60" height="68">Abel Lyall New profile <a href="#" class="delete noprint">Remove</a></li><li style="display: inline-block;" id="104" class="profile clearfix ui-draggable"><img src="images/portraits/Adam-Cole.jpg" width="60" height="68">Adam Cole Litigation <a href="#" class="delete noprint">Remove</a></li><li style="display: inline-block;" id="83" class="profile clearfix ui-draggable"><img src="images/portraits/Mark-Torode.jpg" width="60" height="68">Mark Torode Private Client <a href="#" class="delete noprint">Remove</a></li></section>\n\n	<footer>\n		<p class="url"><strong>mourantozannes.com</strong></p>\n		<p class="locations">Cayman Guernsey Jersey London</p>\n	</footer>\n\n</div><div class="spacer ui-droppable">DROP PAGE HERE</div><div class="page">\n	<div id="logo">temp. logo will go here</div>\n\n	<header class="small">\n		<h1 style="" class="editable GENTICS_editable GENTICS_editable_highlight" contenteditable="true">New pagedf gdf gd<br></h1>\n		<h2>BRIEFING</h2>\n	</header>\n\n	<aside>\n\n		<time>SEPT 2010</time>\n\n		<p class="link"><strong>For more Briefings visit<br>\n		www.mourantozannes.com</strong></p>\n\n		<p>\n			The information contained in this client information release is intended as a general guide only.\n			The contents are not intended as a substitute for formal legal advice and should be interpreted accordingly.\n		</p>\n		<p>\n			Formal legal advice in all relevant areas should be sought before relying on any of the information contained in this release.\n		</p>\n\n	</aside>\n\n	<section class="profiles ui-sortable">\n	<li style="display: inline-block;" id="66" class="profile clearfix ui-draggable"><img src="images/portraits/Abel-Lyall.jpg" width="60" height="68">Abel Lyall Litigation <a href="#" class="delete noprint">Remove</a></li><li style="display: inline-block;" id="94" class="profile clearfix ui-draggable"><img src="images/portraits/Abel-Lyall.jpg" width="60" height="68">Abel Lyall New profile <a href="#" class="delete noprint">Remove</a></li><li style="display: inline-block;" id="91" class="profile clearfix ui-draggable"><img src="images/portraits/Richard-Roberts.jpg" width="60" height="68">Richard Roberts Private Client <a href="#" class="delete noprint">Remove</a></li><li style="display: inline-block;" id="60" class="profile clearfix ui-draggable"><img src="images/portraits/Adrian-Brown.jpg" width="60" height="68">Adrian Brown Litigation <a href="#" class="delete noprint">Remove</a></li></section>\n\n	<footer>\n		<p class="url"><strong>mourantozannes.com</strong></p>\n		<p class="locations">Cayman Guernsey Jersey London</p>\n	</footer>\n\n</div><div class="spacer ui-droppable">DROP PAGE HERE</div><div class="page">\n\n	<div id="logo">temp. logo will go here</div>\n\n	<header class="small">\n		<h1 style="" class="editable GENTICS_editable GENTICS_editable_highlight" contenteditable="true">New page</h1>\n		<h2>BRIEFING</h2>\n	</header>\n\n	<aside>\n\n		<time>SEPT 2010</time>\n\n		<p class="link"><strong>For more Briefings visit<br>\n		www.mourantozannes.com</strong></p>\n\n		<p>\n			The information contained in this client information release is intended as a general guide only.\n			The contents are not intended as a substitute for formal legal advice and should be interpreted accordingly.\n		</p>\n		<p>\n			Formal legal advice in all relevant areas should be sought before relying on any of the information contained in this release.\n		</p>\n\n	</aside>\n\n	<section style="height: 572px; top: 247px;" class="columns main editable GENTICS_editable GENTICS_editable_highlight" contenteditable="true">\n		<p>Copy</p><p class="link"><strong>For more Briefings visit<br>\n		www.mourantozannes.com</strong></p>\n\n		<p>\n			The information contained in this client information release is intended as a general guide only.\n			The contents are not intended as a substitute for formal legal advice and should be interpreted accordingly.\n		</p>\n		<p>\n			Formal legal advice in all relevant areas should be sought before \nrelying on any of the information contained in this release.\n		</p><p class="link"><strong>For more Briefings visit<br>\n		www.mourantozannes.com</strong></p>\n\n		<p>\n			The information contained in this client information release is intended as a general guide only.\n			The contents are not intended as a substitute for formal legal advice and should be interpreted accordingly.\n		</p>\n		<p>\n			Formal legal advice in all relevant areas should be sought before \nrelying on any of the information contained in this release.\n		</p><p class="link"><strong>For more Briefings visit<br>\n		www.mourantozannes.com</strong></p>\n\n		<p>\n			The information contained in this client information release is intended as a general guide only.\n			The contents are not intended as a substitute for formal legal advice and should be interpreted accordingly.\n		</p>\n		<p>\n			Formal legal advice in all relevant areas should be sought before \nrelying on any of the information contained in this release.\n		</p><p class="link"><strong>For more Briefings visit<br>\n		www.mourantozannes.com</strong></p>\n\n		<p>\n			The information contained in this client information release is intended as a general guide only.\n			The contents are not intended as a substitute for formal legal advice and should be interpreted accordingly.\n		</p>\n		<p>\n			Formal legal advice in all relevant areas should be sought before \nrelying on any of the information contained in this release.\n		</p><p class="link"><strong>For more Briefings visit<br>\n		www.mourantozannes.com</strong></p>\n\n		<p>\n			The information contained in this client information release is intended as a general guide only.\n			The contents are not intended as a substitute for formal legal advice and should be interpreted accordingly.\n		</p>\n		<p>\n			Formal legal advice in all relevant areas should be sought before \nrelying on any of the information contained in this release.\n		</p>\n	</section>\n\n	<section style="top: 851px; height: 135px;" class="footnote editable GENTICS_editable GENTICS_editable_highlight" contenteditable="true">\n		<p>Footnote</p><p class="link"><strong>For more Briefings visit<br>\n		www.mourantozannes.com</strong></p>\n\n		<p>\n			The information contained in this client information release is intended as a general guide only.\n			The contents are not intended as a substitute for formal legal advice and should be interpreted accordingly.\n		</p>\n		<p>\n			Formal legal advice in all relevant areas should be sought before \nrelying on any of the information contained in this release.\n		</p><p class="link"><strong>For more Briefings visit<br>\n		www.mourantozannes.com</strong></p>\n\n		<p>\n			The information contained in this client information release is intended as a general guide only.\n			The contents are not intended as a substitute for formal legal advice and should be interpreted accordingly.\n		</p>\n		<p>\n			Formal legal advice in all relevant areas should be sought before \nrelying on any of the information contained in this release.\n		</p>\n	</section>\n\n	<footer>\n		<p class="url"><strong>mourantozannes.com</strong></p>\n\n		<p class="locations">Cayman Guernsey Jersey London</p>\n	</footer>\n</div><div class="spacer ui-droppable">DROP PAGE HERE</div>', '2010-08-30 15:43:57');

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

--
-- Table structure for table `opm_profile_person`
--

CREATE TABLE IF NOT EXISTS `opm_profile_person` (
  `person_id` mediumint(11) NOT NULL AUTO_INCREMENT,
  `person_name` varchar(100) NOT NULL,
  `person_title` varchar(100) NOT NULL,
  `person_email` varchar(100) NOT NULL,
  `person_tel` varchar(30) NOT NULL,
  `person_fax` varchar(30) NOT NULL,
  `person_photo` varchar(50) NOT NULL,
  PRIMARY KEY (`person_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=89 ;

--
-- Dumping data for table `opm_profile_person`
--

INSERT INTO `opm_profile_person` (`person_id`, `person_name`, `person_title`, `person_email`, `person_tel`, `person_fax`, `person_photo`) VALUES
(7, 'Paul Christopher', 'Partner', 'paul.christopher@ozannes.com', '+44 (0)1481 739311', '+44 (0)1481 713491', 'images/portraits/Paul-Christopher.jpg'),
(8, 'David Moore', 'Partner and Head of Corporate', 'david.moore@ozannes.com', '+44 (0)1481 731444', '+44 (0)1481 714653', 'images/portraits/David-Moore.jpg'),
(6, 'Peter Harwood', 'Consultant', 'peter.harwood@ozannes.com', '+44 (0)1481 731436', '+44 (0)1481 714653', 'images/portraits/Peter-Harwood.jpg'),
(9, 'Marcus Stone', 'Partner (Jersey)', 'marcus.stone@ozannes.com', '+44 (0)1534 784014', '+44 (0)1534 723465', 'images/portraits/Marcus-Stone.jpg'),
(10, 'Gavin Farrell', 'Partner', 'gavin.farrell@ozannes.com', '+44 (0)1481 731457', '+44 (0)1481 727964', 'images/portraits/Gavin-Farrell.jpg'),
(11, 'Mark Chambers', 'Partner (Jersey)', 'mark.chambers@ozannes.com', '+44 (0)1534 723466', '+44 (0)1534 723465', 'images/portraits/Mark-Chambers.jpg'),
(12, 'Andrew Walters', 'Partner', 'andrew.walters@ozannes.com', '+44 (0)1481 731454', '+44 (0)1481 714653', 'images/portraits/Andrew-Walters.jpg'),
(13, 'Helen Crossley', 'Senior Associate', 'helen.crossley@ozannes.com', '+44 (0)1481 731480', '+44 (0)1481 727964', 'images/portraits/Helen-Crossley.jpg'),
(14, 'Rupert Evans', 'Consultant', 'rupert.evans@ozannes.com', '+44 (0)1481 731433', '+44 (0)1481 713491', 'images/portraits/Rupert-Evans.jpg'),
(15, 'Carolyn Cowan', 'Senior Associate', 'carolyn.cowan@ozannes.com', '+44 (0)1534 784090', '+44 (0)1534 723456', 'images/portraits/Carolyn-Cowan.jpg'),
(16, 'John Dyke', 'Consultant', 'john.dyke@ozannes.com', '+44 (0)1481 731446', '+44 (0)1481 714653', 'images/portraits/John-Dyke.jpg'),
(17, 'Valerie Rouse', 'Senior Associate', 'val.rouse@ozannes.com', '+44 (0)1481 731476', '+44 (0)1481 713491', 'images/portraits/Valerie-Rouse.jpg'),
(18, 'Helen Wyatt', 'Senior Associate & Advocate', 'helen.wyatt@ozannes.com', '+44 (0)1481 731408', '+44 (0)1481 714653', 'images/portraits/Helen-Wyatt.jpg'),
(19, 'Nelson Wu', 'Associate', 'nelson.wu@ozannes.com', '+44 (0)1481 739308', '+44 (0)1481 714653', 'images/portraits/Nelson-Wu.jpg'),
(20, 'Barney Lee', 'Senior Associate', 'barney.lee@ozannes.com', '+44 (0)1481 731428', '+44 (0)1481 713491', 'images/portraits/Barney-Lee.jpg'),
(21, 'Claire Gaston-Parry', 'Associate', 'claire.gastonparry@ozannes.com', '+44 (0)1481 731413', '+44 (0)1481 713491', 'images/portraits/Claire-Gaston-Parry.jpg'),
(22, 'James Haughton', 'Senior Associate', 'james.haughton@ozannes.com', '+44 (0)1481 731485', '+44 (0)1481 713491', 'images/portraits/James-Haughton.jpg'),
(23, 'Andrew Bridgeford', 'Consultant', 'andrew.bridgeford@ozannes.com', '+44 (0)1534 784092', '+44 (0)1534 723465', 'images/portraits/Andrew-Bridgeford.jpg'),
(24, 'Johannes Botha', 'Associate', 'johannes.botha@ozannes.com', '+44 (0)1534 723466', '+44 (0)1534 723465', 'images/portraits/Johannes-Botha.jpg'),
(25, 'Rose Toussaint', 'Associate', 'rose.toussaint@ozannes.com', '+44 (0)1534 731401', '+44 (0)1534 713491', 'images/portraits/Rose-Toussaint.jpg'),
(26, 'Jane Struth', 'Associate', 'jane.struth@ozannes.com', '+44 (0)1534 784035', '+44 (0)1534 723465', 'images/portraits/Jane-Struth.jpg'),
(27, 'Michelle Tierney', 'Associate', 'michelle.tierney@ozannes.com', '+44 (0)1534 739377', '+44 (0)1534 727964', 'images/portraits/Michelle-Tierney.jpg'),
(28, 'Darren Stephens', 'Senior Associate', 'darren.stephens@ozannes.com', '+44 (0)1534 739373', '+44 (0)1534 714653', 'images/portraits/Darren-Stephens.jpg'),
(29, 'Kristin Holmes', 'Associate', 'kristin.holmes@ozannes.com', '+44 (0)1534 784015', '+44 (0)1534 723465', 'images/portraits/Kristin-Holmes.jpg'),
(30, 'Simon York', 'Associate', 'simon.york@ozannes.com', '+44 (0)1534 784007', '+44 (0)1534 723465', 'images/portraits/Simon-York.jpg'),
(31, 'Jessica Roland', 'Partner and Head of Employment', 'jessica.roland@ozannes.com', '+44 (0)1481 731455', '+44 (0)1481 710487', 'images/portraits/Jessica-Roland.jpg'),
(32, 'Mark Temple', 'Partner', 'mark.temple@ozannes.com', '+44 (0)1534 784025', '+44 (0)1534 723465', 'images/portraits/Mark-Temple.jpg'),
(33, 'Peter Ferbrache', ' Senior Partner', 'peter.ferbrache@ozannes.com', '+44 (0)1481 731435', '+44 (0)1481 713839', 'images/portraits/Peter-Ferbrache.jpg'),
(34, 'Robert Shepherd', 'Managing Partner', 'robert.shepherd@ozannes.com', '+44 (0)1481 731473', '+44 (0)1481 714571', 'images/portraits/Robert-Shepherd.jpg'),
(35, 'Christopher Edwards', 'Partner', 'christopher.edwards@ozannes.com', '+44 (0)1481 739329', '+44 (0)1481 710487', 'images/portraits/Christopher-Edwards.jpg'),
(36, 'Stephen Wauchope', 'Associate', 'stephen.wauchope@ozannes.com', '+44 (0)1534 784089', '+44 (0)1534 723465', 'images/portraits/Stephen-Wauchope.jpg'),
(37, 'Anthony Williams', 'Associate', 'anthony.williams@ozannes.com', '+44 (0)1481 731473', '+44 (0)1481 714571', 'images/portraits/Anthony-Williams.jpg'),
(38, 'Teresa de Nobrega', 'Associate', 'teresa.denobrega@ozannes.com', '+44 (0)1481 731455', '+44 (0)1481 710487', 'images/portraits/Teresa-de-Nobrega.jpg'),
(39, 'Tracey Powell', 'Associate', 'tracey.powell@ozannes.com', '+44 (0)1481 731482', '+44 (0)1481 710487', 'images/portraits/Tracey-Powell.jpg'),
(40, 'Gordon Dawes', 'Partner', 'gordon.dawes@ozannes.com', '+44 (0)1481 731479', '+44 (0)1481 710487', 'images/portraits/Gordon-Dawes.jpg'),
(41, 'St John Robilliard', 'Partner', 'stjohn.robilliard@ozannes.com', '+44 (0)1481 731440', '+44 (0)1481 710426', 'images/portraits/St-John-Robilliard.jpg'),
(42, 'Jeremy Wessels', 'Partner', 'jeremy.wessels@ozannes.com', '+44 (0)1481 731439', '+44 (0)1481 714571', 'images/portraits/Jeremy-Wessels.jpg'),
(43, 'Adrian Brown', 'Senior Associate & Advocate', 'adrian.brown@ozannes.com', '+44 (0)1481 731472', '+44 (0)1481 710487', 'images/portraits/Adrian-Brown.jpg'),
(44, 'Jeremy Le Tissier', 'Associate & Advocate', 'jeremy.letissier@ozannes.com', '+44 (0)1481 739322', '+44 (0)1481 714571', 'images/portraits/Jeremy-Le-Tissier.jpg'),
(45, 'Matthew Jowitt', 'Partner', 'matthew.jowitt@ozannes.com', '+44 (0)1534 784004', '+44 (0)1534 723465', 'images/portraits/Matthew-Jowitt.jpg'),
(46, 'Martin Jones', 'Senior Associate', 'martin.jones@ozannes.com', '+44 (0)1481 731324', '+44 (0)1481 714571', 'images/portraits/Martin-Jones.jpg'),
(47, 'Elaine McGriele', 'Associate', 'elaine.mcgriele@ozannes.com', '+44 (0)1534 784087', '+44 (0)1534 723465', 'images/portraits/Elaine-McGriele.jpg'),
(48, 'Abel Lyall', 'Associate', 'abel.lyall@ozannes.com', '+44 (0)1481 739364', '+44 (0)1481 710487', 'images/portraits/Abel-Lyall.jpg'),
(49, 'Patrick Barry', 'Associate', 'patrick.barry@ozannes.com', '+44 (0)1481 739363', '+44 (0)1481 710487', 'images/portraits/Patrick-Barry.jpg'),
(50, 'Chantal Barrett', 'Associate', 'chantal.barrett@ozannes.com', '+44 (0)1481 739391', '+44 (0)1481 710487', 'images/portraits/Chantal-Barrett.jpg'),
(51, 'Nathalie Kieffer Chandler', 'Associate', 'nathalie.chandler@ozannes.com', '+44 (0)1481 739374', '+44 (0)1481 710487', 'images/portraits/Nathalie-Kieffer-Chandler.jpg'),
(52, 'Penny Grainge', 'Associate', 'penny.grainge@ozannes.com', '+44 (0)1481 739309', '+44 (0)1481 710487', 'images/portraits/Penny-Grainge.jpg'),
(53, 'Sharon McHugh', 'Associate', 'sharon.mchugh@ozannes.com', '+44 (0)1481 739305', '+44 (0)1481 714571', 'images/portraits/Sharon-McHugh.jpg'),
(54, 'Michaela Ryan', 'Associate', 'michaela.ryan@ozannes.com', '+44 (0)1481 739317', '+44 (0)1481 714571', 'images/portraits/Michaela-Ryan.jpg'),
(55, 'Roger Perrot', 'Partner', 'roger.perrot@ozannes.com', '+44 (0)1481 731432', '+44 (0)1481 728414', 'images/portraits/Roger-Perrot.jpg'),
(56, 'Gavin Ferguson', 'Senior Associate', 'gavin.ferguson@ozannes.com', '+44 (0)1481 739323', '+44 (0)1481 710426', 'images/portraits/Gavin-Ferguson.jpg'),
(57, 'Jane Struth', 'Associate', 'jane.struth@ozannes.com', '+44 (0)1534 784035', '+44 (0)1534 723465', 'images/portraits/Jane-Struth.jpg'),
(58, 'Mark Torode', 'Partner', 'mark.torode@ozannes.com', '+44 (0)1481 739332', '+44 (0)1481 720378', 'images/portraits/Mark-Torode.jpg'),
(59, 'Garth Bainbridge', 'Partner and Head of Private Client Property & Planning', 'garth.bainbridge@ozannes.com', '+44 (0)1481 731434', '+44 (0)1481 728414', 'images/portraits/Garth-Bainbridge.jpg'),
(60, 'Alison Wood', 'Associate & Advocate', 'alison.wood@ozannes.com', '+44 (0)1481 731449', '+44 (0)1481 728414', 'images/portraits/Alison-Wood.jpg'),
(61, 'Edward Prentice', 'Partner ', 'edward.prentice@ozannes.com', '+44 (0)1481 731437', '+44 (0)1481 728414', 'images/portraits/Edward-Prentice.jpg'),
(62, 'Paul Yeomans', 'Associate', 'paul.yeomans@ozannes.com', '+44 (0)1481 731421', '+44 (0)1481 720378', 'images/portraits/Paul-Yeomans.jpg'),
(63, 'Julie Perfitt', 'Conveyancing Team Manager', 'julie.perfitt@ozannes.com', '+44 (0)1481 723466', '+44 (0)1481 710021', 'images/portraits/Julie-Perfitt.jpg'),
(64, 'Anthea Clark', 'Probate Manager', 'anthea.clark@ozannes.com', '+44 (0)1481 731415', '+44 (0)1481 720378', 'images/portraits/Anthea-Clark.jpg'),
(65, 'Nicholas Le Poidevin', 'Senior Conveyancer', 'nicholas.lepoidevin@ozannes.com', '+44 (0)1481 723466', '+44 (0)1481 710021', 'images/portraits/Nicholas-Le-Poidevin.jpg'),
(66, 'Richard Roberts', 'Senior Conveyancer', 'richard.roberts@ozannes.com', '+44 (0)1481 739347', '+44 (0)1481 710021', 'images/portraits/Richard-Roberts.jpg'),
(67, 'Ric', 'New', 'ric@betleywhitehorne.com', '+00 (0)0000 000000', '+54 (5)3453 453453', 'images/portraits/Richard-Roberts.jpg'),
(68, 'Carly Parrott', 'Associate', 'carly.parrott@ozannes.com', '+44 (0)1481 731430', '+44 (0)1481 710487', 'images/portraits/Carly-Parrott.jpg'),
(69, 'James Clyne', 'Associate', 'james.clyne@ozannes.com', '+44 (0)1481 739370', '+44 (0)1481 714571', 'images/portraits/James-Clyne.jpg'),
(73, 'Paula Lanyon', 'Legal Executive', 'paula.lanyon@ozannes.com', '+44 (0)1481 731470', '+44 (0)1481 713353', 'images/portraits/Paula-Lanyon.jpg'),
(74, 'Toni Hooper', 'Paralegal', 'toni.hooper@ozannes.com', '+44 (0)1481 731490', '+44 (0)1481 713353', 'images/portraits/Toni-Hooper.jpg'),
(76, 'New person', '', '', '', '', ''),
(78, 'New person', '', '', '', '', ''),
(80, 'Andrea Holford', 'Paralegal', 'andrea.holford@ozannes.com', '+44 (0)1481 739304', '+44 (0)1481 713353', 'images/portraits/Andrea-Holford.jpg'),
(81, 'Adam Cole', 'Associate', 'adam.cole@ozannes.com', '+44 (0)1481 739390', '+44 (0)1481 713353', 'images/portraits/Adam-Cole.jpg'),
(82, 'Edward Miller', 'Associate', 'edward.miller@ozannes.com', '+44 (0)1534 784002', '+44 (0)1534 723465', 'images/portraits/Edward-Miller.jpg'),
(83, 'Gemma Campbell', 'Associate', 'gemma.campbell@ozannes.com', '+44 (0)1481 739312', '+44 (0)1481 713491', 'images/portraits/Gemma-Campbell.jpg'),
(84, 'Henry Burger', 'Associate', 'henry.burger@ozannes.com', '+44 (0)1534 784083', '+44 (0)1534 723465', 'images/portraits/Henry-Burger.jpg'),
(85, 'Hennie du Toit', 'Associate', 'hennie.dutoit@ozannes.com', '+44 (0)1481 739389', '+44 (0)1481 714571', 'images/portraits/Hennie-Du-Toit.jpg'),
(87, 'Ric Le P', 'Mr', 'ric@ric.ric', '+00 (0)0000 000000', '+00 (0)0000 000000', 'images/portraits/Abel-Lyall.jpg'),
(88, 'New person', '', '', '', '', '');

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

--
-- Table structure for table `opm_profile_version`
--

CREATE TABLE IF NOT EXISTS `opm_profile_version` (
  `version_id` mediumint(11) NOT NULL AUTO_INCREMENT,
  `version_name` varchar(100) NOT NULL,
  `version_title` varchar(100) NOT NULL,
  `version_content` text NOT NULL,
  `person_id` int(11) NOT NULL,
  PRIMARY KEY (`version_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=115 ;

--
-- Dumping data for table `opm_profile_version`
--

INSERT INTO `opm_profile_version` (`version_id`, `version_name`, `version_title`, `version_content`, `person_id`) VALUES
(24, 'Corporate', '', 'Andrew was called to the English Bar in 1999 and subsequently qualified as a solicitor in 2002 and as an advocate in 2008. Before joining Ozannes in 2004 he practised within the Financial Services Department of City law firm, Lovells. Andrew specialises in offshore collective investment schemes and the provision of corporate and commercial legal services to the financial services sector.', 12),
(25, 'Corporate', '', 'Helen was admitted as a solicitor in 2000 and joined Ozannes in 2005. Helen has a general corporate background specialising in mergers, acquisitions and joint ventures having worked for Eversheds\r\nand undertaken various placements with blue-chip companies.', 13),
(26, 'Corporate / Trust', '', 'Rupert practised at the Chancery Bar for 14 years before moving to Guernsey in 1976 where he has established his reputation as a leading funds and trust lawyer. Rupert retired as a partner of Ozannes in 2004 and now acts as a consultant to the firm. In 2005 he was appointed by the Department of Commerce and Employment of the States of Guernsey as Chairman of the Trust Law Working Party to review the existing legislation in Guernsey relating to trusts.', 14),
(22, 'Corporate', '', 'Gavin joined the firm in 2001 after a number of years working for Simmons & Simmons in both\r\ntheir London and Paris offices. A dual-qualified French and English lawyer, Gavin has multijurisdictional commercial experience and specialises in offshore funds.', 10),
(23, 'Corporate', '', 'Mark was called to the English Bar in 1996 and practised in London before moving to Jersey in 1998. Mark joined Ozannes in 2007 as a partner to boost its rapidly expanding team. He specialises in banking, corporate, commercial, structured finance and investment funds. His practice has focused particularly on structured and project finance, corporate acquisitions, mergers, investment funds and private equity.', 11),
(21, 'Corporate', '', 'Marcus joined Ozannes in 2006 to head up the Jersey practice. He has 11 years’ experience in Jersey law, specialising in banking and finance, the establishment and management of investment funds and the creation and continuation of securitisation structures and programmes.', 9),
(18, 'Corporate', 'Partner ', 'Peter was in private practice in London with Coward Chance before becoming a Corporate Finance Executive with Hill Samuel & Co Limited. In 1980 Peter joined Ozannes and specialises in capital markets, banking, trusts and offshore funds. He was Chairman of the panel appointed by the States of Guernsey to review the machinery of Government in Guernsey.  In February 2006 Peter was appointed chairman of the Guernsey Financial Services Commission.\r\n', 6),
(19, 'Corporate', '', 'Paul has practised with Ozannes since 1999 and specialises in corporate, finance, commercial law and trusts, particularly the establishment of all types of investment funds and mergers and acquisitions, as well as regulatory matters. He has an established trust practice and acts for a number of leading trust institutions on the Island.', 7),
(20, 'Corporate', 'Partner', 'After a number of years practising at Ashurst Morris Crisp in London, David returned to Guernsey and Ozannes, where he has established a very successful practice in corporate finance, insurance, offshore funds, trusts and regulatory issues. He is regularly reported in legal directories as one of the leading Guernsey corporate lawyers and is also Head of Ozannes\\'' Corporate.\r\n', 8),
(27, 'Corporate', '', 'Carolyn is a qualified Scottish solicitor, and joined the firm in 2007 from Walkers. She has 24 years legal experience, including 17 in Jersey. She specialises in trusts, banking and general corporate transactions. Carolyn has previously worked for HSBC Private Banking, Bank of Scotland and Mourant du Feu & Jeune.', 15),
(28, 'Corporate', '', 'John qualified as an English solicitor in 1981. He was a partner of Maples and Calder in the Cayman Islands before joining Ozannes in 1999 as a Consultant. John specialises in securitisations and has comprehensive experience and expertise in this field, as well as in corporate finance and offshore funds.', 16),
(29, 'Corporate', '', 'Val was called to the English Bar in 2005 and the Guernsey Bar in 2006. She specialises in offshore collective investment schemes and regulatory issues and has considerable experience in this area through employment for many years in the offshore finance sector. Before joining the firm in 1997, Val spent three years with the Guernsey Financial Services Commission.', 17),
(30, 'Corporate', '', 'Helen joined Ozannes in 2001 and was the first candidate to undertake a training contract with the firm. She has gained broad commercial experience but has particular interests in regulatory issues. Helen holds the International Diploma in Compliance and became an Advocate 2007.', 18),
(31, 'Corporate', '', 'Nelson was admitted as a barrister and solicitor of the High Court of New Zealand in January\r\n2000 prior to joining Ozannes’ Corporate team in March 2007. He specialises in corporate, commercial and tax law in Auckland. Nelson has previously advised clients on corporate and commercial transactions,\r\ncorporate structures and restructuring, corporate governance, mergers and acquisitions, employment and tax.', 19),
(32, 'Corporate ', 'Senior Associate', 'Prior to joining Ozannes at the beginning of 2005, Barney developed a range of commercial and litigation skills representing, amongst others, major players in the Australian construction and insurance industries. Barney now focuses on offshore collective investment schemes and provides advice in respect of corporate and commercial services, particularly to the financial services sector. ', 20),
(33, 'Corporate', '', 'Claire joined Ozannes’ Corporate team in July 2007 from Partners Group where she was in-house legal counsel. Claire was primarily responsible for managing the legal and tax due diligence on a variety of fund, debt and equity investments. Her valuable industry experience extends to leading negotiations\r\nwith general partners, equity sponsors and lead banks on behalf of a variety of investors. Claire holds a Bachelor of Laws (1st class) and a Bachelor of Economics from the University of Sydney.', 21),
(34, 'Corporate', '', 'James was admitted as a solicitor in New Zealand in 2002 and specialised in corporate and commercial law in Wellington before joining the firm in February 2007. James has advised clients on a variety of corporate transactions including mergers, acquisitions, joint ventures and capital markets. James is also experienced in corporate governance issues and has been involved in setting up a number of charitable organisations.', 22),
(35, 'Corporate ', 'Consultant', 'Andrew was called to the English Bar in 1986 and qualified as a Jersey Advocate in 1988. He has over twenty years’ experience in Jersey corporate, banking and commercial law and was previously a partner in another Jersey firm. He is the author and publisher of the Weekly Digest of Jersey Law, which has established itself an important resource for Jersey lawyers, and was the general editor and a contributing author of Offshore Legal Opinions in Loan and Security Transactions (Sweet &\r\nMaxwell, 1996). ', 23),
(108, 'Litigation', 'Associate', 'Hennie joined Ozannes in April 2009 from another local law firm. Before moving to Guernsey, Hennie was a partner at a niche corporate and commercial law firm in Rosebank, Johannesburg, South Africa. In 2002 he obtained his Right of Appearance certificate to appear in the Appeal Court, which is the highest court in South Africa. His clients included several financial institutions, registered commercial banks and companies listed on the Johannesburg Stock Exchange. \r\n', 85),
(36, 'Corporate', 'Associate', 'Hannes was admitted to practice as an advocate in the High Court of South Africa in February 2004,\r\nhaving graduated from the University of Pretoria. Hannes has previously worked for the LDP Group, specialising in commercial law with a strong focus on taxation, contractual issues, mergers and acquisitions and corporate financing. He joined Ozannes in February 2008 and practises corporate and commercial law. Hannes has recently completed his Master of Laws Degree, with specialisation in commercial law.', 24),
(37, 'Corporate', '', 'Rose qualified as a solicitor in 2004 and joined Ozannes in June 2008. Rose has advised clients on a variety of corporate transactions and specialises in mergers, acquisitions and joint ventures and corporate governance advice for both private and public sector clients. Before joining Ozannes, Rose\r\nworked in the commercial projects team at Beachcrofts and in the corporate departments of Gordons and Hammonds, advising various private companies and blue-chip companies on a series of high profile transactions.', 25),
(38, 'Corporate', '', 'Jane joined Ozannes in June 2008 after moving to Jersey from Edinburgh, where she worked for Anderson Strathern LLP. She is presently advising clients on corporate transactions, investment funds and banking. Jane qualified as a solicitor in Scotland in 2004. She also advises on trust matters and has recently published articles on the introduction of foundations in Jersey.', 26),
(39, 'Corporate', '', 'Michelle joined the firm in July 2008 after moving from Arthur Cox in Dublin, where she specialised in banking law. Michelle holds a degree in Corporate Law and a LLB. She qualified as a solicitor in Ireland in 2007.', 27),
(40, 'Corporate', '', 'Darren qualified as a solicitor in 1999 and joined Ozannes in June 2008. Before joining Ozannes, Darren worked in the corporate team at Hammonds and in the private equity team at Eversheds. He subsequently spent 18 months working as in-house counsel at a leading financial services business.\r\nDarren has a corporate background having advised on listings, mergers and acquisitions, joint ventures and fund raisings. Before becoming a solicitor Darren also worked for three years for the Japanese Ministry of Education in Japan.', 28),
(41, 'Corporate', '', 'Kristin was admitted as a solicitor in Australia in February 2002 and specialised in corporate/financial services law in Sydney. In recent years, Kristin gained her experience as a lawyer for the Australian corporate regulator, and as in-house counsel for a leading Australian financial services company. Kristin holds Bachelor of Law and Master of Law degrees and joined the firm in July 2008.', 29),
(43, 'Corporate', '', 'Simon obtained a Bachelor of Laws degree together with a Bachelor of Commerce degree, majoring in finance, from the University of Otago, New Zealand, in 2004. Simon joined Ozannes’ Jersey office in December 2008 from another leading Jersey law firm. Prior to moving to Jersey, Simon worked\r\nin the investment funds team at Kensington Swan, a top tier New Zealand law firm. Simon specialises in investment funds, corporate transactions and banking.', 30),
(44, 'Employment', 'Partner and Head of Employment', 'Jessica qualified and practised in England as a solicitor, before returning to Guernsey in 1998. Jessica practises commercial and common law,  specialising in employment law, on which she regularly lectures and provides training.  She has substantial experience before Guernsey Courts and the Guernsey employment tribunal. She advises some of the Island’s largest institutions on dealing with employment matters including redundancies. She is listed as a leading individual in the Legal 500 and Chambers & Partners. ', 31),
(45, 'Employment', '', 'Paul has been with the firm since 1999. He specialises in corporate, commercial, trusts, regulatation and employment law. He has worked in-house advising on a spectrum of employment issues and has significant experience of dealing with all matters on a practical level.', 7),
(46, 'Employment', 'Senior Partner', 'Peter practised in England from 1972 before returning to his Channel Island home in 1980. Peter is recognised as Guernsey’s most experienced and hardened litigator, found on one side or the other of the majority of leading Guernsey cases in the last 21 years. His workload regularly includes advising on all aspects of employment law. He is Head of Ozannes’ Litigation and is highly respected amongst his competitors.', 33),
(47, 'Employment / Litigation', 'Partner', 'Mark joined Ozannes in Jersey in March 2007. He qualified and practised as a solicitor in leading\r\nCity firm Ashursts from 1992 to 2003, specialising in general commercial litigation, dispute resolution and employment law. He then practised commercial litigation at another Jersey law firm where his work included contentious trusts, bankruptcy and asset tracing litigation. Mark is a Cambridge graduate and an ADR qualified mediator.', 32),
(48, 'Employment', '', 'Robert obtained his Maitrise from Paris University in 1989 and joined Clifford Chance in 1991, before joining Ozannes in 1999. Robert has wide commercial experience which enables him to give practical advice on employment matters both in preventing them from arising and dealing with them if they have. He has been involved in a number of high profile cases.', 34),
(49, 'Employment', '', 'Christopher joined the firm in 2002, having previously practised in Western Australia. He specialises in commercial litigation and employment law, and his previous experience includes the employment law departments of Clayton Utz in Perth, and latterly, the Treasury Solicitor’s Department in London. He has appeared on numerous unfair dismissals hearings, both at first instance and on appeal, and advises on such matters as discrimination and redundancy, with a special interest in restrictive covenants and confidential information.', 35),
(50, 'Employment / Litigation', 'Associate', 'Stephen joined the firm in October 2007 after moving from London where he worked for Linklaters. His areas of practice are general commercial litigation, defendant personal injury and clinical negligence.  Stephen holds a Bachelors’ degree in Law and Arts and qualified as a Solicitor in Western Australia in 2002 where he practised at Formbys.', 36),
(51, 'Employment / Litigation', '', 'Anthony was admitted as a solicitor in the Supreme Court of Queensland and the High Court of Australia in 2003. He has practised exclusively in the area of litigation, specialising in complex litigation and insolvency matters. Anthony has appeared regularly in all levels of the Courts’ jurisdictions in Queensland and joined the firm in March 2008.', 37),
(52, 'Employment / Litigation', '', 'Teresa worked for London firms Barlow Lyde & Gilbert LLP and Reed Smith Richards Butler LLP\r\nbefore joining Ozannes in 2005 to undertake a training contract. Teresa qualified as a solicitor in\r\n2007 and specialises in civil litigation, employment and personal injury; she is also fluent in Portuguese.', 38),
(53, 'Employment / Litigation', '', 'Tracey worked for US firm Skadden, Arps, Slate, Meagher and Flom (UK) LLP in London before joining Ozannes in 2007 to undertake a training contract. Tracey qualified as a Solicitor in 2008 and specialises in general commercial and civil litigation and employment law.', 39),
(54, 'Litigation', 'Senior Partner', 'Peter practised in England from 1972 before returning to his Channel Island home in 1980. Peter is recognised as Guernsey’s most experienced and hardened litigator, found on one side or the other of the majority of leading Guernsey cases in the last 20 years. He is Head of Ozannes’ Litigation and the firm\\''s Senior Partner.', 33),
(55, 'Litigation', 'Partner', 'Gordon practised from London Chambers for nine years before moving to the Island in 1998. He has extensive experience before the English Courts and a special interest in Guernsey and English common law. He has a substantial commercial law, professional negligence and personal injury practice. In\r\naddition he is Guernsey’s most renowned public lawyer and has recently appeared before the Privy Council. His textbook of Guernsey Law was published in 2003.', 40),
(56, 'Litigation', '', 'St John took a double first from Emmanuel College, Cambridge, before pursuing an academic career in law. He then practised in Jersey for seven years before joining Ozannes in 1994. St John specialises in trust disputes and issues relating to Guernsey taxation. He has appeared in most of the leading Guernsey trust cases of recent years. St John was a member of The States of Guernsey Legislation\r\nCommittee 2002-2004 and in 2004 was elected to The International Academy of Estate and Trust Law.', 41),
(57, 'Litigation', '', 'Robert obtained his Maîtrise from Paris University in 1989 and joined Clifford Chance in 1991, before joining Ozannes in 1999. Robert’s know-how and abilities as a commercial litigator make him a key member of the team. His practice involves multi-jurisdictional matters relating to financial services, regulatory and contentious trust matters.', 34),
(58, 'Litigation / Trust', '', 'Jeremy joined Ozannes in October 2002, and specialises in commercial litigation, and particularly cases involving contentious trust disputes and financial services businesses, along with asset tracing and freezing orders. He also advises on insolvency related matters and money laundering issues. He acted for Westminster City Council in relation to the proceedings against Dame Shirley Porter and was also involved in the Flightlease Group liquidation.', 42),
(59, 'Litigation', '', 'Jessica practised in England as a solicitor in general litigation before returning to Guernsey in 1998. Jessica concentrates her practice in the areas of litigation concerning commercial matters with a special interest in employment law and trust litigation. She has substantial experience before Guernsey Courts at all levels.', 31),
(60, 'Litigation', '', 'Adrian qualified in England in 1987. He worked in the North of England, gaining extensive experience in all aspects of matrimonial law, including high value ancillary relief cases and all aspects of law relating to children. Adrian joined the firm in 2001 and qualified as an Advocate in 2004. He is a member of the Solicitors’ Family Law Association and the Family Mediators Association. He is the first Guernsey Advocate to be trained in collaborative law.', 43),
(61, 'Litigation ', 'Partner', 'Christopher joined the firm in January 2002 from Australia and was called to the Guernsey Bar in 2005. He specialises in complex commercial and trust litigation and provides advice to a range of financial institutions and fiduciaries, with particular expertise in large scale complex multi-jurisdictional disputes. In addition he has a particular interest in regulatory and compliance matters, having obtained Diplomas in Compliance and Anti-Money Laundering, and regularly advises on a number of routine and non-routine matters.', 35),
(62, 'Litigation', '', 'Jeremy is an English Barrister and a Guernsey Advocate. He was called to the Guernsey Bar in 2005 and regularly appears in Court. His practice is based on matters involving complex fraud, money laundering, regulatory and associated matters. His client base is largely made up of banks and fiduciaries. In addition, Jeremy has growing specialisation in property litigation. He is a Chartered Surveyor and is an associate of the Chartered Institute of Arbitrators. Jeremy was rated as an ‘associate to watch’ in the 2008 edition of Chambers and Partners.', 44),
(63, 'Litigation', 'Partner', 'Matthew was a barrister for 10 years at 7 Bedford Row in London where he practiced a mix of civil and criminal litigation cases. He moved to Jersey in 2004 to work for the Law Officers Department in Jersey and qualified as a Jersey Advocate in 2006. Whilst working at the Law Officers Department Matthew has prosecuted its largest and most complex cases, including\r\nJersey\\''s largest money laundering case.', 45),
(64, 'Litigation', '', 'Martin qualified as a solicitor in the UK in 1999, having trained at Masons (now Pinsent Masons). Martin continued to practice in the UK until 2003, when he moved to the Cayman Islands, where he was admitted as an attorney at law and practised at the law firm Campbells. Martin relocated to Guernsey and joined Ozannes in November 2006. Martin specialises in complex international commercial and financial litigation, including trust matters, cross-border fraud claims, asset tracing, contract and tort disputes and multi-jurisdictional insolvency matters.', 46),
(65, 'Litigation', '', 'Elaine McGriele qualified as a solicitor in England & Wales in 2004 and then practised at Lyons Davidson where she specialised in commercial litigation. She joined Ozannes Litigation Department in Jersey in October 2007 where her work includes trusts, insolvency and general commercial litigation.', 47),
(66, 'Litigation', 'Associate', 'Abel joined the firm in January 2008 from McInnes Wilson in Queensland, Australia. He specialises in professional liability, insolvency and general commercial litigation. Abel holds degrees in both Law and Applied Science and was admitted to practice as a solicitor of the Supreme Court of Queensland in 2002.', 48),
(67, 'Litigation', 'Associate', 'Patrick is an Australian solicitor admitted in both New South Wales and Victoria. Patrick has been involved in workplace safety criminal litigation matters throughout Australia. In 2007, Patrick practised at leading firm Clyde & Co in London, focusing on aviation litigation in a number of international jurisdictions. He is fluent in German and Japanese and joined the firm in March 2008.', 49),
(68, 'Litigation', 'Associate', 'Chantal is an Advocate and manager of the Insurance Risk Group.  She qualified as a Solicitor in 2001 and practised in insurance litigation with Beachcroft LLP for 9 years, before returning to the island and joining Ozannes in 2008.   She specialises in defendant insurance litigation, particularly personal injury, clinical negligence and professional indemnity claims.    Chantal completed her Certificat d\\''Etudes Juridiques Francaises et Normandes at the Universite de Caen in 2009 and was called to the Guernsey Bar in 2010.  \r\n\r\n \r\n', 50),
(69, 'Litigation', 'Associate', 'Nathalie is a French lawyer and joined Ozannes in November 2008. She completed her Maitrise en Droit at the University of Strasbourg, France and went on to study E.U. law at the Europa Institut Saarbrucken, Germany. Nathalie was called to the Bar of Luxembourg in 1996 where she worked as an \\"advocat\\" before joining Luxembourg\\''s largest insurance company, Groupe Le Royer. She specialised in private client property, corporate and insurance law, working often on multi-jurisdictional matters. Nathalie is fluent in French, German and English.', 51),
(70, 'Litigation', '', 'Penny qualified as a solicitor in England in 1992, initially working for Somerset County Council in childcare and education law. She moved to Guernsey in 1999 and has specialised in family law since 2000.', 52),
(71, 'Litigation', '', 'Sharon qualified as a solicitor in England in 2002 and holds a Bachelors degree in law. She also holds Parts 1, 2, 3 and 4 of the Certificate in Financial Planning. Sharon joined the firm in January 2009 after moving to Guernsey from Bristol, where she worked for Clarke Willmott. Sharon specialises in commercial litigation generally, particularly disputes involving financial services businesses.', 53),
(72, 'Litigation', '', 'Michaela was admitted as a Barrister and Solicitor of the High Court of New Zealand in 2002. She practised as a litigation solicitor and appeared regularly in the District and High Court, and also at a range of tribunals. Before joining Ozannes in January 2009, Michaela worked as in-house legal counsel for Fortis Prime Fund Solutions in Dublin, in the funds and investment banking industry.', 54),
(73, 'Trust ', 'Partner', 'St John took a double first from Emmanuel College, Cambridge, before pursuing an academic career in law. He then practised in Jersey for seven years before joining Ozannes in 1994. St John is Head of Ozannes’ Trusts and specialises in trust disputes and issues relating to Guernsey taxation. He has appeared in most of the leading Guernsey trust cases of recent years. St John is a frequent contributor to journals, books and conferences. ', 41),
(101, 'Trust', 'Partner', 'Roger has over 30 years’ experience at the Guernsey Bar and has been a partner of the firm since 1976. A substantial proportion of his practice concerns international trust work along with all aspects of planning and property related matters. Roger was a member of the Guernsey States (Parliament) for six years and is a Fellow of the Chartered Institute of Arbitrators.', 55),
(74, 'Private Client', 'Partner', 'Roger has over 30 years’ experience at the Guernsey Bar and has been a partner of the firm since 1976. A substantial proportion of his practice concerns international trust work along with all aspects of planning and property related matters. Roger was a member of the Guernsey States (Parliament) for six years and is a Fellow of the Chartered Institute of Arbitrators.', 55),
(75, 'Trust', '', 'Paul joined Ozannes in 1999 and became a Partner in 2006. He has an established trust practice and acts for a number of leading trust institutions on the Island.', 7),
(76, 'Trust', 'Managing Partner', 'Robert joined the firm from Clifford Chance in 1999 and was made a Partner in 2002. He has pursued a varied litigation practice before the Guernsey and English Courts specialising in disputes concerning trust companies, including regulatory and banking matters as well as disputes between beneficiaries and trustees. He has appeared in the Court of Appeal in HM Procureur - v- A and B as well as a host of other trust disputes before the Royal Court. ', 34),
(77, 'Trust', '', 'Marcus joined Ozannes in 2006. He has 12 years'' experience in Jersey law, specialising in banking and finance, corporate acquisitions and mergers, the establishment and management of investment funds and the creation and continuation of securitisation structures and programmes. Marcus has a strong trust practice and advises beneficiaries and professional trustees.', 9),
(79, 'Trust', '', 'Martin has broad trusts experience, specialising both in non contentious and contentious matters. He regularly advises corporate trustees and has recently completed a lengthy part time secondment to a trust company in Guernsey. He has also acted in high value disputes on behalf of protectors and trustees in both the Cayman Islands and Guernsey.', 46),
(80, 'Trust ', 'Senior Associate', 'Prior to joining Ozannes in 2005, Gavin worked in London for a well-known private client firm, practicing as a private client solicitor specialising in trusts, tax and estate planning. Gavin has an established trust practice and acts for both individuals and corporates in respect of all areas of trust law, both contentious and non contentious, and also on regulatory matters. Gavin also has an interest in Shari\\''a law and Shari\\''a compliant trust structures and holds the Islamic Finance Qualification. ', 56),
(81, 'Trust', '', 'Jane joined Ozannes in June 2008 after moving to Jersey from Edinburgh, where she worked for Anderson Strathern LLP. She is presently advising clients on corporate transactions, investment funds and banking. Jane qualified as a solicitor in Scotland in 2004. She advises on trust matters and has recently published articles on the introduction of foundations in Jersey.', 57),
(82, 'Trust', 'Senior Associate', 'Carolyn is a qualified Scottish solicitor who joined the firm in 2007 from Walkers in Jersey where she headed up the trustdepartment. Carolyn has practiced law for twenty-five years - eighteen of these in Jersey - and specialises in trusts, regulatory matters and general corporate law. She advises several trust companies in both Jersey and Guernsey on non contentious trust matters. ', 15),
(83, 'Private Client', '', 'Mark is an Advocate with more than ten years’ experience at the Guernsey Bar, whose client base was founded on a vast network of contacts, which has grown due to his reputation for dynamism and problemsolving. His ability to communicate complex matters simply to a wide spectrum of clients has meant that he is constantly attracting new work from the recommendations of existing clients.', 58),
(84, 'Private Client', 'Partner and Head of Private Client Property & Planning', 'Garth joined Ozannes in 1980 and has a specialist knowledge of all matters relating to the Guernsey law of realty and conveyancing. He is Head of  Private Client and is a Member of the Chartered Institute of Arbitrators.', 59),
(85, 'Private Client', '', 'Alison was admitted as a solicitor in 1991 and practised in Oxford prior to joining Ozannes in 1996. She has considerable experience in all types of commercial property transactions and specialises in landlord and tenant matters. She was called to the Guernsey Bar in 2007.', 60),
(86, 'Private Client', 'Partner', 'Edward is the Head of the Property team and has worked on property-related matters for the firm since 1972 and became an Advocate in 1984. He has a specialist knowledge of Guernsey property law and conveyancing, with a particular interest in disputes relating to Guernsey land and planning matters.', 61),
(87, 'Private Client', '', 'Paul qualified as a solicitor in 1980 and has acted on behalf of public and private company clients across a broad spectrum of the commercial property industry, including developers, landlords, tenants and financiers. He brings extensive experience from his time at Slaughter and May and Lovells in London, as well as from local law firms in recent years. He joined Ozannes in 2004.', 62),
(88, 'Private Client', '', 'Julie joined Ozannes in 1983 and has been instrumental in reviewing and updating the firm’s conveyancing procedures. Julie has been directly involved in a number of the Island’s largest property transactions.', 63),
(89, 'Private Client', '', 'Anthea joined Ozannes in 1990 and has been probate manager since 2000. She assists Guernsey resident and non-resident clients in obtaining Grants of Probate and Letters of Administration. She also deals with the administration and winding up of local estates.', 64),
(90, 'Private Client', '', 'Nicholas has been with the firm for over 25 years. His knowledge and expertise of Guernsey conveyancing makes him one of the most experienced conveyancers in the Island.', 65),
(91, 'Private Client', '', 'Richard is one of Guernsey’s most experienced conveyancers who joined a local law firm straight after leaving school. Richard joined Ozannes in December 2007 as a senior conveyancer and brought with him over 41 years’ experience in Court Row.', 66),
(92, 'New profile', '', '', 67),
(93, 'Litigation', 'Associate', 'Carly joined the firm in March 2009 after working as a solicitor with Minter Ellison in Sydney. Carly specialises in employment law and her areas of practice include employment and HR advisory, employment litigation and general commercial litigation. Carly holds a Bachelor of Laws (Honours), a Bachelor of Business and qualified as a solicitor of the Supreme Court of New South Wales in 2005.\r\n', 68),
(94, 'New profile', '', '', 48),
(95, 'Corporate', 'Associate', 'James joined the firm in March 2009 after moving from Australia. His areas of specialty include corporate advisory, capital markets including capital raising and IPO, general commercial and corporate law, mergers and acquisitions, particularly in the areas of mining and related industries. James has acted for a number of Australian public listed companies and has advised significant international clients on their operations in Australia, including issues with respect of foreign investment.', 69),
(97, 'Litigation', 'Legal Executive', 'Paula has 21 years of experience witin the Litigation Department at Ozannes.  Paula joined the Insurance Risk Group in 2001 as a paralegal.  Paula focuses on personal injury including catastrophic injury claims, employers and motor liability claims.  In 2009, Paula qualified as a Fellow of the Institute of Legal Executives.', 73),
(103, 'Litigation', 'Paralegal', 'Andrea has been with Ozannes since 2003 and previously worked in the Court Office.  Andrea joined the Insurance Risk Group in 2008 and assists the team on a varied range of matters including personal injury, clinical negligence and debt recovery work.', 80),
(98, 'Litigation', 'Paralegal', 'Toni has 20 years experience within the Litigation Department giving her a wealth of experience of civil litigation practices and procedures.  She joined the Insurance Risk Group in 2004 and provides a range of paralegal assistance to the team.   ', 74),
(102, 'Litigation', 'Paralegal', 'Andrea has been with Ozannes since 2003 and previously worked in the Court Office.  Andrea joined the Insurance Risk Group in 2008 and assists the team on a varied range of matters including personal injury, clinical negligence and debt recovery work.', 78),
(99, 'Litigation', 'Adam Cole', 'Adam joined the firm in April 2009 after moving from London where he worked in the Insurance and Re-Insurance Group of Cameron McKenna. Having qualified as a solicitor in 2008, Adam\\''s areas of practice include insurance litigation and general commercial litigation.', 76),
(109, 'Pension', 'Partner', 'Andrew is a partner within Ozannes\\'' Corporate Department. He was called to the English Bar in 1999, qualified as a solicitor in 2002 and joined Ozannes in 2004.  Andrew specialises in offshore collective investment schemes and the provision of corporate and commercial legal services to the financial services sector. Andrew has established, restructured and listed a wide range of investment vehicles in various jurisdictions. He also provides advice in relation to captive insurance vehicles, securitisation structures and trusts.', 12),
(111, 'Pension', 'Senior Associate', 'Gavin has an established trust practice and acts for both individuals and corporates in respect of all areas of trust law, both contentious and non-contentious, including in respect of private, corporate and pension trusts, employee share schemes and also on regulatory matters. Gavin also has an interest in Sharia\\''a law and Sharia\\''a compliant trust structures and holds the Islamic Finance Qualification. Gavin is a member of the International Tax Planning Association, the Society of Trust and Estate Practitioners and the Securities Institute.', 56),
(104, 'Litigation', 'Associate', 'Adam joined the firm in April 2009 after moving from London where he worked in the Insurance and Reinsurance Group of CMS Cameron McKenna. Adam qualified as a solicitor in 2008, and his areas of practice are insurance litigation and general commercial litigation.\r\n\r\n', 81),
(105, 'Litigation', 'Associate', 'Edward was admitted as a solicitor in England and Wales in 2008, having previously been called to the English Bar in 2005. He previously practised at Allen & Overy and Ashursts, and also worked in-house for Morgan Stanley. He has experience in civil and commercial litigation, personal injury litigation, international capital markets and derivatives. Edward joined Ozannes in January 2009.\r\n', 82),
(106, 'Corporate', 'Associate', 'Gemma qualified as an English solicitor in April 2009 and works in the corporate department. Gemma has advised clients in the investment funds area, including the establishment and re-structuring of vehicles. She has also advised on employment law matters. Gemma is currently studying to gain an LLM in Professional Legal Practice.', 83),
(107, 'Corporate', 'Associate', 'Henry was admitted to practice as an attorney in the High Court of South Africa in January 2002, having graduated from the University of Stellenbosch. Henry has previously worked for the PSG Group, specialising in corporate law with a strong focus on investment funds, fund structures, formation of fund management companies, obtaining regulatory approvals and advising upon ongoing legal and regulatory requirements. He joined Ozannes in March 2009 and practices corporate and commercial law.', 84),
(112, 'Pension', 'Associate & Advocate', 'Helen joined Ozannes in 2001 and was the first candidate to undertake a training contract with the firm.  She became an Advocate in 2007 and holds the International Diploma in Compliance.  Helen has broad commercial experience and specialises in advising all types of regulated business, in particular banks, fiduciaries and insurance companies.', 18),
(113, 'Pension', 'Partner and Head of Employment', 'Jessica practised in England as a solicitor, conducting general litigation, before returning to Guernsey in 1998. Jessica practises commercial and common law, specialising in employment law and human/corporate rights. She has substantial experience before Guernsey Courts, and has advised some of the Island\\''s largest institutions on dealing with employment matters, including on pension issues. She has appeared before the Guernsey employment tribunal on numerous occasions. Jessica also lectures and undertakes training on employment law.', 31),
(114, 'New profile', 'Mr', 'this is the test for this version of the profile', 87);

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

--
-- Table structure for table `opm_setting`
--

CREATE TABLE IF NOT EXISTS `opm_setting` (
  `setting_id` int(11) NOT NULL,
  `setting_left` varchar(5) NOT NULL,
  `setting_top` varchar(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `opm_setting`
--

INSERT INTO `opm_setting` (`setting_id`, `setting_left`, `setting_top`) VALUES
(1, '7', '35'),
(2, '7', '35'),
(3, '7', '35'),
(4, '7', '35');