# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : gnutella

# --------------------------------------------------------
#
# Table structure for table 'search_results'
#

DROP TABLE IF EXISTS search_results;
CREATE TABLE search_results (
   search_id int(11) NOT NULL,
   hosts int(11) NOT NULL,
   files int(11) NOT NULL,
   messages int(11) NOT NULL,
   PRIMARY KEY (search_id)
);


# --------------------------------------------------------
#
# Table structure for table 'search_words'
#

DROP TABLE IF EXISTS search_words;
CREATE TABLE search_words (
   search_id int(11) NOT NULL,
   word varchar(100) NOT NULL,
   KEY search_id (search_id),
   KEY word (word)
);


# --------------------------------------------------------
#
# Table structure for table 'searches'
#

DROP TABLE IF EXISTS searches;
CREATE TABLE searches (
   search_id int(11) NOT NULL auto_increment,
   search_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   ip varchar(16) NOT NULL,
   host varchar(100) NOT NULL,
   timeout int(11) NOT NULL,
   PRIMARY KEY (search_id)
);