add rating feature

git-svn-id: http://piwigo.org/svn/trunk@507 68402e56-0260-453c-a942-63ccdbb3a9ee

1 files changed, 13 insertions, 0 deletions

diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql
index 06ea1cebf..3a387603b 100644
--- a/install/phpwebgallery_structure.sql
+++ b/install/phpwebgallery_structure.sql
@@ -137,12 +137,25 @@ CREATE TABLE phpwebgallery_images (
   storage_category_id smallint(5) unsigned default NULL,
   representative_ext varchar(4) default NULL,
   date_metadata_update date default NULL,
+  average_rate float(5,2) unsigned default NULL,
   PRIMARY KEY  (id),
   KEY images_i2 (date_available),
   KEY images_i1 (storage_category_id)
 ) TYPE=MyISAM;
 
 --
+-- Table structure for table 'phpwebgallery_rate'
+--
+
+DROP TABLE IF EXISTS phpwebgallery_rate;
+CREATE TABLE phpwebgallery_rate (
+  user_id smallint(5) unsigned NOT NULL default '0',
+  element_id mediumint(8) unsigned NOT NULL default '0',
+  rate tinyint(2) unsigned NOT NULL default '0',
+  PRIMARY KEY  (user_id,element_id)
+) TYPE=MyISAM;
+
+--
 -- Table structure for table 'phpwebgallery_sessions'
 --