-- phpMyAdmin SQL Dump
-- version 4.0.10.18
-- https://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Apr 10, 2017 at 01:28 PM
-- Server version: 5.6.35-cll-lve
-- PHP Version: 5.6.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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: `d2fajrid_aasiasteel`
--

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

--
-- Table structure for table `about_us`
--

CREATE TABLE IF NOT EXISTS `about_us` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Title` varchar(100) NOT NULL,
  `Description` text NOT NULL,
  `Image` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `about_us`
--

INSERT INTO `about_us` (`id`, `Title`, `Description`, `Image`) VALUES
(1, 'Company Profile', '<p>Aasia Steel is an ISO, API and ASME certified manufacturer with a team of highly skilled individuals providing specialized services and products primarily to local and international clients involved in the construction of the oil &amp; gas, petrochemical, fertilizer, power, desalination and infrastructure sectors</p>', 'IMG_0326(1).jpg'),
(2, 'Our Vision', '<p>To be a leading manufacturer and service provider in the energy sector in the MENA region. And to exceed our clients expectations in quality, delivery, and cost. and to exceed our clients expectations in quality, delivery, and cost</p>', 'vision.jpg'),
(3, 'Engineering Capabilities', '<p>AASIA''s engineering resources are well established in structural steel and weld overlay cladding works. AASIA engineering team has a wide-range of capabilities that includes but not limited to the following:</p>\r\n\r\n<p><br />\r\n<strong>=&gt; Material sourcing and availability studies<br />\r\n=&gt; Alternative designs and cost evaluations<br />\r\n=&gt; Stress analysis and calculations<br />\r\n=&gt; Pipe spooling drawings</strong><strong>&nbsp;</strong></p>', 'Engineering.jpg'),
(4, 'QA/QC Policy', '<p>We are committed to total customer satisfaction, and compliance with regulatory bodies at all times, at maximum effectiveness and minimal cost by ensuring that all products and services fully meet or exceed customers'' requirements and providing high level of personal.</p>\r\n\r\n<p>The quality policy is based on 3 fundamental principles:</p>\r\n\r\n<p>&nbsp;&nbsp;&nbsp; Ensuring that we fully identify and conform to the needs of our customers<br />\r\n&nbsp;&nbsp;&nbsp; Looking at our service provision processes, identifying the potential for errors and taking the necessary action to eliminate them<br />\r\n&nbsp;&nbsp;&nbsp; Everyone understanding how to do their job and doing it right first time</p>\r\n\r\n<p>To ensure that the policy is successfully implemented, staff will be responsible for identifying customer requirements, and ensuring that the correct procedures are followed to meet those requirements.</p>\r\n\r\n<p>Objectives needed to ensure that the requirements of this policy are met and that continual improvement is maintained in line with the spirit of the policy, will be set, determined and monitored at management review.</p>\r\n\r\n<p>The quality policy principles and objectives will be communicated and available to staff at all times. Training will be an integral part of the strategy to achieve the objectives.</p>\r\n\r\n<p>Within this policy we are committed to operate within the disciplines and control of a quality management system conforming to the international standard ISO 9001:2008, planned and developed jointly with our other management functions.</p>\r\n\r\n<p>We are all committed to operating continuously to this standard and we will maintain the necessary quality approvals consistent with our customer requirements.</p>\r\n\r\n<p>Our company will constantly review and improve on our services to ensure tasks are completed in the most cost effective and timely manner for the benefit of all our customers.</p>\r\n\r\n<p>We shall ensure that all our personnel understand and fully implement our company''s policies and objectives and are able to perform their duties effectively through an ongoing training and development programme.</p>', 'QC3.JPG'),
(5, 'HSE Policy', '<p>Aasia Steel Factory Company Limited (AASIA) is committed to achieve and maintain excellence in health, safety, and environment (HSE). AASIA shall conduct business in a manner that protects the safety and health of our employees, contractors, customers, and the community. AASIA shall constantly demonstrate a proactive approach towards environmental stewardship and continual improvement</p>\r\n\r\n<p>HSE excellence will be achieved through the leadership and commitment of management, implementation and communication of a management system approach, and maintaining compliance to our policies and standards. Active commitment and proactive support of HSE programs and initiatives is required by employees of Aasia Steel Factory Company Limited:</p>\r\n\r\n<ul>\r\n	<li>Our belief is that safety, health, and environmental accidents are preventable</li>\r\n	<li>Protect the health, safety and environment of our employees, contractors, customers and the community</li>\r\n	<li>Promote and maintain a work environment in which each one accepts personal responsibility for our own safety , and in which everyone is empowered to intervene to ensure the safety of their fellow employees and others</li>\r\n	<li>Use of an effective HSE management system which serves as the framework for the setting of goals and performance objectives aimed at continuous improvement</li>\r\n	<li>Monitor and evaluate our HSE performance through the definition and use of key performance indicators, implementation of, and compliance to operational and regulatory standards, training (technical, operational, behavior-based Safety and human factors) and assessments and audits</li>\r\n	<li>Educate our employees by providing technical, regulatory, operational, and behavior-based Safety /human factors training focused on developing a culture of excellence</li>\r\n	<li>A basic obligation to comply with applicable laws and regulations where we operate</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The commitment to this policy by employees of Aasia Steel Factory Company Limited provides the foundation for risk management, operational excellence, and long term business success</p>', 'hse.jpg');

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

--
-- Table structure for table `careers`
--

CREATE TABLE IF NOT EXISTS `careers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Title` varchar(100) NOT NULL,
  `Description` text NOT NULL,
  `Image` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `careers`
--

INSERT INTO `careers` (`id`, `Title`, `Description`, `Image`) VALUES
(1, 'S. Engineer', '<p>S. Engineer</p>', 'Mehdi-Tehrani-Austin-Engineering-Structural-Engineer.jpg');

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

--
-- Table structure for table `contact_us`
--

CREATE TABLE IF NOT EXISTS `contact_us` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Business_Hours` varchar(50) NOT NULL,
  `Business_Day` varchar(50) NOT NULL,
  `Day_Off` varchar(30) NOT NULL,
  `Address` text NOT NULL,
  `Phone` varchar(15) NOT NULL,
  `Fax` varchar(15) NOT NULL,
  `EmailId` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `contact_us`
