-- Generation Time: Oct 25, 2015 at 02:37 AM
-- Server version: 5.5.40-0ubuntu0.14.04.1
-- PHP Version: 5.5.9-1ubuntu4.5

--
-- Database: `residenz`
--

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

--
-- 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=1 ;

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

--
-- Table structure for table `auto_number`
--

CREATE TABLE IF NOT EXISTS `auto_number` (
  `group` varchar(32) NOT NULL,
  `number` int(11) NOT NULL,
  `optimistic_lock` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  PRIMARY KEY (`group`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `booking`
--

CREATE TABLE IF NOT EXISTS `booking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `condo_unit_id` int(11) NOT NULL,
  `booking_date` date NOT NULL,
  `booking_no` varchar(50) NOT NULL,
  `facility_id` int(11) NOT NULL,
  `purpose` varchar(255) NOT NULL,
  `deposit` decimal(10,2) DEFAULT NULL,
  `rental` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `no_of_guest` int(11) DEFAULT NULL,
  `salutation_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `contact_no` varchar(50) DEFAULT NULL,
  `remark` text,
  `remark_office` text,
  `payment_due_date` date DEFAULT NULL,
  `deposit_payment_mode` int(1) NOT NULL DEFAULT '0',
  `deposit_cheque_no` varchar(25) DEFAULT NULL,
  `deposit_ref_no` varchar(25) DEFAULT NULL,
  `rental_payment_mode` int(1) NOT NULL DEFAULT '0',
  `rental_cheque_no` varchar(25) DEFAULT NULL,
  `rental_ref_no` varchar(25) DEFAULT NULL,
  `payment_made_by_name` varchar(50) DEFAULT NULL,
  `refund_amount` decimal(10,2) DEFAULT NULL,
  `refunded_to_by_name` varchar(50) DEFAULT NULL,
  `forfeiture` decimal(10,2) DEFAULT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `approved_datetime` datetime DEFAULT NULL,
  `disapproved_by` int(11) DEFAULT NULL,
  `disapproved_datetime` datetime DEFAULT NULL,
  `cancelled_by` int(11) DEFAULT NULL,
  `cancelled_datetime` datetime DEFAULT NULL,
  `payment_received_by` int(11) DEFAULT NULL,
  `payment_received_datetime` datetime DEFAULT NULL,
  `refunded_by` int(11) DEFAULT NULL,
  `refunded_datetime` datetime DEFAULT NULL,
  `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,
  `on_behalf_of` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `booking_period`
--

CREATE TABLE IF NOT EXISTS `booking_period` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `booking_id` int(11) NOT NULL,
  `facility_period_id` int(11) NOT NULL,
  `booking_date` date 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=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,
  `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=1 ;

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

--
-- 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,
  `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=1 ;

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

--
-- 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,
  `booking_terms_conditions` 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=1 ;

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

--
-- 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=1 ;

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

--
-- Table structure for table `condo_unit_upload`
--

CREATE TABLE IF NOT EXISTS `condo_unit_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,
  `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=1 ;

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

--
-- 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,
  `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=1 ;

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

--
-- 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,
  `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=1 ;

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

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

CREATE TABLE IF NOT EXISTS `conversation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `message_no` varchar(25) DEFAULT 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=1 ;

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

--
-- 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(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`),
  KEY `conversation_id` (`conversation_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- 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,
  `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=1 ;

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

--
-- Table structure for table `country`
--

CREATE TABLE IF NOT EXISTS `country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `nationality` varchar(100) 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=1 ;

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

--
-- 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=1 ;

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

--
-- Table structure for table `email_blast_send`
--

CREATE TABLE IF NOT EXISTS `email_blast_send` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email_blast_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'P',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- 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) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT 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=1 ;

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

--
-- Table structure for table `facility`
--

CREATE TABLE IF NOT EXISTS `facility` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `auto_approve` varchar(1) NOT NULL DEFAULT 'N',
  `booking_advance_period` int(11) NOT NULL,
  `booking_advance_period_type` varchar(1) NOT NULL,
  `maximum_period_selection` int(11) DEFAULT NULL,
  `deposit` decimal(10,2) NOT NULL,
  `rental` decimal(10,2) NOT NULL,
  `no_of_guest` int(11) DEFAULT NULL,
  `booking_terms_conditions` 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=1 ;

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

--
-- Table structure for table `facility_item`
--

CREATE TABLE IF NOT EXISTS `facility_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `facility_id` int(11) NOT NULL,
  `item_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=1 ;

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

--
-- Table structure for table `facility_period`
--

CREATE TABLE IF NOT EXISTS `facility_period` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `facility_id` int(11) NOT NULL,
  `period` varchar(50) NOT NULL,
  `time_from` varchar(11) NOT NULL,
  `time_to` varchar(11) NOT NULL,
  `deposit` decimal(10,2) NOT NULL,
  `rental` decimal(10,2) NOT NULL,
  `ordering` 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=1 ;

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

--
-- Table structure for table `feedback`
--

CREATE TABLE IF NOT EXISTS `feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `condo_unit_id` int(11) NOT NULL,
  `feedback_no` varchar(15) NOT NULL,
  `feedback_type_id` int(11) NOT NULL,
  `nature_id` int(11) DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `status` varchar(1) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `on_behalf_of` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `feedback_log`
--

CREATE TABLE IF NOT EXISTS `feedback_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `feedback_id` int(11) NOT NULL,
  `status` varchar(1) 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=1 ;

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

--
-- Table structure for table `feedback_message`
--

CREATE TABLE IF NOT EXISTS `feedback_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `feedback_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `attachment` varchar(150) 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`),
  KEY `feedback_id` (`feedback_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `feedback_type`
--

CREATE TABLE IF NOT EXISTS `feedback_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `feedback` varchar(50) NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- 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,
  `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=1 ;

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

--
-- 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=1 ;

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

--
-- 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=1 ;

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

--
-- 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,
  `message_no` varchar(25) DEFAULT 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,
  `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=1 ;

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

--
-- Table structure for table `item`
--

CREATE TABLE IF NOT EXISTS `item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `quantity` int(11) NOT NULL,
  `deposit_per_item` decimal(10,2) NOT NULL,
  `rental_per_item` decimal(10,2) 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=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=1 ;

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

--
-- Table structure for table `make`
--

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

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

--
-- 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;

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

--
-- Table structure for table `nature`
--

CREATE TABLE IF NOT EXISTS `nature` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `nature` varchar(50) NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=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) DEFAULT NULL,
  `level` varchar(15) DEFAULT NULL,
  `unit` varchar(15) DEFAULT NULL,
  `condo_id` int(11) NOT NULL,
  `residence_type` varchar(1) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT 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=1 ;

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

--
-- 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) DEFAULT 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=1 ;

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

