Changeset 25801 for trunk/install/piwigo_structure-mysql.sql

Timestamp:

Dec 6, 2013, 8:14:44 PM (10 years ago)

Author:

mistic100

Message:

feature 3009: Add 'latitude' and 'longitude' fields in images table

File:

• trunk/install/piwigo_structure-mysql.sql (modified) (2 diffs)

trunk/install/piwigo_structure-mysql.sql

@@ -197 +197 @@
   `md5sum` char(32) default NULL,
   `added_by` smallint(5) NOT NULL default '0',
-  `rotation` tinyint unsigned default null,
+  `rotation` tinyint unsigned default NULL,
+  `latitude` double(8, 6) default NULL,
+  `longitude` double(9, 6) default NULL,
   PRIMARY KEY  (`id`),
   KEY `images_i2` (`date_available`),
@@ -203 +205 @@
   KEY `images_i4` (`hit`),
   KEY `images_i5` (`date_creation`),
-  KEY `images_i1` (`storage_category_id`)
+  KEY `images_i1` (`storage_category_id`),
+  KEY `images_i6` (`latitude`)
 ) ENGINE=MyISAM;