[Linpha-cvs] SF.net SVN: linpha: [4835] trunk/linpha2/lib/plugins/maps/sql

[<bz...@us...>]

Revision: 4835
          http://linpha.svn.sourceforge.net/linpha/?rev=4835&view=rev
Author:   bzrudi
Date:     2008-01-30 04:59:00 -0800 (Wed, 30 Jan 2008)

Log Message:
-----------
"don't use uppercase characters in column names, causes PG to stumple upon"

Modified Paths:
--------------
    trunk/linpha2/lib/plugins/maps/sql/sql.data.php
    trunk/linpha2/lib/plugins/maps/sql/sql.mysql.php
    trunk/linpha2/lib/plugins/maps/sql/sql.oci8po.php
    trunk/linpha2/lib/plugins/maps/sql/sql.postgres.php
    trunk/linpha2/lib/plugins/maps/sql/sql.sqlite.php

Modified: trunk/linpha2/lib/plugins/maps/sql/sql.data.php
===================================================================
--- trunk/linpha2/lib/plugins/maps/sql/sql.data.php	2008-01-29 21:18:19 UTC (rev 4834)
+++ trunk/linpha2/lib/plugins/maps/sql/sql.data.php	2008-01-30 12:59:00 UTC (rev 4835)
@@ -18,8 +18,10 @@
 $sql_queries[] = "INSERT INTO ".LIN_PREFIX."config (option_name, option_value, override, user_id) " .
 				 "VALUES ('plugins_maps_markerThumbSize', '350', '0', '0')";
 
-
 $sql_queries[] = "INSERT INTO ".LIN_PREFIX."permissions (perm_type, permission) " .
 				 "VALUES ('plugins_maps_setMarkers', '')";
 
-?>
\ No newline at end of file
+$sql_queries[] = "INSERT INTO ".LIN_PREFIX."config (option_name, option_value, override, user_id) " .
+				 "VALUES ('plugins_maps_enable_geotagged', '0', '0', '0')";				 
+
+?>

Modified: trunk/linpha2/lib/plugins/maps/sql/sql.mysql.php
===================================================================
--- trunk/linpha2/lib/plugins/maps/sql/sql.mysql.php	2008-01-29 21:18:19 UTC (rev 4834)
+++ trunk/linpha2/lib/plugins/maps/sql/sql.mysql.php	2008-01-30 12:59:00 UTC (rev 4835)
@@ -1,14 +1,14 @@
-<?php
-if(!defined('LINPHA_DIR')) { exit(1); }
-
-$sql_tables[] = "CREATE TABLE ".LIN_PREFIX."plugins_maps_markers ( ".
-		"id INT NOT NULL AUTO_INCREMENT, " .
-		"albId INT NOT NULL default '0', " .
-		"albPath VARCHAR(255) NOT NULL default '', " .
-		"markerName VARCHAR(255) NOT NULL default '', " .
-		"markerLat VARCHAR(255) NOT NULL default '', " .
-		"markerLon VARCHAR(255) NOT NULL default '', " .
-		"markerZoom INT NOT NULL default '0', " .
-		"PRIMARY KEY (id) )";
-
+<?php
+if(!defined('LINPHA_DIR')) { exit(1); }
+
+$sql_tables[] = "CREATE TABLE ".LIN_PREFIX."plugins_maps_markers ( ".
+		"id INT NOT NULL AUTO_INCREMENT, " .
+		"albid INT NOT NULL default '0', " .
+		"albpath VARCHAR(255) NOT NULL default '', " .
+		"markername VARCHAR(255) NOT NULL default '', " .
+		"markerlat VARCHAR(255) NOT NULL default '', " .
+		"markerlon VARCHAR(255) NOT NULL default '', " .
+		"markerzoom INT NOT NULL default '0', " .
+		"PRIMARY KEY (id) )";
+
 ?>
\ No newline at end of file

Modified: trunk/linpha2/lib/plugins/maps/sql/sql.oci8po.php
===================================================================
--- trunk/linpha2/lib/plugins/maps/sql/sql.oci8po.php	2008-01-29 21:18:19 UTC (rev 4834)
+++ trunk/linpha2/lib/plugins/maps/sql/sql.oci8po.php	2008-01-30 12:59:00 UTC (rev 4835)
@@ -3,12 +3,12 @@
 
 $sql_tables[] = "CREATE TABLE ".LIN_PREFIX."plugins_maps_markers ( ".
 		"id NUMBER PRIMARY KEY, " .
