[datapress] r147 committed - adding geocode table

[codesite...@google.com]

Revision: 147
Author: edward.benson
Date: Wed Feb 16 13:05:22 2011
Log: adding geocode table
http://code.google.com/p/datapress/source/detail?r=147

Modified:
/trunk/plugin/wp-exhibit-activation-tools.php

=======================================
--- /trunk/plugin/wp-exhibit-activation-tools.php Fri Oct 16 08:00:53 2009
+++ /trunk/plugin/wp-exhibit-activation-tools.php Wed Feb 16 13:05:22 2011
@@ -5,6 +5,7 @@
self::setup_exhibits_table();
self::setup_parrotable_urls_table();
self::setup_post_exhibits_table();
+ self::setup_geocode_table();

if (get_option(WpExhibitConfig::$WP_EXHIBIT_DB_VERSION_KEY)) {
update_option(WpExhibitConfig::$WP_EXHIBIT_DB_VERSION_KEY,
@@ -51,6 +52,20 @@
self::setup_table(WpExhibitConfig::$DATASCRAPS_TABLE_KEY,
$creation_sql);
}
+
+ static function setup_geocode_table() {
+ $creation_sql = " (
+ id INT NOT NULL AUTO_INCREMENT,
+ exhibit_id INT NOT NULL DEFAULT 0,
+ datum_id varchar(255),
+ address TEXT,
+ lat FLOAT,
+ lng FLOAT,
+ PRIMARY KEY (id)
+ )
+ ";
+ self::setup_table(WpExhibitConfig::$GEOCODE_TABLE_KEY,
$creation_sql);
+ }

static function setup_post_datascraps_table() {
$creation_sql = " (