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

Revision 2, 0.8 kB (checked in by nperriault, 10 months ago)

First commit of the extracted code from production, I hope no passwd has been forgotten :-)

Line 
1 <?php
2 class Migration002 extends sfMigration
3 {
4
5   // Adding budget column for jobs table
6   public function up()
7   {
8     $this->executeSQL("ALTER TABLE sf_guard_user CHANGE `zip` `zip` VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL");
9     $this->executeSQL("ALTER TABLE company CHANGE `zip` `zip` VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL");
10   }
11
12   // Dropping budget column for jobs table
13   public function down()
14   {
15     $this->executeSQL("ALTER TABLE sf_guard_user CHANGE `zip` `zip` VARCHAR(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL");
16     $this->executeSQL("ALTER TABLE company CHANGE `zip` `zip` VARCHAR(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL");
17   }
18
19 }
20
Note: See TracBrowser for help on using the browser.