diff options
| author | fisharebest <fisharebest@gmail.com> | 2011-02-24 19:22:36 +0000 |
|---|---|---|
| committer | fisharebest <fisharebest@gmail.com> | 2011-02-24 19:22:36 +0000 |
| commit | aefcd22481ea2a5401545751c95f1eb6b203c04d (patch) | |
| tree | 323067a4892ebca01139ea1a73b13b93f48fdaa0 | |
| parent | 8d9d1cd59a59431e7082d679587edacc88916992 (diff) | |
| download | webtrees-aefcd22481ea2a5401545751c95f1eb6b203c04d.tar.gz webtrees-aefcd22481ea2a5401545751c95f1eb6b203c04d.tar.bz2 webtrees-aefcd22481ea2a5401545751c95f1eb6b203c04d.zip | |
(1) Fix: SQL syntax errors (2) sv_lati/long should be floats?
| -rw-r--r-- | modules/googlemap/db_schema/db_schema_1_2.php | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/modules/googlemap/db_schema/db_schema_1_2.php b/modules/googlemap/db_schema/db_schema_1_2.php index c6219a17bb..83c35bf4b9 100644 --- a/modules/googlemap/db_schema/db_schema_1_2.php +++ b/modules/googlemap/db_schema/db_schema_1_2.php @@ -44,20 +44,20 @@ exit; define('WT_GM_DB_SCHEMA_1_2', ''); // Create all of the tables needed for this module -try { +//try { WT_DB::exec( "ALTER TABLE `##placelocation` ADD (". " pl_media VARCHAR(60) NULL,". - " sv_long VARCHAR(30) 0,". - " sv_lati VARCHAR(30) 0,". - " sv_bearing FLOAT 0,". - " sv_elevation FLOAT 0,". - " sv_zoom FLOAT 1". + " sv_long FLOAT NOT NULL DEFAULT 0,". + " sv_lati FLOAT NOT NULL DEFAULT 0,". + " sv_bearing FLOAT NOT NULL DEFAULT 0,". + " sv_elevation FLOAT NOT NULL DEFAULT 0,". + " sv_zoom FLOAT NOT NULL DEFAULT 1". ")" ); -} catch (PDOException $ex) { +//} catch (PDOException $ex) { // Already done this? -} +//} // Update the version to indicate success set_site_setting($schema_name, $next_version); |