-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Sep 05, 2020 at 06:58 PM
-- Server version: 10.1.19-MariaDB
-- PHP Version: 5.6.28

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

--
-- Database: `ctv`
--

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

--
-- Table structure for table `gift`
--

CREATE TABLE `gift` (
  `GiftID` int(3) NOT NULL,
  `GiftName` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `GiftCName` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `Cost` decimal(4,1) NOT NULL,
  `TotalBuy` int(4) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '0',
  `QuantityLeft` int(3) NOT NULL DEFAULT '0',
  `MarkRequire` int(3) NOT NULL DEFAULT '0',
  `ImagePath` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '../../gift-photo/',
  `LImagePath` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '../../gift-photo/'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `gift`
--

INSERT INTO `gift` (`GiftID`, `GiftName`, `GiftCName`, `Cost`, `TotalBuy`, `status`, `QuantityLeft`, `MarkRequire`, `ImagePath`, `LImagePath`) VALUES
(1, 'Clear File', '透明多頁文件夾', '0.0', 0, 0, 2, 200, 's-clear-file.jpg', 'clear-file.jpg'),
(2, 'Correction Pen', '改錯帶', '6.0', 10, 1, 5, 100, 's-correction-pen.jpg', 'correction-pen.jpg'),
(3, 'HeadPhones', '耳機', '0.0', 0, 0, 0, 100, 's-head-phone.jpg', 'head-phone.jpg'),
(5, 'Note Book', '筆記簿', '0.0', 0, 0, 0, 100, 's-notebook1.jpg', 'notebook1.jpg'),
(6, 'Octopus Holder', '八達通卡套', '0.0', 0, 0, 3, 150, 's-octopus-holder1.jpg', 'octopus-holder1.jpg'),
(7, 'Pen Case', '筆盒', '0.0', 0, 0, 0, 150, 's-pen-case.jpg', 'pen-case.jpg'),
(8, 'Color Pen Set', '色筆套裝', '0.0', 0, 0, 2, 90, 's-pen-set.jpg', 'pen-set.jpg'),
(9, 'Purse1', '銀包1', '0.0', 0, 0, 2, 250, 's-purse1.jpg', 'purse1.jpg'),
(10, 'Purse2', '銀包2', '0.0', 0, 0, 0, 250, 's-purse2.jpg', 'purse2.jpg'),
(11, 'Purse3', '銀包3', '0.0', 0, 0, 0, 250, 's-purse3.jpg', 'purse3.jpg'),
(12, 'Purse4', '銀包4', '0.0', 0, 0, 0, 250, 's-purse4.jpg', 'purse4.jpg'),
(14, 'Small Note Book', '小型筆記簿1', '0.0', 0, 0, 0, 80, 's-small-notebook.jpg', 'small-notebook.jpg'),
(16, 'Hand Tower', '手帕', '2.0', 20, 1, 0, 10, 's-tower.jpg', 'tower.jpg'),
(17, 'Tower1', '面巾', '0.0', 0, 0, 2, 15, 's-tower1.jpg', 'tower1.jpg'),
(18, 'key1', '生果匙扣(櫻桃)', '0.0', 0, 0, 4, 100, 'skey1.jpg', 'key1.jpg'),
(19, 'key2', '生果匙扣(西瓜)', '0.0', 0, 0, 2, 100, 'skey2.jpg', 'key2.jpg'),
(20, 'key3', '生果匙扣(檸檬)', '5.0', 10, 1, 2, 100, 'skey3.jpg', 'key3.jpg'),
(23, 'Slidekey2', '滑板匙扣(銀色)', '0.0', 0, 0, 0, 150, 'sslidekey2.jpg', 'slidekey2.jpg'),
(24, 'Slidekey3', '滑板匙扣(紅色)', '0.0', 0, 0, 0, 150, 'sslidekey5.jpg', 'slidekey5.jpg'),
(26, 'Slidekey4', '滑板匙扣(黑色)', '0.0', 0, 0, 0, 150, 'sslidekey3.jpg', 'slidekey3.jpg'),
(27, 'Slidekey5', '滑板匙扣(青色)', '0.0', 0, 0, 0, 100, 'sslidekey4.jpg', 'slidekey4.jpg'),
(28, 'Slidekey6', '滑板匙扣(藍色)', '0.0', 0, 0, 0, 100, 'sslidekey6.jpg', 'slidekey6.jpg'),
(29, 'Correction Liquid Pe', '塗改液筆', '0.0', 0, 0, 0, 120, 'scorrect2.jpg', 'correct2.jpg'),
(30, 'Coins Dog', '碎錢包', '0.0', 0, 0, 0, 350, 'scoins.jpg', 'coins.jpg'),
(31, 'CD Bag', 'CD 袋', '0.0', 0, 0, 0, 350, 'scd.jpg', 'cs.jpg'),
(32, 'Dog', '狗仔', '0.0', 0, 0, 2, 300, 'sdog2.jpg', 'dog2.jpg'),
(33, 'Multi-Color Pen', '多色筆', '0.0', 0, 0, 0, 150, 's3cpen.jpg', '3cpen.jpg'),
(34, 'Pen-snake', '原子筆(青竹蛇)', '0.0', 0, 0, 0, 300, 'spen-snake.jpg', 'pen-snake.jpg'),
(35, 'Pen-crocodile', '原子筆(鱷魚)', '0.0', 0, 0, 2, 300, 'spen-croco.jpg', 'pen-croco.jpg'),
(36, 'Color Pen (Sweet)', '螢光筆(Sweet Friends', '0.0', 0, 0, 0, 300, 'spen-sweet.jpg', 'pen-sweet.jpg'),
(37, 'Color Pen (Peter Rab', '螢光筆(Peter Rabbit)', '0.0', 0, 0, 0, 500, 'pen-rabbit.jpg', 'pen-rabbit.jpg'),
(38, 'Set Notebook', '禮包 (記事簿)', '0.0', 0, 0, 0, 250, 'sset-notebook.jpg', 'set-notebook.jpg'),
(39, 'Set Phonebook', '禮包 (電話簿)', '0.0', 0, 0, 0, 250, 'sset-phonebook.jpg', 'set-phonebook.jpg'),
(40, 'Set for Letter', '禮包 (信套)', '0.0', 0, 0, 0, 300, 'sset-letter.jpg', 'set-letter.jpg'),
(41, 'Set Hello I with 2 p', '禮包 (Hello I-neco)', '0.0', 0, 0, 0, 300, 'sset-i2pen.jpg', 'set-i2pen.jpg'),
(42, 'Set with 2 pens', '禮包 (雙筆 + 尺)', '0.0', 0, 0, 0, 400, 'sset-2pen.jpg', 'set-2pen.jpg'),
(43, 'Set with key', '禮包 (筆 + 匙)', '0.0', 0, 0, 0, 400, 'sset-key.jpg', 'set-key.jpg'),
(44, 'Set Pooh with pens', '禮包 (Pooh筆 + 尺)', '0.0', 0, 0, 0, 400, 'sset-pooh.jpg', 'set-pooh.jpg'),
(45, 'Small Tower', '方 巾', '0.0', 0, 0, 0, 80, 's-tower2.jpg', 'tower2.jpg'),
(46, 'Small Notebook', '小型筆記簿', '0.0', 0, 0, 0, 80, 'ssmall-notebook.jpg', 'small-notebook1.jpg'),
(47, 'Clock', '座鐘', '0.0', 0, 0, 0, 150, 'sclock.jpg', 'clock.jpg'),
(48, 'Radio', '收音機', '0.0', 0, 0, 0, 500, 'sradio.jpg', 'radio.jpg'),
(49, 'Flower Seed', '種花套裝', '0.0', 0, 0, 0, 200, 'sflower.jpg', 'flower.jpg'),
(50, 'Memory Book', '紀念冊', '0.0', 0, 0, 0, 150, 'smemorybook.jpg', 'memorybook.jpg'),
(51, 'small radio', '小型收音機', '10.0', 3, 1, 3, 100, 'sradio.jpg', 'radio.jpg');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `gift`
--
ALTER TABLE `gift`
  ADD PRIMARY KEY (`GiftID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `gift`
--
ALTER TABLE `gift`
  MODIFY `GiftID` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;
/*!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 */;
