-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 06, 2015 at 05:02 AM
-- Server version: 5.1.37
-- PHP Version: 5.3.0

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: `quick_media_hcms`
--

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

--
-- Table structure for table `tbl_account`
--

CREATE TABLE IF NOT EXISTS `tbl_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_no` varchar(50) NOT NULL,
  `account_name` varchar(100) NOT NULL,
  `address` text NOT NULL,
  `phone_no` varchar(100) NOT NULL,
  `mobile_no` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `website` varchar(100) NOT NULL,
  `license` varchar(100) NOT NULL,
  `timezone_id` int(11) NOT NULL,
  `country_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `currency_id` int(11) NOT NULL,
  `number_format_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbl_account`
--

INSERT INTO `tbl_account` (`id`, `account_no`, `account_name`, `address`, `phone_no`, `mobile_no`, `email`, `website`, `license`, `timezone_id`, `country_id`, `language_id`, `currency_id`, `number_format_id`, `date`, `time`, `a_status`) VALUES
(1, '123', 'PHP Hospital Management System', '#000 Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempd tempor incid.', '(00) 000-0000', '(000)-0000000', 'email@domain.com', 'www.domain.com', '00000000001', 0, 0, 1, 0, 0, '2015-01-08', '08:00:00', 1);

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

--
-- Table structure for table `tbl_bed`
--

CREATE TABLE IF NOT EXISTS `tbl_bed` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bed_no` varchar(100) NOT NULL,
  `bed` varchar(100) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `tbl_bed`
--

INSERT INTO `tbl_bed` (`id`, `bed_no`, `bed`, `user_id`, `date`, `time`, `a_status`) VALUES
(1, '151', 'Bed 00001', 2, '2015-07-11', '11:35:37', 1),
(2, '152', 'Bed 00002', 2, '2015-07-11', '11:35:37', 1),
(3, '153', 'Bed 00003', 2, '2015-07-11', '11:35:37', 1),
(4, '154', 'Bed 00004', 2, '2015-07-11', '11:35:37', 1),
(5, '155', 'Bed 00005', 2, '2015-07-11', '11:35:37', 1),
(6, '156', 'Bed 00006', 2, '2015-07-11', '11:35:37', 1),
(7, '157', 'Bed 00007', 2, '2015-07-11', '11:35:37', 1),
(8, '158', 'Bed 00008', 2, '2015-07-11', '11:35:37', 1),
(9, '159', 'Bed 00009', 2, '2015-07-11', '11:35:37', 1),
(10, '1510', 'Bed 000010', 2, '2015-07-11', '11:35:37', 1);

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

--
-- Table structure for table `tbl_civil_status`
--

CREATE TABLE IF NOT EXISTS `tbl_civil_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `civil_status` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `tbl_civil_status`
--

INSERT INTO `tbl_civil_status` (`id`, `civil_status`) VALUES
(1, 'Single'),
(2, 'Married'),
(3, 'Widow(er)'),
(4, 'Defacto'),
(5, 'Traditional'),
(6, 'Child'),
(7, 'Newborn'),
(8, 'Separated');

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

--
-- Table structure for table `tbl_consultant`
--

CREATE TABLE IF NOT EXISTS `tbl_consultant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `consultant_no` varchar(50) NOT NULL,
  `image` varchar(255) NOT NULL,
  `firstname` varchar(100) NOT NULL,
  `middlename` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `birth_date` date NOT NULL,
  `gender` varchar(10) NOT NULL,
  `address` text NOT NULL,
  `phone_no` varchar(100) NOT NULL,
  `mobile_no` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `tbl_consultant`
--

INSERT INTO `tbl_consultant` (`id`, `consultant_no`, `image`, `firstname`, `middlename`, `lastname`, `birth_date`, `gender`, `address`, `phone_no`, `mobile_no`, `email`, `user_id`, `date`, `time`, `a_status`) VALUES
(1, '151', '', 'Turner', 'Wall', 'Durham', '1978-07-31', 'Male', '', '', '', '', 1, '2015-07-15', '23:31:55', 1),
(2, '152', '', 'Faith', 'Bryan', 'Deane', '1997-07-17', 'Female', '', '', '', '', 1, '2015-07-17', '17:10:43', 1),
(3, '153', '', 'Charles', 'Mathew', 'Lewis', '1990-07-28', 'Male', '', '', '', '', 1, '2015-07-17', '17:11:03', 1),
(4, '154', '', 'Anderson', 'Cay', 'Brook', '1955-07-10', 'Male', '', '', '', '', 1, '2015-07-17', '17:11:24', 1),
(5, '155', '', 'Collyson', 'Park', 'Swish', '1996-07-06', 'Female', '', '', '', '', 1, '2015-07-17', '17:11:41', 1),
(6, '156', '', 'Dalton', 'Gibson', 'Hawton', '1996-07-31', 'Male', '', '', '', '', 1, '2015-07-17', '17:12:44', 1),
(7, '157', '', 'Hunter', 'Marley', 'Potter', '1982-07-10', 'Male', '', '', '', '', 1, '2015-07-17', '17:13:14', 1),
(8, '158', '', 'Rusell', 'West', 'Scotland', '1964-04-30', 'Male', '', '', '', '', 1, '2015-07-17', '17:13:53', 1),
(9, '159', '', 'Tiller', 'Chandler', 'Wilfred', '1977-06-01', 'Male', '', '', '', '', 1, '2015-07-17', '17:14:12', 1),
(10, '1510', '', 'Tobie', 'Wright', 'Ray', '1954-07-30', 'Male', '', '', '', '', 1, '2015-07-17', '17:14:37', 1);

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

--
-- Table structure for table `tbl_country`
--

