INSERT INTO FILM (id_film,judul,kategori) VALUES ('1','London Love Story','Roman'), ('2','Black Panther','Fiksi Ilmiah'), ('3','Dilan 1990','Drama'), ('4','Braven','Drama'), ('5','Bayi Gaib: Bayi Tumbal Bayi Mati','Horor'), ('6','The Monkey King 3','Petualangan'), ('7','Yowis Ben','Komedi'), ('8','Eiffel... I''m in Love 2','Roman'), ('9','Maze Runner: The Death Cure','Petualangan'), ('10','The Greatest Showman','Musikal'), ('11','Padman','Biografi'), ('12','Lady Bird','Komedi'), ('13','Downsizing','Komedi'), ('14','Den of Thieves','Laga'), ('15','Thomas & Friends: Journey Beyond Sodor','Animasi');


INSERT INTO STUDIO (no_studio,kapasitas,type) VALUES ('REG1','300','Regular'), ('REG2','300','Regular'), ('VIP1','50','VIP'), ('VIP2','50','VIP');


INSERT INTO SEATING (id_seating,no_kursi,no_studio) VALUES ('SE1','A1','REG1'), ('SE2','A2','REG1'), ('SE3','A3','REG1'), ('SE4','A4','REG1'), ('SE5','A5','REG1'), ('SE6','A6','REG1'), ('SE7','A7','REG1'), ('SE8','A8','REG1'), ('SE9','A9','REG1'), ('SE10','A10','REG1'), ('SE11','A11','REG1'), ('SE12','A12','REG1'), ('SE13','A13','REG1'), ('SE14','A14','REG1'), ('SE15','A15','REG1'), ('SE16','A16','REG1'), ('SE17','A17','REG1'), ('SE18','A18','REG1'), ('SE19','A19','REG1'), ('SE20','A20','REG1'), ('SE21','A21','REG1'), ('SE22','A22','REG1'), ('SE23','A23','REG1'), ('SE24','A24','REG1'), ('SE25','A25','REG1'), ('SE26','A26','REG1'), ('SE27','A27','REG1'), ('SE28','A28','REG1'), ('SE29','A29','REG1'), ('SE30','A30','REG1'), ('SE31','B1','REG1'), ('SE32','B2','REG1'), ('SE33','B3','REG1'), ('SE34','B4','REG1'), ('SE35','B5','REG1'), ('SE36','B6','REG1'), ('SE37','B7','REG1'), ('SE38','B8','REG1'), ('SE39','B9','REG1'), ('SE40','B10','REG1'), ('SE41','B11','REG1'), ('SE42','B12','REG1'), ('SE43','B13','REG1'), ('SE44','B14','REG1'), ('SE45','B15','REG1'), ('SE46','B16','REG1'), ('SE47','B17','REG1'), ('SE48','B18','REG1'), ('SE49','B19','REG1'), ('SE50','B20','REG1'), ('SE51','B21','REG1'), ('SE52','B22','REG1'), ('SE53','B23','REG1'), ('SE54','B24','REG1'), ('SE55','B25','REG1'), ('SE56','B26','REG1'), ('SE57','B27','REG1'), ('SE58','B28','REG1'), ('SE59','B29','REG1'), ('SE60','B30','REG1'), ('SE61','C1','REG1'), ('SE62','C2','REG1'), ('SE63','C3','REG1'), ('SE64','C4','REG1'), ('SE65','C5','REG1'), ('SE66','C6','REG1'), ('SE67','C7','REG1'), ('SE68','C8','REG1'), ('SE69','C9','REG1'), ('SE70','C10','REG1'), ('SE71','C11','REG1'), ('SE72','C12','REG1'), ('SE73','C13','REG1'), ('SE74','C14','REG1'), ('SE75','C15','REG1'), ('SE76','C16','REG1'), ('SE77','C17','REG1'), ('SE78','C18','REG1'), ('SE79','C19','REG1'), ('SE80','C20','REG1'), ('SE81','C21','REG1'), ('SE82','C22','REG1'), ('SE83','C23','REG1'), ('SE84','C24','REG1'), ('SE85','C25','REG1'), ('SE86','C26','REG1'), ('SE87','C27','REG1'), ('SE88','C28','REG1'), ('SE89','C29','REG1'), ('SE90','C30','REG1'), ('SE91','D1','REG1'), ('SE92','D2','REG1'), ('SE93','D3','REG1'), ('SE94','D4','REG1'), ('SE95','D5','REG1'), ('SE96','D6','REG1'), ('SE97','D7','REG1'), ('SE98','D8','REG1'), ('SE99','D9','REG1'), ('SE100','D10','REG1'), ('SE101','D11','REG1'), ('SE102','D12','REG1'), ('SE103','D13','REG1'), ('SE104','D14','REG1'), ('SE105','D15','REG1'), ('SE106','D16','REG1'), ('SE107','D17','REG1'), ('SE108','D18','REG1'), ('SE109','D19','REG1'), ('SE110','D20','REG1'), ('SE111','D21','REG1'), ('SE112','D22','REG1'), ('SE113','D23','REG1'), ('SE114','D24','REG1'), ('SE115','D25','REG1'), ('SE116','D26','REG1'), ('SE117','D27','REG1'), ('SE118','D28','REG1'), ('SE119','D29','REG1'), ('SE120','D30','REG1'), ('SE121','E1','REG1'), ('SE122','E2','REG1'), ('SE123','E3','REG1'), ('SE124','E4','REG1'), ('SE125','E5','REG1'), ('SE126','E6','REG1'), ('SE127','E7','REG1'), ('SE128','E8','REG1'), ('SE129','E9','REG1'), ('SE130','E10','REG1'), ('SE131','E11','REG1'), ('SE132','E12','REG1'), ('SE133','E13','REG1'), ('SE134','E14','REG1'), ('SE135','E15','REG1'), ('SE136','E16','REG1'), ('SE137','E17','REG1'), ('SE138','E18','REG1'), ('SE139','E19','REG1'), ('SE140','E20','REG1'), ('SE141','E21','REG1'), ('SE142','E22','REG1'), ('SE143','E23','REG1'), ('SE144','E24','REG1'), ('SE145','E25','REG1'), ('SE146','E26','REG1'), ('SE147','E27','REG1'), ('SE148','E28','REG1'), ('SE149','E29','REG1'), ('SE150','E30','REG1'), ('SE151','F1','REG1'), ('SE152','F2','REG1'), ('SE153','F3','REG1'), ('SE154','F4','REG1'), ('SE155','F5','REG1'), ('SE156','F6','REG1'), ('SE157','F7','REG1'), ('SE158','F8','REG1'), ('SE159','F9','REG1'), ('SE160','F10','REG1'), ('SE161','F11','REG1'), ('SE162','F12','REG1'), ('SE163','F13','REG1'), ('SE164','F14','REG1'), ('SE165','F15','REG1'), ('SE166','F16','REG1'), ('SE167','F17','REG1'), ('SE168','F18','REG1'), ('SE169','F19','REG1'), ('SE170','F20','REG1'), ('SE171','F21','REG1'), ('SE172','F22','REG1'), ('SE173','F23','REG1'), ('SE174','F24','REG1'), ('SE175','F25','REG1'), ('SE176','F26','REG1'), ('SE177','F27','REG1'), ('SE178','F28','REG1'), ('SE179','F29','REG1'), ('SE180','F30','REG1'), ('SE181','G1','REG1'), ('SE182','G2','REG1'), ('SE183','G3','REG1'), ('SE184','G4','REG1'), ('SE185','G5','REG1'), ('SE186','G6','REG1'), ('SE187','G7','REG1'), ('SE188','G8','REG1'), ('SE189','G9','REG1'), ('SE190','G10','REG1'), ('SE191','G11','REG1'), ('SE192','G12','REG1'), ('SE193','G13','REG1'), ('SE194','G14','REG1'), ('SE195','G15','REG1'), ('SE196','G16','REG1'), ('SE197','G17','REG1'), ('SE198','G18','REG1'), ('SE199','G19','REG1'), ('SE200','G20','REG1');


