From 749d6c759e1e43259510b74b2159749c558801b3 Mon Sep 17 00:00:00 2001 From: "Michael J. Rubinsky" Date: Sat, 24 Apr 2010 16:28:54 -0400 Subject: [PATCH] add username to the device table --- horde/scripts/sql/horde_activesync.sql | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/horde/scripts/sql/horde_activesync.sql b/horde/scripts/sql/horde_activesync.sql index ee54e550a..ca837d292 100644 --- a/horde/scripts/sql/horde_activesync.sql +++ b/horde/scripts/sql/horde_activesync.sql @@ -20,7 +20,7 @@ CREATE TABLE horde_activesync_map ( ); CREATE INDEX activesync_map_devid_idx ON horde_activesync_map (sync_devid); -CREATE INDEX activesync_map_message_idx ON horde_activesync_map(message_uid); +CREATE INDEX activesync_map_message_idx ON horde_activesync_map (message_uid); CREATE TABLE horde_activesync_device ( device_id VARCHAR(255) NOT NULL, @@ -30,7 +30,11 @@ CREATE TABLE horde_activesync_device ( device_policykey BIGINT DEFAULT 0, device_rwstatus INTEGER, device_folders TEXT, + device_user VARCHAR(255), -- PRIMARY KEY (device_id) ); + +CREATE INDEX activesync_device_user_idx ON horde_activesync_device (device_user); + -- 2.11.0