CREATE TABLE IF NOT EXISTS `tbl_country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` char(2) COLLATE utf8_bin DEFAULT NULL,
  `country` varchar(45) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_country_code` (`code`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=253 ;

--
-- Dumping data for table `tbl_country`
--

INSERT INTO `tbl_country` (`id`, `code`, `country`) VALUES
(1, 'AD', 'Andorra'),
(2, 'AE', 'United Arab Emirates'),
(3, 'AF', 'Afghanistan'),
(4, 'AG', 'Antigua and Barbuda'),
(5, 'AI', 'Anguilla'),
(6, 'AL', 'Albania'),
(7, 'AM', 'Armenia'),
(8, 'AN', 'Netherlands Antilles'),
(9, 'AO', 'Angola'),
(10, 'AQ', 'Antarctica'),
(11, 'AR', 'Argentina'),
(12, 'AS', 'American Samoa'),
(13, 'AT', 'Austria'),
(14, 'AU', 'Australia'),
(15, 'AW', 'Aruba'),
(16, 'AX', 'Aland Islands'),
(17, 'AZ', 'Azerbaijan'),
(18, 'BA', 'Bosnia and Herzegovina'),
(19, 'BB', 'Barbados'),
(20, 'BD', 'Bangladesh'),
(21, 'BE', 'Belgium'),
(22, 'BF', 'Burkina Faso'),
(23, 'BG', 'Bulgaria'),
(24, 'BH', 'Bahrain'),
(25, 'BI', 'Burundi'),
(26, 'BJ', 'Benin'),
(27, 'BL', 'Saint Barthélemy'),
(28, 'BM', 'Bermuda'),
(29, 'BN', 'Brunei'),
(30, 'BO', 'Bolivia'),
(31, 'BQ', 'Bonaire, Saint Eustatius and Saba '),
(32, 'BR', 'Brazil'),
(33, 'BS', 'Bahamas'),
(34, 'BT', 'Bhutan'),
(35, 'BV', 'Bouvet Island'),
(36, 'BW', 'Botswana'),
(37, 'BY', 'Belarus'),
(38, 'BZ', 'Belize'),
(39, 'CA', 'Canada'),
(40, 'CC', 'Cocos Islands'),
(41, 'CD', 'Democratic Republic of the Congo'),
(42, 'CF', 'Central African Republic'),
(43, 'CG', 'Republic of the Congo'),
(44, 'CH', 'Switzerland'),
(45, 'CI', 'Ivory Coast'),
(46, 'CK', 'Cook Islands'),
(47, 'CL', 'Chile'),
(48, 'CM', 'Cameroon'),
(49, 'CN', 'China'),
(50, 'CO', 'Colombia'),
(51, 'CR', 'Costa Rica'),
(52, 'CS', 'Serbia and Montenegro'),
(53, 'CU', 'Cuba'),
(54, 'CV', 'Cape Verde'),
(55, 'CW', 'Curaçao'),
(56, 'CX', 'Christmas Island'),
(57, 'CY', 'Cyprus'),
(58, 'CZ', 'Czech Republic'),
(59, 'DE', 'Germany'),
(60, 'DJ', 'Djibouti'),
(61, 'DK', 'Denmark'),
(62, 'DM', 'Dominica'),
(63, 'DO', 'Dominican Republic'),
(64, 'DZ', 'Algeria'),
(65, 'EC', 'Ecuador'),
(66, 'EE', 'Estonia'),
(67, 'EG', 'Egypt'),
(68, 'EH', 'Western Sahara'),
(69, 'ER', 'Eritrea'),
(70, 'ES', 'Spain'),
(71, 'ET', 'Ethiopia'),
(72, 'FI', 'Finland'),
(73, 'FJ', 'Fiji'),
(74, 'FK', 'Falkland Islands'),
(75, 'FM', 'Micronesia'),
(76, 'FO', 'Faroe Islands'),
(77, 'FR', 'France'),
(78, 'GA', 'Gabon'),
(79, 'GB', 'United Kingdom'),
(80, 'GD', 'Grenada'),
(81, 'GE', 'Georgia'),
(82, 'GF', 'French Guiana'),
(83, 'GG', 'Guernsey'),
(84, 'GH', 'Ghana'),
(85, 'GI', 'Gibraltar'),
(86, 'GL', 'Greenland'),
(87, 'GM', 'Gambia'),
(88, 'GN', 'Guinea'),
(89, 'GP', 'Guadeloupe'),
(90, 'GQ', 'Equatorial Guinea'),
(91, 'GR', 'Greece'),
(92, 'GS', 'South Georgia and the South Sandwich Islands'),
(93, 'GT', 'Guatemala'),
(94, 'GU', 'Guam'),
(95, 'GW', 'Guinea-Bissau'),
(96, 'GY', 'Guyana'),
(97, 'HK', 'Hong Kong'),
(98, 'HM', 'Heard Island and McDonald Islands'),
(99, 'HN', 'Honduras'),
(100, 'HR', 'Croatia'),
(101, 'HT', 'Haiti'),
(102, 'HU', 'Hungary'),
(103, 'ID', 'Indonesia'),
(104, 'IE', 'Ireland'),
(105, 'IL', 'Israel'),
(106, 'IM', 'Isle of Man'),
(107, 'IN', 'India'),
(108, 'IO', 'British Indian Ocean Territory'),
(109, 'IQ', 'Iraq'),
(110, 'IR', 'Iran'),
(111, 'IS', 'Iceland'),
(112, 'IT', 'Italy'),
(113, 'JE', 'Jersey'),
(114, 'JM', 'Jamaica'),
(115, 'JO', 'Jordan'),
(116, 'JP', 'Japan'),
(117, 'KE', 'Kenya'),
(118, 'KG', 'Kyrgyzstan'),
(119, 'KH', 'Cambodia'),
(120, 'KI', 'Kiribati'),
(121, 'KM', 'Comoros'),
(122, 'KN', 'Saint Kitts and Nevis'),
(123, 'KP', 'North Korea'),
(124, 'KR', 'South Korea'),
(125, 'KW', 'Kuwait'),
(126, 'KY', 'Cayman Islands'),
(127, 'KZ', 'Kazakhstan'),
(128, 'LA', 'Laos'),
(129, 'LB', 'Lebanon'),
(130, 'LC', 'Saint Lucia'),
(131, 'LI', 'Liechtenstein'),
(132, 'LK', 'Sri Lanka'),
(133, 'LR', 'Liberia'),
(134, 'LS', 'Lesotho'),
(135, 'LT', 'Lithuania'),
(136, 'LU', 'Luxembourg'),
(137, 'LV', 'Latvia'),
(138, 'LY', 'Libya'),
(139, 'MA', 'Morocco'),
(140, 'MC', 'Monaco'),
(141, 'MD', 'Moldova'),
(142, 'ME', 'Montenegro'),
(143, 'MF', 'Saint Martin'),
(144, 'MG', 'Madagascar'),
(145, 'MH', 'Marshall Islands'),
(146, 'MK', 'Macedonia'),
(147, 'ML', 'Mali'),
(148, 'MM', 'Myanmar'),
(149, 'MN', 'Mongolia'),
(150, 'MO', 'Macao'),
(151, 'MP', 'Northern Mariana Islands'),
(152, 'MQ', 'Martinique'),
(153, 'MR', 'Mauritania'),
(154, 'MS', 'Montserrat'),
(155, 'MT', 'Malta'),
(156, 'MU', 'Mauritius'),
(157, 'MV', 'Maldives'),
(158, 'MW', 'Malawi'),
(159, 'MX', 'Mexico'),
(160, 'MY', 'Malaysia'),
(161, 'MZ', 'Mozambique'),
(162, 'NA', 'Namibia'),
(163, 'NC', 'New Caledonia'),
(164, 'NE', 'Niger'),
(165, 'NF', 'Norfolk Island'),
(166, 'NG', 'Nigeria'),
(167, 'NI', 'Nicaragua'),
(168, 'NL', 'Netherlands'),
(169, 'NO', 'Norway'),
(170, 'NP', 'Nepal'),
(171, 'NR', 'Nauru'),
(172, 'NU', 'Niue'),
(173, 'NZ', 'New Zealand'),
(174, 'OM', 'Oman'),
(175, 'PA', 'Panama'),
(176, 'PE', 'Peru'),
(177, 'PF', 'French Polynesia'),
(178, 'PG', 'Papua New Guinea'),
(179, 'PH', 'Philippines'),
(180, 'PK', 'Pakistan'),
(181, 'PL', 'Poland'),
(182, 'PM', 'Saint Pierre and Miquelon'),
(183, 'PN', 'Pitcairn'),
(184, 'PR', 'Puerto Rico'),
(185, 'PS', 'Palestinian Territory'),
(186, 'PT', 'Portugal'),
(187, 'PW', 'Palau'),
(188, 'PY', 'Paraguay'),
(189, 'QA', 'Qatar'),
(190, 'RE', 'Reunion'),
(191, 'RO', 'Romania'),
(192, 'RS', 'Serbia'),
(193, 'RU', 'Russia'),
(194, 'RW', 'Rwanda'),
(195, 'SA', 'Saudi Arabia'),
(196, 'SB', 'Solomon Islands'),
(197, 'SC', 'Seychelles'),
(198, 'SD', 'Sudan'),
(199, 'SE', 'Sweden'),
(200, 'SG', 'Singapore'),
(201, 'SH', 'Saint Helena'),
(202, 'SI', 'Slovenia'),
(203, 'SJ', 'Svalbard and Jan Mayen'),
(204, 'SK', 'Slovakia'),
(205, 'SL', 'Sierra Leone'),
(206, 'SM', 'San Marino'),
(207, 'SN', 'Senegal'),
(208, 'SO', 'Somalia'),
(209, 'SR', 'Suriname'),
(210, 'SS', 'South Sudan'),
(211, 'ST', 'Sao Tome and Principe'),
(212, 'SV', 'El Salvador'),
(213, 'SX', 'Sint Maarten'),
(214, 'SY', 'Syria'),
(215, 'SZ', 'Swaziland'),
(216, 'TC', 'Turks and Caicos Islands'),
(217, 'TD', 'Chad'),
(218, 'TF', 'French Southern Territories'),
(219, 'TG', 'Togo'),
(220, 'TH', 'Thailand'),
(221, 'TJ', 'Tajikistan'),
(222, 'TK', 'Tokelau'),
(223, 'TL', 'East Timor'),
(224, 'TM', 'Turkmenistan'),
(225, 'TN', 'Tunisia'),
(226, 'TO', 'Tonga'),
(227, 'TR', 'Turkey'),
(228, 'TT', 'Trinidad and Tobago'),
(229, 'TV', 'Tuvalu'),
(230, 'TW', 'Taiwan'),
(231, 'TZ', 'Tanzania'),
(232, 'UA', 'Ukraine'),
(233, 'UG', 'Uganda'),
(234, 'UM', 'United States Minor Outlying Islands'),
(235, 'US', 'United States'),
(236, 'UY', 'Uruguay'),
(237, 'UZ', 'Uzbekistan'),
(238, 'VA', 'Vatican'),
(239, 'VC', 'Saint Vincent and the Grenadines'),
(240, 'VE', 'Venezuela'),
(241, 'VG', 'British Virgin Islands'),
(242, 'VI', 'U.S. Virgin Islands'),
(243, 'VN', 'Vietnam'),
(244, 'VU', 'Vanuatu'),
(245, 'WF', 'Wallis and Futuna'),
(246, 'WS', 'Samoa'),
(247, 'XK', 'Kosovo'),
(248, 'YE', 'Yemen'),
(249, 'YT', 'Mayotte'),
(250, 'ZA', 'South Africa'),
(251, 'ZM', 'Zambia'),
(252, 'ZW', 'Zimbabwe');

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

--
-- Table structure for table `tbl_currency`
--

CREATE TABLE IF NOT EXISTS `tbl_currency` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `currency` varchar(100) NOT NULL,
  `code1` varchar(20) NOT NULL,
  `code2` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tbl_currency`
