From d7920c4c25e99e61cca10cd1c1ae73c5c3cf0cb5 Mon Sep 17 00:00:00 2001 From: friendica Date: Thu, 5 Jul 2012 17:59:56 -0700 Subject: term (tag, mention, category, file, etc.) table --- database.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) (limited to 'database.sql') diff --git a/database.sql b/database.sql index bd57d9fdd..1d0a32176 100644 --- a/database.sql +++ b/database.sql @@ -1000,6 +1000,26 @@ CREATE TABLE IF NOT EXISTS `spam` ( -- -------------------------------------------------------- +-- +-- Table structure for table `term` +-- + +CREATE TABLE IF NOT EXISTS `term` ( + `tid` INT UNSIGNED NOT NULL AUTO_INCREMENT, + `oid` INT UNSIGNED NOT NULL , + `otype` TINYINT( 3 ) UNSIGNED NOT NULL , + `type` TINYINT( 3 ) UNSIGNED NOT NULL , + `term` CHAR( 255 ) NOT NULL , + `url` CHAR( 255 ) NOT NULL, + PRIMARY KEY (`tid`), + KEY `oid` ( `oid` ), + KEY `otype` ( `otype` ), + KEY `type` ( `type` ), + KEY `term` ( `term` ) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + -- -- Table structure for table `tokens` -- -- cgit v1.2.3