-- Table structure for table `content`
--

CREATE TABLE `content` (
  `content_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `slug_name_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `seo_url` varchar(255) DEFAULT NULL,
  `seo_url_edit` enum('Y','N') NOT NULL DEFAULT 'Y',
  `title` varchar(255) DEFAULT NULL,
  `meta_description` text,
  `meta_keywords` text,
  `content` longtext,
  `author` varchar(255) NOT NULL,
  `sub_menu` enum('Y','N') NOT NULL DEFAULT 'N',
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `status_edit` enum('Y','N') NOT NULL DEFAULT 'Y',
  `show_menu` enum('Y','N') NOT NULL DEFAULT 'Y',
  `show_menu_edit` enum('Y','N') NOT NULL DEFAULT 'Y',
  `can_delete` enum('Y','N') NOT NULL DEFAULT 'Y',
  `order_id` int(11) NOT NULL,
  PRIMARY KEY (`content_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `content`
--

INSERT INTO `content` VALUES (1,0,'Home','index.html','N','Home','Home','Home','<p>BIB</p>','','N','0000-00-00 00:00:00','2016-03-07 22:25:12','Y','N','N','N','N',0),(2,0,'Page Not Found','page-not-found.html','Y','Page Not Found','test meta','test key','<div style=\"text-align: center;\"><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/admin/images/page-not-found.png\" /></div>','','N','2015-06-12 09:40:52','2016-01-13 11:59:56','Y','N','N','N','N',0),(4,4,'Corporate Profile','about us.html','Y','About Us','About Us','About Us','<div class=\"image\" style=\"background-image: url( \'http://demo.softunique.net/websites/bib/img/about/about-img.jpg\' ); height: 455px !important; background-repeat: no-repeat !important; \">\r\n            </div>\r\n\r\n            <div class=\"content margin-bottom\">\r\n\r\n                <h3 class=\"about-title\">Who We Are ?</h3>\r\n                <h2>Al Berwaz Insurance Brokers</h2>\r\n                \r\n                <p class=\"margin-bottom-10\">Al Berwaz Insurance Brokers Establishment is a National Establishment licensed by the Ministry of Finance & Economy Reg. No. 81 and certified by Abu Dhabi Health Authority (HAAD) to exercise all types of insurance services.</p>\r\n                <p class=\"margin-bottom-10\">Our company founded in 1995 by highly qualified UAE nationals and managed by professional insurance specialists tuned to stay alert to new risks and exposures, focused to provide business conglomerates and individuals with professional advice derived at obtaining comprehensive, competitive and complete solutions on diverse classes of Insurance.</p>\r\n                \r\n                \r\n            </div>','','Y','2016-01-15 14:29:33','2016-05-19 10:25:50','N','Y','Y','Y','Y',1),(5,2,'Contact Us','contact-us','Y','Contact Us','Contact Us','BIB','','','N','2016-06-09 11:37:51','2016-06-09 11:37:51','Y','Y','Y','Y','Y',0),(6,5,'Our Services','our-services.html','Y','Our Services','Services','BIB','<div class=\"news\">\r\n           \r\n                                        <img src=\"http://demo.softunique.net/websites/bib/img/services/1.jpg\" alt=\"Al Berwaz Insurance Brokers\" title=\"Al Berwaz Insurance Brokers\" width=\"240px\">\r\n                                       \r\n                                        <p>Assist our clients to recognize and identify the \"insurable risks\".</p>\r\n                                                   \r\n                                                \r\n                                </div>       \r\n                            \r\n                                <div class=\"clear\">&nbsp;</div>\r\n\r\n                                <div class=\"news\">\r\n           \r\n                                        <img src=\"http://demo.softunique.net/websites/bib/img/services/2.jpg\" alt=\"Al Berwaz Insurance Brokers\" title=\"Al Berwaz Insurance Brokers\" width=\"240px\">\r\n                                      \r\n                                        <p>Design the widest possible wording for these risks in order to transfer the entire exposures.</p>\r\n                                                   \r\n                                                \r\n                                </div>       \r\n                            \r\n                                <div class=\"clear\">&nbsp;</div>\r\n\r\n                                <div class=\"news\">\r\n           \r\n                                        <img src=\"http://demo.softunique.net/websites/bib/img/services/4.jpg\" alt=\"Al Berwaz Insurance Brokers\" title=\"Al Berwaz Insurance Brokers\" width=\"240px\">\r\n                                       \r\n                                        <p>Provide our clients with the analyzed lowest possible rates for transfer of these risks from local and international markets.</p>\r\n                                                   \r\n                                                \r\n                                </div>       \r\n                            \r\n                                <div class=\"clear\">&nbsp;</div>\r\n\r\n                                <div class=\"news\">\r\n           \r\n                                        <img src=\"http://demo.softunique.net/websites/bib/img/services/5.jpg\" alt=\"Al Berwaz Insurance Brokers\" title=\"Al Berwaz Insurance Brokers\" width=\"240px\">\r\n                                      \r\n                                        <p>Consultations in terms of contracts and policy wording to ensure high protection for our client\'s benefits.</p>\r\n                                                   \r\n                                                \r\n                                </div>       \r\n                            \r\n                                <div class=\"clear\">&nbsp;</div>\r\n\r\n                                <div class=\"news\">\r\n           \r\n                                        <img src=\"http://demo.softunique.net/websites/bib/img/services/3.jpg\" alt=\"Al Berwaz Insurance Brokers\" title=\"Al Berwaz Insurance Brokers\" width=\"240px\">\r\n                                       \r\n                                        <p>Consultations in terms of HAAD BY LAW and the Insurance Authority rules.</p>\r\n                                                   \r\n                                                \r\n                                </div>       \r\n                            \r\n                                <div class=\"clear\">&nbsp;</div>\r\n\r\n                                <div class=\"news\">\r\n           \r\n                                        <img src=\"http://demo.softunique.net/websites/bib/img/services/6.jpg\" alt=\"Al Berwaz Insurance Brokers\" title=\"Al Berwaz Insurance Brokers\" width=\"240px\">\r\n                                    \r\n                                        <p>Apply our scrutiny in making sure that the documentations issued by the insurers actually are as per our joint expectations and requirements.</p>\r\n                                                   \r\n                                                \r\n                                </div>       \r\n                            \r\n                                <div class=\"clear\">&nbsp;</div>\r\n                               \r\n                                <div class=\"news\">\r\n           \r\n                                        <img src=\"http://demo.softunique.net/websites/bib/img/services/9.jpg\" alt=\"Al Berwaz Insurance Brokers\" title=\"Al Berwaz Insurance Brokers\" width=\"240px\">\r\n                                    \r\n                                        <p>Be on their side at the time of any losses and make sure that their personnel abide by the conditions of the insurance policies and submit the right documents to insurers.</p>\r\n                                                   \r\n                                                \r\n                                </div>       \r\n                            \r\n                                <div class=\"clear\">&nbsp;</div>\r\n\r\n                                 <div class=\"news\">\r\n           \r\n                                        <img src=\"http://demo.softunique.net/websites/bib/img/services/7.jpg\" alt=\"Al Berwaz Insurance Brokers\" title=\"Al Berwaz Insurance Brokers\" width=\"240px\">\r\n                                   \r\n                                        <p>Follow up on claims to ensure that our clients receive their rightful on the agreed time.</p>\r\n                                                   \r\n                                                \r\n                                </div>       \r\n                            \r\n                                <div class=\"clear\">&nbsp;</div>\r\n\r\n                                <div class=\"news\">\r\n           \r\n                                        <img src=\"http://demo.softunique.net/websites/bib/img/services/8.jpg\" alt=\"Al Berwaz Insurance Brokers\" title=\"Al Berwaz Insurance Brokers\" width=\"240px\">\r\n                                    \r\n                                        <p>Follow up on day to day transactions such as initial, addition, deletion, lost and correction on medical cards, credits and debits etc. (electronically).</p>\r\n                                                   \r\n                                                \r\n                                </div>       \r\n                            \r\n                                <div class=\"clear\">&nbsp;</div>','','Y','2016-06-09 13:07:37','2016-10-07 07:52:48','Y','Y','Y','Y','Y',0),(7,1,'Product listing','product','Y','Products','Products','BIB','Fast Quality Service is our Objective With a view to create indelible impression in the minds of our clients, we spare no stones unturned with high professionalism, loyalty to customers, objective at sight and strict confidentiality. Our experienced professionals work as a team to find superior solutions.','','N','2016-06-09 15:45:53','2016-06-09 15:45:53','Y','Y','Y','Y','Y',0),(8,5,'Scope of Services','scope-of-services.html','Y','Scope of Services','Scope of Services','Scope of Services','\r\n\r\n<ul class=\"style-list-one\">\r\n	<li><strong>Renewal of Existing Insurance Program and Placement of New Insurance policies</strong></li>\r\n</ul>\r\n\r\n<p>\r\nComprehensive and professional analysis of the existing insurance policies with regards to the wordings, endorsements, schedules, special terms and conditions and adequacy of sums insured and to ensure that these are in line with international standards and practices, the analysis will include the following policies:\r\n<img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/services.jpg\" style=\"width:380px; float:right; padding-top:20px;\" />\r\n</p>\r\n\r\n<ul class=\"margin-l20\">\r\n	<li>Property All Risks &amp; Consequential Loss Insurance Policies</li>\r\n	<li>Public Liability Insurance policy</li>\r\n	<li>Money Insurance Policy</li>\r\n	<li>Fidelity Guarantee Insurance Policy</li>\r\n	<li>Workmen\'s Compensation and Employer\'s Liability Insurance Policy</li>\r\n	<li>Motor Insurance Policy</li>\r\n	<li>Medical Insurance Policy</li>\r\n	<li>Mortgage Impairment (Mortgage Errors &amp;Omissions)</li>\r\n	<li>Banker&rsquo;s REO Coverage</li>\r\n	<li>Banker&rsquo;s Blanket Bond</li>\r\n	<li>Banker&rsquo;s D&amp;O Liability Coverage including Entity Coverage</li>\r\n	<li>Other Insurance policies</li>\r\n</ul>\r\n\r\n<p>\r\nIn Respect of Medical Insurance Policy (Emirate of Abu Dhabi) and as per the doctrine of the law No. 23 for the Year 2005, our service will be concentrated on:\r\n</p>\r\n\r\n<ul class=\"margin-l20\">\r\n	<li>Advising of all information required by &quot;the insurance companies&quot; for their insurance Renewal quotations in respect of:</li>\r\n</ul>\r\n<br/>\r\n<ul class=\"margin-l30\">\r\n	<li>The format of the List of Employees to be submitted</li>\r\n	<li>The particulars of insurance coverage under Basic Scheme: Abu Dhabi &ndash; In/Out Patient applicable to the Company\'s Labors of total cash salary package of AED. 5,000/- or AED. 4,000/- plus accommodation</li>\r\n	<li>The particulars of insurance coverage under Enhanced Scheme: In/Out Patient applicable to the Company\'s Staff of total cash salary package of above AED. 5,000/- or AED. 4,000/- plus accommodation and give alternative categorization of the staff benefits under schemes ranging from Local to International with different benefit limits.\r\n	<ul>\r\n		<li>Ensure the accuracy of the information in the application form and list of employees by the Company and cross-check such information for amendment if necessary in coordination with the client</li>\r\n		<li>Approaching &quot;the insurance companies&quot; for their quotations for Basic and enhanced Covers providing them with all necessary underwriting information. Upon receipt of \"the insurance companies\' quotations\", we shall immediately convey its contents along with clarification and recommendation to the client for their approval to go ahead with obtaining the insurance policy.</li>\r\n	</ul>\r\n	</li>\r\n\r\n	<li> We shall immediately and after having the client approval to issue the policy and also having the photographs imaged, approach &quot;the successful insurance company&quot; to issue the insurance policy and the insurance Cards.</li>\r\n	<li>We shall be responsible for following up the matter of issuing the insurance policy as soon as possible and to ensure that all documentation is accurate and to be safely handed over to the client</li>\r\n   <li>In the event of any additions or deletions of members (and after have been informed about it by the client on the format agreed upon) in the insurance policy, we shall intimate it immediately to &quot;insurance company&quot; for amendment.</li>\r\n</ul>\r\n<br/>\r\n<ul class=\"style-list-one\">\r\n	<li><strong>Contract Review</strong></li>\r\n</ul>\r\n<p>\r\nReview of insurance provision in various contracts to be entered in to by the client including review and comment on all parties&rsquo; rights and obligations in relation to insurance, considering commercial aspects of the transaction, the agreed risk allocation between the parties, appropriate levels of indemnity and UAE insurance legislation and regulations.</p>\r\n<p>\r\nFor each contract we would propose drafting on insurance related clauses and to review policies taken out by M/s the client counterparties in line with the international practice in this respect and to ensure compliance with contractual obligations.</p>\r\n<p>\r\nThe type of contracts in question include, but are not necessarily limited to, construction contracts, facility management contracts, professional services agreements, concession agreements, lease agreements and minor works contracts.</p>\r\n<ul class=\"style-list-one\">\r\n	<li><strong>Annual Insurance Review</strong></li>\r\n</ul>\r\n<p>\r\nReview the client assets and activities on an annual basis and identify any gaps in relation to existing insurance coverage (for example, non-existing insurance policies and/or inadequate provisions in current policies and contracts).</p>\r\n<p>To perform the review, the undertaking of documentation reviews, interviews with staff (and possibly other stakeholders) and inspections of relevant locations across the Emirate of Abu Dhabi will be required.</p>\r\n<p>The review will be concluded in a report submitted to the client which identifies the gaps, recommends remedial action and provides estimates for budgeting purposes of the premium costs. Un-insurable risks shall be identified with recommendations for mitigation. The report should also<br />\r\n\r\nHighlight relevant main trends and developments in the insurance industry that are of relevance to the client</p>\r\n&nbsp;\r\n<ul class=\"style-list-one\">\r\n	<li><strong>Claims Management </strong></li>\r\n</ul>\r\n<p>\r\nPreparing Claim files including all documentary information to be submitted to the insurance companies and entering into joint negotiation for claim\'s settlement and coordinating with the client for the collection of claims funds from insurance companies.</p>\r\n<br/>\r\n\r\n<h1>General Methodology - Action/Services </h1>\r\n\r\n<ul class=\"style-list-one\">\r\n	<li><strong>Renewal of Existing Insurance Program</strong></li>\r\n</ul>\r\n<p>\r\nWe will be following the renewal tendering process where we bear the full burden of preparing all necessary and relating documents formatted in a very professional manner to be tendered in the market for quotations. This process will be in full cooperation with the client concerned staff represented by the Financial Manager and Operation Manger or any other staff in relevant field of operation and experience by holding 3-5 extensive meetings tackling all relating issues with the intention of having the permission of the client to go ahead with the information repaired . We will be taking the following steps in this regard:</p>\r\n\r\n<ul class=\"margin-l20\" style=\"list-style-type:circle\">\r\n	<li>Tendering the insurance requirements to at least five insurance companies giving specific deadlines for them:</li>\r\n	<li>Analyzing their replies in a very comprehensive manner and also stating our comments and recommendations for your consideration and approval&nbsp;&nbsp;</li>\r\n	<li>Following up issuance of policies with the recommended company and ensuring full compliance with tender documents and quotations.</li>\r\n</ul>\r\n<br/>\r\n<ul class=\"style-list-one\">\r\n	<li><strong>Annual Insurance Review</strong></li>\r\n</ul>\r\n\r\n<p>\r\n\r\n<u>Special Methodology on Risk Management to be implemented for Annual Insurance Review: </u><br />\r\nAs your are aware of the importance of risk management in eliminating the hazardous factor surrounding the Branches and its major role in keeping these Branches working properly and effectively in respect of fire fighting &amp; safety measures, this also will have a positive impact on the terms and conditions of the insurance coverage, and could substantially enhance these terms to your benefit, our service in risk management includes:</p>\r\n<ul class=\"margin-l20\" style=\"list-style-type:circle\">\r\n	<li>Carrying on professional physical survey to all Branches to:</li>\r\n</ul>\r\n\r\n<ul class=\"margin-l30\">\r\n	<li>Identifying risk</li>\r\n	<li>Analyzing risk</li>\r\n	<li>Controlling Risk in terms of Physical risk Control, Pre-loss risk reduction and &nbsp;&nbsp;&nbsp;&nbsp;Post-loss risk control.</li>\r\n</ul>\r\n\r\n<ul class=\"margin-l20\" style=\"list-style-type:circle\">\r\n	<li>Putting recommendations for further enhancements for positive factors, and to enhance the negative factors. The main doctrine behind this process is to make the risks insurable at optimal terms and conditions and to also watch the good maintenance and status of the Branches.&nbsp;&nbsp;</li>\r\n	<li>Following up with the company the implementation of recommendation to ensure that all pre-loss and post-loss measures</li>\r\n</ul>\r\n&nbsp;\r\n\r\n<ul class=\"style-list-one\">\r\n	<li><strong>CONFIDENTIALITY AND SAFEGUARDING OF INERESTS</strong></li>\r\n</ul>\r\n<p>\r\nWe confirm maintaining all information provided by the Company to us relating to the Company\'s business and operation as strictly confidential and shall not disclose the information to third party(s), except as required for the performance of the our obligations as your consultants, without the Company\'s prior written consent.</p>\r\n&nbsp;','','Y','2016-06-13 16:04:10','2016-06-13 16:04:10','Y','Y','Y','Y','Y',0),(9,4,'News & Events','news.html','Y','News','News & Events','BIB','','','N','2016-06-13 11:21:27','2016-06-13 11:21:27','Y','Y','Y','Y','Y',2),(10,0,'E-Profile','e-profile.html','Y','E-Profile','E-Profile','BIB','\r\n<img alt=\"Al Berwaz Insurance Brokers\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/services.jpg\" style=\"width:320px; float:left; padding-right:15px\" />\r\nWe offer a combination of insurance, risks management and consultancy services expertise tailor-made to less cost and lesser risks to industrial, commercial, financial and professional firms, we are positioned to place a comprehensive range of insurance covers with traditional insurance market. ','','N','2016-06-13 11:14:25','2016-06-13 11:14:25','Y','Y','Y','Y','Y',0),(11,4,'Our Management','our-management.html','Y','Our Management','Our Management','BIB','<ol>\r\n<li>Mr. Eyad Al Jamal - Managing partner </li>\r\n<li>Mr. Mohammed Abdel Fattah - Business Development Manager</li>\r\n<li>Mr. Tamam Rajab - Marketing Manager</li>\r\n<li>Mr. Ayam Saghir - Sales Manager</li>\r\n<li>Buthaina Ali  - Head of Motor Dept.</li>\r\n<li>Head Of Medical Dept. Vivian </li>\r\n<li>Head of Claims - Princess Canlas</li>\r\n\r\n</ol>\r\n','','Y','2016-06-13 17:46:38','2016-06-13 17:46:38','N','Y','Y','Y','Y',3),(12,0,'Careers','career.html','Y','Careers','Careers','BIB','Career with&nbsp;<span style=\"background-color:rgb(253, 253, 253); color:rgb(148, 152, 171); font-family:signika; font-size:16px\">Al Berwaz Insurance Brokers LLC<br />\r\n<br />\r\n<img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/image-1.jpg\" style=\"height:400px; width:600px\" /></span><br />\r\nInterested candidates can forward the resume to&nbsp;<a href=\"mailto:hr@alberwazinsurance.com\">hr@alberwazinsurance.com</a>\r\n\r\n<table border=\"0\" cellpadding=\"1\" cellspacing=\"1\" style=\"border:1px solid #ccc\">\r\n	<caption><br />\r\n	<span style=\"font-family:verdana,geneva,sans-serif\"><span style=\"color:#FF0000\"><strong><u>Vacancies</u></strong></span></span><br />\r\n	&nbsp;</caption>\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n			<div style=\"background:#eee;border:1px solid #ccc;padding:5px 10px;\"><strong>Job Id</strong></div>\r\n			</td>\r\n			<td>\r\n			<div style=\"background:#eee;border:1px solid #ccc;padding:5px 10px;\"><strong>Title</strong></div>\r\n			</td>\r\n			<td>\r\n			<div style=\"background:#eee;border:1px solid #ccc;padding:5px 10px;\"><strong>Details</strong></div>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>AO#001</td>\r\n			<td>Recruitment of Administrative Officers (Scale I)</td>\r\n			<td><a href=\"http://demo.softunique.net/websites/bib/userfiles/files/manager.docx\">Download</a></td>\r\n		</tr>\r\n		<tr>\r\n			<td>AOM#010</td>\r\n			<td>Recruitment of AO-Medical (Scale-I)</td>\r\n			<td><a href=\"http://demo.softunique.net/websites/bib/userfiles/files/manager.docx\">Download</a></td>\r\n		</tr>\r\n	</tbody>\r\n</table>','','N','2016-06-15 09:39:40','2017-06-12 21:16:59','Y','Y','Y','Y','Y',4),(13,4,'Our Vision','our-vision.html','Y','Our Vision','Our Vision','BIB','<div>\r\n<p>We offer a combination of insurance, risks management and consultancy services expertise tailor-made to less cost and lesser risks to industrial, commercial, financial and professional firms, we are positioned to place a comprehensive range of insurance covers with traditional insurance market.</p>\r\n<p>To achieve our goal, we have a dedicated team to scale greater heights and lengths to determine our client&#39;s comprehensive and most effective cover at a competitive premium. We deal with &quot;A&quot; rated Admitted and qualified Insurance carriers.</p>\r\n</div>','','Y','2016-08-12 13:34:34','2016-10-03 06:18:34','N','Y','Y','Y','Y',1),(15,4,'Meet BIB','meet-bib.html','Y','Meet BIB','meet-bib Meet BIB','Meet BIB, Meet BIB','<p>We offer a combination of insurance, risks management and consultancy services to less cost and lesser risks to industrial, commercial, financial and professional firms.</p>\r\n\r\n<div style=\"margin: 0px; padding: 0px; font-family: Signika; color: rgb(0, 0, 0); font-size: medium; background-color: rgb(253, 253, 253);\">\r\n<div>\r\n<ul>\r\n	<li>Assist our clients to recognize and identify the &quot;insurable risks&quot;</li>\r\n	<li>Design the widest possible wording for these risks in order to transfer the entire exposures.</li>\r\n	<li>Consultations in terms of contracts and policy wording to ensure high protection for our client&#39;s benefits.</li>\r\n	<li>Consultations in terms of HAAD BY LAW and the Insurance Authority rules.</li>\r\n	<li>Follow up on claims to ensure that our clients receive their rightful on the agreed time</li>\r\n</ul>\r\n</div>\r\n<img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/explaining-viewpoint.jpg\" style=\"height:400px; width:600px\" /></div>','','Y','2016-12-05 11:00:45','2016-12-05 12:19:02','Y','Y','Y','Y','Y',0),(16,4,'CEO Message','ceo-message.html','Y','CEO Message','CEO Message','CEO Message','<p>Dear Valued Partners,</p>\r\n\r\n<p>The idea of founding the company has evolved based on the future vision of a business men and experts to the role of the promising future of the insurance sector, the extent of the market and the urgent need due to the steady growth of the economy in the United Arab Emirates.<img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Al%20Hamili.jpg\" style=\"float:right; height:331px; width:250px\" /></p>\r\n\r\n<p>BIBBased on the spectrum, Al Berwaz Insurance Brokers was founded in 1995 as a pioneer in the world of insurance in UAE market offering all types of insurance services to its customers and in line with the evolution of the legislative systems developed by official bodies and authorities in the state, where the company is working to cover all the needs of insurance to its customers by studying and analyzing the market risks in general and the client in particular, and to make appropriate recommendations to issue competitive insurance policies, which works to protect the customer&#39;s business and investment through the reduction of losses in the event of damage and leads to the increase of the customer &#39;s confidence in the market and to work on the expansion of its investments and activities.</p>\r\n\r\n<p>Al Berwaz was and still trying to reach full satisfaction to its customers by providing high quality of service through expertise who are working on risks assessment and management using the latest technical and technological means to develop effective solutions that lead to protect the interests of our customers and their investments, which will also contribute to increase their confidence toward our products and services provided to them to enhance the relationships.</p>\r\n\r\n<p>We welcome and wish you further progress and success.</p>\r\n\r\n<p>Ali Al Hameli<br />\r\nCEO<br />\r\n&nbsp;</p>','','Y','2016-12-07 06:12:43','2017-02-07 08:14:51','Y','Y','Y','Y','Y',0),(17,0,'Partners','partners.html','Y','Partners','Partners','Partners','<table border=\"0\" cellpadding=\"1\" cellspacing=\"1\" style=\"width:500px\">\r\n	<tbody>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Abu-Dhabi-National-Takaful1.jpg\" style=\"height:52px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/ADNIC-Insurance-company1.jpg\" style=\"height:52px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/AETNA1.jpg\" style=\"height:52px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Al-Ain-Ahlia-Insurance1.jpg\" style=\"height:51px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Al-Dharfa-Insurace1.jpg\" style=\"height:54px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Al-Ittihad-Al-Watani1.jpg\" style=\"height:53px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Al-Sagr-Insurance1.jpg\" style=\"height:51px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Al-Wathba-National-Insurance1.jpg\" style=\"height:54px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Cigna-Saico2.jpg\" style=\"height:53px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Daman-Insurance1.jpg\" style=\"height:51px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Emirates-Ins.Co_1.jpg\" style=\"height:56px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Expacare2.jpg\" style=\"height:55px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Green-Crescent1.jpg\" style=\"height:60px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Insurance-House2.jpg\" style=\"height:54px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/MetLife1.jpg\" style=\"height:57px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/National-Life-General-Insurance2.jpg\" style=\"height:55px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/NGI2.jpg\" style=\"height:60px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Oman-Bupa2.jpg\" style=\"height:60px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Orient-Insurance1.jpg\" style=\"height:52px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Qatar-Insurance1.jpg\" style=\"height:56px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/RAK-Insurance-Company1.jpg\" style=\"height:46px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/RSA1.jpg\" style=\"height:60px; width:126px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/SBC-UAE-Logo-300x180.png\" style=\"height:120px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Takaful-Emarat1.jpg\" style=\"height:60px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Union-Insurance-Company-PSC1.jpg\" style=\"height:58px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Zurich1.jpg\" style=\"height:56px; width:200px\" /></td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>','','N','2016-12-05 13:15:15','2016-12-05 13:27:55','Y','Y','Y','Y','Y',0),(18,4,'MD Message','md-message.html','Y','MD Message','MD Message','MD Message','<img alt=\"BIB\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/EyadAlJamal.jpg\" style=\"float:right; height:339px; margin-left:20px; width:300px\" />\r\n<p>Dear Valued Partners,<br />\r\n<br />\r\nSince company was founded, we are increasing our investments to develop the infrastructure and the workflow by raising the competency and expertise of our staff, enhance the technical and technological means and promote the agreements concluded with the major insurance companies operating in United Arab Emirates in order to reach the highest professional degrees, accuracy and secrecy in line with the new regulations and legislatures, which was developed by the insurance Authority and the bodies of Health in Abu Dhabi and Dubai to save clients&rsquo; interests, transactions and information.<br />\r\n<br />\r\nThe company has also working on providing high quality products and services in competitive prices, in addition to the contractual terms and conditions that are consistent with local and international standards for corporate insurance and reinsurance,in order to protect the rights of our clients in insurance claims from the potential risks that may be exposed to their investments, business, employees and dependents, which will reflect positively on their workflow and productivity.<br />\r\n<br />\r\nAl Berwaz has worked over 21 years to hire technical, administrative and marketing team with extensive experience in the field of insurance and support them with the latest training programs to enhance their skills and competencies to cope with all the changes in the insurance market, in addition, to establish a contracts with the most important local and regional insurance companies to offer our clients a variety of insurance products, such as health, life, vehicles, engineering projects, real estate, shipping, fire, etc. in competitive prices that meet clients&rsquo; needs and expectations.<br />\r\n<br />\r\nThe company has worked also on raising the quality of their services and the speed of performance by dealing with the well reputed information technology and electronic applications companies, which facilitates communication with our customers to answer their queries, follow up on their transactions and claims.<br />\r\n<br />\r\nOur ultimate goal is to reach our clients satisfaction by fulfilling their needs and requirements and to meet their expectations which will reflect positively on the bilateral relations in the present and the future.<br />\r\n<br />\r\nEyad Al Jamal<br />\r\nManaging Partner</p>','','Y','2016-12-05 11:22:23','2017-02-07 08:22:18','Y','Y','Y','Y','Y',0);

--
-- Table structure for table `content_option`
--

CREATE TABLE `content_option` (
  `content_option_id` int(11) NOT NULL AUTO_INCREMENT,
  `content_id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `url` varchar(500) NOT NULL,
  `description` text NOT NULL,
  `added_date` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `order_id` int(11) NOT NULL,
  `image_name` varchar(255) NOT NULL,
  PRIMARY KEY (`content_option_id`),
  UNIQUE KEY `content_option_id` (`content_option_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `content_option`
--

INSERT INTO `content_option` VALUES (1,11,'Management Structure','','\r\n<div class=\"center flowchart\">\r\n  <img  src=\"http://demo.softunique.net/websites/bib/userfiles/files/flowchart.png\" alt=\"Al Berwaz Insurance Brokers\" title=\"Al Berwaz Insurance Brokers\" width=\"840px\">\r\n  <img src=\"http://demo.softunique.net/websites/bib/userfiles/files/flowchart1.png\" alt=\"Al Berwaz Insurance Brokers\" title=\"Al Berwaz Insurance Brokers\" width=\"240px\" class=\"chart\">\r\n        \r\n</div>\r\n','2016-06-14 15:40:09','Y',1,''),(2,12,'Work with us','','<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" style=\"width:500px\">\r\n	<caption>Recruitment</caption>\r\n	<tbody>\r\n		<tr>\r\n			<td>Sl No</td>\r\n			<td>Title</td>\r\n			<td>Details</td>\r\n		</tr>\r\n		<tr>\r\n			<td>1</td>\r\n			<td>Recruitment of Administrative Officers (Scale I)</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>2</td>\r\n			<td>Recruitment of AO-Medical</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>','2016-06-14 12:56:56','Y',1,'');

--
-- Table structure for table `download`
--

CREATE TABLE `download` (
  `download_id` int(11) NOT NULL AUTO_INCREMENT,
  `download_name` varchar(300) NOT NULL,
  `file_name` varchar(200) NOT NULL,
  `extension` varchar(100) NOT NULL,
  `status` enum('Y','N') NOT NULL,
  `order_id` int(11) NOT NULL,
  `added_date` date NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`download_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `download`
--

INSERT INTO `download` VALUES (1,'General Insurance','146581619416573300146581619431054bib-introduction-2013.doc','doc','Y',1,'2016-06-13','2016-06-13 11:09:54');

--
-- Table structure for table `download_category`
--

CREATE TABLE `download_category` (
  `download_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL,
  `category_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
  `order_id` int(11) NOT NULL,
  `added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`download_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `download_category`
--

INSERT INTO `download_category` VALUES (1,0,'test','Y',1,'2016-05-12 03:55:11'),(27,0,'Manuals','Y',2,'2016-01-19 12:21:15'),(28,0,'Catalogues','Y',3,'2016-01-19 12:21:38'),(29,0,'Software','Y',4,'2016-01-19 12:24:56'),(30,0,'Soil Moisture / Environment','Y',5,'2016-02-08 10:05:00'),(31,30,'PICO-Config','Y',6,'2016-02-08 10:05:19'),(32,0,'Grain Moisture / Bulk Industry','Y',7,'2016-05-11 11:39:20'),(33,32,'TrimeWinCal','Y',8,'2016-02-08 10:09:51'),(35,32,'Catalogues','Y',9,'2016-02-09 11:37:56');

--
-- Table structure for table `email_template`
--

CREATE TABLE `email_template` (
  `email_template_id` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(50) NOT NULL,
  `file_name` varchar(100) NOT NULL,
  `subject` varchar(100) NOT NULL,
  PRIMARY KEY (`email_template_id`),
  UNIQUE KEY `file_name` (`file_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `email_template`
--

INSERT INTO `email_template` VALUES (1,'contactus.message','contactus.message.html','Contact Mail'),(2,'product_enquiry.message','product_enquiry.message.html','Product Enquiry');

--
-- Table structure for table `faq`
--

CREATE TABLE `faq` (
  `faq_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `title` varchar(1000) NOT NULL,
  `description` text NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `order_id` int(11) NOT NULL,
  PRIMARY KEY (`faq_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `faq`
--

INSERT INTO `faq` VALUES (1,1,'FAQ1','<p>FAQ1</p>','Y','2016-01-18 10:19:21',3),(2,1,'FAQ2','<p>FAQ2</p>','Y','2016-01-18 06:00:00',2),(3,2,'feature','<p>So far no questions are to be answered.</p>','Y','2016-01-18 06:00:00',4),(4,3,'TRIME probes measure conductivity','<div class=\"listWhite\">\r\n<ul>\r\n	<li>TRIME probes measure conductivity with the same large soil volume as it will be used for the TDR moisture measurement. The contact of the probe rods inside the soil is far less critical as with &quot;galvanic&quot; EC probes with a point to point measurement where even small air gaps lead to significant deviations.</li>\r\n	<li>- TRIME probes use coated and therefore isolated rods which guarantee the non-appearance of galvanic accumulation along the rods allowing for long-run installations over many years. Unisolated rods means there is a risk of galvanic reactions and possible influence on the sensor&acute;s reading with serious problems when the probes must be removed from larger depths due to a rod cleaning.</li>\r\n	<li>- TRIME probes measure moisture and conductivity very precisely at a frequency of 1GHz with a better and more exact separation of moisture and conductivity in comparison to capacitive probes with lower frequencies. This means that in practice, a reliable determination of the pore water conductivity ECw and respectively TDS (mg of salt per liter water) is possible at different moisture levels.</li>\r\n	<li>All TRIME probes work with a concurrently basic calibration for moisture and conductivity. This allows a check of the limits of saline stress in soils according to standards of FAO2006 for specific soils.</li>\r\n</ul>\r\n</div>','Y','2016-01-18 12:43:56',2),(6,3,'test title2','<div class=\"listWhite\">\r\n<ul>\r\n	<li>TRIME probes measure conductivity with the same large soil volume as it will be used for the TDR moisture measurement. The contact of the probe rods inside the soil is far less critical as with &quot;galvanic&quot; EC probes with a point to point measurement where even small air gaps lead to significant deviations.</li>\r\n	<li>- TRIME probes use coated and therefore isolated rods which guarantee the non-appearance of galvanic accumulation along the rods allowing for long-run installations over many years. Unisolated rods means there is a risk of galvanic reactions and possible influence on the sensor&acute;s reading with serious problems when the probes must be removed from larger depths due to a rod cleaning.</li>\r\n	<li>- TRIME probes measure moisture and conductivity very precisely at a frequency of 1GHz with a better and more exact separation of moisture and conductivity in comparison to capacitive probes with lower frequencies. This means that in practice, a reliable determination of the pore water conductivity ECw and respectively TDS (mg of salt per liter water) is possible at different moisture levels.</li>\r\n	<li>All TRIME probes work with a concurrently basic calibration for moisture and conductivity. This allows a check of the limits of saline stress in soils according to standards of FAO2006 for specific soils.</li>\r\n</ul>\r\n</div>','Y','2016-01-18 12:44:32',1),(7,3,'test title 3','<div class=\"listWhite\">\r\n<ul>\r\n	<li>TRIME probes measure conductivity with the same large soil volume as it will be used for the TDR moisture measurement. The contact of the probe rods inside the soil is far less critical as with &quot;galvanic&quot; EC probes with a point to point measurement where even small air gaps lead to significant deviations.</li>\r\n	<li>- TRIME probes use coated and therefore isolated rods which guarantee the non-appearance of galvanic accumulation along the rods allowing for long-run installations over many years. Unisolated rods means there is a risk of galvanic reactions and possible influence on the sensor&acute;s reading with serious problems when the probes must be removed from larger depths due to a rod cleaning.</li>\r\n	<li>- TRIME probes measure moisture and conductivity very precisely at a frequency of 1GHz with a better and more exact separation of moisture and conductivity in comparison to capacitive probes with lower frequencies. This means that in practice, a reliable determination of the pore water conductivity ECw and respectively TDS (mg of salt per liter water) is possible at different moisture levels.</li>\r\n	<li>All TRIME probes work with a concurrently basic calibration for moisture and conductivity. This allows a check of the limits of saline stress in soils according to standards of FAO2006 for specific soils.</li>\r\n</ul>\r\n</div>','Y','2016-01-18 06:00:00',5),(8,4,'system techelligenology is as intnt as the m nology is as intelligent as theeasurement method itself','<p>TRIME&reg; system techelligenology is as intnt as the measurement method itself. IMKO offers numerous other peripheral SM-sensor modules, enabling the system to be applied to special tasks and major projects. This is another important argument for using TRIME&reg; and the ENVIS&reg; system as an ideal measurement technique for determining soil moisture and other measurement parameters.</p>\r\n\r\n<ul>\r\n	<li>Modular, flexible, and extendable set-up of TRIME&reg; probes and other sensors inside the IMP-Bus network</li>\r\n	<li>Simple network administration with software package globeLog control</li>\r\n</ul>\r\n\r\n<p>Set out below is a selection of the sensors and data-aquisition modules in the IMKO range: Hygrometer/temperature probe, radiation meter, barometer, air velocity and air direction indicator, rain gauge, tensiometer, tree sensors, and special sensors on request!</p>\r\n\r\n<p>TRIME&reg; system technology is as intelligent as the measurement method itself. IMKO offers numerous other peripheral SM-sensor modules, enabling the system to be applied to special tasks and major projects. This is another important argument for using TRIME&reg; and the ENVIS&reg; system as an ideal measurement technique for determining soil moisture and other measurement parameters.</p>\r\n\r\n<ul>\r\n	<li>Modular, flexible, and extendable set-up of TRIME&reg; probes and other sensors inside the IMP-Bus network</li>\r\n	<li>Simple network administration with software package globeLog control</li>\r\n</ul>\r\n\r\n<p>Set out below is a selection of the sensors and data-aquisition modules in the IMKO range: Hygrometer/temperature probe, radiation meter, barometer, air velocity and air direction indicator, rain gauge, tensiometer, tree sensors, and special sensors on request!</p>\r\n\r\n<p>TRIME&reg; system technology is as intelligent as the measurement method itself. IMKO offers numerous other peripheral SM-sensor modules, enabling the system to be applied to special tasks and major projects. This is another important argument for using TRIME&reg; and the ENVIS&reg; system as an ideal measurement technique for determining soil moisture and other measurement parameters.</p>\r\n\r\n<ul>\r\n	<li>Modular, flexible, and extendable set-up of TRIME&reg; probes and other sensors inside the IMP-Bus network</li>\r\n	<li>Simple network administration with software package globeLog control</li>\r\n</ul>\r\n\r\n<p>Set out below is a selection of the sensors and data-aquisition modules in the IMKO range: Hygrometer/temperature probe, radiation meter, barometer, air velocity and air direction indicator, rain gauge, tensiometer, tree sensors, and special sensors on request!</p>','Y','2016-01-19 06:00:00',1),(10,4,'test1','<p>TRIME&reg; system technology is as intelligent as the measurement method itself. IMKO offers numerous other peripheral SM-sensor modules, enabling the system to be applied to special tasks and major projects. This is another important argument for using TRIME&reg; and the ENVIS&reg; system as an ideal measurement technique for determining soil moisture and other measurement parameters.</p>\r\n\r\n<ul>\r\n	<li>Modular, flexible, and extendable set-up of TRIME&reg; probes and other sensors inside the IMP-Bus network</li>\r\n	<li>Simple network administration with software package globeLog control</li>\r\n</ul>\r\n\r\n<p>Set out below is a selection of the sensors and data-aquisition modules in the IMKO range: Hygrometer/temperature probe, radiation meter, barometer, air velocity and air direction indicator, rain gauge, tensiometer, tree sensors, and special sensors on request!</p>','Y','2016-01-18 06:00:00',6),(11,4,'test2','<p>TRIME&reg; system technology is as intelligent as the measurement method itself. IMKO offers numerous other peripheral SM-sensor modules, enabling the system to be applied to special tasks and major projects. This is another important argument for using TRIME&reg; and the ENVIS&reg; system as an ideal measurement technique for determining soil moisture and other measurement parameters.</p>\r\n\r\n<ul>\r\n	<li>Modular, flexible, and extendable set-up of TRIME&reg; probes and other sensors inside the IMP-Bus network</li>\r\n	<li>Simple network administration with software package globeLog control</li>\r\n</ul>\r\n\r\n<p>Set out below is a selection of the sensors and data-aquisition modules in the IMKO range: Hygrometer/temperature probe, radiation meter, barometer, air velocity and air direction indicator, rain gauge, tensiometer, tree sensors, and special sensors on request!</p>','Y','2016-01-18 06:00:00',7),(12,4,'test 3','<p>TRIME&reg; system technology is as intelligent as the measurement method itself. IMKO offers numerous other peripheral SM-sensor modules, enabling the system to be applied to special tasks and major projects. This is another important argument for using TRIME&reg; and the ENVIS&reg; system as an ideal measurement technique for determining soil moisture and other measurement parameters.</p>\r\n\r\n<ul>\r\n	<li>Modular, flexible, and extendable set-up of TRIME&reg; probes and other sensors inside the IMP-Bus network</li>\r\n	<li>Simple network administration with software package globeLog control</li>\r\n</ul>\r\n\r\n<p>Set out below is a selection of the sensors and data-aquisition modules in the IMKO range: Hygrometer/temperature probe, radiation meter, barometer, air velocity and air direction indicator, rain gauge, tensiometer, tree sensors, and special sensors on request!</p>','Y','2016-01-18 06:00:00',8),(13,4,'test4','<p>TRIME&reg; system technology is as intelligent as the measurement method itself. IMKO offers numerous other peripheral SM-sensor modules, enabling the system to be applied to special tasks and major projects. This is another important argument for using TRIME&reg; and the ENVIS&reg; system as an ideal measurement technique for determining soil moisture and other measurement parameters.</p>\r\n\r\n<ul>\r\n	<li>Modular, flexible, and extendable set-up of TRIME&reg; probes and other sensors inside the IMP-Bus network</li>\r\n	<li>Simple network administration with software package globeLog control</li>\r\n</ul>\r\n\r\n<p>Set out below is a selection of the sensors and data-aquisition modules in the IMKO range: Hygrometer/temperature probe, radiation meter, barometer, air velocity and air direction indicator, rain gauge, tensiometer, tree sensors, and special sensors on request!</p>','Y','2016-01-18 06:00:00',9),(14,6,'Question1 ?','<p>So far no questions are to be answered.</p>','Y','2016-01-19 06:00:00',10);

--
-- Table structure for table `module_settings`
--

CREATE TABLE `module_settings` (
  `module_settings_id` int(11) NOT NULL AUTO_INCREMENT,
  `keys` varchar(50) NOT NULL,
  `values` varchar(50) NOT NULL,
  PRIMARY KEY (`module_settings_id`),
  UNIQUE KEY `keys` (`keys`),
  UNIQUE KEY `keys_2` (`keys`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `module_settings`
--

INSERT INTO `module_settings` VALUES (1,'CONTENT_EXTENSION','html'),(2,'PRODUCT_MIN_WIDTH','200'),(3,'PRODUCT_MIN_HEIGHT','200'),(4,'PRODUCT_MAX_WIDTH','2000'),(5,'PRODUCT_MAX_HEIGHT','2000'),(6,'PRODUCT_THUMB_WIDTH','200'),(7,'PRODUCT_THUMB_HEIGHT','200'),(8,'DIR_PRODUCT','DIR_ROOT . userfiles/product/'),(9,'URI_PRODUCT','URI_ROOT . userfiles/product/'),(10,'SLUG_CONTACT','URI_ROOT . contact-us/'),(11,'SLUG_AJAX','URI_ROOT . ajax/'),(12,'SLUG_CATEGORY','URI_ROOT . category/'),(13,'SLUG_PRODUCT','URI_ROOT . product/'),(14,'DIR_CATEGORY','DIR_ROOT . userfiles/category/'),(15,'URI_CATEGORY','URI_ROOT . userfiles/category/'),(16,'CATEGORY_MIN_WIDTH','118'),(17,'CATEGORY_MIN_HEIGHT','118'),(18,'CATEGORY_MAX_WIDTH','2000'),(19,'CATEGORY_MAX_HEIGHT','2000'),(20,'CATEGORY_THUMB_WIDTH','118'),(21,'CATEGORY_THUMB_HEIGHT','118'),(22,'PRODUCT_GALLERY_MIN_WIDTH','150'),(23,'PRODUCT_GALLERY_MIN_HEIGHT','150'),(24,'PRODUCT_GALLERY_MAX_WIDTH','2000'),(25,'PRODUCT_GALLERY_MAX_HEIGHT','2000'),(26,'PRODUCT_GALLERY_THUMB_WIDTH','150'),(27,'PRODUCT_GALLERY_THUMB_HEIGHT','150'),(28,'DIR_PRODUCT_GALLERY','DIR_ROOT . userfiles/product_gallery/'),(29,'URI_PRODUCT_GALLERY','URI_ROOT . userfiles/product_gallery/'),(30,'DIR_BROCHURE','DIR_ROOT . userfiles/brochure/'),(31,'URI_BROCHURE','URI_ROOT . userfiles/brochure/'),(32,'PRODUCT_GALLERY_PORTRATE_THUMB_HEIGHT','100'),(33,'PRODUCT_GALLERY_PORTRATE_THUMB_WIDTH','90'),(34,'DIR_PRODUCT_DOWNLOAD','DIR_ROOT . userfiles/product_download/'),(35,'URI_PRODUCT_DOWNLOAD','URI_ROOT . userfiles/product_download/'),(36,'DIR_PRODUCT_PDF','DIR_ROOT . userfiles/product_pdf/'),(37,'URI_PRODUCT_PDF','URI_ROOT . userfiles/product_pdf/'),(38,'DIR_NEWS','DIR_ROOT . userfiles/news/'),(39,'URI_NEWS','URI_ROOT . userfiles/news/'),(40,'SLUG_AJAX_SEARCH','URI_ROOT . system/ajax/'),(41,'DIR_DOWNLOAD','DIR_ROOT . userfiles/download/'),(42,'URI_DOWNLOAD','URI_ROOT . userfiles/download/');

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `news_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `news_date` date NOT NULL,
  `news_name` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `image_name` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `month` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`news_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `news`
--

INSERT INTO `news` VALUES (1,'2017-05-13','General Insurance','We offer a combination of insurance, risks management and consultancy services expertise tailor-made to less cost and lesser risks to industrial, commercial, financial and professional firms, we are positioned to place a comprehensive range of insurance covers with traditional insurance market.','146581673784139700146581673759637about-img.jpg','','2017-05-13 07:30:20'),(3,'2017-05-13','Framing your Needs','We follow up on day to day transactions such as initial, addition, deletion, lost and correction on medical cards, credits and debits etc. (electronically).','14660682516286790014660682514770product-4.jpg','','2017-05-13 07:30:34'),(4,'2017-05-13','BIB Launches Latest Interactive Website','BIB launches its latest interactive website to cater to the insurance requirements of new as well as existing clients at all times with online chat option provided for quick updates and support.','146607168284864200146607168288378screenshot--11-.png','','2017-05-13 07:27:53');

--
-- Table structure for table `page_content`
--

CREATE TABLE `page_content` (
  `page_content_id` int(10) NOT NULL AUTO_INCREMENT,
  `page_name` varchar(255) DEFAULT NULL,
  `title` varchar(250) NOT NULL,
  `content` longtext,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `order_id` int(11) NOT NULL,
  PRIMARY KEY (`page_content_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `page_content`
--

INSERT INTO `page_content` VALUES (1,'index','Page Heading','STATE OF THE ART ENVIRONMENTAL MONITORING','2016-01-28 16:38:33','2016-01-28 16:47:19','Y',0),(2,'Index','Page Title','With distributed data acquisition | With an central data acquisition','2016-01-28 16:39:02','2016-01-28 16:44:15','Y',0),(3,'Index','Specialized In','<ul>\n	<li>Agriculture and Irrigation</li>\n	<li>Food Processing</li>\n	<li>Construction Industry</li>\n	<li>Live Cycle Monitoring</li>\n</ul>','2016-01-28 16:43:45','2016-05-14 15:22:42','Y',0),(4,'index','General content','in an environment, where efficiency, especially energy and fresh water saving, is a growing task for serious management.','2016-01-28 16:50:49','2016-03-06 22:22:35','N',0),(5,'Products','Products','<div class=\"contact-details\">\n\n                                        <div class=\"contact-detail-single font_18\">\n\n                                          <ul>\n\n                                              <li>Standard Fire and Perils</li>\n                                              <li>Property All Risk</li>\n                                              <li>Office Package</li> \n                                              <li>Business Interruption (Fire)</li>\n                                              <li>Burglary</li>\n                                              <li>Deterioration Of Stock</li>\n                                              <li>Plate Glass</li>\n                                              <li>Public Liability </li>\n                                              <li>Product Liability </li>\n                                              <li>Professional Indemnity </li>\n                                              <li>Director and Officer Liability</li>\n                                              <li>Miscellaneous Accident</li>\n                                              <li>Livestock and bloodstock</li>\n                                              <li>Workmen\'s Compensation / Employers Liability</li> \n                                              \n                                                                                    \n                                          </ul>   \n                                             \n                                        </div>\n\n                                        <div class=\"contact-detail-single font_18\">\n                                        \n                                            <ul>\n                                          \n                                              <li>Kidnap and Ransom</li>\n                                              <li>Money</li>\n                                              <li>Fidelity Guarantee </li>\n                                              <li>Bankers Blanket Bond</li>\n                                              <li>Credit Insurance </li>\n                                              <li>Electronic equipment </li>\n                                              <li>Machinery breakdown</li>\n                                              <li>Marine Hull</li>\n                                              <li>Marine Cargo</li>\n                                              <li>Marine Liability</li>\n                                              <li>Protection & Indemnity</li>\n                                              <li>Good In transit</li>\n                                              <li>Contractor\'s All Risk and Erection All Risk </li>\n                                                                                        \n                                          </ul>   \n                                        \n                                        </div>\n                                        \n                                        \n                                    \n                                    </div>','2016-06-09 17:05:41','2016-12-05 12:29:29','Y',0),(9,'Services','Services','                        <li> <a href=\"#\"><i class=\"fa fa-chevron-right\"></i> Standard Fire and Perils</a></li>\n                        <li>\n                            <a href=\"#\"><i class=\"fa fa-chevron-right\"></i> Property All Risk</a>\n                        </li>\n                        <li><a href=\"#\"><i class=\"fa fa-chevron-right\"></i> Office Package </a></li>\n                        <li><a href=\"#\"><i class=\"fa fa-chevron-right\"></i> Business Interruption (Fire)</a></li>\n                        <li><a href=\"#\"><i class=\"fa fa-chevron-right\"></i> Burglary</a></li>\n                        <li><a href=\"#\"><i class=\"fa fa-chevron-right\"></i> Deterioration  Of Stock</a></li>\n                        <li><a href=\"#\"><i class=\"fa fa-chevron-right\"></i> Public Liability</a></li>\n                        <li><a href=\"#\"><i class=\"fa fa-chevron-right\"></i> Product Liability</a></li>\n                        <li><a href=\"#\"><i class=\"fa fa-chevron-right\"></i> Protection &amp; Indemnity</a></li>','2016-05-17 15:04:33','2016-05-17 15:04:33','Y',0),(11,'Management','Image','<img alt=\"Al Berwaz Insurance Brokers\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/team.jpg\"  />','2016-06-14 16:10:28','2016-06-14 16:10:28','Y',0),(12,'Product listing','Image','<img src=\"http://demo.softunique.net/websites/bib/userfiles/files/product1.jpg\" width=\"300px\" alt=\"Al Berwaz Insurance Brokers\" />','2016-06-14 16:45:47','2016-11-30 11:53:13','Y',0),(13,'Careers','Careers','Careers','2016-06-15 09:33:37','2016-06-15 09:33:37','Y',0),(14,'Management','MD Message','<div class=\"content-wrapper\">\n<h1>MD Message</h1>\n<img alt=\"BIB\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/EyadAlJamal.jpg\" style=\"float:right; margin-left:20px; width:150px\" />\n<p>Dear Valued Partners,<br />\n<br />\nSince company was founded, we are increasing our investments to develop the infrastructure and the workflow by raising the competency and expertise of our staff, enhance the technical and technological means and promote the agreements concluded with the major insurance companies operating in United Arab Emirates in order to reach the highest professional degrees, accuracy and secrecy in line with the new regulations and legislatures, which was developed by the insurance Authority and the bodies of Health in Abu Dhabi and Dubai to save clients&rsquo; interests, transactions and information.<br />\n<br />\nThe company has also working on providing high quality products and services in competitive prices, in addition to the contractual terms and conditions that are consistent with local and international standards for corporate insurance and reinsurance,in order to protect the rights of our clients in insurance claims from the potential risks that may be exposed to their investments, business, employees and dependents, which will reflect positively on their workflow and productivity.<br />\n<br />\nAl Berwaz has worked over 21 years to hire technical, administrative and marketing team with extensive experience in the field of insurance and support them with the latest training programs to enhance their skills and competencies to cope with all the changes in the insurance market, in addition, to establish a contracts with the most important local and regional insurance companies to offer our clients a variety of insurance products, such as health, life, vehicles, engineering projects, real estate, shipping, fire, etc. in competitive prices that meet clients&rsquo; needs and expectations.<br />\n<br />\nThe company has worked also on raising the quality of their services and the speed of performance by dealing with the well reputed information technology and electronic applications companies, which facilitates communication with our customers to answer their queries, follow up on their transactions and claims.<br />\n<br />\nOur ultimate goal is to reach our clients satisfaction by fulfilling their needs and requirements and to meet their expectations which will reflect positively on the bilateral relations in the present and the future.<br />\n<br />\nEyad Al Jamal<br />\nManaging Partner</p>\n\n<div class=\"clear\">&nbsp;</div>\n</div>','2016-10-03 12:16:30','2016-10-03 12:16:30','Y',0),(15,'Partners','Partners','<table border=\"0\" cellpadding=\"1\" cellspacing=\"1\" style=\"width:500px\">\r\n	<tbody>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Abu-Dhabi-National-Takaful1.jpg\" style=\"height:52px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/ADNIC-Insurance-company1.jpg\" style=\"height:52px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/AETNA1.jpg\" style=\"height:52px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Al-Ain-Ahlia-Insurance1.jpg\" style=\"height:51px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Al-Dharfa-Insurace1.jpg\" style=\"height:54px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Al-Ittihad-Al-Watani1.jpg\" style=\"height:53px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Al-Sagr-Insurance1.jpg\" style=\"height:51px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Al-Wathba-National-Insurance1.jpg\" style=\"height:54px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Cigna-Saico2.jpg\" style=\"height:53px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Daman-Insurance1.jpg\" style=\"height:51px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Emirates-Ins.Co_1.jpg\" style=\"height:56px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Expacare2.jpg\" style=\"height:55px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Green-Crescent1.jpg\" style=\"height:60px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Insurance-House2.jpg\" style=\"height:54px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/MetLife1.jpg\" style=\"height:57px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/National-Life-General-Insurance2.jpg\" style=\"height:55px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/NGI2.jpg\" style=\"height:60px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Oman-Bupa2.jpg\" style=\"height:60px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Orient-Insurance1.jpg\" style=\"height:52px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Qatar-Insurance1.jpg\" style=\"height:56px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/RAK-Insurance-Company1.jpg\" style=\"height:46px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/RSA1.jpg\" style=\"height:60px; width:126px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/SBC-UAE-Logo-300x180.png\" style=\"height:120px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Takaful-Emarat1.jpg\" style=\"height:60px; width:200px\" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Union-Insurance-Company-PSC1.jpg\" style=\"height:58px; width:200px\" /></td>\r\n			<td><img alt=\"\" src=\"http://demo.softunique.net/websites/bib/userfiles/files/Zurich1.jpg\" style=\"height:56px; width:200px\" /></td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>','2016-12-05 13:27:03','2016-12-05 13:27:03','Y',0);

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `show_home_page` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `category_id` int(11) NOT NULL,
  `product_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `meta_description` text COLLATE utf8_unicode_ci NOT NULL,
  `meta_keywords` text COLLATE utf8_unicode_ci NOT NULL,
  `basic_content` text COLLATE utf8_unicode_ci NOT NULL,
  `small_description` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `seo_url` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `image_name` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `item_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `features` text COLLATE utf8_unicode_ci NOT NULL,
  `video` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `order_id` int(11) NOT NULL,
  `status` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
  `added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `product`
--


--
-- Table structure for table `product_download`
--

CREATE TABLE `product_download` (
  `product_download_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `download_category_id` int(11) NOT NULL,
  `file_name` varchar(200) CHARACTER SET latin1 NOT NULL,
  `extension` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
  `order_id` int(11) NOT NULL,
  `added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`product_download_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `product_download`
--


--
-- Table structure for table `product_enquiry`
--

CREATE TABLE `product_enquiry` (
  `product_enquiry_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `subject` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`product_enquiry_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `product_enquiry`
--


--
-- Table structure for table `product_gallery`
--

CREATE TABLE `product_gallery` (
  `product_gallery_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `alt` varchar(100) NOT NULL,
  `image_name` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `default_image` enum('Y','N') NOT NULL DEFAULT 'N',
  `added_date` datetime NOT NULL,
  `order_id` int(11) NOT NULL,
  `valid_image` enum('Y','N') NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`product_gallery_id`),
  UNIQUE KEY `product_gallery_id` (`product_gallery_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `product_gallery`
--


--
-- Table structure for table `product_video`
--

CREATE TABLE `product_video` (
  `product_video_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `product_id` varchar(20) NOT NULL,
  `video_type` varchar(20) NOT NULL,
  `title` varchar(100) NOT NULL,
  `video_url` varchar(300) NOT NULL,
  `description` text,
  `added_date` datetime NOT NULL,
  `order_id` int(11) NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`product_video_id`),
  UNIQUE KEY `video_gallery_id` (`product_video_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `product_video`
--

INSERT INTO `product_video` VALUES (1,'2','2','TRIME-PICO64','https://www.youtube.com/watch?v=1q-JSILQSGY','TRIME-PICO32 sensor with internal TDR-electronics\r\n\r\nIMKO‘s intelligent rod probes are highly sophisticated high-tech devices and extremely robust. A unique feature is their integrated TDR electronics, thus achieving the greatest accuracy and best networking capability e.g. digital network cable lengths of up to 3 km are possible for the IMP-Bus version. In contrast to other methods TRIME®-PICO is less effected by disturbing variables such as temperature or electrical conductivity. An integrated','2016-01-18 04:56:25',1,'Y'),(3,'4','2','new title 123','https://www.youtube.com/watch?v=1q-JSILQSGY','','2016-01-18 23:08:23',1,'Y'),(4,'4','2','youtube test','https://www.youtube.com/watch?v=1q-JSILQSGY','','2016-01-18 23:12:52',3,'Y'),(8,'6','2','SONO-WZ the Water/Cement Analyzer','https://www.youtube.com/watch?v=01EYuMPrRmY','Easy handling: Simply place the innovative lance probe SONO-WZ inside the fresh concrete. After 4 to 5 single measurements with the SONO-DIS device, an automatic averaging ensures precise results within 1 to 2 minutes – directly on site.','2016-01-19 05:22:54',4,'Y'),(9,'5','2','TRIME-ES Concrete','https://www.youtube.com/watch?v=h5cPks9v1Lg','Precise measurement of water content of fresh concrete mixtures. As user you will obtain not only the percent moisture value, but also the water content in liter per m 3 by considering of the mass density entered by hand inside the SONO-DIS measurement device.','2016-01-19 05:25:44',5,'Y'),(11,'7','2','video 1','https://www.youtube.com/watch?feature=player_embedded&v=SwrmtozhcAg','','2016-02-04 06:57:48',6,'Y'),(12,'7','2','video 2','https://www.youtube.com/watch?feature=player_embedded&v=fW42CvHHO3Y','','2016-02-05 01:34:39',7,'Y'),(14,'7','2','video 3','https://www.youtube.com/watch?v=4f-Q6N1wrBw&feature=player_embedded','','2016-02-05 01:36:26',8,'Y'),(15,'3','2','The most advanced probe for moisture measurement of sand, gravel and grit','https://www.youtube.com/watch?feature=player_embedded&v=XURe1XRfptU','','2016-02-05 03:44:30',1,'Y');

--
-- Table structure for table `seo_management`
--

CREATE TABLE `seo_management` (
  `seo_management_id` int(11) NOT NULL AUTO_INCREMENT,
  `module_settings_id` int(11) NOT NULL,
  `caption` varchar(200) NOT NULL,
  `seo_key` varchar(100) NOT NULL,
  `seo_value` varchar(100) NOT NULL,
  PRIMARY KEY (`seo_management_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `seo_management`
--

INSERT INTO `seo_management` VALUES (1,242,'Clothing Page Url','cloth','model-cloth'),(5,12,'Category Page','category','category');

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `settings_id` int(4) NOT NULL AUTO_INCREMENT,
  `caption` varchar(50) NOT NULL,
  `keys` varchar(50) NOT NULL,
  `values` text NOT NULL,
  `display` enum('Y','N') NOT NULL,
  PRIMARY KEY (`settings_id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'Website Name','SITE_NAME','Al Berwaz Insurance Brokers','Y'),(2,'Website URL','SITE_URL','http://www.alberwazinsurance.com/','Y'),(3,'Meta Description','META_DESCRIPTION','Al Berwaz Insurance Brokers LLC','Y'),(4,'Meta Keywords','META_KEYWORDS','Al Berwaz Insurance Brokers','Y'),(5,'Client Max. No. of Rows/Page','FRONT_PAGE_LIMIT','15','Y'),(6,'Admin Max. No. of Rows/Page','PAGE_LIMIT','20','Y'),(7,'Admin Email Display Name','ADMIN_EMAIL_NAME','Al Berwaz Insurance Brokers','Y'),(8,'Admin Email','ADMIN_EMAIL_ID','info@alberwazinsurance.com','Y'),(9,'Admin Reply Email','ADMIN_REPLY_EMAIL_ID','info@alberwazinsurance.com','Y'),(10,'Contact Us Email','CONTACT_EMAIL_ID','info@alberwazinsurance.com','Y'),(11,'Bounce  Email','BOUNCE_EMAIL_ID','test@rainend.com','N'),(12,'Minimum Image Width','MIN_IMAGE_WIDTH','280','N'),(13,'Minimum Image Height','MIN_IMAGE_HEIGHT','207','N'),(14,'Maximum Image Width','MAX_IMAGE_WIDTH','745','N'),(15,'Maximum Image Height','MAX_IMAGE_HEIGHT','695','N'),(16,'Maximum Width Of Thumb Image','MAX_THUMB_IMAGE_WIDTH','150','N'),(17,'Maximum Height Of Thumb Image','MAX_THUMB_IMAGE_HEIGHT','209','N'),(18,'Number of emails sent by cron','CRON_EMAIL_COUNT','20','N'),(19,'Admin Page Theme','ADMIN_THEME','gray','N'),(20,'Default county','DEFAULT_COUNTRY','826','N'),(21,'Contact Phone','PHONE','+971 2 626 1555','Y'),(24,'Client Page Title','FRONT_TITLE','Al Berwaz Insurance Brokers','Y'),(25,'Admin Page Title','ADMIN_TITLE','Al Berwaz Insurance Brokers - Administration Control Panel','Y'),(26,'Technical Support Phone','TECHNICAL_SUPPORT_NO','01920870400','N'),(27,'Office Address','ADDRESS','Abu Dhabi, UAE. ','Y'),(28,'Contact Address','CONTACT_ADDRESS','P.O BOX No.: 31116\r\nAbu Dhabi, UAE. ','Y'),(29,'Currency Code','CURRENCY_CODE','GBP','N'),(30,'Shipping Cost','SHIPPING_COST','1','N'),(32,'Language Code','LANGAGE_CODE','GB','N'),(33,'Fax','FAX','+971 2 626 7400','Y'),(34,'Working time','WORKING_TIME','Saturdays 8 am - 3 pm Hatfield Market Square','N'),(35,'Email id list to show on footer contact us section','FOOTER_EMAIL_ID','test@rainend.com\r\n \r\n\r\n','N'),(36,'Copy Right','COPY_RIGHT','Al Berwaz Insurance Brokers','Y'),(40,'Facebook URL','FACEBOOK_URL','https://www.facebook.com/','Y'),(41,'Twitter URL','TWITTER_URL','https://twitter.com/','Y'),(42,'Sandbox Account	','SANDBOX_ACCOUNT','developer-developer@rainend.com',''),(43,'Paypal Account','PAYPAL_ACCOUNT','developer-developer@rainend.com',''),(44,'Package Amount','PACKAGE_AMOUNT','5','N'),(45,'Currency symbol','CURRENCY_SYMBOL','&#36;','N'),(46,'Paypal api username','PAYPAL_API_USERNAME','developer-facilitator_api1.rainend.com','N'),(47,'Paypal api password','PAYPAL_API_PASSWORD','1376659693','N'),(48,'Paypal api signature','PAYPAL_API_SIGNATURE','AQU0e5vuZCvSg-XJploSa.sGUDlpAnm0AUBByIKbbKKGHNP5A7XMvq4P\r\n','N'),(49,'Paypal Test Mode','PAYPAL_TEST_MODE','1','N'),(50,'Sandbox api username','SANDBOX_API_USERNAME','developer-facilitator_api1.rainend.com','N'),(51,'Sandbox api password','SANDBOX_API_PASSWORD','1376659693','N'),(52,'Sandbox api signature','SANDBOX_API_SIGNATURE','AQU0e5vuZCvSg-XJploSa.sGUDlpAnm0AUBByIKbbKKGHNP5A7XMvq4P\r\n','N'),(53,'Facebook APP Id','FB_APP_ID','708853272593702','N'),(54,'Facebook APP Secret','FB_APP_SECRET','e441631b1aa23eae7d346ae80373bea5','N'),(55,'Google Client ID','GOOGLE_CLIENT_ID','614423535242-e257n2ov9o1fol441nk17dbvlkqrmg69.apps.googleusercontent.com','N'),(56,'Google Client Secret','GOOGLE_CLIENT_SECRET','sL_hnsuOP1rYP0lQSJk8FO_k','N'),(57,'Google Redirect Url','GOOGLE_REDIRECT_URL','http://clients.rainend.com/tutoros/','N'),(58,'Google Developer Key','GOOGLE_DEVELOPER_KEY','AIzaSyDkbDaXgCjBOQk3sGU8g0uAP9W3jvH9b9I','N'),(59,'SMTP Host','SMTP_HOST','smtp.gmail.com','N'),(60,'SMTP Port','SMTP_PORT','587','N'),(61,'SMTP Username','SMTP_USERNAME','','N'),(62,'SMTP Password','SMTP_PASSWORD','','N'),(63,'SMTP Secure','SMTP_SECURE','tls','N'),(64,'SMTP','SMTP','N','N'),(65,'Google Plus URL','GOOGLE_PLUS_URL','https://plus.google.com/','Y');

--
-- Table structure for table `slug_name`
--

CREATE TABLE `slug_name` (
  `slug_name_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `slug_name` varchar(300) NOT NULL,
  `slug_value` varchar(300) NOT NULL,
  `prev_url` varchar(1000) NOT NULL,
  `meta_val` enum('Y','N') NOT NULL DEFAULT 'N',
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `order_id` int(11) NOT NULL,
  PRIMARY KEY (`slug_name_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slug_name`
--

INSERT INTO `slug_name` VALUES (1,'Product listing','product','','Y','Y',0),(2,'Contact Us','contact us','','Y','Y',0),(3,'Our Staffs','our-staffs','','Y','Y',0),(4,'About Us','about us','','Y','Y',0),(5,'Services','services','','Y','Y',0);

--
-- Table structure for table `temp_product_gallery`
--

CREATE TABLE `temp_product_gallery` (
  `temp_product_gallery_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `image_name` varchar(255) CHARACTER SET latin1 NOT NULL,
  `added_time` datetime NOT NULL,
  PRIMARY KEY (`temp_product_gallery_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `temp_product_gallery`
--


--
-- Table structure for table `user_logging`
--

CREATE TABLE `user_logging` (
  `pk_bint_user_logging` bigint(20) NOT NULL AUTO_INCREMENT,
  `fk_int_admin_id` bigint(20) NOT NULL COMMENT 'Logged Dealer Id',
  `tim_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tim_logout` datetime NOT NULL,
  `vchr_mac_address` varchar(150) NOT NULL,
  `vchr_ip_address` varchar(150) NOT NULL,
  `vchr_host_name` varchar(150) NOT NULL,
  PRIMARY KEY (`pk_bint_user_logging`)
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_logging`
--

INSERT INTO `user_logging` VALUES (46,1,'2016-05-27 06:41:16','2016-05-27 17:13:34','','',''),(47,1,'2016-05-28 03:54:19','0000-00-00 00:00:00','','',''),(48,1,'2016-05-30 04:31:31','0000-00-00 00:00:00','','',''),(49,1,'2016-05-31 04:09:25','0000-00-00 00:00:00','','',''),(50,1,'2016-06-01 03:34:24','0000-00-00 00:00:00','','',''),(51,1,'2016-06-01 06:17:00','0000-00-00 00:00:00','','',''),(52,1,'2016-06-01 08:55:21','0000-00-00 00:00:00','','',''),(53,1,'2016-06-02 06:40:25','0000-00-00 00:00:00','','',''),(54,1,'2016-06-02 07:21:46','0000-00-00 00:00:00','','',''),(55,1,'2016-06-04 06:58:52','2016-06-04 12:37:33','','',''),(56,1,'2016-06-07 03:52:58','2016-06-07 17:25:40','','',''),(57,1,'2016-06-08 09:18:17','2016-06-08 15:11:45','','',''),(58,1,'2016-06-08 09:59:13','2016-06-08 15:43:11','','',''),(59,1,'2016-06-08 11:01:52','0000-00-00 00:00:00','','',''),(60,1,'2016-06-08 11:07:33','0000-00-00 00:00:00','','',''),(61,1,'2016-06-08 11:39:16','0000-00-00 00:00:00','','',''),(62,1,'2016-06-08 11:40:40','2016-06-08 11:49:26','','',''),(63,1,'2016-06-08 11:53:02','2016-06-08 12:16:19','','',''),(64,1,'2016-06-08 12:11:42','0000-00-00 00:00:00','','',''),(65,1,'2016-06-08 12:16:32','0000-00-00 00:00:00','','',''),(66,1,'2016-06-08 12:21:32','0000-00-00 00:00:00','','',''),(67,1,'2016-06-08 12:25:29','0000-00-00 00:00:00','','',''),(68,1,'2016-06-09 04:05:05','0000-00-00 00:00:00','','',''),(69,1,'2016-06-09 04:34:18','2016-06-09 04:35:35','','',''),(70,1,'2016-06-09 11:17:07','0000-00-00 00:00:00','','',''),(71,1,'2016-06-10 03:55:43','2016-06-10 11:40:26','','',''),(72,1,'2016-06-11 04:24:04','2016-06-11 07:08:58','','',''),(73,1,'2016-06-11 11:58:25','2016-06-11 11:58:39','','',''),(74,1,'2016-06-12 05:03:53','0000-00-00 00:00:00','','',''),(75,1,'2016-06-12 12:57:48','0000-00-00 00:00:00','','',''),(76,1,'2016-06-12 13:34:00','0000-00-00 00:00:00','','',''),(77,1,'2016-06-13 03:46:33','0000-00-00 00:00:00','','',''),(78,1,'2016-06-13 07:28:13','0000-00-00 00:00:00','','',''),(79,1,'2016-06-13 09:30:26','0000-00-00 00:00:00','','',''),(80,1,'2016-06-13 11:49:13','0000-00-00 00:00:00','','',''),(81,1,'2016-06-13 13:00:12','0000-00-00 00:00:00','','',''),(82,1,'2016-06-13 13:04:31','0000-00-00 00:00:00','','',''),(83,1,'2016-06-13 16:26:35','0000-00-00 00:00:00','','',''),(84,1,'2016-06-14 03:49:21','0000-00-00 00:00:00','','',''),(85,1,'2016-06-14 03:57:22','0000-00-00 00:00:00','','',''),(86,1,'2016-06-14 10:08:21','0000-00-00 00:00:00','','',''),(87,1,'2016-06-15 03:57:49','0000-00-00 00:00:00','','',''),(88,1,'2016-06-15 08:52:24','0000-00-00 00:00:00','','',''),(89,1,'2016-06-15 15:08:29','2016-06-15 18:59:11','','',''),(90,1,'2016-06-15 21:51:57','0000-00-00 00:00:00','','',''),(91,1,'2016-06-16 03:44:21','0000-00-00 00:00:00','','',''),(92,1,'2016-06-16 05:34:08','0000-00-00 00:00:00','','',''),(93,1,'2016-06-16 06:11:07','0000-00-00 00:00:00','','',''),(94,1,'2016-06-16 06:56:40','0000-00-00 00:00:00','','',''),(95,1,'2016-06-16 09:08:12','0000-00-00 00:00:00','','',''),(96,1,'2016-06-16 10:09:00','0000-00-00 00:00:00','','',''),(97,1,'2016-06-17 03:47:57','2016-06-17 06:00:12','','',''),(98,1,'2016-06-26 11:07:33','0000-00-00 00:00:00','','',''),(99,1,'2016-06-27 07:36:06','0000-00-00 00:00:00','','',''),(100,1,'2016-08-10 10:08:47','2016-08-10 11:20:22','','',''),(101,1,'2016-10-03 04:42:45','2016-10-03 11:35:26','','',''),(102,1,'2016-10-07 07:51:14','0000-00-00 00:00:00','','',''),(103,1,'2016-11-01 15:13:27','0000-00-00 00:00:00','','',''),(104,1,'2016-11-30 11:49:40','0000-00-00 00:00:00','','',''),(105,1,'2016-12-05 10:58:57','0000-00-00 00:00:00','','',''),(106,1,'2016-12-07 05:49:56','0000-00-00 00:00:00','','',''),(107,1,'2017-01-13 18:50:12','0000-00-00 00:00:00','','',''),(108,1,'2017-02-07 08:13:07','0000-00-00 00:00:00','','',''),(109,2,'2017-05-12 09:37:27','0000-00-00 00:00:00','','',''),(110,1,'2017-05-12 09:37:39','0000-00-00 00:00:00','','',''),(111,2,'2017-05-12 10:31:16','0000-00-00 00:00:00','','',''),(112,2,'2017-05-12 10:32:45','0000-00-00 00:00:00','','',''),(113,2,'2017-05-13 07:22:28','0000-00-00 00:00:00','','',''),(114,1,'2017-05-17 04:33:33','0000-00-00 00:00:00','','',''),(115,2,'2017-05-19 20:36:47','0000-00-00 00:00:00','','',''),(116,1,'2017-05-30 05:12:48','0000-00-00 00:00:00','','',''),(117,1,'2017-06-12 20:16:25','2017-06-12 21:19:43','','',''),(118,2,'2017-06-14 17:30:05','0000-00-00 00:00:00','','',''),(119,2,'2017-06-21 05:33:19','2017-06-21 06:33:32','','',''),(120,2,'2017-07-03 19:12:16','2017-07-03 20:16:59','','',''),(121,2,'2017-07-05 19:20:06','2017-07-05 20:20:13','','',''),(122,2,'2017-07-11 11:58:25','2017-07-11 12:59:23','','',''),(123,2,'2017-07-12 21:24:21','2017-07-12 22:24:31','','',''),(124,2,'2017-07-12 21:25:40','2017-07-12 22:25:46','','',''),(125,1,'2017-07-13 09:17:50','2017-07-13 10:19:04','','',''),(126,1,'2017-07-13 09:25:16','0000-00-00 00:00:00','','',''),(127,2,'2017-08-22 07:22:10','0000-00-00 00:00:00','','',''),(128,2,'2017-10-16 17:52:43','0000-00-00 00:00:00','','',''),(129,2,'2018-03-04 08:36:47','0000-00-00 00:00:00','','',''),(130,2,'2018-03-27 05:39:40','0000-00-00 00:00:00','','',''),(131,2,'2018-07-29 06:50:45','0000-00-00 00:00:00','','','');

--
-- Dumping routines for database 'cl51-sucdata'
--