--

INSERT INTO `tbl_currency` (`id`, `currency`, `code1`, `code2`) VALUES
(1, 'Dollar Sign', '&#36;', '&#x24;'),
(2, 'Pound Sterling', '&#163;', '&#xa3;'),
(3, 'Euro Symbol', '&#128;', '&#x80;'),
(4, 'Yen Symbol', '&#165;', '&#xa5;'),
(5, 'Peso Sign', '&#8369;', '&#x20b1;');

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

--
-- Table structure for table `tbl_department`
--

CREATE TABLE IF NOT EXISTS `tbl_department` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `department_no` varchar(50) NOT NULL,
  `department` varchar(100) NOT NULL,
  `abb` varchar(10) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `tbl_department`
--

INSERT INTO `tbl_department` (`id`, `department_no`, `department`, `abb`, `user_id`, `date`, `time`, `a_status`) VALUES
(1, '151', 'Administrator', 'ADM', 1, '2015-07-11', '10:24:22', 1),
(2, '152', 'Information & Admitting', 'INFO', 1, '2015-07-11', '10:25:35', 1),
(3, '153', 'Items & Services', 'IS', 1, '2015-07-17', '17:01:25', 1),
(4, '154', 'Emergency Room', 'ER', 1, '2015-07-17', '17:01:41', 1),
(5, '155', 'Nurse Station', 'NS', 1, '2015-07-17', '17:01:54', 1),
(6, '156', 'Billing', 'BIL', 1, '2015-07-17', '17:02:06', 1),
(7, '157', 'Laboratory', 'LAB', 1, '2015-07-17', '17:02:21', 1),
(8, '158', 'Medical Records', 'MR', 1, '2015-07-17', '17:03:15', 1),
(9, '159', 'Intensive Care Unit', 'ICU', 1, '2015-07-17', '17:03:48', 1),
(10, '1510', 'Operating Room', 'OR', 1, '2015-07-17', '17:04:02', 1);

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

--
-- Table structure for table `tbl_item`
--

CREATE TABLE IF NOT EXISTS `tbl_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_no` varchar(100) NOT NULL,
  `barcode` varchar(100) NOT NULL,
  `item` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `item_category_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_item`
--


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

--
-- Table structure for table `tbl_item_category`
--

