--confkolom --- BPS

--1 rp3DaerahAdministrasi
delete from confkolom where urut=301;
insert into confkolom values(301,'bulan',1);
insert into confkolom values(301,'tahun',2);
insert into confkolom values(301,'propinsi',3);
insert into confkolom values(301,'kabupaten',4);
insert into confkolom values(301,'kota',5);
insert into confkolom values(301,'kecamatan',6);
insert into confkolom values(301,'desa',7);


--2 rp3daerahPropinsi
delete from confkolom where urut=302;
insert into confkolom values(302,'tahun',1);
insert into confkolom values(302,'propinsi',2);
insert into confkolom values(302,'kabupaten',3);
insert into confkolom values(302,'kota',4);
insert into confkolom values(302,'kecamatan',5);
insert into confkolom values(302,'desa',6);

--3 rp3luasIndonesia
delete from confkolom where urut=303;
insert into confkolom values(303,'tahun',1);
insert into confkolom values(303,'propinsi',2);
insert into confkolom values(303,'luas',3);

--4 rp3penduduk
delete from confkolom where urut=304;
insert into confkolom values(304,'tahun',1);
insert into confkolom values(304,'penduduk',2);

--5 rp3kepadatan
delete from confkolom where urut=305;
insert into confkolom values(305,'tahun',1);
insert into confkolom values(305,'penduduk',2);
insert into confkolom values(305,'prosen',3);
insert into confkolom values(305,'padatan',4);

--6 rp3pendudukPropinsi
delete from confkolom where urut=306;
insert into confkolom values(306,'bulan',1);
insert into confkolom values(306,'tahun',2);
insert into confkolom values(306,'propinsi',3);
insert into confkolom values(306,'jumlah',4);


--7 rp3pendudukKU
delete from confkolom where urut=307;
insert into confkolom values(307,'tahun',1);
insert into confkolom values(307,'u1',2);
insert into confkolom values(307,'u2',3);
insert into confkolom values(307,'u3',4);
insert into confkolom values(307,'u4',5);
insert into confkolom values(307,'u5',6);
insert into confkolom values(307,'u6',7);
insert into confkolom values(307,'u7',8);
insert into confkolom values(307,'u8',9);
insert into confkolom values(307,'u9',10);
insert into confkolom values(307,'u10',11);
insert into confkolom values(307,'u11',12);
insert into confkolom values(307,'u12',13);
insert into confkolom values(307,'u13',14);
insert into confkolom values(307,'u14',15);
insert into confkolom values(307,'u15',16);
insert into confkolom values(307,'u16',17);

--8 rp3pendudukKU
delete from confkolom where urut=308;
insert into confkolom values(308,'tahun',1);
insert into confkolom values(308,'u1',2);
insert into confkolom values(308,'u2',3);
insert into confkolom values(308,'u3',4);
insert into confkolom values(308,'beban',5);

--9 rp3estimasi
delete from confkolom where urut=309;
insert into confkolom values(309,'tahun',1);
insert into confkolom values(309,'propinsi',2);
insert into confkolom values(309,'tfr',3);
insert into confkolom values(309,'imr',4);
insert into confkolom values(309,'nrr',5);

--10 rp3rumahtangga
delete from confkolom where urut=310;
insert into confkolom values(310,'tahun',1);
insert into confkolom values(310,'propinsi',2);
insert into confkolom values(310,'tfr',3);
insert into confkolom values(310,'imr',4);
insert into confkolom values(310,'nrr',5);





