From d7920c4c25e99e61cca10cd1c1ae73c5c3cf0cb5 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
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

