17 lines
957 B
PHP
17 lines
957 B
PHP
<?php
|
|
include('../koneksi.php');
|
|
pg_query("ALTER TABLE jabatan_pegawai ADD COLUMN urut INT");
|
|
pg_query("UPDATE jabatan_pegawai SET urut=12");
|
|
pg_query("UPDATE jabatan_pegawai SET urut=1 WHERE nama='Direktur'");
|
|
pg_query("UPDATE jabatan_pegawai SET urut=2 WHERE nama LIKE 'Wadir%'");
|
|
pg_query("UPDATE jabatan_pegawai SET urut=3 WHERE nama LIKE 'Ka.Bag%'");
|
|
pg_query("UPDATE jabatan_pegawai SET urut=4 WHERE nama LIKE 'Ka.Bid%'");
|
|
pg_query("UPDATE jabatan_pegawai SET urut=5 WHERE nama LIKE 'Ka.Sub%'");
|
|
pg_query("UPDATE jabatan_pegawai SET urut=6 WHERE nama LIKE 'Ka.Seksi%'");
|
|
pg_query("UPDATE jabatan_pegawai SET urut=7 WHERE nama LIKE 'Ka.Ins%'");
|
|
pg_query("UPDATE jabatan_pegawai SET urut=8 WHERE nama LIKE 'Koo%'");
|
|
pg_query("UPDATE jabatan_pegawai SET urut=9 WHERE nama LIKE 'Ka Ur%'");
|
|
pg_query("UPDATE jabatan_pegawai SET urut=10 WHERE nama LIKE 'Kaur%'");
|
|
pg_query("UPDATE jabatan_pegawai SET urut=11 WHERE nama LIKE '%Unit%'");
|
|
|
|
?>
|