· 6 years ago · Jun 10, 2019, 03:08 AM
1██████╗ ███████╗███╗ ███╗ ██████╗ ███╗ ██╗███████╗ █████╗ ██████╗
2██╔══██╗██╔════╝████╗ ████║██╔═══██╗████╗ ██║██╔════╝██╔══██╗██╔══██╗
3██║ ██║█████╗ ██╔████╔██║██║ ██║██╔██╗ ██║███████╗███████║██║ ██║
4██║ ██║██╔══╝ ██║╚██╔╝██║██║ ██║██║╚██╗██║╚════██║██╔══██║██║ ██║
5██████╔╝███████╗██║ ╚═╝ ██║╚██████╔╝██║ ╚████║███████║██║ ██║██████╔╝
6╚═════╝ ╚══════╝╚═╝ ╚═╝ ╚═════╝ ╚═╝ ╚═══╝╚══════╝╚═╝ ╚═╝╚═════╝
7
8
9███╗ ██╗███████╗██╗ ██╗███████╗███████╗ ██████╗
10████╗ ██║██╔════╝██║ ██║██╔════╝██╔════╝██╔════╝
11██╔██╗ ██║█████╗ ██║ █╗ ██║███████╗█████╗ ██║
12██║╚██╗██║██╔══╝ ██║███╗██║╚════██║██╔══╝ ██║
13██║ ╚████║███████╗╚███╔███╔╝███████║███████╗╚██████╗
14╚═╝ ╚═══╝╚══════╝ ╚══╝╚══╝ ╚══════╝╚══════╝ ╚═════╝
15
16-------------------------------------------------------------------------------------------------
17
18I am DemonSad <3
19
20Target : https://www.harvard.edu/ ( Harvard University )
21
22Greetings: TioSan, Angel, Cloudmore, NedLock, Menor
23
24-- ------------------------------------------------------------------------------------------------
25"HARVARD OWNED BY : DEMONSAD"
26---------------------------------------------------------------------------------------------------
27
28SET FOREIGN_KEY_CHECKS = 0;
29
30--
31-- Table structure for table `harvard_byt_accommodation_bookings`
32--
33
34DROP TABLE IF EXISTS `harvard_byt_accommodation_bookings`;
35CREATE TABLE `harvard_byt_accommodation_bookings` (
36`Id` bigint(20) unsigned NOT NULL auto_increment,
37`first_name` varchar(255) NOT NULL,
38`last_name` varchar(255) NOT NULL,
39`email` varchar(255) NOT NULL,
40`phone` varchar(255),
41`address` varchar(255),
42`town` varchar(255),
43`zip` varchar(255),
44`country` varchar(255),
45`special_requirements` text,
46`room_count` int(11) NOT NULL,
47`adults` int(11) NOT NULL,
48`children` int(11) NOT NULL,
49`total_price` decimal(16,2) DEFAULT '0.00' NOT NULL,
50`accommodation_id` bigint(20) unsigned NOT NULL,
51`room_type_id` bigint(20) unsigned NOT NULL,
52`date_from` datetime NOT NULL,
53`date_to` datetime NOT NULL,
54`user_id` bigint(20) unsigned,
55`created` timestamp DEFAULT 'CURRENT_TIMESTAMP' NOT NULL,
56`woo_order_id` bigint(20),
57`cart_key` varchar(64) NOT NULL,
58`currency_code` varchar(8),
59 PRIMARY KEY (`Id`)
60) ENGINE=MyISAM AUTO_INCREMENT=1;
61
62-- --------------------------------------------------------
63
64--
65-- Table structure for table `harvard_byt_accommodation_vacancies`
66--
67
68DROP TABLE IF EXISTS `harvard_byt_accommodation_vacancies`;
69CREATE TABLE `harvard_byt_accommodation_vacancies` (
70`Id` bigint(20) unsigned NOT NULL auto_increment,
71`start_date` datetime NOT NULL,
72`end_date` datetime NOT NULL,
73`accommodation_id` bigint(20) unsigned NOT NULL,
74`room_type_id` bigint(20) unsigned NOT NULL,
75`room_count` int(11) NOT NULL,
76`price_per_day` decimal(16,2) NOT NULL,
77`price_per_day_child` decimal(16,2) NOT NULL,
78 PRIMARY KEY (`Id`)
79) ENGINE=MyISAM AUTO_INCREMENT=1;
80
81-- --------------------------------------------------------
82
83--
84-- Table structure for table `harvard_byt_car_rental_booking_days`
85--
86
87DROP TABLE IF EXISTS `harvard_byt_car_rental_booking_days`;
88CREATE TABLE `harvard_byt_car_rental_booking_days` (
89`Id` bigint(20) unsigned NOT NULL auto_increment,
90`car_rental_booking_id` bigint(20) NOT NULL,
91`booking_date` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
92`created` timestamp DEFAULT 'CURRENT_TIMESTAMP' NOT NULL,
93 PRIMARY KEY (`Id`)
94) ENGINE=MyISAM AUTO_INCREMENT=1;
95
96-- --------------------------------------------------------
97
98--
99-- Table structure for table `harvard_byt_car_rental_bookings`
100--
101
102DROP TABLE IF EXISTS `harvard_byt_car_rental_bookings`;
103CREATE TABLE `harvard_byt_car_rental_bookings` (
104`Id` bigint(20) unsigned NOT NULL auto_increment,
105`car_rental_id` bigint(20) NOT NULL,
106`first_name` varchar(255) NOT NULL,
107`last_name` varchar(255) NOT NULL,
108`email` varchar(255) NOT NULL,
109`phone` varchar(255),
110`address` varchar(255),
111`town` varchar(255),
112`zip` varchar(255),
113`country` varchar(255),
114`special_requirements` text,
115`drop_off` bigint(10) NOT NULL,
116`total_price` decimal(16,2) NOT NULL,
117`user_id` bigint(10) NOT NULL,
118`created` timestamp DEFAULT 'CURRENT_TIMESTAMP' NOT NULL,
119`woo_order_id` bigint(20),
120`cart_key` varchar(64) NOT NULL,
121`currency_code` varchar(8),
122 PRIMARY KEY (`Id`)
123) ENGINE=MyISAM AUTO_INCREMENT=1;
124
125-- --------------------------------------------------------
126
127--
128-- Table structure for table `harvard_byt_cruise_booking`
129--
130
131DROP TABLE IF EXISTS `harvard_byt_cruise_booking`;
132CREATE TABLE `harvard_byt_cruise_booking` (
133`Id` bigint(20) unsigned NOT NULL auto_increment,
134`first_name` varchar(255) NOT NULL,
135`last_name` varchar(255) NOT NULL,
136`email` varchar(255) NOT NULL,
137`phone` varchar(255),
138`address` varchar(255),
139`town` varchar(255),
140`zip` varchar(255),
141`country` varchar(255),
142`special_requirements` text,
143`adults` int(11) NOT NULL,
144`children` int(11) NOT NULL,
145`cruise_schedule_id` bigint(20) NOT NULL,
146`cruise_date` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
147`user_id` bigint(20) unsigned,
148`total_price_adults` decimal(16,2) NOT NULL,
149`total_price_children` decimal(16,2) NOT NULL,
150`total_price` decimal(16,2) NOT NULL,
151`created` timestamp DEFAULT 'CURRENT_TIMESTAMP' NOT NULL,
152`woo_order_id` bigint(20),
153`cart_key` varchar(64) NOT NULL,
154`currency_code` varchar(8),
155 PRIMARY KEY (`Id`)
156) ENGINE=MyISAM AUTO_INCREMENT=1;
157
158-- --------------------------------------------------------
159
160--
161-- Table structure for table `harvard_byt_cruise_schedule`
162--
163
164DROP TABLE IF EXISTS `harvard_byt_cruise_schedule`;
165CREATE TABLE `harvard_byt_cruise_schedule` (
166`Id` bigint(20) unsigned NOT NULL auto_increment,
167`start_date` datetime NOT NULL,
168`duration_days` int(11) NOT NULL,
169`end_date` datetime,
170`cruise_id` bigint(20) unsigned NOT NULL,
171`cabin_type_id` bigint(20) unsigned NOT NULL,
172`cabin_count` int(11) NOT NULL,
173`price` decimal(16,2) NOT NULL,
174`price_child` decimal(16,2) NOT NULL,
175`created` timestamp DEFAULT 'CURRENT_TIMESTAMP' NOT NULL,
176 PRIMARY KEY (`Id`)
177) ENGINE=MyISAM AUTO_INCREMENT=1;
178
179-- --------------------------------------------------------
180
181--
182-- Table structure for table `harvard_byt_currencies`
183--
184
185DROP TABLE IF EXISTS `harvard_byt_currencies`;
186CREATE TABLE `harvard_byt_currencies` (
187`Id` bigint(20) unsigned NOT NULL auto_increment,
188`currency_code` varchar(10) NOT NULL,
189`currency_label` varchar(255) NOT NULL,
190`currency_symbol` varchar(10),
191 PRIMARY KEY (`Id`)
192) ENGINE=MyISAM AUTO_INCREMENT=48;
193
194-- --------------------------------------------------------
195
196--
197-- Table structure for table `harvard_byt_tour_booking`
198--
199
200DROP TABLE IF EXISTS `harvard_byt_tour_booking`;
201CREATE TABLE `harvard_byt_tour_booking` (
202`Id` bigint(20) unsigned NOT NULL auto_increment,
203`tour_schedule_id` bigint(20) NOT NULL,
204`tour_date` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
205`first_name` varchar(255) NOT NULL,
206`last_name` varchar(255) NOT NULL,
207`email` varchar(255) NOT NULL,
208`phone` varchar(255),
209`address` varchar(255),
210`town` varchar(255),
211`zip` varchar(255),
212`country` varchar(255),
213`special_requirements` text,
214`adults` bigint(20) NOT NULL,
215`children` bigint(20) NOT NULL,
216`user_id` bigint(20) NOT NULL,
217`total_price_adults` decimal(16,2) NOT NULL,
218`total_price_children` decimal(16,2) NOT NULL,
219`total_price` decimal(16,2) NOT NULL,
220`created` timestamp DEFAULT 'CURRENT_TIMESTAMP' NOT NULL,
221`woo_order_id` bigint(20),
222`cart_key` varchar(64) NOT NULL,
223`currency_code` varchar(8),
224 PRIMARY KEY (`Id`)
225) ENGINE=MyISAM AUTO_INCREMENT=1;
226
227-- --------------------------------------------------------
228
229--
230-- Table structure for table `harvard_byt_tour_schedule`
231--
232
233DROP TABLE IF EXISTS `harvard_byt_tour_schedule`;
234CREATE TABLE `harvard_byt_tour_schedule` (
235`Id` bigint(20) unsigned NOT NULL auto_increment,
236`tour_id` bigint(20) NOT NULL,
237`start_date` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
238`duration_days` int(11) NOT NULL,
239`price` decimal(16,2) DEFAULT '0.00' NOT NULL,
240`price_child` decimal(16,2) DEFAULT '0.00' NOT NULL,
241`max_people` int(11) NOT NULL,
242`created` timestamp DEFAULT 'CURRENT_TIMESTAMP' NOT NULL,
243`end_date` datetime,
244 PRIMARY KEY (`Id`)
245) ENGINE=MyISAM AUTO_INCREMENT=5;
246
247-- --------------------------------------------------------
248
249--
250-- Table structure for table `harvard_commentmeta`
251--
252
253DROP TABLE IF EXISTS `harvard_commentmeta`;
254CREATE TABLE `harvard_commentmeta` (
255`meta_id` bigint(20) unsigned NOT NULL auto_increment,
256`comment_id` bigint(20) unsigned NOT NULL,
257`meta_key` varchar(255),
258`meta_value` longtext,
259 PRIMARY KEY (`meta_id`),
260 KEY `comment_id` (`comment_id`),
261 KEY `meta_key` (`meta_key`)
262) ENGINE=MyISAM AUTO_INCREMENT=1;
263
264-- --------------------------------------------------------
265
266--
267-- Table structure for table `harvard_comments`
268--
269
270DROP TABLE IF EXISTS `harvard_comments`;
271CREATE TABLE `harvard_comments` (
272`comment_ID` bigint(20) unsigned NOT NULL auto_increment,
273`comment_post_ID` bigint(20) unsigned NOT NULL,
274`comment_author` text NOT NULL,
275`comment_author_email` varchar(100) NOT NULL,
276`comment_author_url` varchar(200) NOT NULL,
277`comment_author_IP` varchar(100) NOT NULL,
278`comment_date` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
279`comment_date_gmt` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
280`comment_content` mediumtext NOT NULL,
281`comment_karma` int(11) NOT NULL,
282`comment_approved` varchar(20) DEFAULT '1' NOT NULL,
283`comment_agent` varchar(255) NOT NULL,
284`comment_type` varchar(20) NOT NULL,
285`comment_parent` bigint(20) unsigned NOT NULL,
286`user_id` bigint(20) unsigned NOT NULL,
287 PRIMARY KEY (`comment_ID`),
288 KEY `comment_post_ID` (`comment_post_ID`),
289 KEY `comment_approved_date_gmt` (`comment_approved`, `comment_date_gmt`),
290 KEY `comment_date_gmt` (`comment_date_gmt`),
291 KEY `comment_parent` (`comment_parent`),
292 KEY `comment_author_email` (`comment_author_email`)
293) ENGINE=MyISAM AUTO_INCREMENT=2;
294
295-- --------------------------------------------------------
296
297--
298-- Table structure for table `harvard_layerslider`
299--
300
301DROP TABLE IF EXISTS `harvard_layerslider`;
302CREATE TABLE `harvard_layerslider` (
303`id` int(10) NOT NULL auto_increment,
304`author` int(10) NOT NULL,
305`name` varchar(100) NOT NULL,
306`slug` varchar(100) NOT NULL,
307`data` mediumtext NOT NULL,
308`date_c` int(10) NOT NULL,
309`date_m` int(11) NOT NULL,
310`flag_hidden` tinyint(1) NOT NULL,
311`flag_deleted` tinyint(1) NOT NULL,
312 PRIMARY KEY (`id`)
313) ENGINE=MyISAM AUTO_INCREMENT=2;
314
315-- --------------------------------------------------------
316
317--
318-- Table structure for table `harvard_links`
319--
320
321DROP TABLE IF EXISTS `harvard_links`;
322CREATE TABLE `harvard_links` (
323`link_id` bigint(20) unsigned NOT NULL auto_increment,
324`link_url` varchar(255) NOT NULL,
325`link_name` varchar(255) NOT NULL,
326`link_image` varchar(255) NOT NULL,
327`link_target` varchar(25) NOT NULL,
328`link_description` varchar(255) NOT NULL,
329`link_visible` varchar(20) DEFAULT 'Y' NOT NULL,
330`link_owner` bigint(20) unsigned DEFAULT '1' NOT NULL,
331`link_rating` int(11) NOT NULL,
332`link_updated` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
333`link_rel` varchar(255) NOT NULL,
334`link_notes` longtext NOT NULL,
335`link_rss` varchar(255) NOT NULL,
336 PRIMARY KEY (`link_id`),
337 KEY `link_visible` (`link_visible`)
338) ENGINE=MyISAM AUTO_INCREMENT=1;
339
340-- --------------------------------------------------------
341
342--
343-- Table structure for table `harvard_options`
344--
345
346DROP TABLE IF EXISTS `harvard_options`;
347CREATE TABLE `harvard_options` (
348`option_id` bigint(20) unsigned NOT NULL auto_increment,
349`option_name` varchar(64) NOT NULL,
350`option_value` longtext NOT NULL,
351`autoload` varchar(20) DEFAULT 'yes' NOT NULL,
352 PRIMARY KEY (`option_id`),
353 UNIQUE KEY `option_name` (`option_name`)
354) ENGINE=MyISAM AUTO_INCREMENT=3946;
355
356-- --------------------------------------------------------
357
358--
359-- Table structure for table `harvard_postmeta`
360--
361
362DROP TABLE IF EXISTS `harvard_postmeta`;
363CREATE TABLE `harvard_postmeta` (
364`meta_id` bigint(20) unsigned NOT NULL auto_increment,
365`post_id` bigint(20) unsigned NOT NULL,
366`meta_key` varchar(255),
367`meta_value` longtext,
368 PRIMARY KEY (`meta_id`),
369 KEY `post_id` (`post_id`),
370 KEY `meta_key` (`meta_key`)
371) ENGINE=MyISAM AUTO_INCREMENT=2396;
372
373-- --------------------------------------------------------
374
375--
376-- Table structure for table `harvard_posts`
377--
378
379DROP TABLE IF EXISTS `harvard_posts`;
380CREATE TABLE `harvard_posts` (
381`ID` bigint(20) unsigned NOT NULL auto_increment,
382`post_author` bigint(20) unsigned NOT NULL,
383`post_date` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
384`post_date_gmt` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
385`post_content` longtext NOT NULL,
386`post_title` mediumtext NOT NULL,
387`post_excerpt` mediumtext NOT NULL,
388`post_status` varchar(20) DEFAULT 'publish' NOT NULL,
389`comment_status` varchar(20) DEFAULT 'open' NOT NULL,
390`ping_status` varchar(20) DEFAULT 'open' NOT NULL,
391`post_password` varchar(20) NOT NULL,
392`post_name` varchar(200) NOT NULL,
393`to_ping` mediumtext NOT NULL,
394`pinged` mediumtext NOT NULL,
395`post_modified` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
396`post_modified_gmt` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
397`post_content_filtered` longtext NOT NULL,
398`post_parent` bigint(20) unsigned NOT NULL,
399`guid` varchar(255) NOT NULL,
400`menu_order` int(11) NOT NULL,
401`post_type` varchar(20) DEFAULT 'post' NOT NULL,
402`post_mime_type` varchar(100) NOT NULL,
403`comment_count` bigint(20) NOT NULL,
404 PRIMARY KEY (`ID`),
405 KEY `type_status_date` (`post_type`, `post_status`, `post_date`, `ID`),
406 KEY `post_parent` (`post_parent`),
407 KEY `post_author` (`post_author`),
408 KEY `post_name` (`post_name`)
409) ENGINE=MyISAM AUTO_INCREMENT=2252;
410
411-- --------------------------------------------------------
412
413--
414-- Table structure for table `harvard_revslider_css`
415--
416
417DROP TABLE IF EXISTS `harvard_revslider_css`;
418CREATE TABLE `harvard_revslider_css` (
419`id` int(9) NOT NULL auto_increment,
420`handle` text NOT NULL,
421`settings` text,
422`hover` text,
423`params` text NOT NULL,
424 PRIMARY KEY (`id`)
425) ENGINE=MyISAM AUTO_INCREMENT=48;
426
427-- --------------------------------------------------------
428
429--
430-- Table structure for table `harvard_revslider_layer_animations`
431--
432
433DROP TABLE IF EXISTS `harvard_revslider_layer_animations`;
434CREATE TABLE `harvard_revslider_layer_animations` (
435`id` int(9) NOT NULL auto_increment,
436`handle` text NOT NULL,
437`params` text NOT NULL,
438 PRIMARY KEY (`id`)
439) ENGINE=MyISAM AUTO_INCREMENT=1;
440
441-- --------------------------------------------------------
442
443--
444-- Table structure for table `harvard_revslider_settings`
445--
446
447DROP TABLE IF EXISTS `harvard_revslider_settings`;
448CREATE TABLE `harvard_revslider_settings` (
449`id` int(9) NOT NULL auto_increment,
450`general` text NOT NULL,
451`params` text NOT NULL,
452 PRIMARY KEY (`id`)
453) ENGINE=MyISAM AUTO_INCREMENT=2;
454
455-- --------------------------------------------------------
456
457--
458-- Table structure for table `harvard_revslider_sliders`
459--
460
461DROP TABLE IF EXISTS `harvard_revslider_sliders`;
462CREATE TABLE `harvard_revslider_sliders` (
463`id` int(9) NOT NULL auto_increment,
464`title` tinytext NOT NULL,
465`alias` tinytext,
466`params` text NOT NULL,
467 PRIMARY KEY (`id`)
468) ENGINE=MyISAM AUTO_INCREMENT=2;
469
470-- --------------------------------------------------------
471
472--
473-- Table structure for table `harvard_revslider_slides`
474--
475
476DROP TABLE IF EXISTS `harvard_revslider_slides`;
477CREATE TABLE `harvard_revslider_slides` (
478`id` int(9) NOT NULL auto_increment,
479`slider_id` int(9) NOT NULL,
480`slide_order` int(11) NOT NULL,
481`params` text NOT NULL,
482`layers` text NOT NULL,
483 PRIMARY KEY (`id`)
484) ENGINE=MyISAM AUTO_INCREMENT=4;
485
486-- --------------------------------------------------------
487
488--
489-- Table structure for table `harvard_revslider_static_slides`
490--
491
492DROP TABLE IF EXISTS `harvard_revslider_static_slides`;
493CREATE TABLE `harvard_revslider_static_slides` (
494`id` int(9) NOT NULL auto_increment,
495`slider_id` int(9) NOT NULL,
496`params` text NOT NULL,
497`layers` text NOT NULL,
498 PRIMARY KEY (`id`)
499) ENGINE=MyISAM AUTO_INCREMENT=1;
500
501-- --------------------------------------------------------
502
503--
504-- Table structure for table `harvard_term_relationships`
505--
506
507DROP TABLE IF EXISTS `harvard_term_relationships`;
508CREATE TABLE `harvard_term_relationships` (
509`object_id` bigint(20) unsigned NOT NULL,
510`term_taxonomy_id` bigint(20) unsigned NOT NULL,
511`term_order` int(11) NOT NULL,
512 PRIMARY KEY (`object_id`, `term_taxonomy_id`),
513 KEY `term_taxonomy_id` (`term_taxonomy_id`)
514) ENGINE=MyISAM;
515
516-- --------------------------------------------------------
517
518--
519-- Table structure for table `harvard_term_taxonomy`
520--
521
522DROP TABLE IF EXISTS `harvard_term_taxonomy`;
523CREATE TABLE `harvard_term_taxonomy` (
524`term_taxonomy_id` bigint(20) unsigned NOT NULL auto_increment,
525`term_id` bigint(20) unsigned NOT NULL,
526`taxonomy` varchar(32) NOT NULL,
527`description` longtext NOT NULL,
528`parent` bigint(20) unsigned NOT NULL,
529`count` bigint(20) NOT NULL,
530 PRIMARY KEY (`term_taxonomy_id`),
531 UNIQUE KEY `term_id_taxonomy` (`term_id`, `taxonomy`),
532 KEY `taxonomy` (`taxonomy`)
533) ENGINE=MyISAM AUTO_INCREMENT=60;
534
535-- --------------------------------------------------------
536
537--
538-- Table structure for table `harvard_terms`
539--
540
541DROP TABLE IF EXISTS `harvard_terms`;
542CREATE TABLE `harvard_terms` (
543`term_id` bigint(20) unsigned NOT NULL auto_increment,
544`name` varchar(200) NOT NULL,
545`slug` varchar(200) NOT NULL,
546`term_group` bigint(10) NOT NULL,
547 PRIMARY KEY (`term_id`),
548 KEY `name` (`name`),
549 KEY `slug` (`slug`)
550) ENGINE=MyISAM AUTO_INCREMENT=60;
551
552-- --------------------------------------------------------
553
554--
555-- Table structure for table `harvard_usermeta`
556--
557
558DROP TABLE IF EXISTS `harvard_usermeta`;
559CREATE TABLE `harvard_usermeta` (
560`umeta_id` bigint(20) unsigned NOT NULL auto_increment,
561`user_id` bigint(20) unsigned NOT NULL,
562`meta_key` varchar(255),
563`meta_value` longtext,
564 PRIMARY KEY (`umeta_id`),
565 KEY `user_id` (`user_id`),
566 KEY `meta_key` (`meta_key`)
567) ENGINE=MyISAM AUTO_INCREMENT=47;
568
569-- --------------------------------------------------------
570
571--
572-- Table structure for table `harvard_users`
573--
574
575DROP TABLE IF EXISTS `harvard_users`;
576CREATE TABLE `harvard_users` (
577`ID` bigint(20) unsigned NOT NULL auto_increment,
578`user_login` varchar(60) NOT NULL,
579`user_pass` varchar(64) NOT NULL,
580`user_nicename` varchar(50) NOT NULL,
581`user_email` varchar(100) NOT NULL,
582`user_url` varchar(100) NOT NULL,
583`user_registered` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
584`user_activation_key` varchar(60) NOT NULL,
585`user_status` int(11) NOT NULL,
586`display_name` varchar(250) NOT NULL,
587 PRIMARY KEY (`ID`),
588 KEY `user_login_key` (`user_login`),
589 KEY `user_nicename` (`user_nicename`)
590) ENGINE=MyISAM AUTO_INCREMENT=3;
591
592-- --------------------------------------------------------
593
594--
595-- Dumping data for table `harvard_byt_currencies`
596--
597
598INSERT INTO `harvard_byt_currencies` (`Id`, `currency_code`, `currency_label`, `currency_symbol`) VALUES ('1','aed','united arab emirates dirham',''),
599 ('2','ars','argentina peso',''),
600 ('3','aud','australia dollar',''),
601 ('4','bgn','bulgaria lev',''),
602 ('5','bob','bolivia boliviano',''),
603 ('6','brl','brazil real',''),
604 ('7','cad','canada dollar',''),
605 ('8','chf','switzerland franc',''),
606 ('9','clp','chile peso',''),
607 ('10','cny','china yuan renminbi',''),
608 ('11','czk','czech republic koruna',''),
609 ('12','dkk','denmark krone',''),
610 ('13','egp','egypt pound',''),
611 ('14','eur','euro','€'),
612 ('15','gbp','pound','£'),
613 ('16','hkd','hong kong dollar',''),
614 ('17','hrk','croatia kuna',''),
615 ('18','huf','hungary forint',''),
616 ('19','idr','indonesia rupiah',''),
617 ('20','ils','israel shekel',''),
618 ('21','inr','india rupee',''),
619 ('22','jpy','japan yen',''),
620 ('23','krw','korea (south) won',''),
621 ('24','ltl','lithuania litas',''),
622 ('25','mad','morocco dirham',''),
623 ('26','mxn','mexico peso',''),
624 ('27','myr','malaysia ringgit',''),
625 ('28','nok','norway krone',''),
626 ('29','nzd','new zealand dollar',''),
627 ('30','pen','peru nuevo sol',''),
628 ('31','php','philippines peso',''),
629 ('32','pkr','pakistan rupee',''),
630 ('33','pln','poland zloty',''),
631 ('34','ron','romania new leu',''),
632 ('35','rsd','serbia dinar',''),
633 ('36','rub','russia ruble',''),
634 ('37','sar','saudi arabia riyal',''),
635 ('38','sek','sweden krona',''),
636 ('39','sgd','singapore dollar',''),
637 ('40','thb','thailand baht',''),
638 ('41','trl','turkey lira',''),
639 ('42','twd','taiwan new dollar',''),
640 ('43','uah','ukraine hryvna',''),
641 ('44','usd','us dollar','$'),
642 ('45','vef','venezuela bolivar',''),
643 ('46','vnd','viet nam dong',''),
644 ('47','zar','south africa rand','');
645
646-- --------------------------------------------------------
647
648--
649-- Dumping data for table `harvard_comments`
650--
651
652INSERT INTO `harvard_comments` (`comment_ID`, `comment_post_ID`, `comment_author`, `comment_author_email`, `comment_author_url`, `comment_author_IP`, `comment_date`, `comment_date_gmt`, `comment_content`, `comment_karma`, `comment_approved`, `comment_agent`, `comment_type`, `comment_parent`, `user_id`) VALUES ('1','1','Monsieur WordPress','','https://wordpress.org/','','2015-05-16 19:50:13','2015-05-16 19:50:13','Bonjour, ceci est un commentaire.\nPour supprimer un commentaire, connectez-vous et affichez les commentaires de cet article. Vous pourrez alors les modifier ou les supprimer.','0','1','','','0','0');
653
654-- --------------------------------------------------------
655
656-- Dumping data for table `harvard_usermeta`
657--
658
659INSERT INTO `harvard_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES ('1','1','first_name',''),
660 ('2','1','last_name',''),
661 ('3','1','nickname','adil'),
662 ('4','1','description',''),
663 ('5','1','rich_editing','true'),
664 ('6','1','comment_shortcuts','false'),
665 ('7','1','admin_color','fresh'),
666 ('8','1','use_ssl','0'),
667 ('9','1','show_admin_bar_front','true'),
668 ('10','1','harvard_capabilities','a:1:{s:13:"administrator";b:1;}'),
669 ('11','1','harvard_user_level','10'),
670 ('12','1','dismissed_harvard_pointers','harvard350_media,harvard360_revisions,harvard360_locks,harvard390_widgets,harvard410_dfw'),
671 ('13','1','show_welcome_panel','1'),
672 ('14','1','harvard_dashboard_quick_press_last_post_id','2251'),
673 ('15','1','session_tokens','a:1:{s:64:"6b5aaee0fefbcb7d5efd547a0f244cb427476ccea5d52f4b36cd808cd53082dc";a:4:{s:10:"expiration";i:1438771050;s:2:"ip";s:14:"105.156.122.54";s:2:"ua";s:72:"Mozilla/5.0 (Windows NT 6.3; WOW64; rv:39.0) Gecko/20100101 Firefox/39.0";s:5:"login";i:1438598250;}}'),
674 ('16','1','harvard_user-settings','libraryContent=browse&editor=tinymce&hidetb=1&posts_list_mode=list'),
675 ('17','1','harvard_user-settings-time','1437566139'),
676 ('18','1','nav_menu_recently_edited','58'),
677 ('19','1','managenav-menuscolumnshidden','a:4:{i:0;s:11:"link-target";i:1;s:11:"css-classes";i:2;s:3:"xfn";i:3;s:11:"description";}'),
678 ('20','1','metaboxhidden_nav-menus','a:6:{i:0;s:8:"add-post";i:1;s:14:"add-templatera";i:2;s:12:"add-location";i:3;s:8:"add-tour";i:4;s:12:"add-post_tag";i:5;s:13:"add-tour_type";}'),
679 ('21','1','closedpostboxes_page','a:0:{}'),
680 ('22','1','metaboxhidden_page','a:6:{i:0;s:11:"postexcerpt";i:1;s:10:"postcustom";i:2;s:16:"commentstatusdiv";i:3;s:11:"commentsdiv";i:4;s:7:"slugdiv";i:5;s:9:"authordiv";}'),
681 ('23','1','layerslider_help_harvard_pointer','1'),
682 ('24','2','nickname','othman'),
683 ('25','2','first_name','othman'),
684 ('26','2','last_name',''),
685 ('27','2','description',''),
686 ('28','2','rich_editing','true'),
687 ('29','2','comment_shortcuts','false'),
688 ('30','2','admin_color','fresh'),
689 ('31','2','use_ssl','0'),
690 ('32','2','show_admin_bar_front','true'),
691 ('33','2','harvard_capabilities','a:1:{s:6:"editor";b:1;}'),
692 ('34','2','harvard_user_level','7'),
693 ('35','2','dismissed_harvard_pointers','harvard360_locks,harvard390_widgets,harvard410_dfw'),
694 ('36','2','session_tokens','a:2:{s:64:"832222d093c7b94a3911968502f176ce56b504e7ab64fa8e1291a5c17dfd747d";a:4:{s:10:"expiration";i:1434719493;s:2:"ip";s:15:"105.135.163.226";s:2:"ua";s:101:"Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.81 Safari/537.36";s:5:"login";i:1433509893;}s:64:"f3f85697ea8550ce142f30919d6551191c33989769196d2f8e087edecefe4299";a:4:{s:10:"expiration";i:1435438985;s:2:"ip";s:13:"105.152.52.29";s:2:"ua";s:138:"Mozilla/5.0 (Linux; Android 4.4.2; SM-N7505 Build/KOT49H) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.111 Mobile Safari/537.36";s:5:"login";i:1434229385;}}'),
695 ('37','2','harvard_dashboard_quick_press_last_post_id','2221'),
696 ('38','1','meta-box-order_page','a:3:{s:4:"side";s:46:"submitdiv,pageparentdiv,vc_teaser,postimagediv";s:6:"normal";s:111:"harvardb_visual_composer,postexcerpt,postcustom,commentstatusdiv,commentsdiv,slugdiv,authordiv,mymetabox_revslider_0";s:8:"advanced";s:0:"";}'),
697 ('39','1','screen_layout_page','2'),
698 ('40','2','closedpostboxes_page','a:0:{}'),
699 ('41','2','metaboxhidden_page','a:7:{i:0;s:12:"revisionsdiv";i:1;s:11:"postexcerpt";i:2;s:10:"postcustom";i:3;s:16:"commentstatusdiv";i:4;s:11:"commentsdiv";i:5;s:7:"slugdiv";i:6;s:9:"authordiv";}'),
700 ('42','2','harvard_user-settings','editor=tinymce&post_dfw=off&libraryContent=browse&hidetb=1&mfold=o'),
701 ('43','2','harvard_user-settings-time','1434505924'),
702 ('44','1','harvard_media_library_mode','list'),
703 ('45','2','closedpostboxes_tour','a:1:{i:0;s:12:"postimagediv";}'),
704 ('46','2','metaboxhidden_tour','a:1:{i:0;s:7:"slugdiv";}');
705
706-- --------------------------------------------------------
707
708--
709-- Dumping data for table `harvard_users`
710--
711
712INSERT INTO `harvard_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('1','adil','$P$BGrVzXncyE4t6kTyIFEcIq3RFWlZrs0','adil','adil.moufid@gmail.com','','2015-05-16 19:50:13','','0','adil'),
713 ('2','othman','$P$BjUN3cMnM9yP3aoBuRDa8cF391HLQv/','othman','visitamarruecos.tours@gmail.com','','2015-05-18 20:26:38','','0','othman');
714
715-- --------------------------------------------------------
716
717SET FOREIGN_KEY_CHECKS = 1;