SET datestyle = "ISO, DMY";
INSERT INTO JADWAL (id_jadwal,tanggal,waktu_mulai,waktu_selesai,id_film) VALUES ('JD1','2018-2-11','2018-02-11 11:15:00','2018-02-11 13:15:00','1'), ('JD2','2018-2-11','2018-02-11 13:20:00','2018-02-11 15:30:00','7'), ('JD3','2018-2-11','2018-02-11 15:35:00','2018-02-11 17:35:00','3'), ('JD4','2018-2-11','2018-02-11 17:40:00','2018-02-11 19:40:00','4'), ('JD5','2018-2-11','2018-02-11 19:45:00','2018-02-11 21:45:00','5'), ('JD6','2018-2-11','2018-02-11 11:15:00','2018-02-11 13:15:00','1'), ('JD7','2018-2-11','2018-02-11 13:20:00','2018-02-11 15:30:00','3'), ('JD8','2018-2-11','2018-02-11 15:35:00','2018-02-11 17:35:00','2'), ('JD9','2018-2-11','2018-02-11 17:40:00','2018-02-11 19:40:00','3'), ('JD10','2018-2-11','2018-02-11 19:45:00','2018-02-11 21:45:00','4');


INSERT INTO MEMBER (email,nama,jenis_kelamin,alamat,no_hp) VALUES ('dodo@gmail.com','Dodo Sardodo','L','Jl. Pinus Tinggi No.21, Depok','021509213'), ('jubile12@yahoo.com','Juniar Septian','L','Perumahan Melati Raya Blok D/5, Tangerang','0218314401'), ('teran_bks@yahoo.co.id','Achmad Terry','L','Jl. Senja Timur No. 4, Bekasi','021823390'), ('nanasinana@yahoo.com','Muna Fika Lestari','P','Jl. Samudera Raya No. 61, Grogol, Jakarta','0218456411'), ('newton_mc2@yahoo.com','Christopher Albert','L','Jl. Pegangsaan Selatan No. 27, Grogol, Jakarta','0211230422'), ('lolokthat@gmail.com','Hussein A','L','Perumahan Asri Blok S No. 21, Bekasi','021855686'), ('flawlessbtj@gmail.com','Amanda Prasetya','P','Perumahan Ujung Indah Blok A/6, Tangerang','0211323314'), ('myert@gmail.com','Mylea Sugandi','P','Jl. Permata No. 5, Semarang','0241232915'), ('mymyhug@gmail.com','Mytea Hugandi','P','Jl. Papandayan No. 143, Ciamis','0228459895'), ('huskybrother@yahoo.com','M. Kodir','L','Jl. Sumarko No. 111, Semarang','0248555316'), ('kutakmau@yahoo.com','Dilan Dashusa','L','Perumahan Lama Ijo Blok E/3, Semarang','0248324792'), ('nataliehuang@rocketmail.com','Natalie Huang','P','Jl. Sukmaduka No. 3, Yogyakarta','0214458211'), ('hanatiara@yahoo.com','Hana Tiara','P','Jl. Lontar No. 12, Bandung','0225831582'), ('imnotgirl@gmail.com','Siti Fadhilia','P','Jl. Rimba Raya No. 73, Bekasi, Jakarta','0216452718'), ('ferryt@yahoo.com','Ferry Tambunan','L','Perumahan Hijau Indah Blok Z/22, Tangerang','0219896652'), ('coprter@yahoo.com','Hugo Cooper','L','Jl. Papandayan No. 95, Bandung','0224577812'), ('jugehoy@yahoo.com','Bradley Agung','L','Jl. Langit Raya No. 67, Grogol, Jakarta','026485114'), ('edwardkoi@yahoo.com','Edward ','L','Jl. Krida Raya No. 91, Depok','0214214312'), ('dewjughi@gmail.com','Aurora Dewi','P','Jl. Tubagus Indra No. 9, Bekasi','0218377212'), ('aaronmt@','Aaron Sudarman','L','Jl. Pegangsaan Utara No. 5, Grogol, Jakarta','0216434213');