--

INSERT INTO `contact_us` (`id`, `Business_Hours`, `Business_Day`, `Day_Off`, `Address`, `Phone`, `Fax`, `EmailId`) VALUES
(1, '08:00 - 17:00', 'Sunday - Thursday', 'Friday-Saturday', 'Road 118, Support Industries-3\r\nP.O. Box: 10372\r\nJubail Industrial City 31961', '+966-03-3408414', '+966-03-3404625', 'info@aasiasteel.com');

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

--
-- Table structure for table `projects`
--

CREATE TABLE IF NOT EXISTS `projects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Title` varchar(100) NOT NULL,
  `Description` text NOT NULL,
  `Image` text,
  `Featured` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `Title`, `Description`, `Image`, `Featured`) VALUES
(1, 'CHINA HARBOUR', '<p>Structure for maintenance building</p>', NULL, 1),
(2, 'SAMSUNG', '<p>Process Equipment Structure</p>', NULL, 1),
(3, 'PETROL STEEL', '<p>Tank farm piperack structure</p>', NULL, 1);

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

--
-- Table structure for table `project_images`
--

CREATE TABLE IF NOT EXISTS `project_images` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ProjectId` int(11) NOT NULL,
  `Images` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `project_images`
--

INSERT INTO `project_images` (`id`, `ProjectId`, `Images`) VALUES
(1, 1, 'DSC00639.JPG'),
(2, 1, 'hse(1).jpg'),
(3, 1, 'Engineering(1).jpg'),
(4, 1, 'DSC00645.JPG');

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

--
-- Table structure for table `services`
--

CREATE TABLE IF NOT EXISTS `services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Title` varchar(100) NOT NULL,
  `Description` text NOT NULL,
  `Image` text,
  `Featured` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `Title`, `Description`, `Image`, `Featured`) VALUES
(3, 'CRA Clad Pipe (Weld Overlay Technique)', '<p>At our facility alone we have 30 vertical 20 horizontal weld overlay machines suited to pipe diameters from 6&rdquo; to 66&rdquo;, all able to handle 12m random lengths. Our weld overlay capability also extends to small diameters based on cladding shorter pipe lengths.</p>\r\n\r\n<p>Once clad, our pipes (as required) undergo full hydrostatic testing to prove product integrity. Our test facility is capable to handle pressures up to 20,000 psi. CRA Clad pipe is also extensively Non Destructively Examined to ensure product quality.&nbsp;</p>', 'IMG_0344(2).jpg', 1),
(4, 'CRA Clad Fittings and Flanges', '<p>Aasia Steel has an extensive range of equipment to weld overlay clad of fittings &amp; flanges, and special fittings. This includes vertical machines to suit all diameters from 2&rdquo; to 66&rdquo;.</p>', 'Blind Flange1.JPG', 1),
(5, 'Fabrication', '<p>Aasia Steel Fabrication Division has become a key factor in our service range as we continue to provide clients with a complete turnkey engineering solution.</p>', 'fabrication 1.jpg', 1),
(6, 'API Products', '<p style="text-align: justify;">Aasia Steel is certified to manufacture API 6A (Wellhead &amp; Xmas Tree equipment) and 16A (Drill through equipment) Products, especially weld neck &amp; blind flanges for wellhead piping.</p>\r\n\r\n<p style="text-align: justify;">Ranging size from 2&rdquo; to 20&rdquo;.flanges material grade shall be based on customer&rsquo;s specification &amp; requirement.</p>', 'images.jpg', 1),
(7, 'Heat Treatment', '<p style="text-align:justify">We have our own heat treatment facility to meet the customer requirement.<br />\r\nAll Our Testing instruments are calibrated as per international standards &amp; quality management system to ensure supreme accuracy. Every furnace is surveyed every 12 months in line with API 6A &amp; 16A requirements.</p>', 'heat tratment.jpg', 1),
(8, 'Machining', '<p>Our machining division is providing solutions to some of the world''s leading projects and global companies.</p>', 'IMG_0490.jpg', 1),
(9, 'Testing', '<p>Our Facility is equipped to perform the following range of testing in house.</p>\r\n\r\n<p>NDT, DPT (water washable technique), MT, UT</p>\r\n\r\n<p>Hardness</p>\r\n\r\n<p>PMI</p>\r\n\r\n<p>CRA Clad Line Pipe shop Hydro testing</p>\r\n\r\n<p>Other Mechanical &amp; Chemical Test are performed through well-known 3<sup>rd</sup> party Laboratories (Exova, SGS, etc.)&nbsp;</p>', 'images (1).jpg', 1);

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

--
-- Table structure for table `slider`
--

CREATE TABLE IF NOT EXISTS `slider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Title` varchar(30) DEFAULT NULL,
  `Image` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `Title`, `Image`) VALUES
(1, 'Slide1', 'banner4.jpg'),
(2, 'Title2', 'banner5.jpg'),
(3, 'Title3', 'banner3.jpg'),
(4, 'Title4', 'IMG_0406.jpg'),
(6, 'slide 5', 'IMG_0326.jpg'),
(7, 'slide 7', 'IMG_0486.jpg');

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

--
-- Table structure for table `subscribe`
--

CREATE TABLE IF NOT EXISTS `subscribe` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Emailid` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `User_Name` varchar(15) NOT NULL,
  `Password` text NOT NULL,
  `UserEmail` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `User_Name`, `Password`, `UserEmail`) VALUES
(1, 'admin', '54b0daedd50c222ca45a9c846ad344cc', 'admin@fajri.com');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
