goods.sql

一个简单的网上商店系统

-- MySQL dump 10.10
--
-- Host: 127.0.0.1    Database: netshop
-- ------------------------------------------------------
-- Server version	5.0.21-community-nt

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `goods`
--

DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `goods_id` int(11) NOT NULL auto_increment,
  `goods_name` varchar(50) default NULL,
  `typeid` int(11) default NULL,
  `goods_price` float default NULL,
  `goods_discount` float default NULL,
  `goods_desc` varchar(200) default NULL,
  `supplier` varchar(50) default NULL,
  `qty` int(11) default NULL,
  `ispreferred` int(11) default NULL,
  `goods_pic` varchar(50) default NULL,
  `hold1` varchar(50) default NULL,
  `hold2` varchar(50) default NULL,
  `hold3` varchar(50) default NULL,
  `hold4` varchar(50) default NULL,
  `hold5` varchar(50) default NULL,
  PRIMARY KEY  (`goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

--
-- Dumping data for table `goods`
--


/*!40000 ALTER TABLE `goods` DISABLE KEYS */;
LOCK TABLES `goods` WRITE;
INSERT INTO `goods` VALUES 
	(1,'Eclipse从入门到精通',3,55,7.5,'本书系统讲述了基于Eclipse的应用开发和设计，并提供了完整而实用的例程，适用于所有希望掌握Eclipse的人','陈刚著，清华大学出版社',400,0,'./image/book-1.jpg',NULL,NULL,NULL,NULL,NULL);


INSERT INTO `goods` VALUES
	(2,'滑稽狗宝贝',2,40,9.5,'可爱滑稽的狗宝宝，让孩子欢心，女友开心，妻子舒心','温馨礼品店',400,0,'./image/gift-1.jpg',NULL,NULL,NULL,NULL,NULL);

INSERT INTO `goods` VALUES
	(3,'珍珠礼品项链',2,100,9.5,'一串珍珠项链，可以让男人得到女人的真爱，而让女人更加婀娜丰韵','温馨礼品店',400,0,'./image/gift-2.jpg',NULL,NULL,NULL,NULL,NULL);

INSERT INTO `goods` VALUES
	(4,'玲珑木偶',2,50,9.5,'小巧玲珑的木偶，因其可爱的造型，精细的做工而成为节日里传达爱意的绝佳礼品','温馨礼品店',200,0,'./image/gift-3.jpg',NULL,NULL,NULL,NULL,NULL);


INSERT INTO `goods` VALUES 
	(5,'温馨玫瑰',2,10,9,'一朵含苞怒放的玫瑰花带给心中的她/他无限柔情蜜意','温馨花市',200,0,'./image/love-1.jpg',NULL,NULL,NULL,NULL,NULL);


INSERT INTO `goods` VALUES
  (6,'飞天TX888',1,500,9.5,'可以更换外壳，内置天线','飞天公司',200,0,'./image/TX888.jpg',NULL,NULL,NULL,NULL,NULL);


INSERT INTO `goods` VALUES
	(7,'飞天TX666',1,850,9.5,'钛金属外壳，GPRS网络与蓝牙，可录音，内置天线，内置振动，语音拨号','飞天公司',200,0,'./image/TX666.jpg',NULL,NULL,NULL,NULL,NULL);
UNLOCK TABLES;