INSERT INTO TIKET (id_tiket,harga,id_seating,id_jadwal) VALUES ('TK1','50000','SE1','JD1'), ('TK2','50000','SE2','JD1'), ('TK3','50000','SE3','JD1'), ('TK4','50000','SE4','JD1'), ('TK5','50000','SE5','JD1'), ('TK6','50000','SE6','JD1'), ('TK7','50000','SE7','JD1'), ('TK8','50000','SE8','JD1'), ('TK9','50000','SE9','JD1'), ('TK10','50000','SE10','JD1'), ('TK11','50000','SE11','JD1'), ('TK12','50000','SE12','JD1'), ('TK13','50000','SE13','JD1'), ('TK14','50000','SE14','JD1'), ('TK15','50000','SE15','JD1'), ('TK16','50000','SE16','JD1'), ('TK17','50000','SE17','JD1'), ('TK18','50000','SE18','JD1'), ('TK19','50000','SE19','JD1'), ('TK20','50000','SE20','JD1'), ('TK21','50000','SE21','JD1'), ('TK22','50000','SE22','JD1'), ('TK23','50000','SE23','JD1'), ('TK24','50000','SE24','JD1'), ('TK25','50000','SE25','JD1'), ('TK26','50000','SE26','JD1'), ('TK27','50000','SE27','JD1'), ('TK28','50000','SE28','JD1'), ('TK29','50000','SE29','JD1'), ('TK30','50000','SE30','JD1'), ('TK31','50000','SE31','JD1'), ('TK32','50000','SE32','JD1'), ('TK33','50000','SE33','JD1'), ('TK34','50000','SE34','JD1'), ('TK35','50000','SE35','JD1'), ('TK36','50000','SE36','JD1'), ('TK37','50000','SE37','JD1'), ('TK38','50000','SE38','JD1'), ('TK39','50000','SE39','JD1'), ('TK40','50000','SE40','JD1'), ('TK41','50000','SE41','JD1'), ('TK42','50000','SE42','JD1'), ('TK43','50000','SE43','JD1'), ('TK44','50000','SE44','JD1'), ('TK45','50000','SE45','JD1'), ('TK46','50000','SE46','JD1'), ('TK47','50000','SE47','JD1'), ('TK48','50000','SE48','JD1'), ('TK49','50000','SE49','JD1'), ('TK50','50000','SE50','JD1'), ('TK51','50000','SE51','JD1'), ('TK52','50000','SE52','JD1'), ('TK53','50000','SE53','JD1'), ('TK54','50000','SE54','JD1'), ('TK55','50000','SE55','JD1'), ('TK56','50000','SE56','JD1'), ('TK57','50000','SE57','JD1'), ('TK58','50000','SE58','JD1'), ('TK59','50000','SE59','JD1'), ('TK60','50000','SE60','JD1'), ('TK61','50000','SE61','JD1'), ('TK62','50000','SE62','JD1'), ('TK63','50000','SE63','JD1'), ('TK64','50000','SE64','JD1'), ('TK65','50000','SE65','JD1'), ('TK66','50000','SE66','JD1'), ('TK67','50000','SE67','JD1'), ('TK68','50000','SE68','JD1'), ('TK69','50000','SE69','JD1'), ('TK70','50000','SE70','JD1'), ('TK71','50000','SE71','JD1'), ('TK72','50000','SE72','JD1'), ('TK73','50000','SE73','JD1'), ('TK74','50000','SE74','JD1'), ('TK75','50000','SE75','JD1'), ('TK76','50000','SE76','JD1'), ('TK77','50000','SE77','JD1'), ('TK78','50000','SE78','JD1'), ('TK79','50000','SE79','JD1'), ('TK80','50000','SE80','JD1'), ('TK81','50000','SE81','JD1'), ('TK82','50000','SE82','JD1'), ('TK83','50000','SE83','JD1'), ('TK84','50000','SE84','JD1'), ('TK85','50000','SE85','JD1'), ('TK86','50000','SE86','JD1'), ('TK87','50000','SE87','JD1'), ('TK88','50000','SE88','JD1'), ('TK89','50000','SE89','JD1'), ('TK90','50000','SE90','JD1'), ('TK91','50000','SE91','JD1'), ('TK92','50000','SE92','JD1'), ('TK93','50000','SE93','JD1'), ('TK94','50000','SE94','JD1'), ('TK95','50000','SE95','JD1'), ('TK96','50000','SE96','JD1'), ('TK97','50000','SE97','JD1'), ('TK98','50000','SE98','JD1'), ('TK99','50000','SE99','JD1'), ('TK100','50000','SE100','JD1'), ('TK101','50000','SE101','JD1'), ('TK102','50000','SE102','JD1'), ('TK103','50000','SE103','JD1'), ('TK104','50000','SE104','JD1'), ('TK105','50000','SE105','JD1'), ('TK106','50000','SE106','JD1'), ('TK107','50000','SE107','JD1'), ('TK108','50000','SE108','JD1'), ('TK109','50000','SE109','JD1'), ('TK110','50000','SE110','JD1'), ('TK111','50000','SE111','JD1'), ('TK112','50000','SE112','JD1'), ('TK113','50000','SE113','JD1'), ('TK114','50000','SE114','JD1'), ('TK115','50000','SE115','JD1'), ('TK116','50000','SE116','JD1'), ('TK117','50000','SE117','JD1'), ('TK118','50000','SE118','JD1'), ('TK119','50000','SE119','JD1'), ('TK120','50000','SE120','JD1'), ('TK121','50000','SE121','JD1'), ('TK122','50000','SE122','JD1'), ('TK123','50000','SE123','JD1'), ('TK124','50000','SE124','JD1'), ('TK125','50000','SE125','JD1'), ('TK126','50000','SE126','JD1'), ('TK127','50000','SE127','JD1'), ('TK128','50000','SE128','JD1'), ('TK129','50000','SE129','JD1'), ('TK130','50000','SE130','JD1'), ('TK131','50000','SE131','JD1'), ('TK132','50000','SE132','JD1'), ('TK133','50000','SE133','JD1'), ('TK134','50000','SE134','JD1'), ('TK135','50000','SE135','JD1'), ('TK136','50000','SE136','JD1'), ('TK137','50000','SE137','JD1'), ('TK138','50000','SE138','JD1'), ('TK139','50000','SE139','JD1'), ('TK140','50000','SE140','JD1'), ('TK141','50000','SE141','JD1'), ('TK142','50000','SE142','JD1'), ('TK143','50000','SE143','JD1'), ('TK144','50000','SE144','JD1'), ('TK145','50000','SE145','JD1'), ('TK146','50000','SE146','JD1'), ('TK147','50000','SE147','JD1'), ('TK148','50000','SE148','JD1'), ('TK149','50000','SE149','JD1'), ('TK150','50000','SE150','JD1'), ('TK151','50000','SE151','JD1'), ('TK152','50000','SE152','JD1'), ('TK153','50000','SE153','JD1'), ('TK154','50000','SE154','JD1'), ('TK155','50000','SE155','JD1'), ('TK156','50000','SE156','JD1'), ('TK157','50000','SE157','JD1'), ('TK158','50000','SE158','JD1'), ('TK159','50000','SE159','JD1'), ('TK160','50000','SE160','JD1'), ('TK161','50000','SE161','JD1'), ('TK162','50000','SE162','JD1'), ('TK163','50000','SE163','JD1'), ('TK164','50000','SE164','JD1'), ('TK165','50000','SE165','JD1'), ('TK166','50000','SE166','JD1'), ('TK167','50000','SE167','JD1'), ('TK168','50000','SE168','JD1'), ('TK169','50000','SE169','JD1'), ('TK170','50000','SE170','JD1'), ('TK171','50000','SE171','JD1'), ('TK172','50000','SE172','JD1'), ('TK173','50000','SE173','JD1'), ('TK174','50000','SE174','JD1'), ('TK175','50000','SE175','JD1'), ('TK176','50000','SE176','JD1'), ('TK177','50000','SE177','JD1'), ('TK178','50000','SE178','JD1'), ('TK179','50000','SE179','JD1'), ('TK180','50000','SE180','JD1'), ('TK181','50000','SE181','JD1'), ('TK182','50000','SE182','JD1'), ('TK183','50000','SE183','JD1'), ('TK184','50000','SE184','JD1'), ('TK185','50000','SE185','JD1'), ('TK186','50000','SE186','JD1'), ('TK187','50000','SE187','JD1'), ('TK188','50000','SE188','JD1'), ('TK189','50000','SE189','JD1'), ('TK190','50000','SE190','JD1'), ('TK191','50000','SE191','JD1'), ('TK192','50000','SE192','JD1'), ('TK193','50000','SE193','JD1'), ('TK194','50000','SE194','JD1'), ('TK195','50000','SE195','JD1'), ('TK196','50000','SE196','JD1'), ('TK197','50000','SE197','JD1'), ('TK198','50000','SE198','JD1'), ('TK199','50000','SE199','JD1'), ('TK200','50000','SE200','JD1');


