diff options
| author | friendica <info@friendica.com> | 2012-01-03 20:26:20 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-01-03 20:26:20 -0800 |
| commit | fc7d0360bb059bf87c5c531a2bfd5bcee3aef3f6 (patch) | |
| tree | 091edb45d73b6bf79534a5d6fbda144b4d81ddf5 /database.sql | |
| parent | 8e6c02cda383b7655ef7c045a1c9cb2c63541b60 (diff) | |
| download | volse-hubzilla-fc7d0360bb059bf87c5c531a2bfd5bcee3aef3f6.tar.gz volse-hubzilla-fc7d0360bb059bf87c5c531a2bfd5bcee3aef3f6.tar.bz2 volse-hubzilla-fc7d0360bb059bf87c5c531a2bfd5bcee3aef3f6.zip | |
add verb and item to notifications to aid in localisation
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 17 |
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; + + |