Hibernate Example

-- phpMyAdmin SQL Dump -- version 3.3.9 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Nov 15, 2013 at 03:49 PM -- Server version: 5.5.8 -- PHP Version: 5.3.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `product_catalog` -- -- -------------------------------------------------------- -- -- Table structure for table `product_info` -- CREATE TABLE IF NOT EXISTS `product_info` ( `pk_product_id` varchar(50) NOT NULL, `product_name` varchar(50) NOT NULL, `product_detail` varchar(100) NOT NULL, `parent_product_id` varchar(20) NOT NULL, `child_product_id` varchar(20) NOT NULL, `model` varchar(50) NOT NULL, `material_type` varchar(50) NOT NULL, `quantity` int(5) NOT NULL, `calculation_unit` varchar(4) NOT NULL, `current_rate` decimal(8,0) NOT NULL, `product_image` varchar(255) NOT NULL, `created_by` varchar(25) NOT NULL, `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_updated_by` varchar(50) NOT NULL, `last_updated_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `status` varchar(1) NOT NULL, PRIMARY KEY (`pk_product_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `product_info` -- INSERT INTO `product_info` (`pk_product_id`, `product_name`, `product_detail`, `parent_product_id`, `child_product_id`, `model`, `material_type`, `quantity`, `calculation_unit`, `current_rate`, `product_image`, `created_by`, `created_date`, `last_updated_by`, `last_updated_datetime`, `status`) VALUES ('', '', '', '', '', '', 'JW', 0, '', '0', '', '', '2013-10-16 01:44:00', '', '0000-00-00 00:00:00', ''), ('1000', 'thosanas', 'pd', 'pid', 'NULL', 'model', 'material_type', 0, 'NO', '999', 'image', 'created_by', '2013-11-15 21:08:01', 'last_updated_by', '2013-11-15 21:08:01', '1'), ('11111111111', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381586227Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('111111111111111', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381586094Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('11111111111a', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381586262Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('67876876', 'yiuyi', 'yiuy', '', '', 'yiy', 'HH', 0, 'no', '0', '1381588215Chrysanthemum.jpg', 'yiyi', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('7', '8798798', '7987', '', '', 'pm', 'JW', 798798, 'no', '98798', '1381571437c-t-winding-machine-150mm-125x125.jpg', '798798', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '1'), ('78798', '9879', '7987', '', '', '', 'JW', 98798, 'no', '987988', '1381580817Penguins.jpg', '79879', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('7987', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381582956Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('79877777777', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381584809Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('79877777777888', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381585060Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('79877777777888222222222222', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381585167Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('79877897987', '98798', '7987', '', '', '', 'JW', 798, 'no', '987', '1381580987Jellyfish.jpg', '98798', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('798798797', '897', '987', '', '', '98798', 'JW', 0, 'no', '7', '1381588288Koala.jpg', '779879', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('987', '7987', '987987', '', '', '87', '87987', 0, 'no', '87', '1382179471Hydrangeas.jpg', '87', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('ajskdhaksh', 'yiuyi', 'iuy', '', '', 'iuyiuy', 'JW', 0, 'uiy', '0', '13815690002013-09-23 17.09.05.jpg', 'uy', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '1'), ('hjg', 'hjg', 'hg', '', '', 'g', 'JW', 0, 'j', '0', '1381567851judithpaper.jpg', 'gg', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'g'), ('iuououoiuioui', 'uou', 'oiuoi', '', '', 'uoiu', 'JW', 0, 'oiuo', '0', '13815690932013-09-21 17.43.29.jpg', 'uoiu', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'o'), ('u', 'iouo', 'iuoiu', '', '', 'pm', 'JW', 0, 'no', '0', '1381572794Koala.jpg', 'oiuo', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'u'), ('yiuyiuuiy', 'uiy', 'uy', '', '', 'uy', 'HH', 0, 'no', '0', '1381600683Penguins.jpg', 'uy', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A');