# --------------------------------------------------------------------------
#
# INDEXU(tm) v.3.0.3
# Copyright(C), Sentraweb, 2001, All Rights Reserved.
#
# INDEXU(tm) is protected by Indonesia and International copyright laws.
# Unauthorized use or distribution of INDEXU(tm) is strictly prohibited,
# violators will be prosecuted. To obtain a license for using INDEXU(tm), 
# please register at INDEXU home page at http:#www.indexu.com/
#
# Author: Dody Rachmat Wicaksono (dody@sentraweb.com) 
#
# 26-Des-2001
#
# --------------------------------------------------------------------------



# --------------------------------------------------------
#
# Table structure for table 'idx_bad_link'
#

CREATE TABLE idx_bad_link (
   bad_link_id mediumint(8) unsigned NOT NULL auto_increment,
   link_id mediumint(8) unsigned NOT NULL,
   name varchar(50) NOT NULL,
   email varchar(50) NOT NULL,
   type tinyint(3) unsigned NOT NULL,
   date date DEFAULT '0000-00-00' NOT NULL,
   PRIMARY KEY (bad_link_id)
);

#
# Dumping data for table 'idx_bad_link'
#

INSERT INTO idx_bad_link VALUES( '1', '75', '', '', '5', '2001-10-07');
INSERT INTO idx_bad_link VALUES( '2', '3', '', '', '0', '2001-12-19');

# --------------------------------------------------------
#
# Table structure for table 'idx_category'
#

CREATE TABLE idx_category (
   category_id smallint(5) unsigned NOT NULL auto_increment,
   parent_id smallint(5) unsigned NOT NULL,
   name varchar(100) NOT NULL,
   description text NOT NULL,
   image varchar(100),
   content text,
   visible char(1),
   links mediumint(9),
   meta_keyword text,
   meta_description text,
   permission char(2),
   registered_only char(1),
   PRIMARY KEY (category_id)
);

#
# Dumping data for table 'idx_category'
#

INSERT INTO idx_category VALUES( '4', '0', 'Anime Web', 'halowww .. descnya anieweb', '', '', '1', '68', '', '', '0', '0');
INSERT INTO idx_category VALUES( '5', '4', 'Adopt', 'desc . ..nya', '', '', '1', '5', '', '', '1', '0');
INSERT INTO idx_category VALUES( '6', '4', 'Awards', 'desc . ..nya lagi', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '7', '4', 'Link Exchange', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '8', '4', 'Link List', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '9', '4', 'Search Engines', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '11', '4', 'Top Sites', '', '', '', '1', '1', '', '', '1', '0');
INSERT INTO idx_category VALUES( '12', '4', 'Voting', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '13', '4', 'Webrings', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '14', '0', 'Clubs', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '15', '14', 'Email', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '16', '14', 'International', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '17', '14', 'United States', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '18', '14', 'Yahoo', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '19', '0', 'Commercial', '', '', '', '1', '1', '', '', '1', '0');
INSERT INTO idx_category VALUES( '20', '0', 'Japan', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '21', '19', 'Shopping Guides', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '22', '19', 'United_States', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '23', '0', 'Entertainment', '', '', 'halllooooowwww !!!!!<br>ini contentnya ... !! \"hoho\"', '1', '2', '', '', '1', '0');
INSERT INTO idx_category VALUES( '24', '23', 'Chats', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '25', '23', 'Magazines', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '26', '23', 'Mangas', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '27', '23', 'Movies', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '28', '23', 'Musics', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '29', '23', 'News', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '30', '23', 'Reviews', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '31', '23', 'Softwares', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '32', '0', 'Fandom', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '33', '32', 'Conventions', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '34', '32', 'Fan Art', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '35', '32', 'Fan Fiction', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '36', '0', 'Fan Mangas', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '37', '0', 'Images', '', '', '', '0', '2', '', '', '0', '0');
INSERT INTO idx_category VALUES( '38', '37', 'Cells', '', '', '', '0', '1', '', '', '1', '0');
INSERT INTO idx_category VALUES( '39', '37', 'Themes', '', '', '', '0', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '40', '37', 'Wallpaper', '', '', '', '0', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '41', '0', 'Resources', '', 'email.gif', '', '1', '0', '', '', '0', '1');
INSERT INTO idx_category VALUES( '42', '41', 'FTP', '', '', '', '1', '0', '', '', '1', '1');
INSERT INTO idx_category VALUES( '43', '41', 'Guides', '', '', '', '1', '0', '', '', '1', '1');
INSERT INTO idx_category VALUES( '44', '41', 'Mailing List', '', '', '', '1', '1', '', '', '1', '1');
INSERT INTO idx_category VALUES( '45', '41', 'Manga Artists', '', '', '', '1', '0', '', '', '1', '1');
INSERT INTO idx_category VALUES( '46', '41', 'News Groups', '', '', '', '1', '0', '', '', '1', '1');
INSERT INTO idx_category VALUES( '47', '41', 'Production Studios', '', '', '', '1', '0', '', '', '1', '1');
INSERT INTO idx_category VALUES( '48', '41', 'Web Hosting', '', '', '', '1', '0', '', '', '1', '1');
INSERT INTO idx_category VALUES( '49', '0', 'Series', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '50', '37', 'How to draw', '', '', '', '0', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '55', '4', 'coba juga', '', '', '', '1', '0', '', '', '1', '0');
INSERT INTO idx_category VALUES( '57', '48', 'qweqw', '', 'folder.gif', '', '1', '0', '', '', '0', '1');
INSERT INTO idx_category VALUES( '58', '49', 'asdas', 'dasd', 'folder.gif', '', '1', '0', '', '', '0', '0');

