· 8 years ago · Dec 24, 2017, 08:36 PM
1DROP TABLE IF EXISTS `WorkActivityNew`;
2CREATE TABLE `WorkActivityNew` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `field` varchar(255) DEFAULT NULL,
5 `data` text,
6 PRIMARY KEY (`id`)
7) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
8
9-- ----------------------------
10-- Records of WorkActivity
11-- ----------------------------
12INSERT INTO `WorkActivityNew` VALUES ('1', 'Admin', null);
13INSERT INTO `WorkActivityNew` VALUES ('2', 'Analysis', null);
14INSERT INTO `WorkActivityNew` VALUES ('3', 'Checking\\Approval', null);
15INSERT INTO `WorkActivityNew` VALUES ('4', 'Design', null);
16INSERT INTO `WorkActivityNew` VALUES ('5', 'Meeting', null);
17INSERT INTO `WorkActivityNew` VALUES ('6', 'Manufacturing', null);
18INSERT INTO `WorkActivityNew` VALUES ('7', 'Project Management', null);
19INSERT INTO `WorkActivityNew` VALUES ('8', 'Testing', null);
20INSERT INTO `WorkActivityNew` VALUES ('9', 'Holiday', null);
21INSERT INTO `WorkActivityNew` VALUES ('10', 'Sick', null);
22INSERT INTO `WorkActivityNew` VALUES ('11', 'Proposal\\Meeting', null);
23INSERT INTO `WorkActivityNew` VALUES ('12', 'Logistics', null);
24INSERT INTO `WorkActivityNew` VALUES ('13', 'Procurement', null);