-- phpMyAdmin SQL Dump
-- version 2.11.2.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 07, 2009 at 12:13 PM
-- Server version: 5.0.84
-- PHP Version: 5.2.9
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `search_MusicSearch`
--
-- --------------------------------------------------------
--
-- Table structure for table `mp_usenet_groups`
--
CREATE TABLE IF NOT EXISTS `mp_usenet_groups` (
`id` int(10) unsigned NOT NULL auto_increment,
`server_id` text NOT NULL,
`name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`language` varchar(50) NOT NULL default 'English',
`encoding` varchar(255) NOT NULL default 'UTF-8',
`topic` varchar(255) NOT NULL,
`region` varchar(255) NOT NULL,
`messages_per_month` int(11) NOT NULL default '0',
`members` int(11) NOT NULL default '0',
`days_since_last_post` int(11) NOT NULL default '0',
`article_count` int(11) NOT NULL default '0',
`is_readonly` tinyint(4) NOT NULL,
`is_searched` tinyint(4) NOT NULL,
`member_id` int(11) NOT NULL default '-1',
`created_on` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
FULLTEXT KEY `name_2` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=380960 ;
-- --------------------------------------------------------
--
-- Table structure for table `mp_usenet_servers`
--
CREATE TABLE IF NOT EXISTS `mp_usenet_servers` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`group_count` int(11) NOT NULL,
`processed_on` varchar(50) NOT NULL,
`processed_on_id` varchar(10) NOT NULL default 'no',
`is_searched` tinyint(4) NOT NULL,
`created_on` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2321 ;
|
Stumble It!
Bookmark in del.icio.us
Download
