-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- 主機: localhost
-- 產生日期: 2014 年 03 月 11 日 01:29
-- 伺服器版本: 5.5.24-log
-- PHP 版本: 5.2.6

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


/*!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 */;

--
-- 資料庫: `jddtadmin`
--

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

--
-- 表的結構 `product_category_tb`
--

CREATE TABLE IF NOT EXISTS `produce_category_tb` (
  `category_sn` int(10) NOT NULL AUTO_INCREMENT,
  `category_level_sn` varchar(10) NOT NULL,
  `category_depend_sn` int(10) NOT NULL DEFAULT '0',
  `category_name` varchar(100) NOT NULL DEFAULT '',
  `category_content` text NOT NULL,
  `category_pic_path` varchar(100) NOT NULL DEFAULT '',
  `category_pic1_path` varchar(100) NOT NULL,
  `category_file_path` varchar(100) NOT NULL,
  `category_online_sort` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`category_sn`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;

--
-- 轉存資料表中的資料 `product_category_tb`
--

INSERT INTO `produce_category_tb` (`category_sn`, `category_level_sn`, `category_depend_sn`, `category_name`, `category_content`, `category_pic_path`, `category_pic1_path`, `category_file_path`, `category_online_sort`) VALUES
(1, '1', 0, '分類1', '', '', '', '', 2),
(2, '1', 0, '分類2', '', '', '', '', 6),
(3, '2', 1, '次分類1', '', '', '', '', 1),
(5, '2', 1, '次分類2', '', '', '', '', 2),
(9, '1', 0, '塑材代工', '', '', '', '', 1),
(10, '2', 9, '塑材代工01', '', '', '', '', 1),
(11, '2', 9, '塑材代工02', '', '', '', '', 2),
(12, '2', 9, '塑材代工03', '', '', '', '', 3),
(13, '1', 0, '焊接代工', '', '', '', '', 5),
(14, '1', 0, '設備代工', '', '', '', '', 4),
(15, '1', 0, '規格品', '', '', '', '', 3);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;