CREATE TABLE IF NOT EXISTS `tbl_item_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_category` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_item_category`
--

INSERT INTO `tbl_item_category` (`id`, `item_category`) VALUES
(1, 'Drugs & Medicine'),
(2, 'Services');

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

--
-- Table structure for table `tbl_item_price`
--

CREATE TABLE IF NOT EXISTS `tbl_item_price` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `price` varchar(100) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_item_price`
--


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

--
-- Table structure for table `tbl_language`
--

CREATE TABLE IF NOT EXISTS `tbl_language` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image` varchar(100) NOT NULL,
  `language` varchar(100) NOT NULL,
  `code` varchar(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_language`
--

INSERT INTO `tbl_language` (`id`, `image`, `language`, `code`) VALUES
(1, 'en.png', 'English', 'en'),
(2, 'es.png', 'Spanish', 'es'),
(3, 'de.png', 'German', 'de');

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

--
-- Table structure for table `tbl_nationality`
--

CREATE TABLE IF NOT EXISTS `tbl_nationality` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nationality` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

--
-- Dumping data for table `tbl_nationality`
--

INSERT INTO `tbl_nationality` (`id`, `nationality`) VALUES
(1, 'American'),
(2, 'Chinese'),
(3, 'Singaporean'),
(4, 'Taiwanese'),
(5, 'Korean'),
(6, 'Sri Lankan'),
(7, 'Turkish'),
(8, 'Filipino'),
(9, 'Canadian'),
(10, 'Austrialian'),
(11, 'Japanese'),
(12, 'Indian'),
(13, 'Thailander'),
(14, 'Mexican'),
(15, 'Polish'),
(16, 'Panamian'),
(17, 'Spaniard'),
(18, 'Swedish'),
(19, 'Scotish'),
(20, 'British'),
(21, 'Burmese'),
(22, 'Argentinian'),
(23, 'Bangladeshi'),
(24, 'Angelocan'),
(25, 'African'),
(26, 'Dutch'),
(27, 'Pakistani'),
(28, 'German'),
(29, 'Norwegian'),
(30, 'Russian');

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

--
-- Table structure for table `tbl_number_format`
--

CREATE TABLE IF NOT EXISTS `tbl_number_format` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `number_format` varchar(50) NOT NULL,
  `description` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_number_format`
--

INSERT INTO `tbl_number_format` (`id`, `number_format`, `description`) VALUES
(1, '1,235', 'English notation'),
(2, '1 234,56', 'French notation'),
(3, '1234.57', 'English notation without thousands separator');

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

--
-- Table structure for table `tbl_patient`
--

CREATE TABLE IF NOT EXISTS `tbl_patient` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patient_no` varchar(50) NOT NULL,
  `image` varchar(255) NOT NULL,
  `firstname` varchar(100) NOT NULL,
  `middlename` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `birth_date` date NOT NULL,
  `gender` varchar(10) NOT NULL,
  `civil_status_id` int(11) NOT NULL,
  `nationality_id` int(11) NOT NULL,
  `address` text NOT NULL,
  `phone_no` varchar(100) NOT NULL,
  `mobile_no` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `ref_name` varchar(200) NOT NULL,
  `ref_relationship_id` int(11) NOT NULL,
  `ref_address` text NOT NULL,
  `ref_phone_no` varchar(100) NOT NULL,
  `ref_mobile_no` varchar(100) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `tbl_patient`
--

INSERT INTO `tbl_patient` (`id`, `patient_no`, `image`, `firstname`, `middlename`, `lastname`, `birth_date`, `gender`, `civil_status_id`, `nationality_id`, `address`, `phone_no`, `mobile_no`, `email`, `ref_name`, `ref_relationship_id`, `ref_address`, `ref_phone_no`, `ref_mobile_no`, `user_id`, `date`, `time`, `a_status`) VALUES
(1, '151', '', 'Parker', 'Cay', 'Chandler', '1965-09-30', 'Male', 0, 0, '', '', '', '', '', 0, '', '', '', 1, '2015-07-17', '17:16:54', 1),
(2, '152', '', 'Roger', 'Lewis', 'Den', '1980-09-24', 'Male', 0, 0, '', '', '', '', '', 0, '', '', '', 1, '2015-07-17', '17:17:14', 1),
(3, '153', '', 'Adam', 'Drew', 'Lancelot', '1992-07-08', 'Male', 0, 0, '', '', '', '', '', 0, '', '', '', 1, '2015-07-17', '17:17:39', 1),
(4, '154', '', 'Allen', 'Browne', 'Clarkson', '1968-07-01', 'Male', 0, 0, '', '', '', '', '', 0, '', '', '', 1, '2015-07-17', '17:18:13', 1),
(5, '155', '', 'Maire', 'Hill', 'White', '1995-06-22', 'Female', 0, 0, '', '', '', '', '', 0, '', '', '', 1, '2015-07-17', '17:18:40', 1),
(6, '156', '', 'John', 'Silver', 'Stone', '1977-09-09', 'Male', 0, 0, '', '', '', '', '', 0, '', '', '', 1, '2015-07-17', '17:19:12', 1),
(7, '157', '', 'Paris', 'Morley', 'Gray', '1999-07-10', 'Female', 0, 0, '', '', '', '', '', 0, '', '', '', 1, '2015-07-17', '17:20:02', 1),
(8, '158', '', 'Johnson', 'Ironside', 'Ludge', '1988-06-27', 'Male', 0, 0, '', '', '', '', '', 0, '', '', '', 1, '2015-07-17', '17:20:33', 1),
(9, '159', '', 'Ellen', 'Dorothy', 'Scotland', '1959-07-04', 'Female', 0, 0, '', '', '', '', '', 0, '', '', '', 1, '2015-07-17', '17:21:11', 1),
(10, '1510', '', 'Allison', 'Brook', 'Chilton', '1960-08-15', 'Female', 0, 0, '', '', '', '', '', 0, '', '', '', 1, '2015-07-17', '17:21:34', 1);

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

--
-- Table structure for table `tbl_patient_type`
--

CREATE TABLE IF NOT EXISTS `tbl_patient_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patient_type` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_patient_type`
--

INSERT INTO `tbl_patient_type` (`id`, `patient_type`) VALUES
(1, 'Inpatient'),
(2, 'Outpatient');

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

--
-- Table structure for table `tbl_relationship`
--

CREATE TABLE IF NOT EXISTS `tbl_relationship` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `relationship` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tbl_relationship`
--

INSERT INTO `tbl_relationship` (`id`, `relationship`) VALUES
(1, 'Father'),
(2, 'Mother'),
(3, 'Sister'),
(4, 'Brother');

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

--
-- Table structure for table `tbl_room`
--

CREATE TABLE IF NOT EXISTS `tbl_room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `room_no` varchar(100) NOT NULL,
  `room` varchar(255) NOT NULL,
  `room_type_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_room`
