diff options
| author | friendica <info@friendica.com> | 2012-04-11 16:13:57 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-04-11 16:13:57 -0700 |
| commit | 8a8702c9cd5dde44356da11f5417db6af0597d4e (patch) | |
| tree | 7b50275f011fabbef1a9b4b559ce735e582cb0ff /database.sql | |
| parent | cdb6510b9f3007d2afd3081313caa7d045af1e7c (diff) | |
| download | volse-hubzilla-8a8702c9cd5dde44356da11f5417db6af0597d4e.tar.gz volse-hubzilla-8a8702c9cd5dde44356da11f5417db6af0597d4e.tar.bz2 volse-hubzilla-8a8702c9cd5dde44356da11f5417db6af0597d4e.zip | |
extensible item_id table for managing all the different message-ids generated by multiple services
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 12 |
1 files changed, 4 insertions, 8 deletions
diff --git a/database.sql b/database.sql index 010c63bb2..6824dd1bd 100644 --- a/database.sql +++ b/database.sql @@ -782,16 +782,12 @@ INDEX ( `otype` ) 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 , +`sid` CHAR ( 255 ) NOT NULL, +`service` char ( 255 ) NOT NULL, PRIMARY KEY ( `iid` ), INDEX ( `uid` ), -INDEX ( `face` ), -INDEX ( `dspr` ), -INDEX ( `twit` ), -INDEX ( `stat` ) +INDEX ( `sid` ), +INDEX ( `service` ) ) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `manage` ( |