From 5dbad41e2e125b6a55e85c5588d96b68f6486ef4 Mon Sep 17 00:00:00 2001
From: rvelices <rv-github@modusoptimus.com>
Date: Tue, 6 May 2008 01:04:58 +0000
Subject: - remove some unnecessary db columns (#history_summary.id,
 #history.year, month, day and hour)

git-svn-id: http://piwigo.org/svn/trunk@2333 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 install/phpwebgallery_structure.sql | 7 +------
 1 file changed, 1 insertion(+), 6 deletions(-)

(limited to 'install/phpwebgallery_structure.sql')

diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql
index 452d9f7a7..f34b2f571 100644
--- a/install/phpwebgallery_structure.sql
+++ b/install/phpwebgallery_structure.sql
@@ -116,10 +116,6 @@ CREATE TABLE `phpwebgallery_history` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `date` date NOT NULL default '0000-00-00',
   `time` time NOT NULL default '00:00:00',
-  `year` smallint(4) NOT NULL default '0',
-  `month` tinyint(2) NOT NULL default '0',
-  `day` tinyint(2) NOT NULL default '0',
-  `hour` tinyint(2) NOT NULL default '0',
   `user_id` smallint(5) NOT NULL default '0',
   `IP` varchar(15) NOT NULL default '',
   `section` enum('categories','tags','search','list','favorites','most_visited','best_rated','recent_pics','recent_cats') default NULL,
@@ -138,13 +134,12 @@ CREATE TABLE `phpwebgallery_history` (
 
 DROP TABLE IF EXISTS `phpwebgallery_history_summary`;
 CREATE TABLE `phpwebgallery_history_summary` (
-  `id` varchar(13) NOT NULL default '',
   `year` smallint(4) NOT NULL default '0',
   `month` tinyint(2) default NULL,
   `day` tinyint(2) default NULL,
   `hour` tinyint(2) default NULL,
   `nb_pages` int(11) default NULL,
-  PRIMARY KEY  (`id`)
+  UNIQUE KEY history_summary_ymdh (`year`,`month`,`day`,`hour`)
 ) TYPE=MyISAM;
 
 --
-- 
cgit v1.2.3

