/*
SQLyog Ultimate v12.4.3 (64 bit)
MySQL - 10.1.34-MariaDB : Database - unibridge
*********************************************************************
*/



CREATE DATABASE /*!32312 IF NOT EXISTS*/`unibridge` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `unibridge`;

/*Table structure for table `alamat` */


CREATE TABLE `alamat` (
  `id_alamat` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_negara` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_provinsi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_kota` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_pos` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` char(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` char(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_alamat`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `alamat` */

insert  into `alamat`(`id_alamat`,`nama_negara`,`nama_provinsi`,`nama_kota`,`alamat`,`kode_pos`,`phone`,`mobile`,`email`,`created_at`,`updated_at`) values 
(3,'Indonesia','Jakarta','TANGERANG','Alam Sutera Town Centre 10F/29\r\nJl. Alam Sutera Boulevard\r\nSerpong','15325','+62 2129008667/ +62 29008665','+62 8111668576','serpong@uni-bridge.com.au','2020-06-29 07:45:14','2020-07-16 07:49:41'),
(4,'Indonesia','Jawa Barat','BANDUNG','Jl. Kaca Kaca Wetan no. 3C','40261','+62 224264540/ +62 224264550','+62 85100087878','bandung@uni-bridge.com.au','2020-06-29 07:56:38','2020-07-16 07:50:17'),
(5,'Indonesia','Jawa Barat','BOGOR','Gedung Ditta (Pizza Hut Baranangsiang) <br>\r\nJl. Raya Pajajaran No. 29','16143','+62 2518390211/ +62 2518390212','+62 811980724','bogor@uni-bridge.com.au','2020-06-29 07:58:16','2020-07-16 07:51:13'),
(6,'Indonesia','Riau','PEKANBARU','Jl. Ahmad Yani No. 42','28156','+62 81371022002','+62 81371022002','pekanbaru@uni-bridge.com.au','2020-06-29 08:01:37','2020-07-16 07:51:55'),
(7,'Indonesia','Sulawesi Selatan','MAKASSAR','Jl. Rappocini Raya No.27, Rappocini','90222','+62 4118918791','+62 85342226899','makassar@uni-bridge.com.au','2020-06-29 08:11:59','2020-07-16 07:52:33'),
(8,'Indonesia','Jawa Timur','MALANG','Ruko Langsep 2C\r\nJl. Raya Langsep','65115','+62 341562929','+62 8113394557','malang@uni-bridge.com.au','2020-06-29 08:17:51','2020-07-16 07:53:23'),
(9,'Indonesia','Sumatera Selatan','PALEMBANG','Jl. Mayor Salim Batubara no. 1145-C\r\nKemuning Sekip Ujung','30127','+62 7115735377','+62 89655277270','palembang@uni-bridge.com.au','2020-06-29 08:44:43','2020-07-16 07:53:51'),
(10,'Indonesia','Jawa Timur','SURABAYA','Jl. R.A. Kartini no. 39','60264','+62 315680045','+62 8113093795','surabaya@uni-bridge.com.au','2020-06-29 08:45:56','2020-07-16 07:54:37');

/*Table structure for table `album` */


CREATE TABLE `album` (
  `id_album` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_album` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `foto` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_album`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `album` */

insert  into `album`(`id_album`,`nama_album`,`foto`,`created_at`,`updated_at`) values 
(5,'Unibridge','placeholder.jpg','2020-06-12 10:34:35','2020-07-07 03:16:33');

/*Table structure for table `banner` */


CREATE TABLE `banner` (
  `id_banner` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_banner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `foto` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi_indo` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_banner`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `banner` */

insert  into `banner`(`id_banner`,`nama_banner`,`foto`,`deskripsi`,`deskripsi_indo`,`created_at`,`updated_at`) values 
(3,'WELCOME TO UNI-BRIDGE','banner1.jpg','A Diploma program with options to do 4 or 8 months in Indonesia, prior to completing the Undergraduate Program (for 18 – 24 months) in Australia or Singapore','Program  Pendidikan  Diploma  dengan pilihan  untuk  kuliah  selama  4 bulan  atau  8  bulan  di  Indonesia,  sebelum menyelesaikan program Strata 1 [selama  18-24  bulan]  di Australia  atau  Singapura','2020-06-03 06:02:35','2020-07-14 08:54:05'),
(5,'WELCOME TO UNI-BRIDGE','ubububu.jpg','A 3 or 4 or 8 months held in Indonesia, is available for students who have completed SMA 1 or Year 10, and are planning to do their Bachelor Degree program overseas with affordable cost.','Program 3 atau 6 atau 8  bulan yang diselenggarakan  di  Indonesia  ini,  di peruntukan  bagi siswa/i  yang telah menyelesaikan SMA Kelas 1, dan  ingin  melanjutkan  pendidikannya  pada jenjang Strata 1  diluar  negeri, dengan  harga  terjangkau.','2020-07-07 03:53:15','2020-07-14 08:54:48');

/*Table structure for table `diploma` */


CREATE TABLE `diploma` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_lengkap` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tempat_lahir` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal_lahir` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `telepon_rumah` char(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nomor_telepon` char(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pendidikan_terakhir` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat_sekolah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kurikulum` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `current_qualification` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_ayah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nomor_ayah` char(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_ayah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_ibu` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nomor_ibu` char(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_ibu` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_wali` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nomor_wali` char(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_wali` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat_2` text COLLATE utf8mb4_unicode_ci,
  `program` enum('1','2') COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `campus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dokumen` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dokumen_2` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dokumen_3` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dokumen_4` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dokumen_5` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `diploma` */

insert  into `diploma`(`id`,`nama_lengkap`,`gender`,`tempat_lahir`,`tanggal_lahir`,`alamat`,`telepon_rumah`,`nomor_telepon`,`email`,`pendidikan_terakhir`,`alamat_sekolah`,`kurikulum`,`current_qualification`,`nama_ayah`,`nomor_ayah`,`email_ayah`,`nama_ibu`,`nomor_ibu`,`email_ibu`,`nama_wali`,`nomor_wali`,`email_wali`,`alamat_2`,`program`,`country`,`campus`,`city`,`dokumen`,`dokumen_2`,`dokumen_3`,`dokumen_4`,`dokumen_5`,`created_at`,`updated_at`) values 
(5,'Jhon Doe','','Bandung','21 July, 2000','Test','0811116488','0811116488','jhondoe@gmail.com','SMKN 11 Bandung','Jl budhi','2013','Test','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'1','','','','Uni-bridge Diploma.docx','Uni-bridge Diploma.docx','Uni-bridge English.docx','Uni-bridge English.docx','Uni-bridge Diploma.docx','2020-06-22 08:15:39','2020-06-22 08:15:39'),
(6,'Jhon Doe','','Bandung','21 July, 2000','Jl. Test','0811116488','0811116488','jhondoe@gmail.com','SMKN 11 Bandung','Jl budhi','2013','Test','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'2','','','','Uni-bridge Diploma.docx','Uni-bridge English.docx','Uni-bridge Diploma.docx','Uni-bridge English.docx','Uni-bridge Diploma.docx','2020-06-22 08:18:21','2020-06-22 08:18:21'),
(8,'Jhon Doe','','Bandung','21 July, 2000','pickadate-format','0811116488','0811116488','jhondoe@gmail.com','SMKN 11 Bandung','Jl budhiaaaaa','2013','pickadate-format','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'1','','','','Uni-bridge Diploma.docx','Uni-bridge English.docx','Uni-bridge Diploma.docx','Uni-bridge English.docx','Uni-bridge English.docx','2020-06-22 11:40:31','2020-06-22 11:40:31'),
(9,'Jhon Doe','Male','Bandung','21 July, 2000','test','0811116488','08113093795','jhondoe@gmail.com','SMKN 11 Bandung','Jl budhi','2013','test','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'2','INDONESIA','STMIK LIKMI','Bandung','BROKERBIZ MODULE to Sigit & Mira.xlsx','Hasil Checking CMS Uni-Bridge.docx','Uni-bridge Diploma.docx','Uni-bridge English.docx','Hasil Checking CMS Uni-Bridge.docx','2020-07-16 06:05:09','2020-07-16 06:05:09'),
(10,'Jhon Doe','Male','Bandung','21 July, 2000','Test','0811116488','0811116488','jhondoe@gmail.com','SMKN 11 Bandung','Jl budhi','2013','Test','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'2','AUSTRALIA','Kaplan Business School (KBS)','Brisbane','Hasil Checking CMS Uni-Bridge.docx','BROKERBIZ MODULE to Sigit & Mira.xlsx','Uni-bridge Diploma.docx','Uni-bridge English.docx','Hasil Checking CMS Uni-Bridge.docx','2020-07-17 03:42:54','2020-07-17 03:42:54'),
(11,'Jhon Doe','Male','Bandung','21 July, 2000','Test','0811116488','0811116488','jhondoe@gmail.com','SMKN 11 Bandung','Jl budhi','2013','Test','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,'Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','2020-07-17 03:50:36','2020-07-17 03:50:36'),
(12,'Jhon Doe','Male','Bandung','21 July, 2000','Test','0811116488','0811116488','sigitpermana2109@gmail.com','SMKN 11 Bandung','Jl budhi','2013','Test','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,'Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','2020-07-17 03:53:10','2020-07-17 03:53:10'),
(13,'Jhon Doe','Female','Bandung','0000-00-00','Test','0811116488','0811116488','jhondoe@gmail.com','SMKN 11 Bandung','Jl budhi','2013','test','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,'Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','2020-07-17 04:12:53','2020-07-17 04:12:53'),
(14,'Jhon Doe','Male','Bandung','21 July, 2000','test','0811116488','0811116488','admin@gmail.com','SMKN 11 Bandung','Jl budhi','2013','tset','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,'Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','Hasil Checking CMS Uni-Bridge.docx','2020-07-17 04:14:13','2020-07-17 04:14:13');

/*Table structure for table `foundation` */


CREATE TABLE `foundation` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `nama_lengkap` varchar(255) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `tempat_lahir` varchar(255) NOT NULL,
  `tanggal_lahir` varchar(255) NOT NULL,
  `alamat` text NOT NULL,
  `telepon_rumah` char(13) NOT NULL,
  `nomor_telepon` char(13) NOT NULL,
  `email` varchar(255) NOT NULL,
  `pendidikan_terakhir` varchar(255) NOT NULL,
  `alamat_sekolah` text NOT NULL,
  `kurikulum` varchar(255) NOT NULL,
  `current_qualification` varchar(255) NOT NULL,
  `nama_ayah` varchar(255) NOT NULL,
  `nomor_ayah` char(13) NOT NULL,
  `email_ayah` varchar(255) NOT NULL,
  `nama_ibu` varchar(255) NOT NULL,
  `nomor_ibu` char(1) NOT NULL,
  `email_ibu` varchar(255) NOT NULL,
  `nama_wali` varchar(255) DEFAULT NULL,
  `nomor_wali` char(13) DEFAULT NULL,
  `email_wali` varchar(255) DEFAULT NULL,
  `alamat_2` text,
  `years` char(4) NOT NULL,
  `stream` varchar(255) NOT NULL,
  `institution` varchar(255) NOT NULL,
  `course` varchar(255) NOT NULL,
  `campus` varchar(255) NOT NULL,
  `dokumen` text,
  `dokumen_2` text,
  `dokumen_3` text,
  `dokumen_4` text,
  `dokumen_5` text,
  `dokumen_6` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `foundation` */

insert  into `foundation`(`id`,`nama_lengkap`,`gender`,`tempat_lahir`,`tanggal_lahir`,`alamat`,`telepon_rumah`,`nomor_telepon`,`email`,`pendidikan_terakhir`,`alamat_sekolah`,`kurikulum`,`current_qualification`,`nama_ayah`,`nomor_ayah`,`email_ayah`,`nama_ibu`,`nomor_ibu`,`email_ibu`,`nama_wali`,`nomor_wali`,`email_wali`,`alamat_2`,`years`,`stream`,`institution`,`course`,`campus`,`dokumen`,`dokumen_2`,`dokumen_3`,`dokumen_4`,`dokumen_5`,`dokumen_6`,`created_at`,`updated_at`) values 
(1,'Jhon Doe','','Bandung','21 July, 2000','Test','0811116488','0811116488','jhondoe@gmail.com','SMKN 11 Bandung','Jl budhi','2013','Test','Test','0811116488','test@gmail.com','Test','0','test@gmail.com',NULL,NULL,NULL,NULL,'11','Science/ Health Science/ Engineering','','','','Konten laman Event-2-Indonesia.docx','Uni-bridge Foundation.docx','Konten laman_Event 1_Indonesia.docx','Konten laman Event-2-Indonesia.docx','05-ICON KEUNTUNGAN UB-BAHASA INDO.pdf','05-ICON KEUNTUNGAN UB-BAHASA INGGRIS.pdf','2020-07-17 11:20:18','2020-07-10 06:59:46'),
(2,'Jhon Doe','Male','Bandung','21 July, 2000','Test','0811116488','0811116488','jhondoe@gmail.com','SMKN 11 Bandung','Jl budhi','2013','Test','Test','0811116488','test@gmail.com','Test','0','test@gmail.com',NULL,NULL,NULL,NULL,'10','Business','Canning College – Western Australia','Western Australia Universities Foundation Program (WAUFP)','Perth','Hasil Checking CMS Uni-Bridge.docx','Uni-bridge Diploma.docx','Uni-bridge English.docx','Hasil Checking CMS Uni-Bridge.docx','Uni-bridge Diploma.docx','BROKERBIZ MODULE to Sigit & Mira.xlsx','2020-07-17 11:21:04','2020-07-17 03:30:40');

/*Table structure for table `galeri` */


CREATE TABLE `galeri` (
  `id_foto` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_album` bigint(20) unsigned NOT NULL,
  `judul_foto` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `foto` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_foto`),
  KEY `galeri_id_album_foreign` (`id_album`),
  CONSTRAINT `galeri_id_album_foreign` FOREIGN KEY (`id_album`) REFERENCES `album` (`id_album`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `galeri` */

insert  into `galeri`(`id_foto`,`id_album`,`judul_foto`,`foto`,`created_at`,`updated_at`) values 
(5,5,'Santo Aloysius Student Joining Uni-bridge Preparation Program','St Aloysius Student Joining Uni-bridge Preparation Program1.jpg','2020-07-07 03:17:55','2020-07-14 09:36:12'),
(6,5,'Uni-bridge Foundation at Canning College\'s Orientation Program','Uni-bridge Foundation at Canning College\'s Orientation Program1.jpg','2020-07-07 03:21:15','2020-07-14 09:36:41'),
(7,5,'Uni-bridge Information Day @SMA Aloysius Bandung 3-4 March 2018','Uni-bridge Information Day @SMA Aloysius Bandung 3-4 March 20181.jpg','2020-07-07 03:21:41','2020-07-14 09:37:02'),
(8,5,'Canning College - Graduation night June 2019','Canning College - Graduation night June 20191.jpg','2020-07-07 03:23:15','2020-07-14 09:37:29'),
(9,5,'Visit to Edith Cowan University - June 2019','Visit to Edith Cowan University - June 20191.jpg','2020-07-07 03:23:53','2020-07-14 09:37:48');

/*Table structure for table `identitas` */


CREATE TABLE `identitas` (
  `id_identitas` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_website` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nomor_telepon` char(13) COLLATE utf8mb4_unicode_ci NOT NULL,
  `favicon` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo_2` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_facebook` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_instagram` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_twitter` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi_indo` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_identitas`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `identitas` */

insert  into `identitas`(`id_identitas`,`nama_website`,`email`,`nomor_telepon`,`favicon`,`logo`,`logo_2`,`link_facebook`,`link_instagram`,`link_twitter`,`deskripsi`,`deskripsi_indo`,`created_at`,`updated_at`) values 
(1,'PT. University Bridging Indonesia','info@uni-bridge.com.au','0811116488','02-LOGO UB PNG.png','logo-hitam.png','02-LOGO UB PNG.png','https://web.facebook.com/unibridgeindonesiapage/?_rdc=1&_rdr','https://www.instagram.com/unibridge/','https://twitter.com/unibridgeub','<p style=\"margin-bottom:13px\"><span style=\"font-size:11pt\"><span style=\"line-height:normal\"><span style=\"font-family: sans-serif;font-size: 36px !important;\"><b><span style=\"font-size:36px\"><span sans=\"\" style=\"font-family:\"><span style=\"color:red\">WELCOME TO <br> UNI-BRIDGE</span></span></span></b></span></span></span></p>\r\n\r\n<p style=\"margin-bottom:13px\"><span style=\"font-size:11pt\"><span style=\"line-height:115%\"><span style=\"font-family: sans-serif;font-size: 16px !important;\"><span style=\"font-size:16px\"><span style=\"line-height:115%\"><span sans=\"\" style=\"font-family:\">The world of education is dynamic. It embraces fresh and challenging ideas on methods and means to facilitate and guide students on their journey within the world of knowledge. A group of scholars and professionals in Australia gathered a few years back, and decided to support the world of education, which then marked the birth of Uni-bridge Consortium Australia in 2008. The website would provide you with a deeper understanding on what we do, all in favor to the development of humanity and accordingly to the world of education.</span></span></span></span></span></span></p>','<p style=\"margin-bottom:13px\"><span style=\"font-size:11pt\"><span style=\"line-height:normal\"><span style=\"font-family: sans-serif;font-size: 36px !important;\"><b><span style=\"font-size:36px\"><span sans=\"\" style=\"font-family:\"><span style=\"color:red\">SELAMAT DATANG DI <br>UNI-BRIDGE</span></span></span></b></span></span></span></p>\r\n\r\n<p style=\"margin-bottom:13px\"><span style=\"font-size:11pt\"><span style=\"line-height:115%\"><span style=\"font-family: sans-serif;font-size: 16px !important;\"><span style=\"font-size:16px\"><span style=\"line-height:115%\"><span sans=\"\" style=\"font-family:\">Dunia Pendidikan adalah dunia yang dinamis. Dunia dengan ide dan tantangan yang segar dan baru, mengenai metoda dan sarana untuk memfasilitasi siswa/i, dalam perjalanannya menyusuri kencah pengetahuan yang luas. Sekumpulan ilmuwan dan profesional di Australia, berkumpul dan berdiskusi beberapa tahun lalu, dan memutuskan untuk mendukung dunia pendidikan, yang kemudian ditandai dengan lahirnya Uni-bridge Consortium Australia, di tahun 2008. Website ini akan memberikan informasi yang lebih dalam mengenai apa yang kami lakukan, yang kesemuanya ini diperuntukan bagi pengembangan kemanusiaan dan tentunya dunia Pendidikan.&nbsp;</span></span></span></span></span></span></p>','2020-05-29 16:21:32','2020-07-08 15:09:09');

/*Table structure for table `kategori` */


CREATE TABLE `kategori` (
  `id_kategori` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_kategori` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_kategori`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `kategori` */

insert  into `kategori`(`id_kategori`,`nama_kategori`,`created_at`,`updated_at`) values 
(4,'About Us','2020-06-08 06:03:30','2020-06-08 06:03:30'),
(5,'Benefits','2020-06-08 06:17:41','2020-06-13 04:12:40'),
(6,'About Program','2020-06-29 09:29:38','2020-06-29 09:29:38'),
(7,'Events','2020-07-01 09:44:09','2020-07-01 09:44:09'),
(8,'Program','2020-07-02 02:36:51','2020-07-02 02:37:35');

/*Table structure for table `kontak_event` */


CREATE TABLE `kontak_event` (
  `id_kontak_event` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_page` bigint(20) unsigned NOT NULL,
  `nama_lengkap` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nomor_telepon` char(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `jk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kota` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_kontak_event`),
  KEY `kontak_event_id_page_foreign` (`id_page`),
  CONSTRAINT `kontak_event_id_page_foreign` FOREIGN KEY (`id_page`) REFERENCES `page` (`id_page`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `kontak_event` */

insert  into `kontak_event`(`id_kontak_event`,`id_page`,`nama_lengkap`,`email`,`nomor_telepon`,`tanggal_lahir`,`jk`,`kota`,`created_at`,`updated_at`) values 
(2,15,'Jhon Doe','jhondoe@gmail.com','0811116488','2020-07-08','Male','Bandung','2020-07-02 03:37:07','2020-07-02 03:37:07'),
(3,15,'Jhon Doe','jhondoe@gmail.com','0811116488','2020-07-09','Male','Bandung','2020-07-02 06:08:27','2020-07-02 06:08:27'),
(5,24,'Jhon Doe','jhondoe@gmail.com','0811116488','2020-07-29','Male','Bandung','2020-07-07 07:33:01','2020-07-07 07:33:01'),
(6,17,'Jhon Doe','jhondoe@gmail.com','0811116488','2020-07-07','Male','Bandung','2020-07-07 07:38:31','2020-07-07 07:38:31'),
(7,18,'Jhon Doe','jhondoe@gmail.com','089123345','2020-07-06','Male','Bandung','2020-07-07 08:23:43','2020-07-07 08:23:43'),
(8,24,'Jhon Doe','jhondoe@gmail.com','089238786','2020-05-04','Male','Bandung','2020-07-07 09:19:20','2020-07-07 09:19:20'),
(9,24,'Jhon Doe','jhondoe@gmail.com','0811116488','2020-07-06','Male','Bandung','2020-07-07 13:53:31','2020-07-07 13:53:31');

/*Table structure for table `migrations` */


CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `migrations` */

insert  into `migrations`(`id`,`migration`,`batch`) values 
(1,'2020_05_27_032647_create_user_table',1),
(3,'2020_05_27_035821_create_identitas_table',2),
(4,'2020_05_27_042136_create_banner_table',3),
(7,'2020_05_27_042437_create_album_table',4),
(8,'2020_05_27_043324_create_galeri_table',5),
(9,'2020_05_27_044346_modifikasi_galeri_table',5),
(10,'2020_05_27_050902_create_galeri_table',6),
(11,'2020_05_27_051339_create_galeri_table',7),
(12,'2020_05_27_060523_create_event_table',8),
(13,'2020_05_27_061034_create_testimoni_table',9),
(14,'2020_05_27_061926_create_program_table',10),
(15,'2020_05_27_062127_create_partner_table',11),
(16,'2020_05_29_083236_create_alamat_table',12),
(17,'2020_05_29_084240_modifikasi_identitas_table',13),
(18,'2020_05_29_084703_update_identitas_table',14),
(19,'2020_05_29_084824_update2_identitas_table',15),
(20,'2020_05_29_090525_update3_identitas_table',16),
(21,'2020_06_03_054145_update4_identitas_table',17),
(22,'2020_06_03_091614_create_visitor_table',17),
(23,'2020_06_08_032358_create_kategori_table',18),
(24,'2020_06_08_034659_create_page_table',19),
(25,'2020_06_19_063606_create_reg_english_table',20),
(26,'2020_06_19_081443_create_diploma_table',21),
(27,'2020_06_29_093804_create_program_table',22),
(28,'2020_06_30_071046_create_kontak_table',23),
(29,'2020_06_30_080050_create_kontak_table',24),
(30,'2020_07_02_015844_create_kontak_event_table',25);

/*Table structure for table `page` */


CREATE TABLE `page` (
  `id_page` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_kategori` bigint(20) unsigned NOT NULL,
  `judul_page` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `seo_page` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi_indo` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `foto` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `thumbnail` text COLLATE utf8mb4_unicode_ci,
  `video` text COLLATE utf8mb4_unicode_ci,
  `status` enum('draft','publish') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_page`),
  KEY `id_kategori` (`id_kategori`),
  CONSTRAINT `page_ibfk_1` FOREIGN KEY (`id_kategori`) REFERENCES `kategori` (`id_kategori`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `page` */

insert  into `page`(`id_page`,`id_kategori`,`judul_page`,`seo_page`,`deskripsi`,`deskripsi_indo`,`foto`,`thumbnail`,`video`,`status`,`created_at`,`updated_at`) values 
(4,4,'About Us','about-us','<p font-family: sans-serif;font-size: 16px !important;\">In collaboration with Uni-bridge Indonesia, Uni-bridge Consortium Australia designs a number of programs. The main objective of all programs created, is to offer opportunities for students who have plans and/ or interests in continuing their study overseas, to start their first stage of learning in Indonesia, rather than directly to the selected country of destination.<br></p>','<p font-family: sans-serif; font-size: 16px! important; \"> Bekerja sama dengan Uni-bridge Indonesia, Uni-bridge Konsorsium Australia merancang sejumlah program. Tujuan utama dari semua program yang dibuat, adalah untuk menawarkan peluang bagi siswa yang memiliki rencana dan / atau minat melanjutkan studi di luar negeri, untuk memulai tahap pertama pembelajaran mereka di Indonesia, daripada langsung ke negara tujuan yang dipilih. <br> </p>','default.png','',NULL,'publish','2020-06-08 06:06:50','2020-06-08 06:06:50'),
(5,5,'Saving of costs','saving-of-costs','<p>Saving of costs</p>','','SAVING-COST1.png','HEMAT-BIAYA1.png',NULL,'publish','2020-06-08 06:17:41','2020-07-14 08:43:35'),
(6,5,'Study duration','study-duration','<p>Scattered study location</p>','','TEACHING-TEAM1.png','TEACHING-TEAM1.png',NULL,'publish','2020-06-08 06:17:41','2020-07-14 08:44:09'),
(7,5,'Use of English as the media of communication','use-of-english-as-the-media-of-communication','<p>Study duration</p>','','QUALIFIED-PROGRAM1.png','PROGRAM-BERKUALITAS1.png',NULL,'publish','2020-06-08 06:17:41','2020-07-14 08:44:47'),
(8,5,'Scattered study location','scattered-study-location','<p>Use of English as the media of communication</p>','','STRUCTURE-ONLINE-LEARNING1.png','FORMAT-PEMBELAJARAN1.png',NULL,'publish','2020-06-08 06:17:41','2020-07-14 08:45:39'),
(13,6,'We’re here to support the world of education','were-here-to-support-the-world-of-education','The programs is to offer opportunities for students who have plans and/or interests in continuing their study overseas, to start their first stage of learning in Indonesia, rather than directly to the selected country of destination.','Program-program ini menawarkan kesempatan bagi siswa yang memiliki rencana dan / atau minat untuk melanjutkan studi mereka di luar negeri, untuk memulai tahap pertama pembelajaran mereka di Indonesia, daripada langsung ke negara tujuan yang dipilih.','user.png','',NULL,'publish','2020-06-29 09:31:34','2020-06-29 09:31:34'),
(15,8,'UNI-BRIDGE ENGLISH','uni-bridge-english','<p><span style=\"font-size:16px\">It is still undeniable, that the use of English plays an important role, not only within the education world, but in many significant aspects, in the field of education and employment. To date, students and employees are recommended, to use the language well &amp; properly.</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Embracing the idea, Uni-bridge English designs programs on the study of this language, for students and adults as follows:</span></p>\r\n\r\n<p><span style=\"font-size:16px\"><strong>Preparation programs to sit for English language exams from Cambridge Assessment English:</strong></span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">English for Young Learners (Starters, Movers &amp; Flyers)</span></li>\r\n	<li><span style=\"font-size:16px\">Key English Test (KET)</span></li>\r\n	<li><span style=\"font-size:16px\">Preliminary English Test (PET)</span></li>\r\n	<li><span style=\"font-size:16px\">International English Language Testing System (IELTS)</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\">The program is available to be implemented by any educational institutions, i.e. formal and/ or non-formal. When the program is to run at any formal education institution, then it is to only function as a supplement to the main curriculum employed in the respected schools/ universities. However, should the program be adopted by a non-formal institution, then it is feasible to be offered as the main program.</span></p>\r\n\r\n<p><span style=\"font-size:16px\"><strong>CERTIFICATE IV IN TESOL (TEACHING ENGLISH TO SPEAKERS OF OTHER LANGUAGES)</strong></span></p>\r\n\r\n<p><span style=\"font-size:16px\">For this program, Uni-bridge English collaborates with Holmesglen Institute of TAFE &ndash; Australia. The qualification gained from the program is internationally recognized. Each learning aspect has been designed in such a way that that participants will have the competency to:</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">Analyse the relationship between culture and learning to create an inclusive learning environment</span></li>\r\n	<li><span style=\"font-size:16px\">Understand the English language and its use in communication</span></li>\r\n	<li><span style=\"font-size:16px\">Gain knowledge of the genre-based approach to teaching English</span></li>\r\n	<li><span style=\"font-size:16px\">Plan lessons and classroom management strategies</span></li>\r\n	<li><span style=\"font-size:16px\">Understand and teach grammar, spelling and pronunciation</span></li>\r\n	<li><span style=\"font-size:16px\">Teach others to speak, listen to, read and write English</span></li>\r\n	<li><span style=\"font-size:16px\">Evaluate English ability Create, collect and collate teaching resources</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\"><strong>CONVERSATION CLASSES</strong></span></p>\r\n\r\n<p><span style=\"font-size:16px\">This type of classes in learning English is always interesting and very popular as the delivery format is dynamic and interactive. The topic discussed in each meeting, will be related to ideas/ themes which have been designed in tune with some daily activities, which are dynamic and always interesting, such as: travelling, shopping, going to the coffee shops, etc.</span></p>','<p><span style=\"font-size:16px\">Tidak dapat dipungkiri, bahwa penggunaan bahasa Inggris tetap memegang peranan penting, bukan saja di dunia pendidikan, namun didalam banyak aspek, seperti halnya di dunia kerja. Sampai dengan saat ini, para siswa/i dan karyawan, sangat direkomendasikan untuk dapat menggunakan bahasa Inggris, dengan baik dan benar.</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Beranjak dari ide ini, Uni-bridge English merancang program pembelajaran bahasa Inggris, untuk pelajar dan orang dewasa, sebagai berikut:</span></p>\r\n\r\n<p><span style=\"font-size:16px\"><strong>PROGRAM PERSIAPAN UNTUK UJIAN &ndash; UJIAN BAHASA INGGRIS DARI CAMBRIDGE ASSESSMENT ENGLISH</strong></span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">English for Young Learners (Starters, Movers &amp; Flyers)</span></li>\r\n	<li><span style=\"font-size:16px\">Key English Test (KET)</span></li>\r\n	<li><span style=\"font-size:16px\">Preliminary English Test (PET)</span></li>\r\n	<li><span style=\"font-size:16px\">International English Language Testing System (IELTS)</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\">Program bahasa Inggris dari Cambridge ini dapat diimplementasikan oleh semua institusi pendidikan formal maupun non-formal. Jika program ini dijalankan di institusi pendidikan formal, maka program ini hanya berfungsi sebagai program pendukung pada pembelajaran bahasa Inggris, dan tidak menggantikan program/ kurikulum yang dijalankan di sekolah/ institusi pendidikan tersebut. Namun, jika program ini diadopsi oleh institusi pendidikan non-formal, maka program ini dapat dijalankan sebagai program utama.</span></p>\r\n\r\n<p><span style=\"font-size:16px\"><strong>CERTIFICATE IV IN TESOL (TEACHING ENGLISH TO SPEAKERS OF OTHER LANGUAGES)</strong></span></p>\r\n\r\n<p><span style=\"font-size:16px\">Untuk program ini, Uni-bridge English berkolaborasi dengan Holmesglen Institute of TAFE (Government College) &ndash; Australia. Kualifikasi yang dicapai dari program ini diakui secara internasional. Setiap aspek pembelajaran yang diberikan, telah dirancang sedemikian rupa agar setiap peserta memiliki kompetensi untuk:</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">Menganalisa hubungan antar budaya, dan belajar menciptakan suasana dan lingkungan belajar yang mengikutsertakan budaya setempat</span></li>\r\n	<li><span style=\"font-size:16px\">Memahami bahasa Inggris, dan penggunaannya dalam berkomunikasi</span></li>\r\n	<li><span style=\"font-size:16px\">Mendapatkan pengetahuan mengenai model penyampaian dalam pengajaran bahasa Inggris</span></li>\r\n	<li><span style=\"font-size:16px\">Mampu membuat perencanaan materi pelajaran bahasa Inggris dan strategi penyampaiannya dikelas</span></li>\r\n	<li><span style=\"font-size:16px\">Memahami pengajaran bahasa Inggris yang berhubungan dengan tatabahasa, pengejaan dan pengucapan</span></li>\r\n	<li><span style=\"font-size:16px\">Mengajar bahasa Inggris kepada peserta didik, untuk berbicara, mendengar, membaca dan menulis dalam bahasa Inggris</span></li>\r\n	<li><span style=\"font-size:16px\">Mengevaluasi kemampuan berbahasa Inggris dari para peserta didik, dengan cara membuat, mengumpulkan, dan menyusun bahan pengajaran</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\"><strong>CONVERSATION CLASSES</strong></span></p>\r\n\r\n<p><span style=\"font-size:16px\">Kelas &lsquo;Conversation&rsquo; selalu menjadi model pembelajaran bahasa Inggris yang menarik dan paling banyak diminati, oleh karena format pembelajarannya bersifat dinamis, dan interaktif. Topik yang dipilih dalam setiap pertemuan akan mengangkat ide/ tema yang disesuaikan dengan pilihan-pilihan topik terkini, sesuai dengan kehidupan sehari-hari yang serba dinamis dan selalu menarik, seperti misalnya: berwisata, belanja, ke coffee shop dan lain sebagainya.</span></p>','icon-program-english.png','thumbnail-program-english.png','https://youtu.be/tDUqhZRmWDQ','publish','2020-07-02 02:36:51','2020-07-17 09:14:12'),
(17,8,'UNI-BRIDGE DIPLOMA MODEL 1','uni-bridge-diploma-model-1','<p><span style=\"font-size:16px\">The program prepares students to study those subjects, normally studied on the first year of Undergraduate Program, particularly in Business field. Upon completion of the program in Indonesia, students have the option to continue their study for the Bachelor Degree overseas, i.e. to those institutions in partnership with Uni-bridge Consortium Australia. The most unique aspect of the program is on the possibility of running it as a &rsquo;Year 13&rsquo; for Secondary Level students or Year 1 program on the Tertiary Level of study.</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Today, we have 2 model of Uni-bridge Diploma, in collaboration with different partners of Uni-bridge Consortium Australia.</span></p>\r\n\r\n<h3><span style=\"font-size:16px\">Model 1</span></h3>\r\n\r\n<p><span style=\"font-size:16px\">The collaboration is with Canning College &ndash; Perth, Western Australia. In short, the format of the program is as follows:</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">Complete Year 12 ➙ 4 subjects at Uni-bridge Partner&rsquo;s school/ universities in Indonesia ➙ 4 subjects of Diploma of Commerce at Canning College, Perth &ndash; Western Australia ➙ Second Year of Bachelor of Commerce at Curtin University &ndash; Perth, Western Australia</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\">There are some added value to this model, as follows:</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">International English Language Testing System (IELTS) Preparation Program</span></li>\r\n	<li><span style=\"font-size:16px\">1 time Free of Charge - International English Language Testing System (IELTS) &ndash; Academic Version</span></li>\r\n	<li><span style=\"font-size:16px\">Students will also have a laptop and headset</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\">The diagram hereunder, would provide you with you with a better understanding of the program:</span></p>\r\n\r\n<figure class=\"easyimage easyimage-full\"><img alt=\"\" src=\"/upload/page/03-BAGAN-CURTIN-INGGRsssssIS.png\" width=\"100%\" />\r\n<figcaption></figcaption>\r\n</figure>\r\n\r\n<p><span style=\"font-size:16px\">On the second Year of Bachelor of Commerce at Curtin University &ndash; Perth, Western Australia, students will have a variety of majors to choose from:</span></p>\r\n\r\n<figure class=\"easyimage easyimage-full\"><img alt=\"\" src=\"/upload/page/03-Pilihan-Bidang-Studi-Curtin-University-INGGRISsssss.png\" width=\"100%\" />\r\n<figcaption></figcaption>\r\n</figure>\r\n\r\n<p>&nbsp;</p>','<p><span style=\"font-size:16px\">Program ini mempersiapkan siswa/i untuk mempelajari mata kuliah, yang lazimnya dipelajari di tahun pertama pada jenjang program Strata 1, khususnya bidang Bisnis. Setelah menyelesaikan program ini di Indonesia, siswa/i memiliki opsi untuk melanjutkan studi pada jenjang Strata 1 di luar negeri, yaitu ke institusi &ndash; institusi yang merupakan rekanan dari Uni-bridge Consortium Australia. Aspek unik dari program ini adalah, pembelajaran dengan model &lsquo;Block System&rsquo; per 4 (empat) bulan untuk 4 (empat) mata kuliah dari tahun pertama jenjang universitas.</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Saat ini kami memiliki 2 model program Uni-bridge Diploma. Masing &ndash; masing model berkolaborasi dengan institusi yang berbeda, sebagai rekanan dari Uni-bridge Consortium Australia:</span></p>\r\n\r\n<h3><span style=\"font-size:16px\"><strong>Model 1</strong></span></h3>\r\n\r\n<p><span style=\"font-size:16px\">Rekanan untuk model 1 ini adalah dengan Canning College (A Government College) di Perth, Western Australia. Format dari program ini adalah sebagai berikut:</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">Selesai SMA kelas 3 atau setara ➙ mengambil 4 mata kuliah di Indonesia ➙ selanjutnya mengambil 4 mata kuliah dari program Diploma of Commerce di Canning College, Perth &ndash; Western Australia ➙ selanjutnya tahun ke-2 (dua) program Bachelor of Commerce di Curtin University &ndash; Perth, Western Australia</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\">Ada beberapa nilai tambah pada model 1 dari progam ini yaitu:</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">Diberikan pembelajaran International English Language Testing System (IELTS) Preparation Program</span></li>\r\n	<li><span style=\"font-size:16px\">1 kali Free of Charge - International English Language Testing System (IELTS) &ndash; Versi Akademik</span></li>\r\n	<li><span style=\"font-size:16px\">Siswa/i sebagai peserta program mendapatkan 1 laptop dan headset</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\">Diagram di bawah ini, akan memberikan penjelasan mengenai program tersebut di atas:</span></p>\r\n\r\n<figure class=\"easyimage easyimage-full\"><img alt=\"\" src=\"/upload/page/03-BAGAN-CURTIN-INDONESIAaaaaaa.png\" width=\"100%\" />\r\n<figcaption></figcaption>\r\n</figure>\r\n\r\n<p><span style=\"font-size:16px\">Ditahun kedua pada program Bachelor of Commerce di Curtin University &ndash; Perth, Western Australia, para siswa/i memiliki opsi yang bervariasi untuk bidang studi yang akan ditekuni, yaitu:</span></p>\r\n\r\n<figure class=\"easyimage easyimage-full\"><img alt=\"\" src=\"/upload/page/03-Pilihan-Bidang-Studi-Curtin-University-INGGRISsssss.png\" width=\"100%\" />\r\n<figcaption></figcaption>\r\n</figure>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>','icon-program-diploma1.png','thumbnail-program-diploma1.png','https://youtu.be/A84c1m2iTKM','publish','2020-07-02 02:36:51','2020-07-17 09:14:43'),
(18,8,'UNI-BRIDGE DIPLOMA MODEL 2','uni-bridge-diploma-model-2','<p><span style=\"font-size:16px\">The second model of the Diploma Program also allows students completing the Secondary Level of study, to do 8 (eight) subjects in Indonesia, of which are normally studied at Year 1 of the university level, especially in Business field. Afterward, students will continue to the Year 2 (two) on the Undergraduate Level overseas, i.e. to those partner institutions of Uni-bridge Consortium Australia.&nbsp; In tune with the first model, the second model of Uni-bridge Diploma Program will also make use of the &lsquo;Block System&rsquo; for the 4 (four) months study duration on 4 (four) subjects.</span></p>\r\n\r\n<p><span style=\"font-size:16px\">As such, the 8 (eight) subjects, will be completed in 8 months, which is actually of the same number of subjects taken on the first year of university. After the 8(eight) subjects in Indonesia, students will be accepted into Year 2 of the Undergraduate Level at the partner universities of Uni-bridge Consortium Australia. To complete the Undergraduate Degree at an institution in Australia or Singapore (with a degree from United Kingdom), it will take between 18 to 24 months study duration.</span></p>\r\n\r\n<p style=\"text-align:justify\"><span style=\"font-size:16px\">Model 2</span></p>\r\n\r\n<p><span style=\"font-size:16px\">This model allows students to complete their Bachelor Degree in a number of institutions overseas in partnership with Uni-bridge Consortium Australia, such as:</span></p>\r\n\r\n<ol>\r\n	<li><span style=\"font-size:16px\">RMIT University &ndash; Melbourne, Australia*</span></li>\r\n	<li><span style=\"font-size:16px\">Kaplan Business School &ndash; Australia (Campus: Adelaide, Brisbane, Melbourne, Sydney)</span></li>\r\n	<li><span style=\"font-size:16px\">Melbourne Institute of Technology &ndash; Australia (Campus: Melbourne, Sydney)</span></li>\r\n	<li><span style=\"font-size:16px\">De Montfort University &ndash; United Kingdom, at East Asia Institute of Management (EASB) -&nbsp; Singapore</span></li>\r\n	<li><span style=\"font-size:16px\">Queen Margaret University &ndash; Scotland, at East Asia Institute of Management (EASB) &ndash; Singapore</span></li>\r\n	<li><span style=\"font-size:16px\">Royal Holloway, University of London &ndash; United Kingdom at Kaplan Singapore</span></li>\r\n	<li><span style=\"font-size:16px\">University College Dublin &ndash; Ireland at Kaplan Singapore</span></li>\r\n</ol>\r\n\r\n<p><span style=\"font-size:16px\">There are some added value to model 2 of Uni-bridge Diploma Program, as follows:</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">Be entitled to an International English Language Testing System (IELTS) Preparation Program</span></li>\r\n	<li><span style=\"font-size:16px\">1 time Free of Charge - International English Language Testing System (IELTS) &ndash; Academic Version</span></li>\r\n	<li><span style=\"font-size:16px\">Students of the program will also have a laptop and headset</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\">The diagram hereunder, will provide a clearer picture about the above program :</span></p>\r\n\r\n<figure class=\"easyimage easyimage-full\"><img alt=\"\" src=\"/upload/page/bagan-diploma2-ing.png\" width=\"100%\" />\r\n<figcaption></figcaption>\r\n</figure>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>','<p><span style=\"font-size:16px\">Model kedua dari Program Diploma ini, siswa/i yang telah menyelesaikan Jenjang Sekolah Menengah Atas, mengambil 8 (delapan) mata kuliah di Indonesia, yang merupakan mata pelajaran tahun pertama pada jenjang program Strata 1, khususnya bidang Bisnis. Selanjutnya siswa/i melanjutkan studi di tahun ke 2 (dua) pada jenjang Strata 1 di luar negeri, yaitu ke institusi &ndash; institusi yang merupakan rekanan dari Uni-bridge Consortium Australia. Sama halnya seperti model 1, model 2 dari program Diploma ini, model pembelajarannya diselenggarakan dengan menggunakan model block system per 4 (empat) bulan untuk 4 (empat) mata kuliah.</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Dengan demikian, untuk 8 (delapan) mata kuliah, diselesaikan dalam jangka waktu 8 bulan, yang sama dengan kuliah tahun pertama di jenjang universitas. Selesai mengambil 8 (delapan) mata kuliah di Indonesia, selanjutnya diterima di tahun kedua, jenjang program Strata 1 di universitas-universitas rekanan dari Uni-bridge Consortium Australia. Untuk menyelesaikan program Strata 1 di institusi tertentu di Australia atau New Zealand atau Singapore (dengan gelar sarjana dari United Kingdom), dapat ditempuh dalam jangka waktu 18 s/d 24 bulan.</span></p>\r\n\r\n<h3><span style=\"font-size:16px\">Model 2</span></h3>\r\n\r\n<p><span style=\"font-size:16px\">Model ini membuka kesempatan bagi siswa/i untuk menyelesaikan program Strata 1 di institusi rekanan dari Uni-bridge Consortium Australia, sebagai berikut:</span></p>\r\n\r\n<ol>\r\n	<li><span style=\"font-size:16px\">RMIT University &ndash; Melbourne, Australia<strong>*</strong></span></li>\r\n	<li><span style=\"font-size:16px\">Kaplan Business School &ndash; Australia (Campus: Adelaide, Brisbane, Melbourne, Sydney)</span></li>\r\n	<li><span style=\"font-size:16px\">Melbourne Institute of Technology &ndash; Australia (Campus: Melbourne, Sydney)</span></li>\r\n	<li><span style=\"font-size:16px\">De Montfort University &ndash; United Kingdom, at East Asia Institute of Management (EASB) - Singapore</span></li>\r\n	<li><span style=\"font-size:16px\">Queen Margaret University &ndash; Scotland, at East Asia Institute of Management (EASB) &ndash; Singapore</span></li>\r\n	<li><span style=\"font-size:16px\">Royal Holloway, University of London &ndash; United Kingdom at Kaplan Singapore</span></li>\r\n	<li><span style=\"font-size:16px\">University College Dublin &ndash; Ireland at Kaplan Singapore</span></li>\r\n</ol>\r\n\r\n<p><span style=\"font-size:16px\">Beberapa nilai tambah pada model 2 dari program ini yaitu:</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">Diberikan pembelajaran International English Language Testing System (IELTS) Preparation Program</span></li>\r\n	<li><span style=\"font-size:16px\">1 kali Free of Charge - International English Language Testing System (IELTS) &ndash; Versi Akademik</span></li>\r\n	<li><span style=\"font-size:16px\">Siswa/i sebagai peserta program mendapatkan 1 laptop dan headset</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\">Diagram di bawah ini, akan memberikan penjelasan mengenai program tersebut di atas:</span></p>\r\n\r\n<figure class=\"easyimage easyimage-full\"><img alt=\"\" src=\"/upload/page/bagan-diploma2-ind.png\" width=\"100%\" />\r\n<figcaption></figcaption>\r\n</figure>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>','icon-program-diploma2.png','thumbnail-program-diploma2.png','https://youtu.be/A84c1m2iTKM','publish','2020-07-02 02:36:51','2020-07-17 09:15:12'),
(19,8,'UNI-BRIDGE PREPARATION PROGRAM','uni-bridge-preparation-program','<p><span style=\"font-size:16px\">Uni-bridge Foundation Program is a pre-university program for students who are planning to continue their study of Undergraduate Degree overseas only. A Foundation program, however, is normally offered to students who have completed their Senior High and decided to continue their study overseas for the Undergraduate level.</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Uni-bridge Foundation Program, is offered to students who have completed Year 9 (=SMP 3) and Year 10 (=SMA 1) or O level. Students participating on the Uni-bridge Foundation Program, will sit for the interest &amp; talent test. The result of this test, will assist the students in selecting the streams available: Science or Business. In Science, students will study Math, Chemistry, Physics as well as English. For those who will do Business, then their concentration will be on Math, Economics &amp; Accounting and English.</span></p>\r\n\r\n<p><span style=\"font-size:16px\">On completion of the Uni-bridge Foundation in Indonesia, students will do the final stage of the Foundation Program, at Uni-bridge&rsquo;s partner institutions overseas such as at:</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">Bellerbys College &ndash; United Kingdom (Campus: Brighton, Cambridge, London)</span></li>\r\n	<li><span style=\"font-size:16px\">Canning College &ndash; Perth, Western Australia</span></li>\r\n	<li><span style=\"font-size:16px\">East Asia Institute of Management &ndash; Singapore</span></li>\r\n	<li><span style=\"font-size:16px\">UP Education &ndash; New Zealand</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\">The following diagram is the description of the Uni-bridge Foundation Program:</span></p>\r\n\r\n<figure class=\"easyimage easyimage-full\"><img alt=\"\" src=\"/upload/page/bagan-inggrisssss.png\" width=\"100%\" />\r\n<figcaption></figcaption>\r\n</figure>\r\n\r\n<p>&nbsp;</p>','<p><span style=\"font-size:16px\">Program Uni-bridge Foundation adalah program pra-universitas hanya bagi siswa/i yang hendak melanjutkan studinya ke luar negeri, untuk jenjang Strata 1. Program foundation, biasanya diselenggarakan bagi para siswa/i yang telah menyelesaikan pendidikan pada jenjang Sekolah Menengah Atas dan bermaksud untuk melanjutkan studi di luar negeri pada jenjang Strata 1.</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Program Uni-bridge Foundation, diperuntukan bagi siswa/i yang telah menyelesaikan SMP 3 (=Year 9) dan SMA 1 (=Year 10) atau O level. Pada program Uni-bridge Foundation, para siswa/i akan diberikan tes minat dan bakat. Hasil tes ini akan menolong mereka untuk menentukan fokus bidang studi yang akan ditekuni yaitu: &lsquo;Science&rsquo; atau &lsquo;Business&rsquo;. Di bidang &lsquo;Science&rsquo;, para siswa/i akan mempelajari pelajaran: Matematika, Kimia, Fisika serta Bahasa Inggris. Untuk siswa/i yang memilih untuk fokus pada bidang &lsquo;Business&rsquo;, konsentrasi mata pelajaran yang harus diambilnya yaitu: Matematika, Ekonomi, Akunting dan Bahasa Inggris.</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Setelah menyelesaikan program Uni-bridge Foundation di Indonesia, siswa/i melanjutkan tahap akhir dari jenjang program Foundation, di institusi pendidikan di luar negeri, yang dapat dipilih:</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">Bellerbys College &ndash; United Kingdom (Campus: Brighton, Cambridge, London)</span></li>\r\n	<li><span style=\"font-size:16px\">Canning College &ndash; Perth, Western Australia</span></li>\r\n	<li><span style=\"font-size:16px\">East Asia Institute of Management &ndash; Singapore</span></li>\r\n	<li><span style=\"font-size:16px\">UP Education &ndash; New Zealand</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\">Diagram berikut ini merupakan gambaran program Uni-bridge Foundation:</span></p>\r\n\r\n<figure class=\"easyimage easyimage-full\"><img alt=\"\" src=\"/upload/page/bagan-indonesiaaaaa.png\" width=\"100%\" />\r\n<figcaption></figcaption>\r\n</figure>\r\n\r\n<p>&nbsp;</p>','icon-program-foundations.png','thumbnail-program-preparation.png',NULL,'publish','2020-07-02 02:36:51','2020-07-17 09:15:43'),
(24,7,'Uni-bridge Diploma','uni-bridge-diploma','<ul>\r\n	<li><span style=\"font-size:16px\">Mengenal Minat Bakat &amp; Perilaku Anak: Strategi untuk Menentukan Jurusan Studi Lanjut</span></li>\r\n	<li><span style=\"font-size:16px\">Strategi Memilih Universitas di Luar Negeri untuk Studi Lanjut</span></li>\r\n</ul>\r\n\r\n<table style=\"width:100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n			<div>\r\n			<p style=\"text-align:center\"><strong><span style=\"font-size:12.0pt\"><span style=\"color:red\">Saturday, 11 July&nbsp;2020</span></span></strong></p>\r\n\r\n			<p style=\"text-align:center\"><strong><span style=\"font-size:12.0pt\"><span style=\"color:red\">10.00 AM &ndash; 12.30 PM</span></span></strong></p>\r\n			</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<p><span style=\"font-size:16px\"><strong>Speakers: </strong></span></p>\r\n\r\n<ol>\r\n	<li><span style=\"font-size:16px\">Sapta Dwikardana, PhD &ndash;Behavioral Analyst &amp; Principal Advisor ALESI Indonesia</span></li>\r\n	<li><span style=\"font-size:16px\">Sugie J. Hambali, Drs., M.Com (Hons) &ndash;Chief Executive Officer Uni-bridge Indonesia</span></li>\r\n	<li><span style=\"font-size:16px\">Pertiwi Megasari, S.AP., MH &ndash; Manager Business Development &amp; Program BJB Precious</span></li>\r\n	<li><span style=\"font-size:16px\">Bpk. Hieronymus Sunarto &ndash; Kepala Bidang Pendidikan Yayasan Panca Dharma</span></li>\r\n</ol>\r\n\r\n<p><span style=\"font-size:16px\"><strong>Moderator: </strong></span></p>\r\n\r\n<p><span style=\"font-size:16px\">Nancy Sudarmo, BCom</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Group Manager ~ Business Administration</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Uni-bridge Indonesia</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style=\"font-size:16px\">Thank you,</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Tim Uni-bridge</span></p>','<ul>\r\n	<li><span style=\"font-size:16px\">Mengenal Minat Bakat &amp; Perilaku Anak: Strategi untuk Menentukan Jurusan Studi Lanjut</span></li>\r\n	<li><span style=\"font-size:16px\">Strategi Memilih Universitas di Luar Negeri untuk Studi Lanjut</span></li>\r\n</ul>\r\n\r\n<table style=\"width:100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n			<div>\r\n			<p style=\"text-align:center\"><strong><span style=\"font-size:12.0pt\"><span style=\"color:red\">Sabtu, 11 Juli 2020</span></span></strong></p>\r\n\r\n			<p style=\"text-align:center\"><strong><span style=\"font-size:12.0pt\"><span style=\"color:red\">Jam 10.00 &ndash; 12.30 WIB</span></span></strong></p>\r\n			</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<p><span style=\"font-size:16px\"><strong>Pembicara: </strong></span></p>\r\n\r\n<ol>\r\n	<li><span style=\"font-size:16px\">Sapta Dwikardana, PhD &ndash;Behavioral Analyst &amp; Principal Advisor ALESI Indonesia</span></li>\r\n	<li><span style=\"font-size:16px\">Sugie J. Hambali, Drs., M.Com (Hons) &ndash;Chief Executive Officer Uni-bridge Indonesia</span></li>\r\n	<li><span style=\"font-size:16px\">Pertiwi Megasari, S.AP., MH &ndash; Manager Business Development &amp; Program BJB Precious</span></li>\r\n	<li><span style=\"font-size:16px\">Bpk. Hieronymus Sunarto &ndash; Kepala Bidang Pendidikan Yayasan Panca Dharma</span></li>\r\n</ol>\r\n\r\n<p><span style=\"font-size:16px\"><strong>Moderator: </strong></span></p>\r\n\r\n<p><span style=\"font-size:16px\">Nancy Sudarmo, BCom</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Group Manager ~ Business Administration</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Uni-bridge Indonesia</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style=\"font-size:16px\">Terima kasih,</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Tim Uni-bridge</span></p>','eventsbosco.jpg','banner-event-1-fix.png',NULL,'publish','2020-07-01 09:44:09','2020-07-16 08:01:17'),
(26,7,'Uni-bridge Diploma','uni-bridge-diploma','<p><span style=\"font-size:16px\">This program is available for students who have completed SMA 3 or Year 12, and:</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">are interested to continue their study on Undergraduate level concentrating in Business</span></li>\r\n	<li><span style=\"font-size:16px\">have the objective to commence study in 2020</span></li>\r\n	<li><span style=\"font-size:16px\">are considering to study in Australia or Singapore</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\">Come and join the online seminar on this program on:</span></p>\r\n\r\n<p style=\"text-align:center\"><strong><span style=\"color:#e74c3c\"><span style=\"font-size:16px\">Saturday, 18 July 2020<br />\r\n10.00 AM - 12.00 PM</span></span></strong></p>\r\n\r\n<p><span style=\"font-size:16px\">The ONLINE seminar&nbsp; will cover all aspects you may have on this program. Please do the RSVP by completing the registration form on the right hand sight of this page, then we will send you the invitation to your email.</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style=\"font-size:16px\">Thank you,</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Uni-bridge Team</span></p>','<p><span style=\"font-size:16px\">Program ini khusus tersedia bagi siswa/i yang telah menyelesaikan SMA 3 atau Year 12, dan:</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">tertarik untuk melanjutkan studi ke jenjang Strata 1 di bidang bisnis</span></li>\r\n	<li><span style=\"font-size:16px\">ingin mulai studi tahun 2020</span></li>\r\n	<li><span style=\"font-size:16px\">berencana untuk melanjutkan studi di Australia atau di Singapore</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\">Hadiri seminar online untuk program ini pada:</span></p>\r\n\r\n<p style=\"text-align:center\"><span style=\"font-size:16px\"><span style=\"color:#e74c3c\"><strong>Sabtu, 18 Juli 2020</strong></span></span><br />\r\n<span style=\"color:#e74c3c\"><strong><span style=\"font-size:16px\">10.00 AM - 12.00 PM</span></strong></span></p>\r\n\r\n<p><span style=\"font-size:16px\">Seminar ONLINE ini akan mengupas tuntas semua pertanyaan Anda mengenai program ini.</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Silahkan melakukan RSVP dengan mengisi formulir di bagian kanan, dan kami akan mengirimkan undangan untuk mengikuti acara ini melalui alamat email yang Anda berikan.</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style=\"font-size:16px\">Terima kasih,</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Tim Uni-bridge</span></p>','banner1.jpg','banner-event-2-fix.png',NULL,'publish','2020-07-01 09:44:09','2020-07-17 06:11:37'),
(27,5,'Multi bahasa','multi-bahasa','<p>Multi Bahasa</p>','<p>Multi Bahasa</p>','BILINGUAL-COMMUNICATION1.png','DUA-BAHASA1.png',NULL,'publish',NULL,'2020-07-14 08:47:40'),
(28,5,'Flexible','flexible','<p>Flexible</p>','<p>Flexible</p>','FLEXIBLE-STUDY1.png','DURASI-BELAJAR1.png',NULL,'publish',NULL,'2020-07-14 08:50:23');

/*Table structure for table `partner` */


CREATE TABLE `partner` (
  `id_partner` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_partner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci,
  `deskripsi_indo` text COLLATE utf8mb4_unicode_ci,
  `foto` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `asal` enum('lokal','internasional') COLLATE utf8mb4_unicode_ci NOT NULL,
  `negara` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kota` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_partner`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `partner` */

insert  into `partner`(`id_partner`,`nama_partner`,`deskripsi`,`deskripsi_indo`,`foto`,`asal`,`negara`,`kota`,`link`,`created_at`,`updated_at`) values 
(2,'UP Education','<p><span style=\"font-size:16px\">In association with AUTH &amp; Victoria University - New Zealand&nbsp; UTAS, Swimburne Academy CDU International College - Australia</span></p>','<p><span style=\"font-size:16px\">Bekerja sama dengan AUTH &amp; Victoria University - Selandia Baru UTAS, Swimburne Academy CDU International College - Australia</span></p>','partner8.png','internasional','New Zealand',NULL,'https://www.up.education/','2020-06-29 06:12:37','2020-07-17 09:05:07'),
(3,'KAPLAN','<p><span style=\"font-size:16px\">In association with Royal Halloway, University of London - United Kingdom &amp; Queen Margaret University - United Kingdom</span></p>','<p><span style=\"font-size:16px\">Bekerja sama dengan Royal Halloway, Universitas London - Inggris &amp; Universitas Queen Margaret - Inggris</span></p>','Partner-kaplan-200x200.png','internasional','Singapore',NULL,'https://kaplan-learning.com/?gclid=CjwKCAjw_-D3BRBIEiwAjVMy7Hv1vAEgtFS7ON1vMzbMDYlrpcP1L_hmJR10f3uLaVTqJiROcNcU7xoCeh0QAvD_BwE','2020-06-29 06:18:29','2020-07-17 09:05:32'),
(4,'East Asia Institute of Management','<p><span style=\"font-size:16px\">In association with De Montfort University &amp; Queen Margaret University - United Kingdom</span></p>','<p><span style=\"font-size:16px\">Bekerja sama dengan De Montfort University &amp; Queen Margaret University - Inggris</span></p>','partner9.png','internasional','Singapore',NULL,'https://www.easb.edu.sg/en/','2020-06-29 06:14:22','2020-07-17 09:05:57'),
(5,'KAPLAN',NULL,NULL,'partner10.png','internasional','SA, BNE, SYD, MELB',NULL,'https://kaplan-learning.com/?gclid=CjwKCAjw_-D3BRBIEiwAjVMy7Hv1vAEgtFS7ON1vMzbMDYlrpcP1L_hmJR10f3uLaVTqJiROcNcU7xoCeh0QAvD_BwE','2020-06-29 06:15:30','2020-07-17 09:06:55'),
(6,'Melbourne Instistute of Technology',NULL,NULL,'partner-200x200.png','internasional','Australia',NULL,'https://www.mit.edu.au/','2020-06-29 06:20:42','2020-07-17 09:07:51'),
(7,'RMIT University',NULL,NULL,'Partner-RMIT-200x200.png','internasional','Australia',NULL,'https://www.rmit.edu.au/study-with-us/international-students/indonesia-enquire?gclid=CjwKCAjw_-D3BRBIEiwAjVMy7AafFGQtya6oUaNXNmEIFiA-CqdhqwcSh3RU0tBj7By1f3EH_Gl8IRoCy38QAvD_BwE&gclsrc=aw.ds','2020-06-29 06:22:07','2020-07-17 09:08:19'),
(8,'Darma Yudha',NULL,NULL,'partner1.png','lokal','Riau','Pekanbaru','https://darmayudha.com/id/','2020-06-29 09:16:57','2020-07-09 12:25:12'),
(9,'SMA Katolik Rajawali',NULL,NULL,'partner2.png','lokal','Sulawesi Selatan','Makassar','http://www.smarajawalimakassar.sch.id/smakara/','2020-06-29 09:19:53','2020-07-09 12:26:19'),
(10,'Papua National School',NULL,NULL,'partner3.png','lokal','Papua','Jayapura','#','2020-06-29 09:23:20','2020-07-17 09:09:32'),
(11,'Santo Aloysius',NULL,NULL,'Partner-aloy-200x200.png','lokal','Jawa Barat','Bandung','#','2020-06-29 09:24:27','2020-07-17 09:10:30'),
(12,'Scola LMS',NULL,NULL,'scola-lms.png','lokal','Jawa Barat','Bandung','https://scola.id/','2020-06-29 09:25:06','2020-07-17 09:10:59'),
(13,'Universitas Putera Batam',NULL,NULL,'Partner-upb-200x200.png','lokal','Kepulauan Riau','Batam','https://www.upbatam.ac.id/','2020-06-29 09:26:22','2020-07-17 09:11:49'),
(17,'Canning College','<p><span style=\"font-size:16px\">Graduates of the institutions have until today managed to get entry into the following universities worldwide</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">Curtin University &ndash; Western Australia</span></li>\r\n	<li><span style=\"font-size:16px\">Edith Cowan University &ndash; Western Australia</span></li>\r\n	<li><span style=\"font-size:16px\">Murdoch University &ndash; Western Australia</span></li>\r\n	<li><span style=\"font-size:16px\">Notre Dame University &ndash; Western Australia</span></li>\r\n	<li><span style=\"font-size:16px\">UWA &ndash; Western Australia</span></li>\r\n	<li><span style=\"font-size:16px\">Monash University &ndash; Melbourne, Australia</span></li>\r\n	<li><span style=\"font-size:16px\">University of Melbourne - Australia</span></li>\r\n	<li><span style=\"font-size:16px\">RMIT University &ndash; Melbourne, Australia</span></li>\r\n	<li><span style=\"font-size:16px\">Kobe Design University &ndash; Japan</span></li>\r\n	<li><span style=\"font-size:16px\">University of Sydney &ndash; Australia</span></li>\r\n	<li><span style=\"font-size:16px\">Australian National University &ndash; Canberra, Australia</span></li>\r\n	<li><span style=\"font-size:16px\">Nottingham University &ndash; United Kingdom</span></li>\r\n	<li><span style=\"font-size:16px\">Humber Institute of Technology &ndash; Toronto, Canada</span></li>\r\n</ul>','<p><span style=\"font-size:16px\">Lulusan institusi tersebut hingga hari ini berhasil masuk ke universitas-universitas berikut di seluruh dunia</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">Curtin University &ndash; Western Australia</span></li>\r\n	<li><span style=\"font-size:16px\">Edith Cowan University &ndash; Western Australia</span></li>\r\n	<li><span style=\"font-size:16px\">Murdoch University &ndash; Western Australia</span></li>\r\n	<li><span style=\"font-size:16px\">Notre Dame University &ndash; Western Australia</span></li>\r\n	<li><span style=\"font-size:16px\">UWA &ndash; Western Australia</span></li>\r\n	<li><span style=\"font-size:16px\">Monash University &ndash; Melbourne, Australia</span></li>\r\n	<li><span style=\"font-size:16px\">University of Melbourne - Australia</span></li>\r\n	<li><span style=\"font-size:16px\">RMIT University &ndash; Melbourne, Australia</span></li>\r\n	<li><span style=\"font-size:16px\">Kobe Design University &ndash; Japan</span></li>\r\n	<li><span style=\"font-size:16px\">University of Sydney &ndash; Australia</span></li>\r\n	<li><span style=\"font-size:16px\">Australian National University &ndash; Canberra, Australia</span></li>\r\n	<li><span style=\"font-size:16px\">Nottingham University &ndash; United Kingdom</span></li>\r\n	<li><span style=\"font-size:16px\">Humber Institute of Technology &ndash; Toronto, Canada</span></li>\r\n</ul>','canning-college-fix.png','internasional','Australia',NULL,'https://www.canningcollege.wa.edu.au/Home__Canning_College.htm','2020-07-07 04:17:36','2020-07-17 09:12:17'),
(18,'Bellerbys College','<p><span style=\"font-size:16px\">Graduates of the institutions have until today managed to get entry into the following universities in United Kingdom</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">University of Birmingham</span></li>\r\n	<li><span style=\"font-size:16px\">University of Bristol</span></li>\r\n	<li><span style=\"font-size:16px\">University of Cambridge</span></li>\r\n	<li><span style=\"font-size:16px\">Cardiff University</span></li>\r\n	<li><span style=\"font-size:16px\">Durham University</span></li>\r\n	<li><span style=\"font-size:16px\">University of Edinburgh</span></li>\r\n	<li><span style=\"font-size:16px\">University of Exeter</span></li>\r\n	<li><span style=\"font-size:16px\">University of Glasgow</span></li>\r\n	<li><span style=\"font-size:16px\">Imperial College London</span></li>\r\n	<li><span style=\"font-size:16px\">King&rsquo;s College London</span></li>\r\n	<li><span style=\"font-size:16px\">University of Leeds&nbsp;</span></li>\r\n	<li><span style=\"font-size:16px\">University of Liverpool</span></li>\r\n	<li><span style=\"font-size:16px\">London School of Economics &amp; Political Science</span></li>\r\n	<li><span style=\"font-size:16px\">University of Manchester</span></li>\r\n	<li><span style=\"font-size:16px\">Newcastle University</span></li>\r\n	<li><span style=\"font-size:16px\">University of Nottingham</span></li>\r\n	<li><span style=\"font-size:16px\">University of Oxford</span></li>\r\n	<li><span style=\"font-size:16px\">Queen Mary, University of London</span></li>\r\n	<li><span style=\"font-size:16px\">Queen&rsquo;s University Belfast</span></li>\r\n	<li><span style=\"font-size:16px\">University of Sheffield</span></li>\r\n	<li><span style=\"font-size:16px\">University of Southampton</span></li>\r\n	<li><span style=\"font-size:16px\">University College London</span></li>\r\n	<li><span style=\"font-size:16px\">University of Warwick</span></li>\r\n	<li><span style=\"font-size:16px\">University of York</span></li>\r\n</ul>','<p><span style=\"font-size:16px\">Lulusan institusi tersebut hingga hari ini berhasil masuk ke universitas-universitas berikut di Inggris</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">University of Birmingham</span></li>\r\n	<li><span style=\"font-size:16px\">University of Bristol</span></li>\r\n	<li><span style=\"font-size:16px\">University of Cambridge</span></li>\r\n	<li><span style=\"font-size:16px\">Cardiff University</span></li>\r\n	<li><span style=\"font-size:16px\">Durham University</span></li>\r\n	<li><span style=\"font-size:16px\">University of Edinburgh</span></li>\r\n	<li><span style=\"font-size:16px\">University of Exeter</span></li>\r\n	<li><span style=\"font-size:16px\">University of Glasgow</span></li>\r\n	<li><span style=\"font-size:16px\">Imperial College London</span></li>\r\n	<li><span style=\"font-size:16px\">King&rsquo;s College London</span></li>\r\n	<li><span style=\"font-size:16px\">University of Leeds&nbsp;</span></li>\r\n	<li><span style=\"font-size:16px\">University of Liverpool</span></li>\r\n	<li><span style=\"font-size:16px\">London School of Economics &amp; Political Science</span></li>\r\n	<li><span style=\"font-size:16px\">University of Manchester</span></li>\r\n	<li><span style=\"font-size:16px\">Newcastle University</span></li>\r\n	<li><span style=\"font-size:16px\">University of Nottingham</span></li>\r\n	<li><span style=\"font-size:16px\">University of Oxford</span></li>\r\n	<li><span style=\"font-size:16px\">Queen Mary, University of London</span></li>\r\n	<li><span style=\"font-size:16px\">Queen&rsquo;s University Belfast</span></li>\r\n	<li><span style=\"font-size:16px\">University of Sheffield</span></li>\r\n	<li><span style=\"font-size:16px\">University of Southampton</span></li>\r\n	<li><span style=\"font-size:16px\">University College London</span></li>\r\n	<li><span style=\"font-size:16px\">University of Warwick</span></li>\r\n	<li><span style=\"font-size:16px\">University of York</span></li>\r\n</ul>','canning-college.png','internasional','United Kingdom',NULL,'https://www.bellerbys.com/','2020-07-07 04:22:55','2020-07-17 09:12:44'),
(19,'Indonesia','<p><span style=\"font-size:16px\">PARTNERS IN THE PROCESS OF COLLABORATION</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">Sekolah BPK Penabur - Bandung</span></li>\r\n	<li><span style=\"font-size:16px\">Universitas Kristen Maranatha - Bandung</span></li>\r\n	<li><span style=\"font-size:16px\">LPP Unpar+ - Bandung</span></li>\r\n	<li><span style=\"font-size:16px\">Pusdiklat Marwita Magiswara - Bandung</span></li>\r\n	<li><span style=\"font-size:16px\">PT Bank Jawa Barat and&nbsp;Banten</span></li>\r\n	<li><span style=\"font-size:16px\">Kompas group - Jakarta</span></li>\r\n	<li><span style=\"font-size:16px\">Universitas Telkom - Bandung</span></li>\r\n	<li><span style=\"font-size:16px\">Sekolah Don Bosco - Jakarta</span></li>\r\n	<li><span style=\"font-size:16px\">Karunia Global School - Jambi</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\">And many more</span></p>','<p><span style=\"font-size:16px\">MITRA DALAM PROSES KERJA SAMA</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">Sekolah BPK Penabur - Bandung</span></li>\r\n	<li><span style=\"font-size:16px\">Universitas Kristen Maranatha - Bandung</span></li>\r\n	<li><span style=\"font-size:16px\">LPP Unpar+ - Bandung</span></li>\r\n	<li><span style=\"font-size:16px\">Pusdiklat Marwita Magiswara - Bandung</span></li>\r\n	<li><span style=\"font-size:16px\">PT Bank Jawa Barat and&nbsp;Banten</span></li>\r\n	<li><span style=\"font-size:16px\">Kompas group - Jakarta</span></li>\r\n	<li><span style=\"font-size:16px\">Universitas Telkom - Bandung</span></li>\r\n	<li><span style=\"font-size:16px\">Sekolah Don Bosco - Jakarta</span></li>\r\n	<li><span style=\"font-size:16px\">Karunia Global School - Jambi</span></li>\r\n</ul>\r\n\r\n<p><span style=\"font-size:16px\">Dan masih banyak lagi</span></p>','partner-thumbnail.png','lokal','Indonesia','Indonesia','#','2020-07-16 08:20:19','2020-07-16 08:20:19'),
(20,'Indonesia','<p><span style=\"font-size:16px\">PARTNERS IN THE PROCESS OF EXTENDING THE COLLABORATION</span></p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">PT Bank Mandiri</span></li>\r\n	<li><span style=\"font-size:16px\">PT Bank Central Asia</span></li>\r\n	<li><span style=\"font-size:16px\">PT Bank CIMB Niaga</span></li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>','<p>MITRA DALAM PROSES MEMPERPANJANG KERJASAMA</p>\r\n\r\n<ul>\r\n	<li><span style=\"font-size:16px\">PT Bank Mandiri</span></li>\r\n	<li><span style=\"font-size:16px\">PT Bank Central Asia</span></li>\r\n	<li><span style=\"font-size:16px\">PT Bank CIMB Niaga</span></li>\r\n</ul>','partner-thumbnail.png','lokal','Indonesia','Indonesia','#','2020-07-16 08:22:46','2020-07-17 06:00:52');

/*Table structure for table `student` */


CREATE TABLE `student` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_lengkap` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tempat_lahir` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal_lahir` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `telepon_rumah` char(13) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nomor_telepon` char(13) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `usia` enum('student','adult') COLLATE utf8mb4_unicode_ci NOT NULL,
  `pendidikan_terakhir` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat_sekolah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kurikulum` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `current_qualification` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_ayah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nomor_ayah` char(13) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_ayah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_ibu` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nomor_ibu` char(13) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_ibu` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_wali` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nomor_wali` char(13) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_wali` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat_2` text COLLATE utf8mb4_unicode_ci,
  `program` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dokumen` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dokumen_2` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dokumen_3` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `student` */

insert  into `student`(`id`,`nama_lengkap`,`gender`,`tempat_lahir`,`tanggal_lahir`,`alamat`,`telepon_rumah`,`nomor_telepon`,`email`,`usia`,`pendidikan_terakhir`,`alamat_sekolah`,`kurikulum`,`current_qualification`,`nama_ayah`,`nomor_ayah`,`email_ayah`,`nama_ibu`,`nomor_ibu`,`email_ibu`,`nama_wali`,`nomor_wali`,`email_wali`,`alamat_2`,`program`,`dokumen`,`dokumen_2`,`dokumen_3`,`created_at`,`updated_at`) values 
(8,'Jhon Doe','','Bandung','21 July, 2000','Test','0811116488','0811116488','jhondoe@gmail.com','student','SMKN 11 Bandung','Jl. Budhi','2013','Test','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'flyers','Uni-bridge Diploma.docx','Uni-bridge English.docx','Uni-bridge Diploma.docx','2020-06-22 07:54:27','2020-06-22 07:54:27'),
(9,'Jhon Doe','','Bandung','21 July, 2000','Jl. Test','0811116488','0811116488','jhondoe@gmail.com','adult','SMKN 11 Bandung','Test','Test','Test','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'20_hours','Uni-bridge English.docx','Uni-bridge Diploma.docx','default.png','2020-06-22 08:19:39','2020-06-22 08:19:39'),
(18,'Jhon Doe','','Bandung','21 July, 2000','Test','0811116488','0811116488','jhondoe@gmail.com','student','SMKN 11 Bandung','Jl. Budhi','2013','Test','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'pre_starters','Uni-bridge Diploma.docx','Uni-bridge English.docx','default.png','2020-06-22 11:37:33','2020-06-22 11:37:33'),
(19,'Jhon Doe','','Bandung','21 July, 2000','Test','0811116488','0811116488','jhondoe@gmail.com','student','SMKN 11 Bandung','Jl. Budhi','2013','Test','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'pre_starters','Uni-bridge Diploma.docx','Hasil Checking CMS Uni-Bridge.docx','default.png','2020-06-30 03:20:34','2020-06-30 03:20:34'),
(20,'Jhon Doe','','Bandung','21 July, 2000','Test','0811116488','0811116488','jhondoe@gmail.com','student','SMKN 11 Bandung','Jl. Budhi','2013','Test','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'certificate_iv','Uni-bridge English.docx','Hasil Checking CMS Uni-Bridge.docx','default.png','2020-06-30 03:28:49','2020-06-30 03:28:49'),
(21,'Jhon Doe','','Bandung','21 July, 2000','Test','0811116488','0811116488','jhondoe@gmail.com','student','SMKN 11 Bandung','Jl. Budhi','2013','Test','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'pre_starters','Uni-bridge Diploma.docx','Uni-bridge English.docx','default.png','2020-06-30 03:32:21','2020-06-30 03:32:21'),
(22,'Jhon Doe','','Bandung','21 July, 2000','Test','0811116488','0811116488','jhondoe@gmail.com','student','SMKN 11 Bandung','Jl. Budhi','2013','Test','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'pre_starters','Hasil Checking CMS Uni-Bridge.docx','Uni-bridge English.docx','default.png','2020-06-30 03:35:02','2020-06-30 03:35:02'),
(23,'Jhon Doe','Male','Bandung','21 July, 2000','Test','0811116488','0811116488','jhondoe@gmail.com','student','SMKN 11 Bandung','Jl. Budhi','2013','TEst','Test','0811116488','test@gmail.com','Test','0891234567890','test@gmail.com',NULL,NULL,NULL,NULL,'CERTIFICATE IV IN TESOL','Hasil Checking CMS Uni-Bridge.docx','Uni-bridge Diploma.docx','Uni-bridge English.docx','2020-07-17 02:34:00','2020-07-17 02:34:00');

/*Table structure for table `testimoni` */


CREATE TABLE `testimoni` (
  `id_testimoni` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi_indo` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `asal_sekolah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `foto` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_testimoni`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `testimoni` */

insert  into `testimoni`(`id_testimoni`,`nama`,`deskripsi`,`deskripsi_indo`,`asal_sekolah`,`foto`,`created_at`,`updated_at`) values 
(3,'Muhamad Ihsan H.','This program offers one year courses in Indonesia and one year in Australia for Bachelor Business. A one-year experience at STMIK LIKMI – Bandung is great. The experience of studying in Melbourne, Australia is very impressive because I can get to know new cultures, make new friends and learn new things.','Program ini menawarkan untuk mengikuti program satu tahun di Indonesia dan satu tahun di Australia untuk Bachelor Business. Pengalaman selama satu tahun di STKMIK LIKMI – Bandung, sangat menyenangkan. Pengalaman berkuliah di Melbourne, Australia sangat mengesankan karena saya dapat mengenal budaya baru, mendapat teman-teman baru dan pembelajaran baru.','Student of Uni-bridge Diploma Bandung 2014','avatar3.png','2020-06-03 05:59:58','2020-07-08 15:18:40'),
(5,'Mr. Tanu Kartawiria & Mrs. Rafi Mamangdean','The Uni-bridge program not only make our children become on the lessons and majors that they will be chose during their college time, but also make them a much more mature, independent, disciplined person, and can manage time and finances more wisely.','Program Uni-bridge tidak hanya membuat anak-anak kami fokus dalam pelajaran dan jurusan yang akan dipilih saat berkuliah, tetapi juga membuat mereka menjadi pribadi yang jauh lebih dewasa, mandiri, disiplin, dan bisa mengatur waktu serta keuangan dengan lebih bijak.','Parents of Brian Ezra & Tristan Adriel (Uni-bridge Foundation Bandung 2012 & 2014)','avatar4.png','2020-06-29 06:39:45','2020-07-08 15:19:15'),
(6,'Amanda Sjahli','Learning english with UB was very fun. It was one of my favorite subjects every year. I had learned so many lessons, such as grammar, verbs, adjectives, writing, listening, and speaking. I also learned to be more disciplined. It’s always fun to learn English, and sometimes we got to play games with our classmates and the teacher as well. Thank you teachers, for teaching us.','Belajar bahasa Inggris bersama Uni-bridge sangat menyenangkan. Ini adalah salah satu pelajaran favorit saya setiap tahun. Banyak yang telah saya pelajari di program ini, seperti grammar, verbs, adjectives, writing, listening dan speaking. Saya juga belajar untuk lebih disiplin. Selalu menyenangkan untuk belajar bahasa Inggris, dan terkadang kami dapat bermain game dengan teman sekelas dan guru Uni-bridge kami. Terima kasih guru Uni-bridge telah mengajar kami.','St. Aloysius (Sultan Agung Campus)','avatar5.png','2020-06-29 06:41:02','2020-07-08 15:19:40'),
(7,'Mr. Hadi Purnomo Djayasaputra & Mrs. Dharmawati Liman (Sisil)','Uni-bridge has been amazing in assisting our child academically, so that he could study abroad and graduate from a university in Australia. Uni-bridge Program helps our son to be focus and independent in such a way that Toto managed to continue his study overseas and graduated from Monash University with excellent result.','Uni-bridge sangat membantu anak kami untuk dapat kuliah hingga lulus dari universitas di Australia. Program Uni-bridge membuat anak kami menjadi fokus dan mandiri sehingga Toto dapat melanjutkan studi dan lulus dari Monash dengan hasil yang memuaskan.','Parents of Christophorus Raymond Djayasaputra (Uni-bridge Foundation Bandung 2011)','avatar6.png','2020-06-29 06:41:48','2020-07-08 15:20:08'),
(8,'Kent Mulyadi','The Uni-bridge Foundation is honestly great. In my opinion it’s one of the best selections for school. Teachers are fun, the place isn’t loud. Although some teachers may be loud, they are intresting people to talk to. No regrets, apply your child in it now and I’m positive they won’t get bullied. It\'s faster than most programs, so that they can start life earlier. So yeah, the school is what I woud call efficient. Not too much stress, fluffy companions everywhere if you make effort to befriend them, fun teachers to talk with, and a relatively quick school life for the child. I don’t think there is a more effective program than this one.','Jujur, menurut saya Uni-bridge Foundation itu hebat. Program ini adalah salah satu pilihan yang terbaik menurut pendapat saya. Guru-gurunya menyenangkan, dan tempat belajar-nya tidak berisik. Meskipun beberapa guru memang bersuara keras, tetap mereka merupakan orang – orang yang menarik untuk diajak bicara. Tidak ada penyesalan, daftarkanlah anak anda ke program ini sekarang, dan saya yakin mereka tidak akan di bully. Program ini lebih cepat durasinya dibanding kebanyakan program serupa, sehingga para siswa-nya bisa mulai masuk dalam dunia nyata lebih awal. Jadi ya, program ini adalah program yang saya sebut efisien.Tidak terlalu stress, teman – teman yang baik, jika saja kamu berusaha untuk berteman dengan mereka, guru – guru yang menyenangkan untuk diajak bicara, dana masa bersekolah yang cepat untuk seorang siswa. Saya piker thidak ada program lain yang lebih efektif disbanding program ini.','Student of Uni-bridge Foundation Bandung 2019','avatar8.png','2020-06-29 06:42:47','2020-07-08 15:20:36'),
(9,'Diandra Elizabeth','Uni-Bridge Foundation is a great program that allows me to study my desired course, which is science, and ELACS (English Language and Australian Cultural Studies). The teachers are great, and they’re very supportive of the students. This past year studying at St. Aloysius Uni-Bridge Foundation Program has been an excellent experience. Through this program, I’ve become more prepared and more confident to attend university in Australia.','Uni-Bridge Foundation adalah program bagus, yangmembuat saya dapat mempelajari bisang studi yang saya sukai, yaitu Sains dan ELACS (English Language and Australian Cultural Studies). Guru-gurunya juga hebat, dan mereka sangat mendukung siswa-siswanya. Belajar di St. Aloysius Uni-Bridge Foundation Program merupakan pengalaman yang luar biasa. Melalui program ini, saya menjadi lebih siap dan yakin untuk masuk ke jenjang universitas di Australia.','Student of Uni-bridge Foundation Bandung 2019','avatar7.png','2020-06-29 06:43:29','2020-07-08 15:20:59');

/*Table structure for table `visitor` */


CREATE TABLE `visitor` (
  `id_visitor` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tanggal` date NOT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `counter` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `browser` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id_visitor`)
) ENGINE=InnoDB AUTO_INCREMENT=185 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `visitor` */

insert  into `visitor`(`id_visitor`,`tanggal`,`ip_address`,`counter`,`browser`) values 
(43,'2020-05-27','127.0.0.1','1','Chrome/Opera'),
(44,'2020-05-28','127.0.0.1','1','Chrome/Opera'),
(45,'2020-05-28','127.0.0.1','1','Chrome/Opera'),
(46,'2020-05-29','127.0.0.1','1','Chrome/Opera'),
(47,'2020-05-29','127.0.0.1','1','Chrome/Opera'),
(48,'2020-05-29','127.0.0.1','1','Chrome/Opera'),
(49,'2020-05-30','127.0.0.1','1','Chrome/Opera'),
(50,'2020-05-30','127.0.0.1','1','Chrome/Opera'),
(51,'2020-05-31','127.0.0.1','1','Chrome/Opera'),
(52,'2020-05-31','127.0.0.1','1','Chrome/Opera'),
(53,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(54,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(55,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(56,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(57,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(58,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(59,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(60,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(61,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(62,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(63,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(64,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(65,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(66,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(67,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(68,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(69,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(70,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(71,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(72,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(73,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(74,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(75,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(76,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(77,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(78,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(79,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(80,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(81,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(82,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(83,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(84,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(85,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(86,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(87,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(88,'2020-06-03','127.0.0.1','1','Chrome/Opera'),
(89,'2020-06-08','127.0.0.1','1','Chrome/Opera'),
(90,'2020-06-08','127.0.0.1','1','Chrome/Opera'),
(91,'2020-06-08','127.0.0.1','1','Chrome/Opera'),
(92,'2020-06-08','127.0.0.1','1','Chrome/Opera'),
(93,'2020-06-08','127.0.0.1','1','Chrome/Opera'),
(94,'2020-06-08','127.0.0.1','1','Chrome/Opera'),
(95,'2020-06-08','127.0.0.1','1','Chrome/Opera'),
(96,'2020-06-08','127.0.0.1','1','Chrome/Opera'),
(97,'2020-06-08','127.0.0.1','1','Chrome/Opera'),
(98,'2020-06-08','127.0.0.1','1','Chrome/Opera'),
(99,'2020-06-08','127.0.0.1','1','Chrome/Opera'),
(100,'2020-06-08','127.0.0.1','1','Chrome/Opera'),
(101,'2020-06-08','127.0.0.1','1','Chrome/Opera'),
(102,'2020-06-08','127.0.0.1','1','Chrome/Opera'),
(103,'2020-06-08','127.0.0.1','1','Chrome/Opera'),
(104,'2020-06-12','127.0.0.1','1','Chrome/Opera'),
(105,'2020-06-13','127.0.0.1','1','Chrome/Opera'),
(106,'2020-06-13','127.0.0.1','1','Chrome/Opera'),
(107,'2020-06-13','127.0.0.1','1','Chrome/Opera'),
(108,'2020-06-13','127.0.0.1','1','Chrome/Opera'),
(109,'2020-06-13','127.0.0.1','1','Chrome/Opera'),
(110,'2020-06-15','127.0.0.1','1','Chrome/Opera'),
(111,'2020-06-15','127.0.0.1','1','Chrome/Opera'),
(112,'2020-06-15','127.0.0.1','1','Chrome/Opera'),
(113,'2020-06-15','127.0.0.1','1','Chrome/Opera'),
(114,'2020-06-15','127.0.0.1','1','Chrome/Opera'),
(115,'2020-06-15','127.0.0.1','1','Chrome/Opera'),
(116,'2020-06-15','127.0.0.1','1','Chrome/Opera'),
(117,'2020-06-19','127.0.0.1','1','Chrome/Opera'),
(118,'2020-06-19','127.0.0.1','1','Chrome/Opera'),
(119,'2020-06-19','127.0.0.1','1','Chrome/Opera'),
(120,'2020-06-19','127.0.0.1','1','Chrome/Opera'),
(121,'2020-06-19','127.0.0.1','1','Chrome/Opera'),
(122,'2020-06-19','127.0.0.1','1','Chrome/Opera'),
(123,'2020-06-22','127.0.0.1','1','Chrome/Opera'),
(124,'2020-06-29','127.0.0.1','1','Chrome/Opera'),
(125,'2020-06-29','127.0.0.1','1','Chrome/Opera'),
(126,'2020-06-30','127.0.0.1','1','Chrome/Opera'),
(127,'2020-06-30','127.0.0.1','1','Chrome/Opera'),
(128,'2020-06-30','127.0.0.1','1','Chrome/Opera'),
(129,'2020-06-30','127.0.0.1','1','Chrome/Opera'),
(130,'2020-06-30','127.0.0.1','1','Chrome/Opera'),
(131,'2020-06-30','127.0.0.1','1','Chrome/Opera'),
(132,'2020-06-30','127.0.0.1','1','Chrome/Opera'),
(133,'2020-07-01','127.0.0.1','1','Chrome/Opera'),
(134,'2020-07-01','127.0.0.1','1','Chrome/Opera'),
(135,'2020-07-01','127.0.0.1','1','Chrome/Opera'),
(136,'2020-07-02','127.0.0.1','1','Chrome/Opera'),
(137,'2020-07-02','127.0.0.1','1','Chrome/Opera'),
(138,'2020-07-02','127.0.0.1','1','Chrome/Opera'),
(139,'2020-07-02','127.0.0.1','1','Chrome/Opera'),
(140,'2020-07-02','127.0.0.1','1','Chrome/Opera'),
(141,'2020-07-02','127.0.0.1','1','Chrome/Opera'),
(142,'2020-07-02','127.0.0.1','1','Chrome/Opera'),
(143,'2020-07-03','127.0.0.1','1','Chrome/Opera'),
(144,'2020-07-03','127.0.0.1','1','Chrome/Opera'),
(145,'2020-07-03','127.0.0.1','1','Chrome/Opera'),
(146,'2020-07-03','127.0.0.1','1','Chrome/Opera'),
(147,'2020-07-06','127.0.0.1','1','Chrome/Opera'),
(148,'2020-07-06','127.0.0.1','1','Chrome/Opera'),
(149,'2020-07-06','127.0.0.1','1','Chrome/Opera'),
(150,'2020-07-07','127.0.0.1','1','Chrome/Opera'),
(151,'2020-07-07','127.0.0.1','1','Chrome/Opera'),
(152,'2020-07-08','127.0.0.1','1','Chrome/Opera'),
(153,'2020-07-08','127.0.0.1','1','Chrome/Opera'),
(154,'2020-07-08','127.0.0.1','1','Chrome/Opera'),
(155,'2020-07-08','127.0.0.1','1','Chrome/Opera'),
(156,'2020-07-08','127.0.0.1','1','Chrome/Opera'),
(157,'2020-07-08','127.0.0.1','1','Chrome/Opera'),
(158,'2020-07-09','127.0.0.1','1','Chrome/Opera'),
(159,'2020-07-09','127.0.0.1','1','Chrome/Opera'),
(160,'2020-07-09','127.0.0.1','1','Chrome/Opera'),
(161,'2020-07-09','127.0.0.1','1','Chrome/Opera'),
(162,'2020-07-09','127.0.0.1','1','Chrome/Opera'),
(163,'2020-07-09','127.0.0.1','1','Chrome/Opera'),
(164,'2020-07-09','127.0.0.1','1','Chrome/Opera'),
(165,'2020-07-10','127.0.0.1','1','Chrome/Opera'),
(166,'2020-07-10','127.0.0.1','1','Chrome/Opera'),
(167,'2020-07-10','127.0.0.1','1','Chrome/Opera'),
(168,'2020-07-10','127.0.0.1','1','Chrome/Opera'),
(169,'2020-07-10','127.0.0.1','1','Chrome/Opera'),
(170,'2020-07-10','127.0.0.1','1','Chrome/Opera'),
(171,'2020-07-11','127.0.0.1','1','Chrome/Opera'),
(172,'2020-07-11','127.0.0.1','1','Chrome/Opera'),
(173,'2020-07-11','127.0.0.1','1','Chrome/Opera'),
(174,'2020-07-11','127.0.0.1','1','Chrome/Opera'),
(175,'2020-07-12','127.0.0.1','1','Chrome/Opera'),
(176,'2020-07-12','127.0.0.1','1','Chrome/Opera'),
(177,'2020-07-12','127.0.0.1','1','Chrome/Opera'),
(178,'2020-07-14','127.0.0.1','1','Chrome/Opera'),
(179,'2020-07-16','127.0.0.1','1','Chrome/Opera'),
(180,'2020-07-16','127.0.0.1','1','Chrome/Opera'),
(181,'2020-07-16','127.0.0.1','1','Chrome/Opera'),
(182,'2020-07-17','127.0.0.1','1','Chrome/Opera'),
(183,'2020-07-17','127.0.0.1','1','Chrome/Opera'),
(184,'2020-07-17','127.0.0.1','1','Chrome/Opera');

/*Table structure for table `laporan_kunjungan` */


/*!50001 DROP VIEW IF EXISTS `laporan_kunjungan` */;
/*!50001 DROP TABLE IF EXISTS `laporan_kunjungan` */;

/*!50001 CREATE TABLE  `laporan_kunjungan`(
 `bulan` varchar(9) ,
 `total` double 
)*/;

/*View structure for view laporan_kunjungan */

/*!50001 DROP TABLE IF EXISTS `laporan_kunjungan` */;
/*!50001 DROP VIEW IF EXISTS `laporan_kunjungan` */;

