Preparations for a new tag structure. Tags are now stored in a dedicated table.

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 369637fe60c4a938d1bb458ab66d263ab739e719..bc3c1aabd154a0470f29217b3f51c75fa5634e36 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -1118,3 +1118,17 @@ CREATE TABLE IF NOT EXISTS `userd` (
   `username` char(255) NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `tag`
+--
+
+CREATE TABLE IF NOT EXISTS `tag` (
+  `iid` int(11) NOT NULL,
+  `tag` char(255) NOT NULL,
+  `link` char(255) NOT NULL,
+  PRIMARY KEY (`iid`, `tag`),
+  KEY `tag` (`tag`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;