--


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

--
-- Table structure for table `tbl_room_bed`
--

CREATE TABLE IF NOT EXISTS `tbl_room_bed` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `room_id` int(11) NOT NULL,
  `bed_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_room_bed`
--


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

--
-- Table structure for table `tbl_room_price`
--

CREATE TABLE IF NOT EXISTS `tbl_room_price` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `room_id` int(11) NOT NULL,
  `price` varchar(100) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_room_price`
--


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

--
-- Table structure for table `tbl_room_type`
--

CREATE TABLE IF NOT EXISTS `tbl_room_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `room_type` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tbl_room_type`
--

INSERT INTO `tbl_room_type` (`id`, `room_type`) VALUES
(1, 'Public Room'),
(2, 'Semi Private'),
(3, 'Private Room'),
(4, 'Suite Room');

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

--
-- Table structure for table `tbl_timezone`
--

CREATE TABLE IF NOT EXISTS `tbl_timezone` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timezone` varchar(35) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_zone_name` (`timezone`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=417 ;

--
-- Dumping data for table `tbl_timezone`
--

INSERT INTO `tbl_timezone` (`id`, `timezone`) VALUES
(1, 'Europe/Andorra'),
(2, 'Asia/Dubai'),
(3, 'Asia/Kabul'),
(4, 'America/Antigua'),
(5, 'America/Anguilla'),
(6, 'Europe/Tirane'),
(7, 'Asia/Yerevan'),
(8, 'Africa/Luanda'),
(9, 'Antarctica/McMurdo'),
(10, 'Antarctica/Rothera'),
(11, 'Antarctica/Palmer'),
(12, 'Antarctica/Mawson'),
(13, 'Antarctica/Davis'),
(14, 'Antarctica/Casey'),
(15, 'Antarctica/Vostok'),
(16, 'Antarctica/DumontDUrville'),
(17, 'Antarctica/Syowa'),
(18, 'Antarctica/Troll'),
(19, 'America/Argentina/Buenos_Aires'),
(20, 'America/Argentina/Cordoba'),
(21, 'America/Argentina/Salta'),
(22, 'America/Argentina/Jujuy'),
(23, 'America/Argentina/Tucuman'),
(24, 'America/Argentina/Catamarca'),
(25, 'America/Argentina/La_Rioja'),
(26, 'America/Argentina/San_Juan'),
(27, 'America/Argentina/Mendoza'),
(28, 'America/Argentina/San_Luis'),
(29, 'America/Argentina/Rio_Gallegos'),
(30, 'America/Argentina/Ushuaia'),
(31, 'Pacific/Pago_Pago'),
(32, 'Europe/Vienna'),
(33, 'Australia/Lord_Howe'),
(34, 'Antarctica/Macquarie'),
(35, 'Australia/Hobart'),
(36, 'Australia/Currie'),
(37, 'Australia/Melbourne'),
(38, 'Australia/Sydney'),
(39, 'Australia/Broken_Hill'),
(40, 'Australia/Brisbane'),
(41, 'Australia/Lindeman'),
(42, 'Australia/Adelaide'),
(43, 'Australia/Darwin'),
(44, 'Australia/Perth'),
(45, 'Australia/Eucla'),
(46, 'America/Aruba'),
(47, 'Europe/Mariehamn'),
(48, 'Asia/Baku'),
(49, 'Europe/Sarajevo'),
(50, 'America/Barbados'),
(51, 'Asia/Dhaka'),
(52, 'Europe/Brussels'),
(53, 'Africa/Ouagadougou'),
(54, 'Europe/Sofia'),
(55, 'Asia/Bahrain'),
(56, 'Africa/Bujumbura'),
(57, 'Africa/Porto-Novo'),
(58, 'America/St_Barthelemy'),
(59, 'Atlantic/Bermuda'),
(60, 'Asia/Brunei'),
(61, 'America/La_Paz'),
(62, 'America/Kralendijk'),
(63, 'America/Noronha'),
(64, 'America/Belem'),
(65, 'America/Fortaleza'),
(66, 'America/Recife'),
(67, 'America/Araguaina'),
(68, 'America/Maceio'),
(69, 'America/Bahia'),
(70, 'America/Sao_Paulo'),
(71, 'America/Campo_Grande'),
(72, 'America/Cuiaba'),
(73, 'America/Santarem'),
(74, 'America/Porto_Velho'),
(75, 'America/Boa_Vista'),
(76, 'America/Manaus'),
(77, 'America/Eirunepe'),
(78, 'America/Rio_Branco'),
(79, 'America/Nassau'),
(80, 'Asia/Thimphu'),
(81, 'Africa/Gaborone'),
(82, 'Europe/Minsk'),
(83, 'America/Belize'),
(84, 'America/St_Johns'),
(85, 'America/Halifax'),
(86, 'America/Glace_Bay'),
(87, 'America/Moncton'),
(88, 'America/Goose_Bay'),
(89, 'America/Blanc-Sablon'),
(90, 'America/Toronto'),
(91, 'America/Nipigon'),
(92, 'America/Thunder_Bay'),
(93, 'America/Iqaluit'),
(94, 'America/Pangnirtung'),
(95, 'America/Resolute'),
(96, 'America/Atikokan'),
(97, 'America/Rankin_Inlet'),
(98, 'America/Winnipeg'),
(99, 'America/Rainy_River'),
(100, 'America/Regina'),
(101, 'America/Swift_Current'),
(102, 'America/Edmonton'),
(103, 'America/Cambridge_Bay'),
(104, 'America/Yellowknife'),
(105, 'America/Inuvik'),
(106, 'America/Creston'),
(107, 'America/Dawson_Creek'),
(108, 'America/Vancouver'),
(109, 'America/Whitehorse'),
(110, 'America/Dawson'),
(111, 'Indian/Cocos'),
(112, 'Africa/Kinshasa'),
(113, 'Africa/Lubumbashi'),
(114, 'Africa/Bangui'),
(115, 'Africa/Brazzaville'),
(116, 'Europe/Zurich'),
(117, 'Africa/Abidjan'),
(118, 'Pacific/Rarotonga'),
(119, 'America/Santiago'),
(120, 'Pacific/Easter'),
(121, 'Africa/Douala'),
(122, 'Asia/Shanghai'),
(123, 'Asia/Urumqi'),
(124, 'America/Bogota'),
(125, 'America/Costa_Rica'),
(126, 'America/Havana'),
(127, 'Atlantic/Cape_Verde'),
(128, 'America/Curacao'),
(129, 'Indian/Christmas'),
(130, 'Asia/Nicosia'),
(131, 'Europe/Prague'),
(132, 'Europe/Berlin'),
(133, 'Europe/Busingen'),
(134, 'Africa/Djibouti'),
(135, 'Europe/Copenhagen'),
(136, 'America/Dominica'),
(137, 'America/Santo_Domingo'),
(138, 'Africa/Algiers'),
(139, 'America/Guayaquil'),
(140, 'Pacific/Galapagos'),
(141, 'Europe/Tallinn'),
(142, 'Africa/Cairo'),
(143, 'Africa/El_Aaiun'),
(144, 'Africa/Asmara'),
(145, 'Europe/Madrid'),
(146, 'Africa/Ceuta'),
(147, 'Atlantic/Canary'),
(148, 'Africa/Addis_Ababa'),
(149, 'Europe/Helsinki'),
(150, 'Pacific/Fiji'),
(151, 'Atlantic/Stanley'),
(152, 'Pacific/Chuuk'),
(153, 'Pacific/Pohnpei'),
(154, 'Pacific/Kosrae'),
(155, 'Atlantic/Faroe'),
(156, 'Europe/Paris'),
(157, 'Africa/Libreville'),
(158, 'Europe/London'),
(159, 'America/Grenada'),
(160, 'Asia/Tbilisi'),
(161, 'America/Cayenne'),
(162, 'Europe/Guernsey'),
(163, 'Africa/Accra'),
(164, 'Europe/Gibraltar'),
(165, 'America/Godthab'),
(166, 'America/Danmarkshavn'),
(167, 'America/Scoresbysund'),
(168, 'America/Thule'),
(169, 'Africa/Banjul'),
(170, 'Africa/Conakry'),
(171, 'America/Guadeloupe'),
(172, 'Africa/Malabo'),
(173, 'Europe/Athens'),
(174, 'Atlantic/South_Georgia'),
(175, 'America/Guatemala'),
(176, 'Pacific/Guam'),
(177, 'Africa/Bissau'),
(178, 'America/Guyana'),
(179, 'Asia/Hong_Kong'),
(180, 'America/Tegucigalpa'),
(181, 'Europe/Zagreb'),
(182, 'America/Port-au-Prince'),
(183, 'Europe/Budapest'),
(184, 'Asia/Jakarta'),
(185, 'Asia/Pontianak'),
(186, 'Asia/Makassar'),
(187, 'Asia/Jayapura'),
(188, 'Europe/Dublin'),
(189, 'Asia/Jerusalem'),
(190, 'Europe/Isle_of_Man'),
(191, 'Asia/Kolkata'),
(192, 'Indian/Chagos'),
(193, 'Asia/Baghdad'),
(194, 'Asia/Tehran'),
(195, 'Atlantic/Reykjavik'),
(196, 'Europe/Rome'),
(197, 'Europe/Jersey'),
(198, 'America/Jamaica'),
(199, 'Asia/Amman'),
(200, 'Asia/Tokyo'),
(201, 'Africa/Nairobi'),
(202, 'Asia/Bishkek'),
(203, 'Asia/Phnom_Penh'),
(204, 'Pacific/Tarawa'),
(205, 'Pacific/Enderbury'),
(206, 'Pacific/Kiritimati'),
(207, 'Indian/Comoro'),
(208, 'America/St_Kitts'),
(209, 'Asia/Pyongyang'),
(210, 'Asia/Seoul'),
(211, 'Asia/Kuwait'),
(212, 'America/Cayman'),
(213, 'Asia/Almaty'),
(214, 'Asia/Qyzylorda'),
(215, 'Asia/Aqtobe'),
(216, 'Asia/Aqtau'),
(217, 'Asia/Oral'),
(218, 'Asia/Vientiane'),
(219, 'Asia/Beirut'),
(220, 'America/St_Lucia'),
(221, 'Europe/Vaduz'),
(222, 'Asia/Colombo'),
(223, 'Africa/Monrovia'),
(224, 'Africa/Maseru'),
(225, 'Europe/Vilnius'),
(226, 'Europe/Luxembourg'),
(227, 'Europe/Riga'),
(228, 'Africa/Tripoli'),
(229, 'Africa/Casablanca'),
(230, 'Europe/Monaco'),
(231, 'Europe/Chisinau'),
(232, 'Europe/Podgorica'),
(233, 'America/Marigot'),
(234, 'Indian/Antananarivo'),
(235, 'Pacific/Majuro'),
(236, 'Pacific/Kwajalein'),
(237, 'Europe/Skopje'),
(238, 'Africa/Bamako'),
(239, 'Asia/Rangoon'),
(240, 'Asia/Ulaanbaatar'),
(241, 'Asia/Hovd'),
(242, 'Asia/Choibalsan'),
(243, 'Asia/Macau'),
(244, 'Pacific/Saipan'),
(245, 'America/Martinique'),
(246, 'Africa/Nouakchott'),
(247, 'America/Montserrat'),
(248, 'Europe/Malta'),
(249, 'Indian/Mauritius'),
(250, 'Indian/Maldives'),
(251, 'Africa/Blantyre'),
(252, 'America/Mexico_City'),
(253, 'America/Cancun'),
(254, 'America/Merida'),
(255, 'America/Monterrey'),
(256, 'America/Matamoros'),
(257, 'America/Mazatlan'),
(258, 'America/Chihuahua'),
(259, 'America/Ojinaga'),
(260, 'America/Hermosillo'),
(261, 'America/Tijuana'),
(262, 'America/Santa_Isabel'),
(263, 'America/Bahia_Banderas'),
(264, 'Asia/Kuala_Lumpur'),
(265, 'Asia/Kuching'),
(266, 'Africa/Maputo'),
(267, 'Africa/Windhoek'),
(268, 'Pacific/Noumea'),
(269, 'Africa/Niamey'),
(270, 'Pacific/Norfolk'),
(271, 'Africa/Lagos'),
(272, 'America/Managua'),
(273, 'Europe/Amsterdam'),
(274, 'Europe/Oslo'),
(275, 'Asia/Kathmandu'),
(276, 'Pacific/Nauru'),
(277, 'Pacific/Niue'),
(278, 'Pacific/Auckland'),
(279, 'Pacific/Chatham'),
(280, 'Asia/Muscat'),
(281, 'America/Panama'),
(282, 'America/Lima'),
(283, 'Pacific/Tahiti'),
(284, 'Pacific/Marquesas'),
(285, 'Pacific/Gambier'),
(286, 'Pacific/Port_Moresby'),
(287, 'Pacific/Bougainville'),
(288, 'Asia/Manila'),
(289, 'Asia/Karachi'),
(290, 'Europe/Warsaw'),
(291, 'America/Miquelon'),
(292, 'Pacific/Pitcairn'),
(293, 'America/Puerto_Rico'),
(294, 'Asia/Gaza'),
(295, 'Asia/Hebron'),
(296, 'Europe/Lisbon'),
(297, 'Atlantic/Madeira'),
(298, 'Atlantic/Azores'),
(299, 'Pacific/Palau'),
(300, 'America/Asuncion'),
(301, 'Asia/Qatar'),
(302, 'Indian/Reunion'),
(303, 'Europe/Bucharest'),
(304, 'Europe/Belgrade'),
(305, 'Europe/Kaliningrad'),
(306, 'Europe/Moscow'),
(307, 'Europe/Simferopol'),
(308, 'Europe/Volgograd'),
(309, 'Europe/Samara'),
(310, 'Asia/Yekaterinburg'),
(311, 'Asia/Omsk'),
(312, 'Asia/Novosibirsk'),
(313, 'Asia/Novokuznetsk'),
(314, 'Asia/Krasnoyarsk'),
(315, 'Asia/Irkutsk'),
(316, 'Asia/Chita'),
(317, 'Asia/Yakutsk'),
(318, 'Asia/Khandyga'),
(319, 'Asia/Vladivostok'),
(320, 'Asia/Sakhalin'),
(321, 'Asia/Ust-Nera'),
(322, 'Asia/Magadan'),
(323, 'Asia/Srednekolymsk'),
(324, 'Asia/Kamchatka'),
(325, 'Asia/Anadyr'),
(326, 'Africa/Kigali'),
(327, 'Asia/Riyadh'),
(328, 'Pacific/Guadalcanal'),
(329, 'Indian/Mahe'),
(330, 'Africa/Khartoum'),
(331, 'Europe/Stockholm'),
(332, 'Asia/Singapore'),
(333, 'Atlantic/St_Helena'),
(334, 'Europe/Ljubljana'),
(335, 'Arctic/Longyearbyen'),
(336, 'Europe/Bratislava'),
(337, 'Africa/Freetown'),
(338, 'Europe/San_Marino'),
(339, 'Africa/Dakar'),
(340, 'Africa/Mogadishu'),
(341, 'America/Paramaribo'),
(342, 'Africa/Juba'),
(343, 'Africa/Sao_Tome'),
(344, 'America/El_Salvador'),
(345, 'America/Lower_Princes'),
(346, 'Asia/Damascus'),
(347, 'Africa/Mbabane'),
(348, 'America/Grand_Turk'),
(349, 'Africa/Ndjamena'),
(350, 'Indian/Kerguelen'),
(351, 'Africa/Lome'),
(352, 'Asia/Bangkok'),
(353, 'Asia/Dushanbe'),
(354, 'Pacific/Fakaofo'),
(355, 'Asia/Dili'),
(356, 'Asia/Ashgabat'),
(357, 'Africa/Tunis'),
(358, 'Pacific/Tongatapu'),
(359, 'Europe/Istanbul'),
(360, 'America/Port_of_Spain'),
(361, 'Pacific/Funafuti'),
(362, 'Asia/Taipei'),
(363, 'Africa/Dar_es_Salaam'),
(364, 'Europe/Kiev'),
(365, 'Europe/Uzhgorod'),
(366, 'Europe/Zaporozhye'),
(367, 'Africa/Kampala'),
(368, 'Pacific/Johnston'),
(369, 'Pacific/Midway'),
(370, 'Pacific/Wake'),
(371, 'America/New_York'),
(372, 'America/Detroit'),
(373, 'America/Kentucky/Louisville'),
(374, 'America/Kentucky/Monticello'),
(375, 'America/Indiana/Indianapolis'),
(376, 'America/Indiana/Vincennes'),
(377, 'America/Indiana/Winamac'),
(378, 'America/Indiana/Marengo'),
(379, 'America/Indiana/Petersburg'),
(380, 'America/Indiana/Vevay'),
(381, 'America/Chicago'),
(382, 'America/Indiana/Tell_City'),
(383, 'America/Indiana/Knox'),
(384, 'America/Menominee'),
(385, 'America/North_Dakota/Center'),
(386, 'America/North_Dakota/New_Salem'),
(387, 'America/North_Dakota/Beulah'),
(388, 'America/Denver'),
(389, 'America/Boise'),
(390, 'America/Phoenix'),
(391, 'America/Los_Angeles'),
(392, 'America/Metlakatla'),
(393, 'America/Anchorage'),
(394, 'America/Juneau'),
(395, 'America/Sitka'),
(396, 'America/Yakutat'),
(397, 'America/Nome'),
(398, 'America/Adak'),
(399, 'Pacific/Honolulu'),
(400, 'America/Montevideo'),
(401, 'Asia/Samarkand'),
(402, 'Asia/Tashkent'),
(403, 'Europe/Vatican'),
(404, 'America/St_Vincent'),
(405, 'America/Caracas'),
(406, 'America/Tortola'),
(407, 'America/St_Thomas'),
(408, 'Asia/Ho_Chi_Minh'),
(409, 'Pacific/Efate'),
(410, 'Pacific/Wallis'),
(411, 'Pacific/Apia'),
(412, 'Asia/Aden'),
(413, 'Indian/Mayotte'),
(414, 'Africa/Johannesburg'),
(415, 'Africa/Lusaka'),
(416, 'Africa/Harare');

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

--
-- Table structure for table `tbl_transaction`
--

CREATE TABLE IF NOT EXISTS `tbl_transaction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_no` varchar(50) NOT NULL,
  `patient_id` int(11) NOT NULL,
  `pt_type_id` int(11) NOT NULL,
  `remark` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_transaction`
