-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 19, 2015 at 12:24 AM
-- Server version: 5.5.38-0ubuntu0.14.04.1
-- PHP Version: 5.5.9-1ubuntu4.5

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

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

DROP TABLE IF EXISTS `user`;

--
-- Table structure for table `announcement`
--

CREATE TABLE IF NOT EXISTS `announcement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'D',
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `announcement`
--

INSERT INTO `announcement` (`id`, `condo_id`, `message`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(1, 1, 'MANAGEMENT OFFICE Operating Hours : Monday to Friday (08.00 am to 05.00 pm) / Saturday (09.00 am to 01.00 pm) / Sunday & Public Holiday (Closed)', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(2, 1, 'LIFT A2 IS OUT OF ORDER AT THE MOMENT DUE TO SOME MECHANICAL ISSUE.', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(3, 1, 'tdsff sdfdfsfs', 'A', '2015-05-12 01:00:24', '2015-05-12 01:00:24', 1, 1);

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

--
-- Table structure for table `business`
--

CREATE TABLE IF NOT EXISTS `business` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `business_type_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `contact_person` varchar(100) DEFAULT NULL,
  `services` varchar(255) DEFAULT NULL,
  `description` text,
  `office_no` varchar(15) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `fax_no` varchar(15) DEFAULT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `business`
--