# --------------------------------------------------------
#
# Table structure for table 'idx_category_in_order'
#

CREATE TABLE idx_category_in_order (
   category_id smallint(5) unsigned
);

#
# Dumping data for table 'idx_category_in_order'
#


# --------------------------------------------------------
#
# Table structure for table 'idx_editor'
#

CREATE TABLE idx_editor (
   username varchar(20),
   category_id smallint(5),
   category char(1),
   link char(1),
   review char(1),
   pick char(1),
   status char(1),
   date date
);

#
# Dumping data for table 'idx_editor'
#

INSERT INTO idx_editor VALUES( 'emon', '4', '1', '1', '1', '1', '1', '2001-10-20');
INSERT INTO idx_editor VALUES( 'celes', '4', '1', '1', '1', '1', '1', '2001-10-20');
INSERT INTO idx_editor VALUES( 'dody', '11', '1', '1', '1', '1', '1', '2001-10-20');
INSERT INTO idx_editor VALUES( 'emon', '13', '1', '1', '1', '1', '1', '2001-10-20');
INSERT INTO idx_editor VALUES( 'celes', '13', '1', '1', '1', '1', '1', '2001-10-20');
INSERT INTO idx_editor VALUES( 'dody', '23', '1', '1', '1', '1', '1', '2001-11-05');

# --------------------------------------------------------
#
# Table structure for table 'idx_favorites'
#

CREATE TABLE idx_favorites (
   favorite_id int(11) NOT NULL auto_increment,
   username varchar(20),
   date date,
   title varchar(100),
   description text,
   PRIMARY KEY (favorite_id)
);

#
# Dumping data for table 'idx_favorites'
#


# --------------------------------------------------------
#
# Table structure for table 'idx_favorites_detail'
#

CREATE TABLE idx_favorites_detail (
   favorite_id int(11),
   link_id mediumint(9)
);

#
# Dumping data for table 'idx_favorites_detail'
#


# --------------------------------------------------------
#
# Table structure for table 'idx_link'
#