--


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

--
-- Table structure for table `tbl_transaction_charge`
--

CREATE TABLE IF NOT EXISTS `tbl_transaction_charge` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` int(11) NOT NULL,
  `transaction_charge_no` varchar(100) NOT NULL,
  `remark` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_transaction_charge`
--


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

--
-- Table structure for table `tbl_transaction_charge_item`
--

CREATE TABLE IF NOT EXISTS `tbl_transaction_charge_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_charge_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `price` varchar(100) NOT NULL,
  `total` varchar(100) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_transaction_charge_item`
--


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

--
-- Table structure for table `tbl_transaction_consultant`
--

CREATE TABLE IF NOT EXISTS `tbl_transaction_consultant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` int(11) NOT NULL,
  `consultant_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_transaction_consultant`
--


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

--
-- Table structure for table `tbl_transaction_diagnosis`
--

CREATE TABLE IF NOT EXISTS `tbl_transaction_diagnosis` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` int(11) NOT NULL,
  `admitting_diagnosis` text NOT NULL,
  `final_diagnosis` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_transaction_diagnosis`
--


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

--
-- Table structure for table `tbl_transaction_file`
--

CREATE TABLE IF NOT EXISTS `tbl_transaction_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` int(11) NOT NULL,
  `file` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_transaction_file`
--


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

--
-- Table structure for table `tbl_transaction_room`
--

CREATE TABLE IF NOT EXISTS `tbl_transaction_room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` int(11) NOT NULL,
  `room_id` int(11) NOT NULL,
  `bed_id` int(11) NOT NULL,
  `price` varchar(100) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_transaction_room`
