· 8 years ago · Nov 30, 2017, 09:24 PM
1-- phpMyAdmin SQL Dump
2-- version 3.1.5
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jan 25, 2011 at 07:30 AM
7-- Server version: 5.1.39
8-- PHP Version: 5.2.9-2
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17
18--
19-- Database: `cturk`
20--
21
22-- --------------------------------------------------------
23
24--
25-- Table structure for table `cturk4_assignments`
26--
27
28CREATE TABLE IF NOT EXISTS `cturk4_assignments` (
29 `id` int(11) NOT NULL AUTO_INCREMENT,
30 `requester_id` int(11) NOT NULL,
31 `worker_id` int(11) NOT NULL,
32 `hit_id` int(11) NOT NULL,
33 `group_id` int(11) NOT NULL,
34 `acceptDate` varchar(16) NOT NULL,
35 `submitDate` varchar(16) DEFAULT NULL,
36 `finishDate` varchar(16) DEFAULT NULL,
37 `expireDate` varchar(16) DEFAULT NULL,
38 `data` text,
39 `state` varchar(255) NOT NULL,
40 `message` text,
41 PRIMARY KEY (`id`)
42) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
43
44--
45-- Dumping data for table `cturk4_assignments`
46--
47
48
49-- --------------------------------------------------------
50
51--
52-- Table structure for table `cturk4_groups`
53--
54
55CREATE TABLE IF NOT EXISTS `cturk4_groups` (
56 `id` int(11) NOT NULL AUTO_INCREMENT,
57 `requester_id` int(11) NOT NULL,
58 `name` varchar(255) NOT NULL,
59 `description` text NOT NULL,
60 `currencyCode` varchar(64) NOT NULL,
61 `reward` varchar(16) NOT NULL,
62 `expireDate` varchar(16) NOT NULL,
63 `assignmentTime` int(11) NOT NULL COMMENT 'seconds',
64 `autoApprovalTime` int(11) NOT NULL COMMENT 'seconds',
65 `maxHits` int(11) NOT NULL DEFAULT '0',
66 `numCompletedHit` int(11) NOT NULL DEFAULT '0',
67 `numAvailableHit` int(11) NOT NULL DEFAULT '0',
68 `state` varchar(255) NOT NULL,
69 PRIMARY KEY (`id`)
70) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
71
72--
73-- Dumping data for table `cturk4_groups`
74--
75
76
77-- --------------------------------------------------------
78
79--
80-- Table structure for table `cturk4_hits`
81--
82
83CREATE TABLE IF NOT EXISTS `cturk4_hits` (
84 `id` int(11) NOT NULL AUTO_INCREMENT,
85 `group_id` int(11) NOT NULL,
86 `name` varchar(255) NOT NULL,
87 `description` text NOT NULL,
88 `currencyCode` varchar(64) NOT NULL,
89 `reward` varchar(16) NOT NULL,
90 `publishDate` varchar(16) NOT NULL,
91 `expireDate` varchar(16) NOT NULL,
92 `assignmentTime` int(11) NOT NULL COMMENT 'seconds',
93 `autoApprovalTime` int(11) NOT NULL COMMENT 'seconds',
94 `url` varchar(255) NOT NULL,
95 `frameHeight` int(11) NOT NULL,
96 `requester_id` int(11) NOT NULL,
97 `state` varchar(255) NOT NULL,
98 PRIMARY KEY (`id`)
99) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
100
101--
102-- Dumping data for table `cturk4_hits`
103--
104
105
106-- --------------------------------------------------------
107
108--
109-- Table structure for table `cturk4_payorders`
110--
111
112CREATE TABLE IF NOT EXISTS `cturk4_payorders` (
113 `id` int(11) NOT NULL AUTO_INCREMENT,
114 `senderEmail` varchar(255) NOT NULL,
115 `receiver_id` int(11) NOT NULL,
116 `receiverEmail` varchar(255) NOT NULL,
117 `receiverAmount` varchar(255) NOT NULL,
118 `payKey` varchar(255) NOT NULL,
119 `assignmentIds` varchar(255) NOT NULL,
120 `state` varchar(255) NOT NULL,
121 `createDate` varchar(16) NOT NULL,
122 `completeDate` varchar(16) DEFAULT NULL,
123 PRIMARY KEY (`id`)
124) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
125
126--
127-- Dumping data for table `cturk4_payorders`
128--
129
130
131-- --------------------------------------------------------
132
133--
134-- Table structure for table `cturk4_users`
135--
136
137CREATE TABLE IF NOT EXISTS `cturk4_users` (
138 `id` int(11) NOT NULL AUTO_INCREMENT,
139 `username` varchar(255) NOT NULL,
140 `password` varchar(32) NOT NULL,
141 `paypalAccount` varchar(255) NOT NULL,
142 `title` varchar(255) NOT NULL,
143 `firstname` varchar(255) NOT NULL,
144 `surname` varchar(255) NOT NULL,
145 `sex` varchar(16) NOT NULL,
146 `buildingName` varchar(255) DEFAULT NULL,
147 `streetName` varchar(255) DEFAULT NULL,
148 `cityName` varchar(255) DEFAULT NULL,
149 `postcode` varchar(255) DEFAULT NULL,
150 `email` varchar(255) NOT NULL,
151 `isRequester` int(11) NOT NULL DEFAULT '0',
152 `isActive` int(11) NOT NULL DEFAULT '1',
153 `isEnabled` int(11) NOT NULL DEFAULT '1',
154 `acceptanceRatio` int(11) NOT NULL DEFAULT '0',
155 `createDate` varchar(16) NOT NULL,
156 PRIMARY KEY (`id`)
157) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
158
159--
160-- Dumping data for table `cturk4_users`
161--
162
163INSERT INTO `cturk4_users` (`id`, `username`, `password`, `paypalAccount`, `title`, `firstname`, `surname`, `sex`, `buildingName`, `streetName`, `cityName`, `postcode`, `email`, `isRequester`, `isActive`, `isEnabled`, `acceptanceRatio`, `createDate`) VALUES
164(1, 'midfar@qq.com', '21232f297a57a5a743894a0e4a801fc3', 'cturk__1287135123_per@126.com', 'Mr.', 'firstname', 'surname', 'male', 'b', 's', 'c', 'p', 'midfar@qq.com', 1, 1, 1, 67, '1293254326110'),
165(2, 'midfar@vip.qq.com', '21232f297a57a5a743894a0e4a801fc3', 'cturk__1287126000_per@126.com', 'Mr.', 'firstname', 'surname', 'male', 'b', 's', 'c', 'p', 'midfar@vip.qq.com', 0, 1, 1, 67, '1293254382316'),
166(3, 'admin@midfar.com', '21232f297a57a5a743894a0e4a801fc3', 'cturk__1287563539_per@126.com', 'Mr.', 'f3', 's3', 'male', 'b', 's', 'c', 'p', 'admin@midfar.com', 1, 1, 1, 67, '1293254406452');
167
168-- --------------------------------------------------------
169
170--
171-- Table structure for table `cturk4_usertokens`
172--
173
174CREATE TABLE IF NOT EXISTS `cturk4_usertokens` (
175 `id` int(11) NOT NULL AUTO_INCREMENT,
176 `user_id` int(11) NOT NULL,
177 `resetPasswordToken` varchar(32) DEFAULT NULL,
178 `hasUsed` int(11) NOT NULL DEFAULT '0',
179 PRIMARY KEY (`id`)
180) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
181
182--
183-- Dumping data for table `cturk4_usertokens`
184--
185
186
187-- --------------------------------------------------------
188
189--
190-- Table structure for table `cturk4_workerrequests`
191--
192
193CREATE TABLE IF NOT EXISTS `cturk4_workerrequests` (
194 `id` int(11) NOT NULL AUTO_INCREMENT,
195 `worker_id` int(11) NOT NULL,
196 `requester_id` int(11) NOT NULL,
197 `createDate` varchar(16) NOT NULL,
198 `isActive` int(11) NOT NULL DEFAULT '1',
199 PRIMARY KEY (`id`)
200) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
201
202--
203-- Dumping data for table `cturk4_workerrequests`
204--
205
206
207-- --------------------------------------------------------
208
209--
210-- Table structure for table `cturk_list`
211--
212
213CREATE TABLE IF NOT EXISTS `cturk_list` (
214 `id` int(11) NOT NULL AUTO_INCREMENT,
215 `path` varchar(255) NOT NULL,
216 `status` int(11) DEFAULT NULL,
217 `hitid` varchar(100) DEFAULT NULL,
218 `hittypeid` varchar(100) DEFAULT NULL,
219 `AssignmentId` varchar(100) DEFAULT NULL,
220 `AssignmentStatus` varchar(100) DEFAULT NULL,
221 `WorkerId` varchar(100) DEFAULT NULL,
222 `Answers` text,
223 `StdAnswers` text,
224 `audioLength` varchar(20) DEFAULT NULL,
225 `publishDate` varchar(100) DEFAULT NULL,
226 `checkDate` varchar(100) DEFAULT NULL,
227 PRIMARY KEY (`id`)
228) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
229
230--
231-- Dumping data for table `cturk_list`
232--
233
234
235-- --------------------------------------------------------
236
237--
238-- Table structure for table `cturk_list2`
239--
240
241CREATE TABLE IF NOT EXISTS `cturk_list2` (
242 `id` int(11) NOT NULL AUTO_INCREMENT,
243 `trans_id` int(11) DEFAULT NULL,
244 `trans_AssignmentId` varchar(100) DEFAULT NULL,
245 `path` varchar(255) NOT NULL,
246 `status` int(11) DEFAULT NULL,
247 `hitid` varchar(100) DEFAULT NULL,
248 `hittypeid` varchar(100) DEFAULT NULL,
249 `AssignmentId` varchar(100) DEFAULT NULL,
250 `AssignmentStatus` varchar(100) DEFAULT NULL,
251 `WorkerId` varchar(100) DEFAULT NULL,
252 `StdQuestions` text,
253 `Answers` text,
254 `StdAnswers` text,
255 `audioLength` varchar(20) DEFAULT NULL,
256 `publishDate` varchar(100) DEFAULT NULL,
257 `checkDate` varchar(100) DEFAULT NULL,
258 PRIMARY KEY (`id`)
259) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
260
261--
262-- Dumping data for table `cturk_list2`
263--