From c7938e57684bcd7708bfa64ffff2dc88b30ab636 Mon Sep 17 00:00:00 2001 From: "Michael J. Rubinsky" Date: Fri, 23 Apr 2010 17:58:13 -0400 Subject: [PATCH] add sql creation script for the activesync tables --- horde/scripts/sql/horde_activesync.sql | 35 ++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 horde/scripts/sql/horde_activesync.sql diff --git a/horde/scripts/sql/horde_activesync.sql b/horde/scripts/sql/horde_activesync.sql new file mode 100644 index 000000000..970f8da47 --- /dev/null +++ b/horde/scripts/sql/horde_activesync.sql @@ -0,0 +1,35 @@ +CREATE TABLE horde_activesync_state ( + sync_time INTEGER, + sync_key VARCHAR(255) NOT NULL, + sync_data TEXT, + sync_devid VARCHAR(255), + sync_folderid VARCHAR(255), +-- + PRIMARY KEY (sync_key) +); + +CREATE INDEX activesync_state_folder_idx ON horde_activesync_state (sync_folderid); +CREATE INDEX activesync_state_devid_idx ON horde_activesync_state (sync_devid); + +CREATE TABLE horde_activesync_map ( + message_uid VARCHAR(255) NOT NULL, + sync_modtime INTEGER, + sync_key VARCHAR(255) NOT NULL, + sync_devid VARCHAR(255) NOT NULL, + sync_folderid VARCHAR(255) NOT NULL +); + +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 TABLE horde_activesync_device ( + device_id VARCHAR(255) NOT NULL, + device_type VARCHAR(255) NOT NULL, + device_agent VARCHAR(255) NOT NULL, + device_ping TEXT, + device_policykey BIGINT DEFAULT 0, + device_rwstatus INTEGER, + +-- + PRIMARY KEY (device_id) +); -- 2.11.0