· 9 years ago · May 18, 2017, 03:44 PM
1http://datapi.com DB's hacked BY PinkihacksOfficial
2
3-- phpMyAdmin SQL Dump
4-- version 3.4.11.1
5-- http://www.phpmyadmin.net
6--
7-- Host: localhost
8-- Generation Time: Jun 15, 2013 at 12:41 PM
9-- Server version: 5.5.32
10-- PHP Version: 5.2.17
11
12SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;
20
21--
22-- Database: `datapico_wsms_uat_mar9`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `account_type`
29--
30
31DROP TABLE IF EXISTS `account_type`;
32CREATE TABLE IF NOT EXISTS `account_type` (
33 `aid` int(10) NOT NULL AUTO_INCREMENT,
34 `name` varchar(24) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
35 `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
36 PRIMARY KEY (`aid`)
37) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
38
39--
40-- Dumping data for table `account_type`
41--
42
43INSERT INTO `account_type` (`aid`, `name`, `description`) VALUES
44(5, 'General Users', NULL),
45(1, 'Teachers', ''),
46(2, 'Schools', 'School Supervisor Accounts'),
47(3, 'Administrators', 'Datapi Administrator Accounts');
48
49-- --------------------------------------------------------
50
51--
52-- Table structure for table `applications`
53--
54
55DROP TABLE IF EXISTS `applications`;
56CREATE TABLE IF NOT EXISTS `applications` (
57 `appid` int(10) NOT NULL AUTO_INCREMENT,
58 `app_code` varchar(25) NOT NULL,
59 `app_name` text NOT NULL,
60 `description` text,
61 PRIMARY KEY (`appid`),
62 UNIQUE KEY `app_name` (`app_code`)
63) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
64
65--
66-- Dumping data for table `applications`
67--
68
69INSERT INTO `applications` (`appid`, `app_code`, `app_name`, `description`) VALUES
70(1, 'wsms', 'Worksheet Management System', 'Worksheet Store!'),
71(2, 'lit_mast', 'Literature Master', 'English Crosswords');
72
73-- --------------------------------------------------------
74
75--
76-- Table structure for table `assign_class`
77--
78
79DROP TABLE IF EXISTS `assign_class`;
80CREATE TABLE IF NOT EXISTS `assign_class` (
81 `acid` int(10) NOT NULL AUTO_INCREMENT,
82 `student_id` int(10) NOT NULL,
83 `class_id` int(10) NOT NULL,
84 `worksheet_id` int(10) NOT NULL,
85 `page_num` int(10) NOT NULL,
86 `assigned_datetime` datetime NOT NULL,
87 `banner_area1` text,
88 `banner_area2` text,
89 `banner_area3` text,
90 `header_id` int(10) DEFAULT NULL,
91 `print_history_id` int(11) DEFAULT NULL,
92 PRIMARY KEY (`acid`),
93 KEY `assign_class_student` (`student_id`),
94 KEY `assign_class_class` (`class_id`),
95 KEY `assign_class_worksheet` (`worksheet_id`)
96) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=67 ;
97
98--
99-- Dumping data for table `assign_class`
100--
101
102INSERT INTO `assign_class` (`acid`, `student_id`, `class_id`, `worksheet_id`, `page_num`, `assigned_datetime`, `banner_area1`, `banner_area2`, `banner_area3`, `header_id`, `print_history_id`) VALUES
103(66, 38, 11, 1, 7, '2013-05-16 00:28:40', '1', '', NULL, NULL, NULL),
104(65, 38, 11, 1, 6, '2013-05-16 00:28:40', '1', '', NULL, NULL, NULL),
105(64, 38, 11, 1, 5, '2013-05-16 00:28:40', '1', '', NULL, NULL, 27),
106(63, 38, 11, 1, 4, '2013-05-16 00:28:40', '1', '', NULL, NULL, NULL),
107(62, 38, 11, 1, 3, '2013-05-16 00:16:28', '1', '', NULL, NULL, 26),
108(61, 38, 11, 1, 2, '2013-05-16 00:16:28', '1', '', NULL, NULL, 25);
109
110-- --------------------------------------------------------
111
112--
113-- Table structure for table `assign_family`
114--
115
116DROP TABLE IF EXISTS `assign_family`;
117CREATE TABLE IF NOT EXISTS `assign_family` (
118 `afid` int(10) NOT NULL AUTO_INCREMENT,
119 `member_id` int(10) NOT NULL,
120 `family_id` int(10) NOT NULL,
121 `worksheet_id` int(10) NOT NULL,
122 `page_num` int(10) NOT NULL,
123 `assigned_datetime` datetime NOT NULL,
124 `banner_area1` text,
125 `banner_area2` text,
126 `banner_area3` text,
127 `header_id` int(11) DEFAULT NULL,
128 `print_history_id` int(11) DEFAULT NULL,
129 PRIMARY KEY (`afid`),
130 KEY `assign_family_family` (`family_id`),
131 KEY `assign_family_worksheet` (`worksheet_id`),
132 KEY `assign_family_member` (`member_id`)
133) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
134
135-- --------------------------------------------------------
136
137--
138-- Table structure for table `ci_sessions`
139--
140
141DROP TABLE IF EXISTS `ci_sessions`;
142CREATE TABLE IF NOT EXISTS `ci_sessions` (
143 `session_id` varchar(40) NOT NULL DEFAULT '0',
144 `ip_address` varchar(16) NOT NULL DEFAULT '0',
145 `user_agent` varchar(120) NOT NULL,
146 `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
147 `user_data` text NOT NULL,
148 PRIMARY KEY (`session_id`),
149 KEY `last_activity_idx` (`last_activity`)
150) ENGINE=MyISAM DEFAULT CHARSET=latin1;
151
152--
153-- Dumping data for table `ci_sessions`
154--
155
156INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES
157('bef9759e709a5dfaa2013e06b956d1c7', '24.84.232.234', 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', 1371317970, ''),
158('55b5b785a42ecc4cab8fe35075a7e7e7', '209.85.238.94', 'AdsBot-Google-Mobile (+http://www.google.com/mobile/adsbot.html) Mozilla (iPhone; U; CPU iPhone OS 3 0 like Mac OS X) Ap', 1371318839, ''),
159('1fdb405ba23fdc7c2c44b7e24f2eb3da', '209.85.238.94', 'AdsBot-Google (+http://www.google.com/adsbot.html)', 1371318840, ''),
160('9584ea3f32c2d71643a620922fe1c523', '24.84.232.234', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', 1371321307, ''),
161('975580a655dcab9288f19ee2a5bdf5f7', '24.84.232.234', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.2; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR', 1371316744, ''),
162('485586611634818d679c1106b354941d', '24.84.232.234', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', 1371320611, 'a:10:{s:9:"user_data";s:0:"";s:9:"user_name";s:8:"teacher1";s:3:"uid";s:2:"14";s:3:"aid";s:1:"1";s:7:"credits";s:1:"0";s:15:"profile_picture";s:53:"http://wsms.boostik.com/codeigniter/uploads/logo2.png";s:8:"fullname";s:11:"Teacher abc";s:10:"last_login";s:19:"2013-06-15 11:06:24";s:8:"loggedin";b:1;s:15:"printQueue_file";s:110:"http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-15_11-12-45_51bca08d210a4.pdf";}'),
163('fe8420db13cf481d569bf026661311c9', '24.84.232.234', 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', 1371318260, 'a:9:{s:7:"credits";s:1:"0";s:15:"profile_picture";s:53:"http://wsms.boostik.com/codeigniter/uploads/logo2.png";s:8:"fullname";s:11:"Teacher abc";s:10:"last_login";s:19:"2013-06-15 11:06:25";s:9:"user_name";s:8:"teacher1";s:3:"uid";s:2:"14";s:3:"aid";s:1:"1";s:8:"loggedin";b:1;s:15:"printQueue_file";s:110:"http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-15_11-19-06_51bca20a1c417.pdf";}'),
164('329376cc4231a52fb7307ba08b22f323', '198.46.150.24', 'Mozilla/5.0 (Linux; U; Android 2.2; fr-fr; Desire_A8181 Build/FRF91) App3leWebKit/53.1 (KHTML, like Gecko) Version/4.0 M', 1371315342, ''),
165('7e8364c65af0c876692f8686b479bb7f', '24.84.232.234', 'Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20100101 Firefox/12.0', 1371316416, ''),
166('91ed156665c59f59121c6f611b664119', '24.84.232.234', 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', 1371316662, ''),
167('3707613154d8f747c083e46bc772f1b3', '131.253.26.254', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; SV1; .NET CLR 1.1.4325; .NET CLR 2.0.40607)', 1371314415, '');
168
169-- --------------------------------------------------------
170
171--
172-- Table structure for table `classes`
173--
174
175DROP TABLE IF EXISTS `classes`;
176CREATE TABLE IF NOT EXISTS `classes` (
177 `cid` int(10) NOT NULL AUTO_INCREMENT,
178 `teacher_id` int(10) NOT NULL DEFAULT '0',
179 `school_id` int(10) NOT NULL DEFAULT '0',
180 `active` tinyint(4) NOT NULL DEFAULT '0',
181 `name` varchar(64) NOT NULL,
182 `grade` int(8) NOT NULL,
183 `description` text,
184 `created_datetime` datetime NOT NULL,
185 PRIMARY KEY (`cid`),
186 UNIQUE KEY `name` (`name`),
187 KEY `teacher_user` (`teacher_id`),
188 KEY `school_id` (`school_id`)
189) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
190
191--
192-- Dumping data for table `classes`
193--
194
195INSERT INTO `classes` (`cid`, `teacher_id`, `school_id`, `active`, `name`, `grade`, `description`, `created_datetime`) VALUES
196(11, 57, 12, 1, 'Brit-Class-1', 5, 'testing new class', '2013-05-16 00:05:09');
197
198-- --------------------------------------------------------
199
200--
201-- Table structure for table `country`
202--
203
204DROP TABLE IF EXISTS `country`;
205CREATE TABLE IF NOT EXISTS `country` (
206 `id` int(11) NOT NULL,
207 `country_name` varchar(200) NOT NULL,
208 PRIMARY KEY (`id`)
209) ENGINE=MyISAM DEFAULT CHARSET=utf8;
210
211--
212-- Dumping data for table `country`
213--
214
215INSERT INTO `country` (`id`, `country_name`) VALUES
216(1, 'United States'),
217(0, 'Canada');
218
219-- --------------------------------------------------------
220
221--
222-- Table structure for table `families`
223--
224
225DROP TABLE IF EXISTS `families`;
226CREATE TABLE IF NOT EXISTS `families` (
227 `fid` int(10) NOT NULL AUTO_INCREMENT,
228 `parent_id` int(10) NOT NULL DEFAULT '0',
229 `name` varchar(64) NOT NULL,
230 `description` text,
231 `created_datetime` datetime NOT NULL,
232 `active` int(11) NOT NULL,
233 PRIMARY KEY (`fid`),
234 UNIQUE KEY `name` (`name`),
235 KEY `family_user` (`parent_id`)
236) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
237
238-- --------------------------------------------------------
239
240--
241-- Table structure for table `join_class`
242--
243
244DROP TABLE IF EXISTS `join_class`;
245CREATE TABLE IF NOT EXISTS `join_class` (
246 `jcid` int(10) NOT NULL AUTO_INCREMENT,
247 `joiner_id` int(10) NOT NULL DEFAULT '0',
248 `class_id` int(10) NOT NULL DEFAULT '0',
249 `joined_time` datetime NOT NULL,
250 `request_approve` int(11) NOT NULL DEFAULT '0',
251 PRIMARY KEY (`jcid`),
252 UNIQUE KEY `joiner_id_class_id` (`joiner_id`,`class_id`),
253 KEY `joiner_class_class` (`class_id`)
254) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
255
256--
257-- Dumping data for table `join_class`
258--
259
260INSERT INTO `join_class` (`jcid`, `joiner_id`, `class_id`, `joined_time`, `request_approve`) VALUES
261(16, 38, 11, '2013-05-16 00:05:25', 1);
262
263-- --------------------------------------------------------
264
265--
266-- Table structure for table `join_family`
267--
268
269DROP TABLE IF EXISTS `join_family`;
270CREATE TABLE IF NOT EXISTS `join_family` (
271 `jfid` int(10) NOT NULL AUTO_INCREMENT,
272 `joiner_id` int(10) NOT NULL,
273 `family_id` int(10) NOT NULL,
274 `joined_time` datetime NOT NULL,
275 `request_approve` int(11) NOT NULL DEFAULT '0',
276 PRIMARY KEY (`jfid`),
277 UNIQUE KEY `joiner_id_family_id` (`joiner_id`,`family_id`),
278 KEY `join_family_family` (`family_id`)
279) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
280
281-- --------------------------------------------------------
282
283--
284-- Table structure for table `join_school`
285--
286
287DROP TABLE IF EXISTS `join_school`;
288CREATE TABLE IF NOT EXISTS `join_school` (
289 `jsid` int(10) NOT NULL AUTO_INCREMENT,
290 `joiner_id` int(10) NOT NULL DEFAULT '0',
291 `school_id` int(10) NOT NULL DEFAULT '0',
292 `joined_time` datetime NOT NULL,
293 PRIMARY KEY (`jsid`),
294 UNIQUE KEY `joiner_id_school_id` (`joiner_id`,`school_id`),
295 KEY `join_school_school` (`school_id`)
296) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
297
298-- --------------------------------------------------------
299
300--
301-- Table structure for table `paypal_ipn`
302--
303
304DROP TABLE IF EXISTS `paypal_ipn`;
305CREATE TABLE IF NOT EXISTS `paypal_ipn` (
306 `ipn_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
307 `business` varchar(60) NOT NULL,
308 `receiver_email` varchar(60) DEFAULT NULL,
309 `receiver_id` varchar(16) NOT NULL,
310 `item_name` varchar(100) DEFAULT NULL,
311 `item_number` varchar(10) DEFAULT NULL,
312 `quantity` varchar(6) DEFAULT NULL,
313 `payment_status` varchar(10) DEFAULT NULL,
314 `pending_reason` varchar(10) DEFAULT NULL,
315 `payment_date` varchar(32) DEFAULT NULL,
316 `payment_fee` float NOT NULL,
317 `payment_gross` float NOT NULL,
318 `mc_gross` float DEFAULT NULL,
319 `mc_fee` float DEFAULT NULL,
320 `tax` float DEFAULT NULL,
321 `mc_currency` varchar(3) DEFAULT NULL,
322 `txn_id` varchar(20) NOT NULL,
323 `txn_type` varchar(10) DEFAULT NULL,
324 `first_name` varchar(30) DEFAULT NULL,
325 `last_name` varchar(40) DEFAULT NULL,
326 `address_street` varchar(50) DEFAULT NULL,
327 `address_city` varchar(30) DEFAULT NULL,
328 `address_state` varchar(30) DEFAULT NULL,
329 `address_zip` varchar(20) DEFAULT NULL,
330 `address_country` varchar(30) DEFAULT NULL,
331 `address_status` varchar(10) DEFAULT NULL,
332 `payer_id` varchar(16) NOT NULL,
333 `payer_email` varchar(60) NOT NULL,
334 `payer_status` varchar(10) DEFAULT NULL,
335 `payment_type` varchar(10) DEFAULT NULL,
336 `notify_version` varchar(10) DEFAULT NULL,
337 `verify_sign` varchar(100) DEFAULT NULL,
338 `ipn_track_id` varchar(24) NOT NULL,
339 `referrer_id` varchar(10) DEFAULT NULL,
340 PRIMARY KEY (`ipn_id`),
341 UNIQUE KEY `txn_id` (`txn_id`)
342) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;
343
344--
345-- Dumping data for table `paypal_ipn`
346--
347
348INSERT INTO `paypal_ipn` (`ipn_id`, `business`, `receiver_email`, `receiver_id`, `item_name`, `item_number`, `quantity`, `payment_status`, `pending_reason`, `payment_date`, `payment_fee`, `payment_gross`, `mc_gross`, `mc_fee`, `tax`, `mc_currency`, `txn_id`, `txn_type`, `first_name`, `last_name`, `address_street`, `address_city`, `address_state`, `address_zip`, `address_country`, `address_status`, `payer_id`, `payer_email`, `payer_status`, `payment_type`, `notify_version`, `verify_sign`, `ipn_track_id`, `referrer_id`) VALUES
349(1, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '20 DataPi Credits', '20', '1', 'Completed', NULL, '12:30:17 Jan 12, 2013 PST', 0, 0, 6, 0.47, 0, 'CAD', '39P85183KB1497118', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'AfkG-qY2ZmnUzcpNjSwbCoRd6CiFAcTvdmDuWyKwBW-8a0dhtXGunGB-', 'e5cbb907c3477', NULL),
350(2, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '10 DataPi Credits', '10', '1', 'Completed', NULL, '12:59:42 Jan 12, 2013 PST', 0, 0, 3, 0.39, 0, 'CAD', '4RY64005DM619162X', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'AUF3I.chutYitnxqZoj6Opo5-ferAEabni0RPGIb0ggevrmUnZGOsRLI', '683c890a55e8e', NULL),
351(3, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '60 DataPi Credits', '60', '1', 'Completed', NULL, '13:01:44 Jan 12, 2013 PST', 0, 0, 15, 0.74, 0, 'CAD', '21G43190322250229', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'An54LtUtmC1pT3CRh8EKmShI6FxLAe9Ps3S2FadxP0lz8xQ.Z4slYJSU', '216815991fc13', NULL),
352(4, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '20 DataPi Credits', '20', '1', 'Completed', NULL, '13:03:03 Jan 12, 2013 PST', 0, 0, 6, 0.47, 0, 'CAD', '01182241PD479162W', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'AzelZcVaEWocVuCEBXxvb.pGajngA-HrdVjm.9TMt-.wU6Y29bp9jcRG', 'a07abe72483fd', NULL),
353(5, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '80 DataPi Credits', '80', '1', 'Completed', NULL, '13:03:47 Jan 12, 2013 PST', 0, 0, 20, 0.88, 0, 'CAD', '3YE89265D0070021N', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'A3e3froTbQoYlAgAZ5OVGcTH3X3bAho4oe5V5LDR5EvR-01nQygrMvzn', '5fcc079061185', NULL),
354(6, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '40 DataPi Credits', '40', '1', 'Completed', NULL, '13:06:28 Jan 12, 2013 PST', 0, 0, 10, 0.59, 0, 'CAD', '856487514V333332N', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'Ag5mp8jhM5rMa711sVV.EJNpwF6GAqRKPH6ATqG6o.1xgTHz7YqTJt3L', '271070da28e9d', NULL),
355(7, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '40 DataPi Credits', '40', '1', 'Completed', NULL, '13:07:21 Jan 12, 2013 PST', 0, 0, 10, 0.59, 0, 'CAD', '8JB79498ER549253R', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'AlLmeyjPGoMhL1vNYFlTWh2SY26OAjhsGS80N6ipuBL87ow2DMRU1h1M', '615441e637f4', NULL),
356(8, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '100 DataPi Credits', '100', '1', 'Completed', NULL, '13:08:46 Jan 12, 2013 PST', 0, 0, 22, 0.94, 0, 'CAD', '9N5455289A661053K', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'AGeKhhyPTZeL8uXCq4CHz2V1gZQmAS7R7zlBDaCaMxVDuf3z2v64m5UI', 'ea29f86cf118b', NULL),
357(9, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '60 DataPi Credits', '60', '1', 'Completed', NULL, '12:31:25 Jan 12, 2013 PST', 0, 0, 15, 0.74, 0, 'CAD', '6DC520838A755315G', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'AbaKs3prUHvDeIXEsxZmx7QEDMrLAATOHQo9Gcy9G4lFpoYfiELaDX46', '77c45473ec891', NULL),
358(10, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '20 DataPi Credits', '20', '1', 'Completed', NULL, '13:16:06 Jan 12, 2013 PST', 0, 0, 6, 0.47, 0, 'CAD', '03N98630ER287491W', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'AFcWxV21C7fd0v3bYYYRCpSSRl31A9r9V2altFuKkRjZW3MHmPnZ1gBM', '4652a4d9d29a', NULL),
359(11, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '60 DataPi Credits', '60', '1', 'Completed', NULL, '13:18:35 Jan 12, 2013 PST', 0, 0, 15, 0.74, 0, 'CAD', '3CX42864V3323221V', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'An5ns1Kso7MWUdW4ErQKJJJ4qi4-A.hgxWe.QpESmAeNW7pcI9NNccmj', '72092048725e8', NULL),
360(12, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '10 DataPi Credits', '10', '1', 'Completed', NULL, '13:30:17 Jan 12, 2013 PST', 0, 0, 3, 0.39, 0, 'CAD', '95A87774RR481283H', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'AFcWxV21C7fd0v3bYYYRCpSSRl31ApuAVhlnFv7qGHITePeh-uxpk8QS', '62b090ff4697b', NULL),
361(13, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '20 DataPi Credits', '20', '1', 'Completed', NULL, '13:38:40 Jan 12, 2013 PST', 0, 0, 6, 0.47, 0, 'CAD', '1N4911564V088800F', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'Axi4MaYYY4DHuemgRKce4xlbo2abA4R5Vk80kl8IWoIfIf7phHzC4ymI', '32ecee1c7a453', NULL),
362(14, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '40 DataPi Credits', '40', '1', 'Completed', NULL, '13:55:03 Jan 12, 2013 PST', 0, 0, 10, 0.59, 0, 'CAD', '6D632240WX259033G', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'Agz8yg7wLmTgaFL-hWkAgza4evngA47ms.-9ptQx1lELQt5HcqvnVBRF', 'bbb6dda51719f', NULL),
363(15, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '40 DataPi Credits', '40', '1', 'Completed', NULL, '13:59:12 Jan 12, 2013 PST', 0, 0, 10, 0.59, 0, 'CAD', '8T919218K0369914R', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'ATLWEjpHtoFkgYEFGIGNkxiK1Q4VATdCRAPNg8.Qnq6CVVlJdEFzJUbm', '17e993761f6b0', NULL),
364(16, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '60 DataPi Credits', '60', '1', 'Completed', NULL, '14:03:38 Jan 12, 2013 PST', 0, 0, 15, 0.74, 0, 'CAD', '6A412399EV209073M', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'ABZ194Wn6kAtBqWpQKhOzQ8imMwHAI5mAfh-Sor4ArGj55SJbOG4sUH8', '36542b062560d', NULL),
365(17, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '40 DataPi Credits', '40', '1', 'Completed', NULL, '14:12:51 Jan 12, 2013 PST', 0, 0, 10, 0.59, 0, 'CAD', '73G05837G64188742', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'An5ns1Kso7MWUdW4ErQKJJJ4qi4-A0jooOBBOtNEJMQXwpXlw4KqDymv', 'cd8a2a3d666fc', NULL),
366(18, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '60 DataPi Credits', '60', '1', 'Completed', NULL, '14:17:22 Jan 12, 2013 PST', 0, 0, 15, 0.74, 0, 'CAD', '3HF59700AS386722T', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'AzxDbRUsHuONb0y4W3pVzxY0hnXWADv7EGfbzT7NNZkBAady4payI1XB', '30941a2ab596a', NULL),
367(19, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '10 DataPi Credits', '10', '1', 'Completed', NULL, '14:52:43 Jan 12, 2013 PST', 0, 0, 3, 0.39, 0, 'CAD', '5MY30564XF8273516', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'A-XGPr68xlhbG5ZE2IEFycK8y6GcAs54.Ue.FfP7S0StaaDNHiv0MZ-H', '43d9dc032fc14', NULL),
368(20, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '10 DataPi Credits', '10', '1', 'Completed', NULL, '14:54:57 Jan 12, 2013 PST', 0, 0, 3, 0.39, 0, 'CAD', '93V09495DW054293T', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'AFcWxV21C7fd0v3bYYYRCpSSRl31AGf-W97sOZGMUqtQVaFFWP71uzZy', '25f79b44c5e50', NULL),
369(21, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '10 DataPi Credits', '10', '1', 'Completed', NULL, '15:01:10 Jan 12, 2013 PST', 0, 0, 3, 0.39, 0, 'CAD', '2RJ23075KC240940F', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'Avk69m0geRQkARRelJ4gEh7GZ1AyAmug5.p4yjRyN7wAGGKjj3YVDyvX', '14538e92235b0', NULL),
370(22, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '20 DataPi Credits', '20', '1', 'Completed', NULL, '10:38:07 Jan 19, 2013 PST', 0, 0, 6, 0.47, 0, 'CAD', '424938176F225732E', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'A6Mw3nVFFnA63tJ.eOw66aoAsf23A0Q61bivHHyrwVuKGcjRR9VJF3dQ', '1f165df884329', NULL),
371(23, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '20 DataPi Credits', '20', '1', 'Completed', NULL, '11:01:54 Jan 19, 2013 PST', 0, 0, 6, 0.47, 0, 'CAD', '88X34365H9006401H', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'Aru96MJgeoZwFpVXtEDfHE5ujW9fARolEToC3b8S3CCS1aatZAo97Coa', 'e13186dfbe1c8', NULL),
372(24, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '40 DataPi Credits', '40', '1', 'Completed', NULL, '11:16:16 Jan 19, 2013 PST', 0, 0, 10, 0.59, 0, 'CAD', '0XG34897UN587594G', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'Au6mt7eYD7Q4jgcLjk4i8B6fwXx.AwZX7iLFsY56pVtBpHVXMp7sptwL', '2aacabf1487a9', NULL),
373(25, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '10 DataPi Credits', '10', '1', 'Completed', NULL, '11:37:18 Jan 19, 2013 PST', 0, 0, 3, 0.39, 0, 'CAD', '8JB09893898306216', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'ACI2PqMiJazILEmgXXU5X3OsnLOKAA9EvIkIunb9wdLex1HzYMe.6vQm', 'dd5950db86ac3', NULL),
374(26, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '20 DataPi Credits', '20', '1', 'Completed', NULL, '11:43:34 Jan 19, 2013 PST', 0, 0, 6, 0.47, 0, 'CAD', '5WD35258SM294461W', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'AaxKGdq73fXexhwPqgwPK5U91IxKAUtF04.BVvFH1MIxz78e694zsTGK', '8f981209fda6', NULL),
375(27, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '40 DataPi Credits', '40', '1', 'Completed', NULL, '11:49:06 Jan 19, 2013 PST', 0, 0, 10, 0.59, 0, 'CAD', '45A01410AD737032G', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'An5ns1Kso7MWUdW4ErQKJJJ4qi4-AltWaw62c62q-5HfFGaIBNJb1gZb', '5fedd5b87bd', NULL),
376(28, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '10 DataPi Credits', '10', '1', 'Completed', NULL, '13:10:13 Jan 19, 2013 PST', 0, 0, 3, 0.39, 0, 'CAD', '08G191926W358080L', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'Akrir6i6YRo5PC4KqwLYZAhgwry8ARFSEhROEccKFleovBRxawFApV2X', 'b5087864d29d9', NULL),
377(29, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '20 DataPi Credits', '20', '1', 'Completed', NULL, '13:13:06 Jan 19, 2013 PST', 0, 0, 6, 0.47, 0, 'CAD', '17N85634L7864023A', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'APLbPFCJGyPgIpUwb.ibaZ00l1e9Acy52bev3i-.svnV3GAp2upffDA9', '373aed7ea58c', NULL),
378(30, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '60 DataPi Credits', '60', '1', 'Completed', NULL, '14:33:24 Jan 19, 2013 PST', 0, 0, 15, 0.74, 0, 'CAD', '99Y95309940588237', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'An5ns1Kso7MWUdW4ErQKJJJ4qi4-A0GK.33rmTmf6std7B30rChAn1-v', '24125cafa4d83', NULL),
379(31, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '80 DataPi Credits', '80', '1', 'Completed', NULL, '14:35:24 Jan 19, 2013 PST', 0, 0, 20, 0.88, 0, 'CAD', '0A1767936C423094L', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'ANvoR8BOGPFKR.STT83pgSwWRU-4AGbvTaQNbDG3jBu5SeM1.TanXViv', '9f7a3edf2d33b', NULL),
380(32, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '10 DataPi Credits', '10', '1', 'Completed', NULL, '14:42:22 Jan 19, 2013 PST', 0, 0, 3, 0.39, 0, 'CAD', '7E392520D78737728', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'AugjNz6Nloin.SjjSO-DOpKyrzmBAcuIe-3i5aTcDTROl6b0U3LxvB6f', '919ba9d931a43', NULL),
381(33, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '20 DataPi Credits', '20', '1', 'Completed', NULL, '14:55:48 Jan 19, 2013 PST', 0, 0, 6, 0.47, 0, 'CAD', '8P133678AW782002E', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'AiKZhEEPLJjSIccz.2M.tbyW5YFwAf7Lni5yd0u5oUuwPUK-I4gf0S86', 'da5cfa072b827', NULL),
382(34, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '40 DataPi Credits', '40', '1', 'Completed', NULL, '11:01:41 Jan 26, 2013 PST', 0, 0, 10, 0.59, 0, 'CAD', '2D761869EB151952K', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'AC1QM0nyKELc3mdWUfshmaRpdnPCABGrHzR02aBtCksuAWcQ2auqmxTq', '1f56acc365e00', NULL),
383(35, 'datapi_1345932428_biz@gmail.com', 'datapi_1345932428_biz@gmail.com', 'X7UJZWDUCREN6', '10 DataPi Credits', '10', '1', 'Completed', NULL, '11:03:11 Jan 26, 2013 PST', 0, 0, 3, 0.39, 0, 'CAD', '2KJ69451WN493170K', 'web_accept', 'Ngan', 'Do', '1 Maire-Victorin', 'Toronto', 'Ontario', 'M5A 1E1', 'Canada', 'confirmed', 'UR2FC757DJH7C', 'ngan_1345932502_per@gmail.com', 'verified', 'instant', '3.7', 'AUROk5aKaoOH29y0iJ8LX9jDAtYhA1bCphRoCYrZcW7X-YVeTw8O0wt.', 'dba58b8336d7a', NULL);
384
385-- --------------------------------------------------------
386
387--
388-- Table structure for table `printing_history`
389--
390
391DROP TABLE IF EXISTS `printing_history`;
392CREATE TABLE IF NOT EXISTS `printing_history` (
393 `phid` int(10) NOT NULL AUTO_INCREMENT,
394 `user_id` int(10) NOT NULL,
395 `worksheet_id` int(10) NOT NULL,
396 `page_num` int(10) NOT NULL,
397 `qty_printed` int(10) NOT NULL,
398 `inventory_type` text NOT NULL,
399 `print_time` datetime NOT NULL,
400 `printed_file` text NOT NULL,
401 PRIMARY KEY (`phid`)
402) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=183 ;
403
404--
405-- Dumping data for table `printing_history`
406--
407
408INSERT INTO `printing_history` (`phid`, `user_id`, `worksheet_id`, `page_num`, `qty_printed`, `inventory_type`, `print_time`, `printed_file`) VALUES
409(27, 38, 1, 5, 1, 'class_assignment', '2013-05-16 00:29:16', 'http://datapi.com/wsms_uat/codeigniter/pdfs/user_prints/jhuang_38_2013-05-16_00-29-16_51947cbca1254.pdf'),
410(26, 38, 1, 3, 1, 'class_assignment', '2013-05-16 00:25:01', 'http://datapi.com/wsms_uat/codeigniter/pdfs/user_prints/jhuang_38_2013-05-16_00-25-01_51947bbd56a57.pdf'),
411(25, 38, 1, 2, 1, 'class_assignment', '2013-05-16 00:25:01', 'http://datapi.com/wsms_uat/codeigniter/pdfs/user_prints/jhuang_38_2013-05-16_00-25-01_51947bbd56a57.pdf'),
412(24, 57, 1, 3, 1, 'class_assignment', '2013-05-16 00:16:47', 'http://datapi.com/wsms_uat/codeigniter/pdfs/user_prints/brit-teach_57_2013-05-16_00-16-47_519479cf468ea.pdf'),
413(23, 57, 1, 2, 1, 'class_assignment', '2013-05-16 00:16:47', 'http://datapi.com/wsms_uat/codeigniter/pdfs/user_prints/brit-teach_57_2013-05-16_00-16-47_519479cf468ea.pdf'),
414(22, 18, 1, 2, 1, 'datapi', '2013-05-15 23:33:02', 'http://datapi.com/wsms_uat/codeigniter/pdfs/user_prints/admin_18_2013-05-15_23-33-02_51946f8e610cf.pdf'),
415(21, 18, 1, 1, 1, 'datapi', '2013-05-15 23:33:02', 'http://datapi.com/wsms_uat/codeigniter/pdfs/user_prints/admin_18_2013-05-15_23-33-02_51946f8e610cf.pdf'),
416(20, 18, 1, 2, 1, 'datapi', '2013-05-15 23:32:20', 'http://datapi.com/wsms_uat/codeigniter/pdfs/user_prints/admin_18_2013-05-15_23-32-20_51946f640dc2d.pdf'),
417(19, 18, 1, 1, 1, 'datapi', '2013-05-15 23:32:20', 'http://datapi.com/wsms_uat/codeigniter/pdfs/user_prints/admin_18_2013-05-15_23-32-20_51946f640dc2d.pdf'),
418(28, 57, 1, 1, 1, 'datapi', '2013-05-18 10:47:46', 'http://datapi.com/wsms_uat/codeigniter/pdfs/user_prints/brit-teach_57_2013-05-18_10-47-46_5197b0b2cdcde.pdf'),
419(29, 57, 1, 1, 1, 'datapi', '2013-05-18 10:51:09', 'http://datapi.com/wsms_uat/codeigniter/pdfs/user_prints/brit-teach_57_2013-05-18_10-51-09_5197b17d8434f.pdf'),
420(30, 57, 1, 1, 1, 'datapi', '2013-05-18 12:45:44', 'http://datapi.com/datapi/live/pdfs/user_prints/brit-teach_57_2013-05-18_12-45-44_5197cc5817660.pdf'),
421(31, 57, 1, 2, 1, 'datapi', '2013-05-18 12:45:44', 'http://datapi.com/datapi/live/pdfs/user_prints/brit-teach_57_2013-05-18_12-45-44_5197cc5817660.pdf'),
422(32, 57, 1, 3, 1, 'datapi', '2013-05-18 13:52:58', 'http://datapi.com/datapi/live/pdfs/user_prints/brit-teach_57_2013-05-18_13-52-58_5197dc1a1a4dd.pdf'),
423(33, 57, 1, 4, 1, 'datapi', '2013-05-18 13:52:58', 'http://datapi.com/datapi/live/pdfs/user_prints/brit-teach_57_2013-05-18_13-52-58_5197dc1a1a4dd.pdf'),
424(34, 18, 2, 1, 1, 'datapi', '2013-05-18 15:13:03', 'http://datapi.com/datapi/live/pdfs/user_prints/admin_18_2013-05-18_15-13-03_5197eedf90f1c.pdf'),
425(35, 18, 2, 1, 1, 'datapi', '2013-05-18 15:14:42', 'http://datapi.com/datapi/live/pdfs/user_prints/admin_18_2013-05-18_15-14-42_5197ef42be242.pdf'),
426(36, 18, 2, 1, 1, 'datapi', '2013-05-18 15:16:00', 'http://datapi.com/datapi/live/pdfs/user_prints/admin_18_2013-05-18_15-16-00_5197ef906db61.pdf'),
427(37, 18, 2, 1, 1, 'datapi', '2013-05-18 15:17:46', 'http://datapi.com/datapi/live/pdfs/user_prints/admin_18_2013-05-18_15-17-46_5197effa030b5.pdf'),
428(38, 18, 2, 1, 1, 'datapi', '2013-05-18 15:18:57', 'http://datapi.com/datapi/live/pdfs/user_prints/admin_18_2013-05-18_15-18-57_5197f041b92f9.pdf'),
429(39, 18, 2, 1, 1, 'datapi', '2013-05-18 15:20:43', 'http://datapi.com/datapi/live/pdfs/user_prints/admin_18_2013-05-18_15-20-43_5197f0abbc68a.pdf'),
430(40, 18, 2, 1, 1, 'datapi', '2013-05-18 15:24:40', 'http://datapi.com/datapi/live/pdfs/user_prints/admin_18_2013-05-18_15-24-40_5197f19859491.pdf'),
431(41, 18, 2, 1, 1, 'datapi', '2013-05-18 15:25:53', 'http://datapi.com/datapi/live/pdfs/user_prints/admin_18_2013-05-18_15-25-53_5197f1e1c69a1.pdf'),
432(42, 18, 1, 2, 1, 'datapi', '2013-05-18 15:27:19', 'http://datapi.com/datapi/live/pdfs/user_prints/admin_18_2013-05-18_15-27-19_5197f2373b049.pdf'),
433(43, 18, 1, 3, 1, 'datapi', '2013-05-18 15:27:19', 'http://datapi.com/datapi/live/pdfs/user_prints/admin_18_2013-05-18_15-27-19_5197f2373b049.pdf'),
434(44, 18, 2, 6, 1, 'datapi', '2013-05-18 15:27:39', 'http://datapi.com/datapi/live/pdfs/user_prints/admin_18_2013-05-18_15-27-38_5197f24a1a8b4.pdf'),
435(45, 18, 2, 7, 1, 'datapi', '2013-05-18 15:27:39', 'http://datapi.com/datapi/live/pdfs/user_prints/admin_18_2013-05-18_15-27-38_5197f24a1a8b4.pdf'),
436(46, 18, 2, 6, 1, 'datapi', '2013-05-18 15:28:13', 'http://datapi.com/datapi/live/pdfs/user_prints/admin_18_2013-05-18_15-28-13_5197f26da9c3a.pdf'),
437(47, 18, 2, 7, 1, 'datapi', '2013-05-18 15:28:13', 'http://datapi.com/datapi/live/pdfs/user_prints/admin_18_2013-05-18_15-28-13_5197f26da9c3a.pdf'),
438(48, 18, 1, 1, 1, 'datapi', '2013-05-18 15:33:57', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/admin_18_2013-05-18_15-33-57_5197f3c5d6fcd.pdf'),
439(49, 18, 1, 2, 1, 'datapi', '2013-05-18 15:33:57', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/admin_18_2013-05-18_15-33-57_5197f3c5d6fcd.pdf'),
440(50, 18, 2, 1, 1, 'datapi', '2013-05-18 15:34:15', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/admin_18_2013-05-18_15-34-15_5197f3d764e12.pdf'),
441(51, 18, 1, 1, 1, 'datapi', '2013-05-18 15:40:37', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/admin_18_2013-05-18_15-40-37_5197f555681d5.pdf'),
442(52, 18, 1, 2, 1, 'datapi', '2013-05-18 15:40:37', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/admin_18_2013-05-18_15-40-37_5197f555681d5.pdf'),
443(53, 18, 1, 1, 1, 'datapi', '2013-05-18 15:41:37', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/admin_18_2013-05-18_15-41-36_5197f590f320b.pdf'),
444(54, 18, 1, 2, 1, 'datapi', '2013-05-18 15:41:37', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/admin_18_2013-05-18_15-41-36_5197f590f320b.pdf'),
445(55, 18, 2, 1, 1, 'datapi', '2013-05-18 15:46:20', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/admin_18_2013-05-18_15-46-20_5197f6ac1bbe2.pdf'),
446(56, 18, 2, 2, 1, 'datapi', '2013-05-18 15:46:20', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/admin_18_2013-05-18_15-46-20_5197f6ac1bbe2.pdf'),
447(57, 18, 2, 1, 1, 'datapi', '2013-05-18 15:51:57', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/admin_18_2013-05-18_15-51-56_5197f7fcf3bf8.pdf'),
448(58, 18, 2, 1, 1, 'datapi', '2013-05-18 15:54:51', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/admin_18_2013-05-18_15-54-51_5197f8ab75387.pdf'),
449(59, 14, 2, 1, 1, 'datapi', '2013-06-03 18:06:17', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-03_18-06-17_51ad2f7998f5a.pdf'),
450(60, 14, 2, 2, 1, 'datapi', '2013-06-03 18:20:46', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-03_18-20-46_51ad32de6962a.pdf'),
451(61, 14, 2, 1, 1, 'datapi', '2013-06-03 18:34:11', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-03_18-34-11_51ad360396673.pdf'),
452(62, 14, 2, 2, 1, 'datapi', '2013-06-03 18:40:10', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-03_18-40-10_51ad376aca0f5.pdf'),
453(63, 14, 2, 2, 1, 'datapi', '2013-06-03 18:41:15', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-03_18-41-14_51ad37aaeeefa.pdf'),
454(64, 14, 2, 2, 1, 'datapi', '2013-06-03 18:42:13', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-03_18-42-12_51ad37e4e3adc.pdf'),
455(65, 14, 2, 2, 1, 'datapi', '2013-06-03 18:43:33', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-03_18-43-33_51ad383569224.pdf'),
456(66, 14, 2, 2, 1, 'datapi', '2013-06-03 18:56:20', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-03_18-56-20_51ad3b348b0a2.pdf'),
457(67, 14, 2, 1, 1, 'datapi', '2013-06-03 18:57:32', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-03_18-57-31_51ad3b7be5d8a.pdf'),
458(68, 14, 2, 1, 1, 'datapi', '2013-06-05 19:04:41', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-05_19-04-40_51afe028c9153.pdf'),
459(69, 14, 2, 1, 1, 'datapi', '2013-06-05 19:04:52', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-05_19-04-51_51afe033eaf77.pdf'),
460(70, 14, 2, 1, 1, 'datapi', '2013-06-05 19:05:24', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-05_19-05-24_51afe0546ea2e.pdf'),
461(71, 14, 2, 1, 1, 'datapi', '2013-06-06 14:25:41', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_14-25-40_51b0f044e1ef5.pdf'),
462(72, 14, 2, 2, 1, 'datapi', '2013-06-06 14:25:41', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_14-25-40_51b0f044e1ef5.pdf'),
463(73, 14, 2, 1, 1, 'datapi', '2013-06-06 14:54:37', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_14-54-37_51b0f70d22a07.pdf'),
464(74, 14, 2, 1, 1, 'datapi', '2013-06-06 15:00:52', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_15-00-52_51b0f8842da11.pdf'),
465(75, 14, 2, 1, 1, 'datapi', '2013-06-06 15:05:15', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_15-05-15_51b0f98b5f74e.pdf'),
466(76, 14, 2, 2, 1, 'datapi', '2013-06-06 15:05:15', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_15-05-15_51b0f98b5f74e.pdf'),
467(77, 14, 2, 1, 1, 'datapi', '2013-06-06 15:18:44', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_15-18-44_51b0fcb4b8710.pdf'),
468(78, 14, 2, 2, 1, 'datapi', '2013-06-06 15:18:44', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_15-18-44_51b0fcb4b8710.pdf'),
469(79, 14, 2, 1, 1, 'datapi', '2013-06-06 15:21:29', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_15-21-29_51b0fd5973d4d.pdf'),
470(80, 14, 2, 2, 1, 'datapi', '2013-06-06 15:21:29', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_15-21-29_51b0fd5973d4d.pdf'),
471(81, 14, 2, 1, 1, 'datapi', '2013-06-06 15:28:17', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_15-28-16_51b0fef0d8d9b.pdf'),
472(82, 14, 2, 2, 1, 'datapi', '2013-06-06 15:28:17', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_15-28-16_51b0fef0d8d9b.pdf'),
473(83, 14, 2, 1, 1, 'datapi', '2013-06-06 15:41:13', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_15-41-13_51b101f96296e.pdf'),
474(84, 14, 2, 2, 1, 'datapi', '2013-06-06 15:41:13', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_15-41-13_51b101f96296e.pdf'),
475(85, 14, 2, 1, 1, 'datapi', '2013-06-06 15:43:30', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_15-43-30_51b10282ac138.pdf'),
476(86, 14, 2, 2, 1, 'datapi', '2013-06-06 15:43:30', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_15-43-30_51b10282ac138.pdf'),
477(87, 14, 2, 1, 1, 'datapi', '2013-06-06 15:49:07', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_15-49-07_51b103d3401ea.pdf'),
478(88, 14, 2, 2, 1, 'datapi', '2013-06-06 15:49:07', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_15-49-07_51b103d3401ea.pdf'),
479(89, 14, 2, 1, 1, 'datapi', '2013-06-06 16:02:53', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-02-53_51b1070d494b1.pdf'),
480(90, 14, 2, 2, 1, 'datapi', '2013-06-06 16:02:53', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-02-53_51b1070d494b1.pdf'),
481(91, 14, 2, 1, 1, 'datapi', '2013-06-06 16:05:01', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-05-00_51b1078cdb52d.pdf'),
482(92, 14, 2, 2, 1, 'datapi', '2013-06-06 16:05:01', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-05-00_51b1078cdb52d.pdf'),
483(93, 14, 2, 1, 1, 'datapi', '2013-06-06 16:17:10', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-17-10_51b10a662e934.pdf'),
484(94, 14, 2, 2, 1, 'datapi', '2013-06-06 16:17:10', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-17-10_51b10a662e934.pdf'),
485(95, 14, 2, 1, 1, 'datapi', '2013-06-06 16:17:38', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-17-38_51b10a827c1fc.pdf'),
486(96, 14, 2, 2, 1, 'datapi', '2013-06-06 16:17:38', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-17-38_51b10a827c1fc.pdf'),
487(97, 14, 2, 1, 1, 'datapi', '2013-06-06 16:18:05', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-18-05_51b10a9dc35bf.pdf'),
488(98, 14, 2, 2, 1, 'datapi', '2013-06-06 16:18:05', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-18-05_51b10a9dc35bf.pdf'),
489(99, 14, 2, 1, 1, 'datapi', '2013-06-06 16:18:40', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-18-39_51b10abfeab65.pdf'),
490(100, 14, 2, 2, 1, 'datapi', '2013-06-06 16:18:40', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-18-39_51b10abfeab65.pdf'),
491(101, 14, 2, 1, 1, 'datapi', '2013-06-06 16:22:59', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-22-59_51b10bc38cefe.pdf'),
492(102, 14, 2, 2, 1, 'datapi', '2013-06-06 16:22:59', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-22-59_51b10bc38cefe.pdf'),
493(103, 14, 2, 1, 1, 'datapi', '2013-06-06 16:32:32', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-32-32_51b10e007bdda.pdf'),
494(104, 14, 2, 2, 1, 'datapi', '2013-06-06 16:32:32', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-32-32_51b10e007bdda.pdf'),
495(105, 14, 2, 1, 1, 'datapi', '2013-06-06 16:33:41', 'http://localhost/datapi_work/wsms/branches/RB-1.0.0/codeigniter/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-33-41_51b10e453979f.pdf'),
496(106, 14, 2, 2, 1, 'datapi', '2013-06-06 16:33:41', 'http://localhost/datapi_work/wsms/branches/RB-1.0.0/codeigniter/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-33-41_51b10e453979f.pdf'),
497(107, 14, 2, 1, 1, 'datapi', '2013-06-06 16:34:10', 'http://localhost/datapi_work/wsms/branches/RB-1.0.0/codeigniter/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-34-10_51b10e6212eb9.pdf'),
498(108, 14, 2, 2, 1, 'datapi', '2013-06-06 16:34:10', 'http://localhost/datapi_work/wsms/branches/RB-1.0.0/codeigniter/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-34-10_51b10e6212eb9.pdf'),
499(109, 14, 2, 1, 1, 'datapi', '2013-06-06 16:36:35', 'http://localhost/datapi_work/wsms/branches/RB-1.0.0/codeigniter/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-36-35_51b10ef36a024.pdf'),
500(110, 14, 2, 2, 1, 'datapi', '2013-06-06 16:36:35', 'http://localhost/datapi_work/wsms/branches/RB-1.0.0/codeigniter/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-36-35_51b10ef36a024.pdf'),
501(111, 14, 2, 1, 1, 'datapi', '2013-06-06 16:39:11', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-39-11_51b10f8f3255f.pdf'),
502(112, 14, 2, 2, 1, 'datapi', '2013-06-06 16:39:11', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-39-11_51b10f8f3255f.pdf'),
503(113, 14, 2, 1, 1, 'datapi', '2013-06-06 16:40:27', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-40-27_51b10fdb14ae4.pdf'),
504(114, 14, 2, 2, 1, 'datapi', '2013-06-06 16:40:27', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-40-27_51b10fdb14ae4.pdf'),
505(115, 14, 2, 1, 1, 'datapi', '2013-06-06 16:40:47', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-40-47_51b10fefbd239.pdf'),
506(116, 14, 2, 2, 1, 'datapi', '2013-06-06 16:40:47', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-40-47_51b10fefbd239.pdf'),
507(117, 14, 2, 1, 1, 'datapi', '2013-06-06 16:43:32', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-43-32_51b11094b4b7c.pdf'),
508(118, 14, 2, 2, 1, 'datapi', '2013-06-06 16:43:32', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-43-32_51b11094b4b7c.pdf'),
509(119, 14, 2, 1, 1, 'datapi', '2013-06-06 16:46:12', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-46-12_51b11134127ad.pdf'),
510(120, 14, 2, 2, 1, 'datapi', '2013-06-06 16:46:12', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-46-12_51b11134127ad.pdf'),
511(121, 14, 2, 1, 1, 'datapi', '2013-06-06 16:53:18', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-53-17_51b112ddf2c06.pdf'),
512(122, 14, 2, 2, 1, 'datapi', '2013-06-06 16:53:18', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-53-17_51b112ddf2c06.pdf'),
513(123, 14, 2, 1, 1, 'datapi', '2013-06-06 16:55:53', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-55-52_51b11378ec181.pdf'),
514(124, 14, 2, 2, 1, 'datapi', '2013-06-06 16:55:53', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_16-55-52_51b11378ec181.pdf'),
515(125, 14, 2, 1, 1, 'datapi', '2013-06-06 17:44:26', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_17-44-26_51b11edaaf8b4.pdf'),
516(126, 14, 2, 2, 1, 'datapi', '2013-06-06 17:44:26', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_17-44-26_51b11edaaf8b4.pdf'),
517(127, 14, 2, 1, 1, 'datapi', '2013-06-06 17:49:10', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_17-49-10_51b11ff63271e.pdf'),
518(128, 14, 2, 2, 1, 'datapi', '2013-06-06 17:49:10', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_17-49-10_51b11ff63271e.pdf'),
519(129, 14, 2, 1, 1, 'datapi', '2013-06-06 18:06:44', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-06-43_51b12413db628.pdf'),
520(130, 14, 2, 2, 1, 'datapi', '2013-06-06 18:06:44', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-06-43_51b12413db628.pdf'),
521(131, 14, 2, 1, 1, 'datapi', '2013-06-06 18:07:58', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-07-58_51b1245e8f8c3.pdf'),
522(132, 14, 2, 2, 1, 'datapi', '2013-06-06 18:07:58', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-07-58_51b1245e8f8c3.pdf'),
523(133, 14, 2, 1, 1, 'datapi', '2013-06-06 18:09:01', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-09-01_51b1249d2d959.pdf'),
524(134, 14, 2, 2, 1, 'datapi', '2013-06-06 18:09:01', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-09-01_51b1249d2d959.pdf'),
525(135, 14, 2, 1, 1, 'datapi', '2013-06-06 18:18:52', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-18-52_51b126ec9af97.pdf'),
526(136, 14, 2, 2, 1, 'datapi', '2013-06-06 18:18:52', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-18-52_51b126ec9af97.pdf'),
527(137, 14, 2, 1, 1, 'datapi', '2013-06-06 18:19:30', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-19-30_51b127128ad3a.pdf'),
528(138, 14, 2, 2, 1, 'datapi', '2013-06-06 18:19:30', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-19-30_51b127128ad3a.pdf'),
529(139, 14, 2, 1, 1, 'datapi', '2013-06-06 18:28:05', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-28-05_51b12915b1824.pdf'),
530(140, 14, 2, 2, 1, 'datapi', '2013-06-06 18:28:05', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-28-05_51b12915b1824.pdf'),
531(141, 14, 2, 1, 1, 'datapi', '2013-06-06 18:45:32', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-45-32_51b12d2cc2817.pdf'),
532(142, 14, 2, 2, 1, 'datapi', '2013-06-06 18:45:32', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-45-32_51b12d2cc2817.pdf'),
533(143, 14, 2, 1, 1, 'datapi', '2013-06-06 18:50:05', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-50-05_51b12e3d183fa.pdf'),
534(144, 14, 2, 2, 1, 'datapi', '2013-06-06 18:50:05', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-50-05_51b12e3d183fa.pdf'),
535(145, 14, 2, 1, 1, 'datapi', '2013-06-06 18:51:15', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-51-15_51b12e835ee90.pdf'),
536(146, 14, 2, 2, 1, 'datapi', '2013-06-06 18:51:15', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-51-15_51b12e835ee90.pdf'),
537(147, 14, 2, 1, 1, 'datapi', '2013-06-06 18:57:31', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-57-31_51b12ffb1738c.pdf'),
538(148, 14, 2, 2, 1, 'datapi', '2013-06-06 18:57:31', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-57-31_51b12ffb1738c.pdf'),
539(149, 14, 2, 1, 1, 'datapi', '2013-06-06 18:59:21', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-59-21_51b130692ee80.pdf'),
540(150, 14, 2, 2, 1, 'datapi', '2013-06-06 18:59:21', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-06_18-59-21_51b130692ee80.pdf'),
541(151, 57, 1, 6, 1, 'class_assignment', '2013-06-09 00:53:17', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/brit-teach_57_2013-06-09_00-53-17_51b4265d655a0.pdf'),
542(152, 57, 1, 6, 1, 'class_assignment', '2013-06-09 01:04:32', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/brit-teach_57_2013-06-09_01-04-31_51b428fff2378.pdf'),
543(153, 57, 1, 6, 1, 'class_assignment', '2013-06-09 01:04:47', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/brit-teach_57_2013-06-09_01-04-47_51b4290f79e10.pdf'),
544(154, 57, 1, 6, 1, 'class_assignment', '2013-06-09 01:07:55', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/brit-teach_57_2013-06-09_01-07-55_51b429cb7b6d2.pdf'),
545(155, 14, 2, 1, 1, 'datapi', '2013-06-13 14:47:56', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-13_14-47-56_51ba2ffc69d6b.pdf'),
546(156, 14, 2, 1, 1, 'datapi', '2013-06-14 16:04:21', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_16-04-21_51bb936508a45.pdf'),
547(157, 14, 2, 1, 1, 'datapi', '2013-06-14 16:08:01', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_16-08-01_51bb94412f32b.pdf'),
548(158, 14, 2, 1, 1, 'datapi', '2013-06-14 16:10:39', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_16-10-38_51bb94dee879d.pdf'),
549(159, 14, 2, 1, 1, 'datapi', '2013-06-14 16:14:30', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_16-14-30_51bb95c63a1da.pdf'),
550(160, 14, 2, 1, 1, 'datapi', '2013-06-14 16:18:55', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_16-18-55_51bb96cf550a5.pdf'),
551(161, 14, 2, 1, 1, 'datapi', '2013-06-14 16:30:54', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_16-30-54_51bb999e0e931.pdf'),
552(162, 14, 2, 1, 1, 'datapi', '2013-06-14 17:23:22', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_17-23-22_51bba5ea48074.pdf'),
553(163, 14, 2, 1, 1, 'datapi', '2013-06-14 17:41:10', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_17-41-10_51bbaa167d803.pdf'),
554(164, 14, 2, 1, 1, 'datapi', '2013-06-14 17:43:26', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_17-43-26_51bbaa9e57d84.pdf'),
555(165, 14, 2, 1, 1, 'datapi', '2013-06-14 17:45:26', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_17-45-26_51bbab163797a.pdf'),
556(166, 14, 2, 1, 1, 'datapi', '2013-06-14 17:46:29', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_17-46-29_51bbab554f285.pdf'),
557(167, 14, 2, 1, 1, 'datapi', '2013-06-14 17:47:49', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_17-47-49_51bbaba502741.pdf'),
558(168, 14, 2, 1, 1, 'datapi', '2013-06-14 17:53:20', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_17-53-19_51bbacefecdf0.pdf'),
559(169, 14, 2, 1, 1, 'datapi', '2013-06-14 17:53:57', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_17-53-57_51bbad1511a76.pdf'),
560(170, 14, 2, 1, 1, 'datapi', '2013-06-14 17:56:13', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_17-56-13_51bbad9dd05e0.pdf'),
561(171, 14, 2, 1, 1, 'datapi', '2013-06-14 17:58:14', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_17-58-14_51bbae16a8353.pdf'),
562(172, 14, 2, 1, 1, 'datapi', '2013-06-14 18:00:10', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_18-00-10_51bbae8ab50a2.pdf'),
563(173, 14, 2, 1, 1, 'datapi', '2013-06-14 18:16:01', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_18-16-01_51bbb24141b9d.pdf'),
564(174, 14, 2, 1, 1, 'datapi', '2013-06-14 18:20:43', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_18-20-42_51bbb35af0be5.pdf'),
565(175, 14, 2, 1, 1, 'datapi', '2013-06-14 18:24:58', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_18-24-58_51bbb45a69da7.pdf'),
566(176, 14, 2, 1, 1, 'datapi', '2013-06-14 18:27:12', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_18-27-12_51bbb4e062f7b.pdf'),
567(177, 14, 2, 1, 1, 'datapi', '2013-06-14 18:28:37', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_18-28-37_51bbb5356e756.pdf'),
568(178, 14, 2, 1, 1, 'datapi', '2013-06-14 18:30:06', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-14_18-30-06_51bbb58ec52c6.pdf'),
569(179, 14, 2, 1, 1, 'datapi', '2013-06-15 11:04:44', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-15_11-04-43_51bc9eabea499.pdf'),
570(180, 14, 2, 1, 1, 'datapi', '2013-06-15 11:12:45', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-15_11-12-45_51bca08d210a4.pdf'),
571(181, 14, 2, 1, 1, 'datapi', '2013-06-15 11:18:40', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-15_11-18-40_51bca1f0018b7.pdf'),
572(182, 14, 2, 1, 1, 'datapi', '2013-06-15 11:19:06', 'http://datapi.com/datapi/live/uploads/worksheets/user_prints/teacher1_14_2013-06-15_11-19-06_51bca20a1c417.pdf');
573
574-- --------------------------------------------------------
575
576--
577-- Table structure for table `province`
578--
579
580DROP TABLE IF EXISTS `province`;
581CREATE TABLE IF NOT EXISTS `province` (
582 `id` int(11) NOT NULL,
583 `province_name` varchar(200) NOT NULL,
584 `country_id` int(11) NOT NULL,
585 PRIMARY KEY (`id`)
586) ENGINE=MyISAM DEFAULT CHARSET=utf8;
587
588--
589-- Dumping data for table `province`
590--
591
592INSERT INTO `province` (`id`, `province_name`, `country_id`) VALUES
593(6, 'Northwest Territories', 0),
594(5, 'Newfoundland', 0),
595(4, 'New Brunswick', 0),
596(3, 'Manitoba', 0),
597(2, 'British Columbia', 0),
598(1, 'Alberta', 0),
599(7, 'Nova Scotia', 0),
600(8, 'Ontario', 0),
601(9, 'Prince Edward Island', 0),
602(10, 'Quebec', 0),
603(11, 'Saskatchewan', 0),
604(12, 'Yukon Territory', 0),
605(13, 'Alaska', 1),
606(14, 'Alabama', 1),
607(15, 'American Samoa', 1),
608(16, 'Arizona', 1),
609(17, 'Arkansas', 1),
610(18, 'California', 1),
611(19, 'Colorado', 1),
612(20, 'Connecticut', 1),
613(21, 'Delaware', 1),
614(22, 'District of Columbia', 1),
615(23, 'Federated States of Micronesia', 1),
616(24, 'Florida', 1),
617(25, 'Georgia', 1),
618(26, 'Guam', 1),
619(27, 'Hawaii', 1),
620(28, 'Idaho', 1),
621(29, 'Illinois', 1),
622(30, 'Indiana', 1),
623(31, 'Iowa', 1),
624(32, 'Kansas', 1),
625(33, 'Kentucky', 1),
626(34, 'Louisiana', 1),
627(35, 'Maine', 1),
628(36, 'Marshall Islands', 1),
629(37, 'Maryland', 1),
630(38, 'Massachusetts', 1),
631(39, 'Michigan', 1),
632(40, 'Minnesota', 1),
633(41, 'Mississippi', 1),
634(42, 'Missouri', 1),
635(43, 'Montana', 1),
636(44, 'Nebraska', 1),
637(45, 'Nevada', 1),
638(46, 'New Hampshire', 1),
639(47, 'New Jersey', 1),
640(48, 'New Mexico', 1),
641(49, 'New York', 1),
642(50, 'North Carolina', 1),
643(51, 'North Dakota', 1),
644(52, 'Northern Mariana Islands', 1),
645(53, 'Ohio', 1),
646(54, 'Oklahoma', 1),
647(55, 'Oregon', 1),
648(56, 'Palau', 1),
649(57, 'Pennsylvania', 1),
650(58, 'Puerto Rico', 1),
651(59, 'Rhode Island', 1),
652(60, 'South Carolina', 1),
653(61, 'South Dakota', 1),
654(62, 'Tennessee', 1),
655(63, 'Texas', 1),
656(64, 'Utah', 1),
657(65, 'Vermont', 1),
658(66, 'Virgin Islands', 1),
659(67, 'Virginia', 1),
660(68, 'Washington', 1),
661(69, 'West Virginia', 1),
662(70, 'Wisconsin', 1),
663(71, 'Wyoming', 1),
664(72, 'Armed Forces Africa', 1),
665(73, 'Armed Forces Americas (except Canada)', 1),
666(74, 'Armed Forces Canada', 1),
667(75, 'Armed Forces Europe', 1),
668(76, 'Armed Forces Middle East', 1),
669(77, 'Armed Forces Pacific', 1);
670
671-- --------------------------------------------------------
672
673--
674-- Table structure for table `purchases`
675--
676
677DROP TABLE IF EXISTS `purchases`;
678CREATE TABLE IF NOT EXISTS `purchases` (
679 `pid` int(10) NOT NULL AUTO_INCREMENT,
680 `uid` int(10) NOT NULL DEFAULT '0',
681 `worksheet_id` int(10) NOT NULL DEFAULT '0',
682 `page_num` int(10) NOT NULL DEFAULT '0',
683 `qty_purchased` int(10) NOT NULL DEFAULT '0',
684 `unit_cost` int(10) NOT NULL,
685 `purchased_time` datetime NOT NULL,
686 `last_updated` datetime NOT NULL,
687 `updated_by` int(10) DEFAULT '0',
688 `qty_used` int(11) NOT NULL DEFAULT '0',
689 `spending_id` int(11) NOT NULL,
690 `created_datetime` datetime NOT NULL,
691 `created_by` int(11) NOT NULL,
692 PRIMARY KEY (`pid`),
693 KEY `purchases_user` (`uid`),
694 KEY `purchases_worksheet` (`worksheet_id`)
695) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
696
697-- --------------------------------------------------------
698
699--
700-- Table structure for table `schools`
701--
702
703DROP TABLE IF EXISTS `schools`;
704CREATE TABLE IF NOT EXISTS `schools` (
705 `sid` int(10) NOT NULL AUTO_INCREMENT,
706 `principal_id` int(10) NOT NULL,
707 `name` varchar(64) NOT NULL,
708 `logo` varchar(120) DEFAULT NULL,
709 `type` varchar(64) DEFAULT NULL,
710 `phone_number` varchar(16) NOT NULL,
711 `address` varchar(32) NOT NULL,
712 `city` varchar(32) NOT NULL,
713 `province_state` varchar(16) NOT NULL,
714 `postal_code` varchar(8) NOT NULL,
715 `country` varchar(56) NOT NULL,
716 `website` varchar(120) DEFAULT NULL,
717 `create_datetime` datetime NOT NULL,
718 `description` varchar(500) NOT NULL,
719 `active` int(11) NOT NULL,
720 `email` varchar(100) NOT NULL,
721 PRIMARY KEY (`sid`),
722 UNIQUE KEY `name` (`name`),
723 KEY `school_user` (`principal_id`)
724) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
725
726--
727-- Dumping data for table `schools`
728--
729
730INSERT INTO `schools` (`sid`, `principal_id`, `name`, `logo`, `type`, `phone_number`, `address`, `city`, `province_state`, `postal_code`, `country`, `website`, `create_datetime`, `description`, `active`, `email`) VALUES
731(11, 16, 'school1', NULL, '', '3242', '43fds', 'fds', '7', '342vscv', 'US', '', '0000-00-00 00:00:00', '', 0, 'school1@gmail.com'),
732(12, 55, 'Britannia', '', '1', '6041112222', '1234 Main St', 'Vancouver', '2', 'V5X 1E8', '0', '', '2013-05-15 23:05:48', '', 1, '1234@datapi.com'),
733(1, 2, 'Crofton House School', NULL, NULL, '6042633255', '3200 West 41st Avenue', 'Vancouver', 'British Columbia', 'V6N 3E1', 'Canada', NULL, '2013-05-15 00:00:00', '', 1, 'admin@crofton.com');
734
735-- --------------------------------------------------------
736
737--
738-- Table structure for table `school_teacher`
739--
740
741DROP TABLE IF EXISTS `school_teacher`;
742CREATE TABLE IF NOT EXISTS `school_teacher` (
743 `stid` int(10) NOT NULL AUTO_INCREMENT,
744 `school_id` int(10) NOT NULL,
745 `teacher_id` int(10) NOT NULL,
746 `joined_time` datetime NOT NULL,
747 PRIMARY KEY (`stid`),
748 UNIQUE KEY `school_id_teacher_id` (`school_id`,`teacher_id`),
749 KEY `school_teacher_teacher_user` (`teacher_id`)
750) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
751
752--
753-- Dumping data for table `school_teacher`
754--
755
756INSERT INTO `school_teacher` (`stid`, `school_id`, `teacher_id`, `joined_time`) VALUES
757(11, 12, 57, '2013-05-16 00:05:46'),
758(9, 11, 54, '2013-05-15 17:05:15');
759
760-- --------------------------------------------------------
761
762--
763-- Table structure for table `spendings`
764--
765
766DROP TABLE IF EXISTS `spendings`;
767CREATE TABLE IF NOT EXISTS `spendings` (
768 `spid` int(10) NOT NULL AUTO_INCREMENT,
769 `user_id` int(10) NOT NULL DEFAULT '0',
770 `app_id` int(3) NOT NULL DEFAULT '0',
771 `num_credits` int(3) NOT NULL DEFAULT '0',
772 `child_table` text NOT NULL,
773 `child_id` text NOT NULL,
774 `created_by` int(10) NOT NULL,
775 `last_updated_by` int(10) DEFAULT NULL,
776 `created_time` datetime NOT NULL,
777 `last_updated_time` datetime DEFAULT NULL,
778 PRIMARY KEY (`spid`)
779) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
780
781-- --------------------------------------------------------
782
783--
784-- Table structure for table `transactions`
785--
786
787DROP TABLE IF EXISTS `transactions`;
788CREATE TABLE IF NOT EXISTS `transactions` (
789 `tid` int(10) NOT NULL AUTO_INCREMENT,
790 `uid` int(10) NOT NULL,
791 `transaction_time` datetime NOT NULL,
792 `amount` float NOT NULL,
793 `tax` float NOT NULL,
794 `num_credit` int(10) NOT NULL,
795 `currency` varchar(4) NOT NULL,
796 `description` text,
797 `transaction_code` varchar(64) NOT NULL,
798 `last_updated` datetime NOT NULL,
799 `updated_by` int(10) DEFAULT NULL,
800 `app_id` int(10) NOT NULL,
801 `transaction_method` varchar(16) NOT NULL,
802 PRIMARY KEY (`tid`),
803 KEY `transaction_buyer` (`uid`),
804 KEY `transaction_updater` (`updated_by`)
805) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;
806
807--
808-- Dumping data for table `transactions`
809--
810
811INSERT INTO `transactions` (`tid`, `uid`, `transaction_time`, `amount`, `tax`, `num_credit`, `currency`, `description`, `transaction_code`, `last_updated`, `updated_by`, `app_id`, `transaction_method`) VALUES
812(23, 38, '2013-01-12 15:01:03', 3, 0, 10, 'CAD', '10 DataPi Credits', '93V09495DW054293T', '2013-01-12 15:01:03', NULL, 0, 'PayPal'),
813(20, 50, '2013-01-12 15:01:57', 10, 0, 40, 'CAD', '40 DataPi Credits', '73G05837G64188742', '2013-01-12 15:01:57', NULL, 0, 'PayPal'),
814(21, 50, '2013-01-12 15:01:26', 15, 0, 60, 'CAD', '60 DataPi Credits', '3HF59700AS386722T', '2013-01-12 15:01:26', NULL, 0, 'PayPal'),
815(22, 38, '2013-01-12 15:01:48', 3, 0, 10, 'CAD', '10 DataPi Credits', '5MY30564XF8273516', '2013-01-12 15:01:48', NULL, 0, 'PayPal'),
816(7, 38, '2013-01-12 14:01:10', 6, 0, 20, 'CAD', '20 DataPi Credits', '01182241PD479162W', '2013-01-12 14:01:10', NULL, 0, 'PayPal'),
817(19, 50, '2013-01-12 15:01:46', 15, 0, 60, 'CAD', '60 DataPi Credits', '6A412399EV209073M', '2013-01-12 15:01:46', NULL, 0, 'PayPal'),
818(9, 38, '2013-01-12 14:01:27', 10, 0, 40, 'CAD', '40 DataPi Credits', '8JB79498ER549253R', '2013-01-12 14:01:27', NULL, 0, 'PayPal'),
819(18, 50, '2013-01-12 14:01:21', 10, 0, 40, 'CAD', '40 DataPi Credits', '8T919218K0369914R', '2013-01-12 14:01:21', NULL, 0, 'PayPal'),
820(11, 38, '2013-01-12 14:01:19', 15, 0, 60, 'CAD', '60 DataPi Credits', '6DC520838A755315G', '2013-01-12 14:01:19', NULL, 0, 'PayPal'),
821(17, 50, '2013-01-12 14:01:09', 10, 0, 40, 'CAD', '40 DataPi Credits', '6D632240WX259033G', '2013-01-12 14:01:09', NULL, 0, 'PayPal'),
822(16, 50, '2013-01-12 14:01:46', 6, 0, 20, 'CAD', '20 DataPi Credits', '1N4911564V088800F', '2013-01-12 14:01:46', NULL, 0, 'PayPal'),
823(15, 50, '2013-01-12 14:01:25', 3, 0, 10, 'CAD', '10 DataPi Credits', '95A87774RR481283H', '2013-01-12 14:01:25', NULL, 0, 'PayPal'),
824(24, 38, '2013-01-12 16:01:17', 3, 0, 10, 'CAD', '10 DataPi Credits', '2RJ23075KC240940F', '2013-01-12 16:01:17', NULL, 0, 'PayPal'),
825(25, 38, '2013-01-19 12:01:59', 6, 0, 20, 'CAD', '20 DataPi Credits', '88X34365H9006401H', '2013-01-19 12:01:59', NULL, 0, 'PayPal'),
826(26, 38, '2013-01-19 12:01:22', 10, 0, 40, 'CAD', '40 DataPi Credits', '0XG34897UN587594G', '2013-01-19 12:01:22', NULL, 0, 'PayPal'),
827(27, 38, '2013-01-19 12:01:22', 3, 0, 10, 'CAD', '10 DataPi Credits', '8JB09893898306216', '2013-01-19 12:01:22', NULL, 0, 'PayPal'),
828(28, 38, '2013-01-19 12:01:40', 6, 0, 20, 'CAD', '20 DataPi Credits', '5WD35258SM294461W', '2013-01-19 12:01:40', NULL, 0, 'PayPal'),
829(29, 38, '2013-01-19 12:01:11', 10, 0, 40, 'CAD', '40 DataPi Credits', '45A01410AD737032G', '2013-01-19 12:01:11', NULL, 0, 'PayPal'),
830(30, 38, '2013-01-19 14:01:55', 3, 0, 10, 'CAD', '10 DataPi Credits', '08G191926W358080L', '2013-01-19 14:01:55', NULL, 0, 'PayPal'),
831(31, 38, '2013-01-19 14:01:11', 6, 0, 20, 'CAD', '20 DataPi Credits', '17N85634L7864023A', '2013-01-19 14:01:11', NULL, 0, 'PayPal'),
832(32, 50, '2013-01-19 14:00:24', 15, 0, 60, 'CAD', '60 DataPi Credits', '99Y95309940588237', '2013-01-19 15:01:30', NULL, 0, 'PayPal'),
833(33, 50, '2013-01-19 14:00:24', 20, 0, 80, 'CAD', '80 DataPi Credits', '0A1767936C423094L', '2013-01-19 15:01:30', NULL, 0, 'PayPal'),
834(34, 50, '2013-01-19 14:00:22', 3, 0, 10, 'CAD', '10 DataPi Credits', '7E392520D78737728', '2013-01-19 15:01:27', NULL, 0, 'PayPal'),
835(35, 50, '2013-01-19 14:55:48', 6, 0, 20, 'CAD', '20 DataPi Credits', '8P133678AW782002E', '2013-01-19 15:55:54', NULL, 0, 'PayPal'),
836(36, 31, '2013-01-26 11:01:41', 10, 0, 40, 'CAD', '40 DataPi Credits', '2D761869EB151952K', '2013-01-26 12:01:53', NULL, 0, 'PayPal'),
837(37, 31, '2013-01-26 11:03:11', 3, 0, 10, 'CAD', '10 DataPi Credits', '2KJ69451WN493170K', '2013-01-26 12:03:16', NULL, 0, 'PayPal');
838
839-- --------------------------------------------------------
840
841--
842-- Table structure for table `users`
843--
844
845DROP TABLE IF EXISTS `users`;
846CREATE TABLE IF NOT EXISTS `users` (
847 `uid` int(10) NOT NULL AUTO_INCREMENT,
848 `aid` int(10) NOT NULL DEFAULT '0',
849 `email` varchar(64) NOT NULL,
850 `user_name` varchar(16) NOT NULL,
851 `acc_confirmation` tinyint(10) NOT NULL DEFAULT '0',
852 `active` tinyint(10) NOT NULL DEFAULT '0',
853 `banned` tinyint(4) NOT NULL DEFAULT '0',
854 `password` varchar(32) NOT NULL,
855 `conf_hash` varchar(96) NOT NULL,
856 `credit` int(10) NOT NULL DEFAULT '0',
857 `last_login` datetime NOT NULL,
858 `last_updated` datetime NOT NULL,
859 `first_name` varchar(32) NOT NULL,
860 `last_name` varchar(32) NOT NULL,
861 `home_phone` varchar(16) DEFAULT NULL,
862 `cell_phone` varchar(16) DEFAULT NULL,
863 `gender` varchar(8) DEFAULT NULL,
864 `birthday` date DEFAULT NULL,
865 `address` varchar(32) DEFAULT NULL,
866 `city` varchar(32) DEFAULT NULL,
867 `province_state` varchar(16) DEFAULT NULL,
868 `postal_code` varchar(8) DEFAULT NULL,
869 `country` varchar(56) DEFAULT NULL,
870 `profile_picture` varchar(120) DEFAULT NULL,
871 `joined_time` datetime NOT NULL,
872 PRIMARY KEY (`uid`),
873 UNIQUE KEY `user_name` (`user_name`),
874 UNIQUE KEY `aid_email` (`aid`,`email`)
875) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=58 ;
876
877--
878-- Dumping data for table `users`
879--
880
881INSERT INTO `users` (`uid`, `aid`, `email`, `user_name`, `acc_confirmation`, `active`, `banned`, `password`, `conf_hash`, `credit`, `last_login`, `last_updated`, `first_name`, `last_name`, `home_phone`, `cell_phone`, `gender`, `birthday`, `address`, `city`, `province_state`, `postal_code`, `country`, `profile_picture`, `joined_time`) VALUES
882(7, 0, 'g5.binhht@gmail.com', 'binhht', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '4e5912c42c800fe', 0, '2013-01-23 01:01:18', '2012-09-11 20:09:55', 'Binh', 'Hoang', '04343444444', '8169834545', 'male', '2012-05-01', 'sadsadsad\\ndsadsad Pham Van Ngh', 'sadsad', '3', '34343', '1', 'http://wsms.boostik.com/codeigniter/uploads/Koala.jpg', '2012-10-12 00:00:00'),
883(8, 0, 'aaa@ddd.com', 'parent', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '51fc1ef533d2281', 0, '2012-08-23 22:08:42', '2012-08-22 02:08:47', 'Binh', 'Hoang', '816983', '0989079805', 'male', '2012-05-01', 'sadsadsad\\ndsadsad Pham Van Ngh', 'sadsad', '3', '34343', '1', 'http://localhost/datapi-worksheet/codeigniter/uploads/crossword-answers.jpg', '2012-10-12 00:00:00'),
884(9, 0, 'aaa@aaa.com', 'thangnv', 0, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '1f7e0c658bd1f32', 0, '0000-00-00 00:00:00', '2012-08-25 23:08:45', 'thang', 'nguyen', '34324324', '', 'male', '2012-08-01', 'sadsadsad\\nsdsad', '334324', '4', '343434', '2', 'http://localhost/datapi-worksheet/codeigniter/uploads/Blue_hills.jpg', '2012-10-12 00:00:00'),
885(10, 0, 'asd@sdsad.com', 'ssdsadsa', 0, 1, 0, '5d793fc5b00a2348c3fb9ab59e5ca98a', '1df034f532be197', 0, '0000-00-00 00:00:00', '2012-08-26 00:08:46', 'sdsadsad', 'sdsd', '3432432', '', 'male', '2012-08-16', '3r432432\\n', '34234', '1', '23432434', '1', '', '2012-10-12 00:00:00'),
886(38, 0, 'jimmyhuang98@yahoo.com', 'jhuang', 1, 1, 0, 'ae2b1fca515949e5d54fb22b8ed95575', '742ad506922339e', 207, '2013-06-08 20:06:17', '2012-10-20 13:10:49', 'Jimmy', 'Huang', '6043334444', '', 'male', '1993-10-11', '123 Main St\\n', 'Vancouver', '8', 'v6a2g3', '0', 'http://www.matrox.com/graphics/media/image/products/gxm/dualhead2go_digital.jpg', '2012-10-12 00:00:00'),
887(12, 0, 'viet.thangdng@gmail.com', 'thangnguyen', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '01e114c244f36c0', 0, '2013-02-20 07:02:04', '2013-01-31 06:01:31', 'Woody', 'Woodpecker', '(123) 123-1234', '', 'male', '1985-02-15', '123 King road ok\\n', 'Vancouver', '8', '123', '0', 'http://wsms.boostik.com/codeigniter/uploads/avatar1.JPG', '2012-10-12 00:00:00'),
888(13, 0, 'tytdng@yahoo.ca', 'member1', 0, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '164a2c7c0197da2', 0, '0000-00-00 00:00:00', '2012-09-04 10:09:31', 'member', '1', '1222222222222222', '', 'female', '2012-09-02', '1 street\\n', 'Texas', '4', '1', '2', 'data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAkGBwgHBgkIBwgKCgkLDRYPDQwMDRsUFRAWIB0iIiAdHx8kKDQsJCYxJx8fLT0tM', '2012-10-12 00:00:00'),
889(14, 1, 'teacher1@gmail.com', 'teacher1', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '', 0, '2013-06-15 11:06:25', '2013-01-23 05:01:49', 'Teacher', 'abc', '(123) 123-1235', '(123) 123-1234', 'male', '2012-10-05', '123 King road\\n', 'Vancouver', '8', '12dsd', '0', 'http://wsms.boostik.com/codeigniter/uploads/logo2.png', '2012-10-12 00:00:00'),
890(15, 1, 'teacher2@gmail.com', 'teacher2', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '', 0, '2013-01-27 20:01:31', '2012-10-10 09:10:46', 'Teacher', '2', '1234', '', 'female', '2003-10-02', '123 Nguyen Viet Thang\\n', 'abcd', '7', '123dcb', '0', 'http://wsms.boostik.com/codeigniter/uploads/test1.GIF', '2012-10-12 00:00:00'),
891(16, 2, 'school1@gmail.com', 'school1', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '', 0, '2013-05-15 19:05:16', '0000-00-00 00:00:00', 'School', '1', '3242', NULL, 'female', '2012-10-17', '43fds', 'fds', '7', '342vscv', 'US', NULL, '2012-10-12 00:00:00'),
892(17, 2, 'school2@gmail.com', 'school2', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '', 0, '2013-05-15 15:05:15', '0000-00-00 00:00:00', 'School', '2', '432432', NULL, 'male', '2012-10-10', '312', 'DN', '7', 'fdsaf34', 'VN', NULL, '2012-10-12 00:00:00'),
893(18, 3, 'datapi@gmail.com', 'admin', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '', 0, '2013-05-27 17:05:34', '2012-12-19 18:12:45', 'DataPi', 'Administrator', '', '', 'female', '2012-11-03', '\\n', '', '7', '', '0', 'http://wsms.boostik.com/codeigniter/uploads/logo5.png', '2012-10-12 00:00:00'),
894(19, 0, 'jtantongco@gmail.com', 'jtantongco', 1, 1, 0, '29bc98e7d0fc8a24d7e5758d2a365c5c', '2994ca736878735', 0, '2012-09-22 15:09:07', '2012-09-09 20:09:50', 'Jeremiah', 'Tantongco', '', '6047271590', 'male', '2012-04-29', '4731 Westminster Highway\\n', 'Richmond', '5', '123456', '2', '', '2012-10-12 00:00:00'),
895(20, 0, 'thangnguyen@chotintuc.com', 'test1', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '94a6b5ed2871f31', 0, '2013-03-07 07:03:40', '2012-11-26 09:11:26', 'test1', 'Thang', '', '123', 'male', '2012-09-04', '123 King road\\n', 'Austin', '4', '123', '2', 'http://wsms.boostik.com/codeigniter/uploads/avatar2.JPG', '2012-10-12 00:00:00'),
896(31, 0, 'registertotest@gmail.com', 'ngan', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '20a261b31861aef', 50, '2013-06-15 11:06:03', '2013-01-26 15:01:33', 'First', 'Last', '(604) 778-8899', '', '', '2012-12-12', '\\n', '', '', '', '-1', 'http://wsms.boostik.com/codeigniter/uploads/totoro2.JPG', '2012-10-12 00:00:00'),
897(42, 0, 'boostik.testing@gmail.com', 'ngan2', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '12b2fd3ed61189b', 0, '2013-01-24 13:01:39', '2012-12-21 13:12:36', 'abcdefghijklmnopqrstuvwxyz', 'abcdefghijklmnopqrstuvwxyz', '', '', '', '2012-12-21', '\\n', '', '', '', '-1', '', '2012-12-18 20:12:08'),
898(22, 3, 'woodpecker.operator@gmail.com', 'thang_admin', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', 'a7153d249c3bed8', 0, '2013-01-04 19:01:34', '2012-12-17 09:12:32', 'Thang', 'Admin', '(123) 123-4567', '', 'male', '2012-02-15', '123 Nguyen Viet Thang\\n', 'Austin', '4', '123', '2', 'http://www.awn.com/files/imagepicker/1/sito02_WoodyWoodpecker.gif', '2012-10-12 00:00:00'),
899(23, 0, 'meenmaker@gmail.com', 'xxxx', 0, 0, 0, 'e10adc3949ba59abbe56e057f20f883e', '32e917773bf481c', 0, '0000-00-00 00:00:00', '2012-09-18 18:09:04', 'test', 'plan', '123', '', 'male', '2012-09-18', 'v\\n', 'gangnam', '1', '123645', '1', '', '2012-10-12 00:00:00'),
900(39, 0, 'jimmyhuang000@gmail.com', 'jhuang1', 1, 1, 0, 'ae2b1fca515949e5d54fb22b8ed95575', 'cbdb5c7cdfe8b3b', 0, '2013-04-20 15:04:05', '2012-10-20 13:10:58', 'Jimmy1', 'Huang1', '12345678910000', '3334445555', 'male', '1996-04-09', '222 Pender St\\n', 'Vancouver', '8', 'v6a2g3', '0', '', '2012-10-12 00:00:00'),
901(32, 2, 'rsss@cas.com', 'LQD-DN', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '0d4a1c87ca44d3f', 0, '0000-00-00 00:00:00', '2012-10-04 11:10:21', 'Le Quy Don', 'school', '0989079805', NULL, 'male', NULL, 'Le Loi\\nHai Chau', 'Da Nang', '3', '23213', '1', '', '2012-10-12 00:00:00'),
902(30, 0, 'killer123@yahoo.com', 'Kim Nguyen', 0, 0, 0, '95aaa259ebcae81e6fa6fd30f0c84d62', '4fdf32d8e1f9605', 0, '0000-00-00 00:00:00', '2012-09-29 11:09:40', 'Kim', 'Nguyen', '', '778123456', 'male', '1986-03-20', 'Terminal\\n', 'Vancouver', '8', 'V1N 1Y1', '0', '', '2012-10-12 00:00:00'),
903(33, 2, 'bot_00_002@yahoo.com.vn', 'thang_school_tes', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', 'fbd8184b268a407', 0, '2012-11-27 07:11:29', '2012-10-05 07:10:29', 'thang_school_test', 'school', '1213', NULL, 'male', NULL, '121\\n', 'qwad', '7', '12dsd', '0', 'http://wsms.boostik.com/codeigniter/uploads/git2.JPG', '2012-10-12 00:00:00'),
904(34, 1, 'testabc@abc.com', 'teacher3', 0, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '6cbd6b5d8f4360c', 0, '0000-00-00 00:00:00', '2012-10-14 08:10:05', 'Teacher', '3', '', '123', 'male', '1988-10-12', '3\\n', 'ed', '7', '12fd', '0', '', '2012-10-12 00:00:00'),
905(35, 2, 'test@test.abc', 'school3', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', 'e17087fe38910ae', 0, '0000-00-00 00:00:00', '2012-10-14 09:10:41', 'Thang_school 3', 'school', '123654', NULL, 'male', NULL, '1234\\n', 'Toronto', '8', '12vvc', '0', 'http://wsms.boostik.com/codeigniter/uploads/Worksheet_image.jpg', '2012-10-12 00:00:00'),
906(36, 1, 'tesfdsa@fad.com', 'teacher4', 0, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '63294b26233a586', 0, '0000-00-00 00:00:00', '2012-10-17 09:10:59', 'Teacher', '4', '2331431', '', 'male', '2012-10-18', '123 King road\\n', 'ewr', '7', '12fd', '0', '', '2012-10-12 00:00:00'),
907(37, 1, 'teafd@gsf.com', 'teacher5', 0, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '39d2eb2c0c335b6', 0, '0000-00-00 00:00:00', '2012-10-19 10:10:59', 'Teacher', '5', '1431', '', 'female', '2012-10-10', '123 Nguyen Viet Thang\\n', '12fdsa', '7', '312dawa', '0', '', '2012-10-12 00:00:00'),
908(40, 0, 'abc@bca.com', 'Student', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '5d84d11093b5085', 0, '2012-11-09 18:11:54', '2012-10-27 14:10:58', 'Jane', 'Doe', '12346578954646', '', 'female', '1986-08-28', '123 abc\\n', 'somewhere', '6', '12345612', '2', '', '2012-10-12 00:00:00'),
909(41, 0, 'vinhoffer@gmail.com', 'Vinh', 1, 1, 0, 'd7cd508dbe97b2e5f09533450fa559b0', '9c4a1469a29af57', 0, '0000-00-00 00:00:00', '2012-11-26 08:11:53', 'Ho', 'vinhhq', '84123456789', '', 'male', '1986-10-25', 'K132/18 LTT\\n', 'DaNang', '3', '59000', '1', 'http://wsms.boostik.com/codeigniter/uploads/IMG_1005.JPG', '2012-11-26 08:11:53'),
910(43, 0, 'feedback@boostik.com', 'test2', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', 'e97263f2fd9e046', 0, '2012-12-21 08:12:05', '2012-12-19 08:12:51', 'thang', 'Woodpecker', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2012-12-19 08:12:51'),
911(44, 2, 'learning@datapi.com', 'school6', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '860ef9d91263458', 0, '0000-00-00 00:00:00', '2012-12-19 17:12:04', 'Catherine''s Testing Academy', 'school', '6048888688', NULL, 'male', NULL, '9876 Wonder Lane', 'Vancity', '8', 'ZZZ', '0', '', '0000-00-00 00:00:00'),
912(45, 0, 'binhhoang@magrabbit.com', 'binhhoang', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '8c0ab1ce77266c1', 0, '2012-12-20 10:12:23', '2012-12-20 09:12:14', 'Binh', 'Hoang', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2012-12-20 09:12:14'),
913(46, 2, 'a2819692@rmqkr.net', 'school7', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', '218c5b92b7b4e8d', 0, '0000-00-00 00:00:00', '2012-12-20 14:12:39', 'Test Learning Inc.', 'school', '1234567890987654', NULL, 'male', NULL, '1000 Sesame St', 'London', '7', 'XYZ', '0', '', '0000-00-00 00:00:00'),
914(47, 1, 'testing@datapi.com', 'teacher6', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', 'cd755e628903097', 0, '2012-12-21 16:12:50', '2012-12-21 16:12:01', 'Miss Atomic', 'Bomb', '9998887777', '', 'female', '2012-12-21', '100 The Killers Dr.\\n', 'New York', '6', 'IDK', '2', '', '0000-00-00 00:00:00'),
915(48, 1, 'math@datapi.com', 'teacher7', 0, 0, 0, 'e10adc3949ba59abbe56e057f20f883e', 'd60f7feaa11e31e', 0, '0000-00-00 00:00:00', '2012-12-21 15:12:55', 'Rapunzel', 'de Blonde', '', '3141592653', 'female', '1985-03-30', '3-1415 Pi Square\\n', 'Math Constants', '0', 'DEC', '0', 'http://wsms.boostik.com/codeigniter/uploads/Tulips.jpg', '0000-00-00 00:00:00'),
916(49, 1, 'a2891626@rmqkr.net', 'teacher8', 0, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', 'c1ad3485deaae16', 0, '0000-00-00 00:00:00', '2012-12-21 16:12:44', 'Mad', 'Hatter', '5556667890', '', 'male', '1975-07-09', '777 Disney Ave.\\n', 'Wonderland', '5', 'AAA', '2', '', '0000-00-00 00:00:00'),
917(51, 0, 'tantongco.family@gmail.com', 'Zigu', 1, 1, 0, 'e19d5cd5af0378da05f63f891c7467af', '28788454bb75706', 388, '2013-02-02 14:02:23', '2013-02-02 13:02:51', 'Jeremiah', 'Tantongco', '6042735157', '6047271590', NULL, NULL, NULL, NULL, 'abcd1234', NULL, NULL, NULL, '2013-02-02 13:02:51'),
918(52, 2, 'jtantongco@hotmail.com', 'JTSchool', 1, 1, 0, 'e19d5cd5af0378da05f63f891c7467af', 'ac568fb22d32c60', 0, '2013-02-02 14:02:25', '2013-02-02 14:02:43', 'Jeremiah''s School', 'school', '6042735157', NULL, 'male', NULL, '4731 Blah Street', 'Richmond', '8', 'A1B2C3', '0', '', '0000-00-00 00:00:00'),
919(53, 2, 'admin@crofton.com', '0001', 1, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', 'b8cdcbc776aece8', 0, '0000-00-00 00:00:00', '2013-05-15 15:05:10', 'Crofton House School', 'school', '6042633255', NULL, 'male', NULL, '3200 West 41st Avenue', 'Vancouver', '2', 'V6N 3E1', '0', 'http://datapi.com/wsms_uat/codeigniter/uploads/logo-crofton1.jpg', '0000-00-00 00:00:00'),
920(54, 1, 'nina@bacon.com', 'Nina', 0, 1, 0, 'e10adc3949ba59abbe56e057f20f883e', 'fac2a1581394502', 0, '0000-00-00 00:00:00', '2013-05-15 18:05:51', 'Nina', 'Bacon', '604789456', '', 'female', '1980-05-12', '772 KIngsway street\\n', 'Vancouver', '2', 'V5V 1K1', '0', 'http://us.123rf.com/400wm/400/400/lordalea/lordalea1207/lordalea120700003/14583406-frog-prince-isolated-on-white-cartoon', '0000-00-00 00:00:00'),
921(55, 2, '1234@datapi.com', 'britannia', 1, 1, 0, 'ae2b1fca515949e5d54fb22b8ed95575', '26261fac0d97aa6', 0, '2013-05-15 23:05:41', '2013-05-15 23:05:48', 'Britannia', 'school', '6041112222', NULL, 'male', NULL, '1234 Main St', 'Vancouver', '2', 'V5X 1E8', '0', '', '0000-00-00 00:00:00'),
922(57, 1, '2345@datapi.com', 'brit-teach', 1, 1, 0, 'ae2b1fca515949e5d54fb22b8ed95575', 'c37ba0ef6f17eaf', 0, '2013-06-09 00:06:07', '2013-05-16 00:05:46', 'Britannia', 'Teacher', '6042223333', '', 'male', '2013-05-01', '123 Main St\\n', 'Vancouver', '2', 'V5X 1E8', '0', '', '0000-00-00 00:00:00');
923
924-- --------------------------------------------------------
925
926--
927-- Table structure for table `user_worksheet_claims`
928--
929
930DROP TABLE IF EXISTS `user_worksheet_claims`;
931CREATE TABLE IF NOT EXISTS `user_worksheet_claims` (
932 `clid` int(10) NOT NULL AUTO_INCREMENT,
933 `uid` int(10) NOT NULL DEFAULT '0',
934 `last_claim_date` datetime DEFAULT NULL,
935 `second_last_claim_date` datetime DEFAULT NULL,
936 `last_claim_wsid` int(10) DEFAULT NULL,
937 `second_last_claim_wsid` int(10) DEFAULT NULL,
938 `last_claim_page` int(10) DEFAULT NULL,
939 `second_last_claim_page` int(10) DEFAULT NULL,
940 PRIMARY KEY (`clid`),
941 KEY `user_worksheet_claim_user_id` (`uid`),
942 KEY `user_worksheet_claim_lc_wsid` (`last_claim_wsid`),
943 KEY `user_worksheet_claim_slc_wsid` (`second_last_claim_wsid`)
944) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
945
946-- --------------------------------------------------------
947
948--
949-- Table structure for table `user_worksheet_inventory`
950--
951
952DROP TABLE IF EXISTS `user_worksheet_inventory`;
953CREATE TABLE IF NOT EXISTS `user_worksheet_inventory` (
954 `iid` int(10) NOT NULL AUTO_INCREMENT,
955 `uid` int(10) NOT NULL DEFAULT '0',
956 `worksheet_id` int(10) NOT NULL DEFAULT '0',
957 `page_num` int(10) NOT NULL DEFAULT '1',
958 `quantity` int(10) NOT NULL DEFAULT '0',
959 `inventory_type` varchar(24) NOT NULL,
960 PRIMARY KEY (`iid`),
961 KEY `user_worksheet_inventory_worksheet` (`worksheet_id`)
962) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=62 ;
963
964--
965-- Dumping data for table `user_worksheet_inventory`
966--
967
968INSERT INTO `user_worksheet_inventory` (`iid`, `uid`, `worksheet_id`, `page_num`, `quantity`, `inventory_type`) VALUES
969(61, 38, 1, 7, 1, 'class_assignment'),
970(60, 38, 1, 6, 1, 'class_assignment'),
971(59, 38, 1, 5, 0, 'class_assignment'),
972(58, 38, 1, 4, 1, 'class_assignment'),
973(57, 38, 1, 3, 0, 'class_assignment'),
974(56, 38, 1, 2, 0, 'class_assignment');
975
976-- --------------------------------------------------------
977
978--
979-- Table structure for table `user_worksheet_records`
980--
981
982DROP TABLE IF EXISTS `user_worksheet_records`;
983CREATE TABLE IF NOT EXISTS `user_worksheet_records` (
984 `rid` int(10) NOT NULL AUTO_INCREMENT,
985 `uid` int(10) NOT NULL,
986 `worksheet_id` int(10) NOT NULL,
987 `page_num` int(10) NOT NULL,
988 `score` int(10) NOT NULL,
989 `time_taken` time NOT NULL,
990 `last_updated` datetime NOT NULL,
991 `record_date` datetime NOT NULL,
992 `family_assignment` int(10) DEFAULT NULL,
993 `class_assignment` int(10) DEFAULT NULL,
994 PRIMARY KEY (`rid`),
995 KEY `user_worksheet_record_user` (`uid`),
996 KEY `user_worksheet_record_worksheet` (`worksheet_id`),
997 KEY `user_worksheet_record_afid` (`family_assignment`),
998 KEY `user_worksheet_record_acid` (`class_assignment`)
999) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
1000
1001--
1002-- Dumping data for table `user_worksheet_records`
1003--
1004
1005INSERT INTO `user_worksheet_records` (`rid`, `uid`, `worksheet_id`, `page_num`, `score`, `time_taken`, `last_updated`, `record_date`, `family_assignment`, `class_assignment`) VALUES
1006(1, 38, 1, 7, 90, '00:01:25', '2013-06-01 15:06:09', '2013-06-01 15:06:09', NULL, 11),
1007(2, 38, 1, 7, 0, '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL),
1008(3, 14, 2, 1, 4, '00:05:00', '0000-00-00 00:00:00', '2013-06-01 15:06:09', NULL, NULL),
1009(4, 14, 2, 1, 5, '00:07:00', '0000-00-00 00:00:00', '2013-06-02 14:06:09', NULL, NULL),
1010(5, 14, 2, 1, 6, '00:08:00', '0000-00-00 00:00:00', '2013-06-03 15:06:09', NULL, NULL),
1011(6, 14, 2, 1, 7, '00:05:00', '0000-00-00 00:00:00', '2013-06-06 18:43:42', NULL, NULL),
1012(7, 14, 2, 1, 8, '00:06:00', '0000-00-00 00:00:00', '2013-06-05 15:06:09', NULL, NULL),
1013(8, 14, 2, 1, 7, '00:04:00', '0000-00-00 00:00:00', '2013-06-04 15:06:09', NULL, NULL);
1014
1015-- --------------------------------------------------------
1016
1017--
1018-- Table structure for table `worksheets`
1019--
1020
1021DROP TABLE IF EXISTS `worksheets`;
1022CREATE TABLE IF NOT EXISTS `worksheets` (
1023 `wsid` int(10) NOT NULL AUTO_INCREMENT,
1024 `topic_id` int(10) NOT NULL DEFAULT '0',
1025 `creator_id` int(10) NOT NULL DEFAULT '0',
1026 `section_name` varchar(48) NOT NULL DEFAULT '0',
1027 `set_name` varchar(48) NOT NULL DEFAULT '0',
1028 `file_name` varchar(96) NOT NULL DEFAULT '0',
1029 `file_path` varchar(96) NOT NULL DEFAULT '0',
1030 `num_pages` int(10) NOT NULL DEFAULT '0',
1031 `max_score` float NOT NULL DEFAULT '0',
1032 `goal_time` time NOT NULL DEFAULT '00:00:00',
1033 `unit_cost` int(11) NOT NULL DEFAULT '0',
1034 `pdf_preview_name` varchar(100) NOT NULL DEFAULT '0',
1035 `worksheet_header_id` int(11) NOT NULL,
1036 PRIMARY KEY (`wsid`),
1037 KEY `worksheet_topic` (`topic_id`),
1038 KEY `worksheet__creator` (`creator_id`)
1039) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
1040
1041--
1042-- Dumping data for table `worksheets`
1043--
1044
1045INSERT INTO `worksheets` (`wsid`, `topic_id`, `creator_id`, `section_name`, `set_name`, `file_name`, `file_path`, `num_pages`, `max_score`, `goal_time`, `unit_cost`, `pdf_preview_name`, `worksheet_header_id`) VALUES
1046(1, 1, 18, 'Adv Ones', '1', 'Int_Adv1', 'Int_Adv1.pdf', 7, 100, '00:04:00', 1, '', 30),
1047(2, 51, 18, '11-to-18', '1', 'BasicOps-Add-11to18-Trace1', 'BasicOps-Add-11to18-Trace1.pdf', 8, 14, '00:03:00', 1, '', 31);
1048
1049-- --------------------------------------------------------
1050
1051--
1052-- Table structure for table `worksheet_categories`
1053--
1054
1055DROP TABLE IF EXISTS `worksheet_categories`;
1056CREATE TABLE IF NOT EXISTS `worksheet_categories` (
1057 `category_id` int(10) NOT NULL AUTO_INCREMENT,
1058 `type_id` int(10) NOT NULL,
1059 `category_name` varchar(48) NOT NULL,
1060 `category_code` varchar(8) NOT NULL,
1061 `category_description` tinytext,
1062 PRIMARY KEY (`category_id`),
1063 KEY `worksheet_categories_type` (`type_id`)
1064) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;
1065
1066--
1067-- Dumping data for table `worksheet_categories`
1068--
1069
1070INSERT INTO `worksheet_categories` (`category_id`, `type_id`, `category_name`, `category_code`, `category_description`) VALUES
1071(3, 2, 'Unit Convertion', '3', 'Unit Convertion'),
1072(2, 1, 'Compare Numbers', '2', 'Compare Numbers'),
1073(1, 1, 'Place Value', '1', 'Place Value'),
1074(4, 1, 'Order Numbers', '4', 'Order Numbers'),
1075(5, 2, 'Interger', '5', NULL),
1076(6, 2, 'Statistics', '6', NULL),
1077(7, 3, 'Radical', '7', NULL),
1078(8, 3, 'Factoring', '8', NULL),
1079(9, 1, 'Clock & Time', '9', 'Clock & Time'),
1080(10, 1, 'Money', '10', 'Money'),
1081(11, 1, 'Rounding', '11', 'Rounding'),
1082(12, 1, 'Estimation', '12', 'Estimation'),
1083(13, 1, 'Basic Ops', '13', 'Basic Ops'),
1084(14, 1, 'Fraction', '14', 'Fraction'),
1085(15, 2, 'Scientific Notation', '', NULL),
1086(16, 2, 'Properties', '', NULL),
1087(17, 2, 'Pre-Algebra Equation', '', NULL),
1088(18, 2, 'Square-Cube-Root', '', NULL),
1089(19, 3, 'Algebra Equation', '', NULL),
1090(20, 3, 'Geometry', '', NULL),
1091(21, 3, 'System of Equation', '', NULL),
1092(22, 3, 'Polynominal', '', NULL),
1093(23, 3, 'Simplify or Expanding Expression', '', NULL),
1094(24, 3, 'Trigonimetry', '', NULL),
1095(25, 1, 'Thang Cat', 'T', 'Thang Cat');
1096
1097-- --------------------------------------------------------
1098
1099--
1100-- Table structure for table `worksheet_filler`
1101--
1102
1103DROP TABLE IF EXISTS `worksheet_filler`;
1104CREATE TABLE IF NOT EXISTS `worksheet_filler` (
1105 `sfid` int(10) NOT NULL AUTO_INCREMENT,
1106 `content1` text NOT NULL,
1107 `content2` text NOT NULL,
1108 `riddle` int(11) NOT NULL DEFAULT '0',
1109 PRIMARY KEY (`sfid`)
1110) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
1111
1112--
1113-- Dumping data for table `worksheet_filler`
1114--
1115
1116INSERT INTO `worksheet_filler` (`sfid`, `content1`, `content2`, `riddle`) VALUES
1117(1, 'What gets wetter and wetter the more it dries?', 'A sponger or towel', 1),
1118(2, 'You throw away the outside and cook the inside. Then you eat the outside and throw away the inside. What did you eat?', 'A egg', 1),
1119(3, 'What goes up and down the stairs without moving?', 'A rug', 1),
1120(4, 'The world''s termites outweigh the world''s humans 10 to 1. ', 'On average, 100 people choke to death on ball point pens every year, so be careful. ', 0),
1121(5, 'The first toilet ever seen on television was on "Leave It To Beaver."', 'Thirty-five percent of the people who use personal ads for dating are already married.', 0),
1122(6, 'Dreamt is the only English word that ends in the letters "mt".', 'Maine is the only state whose name is just one syllable.', 0);
1123
1124-- --------------------------------------------------------
1125
1126--
1127-- Table structure for table `worksheet_headers`
1128--
1129
1130DROP TABLE IF EXISTS `worksheet_headers`;
1131CREATE TABLE IF NOT EXISTS `worksheet_headers` (
1132 `whid` int(11) NOT NULL AUTO_INCREMENT,
1133 `header_name` varchar(200) NOT NULL,
1134 `owner` int(11) NOT NULL,
1135 `banner_area1` varchar(200) DEFAULT NULL,
1136 `banner_area2` varchar(200) DEFAULT NULL,
1137 `banner_area3` varchar(200) DEFAULT NULL,
1138 `type` varchar(10) NOT NULL,
1139 `type_area3` varchar(10) NOT NULL,
1140 PRIMARY KEY (`whid`),
1141 UNIQUE KEY `whid` (`whid`)
1142) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;
1143
1144--
1145-- Dumping data for table `worksheet_headers`
1146--
1147
1148INSERT INTO `worksheet_headers` (`whid`, `header_name`, `owner`, `banner_area1`, `banner_area2`, `banner_area3`, `type`, `type_area3`) VALUES
1149(1, 'random', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1150(2, 'random', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1151(3, 'random', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1152(4, 'random', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1153(5, 'random', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1154(6, 'random', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1155(7, 'random', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1156(8, 'random', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1157(9, 'random', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1158(10, 'random', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1159(11, 'random', 18, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1160(12, 'random', 18, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1161(13, 'random', 18, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1162(14, 'random', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1163(15, 'random', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1164(16, 'random', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1165(17, 'Header Test', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '1', 'Img'),
1166(18, 'Riddle 1', 18, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '1', 'Img'),
1167(19, 'Trivial 1', 18, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '2', 'Img'),
1168(20, 'Thang_Custom_20121210', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '2', 'Img'),
1169(21, 'Thang_Trivia_20121210', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'Img'),
1170(22, 'Thang_Riddle_20121210', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '1', 'Img'),
1171(23, 'Thang_Riddle_20121210_2', 22, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '1', 'Img'),
1172(24, 'riddle1', 18, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '1', 'Img'),
1173(25, 'riddle1', 18, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '1', 'Img'),
1174(26, 'riddle2', 18, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '1', 'Img'),
1175(27, 'Riddle 1', 18, 'qr-code_rusocial_media_ready.png', 'Boostik_ws.jpg', 'Summary.jpg', '1', 'img'),
1176(28, 'Riddle 1', 18, 'qr-code_rusocial_media_ready1.png', 'Boostik_ws1.jpg', 'Summary1.jpg', '1', 'img'),
1177(29, 'jh_add1', 18, 'header_area_1.jpg', 'header_area_2.jpg', 'header_area_3.jpg', '0', 'img'),
1178(30, 'jh_add1', 18, 'header_area_11.jpg', 'header_area_21.jpg', 'header_area_31.jpg', '0', 'img'),
1179(31, 'testing-header', 18, 'qr-code_rusocial_media_ready2.png', 'logo.jpg', 'Untitled-3.jpg', '2', 'img');
1180
1181-- --------------------------------------------------------
1182
1183--
1184-- Table structure for table `worksheet_topics`
1185--
1186
1187DROP TABLE IF EXISTS `worksheet_topics`;
1188CREATE TABLE IF NOT EXISTS `worksheet_topics` (
1189 `topic_id` int(10) NOT NULL AUTO_INCREMENT,
1190 `category_id` int(10) NOT NULL DEFAULT '0',
1191 `topic_name` varchar(48) NOT NULL DEFAULT '0',
1192 `topic_code` varchar(8) NOT NULL DEFAULT '0',
1193 `topic_description` tinytext,
1194 PRIMARY KEY (`topic_id`),
1195 KEY `worksheet_topics_category` (`category_id`)
1196) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=98 ;
1197
1198--
1199-- Dumping data for table `worksheet_topics`
1200--
1201
1202INSERT INTO `worksheet_topics` (`topic_id`, `category_id`, `topic_name`, `topic_code`, `topic_description`) VALUES
1203(2, 2, 'Whole Numbers ', '2', 'Whole Numbers '),
1204(1, 1, 'Ones', '1', 'Ones'),
1205(3, 3, 'Metric Conversion', '3', 'Metric Conversion'),
1206(4, 4, 'Ascending', '4', NULL),
1207(5, 1, 'Tens', '5', NULL),
1208(6, 1, 'Hundreds', '6', NULL),
1209(7, 1, 'Thousands', '5', NULL),
1210(8, 1, 'Over Thousands ', '6', NULL),
1211(44, 10, 'US', '', NULL),
1212(43, 9, 'Over/Under', '', NULL),
1213(14, 2, 'Integers', '2', 'Integers'),
1214(15, 3, 'Imperial Conversion', '3', 'Imperial Conversion'),
1215(16, 4, 'Descending', '4', NULL),
1216(18, 2, 'Mix Whole Numbers Integers', '2', 'Mix Whole Numbers Integers'),
1217(20, 4, 'Mix', '4', NULL),
1218(42, 9, 'Hours & Minutes ', '', NULL),
1219(41, 9, 'Hours', '', NULL),
1220(25, 5, 'Add/Sub', '5', NULL),
1221(26, 5, 'Mul/Div ', '26', NULL),
1222(27, 5, 'Mix ', '27', NULL),
1223(64, 15, 'Rewrite', '', NULL),
1224(29, 6, 'Mean', '29', NULL),
1225(30, 6, 'Median', '30', NULL),
1226(63, 6, 'Mix ', '', NULL),
1227(97, 6, 'Mode', '', NULL),
1228(61, 6, 'Range', '', NULL),
1229(34, 7, 'Simplify ', '', NULL),
1230(35, 7, 'Expand ', '', NULL),
1231(81, 19, 'Mathematical Formulae', '', NULL),
1232(38, 8, 'Expanding', '', NULL),
1233(39, 8, 'Common Factor', '', NULL),
1234(80, 19, 'Single Variable ', '', NULL),
1235(45, 10, 'Canada ', '', NULL),
1236(46, 11, 'Whole Numbers ', '', NULL),
1237(47, 11, 'Decimals ', '', NULL),
1238(48, 12, '2 digits', '', NULL),
1239(49, 12, '3 digits', '', NULL),
1240(50, 12, '4 digits', '', NULL),
1241(51, 13, 'Add', '', NULL),
1242(52, 13, 'Subtract', '', NULL),
1243(53, 13, 'Add/Subtract', '', NULL),
1244(54, 13, 'Multiply ', '', NULL),
1245(55, 13, 'Divide', '', NULL),
1246(56, 13, 'Multiply/Divide', '', NULL),
1247(57, 14, 'Equivalent Fraction ', '', NULL),
1248(58, 14, 'Reduce Fraction', '', NULL),
1249(59, 14, 'Compare Fraction ', '', NULL),
1250(60, 14, 'Convert Fraction', '', NULL),
1251(65, 15, 'Compare', '', NULL),
1252(66, 16, 'Inverse Relationship', '', NULL),
1253(67, 16, 'Relationship', '', NULL),
1254(68, 16, 'Order of Operations', '', NULL),
1255(69, 17, 'Add/Sub Mix', '', NULL),
1256(70, 17, 'Mul', '', NULL),
1257(71, 17, 'Div', '', NULL),
1258(72, 17, 'Mul/Div Mix', '', NULL),
1259(73, 17, 'Mix All', '', NULL),
1260(74, 17, '2 Ops', '', NULL),
1261(75, 18, 'Square', '', NULL),
1262(76, 18, 'Cube ', '', NULL),
1263(77, 18, 'Square Root', '', NULL),
1264(78, 18, 'Cube Root', '', NULL),
1265(79, 18, 'Mix ', '', NULL),
1266(82, 20, 'Angles ', '', NULL),
1267(83, 20, 'Formulae', '', NULL),
1268(84, 21, 'Graph', '', NULL),
1269(85, 21, 'Algebra', '', NULL),
1270(86, 22, 'All', '', NULL),
1271(87, 23, 'Fraction', '', NULL),
1272(88, 23, 'Power ', '', NULL),
1273(89, 23, 'Algebra ', '', NULL),
1274(90, 24, 'Sin ', '', NULL),
1275(91, 24, 'Cosin', '', NULL),
1276(92, 24, 'Tan ', '', NULL),
1277(93, 24, 'Cot', '', NULL),
1278(94, 24, 'Sin & Cosin', '', NULL),
1279(95, 24, 'Tan & Cot', '', NULL),
1280(96, 25, 'Thang Topic', 'T', 'Thang Topic');
1281
1282-- --------------------------------------------------------
1283
1284--
1285-- Table structure for table `worksheet_types`
1286--
1287
1288DROP TABLE IF EXISTS `worksheet_types`;
1289CREATE TABLE IF NOT EXISTS `worksheet_types` (
1290 `type_id` int(10) NOT NULL AUTO_INCREMENT,
1291 `type_name` varchar(48) NOT NULL,
1292 `type_code` varchar(8) NOT NULL,
1293 `type_description` text,
1294 PRIMARY KEY (`type_id`)
1295) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
1296
1297--
1298-- Dumping data for table `worksheet_types`
1299--
1300
1301INSERT INTO `worksheet_types` (`type_id`, `type_name`, `type_code`, `type_description`) VALUES
1302(2, '12 to 14', '2', 'Recommended for ages 12 to 14'),
1303(1, '7 to 11', '1', 'Recommended for ages 7 to 11'),
1304(3, '15 to 18', '3', 'Recommended for ages 15 to 18');
1305
1306/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1307/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1308/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;