# SCORES TABLE
# =============================================================================
# Table structure for table 'Links_Scores_Index'
#

$Links_Scores_Index = qq~
CREATE TABLE Links_Scores_Index (
WordID mediumint(8) unsigned DEFAULT '0' NOT NULL,
item int(11) DEFAULT '0' NOT NULL,
score smallint(5) unsigned DEFAULT '0' NOT NULL,
position mediumint(8) unsigned DEFAULT '0' NOT NULL,
KEY WordID (WordID),
KEY item (item)
)
~;

# WORDS TABLE
# =============================================================================
# Table structure for table 'Links_Word_Index'
#

$Links_Word_Index = qq~
CREATE TABLE Links_Word_Index (
WordID mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
Word varchar(50) NOT NULL,
Frequency smallint(5) unsigned,
PRIMARY KEY (WordID),
UNIQUE Word (Word)
)
~;

%TABLES = (
Links => $Links, Category => $Category, Search_Log => $Search_Log,
CategoryHeiarchy => $CategoryHeiarchy, CategoryRelations => $CategoryRelations,
CategoryAlternates => $CategoryAlternates, Validate => $Validate, Users => $Users,
Sessions => $Sessions, Editors => $Editors, Subscribe => $Subscribe, Hits_Track => $Hits_Track,
Rate_Track => $Rate_Track, Build_Update => $Build_Update, Verify => $Verify,
Links_Word_Index => $Links_Word_Index, Links_Scores_Index => $Links_Scores_Index
);