/
podcast.sql
64 lines (55 loc) · 14.3 KB
/
podcast.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
-- MySQL dump 10.13 Distrib 5.5.62, for Linux (x86_64)
--
-- Host: localhost Database: anugrahc_podcast
-- ------------------------------------------------------
-- Server version 5.5.62-cll
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
--
-- Table structure for table `episode`
--
DROP TABLE IF EXISTS `episode`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `episode` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`no_episode` int(11) NOT NULL,
`judul` varchar(50) NOT NULL,
`anchor` varchar(200) NOT NULL,
`caption` text NOT NULL,
`note` text NOT NULL,
`slug` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `episode`
--
LOCK TABLES `episode` WRITE;
/*!40000 ALTER TABLE `episode` DISABLE KEYS */;
INSERT INTO `episode` (`id`, `no_episode`, `judul`, `anchor`, `caption`, `note`, `slug`) VALUES (1,0,'Kenalan','https://anchor.fm/dekadensiotak/embed/episodes/0--Kenalan-e2bo5j','Kenalan yuk! Episode pertama dari saya, Anugrah Ramadhan si tukang ledeng yang belajar koding.','','kenalan'),(2,1,'Episode 02','https://anchor.fm/dekadensiotak/embed/episodes/1--Episode-02-e2bpv5','Episode kedua dari Podcast dekadensiotak','','episode-02'),(3,2,'Episode 03','https://anchor.fm/dekadensiotak/embed/episodes/2--Episode-03-e2bvk4','Ngomongin Dead Poets Society sampai persimpangan hidup','','episode-03'),(4,3,'Tempat belajar ngoding yang asoy buat newbie','https://anchor.fm/dekadensiotak/embed/episodes/3--Tempat-belajar-ngoding-yang-asoy-buat-newbie-e2cljf','main-main kemari gan: (1) sekolahkoding.com , (2) youtube.com/webprogrammingunpas . Di episode berikutnya, mungkin bakal saya tambahin lagi listnya','','tempat-belajar-ngoding-yang-asoy-buat-newbie'),(5,4,'Jangan putusin rantainya!','https://anchor.fm/dekadensiotak/embed/episodes/4--Jangan-putusin-rantainya-e2e43t','Share satu teknik yang lagi saya pakai. Dari komedian Jerry Seinfeld untuk menjaga konsistensi dalam berkarya (dalam konteks podcast ini ya berarti untuk ngoding juga)','','jangan-putusin-rantainya'),(6,5,'Pilih bahasa pemrogramanmu dan bergerak!','https://anchor.fm/dekadensiotak/embed/episodes/05--Pilih-bahasa-pemrogramanmu-dan-bergerak-e2fns4','Jangan terlalu lama galau milih bahasa. Tentukan satu dan bergeraklah.','','pilih-bahasa-pemrogramanmu-dan-bergerak'),(7,6,'Bayar dong!','https://anchor.fm/dekadensiotak/embed/episodes/6--Bayar-dong-e2h35g','Bayar dong biar rada serius ngodingnya :)','','bayar-dong'),(8,7,'Pejalan lambat','https://anchor.fm/dekadensiotak/embed/episodes/7--Pejalan-lambat-e2iac4','Apakah kamu seorang yang berjalan lambat? Sama! Saya juga.','','pejalan-lambat'),(9,8,'ngerjainProject == belajar','https://anchor.fm/dekadensiotak/embed/episodes/8--ngerjainProject--belajar-e2jo14','Ternyata banyak hal baru yang gak diduga dan bisa dipelajari ketika ngerjain suatu project','','ngerjain-project-belajar'),(10,9,'Menghadapi si otak kadal','https://anchor.fm/dekadensiotak/embed/episodes/9--Menghadapi-si-otak-kadal-e2khjc','Pernah ngerasa pesimis akan apa yang mau dikerjain? Itu kerjaan si otak kadal.','','menghadapi-si-otak-kadal'),(11,10,'Talk talk talk','https://anchor.fm/dekadensiotak/embed/episodes/10--Talk-talk-talk-e2lshg','Banyak ngomong sedikit bekerja','','talk-talk-talk'),(12,11,'Do what you want, man.','https://anchor.fm/dekadensiotak/embed/episodes/11--Do-what-you-want--man-e2nb22','Lakuin apa yang dimau biar hati jadi asoy. <br>*Surya Sahetapy maksudnya. Ray mah bapaknya. Duh.','','do-what-you-want-man'),(13,12,'Biar gak norak kayak desain spanduk caleg','https://anchor.fm/dekadensiotak/embed/episodes/12--Biar-gak-norak-kayak-desain-spanduk-caleg-e2oq1u','Terinspirasi dari bukunya Austin Kleon \"Steal Like An Artist\" tentang meniru.','','biar-gak-norak-kayak-desain-spanduk-caleg'),(14,13,'Jadi batman','https://anchor.fm/dekadensiotak/embed/episodes/12--Jadi-batman-e2q9d7','The crossroads of bruce wayne and batman','','jadi-batman'),(15,14,'Kaleidoskop','https://anchor.fm/dekadensiotak/embed/episodes/14--Kaleidoskop-e2rfl3','Ngoding rewind 2018 dan sedikit rekomendasi buku yang asoy buat dibaca','','kaleidoskop'),(16,15,'Sampah brengsek!','https://anchor.fm/dekadensiotak/embed/episodes/15--Sampah-brengsek-e2sfc8','Ngomongin sampah kali cimahi, perpus jalanan, mandi, dan kelasterbuka','','sampah-brengsek'),(17,16,'OOP imajinasi','https://anchor.fm/dekadensiotak/embed/episodes/16--OOP-imajinasi-e2u3ut','Saya baru mulai belajar oop php nih','','oop-imajinasi'),(18,17,'Ngoding dalam liburan abstrak','https://anchor.fm/dekadensiotak/embed/episodes/17--Ngoding-dalam-liburan-abstrak-e305i8','Ngomongin ngoding saat berlibur dan abstrak oop yang kayaknya nyambung sama abstrak skripsi','','ngoding-dalam-liburan-abstrak'),(19,18,'MVC amor fati','https://anchor.fm/dekadensiotak/embed/episodes/18--MVC-amor-fati-e315ma','Mencoba mencintai takdir','','mvc-amor-fati'),(20,19,'Berkembang dengan carpe diem','https://anchor.fm/dekadensiotak/embed/episodes/19--Berkembang-dengan-carpe-diem-e33flc','Carpe diem - seize the day - menguasai hari. Karena hari adalah konsep waktu yang paling mudah diukur','','berkembang-dengan-carpe-diem'),(21,20,'marquee bodo amat','https://anchor.fm/dekadensiotak/embed/episodes/20--marquee-bodo-amat-e350nm','saya cinta tag marquee, sedikit tentang buku bodo amat dan revolusi industri 4.0, jauhi kasur!','','marquee-bodo-amat'),(22,21,'Bertahan a la Onoda','https://anchor.fm/dekadensiotak/embed/episodes/21--Bertahan-a-la-Onoda-e37mf7','Saya ngedongeng kisah Onoda sang Letnan Jepang di Perang Dunia 2. Tentang rela menderita demi suatu keyakinan','','bertahan-a-la-onoda'),(23,22,'Mari bertemu Ultron','https://anchor.fm/dekadensiotak/embed/episodes/22--Mari-bertemu-Ultron-e39fsi','Saya ngebayangin gimana kalau nanti ketemu Ultron','','mari-bertemu-ultron'),(24,23,'Program obituari','https://anchor.fm/dekadensiotak/embed/episodes/23--Program-obituari-e3bo5j','Saya ngabulatuk tentang ngoding yang disayang Tuhan dan tentang ingat mati','','program-obituari'),(25,24,'Punk Programming','https://anchor.fm/dekadensiotak/embed/episodes/24--Punk-programming-e3dp47','Semangat punk dalam ngoding. Why not?','','punk-programming'),(26,25,'Mandek!','https://anchor.fm/dekadensiotak/embed/episodes/25--Mandek-e3flii','Kemandekan hanyalah kelancaran yang tertundaaaaaah','','mandek'),(27,26,'Pandemic procedural','https://anchor.fm/dekadensiotak/embed/episodes/26--Pandemic-procedural-e3hbbd','Kembali lagi ke procedural','','pandemic-procedural'),(28,27,'Candu itu bernama dopamine','https://anchor.fm/dekadensiotak/embed/episodes/27--Candu-itu-bernama-dopamine-e3jk3k','Saya bulatuk tentang pentingnya dopamine biar nyandu ngelakuin sesuatu.','','candu-itu-bernama-dopamine'),(29,28,'Mewujud htaccess terbingkai framework','https://anchor.fm/dekadensiotak/embed/episodes/28--Mewujud-htaccess-terbingkai-framework-e3llds','Htaccess yang memusingkan. Framework yang mengekang.','','mewujud-htaccess-terbingkai-framework'),(30,29,'Belajar Git','https://anchor.fm/dekadensiotak/embed/episodes/29--Belajar-Git-e3nr77','Saya mulai belajar git demi menambah level kekerenan saya sebagai seorang programmer. Juga, tentang membuat deskripsi episode yang lebih serius.','<b>Github:</b>\r\n<a href=\"\">https://github.com/anugrahra\r\n\r\n<b>Podcast <i>dekadensiotak:</i></b>\r\n<a href=\"https://anugrah.club/podcast\">https://anugrah.club/podcast</a>\r\n<a href=\"https://anchor.fm/dekadensiotak\">https://anchor.fm/dekadensiotak</a>\r\n<a href=\"https://open.spotify.com/show/7CXYFUB7c8vx1OqYCSihaC\">https://open.spotify.com/show/7CXYFUB7c8vx1OqYCSihaC</a>\r\n\r\n<b>Books:</b>\r\n<a href=\"https://books.google.co.id/books?id=cnwnDQAAQBAJ&lpg=PR1&hl=id&pg=PR4#v=onepage&q&f=false\">The Life-Changing Magic of Tidying Up (Edisi Bahasa Indonesia)</a> - <i>Marie Kondo</i>','belajar-git'),(34,32,'FOMO dan Memanfaatkan Ramadhan','https://anchor.fm/dekadensiotak/embed/episodes/32--FOMO-dan-Memanfaatkan-Ramadhan-e3uehj','Saya baru aja uninstall aplikasi sosial media supaya ramadhan nanti bisa ngebentuk habit baru yang asoy','Buku:<br>\r\n<a href=\"https://books.google.co.id/books?id=3udrDwAAQBAJ&lpg=PP1&dq=Keep%20going%20austin%20kleon&pg=PP1#v=onepage&q=Keep%20going%20austin%20kleon&f=false\">Keep Going - Austin Kleon</a>','fomo-dan-memanfaatkan-ramadhan'),(32,30,'Kontribusi','https://anchor.fm/dekadensiotak/embed/episodes/30--Kontribusi-e3pqbo','Kontribusi awal saya di Github. Bikin RSS untuk blog saya. Dan, kenapa programmer asik untuk di follow twitternya.','Link-link yang saya sebutin di episode ini:<br>\r\n1. <a href=\"https://github.com/anugrahra\">Github Saya</a><br>\r\n2. <a href=\"https://petanikode.com\">Petanikode</a><br>\r\n3. <a href=\"https://www.youtube.com/channel/UCkXmLjEr95LVtGuIm3l2dPg\">Web Programming Unpas</a>\r\n\r\nBuku:<br>\r\n1. <a href=\"https://books.google.co.id/books?id=cnwnDQAAQBAJ&lpg=PR1&hl=id&pg=PR4#v=onepage&q&f=false\">The Life-changing Magic of Tidying Up - Marie Kondo</a><br>\r\n2. <a href=\"https://www.goodreads.com/book/show/44434105-septictank\">Septictank: Pengalaman Nyemplung Ke Kolam Politik - Pandji Pragiwaksono</a>','kontribusi'),(33,31,'Episode 31','https://anchor.fm/dekadensiotak/embed/episodes/31--Episode-31-e3s8h4','Episode ke 31 dari Podcast <i>dekadensiotak</i>','Kagak perlu note lah, gak terlalu penting juga lu dengerin episode ini.','episode-31'),(35,33,'Retrospeksi internet','https://anchor.fm/dekadensiotak/embed/episodes/33--Retrospeksi-internet-e407kb','Pandang balik saya tentang tingkah laku berinternet','Google Keynote - Google I/O 2019\r\n\r\n<iframe src=\"https://www.youtube.com/embed/lyRPyRKHO8M\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen></iframe>','retrospeksi-internet'),(36,34,'Dokumentasi','https://anchor.fm/dekadensiotak/embed/episodes/34--Dokumentasi-e42pbk','Gue ngebulatuk sehabis nongton tutorial codeigniter\r\n','Dengerin aja dah sambil ngopi sama udud. Semoga hidup anda tentram sentausa.','dokumentasi'),(37,35,'shoutout','https://anchor.fm/dekadensiotak/embed/episodes/35--shoutout-e45a1r','Ucapan terimakasih saya untuk orang2 yang menjaga kewarasan saya.','<b>Senartogok:</b><br>\r\n<a href=\"https://www.youtube.com/senartogok\">youtube.com/senartogok</a><br>\r\n\r\n<b>Developer Muslim Podcast:</b><br>\r\n<a href=\"https://devmuslim.id\">devmuslim.id</a><br>\r\n\r\n<b>Fariz:</b><br>\r\n<a href=\"https://108kb.io\">108kb.io</a><br>\r\n\r\n<b>Fahmy:</b><br>\r\n<a href=\"https://instagram.com/f.sabiel.n\">instagram.com/f.sabiel.n</a>','shoutout'),(38,36,'Sapiens','https://anchor.fm/dekadensiotak/embed/episodes/36--Sapiens-e47ff5','pentingnya ngulik ulang kodingan tutorial yang udah diikutin dan bulatuk saya tentang buku sapiens harari','<b>Books:</b><br>\r\n<a href=\"https://www.ynharari.com/book/sapiens/\">Sapiens: A brief History of Humankind</a>\r\n\r\n<b>Tutorial Codeigniter:</b><br>\r\n<a href=\"https://www.youtube.com/watch?v=8ROgaHfLRq0&list=PLFIM0718LjIXU8ul9FiN-owk04cQKtHPw\">Membuat Sistem Login Lengkap Menggunakan Codeigniter</a>\r\n','sapiens'),(39,37,'Lebaran dunia maya','https://anchor.fm/dekadensiotak/embed/episodes/37--Lebaran-dunia-maya-e49n0l','Bulatuk setelah lebaran','mohon maap lahir batin yaaaaa\r\n\r\n<b>DOWNLOAD:</b><br>\r\n<a href=\"https://www.planetebook.com/free-ebooks/1984.pdf\">1984 by George Orwell</a>','lebaran-dunia-maya'),(40,38,'Public API: Sharing is caring','https://anchor.fm/dekadensiotak/embed/episodes/38--Public-API-Sharing-is-caring-e4bqev','Saya belajar REST-API, dan ternyata itu menyenangkan','Public API:<br>\r\n<ul>\r\n<li><a href=\"https://github.com/farizdotid/DAFTAR-API-LOKAL-INDONESIA\">Daftar API lokal Indonesia oleh Fariz Ramadhan</a></li>\r\n<li><a href=\"https://github.com/bachors/Al-Quran-ID-API\">Al-Quran-ID-API oleh Ican Bachors</a></li>\r\n</ul>\r\n\r\nBeautiful by Eminem<br>\r\n<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/lgT1AidzRWM\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen></iframe>','public-api:-sharing-is-caring'),(41,39,'Not responding is not cool','https://anchor.fm/dekadensiotak/embed/episodes/39--Not-responding-is-not-cool-e4due6','ngomongin javascript, php, chris bosh, eka rock, dan investasi alat','<b>Chris Bosh:</b>\r\n\r\n<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/HSOw4B5LUUA\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen></iframe>\r\n\r\n<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/8T5acEwfJbw\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen></iframe>\r\n\r\n<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/kx3DxBbweGY\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen></iframe>\r\n\r\n<b>Ngoding pake smartphone</b>:\r\n\r\n<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/SS7UAGVxIis?start=1625\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen></iframe>','not-responding-is-not-cool');
/*!40000 ALTER TABLE `episode` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping events for database 'anugrahc_podcast'
--
--
-- Dumping routines for database 'anugrahc_podcast'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2019-06-27 21:38:56