· 8 years ago · Jul 26, 2018, 09:06 AM
1--
2-- Table structure for table `report_mst`
3--
4
5CREATE TABLE IF NOT EXISTS `report_mst` (
6 `r_id` int(11) NOT NULL AUTO_INCREMENT,
7 `r_title` varchar(500) NOT NULL,
8 PRIMARY KEY (`r_id`)
9) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
10
11--
12-- Dumping data for table `report_mst`
13--
14
15INSERT INTO `report_mst` (`r_id`, `r_title`) VALUES
16(1, 'Infringes my rights'),
17(2, 'Spam or misleading'),
18(3, 'Harmful dangerous acts'),
19(4, 'Hateful or abusive content'),
20(5, 'Violent or repulsive content'),
21(6, 'Sexual content'),
22(7, 'Others');
23
24-- --------------------------------------------------------
25
26--
27-- Table structure for table `report_problem`
28--
29
30CREATE TABLE IF NOT EXISTS `report_problem` (
31 `r_id` int(11) NOT NULL AUTO_INCREMENT,
32 `offers_id` int(11) NOT NULL,
33 `store_id` int(11) NOT NULL,
34 `reported_by` int(11) NOT NULL,
35 `device` int(11) NOT NULL,
36 `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
37 `issue_id` int(11) NOT NULL,
38 `issue_details` text NOT NULL,
39 PRIMARY KEY (`r_id`)
40) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;
41
42--
43-- Dumping data for table `report_problem`
44--
45
46INSERT INTO `report_problem` (`r_id`, `offers_id`, `store_id`, `reported_by`, `device`, `date_added`, `issue_id`, `issue_details`) VALUES
47(1, 10, 0, 2, 1, '2015-12-28 12:51:46', 3, 'issue_details'),
48(2, 0, 10, 2, 1, '2015-12-28 12:52:26', 3, 'issue_details'),
49(3, 0, 5, 2, 1, '2015-12-28 13:11:52', 3, 'issue_details'),
50(4, 203, 0, 106, 1, '2015-12-28 13:24:38', 1, 'Infringes my rights'),
51(5, 203, 0, 106, 1, '2015-12-28 13:26:29', 7, 'test'),
52(6, 193, 0, 106, 1, '2015-12-29 05:48:23', 6, 'Sexual content'),
53(7, 0, 149, 106, 1, '2015-12-29 06:17:04', 6, 'Sexual content'),
54(8, 0, 149, 106, 1, '2015-12-29 06:17:36', 7, 'Hello'),
55(9, 0, 148, 106, 1, '2015-12-29 06:19:39', 6, 'Sexual content'),
56(10, 0, 148, 106, 1, '2015-12-29 06:19:59', 7, 'Hello Report Abuse'),
57(11, 0, 148, 106, 1, '2015-12-29 06:30:43', 6, 'Sexual content'),
58(12, 217, 0, 106, 1, '2015-12-29 06:31:02', 4, 'Hateful or abusive content'),
59(13, 246, 0, 106, 1, '2015-12-29 12:25:16', 6, 'Sexual content'),
60(14, 246, 0, 106, 1, '2015-12-30 04:49:23', 5, 'Violent or repulsive content'),
61(15, 209, 0, 106, 1, '2015-12-30 04:58:15', 6, 'Sexual content'),
62(16, 169, 0, 106, 1, '2015-12-30 05:54:08', 2, 'Spam or misleading'),
63(17, 171, 0, 106, 1, '2015-12-30 10:46:13', 4, 'Hateful or abusive content'),
64(18, 205, 0, 106, 1, '2015-12-31 05:01:32', 6, 'Sexual content'),
65(19, 225, 0, 106, 1, '2015-12-31 05:46:42', 6, 'Sexual content'),
66(20, 0, 153, 106, 1, '2016-01-04 11:28:04', 5, 'Violent or repulsive content'),
67(21, 164, 0, 110, 1, '2016-01-05 06:21:27', 2, 'Spam or misleading'),
68(22, 259, 0, 117, 1, '2016-01-07 11:53:58', 3, 'Harmful dangerous acts'),
69(23, 259, 0, 117, 1, '2016-01-07 11:57:11', 7, 'jdjdjks'),
70(24, 214, 0, 117, 1, '2016-01-07 12:14:28', 2, 'Spam or misleading'),
71(25, 172, 0, 106, 1, '2016-01-07 12:23:33', 5, 'Violent or repulsive content'),
72(26, 0, 160, 106, 1, '2016-01-07 12:24:06', 5, 'Violent or repulsive content'),
73(27, 184, 0, 106, 1, '2016-01-07 12:33:05', 5, 'Violent or repulsive content'),
74(28, 0, 161, 106, 1, '2016-01-07 12:34:31', 5, 'Violent or repulsive content'),
75(29, 0, 271, 106, 1, '2016-01-07 12:34:53', 4, 'Hateful or abusive content'),
76(30, 0, 270, 117, 1, '2016-01-08 08:53:06', 3, 'Harmful dangerous acts'),
77(31, 228, 0, 110, 1, '2016-01-13 11:47:58', 3, 'Harmful dangerous acts'),
78(32, 228, 0, 110, 1, '2016-01-13 11:48:15', 7, 'this is testing'),
79(33, 279, 0, 0, 1, '2016-01-15 08:14:52', 1, 'Infringes my rights'),
80(34, 279, 0, 0, 1, '2016-01-15 08:15:11', 5, 'Violent or repulsive content'),
81(35, 279, 0, 0, 1, '2016-01-15 08:15:21', 4, 'Hateful or abusive content'),
82(36, 279, 0, 0, 1, '2016-01-15 08:15:42', 7, 'cdyiisyyks'),
83(37, 279, 0, 0, 1, '2016-01-15 09:55:14', 7, 'gshshs'),
84(38, 279, 0, 0, 1, '2016-01-15 10:09:36', 7, 'ha ja ha '),
85(39, 0, 268, 0, 1, '2016-01-16 07:38:38', 7, 'okkkkkey'),
86(40, 228, 0, 0, 1, '2016-01-18 14:05:27', 2, 'Spam or misleading'),
87(41, 228, 0, 0, 1, '2016-01-18 14:05:53', 7, 'ok testing'),
88(42, 243, 0, 0, 1, '2016-01-20 11:39:02', 3, 'Harmful dangerous acts'),
89(43, 284, 0, 0, 1, '2016-01-20 11:45:33', 2, 'Spam or misleading'),
90(44, 0, 287, 0, 1, '2016-01-20 11:49:35', 3, 'Harmful dangerous acts');