www.pudn.com > lucene+mysql+eclipe.rar > mysql.sql

CREATE DATABASE LUCENE; 
 
USE LUCENE; 
 
CREATE TABLE `product` ( 
`product_id` int(11) NOT NULL auto_increment, 
`title` varchar(11) default NULL, 
`address` varchar(50) default NULL, 
`descr` text, 
`user_id` int(11) default NULL, 
`user_name` varchar(11) default NULL, 
`upload_time` date default NULL, 
`tag_name` varchar(11) default NULL, 
PRIMARY KEY (`product_id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT; 
 
insert into product values(1,"anycall三星","重庆沙坪坝区","三星手机，来自韩国的品牌",1,"申华锋",now(),"品牌手机"); 
insert into product values(2,"nokia诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机"); 
insert into product values(3,"moto摩托罗拉","重庆沙坪坝区","三星手机，来自美国的品牌",1,"申华锋",now(),"品牌手机"); 
insert into product values(4,"moto摩托罗拉","重庆沙坪坝区","三星手机，来自美国的品牌",1,"申华锋",now(),"品牌手机"); 
insert into product values(5,"nokia诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机"); 
insert into product values(6,"java与模式","重庆渝北区","美籍华人阎宏的作品，对java设计模式有深刻的描述",2,"佐飞",now(),"计算机书籍"); 
insert into product values(7,"j2ee核心模式","重庆渝北区","sun的官方书记，标准的j2ee设计模式讲述",2,"佐飞",now(),"计算机书籍"); 
insert into product values(8,"java编程思想","重庆渝北区","本书赢得了全球程序员的广泛赞誉，即使是最晦涩的概念，在Bruce Eckel的文字亲和力和小而直接的编程示例面前也会化解于无形。",2,"佐飞",now(),"计算机书籍"); 
insert into product values(9,"nokia520诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机"); 
insert into product values(11,"anycall303","重庆沙坪坝区","三星手机，来自韩国的品牌",1,"申华锋",now(),"品牌手机"); 
insert into product values(12,"nokia520诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机"); 
insert into product values(13,"nokia520诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机"); 
insert into product values(14,"nokia520诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机"); 
insert into product values(15,"nokia520诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机"); 
insert into product values(16,"nokia520诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机"); 
insert into product values(25,"nokia32","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机"); 
insert into product values(26,"nokia32","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机"); 
insert into product values(27,"nokia33","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机"); 
insert into product values(28,"3诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机");