JDBC&Oracle启动

 

【Wed Apr 26 2017 16:05:11 GMT+0800】
PLSQL Developer连接远程oracle配置（本地不安装客户端）、
在windows机器上不想安装oracle或者oracle的客户端，我们怎么使用PLSQL Developer工具呢？答案如下：
1：在oracle官网上下载instantclient-basic-nt-11.2.0.3.0.zip该文件，
下载完成后解压该文件。如：我将其解压在E:\oracleClient\instantclient_11_2该路径下。进入到instantclient_11_2下创建目录NETWORK，然后再NETWORK下建立目录ADMIN。在ADMIN目录下建立tnsnames.ora文件，在该tnsnames.ora文件中添加如下内容：

# tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.222)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

192.168.1.222：为数据库所在机器IP。
2：环境变量的配置
打开环境变量设置添加TNS_ADMIN，值为tnsnames.ora所在路径。如本机为E:\oracleClient\instantclient_11_2\NETWORK\ADMIN\tnsnames.ora
设置ORACLE的语言，添加环境变量NLS_LANG，值为AMERICAN_AMERICA.AL32UTF8 如果出现乱码可用SIMPLIFIED CHINESE_CHINA.ZHS16GBK
3：下载并安装PLSQL Developer
安装完成后进入PLSQL Developer，选择tools->preferences->connection
Oracle Home：E:\oracleClient\instantclient_11_2 
OCI library：E:\oracleClient\instantclient_11_2\oci.dll
修改完毕后保存并重启PLSQL Developer就可以使用该工具了。

 

【Mon Aug 29 2016 13:34:21 GMT+0800】

CREATE TABLE `customers` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL,
  `address` varchar(30) default '',
  `phone` varchar(30) default '',
  `email` varchar(30) default '',
  `birth` date default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

【2019年1月2日 00:36:46】
PLSQL+Developer+11.06最新中文绿色注册版(免Oracle11g客户端)

编辑D:\Dev\Program\DB\PLSQL Developer\instantclient_11_2下的tnsnames.ora，如下：

# tnsnames.ora Network Configuration File:  tnsnames.ora
# Generated by Oracle configuration tools.

orcl =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1 )(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl )
    )
  )

helowin15 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 223.223.185.15 )(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = helowin )
    )
  ) 

即可登录成功。

001-通过Driver接口获取数据库连接

　　Driver 是一个接口: 数据库厂商必须提供实现的接口. 能从其中获取数据库连接。
　　可以通过 Driver的实现类对象获取数据库连接。
　　1. 加入MySQL驱动
　　⑴解压"mysql-connector-java-5.1.7.zip"。
　　⑵在当前项目下新建"lib"目录。
　　⑶把"mysql-connector-java-5.1.7-bin.jar"复制到lib目录下。
　　⑷右键"Build Path"→"Add to Build Path"加入到类路径下。

package com.atguigu.jdbc;

import java.sql.Connection;
import java.sql.Driver;
import java.sql.SQLException;
import java.util.Properties;

import org.junit.Test;

public class JDBCTest1 {
  @Test
  public void testDriver() throws SQLException {
    //1. 创建一个 Driver实现类的对象
    Driver driver = new com.mysql.jdbc.Driver();
    //2. 准备连接数据库的基本信息: url、user、password
    String url = "jdbc:mysql://localhost:3306/atguigu";
    Properties info = new Properties();
    info.put("user", "root");
    info.put("password", "123456");
    //3. 调用 Driver 接口的　connect(url, info) 获取数据库连接
    Connection connection = driver.connect(url, info);
    System.out.println(connection);
  }    
}

　　第8行，需要加入单元测试：右键“Properties”在窗口中，首先在左边选择“Java Build Path”，然后到右上选择“Libraries”标签，之后在最右边点击“Add Library…”按钮，选择“JUnit4”。
　　第16行，数据库的库名：atguigu。

　　编写一个通用的方法, 在不修改源程序的情况下, 可以获取任何数据库的连接
　　解决方案: 把数据库驱动Driver实现类的全类名、url、user、password 放入一个配置文件（jdbc.properties）中, 通过修改配置文件的方式实现和具体的数据库解耦。

package com.atguigu.jdbc;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.Driver;
import java.util.Properties;

import org.junit.Test;

public class JDBCTest2 {
  public Connection getConnection() throws Exception {
    String driverClass = null;
    String jdbcUrl = null;
    String user = null;
    String password = null;
    //读取类路径下的jdbc.properties文件（在src下）
    InputStream in = getClass().getClassLoader().getResourceAsStream("jdbc.properties");
    Properties properties = new Properties();
    properties.load(in);
    driverClass = properties.getProperty("driver");
    jdbcUrl = properties.getProperty("jdbcUrl");
    user = properties.getProperty("user");
    password = properties.getProperty("password");
    //通过反射常见Driver对象 
    Driver driver = (Driver) Class.forName(driverClass).newInstance();
    Properties info = new Properties();
    info.put("user", user);
    info.put("password", password);
    //通过Driver的connect方法获取数据库连接.
    Connection connection = driver.connect(jdbcUrl, info);
    return connection;
  }
  @Test
  public void testGetConnection() throws Exception{
    System.out.println(getConnection());
  }
}

　　DriverManager是驱动的管理类
　　⑴可以通过重载的 getConnection()方法获取数据库连接. 较为方便。
　　⑵可以同时管理多个驱动程序: 若注册了多个数据库连接, 则调用 getConnection()方法时传入的参数不同, 即：返回不同的数据库连接。

package com.atguigu.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;

import org.junit.Test;

public class JDBCTest3 {
  @Test
  public void testDriverManager() throws Exception {
    //1. 准备连接数据库的4个字符串. 
    String driverClass = "com.mysql.jdbc.Driver"; //驱动的全类名 
    String jdbcUrl = "jdbc:mysql:///atguigu"; //JDBC URL   
    String user = "root"; //user 
    String password = "123456"; //password

    //2. 加载数据库驱动程序(对应的 Driver 实现类中有注册驱动的静态代码块.)
    Class.forName(driverClass);

    //3. 通过 DriverManager 的 getConnection() 方法获取数据库连接. 
    Connection connection =  DriverManager.getConnection(jdbcUrl, user, password);
    System.out.println(connection); 
  }
}

 

package com.atguigu.jdbc;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

import org.junit.Test;

public class JDBCTest4 {
  public Connection getConnection2() throws Exception{
    //1. 准备连接数据库的4个字符串. 
    //⑴创建Properties对象
    Properties properties = new Properties();
    //⑵ 获取jdbc.properties对应的输入流
    InputStream in = this.getClass().getClassLoader().getResourceAsStream("jdbc.properties");
    //⑶加载⑵对应的输入流
    properties.load(in);
    //⑷具体决定user、password 等4个字符串. 
    String user = properties.getProperty("user");
    String password = properties.getProperty("password");
    String jdbcUrl = properties.getProperty("jdbcUrl");
    String driver = properties.getProperty("driver");
    //2. 加载数据库驱动程序(对应的Driver实现类中有注册驱动的静态代码块)
    Class.forName(driver);
    //3. 通过DriverManager的getConnection()方法获取数据库连接. 
    return DriverManager.getConnection(jdbcUrl, user, password);
  }
  @Test
  public void testGetConnection2() throws Exception{
    System.out.println(getConnection2()); 
  }
}

　　通过JDB 向指定的数据表中插入一条记录.
　　1. Statement: 用于执行SQ 语句的对象
　　⑴通过Connectio的createStatement()方法来获取。
　　⑵通过executeUpdate(sql)可以执行SQL语句。
　　⑶传入的SQL可以是INSRET、UPDATE或DELETE。但不能是SELECT。
　　2. Connection、Statement都是应用程序和数据库服务器的连接资源. 使用后一定要关闭。需要在finally中关闭Connection和Statement对象。
　　3. 关闭的顺序是: 先关闭后获取的， 即：先关闭Statement后关闭Connection。

package com.atguigu.jdbc;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.util.Properties;
import org.junit.Test;

public class JDBCTest5 {
  @Test
  public void testStatement() throws Exception{
    //1. 获取数据库连接
    Connection conn = null;
    Statement statement = null;
    try {
      conn = getConnection2();
      //3. 准备插入的SQL语句
      String sql = null;
      sql = "INSERT INTO customers (name, email, birth) VALUES('Jerry', 'jerry@atguigu.com', '1991-2-12')";
      // sql = "DELETE FROM customers WHERE id = 1";
      // sql = "UPDATE customers SET name = 'TOM' WHERE id = 4";
      System.out.println(sql);
      //4. 执行插入
      //⑴获取操作SQL语句的Statement对象: 
      statement = conn.createStatement();//调用Connection的createStatement()方法来获取
      //⑵调用Statement对象的executeUpdate(sql)执行SQL语句进行插入
      statement.executeUpdate(sql);
    } catch (Exception e) {
      e.printStackTrace();
    } finally{
      try {
        //5. 关闭Statement对象
        if(statement != null)
        statement.close();
      } catch (Exception e) {
        // TODO Auto-generated catch block
      e.printStackTrace();
      } finally {
        //2. 关闭连接
        if(conn != null)
        conn.close();                            
      }
    }
  }

  public Connection getConnection2() throws Exception {
    //1. 准备连接数据库的4个字符串. 
    //⑴创建Properties对象
    Properties properties = new Properties();    
    //⑵获取jdbc.properties对应的输入流
    InputStream in = this.getClass().getClassLoader().getResourceAsStream("jdbc.properties");        
    //⑶加载⑵对应的输入流
    properties.load(in);        
    //⑷具体决定 user、password等4个字符串. 
    String user = properties.getProperty("user");
    String password = properties.getProperty("password");
    String jdbcUrl = properties.getProperty("jdbcUrl");
    String driver = properties.getProperty("driver");        
    //2. 加载数据库驱动程序(对应的Driver实现类中有注册驱动的静态代码块)
    Class.forName(driver);        
    //3. 通过DriverManager的getConnection() 方法获取数据库连接.
    return DriverManager.getConnection(jdbcUrl, user, password);
  }

  @Test
  public void testGetConnection2() throws Exception{
    System.out.println(getConnection2()); 
  }
}

 　　版本1：通用的更新的方法（包括 INSERT、UPDATE、DELETE）版本1

******************************
ORACLE
******************************
【Tue Oct 11 2016 09:37:50 GMT+0800】
使用Oracle的plsqldev.exe之前需要启动这两个服务：OracleServiceORCL和OracleOraDb10g_home1TNSListener，在Widows命令行
net start oracleserviceorcl 和 net start OracleOraDb10g_home1TNSListener（lsnrctl start）

C:\Users\admin>net start oracleserviceorcl
OracleServiceORCL 服务正在启动 ......
OracleServiceORCL 服务已经启动成功。

C:\Users\admin>net start OracleOraDb10g_home1TNSListener
OracleOraDb10g_home1TNSListener 服务正在启动 .
OracleOraDb10g_home1TNSListener 服务已经启动成功。

 

【Sat Jun 10 2017 10:23:12 GMT+0800】
net start OracleServiceORCL 和 net start OracleOraDb11g_home1TNSListener
(Oracle数据库-服务-ORCL库名 和 Oracle-Ora文件-Db11g_home1TNSListener监听)

 

【Thu Nov 17 2016 09:19:10 GMT+0800】
在win7下安装Apahce2.2和MySQL服务
如果直接“win+R”→“cmd”

C:\Users\John>d:
D:\>cd D:\AppServ\Apache2.2\bin
D:\AppServ\Apache2.2\bin>httpd -k install
Installing the Apache2.2 service
(OS 5)拒绝访问。  : Failed to open the WinNT service manager

出现第4、5行信息，主要是需要管理员权限才行。需要在打开cmd的时候用管理员身份打开，然后执行以上命令即可；也可以写一个bat文件以管理员身份也可以。
到“C:\Windows\SysWOW64”下打开“cmd”

C:\Windows\system32>d:
D:\>cd D:\AppServ\Apache2.2\bin
D:\AppServ\Apache2.2\bin>httpd -k install
Installing the Apache2.2 service
The Apache2.2 service is successfully installed.
Testing httpd.conf....
Errors reported here must be corrected before the service can be started.

D:\AppServ\Apache2.2\bin>net start Apache2.2
Apache2.2 服务正在启动 .
Apache2.2 服务已经启动成功。

D:\AppServ\Apache2.2\bin>cd D:\AppServ\MySQL\bin

D:\AppServ\MySQL\bin>mysqld-nt --install
Service successfully installed.

D:\AppServ\MySQL\bin>mysql
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

D:\AppServ\MySQL\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。

D:\AppServ\MySQL\bin>mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

 

【Sat Oct 22 2016 21:56:08 GMT+0800】

-- phpMyAdmin SQL Dump
-- version 3.5.3
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2016 年 10 月 22 日 21:19
-- 服务器版本: 5.5.20
-- PHP 版本: 5.3.5

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

--
-- 数据库: `ecshop`
--

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

--
-- 表的结构 `goods`
--

