aboutsummaryrefslogtreecommitdiffstats
path: root/database.sql
diff options
context:
space:
mode:
authorFabio Comuni <fabrix.xm@gmail.com>2012-01-06 09:10:21 +0100
committerFabio Comuni <fabrix.xm@gmail.com>2012-01-06 09:10:21 +0100
commita9670cbb7d2cab644ee9d499aade98164f92631a (patch)
treef136b6448ecd23ec7c987bf26b8d49be25a8aca5 /database.sql
parent93563370c96848948d28ed39e13284ebaf7f430a (diff)
parent53878625f6ecc014283cefbd84f92b6f1294b8a3 (diff)
downloadvolse-hubzilla-a9670cbb7d2cab644ee9d499aade98164f92631a.tar.gz
volse-hubzilla-a9670cbb7d2cab644ee9d499aade98164f92631a.tar.bz2
volse-hubzilla-a9670cbb7d2cab644ee9d499aade98164f92631a.zip
Merge remote-tracking branch 'friendica/master'
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/database.sql b/database.sql
index 4dc1973ed..6826aa6f8 100644
--- a/database.sql
+++ b/database.sql
@@ -751,3 +751,20 @@ INDEX ( `uid` ),
INDEX ( `seen` ),
INDEX ( `date` )
) ENGINE = MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE IF NOT EXISTS `item_id` (
+`iid` INT NOT NULL ,
+`uid` INT NOT NULL ,
+`face` CHAR( 255 ) NOT NULL ,
+`dspr` CHAR( 255 ) NOT NULL ,
+`twit` CHAR( 255 ) NOT NULL ,
+`stat` CHAR( 255 ) NOT NULL ,
+PRIMARY KEY ( `iid` ),
+INDEX ( `uid` ),
+INDEX ( `face` ),
+INDEX ( `dspr` ),
+INDEX ( `twit` ),
+INDEX ( `stat` )
+) ENGINE = MyISAM DEFAULT CHARSET=utf8;
+
+