/usr/share/php/data/Horde_ActiveSync/migration/1_horde_activesync_base_tables.php is in php-horde-activesync 2.19.2-2.
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 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 | <?php
class HordeActiveSyncBaseTables extends Horde_Db_Migration_Base
{
public function up()
{
if (!in_array('horde_activesync_state', $this->tables())) {
$t = $this->createTable('horde_activesync_state', array('autoincrementKey' => array('sync_key')));
$t->column('sync_time', 'integer');
$t->column('sync_key', 'string', array('limit' => 255, 'null' => false));
$t->column('sync_data', 'text');
$t->column('sync_devid', 'string', array('limit' => 255));
$t->column('sync_folderid', 'string', array('limit' => 255));
$t->column('sync_user', 'string', array('limit' => 255));
$t->end();
$this->addIndex('horde_activesync_state', array('sync_folderid'));
$this->addIndex('horde_activesync_state', array('sync_devid'));
}
if (!in_array('horde_activesync_map', $this->tables())) {
$t = $this->createTable('horde_activesync_map', array('autoincrementKey' => false));
$t->column('message_uid', 'string', array('limit' => 255, 'null' => false));
$t->column('sync_modtime', 'integer');
$t->column('sync_key', 'string', array('limit' => 255, 'null' => false));
$t->column('sync_devid', 'string', array('limit' => 255, 'null' => false));
$t->column('sync_folderid', 'string', array('limit' => 255, 'null' => false));
$t->column('sync_user', 'string', array('limit' => 255));
$t->end();
$this->addIndex('horde_activesync_map', array('sync_devid'));
$this->addIndex('horde_activesync_map', array('message_uid'));
$this->addIndex('horde_activesync_map', array('sync_user'));
}
if (!in_array('horde_activesync_device', $this->tables())) {
$t = $this->createTable('horde_activesync_device', array('autoincrementKey' => array('device_id')));
$t->column('device_id', 'string', array('limit' => 255, 'null' => false));
$t->column('device_type', 'string', array('limit' => 255, 'null' => false));
$t->column('device_agent', 'string', array('limit' => 255, 'null' => false));
$t->column('device_supported', 'text');
$t->column('device_policykey', 'bigint', array('default' => 0));
$t->column('device_rwstatus', 'integer');
$t->end();
}
if (!in_array('horde_activesync_device_users', $this->tables())) {
$t = $this->createTable('horde_activesync_device_users', array('autoincrementKey' => false));
$t->column('device_id', 'string', array('limit' => 255, 'null' => false));
$t->column('device_user', 'string', array('limit' => 255, 'null' => false));
$t->column('device_ping', 'text');
$t->column('device_folders', 'text');
$t->end();
$this->addIndex('horde_activesync_device_users', array('device_user'));
$this->addIndex('horde_activesync_device_users', array('device_id'));
}
}
public function down()
{
$this->dropTable('horde_activesync_device_users');
$this->dropTable('horde_activesync_device');
$this->dropTable('horde_activesync_map');
$this->dropTable('horde_activesync_state');
}
}
|