13 lines
513 B
SQL
Executable File
13 lines
513 B
SQL
Executable File
CREATE TABLE `tb_profil` (
|
|
`id_profil` int(11) NOT NULL PRIMARY KEY,
|
|
`nama_desa` varchar(50) NOT NULL,
|
|
`alamat` text NOT NULL,
|
|
`kecamatan` varchar(50) NOT NULL,
|
|
`kabupaten` varchar(50) NOT NULL,
|
|
`provinsi` varchar(50) NOT NULL,
|
|
`kepala_desa` varchar(50) NOT NULL,
|
|
`nip_kades` varchar(30) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
INSERT INTO `tb_profil` VALUES (1, 'Desa Percontohan', 'Jl. Contoh No. 1', 'Kecamatan Contoh', 'Kabupaten Contoh', 'Jawa Barat', 'Budi Santoso', '123456789');
|