-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- 主機: localhost
-- 產生日期: 2014 年 03 月 11 日 01:30
-- 伺服器版本: 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_tb`
--

CREATE TABLE IF NOT EXISTS `produce_tb` (
  `product_sn` int(10) NOT NULL AUTO_INCREMENT COMMENT '唯一值',
  `product_depend_sn` int(5) NOT NULL COMMENT '直屬層sn',
  `product_level_sn` int(5) NOT NULL COMMENT '階層',
  `product_master_sn` int(10) NOT NULL DEFAULT '0' COMMENT '第一層',
  `product_sub_sn` int(10) NOT NULL DEFAULT '0' COMMENT '第二層',
  `product_third_sn` int(10) NOT NULL DEFAULT '0' COMMENT '第三層',
  `product_fourth_sn` int(10) NOT NULL DEFAULT '0' COMMENT '第四層',
  `product_id` varchar(20) NOT NULL COMMENT '產品編號',
  `product_name` varchar(100) NOT NULL COMMENT '產品名稱',
  `product_pic_path` varchar(50) NOT NULL COMMENT '主圖',
  `product_pic_path_2` varchar(50) NOT NULL,
  `product_pic_path_3` varchar(50) NOT NULL,
  `product_file_name` varchar(50) NOT NULL COMMENT '檔案名',
  `product_file_path` varchar(50) NOT NULL COMMENT '檔案',
  `product_content` longtext NOT NULL COMMENT '內容',
  `product_note` longtext NOT NULL COMMENT '備註',
  `product_price` int(5) NOT NULL COMMENT '價錢',
  `product_amount` int(10) NOT NULL COMMENT '數量',
  `product_bonus` int(5) NOT NULL COMMENT '紅利',
  `product_created_time` varchar(20) NOT NULL COMMENT '建立時間',
  `product_online_YN` varchar(5) NOT NULL DEFAULT 'Y' COMMENT '上下線',
  `product_online_sort` int(5) NOT NULL COMMENT '排序',
  PRIMARY KEY (`product_sn`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

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

INSERT INTO `produce_tb` (`product_sn`, `product_depend_sn`, `product_level_sn`, `product_master_sn`, `product_sub_sn`, `product_third_sn`, `product_fourth_sn`, `product_id`, `product_name`, `product_pic_path`, `product_pic_path_2`, `product_pic_path_3`, `product_file_name`, `product_file_path`, `product_content`, `product_note`, `product_price`, `product_amount`, `product_bonus`, `product_created_time`, `product_online_YN`, `product_online_sort`) VALUES
(1, 2, 0, 2, 0, 0, 0, '222', '111', '20140307055134760.jpg', '', '', '', '', '<p>333</p>', '', 0, 0, 0, '1325215765', 'Y', 2),
(2, 5, 2, 1, 5, 0, 0, 'world', 'hello', '20140307055123872.jpg', '', '', '', '', '<p>aaa</p>', '', 0, 0, 0, '1394005846', 'Y', 1),
(3, 2, 1, 2, 0, 0, 0, 'obama', 'hi', '20140310015337730.jpg', '', '', '', '', '<p>aadsaf</p>', '', 0, 0, 0, '1394005883', 'Y', 1),
(4, 10, 2, 9, 10, 0, 0, '001', '素材代工001', '20140307031517703.jpg', '', '', '', '', '<p>產品</p>', '', 0, 0, 0, '1394162117', 'Y', 2),
(5, 11, 2, 9, 11, 0, 0, '002', '素材代工002', '20140307031716177.jpg', '', '', '', '', '<p>產品代工</p>', '', 0, 0, 0, '1394162236', 'Y', 1),
(6, 12, 2, 9, 12, 0, 0, '003', '素材代工003', '20140307031800090.jpg', '', '', '', '', '<p>產品</p>', '', 0, 0, 0, '1394162280', 'Y', 1),
(7, 15, 1, 15, 0, 0, 0, '1231335213', '規格品', '20140307032039842.jpg', '', '', '', '', '<p>規格產品</p>', '', 0, 0, 0, '1394162439', 'Y', 3),
(8, 14, 1, 14, 0, 0, 0, '005', '設備代工005', '20140307053703592.jpg', '', '', '', '', '<p>設備代工</p>', '', 0, 0, 0, '1394170623', 'Y', 2),
(9, 13, 1, 13, 0, 0, 0, '焊接代工006', '焊接代工', '20140307053740321.jpg', '', '', '', '', '<p>焊接代工</p>', '', 0, 0, 0, '1394170660', 'Y', 4),
(10, 13, 1, 13, 0, 0, 0, '007', '焊接代工007', '20140310014224766.jpg', '', '', '', '', '<p>挖挖哇</p>', '', 0, 0, 0, '1394170681', 'Y', 3),
(11, 10, 2, 9, 10, 0, 0, '008', '素材代工008', '20140307053840866.jpg', '', '', '', '', '<p>素材代工008</p>', '', 0, 0, 0, '1394170720', 'Y', 1),
(12, 15, 1, 15, 0, 0, 0, '5566', '超規格品', '20140307053909742.jpg', '', '', '', '', '<p>ㄚㄚㄚ</p>', '', 0, 0, 0, '1394170749', 'Y', 2),
(13, 13, 1, 13, 0, 0, 0, '66556', '和接待工', '20140307055146942.jpg', '', '', '', '', '<p>崩潰</p>', '', 0, 0, 0, '1394170766', 'Y', 2),
(15, 15, 1, 15, 0, 0, 0, 'borther5566', '還不是靠兄弟', '20140307090849112.jpg', '20140310021424974.JPG', '20140310021424922.JPG', '', '', '<p>adsfasdfasdfasdf</p>', '', 0, 0, 0, '1394183329', 'Y', 1);

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