-		"albId NUMBER(10) DEFAULT '0', " .
-		"albPath VARCHAR(255) NOT NULL default '', " .
-		"markerName VARCHAR(255) NOT NULL default '', " .
-		"markerLat VARCHAR(255) NOT NULL default '', " .
-		"markerLon VARCHAR(255) NOT NULL default '', " .
-		"markerZoom NUMBER(10) DEFAULT '0' )";
+		"albid NUMBER(10) DEFAULT '0', " .
+		"albpath VARCHAR(255) NOT NULL default '', " .
+		"markername VARCHAR(255) NOT NULL default '', " .
+		"markerlat VARCHAR(255) NOT NULL default '', " .
+		"markerlon VARCHAR(255) NOT NULL default '', " .
+		"markerzoom NUMBER(10) DEFAULT '0' )";
 
 /**
  * autoincrement the oracle way ;-)

Modified: trunk/linpha2/lib/plugins/maps/sql/sql.postgres.php
===================================================================
--- trunk/linpha2/lib/plugins/maps/sql/sql.postgres.php	2008-01-29 21:18:19 UTC (rev 4834)
+++ trunk/linpha2/lib/plugins/maps/sql/sql.postgres.php	2008-01-30 12:59:00 UTC (rev 4835)
@@ -1,13 +1,47 @@
-<?php
-if(!defined('LINPHA_DIR')) { exit(1); }
-
-$sql_tables[] = "CREATE TABLE ".LIN_PREFIX."plugins_maps_markers ( ".
-		"id SERIAL PRIMARY KEY, " .
-		"albId INT default '0', " .
-		"albPath VARCHAR(255) NOT NULL default '', " .
-		"markerName VARCHAR(255) NOT NULL default '', " .
-		"markerLat VARCHAR(255) NOT NULL default '', " .
-		"markerLon VARCHAR(255) NOT NULL default '', " .
-		"markerZoom INT NOT NULL default '0' )";
-
-?>
\ No newline at end of file
+<?php
+if(!defined('LINPHA_DIR')) { exit(1); }
+
+$sql_tables[] = "CREATE TABLE ".LIN_PREFIX."plugins_maps_markers ( ".
+		"id SERIAL PRIMARY KEY, " .
+		"albid INT default '0', " .
+		"albpath VARCHAR(255) NOT NULL default '', " .
+		"markername VARCHAR(255) NOT NULL default '', " .
+		"markerlat VARCHAR(255) NOT NULL default '', " .
+		"markerlon VARCHAR(255) NOT NULL default '', " .
+		"markerzoom SMALLINT NOT NULL default '0' )";
+
+$sql_tables[] = "CREATE TABLE ".LIN_PREFIX."plugins_maps_image_geodata ( ".
+		"md5sum CHAR(32) NOT NULL default '', " .
+        "gpsversionid VARCHAR(255) DEFAULT '', " . 
+        "gpslatituderef VARCHAR(255) DEFAULT '', " .
+        "gpslatitude VARCHAR(255) DEFAULT '', " .
+        "gpslongituderef VARCHAR(255) DEFAULT '', " .
+        "gpslongitude VARCHAR(255) DEFAULT '', " .
+        "gpsaltituderef VARCHAR(255) DEFAULT '', " .
+        "gpsaltitude VARCHAR(255) DEFAULT '', " .
+        "gpstimestamp VARCHAR(255) DEFAULT '', " .
+        "gpssatellites VARCHAR(255) DEFAULT '', " .
+        "gpsstatus VARCHAR(255) DEFAULT '', " .
+        "gpsmeasuremode VARCHAR(255) DEFAULT '', " .
+        "gpsdop VARCHAR(255) DEFAULT '', " .
+        "gpsspeedref VARCHAR(255) DEFAULT '', " .
+        "gpsspeed VARCHAR(255) DEFAULT '', " .
+        "gpstrackref VARCHAR(255) DEFAULT '', " .
+        "gpstrack VARCHAR(255) DEFAULT '', " .
+        "gpsimgdirectionref VARCHAR(255) DEFAULT '', " .
+        "gpsimgdirection VARCHAR(255) DEFAULT '', " .
+        "gpsmapdatum VARCHAR(255) DEFAULT '', " .
+        "gpsdestlatituderef VARCHAR(255) DEFAULT '', " .
+        "gpsdestlatitude VARCHAR(255) DEFAULT '', " .
+        "gpsdestlongituderef VARCHAR(255) DEFAULT '', " .
+        "gpsdestlongitude VARCHAR(255) DEFAULT '', " .
+        "gpsdestbearingref VARCHAR(255) DEFAULT '', " .
+        "gpsdestbearing VARCHAR(255) DEFAULT '', " .
+        "gpsdestdistanceref VARCHAR(255) DEFAULT '', " .
+        "gpsdestdistance VARCHAR(255) DEFAULT '', " .
+        "gpsprocessingmethod VARCHAR(255) DEFAULT '', " .
+        "gpsareainformation VARCHAR(255) DEFAULT '', " .
+        "gpsdatestamp VARCHAR(255) DEFAULT '', " .
+        "gpsdatetime VARCHAR(255) DEFAULT '', " .
+        "gpsposition VARCHAR(255) DEFAULT '' )";
+?>

Modified: trunk/linpha2/lib/plugins/maps/sql/sql.sqlite.php
===================================================================
--- trunk/linpha2/lib/plugins/maps/sql/sql.sqlite.php	2008-01-29 21:18:19 UTC (rev 4834)
+++ trunk/linpha2/lib/plugins/maps/sql/sql.sqlite.php	2008-01-30 12:59:00 UTC (rev 4835)
@@ -1,13 +1,13 @@
-<?php
-if(!defined('LINPHA_DIR')) { exit(1); }
-
-$sql_tables[] = "CREATE TABLE ".LIN_PREFIX."plugins_maps_markers ( ".
-		"id INTEGER PRIMARY KEY, " .
-		"albId INTEGER NOT NULL default '0', " .
-		"albPath VARCHAR(255) NOT NULL default '', " .
-		"markerName VARCHAR(255) NOT NULL default '', " .
-		"markerLat VARCHAR(255) NOT NULL default '', " .
-		"markerLon VARCHAR(255) NOT NULL default '', " .
-		"markerZoom INTEGER NOT NULL default '0' )";
-
+<?php
+if(!defined('LINPHA_DIR')) { exit(1); }
+
+$sql_tables[] = "CREATE TABLE ".LIN_PREFIX."plugins_maps_markers ( ".
+		"id INTEGER PRIMARY KEY, " .
+		"albid INTEGER NOT NULL default '0', " .
+		"albpath VARCHAR(255) NOT NULL default '', " .
+		"markername VARCHAR(255) NOT NULL default '', " .
+		"markerlat VARCHAR(255) NOT NULL default '', " .
+		"markerlon VARCHAR(255) NOT NULL default '', " .
+		"markerzoom INTEGER NOT NULL default '0' )";
+
 ?>
\ No newline at end of file


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.