diff options
| author | Friendika <info@friendika.com> | 2011-09-04 17:35:06 -0700 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2011-09-04 17:35:06 -0700 |
| commit | 481853d2cc44a4bf6c540e72c741ff453305a925 (patch) | |
| tree | c29357adbc460d0e3096ef57e2a4844d44eaaef1 /database.sql | |
| parent | f6a43afb8da061ac13d778eb7fba6e2ea6dda6d7 (diff) | |
| download | volse-hubzilla-481853d2cc44a4bf6c540e72c741ff453305a925.tar.gz volse-hubzilla-481853d2cc44a4bf6c540e72c741ff453305a925.tar.bz2 volse-hubzilla-481853d2cc44a4bf6c540e72c741ff453305a925.zip | |
saved searches on network page
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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; |