From ed39a26288a854741ed8f0aa0f172451630301e5 Mon Sep 17 00:00:00 2001 From: "Michael J. Rubinsky" Date: Sat, 1 May 2010 11:29:05 -0400 Subject: [PATCH] Add activesync sql to remaining creation scripts someone with more experience with oracle and sybase might want to verify those... --- horde/scripts/sql/create.mssql.sql | 47 +++++++++ horde/scripts/sql/create.mysql.sql | 41 ++++++++ horde/scripts/sql/create.oci8.sql | 40 ++++++++ horde/scripts/sql/create.pgsql.sql | 41 ++++++++ horde/scripts/sql/create.sql | 41 ++++++++ horde/scripts/sql/create.sybase.sql | 51 +++++++++ horde/scripts/sql/create.xml | 200 ++++++++++++++++++++++++++++++++++++ 7 files changed, 461 insertions(+) diff --git a/horde/scripts/sql/create.mssql.sql b/horde/scripts/sql/create.mssql.sql index 773fb8c38..3b88ce9ee 100644 --- a/horde/scripts/sql/create.mssql.sql +++ b/horde/scripts/sql/create.mssql.sql @@ -229,3 +229,50 @@ CREATE TABLE horde_locks ( PRIMARY KEY (lock_id) ); GO + +CREATE TABLE horde_activesync_state ( + sync_time INT, + sync_key VARCHAR(255) NOT NULL, + sync_data TEXT, + sync_devid VARCHAR(255), + sync_folderid VARCHAR(255), +-- + PRIMARY KEY (sync_key) +); +GO + +CREATE INDEX activesync_state_folder_idx ON horde_activesync_state (sync_folderid); +CREATE INDEX activesync_state_devid_idx ON horde_activesync_state (sync_devid); +GO + +CREATE TABLE horde_activesync_map ( + message_uid VARCHAR(255) NOT NULL, + sync_modtime INT, + sync_key VARCHAR(255) NOT NULL, + sync_devid VARCHAR(255) NOT NULL, + sync_folderid VARCHAR(255) NOT NULL +); +GO + +CREATE INDEX activesync_map_devid_idx ON horde_activesync_map (sync_devid); +CREATE INDEX activesync_map_message_idx ON horde_activesync_map (message_uid); +GO + +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_supported TEXT, + device_policykey BIGINT DEFAULT 0, + device_rwstatus INT, + device_folders TEXT, + device_user VARCHAR(255), + +-- + PRIMARY KEY (device_id) +); +GO + +CREATE INDEX activesync_device_user_idx ON horde_activesync_device (device_user); +GO diff --git a/horde/scripts/sql/create.mysql.sql b/horde/scripts/sql/create.mysql.sql index d7cfeea7b..c18e95e77 100644 --- a/horde/scripts/sql/create.mysql.sql +++ b/horde/scripts/sql/create.mysql.sql @@ -253,4 +253,45 @@ CREATE TABLE IF NOT EXISTS horde_locks ( PRIMARY KEY (lock_id) ); +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_supported TEXT, + 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); + -- Done. diff --git a/horde/scripts/sql/create.oci8.sql b/horde/scripts/sql/create.oci8.sql index aa628ed99..67ca21b55 100644 --- a/horde/scripts/sql/create.oci8.sql +++ b/horde/scripts/sql/create.oci8.sql @@ -278,4 +278,44 @@ CREATE TABLE horde_locks ( PRIMARY KEY (lock_id) ); +CREATE TABLE horde_activesync_state ( + sync_time NUMBER(16), + sync_key VARCHAR2(255) NOT NULL, + sync_data CLOB, + sync_devid VARCHAR2(255), + sync_folderid VARCHAR2(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 VARCHAR2(255) NOT NULL, + sync_modtime NUMBER(16), + sync_key VARCHAR2(255) NOT NULL, + sync_devid VARCHAR2(255) NOT NULL, + sync_folderid VARCHAR2(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 VARCHAR2(255) NOT NULL, + device_type VARCHAR2(255) NOT NULL, + device_agent VARCHAR2(255) NOT NULL, + device_ping CLOB, + device_supported CLOB, + device_policykey NUMBER(16) DEFAULT 0, + device_rwstatus NUMBER(8), + device_folders CLOB, + device_user VARCHAR2(255), +-- + PRIMARY KEY (device_id) +); + +CREATE INDEX activesync_device_user_idx ON horde_activesync_device (device_user); + exit diff --git a/horde/scripts/sql/create.pgsql.sql b/horde/scripts/sql/create.pgsql.sql index 49335f961..9a3dd6536 100644 --- a/horde/scripts/sql/create.pgsql.sql +++ b/horde/scripts/sql/create.pgsql.sql @@ -214,4 +214,45 @@ CREATE TABLE horde_locks ( PRIMARY KEY (lock_id) ); +CREATE TABLE horde_activesync_state ( + sync_time INT, + 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 INT, + 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_supported TEXT, + device_policykey BIGINT DEFAULT 0, + device_rwstatus INT, + device_folders TEXT, + device_user VARCHAR(255), + +-- + PRIMARY KEY (device_id) +); + +CREATE INDEX activesync_device_user_idx ON horde_activesync_device (device_user); + COMMIT; diff --git a/horde/scripts/sql/create.sql b/horde/scripts/sql/create.sql index fdc2a11e3..aca818fcb 100644 --- a/horde/scripts/sql/create.sql +++ b/horde/scripts/sql/create.sql @@ -220,3 +220,44 @@ CREATE TABLE horde_locks ( PRIMARY KEY (lock_id) ); + +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_supported TEXT, + 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); \ No newline at end of file diff --git a/horde/scripts/sql/create.sybase.sql b/horde/scripts/sql/create.sybase.sql index 7f06d0b78..02854d82f 100644 --- a/horde/scripts/sql/create.sybase.sql +++ b/horde/scripts/sql/create.sybase.sql @@ -175,6 +175,42 @@ CREATE TABLE horde_locks ( ) go +CREATE TABLE horde_activesync_state ( + sync_time numeric(10, 0), + sync_key varchar(255) NOT NULL, + sync_data text, + sync_devid varchar(255), + sync_folderid varchar(255), +-- + PRIMARY KEY (sync_key) +); +go + +CREATE TABLE horde_activesync_map ( + message_uid varchar(255) NOT NULL, + sync_modtime numeric(10, 0), + sync_key varchar(255) NOT NULL, + sync_devid varchar(255) NOT NULL, + sync_folderid varchar(255) NOT NULL +); +go + +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_supported text, + device_policykey number(11, 0) DEFAULT 0, + device_rwstatus number(10, 0), + device_folders text, + device_user varchar(255), + +-- + PRIMARY KEY (device_id) +); +go + -- CREATE TABLE horde_datatree_seq ( -- id numeric(10,0) IDENTITY NOT NULL, -- PRIMARY KEY (id) @@ -281,6 +317,21 @@ go CREATE INDEX session_lastmodified_idx ON horde_sessionhandler (session_lastmodified) go +CREATE INDEX activesync_state_folder_idx ON horde_activesync_state (sync_folderid); +go + +CREATE INDEX activesync_state_devid_idx ON horde_activesync_state (sync_devid); +go + +CREATE INDEX activesync_map_devid_idx ON horde_activesync_map (sync_devid); +go + +CREATE INDEX activesync_map_message_idx ON horde_activesync_map (message_uid); +go + +CREATE INDEX activesync_device_user_idx ON horde_activesync_device (device_user); +go + -- CREATE INDEX vfs_path_idx ON horde_vfs (vfs_path) -- go diff --git a/horde/scripts/sql/create.xml b/horde/scripts/sql/create.xml index 928450345..eb30d2986 100644 --- a/horde/scripts/sql/create.xml +++ b/horde/scripts/sql/create.xml @@ -1307,4 +1307,204 @@ + + + horde_activesync_state + + + + + sync_time + integer + false + 0 + + + + sync_key + text + 255 + + + + sync_data + clob + + + + sync_devid + text + 255 + false + + + + sync_folderid + text + 255 + false + + + + activesync_state_primary + true + + sync_key + + + + + activesync_state_folder_idx + + sync_folderid + + + + + activesync_state_devid_idx + + sync_devid + + + + + +
+ + + + horde_activesync_map + + + + + message_uid + text + 255 + + + + sync_modtime + integer + false + + + + sync_key + text + 255 + + + + sync_devid + text + 255 + false + + + + sync_folderid + text + 255 + false + + + + activesync_map_message_idx + + message_uid + + + + + activesync_map_devid_idx + + sync_devid + + + + + +
+ + + + horde_activesync_device + + + + + device_id + text + 255 + + + + device_type + text + 255 + + + + device_agent + text + 255 + + + + device_ping + clob + false + + + + device_supported + clob + false + + + + device_policykey + integer + 0 + + + + device_rwstatus + integer + false + + + + device_folders + clob + false + + + + device_user + text + 255 + false + + + + activesync_device_primary + true + + device_id + + + + + activesync_device_user_message_idx + + device_user + + + + + +
+ -- 2.11.0