CREATE TABLE idx_link (
   link_id mediumint(8) unsigned NOT NULL auto_increment,
   category_id smallint(5) unsigned NOT NULL,
   title varchar(100) NOT NULL,
   url text NOT NULL,
   description text NOT NULL,
   contact_name varchar(100) NOT NULL,
   email varchar(100) NOT NULL,
   hits mediumint(9),
   votes smallint(6),
   rating float(4,2),
   date date DEFAULT '0000-00-00' NOT NULL,
   bid smallint(6),
   new char(1),
   hot char(1),
   top_rated char(1),
   pick char(1),
   password varchar(20),
   updated char(1),
   reviews smallint(6),
   avg_review float(4,2),
   last_updated date,
   logo varchar(251),
   PRIMARY KEY (link_id)
);

#
# Dumping data for table 'idx_link'
#

INSERT INTO idx_link VALUES( '1', '5', 'Japangames', 'http://come.to/japan-animation', 'total up a lot of japan animation in this Sites that can open your vision to the world of animation', 'kelry', 'kelry2@hotmail.com', '0', '1', '2.00', '1999-09-01', '0', '1', '0', '1', '1', '1111', '1', '0', '0.00', '2001-12-17', '');

# --------------------------------------------------------
#
# Table structure for table 'idx_link_temp'
#

CREATE TABLE idx_link_temp (
   vid mediumint(8) unsigned NOT NULL auto_increment,
   link_id mediumint(8),
   category_id smallint(5) unsigned NOT NULL,
   title varchar(100) NOT NULL,
   url text NOT NULL,
   description text NOT NULL,
   contact_name varchar(100) NOT NULL,
   email varchar(100) NOT NULL,
   hits mediumint(9),
   votes smallint(6),
   rating float(4,2),
   date date DEFAULT '0000-00-00' NOT NULL,
   bid smallint(6),
   new char(1),
   hot char(1),
   top_rated char(1),
   pick char(1),
   password varchar(20),
   updated char(1),
   reviews smallint(6),
   avg_review float(4,2),
   last_updated date,
   logo varchar(251),
   PRIMARY KEY (vid)
);

#
# Dumping data for table 'idx_link_temp'
#

INSERT INTO idx_link_temp VALUES( '8', '25', '12', 'Z Team Software\'s', 'http://www.gibbed.com/zteam', 'Dragon Ball Quake TC for Quake and Quake 2\'s', 'James Vandenberg', 'dweezil@ipgnet.com', '0', '0', '0.00', '2001-12-19', '0', '', '', '', '', NULL, '', '0', '0.00', '2001-12-19', '');
INSERT INTO idx_link_temp VALUES( '3', NULL, '5', 'sdf', 'http://sdfsd', 'sdf', 'sfddfsd', 'sdf@dsffd', '0', '0', '0.00', '2001-12-19', '0', '0', '0', '0', '0', '4979', '0', '0', '0.00', '0000-00-00', '');
INSERT INTO idx_link_temp VALUES( '2', NULL, '5', 'sdf', 'http://sdfzx', 'zxczxc', 'zxczxc', 'zxc@dfsf', '0', '0', '0.00', '2001-12-19', '0', '0', '0', '0', '0', '6332', '0', '0', '0.00', '0000-00-00', '');
INSERT INTO idx_link_temp VALUES( '4', NULL, '5', 'sdf', 'http://sdfsd', 'sdf', 'sfddfsd', 'sdf@dsffd', '0', '0', '0.00', '2001-12-19', '0', '0', '0', '0', '0', '8581', '0', '0', '0.00', '0000-00-00', '');
INSERT INTO idx_link_temp VALUES( '5', NULL, '5', 'sdf', 'http://sdfsd', 'sdf', 'sfddfsd', 'sdf@dsffd', '0', '0', '0.00', '2001-12-19', '0', '0', '0', '0', '0', '3716', '0', '0', '0.00', '0000-00-00', '');
INSERT INTO idx_link_temp VALUES( '6', NULL, '5', 'sdf', 'http://sdfsd', 'sdf', 'sfddfsd', 'sdf@dsffd', '0', '0', '0.00', '2001-12-19', '0', '0', '0', '0', '0', '5135', '0', '0', '0.00', '0000-00-00', '');
INSERT INTO idx_link_temp VALUES( '7', NULL, '5', 'sdf', 'http://sdfsd', 'sdf', 'sfddfsd', 'sdf@dsffd', '0', '0', '0.00', '2001-12-19', '0', '0', '0', '0', '0', '4561', '0', '0', '0.00', '0000-00-00', '');

