sql buat gundam_ci_generator

-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
-- [ BELUM FINAL SEBENARNYA ]
-- Host: localhost
-- Generation Time: Apr 22, 2012 at 04:11 AM
-- Server version: 5.5.8
-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `my_work`
--

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

--
-- Table structure for table `buku`
--

CREATE TABLE IF NOT EXISTS `buku` (
  `buku_id` INT(11) NOT NULL AUTO_INCREMENT,
  `buku_nama` VARCHAR(100) NOT NULL,
  `buku_stat` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`buku_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `buku`
--

INSERT INTO `buku` (`buku_id`, `buku_nama`, `buku_stat`) VALUES
(1, 'Dengeki', 1),
(2, 'Introduction Max 9', 1),
(6, 'Sistem Informasi Manajemen ', 1);

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

--
-- Table structure for table `pasien`
--

CREATE TABLE IF NOT EXISTS `pasien` (
  `pat_id` INT(11) NOT NULL AUTO_INCREMENT,
  `pat_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `pat_stat` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`pat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `pasien`
--


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

--
-- Table structure for table `pasien_val`
--

CREATE TABLE IF NOT EXISTS `pasien_val` (
  `pval_pas` INT(11) NOT NULL AUTO_INCREMENT,
  `pval_var` INT(11) NOT NULL,
  `pval_text` text,
  PRIMARY KEY (`pval_pas`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `pasien_val`
--


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

--
-- Table structure for table `pasien_var`
--

CREATE TABLE IF NOT EXISTS `pasien_var` (
  `var_id` INT(11) NOT NULL AUTO_INCREMENT,
  `var_label` VARCHAR(50) NOT NULL,
  `var_name` CHAR(20) NOT NULL,
  PRIMARY KEY (`var_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `pasien_var`
--

INSERT INTO `pasien_var` (`var_id`, `var_label`, `var_name`) VALUES
(1, 'Nama Lengkap', 'name'),
(2, 'Tanggal Lahir', 'birth');

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

--
-- Table structure for table `role`
--

CREATE TABLE IF NOT EXISTS `role` (
  `r_id` INT(11) NOT NULL AUTO_INCREMENT,
  `r_role` VARCHAR(12) NOT NULL,
  PRIMARY KEY (`r_id`),
  UNIQUE KEY `r_role` (`r_role`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `role`
--

INSERT INTO `role` (`r_id`, `r_role`) VALUES
(1, 'admin'),
(2, 'update');

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

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `user_id` INT(11) NOT NULL AUTO_INCREMENT,
  `user_name` VARCHAR(100) NOT NULL,
  `user_stat` tinyint(2) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`user_id`, `user_name`, `user_stat`) VALUES
(1, 'admin', 1),
(2, 'gunawan', 1);

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

--
-- Table structure for table `user_detail`
--

CREATE TABLE IF NOT EXISTS `user_detail` (
  `ud_user` INT(11) NOT NULL AUTO_INCREMENT,
  `ud_name` VARCHAR(100) NOT NULL,
  `ud_birth` DATE NOT NULL,
  `ud_gender` tinyint(4) NOT NULL COMMENT '1=wanita;2=laki-laki',
  PRIMARY KEY (`ud_user`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `user_detail`
--

INSERT INTO `user_detail` (`ud_user`, `ud_name`, `ud_birth`, `ud_gender`) VALUES
(1, 'admin', '1994-04-22', 1),
(2, 'Gunawan', '1994-04-21', 2);

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

--
-- Table structure for table `user_mail`
--

CREATE TABLE IF NOT EXISTS `user_mail` (
  `um_user` INT(11) NOT NULL,
  `um_mail` VARCHAR(100) NOT NULL,
  PRIMARY KEY (`um_user`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_mail`
--

INSERT INTO `user_mail` (`um_user`, `um_mail`) VALUES
(1, 'admin@test.com'),
(2, 'gunawan@tes.com');

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

--
-- Table structure for table `user_pass`
--

CREATE TABLE IF NOT EXISTS `user_pass` (
  `up_id` INT(11) NOT NULL AUTO_INCREMENT,
  `up_user` INT(11) NOT NULL,
  `up_pass` VARCHAR(100) NOT NULL,
  `up_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`up_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `user_pass`
--

INSERT INTO `user_pass` (`up_id`, `up_user`, `up_pass`, `up_date`) VALUES
(1, 1, '111', '2012-04-22 09:10:51'),
(2, 2, '111', '2012-04-22 09:10:51');

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

--
-- Table structure for table `user_role`
--

CREATE TABLE IF NOT EXISTS `user_role` (
  `ur_id` INT(11) NOT NULL AUTO_INCREMENT,
  `ur_user` INT(11) NOT NULL,
  `ur_role` INT(11) NOT NULL,
  PRIMARY KEY (`ur_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `user_role`
--

INSERT INTO `user_role` (`ur_id`, `ur_user`, `ur_role`) VALUES
(1, 1, 1);