INSERT INTO PEMESANAN (email_member,id_tiket,tgl_pesan) VALUES ('dodo@gmail.com','TK1','4/2/2018'), ('dodo@gmail.com','TK2','4/2/2018'), ('teran_bks@yahoo.co.id','TK90','4/2/2018'), ('nanasinana@yahoo.com','TK44','6/2/2018'), ('newton_mc2@yahoo.com','TK29','11/2/2018'), ('lolokthat@gmail.com','TK6','3/2/2018'), ('flawlessbtj@gmail.com','TK7','5/2/2018'), ('myert@gmail.com','TK66','6/2/2018'), ('mymyhug@gmail.com','TK54','8/2/2018'), ('huskybrother@yahoo.com','TK76','3/2/2018'), ('dodo@gmail.com','TK77','10/2/2018'), ('nataliehuang@rocketmail.com','TK12','12/2/2018'), ('hanatiara@yahoo.com','TK15','3/2/2018'), ('imnotgirl@gmail.com','TK67','7/2/2018'), ('ferryt@yahoo.com','TK10','8/2/2018'), ('coprter@yahoo.com','TK80','10/2/2018'), ('jugehoy@yahoo.com','TK198','9/2/2018'), ('edwardkoi@yahoo.com','TK3','4/2/2018'), ('dewjughi@gmail.com','TK23','3/2/2018'), ('aaronmt@','TK26','3/2/2018');