-- phpMyAdmin SQL Dump -- version 4.7.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Oct 12, 2018 at 05:31 AM -- Server version: 5.6.39-cll-lve -- PHP Version: 5.6.30 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `viraledges_db` -- -- -------------------------------------------------------- -- -- Table structure for table `GetDataTable` -- CREATE TABLE `GetDataTable` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `category` varchar(255) NOT NULL, `massage` varchar(1000) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `GetDataTable` -- INSERT INTO `GetDataTable` (`id`, `name`, `email`, `category`, `massage`) VALUES (454, '8165', '01-06-2018', 'Employee Wellbeing', 'Provision of gym facilities for everyone, and not just KLI employees\n'), (491, '', '17-07-2018', 'Employee Wellbeing', 'Please do not shut down access to the gyms. Maybe you can make a fitness champion in each geo and he can help you run a reimbursement model, for people who regularly go to the gym. Hence savings costs on people who do not use the facility, and not compromising on the wellbeing of those who do.\n'), (490, '', '16-07-2018', 'Employee Wellbeing', 'I am one of the territory managers from islamabad, with Karachi being my hometown. I have been hearing rumors over the past few days that we shall not be having access to the gym facility from next month onwards. On one hand we claim to be the best employer of the year and then hold CD conferences with an entire day dedicated to employee wellbeing, with the motto of the conference being \"winning balance\", and on the other hand we take hypocritical decisions like these compromising on the wellness of employees. For atleast the youngsters, who live miles away from their families in a city which is completely strange to them, an hour at the gym is something to look forward to after the grueling stretch for numbers and sales.\nI request the LT to please reconsider this and let not Unilever lose its charm for being a company that is driven not only for numbers but also for employee wellbeing. '), (489, '8086', '12-07-2018', 'Culture & Inclusion', 'Today there was a focus group to discuss opportunities for career development with some TMs. I would like to use this platform to appreciate the initiative and would request the HR team to organize this session for rest of the field team as well.\nWhere some problems may seem impossible to resolve, some actually get resolved by sheer discussion on the platform. '), (450, '7426', '17-05-2018', 'Policy & Process Support', 'As far as project home town is concerned employees are supposed to be working in there home towns, somehow,T.Ms in Faisalabad are all not from Faisalabad. More over, many people of the same designation like myself from Faisalabad are deputed in other towns. A review is required regarding Project Home Town.'), (452, '', '01-06-2018', 'Culture & Inclusion', 'Help me '), (453, '', '01-06-2018', 'Culture & Inclusion', 'mai aik shikyatee bacha hoon'), (488, '', '07-07-2018', 'Policy & Process Support', 'is guest house deduction is revised for employee who staying guest house parmanently???\n its was18% , this is come to know that its 9% from March_18'), (449, '8086', '17-05-2018', 'Employee Wellbeing', 'Provision of Gym break during work hours, thrice a week for TMs/AMs who have BMI imbalance. '), (482, '', '28-06-2018', 'Employee Wellbeing', 'This was our 10th consecutive day at work....\n\nwe still have 9 more to go. 3 weeks without a day off at the end of it.\n\nDid the CD Conference even matter?'), (471, '7568', '04-06-2018', 'Employee Wellbeing', 'Hyderabad Guest house not in good condition. Needs major improvements.\n'), (470, '7568', '04-06-2018', 'Policy & Process Support', 'Can you share pls transfer allowances policy'), (469, '8102', '04-06-2018', 'Policy & Process Support', 'want to know TM mobile purchase entitlement'), (468, '7835', '04-06-2018', 'Policy & Process Support', 'plz share car by back policy '), (467, '', '04-06-2018', 'Policy & Process Support', 'please share car by back policy '), (476, '8127', '12-06-2018', 'Policy & Process Support', 'Visiting cards and fuel card still pending. Request was made to hyd ops/wps team 1 month back. '), (463, '8106', '04-06-2018', 'Policy & Process Support', 'My 3+1 goals pending at my portal bkoz edit option on portal is block kindly support me that i edit my 3+1 tgt on workday.Thanks\n'), (475, '', '09-06-2018', 'Employee Wellbeing', 'there should be something for us on festivals like eid... either in terms of bonus/eidi or early salary disbursement.'), (461, '', '01-06-2018', 'Employee Wellbeing', 'need for ac ad for dist'), (460, '', '01-06-2018', 'Employee Wellbeing', ' no light at distribution\n'), (459, '', '01-06-2018', 'Culture & Inclusion', 'test message\n'), (431, '2166 ', '03-05-2018', 'Culture & Inclusion', 'Awaz is live'), (432, '', '03-05-2018', 'Culture & Inclusion', 'llliiivvvee\n'), (433, '', '1525764400', 'Employee Wellbeing', 'Hey you '), (434, '', '1525764414', 'Employee Wellbeing', 'Hey you '), (435, '', '1525764502', 'Employee Wellbeing', 'Hey you '), (437, '12344', '1525764568', 'Policy & Process Support', 'Pk'), (448, '8081', '17-05-2018', 'Policy & Process Support', 'I want to know how can I simply get benefit\n out of my tax statement. Is there anyone who can guide me on tax paying benefits. '), (439, 'mun', '10-05-2018', 'Culture & Inclusion', '1224\n'), (441, 'emp111', '10-05-2018', 'Employee Wellbeing', 'hello testing'), (442, '', '11-05-2018', 'Employee Wellbeing', 'Test message'), (443, '123456789990009 it yfvbjidc', '11-05-2018', 'Culture & Inclusion', 'test\ntest \nCSS Corp\n'), (451, '', '01-06-2018', 'Culture & Inclusion', 'We need to improve our work life balance. There are alot of late sittings.'), (445, '', '14-05-2018', 'Culture & Inclusion', 'Shfhfd\n'), (446, '', '14-05-2018', 'Employee Safety', 'testgdguhbnjOoubnkoutgbjkoiyggvbnkioijhbbbbbbbbytyvb\ntujh\nuhjn\nJbsbdnk\niejebsj\niejsj\n'), (447, '', '14-05-2018', 'Employee Safety', '\nRfy\n'), (455, '', '01-06-2018', 'Employee Wellbeing', 'excellent '), (456, '', '01-06-2018', 'Employee Safety', 'safety first '), (457, '', '01-06-2018', 'Policy & Process Support', 'Any official policy for employees willing to go for their MBA? '), (458, '2218', '01-06-2018', 'Policy & Process Support', 'Tax deduction certificate required plz \nalready email send to you sir.\nThanks '), (515, '8102', '10-08-2018', 'Employee Wellbeing', 'Dear Sir\nI want to get information of Paternity leaves policy for TMs.\nRegards, '), (516, '', '12-10-2018', '', 'testing'); -- -------------------------------------------------------- -- -- Table structure for table `passcode` -- CREATE TABLE `passcode` ( `id` int(10) NOT NULL, `passcode` varchar(50) NOT NULL, `passwords` varchar(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `passcode` -- INSERT INTO `passcode` (`id`, `passcode`, `passwords`) VALUES (1, '1234', 'unilever@'); -- -- Indexes for dumped tables -- -- -- Indexes for table `GetDataTable` -- ALTER TABLE `GetDataTable` ADD PRIMARY KEY (`id`), ADD KEY `name` (`name`); -- -- Indexes for table `passcode` -- ALTER TABLE `passcode` ADD UNIQUE KEY `id` (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `GetDataTable` -- ALTER TABLE `GetDataTable` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=517; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;