From 481853d2cc44a4bf6c540e72c741ff453305a925 Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Sun, 4 Sep 2011 17:35:06 -0700
Subject: saved searches on network page

---
 database.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index 432ce7693..343d4c497 100644
--- a/database.sql
+++ b/database.sql
@@ -613,3 +613,11 @@ CREATE TABLE IF NOT EXISTS `deliverq` (
 `item` INT NOT NULL ,
 `contact` INT NOT NULL
 ) ENGINE = MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE IF NOT EXISTS `search` (
+`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`uid` INT NOT NULL ,
+`term` CHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
+INDEX ( `uid` ),
+INDEX ( `term` )
+) ENGINE = MyISAM DEFAULT CHARSET=utf8;
-- 
cgit v1.2.3

