/usr/share/php/data/Horde_Alarm/migration/1_horde_alarms_table.php is in php-horde-alarm 2.2.10-1ubuntu1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | <?php
class HordeAlarmsTable extends Horde_Db_Migration_Base
{
public function up()
{
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'));
}
}
public function down()
{
$this->dropTable('horde_alarms');
}
}
|