dibantu

-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 28, 2013 at 08:24 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_hero`
--

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

--
-- Table structure for table `raja_category`
--

CREATE TABLE IF NOT EXISTS `raja_category` (
  `cat_id` INT(11) NOT NULL AUTO_INCREMENT,
  `cat_code` VARCHAR(11) DEFAULT NULL,
  `cat_name` VARCHAR(31) DEFAULT NULL,
  `cat_detail` text,
  `cat_parent` VARCHAR(31) DEFAULT NULL,
  PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `raja_currency`
--

CREATE TABLE IF NOT EXISTS `raja_currency` (
  `cur_id` INT(11) NOT NULL AUTO_INCREMENT,
  `cur_name` VARCHAR(31) DEFAULT NULL,
  PRIMARY KEY (`cur_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `raja_currencyvalue`
--

CREATE TABLE IF NOT EXISTS `raja_currencyvalue` (
  `curval_id` INT(11) NOT NULL AUTO_INCREMENT,
  `curval_cur` INT(11) DEFAULT NULL,
  `curval_sale` INT(11) DEFAULT NULL,
  `curval_buy` INT(11) DEFAULT NULL,
  `curval_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`curval_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `raja_customer`
--

CREATE TABLE IF NOT EXISTS `raja_customer` (
  `cus_id` INT(11) NOT NULL AUTO_INCREMENT,
  `cus_code` VARCHAR(9) CHARACTER SET utf32 COLLATE utf32_bin NOT NULL,
  `cus_name` VARCHAR(30) CHARACTER SET utf32 COLLATE utf32_bin NOT NULL,
  `cus_detail` text CHARACTER SET utf32 COLLATE utf32_bin NOT NULL,
  PRIMARY KEY (`cus_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `raja_customeraddress`
--

CREATE TABLE IF NOT EXISTS `raja_customeraddress` (
  `cadr_id` INT(11) NOT NULL AUTO_INCREMENT,
  `cadr_cus` INT(11) NOT NULL,
  `cadr_address` text CHARACTER SET utf32 COLLATE utf32_bin NOT NULL,
  PRIMARY KEY (`cadr_id`),
  KEY `cadr_cus` (`cadr_cus`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `raja_logstock`
--

CREATE TABLE IF NOT EXISTS `raja_logstock` (
  `logstock_id` INT(11) NOT NULL AUTO_INCREMENT,
  `logstock_prod` INT(11) DEFAULT NULL,
  `logstock_store` INT(11) DEFAULT NULL,
  `logstock_stock0` INT(11) DEFAULT NULL,
  `logstock_stock1` INT(11) DEFAULT NULL,
  `logstock_act` VARCHAR(31) DEFAULT NULL,
  `logstock_type` VARCHAR(31) DEFAULT NULL,
  `logstock_detail` text,
  PRIMARY KEY (`logstock_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `raja_merk`
--

CREATE TABLE IF NOT EXISTS `raja_merk` (
  `merk_id` INT(11) NOT NULL AUTO_INCREMENT,
  `merk_code` VARCHAR(11) DEFAULT NULL,
  `merk_name` VARCHAR(31) DEFAULT NULL,
  `merk_detail` text,
  PRIMARY KEY (`merk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `raja_product`
--

CREATE TABLE IF NOT EXISTS `raja_product` (
  `prod_id` INT(11) NOT NULL AUTO_INCREMENT,
  `prod_code` VARCHAR(9) CHARACTER SET utf32 COLLATE utf32_bin NOT NULL,
  `prod_name` VARCHAR(30) CHARACTER SET utf32 COLLATE utf32_bin NOT NULL,
  `prod_parent` INT(11) DEFAULT NULL,
  `prod_merk` INT(11) DEFAULT NULL,
  `prod_price` INT(11) DEFAULT NULL,
  `prod_stat` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`prod_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `raja_productcat`
--

CREATE TABLE IF NOT EXISTS `raja_productcat` (
  `pcat_id` INT(11) NOT NULL AUTO_INCREMENT,
  `pcat_prod` INT(11) DEFAULT NULL,
  `pcat_cat` INT(11) DEFAULT NULL,
  PRIMARY KEY (`pcat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `raja_productdetail`
--

CREATE TABLE IF NOT EXISTS `raja_productdetail` (
  `prodet_id` INT(11) NOT NULL AUTO_INCREMENT,
  `prodet_detail` text CHARACTER SET utf32 COLLATE utf32_bin NOT NULL,
  PRIMARY KEY (`prodet_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `raja_productprice`
--

CREATE TABLE IF NOT EXISTS `raja_productprice` (
  `prodprice_id` INT(11) NOT NULL AUTO_INCREMENT,
  `prodprice_product` INT(11) DEFAULT NULL,
  `prodprice_currency` INT(11) DEFAULT NULL,
  `prodprice_price` INT(11) DEFAULT NULL,
  PRIMARY KEY (`prodprice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `raja_productstock`
--

CREATE TABLE IF NOT EXISTS `raja_productstock` (
  `pstock_id` INT(11) NOT NULL AUTO_INCREMENT,
  `pstock_prod` INT(11) DEFAULT NULL,
  `pstock_store` INT(11) DEFAULT NULL,
  `pstock_stock` INT(11) DEFAULT NULL,
  PRIMARY KEY (`pstock_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `raja_store`
--

CREATE TABLE IF NOT EXISTS `raja_store` (
  `str_id` INT(11) NOT NULL AUTO_INCREMENT,
  `str_code` VARCHAR(9) COLLATE utf32_bin NOT NULL,
  `str_name` VARCHAR(30) COLLATE utf32_bin NOT NULL,
  `str_detail` text COLLATE utf32_bin NOT NULL,
  PRIMARY KEY (`str_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf32 COLLATE=utf32_bin AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `raja_suplier`
--

CREATE TABLE IF NOT EXISTS `raja_suplier` (
  `sup_id` INT(11) NOT NULL AUTO_INCREMENT,
  `sup_name` VARCHAR(30) NOT NULL,
  `sup_detail` text NOT NULL,
  PRIMARY KEY (`sup_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `raja_customer`
--
ALTER TABLE `raja_customer`
  ADD CONSTRAINT `raja_customer_ibfk_1` FOREIGN KEY (`cus_id`) REFERENCES `raja_customeraddress` (`cadr_cus`) ON DELETE NO ACTION ON UPDATE NO ACTION;