Changeset 2333 for trunk/install

Timestamp:

May 6, 2008, 3:04:58 AM (16 years ago)

Author:

rvelices

Message:

• remove some unnecessary db columns (#history_summary.id, #history.year, month, day and hour)

Location:

trunk/install

Files:

• db/71-database.php (added)
• phpwebgallery_structure.sql (modified) (3 diffs)

trunk/install/phpwebgallery_structure.sql

@@ -117 +117 @@
   `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 '',
@@ -139 +135 @@
 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,
@@ -145 +140 @@
   `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;