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 a3d78d79a3201396bb9cb4eed4c54a75e7d5e120..ced7573f3bd41d7b1f41f0a40fb838a899f9cad0 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -56,8 +56,10 @@ CREATE TABLE IF NOT EXISTS `contact` (
   `duplex` tinyint(1) NOT NULL DEFAULT '0',
   `network` char(255) NOT NULL,
   `name` char(255) NOT NULL,
+  `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,
@@ -169,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,