/* SQLyog Ultimate v12.4.3 (64 bit) MySQL - 10.1.34-MariaDB : Database - unibridge ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`unibridge` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `unibridge`; /*Table structure for table `alamat` */ DROP TABLE IF EXISTS `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)
\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` */ DROP TABLE IF EXISTS `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` */ DROP TABLE IF EXISTS `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` */ DROP TABLE IF EXISTS `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` */ DROP TABLE IF EXISTS `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` */ DROP TABLE IF EXISTS `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` */ DROP TABLE IF EXISTS `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','

WELCOME TO
UNI-BRIDGE

\r\n\r\n

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.

','

SELAMAT DATANG DI
UNI-BRIDGE

\r\n\r\n

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.

','2020-05-29 16:21:32','2020-07-08 15:09:09'); /*Table structure for table `kategori` */ DROP TABLE IF EXISTS `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` */ DROP TABLE IF EXISTS `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` */ DROP TABLE IF EXISTS `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` */ DROP TABLE IF EXISTS `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','

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.

','

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.

','default.png','',NULL,'publish','2020-06-08 06:06:50','2020-06-08 06:06:50'), (5,5,'Saving of costs','saving-of-costs','

Saving of costs

','','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','

Scattered study location

','','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','

Study duration

','','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','

Use of English as the media of communication

','','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','

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 & properly.

\r\n\r\n

Embracing the idea, Uni-bridge English designs programs on the study of this language, for students and adults as follows:

\r\n\r\n

Preparation programs to sit for English language exams from Cambridge Assessment English:

\r\n\r\n

English for Young Learners (Starters, Movers & Flyers)
Key English Test (KET)
Preliminary English Test (PET)
International English Language Testing System (IELTS)

\r\n\r\n

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.

\r\n\r\n

CERTIFICATE IV IN TESOL (TEACHING ENGLISH TO SPEAKERS OF OTHER LANGUAGES)

\r\n\r\n

For this program, Uni-bridge English collaborates with Holmesglen Institute of TAFE – 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:

\r\n\r\n

Analyse the relationship between culture and learning to create an inclusive learning environment
Understand the English language and its use in communication
Gain knowledge of the genre-based approach to teaching English
Plan lessons and classroom management strategies
Understand and teach grammar, spelling and pronunciation
Teach others to speak, listen to, read and write English
Evaluate English ability Create, collect and collate teaching resources

\r\n\r\n

CONVERSATION CLASSES

\r\n\r\n

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.

','

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.

\r\n\r\n

Beranjak dari ide ini, Uni-bridge English merancang program pembelajaran bahasa Inggris, untuk pelajar dan orang dewasa, sebagai berikut:

\r\n\r\n

PROGRAM PERSIAPAN UNTUK UJIAN – UJIAN BAHASA INGGRIS DARI CAMBRIDGE ASSESSMENT ENGLISH

\r\n\r\n

English for Young Learners (Starters, Movers & Flyers)
Key English Test (KET)
Preliminary English Test (PET)
International English Language Testing System (IELTS)

\r\n\r\n

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.

\r\n\r\n

CERTIFICATE IV IN TESOL (TEACHING ENGLISH TO SPEAKERS OF OTHER LANGUAGES)

\r\n\r\n

Untuk program ini, Uni-bridge English berkolaborasi dengan Holmesglen Institute of TAFE (Government College) – 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:

\r\n\r\n

Menganalisa hubungan antar budaya, dan belajar menciptakan suasana dan lingkungan belajar yang mengikutsertakan budaya setempat
Memahami bahasa Inggris, dan penggunaannya dalam berkomunikasi
Mendapatkan pengetahuan mengenai model penyampaian dalam pengajaran bahasa Inggris
Mampu membuat perencanaan materi pelajaran bahasa Inggris dan strategi penyampaiannya dikelas
Memahami pengajaran bahasa Inggris yang berhubungan dengan tatabahasa, pengejaan dan pengucapan
Mengajar bahasa Inggris kepada peserta didik, untuk berbicara, mendengar, membaca dan menulis dalam bahasa Inggris
Mengevaluasi kemampuan berbahasa Inggris dari para peserta didik, dengan cara membuat, mengumpulkan, dan menyusun bahan pengajaran

\r\n\r\n

CONVERSATION CLASSES

\r\n\r\n

Kelas ‘Conversation’ 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.

','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','

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 ’Year 13’ for Secondary Level students or Year 1 program on the Tertiary Level of study.

\r\n\r\n

