clean up some regex's for i18n, and eliminate old ereg patterns.

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 36c578961a98e5a2076ad2277dcae0903c074206..ced7573f3bd41d7b1f41f0a40fb838a899f9cad0 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -59,6 +59,7 @@ CREATE TABLE IF NOT EXISTS `contact` (
   `nick` char(255) NOT NULL,
   `photo` text NOT NULL, 
   `thumb` text NOT NULL,
+  `micro` text NOT NULL,
   `site-pubkey` text NOT NULL,
   `issued-id` char(255) NOT NULL,
   `dfrn-id` char(255) NOT NULL,
@@ -170,12 +171,15 @@ CREATE TABLE IF NOT EXISTS `item` (
   `author-link` char(255) NOT NULL,
   `author-avatar` char(255) NOT NULL,
   `title` char(255) NOT NULL,
-  `body` text NOT NULL,
+  `body` mediumtext NOT NULL,
   `verb` char(255) NOT NULL,
   `object-type` char(255) NOT NULL,
   `object` text NOT NULL,
+  `target-type` char(255) NOT NULL,
+  `target` text NOT NULL,
   `resource-id` char(255) NOT NULL,
   `tag` mediumtext NOT NULL,
+  `inform` mediumtext NOT NULL,
   `location` char(255) NOT NULL,
   `coord` char(255) NOT NULL,
   `allow_cid` mediumtext NOT NULL,