-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `zemydbus_support_main`
--

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

--
-- Table structure for table `bsrv_activity`
--

CREATE TABLE `bsrv_activity` (
  `id` int(11) NOT NULL,
  `activity_type` enum('M','P') COLLATE utf8_unicode_ci NOT NULL COMMENT 'M-Meeting,P-Project',
  `remarks` text COLLATE utf8_unicode_ci NOT NULL,
  `activity_date` date NOT NULL,
  `project_deadline_date` date NOT NULL,
  `client_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_date_time` datetime NOT NULL,
  `updated_by` int(11) NOT NULL,
  `updated_date_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `bsrv_company_project`
--

CREATE TABLE `bsrv_company_project` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `project_description` text NOT NULL,
  `note` text NOT NULL,
  `start_date` date NOT NULL,
  `actual_planned_date` date NOT NULL,
  `dead_line_date` date NOT NULL,
  `completed_date` date NOT NULL,
  `status` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_date_time` datetime NOT NULL,
  `updated_by` int(11) NOT NULL,
  `updated_date_time` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bsrv_mas_company`
--

CREATE TABLE `bsrv_mas_company` (
  `id` int(11) NOT NULL,
  `company_code` varchar(10) NOT NULL,
  `company_logo` varchar(255) NOT NULL,
  `crm_user_id` int(11) NOT NULL DEFAULT '1',
  `company_name` varchar(255) NOT NULL,
  `billing_address` text NOT NULL,
  `billing_city` varchar(255) NOT NULL,
  `billing_state` varchar(255) NOT NULL,
  `billing_country` varchar(255) NOT NULL,
  `billing_pinzip` varchar(255) NOT NULL,
  `billing_postalcode` varchar(255) NOT NULL,
  `shipping_address_same_as_billing` enum('Y','N') NOT NULL DEFAULT 'N',
  `shipping_address` varchar(255) NOT NULL,
  `shipping_city` varchar(255) NOT NULL,
  `shipping_state` varchar(255) NOT NULL,
  `shipping_country` varchar(255) NOT NULL,
  `shipping_postalcode` varchar(255) NOT NULL,
  `shipping_pinzip` varchar(255) NOT NULL,
  `facebook` varchar(255) NOT NULL,
  `skype` varchar(255) NOT NULL,
  `twitter` varchar(255) NOT NULL,
  `linkedin` varchar(255) NOT NULL,
  `instagram` varchar(255) NOT NULL,
  `myspace` varchar(255) NOT NULL,
  `youtube` varchar(255) NOT NULL,
  `googleplus` varchar(255) NOT NULL,
  `genral_phno` varchar(255) NOT NULL,
  `genral_email` varchar(255) NOT NULL,
  `genral_location` varchar(255) NOT NULL,
  `genral_fax` varchar(255) NOT NULL,
  `genral_web` varchar(255) NOT NULL,
  `genral_industry` varchar(255) NOT NULL,
  `genral_latitude` varchar(255) NOT NULL,
  `genral_longitude` varchar(255) NOT NULL,
  `currency_id` int(11) NOT NULL,
  `company_db_name` varchar(50) NOT NULL,
  `isActive` enum('Y','N') NOT NULL DEFAULT 'Y',
  `footer_line_one` varchar(500) NOT NULL,
  `footer_line_two` varchar(500) NOT NULL,
  `footer_autogenerated` varchar(500) NOT NULL,
  `fin_year` int(11) NOT NULL DEFAULT '1',
  `trn_no` varchar(255) NOT NULL,
  `excise_no` varchar(255) NOT NULL,
  `footer_logo` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bsrv_mas_company`
--

INSERT INTO `bsrv_mas_company` (`id`, `company_code`, `company_logo`, `crm_user_id`, `company_name`, `billing_address`, `billing_city`, `billing_state`, `billing_country`, `billing_pinzip`, `billing_postalcode`, `shipping_address_same_as_billing`, `shipping_address`, `shipping_city`, `shipping_state`, `shipping_country`, `shipping_postalcode`, `shipping_pinzip`, `facebook`, `skype`, `twitter`, `linkedin`, `instagram`, `myspace`, `youtube`, `googleplus`, `genral_phno`, `genral_email`, `genral_location`, `genral_fax`, `genral_web`, `genral_industry`, `genral_latitude`, `genral_longitude`, `currency_id`, `company_db_name`, `isActive`, `footer_line_one`, `footer_line_two`, `footer_autogenerated`, `fin_year`, `trn_no`, `excise_no`, `footer_logo`) VALUES
(1, 'BLUESKY', 'logo.png', 1, 'Bluesky Technologies', 'P. O. Box 95325, Abu Dhabi - U.A.E.', 'Abu Dhabi', 'Abu Dhabi', '143', '95325', '95325', 'N', 'PO Box 95325, Abu Dhabi, UAE', 'Abu Dhabi', 'Abu Dhabi', '143', '110427', '110427', '', '', '', '', '', '', '', '', '+971 2 6737900', ' info@bluesky.ae', '-', '+971 2 6737800', 'www.bluesky.ae', 'IT', '43', '45', 1, 'zemydbus_service_1000', 'Y', 'Bluesky Technolgies Consultant', 'P. O. Box 95325, Abu Dhabi - U.A.E.\r\n| Tel  : +971 2 6737900 | Fax : +971 2 6737800\r\n', 'This is a system generated output and requires no signature. This document is printed from Bluesky ERP on ', 1, '100226227500003', '', 'innovating.png');

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

--
-- Table structure for table `bsrv_mas_company1`
--

CREATE TABLE `bsrv_mas_company1` (
  `id` bigint(20) NOT NULL,
  `company_code` varchar(10) NOT NULL,
  `company_logo` varchar(255) NOT NULL,
  `company_baseurl` text NOT NULL,
  `crm_user_id` int(11) NOT NULL DEFAULT '1',
  `subscription_end_date` date NOT NULL,
  `company_name` varchar(255) NOT NULL,
  `billing_address` text NOT NULL,
  `billing_city` varchar(255) NOT NULL,
  `billing_state` varchar(255) NOT NULL,
  `billing_country` varchar(255) NOT NULL,
  `billing_pinzip` varchar(255) NOT NULL,
  `billing_postalcode` varchar(255) NOT NULL,
  `shipping_address_same_as_billing` enum('Y','N') NOT NULL DEFAULT 'N',
  `shipping_address` varchar(255) NOT NULL,
  `shipping_city` varchar(255) NOT NULL,
  `shipping_state` varchar(255) NOT NULL,
  `shipping_country` varchar(255) NOT NULL,
  `shipping_postalcode` varchar(255) NOT NULL,
  `shipping_pinzip` varchar(255) NOT NULL,
  `facebook` varchar(255) NOT NULL,
  `skype` varchar(255) NOT NULL,
  `twitter` varchar(255) NOT NULL,
  `linkedin` varchar(255) NOT NULL,
  `instagram` varchar(255) NOT NULL,
  `myspace` varchar(255) NOT NULL,
  `youtube` varchar(255) NOT NULL,
  `googleplus` varchar(255) NOT NULL,
  `genral_phno` varchar(255) NOT NULL,
  `genral_email` varchar(255) NOT NULL,
  `genral_location` varchar(255) NOT NULL,
  `genral_fax` varchar(255) NOT NULL,
  `genral_web` varchar(255) NOT NULL,
  `genral_industry` varchar(255) NOT NULL,
  `genral_latitude` varchar(255) NOT NULL,
  `genral_longitude` varchar(255) NOT NULL,
  `currency_id` int(11) NOT NULL,
  `company_db_name` varchar(50) NOT NULL,
  `isActive` enum('Y','N') NOT NULL DEFAULT 'Y',
  `footer_line_one` varchar(500) NOT NULL,
  `footer_line_two` varchar(500) NOT NULL,
  `footer_autogenerated` varchar(500) NOT NULL,
  `fin_year` int(11) NOT NULL DEFAULT '1',
  `trn_no` varchar(255) NOT NULL,
  `excise_no` varchar(255) NOT NULL,
  `license_start_date` date NOT NULL,
  `next_renew_date` date NOT NULL,
  `total_employees_allowed` int(11) NOT NULL,
  `footer_logo` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bsrv_mas_company1`
--

INSERT INTO `bsrv_mas_company1` (`id`, `company_code`, `company_logo`, `company_baseurl`, `crm_user_id`, `subscription_end_date`, `company_name`, `billing_address`, `billing_city`, `billing_state`, `billing_country`, `billing_pinzip`, `billing_postalcode`, `shipping_address_same_as_billing`, `shipping_address`, `shipping_city`, `shipping_state`, `shipping_country`, `shipping_postalcode`, `shipping_pinzip`, `facebook`, `skype`, `twitter`, `linkedin`, `instagram`, `myspace`, `youtube`, `googleplus`, `genral_phno`, `genral_email`, `genral_location`, `genral_fax`, `genral_web`, `genral_industry`, `genral_latitude`, `genral_longitude`, `currency_id`, `company_db_name`, `isActive`, `footer_line_one`, `footer_line_two`, `footer_autogenerated`, `fin_year`, `trn_no`, `excise_no`, `license_start_date`, `next_renew_date`, `total_employees_allowed`, `footer_logo`) VALUES
(1, 'BLUESKY', '', '', 1, '0000-00-00', '', '', '', '', '', '', '', 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 'Y', '', '', '', 1, '', '', '0000-00-00', '0000-00-00', 0, ''),
(2, 'DEMO', '', '', 1, '0000-00-00', '', '', '', '', '', '', '', 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 'Y', '', '', '', 1, '', '', '0000-00-00', '0000-00-00', 0, ''),
(3, 'EIM', '', '', 1, '0000-00-00', '', '', '', '', '', '', '', 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 'Y', '', '', '', 1, '', '', '0000-00-00', '0000-00-00', 0, ''),
(4, 'FGT', '', '', 1, '0000-00-00', '', '', '', '', '', '', '', 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 'Y', '', '', '', 1, '', '', '0000-00-00', '0000-00-00', 0, ''),
(5, 'DEMO1', '', '', 1, '0000-00-00', '', '', '', '', '', '', '', 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 'Y', '', '', '', 1, '', '', '0000-00-00', '0000-00-00', 0, ''),
(6, 'EL', '', '', 1, '0000-00-00', '', '', '', '', '', '', '', 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 'Y', '', '', '', 1, '', '', '0000-00-00', '0000-00-00', 0, ''),
(7, 'HILFIN', '', '', 1, '0000-00-00', '', '', '', '', '', '', '', 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 'Y', '', '', '', 1, '', '', '0000-00-00', '0000-00-00', 0, '');

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

--
-- Table structure for table `bsrv_pending_job`
--

CREATE TABLE `bsrv_pending_job` (
  `id` int(11) NOT NULL,
  `pending_date` date NOT NULL,
  `client_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `remarks` text COLLATE utf8_unicode_ci NOT NULL,
  `reference_id` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `job_status` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_date_time` datetime NOT NULL,
  `updated_by` int(11) NOT NULL,
  `updated_date_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bsrv_company_project`
--
ALTER TABLE `bsrv_company_project`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bsrv_mas_company`
--
ALTER TABLE `bsrv_mas_company`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bsrv_mas_company1`
--
ALTER TABLE `bsrv_mas_company1`
  ADD PRIMARY KEY (`id`),
  ADD KEY `crm_user_id` (`crm_user_id`);

--
-- Indexes for table `bsrv_pending_job`
--
ALTER TABLE `bsrv_pending_job`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bsrv_company_project`
--
ALTER TABLE `bsrv_company_project`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bsrv_mas_company`
--
ALTER TABLE `bsrv_mas_company`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `bsrv_mas_company1`
--
ALTER TABLE `bsrv_mas_company1`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `bsrv_pending_job`
--
ALTER TABLE `bsrv_pending_job`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

