-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- 主機: localhost
-- 產生日期: 2017 年 04 月 22 日 12:11
-- 伺服器版本: 5.6.12-log
-- PHP 版本: 5.4.12

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

--
-- 資料庫: `4k010_20123`
--

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

--
-- 表的結構 `qc_defpri`
--

CREATE TABLE IF NOT EXISTS `qc_defpri` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `DEFPRI` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `P0` double DEFAULT NULL,
  `P1` double DEFAULT NULL,
  `P2` double DEFAULT NULL,
  `P3` double DEFAULT NULL,
  `P4` double DEFAULT NULL,
  `P5` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `qc_defpri` (`UID`, `XID`, `DEFPRI`, `COUNTRY`, `P0`, `P1`, `P2`, `P3`, `P4`, `P5`) VALUES
('4K010_20123', 18, '19000', '3', 19000, 565, 610, 720, 1100, 1480),
('4K010_20123', 28, '29000', '3', 29000, 865, 910, 1150, 2100, 2480),
('4K010_20123', 4, '5000', '3', 5000, 145, 220, 250, 350, 390),
('4K010_20123', 2, '3500', '3', 3500, 100, 170, 16200, 350, 390),
('4K010_20123', 43, 'null', '3', 45000, 1296, 0, 1880, 0, 0),
('4K010_20123', 5, '6000', '3', 6000, 175, 270, 300, 400, 490),
('4K010_20123', 27, '28000', '3', 28000, 835, 880, 1100, 2000, 2380),
('4K010_20123', 13, '14000', '3', 14000, 415, 460, 520, 800, 1080),
('4K010_20123', 26, '27000', '3', 27000, 805, 850, 1050, 1900, 2280),
('4K010_20123', 16, '17000', '3', 17000, 505, 550, 640, 1000, 1280),
('4K010_20123', 31, '32000', '3', 32000, 955, 1000, 1300, 2400, 2780),
('4K010_20123', 29, '30000', '3', 30000, 895, 940, 1200, 2200, 2580),
('4K010_20123', 32, '33000', '3', 33000, 985, 1030, 1350, 2500, 2880),
('4K010_20123', 8, '9000', '3', 9000, 265, 350, 380, 600, 690),
('4K010_20123', 10, '11000', '3', 11000, 325, 420, 450, 750, 890),
('4K010_20123', 6, '7000.0', '3', 7000, 210, 450, 650, 780, 780),
('4K010_20123', 17, '18000', '3', 18000, 535, 580, 680, 1000, 1380),
('4K010_20123', 23, '24000', '3', 24000, 715, 760, 920, 1600, 1980),
('4K010_20123', 22, '23000', '3', 23000, 685, 730, 880, 1500, 1880),
('4K010_20123', 21, '22000', '3', 22000, 655, 700, 840, 1400, 1780),
('4K010_20123', 42, 'null', '3', 65000, 1872, 3280, 3280, 0, 3280),
('4K010_20123', 50, '280.0', '1', 280, 280, 300, 330, 580, 680),
('4K010_20123', 12, '13000', '3', 13000, 385, 430, 480, 800, 890),
('4K010_20123', 15, '16000', '3', 16000, 475, 520, 600, 900, 1180),
('4K010_20123', 11, '12000', '3', 12000, 355, 550, 600, 800, 980),
('4K010_20123', 7, '8000', '3', 8000, 235, 320, 350, 600, 690),
('4K010_20123', 47, 'null', '2', 45, 215, 280, 300, 450, 490),
('4K010_20123', 9, '10000.0', '3', 10000, 600, 800, 1000, 1100, 1280),
('4K010_20123', 49, '250.0', '1', 250, 260, 500, 550, 680, 490),
('4K010_20123', 33, '34000', '3', 34000, 1015, 1060, 1400, 2600, 2980),
('4K010_20123', 20, '21000', '3', 21000, 625, 670, 800, 1300, 1680),
('4K010_20123', 14, '15000', '3', 15000, 445, 490, 560, 900, 1080),
('4K010_20123', 24, '25000', '3', 25000, 745, 790, 960, 1700, 2080),
('4K010_20123', 19, '20000', '3', 20000, 595, 640, 760, 1200, 1580),
('4K010_20123', 30, '31000', '3', 31000, 925, 970, 1250, 2300, 2680),
('4K010_20123', 46, '38.0', '2', 38, 181, 250, 380, 580, 780),
('4K010_20123', 25, '26000', '3', 26000, 775, 820, 1000, 1800, 2180),
('4K010_20123', 34, '35000', '3', 35000, 1045, 1090, 1450, 2700, 3080),
('4K010_20123', 44, '60.0', '2', 60, 320, 640, 750, 880, 980),
('4K010_20123', 45, 'null', '2', 180, 860, 1100, 1450, 1800, 1980),
('4K010_20123', 1, '3000', '3', 3000, 85, 150, 180, 250, 290),
('4K010_20123', 52, '33.0', '2', 33, 165, 330, 440, 580, 680),
('4K010_20123', 54, '69.0', '5', 69, 269, 450, 600, 880, 1080),
('4K010_20123', 55, '49.0', '5', 49, 191, 400, 500, 700, 880),
('4K010_20123', 56, '13.0', '2', 13, 65, 130, 260, 350, 580),
('4K010_20123', 57, '59.0', '5', 59, 230, 400, 500, 600, 980),
('4K010_20123', 58, '72.0', '5', 72, 288, 580, 680, 880, 1280),
('4K010_20123', 59, '55.0', '2', 55, 275, 550, 660, 780, 880),
('4K010_20123', 60, '220.0', '1', 220, 220, 440, 480, 580, 580),
('4K010_20123', 61, '79.0', '5', 79, 316, 630, 750, 980, 1380),
('4K010_20123', 62, '280.0', '1', 280, 280, 560, 660, 780, 880),
('4K010_20123', 63, '18.0', '2', 18, 90, 120, 200, 380, 380),
('4K010_20123', 64, '240.0', '1', 240, 240, 480, 530, 680, 680),
('4K010_20123', 65, '26.0', '2', 26, 130, 260, 370, 480, 580),
('4K010_20123', 66, '109.0', '5', 109, 436, 860, 960, 1200, 7580),
('4K010_20123', 68, '320.0', '1', 320, 320, 0, 0, 0, 0),
('4K010_20123', 69, '420.0', '1', 420, 430, 540, 650, 800, 980),
('4K010_20123', 70, '10000.0', '3', 10000, 300, 600, 900, 1000, 1280);

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