From 6bf83198df9525391881848a3e84d6cbd6f1e6c5 Mon Sep 17 00:00:00 2001 From: John Klehm Date: Mon, 7 Apr 2008 15:31:07 -0500 Subject: apidb.sql: Add search index table --- tables/appdb_tables.sql | 8 ++++++++ 1 files changed, 8 insertions(+), 0 deletions(-) diff --git a/tables/appdb_tables.sql b/tables/appdb_tables.sql index 2347ea7..3c47c29 100644 --- a/tables/appdb_tables.sql +++ b/tables/appdb_tables.sql @@ -175,3 +175,11 @@ create table appNotes ( key(noteId) ); +drop table if exists searchIndex; +create table searchIndex ( + hash char(32) not null, + name varchar(100) not null, + objectId int unsigned not null, + rank tinyint unsigned not null, + type tinyint unsigned not null +); -- 1.5.4.5