· 6 years ago · May 13, 2019, 08:46 PM
1-- phpMyAdmin SQL Dump
2-- version 4.7.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: May 10, 2019 at 06:50 PM
7-- Server version: 5.7.19
8-- PHP Version: 5.6.31
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `task_db`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `admin`
29--
30
31DROP TABLE IF EXISTS `admin`;
32CREATE TABLE IF NOT EXISTS `admin` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `userName` varchar(255) NOT NULL,
35 `password` varchar(255) DEFAULT NULL,
36 `firstName` varchar(255) DEFAULT NULL,
37 `lastName` varchar(255) DEFAULT NULL,
38 `email` varchar(255) DEFAULT NULL,
39 `phone` varchar(21) NOT NULL,
40 `modifiedDate` date NOT NULL,
41 `last_login` datetime NOT NULL,
42 `ip_address` varchar(255) NOT NULL,
43 PRIMARY KEY (`id`)
44) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
45
46--
47-- Dumping data for table `admin`
48--
49
50INSERT INTO `admin` (`id`, `userName`, `password`, `firstName`, `lastName`, `email`, `phone`, `modifiedDate`, `last_login`, `ip_address`) VALUES
51(1, 'admin', 'admin', 'Amitava', 'Mishra', 'amitava.php5@gmail.com', '+91-9748097959', '2015-05-06', '2019-05-09 20:11:22', '::1');
52
53-- --------------------------------------------------------
54
55--
56-- Table structure for table `department`
57--
58
59DROP TABLE IF EXISTS `department`;
60CREATE TABLE IF NOT EXISTS `department` (
61 `id` int(11) NOT NULL AUTO_INCREMENT,
62 `deptName` varchar(255) NOT NULL,
63 `status` int(11) NOT NULL DEFAULT '1',
64 PRIMARY KEY (`id`)
65) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
66
67--
68-- Dumping data for table `department`
69--
70
71INSERT INTO `department` (`id`, `deptName`, `status`) VALUES
72(1, 'Development', 1),
73(2, 'Designing', 1),
74(3, 'SEO', 1),
75(4, 'Testing', 0),
76(7, 'Test', 1);
77
78-- --------------------------------------------------------
79
80--
81-- Table structure for table `employee`
82--
83
84DROP TABLE IF EXISTS `employee`;
85CREATE TABLE IF NOT EXISTS `employee` (
86 `id` int(11) NOT NULL AUTO_INCREMENT,
87 `empName` varchar(255) NOT NULL,
88 `gender` varchar(20) NOT NULL,
89 `dob` datetime NOT NULL,
90 `deptId` int(11) NOT NULL,
91 `phone` varchar(20) NOT NULL,
92 `email` varchar(255) NOT NULL,
93 `password` varchar(50) NOT NULL,
94 `address` text,
95 `pincode` int(11) NOT NULL,
96 `status` int(11) NOT NULL DEFAULT '1',
97 PRIMARY KEY (`id`)
98) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
99
100--
101-- Dumping data for table `employee`
102--
103
104INSERT INTO `employee` (`id`, `empName`, `gender`, `dob`, `deptId`, `phone`, `email`, `password`, `address`, `pincode`, `status`) VALUES
105(1, 'Amitava Misra', '', '1987-11-28 00:00:00', 1, 'Amitava Misra', 'amitava.php5@gmail.com', 'ami12', '4-A, Jamini KAhiraj row,\r\nKolkata -700004', 700001, 1),
106(2, 'Sandy Jons', '', '2000-09-25 00:00:00', 3, '2242443242', 'sandy@gmail.com', 'sandy', 'Test address, Kolkata', 700001, 1),
107(8, 'Thomas Lili', 'Female', '1990-05-01 00:00:00', 2, '+91-9723211299', 'thomas@gmail.com', 'thomas1', ' asasasada s fffh sh gdg ', 702322, 1),
108(7, 'Lili Rabartson', '', '2000-01-15 00:00:00', 2, '+91-972321122', 'lili@gmail.com', '121', 'sdad a dada', 1212121, 1);
109
110-- --------------------------------------------------------
111
112--
113-- Table structure for table `messages`
114--
115
116DROP TABLE IF EXISTS `messages`;
117CREATE TABLE IF NOT EXISTS `messages` (
118 `id` int(11) NOT NULL AUTO_INCREMENT,
119 `subject` varchar(255) NOT NULL,
120 `message` text NOT NULL,
121 `msgDate` datetime NOT NULL,
122 PRIMARY KEY (`id`)
123) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
124
125--
126-- Dumping data for table `messages`
127--
128
129INSERT INTO `messages` (`id`, `subject`, `message`, `msgDate`) VALUES
130(2, 'hello testing', 'The global \"Standard\" is yyyy-mm-dd, and should always be used by systems wherever possible. The order day, month, year is used by people in most of the world (except USA), but usually with slashes, not hyphens. To avoid confusion, I only separate YYYY-MM-DD with hyphens. Any other date format I will separate with slashes. This keeps things consisten<br>', '2019-05-08 13:06:54'),
131(3, 'I am sandy', 'Many scripts written in php need date and time function . PHP has many predefined date formats and you can also customized it as per your need .\r\nHere are some of the php date format examples and additional details for php.', '2019-05-08 13:56:54'),
132(4, '1 to 1', 'Returns a string formatted according to the given format string using the given integer timestamp or the current time if no timestamp is given. In other words, timestamp is optional and defaults to the value of<br>', '2019-05-08 13:57:24'),
133(5, 'aaa', 'ptimized for learning, testing, and training. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using this site, you agree to have read and accepted our terms of use, <br>', '2019-05-08 14:46:35'),
134(6, 'dfsd fsdf fdsf sdf', 'Characters used as input for displaying different date formats used in date and time functionsCharacters used as input for displaying different date formats used in date and time functions<br>', '2019-05-08 15:35:34'),
135(7, 'Welcome Message to All', '<div>Congratulations and in behalf of our members and supervisors, we would like to welcome you. We are all happy and excited for the upbringing of our company.Congratulations and in behalf of our members and supervisors, we would like to welcome you. We are all happy and excited for the upbringing of our company.<span>Congratulations and in behalf of our members and supervisors, we would like to welcome you. We are all happy and excited for the upbringing of our company.<br></span></div><div><span>Congratulations and in behalf of our members and supervisors, we would like to welcome you. We are all happy and excited for the upbringing of our company.<br></span></div><div>Congratulations and in behalf of our members and supervisors, we would like to welcome you. We are all happy and excited for the upbringing of our company.Congratulations and in behalf of our members and supervisors, we would like to welcome you. We are all happy and excited for the upbringing of our company.</div><br><br><br>', '2019-05-09 10:57:46'),
136(8, 'HI', 'HI HELLO<br>', '2019-05-09 10:58:54');
137
138-- --------------------------------------------------------
139
140--
141-- Table structure for table `messages_employee_map`
142--
143
144DROP TABLE IF EXISTS `messages_employee_map`;
145CREATE TABLE IF NOT EXISTS `messages_employee_map` (
146 `id` int(11) NOT NULL AUTO_INCREMENT,
147 `msgId` int(11) NOT NULL,
148 `senderId` int(11) NOT NULL,
149 `receiverId` int(11) NOT NULL,
150 `senderDelStatus` int(11) NOT NULL DEFAULT '1',
151 `receiverDelStatus` int(11) NOT NULL DEFAULT '1',
152 `readStatus` int(11) NOT NULL DEFAULT '1',
153 PRIMARY KEY (`id`)
154) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
155
156--
157-- Dumping data for table `messages_employee_map`
158--
159
160INSERT INTO `messages_employee_map` (`id`, `msgId`, `senderId`, `receiverId`, `senderDelStatus`, `receiverDelStatus`, `readStatus`) VALUES
161(1, 2, 8, 0, 1, 1, 1),
162(2, 2, 8, 1, 1, 0, 1),
163(3, 2, 8, 2, 1, 1, 1),
164(4, 3, 2, 1, 1, 1, 1),
165(5, 3, 2, 8, 1, 1, 1),
166(6, 3, 2, 7, 1, 1, 1),
167(7, 4, 2, 8, 1, 0, 1),
168(8, 5, 1, 8, 1, 1, 1),
169(9, 5, 1, 2, 0, 1, 1),
170(10, 6, 1, 0, 1, 1, 1),
171(11, 6, 1, 8, 1, 1, 1),
172(12, 7, 0, 1, 1, 1, 1),
173(13, 7, 0, 8, 1, 1, 1),
174(14, 7, 0, 7, 1, 1, 1),
175(15, 7, 0, 2, 1, 1, 1),
176(16, 8, 0, 7, 0, 1, 1);
177
178-- --------------------------------------------------------
179
180--
181-- Table structure for table `task`
182--
183
184DROP TABLE IF EXISTS `task`;
185CREATE TABLE IF NOT EXISTS `task` (
186 `id` int(11) NOT NULL AUTO_INCREMENT,
187 `title` varchar(255) NOT NULL,
188 `description` text,
189 `clientName` varchar(255) NOT NULL,
190 `taskEntryDate` date NOT NULL,
191 `taskEndDate` date NOT NULL,
192 `progressStatus` int(11) NOT NULL DEFAULT '0' COMMENT '0=NotStarted, 1=ongoing, 2=completed, 3=onhold',
193 `assignStatus` int(11) NOT NULL DEFAULT '0' COMMENT '0=NotAssign, 1=Assign',
194 `assignStartDate` date DEFAULT NULL,
195 `assignEndDate` date DEFAULT NULL,
196 `assignNote` text,
197 PRIMARY KEY (`id`)
198) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
199
200--
201-- Dumping data for table `task`
202--
203
204INSERT INTO `task` (`id`, `title`, `description`, `clientName`, `taskEntryDate`, `taskEndDate`, `progressStatus`, `assignStatus`, `assignStartDate`, `assignEndDate`, `assignNote`) VALUES
205(1, 'test task #1', 'test description', 'Mt. R. Aswim', '2019-05-06', '2019-05-31', 0, 0, '2019-05-05', '2019-05-01', 'hello world'),
206(2, 'test task #2', 'hello world 12313', 'Mr. Ram', '2019-05-05', '2019-05-30', 1, 1, '2019-05-05', '2019-05-28', 'na'),
207(3, 'Test task 3', '<div><b>hello </b>world 2312 3 j glkfg dsf hs</div><div>dfs<u>gk dfus gdfhghdfs g</u>dfs g</div><div>dfs gdfu<i> gysdf gd </i>s fdfd uy</div><div> df</div><br><br>', 'Mile Testing', '2019-05-05', '2019-05-31', 2, 1, '2019-05-10', '2019-05-25', 'keep good work<br>'),
208(4, 'The position property', '<div><span><b>Position</b>: absolute; An element with <b>position</b>: absolute; is positioned <b>relative</b> to the nearest positioned ancestor (instead of positioned <b>relative</b>\r\n to the viewport, like fixed). However; if an absolute positioned \r\nelement has no positioned ancestors, it uses the document body, and \r\nmoves along with page scrolling.</span></div><div><br><span>The position property specifies the type of positioning method used for an element (static, relative, ... JavaScript syntax: object.style.position=\"absolute\" Try it<br></span></div><div> Now let\'s explain the CSS: position values in detail. Static. position: static is the default value. Relative. position: relative : An element\'s new position relative to its normal position. Absolute. In position: relative , the element is positioned relative to itself. Fixed. Sticky. Now let\'s explain the CSS: position values in detail. Static. position: static is the default value. Relative. position: relative : An element\'s new position relative to its normal position. Absolute. In position: relative , the element is positioned relative to itself. Fixed. Sticky.</div><div>CSS Position: Relative vs Position \r\nAbsolute. Static - this is the default value, all elements are in order \r\nas they appear in the document. Relative - the element is positioned \r\nrelative to its normal position. Absolute - the element is positioned absolutely to its first positioned parent. <br></div><br><br><br>', 'Mike Goms', '2019-05-05', '2019-06-30', 0, 1, '2019-05-15', '2019-05-18', 'very impotent<br>');
209
210-- --------------------------------------------------------
211
212--
213-- Table structure for table `task_employee_map`
214--
215
216DROP TABLE IF EXISTS `task_employee_map`;
217CREATE TABLE IF NOT EXISTS `task_employee_map` (
218 `id` int(11) NOT NULL AUTO_INCREMENT,
219 `taskId` int(11) NOT NULL,
220 `empId` int(11) NOT NULL,
221 PRIMARY KEY (`id`)
222) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
223
224--
225-- Dumping data for table `task_employee_map`
226--
227
228INSERT INTO `task_employee_map` (`id`, `taskId`, `empId`) VALUES
229(1, 3, 1),
230(2, 3, 8),
231(3, 3, 2),
232(5, 2, 8),
233(6, 2, 7),
234(7, 4, 1),
235(8, 4, 8),
236(9, 4, 2);
237COMMIT;
238
239/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
240/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
241/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;