Today, we have 2 model of Uni-bridge Diploma, in collaboration with different partners of Uni-bridge Consortium Australia.

\r\n\r\n

Model 1

\r\n\r\n

The collaboration is with Canning College – Perth, Western Australia. In short, the format of the program is as follows:

\r\n\r\n

Complete Year 12 ➙ 4 subjects at Uni-bridge Partner’s school/ universities in Indonesia ➙ 4 subjects of Diploma of Commerce at Canning College, Perth – Western Australia ➙ Second Year of Bachelor of Commerce at Curtin University – Perth, Western Australia

\r\n\r\n

There are some added value to this model, as follows:

\r\n\r\n

International English Language Testing System (IELTS) Preparation Program
1 time Free of Charge - International English Language Testing System (IELTS) – Academic Version
Students will also have a laptop and headset

\r\n\r\n

The diagram hereunder, would provide you with you with a better understanding of the program:

\r\n\r\n

\r\n\r\n

On the second Year of Bachelor of Commerce at Curtin University – Perth, Western Australia, students will have a variety of majors to choose from:

\r\n\r\n

\r\n\r\n

','

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 – institusi yang merupakan rekanan dari Uni-bridge Consortium Australia. Aspek unik dari program ini adalah, pembelajaran dengan model ‘Block System’ per 4 (empat) bulan untuk 4 (empat) mata kuliah dari tahun pertama jenjang universitas.

\r\n\r\n

Saat ini kami memiliki 2 model program Uni-bridge Diploma. Masing – masing model berkolaborasi dengan institusi yang berbeda, sebagai rekanan dari Uni-bridge Consortium Australia:

\r\n\r\n

Model 1

\r\n\r\n

Rekanan untuk model 1 ini adalah dengan Canning College (A Government College) di Perth, Western Australia. Format dari program ini adalah sebagai berikut:

\r\n\r\n

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 – Western Australia ➙ selanjutnya tahun ke-2 (dua) program Bachelor of Commerce di Curtin University – Perth, Western Australia

\r\n\r\n

Ada beberapa nilai tambah pada model 1 dari progam ini yaitu:

\r\n\r\n

Diberikan pembelajaran International English Language Testing System (IELTS) Preparation Program
1 kali Free of Charge - International English Language Testing System (IELTS) – Versi Akademik
Siswa/i sebagai peserta program mendapatkan 1 laptop dan headset

\r\n\r\n

Diagram di bawah ini, akan memberikan penjelasan mengenai program tersebut di atas:

\r\n\r\n

\r\n\r\n

Ditahun kedua pada program Bachelor of Commerce di Curtin University – Perth, Western Australia, para siswa/i memiliki opsi yang bervariasi untuk bidang studi yang akan ditekuni, yaitu:

\r\n\r\n

\r\n\r\n

','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','

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. In tune with the first model, the second model of Uni-bridge Diploma Program will also make use of the ‘Block System’ for the 4 (four) months study duration on 4 (four) subjects.

\r\n\r\n

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.

\r\n\r\n

Model 2

\r\n\r\n

This model allows students to complete their Bachelor Degree in a number of institutions overseas in partnership with Uni-bridge Consortium Australia, such as:

\r\n\r\n

RMIT University – Melbourne, Australia*
Kaplan Business School – Australia (Campus: Adelaide, Brisbane, Melbourne, Sydney)
Melbourne Institute of Technology – Australia (Campus: Melbourne, Sydney)
De Montfort University – United Kingdom, at East Asia Institute of Management (EASB) - Singapore
Queen Margaret University – Scotland, at East Asia Institute of Management (EASB) – Singapore
Royal Holloway, University of London – United Kingdom at Kaplan Singapore
University College Dublin – Ireland at Kaplan Singapore

\r\n\r\n

There are some added value to model 2 of Uni-bridge Diploma Program, as follows:

\r\n\r\n

Be entitled to an International English Language Testing System (IELTS) Preparation Program
1 time Free of Charge - International English Language Testing System (IELTS) – Academic Version
Students of the program will also have a laptop and headset

\r\n\r\n

The diagram hereunder, will provide a clearer picture about the above program :

\r\n\r\n

\r\n\r\n

','

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 – 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.

\r\n\r\n

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.

\r\n\r\n

Model 2

\r\n\r\n

Model ini membuka kesempatan bagi siswa/i untuk menyelesaikan program Strata 1 di institusi rekanan dari Uni-bridge Consortium Australia, sebagai berikut:

\r\n\r\n