# --------------------------------------------------------
#
# Table structure for table 'idx_mailing_list'
#

CREATE TABLE idx_mailing_list (
   email varchar(100) NOT NULL,
   code varchar(4),
   status char(1),
   PRIMARY KEY (email)
);

#
# Dumping data for table 'idx_mailing_list'
#

INSERT INTO idx_mailing_list VALUES( 'dody@localhost.pc', '', '1');
INSERT INTO idx_mailing_list VALUES( 'dody2@localhost.pc', '', '1');
INSERT INTO idx_mailing_list VALUES( 'dody3@localhost.pc', '', '1');

# --------------------------------------------------------
#
# Table structure for table 'idx_message'
#

CREATE TABLE idx_message (
   message_id smallint(6) NOT NULL auto_increment,
   date date,
   body text,
   subject varchar(100),
   PRIMARY KEY (message_id)
);

#
# Dumping data for table 'idx_message'
#

INSERT INTO idx_message VALUES( '1', '2001-10-22', 'fs fsdfsd sdf sdf sd', 'sdfsd');

# --------------------------------------------------------
#
# Table structure for table 'idx_rating'
#

CREATE TABLE idx_rating (
   rating tinyint(3) unsigned NOT NULL,
   name varchar(20)
);

#
# Dumping data for table 'idx_rating'
#


# --------------------------------------------------------
#
# Table structure for table 'idx_review'
#

CREATE TABLE idx_review (
   review_id mediumint(8) unsigned NOT NULL auto_increment,
   link_id mediumint(8) unsigned NOT NULL,
   review text NOT NULL,
   rating tinyint(3) unsigned NOT NULL,
   date date DEFAULT '0000-00-00' NOT NULL,
   subject varchar(100),
   status char(1),
   username varchar(20),
   PRIMARY KEY (review_id)
);

#
# Dumping data for table 'idx_review'
#

INSERT INTO idx_review VALUES( '1', '75', 'tok!!!', '5', '2001-11-07', 'tesssssssssssssssss', '1', 'dody');
INSERT INTO idx_review VALUES( '2', '75', 'asddas', '3', '2001-12-10', 'asd', '1', 'admin');
INSERT INTO idx_review VALUES( '3', '75', 'sdf', '2', '2001-12-10', 'sdf', '1', 'admin');
INSERT INTO idx_review VALUES( '4', '3', 'dfgdfg', '3', '2001-12-19', 'dsfg', '1', 'dody');

# --------------------------------------------------------
#
# Table structure for table 'idx_searchlog'
#

CREATE TABLE idx_searchlog (
   keyword varchar(100) NOT NULL,
   time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   ip varchar(100),
   result mediumint(8) unsigned
);

#
# Dumping data for table 'idx_searchlog'
#