--


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

--
-- Table structure for table `tbl_transaction_type`
--

CREATE TABLE IF NOT EXISTS `tbl_transaction_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_type` varchar(100) NOT NULL,
  `color` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `tbl_transaction_type`
--

INSERT INTO `tbl_transaction_type` (`id`, `transaction_type`, `color`) VALUES
(1, 'Active', 'Green'),
(2, 'Paid & Discharge', 'LightBlue'),
(3, 'Promissory & Discharge', 'Gold'),
(4, 'Expired', 'Black'),
(5, 'Cancel Account', 'Red'),
(6, 'Other', 'Sea');

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

--
-- Table structure for table `tbl_url`
--

CREATE TABLE IF NOT EXISTS `tbl_url` (
  `connect_url` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_url`
--

INSERT INTO `tbl_url` (`connect_url`) VALUES
('http://localhost/quickmedia/hcms');

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

--
-- Table structure for table `tbl_user`
--

CREATE TABLE IF NOT EXISTS `tbl_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_no` varchar(50) NOT NULL,
  `image` varchar(255) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `firstname` varchar(100) NOT NULL,
  `middlename` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `birth_date` date NOT NULL,
  `gender` varchar(10) NOT NULL,
  `address` text NOT NULL,
  `phone_no` varchar(100) NOT NULL,
  `mobile_no` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `department_id` int(11) NOT NULL,
  `user_type_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `tbl_user`
--

INSERT INTO `tbl_user` (`id`, `user_no`, `image`, `username`, `password`, `firstname`, `middlename`, `lastname`, `birth_date`, `gender`, `address`, `phone_no`, `mobile_no`, `email`, `department_id`, `user_type_id`, `user_id`, `date`, `time`, `a_status`) VALUES
(1, '151', '', 'admin', 'c4ca4238a0b923820dcc509a6f75849b', 'John', 'Drew', 'William', '2015-07-11', 'Male', '#000 Address', '', '', 'johndrewwilliam@gmail.com', 1, 1, 1, '2015-07-11', '08:00:00', 1),
(2, '152', '', 'user0', 'c4ca4238a0b923820dcc509a6f75849b', 'Wren', 'Silver', 'Booker', '1991-07-11', 'Male', '', '', '', '', 6, 5, 1, '2015-07-11', '10:28:18', 1),
(3, '153', '', 'user1', 'c4ca4238a0b923820dcc509a6f75849b', 'Ellen', 'Grace', 'Mendiola', '0000-00-00', '', '', '', '', '', 2, 2, 1, '2015-07-17', '16:48:31', 1),
(4, '154', '', 'user2', 'c4ca4238a0b923820dcc509a6f75849b', 'Grace', 'Adam', 'Torres', '0000-00-00', 'Female', '', '', '', '', 5, 4, 1, '2015-07-17', '16:49:03', 1),
(5, '155', '', 'user3', 'c4ca4238a0b923820dcc509a6f75849b', 'Hector', 'Doe', 'Domingo', '0000-00-00', 'Male', '', '', '', '', 9, 4, 1, '2015-07-17', '16:50:00', 1),
(6, '156', '', 'user4', 'c4ca4238a0b923820dcc509a6f75849b', 'Drew', 'De', 'Cleark', '0000-00-00', 'Male', '', '', '', '', 4, 4, 1, '2015-07-17', '16:50:37', 1),
(7, '157', '1511266327-koala.jpg', 'user5', 'c4ca4238a0b923820dcc509a6f75849b', 'Claxton', 'Barn', 'Garnett', '0000-00-00', 'Male', '', '', '', '', 3, 3, 1, '2015-07-17', '16:51:14', 1),
(8, '158', '', 'user6', 'c4ca4238a0b923820dcc509a6f75849b', 'Rey', 'Mill', 'Hall', '0000-00-00', 'Male', '', '', '', '', 10, 4, 1, '2015-07-17', '16:52:46', 1),
(9, '159', '', 'user6', 'c4ca4238a0b923820dcc509a6f75849b', 'Rusell', 'Fury', 'Hunter', '0000-00-00', 'Male', '', '', '', '', 8, 6, 1, '2015-07-17', '16:53:10', 1),
(10, '1510', '', 'user7', 'c4ca4238a0b923820dcc509a6f75849b', 'Lee', 'Dossy', 'Bradley', '0000-00-00', 'Male', '', '', '', '', 7, 4, 1, '2015-07-17', '16:53:44', 1);

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

--
-- Table structure for table `tbl_user_type`
--

CREATE TABLE IF NOT EXISTS `tbl_user_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_type_no` varchar(100) NOT NULL,
  `user_type_name` varchar(100) NOT NULL,
  `dashboard` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `user_type` int(11) NOT NULL,
  `patient` int(11) NOT NULL,
  `inpatient` int(11) NOT NULL,
  `outpatient` int(11) NOT NULL,
  `room` int(11) NOT NULL,
  `bed` int(11) NOT NULL,
  `consultant` int(11) NOT NULL,
  `item` int(11) NOT NULL,
  `department` int(11) NOT NULL,
  `billing` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `a_status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `tbl_user_type`
--

INSERT INTO `tbl_user_type` (`id`, `user_type_no`, `user_type_name`, `dashboard`, `user`, `user_type`, `patient`, `inpatient`, `outpatient`, `room`, `bed`, `consultant`, `item`, `department`, `billing`, `user_id`, `date`, `time`, `a_status`) VALUES
(1, '151', 'Administrator', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2015-07-11', '08:00:00', 1),
(2, '152', 'Information', 1, 0, 0, 1, 1, 1, 1, 1, 1, 0, 0, 0, 1, '2015-07-11', '10:30:46', 1),
(3, '153', 'Items & Services', 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, '2015-07-17', '16:57:06', 1),
(4, '154', 'Nurse', 1, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, '2015-07-17', '16:59:49', 1),
(5, '155', 'Billing Clerk', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, '2015-07-17', '17:00:02', 1),
(6, '156', 'Staff', 1, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, '2015-07-17', '17:00:33', 1);

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