www.pudn.com > lucene_book(1).rar > script.sql, change:2007-03-08,size:321b


create database searchdb; 
use searchdb; 
create table product ( 
	 id   int AUTO_INCREMENT, 
	 category varchar(128), 
	 name varchar(128), 
	 type varchar(128), 
	 content varchar(20000), 
	 abstractcontent varchar(512), 
	 url varchar(512), 
	 imageurl varchar(128), 
	 updatedtime varchar(64), 
	 primary key(id) 
	);