INSERT INTO `business` (`id`, `condo_id`, `business_type_id`, `name`, `contact_person`, `services`, `description`, `office_no`, `mobile_no`, `fax_no`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(1, 1, 1, 'Asia Creative Events', '', 'Event  Management', 'DJ, Sound and light system for all type of events for example wedding, party, corporate launches, corporate dinners, team building events, expos, exhibition and all other kind of entertainment services such as clowns, dancers, musicians, balloon decorations, etc', '03-42567003', '016-254 1104', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(2, 1, 1, 'AGNI CHAKRA CREATIONS SDN BHD', '', 'Web Design', 'We provide all type of creative services', '03-23002420', '017-2129874', '03-23002421', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(3, 1, 1, 'ADMIRAL', 'Norman William', 'Logistics', 'Inbound Consolidation Services', '0380801715', '0192586340', '0380230082', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(4, 1, 1, 'Chan Kitchen Furniture Sdn Bhd', '', 'Kitchen Interior Design', 'CHAN KITCHEN is one of the leading furniture manufacturer in the industry and it has been standing strong in the local furniture scene for more than 10 years.', '03-51247988', '012-3318025', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(5, 1, 1, 'Prosperity Feng Shui Sdn Bhd', '', 'Feng Shui Consultant', 'Feng Shui consultations for residential and commercial properties', '019-2882968', '019-2882968', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(6, 1, 1, 'KPV Services & Trading', '', 'Cleaning', 'Cleaning | Marble polishing | Grinding | Carpet cleaning/shampooing | Painting & Residential cleaning.', '+60122202862', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(7, 1, 2, 'Kejuruteraan Mercantile Neon', '', 'Electrical', 'All types of electrical work for Residential, Commercial and Industrial', '0342915100', '0123200422', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(8, 1, 2, 'Pan Asiatic Enterprise Sdn Bhd', '', 'Water Proofing', 'Water Proofing Specialist', '03-77295844', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(9, 1, 2, 'AK Plumbing & Roof Leaking Services', '', 'Plumbing', 'Plumbing Specialist', '03-56219285', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(10, 1, 2, 'DREAM HOME RENO & CONSTRUCTION SDN BHD', '', 'Home Renovation', 'ALL-IN-ONE RENOVATION firm that specializes in housing, bungalow, office shops and factory renovation works.', '012-7067869', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(11, 1, 2, 'York', '', 'Air Conditioning', 'Air Conditioning & Fans', '603-77188388', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

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

--
-- Table structure for table `business_type`
--

CREATE TABLE IF NOT EXISTS `business_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `condo_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `business_type`
--

INSERT INTO `business_type` (`id`, `name`, `condo_id`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(1, 'Service Provider', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(2, 'Contractor', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

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

--
-- Table structure for table `charging_condo`
--

CREATE TABLE IF NOT EXISTS `charging_condo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `type` varchar(10) NOT NULL,
  `maintenance_fee` decimal(10,0) NOT NULL,
  `sinking_fund_fee` decimal(10,0) NOT NULL,
  `insurance_fee` decimal(10,0) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `charging_condo`
--

INSERT INTO `charging_condo` (`id`, `condo_id`, `type`, `maintenance_fee`, `sinking_fund_fee`, `insurance_fee`) VALUES
(1, 1, 'A', 150, 50, 50),
(2, 1, 'B', 170, 70, 70),
(3, 1, 'C', 190, 90, 90),
(4, 2, 'A', 150, 50, 50),
(5, 2, 'B', 170, 70, 70),
(6, 2, 'C', 190, 90, 90);

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

--
-- Table structure for table `charging_facility`
--

CREATE TABLE IF NOT EXISTS `charging_facility` (
  `id` int(11) NOT NULL,
  `condo_facility_id` int(11) NOT NULL,
  `fee` decimal(10,0) NOT NULL,
  `deposit` decimal(10,0) DEFAULT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `condo`
--

CREATE TABLE IF NOT EXISTS `condo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `subdomain` varchar(50) NOT NULL,
  `url` varchar(255) NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `house_rules` varchar(255) DEFAULT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `condo`
--

INSERT INTO `condo` (`id`, `name`, `address`, `subdomain`, `url`, `logo`, `house_rules`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(1, 'Kiara 1888', 'Jalan Kiara 3, 50480 Kuala Lumpur, Wilayah Persekutuan Kuala Lumpur', 'kiara1888vmware', 'kiara1888vmware.theresidenz.my', 'kiara1888_logo.png', '1_house_rule.pdf', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(2, 'Vipod', 'Jalan Genting Kelang, Kuala Lumpur, Wilayah Persekutuan Kuala Lumpur', 'vipodvmware', 'vipodvmware.theresidenz.my', 'vipod_logo.png', NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

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

--
-- Table structure for table `condo_facility`
--

CREATE TABLE IF NOT EXISTS `condo_facility` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `condo_facility`
--

INSERT INTO `condo_facility` (`id`, `condo_id`, `name`) VALUES
(1, 1, 'Badminton Court'),
(2, 2, 'Badminton Court'),
(3, 1, 'Swimming Pool');

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

--
-- Table structure for table `condo_unit`
--

CREATE TABLE IF NOT EXISTS `condo_unit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `house_no` varchar(50) NOT NULL,
  `unit` varchar(15) NOT NULL,
  `level` varchar(15) NOT NULL,
  `block` varchar(15) NOT NULL,
  `owner_activation_key` varchar(6) DEFAULT NULL,
  `tenant_activation_key` varchar(6) DEFAULT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=420 ;

--
-- Dumping data for table `condo_unit`
--

INSERT INTO `condo_unit` (`id`, `condo_id`, `house_no`, `unit`, `level`, `block`, `owner_activation_key`, `tenant_activation_key`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(324, 1, 'A-1-1', '1', '1', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(325, 1, 'A-1-2', '2', '1', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(326, 1, 'A-1-3', '3', '1', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(327, 1, 'A-1-4', '4', '1', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(328, 1, 'A-1-5', '5', '1', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(329, 1, 'A-1-6', '6', '1', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(330, 1, 'A-1-7', '7', '1', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(331, 1, 'A-1-8', '8', '1', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(332, 1, 'A-1-9', '9', '1', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(333, 1, 'A-1-10', '10', '1', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(334, 1, 'A-1-11', '11', '1', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(335, 1, 'A-1-12', '12', '1', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(336, 1, 'A-2-1', '1', '2', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(337, 1, 'A-2-2', '2', '2', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(338, 1, 'A-2-3', '3', '2', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(339, 1, 'A-2-4', '4', '2', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(340, 1, 'A-2-5', '5', '2', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(341, 1, 'A-2-6', '6', '2', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(342, 1, 'A-2-7', '7', '2', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(343, 1, 'A-2-8', '8', '2', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(344, 1, 'A-2-9', '9', '2', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(345, 1, 'A-2-10', '10', '2', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(346, 1, 'A-2-11', '11', '2', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(347, 1, 'A-2-12', '12', '2', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(348, 1, 'A-3-1', '1', '3', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(349, 1, 'A-3-2', '2', '3', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(350, 1, 'A-3-3', '3', '3', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(351, 1, 'A-3-4', '4', '3', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(352, 1, 'A-3-5', '5', '3', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(353, 1, 'A-3-6', '6', '3', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(354, 1, 'A-3-7', '7', '3', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(355, 1, 'A-3-8', '8', '3', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(356, 1, 'A-3-9', '9', '3', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(357, 1, 'A-3-10', '10', '3', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(358, 1, 'A-3-11', '11', '3', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(359, 1, 'A-3-12', '12', '3', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(360, 1, 'A-4-1', '1', '4', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(361, 1, 'A-4-2', '2', '4', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(362, 1, 'A-4-3', '3', '4', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(363, 1, 'A-4-4', '4', '4', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(364, 1, 'A-4-5', '5', '4', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(365, 1, 'A-4-6', '6', '4', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(366, 1, 'A-4-7', '7', '4', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(367, 1, 'A-4-8', '8', '4', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(368, 1, 'A-4-9', '9', '4', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(369, 1, 'A-4-10', '10', '4', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(370, 1, 'A-4-11', '11', '4', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(371, 1, 'A-4-12', '12', '4', 'A', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(372, 1, 'B-1-1', '1', '1', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(373, 1, 'B-1-2', '2', '1', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(374, 1, 'B-1-3', '3', '1', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(375, 1, 'B-1-4', '4', '1', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(376, 1, 'B-1-5', '5', '1', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(377, 1, 'B-1-6', '6', '1', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(378, 1, 'B-1-7', '7', '1', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(379, 1, 'B-1-8', '8', '1', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(380, 1, 'B-1-9', '9', '1', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(381, 1, 'B-1-10', '10', '1', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(382, 1, 'B-1-11', '11', '1', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(383, 1, 'B-1-12', '12', '1', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(384, 1, 'B-2-1', '1', '2', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(385, 1, 'B-2-2', '2', '2', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(386, 1, 'B-2-3', '3', '2', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(387, 1, 'B-2-4', '4', '2', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(388, 1, 'B-2-5', '5', '2', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(389, 1, 'B-2-6', '6', '2', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(390, 1, 'B-2-7', '7', '2', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(391, 1, 'B-2-8', '8', '2', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(392, 1, 'B-2-9', '9', '2', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(393, 1, 'B-2-10', '10', '2', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(394, 1, 'B-2-11', '11', '2', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(395, 1, 'B-2-12', '12', '2', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(396, 1, 'B-3-1', '1', '3', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(397, 1, 'B-3-2', '2', '3', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(398, 1, 'B-3-3', '3', '3', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(399, 1, 'B-3-4', '4', '3', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(400, 1, 'B-3-5', '5', '3', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(401, 1, 'B-3-6', '6', '3', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(402, 1, 'B-3-7', '7', '3', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(403, 1, 'B-3-8', '8', '3', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(404, 1, 'B-3-9', '9', '3', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(405, 1, 'B-3-10', '10', '3', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(406, 1, 'B-3-11', '11', '3', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(407, 1, 'B-3-12', '12', '3', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(408, 1, 'B-4-1', '1', '4', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(409, 1, 'B-4-2', '2', '4', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(410, 1, 'B-4-3', '3', '4', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(411, 1, 'B-4-4', '4', '4', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(412, 1, 'B-4-5', '5', '4', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(413, 1, 'B-4-6', '6', '4', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(414, 1, 'B-4-7', '7', '4', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(415, 1, 'B-4-8', '8', '4', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(416, 1, 'B-4-9', '9', '4', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(417, 1, 'B-4-10', '10', '4', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(418, 1, 'B-4-11', '11', '4', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(419, 1, 'B-4-12', '12', '4', 'B', NULL, NULL, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

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

--
-- Table structure for table `contact`
--

CREATE TABLE IF NOT EXISTS `contact` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `contact_type_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `contact_no` varchar(50) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=159 ;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `condo_id`, `contact_type_id`, `name`, `contact_no`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(1, 1, 1, 'Polis & Ambulan', '999', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(2, 1, 1, 'Kebakaran', '994', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(3, 1, 1, 'Pertahanan Awam', '991', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(4, 1, 1, 'Dpd Telefon Bimbit', '112', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(5, 1, 1, 'TNB', '15454', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(6, 1, 1, 'Telekom (kerosakan)', '100', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(7, 1, 1, 'Operator - Domestic', '101', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(8, 1, 1, 'Permintaan No Telefon', '103', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(9, 1, 1, 'Perkhidmatan Telegram', '100', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(10, 1, 1, 'Operator - Antarabangsa', '101', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(11, 1, 2, 'DBKL', '03 2693 4531', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(12, 1, 2, 'MPAJ', '03 4296 8000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(13, 1, 2, 'MPK', '03 3371 6044', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(14, 1, 2, 'MPPJ', '03 7956 3544', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(15, 1, 2, 'MBSA', '03 5510 5133', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(16, 1, 2, 'MPSJ', '03 8026 3131', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(17, 1, 3, 'Bank Negara', '03 2698 8044', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(18, 1, 3, 'Bukit Aman', '03 2262 6222', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(19, 1, 3, 'Customs', '03 6201 6088', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(20, 1, 3, 'Domestic Trade', '03 2274 2100', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(21, 1, 3, 'KWSP', '03 2694 6566', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(22, 1, 3, 'Foreign Affairs', '03 8887 4000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(23, 1, 3, 'Home Affairs', '03 8886 8000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(24, 1, 3, 'Sumber Manusia', '03 8886 5000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(25, 1, 3, 'Kastam', '03 2093 9181', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(26, 1, 3, 'LHDNM', '1-800-88-5436', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(27, 1, 3, 'JAKIM', '03 8886 4000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(28, 1, 3, 'JPJ', '03 2094 5666', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(29, 1, 3, 'KLSE', '03 2026 7099', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(30, 1, 3, 'Meteorology', '03 7958 7422', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(31, 1, 3, 'MIDA', '03 2095 3633', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(32, 1, 3, 'MIMOS', '03 8996 5000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(33, 1, 3, 'SIRIM', '03 5544 6000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(34, 1, 3, 'SOSCO', '03 4253 5320', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(35, 1, 3, 'Jabatan Haiwan', '03 2094 0077', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(36, 1, 4, 'Alam Flora', '03 2052 7922', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(37, 1, 4, 'Indah Water', '1 800 88 3495', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(38, 1, 4, 'SYABAS', '1 800 88 5252', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(39, 1, 4, 'Pos Malaysia', '03 2274 4141', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(40, 1, 4, 'Telekom', '03 2020 9494', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(41, 1, 4, 'Tenaga Nasional', '03 2282 5566', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(42, 1, 5, 'KLIA', '03 8776 2000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(43, 1, 5, 'Penang', '04 643 0501', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(44, 1, 5, 'Changi', '02 542 9727', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(45, 1, 6, 'Aeroflot', '03 2161 3231', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(46, 1, 6, 'AirAsia', '03 7651 2222', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(47, 1, 6, 'Air India', '03 2614 2166', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(48, 1, 6, 'Berjaya Air', '03 2145 2132', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(49, 1, 6, 'Cathay Pacific', '03 2078 3377', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(50, 1, 6, 'Garuda', '03 2162 2811', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(51, 1, 6, 'Japan Airlines', '03 2161 1700', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(52, 1, 6, 'MAS', '1 300 88 3000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(53, 1, 6, 'Qantas', '03 2167 6000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(54, 1, 6, 'Rotal Brunei', '03 2070 7166', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(55, 1, 6, 'SIA', '03 2692 3122', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(56, 1, 6, 'Thai Airways', '03 2031 1900', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(57, 1, 7, 'Comfort', '03 8024 2727', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(58, 1, 7, 'KL Teksi', '03 9221 8999', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(59, 1, 7, 'Persatuan Radio', '03 2693 6211', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(60, 1, 7, 'Public Cab', '03 6259 2020', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(61, 1, 7, 'Radio Cab', '03 9221 7600', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(62, 1, 7, 'Saujana', '03 2162 8888', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(63, 1, 7, 'Silvertop', '03 4023 1267', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(64, 1, 7, 'Supercab', '03 7875 7333', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(65, 1, 7, 'Sunlight', '03 9058 9986', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(66, 1, 7, 'Teletaxi', '03 9221 1011', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(67, 1, 8, 'Intrakota', '03 7726 2944', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(68, 1, 8, 'KESAS', '03 5633 7188', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(69, 1, 8, 'KL Sentral Station', '03 2279 8888', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(70, 1, 8, 'KTM', '03 2273 8000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(71, 1, 8, 'PLUS', '03 7981 8000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(72, 1, 8, 'Plusliner', '03 2272 1586', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(73, 1, 8, 'Putra LRT', '1 800 38 8228', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(74, 1, 8, 'Sprint', '03 7960 1050', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(75, 1, 8, 'Star LRT', '1 800 38 8288', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(76, 1, 9, 'Ere 103.3', '03 9543 3355', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(77, 1, 9, 'Hitz FM  92.9', '03 9543 3311', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(78, 1, 9, 'Light&Ez 105.7', '03 9543 3333', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(79, 1, 9, 'Mix FM   94.5', '03 9543 3322', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(80, 1, 9, 'MyFM 101.8', '03 9543 3366', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(81, 1, 9, 'Radio 1  98.3', '03 2282 2484', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(82, 1, 9, 'Radio 4  90.3', '03 2282 5491', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(83, 1, 9, 'Radio 5  89.3', '03 2288 7266', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(84, 1, 9, 'Radio 6 92.3', '03 2288 7279', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(85, 1, 9, 'Radio KL  97.2', '03 2282 5445', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(86, 1, 9, 'R Muzik 88.5', '03 2288 7676', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(87, 1, 9, 'Red104.9  104.9', '03 4043 1049', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(88, 1, 9, 'Redi 988  98.8', '03 4042 0988', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(89, 1, 9, 'THR 99.3', '03 2720 9993', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(90, 1, 9, 'WOW 97.6', '03 7955 7969', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(91, 1, 10, '1 Stop Crisis Center', '03 2615 3333', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(92, 1, 10, 'AWAM', '03 7877 4221', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(93, 1, 10, 'Befrienders', '03 7956 8144', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(94, 1, 10, 'Buddies of Ipoh', '05 546 7633', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(95, 1, 10, 'HAWA', '03 2693 0095', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(96, 1, 10, 'Talidera', '1 800 88 3040', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(97, 1, 10, 'WAO', '03 7956 3488', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(98, 1, 11, 'Celcom.net', '019 300 0900', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(99, 1, 11, 'Jaring', '03 8996 5000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(100, 1, 11, 'Maxis Net', '1 300 82 1512', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(101, 1, 11, 'Timenet', '03 2710 6200', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(102, 1, 11, 'TMnet', '03 8318 8027', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(103, 1, 12, 'Celcom', '03 3630 8888', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(104, 1, 12, 'Digi', '016 221 1800', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(105, 1, 12, 'Maxis', '03 7492 2123', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(106, 1, 13, 'Amex', '03 2026 1770', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(107, 1, 13, 'Citibank', '03 2383 0000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(108, 1, 13, 'Diners Club', '03 2161 1055', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(109, 1, 13, 'MBF', '03 2161 8075', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(110, 1, 14, 'Biro Pengaduan', '03 8888 7777', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(111, 1, 14, 'Biro Pengaduan', '03 8888 7777', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(112, 1, 14, 'CAP', '04 229 3571', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(113, 1, 14, 'FOMCA', '03 7876 2009', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(114, 1, 14, 'MCA Hotline', '03 6258 9323', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(115, 1, 14, 'MCA PSC Dept', '03 2163 2305', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(116, 1, 14, 'Malay Mail Hotline', '03 2282 1002', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(117, 1, 15, 'Domino''s', '1 300 88 8333', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(118, 1, 15, 'McDonalds', '1 300 13 1300', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(119, 1, 15, 'Pizza Hut', '1 300 88 2525', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(120, 1, 16, 'GSC', '03 8312 3456', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(121, 1, 16, 'TGV', '03 7492 2929', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(122, 1, 17, 'Astro', '03 9543 4188', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(123, 1, 17, 'NTV 7', '03 5569 1777', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(124, 1, 17, 'RTM', '03 2282 5333', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(125, 1, 17, 'TV3', '03 7726 6333', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(126, 1, 18, 'AAM Breakdown', '03 2161 0808', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(127, 1, 18, 'Bar Council', '03 2691 1698', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(128, 1, 18, 'SPCA', '03 4256 5312', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(129, 1, 18, 'SUHAKAM', '03 2612 5600', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(130, 1, 19, 'Ampang Puteri', '03 4270 2500', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(131, 1, 19, 'Assunta', '03 7782 3433', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(132, 1, 19, 'Damansara', '03 7722 2692', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(133, 1, 19, 'GHKL', '03 2692 1044', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(134, 1, 19, 'Gleaneagles', '03 4257 1300', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(135, 1, 19, 'HeartScan', '03 2287 0988', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(136, 1, 19, 'Institut Jantung', '03 2698 1333', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(137, 1, 19, 'Mont'' Kiara', '03 2382 3500', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(138, 1, 19, 'Pantai Cheras', '03 9132 2022', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(139, 1, 19, 'Pantai Medical', '03 2296 0888', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(140, 1, 19, 'Selayang', '03 6136 7788', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(141, 1, 19, 'Sentosa', '03 4043 7166', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(142, 1, 19, 'SJMC', '03 5634 1212', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(143, 1, 19, 'Sunway Medical', '03 7491 9191', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(144, 1, 19, 'Tawakal', '03 4023 3599', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(145, 1, 19, 'Tung Shin', '03 2072 1655', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(146, 1, 19, 'Tun Hussein Onn', '03 7956 1511', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(147, 1, 19, 'University PJ', '03 7956 4422', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(148, 1, 20, 'Australia', '03 2146 5555', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(149, 1, 20, 'Bangladesh', '03 2148 7940', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(150, 1, 20, 'Brunei', '03 2161 2828', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(151, 1, 20, 'Canada', '03 2718 8333', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(152, 1, 20, 'China', '03 2142 8585', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(153, 1, 20, 'France', '03 2053 5500', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(154, 1, 20, 'Germany', '03 2142 9666', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(155, 1, 20, 'India', '03 2093 3504', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(156, 1, 20, 'Indonesia', '03 2142 1151', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(157, 1, 20, 'Japan', '03 2142 7044', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(158, 1, 20, 'Korea (South)', '03 4251 2336', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

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

--
-- Table structure for table `contact_type`
--

CREATE TABLE IF NOT EXISTS `contact_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `condo_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `contact_type`
--

INSERT INTO `contact_type` (`id`, `name`, `condo_id`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(1, 'GENERAL', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(2, 'BADAN BERKUASA TEMPATAN', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(3, 'JABATAN KERAJAAN', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(4, 'SYARIKAT KEMUDAHAN UTILITI', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(5, 'MAKLUMAT PENERBANGAN', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(6, 'PENERBANGAN', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(7, 'PERKHIDMATAN TAXI RADIO', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(8, 'PENGANGKUTAN', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(9, 'RADIO', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(10, 'HELPLINE', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(11, 'ISPs', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(12, 'OPERATOR MOBIL', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(13, 'KAD KREDIT', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(14, 'ADUAN AWAM', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(15, 'MAKANAN', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(16, 'TEMPAHAN PANGGUNG WAYANG', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(17, 'STATION TV', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(18, 'LAIN-LAIN', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(19, 'HOSPITALS', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(20, 'DUTA KL', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

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

--
-- Table structure for table `conversation`
--

CREATE TABLE IF NOT EXISTS `conversation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `block` varchar(5) DEFAULT NULL,
  `residence_type` varchar(1) DEFAULT NULL,
  `unit_id` int(11) DEFAULT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

--
-- Dumping data for table `conversation`
--

INSERT INTO `conversation` (`id`, `condo_id`, `subject`, `block`, `residence_type`, `unit_id`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(22, 1, 'from management to B-4-11', 'B', 'O', 418, '2015-05-18 20:06:21', '2015-05-18 20:12:42', 414, 364);

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

--
-- Table structure for table `conversation_message`
--

CREATE TABLE IF NOT EXISTS `conversation_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `conversation_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `attachment` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `conversation_id` (`conversation_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;

--
-- Dumping data for table `conversation_message`
--

INSERT INTO `conversation_message` (`id`, `conversation_id`, `sender_id`, `message`, `attachment`) VALUES
(33, 22, 414, 'aa', NULL),
(36, 22, 364, 'bb', NULL);

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

--
-- Table structure for table `council_member`
--

CREATE TABLE IF NOT EXISTS `council_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `position` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `contact_no` varchar(15) DEFAULT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `council_member`
--

INSERT INTO `council_member` (`id`, `condo_id`, `position`, `name`, `contact_no`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(1, 1, 'Chairman', 'Mr. Wong Fei Hong', '0123456789', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(2, 1, 'Secretary', 'Ms. Bala', '0123456789', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(3, 1, 'Treasurer', 'Mr. Wahab', '0123456789', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

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

--
-- Table structure for table `email_blast`
--

CREATE TABLE IF NOT EXISTS `email_blast` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `mailgun_campaign_id` varchar(255) DEFAULT NULL,
  `mailgun_mailing_list` varchar(255) DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `body` text,
  `status` varchar(1) NOT NULL DEFAULT 'D',
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `email_blast`
--

INSERT INTO `email_blast` (`id`, `condo_id`, `name`, `mailgun_campaign_id`, `mailgun_mailing_list`, `subject`, `body`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(1, 1, 'New offer from TGV', 'testing_mailgun', 'graduan_news_test_group@graduan.info', 'New offer from TGV', '<div style="background-color:#000000;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#000000; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left">\r\n			<div><img alt="" src="/upload/files/The-Residenz-Logo-trans.png" style="height:47px; width:80px" /></div>\r\n			</td>\r\n			<td style="text-align:right"><img alt="" src="/upload/files/icons/facebook.png" style="border:0px solid; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /> <img alt="" src="/upload/files/icons/twitter.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/googleplus.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/instagram.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/youtube.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n\r\n<div style="padding-top:20px;padding-bottom:20px;background-color:#ddd;text-align:center;align:center;font-family:Arial,Helvetica,sans-serif;font-size:12px;color:#000000;">\r\n<table align="center" border="0" cellpadding="5" cellspacing="0" style="background-color:#fff; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td style="text-align:left">\r\n			<p><img alt="" src="/upload/files/emails/main-banner-1.jpg" style="height:255px; width:580px" /><br />\r\n			<br />\r\n			Dear %recipient%,<br />\r\n			We are.....</p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left">\r\n			<table align="center" border="0" cellpadding="5" cellspacing="0" style="background-color:rgb(51, 102, 153); margin-left:auto; margin-right:auto; width:580px">\r\n				<tbody>\r\n					<tr>\r\n						<td><a href="http://www.google.com" style="color:#fff;">Check it out!</a></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left">&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left"><img alt="" src="/upload/files/emails/email_footer.jpg" style="height:167px; width:580px" /></td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n\r\n<div style="background-color:#000000;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#000000; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td style="text-align:center">\r\n			<div>\r\n			<div>\r\n			<p style="text-align:left"><span style="color:rgb(255, 255, 255); font-size:12px">To avoid future emails from being automatically sent to your junk mail folder, we suggest that you add our email address [abc@residenz.my]&nbsp;<span style="color:rgb(255, 255, 255); font-size:12px"> </span>to your Address Book and/or the &ldquo;Approved Sender&rdquo; list.</span></p>\r\n\r\n			<p style="text-align:left"><span style="color:rgb(255, 255, 255); font-size:12px">This is a computer generated email. Please do not reply to this email. </span></p>\r\n			</div>\r\n			</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n', 'C', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

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

--
-- Table structure for table `email_queue`
--

CREATE TABLE IF NOT EXISTS `email_queue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email_template_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `data` text,
  `status` varchar(1) NOT NULL DEFAULT 'P',
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `email_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `code` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `subject` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `template` text COLLATE utf8_unicode_ci NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

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

INSERT INTO `email_template` (`id`, `condo_id`, `code`, `name`, `subject`, `template`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(1, 1, 'REV01', 'Registration - Email Verification', 'Registration - Email Verification', '<div style="background-color:#000000;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#000000; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left">\r\n			<div><img alt="" src="/upload/files/The-Residenz-Logo-trans.png" style="height:47px; width:80px" /></div>\r\n			</td>\r\n			<td style="text-align:right"><img alt="" src="/upload/files/icons/facebook.png" style="border:0px solid; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /> <img alt="" src="/upload/files/icons/twitter.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/googleplus.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/instagram.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/youtube.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n\r\n<div style="padding-top:20px;padding-bottom:20px;background-color:#ddd;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="5" cellspacing="0" style="background-color:#fff; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td style="text-align:left"><img alt="" src="/upload/files/emails/main-banner-1.jpg" style="height:255px; width:580px" /> Dear {name},<br />\r\n			Thank you for activating your account. Please click on the link below to verify your email address.<br />\r\n			&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left">\r\n			<table align="center" border="0" cellpadding="5" cellspacing="0" style="background-color:rgb(51, 102, 153); margin-left:auto; margin-right:auto; width:580px">\r\n				<tbody>\r\n					<tr>\r\n						<td><strong><a href="http://{site_url}/site/verifyemail/?id={verification_id}" style="color:#fff;" target="_blank">Verify My Email Address</a></strong></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left">&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left"><img alt="" src="/upload/files/emails/email_footer.jpg" style="height:167px; width:580px" /></td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n\r\n<div style="background-color:#000000;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#000000; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td style="text-align:center">\r\n			<div>\r\n			<div>\r\n			<p style="text-align:left"><span style="color:rgb(255, 255, 255); font-size:12px">To avoid future emails from being automatically sent to your junk mail folder, we suggest that you add our email address [abc@residenz.my]&nbsp;<span style="color:rgb(255, 255, 255); font-size:12px"> </span>to your Address Book and/or the &ldquo;Approved Sender&rdquo; list.</span></p>\r\n\r\n			<p style="text-align:left"><span style="color:rgb(255, 255, 255); font-size:12px">This is a computer generated email. Please do not reply to this email. </span></p>\r\n			</div>\r\n			</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(2, 1, 'DN01', 'Daily Notification', 'Daily Notification', '<div style="background-color:#000000;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#000000; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left">\r\n			<div><img alt="" src="/upload/files/The-Residenz-Logo-trans.png" style="height:47px; width:80px" /></div>\r\n			</td>\r\n			<td style="text-align:right"><img alt="" src="/upload/files/icons/facebook.png" style="border:0px solid; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /> <img alt="" src="/upload/files/icons/twitter.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/googleplus.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/instagram.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/youtube.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n\r\n<div style="padding-top:20px;padding-bottom:20px;background-color:#ddd;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="5" cellspacing="0" style="background-color:#fff; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td style="text-align:left"><img alt="" src="/upload/files/emails/main-banner-1.jpg" style="height:255px; width:580px" /> Dear {name},<br />\r\n			Below are your notification(s).<br />\r\n			<br />\r\n			{notifications} &nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left">&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left"><img alt="" src="/upload/files/emails/email_footer.jpg" style="height:167px; width:580px" /></td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n\r\n<div style="background-color:#000000;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#000000; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td style="text-align:center">\r\n			<div>\r\n			<div>\r\n			<p style="text-align:left"><span style="color:rgb(255, 255, 255); font-size:12px">To avoid future emails from being automatically sent to your junk mail folder, we suggest that you add our email address [abc@residenz.my]&nbsp;<span style="color:rgb(255, 255, 255); font-size:12px"> </span>to your Address Book and/or the &ldquo;Approved Sender&rdquo; list.</span></p>\r\n\r\n			<p style="text-align:left"><span style="color:rgb(255, 255, 255); font-size:12px">This is a computer generated email. Please do not reply to this email. </span></p>\r\n			</div>\r\n			</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(3, 1, 'RF01', 'Registration - Followup', 'Congratulations! Your email has been verified', '<div style="background-color:#000000;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#000000; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left">\r\n			<div><img alt="" src="/upload/files/The-Residenz-Logo-trans.png" style="height:47px; width:80px" /></div>\r\n			</td>\r\n			<td style="text-align:right"><img alt="" src="/upload/files/icons/facebook.png" style="border:0px solid; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /> <img alt="" src="/upload/files/icons/twitter.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/googleplus.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/instagram.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/youtube.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n\r\n<div style="padding-top:20px;padding-bottom:20px;background-color:#ddd;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="5" cellspacing="0" style="background-color:#fff; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td style="text-align:left"><img alt="" src="/upload/files/emails/main-banner-1.jpg" style="height:255px; width:580px" /> Dear {name},<br />\r\n			Congratulations. You have successfully verified your email address. You may now proceed to login to residents portal@ http://theresidenz.my<br />\r\n			As a welcome gift, we present you the following:<br />\r\n			(click on the banner for more details)...<br />\r\n			&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left"><a href="http://kiara1888copy.theresidenz.my/partners/zazen.php?vccode={vccode}"><img alt="" src="/upload/files/emails/welcome-banner-1.jpg" style="height:278px; width:580px" /></a></td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left"><a href="http://www.soukai.my/online-shopping/page.ssp?p=residenz"><img alt="" src="/upload/files/emails/welcome-banner-2.jpg" style="height:161px; width:580px" /></a></td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left"><img alt="" src="/upload/files/emails/welcome-banner-3.jpg" style="height:158px; width:580px" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left"><img alt="" src="/upload/files/emails/email_footer.jpg" style="height:167px; width:580px" /></td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n\r\n<div style="background-color:#000000;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#000000; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td style="text-align:center">\r\n			<div>\r\n			<div>\r\n			<p style="text-align:left"><span style="color:rgb(255, 255, 255); font-size:12px">To avoid future emails from being automatically sent to your junk mail folder, we suggest that you add our email address [abc@residenz.my]&nbsp;<span style="color:rgb(255, 255, 255); font-size:12px"> </span>to your Address Book and/or the &ldquo;Approved Sender&rdquo; list.</span></p>\r\n\r\n			<p style="text-align:left"><span style="color:rgb(255, 255, 255); font-size:12px">This is a computer generated email. Please do not reply to this email. </span></p>\r\n			</div>\r\n			</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(4, 1, 'EV01', 'Email Verification', 'Email Verification', '<div style="background-color:#000000;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#000000; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left">\r\n			<div><img alt="" src="/upload/files/The-Residenz-Logo-trans.png" style="height:47px; width:80px" /></div>\r\n			</td>\r\n			<td style="text-align:right"><img alt="" src="/upload/files/icons/facebook.png" style="border:0px solid; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /> <img alt="" src="/upload/files/icons/twitter.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/googleplus.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/instagram.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/youtube.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n\r\n<div style="padding-top:20px;padding-bottom:20px;background-color:#ddd;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="5" cellspacing="0" style="background-color:#fff; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td style="text-align:left"><img alt="" src="/upload/files/emails/main-banner-1.jpg" style="height:255px; width:580px" /> Dear {name},<br />\r\n			Please click on the link below to verify your email address.<br />\r\n			&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left">\r\n			<table align="center" border="0" cellpadding="5" cellspacing="0" style="background-color:rgb(51, 102, 153); margin-left:auto; margin-right:auto; width:580px">\r\n				<tbody>\r\n					<tr>\r\n						<td><strong><a href="http://{site_url}/site/verifyupdateemail/?id={verification_id}" style="color:#fff;" target="_blank">Verify My Email Address</a></strong></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left">&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left"><img alt="" src="/upload/files/emails/email_footer.jpg" style="height:167px; width:580px" /></td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n\r\n<div style="background-color:#000000;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#000000; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td style="text-align:center">\r\n			<div>\r\n			<div>\r\n			<p style="text-align:left"><span style="color:rgb(255, 255, 255); font-size:12px">To avoid future emails from being automatically sent to your junk mail folder, we suggest that you add our email address [abc@residenz.my]&nbsp;<span style="color:rgb(255, 255, 255); font-size:12px"> </span>to your Address Book and/or the &ldquo;Approved Sender&rdquo; list.</span></p>\r\n\r\n			<p style="text-align:left"><span style="color:rgb(255, 255, 255); font-size:12px">This is a computer generated email. Please do not reply to this email. </span></p>\r\n			</div>\r\n			</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(5, 1, 'RN01', 'Registration - Notification to Management', 'New User Registration ', '<div style="background-color:#000000;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#000000; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left">\r\n			<div><img alt="" src="/upload/files/The-Residenz-Logo-trans.png" style="height:47px; width:80px" /></div>\r\n			</td>\r\n			<td style="text-align:right"><img alt="" src="/upload/files/icons/facebook.png" style="border:0px solid; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /> <img alt="" src="/upload/files/icons/twitter.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/googleplus.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/instagram.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /><img alt="" src="/upload/files/icons/youtube.png" style="border:medium none; height:32px; padding-bottom:5px; padding-right:5px; padding-top:5px; width:32px" /></td>\r\n		</tr>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n\r\n<div style="padding-top:20px;padding-bottom:20px;background-color:#ddd;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="5" cellspacing="0" style="background-color:#fff; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td style="text-align:left"><img alt="" src="/upload/files/emails/main-banner-1.jpg" style="height:255px; width:580px" /> Dear {name},<br />\r\n			There is a new user registration</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left">&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td style="text-align:left"><img alt="" src="/upload/files/emails/email_footer.jpg" style="height:167px; width:580px" /></td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n\r\n<div style="background-color:#000000;text-align:center;align:center;font-family:Helvetica Neue,Arial,Helvetica,sans-serif">\r\n<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#000000; margin-left:auto; margin-right:auto; width:580px">\r\n	<tbody>\r\n		<tr>\r\n			<td style="text-align:center">\r\n			<div>\r\n			<div>\r\n			<p style="text-align:left"><span style="color:rgb(255, 255, 255); font-size:12px">To avoid future emails from being automatically sent to your junk mail folder, we suggest that you add our email address [abc@residenz.my]&nbsp;<span style="color:rgb(255, 255, 255); font-size:12px"> </span>to your Address Book and/or the &ldquo;Approved Sender&rdquo; list.</span></p>\r\n\r\n			<p style="text-align:left"><span style="color:rgb(255, 255, 255); font-size:12px">This is a computer generated email. Please do not reply to this email. </span></p>\r\n			</div>\r\n			</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

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

--
-- Table structure for table `file`
--

CREATE TABLE IF NOT EXISTS `file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `filename` varchar(100) NOT NULL,
  `description` text,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `file`
--

INSERT INTO `file` (`id`, `condo_id`, `filename`, `description`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(1, 1, 'Frankenstein.pdf', 'File 1 description.', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(2, 1, 'Oliver-Twist.pdf', 'File 2 description.', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

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

--
-- Table structure for table `gallery`
--

CREATE TABLE IF NOT EXISTS `gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `image` varchar(50) NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `condo_id`, `title`, `image`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(3, 1, 'Gallery 1', 'Gallery1_main_tulips.jpg', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(4, 1, 'Gallery 2', 'Gallery2_main_p_20141101_105817_hdr.jpg', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

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

--
-- Table structure for table `gallery_image`
--

CREATE TABLE IF NOT EXISTS `gallery_image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_id` int(11) NOT NULL,
  `image` varchar(50) NOT NULL,
  `thumbnail` varchar(50) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `gallery_image`
--

INSERT INTO `gallery_image` (`id`, `gallery_id`, `image`, `thumbnail`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(7, 3, 'Gallery1_image_chrysanthemum.jpg', 'Gallery1_image_chrysanthemum.jpg', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(8, 3, 'Gallery1_image_desert.jpg', 'Gallery1_image_desert.jpg', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(9, 3, 'Gallery1_image_hydrangeas.jpg', 'Gallery1_image_hydrangeas.jpg', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(10, 3, 'Gallery1_image_tulips.jpg', 'Gallery1_image_tulips.jpg', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(11, 4, 'Gallery2_image_c360_2014-10-21-15-03-04-943.jpg', 'Gallery2_image_c360_2014-10-21-15-03-04-943.jpg', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(12, 4, 'Gallery2_image_img-20141013-wa0016.jpg', 'Gallery2_image_img-20141013-wa0016.jpg', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(13, 4, 'Gallery2_image_img-20141013-wa0017.jpg', 'Gallery2_image_img-20141013-wa0017.jpg', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(14, 4, 'Gallery2_image_p_20141101_105817_hdr.jpg', 'Gallery2_image_p_20141101_105817_hdr.jpg', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

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

--
-- Table structure for table `general_message`
--

CREATE TABLE IF NOT EXISTS `general_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `block` varchar(5) NOT NULL,
  `residence_type` varchar(1) NOT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `general_message`
--

INSERT INTO `general_message` (`id`, `condo_id`, `block`, `residence_type`, `attachment`, `subject`, `message`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(6, 1, 'A', 'O', 'gm_6_Residents.csv', 'Test General Msg to Owner Block A', 'Test General Msg to Owner Block A', '2015-05-11 20:58:42', '2015-05-11 20:58:42', 1, 1);

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

--
-- Table structure for table `mail_notification`
--

CREATE TABLE IF NOT EXISTS `mail_notification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `notification_type` varchar(15) NOT NULL,
  `data` text,
  `status` varchar(1) NOT NULL DEFAULT 'P',
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

--
-- Dumping data for table `mail_notification`
--

INSERT INTO `mail_notification` (`id`, `user_id`, `notification_type`, `data`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(18, 364, 'message', '{"creator_id":364,"external_id":18}', 'S', '2015-05-18 18:44:03', '2015-05-18 20:49:22', 364, 0),
(19, 364, 'message', '{"creator_id":364,"external_id":19}', 'S', '2015-05-18 19:11:32', '2015-05-18 20:49:23', 364, 0),
(20, 364, 'message', '{"creator_id":414,"external_id":20}', 'S', '2015-05-18 19:30:45', '2015-05-18 20:49:23', 414, 0),
(21, 364, 'message', '{"creator_id":414,"external_id":21}', 'S', '2015-05-18 19:55:04', '2015-05-18 20:49:23', 414, 0),
(22, 414, 'message', '{"creator_id":364,"external_id":21}', 'S', '2015-05-18 19:57:16', '2015-05-18 20:49:24', 364, 0),
(23, 364, 'message', '{"creator_id":414,"external_id":22}', 'S', '2015-05-18 20:06:21', '2015-05-18 20:49:23', 414, 0),
(24, 414, 'message', '{"creator_id":364,"external_id":22}', 'S', '2015-05-18 20:06:34', '2015-05-18 20:49:24', 364, 0),
(25, 1, 'message', '{"creator_id":364,"external_id":22}', 'S', '2015-05-18 20:12:42', '2015-05-18 20:49:21', 364, 0);

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

--
-- Table structure for table `migration`
--

-- CREATE TABLE IF NOT EXISTS `migration` (
--   `version` varchar(180) NOT NULL,
--   `apply_time` int(11) DEFAULT NULL,
--   PRIMARY KEY (`version`)
-- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `migration`
--

-- INSERT INTO `migration` (`version`, `apply_time`) VALUES
-- ('m000000_000000_base', 1424435395),
-- ('m130524_201442_init', 1424435402);

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

--
-- Table structure for table `private_message`
--

CREATE TABLE IF NOT EXISTS `private_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `block` varchar(5) NOT NULL,
  `residence_type` varchar(1) NOT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `unit_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `private_message`
--

INSERT INTO `private_message` (`id`, `condo_id`, `block`, `residence_type`, `attachment`, `subject`, `message`, `unit_id`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(2, 1, 'B', 'O', 'pm_2_aidiel.jpg', 'Your profile photo', 'Keep it', 418, '2015-05-11 20:59:46', '2015-05-11 20:59:46', 1, 1);

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

--
-- Table structure for table `residence_upload`
--

CREATE TABLE IF NOT EXISTS `residence_upload` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `house_no` varchar(15) NOT NULL,
  `block` varchar(15) NOT NULL,
  `level` varchar(15) NOT NULL,
  `unit` varchar(15) NOT NULL,
  `condo_id` int(11) NOT NULL,
  `residence_type` varchar(1) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'P',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=785 ;

--
-- Dumping data for table `residence_upload`
--

INSERT INTO `residence_upload` (`id`, `house_no`, `block`, `level`, `unit`, `condo_id`, `residence_type`, `name`, `email`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`, `status`) VALUES
(687, 'A-1-1', 'A', '1', '1', 1, 'O', 'Owner1', 'owner1@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:46:58', 1, 1, 'C'),
(688, 'A-1-2', 'A', '1', '2', 1, 'O', 'Haslinda', 'elinda35@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:46:59', 1, 1, 'C'),
(689, 'A-1-3', 'A', '1', '3', 1, 'O', 'Owner3', 'owner3@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:00', 1, 1, 'C'),
(690, 'A-1-4', 'A', '1', '4', 1, 'O', 'Owner4', 'owner4@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:00', 1, 1, 'C'),
(691, 'A-1-5', 'A', '1', '5', 1, 'O', 'Owner5', 'owner5@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:01', 1, 1, 'C'),
(692, 'A-1-6', 'A', '1', '6', 1, 'O', 'Owner6', 'owner6@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:01', 1, 1, 'C'),
(693, 'A-1-7', 'A', '1', '7', 1, 'O', 'Owner7', 'owner7@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:02', 1, 1, 'C'),
(694, 'A-1-8', 'A', '1', '8', 1, 'O', 'Owner8', 'owner8@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:02', 1, 1, 'C'),
(695, 'A-1-9', 'A', '1', '9', 1, 'O', 'Owner9', 'owner9@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:03', 1, 1, 'C'),
(696, 'A-1-10', 'A', '1', '10', 1, 'O', 'Razlie Rosman', 'aidiel.naqisma@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:04', 1, 1, 'C'),
(697, 'A-1-11', 'A', '1', '11', 1, 'O', 'Owner11', 'owner11@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:04', 1, 1, 'C'),
(698, 'A-1-12', 'A', '1', '12', 1, 'O', 'Owner12', 'owner12@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:05', 1, 1, 'C'),
(699, 'A-2-1', 'A', '2', '1', 1, 'O', 'Haslinda', 'elinda35@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:05', 1, 1, 'C'),
(700, 'A-2-2', 'A', '2', '2', 1, 'O', 'Owner14', 'owner14@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:06', 1, 1, 'C'),
(701, 'A-2-3', 'A', '2', '3', 1, 'O', 'Owner15', 'owner15@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:07', 1, 1, 'C'),
(702, 'A-2-4', 'A', '2', '4', 1, 'O', 'Owner16', 'owner16@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:22', 1, 1, 'C'),
(703, 'A-2-5', 'A', '2', '5', 1, 'O', 'Owner17', 'owner17@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:24', 1, 1, 'C'),
(704, 'A-2-6', 'A', '2', '6', 1, 'O', 'Owner18', 'owner18@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:25', 1, 1, 'C'),
(705, 'A-2-7', 'A', '2', '7', 1, 'O', 'Owner19', 'owner19@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:25', 1, 1, 'C'),
(706, 'A-2-8', 'A', '2', '8', 1, 'O', 'Owner20', 'owner20@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:26', 1, 1, 'C'),
(707, 'A-2-9', 'A', '2', '9', 1, 'O', 'Owner21', 'owner21@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:26', 1, 1, 'C'),
(708, 'A-2-10', 'A', '2', '10', 1, 'O', 'Owner22', 'owner22@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:27', 1, 1, 'C'),
(709, 'A-2-11', 'A', '2', '11', 1, 'O', 'Owner23', 'owner23@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:28', 1, 1, 'C'),
(710, 'A-2-12', 'A', '2', '12', 1, 'O', 'Owner24', 'owner24@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:28', 1, 1, 'C'),
(711, 'A-3-1', 'A', '3', '1', 1, 'O', 'Owner25', 'owner25@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:29', 1, 1, 'C'),
(712, 'A-3-2', 'A', '3', '2', 1, 'O', 'Owner26', 'owner26@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:29', 1, 1, 'C'),
(713, 'A-3-3', 'A', '3', '3', 1, 'O', 'Owner27', 'owner27@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:30', 1, 1, 'C'),
(714, 'A-3-4', 'A', '3', '4', 1, 'O', 'Owner28', 'owner28@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:31', 1, 1, 'C'),
(715, 'A-3-5', 'A', '3', '5', 1, 'O', 'Owner29', 'owner29@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:31', 1, 1, 'C'),
(716, 'A-3-6', 'A', '3', '6', 1, 'O', 'Owner30', 'owner30@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:32', 1, 1, 'C'),
(717, 'A-3-7', 'A', '3', '7', 1, 'O', 'Owner31', 'owner31@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:32', 1, 1, 'C'),
(718, 'A-3-8', 'A', '3', '8', 1, 'O', 'Owner32', 'owner32@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:33', 1, 1, 'C'),
(719, 'A-3-9', 'A', '3', '9', 1, 'O', 'Owner33', 'owner33@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:33', 1, 1, 'C'),
(720, 'A-3-10', 'A', '3', '10', 1, 'O', 'Owner34', 'owner34@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:34', 1, 1, 'C'),
(721, 'A-3-11', 'A', '3', '11', 1, 'O', 'Owner35', 'owner35@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:51', 1, 1, 'C'),
(722, 'A-3-12', 'A', '3', '12', 1, 'O', 'Owner36', 'owner36@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:51', 1, 1, 'C'),
(723, 'A-4-1', 'A', '4', '1', 1, 'O', 'Owner37', 'owner37@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:52', 1, 1, 'C'),
(724, 'A-4-2', 'A', '4', '2', 1, 'O', 'Owner38', 'owner38@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:52', 1, 1, 'C'),
(725, 'A-4-3', 'A', '4', '3', 1, 'O', 'Owner39', 'owner39@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:53', 1, 1, 'C'),
(726, 'A-4-4', 'A', '4', '4', 1, 'O', 'Owner40', 'owner40@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:54', 1, 1, 'C'),
(727, 'A-4-5', 'A', '4', '5', 1, 'O', 'Owner41', 'owner41@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:54', 1, 1, 'C'),
(728, 'A-4-6', 'A', '4', '6', 1, 'O', 'Owner42', 'owner42@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:55', 1, 1, 'C'),
(729, 'A-4-7', 'A', '4', '7', 1, 'O', 'Owner43', 'owner43@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:55', 1, 1, 'C'),
(730, 'A-4-8', 'A', '4', '8', 1, 'O', 'Owner44', 'owner44@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:56', 1, 1, 'C'),
(731, 'A-4-9', 'A', '4', '9', 1, 'O', 'Owner45', 'owner45@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:57', 1, 1, 'C'),
(732, 'A-4-10', 'A', '4', '10', 1, 'O', 'Owner46', 'owner46@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:57', 1, 1, 'C'),
(733, 'A-4-11', 'A', '4', '11', 1, 'O', 'Aidiel Effendy', 'aidiel.effendy@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:58', 1, 1, 'C'),
(734, 'A-4-11', 'A', '4', '11', 1, 'T', 'Razlie Rosman', 'aidiel.naqisma@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:49:39', 1, 1, 'C'),
(735, 'A-4-12', 'A', '4', '12', 1, 'O', 'Owner48', 'owner47@gmail.com', '2015-05-11 20:46:57', '2015-05-11 20:47:58', 1, 1, 'C'),
(736, 'B-1-1', 'B', '1', '1', 1, 'O', 'Owner49', 'owner1@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:47:59', 1, 1, 'C'),
(737, 'B-1-2', 'B', '1', '2', 1, 'O', 'Owner50', 'owner2@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:00', 1, 1, 'C'),
(738, 'B-1-3', 'B', '1', '3', 1, 'O', 'Owner51', 'owner3@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:16', 1, 1, 'C'),
(739, 'B-1-4', 'B', '1', '4', 1, 'O', 'Owner52', 'owner4@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:17', 1, 1, 'C'),
(740, 'B-1-5', 'B', '1', '5', 1, 'O', 'Owner53', 'owner5@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:18', 1, 1, 'C'),
(741, 'B-1-6', 'B', '1', '6', 1, 'O', 'Owner54', 'owner6@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:19', 1, 1, 'C'),
(742, 'B-1-7', 'B', '1', '7', 1, 'O', 'Owner55', 'owner7@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:20', 1, 1, 'C'),
(743, 'B-1-8', 'B', '1', '8', 1, 'O', 'Owner56', 'owner8@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:20', 1, 1, 'C'),
(744, 'B-1-9', 'B', '1', '9', 1, 'O', 'Owner57', 'owner9@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:21', 1, 1, 'C'),
(745, 'B-1-10', 'B', '1', '10', 1, 'O', 'Owner58', 'owner10@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:21', 1, 1, 'C'),
(746, 'B-1-11', 'B', '1', '11', 1, 'O', 'Owner59', 'owner11@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:22', 1, 1, 'C'),
(747, 'B-1-12', 'B', '1', '12', 1, 'O', 'Owner60', 'owner12@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:23', 1, 1, 'C'),
(748, 'B-2-1', 'B', '2', '1', 1, 'O', 'Owner61', 'owner13@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:24', 1, 1, 'C'),
(749, 'B-2-2', 'B', '2', '2', 1, 'O', 'Owner62', 'owner14@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:24', 1, 1, 'C'),
(750, 'B-2-2', 'B', '2', '2', 1, 'T', 'Aidiel Hotmail', 'aidiel.effendy@hotmail.com', '2015-05-11 20:46:57', '2015-05-11 20:49:43', 1, 1, 'C'),
(751, 'B-2-3', 'B', '2', '3', 1, 'O', 'Owner63', 'owner15@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:25', 1, 1, 'C'),
(752, 'B-2-4', 'B', '2', '4', 1, 'O', 'Owner64', 'owner16@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:26', 1, 1, 'C'),
(753, 'B-2-5', 'B', '2', '5', 1, 'O', 'Owner65', 'owner17@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:26', 1, 1, 'C'),
(754, 'B-2-6', 'B', '2', '6', 1, 'O', 'Owner66', 'owner18@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:46', 1, 1, 'C'),
(755, 'B-2-7', 'B', '2', '7', 1, 'O', 'Owner67', 'owner19@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:47', 1, 1, 'C'),
(756, 'B-2-8', 'B', '2', '8', 1, 'O', 'Owner68', 'owner20@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:48', 1, 1, 'C'),
(757, 'B-2-9', 'B', '2', '9', 1, 'O', 'Owner69', 'owner21@yahoo.com', '2015-05-11 20:46:57', '2015-05-11 20:48:49', 1, 1, 'C'),
(758, 'B-2-10', 'B', '2', '10', 1, 'O', 'Owner70', 'owner22@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:48:49', 1, 1, 'C'),
(759, 'B-2-11', 'B', '2', '11', 1, 'O', 'Owner71', 'owner23@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:48:50', 1, 1, 'C'),
(760, 'B-2-12', 'B', '2', '12', 1, 'O', 'Owner72', 'owner24@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:48:50', 1, 1, 'C'),
(761, 'B-3-1', 'B', '3', '1', 1, 'O', 'Owner73', 'owner25@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:48:51', 1, 1, 'C'),
(762, 'B-3-2', 'B', '3', '2', 1, 'O', 'Owner74', 'owner26@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:48:52', 1, 1, 'C'),
(763, 'B-3-3', 'B', '3', '3', 1, 'O', 'Owner75', 'owner27@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:48:52', 1, 1, 'C'),
(764, 'B-3-4', 'B', '3', '4', 1, 'O', 'Owner76', 'owner28@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:48:53', 1, 1, 'C'),
(765, 'B-3-5', 'B', '3', '5', 1, 'O', 'Owner77', 'owner29@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:48:53', 1, 1, 'C'),
(766, 'B-3-6', 'B', '3', '6', 1, 'O', 'Owner78', 'owner30@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:48:54', 1, 1, 'C'),
(767, 'B-3-7', 'B', '3', '7', 1, 'O', 'Owner79', 'owner31@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:48:54', 1, 1, 'C'),
(768, 'B-3-8', 'B', '3', '8', 1, 'O', 'Owner80', 'owner32@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:48:55', 1, 1, 'C'),
(769, 'B-3-9', 'B', '3', '9', 1, 'O', 'Owner81', 'owner33@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:48:56', 1, 1, 'C'),
(770, 'B-3-10', 'B', '3', '10', 1, 'O', 'Owner82', 'owner34@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:49:14', 1, 1, 'C'),
(771, 'B-3-11', 'B', '3', '11', 1, 'O', 'Owner83', 'owner35@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:49:16', 1, 1, 'C'),
(772, 'B-3-12', 'B', '3', '12', 1, 'O', 'Owner84', 'owner36@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:49:17', 1, 1, 'C'),
(773, 'B-4-1', 'B', '4', '1', 1, 'O', 'Owner85', 'owner37@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:49:17', 1, 1, 'C'),
(774, 'B-4-2', 'B', '4', '2', 1, 'O', 'Owner86', 'owner38@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:49:18', 1, 1, 'C'),
(775, 'B-4-3', 'B', '4', '3', 1, 'O', 'Owner87', 'owner39@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:49:19', 1, 1, 'C'),
(776, 'B-4-4', 'B', '4', '4', 1, 'O', 'Owner88', 'owner40@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:49:19', 1, 1, 'C'),
(777, 'B-4-5', 'B', '4', '5', 1, 'O', 'Owner89', 'owner41@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:49:20', 1, 1, 'C'),
(778, 'B-4-6', 'B', '4', '6', 1, 'O', 'Owner90', 'owner42@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:49:20', 1, 1, 'C'),
(779, 'B-4-7', 'B', '4', '7', 1, 'O', 'Owner91', 'owner43@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:49:21', 1, 1, 'C'),
(780, 'B-4-8', 'B', '4', '8', 1, 'O', 'Owner92', 'owner44@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:49:22', 1, 1, 'C'),
(781, 'B-4-9', 'B', '4', '9', 1, 'O', 'Owner93', 'owner45@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:49:22', 1, 1, 'C'),
(782, 'B-4-10', 'B', '4', '10', 1, 'O', 'Owner94', 'owner46@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:49:23', 1, 1, 'C'),
(783, 'B-4-11', 'B', '4', '11', 1, 'O', 'Aidiel Effendy', 'aidiel.effendy@gmail.com', '2015-05-11 20:46:58', '2015-05-11 20:49:23', 1, 1, 'C'),
(784, 'B-4-12', 'B', '4', '12', 1, 'O', 'Owner96', 'owner47@yahoo.com', '2015-05-11 20:46:58', '2015-05-11 20:49:24', 1, 1, 'C');

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

--
-- Table structure for table `role`
--

CREATE TABLE IF NOT EXISTS `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
  `condo_id` int(11) NOT NULL,
  `updatable` varchar(1) NOT NULL DEFAULT 'Y',
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `role`
--

INSERT INTO `role` (`id`, `name`, `condo_id`, `updatable`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(1, 'Administrator', 1, 'N', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(2, 'Management', 1, 'N', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(3, 'Owner', 1, 'N', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(4, 'Tenant', 1, 'N', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(5, 'Administrator', 2, 'N', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(6, 'Management', 2, 'N', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(7, 'Owner', 2, 'N', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(8, 'Tenant', 2, 'N', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(9, 'Default Management', 1, 'N', '2015-05-19 00:00:00', '2015-05-19 00:00:00', 1, 1),
(10, 'Default Management', 2, 'N', '2015-05-19 00:00:00', '2015-05-19 00:00:00', 1, 1);

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

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

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `auth_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password_reset_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'P',
  `activation_key` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at_del` int(11) DEFAULT NULL,
  `updated_at_del` int(11) DEFAULT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=415 ;

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

INSERT INTO `user` (`id`, `username`, `auth_key`, `password_hash`, `password_reset_token`, `email`, `status`, `activation_key`, `created_at_del`, `updated_at_del`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(1, 'Management', 'zO_PRD7vSad3I2wBCH8laaasSOo_1cbk', '$2y$13$lm7vgH.Xz05CJRipGONX3.787XHLibGy63a8rBkqVXiAh0Wn4VJh6', NULL, 'residenzmanagement@gmail.com', 'A', NULL, 1424435476, 1428819726, '2015-05-12 10:00:00', '2015-05-11 19:05:15', 1, 1),
(319, 'Owner1', 'nG21vvlecJpIA8LuAJcHWUiua3KKZAS5', '$2y$13$UotgicZNurH94uGDq6DVZOVp36EjwBih2n7KBeWl3OsRXNrcyVToW', NULL, 'owner1@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:46:58', '2015-05-11 20:46:58', 1, 1),
(320, 'Haslinda', 'PJBAKyIX4QkUXkcZlhtfjsaWL8sJOhyO', '$2y$13$7fTfm9XUt4Ls1XBcpEwJKeO5EDCb7j0GMt6QCE2/CE2yW0whLdT3G', NULL, 'elinda35@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:46:59', '2015-05-11 20:46:59', 1, 1),
(321, 'Owner3', 'CChP7C1-LoldHg1NDzn2cdrNeI3m2_f0', '$2y$13$FIsstBgqzgbVcY6DNNbx3eTTAR2Uv66Wm/pwWjMW4m/9SvP3c9E3G', NULL, 'owner3@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:00', '2015-05-11 20:47:00', 1, 1),
(322, 'Owner4', 'G-UICP3p-E18xRbGYd8rngLGsabXoWgI', '$2y$13$88u0V4jNuMi9Y5VZGBmSSOJcUY51HvrjOL7orDMl44uIiaaCCx7bW', NULL, 'owner4@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:00', '2015-05-11 20:47:00', 1, 1),
(323, 'Owner5', 'WVUvW7GBfTwpm-y8BUd4rMKRBaEhGxRA', '$2y$13$24KD1A/3OfVAwol1C7cIx.kxakb8/x544Ze.JLpZ/ANXy/Jp3p5MO', NULL, 'owner5@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:01', '2015-05-11 20:47:01', 1, 1),
(324, 'Owner6', 'Emda-3XznIfzHvYyg3W02H_FkTb56ycG', '$2y$13$ptLWENznDShs6Gyl.bRx.u1uXL583oDV4tb5H0mc9.SNcRLwdds3q', NULL, 'owner6@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:01', '2015-05-11 20:47:01', 1, 1),
(325, 'Owner7', 'P6TSv6EcHdrn2FQWqNrn4U_xFbB9Nbli', '$2y$13$6oBa9w.2OggVpUVOVSMRTOnlviGwM6jpcwPHYPO5PNjDMXVPlnE5.', NULL, 'owner7@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:02', '2015-05-11 20:47:02', 1, 1),
(326, 'Owner8', 'iDo8vzPTGjwDXfzvPEy_wUbqHiMYcWN4', '$2y$13$C58Mrc8JRKjbibKv/RQJQ./I3mjAGQvMDCRaI8HO8VfHuiuDSxVPK', NULL, 'owner8@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:02', '2015-05-11 20:47:02', 1, 1),
(327, 'Owner9', '-m0U2obKqpYYaYO4RnEdipNXr3Qlfz-C', '$2y$13$wMvOQQMd6plD0Sd/3vMDF..LcWb6Hrx1tc6iPolhsWKhRng.yRcGO', NULL, 'owner9@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:03', '2015-05-11 20:47:03', 1, 1),
(328, 'Razlie Rosman', 'lF9WHNQkLI2XgJHpCYLQfhaeqGyfztxK', '$2y$13$CF/7.RJduL4vOh.oTr9Cwe5Zi.FwtN8a1jLR7rB3038V9P.NdUgYy', NULL, 'aidiel.naqisma@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:04', '2015-05-11 20:47:04', 1, 1),
(329, 'Owner11', 'W2AAE7ZiI_y1yhfjuV7FCNni2elf1Gp8', '$2y$13$NAtjb7eJvWNvlyKrekS/keuLPeNdYSnVg1lSInbNtFlYZR92PVjXC', NULL, 'owner11@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:04', '2015-05-11 20:47:04', 1, 1),
(330, 'Owner12', 'KyyAj9CGQK4lrZI8d_RR-vsu6ePX8Y9d', '$2y$13$WcyQxkrktXQmxpcVIM8hGuao/yv8XYcYwlnMuRhqRpRbPFbmZ89sG', NULL, 'owner12@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:05', '2015-05-11 20:47:05', 1, 1),
(331, 'Owner14', 'TcaMhzey3outfCP-geroPyxPSdTqIxpp', '$2y$13$0tFwZ3bG857ldpyK3aOneeYIvlV0f792dDI5f8QPg.En3lD1xX4LW', NULL, 'owner14@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:06', '2015-05-11 20:47:06', 1, 1),
(332, 'Owner15', 'q5RF-uBYYjwi0Zqlmjv8CMLg7AhyKd9x', '$2y$13$h5G9gpw2wDg1eQI4eYlgIebcX.QZThMdFrFwWM3CEM2NKMvZytVTm', NULL, 'owner15@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:06', '2015-05-11 20:47:06', 1, 1),
(333, 'Owner16', 'RVDebrl1tCMfodrWnDBMfCg6c3AHdh-X', '$2y$13$96iytjxtBFV9es3Gc7vEIOq9a4SQAVYzOwW2IK3DIcv03tk76S9c6', NULL, 'owner16@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:07', '2015-05-11 20:47:07', 1, 1),
(334, 'Owner17', 'g_ZGaS6YNbYiP55jqhThzzZSJTbkny32', '$2y$13$gFsJRv7qeQ1QYzb5uJoxN.8yEhEyma.yZX6Z3MsqMdBfgD3VSx7ku', NULL, 'owner17@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:23', '2015-05-11 20:47:23', 1, 1),
(335, 'Owner18', 'fx8ocSiHRrmVYUUgLMSt7eE-PAOmQc3i', '$2y$13$DGC93MuLuiAgSVo8Tvg17.Cqielq4CU6cxM/nvx3Fdg9b.dMPoDlm', NULL, 'owner18@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:25', '2015-05-11 20:47:25', 1, 1),
(336, 'Owner19', '8rN8f_J2qKQZU40EeeBWahj5uSCTM_d9', '$2y$13$NHa5O.CN/6ZRZ8irzPu8d.9bpgHlPCsnm..tPV7Ifp8KaCrja6GUi', NULL, 'owner19@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:25', '2015-05-11 20:47:25', 1, 1),
(337, 'Owner20', '39W0FAQHHugN-Nkw4wGokiKQAcJyeDPE', '$2y$13$2SVEEAfuRJWGDxKFIzNPZOnS6Enf54LFOmiSEHCMMIeFRKoF3yPWS', NULL, 'owner20@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:26', '2015-05-11 20:47:26', 1, 1),
(338, 'Owner21', 'F-yNHb-rkTsXo-B3vTZb9juapcvG3D16', '$2y$13$Ql9iw1rinvuEM2ZVbyRcJuhipAtmSWzOwRkgiG4n0ZWy.ZZ/IlYYy', NULL, 'owner21@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:26', '2015-05-11 20:47:26', 1, 1),
(339, 'Owner22', 'UKiGS_YFE81A-UP1AuwRS8DVaEqlDXOA', '$2y$13$1jRQmLzsNdIHuWcB3nRXyuQXwXKhoctD6cZWfofqWDrsZgEh.C9g.', NULL, 'owner22@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:27', '2015-05-11 20:47:27', 1, 1),
(340, 'Owner23', 'W03QyW8Qhm5UtL4RLBs4K2bZDTiOTwTL', '$2y$13$I9SXyaIEKXdedyfU90V86.294mlYaH3fXsE9hgRoq9pVSjGCQ4hUe', NULL, 'owner23@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:28', '2015-05-11 20:47:28', 1, 1),
(341, 'Owner24', '9Dfd1Tu6PEznKQo4TIo38AQrFAxJJNAp', '$2y$13$.NATQNcwjHLSCXKg.I/v6unb7dnJo2MldFso.CsU3g1Na5RuBWsqm', NULL, 'owner24@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:28', '2015-05-11 20:47:28', 1, 1),
(342, 'Owner25', 'Ah_-BbILMKrNKj6oQ8fgC8JKso6Bp8da', '$2y$13$AAtwbZlAHhHbINNTYJECfuNuaW.TqP4I9JhiRO8wWEmkME7XmUvjS', NULL, 'owner25@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:29', '2015-05-11 20:47:29', 1, 1),
(343, 'Owner26', 'unXP6JNe0Fqv6htY2Rv25coCvo3-bmcN', '$2y$13$ybOAG8AaXkk2DnGXYnv4Sea3Vw0EpGn1R05Obh2wYLQuBefaJlRSW', NULL, 'owner26@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:29', '2015-05-11 20:47:29', 1, 1),
(344, 'Owner27', 'vcdhgNvVRC3TZuFM8serpTfqiCplAKX-', '$2y$13$isUCaQuKFeQTYNZ38ZMv4eIY0coZzLTsylbkVzZA7Of72OY/H1xHW', NULL, 'owner27@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:30', '2015-05-11 20:47:30', 1, 1),
(345, 'Owner28', '6Ztv1jU82tY66YSzslo1V51WBCcr-FT7', '$2y$13$L36xiMzlwfIQP3x2ge/Ucu4szOMYAnn1e.QlAOO8Cf383MxVLRp6K', NULL, 'owner28@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:30', '2015-05-11 20:47:30', 1, 1),
(346, 'Owner29', 'TkpupqyrAL3HdoioSgXNomS4zL1-CtjQ', '$2y$13$i1fGGBHwNhq23Mzg5PC4/e2iOiPAuETrCStyqExaWrWUyfTWUqirW', NULL, 'owner29@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:31', '2015-05-11 20:47:31', 1, 1),
(347, 'Owner30', 'P-frbxr93kLBWrKarkSsL90xtmHlB3h_', '$2y$13$J7FtTNswL.0ByvZ3ZKVQBOgKJm0POM6UiQld4TF0bUxA1VtxUrJfG', NULL, 'owner30@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:32', '2015-05-11 20:47:32', 1, 1),
(348, 'Owner31', 'd0ubPSovN8KIsxjP5MkHmdiZXd_cbWRR', '$2y$13$nMjScajEwqIXd35j.8.Xi.uoZXs60FbZfbkHWkVeOcUu0kun65FwO', NULL, 'owner31@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:32', '2015-05-11 20:47:32', 1, 1),
(349, 'Owner32', 'SWakL1OmHqcPVBf1u5HY-fSCj2nJmlky', '$2y$13$/.hBERB7xCcbV8ZXdTkTJeq1MafxexejjUqjOP.2KfNau4titFG16', NULL, 'owner32@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:33', '2015-05-11 20:47:33', 1, 1),
(350, 'Owner33', 'WQp0asWt_5IUfaL1paXxjpaRwZrwB9Vo', '$2y$13$q.pWY/aZJVtMfgvuFwyInen7FnheSdt3MN.iIiSnBtarXK08phahO', NULL, 'owner33@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:33', '2015-05-11 20:47:33', 1, 1),
(351, 'Owner34', 'f8JnwPP8i9ra4xRVb5sCXPPAXuRI_hf1', '$2y$13$Mfkkg02pwxiGKo90e8dnI.Be3poeULhXlnUZgh0Cs1buMyHil96sa', NULL, 'owner34@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:34', '2015-05-11 20:47:34', 1, 1),
(352, 'Owner35', '3Fcuu4GqWEMGOpjlG_1MkwMNo-R65uaX', '$2y$13$.Zvu2dly1TuZR4FMIltFtORlIUulIYrUkf3dKVqmDZ4nnT/.5xYiG', NULL, 'owner35@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:35', '2015-05-11 20:47:35', 1, 1),
(353, 'Owner36', '-RAbxtbD0nj-RjbQhZXWa8I6d2TrB1rd', '$2y$13$X27H6YWA84IOhyEW22scjejTfgwvjp2mC/w8dgsLy9zL6qcHleLu2', NULL, 'owner36@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:51', '2015-05-11 20:47:51', 1, 1),
(354, 'Owner37', 'WpWdzNmtIzR3o1sswOGOlCdYNZur6Jbf', '$2y$13$1YHsGIzRUEP06hrJpT8h..Duy4dL8uZAJ1l8gPlK5Xft4AbGBfDzC', NULL, 'owner37@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:52', '2015-05-11 20:47:52', 1, 1),
(355, 'Owner38', 'gK-dULHQq-HU6u2jEjUNSrSVI2gMpseE', '$2y$13$xgE43DnIQcUMTBK3T8RgNOiBzUzkHIED1A1C2Yco7deotDm9i5SRC', NULL, 'owner38@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:52', '2015-05-11 20:47:52', 1, 1),
(356, 'Owner39', 'UXpbgV3iaO_EMBOvWZ3zlALkunNbL_2G', '$2y$13$CVO2.zwpA4Llf5gueAy2FuXGARM6JG3GaCIbbYatpoZFfxFh.A/Vi', NULL, 'owner39@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:53', '2015-05-11 20:47:53', 1, 1),
(357, 'Owner40', 'u4C6IYX7mOfep8iU66R3z7lmecxYS3qh', '$2y$13$Ne4nouDY25qmm3jv0p.a7efQBtCJfGgNKB3OkKKH0wwDlpS4nXDn6', NULL, 'owner40@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:54', '2015-05-11 20:47:54', 1, 1),
(358, 'Owner41', 'OCcXYoyGKQIzgxfqbbMxFqAXns5JwDbd', '$2y$13$XjI0ygElpkpMAMNrTDiP2uw0W0BRJ3x65em2SlzUEM0RmpNfexbu.', NULL, 'owner41@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:54', '2015-05-11 20:47:54', 1, 1),
(359, 'Owner42', 'mG5Bewvjc113gGnvtvu9tH5syUbUORIx', '$2y$13$2gATxzbJ4DUUTg9dOCk/MeU71R6ZQsHHFCVLNlOYp4XZcV3fd9oyq', NULL, 'owner42@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:55', '2015-05-11 20:47:55', 1, 1),
(360, 'Owner43', 'N9PDg54kNq5qyD6oMlLePR5AOv4KH_Pa', '$2y$13$v40/lCt/es/dyVnItvG9D.KyATXtN7/hBkk2k1VpWVae.D4mQLdPq', NULL, 'owner43@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:55', '2015-05-11 20:47:55', 1, 1),
(361, 'Owner44', 'UwARo-6XVtouqYEu6GJg8_DF3f_eY-7X', '$2y$13$0t3DqMJsLjvAWjJ5zGEBHe2idsq29lr9j7L/FaAQNwcGSlWhjGYze', NULL, 'owner44@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:56', '2015-05-11 20:47:56', 1, 1),
(362, 'Owner45', '1JMmnMSOOIX-lFLWf9by4iQivhlk0hh9', '$2y$13$XZvu0DQHdAZ9VhdM/la8heEFQOkkDPO4shRI6TLFzK6j8kSYDL0ke', NULL, 'owner45@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:57', '2015-05-11 20:47:57', 1, 1),
(363, 'Owner46', '5_wtVUwsWVCP_JLGkKCkDBK520N6126Y', '$2y$13$Qc4vKZckUAI3v1iuSw15UeAsndqRUnNSFxR.AcR3vwe0Ufa.t2uZK', NULL, 'owner46@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:57', '2015-05-11 20:47:57', 1, 1),
(364, 'Aidiel Effendy', '0TcGsT-N7TC6ig-wTx7qAKKrFRo_WgI_', '$2y$13$lm7vgH.Xz05CJRipGONX3.787XHLibGy63a8rBkqVXiAh0Wn4VJh6', NULL, 'aidiel.effendy@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:58', '2015-05-11 20:47:58', 1, 1),
(365, 'Owner48', 'pQ-2zq2Yyse7g6PoCXYtzOfIoPd3rEFV', '$2y$13$7qLqcg0rl0CMeV31LcImMO0MSPLev1eU1k5CCXk5kecVQhvcXC/P.', NULL, 'owner47@gmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:58', '2015-05-11 20:47:58', 1, 1),
(366, 'Owner49', 'xq9AWUp_VmWgnmWRaP6eoMf4tfbqhSNq', '$2y$13$M3IWh743vO9p5HRZDzkvlOy7xFSezz09bMfWi/roE6oqP9O5HBF4y', NULL, 'owner1@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:59', '2015-05-11 20:47:59', 1, 1),
(367, 'Owner50', '70Jt2zCLMTHU6fNYciQ4O5ysbift-icD', '$2y$13$Exeefxsccttkyvx7kKI7WenXqqVpOQW0mWDkR1kNGLHVUOwdcapai', NULL, 'owner2@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:47:59', '2015-05-11 20:47:59', 1, 1),
(368, 'Owner51', 'bUjK1p-tiJIA45RDWGJFuXDs-U5Y6sUZ', '$2y$13$W5A73Tn97RO6rgVNB.ZqEOTP/B1movmySXaLyUoe3zJt5JMQ3b7Vm', NULL, 'owner3@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:01', '2015-05-11 20:48:01', 1, 1),
(369, 'Owner52', 'QwirDPjlNorIPvNUzQi7Q9VZ1VXXaBsG', '$2y$13$o8dsl.dJxngX/11wsc16IuMe85B0Cm1EjqHx/Acs4KxkgYK84x096', NULL, 'owner4@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:17', '2015-05-11 20:48:17', 1, 1),
(370, 'Owner53', 'dFR44DDn1GbPuz4EZYmfds9A1AqbhUC8', '$2y$13$NgaSrsa4s8Q8aA/QiywKYuC7.AGRtdEeE2SsEoD2xt6DLfTQo5e1S', NULL, 'owner5@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:18', '2015-05-11 20:48:18', 1, 1),
(371, 'Owner54', 'ObIVtLmzuRK0T5Tj0lYyW9-2PhPGM22b', '$2y$13$butjUt52rQ2zrYZ9SI20R.r9eutrSQqP3wYVatVf8AvfewFW9Y7D2', NULL, 'owner6@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:19', '2015-05-11 20:48:19', 1, 1),
(372, 'Owner55', 'KYsxVx-jkv1tabYhFz325AOGoxN4Zp-J', '$2y$13$4hsjgzLPO32l3Ua5LlqixOLxSKqh67ltd8IJBFuPJRHcdopE13FW6', NULL, 'owner7@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:20', '2015-05-11 20:48:20', 1, 1),
(373, 'Owner56', 'WdEOiyZgld5rI4pf2wTTVwA765dd4wdj', '$2y$13$fhBCtSDvzRUfjz3d/mE9LOT32PWkHEm/sRIQRUQ4/1Z3PCTCEXTc.', NULL, 'owner8@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:20', '2015-05-11 20:48:20', 1, 1),
(374, 'Owner57', 'Y0sIfbBbcv60rpNKtvkZAh6UgD5tzcpn', '$2y$13$e/CM1sULVs1Zv7JBOcW7cOAq7yCslyf4JDcFmEXgWTroubHRiQu1u', NULL, 'owner9@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:21', '2015-05-11 20:48:21', 1, 1),
(375, 'Owner58', 'W2psIUr544CYGdiG9QZzvSxFEkbB9NCj', '$2y$13$fy3bcKR9dYkKHVWDIM6ia.1/dcnwfDYBEr.5p3ShY8aaaJuAknjS.', NULL, 'owner10@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:21', '2015-05-11 20:48:21', 1, 1),
(376, 'Owner59', 'djV_keSgawaAceRGfRRLaoiSH3ilSUBt', '$2y$13$c89ZDWYL0S.MC4ecL3WBOePfDvUU68JAiV4uL1YE9jGeJrdfB.Ji.', NULL, 'owner11@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:22', '2015-05-11 20:48:22', 1, 1),
(377, 'Owner60', '0CDu6KdfB98w94stTggD1OYmVwI255-X', '$2y$13$wb.S55D/73qZe/k4NwWgX.C/PDAdmga3izlbm9B0T7yexA3909EEC', NULL, 'owner12@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:22', '2015-05-11 20:48:22', 1, 1),
(378, 'Owner61', '5xLrBfOjTgwMWLZBHmGN2P8CFveH8pyx', '$2y$13$bFg5Zg6CEPXw4oAdmsRHW.Z28qGxoi3/qxYn1HcOMNii8bxurczdC', NULL, 'owner13@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:24', '2015-05-11 20:48:24', 1, 1),
(379, 'Owner62', 'aAeyXKa0IXMdWE7horWo-zZSMXBWO-uO', '$2y$13$161K1/yjqVj9EUXKjiMMZOewOG2sjmmyA2D7Ae1OXyQUsz4bkE6o.', NULL, 'owner14@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:24', '2015-05-11 20:48:24', 1, 1),
(380, 'Owner63', '64AlXqYW4sPtdMph-9rCgAZb00q2NGdW', '$2y$13$NsbW38byTuouOAMJLpIdieU.leD7rqoqMbXXAg5sqpq1Ak9saTRVS', NULL, 'owner15@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:25', '2015-05-11 20:48:25', 1, 1),
(381, 'Owner64', 'CvRVQ8CbZXguNse9v2KMlxDamvleMIOF', '$2y$13$ak7MGytdKNlvV/egV5uYauYcsDSpGx6rCv3QfKssQgUrOhQ7MXbxy', NULL, 'owner16@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:26', '2015-05-11 20:48:26', 1, 1),
(382, 'Owner65', 'cTKQBlKBCg42f1VLvPywCyL25vxsLWkw', '$2y$13$miAZH6H8eUiDyj3iyy97OuAI/3Vg33JHgSaLsP2eCG3LUeMJC6fIO', NULL, 'owner17@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:26', '2015-05-11 20:48:26', 1, 1),
(383, 'Owner66', 'eUPz_cacC3US6KWaAPrv-n9rB-3sBFfT', '$2y$13$EuPb2hdpi7AjTNDvft8VSOFbB37PU1Wyb2myVJN2xBO40A6TnjIvK', NULL, 'owner18@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:27', '2015-05-11 20:48:27', 1, 1),
(384, 'Owner67', 'G4Iqf8bU6nwECzTG074Dtctrp2LgLVVV', '$2y$13$T.SIf1JN2FqEh7D3yBCPq.q6jUlLDnw.bHOR4uCzA7cJXRqudf/Ca', NULL, 'owner19@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:47', '2015-05-11 20:48:47', 1, 1),
(385, 'Owner68', 'Sfyxgf8PQhX1S_bPI-IuIQN5EkYoZVwz', '$2y$13$dhdW3v06q04/FDx60J0q5ufMQ7RkSNQTQ.OaeHRzVnanLGJfaV34K', NULL, 'owner20@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:48', '2015-05-11 20:48:48', 1, 1),
(386, 'Owner69', 'sll0Ub2yNQuSpYgHbvmPL8t3YKn5K4Vp', '$2y$13$.kgcFe8bkqTMQYX677435OUUzW66nb4ogREymEPRF3qN.HWhWml46', NULL, 'owner21@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:49', '2015-05-11 20:48:49', 1, 1),
(387, 'Owner70', 'l6Rlua8U7BDG5g8OH7qUZcB2BW1Kp0lo', '$2y$13$/3FJpx57UPkwptgWddSkU.KG/4ycenx2t1q61VzjRYQQl/4rBQA.m', NULL, 'owner22@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:49', '2015-05-11 20:48:49', 1, 1),
(388, 'Owner71', 'OfJQSoKS5ZjWuI6IKU1K43fDGgeWIAnQ', '$2y$13$FF//743DFBhOvtYOp.n5/OxrxJmodDZpaqDJIlPNUdaolmi2sls42', NULL, 'owner23@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:50', '2015-05-11 20:48:50', 1, 1),
(389, 'Owner72', 'LMcEmBeFChB6um8eMT21DRAxGtkgQXVs', '$2y$13$.GglsQ0IcZKF4V5aYk.d0..5K7OKUnCTgYsSNIj6RwZKrg2ekCudK', NULL, 'owner24@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:50', '2015-05-11 20:48:50', 1, 1),
(390, 'Owner73', 'k6dollSvLYHbLyBQx-qCEnRJub3DwMPy', '$2y$13$QodWNNoNfeZk0Ho6MfT9weDskcW0GZXEqdjV5CsicyPV9Q3PQeHiC', NULL, 'owner25@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:51', '2015-05-11 20:48:51', 1, 1),
(391, 'Owner74', 'v_phvlXThCjKLH3PQzvc7Ng3wJ8fOA7Z', '$2y$13$z/7eRfncAL26uvQ5anKn6ubVJCYEvwS1nqWkzk/62ZOkjXFNgpCzu', NULL, 'owner26@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:52', '2015-05-11 20:48:52', 1, 1),
(392, 'Owner75', 'pqSCNEmKZJdv0RrDJKOn0UvBSPxFCQnT', '$2y$13$9jiIDtncWZMLRNQf1FXo0Ofpqsc.lV1buKCHTVc0IYzbgacfYIiBG', NULL, 'owner27@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:52', '2015-05-11 20:48:52', 1, 1),
(393, 'Owner76', 'zzt_6QwJKfGrPQPqlwo47qBAy4gZaksr', '$2y$13$4l5Iq4imkSjK/RQV48BboekPEOTteSsr6w2rbOamB/cczs3jh1FqO', NULL, 'owner28@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:53', '2015-05-11 20:48:53', 1, 1),
(394, 'Owner77', '7rEqxmaRo_0ywryXegi1eGpY3GBsn_Zc', '$2y$13$qQFUds/GGoOgv88B38X.SO2esdJpqw3.XhqCMg.upntBxONlXAbh6', NULL, 'owner29@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:53', '2015-05-11 20:48:53', 1, 1),
(395, 'Owner78', '9bRF8ODVkZ4vV7h0geTWWJ_eslsvrv0E', '$2y$13$iPKi5Z3WxJ.rB9Ypa4ZSV.Kh7VtLuoRcohC1tKMyA0tRRJAKNtEI6', NULL, 'owner30@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:54', '2015-05-11 20:48:54', 1, 1),
(396, 'Owner79', 'ft-uucWGNZQijKcRadiXz4q4abg-yI-r', '$2y$13$td5qtZ5sQsNFLRN6Mm1.t.c6cNet7IKq.QQiUf1.bAaXhDeZFF82m', NULL, 'owner31@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:54', '2015-05-11 20:48:54', 1, 1),
(397, 'Owner80', '7tADB8RzOJKbyamv_QBv4yb-HieXsGjb', '$2y$13$7wt3D4NbX9szrv.7SyVyfeInuCf0pWxODF5GVkhBswfnLIldOqOqe', NULL, 'owner32@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:55', '2015-05-11 20:48:55', 1, 1),
(398, 'Owner81', '5YBdj0q2ISkn5WiXv_bJ5eBSnSXYssW1', '$2y$13$Y5N/NXw7tVSMHI88trH99OPmglIjxn9oc0g0oDyOpLBzt3ZprdwY.', NULL, 'owner33@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:56', '2015-05-11 20:48:56', 1, 1),
(399, 'Owner82', 't7OU8K9FvzzcQ6nfsenSGVpLDqHFZarU', '$2y$13$LuXxx4xu8ZKSTPAngGvIG.vZM/Lhkc/Dn6k.tCj0uA9FtAPB18STq', NULL, 'owner34@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:48:56', '2015-05-11 20:48:56', 1, 1),
(400, 'Owner83', '-5pEgoPzsitKi7PQNxuNpg4OlCCveOMh', '$2y$13$rYSam9CFqRzdOjy8FcjfTOp3GSMKazNIRpOfidoq.6JT1uMUxY5mS', NULL, 'owner35@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:49:16', '2015-05-11 20:49:16', 1, 1),
(401, 'Owner84', 'e7GVJjIiWDozm-1R2RSwRz6HBO3jIJnf', '$2y$13$NDjC2/Mz6BHyImtYT.pmyuFFNlZPapHNJ2PATfhNEhl0gLuOFyvui', NULL, 'owner36@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:49:16', '2015-05-11 20:49:16', 1, 1),
(402, 'Owner85', 'fv4h5ip4oGwdfanyhATtJWXGEpWQt7Fp', '$2y$13$nMlaT/MWDZdtVDTRMNfyeOeBgZ85G13ObN2mEmnTHI6Rbla13lcNy', NULL, 'owner37@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:49:17', '2015-05-11 20:49:17', 1, 1),
(403, 'Owner86', 'KnbGZnlO0pivirrDiD7Vp_QC4gMNt_Yk', '$2y$13$qATx0Kmj5KJfH8BY5l2pOu0FuFhVVLDWfgEBSfiaGYrEkxmBfHw2q', NULL, 'owner38@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:49:18', '2015-05-11 20:49:18', 1, 1),
(404, 'Owner87', 'zbv1khas_RRhHO5Ij8rVlYUqKYN4lTsr', '$2y$13$g.ARkO/mc6797sA.tn1/B.X/lbMcKIwgSuQABO3iyv42T1C/sPtKW', NULL, 'owner39@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:49:19', '2015-05-11 20:49:19', 1, 1),
(405, 'Owner88', 'xj_q-MpohHdD0hwx82L9uHgoYU7_8Gbq', '$2y$13$ZKOsQYqjbCUhy.OOCB20duol4zHlgv5xMWQ95ALhzh5xyFN/F.QPy', NULL, 'owner40@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:49:19', '2015-05-11 20:49:19', 1, 1),
(406, 'Owner89', '_-t2KDriKMNBV95nRPtu35gFIGLLY0rr', '$2y$13$Xk94Q.S/thvfZkTJCDjAV.R3lC2hfjBc.iR02ARsXskuCqnJYoYHe', NULL, 'owner41@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:49:20', '2015-05-11 20:49:20', 1, 1),
(407, 'Owner90', 'C7QpRuMS-PP4-kyGC8IeXyC3P7wUIefY', '$2y$13$40Y1VAwZMOTbMtDESOM0K.3994.kvwL.vZn1IrQZsRTL6fBbpeUVK', NULL, 'owner42@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:49:20', '2015-05-11 20:49:20', 1, 1),
(408, 'Owner91', 'ee949nCru9RGlxBQrRZabP61U8RTRc6E', '$2y$13$2sPHsHpQGO.nDrYpN6V0oucNlTdzRluVp0ft40LvfMf2x3sJ4a73K', NULL, 'owner43@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:49:21', '2015-05-11 20:49:21', 1, 1),
(409, 'Owner92', 'OgXr0jGF2zO4DNK3L1HVtB-0tZqUZO_y', '$2y$13$VFbEaFwcRtv.X.A6wthw4ek0Wox1N5Kj/icbW2vsU/GZz2Z0Qe19m', NULL, 'owner44@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:49:22', '2015-05-11 20:49:22', 1, 1),
(410, 'Owner93', 'ThPaJq7awdn2KCDajqZlSZnYJ151anCE', '$2y$13$jWTKfRrM8B.phosaW8n.uepRVe2rzFWUymwR/vX7toKs3wny.t2FS', NULL, 'owner45@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:49:22', '2015-05-11 20:49:22', 1, 1),
(411, 'Owner94', 'si_1lPvMGQgv1vDVVZ6fBML3l2G3jtrw', '$2y$13$Bi7Yp/6Q3rsfYMIkbMXQDe2ouFYnc44Du7cnrwS8FtIPD0yqvDM9.', NULL, 'owner46@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:49:23', '2015-05-11 20:49:23', 1, 1),
(412, 'Owner96', 'udIJTueR_sbdQI9-9CRI2jjLTnFOBDxK', '$2y$13$kIYq9JOSyA.uUjy3PCs7h.uks0fO3yl7c/666Ck3LDoD1GakppJK6', NULL, 'owner47@yahoo.com', 'A', NULL, NULL, NULL, '2015-05-11 20:49:24', '2015-05-11 20:49:24', 1, 1),
(413, 'Aidiel Hotmail', '_rR4KQcCzzCh6QLX2sLS8zJmZpjpBbwJ', '$2y$13$nNWszFQWsetEF1jG/mBeLeqmkgkw/UBTqJNpSfImg8n0ue0iXTlSK', NULL, 'aidiel.effendy@hotmail.com', 'A', NULL, NULL, NULL, '2015-05-11 20:49:42', '2015-05-11 20:49:42', 1, 1),
(414, 'Management1', 'zO_PRD7vSad3I2wBCH8laaasSOo_1cbk', '$2y$13$lm7vgH.Xz05CJRipGONX3.787XHLibGy63a8rBkqVXiAh0Wn4VJh6', NULL, 'residenzmanagement1@gmail.com', 'A', NULL, 1424435476, 1428819726, '2015-05-12 10:00:00', '2015-05-11 19:05:15', 1, 1);

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

--
-- Table structure for table `user_access_card`
--

CREATE TABLE IF NOT EXISTS `user_access_card` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `access_card` varchar(50) NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  `remark` varchar(255) DEFAULT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `user_condo_unit`
--

CREATE TABLE IF NOT EXISTS `user_condo_unit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `condo_unit_id` int(11) NOT NULL,
  `condo_id` int(11) NOT NULL,
  `residence_type` varchar(1) NOT NULL DEFAULT 'O',
  `status` varchar(1) NOT NULL DEFAULT 'A',
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=421 ;

--
-- Dumping data for table `user_condo_unit`
--

INSERT INTO `user_condo_unit` (`id`, `user_id`, `owner_id`, `condo_unit_id`, `condo_id`, `residence_type`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(323, 319, 319, 324, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(324, 320, 320, 325, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(325, 321, 321, 326, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(326, 322, 322, 327, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(327, 323, 323, 328, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(328, 324, 324, 329, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(329, 325, 325, 330, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(330, 326, 326, 331, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(331, 327, 327, 332, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(332, 328, 328, 333, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(333, 329, 329, 334, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(334, 330, 330, 335, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(335, 320, 320, 336, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(336, 331, 331, 337, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(337, 332, 332, 338, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(338, 333, 333, 339, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(339, 334, 334, 340, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(340, 335, 335, 341, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(341, 336, 336, 342, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(342, 337, 337, 343, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(343, 338, 338, 344, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(344, 339, 339, 345, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(345, 340, 340, 346, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(346, 341, 341, 347, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(347, 342, 342, 348, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(348, 343, 343, 349, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(349, 344, 344, 350, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(350, 345, 345, 351, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(351, 346, 346, 352, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(352, 347, 347, 353, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(353, 348, 348, 354, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(354, 349, 349, 355, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(355, 350, 350, 356, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(356, 351, 351, 357, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(357, 352, 352, 358, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(358, 353, 353, 359, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(359, 354, 354, 360, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(360, 355, 355, 361, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(361, 356, 356, 362, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(362, 357, 357, 363, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(363, 358, 358, 364, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(364, 359, 359, 365, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(365, 360, 360, 366, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(366, 361, 361, 367, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(367, 362, 362, 368, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(368, 363, 363, 369, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(369, 364, 364, 370, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(370, 365, 365, 371, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(371, 366, 366, 372, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(372, 367, 367, 373, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(373, 368, 368, 374, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(374, 369, 369, 375, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(375, 370, 370, 376, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(376, 371, 371, 377, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(377, 372, 372, 378, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(378, 373, 373, 379, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(379, 374, 374, 380, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(380, 375, 375, 381, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(381, 376, 376, 382, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(382, 377, 377, 383, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(383, 378, 378, 384, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(384, 379, 379, 385, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(385, 380, 380, 386, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(386, 381, 381, 387, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(387, 382, 382, 388, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(388, 383, 383, 389, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(389, 384, 384, 390, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(390, 385, 385, 391, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(391, 386, 386, 392, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(392, 387, 387, 393, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(393, 388, 388, 394, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(394, 389, 389, 395, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(395, 390, 390, 396, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(396, 391, 391, 397, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(397, 392, 392, 398, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(398, 393, 393, 399, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(399, 394, 394, 400, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(400, 395, 395, 401, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(401, 396, 396, 402, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(402, 397, 397, 403, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(403, 398, 398, 404, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(404, 399, 399, 405, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(405, 400, 400, 406, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(406, 401, 401, 407, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(407, 402, 402, 408, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(408, 403, 403, 409, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(409, 404, 404, 410, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(410, 405, 405, 411, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(411, 406, 406, 412, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(412, 407, 407, 413, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(413, 408, 408, 414, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(414, 409, 409, 415, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(415, 410, 410, 416, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(416, 411, 411, 417, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(417, 364, 364, 418, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(418, 412, 412, 419, 1, 'O', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(419, 328, 364, 370, 1, 'T', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(420, 413, 379, 385, 1, 'T', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

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

--
-- Table structure for table `user_conversation_message`
--

CREATE TABLE IF NOT EXISTS `user_conversation_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `conversation_id` int(11) NOT NULL,
  `read_status` varchar(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;

--
-- Dumping data for table `user_conversation_message`
--

INSERT INTO `user_conversation_message` (`id`, `unit_id`, `user_id`, `conversation_id`, `read_status`) VALUES
(31, NULL, 414, 22, 'U'),
(32, 418, 364, 22, 'U');

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

--
-- Table structure for table `user_driver`
--

CREATE TABLE IF NOT EXISTS `user_driver` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `photo` varchar(25) DEFAULT NULL,
  `name` varchar(25) NOT NULL,
  `nric` varchar(25) NOT NULL,
  `nationality_id` int(11) NOT NULL,
  `contact_no` varchar(25) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `user_driver`
--

INSERT INTO `user_driver` (`id`, `condo_id`, `user_id`, `photo`, `name`, `nric`, `nationality_id`, `contact_no`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(2, 1, 328, '', 'Razlie Rosman Driver 1', '111111-11-1111', 1, '0123456789', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

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

--
-- Table structure for table `user_emergency_contact`
--

CREATE TABLE IF NOT EXISTS `user_emergency_contact` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `contact_no` varchar(25) NOT NULL,
  `relationship` varchar(25) NOT NULL,
  `additional_info` text,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `user_emergency_contact`
--

INSERT INTO `user_emergency_contact` (`id`, `user_id`, `name`, `contact_no`, `relationship`, `additional_info`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(4, 328, 'Razlie Rosman Contact 1', '0123456789', 'Father', 'Emergency only', 'A', '0000-00-00 00:00:00', '2015-05-17 00:00:44', 328, 328),
(5, 328, 'Razlie Rosman Contact 1', '0123456789', 'Mother', '', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 328, 328),
(8, 364, 'Aidiel Effendy Contact 1', '0111111112', 'Sister', '', 'A', '2015-05-13 20:32:11', '2015-05-13 21:22:42', 364, 364),
(9, 364, 'Aidiel Effendy Contact 2', '0111111112', 'Mother', '', 'A', '2015-05-14 01:47:16', '2015-05-14 01:49:55', 364, 364);

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

--
-- Table structure for table `user_maid`
--

CREATE TABLE IF NOT EXISTS `user_maid` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `photo` varchar(25) DEFAULT NULL,
  `name` varchar(25) NOT NULL,
  `nric` varchar(25) NOT NULL,
  `nationality_id` int(11) NOT NULL,
  `contact_no` varchar(25) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `user_maid`
--

INSERT INTO `user_maid` (`id`, `condo_id`, `user_id`, `photo`, `name`, `nric`, `nationality_id`, `contact_no`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(2, 1, 328, '', 'Razlie Rosman Maid 1', '111111-11-1111', 1, '0123456789', '0000-00-00 00:00:00', '2015-05-18 02:58:42', 0, 328);

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

--
-- Table structure for table `user_notification`
--

CREATE TABLE IF NOT EXISTS `user_notification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `condo_unit_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `notification_name` varchar(50) NOT NULL,
  `notification` varchar(255) NOT NULL,
  `status` varchar(1) NOT NULL,
  `external_id` int(11) DEFAULT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

--
-- Dumping data for table `user_notification`
--

INSERT INTO `user_notification` (`id`, `condo_id`, `condo_unit_id`, `user_id`, `notification_name`, `notification`, `status`, `external_id`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(22, 1, 418, 364, 'message', '{name} has sent you a message', 'A', 22, '2015-05-18 20:06:21', '2015-05-18 20:06:21', 414, 414),
(24, 1, NULL, 1, 'message', '{name} has sent you a message', 'A', 22, '2015-05-18 20:12:42', '2015-05-18 20:12:42', 364, 364);

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

--
-- Table structure for table `user_profile`
--

CREATE TABLE IF NOT EXISTS `user_profile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `photo` varchar(150) DEFAULT NULL,
  `salutation` varchar(15) NOT NULL,
  `name` varchar(150) NOT NULL,
  `email` varchar(255) NOT NULL,
  `verification_id` varchar(255) DEFAULT NULL,
  `nric` varchar(25) DEFAULT NULL,
  `nationality_id` int(11) DEFAULT NULL,
  `residential_address` varchar(255) DEFAULT NULL,
  `mailing_address` varchar(255) DEFAULT NULL,
  `home_no` varchar(25) DEFAULT NULL,
  `mobile_no` varchar(25) DEFAULT NULL,
  `fax_no` varchar(25) DEFAULT NULL,
  `occupation` varchar(50) DEFAULT NULL,
  `company` varchar(50) DEFAULT NULL,
  `company_address` varchar(255) DEFAULT NULL,
  `company_no` varchar(25) DEFAULT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=409 ;

--
-- Dumping data for table `user_profile`
--

INSERT INTO `user_profile` (`id`, `user_id`, `photo`, `salutation`, `name`, `email`, `verification_id`, `nric`, `nationality_id`, `residential_address`, `mailing_address`, `home_no`, `mobile_no`, `fax_no`, `occupation`, `company`, `company_address`, `company_no`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(28, 1, NULL, 'Mr.', 'Residenz Management', 'residenzmanagement@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(313, 319, NULL, 'Mr.', 'Owner1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(314, 320, NULL, 'Mr.', 'Haslinda', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(315, 321, NULL, 'Mr.', 'Owner3', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(316, 322, NULL, 'Mr.', 'Owner4', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(317, 323, NULL, 'Mr.', 'Owner5', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(318, 324, NULL, 'Mr.', 'Owner6', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(319, 325, NULL, 'Mr.', 'Owner7', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(320, 326, NULL, 'Mr.', 'Owner8', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(321, 327, NULL, 'Mr.', 'Owner9', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(322, 328, NULL, 'Mr.', 'Razlie Rosman', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(323, 329, NULL, 'Mr.', 'Owner11', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(324, 330, NULL, 'Mr.', 'Owner12', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(325, 331, NULL, 'Mr.', 'Owner14', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(326, 332, NULL, 'Mr.', 'Owner15', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(327, 333, NULL, 'Mr.', 'Owner16', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(328, 334, NULL, 'Mr.', 'Owner17', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(329, 335, NULL, 'Mr.', 'Owner18', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(330, 336, NULL, 'Mr.', 'Owner19', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(331, 337, NULL, 'Mr.', 'Owner20', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(332, 338, NULL, 'Mr.', 'Owner21', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(333, 339, NULL, 'Mr.', 'Owner22', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(334, 340, NULL, 'Mr.', 'Owner23', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(335, 341, NULL, 'Mr.', 'Owner24', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(336, 342, NULL, 'Mr.', 'Owner25', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(337, 343, NULL, 'Mr.', 'Owner26', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(338, 344, NULL, 'Mr.', 'Owner27', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(339, 345, NULL, 'Mr.', 'Owner28', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(340, 346, NULL, 'Mr.', 'Owner29', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(341, 347, NULL, 'Mr.', 'Owner30', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(342, 348, NULL, 'Mr.', 'Owner31', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(343, 349, NULL, 'Mr.', 'Owner32', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(344, 350, NULL, 'Mr.', 'Owner33', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(345, 351, NULL, 'Mr.', 'Owner34', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(346, 352, NULL, 'Mr.', 'Owner35', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(347, 353, NULL, 'Mr.', 'Owner36', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(348, 354, NULL, 'Mr.', 'Owner37', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(349, 355, NULL, 'Mr.', 'Owner38', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(350, 356, NULL, 'Mr.', 'Owner39', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(351, 357, NULL, 'Mr.', 'Owner40', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(352, 358, NULL, 'Mr.', 'Owner41', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(353, 359, NULL, 'Mr.', 'Owner42', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(354, 360, NULL, 'Mr.', 'Owner43', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(355, 361, NULL, 'Mr.', 'Owner44', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(356, 362, NULL, 'Mr.', 'Owner45', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(357, 363, NULL, 'Mr.', 'Owner46', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(358, 364, 'profile_364.jpg', 'Mr.', 'Aidiel Effendy', '', NULL, '', NULL, '', '', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '2015-05-18 20:14:50', 0, 364),
(359, 365, NULL, 'Mr.', 'Owner48', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(360, 366, NULL, 'Mr.', 'Owner49', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(361, 367, NULL, 'Mr.', 'Owner50', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(362, 368, NULL, 'Mr.', 'Owner51', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(363, 369, NULL, 'Mr.', 'Owner52', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(364, 370, NULL, 'Mr.', 'Owner53', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(365, 371, NULL, 'Mr.', 'Owner54', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(366, 372, NULL, 'Mr.', 'Owner55', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(367, 373, NULL, 'Mr.', 'Owner56', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(368, 374, NULL, 'Mr.', 'Owner57', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(369, 375, NULL, 'Mr.', 'Owner58', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(370, 376, NULL, 'Mr.', 'Owner59', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(371, 377, NULL, 'Mr.', 'Owner60', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(372, 378, NULL, 'Mr.', 'Owner61', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(373, 379, NULL, 'Mr.', 'Owner62', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(374, 380, NULL, 'Mr.', 'Owner63', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(375, 381, NULL, 'Mr.', 'Owner64', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(376, 382, NULL, 'Mr.', 'Owner65', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(377, 383, NULL, 'Mr.', 'Owner66', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(378, 384, NULL, 'Mr.', 'Owner67', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(379, 385, NULL, 'Mr.', 'Owner68', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(380, 386, NULL, 'Mr.', 'Owner69', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(381, 387, NULL, 'Mr.', 'Owner70', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(382, 388, NULL, 'Mr.', 'Owner71', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(383, 389, NULL, 'Mr.', 'Owner72', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(384, 390, NULL, 'Mr.', 'Owner73', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(385, 391, NULL, 'Mr.', 'Owner74', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(386, 392, NULL, 'Mr.', 'Owner75', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(387, 393, NULL, 'Mr.', 'Owner76', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(388, 394, NULL, 'Mr.', 'Owner77', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(389, 395, NULL, 'Mr.', 'Owner78', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(390, 396, NULL, 'Mr.', 'Owner79', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(391, 397, NULL, 'Mr.', 'Owner80', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(392, 398, NULL, 'Mr.', 'Owner81', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(393, 399, NULL, 'Mr.', 'Owner82', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(394, 400, NULL, 'Mr.', 'Owner83', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(395, 401, NULL, 'Mr.', 'Owner84', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(396, 402, NULL, 'Mr.', 'Owner85', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(397, 403, NULL, 'Mr.', 'Owner86', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(398, 404, NULL, 'Mr.', 'Owner87', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(399, 405, NULL, 'Mr.', 'Owner88', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(400, 406, NULL, 'Mr.', 'Owner89', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(401, 407, NULL, 'Mr.', 'Owner90', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(402, 408, NULL, 'Mr.', 'Owner91', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(403, 409, NULL, 'Mr.', 'Owner92', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(404, 410, NULL, 'Mr.', 'Owner93', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(405, 411, NULL, 'Mr.', 'Owner94', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(406, 412, NULL, 'Mr.', 'Owner96', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(407, 413, NULL, 'Mr.', 'Aidiel Hotmail', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(408, 414, NULL, 'Mr.', 'Residenz Management 1', 'residenzmanagement1@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-05-19 11:00:00', '2015-05-19 11:00:00', 1, 1);

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

--
-- Table structure for table `user_role`
--

CREATE TABLE IF NOT EXISTS `user_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `condo_id` int(11) DEFAULT NULL,
  `condo_unit_id` int(11) DEFAULT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `role_id` (`role_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=435 ;

--
-- Dumping data for table `user_role`
--

INSERT INTO `user_role` (`id`, `user_id`, `role_id`, `condo_id`, `condo_unit_id`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(40, 1, 9, 1, NULL, 'A', '2015-05-19 09:00:00', '2015-05-19 09:00:00', 1, 1),
(334, 319, 3, 1, 324, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(335, 320, 3, 1, 325, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(336, 321, 3, 1, 326, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(337, 322, 3, 1, 327, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(338, 323, 3, 1, 328, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(339, 324, 3, 1, 329, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(340, 325, 3, 1, 330, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(341, 326, 3, 1, 331, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(342, 327, 3, 1, 332, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(343, 328, 3, 1, 333, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(344, 329, 3, 1, 334, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(345, 330, 3, 1, 335, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(346, 320, 3, 1, 336, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(347, 331, 3, 1, 337, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(348, 332, 3, 1, 338, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(349, 333, 3, 1, 339, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(350, 334, 3, 1, 340, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(351, 335, 3, 1, 341, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(352, 336, 3, 1, 342, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(353, 337, 3, 1, 343, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(354, 338, 3, 1, 344, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(355, 339, 3, 1, 345, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(356, 340, 3, 1, 346, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(357, 341, 3, 1, 347, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(358, 342, 3, 1, 348, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(359, 343, 3, 1, 349, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(360, 344, 3, 1, 350, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(361, 345, 3, 1, 351, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(362, 346, 3, 1, 352, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(363, 347, 3, 1, 353, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(364, 348, 3, 1, 354, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(365, 349, 3, 1, 355, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(366, 350, 3, 1, 356, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(367, 351, 3, 1, 357, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(368, 352, 3, 1, 358, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(369, 353, 3, 1, 359, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(370, 354, 3, 1, 360, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(371, 355, 3, 1, 361, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(372, 356, 3, 1, 362, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(373, 357, 3, 1, 363, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(374, 358, 3, 1, 364, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(375, 359, 3, 1, 365, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(376, 360, 3, 1, 366, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(377, 361, 3, 1, 367, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(378, 362, 3, 1, 368, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(379, 363, 3, 1, 369, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(380, 364, 3, 1, 370, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(381, 365, 3, 1, 371, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(382, 366, 3, 1, 372, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(383, 367, 3, 1, 373, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(384, 368, 3, 1, 374, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(385, 369, 3, 1, 375, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(386, 370, 3, 1, 376, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(387, 371, 3, 1, 377, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(388, 372, 3, 1, 378, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(389, 373, 3, 1, 379, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(390, 374, 3, 1, 380, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(391, 375, 3, 1, 381, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(392, 376, 3, 1, 382, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(393, 377, 3, 1, 383, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(394, 378, 3, 1, 384, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(395, 379, 3, 1, 385, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(396, 380, 3, 1, 386, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(397, 381, 3, 1, 387, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(398, 382, 3, 1, 388, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(399, 383, 3, 1, 389, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(400, 384, 3, 1, 390, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(401, 385, 3, 1, 391, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(402, 386, 3, 1, 392, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(403, 387, 3, 1, 393, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(404, 388, 3, 1, 394, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(405, 389, 3, 1, 395, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(406, 390, 3, 1, 396, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(407, 391, 3, 1, 397, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(408, 392, 3, 1, 398, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(409, 393, 3, 1, 399, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(410, 394, 3, 1, 400, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(411, 395, 3, 1, 401, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(412, 396, 3, 1, 402, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(413, 397, 3, 1, 403, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(414, 398, 3, 1, 404, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(415, 399, 3, 1, 405, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(416, 400, 3, 1, 406, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(417, 401, 3, 1, 407, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(418, 402, 3, 1, 408, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(419, 403, 3, 1, 409, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(420, 404, 3, 1, 410, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(421, 405, 3, 1, 411, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(422, 406, 3, 1, 412, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(423, 407, 3, 1, 413, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(424, 408, 3, 1, 414, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(425, 409, 3, 1, 415, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(426, 410, 3, 1, 416, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(427, 411, 3, 1, 417, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(428, 364, 3, 1, 418, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(429, 412, 3, 1, 419, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(430, 328, 4, 1, 370, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(431, 413, 4, 1, 385, 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(432, 1, 9, 2, NULL, 'A', '2015-05-19 09:00:00', '2015-05-19 09:00:00', 1, 1),
(434, 414, 2, 1, NULL, 'A', '2015-05-19 09:00:00', '2015-05-19 09:00:00', 1, 1);

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

--
-- Table structure for table `user_vehicle`
--

CREATE TABLE IF NOT EXISTS `user_vehicle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `vehicle_no` varchar(15) NOT NULL,
  `make` varchar(25) NOT NULL,
  `model` varchar(25) NOT NULL,
  `colour` varchar(25) NOT NULL,
  `bay_no` varchar(15) NOT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `user_vehicle`
--

INSERT INTO `user_vehicle` (`id`, `condo_id`, `user_id`, `vehicle_no`, `make`, `model`, `colour`, `bay_no`, `remark`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES
(3, 1, 364, 'BHQ153', 'Perodua', 'Kenari', 'Silver', '1001', '', '0000-00-00 00:00:00', '2015-05-18 04:50:59', 0, 364),
(4, 1, 328, 'WGF 9266', 'Proton', 'Perdana', 'Bluish green', '1002', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(5, 1, 364, 'WAA 9229', 'Proton', 'Iswara', 'Blue', '1000', '', '2015-05-18 01:50:00', '2015-05-18 01:50:00', 364, 364);

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