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

START TRANSACTION;



--
-- Database: `violablh_hr_main`
--

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

--
-- Table structure for table `erp_mas_company`
--

CREATE TABLE `erp_mas_company` (
  `id` bigint(20) 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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `erp_mas_company`
--

INSERT INTO `erp_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`) VALUES
(1, 'DEMO', 'logo.png', 1, 'Magnum Technology Center Ltd', 'P.O. Box: 32478, Dubai (U.A.E)', 'Dubai ', 'Dubai', '143', '32478', '32478', 'N', 'P.O. Box: 32478, Dubai (U.A.E) ', 'Dubai', 'Dubai', '143', '32478', '32478', '', '', '', '', '', '', '', '', '(971-4) 8108 600', 'sales@mtc-intl.com', '-', '-', 'https://www.mtc-intl.com', 'IT', '43', '45', 1, 'violablh_hr_data', 'Y', 'Magnum Technology Center Ltd ', 'P.O. Box: 32478, Dubai (U.A.E)', 'This is a system generated output and requires no signature. This document is printed from Bluesky ERP on ', 1, 'xxx-xxx-xxxxx', '');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `erp_mas_company`
--
ALTER TABLE `erp_mas_company`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