CREATE TABLE IF NOT EXISTS `ec_goods` (
  `goods_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `goods_sn` varchar(60) NOT NULL DEFAULT '',
  `goods_name` varchar(120) NOT NULL DEFAULT '',
  `goods_name_style` varchar(60) NOT NULL DEFAULT '+',
  `click_count` int(10) unsigned NOT NULL DEFAULT '0',
  `brand_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `provider_name` varchar(100) NOT NULL DEFAULT '',
  `goods_number` smallint(5) unsigned NOT NULL DEFAULT '0',
  `goods_weight` decimal(10,3) unsigned NOT NULL DEFAULT '0.000',
  `market_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `shop_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `promote_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `promote_start_date` int(11) unsigned NOT NULL DEFAULT '0',
  `promote_end_date` int(11) unsigned NOT NULL DEFAULT '0',
  `warn_number` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `keywords` varchar(255) NOT NULL DEFAULT '',
  `goods_brief` varchar(255) NOT NULL DEFAULT '',
  `goods_desc` text NOT NULL,
  `goods_thumb` varchar(255) NOT NULL DEFAULT '',
  `goods_img` varchar(255) NOT NULL DEFAULT '',
  `original_img` varchar(255) NOT NULL DEFAULT '',
  `is_real` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `extension_code` varchar(30) NOT NULL DEFAULT '',
  `is_on_sale` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `is_alone_sale` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `is_shipping` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `integral` int(10) unsigned NOT NULL DEFAULT '0',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0',
  `sort_order` smallint(4) unsigned NOT NULL DEFAULT '100',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_best` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_new` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_promote` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `bonus_type_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `last_update` int(10) unsigned NOT NULL DEFAULT '0',
  `goods_type` smallint(5) unsigned NOT NULL DEFAULT '0',
  `seller_note` varchar(255) NOT NULL DEFAULT '',
  `give_integral` int(11) NOT NULL DEFAULT '-1',
  `rank_integral` int(11) NOT NULL DEFAULT '-1',
  `suppliers_id` smallint(5) unsigned DEFAULT NULL,
  `is_check` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`goods_id`),
  KEY `goods_sn` (`goods_sn`),
  KEY `cat_id` (`cat_id`),
  KEY `last_update` (`last_update`),
  KEY `brand_id` (`brand_id`),
  KEY `goods_weight` (`goods_weight`),
  KEY `promote_end_date` (`promote_end_date`),
  KEY `promote_start_date` (`promote_start_date`),
  KEY `goods_number` (`goods_number`),
  KEY `sort_order` (`sort_order`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;

--
-- 转存表中的数据 `goods`
--

INSERT INTO `ec_goods` (`goods_id`, `cat_id`, `goods_sn`, `goods_name`, `goods_name_style`, `click_count`, `brand_id`, `provider_name`, `goods_number`, `goods_weight`, `market_price`, `shop_price`, `promote_price`, `promote_start_date`, `promote_end_date`, `warn_number`, `keywords`, `goods_brief`, `goods_desc`, `goods_thumb`, `goods_img`, `original_img`, `is_real`, `extension_code`, `is_on_sale`, `is_alone_sale`, `is_shipping`, `integral`, `add_time`, `sort_order`, `is_delete`, `is_best`, `is_new`, `is_hot`, `is_promote`, `bonus_type_id`, `last_update`, `goods_type`, `seller_note`, `give_integral`, `rank_integral`, `suppliers_id`, `is_check`) VALUES
(1, 4, 'ECS000000', 'KD876', '+', 7, 8, '', 1, '0.110', '1665.60', '1388.00', '0.00', 0, 0, 1, 'LG 3g 876 支持 双模 2008年04月 灰色 GSM,850,900,1800,1900', '', '<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 很多朋友都已经抢先体验了3G网络的可视通话、高速上网等功能。LG KD876手机<span style="font-size: x-large;"><span style="color: rgb(255, 0, 0);"><strong>支持TD-SCDMA/GSM双模单待</strong></span></span>，便于测试初期GSM网络和TD网络之间的切换和共享。</p>\r\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LG KD876手机整体采用银色塑料材质，<strong><span style="font-size: x-large;"><span style="color: rgb(255, 0, 0);">特殊的旋转屏设计是本机的亮点</span></span></strong>，而机身背部的300万像素摄像头也是首发的六款TD-SCDMA手机中配置最高的。LG KD876手机屏幕下方设置有外键盘，该键盘由左/右软键、通话/挂机键、返回键、五维摇杆组成，摇杆灵敏度很高，定位准确。KD876的内键盘由标准12个电话键和三个功能键、一个内置摄像头组成。三个功能键分别为视频通话、MP3、和菜单键，所有按键的手感都比较一般，键程适中，当由于按键排列过于紧密，快速发短信时很容易误按，用户在使用时一定要多加注意。LG KD876手机机身周边的接口设计非常简洁，手机的厚度主要来自屏幕旋转轴的长度，如果舍弃旋屏设计的话，估计<span style="font-size: x-large;"><strong><span style="color: rgb(255, 0, 0);">厚度可以做到10mm以下</span></strong></span>。</p>', 'images/200905/thumb_img/1_thumb_G_1240902890710.jpg', 'images/200905/goods_img/1_G_1240902890755.jpg', 'images/200905/source_img/1_G_1240902890895.gif', 1, '', 1, 1, 0, 13, 1240902890, 100, 0, 1, 1, 1, 0, 0, 1269589545, 9, '', -1, -1, NULL, NULL),
(4, 8, 'ECS000004', '诺基亚N85原装充电器', '+', 0, 1, '', 17, '0.000', '69.60', '58.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/4_thumb_G_1241422402467.jpg', 'images/200905/goods_img/4_G_1241422402722.jpg', 'images/200905/source_img/4_G_1241422402919.jpg', 1, '', 1, 0, 0, 0, 1241422402, 100, 0, 0, 0, 0, 0, 0, 1242110662, 6, '', -1, -1, NULL, NULL),
(3, 8, 'ECS000002', '诺基亚原装5800耳机', '+', 3, 1, '', 24, '0.000', '81.60', '68.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/3_thumb_G_1241422082679.jpg', 'images/200905/goods_img/3_G_1241422082168.jpg', 'images/200905/source_img/3_G_1241422082367.jpg', 1, '', 1, 1, 0, 0, 1241422082, 100, 0, 0, 0, 0, 0, 0, 1241972255, 6, '', -1, -1, NULL, NULL),
(5, 11, 'ECS000005', '索爱原装M2卡读卡器', '+', 3, 7, '', 8, '0.000', '24.00', '20.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/5_thumb_G_1241422518886.jpg', 'images/200905/goods_img/5_G_1241422518773.jpg', 'images/200905/source_img/5_G_1241422518470.jpg', 1, '', 1, 1, 0, 0, 1241422518, 100, 0, 1, 1, 0, 0, 0, 1241972241, 2, '', -1, -1, NULL, NULL),
(6, 11, 'ECS000006', '胜创KINGMAX内存卡', '+', 0, 0, '', 15, '0.000', '50.40', '42.00', '0.00', 0, 0, 1, '', '', '', '', '', '', 1, '', 1, 0, 0, 0, 1241422573, 100, 0, 0, 0, 0, 0, 0, 1241972238, 6, '', -1, -1, NULL, NULL),
(7, 8, 'ECS000007', '诺基亚N85原装立体声耳机HS-82', '+', 0, 1, '', 20, '0.000', '120.00', '100.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/7_thumb_G_1241422785492.jpg', 'images/200905/goods_img/7_G_1241422785856.jpg', 'images/200905/source_img/7_G_1241422785657.jpg', 1, '', 1, 1, 0, 1, 1241422785, 100, 0, 0, 0, 0, 0, 0, 1241972232, 2, '', -1, -1, NULL, NULL),
(8, 3, 'ECS000008', '飞利浦9@9v', '+', 9, 4, '', 1, '0.075', '478.79', '399.00', '385.00', 1241366400, 1417276800, 1, '双模 2008年春 黑色 直板 中低档', '', '<p align="left">作为一款性价比极高的入门级<font size="3" color="#ff0000"><strong>商务手机</strong></font>，飞利浦<a href="mailto:9@9v">Xenium&nbsp; 9@9v</a>三围大小为105&times;44&times;15.8mm，机身重量仅为<strong><font size="3" color="#ff0000">75g</font></strong>，装配了一块低规格1.75英寸128&times;160像素65000色CSTN显示屏。身正面采用月银色功能键区与屏幕数字键区相分隔，键盘设计较为<font size="3"><strong><font color="#ff0000">别</font><font color="#ff0000">致</font></strong></font>，中部导航键区采用钛金色的&ldquo;腰带&rdquo;彰显出浓郁的商务气息。</p>\r\n<p align="left">&nbsp;</p>\r\n<p align="left">此款手机采用<strong><font size="3" color="#ff0000">触摸屏</font></strong>设计，搭配精致的手写笔，可支持手写中文和英文两个版本。增强的内置系统还能识别潦草字迹，确保在移动中和匆忙时输入文字的识别率。手写指令功能还支持特定图案的瞬间调用，独特的手写记事本功能，可以在触摸屏上随意绘制个性化的图案并进行<strong><font size="3" color="#ff0000">记事提醒</font></strong>，让商务应用更加随意。</p>\r\n<p align="left">&nbsp;</p>\r\n<p align="left">&nbsp;作为入门级为数不多支持<strong><font size="3" color="#ff0000">双卡功能</font></strong>的手机，可以同时插入两张SIM卡，通过菜单随意切换，只需开启漫游自动切换模式，<a href="mailto:9@9V">9@9V</a>在该模式下能够判断网络情况，自动切换适合的手机号。</p>\r\n<p align="left">&nbsp;</p>\r\n<p align="left">&nbsp;</p>', 'images/200905/thumb_img/8_thumb_G_1241425513488.jpg', 'images/200905/goods_img/8_G_1241425513055.jpg', 'images/200905/source_img/8_G_1241425513518.jpg', 1, '', 1, 1, 0, 3, 1241425512, 100, 0, 1, 1, 1, 1, 0, 1269589533, 9, '', -1, -1, NULL, NULL),
(9, 3, 'ECS000009', '诺基亚E66', '+', 20, 1, '', 4, '0.121', '2757.60', '2298.00', '0.00', 0, 0, 1, 'SMS EMS MMS 短消息群发 语音 阅读器 SMS,EMS,MMS,短消息群发语音合成信息阅读器 黑色 白色 滑盖', '', '<p>在机身材质方面，诺基亚E66大量采用金属材质，刨光的金属表面光泽动人，背面的点状效果规则却又不失变化，时尚感总是在不经意间诠释出来，并被人们所感知。E66机身尺寸为<span style="color: rgb(255, 0, 0);"><span style="font-size: larger;"><strong>107.5&times;49.5&times;13.6毫米，重量为121克</strong></span></span>，滑盖的造型竟然比E71还要轻一些。</p>\r\n<p>&nbsp;</p>\r\n<div>诺基亚E66机身正面是<span style="color: rgb(255, 0, 0);"><span style="font-size: larger;"><strong>一块2.4英寸1600万色QVGA分辨率（240&times;320像素）液晶显示屏</strong></span></span>。屏幕上方拥有光线感应元件，能够自适应周 围环境光调节屏幕亮度；屏幕下方是方向功能键区。打开滑盖，可以看到传统的数字键盘，按键的大小、手感、间隔以及键程适中，手感非常舒适。</div>\r\n<div>&nbsp;</div>\r\n<div>诺基亚为E66配备了一颗320万像素自动对焦摄像头，带有LED 闪光灯，支持多种拍照尺寸选择。</div>\r\n<p>&nbsp;</p>', 'images/200905/thumb_img/9_thumb_G_1241511871555.jpg', 'images/200905/goods_img/9_G_1241511871574.jpg', 'images/200905/source_img/9_G_1241511871550.jpg', 1, '', 1, 1, 0, 22, 1241511871, 100, 0, 1, 1, 1, 0, 0, 1269589743, 9, '', -1, -1, NULL, NULL),
(10, 3, 'ECS000010', '索爱C702c', '+', 11, 7, '', 7, '0.000', '1593.60', '1328.00', '1250.00', 1243785600, 1277827200, 1, '2008年05月 GSM,850,900,1800,1900 直板', '', '<p>C702可以说是一种在外观上复古的产物，不仅延续T系列早期的直板造型，而且在屏幕和键盘的组合分布上都继承了前辈的精髓。C702的机身尺寸为106&times;48&times;15.5毫米，重量为105克。此外索尼爱立信为C702融入了<font size="3" color="#ff0000"><strong>三防特性，即防尘、防滑和防水溅</strong></font>，这款新的C702搭载了索尼爱立信经典A200平台，界面布局与W908c、K858c一致，典型的特征就是配备左右软键、中央确定键和通话/挂机键。</p>\r\n<p>索尼爱立信C702配备一块<strong><font size="3" color="#ff0000">2.2英寸26万色TFT液晶显示屏</font></strong>，分辨率为240&times;320像素(QVGA)，显示效果属于目前主流水准。C702可以说是索尼爱立信首批<strong><font size="3" color="#ff0000">内置GPS模块</font></strong>的 手机产品之一，C702的搜星、定位一气呵成，十分精准，误差大约在10米之内。基本上定位后可以将有效卫星数量控制在4&mdash;6颗，可以说可以满足我们的需 要了。C702还提供了&ldquo;影像定位&rdquo;功能，配合内置的AGPS全球定位辅助系统，只须启动Geo-Tagging智能影像定位功能，便可将拍摄地点记录在 照片内，方便用户随时查询。</p>\r\n<p>&nbsp;</p>\r\n<p>作为一款Cyber-shot系列影像手机，索尼爱立信C702在拍照功能方面同样有不俗的表现。并且手机内置的<strong><font size="3" color="#ff0000">320万像素摄像头</font></strong>也 同样在拍照功能上也不错的表现。不仅支持自动聚焦和双LED闪光功能，而且还拥有2倍数码变焦、防红眼、Photo fix优画及场景模式等功能。索尼爱立信C702除了配备的是最大光圈为F3.2的4.2毫米镜头之外，该机也如同门中的旗舰C902一样增加了对脸部有 先自动聚焦功能的支持。</p>\r\n<p>&nbsp;</p>', 'images/200905/thumb_img/10_thumb_G_1242973436403.jpg', 'images/200905/goods_img/10_G_1242973436141.jpg', 'images/200905/source_img/10_G_1242973436172.jpg', 1, '', 1, 1, 0, 13, 1241965622, 100, 0, 0, 0, 1, 1, 0, 1245290333, 9, '', -1, -1, NULL, NULL),
(11, 3, 'ECS000011', '索爱C702c', '+', 0, 7, '', 1, '0.000', '0.00', '1300.00', '0.00', 0, 0, 1, '直板', '', '', '', '', '', 1, '', 0, 1, 0, 0, 1241966951, 100, 1, 0, 0, 0, 0, 0, 1241966960, 7, '', -1, -1, NULL, NULL),
(12, 3, 'ECS000012', '摩托罗拉A810', '+', 13, 2, '', 8, '0.000', '1179.60', '983.00', '960.00', 1241107200, 1255104000, 1, 'SMS EMS MMS pda 摄像 智能 音乐 SMS,EMS,MMS', '', '<p>全机使用的材质除去电池盖部分采用了金属以外，其它均使用了ABS工程塑料作为主材，这款手机的三围是105&times;51&times;14毫米，有着100克的轻量级重量，拿在手中的感觉还是非常不错的。A810手机作为一款<strong><font size="3" color="#ff0000">PDA手机</font></strong>在设计的时候取消了键盘配置，一切数字键都要依靠手机内提供的虚拟键盘进行操作，在手机的左上侧是一个<strong><font size="3" color="#ff0000">3.5mm的标准耳机插口</font></strong>，这种设计可以让用户使用自己习惯或者喜欢的耳机去欣赏音乐。</p>\r\n<p>&nbsp;</p>\r\n<p>这款摩托罗拉A810手机配置了一块<font size="3" color="#ff0000"><strong>26万色的2.2英寸TFT全触摸屏幕</strong></font>，其分辨率达到了主流的QVGA水平（240&times;320像素），摩托罗拉A810采用了内部核心为2.6.10的<strong><font size="3" color="#ff0000">LINUX操作系统</font></strong>，菜单上依然采用传统的9宫格的显示方式，一般手机的名片式电话本只能支持诸如电话、邮件、传真、公司等一些基本信息，而A810手机的电话本除了这些还支持公司地址，配偶信息、子女姓名、上司名称、助手等等，对于一款手机来说，电话本不可谓不强大。A810的<strong><font size="3" color="#ff0000">手写识别能力相当的惊人</font></strong>，对连笔、草书和倒插笔的识别率都相当的高，同时还为左右手设置了不同的书写习惯选择，并支持手写速度的调节。</p>\r\n<p>这款A810手机<strong><font size="3" color="#ff0000">内置的音乐播放功能</font></strong>可以支持MP3、WAV、AMR、AAC等格式的音乐播放，<font size="3" color="#ff0000"><strong>支持后台播放</strong></font>。视频方面，这款A810支持MP4、3GP、H.263格式的播放，视频播放器同样简约，操作方便，这款摩托罗拉A810还内置了6款游戏，每一款都有很高的耐玩性，而且都是支持触摸屏操作的，同时这款手机还内置了<strong><font size="3" color="#ff0000">FM收音机</font></strong>，支持自动搜索，并提供了20个频道供用户存储，不过收音机并不支持后台播放。</p>\r\n<p>&nbsp;</p>', 'images/200905/thumb_img/12_thumb_G_1241965978410.jpg', 'images/200905/goods_img/12_G_1241965978209.jpg', 'images/200905/source_img/12_G_1241965978878.jpg', 1, '', 1, 1, 0, 9, 1245297652, 100, 0, 0, 1, 0, 1, 0, 1245297670, 3, '', -1, -1, NULL, NULL),
(13, 3, 'ECS000013', '诺基亚5320 XpressMusic', '+', 13, 1, '', 8, '0.000', '1573.20', '1311.00', '0.00', 0, 0, 1, '摄像 智能 音乐 蓝色 红色 舒适 直板 中档 2008年07月 黑色 GSM,850,900,1800,1900', '', '<p>诺基亚5320XpressMusic音乐手机采用XpressMusic系列常见的黑红、黑蓝配色方案，而材质方便则选用的是经过<strong><font size="3" color="#ff0000">抛光处理</font></strong>的工程塑料；三围/体重为，为108&times;46&times;15mm/<strong><font size="3" color="#ff0000">90g</font></strong>，手感舒适。</p>\r\n<p>&nbsp;</p>\r\n<p>诺基亚5320采用的是一块可视面积为2.0英寸的<font size="3" color="#ff0000"><strong>1600万色</strong></font>屏幕，分辨率是常见的240&times;320像素（QVGA）。虽然屏幕不是特别大，但效果非常精细，色彩还原不错。</p>\r\n<p>&nbsp;</p>\r\n<p>手机背面，诺基亚为5320XM配备一颗<strong><font size="3" color="#ff0000">200W像素</font></strong>的摄像头，并且带有<strong><font size="3" color="#ff0000">两个LED的补光灯</font></strong>，可以实现拍照、摄像功能，并能通过彩信、邮件方式发送给朋友。</p>\r\n<p>&nbsp;</p>', 'images/200905/thumb_img/13_thumb_G_1241968002527.jpg', 'images/200905/goods_img/13_G_1241968002233.jpg', 'images/200905/source_img/13_G_1241968002732.jpg', 1, '', 1, 1, 0, 13, 1241967762, 100, 0, 0, 0, 1, 0, 0, 1269589198, 9, '', -1, -1, NULL, NULL),
(14, 4, 'ECS000014', '诺基亚5800XM', '+', 6, 1, '', 1, '0.000', '3150.00', '2625.00', '0.00', 0, 0, 1, 'GSM 64和弦 2009年2月 320万摄像头 GPS 直板 工程塑料 支持 2008年10月 黑色', '', '', 'images/200905/thumb_img/14_thumb_G_1241968492116.jpg', 'images/200905/goods_img/14_G_1241968492932.jpg', 'images/200905/source_img/14_G_1241968492305.jpg', 1, '', 1, 1, 0, 26, 1241968492, 100, 0, 0, 0, 1, 0, 0, 1269589186, 9, '', -1, -1, NULL, NULL),
(15, 3, 'ECS000015', '摩托罗拉A810', '+', 8, 2, '', 3, '0.000', '945.60', '788.00', '0.00', 0, 0, 1, '600 直板 工程塑料 蓝牙 视频拍摄 音乐 黑色 白色', '', '', 'images/200905/thumb_img/15_thumb_G_1242973362970.jpg', 'images/200905/goods_img/15_G_1242973362318.jpg', 'images/200905/source_img/15_G_1242973362751.jpg', 1, '', 1, 1, 0, 5, 1241968703, 100, 1, 0, 1, 1, 0, 0, 1245297631, 9, '', -1, -1, NULL, NULL),
(16, 2, 'ECS000016', '恒基伟业G101', '+', 3, 11, '', 0, '0.000', '988.00', '823.33', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/16_thumb_G_1241968949103.jpg', 'images/200905/goods_img/16_G_1241968949002.jpg', 'images/200905/source_img/16_G_1241968949402.jpg', 1, '', 0, 1, 0, 8, 1241968949, 100, 0, 0, 0, 0, 0, 0, 1245290562, 2, '', -1, -1, NULL, NULL),
(17, 3, 'ECS000017', '夏新N7', '+', 2, 5, '', 1, '0.000', '2760.00', '2300.00', '0.00', 0, 0, 1, '2008年01月 GSM,900,1800,1900,2100 直板 262144万 240×400 像素 SMS,EMS,MMS,超长信息发送,短消息群发 黑色 CDMA', '', '', 'images/200905/thumb_img/17_thumb_G_1241969394587.jpg', 'images/200905/goods_img/17_G_1241969394677.jpg', 'images/200905/source_img/17_G_1241969394844.jpg', 1, '', 1, 1, 0, 23, 1241969394, 100, 0, 1, 0, 1, 0, 0, 1269589169, 9, '', -1, -1, NULL, NULL),
(18, 4, 'ECS000018', '夏新T5', '+', 0, 5, '', 1, '0.000', '3453.60', '2878.00', '0.00', 0, 0, 1, '2008年04月 3G(GSM,900,1800,1900,TD-SCDMA ) 直板 262144万 320×240 像素 是 银色', '', '<p>&nbsp;  TD-SCDMA/GSM两种模式任意切换，中国3G手机先驱，支持大陆特有3G网络，轻松实现可视电话、视频留言、视频会议功能，2.6英寸Q屏，手写、键盘双输入，内置移动证券，支持手机邮箱、手机地图、无驱U盘</p>', '', '', '', 1, '', 1, 1, 0, 28, 1241969533, 100, 1, 0, 0, 0, 0, 0, 1241969533, 2, '', -1, -1, NULL, NULL),
(19, 3, 'ECS000019', '三星SGH-F258', '+', 7, 6, '', 12, '0.000', '1029.60', '858.00', '0.00', 0, 0, 1, '滑盖 GSM 258 时尚 蓝牙 黑色 金色 白色', '从整体来看，三星SGH-F258比较时尚可爱，三围尺寸为94×46×17.5mm，重量为96克，曲线柔和具有玲珑美感\r\n', '<p>从整体来看，三星SGH-F258比较<font size="3" color="#ff0000"><strong>时尚</strong></font>可爱，三围尺寸为94&times;46&times;17.5mm，重量为96克，曲线柔和具有玲珑美感。</p>\r\n<p>&nbsp;</p>\r\n<p>三星F258的前面板整体应用<strong><font size="3" color="#ff0000">镜面效果</font></strong>，2.0英寸显示屏幕略显窄小，导航键与功能键在滑盖滑开之前是前面板的全部控制键，没有挂断和接听键，不过，五向键有<font size="3"><strong><font color="#ff0000">音乐操</font><font color="#ff0000">作</font></strong></font>功能，明确显示了F258音乐手机的定位。</p>\r\n<p>&nbsp;</p>\r\n<p>F258的数字键键区采用了极具金属质感的平板式设计，每颗按键的面积足够大，按键与按键之间的间隔明显，操作起来手感舒适。</p>', 'images/200905/thumb_img/19_thumb_G_1241970175208.jpg', 'images/200905/goods_img/19_G_1241970175091.jpg', 'images/200905/source_img/19_G_1241970175549.jpg', 1, '', 1, 1, 0, 8, 1241970139, 100, 0, 1, 1, 1, 0, 0, 1269589154, 9, '', -1, -1, NULL, NULL),
(20, 3, 'ECS000020', '三星BC01', '+', 14, 6, '', 12, '0.000', '336.00', '280.00', '238.00', 1241884800, 1251648000, 1, 'GSM 直板 40和弦 金属材质 2008年07月 黑色 GSM,900,1800,1900,2100', '', '', 'images/200905/thumb_img/20_thumb_G_1242106490058.jpg', 'images/200905/goods_img/20_G_1242106490663.jpg', 'images/200905/source_img/20_G_1242106490922.jpg', 1, '', 1, 1, 0, 2, 1241970417, 100, 0, 1, 1, 1, 1, 0, 1269589110, 9, '', -1, -1, NULL, NULL),
(21, 3, 'ECS000021', '金立 A30', '+', 4, 10, '', 40, '0.000', '2400.00', '2000.00', '0.00', 0, 0, 1, '2008年03月 GSM,900,1800,1900,2100 直板 1600万 240×400 像素 2007年12月 200万摄像头 黑色', '', '<p>&nbsp;</p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">标准配置: 标准锂电池两块,充电器两个,立体声耳机一个,数据线,说明书送256TF</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">通讯功能&nbsp; 输入法 短信功能 话机通讯录 通话记录</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">输入法: 中文输入法</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">短信功能: 支持短信300条和彩信100条</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">话机通讯录: 1000组名片式电话存储 来电防火墙功能&nbsp; 来电大头贴及来电铃声识别</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">通话记录：支持电话录音,恢复/静音,双音多频,免提</font></span></p>\r\n<p>&nbsp;</p>\r\n<p><font size="3">高级功能</font></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">多媒体娱乐: 200万像素，最大支持10240*960，11级数码变焦,多种效果设置,连拍可全屏查看拍摄或下载的图片.支持有声MP4短片拍摄，录像时间根据内存 大小而定，拍摄录像,TV电视可跟朋友家人一起分享。支持网络摄像头功能 支持MPEG4、3GP(H.263)等视频格式 支持MP3等音频格式播放， 支持歌词播放</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">内置游戏:智能拼图</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">扩展存储功能:支持TF扩展,支持U盘功能,本机内置1M,随机赠送256TF卡</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">高级功能:直板/智能PDA手写/键盘输入 超长待机 WAP上网&nbsp; 录音 蓝牙 FM收音机 电子书 Java扩展 TV电视输出 声控语音拨号 免费电视 来电防火墙&nbsp;&nbsp;&nbsp;</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">附加功能: 日历 计算器 闹钟 记事本 日程表 秒表 单位换算</font></span></p>\r\n<p><span style="font-size: medium;"><font size="3">提醒 以上性能均为本公司员工试机后所写,产品资料仅供参考,请以收到实物为准</font></span></p>', 'images/200905/thumb_img/21_thumb_G_1242109298150.jpg', 'images/200905/goods_img/21_G_1242109298873.jpg', 'images/200905/source_img/21_G_1242109298831.jpg', 1, '', 1, 1, 0, 20, 1241970634, 100, 0, 0, 0, 0, 0, 0, 1269589102, 9, '', -1, -1, NULL, NULL),
(22, 3, 'ECS000022', '多普达Touch HD', '+', 15, 3, '', 1, '0.000', '7198.80', '5999.00', '0.00', 0, 0, 1, '500万摄像头 蓝牙 手写 GPS 办公应用 语音拨号 2008年12月 黑色 GSM,850,900,1800,1900 直板', '', '<p><img src="http://xgone.xgou.com/xgoumanage/upload/20090325/2009032502045081100887.jpg" alt="" /></p>\r\n<p>&nbsp;</p>\r\n<p><img src="http://www.ouku.com/upimg/ouku/Image/002(1).jpg" alt="" /></p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>', 'images/200905/thumb_img/22_thumb_G_1241971076803.jpg', 'images/200905/goods_img/22_G_1241971076358.jpg', 'images/200905/source_img/22_G_1241971076130.jpg', 1, '', 1, 1, 0, 59, 1241971076, 100, 0, 1, 1, 0, 0, 0, 1269589090, 9, '', -1, -1, NULL, NULL),
(23, 5, 'ECS000023', '诺基亚N96', '+', 17, 1, '', 8, '0.000', '4440.00', '3700.00', '0.00', 0, 0, 1, '500万摄像头 microSD 工程塑料 蓝牙 数码相机 内置游戏 滑盖 高档 2008年09月 320×240 像素 黑色', '', '<p>诺基亚N96采用了<strong><font size="3" color="#ff0000">双向滑盖</font></strong>设计，机身整体呈灰黑色，沉稳、大气，机身材质采用了高强度的塑料材质，手机背面采用了抛光面板的设计风格。N96三维体积103*55*20mm，重量为125g。屏幕方面，诺基亚N96配备一块<strong><font size="3" color="#ff0000">2.8英寸</font></strong>的屏幕，支持<strong><font size="3" color="#ff0000">1670万色</font></strong>显示，分辨率达到QVGA（320&times;240）水准。</p>\r\n<p><img alt="" src="file:///C:/DOCUME~1/user/LOCALS~1/Temp/moz-screenshot.jpg" /></p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;<img src="http://img2.zol.com.cn/product/21/896/ceN6LBMCid3X6.jpg" alt="" /></p>\r\n<p>诺基亚N96设置有专门的<strong><font size="3" color="#ff0000">音乐播放键</font></strong>和标准的3.5毫米音频插口，支持多格式音乐播放。内置了<strong><font size="3" color="#ff0000">多媒体播放器</font></strong>，支持FM调频收音机等娱乐功能。N96手机支持<strong><font size="3" color="#ff0000">N-Gage游戏平台</font></strong>，内置包括<font size="3" color="#ff0000"><strong>《PinBall》完整版</strong></font>在内的四款N-Gage游戏，除了手机本身内置的游戏，还可以从N-Gage的网站下载或者购买最新的游戏，而且可以在论坛里和其他玩家一起讨论。</p>\r\n<p><img src="http://img2.zol.com.cn/product/21/898/cekkw57qJjSI.jpg" alt="" /></p>\r\n<p>&nbsp;</p>', 'images/200905/thumb_img/23_thumb_G_1241971556399.jpg', 'images/200905/goods_img/23_G_1241971556855.jpg', 'images/200905/source_img/23_G_1241971556256.jpg', 1, '', 1, 1, 0, 37, 1241971488, 100, 0, 1, 1, 0, 0, 0, 1269589078, 9, '', -1, -1, NULL, NULL),
(24, 3, 'ECS000024', 'P806', '+', 35, 9, '', 100, '0.000', '2400.00', '2000.00', '1850.00', 1243785600, 1277827200, 1, '旅行充电器 图形菜单 Wap 上网 红外接口 移动 MSN 支持 2008年06月 灰色', '', '<div>\r\n<div>\r\n<div><font size="4">规格参数</font></div>\r\n<p><font size="4"><span>上市时间：</span><span>2008年06月</span></font></p>\r\n<p><font size="4"><span>网络频率：</span><span>GSM/GPRS；900/1800MHz</span></font></p>\r\n<p><font size="4"><span>重　量　：</span><span>未知</span></font></p>\r\n<p><font size="4"><span>尺寸/体积：</span><span>未知</span></font></p>\r\n<p><font size="4"><span>可选颜色：</span><span>银色</span></font></p>\r\n<p><font size="4"><span>屏幕参数：</span><span>26万色TFT彩色屏幕；</span></font></p>\r\n<p><font size="4"><span>WAP上网：</span><span>支持飞笺</span></font></p>\r\n<p><font size="4"><span>基本配置:<em><strong><font size="5" color="#ff00ff">二电(1760毫安) 一充 数据线 耳机 手写笔 512M内存卡</font></strong></em></span></font></p>\r\n<p>&nbsp;</p>\r\n</div>\r\n</div>\r\n<div><font size="4">基本功能</font></div>\r\n<p><font size="4"><span>『时钟』</span><span>『内置振动』</span><span>『录音』</span><span>『可选铃声』</span></font></p>\r\n<p><font size="4"><span>『和弦铃声』</span><span>『MP3铃声』</span><span>『来电铃声识别』</span><span>『来电图片识别』</span></font></p>\r\n<p><font size="4"><span>『情景模式』</span><span>『待机图片』</span><span>『图形菜单』</span><span>『触摸屏』</span></font></p>\r\n<p><span><font size="4">『手写输入』</font></span></p>\r\n<div><font size="4">通信功能</font></div>\r\n<p><font size="4"><span>『双卡双待』</span><span>『内置天线』</span><span>『输入法』</span><span>『中文短信』</span></font></p>\r\n<p><font size="4"><span>『短信群发』</span><span>『多媒体短信』</span><span>『话机通讯录』</span><span>『通话记录』</span></font></p>\r\n<p><font size="4"><span>『免提通话』</span><span>『飞行模式』</span></font></p>\r\n<div><font size="4">多媒体娱乐 :支持3GP、MP4文件播放</font></div>\r\n<p><font size="4"><span>『视频播放』</span><span>『MP3播放器』</span></font></p>\r\n<p><font size="4"><span>多媒体卡扩展：</span><span>支持microSD卡扩展&nbsp;</span></font></p>\r\n<p><font size="4"><span>摄像头：</span><span>内置</span></font></p>\r\n<p><font size="4"><span>摄像头像素：</span><span>30万像素</span></font></p>\r\n<p><font size="4"><span>传感器类型：</span><span>CMOS</span></font></p>\r\n<p><font size="4"><span>变焦模式：</span><span>数码变焦</span></font></p>\r\n<p><font size="4"><span>照片分辨率：</span><span>多种照片分辨率选择</span></font></p>\r\n<p><font size="4"><span>拍摄模式：</span><span>多种拍摄模式选择</span></font></p>\r\n<p><font size="4"><span>照片质量：</span><span>多种照片质量选择</span></font></p>\r\n<p><font size="4"><span>视频拍摄：</span><span>有声视频拍摄</span></font></p>\r\n<div><font size="4">数据传输</font></div>\r\n<p><font size="4"><span>『WAP浏览器』</span><span>『数据线接口』</span></font></p>\r\n<div><font size="4">个人助理</font></div>\r\n<p><font size="4"><span>『闹钟』</span><span>『日历』</span><span>『计算器』</span></font></p>', 'images/200905/thumb_img/24_thumb_G_1241971981429.jpg', 'images/200905/goods_img/24_G_1241971981284.jpg', 'images/200905/source_img/24_G_1241971981107.jpg', 1, '', 1, 1, 0, 20, 1241971981, 100, 0, 1, 1, 1, 1, 0, 1269589064, 9, '', -1, -1, NULL, NULL),
(25, 13, 'ECS000025', '小灵通/固话50元充值卡', '+', 0, 0, '', 2, '0.000', '57.59', '48.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/25_thumb_G_1241972709885.jpg', 'images/200905/goods_img/25_G_1241972709544.jpg', 'images/200905/source_img/25_G_1241972709750.jpg', 0, 'virtual_card', 1, 1, 0, 0, 1241972709, 100, 0, 1, 0, 1, 0, 0, 1245047546, 0, '', -1, -1, NULL, NULL),
(26, 13, 'ECS000026', '小灵通/固话20元充值卡', '+', 0, 0, '', 2, '0.000', '22.80', '19.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/26_thumb_G_1241972789393.jpg', 'images/200905/goods_img/26_G_1241972789293.jpg', 'images/200905/source_img/26_G_1241972789353.jpg', 0, 'virtual_card', 1, 1, 0, 0, 1241972789, 100, 0, 0, 0, 1, 0, 0, 1245047540, 0, '', -1, -1, NULL, NULL),
(27, 15, 'ECS000027', '联通100元充值卡', '+', 0, 0, '', 2, '0.000', '100.00', '95.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/27_thumb_G_1241972894068.jpg', 'images/200905/goods_img/27_G_1241972894061.jpg', 'images/200905/source_img/27_G_1241972894069.jpg', 0, 'virtual_card', 1, 1, 0, 0, 1241972894, 100, 0, 1, 1, 1, 0, 0, 1245047557, 0, '', -1, -1, NULL, NULL),
(28, 15, 'ECS000028', '联通50元充值卡', '+', 0, 0, '', 0, '0.000', '50.00', '45.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/28_thumb_G_1241972976986.jpg', 'images/200905/goods_img/28_G_1241972976313.jpg', 'images/200905/source_img/28_G_1241972976695.jpg', 0, 'virtual_card', 1, 1, 0, 0, 1241972976, 100, 0, 0, 0, 1, 0, 0, 1245047542, 0, '', -1, -1, NULL, NULL),
(29, 14, 'ECS000029', '移动100元充值卡', '+', 0, 0, '', 0, '0.000', '0.00', '90.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/29_thumb_G_1241973022239.jpg', 'images/200905/goods_img/29_G_1241973022206.jpg', 'images/200905/source_img/29_G_1241973022514.jpg', 0, 'virtual_card', 1, 1, 0, 0, 1241973022, 100, 0, 1, 0, 1, 0, 0, 1245047543, 0, '', -1, -1, NULL, NULL),
(30, 14, 'ECS000030', '移动20元充值卡', '+', 1, 0, '', 9, '0.000', '21.00', '18.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/30_thumb_G_1241973114800.jpg', 'images/200905/goods_img/30_G_1241973114234.jpg', 'images/200905/source_img/30_G_1241973114587.jpg', 0, 'virtual_card', 1, 1, 0, 0, 1241973114, 100, 0, 1, 0, 1, 0, 0, 1245047549, 0, '', -1, -1, NULL, NULL),
(31, 3, 'ECS000031', '摩托罗拉E8 ', '+', 5, 2, '', 1, '0.000', '1604.39', '1337.00', '0.00', 0, 0, 1, '直板', '', '', 'images/200905/thumb_img/31_thumb_G_1242110412996.jpg', 'images/200905/goods_img/31_G_1242110412332.jpg', 'images/200905/source_img/31_G_1242110412519.jpg', 1, '', 0, 1, 0, 13, 1242110412, 100, 0, 0, 0, 0, 0, 0, 1242140652, 7, '', -1, -1, NULL, NULL);
INSERT INTO `ec_goods` (`goods_id`, `cat_id`, `goods_sn`, `goods_name`, `goods_name_style`, `click_count`, `brand_id`, `provider_name`, `goods_number`, `goods_weight`, `market_price`, `shop_price`, `promote_price`, `promote_start_date`, `promote_end_date`, `warn_number`, `keywords`, `goods_brief`, `goods_desc`, `goods_thumb`, `goods_img`, `original_img`, `is_real`, `extension_code`, `is_on_sale`, `is_alone_sale`, `is_shipping`, `integral`, `add_time`, `sort_order`, `is_delete`, `is_best`, `is_new`, `is_hot`, `is_promote`, `bonus_type_id`, `last_update`, `goods_type`, `seller_note`, `give_integral`, `rank_integral`, `suppliers_id`, `is_check`) VALUES
(32, 3, 'ECS000032', '诺基亚N85', '+', 9, 1, '', 4, '0.000', '3612.00', '3010.00', '2750.00', 1243785600, 1417276800, 1, '2008年10月 GSM,850,900,1800,1900 黑色', '', '<p>诺基亚N85参数</p>\r\n<div>&nbsp;</div>\r\n<div>\r\n<table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n    <tbody>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>基本参数</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">手机昵称</td>\r\n            <td width="450" bgcolor="#ffffff">N85</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">上市日期</td>\r\n            <td width="450" bgcolor="#ffffff">2008年10月</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">手机类型</td>\r\n            <td width="450" bgcolor="#ffffff">3G手机；拍照手机；智能手机</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">手机制式</td>\r\n            <td width="450" bgcolor="#ffffff">GSM</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">支持频段</td>\r\n            <td width="450" bgcolor="#ffffff">GSM850/900/1800/1900MHz</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">数据传输</td>\r\n            <td width="450" bgcolor="#ffffff">GPRS、EDGE</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">屏幕材质</td>\r\n            <td width="450" bgcolor="#ffffff">AMOLED</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">屏幕色彩</td>\r\n            <td width="450" bgcolor="#ffffff">1600万色</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">主屏尺寸</td>\r\n            <td width="450" bgcolor="#ffffff">2.6英寸</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">主屏参数</td>\r\n            <td width="450" bgcolor="#ffffff">QVGA 320&times;240像素</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">铃音描述</td>\r\n            <td width="450" bgcolor="#ffffff">可选MP3、WAV、AAC或和弦Midi铃声等格式</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">操作系统</td>\r\n            <td width="450" bgcolor="#ffffff">Symbian OS v9.3操作系统与S60 v3.2平台的组合</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">机身内存</td>\r\n            <td width="450" bgcolor="#ffffff">74MB 内部动态存储空间<br />\r\n            78MB 内置NAND闪存</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">存储卡</td>\r\n            <td width="450" bgcolor="#ffffff">支持MicroSD(T-Flash)卡扩展最大至8GB</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">电池规格</td>\r\n            <td width="450" bgcolor="#ffffff">1200毫安时锂电池</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">标配</td>\r\n            <td width="450" bgcolor="#ffffff">诺基亚 N85<br />\r\n            诺基亚电池（BL-5K）<br />\r\n            诺基亚旅行充电器（AC-10）<br />\r\n            诺基亚视频数据线（CA-75U）<br />\r\n            诺基亚数据线（CA-101）<br />\r\n            诺基亚音乐耳机（HS-45、AD-54）<br />\r\n            诺基亚 8 GB microSD 卡（MU-43）<br />\r\n            《用户手册》<br />\r\n            《快速入门》</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">理论通话时间</td>\r\n            <td width="450" bgcolor="#ffffff">6.9 小时</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">理论待机时间</td>\r\n            <td width="450" bgcolor="#ffffff">363 小时</td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>产品外形</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">外观设计</td>\r\n            <td width="450" bgcolor="#ffffff">双向滑盖</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">产品尺寸</td>\r\n            <td width="450" bgcolor="#ffffff">103&times;50&times;16mm<br />\r\n            体积：76 立方厘米</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">手机重量</td>\r\n            <td width="450" bgcolor="#ffffff">128克</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">产品天线</td>\r\n            <td width="450" bgcolor="#ffffff">内置</td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>拍照功能</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n            <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n                <tbody>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">定时器</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">摄像头</td>\r\n            <td width="450" bgcolor="#ffffff">内置</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">摄像头像素</td>\r\n            <td width="450" bgcolor="#ffffff">500万像素</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">连拍功能</td>\r\n            <td width="450" bgcolor="#ffffff">支持</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">LED闪光灯</td>\r\n            <td width="450" bgcolor="#ffffff">双LED 闪光灯</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">数码变焦</td>\r\n            <td width="450" bgcolor="#ffffff">20 倍数码变焦</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">拍摄模式</td>\r\n            <td width="450" bgcolor="#ffffff">静止、连拍、自动定时器、摄像</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">照片特效</td>\r\n            <td width="450" bgcolor="#ffffff">正常、怀旧、黑白、负片、逼真</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">拍照描述</td>\r\n            <td width="450" bgcolor="#ffffff">支持最大2592&times;1944分辨率照片拍摄<br />\r\n            支持JPEG、Exif格式<br />\r\n            白平衡模式：自动、阳光、阴天、白炽灯、荧光灯<br />\r\n            感光度模式：高、中、低、自动</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">视频拍摄</td>\r\n            <td width="450" bgcolor="#ffffff">最高支持640 x 480 像素（VGA）、30 帧/秒</td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>娱乐功能</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n            <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n                <tbody>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">收音机</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">TV-OUT</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">录音功能</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">电子书</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">视频播放</td>\r\n            <td width="450" bgcolor="#ffffff">内置RealPlayer播放器, 支持MPEG4、H.264/AVC、H.263/3GP、RealVideo等视频格式全屏播放</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">音乐播放</td>\r\n            <td width="450" bgcolor="#ffffff">内置播放器, 支持mp3、.wma、.aac、eAAC、eAAC+格式</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">游戏</td>\r\n            <td width="450" bgcolor="#ffffff">内置</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">Java功能</td>\r\n            <td width="450" bgcolor="#ffffff">支持Java MIDP 2.0 CLDC 1.1</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">Flash功能</td>\r\n            <td width="450" bgcolor="#ffffff">第3.0版Flash lite播放器</td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>数据功能</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n            <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n                <tbody>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">蓝牙功能</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">数据线接口</td>\r\n            <td width="450" bgcolor="#ffffff">USB数据线 3.5mm立体声耳机插孔</td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>基本功能</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n            <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n                <tbody>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">短信(SMS)</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">彩信(MMS)</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">免提通话</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">情景模式</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">闹钟功能</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">日历功能</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">输入方式</td>\r\n            <td width="450" bgcolor="#ffffff">键盘</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">通话记录</td>\r\n            <td width="450" bgcolor="#ffffff">未接来电+已接来电+已拨电话记录</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">通讯录</td>\r\n            <td width="450" bgcolor="#ffffff">S60标准化名片式通讯录</td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>网络功能</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n            <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n                <tbody>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">电子邮件</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">WWW浏览器</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">WAP浏览器</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>商务功能</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n            <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n                <tbody>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">飞行模式</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">语音拨号</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">备忘录</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">日程表</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">世界时间</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>其他功能</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n            <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n                <tbody>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">GPS功能</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">电子词典</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">待机图片</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">计算器</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">来电铃声识别</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">来电图片识别</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">来电防火墙</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">动画屏保</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">图形菜单</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">秒表</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">单位换算</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" align="middle" style="padding: 2px; float: none;">&nbsp;</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n    </tbody>\r\n</table>\r\n</div>\r\n<p>&nbsp;</p>', 'images/200905/thumb_img/32_thumb_G_1242110760196.jpg', 'images/200905/goods_img/32_G_1242110760868.jpg', 'images/200905/source_img/32_G_1242110760437.jpg', 1, '', 1, 1, 0, 30, 1242110760, 100, 0, 0, 1, 1, 1, 0, 1269589051, 9, '', -1, -1, NULL, NULL);

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

 MySQL必知必会

########################################
# MySQL Crash Course
# http://www.forta.com/books/0672327120/
# Example table creation scripts
########################################


########################
# Create crash_customers table
########################
CREATE TABLE crash_customers
(
  cust_id      int       NOT NULL AUTO_INCREMENT,
  cust_name    char(50)  NOT NULL ,
  cust_address char(50)  NULL ,
  cust_city    char(50)  NULL ,
  cust_state   char(5)   NULL ,
  cust_zip     char(10)  NULL ,
  cust_country char(50)  NULL ,
  cust_contact char(50)  NULL ,
  cust_email   char(255) NULL ,
  PRIMARY KEY (cust_id)
) ENGINE=InnoDB;

#########################
# Create crash_orderitems table
#########################
CREATE TABLE crash_orderitems
(
  order_num  int          NOT NULL ,
  order_item int          NOT NULL ,
  prod_id    char(10)     NOT NULL ,
  quantity   int          NOT NULL ,
  item_price decimal(8,2) NOT NULL ,
  PRIMARY KEY (order_num, order_item)
) ENGINE=InnoDB;


#####################
# Create crash_orders table
#####################
CREATE TABLE crash_orders
(
  order_num  int      NOT NULL AUTO_INCREMENT,
  order_date datetime NOT NULL ,
  cust_id    int      NOT NULL ,
  PRIMARY KEY (order_num)
) ENGINE=InnoDB;

#######################
# Create crash_products table
#######################
CREATE TABLE crash_products
(
  prod_id    char(10)      NOT NULL,
  vend_id    int           NOT NULL ,
  prod_name  char(255)     NOT NULL ,
  prod_price decimal(8,2)  NOT NULL ,
  prod_desc  text          NULL ,
  PRIMARY KEY(prod_id)
) ENGINE=InnoDB;

######################
# Create crash_vendors table
######################
CREATE TABLE crash_vendors
(
  vend_id      int      NOT NULL AUTO_INCREMENT,
  vend_name    char(50) NOT NULL ,
  vend_address char(50) NULL ,
  vend_city    char(50) NULL ,
  vend_state   char(5)  NULL ,
  vend_zip     char(10) NULL ,
  vend_country char(50) NULL ,
  PRIMARY KEY (vend_id)
) ENGINE=InnoDB;

###########################
# Create crash_productnotes table
###########################
CREATE TABLE crash_productnotes
(
  note_id    int           NOT NULL AUTO_INCREMENT,
  prod_id    char(10)      NOT NULL,
  note_date datetime       NOT NULL,
  note_text  text          NULL ,
  PRIMARY KEY(note_id),
  FULLTEXT(note_text)
) ENGINE=MyISAM;


#####################
# Define crash_foreign keys
#####################
ALTER TABLE crash_orderitems ADD CONSTRAINT fk_orderitems_orders FOREIGN KEY (order_num) REFERENCES crash_orders (order_num);
ALTER TABLE crash_orderitems ADD CONSTRAINT fk_orderitems_products FOREIGN KEY (prod_id) REFERENCES crash_products (prod_id);
ALTER TABLE crash_orders ADD CONSTRAINT fk_orders_customers FOREIGN KEY (cust_id) REFERENCES crash_customers (cust_id);
ALTER TABLE crash_products ADD CONSTRAINT fk_products_vendors FOREIGN KEY (vend_id) REFERENCES crash_vendors (vend_id);


##########################
# Populate crash_customers table
##########################
INSERT INTO crash_customers(cust_id, cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country, cust_contact, cust_email)
VALUES(10001, 'Coyote Inc.', '200 Maple Lane', 'Detroit', 'MI', '44444', 'USA', 'Y Lee', 'ylee@coyote.com');
INSERT INTO crash_customers(cust_id, cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country, cust_contact)
VALUES(10002, 'Mouse House', '333 Fromage Lane', 'Columbus', 'OH', '43333', 'USA', 'Jerry Mouse');
INSERT INTO crash_customers(cust_id, cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country, cust_contact, cust_email)
VALUES(10003, 'Wascals', '1 Sunny Place', 'Muncie', 'IN', '42222', 'USA', 'Jim Jones', 'rabbit@wascally.com');
INSERT INTO crash_customers(cust_id, cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country, cust_contact, cust_email)
VALUES(10004, 'Yosemite Place', '829 Riverside Drive', 'Phoenix', 'AZ', '88888', 'USA', 'Y Sam', 'sam@yosemite.com');
INSERT INTO crash_customers(cust_id, cust_name, cust_address, cust_city, cust_state, cust_zip, cust_country, cust_contact)
VALUES(10005, 'E Fudd', '4545 53rd Street', 'Chicago', 'IL', '54545', 'USA', 'E Fudd');


########################
# Populate crash_vendors table
########################
INSERT INTO crash_vendors(vend_id, vend_name, vend_address, vend_city, vend_state, vend_zip, vend_country)
VALUES(1001,'Anvils R Us','123 Main Street','Southfield','MI','48075', 'USA');
INSERT INTO crash_vendors(vend_id, vend_name, vend_address, vend_city, vend_state, vend_zip, vend_country)
VALUES(1002,'LT Supplies','500 Park Street','Anytown','OH','44333', 'USA');
INSERT INTO crash_vendors(vend_id, vend_name, vend_address, vend_city, vend_state, vend_zip, vend_country)
VALUES(1003,'ACME','555 High Street','Los Angeles','CA','90046', 'USA');
INSERT INTO crash_vendors(vend_id, vend_name, vend_address, vend_city, vend_state, vend_zip, vend_country)
VALUES(1004,'Furball Inc.','1000 5th Avenue','New York','NY','11111', 'USA');
INSERT INTO crash_vendors(vend_id, vend_name, vend_address, vend_city, vend_state, vend_zip, vend_country)
VALUES(1005,'Jet Set','42 Galaxy Road','London', NULL,'N16 6PS', 'England');
INSERT INTO crash_vendors(vend_id, vend_name, vend_address, vend_city, vend_state, vend_zip, vend_country)
VALUES(1006,'Jouets Et Ours','1 Rue Amusement','Paris', NULL,'45678', 'France');


#########################
# Populate crash_products table
#########################
INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('ANV01', 1001, '.5 ton anvil', 5.99, '.5 ton anvil, black, complete with handy hook');
INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('ANV02', 1001, '1 ton anvil', 9.99, '1 ton anvil, black, complete with handy hook and carrying case');
INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('ANV03', 1001, '2 ton anvil', 14.99, '2 ton anvil, black, complete with handy hook and carrying case');
INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('OL1', 1002, 'Oil can', 8.99, 'Oil can, red');
INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('FU1', 1002, 'Fuses', 3.42, '1 dozen, extra long');
INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('SLING', 1003, 'Sling', 4.49, 'Sling, one size fits all');
INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('TNT1', 1003, 'TNT (1 stick)', 2.50, 'TNT, red, single stick');
INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('TNT2', 1003, 'TNT (5 sticks)', 10, 'TNT, red, pack of 10 sticks');
INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('FB', 1003, 'Bird seed', 10, 'Large bag (suitable for road runners)');
INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('FC', 1003, 'Carrots', 2.50, 'Carrots (rabbit hunting season only)');
INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('SAFE', 1003, 'Safe', 50, 'Safe with combination lock');
INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('DTNTR', 1003, 'Detonator', 13, 'Detonator (plunger powered), fuses not included');
INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('JP1000', 1005, 'JetPack 1000', 35, 'JetPack 1000, intended for single use');
INSERT INTO crash_products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('JP2000', 1005, 'JetPack 2000', 55, 'JetPack 2000, multi-use');



#######################
# Populate crash_orders table
#######################
INSERT INTO crash_orders(order_num, order_date, cust_id)
VALUES(20005, '2005-09-01', 10001);
INSERT INTO crash_orders(order_num, order_date, cust_id)
VALUES(20006, '2005-09-12', 10003);
INSERT INTO crash_orders(order_num, order_date, cust_id)
VALUES(20007, '2005-09-30', 10004);
INSERT INTO crash_orders(order_num, order_date, cust_id)
VALUES(20008, '2005-10-03', 10005);
INSERT INTO crash_orders(order_num, order_date, cust_id)
VALUES(20009, '2005-10-08', 10001);


###########################
# Populate crash_orderitems table
###########################
INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price)
VALUES(20005, 1, 'ANV01', 10, 5.99);
INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price)
VALUES(20005, 2, 'ANV02', 3, 9.99);
INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price)
VALUES(20005, 3, 'TNT2', 5, 10);
INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price)
VALUES(20005, 4, 'FB', 1, 10);
INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price)
VALUES(20006, 1, 'JP2000', 1, 55);
INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price)
VALUES(20007, 1, 'TNT2', 100, 10);
INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price)
VALUES(20008, 1, 'FC', 50, 2.50);
INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price)
VALUES(20009, 1, 'FB', 1, 10);
INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price)
VALUES(20009, 2, 'OL1', 1, 8.99);
INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price)
VALUES(20009, 3, 'SLING', 1, 4.49);
INSERT INTO crash_orderitems(order_num, order_item, prod_id, quantity, item_price)
VALUES(20009, 4, 'ANV03', 1, 14.99);

#############################
# Populate crash_productnotes table
#############################
INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text)
VALUES(101, 'TNT2', '2005-08-17',
'Customer complaint:
Sticks not individually wrapped, too easy to mistakenly detonate all at once.
Recommend individual wrapping.'
);
INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text)
VALUES(102, 'OL1', '2005-08-18',
'Can shipped full, refills not available.
Need to order new can if refill needed.'
);
INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text)
VALUES(103, 'SAFE', '2005-08-18',
'Safe is combination locked, combination not provided with safe.
This is rarely a problem as safes are typically blown up or dropped by customers.'
);
INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text)
VALUES(104, 'FC', '2005-08-19',
'Quantity varies, sold by the sack load.
All guaranteed to be bright and orange, and suitable for use as rabbit bait.'
);
INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text)
VALUES(105, 'TNT2', '2005-08-20',
'Included fuses are short and have been known to detonate too quickly for some customers.
Longer fuses are available (item FU1) and should be recommended.'
);
INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text)
VALUES(106, 'TNT2', '2005-08-22',
'Matches not included, recommend purchase of matches or detonator (item DTNTR).'
);
INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text)
VALUES(107, 'SAFE', '2005-08-23',
'Please note that no returns will be accepted if safe opened using explosives.'
);
INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text)
VALUES(108, 'ANV01', '2005-08-25',
'Multiple customer returns, anvils failing to drop fast enough or falling backwards on purchaser. Recommend that customer considers using heavier anvils.'
);
INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text)
VALUES(109, 'ANV03', '2005-09-01',
'Item is extremely heavy. Designed for dropping, not recommended for use with slings, ropes, pulleys, or tightropes.'
);
INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text)
VALUES(110, 'FC', '2005-09-01',
'Customer complaint: rabbit has been able to detect trap, food apparently less effective now.'
);
INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text)
VALUES(111, 'SLING', '2005-09-02',
'Shipped unassembled, requires common tools (including oversized hammer).'
);
INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text)
VALUES(112, 'SAFE', '2005-09-02',
'Customer complaint:
Circular hole in safe floor can apparently be easily cut with handsaw.'
);
INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text)
VALUES(113, 'ANV01', '2005-09-05',
'Customer complaint:
Not heavy enough to generate flying stars around head of victim. If being purchased for dropping, recommend ANV02 or ANV03 instead.'
);
INSERT INTO crash_productnotes(note_id, prod_id, note_date, note_text)
VALUES(114, 'SAFE', '2005-09-07',
'Call from individual trapped in safe plummeting to the ground, suggests an escape hatch be added.
Comment forwarded to vendor.'
);

【Sat Oct 22 2016 21:56:08 GMT+0800】
MySQL练习数据库

-- phpMyAdmin SQL Dump
-- version 3.5.3
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2016 年 10 月 23 日 21:09
-- 服务器版本: 5.5.20
-- PHP 版本: 5.3.5

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

--
-- 数据库: `exercise`
--

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

--
-- 表的结构 `customers`
--

CREATE TABLE IF NOT EXISTS `customers` (
  `cust_id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_name` char(50) NOT NULL,
  `cust_address` char(50) DEFAULT NULL,
  `cust_city` char(50) DEFAULT NULL,
  `cust_state` char(5) DEFAULT NULL,
  `cust_zip` char(10) DEFAULT NULL,
  `cust_country` char(50) DEFAULT NULL,
  `cust_contact` char(50) DEFAULT NULL,
  `cust_email` char(255) DEFAULT NULL,
  PRIMARY KEY (`cust_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10006 ;

--
-- 转存表中的数据 `customers`
--

INSERT INTO `customers` (`cust_id`, `cust_name`, `cust_address`, `cust_city`, `cust_state`, `cust_zip`, `cust_country`, `cust_contact`, `cust_email`) VALUES
(10001, 'Coyote Inc.', '200 Maple Lane', 'Detroit', 'MI', '44444', 'USA', 'Y Lee', 'ylee@coyote.com'),
(10002, 'Mouse House', '333 Fromage Lane', 'Columbus', 'OH', '43333', 'USA', 'Jerry Mouse', NULL),
(10003, 'Wascals', '1 Sunny Place', 'Muncie', 'IN', '42222', 'USA', 'Jim Jones', 'rabbit@wascally.com'),
(10004, 'Yosemite Place', '829 Riverside Drive', 'Phoenix', 'AZ', '88888', 'USA', 'Y Sam', 'sam@yosemite.com'),
(10005, 'E Fudd', '4545 53rd Street', 'Chicago', 'IL', '54545', 'USA', 'E Fudd', NULL);

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

--
-- 表的结构 `goods`
--

CREATE TABLE IF NOT EXISTS `goods` (
  `goods_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `goods_sn` varchar(60) NOT NULL DEFAULT '',
  `goods_name` varchar(120) NOT NULL DEFAULT '',
  `goods_name_style` varchar(60) NOT NULL DEFAULT '+',
  `click_count` int(10) unsigned NOT NULL DEFAULT '0',
  `brand_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `provider_name` varchar(100) NOT NULL DEFAULT '',
  `goods_number` smallint(5) unsigned NOT NULL DEFAULT '0',
  `goods_weight` decimal(10,3) unsigned NOT NULL DEFAULT '0.000',
  `market_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `shop_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `promote_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `promote_start_date` int(11) unsigned NOT NULL DEFAULT '0',
  `promote_end_date` int(11) unsigned NOT NULL DEFAULT '0',
  `warn_number` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `keywords` varchar(255) NOT NULL DEFAULT '',
  `goods_brief` varchar(255) NOT NULL DEFAULT '',
  `goods_desc` text NOT NULL,
  `goods_thumb` varchar(255) NOT NULL DEFAULT '',
  `goods_img` varchar(255) NOT NULL DEFAULT '',
  `original_img` varchar(255) NOT NULL DEFAULT '',
  `is_real` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `extension_code` varchar(30) NOT NULL DEFAULT '',
  `is_on_sale` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `is_alone_sale` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `is_shipping` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `integral` int(10) unsigned NOT NULL DEFAULT '0',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0',
  `sort_order` smallint(4) unsigned NOT NULL DEFAULT '100',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_best` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_new` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_promote` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `bonus_type_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `last_update` int(10) unsigned NOT NULL DEFAULT '0',
  `goods_type` smallint(5) unsigned NOT NULL DEFAULT '0',
  `seller_note` varchar(255) NOT NULL DEFAULT '',
  `give_integral` int(11) NOT NULL DEFAULT '-1',
  `rank_integral` int(11) NOT NULL DEFAULT '-1',
  `suppliers_id` smallint(5) unsigned DEFAULT NULL,
  `is_check` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`goods_id`),
  KEY `goods_sn` (`goods_sn`),
  KEY `cat_id` (`cat_id`),
  KEY `last_update` (`last_update`),
  KEY `brand_id` (`brand_id`),
  KEY `goods_weight` (`goods_weight`),
  KEY `promote_end_date` (`promote_end_date`),
  KEY `promote_start_date` (`promote_start_date`),
  KEY `goods_number` (`goods_number`),
  KEY `sort_order` (`sort_order`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;

--
-- 转存表中的数据 `goods`
--

INSERT INTO `goods` (`goods_id`, `cat_id`, `goods_sn`, `goods_name`, `goods_name_style`, `click_count`, `brand_id`, `provider_name`, `goods_number`, `goods_weight`, `market_price`, `shop_price`, `promote_price`, `promote_start_date`, `promote_end_date`, `warn_number`, `keywords`, `goods_brief`, `goods_desc`, `goods_thumb`, `goods_img`, `original_img`, `is_real`, `extension_code`, `is_on_sale`, `is_alone_sale`, `is_shipping`, `integral`, `add_time`, `sort_order`, `is_delete`, `is_best`, `is_new`, `is_hot`, `is_promote`, `bonus_type_id`, `last_update`, `goods_type`, `seller_note`, `give_integral`, `rank_integral`, `suppliers_id`, `is_check`) VALUES
(1, 4, 'ECS000000', 'KD876', '+', 7, 8, '', 1, '0.110', '1665.60', '1388.00', '0.00', 0, 0, 1, 'LG 3g 876 支持 双模 2008年04月 灰色 GSM,850,900,1800,1900', '', '<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 很多朋友都已经抢先体验了3G网络的可视通话、高速上网等功能。LG KD876手机<span style="font-size: x-large;"><span style="color: rgb(255, 0, 0);"><strong>支持TD-SCDMA/GSM双模单待</strong></span></span>，便于测试初期GSM网络和TD网络之间的切换和共享。</p>\r\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LG KD876手机整体采用银色塑料材质，<strong><span style="font-size: x-large;"><span style="color: rgb(255, 0, 0);">特殊的旋转屏设计是本机的亮点</span></span></strong>，而机身背部的300万像素摄像头也是首发的六款TD-SCDMA手机中配置最高的。LG KD876手机屏幕下方设置有外键盘，该键盘由左/右软键、通话/挂机键、返回键、五维摇杆组成，摇杆灵敏度很高，定位准确。KD876的内键盘由标准12个电话键和三个功能键、一个内置摄像头组成。三个功能键分别为视频通话、MP3、和菜单键，所有按键的手感都比较一般，键程适中，当由于按键排列过于紧密，快速发短信时很容易误按，用户在使用时一定要多加注意。LG KD876手机机身周边的接口设计非常简洁，手机的厚度主要来自屏幕旋转轴的长度，如果舍弃旋屏设计的话，估计<span style="font-size: x-large;"><strong><span style="color: rgb(255, 0, 0);">厚度可以做到10mm以下</span></strong></span>。</p>', 'images/200905/thumb_img/1_thumb_G_1240902890710.jpg', 'images/200905/goods_img/1_G_1240902890755.jpg', 'images/200905/source_img/1_G_1240902890895.gif', 1, '', 1, 1, 0, 13, 1240902890, 100, 0, 1, 1, 1, 0, 0, 1269589545, 9, '', -1, -1, NULL, NULL),
(4, 8, 'ECS000004', '诺基亚N85原装充电器', '+', 0, 1, '', 17, '0.000', '69.60', '58.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/4_thumb_G_1241422402467.jpg', 'images/200905/goods_img/4_G_1241422402722.jpg', 'images/200905/source_img/4_G_1241422402919.jpg', 1, '', 1, 0, 0, 0, 1241422402, 100, 0, 0, 0, 0, 0, 0, 1242110662, 6, '', -1, -1, NULL, NULL),
(3, 8, 'ECS000002', '诺基亚原装5800耳机', '+', 3, 1, '', 24, '0.000', '81.60', '68.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/3_thumb_G_1241422082679.jpg', 'images/200905/goods_img/3_G_1241422082168.jpg', 'images/200905/source_img/3_G_1241422082367.jpg', 1, '', 1, 1, 0, 0, 1241422082, 100, 0, 0, 0, 0, 0, 0, 1241972255, 6, '', -1, -1, NULL, NULL),
(5, 11, 'ECS000005', '索爱原装M2卡读卡器', '+', 3, 7, '', 8, '0.000', '24.00', '20.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/5_thumb_G_1241422518886.jpg', 'images/200905/goods_img/5_G_1241422518773.jpg', 'images/200905/source_img/5_G_1241422518470.jpg', 1, '', 1, 1, 0, 0, 1241422518, 100, 0, 1, 1, 0, 0, 0, 1241972241, 2, '', -1, -1, NULL, NULL),
(6, 11, 'ECS000006', '胜创KINGMAX内存卡', '+', 0, 0, '', 15, '0.000', '50.40', '42.00', '0.00', 0, 0, 1, '', '', '', '', '', '', 1, '', 1, 0, 0, 0, 1241422573, 100, 0, 0, 0, 0, 0, 0, 1241972238, 6, '', -1, -1, NULL, NULL),
(7, 8, 'ECS000007', '诺基亚N85原装立体声耳机HS-82', '+', 0, 1, '', 20, '0.000', '120.00', '100.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/7_thumb_G_1241422785492.jpg', 'images/200905/goods_img/7_G_1241422785856.jpg', 'images/200905/source_img/7_G_1241422785657.jpg', 1, '', 1, 1, 0, 1, 1241422785, 100, 0, 0, 0, 0, 0, 0, 1241972232, 2, '', -1, -1, NULL, NULL),
(8, 3, 'ECS000008', '飞利浦9@9v', '+', 9, 4, '', 1, '0.075', '478.79', '399.00', '385.00', 1241366400, 1417276800, 1, '双模 2008年春 黑色 直板 中低档', '', '<p align="left">作为一款性价比极高的入门级<font size="3" color="#ff0000"><strong>商务手机</strong></font>，飞利浦<a href="mailto:9@9v">Xenium&nbsp; 9@9v</a>三围大小为105&times;44&times;15.8mm，机身重量仅为<strong><font size="3" color="#ff0000">75g</font></strong>，装配了一块低规格1.75英寸128&times;160像素65000色CSTN显示屏。身正面采用月银色功能键区与屏幕数字键区相分隔，键盘设计较为<font size="3"><strong><font color="#ff0000">别</font><font color="#ff0000">致</font></strong></font>，中部导航键区采用钛金色的&ldquo;腰带&rdquo;彰显出浓郁的商务气息。</p>\r\n<p align="left">&nbsp;</p>\r\n<p align="left">此款手机采用<strong><font size="3" color="#ff0000">触摸屏</font></strong>设计，搭配精致的手写笔，可支持手写中文和英文两个版本。增强的内置系统还能识别潦草字迹，确保在移动中和匆忙时输入文字的识别率。手写指令功能还支持特定图案的瞬间调用，独特的手写记事本功能，可以在触摸屏上随意绘制个性化的图案并进行<strong><font size="3" color="#ff0000">记事提醒</font></strong>，让商务应用更加随意。</p>\r\n<p align="left">&nbsp;</p>\r\n<p align="left">&nbsp;作为入门级为数不多支持<strong><font size="3" color="#ff0000">双卡功能</font></strong>的手机，可以同时插入两张SIM卡，通过菜单随意切换，只需开启漫游自动切换模式，<a href="mailto:9@9V">9@9V</a>在该模式下能够判断网络情况，自动切换适合的手机号。</p>\r\n<p align="left">&nbsp;</p>\r\n<p align="left">&nbsp;</p>', 'images/200905/thumb_img/8_thumb_G_1241425513488.jpg', 'images/200905/goods_img/8_G_1241425513055.jpg', 'images/200905/source_img/8_G_1241425513518.jpg', 1, '', 1, 1, 0, 3, 1241425512, 100, 0, 1, 1, 1, 1, 0, 1269589533, 9, '', -1, -1, NULL, NULL),
(9, 3, 'ECS000009', '诺基亚E66', '+', 20, 1, '', 4, '0.121', '2757.60', '2298.00', '0.00', 0, 0, 1, 'SMS EMS MMS 短消息群发 语音 阅读器 SMS,EMS,MMS,短消息群发语音合成信息阅读器 黑色 白色 滑盖', '', '<p>在机身材质方面，诺基亚E66大量采用金属材质，刨光的金属表面光泽动人，背面的点状效果规则却又不失变化，时尚感总是在不经意间诠释出来，并被人们所感知。E66机身尺寸为<span style="color: rgb(255, 0, 0);"><span style="font-size: larger;"><strong>107.5&times;49.5&times;13.6毫米，重量为121克</strong></span></span>，滑盖的造型竟然比E71还要轻一些。</p>\r\n<p>&nbsp;</p>\r\n<div>诺基亚E66机身正面是<span style="color: rgb(255, 0, 0);"><span style="font-size: larger;"><strong>一块2.4英寸1600万色QVGA分辨率（240&times;320像素）液晶显示屏</strong></span></span>。屏幕上方拥有光线感应元件，能够自适应周 围环境光调节屏幕亮度；屏幕下方是方向功能键区。打开滑盖，可以看到传统的数字键盘，按键的大小、手感、间隔以及键程适中，手感非常舒适。</div>\r\n<div>&nbsp;</div>\r\n<div>诺基亚为E66配备了一颗320万像素自动对焦摄像头，带有LED 闪光灯，支持多种拍照尺寸选择。</div>\r\n<p>&nbsp;</p>', 'images/200905/thumb_img/9_thumb_G_1241511871555.jpg', 'images/200905/goods_img/9_G_1241511871574.jpg', 'images/200905/source_img/9_G_1241511871550.jpg', 1, '', 1, 1, 0, 22, 1241511871, 100, 0, 1, 1, 1, 0, 0, 1269589743, 9, '', -1, -1, NULL, NULL),
(10, 3, 'ECS000010', '索爱C702c', '+', 11, 7, '', 7, '0.000', '1593.60', '1328.00', '1250.00', 1243785600, 1277827200, 1, '2008年05月 GSM,850,900,1800,1900 直板', '', '<p>C702可以说是一种在外观上复古的产物，不仅延续T系列早期的直板造型，而且在屏幕和键盘的组合分布上都继承了前辈的精髓。C702的机身尺寸为106&times;48&times;15.5毫米，重量为105克。此外索尼爱立信为C702融入了<font size="3" color="#ff0000"><strong>三防特性，即防尘、防滑和防水溅</strong></font>，这款新的C702搭载了索尼爱立信经典A200平台，界面布局与W908c、K858c一致，典型的特征就是配备左右软键、中央确定键和通话/挂机键。</p>\r\n<p>索尼爱立信C702配备一块<strong><font size="3" color="#ff0000">2.2英寸26万色TFT液晶显示屏</font></strong>，分辨率为240&times;320像素(QVGA)，显示效果属于目前主流水准。C702可以说是索尼爱立信首批<strong><font size="3" color="#ff0000">内置GPS模块</font></strong>的 手机产品之一，C702的搜星、定位一气呵成，十分精准，误差大约在10米之内。基本上定位后可以将有效卫星数量控制在4&mdash;6颗，可以说可以满足我们的需 要了。C702还提供了&ldquo;影像定位&rdquo;功能，配合内置的AGPS全球定位辅助系统，只须启动Geo-Tagging智能影像定位功能，便可将拍摄地点记录在 照片内，方便用户随时查询。</p>\r\n<p>&nbsp;</p>\r\n<p>作为一款Cyber-shot系列影像手机，索尼爱立信C702在拍照功能方面同样有不俗的表现。并且手机内置的<strong><font size="3" color="#ff0000">320万像素摄像头</font></strong>也 同样在拍照功能上也不错的表现。不仅支持自动聚焦和双LED闪光功能，而且还拥有2倍数码变焦、防红眼、Photo fix优画及场景模式等功能。索尼爱立信C702除了配备的是最大光圈为F3.2的4.2毫米镜头之外，该机也如同门中的旗舰C902一样增加了对脸部有 先自动聚焦功能的支持。</p>\r\n<p>&nbsp;</p>', 'images/200905/thumb_img/10_thumb_G_1242973436403.jpg', 'images/200905/goods_img/10_G_1242973436141.jpg', 'images/200905/source_img/10_G_1242973436172.jpg', 1, '', 1, 1, 0, 13, 1241965622, 100, 0, 0, 0, 1, 1, 0, 1245290333, 9, '', -1, -1, NULL, NULL),
(11, 3, 'ECS000011', '索爱C702c', '+', 0, 7, '', 1, '0.000', '0.00', '1300.00', '0.00', 0, 0, 1, '直板', '', '', '', '', '', 1, '', 0, 1, 0, 0, 1241966951, 100, 1, 0, 0, 0, 0, 0, 1241966960, 7, '', -1, -1, NULL, NULL),
(12, 3, 'ECS000012', '摩托罗拉A810', '+', 13, 2, '', 8, '0.000', '1179.60', '983.00', '960.00', 1241107200, 1255104000, 1, 'SMS EMS MMS pda 摄像 智能 音乐 SMS,EMS,MMS', '', '<p>全机使用的材质除去电池盖部分采用了金属以外，其它均使用了ABS工程塑料作为主材，这款手机的三围是105&times;51&times;14毫米，有着100克的轻量级重量，拿在手中的感觉还是非常不错的。A810手机作为一款<strong><font size="3" color="#ff0000">PDA手机</font></strong>在设计的时候取消了键盘配置，一切数字键都要依靠手机内提供的虚拟键盘进行操作，在手机的左上侧是一个<strong><font size="3" color="#ff0000">3.5mm的标准耳机插口</font></strong>，这种设计可以让用户使用自己习惯或者喜欢的耳机去欣赏音乐。</p>\r\n<p>&nbsp;</p>\r\n<p>这款摩托罗拉A810手机配置了一块<font size="3" color="#ff0000"><strong>26万色的2.2英寸TFT全触摸屏幕</strong></font>，其分辨率达到了主流的QVGA水平（240&times;320像素），摩托罗拉A810采用了内部核心为2.6.10的<strong><font size="3" color="#ff0000">LINUX操作系统</font></strong>，菜单上依然采用传统的9宫格的显示方式，一般手机的名片式电话本只能支持诸如电话、邮件、传真、公司等一些基本信息，而A810手机的电话本除了这些还支持公司地址，配偶信息、子女姓名、上司名称、助手等等，对于一款手机来说，电话本不可谓不强大。A810的<strong><font size="3" color="#ff0000">手写识别能力相当的惊人</font></strong>，对连笔、草书和倒插笔的识别率都相当的高，同时还为左右手设置了不同的书写习惯选择，并支持手写速度的调节。</p>\r\n<p>这款A810手机<strong><font size="3" color="#ff0000">内置的音乐播放功能</font></strong>可以支持MP3、WAV、AMR、AAC等格式的音乐播放，<font size="3" color="#ff0000"><strong>支持后台播放</strong></font>。视频方面，这款A810支持MP4、3GP、H.263格式的播放，视频播放器同样简约，操作方便，这款摩托罗拉A810还内置了6款游戏，每一款都有很高的耐玩性，而且都是支持触摸屏操作的，同时这款手机还内置了<strong><font size="3" color="#ff0000">FM收音机</font></strong>，支持自动搜索，并提供了20个频道供用户存储，不过收音机并不支持后台播放。</p>\r\n<p>&nbsp;</p>', 'images/200905/thumb_img/12_thumb_G_1241965978410.jpg', 'images/200905/goods_img/12_G_1241965978209.jpg', 'images/200905/source_img/12_G_1241965978878.jpg', 1, '', 1, 1, 0, 9, 1245297652, 100, 0, 0, 1, 0, 1, 0, 1245297670, 3, '', -1, -1, NULL, NULL),
(13, 3, 'ECS000013', '诺基亚5320 XpressMusic', '+', 13, 1, '', 8, '0.000', '1573.20', '1311.00', '0.00', 0, 0, 1, '摄像 智能 音乐 蓝色 红色 舒适 直板 中档 2008年07月 黑色 GSM,850,900,1800,1900', '', '<p>诺基亚5320XpressMusic音乐手机采用XpressMusic系列常见的黑红、黑蓝配色方案，而材质方便则选用的是经过<strong><font size="3" color="#ff0000">抛光处理</font></strong>的工程塑料；三围/体重为，为108&times;46&times;15mm/<strong><font size="3" color="#ff0000">90g</font></strong>，手感舒适。</p>\r\n<p>&nbsp;</p>\r\n<p>诺基亚5320采用的是一块可视面积为2.0英寸的<font size="3" color="#ff0000"><strong>1600万色</strong></font>屏幕，分辨率是常见的240&times;320像素（QVGA）。虽然屏幕不是特别大，但效果非常精细，色彩还原不错。</p>\r\n<p>&nbsp;</p>\r\n<p>手机背面，诺基亚为5320XM配备一颗<strong><font size="3" color="#ff0000">200W像素</font></strong>的摄像头，并且带有<strong><font size="3" color="#ff0000">两个LED的补光灯</font></strong>，可以实现拍照、摄像功能，并能通过彩信、邮件方式发送给朋友。</p>\r\n<p>&nbsp;</p>', 'images/200905/thumb_img/13_thumb_G_1241968002527.jpg', 'images/200905/goods_img/13_G_1241968002233.jpg', 'images/200905/source_img/13_G_1241968002732.jpg', 1, '', 1, 1, 0, 13, 1241967762, 100, 0, 0, 0, 1, 0, 0, 1269589198, 9, '', -1, -1, NULL, NULL),
(14, 4, 'ECS000014', '诺基亚5800XM', '+', 6, 1, '', 1, '0.000', '3150.00', '2625.00', '0.00', 0, 0, 1, 'GSM 64和弦 2009年2月 320万摄像头 GPS 直板 工程塑料 支持 2008年10月 黑色', '', '', 'images/200905/thumb_img/14_thumb_G_1241968492116.jpg', 'images/200905/goods_img/14_G_1241968492932.jpg', 'images/200905/source_img/14_G_1241968492305.jpg', 1, '', 1, 1, 0, 26, 1241968492, 100, 0, 0, 0, 1, 0, 0, 1269589186, 9, '', -1, -1, NULL, NULL),
(15, 3, 'ECS000015', '摩托罗拉A810', '+', 8, 2, '', 3, '0.000', '945.60', '788.00', '0.00', 0, 0, 1, '600 直板 工程塑料 蓝牙 视频拍摄 音乐 黑色 白色', '', '', 'images/200905/thumb_img/15_thumb_G_1242973362970.jpg', 'images/200905/goods_img/15_G_1242973362318.jpg', 'images/200905/source_img/15_G_1242973362751.jpg', 1, '', 1, 1, 0, 5, 1241968703, 100, 1, 0, 1, 1, 0, 0, 1245297631, 9, '', -1, -1, NULL, NULL),
(16, 2, 'ECS000016', '恒基伟业G101', '+', 3, 11, '', 0, '0.000', '988.00', '823.33', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/16_thumb_G_1241968949103.jpg', 'images/200905/goods_img/16_G_1241968949002.jpg', 'images/200905/source_img/16_G_1241968949402.jpg', 1, '', 0, 1, 0, 8, 1241968949, 100, 0, 0, 0, 0, 0, 0, 1245290562, 2, '', -1, -1, NULL, NULL),
(17, 3, 'ECS000017', '夏新N7', '+', 2, 5, '', 1, '0.000', '2760.00', '2300.00', '0.00', 0, 0, 1, '2008年01月 GSM,900,1800,1900,2100 直板 262144万 240×400 像素 SMS,EMS,MMS,超长信息发送,短消息群发 黑色 CDMA', '', '', 'images/200905/thumb_img/17_thumb_G_1241969394587.jpg', 'images/200905/goods_img/17_G_1241969394677.jpg', 'images/200905/source_img/17_G_1241969394844.jpg', 1, '', 1, 1, 0, 23, 1241969394, 100, 0, 1, 0, 1, 0, 0, 1269589169, 9, '', -1, -1, NULL, NULL),
(18, 4, 'ECS000018', '夏新T5', '+', 0, 5, '', 1, '0.000', '3453.60', '2878.00', '0.00', 0, 0, 1, '2008年04月 3G(GSM,900,1800,1900,TD-SCDMA ) 直板 262144万 320×240 像素 是 银色', '', '<p>&nbsp;  TD-SCDMA/GSM两种模式任意切换，中国3G手机先驱，支持大陆特有3G网络，轻松实现可视电话、视频留言、视频会议功能，2.6英寸Q屏，手写、键盘双输入，内置移动证券，支持手机邮箱、手机地图、无驱U盘</p>', '', '', '', 1, '', 1, 1, 0, 28, 1241969533, 100, 1, 0, 0, 0, 0, 0, 1241969533, 2, '', -1, -1, NULL, NULL),
(19, 3, 'ECS000019', '三星SGH-F258', '+', 7, 6, '', 12, '0.000', '1029.60', '858.00', '0.00', 0, 0, 1, '滑盖 GSM 258 时尚 蓝牙 黑色 金色 白色', '从整体来看，三星SGH-F258比较时尚可爱，三围尺寸为94×46×17.5mm，重量为96克，曲线柔和具有玲珑美感\r\n', '<p>从整体来看，三星SGH-F258比较<font size="3" color="#ff0000"><strong>时尚</strong></font>可爱，三围尺寸为94&times;46&times;17.5mm，重量为96克，曲线柔和具有玲珑美感。</p>\r\n<p>&nbsp;</p>\r\n<p>三星F258的前面板整体应用<strong><font size="3" color="#ff0000">镜面效果</font></strong>，2.0英寸显示屏幕略显窄小，导航键与功能键在滑盖滑开之前是前面板的全部控制键，没有挂断和接听键，不过，五向键有<font size="3"><strong><font color="#ff0000">音乐操</font><font color="#ff0000">作</font></strong></font>功能，明确显示了F258音乐手机的定位。</p>\r\n<p>&nbsp;</p>\r\n<p>F258的数字键键区采用了极具金属质感的平板式设计，每颗按键的面积足够大，按键与按键之间的间隔明显，操作起来手感舒适。</p>', 'images/200905/thumb_img/19_thumb_G_1241970175208.jpg', 'images/200905/goods_img/19_G_1241970175091.jpg', 'images/200905/source_img/19_G_1241970175549.jpg', 1, '', 1, 1, 0, 8, 1241970139, 100, 0, 1, 1, 1, 0, 0, 1269589154, 9, '', -1, -1, NULL, NULL),
(20, 3, 'ECS000020', '三星BC01', '+', 14, 6, '', 12, '0.000', '336.00', '280.00', '238.00', 1241884800, 1251648000, 1, 'GSM 直板 40和弦 金属材质 2008年07月 黑色 GSM,900,1800,1900,2100', '', '', 'images/200905/thumb_img/20_thumb_G_1242106490058.jpg', 'images/200905/goods_img/20_G_1242106490663.jpg', 'images/200905/source_img/20_G_1242106490922.jpg', 1, '', 1, 1, 0, 2, 1241970417, 100, 0, 1, 1, 1, 1, 0, 1269589110, 9, '', -1, -1, NULL, NULL),
(21, 3, 'ECS000021', '金立 A30', '+', 4, 10, '', 40, '0.000', '2400.00', '2000.00', '0.00', 0, 0, 1, '2008年03月 GSM,900,1800,1900,2100 直板 1600万 240×400 像素 2007年12月 200万摄像头 黑色', '', '<p>&nbsp;</p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">标准配置: 标准锂电池两块,充电器两个,立体声耳机一个,数据线,说明书送256TF</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">通讯功能&nbsp; 输入法 短信功能 话机通讯录 通话记录</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">输入法: 中文输入法</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">短信功能: 支持短信300条和彩信100条</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">话机通讯录: 1000组名片式电话存储 来电防火墙功能&nbsp; 来电大头贴及来电铃声识别</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">通话记录：支持电话录音,恢复/静音,双音多频,免提</font></span></p>\r\n<p>&nbsp;</p>\r\n<p><font size="3">高级功能</font></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">多媒体娱乐: 200万像素，最大支持10240*960，11级数码变焦,多种效果设置,连拍可全屏查看拍摄或下载的图片.支持有声MP4短片拍摄，录像时间根据内存 大小而定，拍摄录像,TV电视可跟朋友家人一起分享。支持网络摄像头功能 支持MPEG4、3GP(H.263)等视频格式 支持MP3等音频格式播放， 支持歌词播放</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">内置游戏:智能拼图</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">扩展存储功能:支持TF扩展,支持U盘功能,本机内置1M,随机赠送256TF卡</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">高级功能:直板/智能PDA手写/键盘输入 超长待机 WAP上网&nbsp; 录音 蓝牙 FM收音机 电子书 Java扩展 TV电视输出 声控语音拨号 免费电视 来电防火墙&nbsp;&nbsp;&nbsp;</font></span></p>\r\n<p align="left"><span style="font-size: medium;"><font size="3">附加功能: 日历 计算器 闹钟 记事本 日程表 秒表 单位换算</font></span></p>\r\n<p><span style="font-size: medium;"><font size="3">提醒 以上性能均为本公司员工试机后所写,产品资料仅供参考,请以收到实物为准</font></span></p>', 'images/200905/thumb_img/21_thumb_G_1242109298150.jpg', 'images/200905/goods_img/21_G_1242109298873.jpg', 'images/200905/source_img/21_G_1242109298831.jpg', 1, '', 1, 1, 0, 20, 1241970634, 100, 0, 0, 0, 0, 0, 0, 1269589102, 9, '', -1, -1, NULL, NULL),
(22, 3, 'ECS000022', '多普达Touch HD', '+', 15, 3, '', 1, '0.000', '7198.80', '5999.00', '0.00', 0, 0, 1, '500万摄像头 蓝牙 手写 GPS 办公应用 语音拨号 2008年12月 黑色 GSM,850,900,1800,1900 直板', '', '<p><img src="http://xgone.xgou.com/xgoumanage/upload/20090325/2009032502045081100887.jpg" alt="" /></p>\r\n<p>&nbsp;</p>\r\n<p><img src="http://www.ouku.com/upimg/ouku/Image/002(1).jpg" alt="" /></p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>', 'images/200905/thumb_img/22_thumb_G_1241971076803.jpg', 'images/200905/goods_img/22_G_1241971076358.jpg', 'images/200905/source_img/22_G_1241971076130.jpg', 1, '', 1, 1, 0, 59, 1241971076, 100, 0, 1, 1, 0, 0, 0, 1269589090, 9, '', -1, -1, NULL, NULL),
(23, 5, 'ECS000023', '诺基亚N96', '+', 17, 1, '', 8, '0.000', '4440.00', '3700.00', '0.00', 0, 0, 1, '500万摄像头 microSD 工程塑料 蓝牙 数码相机 内置游戏 滑盖 高档 2008年09月 320×240 像素 黑色', '', '<p>诺基亚N96采用了<strong><font size="3" color="#ff0000">双向滑盖</font></strong>设计，机身整体呈灰黑色，沉稳、大气，机身材质采用了高强度的塑料材质，手机背面采用了抛光面板的设计风格。N96三维体积103*55*20mm，重量为125g。屏幕方面，诺基亚N96配备一块<strong><font size="3" color="#ff0000">2.8英寸</font></strong>的屏幕，支持<strong><font size="3" color="#ff0000">1670万色</font></strong>显示，分辨率达到QVGA（320&times;240）水准。</p>\r\n<p><img alt="" src="file:///C:/DOCUME~1/user/LOCALS~1/Temp/moz-screenshot.jpg" /></p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;<img src="http://img2.zol.com.cn/product/21/896/ceN6LBMCid3X6.jpg" alt="" /></p>\r\n<p>诺基亚N96设置有专门的<strong><font size="3" color="#ff0000">音乐播放键</font></strong>和标准的3.5毫米音频插口，支持多格式音乐播放。内置了<strong><font size="3" color="#ff0000">多媒体播放器</font></strong>，支持FM调频收音机等娱乐功能。N96手机支持<strong><font size="3" color="#ff0000">N-Gage游戏平台</font></strong>，内置包括<font size="3" color="#ff0000"><strong>《PinBall》完整版</strong></font>在内的四款N-Gage游戏，除了手机本身内置的游戏，还可以从N-Gage的网站下载或者购买最新的游戏，而且可以在论坛里和其他玩家一起讨论。</p>\r\n<p><img src="http://img2.zol.com.cn/product/21/898/cekkw57qJjSI.jpg" alt="" /></p>\r\n<p>&nbsp;</p>', 'images/200905/thumb_img/23_thumb_G_1241971556399.jpg', 'images/200905/goods_img/23_G_1241971556855.jpg', 'images/200905/source_img/23_G_1241971556256.jpg', 1, '', 1, 1, 0, 37, 1241971488, 100, 0, 1, 1, 0, 0, 0, 1269589078, 9, '', -1, -1, NULL, NULL),
(24, 3, 'ECS000024', 'P806', '+', 35, 9, '', 100, '0.000', '2400.00', '2000.00', '1850.00', 1243785600, 1277827200, 1, '旅行充电器 图形菜单 Wap 上网 红外接口 移动 MSN 支持 2008年06月 灰色', '', '<div>\r\n<div>\r\n<div><font size="4">规格参数</font></div>\r\n<p><font size="4"><span>上市时间：</span><span>2008年06月</span></font></p>\r\n<p><font size="4"><span>网络频率：</span><span>GSM/GPRS；900/1800MHz</span></font></p>\r\n<p><font size="4"><span>重　量　：</span><span>未知</span></font></p>\r\n<p><font size="4"><span>尺寸/体积：</span><span>未知</span></font></p>\r\n<p><font size="4"><span>可选颜色：</span><span>银色</span></font></p>\r\n<p><font size="4"><span>屏幕参数：</span><span>26万色TFT彩色屏幕；</span></font></p>\r\n<p><font size="4"><span>WAP上网：</span><span>支持飞笺</span></font></p>\r\n<p><font size="4"><span>基本配置:<em><strong><font size="5" color="#ff00ff">二电(1760毫安) 一充 数据线 耳机 手写笔 512M内存卡</font></strong></em></span></font></p>\r\n<p>&nbsp;</p>\r\n</div>\r\n</div>\r\n<div><font size="4">基本功能</font></div>\r\n<p><font size="4"><span>『时钟』</span><span>『内置振动』</span><span>『录音』</span><span>『可选铃声』</span></font></p>\r\n<p><font size="4"><span>『和弦铃声』</span><span>『MP3铃声』</span><span>『来电铃声识别』</span><span>『来电图片识别』</span></font></p>\r\n<p><font size="4"><span>『情景模式』</span><span>『待机图片』</span><span>『图形菜单』</span><span>『触摸屏』</span></font></p>\r\n<p><span><font size="4">『手写输入』</font></span></p>\r\n<div><font size="4">通信功能</font></div>\r\n<p><font size="4"><span>『双卡双待』</span><span>『内置天线』</span><span>『输入法』</span><span>『中文短信』</span></font></p>\r\n<p><font size="4"><span>『短信群发』</span><span>『多媒体短信』</span><span>『话机通讯录』</span><span>『通话记录』</span></font></p>\r\n<p><font size="4"><span>『免提通话』</span><span>『飞行模式』</span></font></p>\r\n<div><font size="4">多媒体娱乐 :支持3GP、MP4文件播放</font></div>\r\n<p><font size="4"><span>『视频播放』</span><span>『MP3播放器』</span></font></p>\r\n<p><font size="4"><span>多媒体卡扩展：</span><span>支持microSD卡扩展&nbsp;</span></font></p>\r\n<p><font size="4"><span>摄像头：</span><span>内置</span></font></p>\r\n<p><font size="4"><span>摄像头像素：</span><span>30万像素</span></font></p>\r\n<p><font size="4"><span>传感器类型：</span><span>CMOS</span></font></p>\r\n<p><font size="4"><span>变焦模式：</span><span>数码变焦</span></font></p>\r\n<p><font size="4"><span>照片分辨率：</span><span>多种照片分辨率选择</span></font></p>\r\n<p><font size="4"><span>拍摄模式：</span><span>多种拍摄模式选择</span></font></p>\r\n<p><font size="4"><span>照片质量：</span><span>多种照片质量选择</span></font></p>\r\n<p><font size="4"><span>视频拍摄：</span><span>有声视频拍摄</span></font></p>\r\n<div><font size="4">数据传输</font></div>\r\n<p><font size="4"><span>『WAP浏览器』</span><span>『数据线接口』</span></font></p>\r\n<div><font size="4">个人助理</font></div>\r\n<p><font size="4"><span>『闹钟』</span><span>『日历』</span><span>『计算器』</span></font></p>', 'images/200905/thumb_img/24_thumb_G_1241971981429.jpg', 'images/200905/goods_img/24_G_1241971981284.jpg', 'images/200905/source_img/24_G_1241971981107.jpg', 1, '', 1, 1, 0, 20, 1241971981, 100, 0, 1, 1, 1, 1, 0, 1269589064, 9, '', -1, -1, NULL, NULL),
(25, 13, 'ECS000025', '小灵通/固话50元充值卡', '+', 0, 0, '', 2, '0.000', '57.59', '48.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/25_thumb_G_1241972709885.jpg', 'images/200905/goods_img/25_G_1241972709544.jpg', 'images/200905/source_img/25_G_1241972709750.jpg', 0, 'virtual_card', 1, 1, 0, 0, 1241972709, 100, 0, 1, 0, 1, 0, 0, 1245047546, 0, '', -1, -1, NULL, NULL),
(26, 13, 'ECS000026', '小灵通/固话20元充值卡', '+', 0, 0, '', 2, '0.000', '22.80', '19.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/26_thumb_G_1241972789393.jpg', 'images/200905/goods_img/26_G_1241972789293.jpg', 'images/200905/source_img/26_G_1241972789353.jpg', 0, 'virtual_card', 1, 1, 0, 0, 1241972789, 100, 0, 0, 0, 1, 0, 0, 1245047540, 0, '', -1, -1, NULL, NULL),
(27, 15, 'ECS000027', '联通100元充值卡', '+', 0, 0, '', 2, '0.000', '100.00', '95.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/27_thumb_G_1241972894068.jpg', 'images/200905/goods_img/27_G_1241972894061.jpg', 'images/200905/source_img/27_G_1241972894069.jpg', 0, 'virtual_card', 1, 1, 0, 0, 1241972894, 100, 0, 1, 1, 1, 0, 0, 1245047557, 0, '', -1, -1, NULL, NULL),
(28, 15, 'ECS000028', '联通50元充值卡', '+', 0, 0, '', 0, '0.000', '50.00', '45.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/28_thumb_G_1241972976986.jpg', 'images/200905/goods_img/28_G_1241972976313.jpg', 'images/200905/source_img/28_G_1241972976695.jpg', 0, 'virtual_card', 1, 1, 0, 0, 1241972976, 100, 0, 0, 0, 1, 0, 0, 1245047542, 0, '', -1, -1, NULL, NULL),
(29, 14, 'ECS000029', '移动100元充值卡', '+', 0, 0, '', 0, '0.000', '0.00', '90.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/29_thumb_G_1241973022239.jpg', 'images/200905/goods_img/29_G_1241973022206.jpg', 'images/200905/source_img/29_G_1241973022514.jpg', 0, 'virtual_card', 1, 1, 0, 0, 1241973022, 100, 0, 1, 0, 1, 0, 0, 1245047543, 0, '', -1, -1, NULL, NULL),
(30, 14, 'ECS000030', '移动20元充值卡', '+', 1, 0, '', 9, '0.000', '21.00', '18.00', '0.00', 0, 0, 1, '', '', '', 'images/200905/thumb_img/30_thumb_G_1241973114800.jpg', 'images/200905/goods_img/30_G_1241973114234.jpg', 'images/200905/source_img/30_G_1241973114587.jpg', 0, 'virtual_card', 1, 1, 0, 0, 1241973114, 100, 0, 1, 0, 1, 0, 0, 1245047549, 0, '', -1, -1, NULL, NULL),
(31, 3, 'ECS000031', '摩托罗拉E8 ', '+', 5, 2, '', 1, '0.000', '1604.39', '1337.00', '0.00', 0, 0, 1, '直板', '', '', 'images/200905/thumb_img/31_thumb_G_1242110412996.jpg', 'images/200905/goods_img/31_G_1242110412332.jpg', 'images/200905/source_img/31_G_1242110412519.jpg', 1, '', 0, 1, 0, 13, 1242110412, 100, 0, 0, 0, 0, 0, 0, 1242140652, 7, '', -1, -1, NULL, NULL);
INSERT INTO `goods` (`goods_id`, `cat_id`, `goods_sn`, `goods_name`, `goods_name_style`, `click_count`, `brand_id`, `provider_name`, `goods_number`, `goods_weight`, `market_price`, `shop_price`, `promote_price`, `promote_start_date`, `promote_end_date`, `warn_number`, `keywords`, `goods_brief`, `goods_desc`, `goods_thumb`, `goods_img`, `original_img`, `is_real`, `extension_code`, `is_on_sale`, `is_alone_sale`, `is_shipping`, `integral`, `add_time`, `sort_order`, `is_delete`, `is_best`, `is_new`, `is_hot`, `is_promote`, `bonus_type_id`, `last_update`, `goods_type`, `seller_note`, `give_integral`, `rank_integral`, `suppliers_id`, `is_check`) VALUES
(32, 3, 'ECS000032', '诺基亚N85', '+', 9, 1, '', 4, '0.000', '3612.00', '3010.00', '2750.00', 1243785600, 1417276800, 1, '2008年10月 GSM,850,900,1800,1900 黑色', '', '<p>诺基亚N85参数</p>\r\n<div>&nbsp;</div>\r\n<div>\r\n<table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n    <tbody>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>基本参数</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">手机昵称</td>\r\n            <td width="450" bgcolor="#ffffff">N85</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">上市日期</td>\r\n            <td width="450" bgcolor="#ffffff">2008年10月</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">手机类型</td>\r\n            <td width="450" bgcolor="#ffffff">3G手机；拍照手机；智能手机</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">手机制式</td>\r\n            <td width="450" bgcolor="#ffffff">GSM</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">支持频段</td>\r\n            <td width="450" bgcolor="#ffffff">GSM850/900/1800/1900MHz</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">数据传输</td>\r\n            <td width="450" bgcolor="#ffffff">GPRS、EDGE</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">屏幕材质</td>\r\n            <td width="450" bgcolor="#ffffff">AMOLED</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">屏幕色彩</td>\r\n            <td width="450" bgcolor="#ffffff">1600万色</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">主屏尺寸</td>\r\n            <td width="450" bgcolor="#ffffff">2.6英寸</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">主屏参数</td>\r\n            <td width="450" bgcolor="#ffffff">QVGA 320&times;240像素</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">铃音描述</td>\r\n            <td width="450" bgcolor="#ffffff">可选MP3、WAV、AAC或和弦Midi铃声等格式</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">操作系统</td>\r\n            <td width="450" bgcolor="#ffffff">Symbian OS v9.3操作系统与S60 v3.2平台的组合</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">机身内存</td>\r\n            <td width="450" bgcolor="#ffffff">74MB 内部动态存储空间<br />\r\n            78MB 内置NAND闪存</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">存储卡</td>\r\n            <td width="450" bgcolor="#ffffff">支持MicroSD(T-Flash)卡扩展最大至8GB</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">电池规格</td>\r\n            <td width="450" bgcolor="#ffffff">1200毫安时锂电池</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">标配</td>\r\n            <td width="450" bgcolor="#ffffff">诺基亚 N85<br />\r\n            诺基亚电池（BL-5K）<br />\r\n            诺基亚旅行充电器（AC-10）<br />\r\n            诺基亚视频数据线（CA-75U）<br />\r\n            诺基亚数据线（CA-101）<br />\r\n            诺基亚音乐耳机（HS-45、AD-54）<br />\r\n            诺基亚 8 GB microSD 卡（MU-43）<br />\r\n            《用户手册》<br />\r\n            《快速入门》</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">理论通话时间</td>\r\n            <td width="450" bgcolor="#ffffff">6.9 小时</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">理论待机时间</td>\r\n            <td width="450" bgcolor="#ffffff">363 小时</td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>产品外形</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">外观设计</td>\r\n            <td width="450" bgcolor="#ffffff">双向滑盖</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">产品尺寸</td>\r\n            <td width="450" bgcolor="#ffffff">103&times;50&times;16mm<br />\r\n            体积：76 立方厘米</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">手机重量</td>\r\n            <td width="450" bgcolor="#ffffff">128克</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">产品天线</td>\r\n            <td width="450" bgcolor="#ffffff">内置</td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>拍照功能</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n            <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n                <tbody>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">定时器</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">摄像头</td>\r\n            <td width="450" bgcolor="#ffffff">内置</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">摄像头像素</td>\r\n            <td width="450" bgcolor="#ffffff">500万像素</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">连拍功能</td>\r\n            <td width="450" bgcolor="#ffffff">支持</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">LED闪光灯</td>\r\n            <td width="450" bgcolor="#ffffff">双LED 闪光灯</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">数码变焦</td>\r\n            <td width="450" bgcolor="#ffffff">20 倍数码变焦</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">拍摄模式</td>\r\n            <td width="450" bgcolor="#ffffff">静止、连拍、自动定时器、摄像</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">照片特效</td>\r\n            <td width="450" bgcolor="#ffffff">正常、怀旧、黑白、负片、逼真</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">拍照描述</td>\r\n            <td width="450" bgcolor="#ffffff">支持最大2592&times;1944分辨率照片拍摄<br />\r\n            支持JPEG、Exif格式<br />\r\n            白平衡模式：自动、阳光、阴天、白炽灯、荧光灯<br />\r\n            感光度模式：高、中、低、自动</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">视频拍摄</td>\r\n            <td width="450" bgcolor="#ffffff">最高支持640 x 480 像素（VGA）、30 帧/秒</td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>娱乐功能</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n            <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n                <tbody>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">收音机</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">TV-OUT</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">录音功能</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">电子书</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">视频播放</td>\r\n            <td width="450" bgcolor="#ffffff">内置RealPlayer播放器, 支持MPEG4、H.264/AVC、H.263/3GP、RealVideo等视频格式全屏播放</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">音乐播放</td>\r\n            <td width="450" bgcolor="#ffffff">内置播放器, 支持mp3、.wma、.aac、eAAC、eAAC+格式</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">游戏</td>\r\n            <td width="450" bgcolor="#ffffff">内置</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">Java功能</td>\r\n            <td width="450" bgcolor="#ffffff">支持Java MIDP 2.0 CLDC 1.1</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">Flash功能</td>\r\n            <td width="450" bgcolor="#ffffff">第3.0版Flash lite播放器</td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>数据功能</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n            <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n                <tbody>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">蓝牙功能</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">数据线接口</td>\r\n            <td width="450" bgcolor="#ffffff">USB数据线 3.5mm立体声耳机插孔</td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>基本功能</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n            <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n                <tbody>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">短信(SMS)</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">彩信(MMS)</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">免提通话</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">情景模式</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">闹钟功能</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">日历功能</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">输入方式</td>\r\n            <td width="450" bgcolor="#ffffff">键盘</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">通话记录</td>\r\n            <td width="450" bgcolor="#ffffff">未接来电+已接来电+已拨电话记录</td>\r\n        </tr>\r\n        <tr>\r\n            <td width="100" valign="center" bgcolor="#ffffff" align="left">通讯录</td>\r\n            <td width="450" bgcolor="#ffffff">S60标准化名片式通讯录</td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>网络功能</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n            <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n                <tbody>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">电子邮件</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">WWW浏览器</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">WAP浏览器</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>商务功能</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n            <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n                <tbody>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">飞行模式</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">语音拨号</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">备忘录</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">日程表</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">世界时间</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td bgcolor="#f1f7fc" colspan="2">\r\n            <p><b>其他功能</b></p>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td width="550" valign="center" bgcolor="#ffffff" align="left" style="padding: 8px 0px;" colspan="2">\r\n            <table cellspacing="1" cellpadding="0" border="0" align="left">\r\n                <tbody>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">GPS功能</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">电子词典</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">待机图片</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">计算器</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">来电铃声识别</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">来电图片识别</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">来电防火墙</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">动画屏保</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">图形菜单</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">秒表</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#c5d7ed">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" bgcolor="#f1f7fc" align="middle" style="padding: 2px; font-weight: bold;">单位换算</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                        <td width="100" style="padding: 5px 0px 5px 10px;">\r\n                        <table width="100%" cellspacing="1" cellpadding="0" border="0">\r\n                            <tbody>\r\n                                <tr>\r\n                                    <td width="100%" align="middle" style="padding: 2px; float: none;">&nbsp;</td>\r\n                                </tr>\r\n                            </tbody>\r\n                        </table>\r\n                        </td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n    </tbody>\r\n</table>\r\n</div>\r\n<p>&nbsp;</p>', 'images/200905/thumb_img/32_thumb_G_1242110760196.jpg', 'images/200905/goods_img/32_G_1242110760868.jpg', 'images/200905/source_img/32_G_1242110760437.jpg', 1, '', 1, 1, 0, 30, 1242110760, 100, 0, 0, 1, 1, 1, 0, 1269589051, 9, '', -1, -1, NULL, NULL);

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

--
-- 表的结构 `orderitems`
--

CREATE TABLE IF NOT EXISTS `orderitems` (
  `order_num` int(11) NOT NULL,
  `order_item` int(11) NOT NULL,
  `prod_id` char(10) NOT NULL,
  `quantity` int(11) NOT NULL,
  `item_price` decimal(8,2) NOT NULL,
  PRIMARY KEY (`order_num`,`order_item`),
  KEY `fk_orderitems_products` (`prod_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `orderitems`
--

INSERT INTO `orderitems` (`order_num`, `order_item`, `prod_id`, `quantity`, `item_price`) VALUES
(20005, 1, 'ANV01', 10, '5.99'),
(20005, 2, 'ANV02', 3, '9.99'),
(20005, 3, 'TNT2', 5, '10.00'),
(20005, 4, 'FB', 1, '10.00'),
(20006, 1, 'JP2000', 1, '55.00'),
(20007, 1, 'TNT2', 100, '10.00'),
(20008, 1, 'FC', 50, '2.50'),
(20009, 1, 'FB', 1, '10.00'),
(20009, 2, 'OL1', 1, '8.99'),
(20009, 3, 'SLING', 1, '4.49'),
(20009, 4, 'ANV03', 1, '14.99');

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

--
-- 表的结构 `orders`
--

CREATE TABLE IF NOT EXISTS `orders` (
  `order_num` int(11) NOT NULL AUTO_INCREMENT,
  `order_date` datetime NOT NULL,
  `cust_id` int(11) NOT NULL,
  PRIMARY KEY (`order_num`),
  KEY `fk_orders_customers` (`cust_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20010 ;

--
-- 转存表中的数据 `orders`
--

INSERT INTO `orders` (`order_num`, `order_date`, `cust_id`) VALUES
(20005, '2005-09-01 00:00:00', 10001),
(20006, '2005-09-12 00:00:00', 10003),
(20007, '2005-09-30 00:00:00', 10004),
(20008, '2005-10-03 00:00:00', 10005),
(20009, '2005-10-08 00:00:00', 10001);

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

--
-- 表的结构 `productnotes`
--

CREATE TABLE IF NOT EXISTS `productnotes` (
  `note_id` int(11) NOT NULL AUTO_INCREMENT,
  `prod_id` char(10) NOT NULL,
  `note_date` datetime NOT NULL,
  `note_text` text,
  PRIMARY KEY (`note_id`),
  FULLTEXT KEY `note_text` (`note_text`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=115 ;

--
-- 转存表中的数据 `productnotes`
--

INSERT INTO `productnotes` (`note_id`, `prod_id`, `note_date`, `note_text`) VALUES
(101, 'TNT2', '2005-08-17 00:00:00', 'Customer complaint:\r\nSticks not individually wrapped, too easy to mistakenly detonate all at once.\r\nRecommend individual wrapping.'),
(102, 'OL1', '2005-08-18 00:00:00', 'Can shipped full, refills not available.\r\nNeed to order new can if refill needed.'),
(103, 'SAFE', '2005-08-18 00:00:00', 'Safe is combination locked, combination not provided with safe.\r\nThis is rarely a problem as safes are typically blown up or dropped by customers.'),
(104, 'FC', '2005-08-19 00:00:00', 'Quantity varies, sold by the sack load.\r\nAll guaranteed to be bright and orange, and suitable for use as rabbit bait.'),
(105, 'TNT2', '2005-08-20 00:00:00', 'Included fuses are short and have been known to detonate too quickly for some customers.\r\nLonger fuses are available (item FU1) and should be recommended.'),
(106, 'TNT2', '2005-08-22 00:00:00', 'Matches not included, recommend purchase of matches or detonator (item DTNTR).'),
(107, 'SAFE', '2005-08-23 00:00:00', 'Please note that no returns will be accepted if safe opened using explosives.'),
(108, 'ANV01', '2005-08-25 00:00:00', 'Multiple customer returns, anvils failing to drop fast enough or falling backwards on purchaser. Recommend that customer considers using heavier anvils.'),
(109, 'ANV03', '2005-09-01 00:00:00', 'Item is extremely heavy. Designed for dropping, not recommended for use with slings, ropes, pulleys, or tightropes.'),
(110, 'FC', '2005-09-01 00:00:00', 'Customer complaint: rabbit has been able to detect trap, food apparently less effective now.'),
(111, 'SLING', '2005-09-02 00:00:00', 'Shipped unassembled, requires common tools (including oversized hammer).'),
(112, 'SAFE', '2005-09-02 00:00:00', 'Customer complaint:\r\nCircular hole in safe floor can apparently be easily cut with handsaw.'),
(113, 'ANV01', '2005-09-05 00:00:00', 'Customer complaint:\r\nNot heavy enough to generate flying stars around head of victim. If being purchased for dropping, recommend ANV02 or ANV03 instead.'),
(114, 'SAFE', '2005-09-07 00:00:00', 'Call from individual trapped in safe plummeting to the ground, suggests an escape hatch be added.\r\nComment forwarded to vendor.');

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

--
-- 表的结构 `products`
--

CREATE TABLE IF NOT EXISTS `products` (
  `prod_id` char(10) NOT NULL,
  `vend_id` int(11) NOT NULL,
  `prod_name` char(255) NOT NULL,
  `prod_price` decimal(8,2) NOT NULL,
  `prod_desc` text,
  PRIMARY KEY (`prod_id`),
  KEY `fk_products_vendors` (`vend_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `products`
--

INSERT INTO `products` (`prod_id`, `vend_id`, `prod_name`, `prod_price`, `prod_desc`) VALUES
('ANV01', 1001, '.5 ton anvil', '5.99', '.5 ton anvil, black, complete with handy hook'),
('ANV02', 1001, '1 ton anvil', '9.99', '1 ton anvil, black, complete with handy hook and carrying case'),
('ANV03', 1001, '2 ton anvil', '14.99', '2 ton anvil, black, complete with handy hook and carrying case'),
('DTNTR', 1003, 'Detonator', '13.00', 'Detonator (plunger powered), fuses not included'),
('FB', 1003, 'Bird seed', '10.00', 'Large bag (suitable for road runners)'),
('FC', 1003, 'Carrots', '2.50', 'Carrots (rabbit hunting season only)'),
('FU1', 1002, 'Fuses', '3.42', '1 dozen, extra long'),
('JP1000', 1005, 'JetPack 1000', '35.00', 'JetPack 1000, intended for single use'),
('JP2000', 1005, 'JetPack 2000', '55.00', 'JetPack 2000, multi-use'),
('OL1', 1002, 'Oil can', '8.99', 'Oil can, red'),
('SAFE', 1003, 'Safe', '50.00', 'Safe with combination lock'),
('SLING', 1003, 'Sling', '4.49', 'Sling, one size fits all'),
('TNT1', 1003, 'TNT (1 stick)', '2.50', 'TNT, red, single stick'),
('TNT2', 1003, 'TNT (5 sticks)', '10.00', 'TNT, red, pack of 10 sticks');

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

--
-- 表的结构 `vendors`
--

CREATE TABLE IF NOT EXISTS `vendors` (
  `vend_id` int(11) NOT NULL AUTO_INCREMENT,
  `vend_name` char(50) NOT NULL,
  `vend_address` char(50) DEFAULT NULL,
  `vend_city` char(50) DEFAULT NULL,
  `vend_state` char(5) DEFAULT NULL,
  `vend_zip` char(10) DEFAULT NULL,
  `vend_country` char(50) DEFAULT NULL,
  PRIMARY KEY (`vend_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1007 ;

--
-- 转存表中的数据 `vendors`
--

INSERT INTO `vendors` (`vend_id`, `vend_name`, `vend_address`, `vend_city`, `vend_state`, `vend_zip`, `vend_country`) VALUES
(1001, 'Anvils R Us', '123 Main Street', 'Southfield', 'MI', '48075', 'USA'),
(1002, 'LT Supplies', '500 Park Street', 'Anytown', 'OH', '44333', 'USA'),
(1003, 'ACME', '555 High Street', 'Los Angeles', 'CA', '90046', 'USA'),
(1004, 'Furball Inc.', '1000 5th Avenue', 'New York', 'NY', '11111', 'USA'),
(1005, 'Jet Set', '42 Galaxy Road', 'London', NULL, 'N16 6PS', 'England'),
(1006, 'Jouets Et Ours', '1 Rue Amusement', 'Paris', NULL, '45678', 'France');

--
-- 限制导出的表
--

--
-- 限制表 `orderitems`
--
ALTER TABLE `orderitems`
  ADD CONSTRAINT `fk_orderitems_products` FOREIGN KEY (`prod_id`) REFERENCES `products` (`prod_id`),
  ADD CONSTRAINT `fk_orderitems_orders` FOREIGN KEY (`order_num`) REFERENCES `orders` (`order_num`);

--
-- 限制表 `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `fk_orders_customers` FOREIGN KEY (`cust_id`) REFERENCES `customers` (`cust_id`);

--
-- 限制表 `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `fk_products_vendors` FOREIGN KEY (`vend_id`) REFERENCES `vendors` (`vend_id`);

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