RMIT University – Melbourne, Australia*
Kaplan Business School – Australia (Campus: Adelaide, Brisbane, Melbourne, Sydney)
Melbourne Institute of Technology – Australia (Campus: Melbourne, Sydney)
De Montfort University – United Kingdom, at East Asia Institute of Management (EASB) - Singapore
Queen Margaret University – Scotland, at East Asia Institute of Management (EASB) – Singapore
Royal Holloway, University of London – United Kingdom at Kaplan Singapore
University College Dublin – Ireland at Kaplan Singapore

\r\n\r\n

Beberapa nilai tambah pada model 2 dari program ini yaitu:

\r\n\r\n

Diberikan pembelajaran International English Language Testing System (IELTS) Preparation Program
1 kali Free of Charge - International English Language Testing System (IELTS) – Versi Akademik
Siswa/i sebagai peserta program mendapatkan 1 laptop dan headset

\r\n\r\n

Diagram di bawah ini, akan memberikan penjelasan mengenai program tersebut di atas:

\r\n\r\n

\r\n\r\n

','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','

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.

\r\n\r\n

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 & 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 & Accounting and English.

\r\n\r\n

On completion of the Uni-bridge Foundation in Indonesia, students will do the final stage of the Foundation Program, at Uni-bridge’s partner institutions overseas such as at:

\r\n\r\n

Bellerbys College – United Kingdom (Campus: Brighton, Cambridge, London)
Canning College – Perth, Western Australia
East Asia Institute of Management – Singapore
UP Education – New Zealand

\r\n\r\n

The following diagram is the description of the Uni-bridge Foundation Program:

\r\n\r\n

\r\n\r\n

','

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.

\r\n\r\n

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: ‘Science’ atau ‘Business’. Di bidang ‘Science’, para siswa/i akan mempelajari pelajaran: Matematika, Kimia, Fisika serta Bahasa Inggris. Untuk siswa/i yang memilih untuk fokus pada bidang ‘Business’, konsentrasi mata pelajaran yang harus diambilnya yaitu: Matematika, Ekonomi, Akunting dan Bahasa Inggris.

\r\n\r\n

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:

\r\n\r\n

Bellerbys College – United Kingdom (Campus: Brighton, Cambridge, London)
Canning College – Perth, Western Australia
East Asia Institute of Management – Singapore
UP Education – New Zealand

\r\n\r\n

Diagram berikut ini merupakan gambaran program Uni-bridge Foundation:

\r\n\r\n

\r\n\r\n

','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','

Mengenal Minat Bakat & Perilaku Anak: Strategi untuk Menentukan Jurusan Studi Lanjut
Strategi Memilih Universitas di Luar Negeri untuk Studi Lanjut

\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n

\r\n

Saturday, 11 July 2020

\r\n\r\n

10.00 AM – 12.30 PM

\r\n

\r\n\r\n

Speakers:

\r\n\r\n

Sapta Dwikardana, PhD –Behavioral Analyst & Principal Advisor ALESI Indonesia
Sugie J. Hambali, Drs., M.Com (Hons) –Chief Executive Officer Uni-bridge Indonesia
Pertiwi Megasari, S.AP., MH – Manager Business Development & Program BJB Precious
Bpk. Hieronymus Sunarto – Kepala Bidang Pendidikan Yayasan Panca Dharma

\r\n\r\n

Moderator:

\r\n\r\n

Nancy Sudarmo, BCom

\r\n\r\n

Group Manager ~ Business Administration

\r\n\r\n

Uni-bridge Indonesia

\r\n\r\n

Thank you,

\r\n\r\n

Tim Uni-bridge

','

Mengenal Minat Bakat & Perilaku Anak: Strategi untuk Menentukan Jurusan Studi Lanjut
Strategi Memilih Universitas di Luar Negeri untuk Studi Lanjut

\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n

\r\n

Sabtu, 11 Juli 2020

\r\n\r\n

Jam 10.00 – 12.30 WIB

\r\n

\r\n\r\n

Pembicara:

\r\n\r\n

Sapta Dwikardana, PhD –Behavioral Analyst & Principal Advisor ALESI Indonesia
Sugie J. Hambali, Drs., M.Com (Hons) –Chief Executive Officer Uni-bridge Indonesia
Pertiwi Megasari, S.AP., MH – Manager Business Development & Program BJB Precious
Bpk. Hieronymus Sunarto – Kepala Bidang Pendidikan Yayasan Panca Dharma

\r\n\r\n

Moderator:

\r\n\r\n

Nancy Sudarmo, BCom