INSERT INTO idx_searchlog VALUES( 'web', '2001-10-30 05:58:40', '127.0.0.1', '5');
INSERT INTO idx_searchlog VALUES( 'ani', '2001-10-30 05:58:59', '127.0.0.1', '34');
INSERT INTO idx_searchlog VALUES( 'ani', '2001-10-30 06:27:46', '127.0.0.1', '34');
INSERT INTO idx_searchlog VALUES( 'ani', '2001-10-31 01:58:34', '127.0.0.1', '34');
INSERT INTO idx_searchlog VALUES( 'ani', '2001-12-03 07:30:41', '127.0.0.1', '34');
INSERT INTO idx_searchlog VALUES( 'miyuki', '2001-12-10 08:44:41', '127.0.0.1', '1');
INSERT INTO idx_searchlog VALUES( 'miyuki', '2001-12-10 08:44:45', '127.0.0.1', '1');
INSERT INTO idx_searchlog VALUES( 'ani', '2001-12-17 03:34:09', '127.0.0.1', '34');
INSERT INTO idx_searchlog VALUES( 'ani', '2001-12-17 03:36:23', '127.0.0.1', '34');
INSERT INTO idx_searchlog VALUES( 'pok', '2001-12-17 03:36:52', '127.0.0.1', '4');
INSERT INTO idx_searchlog VALUES( 'pok', '2001-12-17 03:37:30', '127.0.0.1', '4');
INSERT INTO idx_searchlog VALUES( 'ent', '2001-12-17 03:37:40', '127.0.0.1', '5');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-17 03:37:51', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'ser', '2001-12-17 03:37:57', '127.0.0.1', '4');
INSERT INTO idx_searchlog VALUES( 'ani', '2001-12-17 03:38:02', '127.0.0.1', '34');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-17 03:40:15', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-17 03:41:00', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'xxx', '2001-12-17 05:51:47', '127.0.0.1', '1');
INSERT INTO idx_searchlog VALUES( 'japa', '2001-12-17 05:53:40', '127.0.0.1', '2');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 02:42:38', '127.0.0.1', '4');
INSERT INTO idx_searchlog VALUES( 'vot', '2001-12-20 02:42:53', '127.0.0.1', '1');
INSERT INTO idx_searchlog VALUES( 'ani', '2001-12-20 02:43:22', '127.0.0.1', '34');
INSERT INTO idx_searchlog VALUES( 'news', '2001-12-20 02:43:50', '127.0.0.1', '0');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 02:44:33', '127.0.0.1', '5');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 02:45:16', '127.0.0.1', '5');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 02:57:02', '127.0.0.1', '4');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 02:57:25', '127.0.0.1', '4');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 02:58:31', '127.0.0.1', '4');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 02:58:50', '127.0.0.1', '4');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 03:00:21', '127.0.0.1', '4');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 03:00:56', '127.0.0.1', '4');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 03:02:21', '127.0.0.1', '4');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 03:02:45', '127.0.0.1', '4');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 03:03:10', '127.0.0.1', '3');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 03:05:03', '127.0.0.1', '3');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 03:05:04', '127.0.0.1', '3');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 03:06:37', '127.0.0.1', '3');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 03:07:24', '127.0.0.1', '4');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 03:16:19', '127.0.0.1', '3');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 05:40:03', '127.0.0.1', '5');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 05:40:51', '127.0.0.1', '10');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 05:40:56', '127.0.0.1', '5');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:31:10', '127.0.0.1', '10');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:31:43', '127.0.0.1', '10');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:32:10', '127.0.0.1', '10');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:32:22', '127.0.0.1', '10');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:32:39', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:33:15', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:33:56', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:34:12', '127.0.0.1', '10');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:34:27', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:34:37', '127.0.0.1', '10');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:35:22', '127.0.0.1', '10');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:35:30', '127.0.0.1', '10');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:40:00', '127.0.0.1', '10');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:40:02', '127.0.0.1', '10');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:40:14', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:40:32', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:40:38', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:42:29', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:42:46', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:42:49', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:43:11', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:43:13', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:43:33', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:43:49', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:44:22', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:44:40', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:47:08', '127.0.0.1', '10');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:47:23', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:48:17', '127.0.0.1', '9');
INSERT INTO idx_searchlog VALUES( 'res', '2001-12-20 06:48:37', '127.0.0.1', '10');
INSERT INTO idx_searchlog VALUES( 'ima', '2001-12-20 06:52:52', '127.0.0.1', '4');

# --------------------------------------------------------
#
# Table structure for table 'idx_users'
#

