/*
MySQL Data Transfer
Source Host: localhost
Source Database: aceshop
Target Host: localhost
Target Database: aceshop
Date: 2013-9-28 18:14:10
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_goods
-- ----------------------------
DROP TABLE IF EXISTS `t_goods`;
CREATE TABLE `t_goods` (
  `g_ID` int(11) NOT NULL AUTO_INCREMENT,
  `g_Name` varchar(50) NOT NULL,
  `g_Spic` varchar(255) NOT NULL,
  `g_apply` varchar(255) NOT NULL,
  `t_ID` int(11) NOT NULL,
  `g_Price` double(11,0) NOT NULL,
  `g_Number` int(11) NOT NULL,
  `g_Discount` float NOT NULL,
  `g_state` varchar(255) NOT NULL,
  `g_flag` varchar(255) NOT NULL,
  PRIMARY KEY (`g_ID`),
  KEY `t_ID` (`t_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `t_goods` VALUES ('1', '金盏花植物爽肤水', 'facewater1.PNG', 'sales', '1', '330', '100', '1', '是','facewater');
INSERT INTO `t_goods` VALUES ('2', '高保湿清爽洁面乳', 'faceclear1.PNG', 'new', '1', '180', '100', '1', 'faceclear',);
INSERT INTO `t_goods` VALUES ('3', '科颜氏高保湿面膜', 'facemo1.PNG', 'new', '1', '340', '100', '1', '是','facemo');
INSERT INTO `t_goods` VALUES ('4', '男士清爽防晒乳SPF30+ PA+++', 'sunface1.PNG', 'sales', '1', '350', '100', '1', '','sunface');
INSERT INTO `t_goods` VALUES ('5', '集焕白亮肤磨砂乳', 'faceclear2.PNG', 'enjoy', '1', '270', '100', '1', '是','faceclear');
INSERT INTO `t_goods` VALUES ('6', '蓝色草本净肤啫喱', 'faceclear3.PNG', 'daily', '1', '300', '100', '1', '','faceclear');
INSERT INTO `t_goods` VALUES ('7', '亚马逊白泥净致洁面乳 ', 'faceclear4.PNG', 'top', '1', '230', '100', '1', '','faceclear');
INSERT INTO `t_goods` VALUES ('8', '亚马逊白泥净致面膜 ', 'facemo2.PNG', 'enjoy', '1', '280', '100', '1', '是','facemo');
INSERT INTO `t_goods` VALUES ('9', '黄瓜植物精华爽肤水 ', 'facewater2.PNG', 'daily', '1', '200', '100', '1', '','facewater');
INSERT INTO `t_goods` VALUES ('10', '集焕白净透爽肤水', 'facewater3.PNG', 'daily', '1', '285', '100', '1', '','facewater');
INSERT INTO `t_goods` VALUES ('11', '全身保湿护肤乳', 'bodywet.PNG', 'daily', '1', '310', '100', '1', '','bodywet');
INSERT INTO `t_goods` VALUES ('12', '全身保湿慕斯护肤霜 ', 'bodywet2.PNG', 'daily', '1', '370', '100', '1', '','bodywet');
INSERT INTO `t_goods` VALUES ('13', '细润美手霜', 'bodyhand1.PNG', 'daily', '1', '160', '100', '1', '','bodyhand');
INSERT INTO `t_goods` VALUES ('14', '迷迭香薄荷丰盈洗发水', 'hairwater1.PNG', 'daily', '1', '180', '100', '1', '','hairwater');
INSERT INTO `t_goods` VALUES ('15', '向日葵护色护发素', 'haircare1.PNG', 'daily', '1', '220', '100', '1', '','haircare');
INSERT INTO `t_goods` VALUES ('16', '焕白美颜BB霜SPF30+ PA+++', 'sunother1.PNG', 'daily', '1', '350', '100', '1', '','sunother');