\r\n\r\n

Group Manager ~ Business Administration

\r\n\r\n

Uni-bridge Indonesia

\r\n\r\n

Terima kasih,

\r\n\r\n

Tim Uni-bridge

','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','

This program is available for students who have completed SMA 3 or Year 12, and:

\r\n\r\n

are interested to continue their study on Undergraduate level concentrating in Business
have the objective to commence study in 2020
are considering to study in Australia or Singapore

\r\n\r\n

Come and join the online seminar on this program on:

\r\n\r\n

Saturday, 18 July 2020
\r\n10.00 AM - 12.00 PM

\r\n\r\n

The ONLINE seminar 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.

\r\n\r\n

Thank you,

\r\n\r\n

Uni-bridge Team

','

Program ini khusus tersedia bagi siswa/i yang telah menyelesaikan SMA 3 atau Year 12, dan:

\r\n\r\n

tertarik untuk melanjutkan studi ke jenjang Strata 1 di bidang bisnis
ingin mulai studi tahun 2020
berencana untuk melanjutkan studi di Australia atau di Singapore

\r\n\r\n

Hadiri seminar online untuk program ini pada:

\r\n\r\n

Sabtu, 18 Juli 2020
\r\n10.00 AM - 12.00 PM

\r\n\r\n

Seminar ONLINE ini akan mengupas tuntas semua pertanyaan Anda mengenai program ini.

\r\n\r\n

Silahkan melakukan RSVP dengan mengisi formulir di bagian kanan, dan kami akan mengirimkan undangan untuk mengikuti acara ini melalui alamat email yang Anda berikan.

\r\n\r\n

Terima kasih,

\r\n\r\n

Tim Uni-bridge

','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','

Multi Bahasa

','

Multi Bahasa

','BILINGUAL-COMMUNICATION1.png','DUA-BAHASA1.png',NULL,'publish',NULL,'2020-07-14 08:47:40'), (28,5,'Flexible','flexible','

Flexible

','

Flexible

','FLEXIBLE-STUDY1.png','DURASI-BELAJAR1.png',NULL,'publish',NULL,'2020-07-14 08:50:23'); /*Table structure for table `partner` */ DROP TABLE IF EXISTS `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','

In association with AUTH & Victoria University - New Zealand UTAS, Swimburne Academy CDU International College - Australia

','

Bekerja sama dengan AUTH & Victoria University - Selandia Baru UTAS, Swimburne Academy CDU International College - Australia

','partner8.png','internasional','New Zealand',NULL,'https://www.up.education/','2020-06-29 06:12:37','2020-07-17 09:05:07'), (3,'KAPLAN','

In association with Royal Halloway, University of London - United Kingdom & Queen Margaret University - United Kingdom

','

Bekerja sama dengan Royal Halloway, Universitas London - Inggris & Universitas Queen Margaret - Inggris

','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','

In association with De Montfort University & Queen Margaret University - United Kingdom

','

Bekerja sama dengan De Montfort University & Queen Margaret University - Inggris

','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','

Graduates of the institutions have until today managed to get entry into the following universities worldwide

\r\n\r\n

Curtin University – Western Australia
Edith Cowan University – Western Australia
Murdoch University – Western Australia
Notre Dame University – Western Australia
UWA – Western Australia
Monash University – Melbourne, Australia
University of Melbourne - Australia
RMIT University – Melbourne, Australia
Kobe Design University – Japan
University of Sydney – Australia
Australian National University – Canberra, Australia
Nottingham University – United Kingdom
Humber Institute of Technology – Toronto, Canada

','

Lulusan institusi tersebut hingga hari ini berhasil masuk ke universitas-universitas berikut di seluruh dunia

\r\n\r\n

Curtin University – Western Australia
Edith Cowan University – Western Australia
Murdoch University – Western Australia
Notre Dame University – Western Australia
UWA – Western Australia
Monash University – Melbourne, Australia
University of Melbourne - Australia
RMIT University – Melbourne, Australia
Kobe Design University – Japan
University of Sydney – Australia
Australian National University – Canberra, Australia
Nottingham University – United Kingdom
Humber Institute of Technology – Toronto, Canada

','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','

Graduates of the institutions have until today managed to get entry into the following universities in United Kingdom

\r\n\r\n

University of Birmingham
University of Bristol
University of Cambridge
Cardiff University
Durham University
University of Edinburgh
University of Exeter
University of Glasgow
Imperial College London
King’s College London
University of Leeds
University of Liverpool
London School of Economics & Political Science
University of Manchester
Newcastle University
University of Nottingham
University of Oxford
Queen Mary, University of London
Queen’s University Belfast
University of Sheffield
University of Southampton
University College London
University of Warwick
University of York