--
-- Table structure for table `salutation`
--

CREATE TABLE IF NOT EXISTS `salutation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `salutation` 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=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_generated` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password_reset_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mobile` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'P',
  `date_last_login` datetime DEFAULT NULL,
  `password_sent_status` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'N',
  `activation_key` varchar(8) COLLATE utf8_unicode_ci 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=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',
  `property_status` varchar(1) DEFAULT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  `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=latin1 AUTO_INCREMENT=1 ;

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

--
-- 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,
  `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`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- 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` text,
  `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=1 ;

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

--
-- 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=1 ;

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

--
-- Table structure for table `user_feedback_message`
--

CREATE TABLE IF NOT EXISTS `user_feedback_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `feedback_id` int(11) NOT NULL,
  `read_status` varchar(1) 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`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- 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` text,
  `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=1 ;

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

--
-- 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=1 ;

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

--
-- 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_id` int(11) DEFAULT NULL,
  `name` varchar(150) NOT NULL,
  `email` varchar(255) DEFAULT 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=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) NOT 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) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `role_id` (`role_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=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) DEFAULT NULL,
  `make_id` int(11) DEFAULT 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=1 ;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(1, 'AD', 'Andorra', 'Andorran', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(2, 'AE', 'United Arab Emirates', 'Emirian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(3, 'AF', 'Afghanistan', 'Afghan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(4, 'AG', 'Antigua and Barbuda', 'Antiguans, Barbudans', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(5, 'AL', 'Albania', 'Albanian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(6, 'AM', 'Armenia', 'Armenian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(7, 'AO', 'Angola', 'Angolan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(8, 'AR', 'Argentina', 'Argentinean', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(9, 'AT', 'Austria', 'Austrian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(10, 'AU', 'Australia', 'Australian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(11, 'AZ', 'Azerbaijan', 'Azerbaijani', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(12, 'BA', 'Bosnia and Herzegovina', 'Bosnian, Herzegovinian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(13, 'BB', 'Barbados', 'Barbadian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(14, 'BD', 'Bangladesh', 'Bangladeshi', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(15, 'BE', 'Belgium', 'Belgian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(16, 'BF', 'Burkina Faso', 'Burkinabe', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(17, 'BG', 'Bulgaria', 'Bulgarian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(18, 'BH', 'Bahrain', 'Bahraini', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(19, 'BI', 'Burundi', 'Burundian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(20, 'BJ', 'Benin', 'Beninese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(21, 'BN', 'Brunei', 'Bruneian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(22, 'BO', 'Bolivia', 'Bolivian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(23, 'BR', 'Brazil', 'Brazilian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(24, 'BS', 'The Bahamas', 'Bahamian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(25, 'BT', 'Bhutan', 'Bhutanese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(26, 'BW', 'Botswana', 'Motswana ('',singular), Batswana ('',plural)', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(27, 'BY', 'Belarus', 'Belarusian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(28, 'BZ', 'Belize', 'Belizean', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(29, 'CA', 'Canada', 'Canadian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(30, 'CD', 'Congo, Republic of the', 'Congolese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(31, 'CG', 'Congo, Democratic Republic of the', 'Congolese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(32, 'CH', 'Switzerland', 'Swiss', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(33, 'CI', 'Cote d''Ivoire', 'Ivorian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(34, 'CM', 'Cameroon', 'Cameroonian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(35, 'CN', 'China', 'Chinese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(36, 'CO', 'Colombia', 'Colombian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(37, 'CR', 'Costa Rica', 'Costa Rican', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(38, 'CU', 'Cuba', 'Cuban', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(39, 'CV', 'Cape Verde', 'Cape Verdian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(40, 'CY', 'Cyprus', 'Cypriot', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(41, 'CZ', 'Czech Republic', 'Czech', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(42, 'DE', 'Germany', 'German', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(43, 'DJ', 'Djibouti', 'Djibouti', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(44, 'DK', 'Denmark', 'Danish', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(45, 'DM', 'Dominica', 'Dominican', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(46, 'DO', 'Dominican Republic', 'Dominican', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(47, 'DZ', 'Algeria', 'Algerian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(48, 'EC', 'Ecuador', 'Ecuadorean', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(49, 'EE', 'Estonia', 'Estonian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(50, 'EG', 'Egypt', 'Egyptian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(51, 'ER', 'Eritrea', 'Eritrean', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(52, 'ES', 'Spain', 'Spanish', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(53, 'ET', 'Ethiopia', 'Ethiopian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(54, 'FI', 'Finland', 'Finnish', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(55, 'FJ', 'Fiji', 'Fijian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(56, 'FR', 'France', 'French', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(57, 'GA', 'Gabon', 'Gabonese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(58, 'GD', 'Grenada', 'Grenadian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(59, 'GE', 'Georgia', 'Georgian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(60, 'GH', 'Ghana', 'Ghanaian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(61, 'GM', 'The Gambia', 'Gambian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(62, 'GN', 'Guinea', 'Guinean', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(63, 'GQ', 'Equatorial Guinea', 'Equatorial Guinean', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(64, 'GT', 'Guatemala', 'Guatemalan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(65, 'GW', 'Guinea-Bissau', 'Guinea-Bissauan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(66, 'GY', 'Guyana', 'Guyanese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(67, 'HK', 'Hong Kong', 'Hong Kong', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(68, 'HN', 'Honduras', 'Honduran', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(69, 'HR', 'Croatia', 'Croatian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(70, 'HT', 'Haiti', 'Haitian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(71, 'HU', 'Hungary', 'Hungarian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(72, 'ID', 'Indonesia', 'Indonesian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(73, 'IE', 'Ireland', 'Irish', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(74, 'IL', 'Israel', 'Israeli', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(75, 'IN', 'India', 'Indian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(76, 'IQ', 'Iraq', 'Iraqi', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(77, 'IR', 'Iran', 'Iranian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(78, 'IS', 'Iceland', 'Icelander', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(79, 'IT', 'Italy', 'Italian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(80, 'JM', 'Jamaica', 'Jamaican', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(81, 'JO', 'Jordan', 'Jordanian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(82, 'JP', 'Japan', 'Japanese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(83, 'KE', 'Kenya', 'Kenyan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(84, 'KG', 'Kyrgyz Republic', 'Kirghiz', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(85, 'KH', 'Cambodia', 'Cambodian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(86, 'KI', 'Kiribati', 'I-Kiribati', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(87, 'KM', 'Comoros', 'Comoran', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(88, 'KN', 'Saint Kitts and Nevis', 'Kittian and Nevisian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(89, 'KP', 'Korea, North', 'North Korean', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(90, 'KR', 'Korea, South', 'South Korean', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(91, 'KW', 'Kuwait', 'Kuwaiti', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(92, 'KY', 'Central African Republic', 'Central African', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(93, 'KZ', 'Kazakhstan', 'Kazakhstani', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(94, 'LA', 'Laos', 'Laotian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(95, 'LB', 'Lebanon', 'Lebanese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(96, 'LC', 'Saint Lucia', 'Saint Lucian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(97, 'LI', 'Liechtenstein', 'Liechtensteiner', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(98, 'LK', 'Sri Lanka', 'Sri Lankan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(99, 'LR', 'Liberia', 'Liberian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(100, 'LS', 'Lesotho', 'Mosotho', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(101, 'LT', 'Lithuania', 'Lithuanian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(102, 'LU', 'Luxembourg', 'Luxembourger', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(103, 'LV', 'Latvia', 'Latvian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(104, 'LY', 'Libya', 'Libyan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(105, 'MA', 'Morocco', 'Moroccan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(106, 'MC', 'Monaco', 'Monegasque', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(107, 'MD', 'Moldova', 'Moldovan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(108, 'MG', 'Madagascar', 'Malagasy', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(109, 'MH', 'Marshall Islands', 'Marshallese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(110, 'MI', 'Federated States of Micronesia', 'Micronesian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(111, 'MK', 'Macedonia', 'Macedonian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(112, 'ML', 'Mali', 'Malian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(113, 'MM', 'Myanmar ('',Burma)', 'Burmese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(114, 'MR', 'Mauritania', 'Mauritanian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(115, 'MT', 'Malta', 'Maltese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(116, 'MU', 'Mauritius', 'Mauritian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(117, 'MV', 'Maldives', 'Maldivan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(118, 'MW', 'Malawi', 'Malawian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(119, 'MX', 'Mexico', 'Mexican', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(120, 'MY', 'Malaysia', 'Malaysian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(121, 'MZ', 'Mozambique', 'Mozambican', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(122, 'NA', 'Namibia', 'Namibian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(123, 'NE', 'Niger', 'Nigerien', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(124, 'NG', 'Nigeria', 'Nigerian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(125, 'NI', 'Nicaragua', 'Nicaraguan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(126, 'NL', 'Netherlands', 'Dutch', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(127, 'NO', 'Norway', 'Norwegian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(128, 'NP', 'Nepal', 'Nepalese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(129, 'NR', 'Nauru', 'Nauruan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(130, 'NZ', 'New Zealand', 'New Zealander', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(131, 'OM', 'Oman', 'Omani', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(132, 'PA', 'Panama', 'Panamanian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(133, 'PE', 'Peru', 'Peruvian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(134, 'PG', 'Papua New Guinea', 'Papua New Guinean', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(135, 'PH', 'Philippines', 'Filipino', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(136, 'PK', 'Pakistan', 'Pakistani', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(137, 'PL', 'Poland', 'Polish', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(138, 'PT', 'Portugal', 'Portuguese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(139, 'PW', 'Palau', 'Palauan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(140, 'PY', 'Paraguay', 'Paraguayan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(141, 'QA', 'Qatar', 'Qatari', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(142, 'RO', 'Romania', 'Romanian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(143, 'RS', 'Serbia and Montenegro', 'Serbian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(144, 'RU', 'Russia', 'Russian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(145, 'RW', 'Rwanda', 'Rwandan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(146, 'SA', 'Saudi Arabia', 'Saudi Arabian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(147, 'SB', 'Solomon Islands', 'Solomon Islander', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(148, 'SC', 'Seychelles', 'Seychellois', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(149, 'SD', 'Sudan', 'Sudanese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(150, 'SE', 'Sweden', 'Swedish', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(151, 'SG', 'Singapore', 'Singaporean', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(152, 'SI', 'Slovenia', 'Slovene', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(153, 'SK', 'Slovakia', 'Slovak', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(154, 'SL', 'Sierra Leone', 'Sierra Leonean', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(155, 'SM', 'San Marino', 'Sammarinese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(156, 'SN', 'Senegal', 'Senegalese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(157, 'SO', 'Somalia', 'Somali', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(158, 'SR', 'Suriname', 'Surinamer', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(159, 'ST', 'Sao Tome and Principe', 'Sao Tomean', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(160, 'SV', 'El Salvador', 'Salvadoran', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(161, 'SY', 'Syria', 'Syrian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(162, 'SZ', 'Swaziland', 'Swazi', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(163, 'TD', 'Chad', 'Chadian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(164, 'TG', 'Togo', 'Togolese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(165, 'TH', 'Thailand', 'Thai', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(166, 'TJ', 'Tajikistan', 'Tadzhik', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(167, 'TL', 'East Timor', 'East Timorese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(168, 'TM', 'Turkmenistan', 'Turkmen', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(169, 'TN', 'Tunisia', 'Tunisian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(170, 'TO', 'Tonga', 'Tongan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(171, 'TR', 'Turkey', 'Turkish', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(172, 'TT', 'Trinidad and Tobago', 'Trinidadian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(173, 'TV', 'Tuvalu', 'Tuvaluan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(174, 'TW', 'Taiwan', 'Taiwanese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(175, 'TZ', 'Tanzania', 'Tanzanian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(176, 'UA', 'Ukraine', 'Ukrainian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(177, 'UG', 'Uganda', 'Ugandan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(178, 'UK', 'United Kingdom', 'British', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(179, 'US', 'United States', 'American', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(180, 'UY', 'Uruguay', 'Uruguayan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(181, 'UZ', 'Uzbekistan', 'Uzbekistani', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(182, 'VA', 'Vatican City ('',Holy See)', 'none', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(183, 'VE', 'Venezuela', 'Venezuelan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(184, 'VH', 'Chile', 'Chilean', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(185, 'VN', 'Vietnam', 'Vietnamese', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(186, 'VU', 'Vanuatu', 'Ni-Vanuatu', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(187, 'WS', 'Samoa', 'Samoan', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(188, 'YE', 'Yemen', 'Yemeni', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(189, 'ZA', 'South Africa', 'South African', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(190, 'ZM', 'Zambia', 'Zambian', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `country` (`id`, `code`, `name`, `nationality`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES(191, 'ZW', 'Zimbabwe', 'Zimbabwean', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

INSERT INTO `salutation` (`salutation`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES('Mr.', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `salutation` (`salutation`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES('Mrs.', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `salutation` (`salutation`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES('Ms.', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `salutation` (`salutation`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES('Miss', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `salutation` (`salutation`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES('Dr.', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `salutation` (`salutation`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES('Prof.', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
INSERT INTO `salutation` (`salutation`, `status`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES('Other', 'A', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);

INSERT INTO `make` (`id`, `name`) VALUES(1, 'Acura');
INSERT INTO `make` (`id`, `name`) VALUES(2, 'Alfa Romeo');
INSERT INTO `make` (`id`, `name`) VALUES(3, 'Aston Martin');
INSERT INTO `make` (`id`, `name`) VALUES(4, 'Audi');
INSERT INTO `make` (`id`, `name`) VALUES(5, 'Auman');
INSERT INTO `make` (`id`, `name`) VALUES(6, 'Austin');
INSERT INTO `make` (`id`, `name`) VALUES(7, 'Baw');
INSERT INTO `make` (`id`, `name`) VALUES(8, 'Bentley');
INSERT INTO `make` (`id`, `name`) VALUES(9, 'Bison');
INSERT INTO `make` (`id`, `name`) VALUES(10, 'BMW');
INSERT INTO `make` (`id`, `name`) VALUES(11, 'Brabus');
INSERT INTO `make` (`id`, `name`) VALUES(12, 'Bufori');
INSERT INTO `make` (`id`, `name`) VALUES(13, 'Cadillac');
INSERT INTO `make` (`id`, `name`) VALUES(14, 'CAM');
INSERT INTO `make` (`id`, `name`) VALUES(15, 'Chana');
INSERT INTO `make` (`id`, `name`) VALUES(16, 'Changan');
INSERT INTO `make` (`id`, `name`) VALUES(17, 'Chery');
INSERT INTO `make` (`id`, `name`) VALUES(18, 'Chevrolet');
INSERT INTO `make` (`id`, `name`) VALUES(19, 'Chrysler');
INSERT INTO `make` (`id`, `name`) VALUES(20, 'Citroen');
INSERT INTO `make` (`id`, `name`) VALUES(21, 'Daihatsu');
INSERT INTO `make` (`id`, `name`) VALUES(22, 'Datsun');
INSERT INTO `make` (`id`, `name`) VALUES(23, 'DFSK');
INSERT INTO `make` (`id`, `name`) VALUES(24, 'Dodge');
INSERT INTO `make` (`id`, `name`) VALUES(25, 'Dong feng');
INSERT INTO `make` (`id`, `name`) VALUES(26, 'Ferrari');
INSERT INTO `make` (`id`, `name`) VALUES(27, 'Fiat');
INSERT INTO `make` (`id`, `name`) VALUES(28, 'Foday');
INSERT INTO `make` (`id`, `name`) VALUES(29, 'Ford');
INSERT INTO `make` (`id`, `name`) VALUES(30, 'Foton');
INSERT INTO `make` (`id`, `name`) VALUES(31, 'GMC');
INSERT INTO `make` (`id`, `name`) VALUES(32, 'Great Wall');
INSERT INTO `make` (`id`, `name`) VALUES(33, 'Greenoranges');
INSERT INTO `make` (`id`, `name`) VALUES(34, 'Gwm');
INSERT INTO `make` (`id`, `name`) VALUES(35, 'Hafei');
INSERT INTO `make` (`id`, `name`) VALUES(36, 'Hicom');
INSERT INTO `make` (`id`, `name`) VALUES(37, 'Hino');
INSERT INTO `make` (`id`, `name`) VALUES(38, 'Honda');
INSERT INTO `make` (`id`, `name`) VALUES(39, 'Huanghai');
INSERT INTO `make` (`id`, `name`) VALUES(40, 'Hummer');
INSERT INTO `make` (`id`, `name`) VALUES(41, 'Hyundai');
INSERT INTO `make` (`id`, `name`) VALUES(42, 'Impul');
INSERT INTO `make` (`id`, `name`) VALUES(43, 'Infiniti');
INSERT INTO `make` (`id`, `name`) VALUES(44, 'Inokom');
INSERT INTO `make` (`id`, `name`) VALUES(45, 'Isuzu');
INSERT INTO `make` (`id`, `name`) VALUES(46, 'JAC');
INSERT INTO `make` (`id`, `name`) VALUES(47, 'Jaguar');
INSERT INTO `make` (`id`, `name`) VALUES(48, 'JBC');
INSERT INTO `make` (`id`, `name`) VALUES(49, 'Jeep');
INSERT INTO `make` (`id`, `name`) VALUES(50, 'JMC');
INSERT INTO `make` (`id`, `name`) VALUES(51, 'Joylong');
INSERT INTO `make` (`id`, `name`) VALUES(52, 'Kama');
INSERT INTO `make` (`id`, `name`) VALUES(53, 'Kia');
INSERT INTO `make` (`id`, `name`) VALUES(54, 'King Long');
INSERT INTO `make` (`id`, `name`) VALUES(55, 'Lada');
INSERT INTO `make` (`id`, `name`) VALUES(56, 'Lamborghini');
INSERT INTO `make` (`id`, `name`) VALUES(57, 'Land Rover');
INSERT INTO `make` (`id`, `name`) VALUES(58, 'Lexus');
INSERT INTO `make` (`id`, `name`) VALUES(59, 'LMG');
INSERT INTO `make` (`id`, `name`) VALUES(60, 'Lotus');
INSERT INTO `make` (`id`, `name`) VALUES(61, 'Mahindra');
INSERT INTO `make` (`id`, `name`) VALUES(62, 'Maserati');
INSERT INTO `make` (`id`, `name`) VALUES(63, 'Maxus');
INSERT INTO `make` (`id`, `name`) VALUES(64, 'Mazda');
INSERT INTO `make` (`id`, `name`) VALUES(65, 'McLaren');
INSERT INTO `make` (`id`, `name`) VALUES(66, 'Mercedes-Benz');
INSERT INTO `make` (`id`, `name`) VALUES(67, 'MG');
INSERT INTO `make` (`id`, `name`) VALUES(68, 'MINI');
INSERT INTO `make` (`id`, `name`) VALUES(69, 'Mitsubishi');
INSERT INTO `make` (`id`, `name`) VALUES(70, 'Mitsuoka');
INSERT INTO `make` (`id`, `name`) VALUES(71, 'Morris');
INSERT INTO `make` (`id`, `name`) VALUES(72, 'Naza');
INSERT INTO `make` (`id`, `name`) VALUES(73, 'Nissan');
INSERT INTO `make` (`id`, `name`) VALUES(74, 'Opel');
INSERT INTO `make` (`id`, `name`) VALUES(75, 'Other');
INSERT INTO `make` (`id`, `name`) VALUES(76, 'Pagani');
INSERT INTO `make` (`id`, `name`) VALUES(77, 'Perodua');
INSERT INTO `make` (`id`, `name`) VALUES(78, 'Peugeot');
INSERT INTO `make` (`id`, `name`) VALUES(79, 'Plymouth');
INSERT INTO `make` (`id`, `name`) VALUES(80, 'Porsche');
INSERT INTO `make` (`id`, `name`) VALUES(81, 'Proton');
INSERT INTO `make` (`id`, `name`) VALUES(82, 'Renault');
INSERT INTO `make` (`id`, `name`) VALUES(83, 'Rolls-Royce');
INSERT INTO `make` (`id`, `name`) VALUES(84, 'Rover');
INSERT INTO `make` (`id`, `name`) VALUES(85, 'Saab');
INSERT INTO `make` (`id`, `name`) VALUES(86, 'Scania');
INSERT INTO `make` (`id`, `name`) VALUES(87, 'Shenyang Brilliance');
INSERT INTO `make` (`id`, `name`) VALUES(88, 'Skoda');
INSERT INTO `make` (`id`, `name`) VALUES(89, 'Smart');
INSERT INTO `make` (`id`, `name`) VALUES(90, 'Ssangyong');
INSERT INTO `make` (`id`, `name`) VALUES(91, 'Subaru');
INSERT INTO `make` (`id`, `name`) VALUES(92, 'Suzuki');
INSERT INTO `make` (`id`, `name`) VALUES(93, 'Tata');
INSERT INTO `make` (`id`, `name`) VALUES(94, 'Toyota');
INSERT INTO `make` (`id`, `name`) VALUES(95, 'Tuah');
INSERT INTO `make` (`id`, `name`) VALUES(96, 'UD Trucks');
INSERT INTO `make` (`id`, `name`) VALUES(97, 'Volkswagen');
INSERT INTO `make` (`id`, `name`) VALUES(98, 'Volvo');
INSERT INTO `make` (`id`, `name`) VALUES(99, 'Wald');
INSERT INTO `make` (`id`, `name`) VALUES(100, 'Weststar');
INSERT INTO `make` (`id`, `name`) VALUES(101, 'ZNA');
INSERT INTO `make` (`id`, `name`) VALUES(102, 'ZX Auto');

INSERT INTO `user` (
`id` ,
`username` ,
`auth_key` ,
`password_hash` ,
`password_reset_token` ,
`email` ,
`status` ,
`activation_key` ,
`created_datetime` ,
`updated_datetime` ,
`created_by` ,
`updated_by`
)
VALUES (
'0', 'Administrator', '0TcGsT-N7TC6ig-wTx7qAKKrFRo_WgI_', '$2y$13$QAZCvSXWY2q2ujx2XSmExOsPLkVZpcOdZm9wgfC.ZliGM3/tvGFXG', NULL , 'tech@theresidenz.my', 'A', NULL , '2015-05-11 20:47:58', '2015-06-17 00:53:06', '1', NULL
);

SET @admin_id=LAST_INSERT_ID();

INSERT INTO `user_profile` (
`id` ,
`user_id` ,
`photo` ,
`salutation_id` ,
`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 (
NULL , @admin_id, NULL , NULL , 'Administrator', 'tech@theresidenz.my', NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , '2015-06-21 00:00:00', '2015-06-21 00:00:00', '1', '1'
);

INSERT INTO `user` (
`id` ,
`username` ,
`auth_key` ,
`password_hash` ,
`password_reset_token` ,
`email` ,
`status` ,
`activation_key` ,
`created_datetime` ,
`updated_datetime` ,
`created_by` ,
`updated_by`
)
VALUES (
'0', 'Support', '0TcGsT-N7TC6ig-wTx7qAKKrFRo_WgI_', '$2y$13$QAZCvSXWY2q2ujx2XSmExOsPLkVZpcOdZm9wgfC.ZliGM3/tvGFXG', NULL , 'support@theresidenz.my', 'A', NULL , '2015-05-11 20:47:58', '2015-06-17 00:53:06', '1', NULL
);

SET @support_id=LAST_INSERT_ID();

INSERT INTO `user_profile` (
`id` ,
`user_id` ,
`photo` ,
`salutation_id` ,
`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 (
NULL , @support_id, NULL , NULL , 'Support', 'support@theresidenz.my', NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , '2015-06-21 00:00:00', '2015-06-21 00:00:00', '1', '1'
);

INSERT INTO `user` (
`id` ,
`username` ,
`auth_key` ,
`password_hash` ,
`password_reset_token` ,
`email` ,
`status` ,
`activation_key` ,
`created_datetime` ,
`updated_datetime` ,
`created_by` ,
`updated_by`
)
VALUES (
'0', 'Default Management', '0TcGsT-N7TC6ig-wTx7qAKKrFRo_WgI_', '$2y$13$QAZCvSXWY2q2ujx2XSmExOsPLkVZpcOdZm9wgfC.ZliGM3/tvGFXG', NULL , 'defaultmanagement@aleph-one.com.my', 'A', NULL , '2015-05-11 20:47:58', '2015-06-17 00:53:06', '1', NULL
);

SET @management_id=LAST_INSERT_ID();

INSERT INTO `user_profile` (
`id` ,
`user_id` ,
`photo` ,
`salutation_id` ,
`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 (
NULL , @management_id, NULL , NULL , 'Default Management', 'defaultmanagement@aleph-one.com.my', NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , '2015-06-21 00:00:00', '2015-06-21 00:00:00', '1', '1'
);