root/trunk/data/migrations/003_m1.php

<?php
class Migration003 extends sfMigration 
{

  // Adding localization plugin table
  public function up() 
  {
    $this->executeSQL(
      "CREATE TABLE `sf_geolocalization` (
        `id` INTEGER  NOT NULL AUTO_INCREMENT,
        `model_name` VARCHAR(255)  NOT NULL,
        `model_id` INTEGER  NOT NULL,
        `latitude` FLOAT (12, 6) NOT NULL,
        `longitude` FLOAT (12, 6) NOT NULL,
        PRIMARY KEY (`id`),
        UNIQUE KEY `object` (`model_name`, `model_id`),
        KEY `geo_index`(`model_name`, `model_id`, `latitude`, `longitude`)
      )Type=MyISAM;");
  }

  // Dropping localization plugin table
  public function down() 
  {
    $this->executeSQL("DROP TABLE IF EXISTS `sf_geolocalization`;");
  }

}