','

Lulusan institusi tersebut hingga hari ini berhasil masuk ke universitas-universitas berikut di Inggris

\r\n\r\n

University of Birmingham
University of Bristol
University of Cambridge
Cardiff University
Durham University
University of Edinburgh
University of Exeter
University of Glasgow
Imperial College London
King’s College London
University of Leeds
University of Liverpool
London School of Economics & Political Science
University of Manchester
Newcastle University
University of Nottingham
University of Oxford
Queen Mary, University of London
Queen’s University Belfast
University of Sheffield
University of Southampton
University College London
University of Warwick
University of York

','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','

PARTNERS IN THE PROCESS OF COLLABORATION

\r\n\r\n

Sekolah BPK Penabur - Bandung
Universitas Kristen Maranatha - Bandung
LPP Unpar+ - Bandung
Pusdiklat Marwita Magiswara - Bandung
PT Bank Jawa Barat and Banten
Kompas group - Jakarta
Universitas Telkom - Bandung
Sekolah Don Bosco - Jakarta
Karunia Global School - Jambi

\r\n\r\n

And many more

','

MITRA DALAM PROSES KERJA SAMA

\r\n\r\n

Sekolah BPK Penabur - Bandung
Universitas Kristen Maranatha - Bandung
LPP Unpar+ - Bandung
Pusdiklat Marwita Magiswara - Bandung
PT Bank Jawa Barat and Banten
Kompas group - Jakarta
Universitas Telkom - Bandung
Sekolah Don Bosco - Jakarta
Karunia Global School - Jambi

\r\n\r\n

Dan masih banyak lagi

','partner-thumbnail.png','lokal','Indonesia','Indonesia','#','2020-07-16 08:20:19','2020-07-16 08:20:19'), (20,'Indonesia','

PARTNERS IN THE PROCESS OF EXTENDING THE COLLABORATION

\r\n\r\n

PT Bank Mandiri
PT Bank Central Asia
PT Bank CIMB Niaga

\r\n\r\n

','

MITRA DALAM PROSES MEMPERPANJANG KERJASAMA

\r\n\r\n

PT Bank Mandiri
PT Bank Central Asia
PT Bank CIMB Niaga

','partner-thumbnail.png','lokal','Indonesia','Indonesia','#','2020-07-16 08:22:46','2020-07-17 06:00:52'); /*Table structure for table `password_resets` */ DROP TABLE IF EXISTS `password_resets`; CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Data for the table `password_resets` */ insert into `password_resets`(`email`,`token`,`created_at`) values ('admin@gmail.com','$2y$10$MOfcRNRdCj0BPFh2Zf624uykNOUqSB1tJQHyNbkzmD4dWZILO5.xO','2020-06-03 06:18:21'); /*Table structure for table `student` */ DROP TABLE IF EXISTS `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` */ DROP TABLE IF EXISTS `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 `users` */ DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` 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 DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `foto` text COLLATE utf8mb4_unicode_ci, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Data for the table `users` */ insert into `users`(`id`,`name`,`email`,`nomor_telepon`,`email_verified_at`,`password`,`foto`,`remember_token`,`created_at`,`updated_at`) values (2,'admin','admin@gmail.com','08912345678',NULL,'$2y$10$6M4d0ETiQlqIgOTvomvavu2tegmoXDuSEQpqFXLQaBvTsXzRmB5/.','13408933_1760669410816019_130794795_n.jpg',NULL,NULL,'2020-06-02 12:08:03'), (4,'Sigit Permana','sigitpermana2109@gmail.com','0895395288400',NULL,'$2y$10$lwipvoJ4kSxP4MPh8es8dODpl0ThFAFKskLHUmS18AJp8GbZdMscm','Muhamad Sigit Permana.png','4cbFN8QxGdI6hcSDaZ60Z9cwZxNRnIFspAgqM0LDjlLe0oZGaQLqQJ5GhlwG','2020-06-03 05:23:14','2020-06-03 06:33:43'); /*Table structure for table `visitor` */ DROP TABLE IF EXISTS `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` */ DROP TABLE IF EXISTS `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` */; /*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `laporan_kunjungan` AS select monthname(`visitor`.`tanggal`) AS `bulan`,sum(`visitor`.`counter`) AS `total` from `visitor` group by month(`visitor`.`tanggal`) */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;