
-- phpMyAdmin SQL Dump
-- version 2.11.11.3
-- http://www.phpmyadmin.net
--
-- Host: 68.178.143.158
-- Generation Time: Mar 17, 2017 at 02:18 AM
-- Server version: 5.5.43
-- PHP Version: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

--
-- Database: `pmAnywhere3`
--

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

--
-- Table structure for table `tierone`
--

CREATE TABLE `tierone` (
  `tierone_id` int(11) NOT NULL AUTO_INCREMENT,
  `tierone_code` varchar(10) NOT NULL,
  `tierone_name` varchar(100) NOT NULL,
  `tierone_categoryID` varchar(100) NOT NULL,
  `tierone_subcategoryID` varchar(100) NOT NULL,
  `tierone_creation_date` varchar(50) NOT NULL,
  `tierone_company_id` int(11) NOT NULL,
  `tierone_status` int(11) NOT NULL,
  `tierone_notes` longtext NOT NULL,
  PRIMARY KEY (`tierone_id`),
  KEY `tierone_company_id` (`tierone_company_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tierone`
--

INSERT INTO `tierone` VALUES(1, 'ITH', 'Information Technology Hardware', '3', '26', '2017-03-13', 261, 1, 'Information technology. Any equipment or interconnected system or subsystem of equipment, that is used in the automatic acquisition, storage, manipulation, management, movement, control, display, switching, interchange, transmission, or reception of data or information. The term ITH ''information technology hardware'' includes computers and ancillary equipment. ITS ''information technology software'' includes software, firmware and similar procedures, services (including support services), and related resources.');
INSERT INTO `tierone` VALUES(2, 'HAP', 'Household Appliances', '3', '26', '2017-03-13', 261, 1, 'e.g. TV, Air-Conditioner, Stove, Refrigerator etc');
INSERT INTO `tierone` VALUES(3, 'ETM', 'Electronic Technology Machines', '3', '26', '2017-03-13', 261, 1, 'e.g. Fax Machines, Telephone Systems, ');
INSERT INTO `tierone` VALUES(4, 'SAF', 'Safety', '3', '26', '2017-03-13', 261, 1, 'All equipment and tools related to Workplace Safety');
INSERT INTO `tierone` VALUES(5, 'HTH', 'Health', '3', '26', '2017-03-13', 261, 1, 'All equipment and tools related to Health Sciences and Biomedical Engineering');
