From 450e5b02036435e094bfec898eadd3bdac95ef69 Mon Sep 17 00:00:00 2001 From: Jan Schneider Date: Thu, 23 Dec 2010 17:19:24 +0100 Subject: [PATCH] Catch existing base table. --- .../migration/Horde/Alarm/1_horde_alarms_table.php | 40 ++++++++++++---------- 1 file changed, 21 insertions(+), 19 deletions(-) diff --git a/framework/Alarm/migration/Horde/Alarm/1_horde_alarms_table.php b/framework/Alarm/migration/Horde/Alarm/1_horde_alarms_table.php index cbe339a83..23659e3c3 100644 --- a/framework/Alarm/migration/Horde/Alarm/1_horde_alarms_table.php +++ b/framework/Alarm/migration/Horde/Alarm/1_horde_alarms_table.php @@ -3,26 +3,28 @@ class HordeAlarmsTable extends Horde_Db_Migration_Base { public function up() { - $t = $this->createTable('horde_alarms'); - $t->column('alarm_id', 'string', array('limit' => 255, 'null' => false)); - $t->column('alarm_uid', 'string', array('limit' => 255)); - $t->column('alarm_start', 'datetime', array('null' => false)); - $t->column('alarm_end', 'datetime'); - $t->column('alarm_methods', 'string', array('limit' => 255)); - $t->column('alarm_params', 'text'); - $t->column('alarm_title', 'string', array('limit' => 255, 'null' => false)); - $t->column('alarm_text', 'text'); - $t->column('alarm_snooze', 'datetime'); - $t->column('alarm_dismissed', 'integer', array('limit' => 1, 'null' => false, 'default' => 0)); - $t->column('alarm_internal', 'text'); - $t->end(); + if (!in_array('horde_alarms', $this->tables())) { + $t = $this->createTable('horde_alarms'); + $t->column('alarm_id', 'string', array('limit' => 255, 'null' => false)); + $t->column('alarm_uid', 'string', array('limit' => 255)); + $t->column('alarm_start', 'datetime', array('null' => false)); + $t->column('alarm_end', 'datetime'); + $t->column('alarm_methods', 'string', array('limit' => 255)); + $t->column('alarm_params', 'text'); + $t->column('alarm_title', 'string', array('limit' => 255, 'null' => false)); + $t->column('alarm_text', 'text'); + $t->column('alarm_snooze', 'datetime'); + $t->column('alarm_dismissed', 'integer', array('limit' => 1, 'null' => false, 'default' => 0)); + $t->column('alarm_internal', 'text'); + $t->end(); - $this->addIndex('horde_alarms', array('alarm_id')); - $this->addIndex('horde_alarms', array('alarm_uid')); - $this->addIndex('horde_alarms', array('alarm_start')); - $this->addIndex('horde_alarms', array('alarm_end')); - $this->addIndex('horde_alarms', array('alarm_snooze')); - $this->addIndex('horde_alarms', array('alarm_dismissed')); + $this->addIndex('horde_alarms', array('alarm_id')); + $this->addIndex('horde_alarms', array('alarm_uid')); + $this->addIndex('horde_alarms', array('alarm_start')); + $this->addIndex('horde_alarms', array('alarm_end')); + $this->addIndex('horde_alarms', array('alarm_snooze')); + $this->addIndex('horde_alarms', array('alarm_dismissed')); + } } public function down() -- 2.11.0