perbaikan

-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 26, 2012 at 06:22 AM
-- Server version: 5.5.16
-- PHP Version: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `work_jk2`
--

-- --------------------------------------------------------

--
-- Table structure for table `agama`
--

CREATE TABLE IF NOT EXISTS `agama` (
  `kode_agama` tinyint(4) NOT NULL AUTO_INCREMENT,
  `nama_agama` VARCHAR(20) DEFAULT NULL,
  PRIMARY KEY (`kode_agama`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `agama`
--

INSERT INTO `agama` (`kode_agama`, `nama_agama`) VALUES
(1, 'islam'),
(2, 'kristen'),
(3, 'budha'),
(4, 'hindu');

-- --------------------------------------------------------

--
-- Table structure for table `kelas`
--

CREATE TABLE IF NOT EXISTS `kelas` (
  `kode_kelas` VARCHAR(4) NOT NULL,
  `nama_kelas` VARCHAR(20) DEFAULT NULL,
  PRIMARY KEY (`kode_kelas`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kelas`
--

INSERT INTO `kelas` (`kode_kelas`, `nama_kelas`) VALUES
('A1', '1 IPA 1'),
('A2', '1 IPA 2'),
('A3', '1 IPA 3');

-- --------------------------------------------------------

--
-- Table structure for table `kota`
--

CREATE TABLE IF NOT EXISTS `kota` (
  `kode_kota` tinyint(4) NOT NULL AUTO_INCREMENT,
  `nama_kota` VARCHAR(50) DEFAULT NULL,
  PRIMARY KEY (`kode_kota`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `kota`
--

INSERT INTO `kota` (`kode_kota`, `nama_kota`) VALUES
(1, 'jakarta'),
(2, 'bogor'),
(3, 'tanggerang'),
(4, 'bekasi');

-- --------------------------------------------------------

--
-- Table structure for table `siswa`
--

CREATE TABLE IF NOT EXISTS `siswa` (
  `nis` VARCHAR(20) NOT NULL DEFAULT '',
  `nama_siswa` VARCHAR(70) DEFAULT NULL,
  `tempat_lahir` tinyint(4) DEFAULT NULL,
  `tgl_lahir` VARCHAR(50) DEFAULT NULL,
  `jkel` enum('L','P') DEFAULT NULL,
  `agama` tinyint(4) DEFAULT NULL,
  `nm_ortu` VARCHAR(70) DEFAULT NULL,
  `pekerjaan_ortu` VARCHAR(100) DEFAULT NULL,
  `alamat` VARCHAR(400) DEFAULT NULL,
  `kelas` VARCHAR(4) DEFAULT NULL,
  PRIMARY KEY (`nis`),
  KEY `agama` (`agama`),
  KEY `tempat_lahir` (`tempat_lahir`),
  KEY `agama_2` (`agama`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `siswa`
--
ALTER TABLE `siswa`
  ADD CONSTRAINT `siswa_ibfk_2` FOREIGN KEY (`tempat_lahir`) REFERENCES `kota` (`kode_kota`),
  ADD CONSTRAINT `siswa_ibfk_1` FOREIGN KEY (`agama`) REFERENCES `agama` (`kode_agama`);