sql

INSERT INTO m_vehicle(
           	vehicle_code,license_no, owner_name,
           	chassis_no, engine_no, vehicle_group_code,
           	vehicle_type_code, year_made, customer_name ,
           	address1, address2, address3,
           	phone1,phone2, active,
           	 active_datetime, non_active_datetime, version,
           	create_datetime, create_username, update_datetime,
            update_username)
VALUES 		(
				'HND','H 6634 SS','Mail',
				'222-442-2442-244','123-432-1234-201','PBD',
	    		'MTR','2016','Rika',
	    		'Boja','Mijen','Ngaliyan',
	    		'087865433421', '0878987661234','Y',
	    		'20160728000000','20160729000000',0,
	    		'20160808000000','Nurfitria','20160813000000',
	    		'Dewi'),

    		(
	    		'YMH', 'H 2434 BP','juky',
	    		'222-443-2443-245','123-432-1234-202','KTR',
	    		'MTR','2016','Ayu',
	    		'gunung_pati','sedayu','Ngaliyan',
	    		'087865466666', '0878987669876','Y',
	    		'20160728000000','20160729000000',0,
	    		'20160808000000', 'efa','20160813000000',
	    		'tania'),

    		(
	    		'DCY', 'DA 1987 BB','Bone',
	    		'222-442-2442-246','123-432-1234-201','PBD',
	    		'MTR','2016','Rika',
	    		'Boja','Mijen','Ngaliyan',
	    		'087865433421','0878987665678','N',
	    		'20160728000000','20160729000000',0,
	    		'20160808000000', 'fitri','20160913000000',
	    		'Nofi'),

    		(
	    		'TYT', 'H 1876 GG','Iwan',
	    		'222-442-2442-247','123-432-1234-203','COS',
	    		'MBL','2016','Desy',
	    		'Mangkang','Peterongan','Belitar',
	    		'087865434576', '0878987669978','Y',
	    		'20160728000000','20160729000000',0,
	    		'20160808000000','Della','20160913000000',
	    		'efa');

     -- ini data vehicle group
    INSERT INTO m_vehicle_group(
    							vehicle_group_code, vehicle_group_name, active,
    							active_datetime, non_active_datetime,version,
				 				create_datetime, create_username, update_datetime,
				   				update_username)
    VALUES 	('PBD','Kendaraan Pribadi','Y','20160713000000',' ',0,'20160713000000', 'Henokh', '20160713000000','Desinta'),
    		('CSTMR', 'Kendaraan Customer', 'Y', '20160713000000', ' ',0, '20160713000000', 'Budi', '20160713000000','Roni' ),
    		('KNTR', 'Kendaraan Kaantor', 'Y', '20160713000000', ' ',0, '20160713000000', 'Maya', '20160713000000','Desi' );

   -- ini data vehicle type
    INSERT INTO m_vehicle_type(
            					vehicle_type_code,vehicle_type_name, vehicle_brand_code,
            					active, active_datetime, non_active_datetime,
           						create_datetime, create_username, update_datetime,
            					update_username, version)

    VALUES ('PCS','Pieces', 'TOYOTA', 'Y',
            '20150724000000', '',
            '20150724000000','Didit', '20150724000000',
            'Congky','0'),

            ('MTR', 'Motor', 'HONDA',
           	'Y', '20150724000000', '',
            '20150724000000', 'Didi', '20150724000000',
            'Coky','0');