CREATE TABLE idx_users (
   username varchar(20),
   password varchar(20),
   name varchar(50),
   email varchar(50),
   theme varchar(20),
   date date,
   status char(1),
   vcode varchar(4),
   group_id tinyint(4),
   homepage varchar(100),
   icq varchar(20),
   aol varchar(20),
   yahoo varchar(20),
   biography text,
   location varchar(50),
   interest varchar(50),
   occupation varchar(50),
   nol_category tinyint(4),
   nol_search tinyint(4)
);

#
# Dumping data for table 'idx_users'
#

INSERT INTO idx_users VALUES( 'admin', 'admin', NULL, 'dody@localhost.pc', NULL, NULL, '1', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO idx_users VALUES( 'dody', 'dody', '', 'dody@localhost.pc', '', '2001-10-20', '1', '6809', '1', 'http://', '', '', '', '', '', '', '', NULL, NULL);
INSERT INTO idx_users VALUES( 'emon', 'emon', '', 'emon@localhost.pc', '', '2001-10-20', '1', '4396', '1', 'http://', '', '', '', '', '', '', '', NULL, NULL);
INSERT INTO idx_users VALUES( 'celes', 'celes', '', 'celes@localhost.pc', '', '2001-10-20', '1', '5674', '1', 'http://', '', '', '', '', '', '', '', NULL, NULL);

# --------------------------------------------------------
#
# Table structure for table 'idx_votes'
#

CREATE TABLE idx_votes (
   link_id mediumint(9),
   ip varchar(100),
   value tinyint(4)
);

#
# Dumping data for table 'idx_votes'
#

INSERT INTO idx_votes VALUES( '75', '127.0.0.1', '5');
INSERT INTO idx_votes VALUES( '32', '127.0.0.1', '5');
INSERT INTO idx_votes VALUES( '34', '127.0.0.1', '2');
INSERT INTO idx_votes VALUES( '20', '127.0.0.1', '4');
INSERT INTO idx_votes VALUES( '75', '', '4');
INSERT INTO idx_votes VALUES( '8', '127.0.0.1', '3');
INSERT INTO idx_votes VALUES( '5', '127.0.0.1', '4');
INSERT INTO idx_votes VALUES( '5', '127.0.0.1', '3');
INSERT INTO idx_votes VALUES( '5', '127.0.0.1', '1');
INSERT INTO idx_votes VALUES( '5', '127.0.0.1', '3');
INSERT INTO idx_votes VALUES( '5', '127.0.0.1', '2');
INSERT INTO idx_votes VALUES( '5', '127.0.0.1', '5');
INSERT INTO idx_votes VALUES( '5', '127.0.0.1', '2');
INSERT INTO idx_votes VALUES( '81', '127.0.0.1', '4');
INSERT INTO idx_votes VALUES( '73', '127.0.0.1', '1');
INSERT INTO idx_votes VALUES( '72', '127.0.0.1', '3');
INSERT INTO idx_votes VALUES( '76', '127.0.0.1', '1');
INSERT INTO idx_votes VALUES( '69', '127.0.0.1', '2');
INSERT INTO idx_votes VALUES( '68', '127.0.0.1', '4');
INSERT INTO idx_votes VALUES( '119', '127.0.0.1', '3');
INSERT INTO idx_votes VALUES( '3', '127.0.0.1', '1');
INSERT INTO idx_votes VALUES( '1', '127.0.0.1', '2');
INSERT INTO idx_votes VALUES( '75', '127.0.0.1', '5');
INSERT INTO idx_votes VALUES( '75', '127.0.0.1', '3');
INSERT INTO idx_votes VALUES( '75', '127.0.0.1', '2');
INSERT INTO idx_votes VALUES( '75', '127.0.0.1', '2');
INSERT INTO idx_votes VALUES( '75', '127.0.0.1', '2');
INSERT INTO idx_votes VALUES( '75', '127.0.0.1', '1');
INSERT INTO idx_votes VALUES( '75', '127.0.0.1', '1');
INSERT INTO idx_votes VALUES( '75', '127.0.0.1', '1');
INSERT INTO idx_votes VALUES( '129', '127.0.0.1', '3');

