[pkg-kolab] r1127 - in kolab-webclient/trunk: . scripts scripts/sql
mparent-guest at alioth.debian.org
mparent-guest at alioth.debian.org
Wed Jan 14 17:31:45 UTC 2009
Author: mparent-guest
Date: 2009-01-14 17:31:45 +0000 (Wed, 14 Jan 2009)
New Revision: 1127
Added:
kolab-webclient/trunk/scripts/
kolab-webclient/trunk/scripts/sql/
kolab-webclient/trunk/scripts/sql/groupware.sql
Log:
imported sql script from original app
Added: kolab-webclient/trunk/scripts/sql/groupware.sql
===================================================================
--- kolab-webclient/trunk/scripts/sql/groupware.sql (rev 0)
+++ kolab-webclient/trunk/scripts/sql/groupware.sql 2009-01-14 17:31:45 UTC (rev 1127)
@@ -0,0 +1,644 @@
+-- $Horde: horde/scripts/sql/create.sql,v 1.1.2.18 2008/08/13 20:18:03 chuck Exp $
+
+CREATE TABLE horde_users (
+ user_uid VARCHAR(255) NOT NULL,
+ user_pass VARCHAR(255) NOT NULL,
+ user_soft_expiration_date INTEGER,
+ user_hard_expiration_date INTEGER,
+--
+ PRIMARY KEY (user_uid)
+);
+
+CREATE TABLE horde_signups (
+ user_name VARCHAR(255) NOT NULL,
+ signup_date INTEGER NOT NULL,
+ signup_host VARCHAR(255) NOT NULL,
+ signup_email VARCHAR(255) NOT NULL,
+ signup_data TEXT NOT NULL,
+ PRIMARY KEY (user_name)
+);
+
+CREATE TABLE horde_groups (
+ group_uid INTEGER NOT NULL,
+ group_name VARCHAR(255) NOT NULL,
+ group_parents VARCHAR(255) NOT NULL,
+ group_email VARCHAR(255),
+ PRIMARY KEY (group_uid)
+);
+
+CREATE TABLE horde_groups_members (
+ group_uid INTEGER NOT NULL,
+ user_uid VARCHAR(255) NOT NULL
+);
+
+CREATE INDEX group_uid_idx ON horde_groups_members (group_uid);
+CREATE INDEX user_uid_idx ON horde_groups_members (user_uid);
+
+
+CREATE TABLE horde_perms (
+ perm_id INTEGER NOT NULL,
+ perm_name VARCHAR(255) NOT NULL,
+ perm_parents VARCHAR(255) NOT NULL,
+ perm_data TEXT,
+ PRIMARY KEY (perm_id)
+);
+
+
+CREATE TABLE horde_prefs (
+ pref_uid VARCHAR(255) NOT NULL,
+ pref_scope VARCHAR(16) DEFAULT '' NOT NULL,
+ pref_name VARCHAR(32) NOT NULL,
+ pref_value TEXT,
+--
+ PRIMARY KEY (pref_uid, pref_scope, pref_name)
+);
+
+
+CREATE TABLE horde_datatree (
+ datatree_id INT UNSIGNED NOT NULL,
+ group_uid VARCHAR(255) NOT NULL,
+ user_uid VARCHAR(255) NOT NULL,
+ datatree_name VARCHAR(255) NOT NULL,
+ datatree_parents VARCHAR(255) NOT NULL,
+ datatree_order INT,
+
+-- There is no portable way to do this apparently. If your db doesn't
+-- allow TEXT columns, then maybe it allows large VARCHAR columns, so
+-- try the second line.
+--
+ datatree_data TEXT,
+-- datatree_data VARCHAR(4096),
+
+ datatree_serialized SMALLINT DEFAULT 0 NOT NULL,
+
+ PRIMARY KEY (datatree_id)
+);
+
+CREATE INDEX datatree_datatree_name_idx ON horde_datatree (datatree_name);
+CREATE INDEX datatree_group_idx ON horde_datatree (group_uid);
+CREATE INDEX datatree_user_idx ON horde_datatree (user_uid);
+CREATE INDEX datatree_order_idx ON horde_datatree (datatree_order);
+CREATE INDEX datatree_serialized_idx ON horde_datatree (datatree_serialized);
+CREATE INDEX datatree_parents_idx ON horde_datatree (datatree_parents);
+
+CREATE TABLE horde_datatree_attributes (
+ datatree_id INT UNSIGNED NOT NULL,
+ attribute_name VARCHAR(255) NOT NULL,
+ attribute_key VARCHAR(255),
+ attribute_value TEXT
+);
+
+CREATE INDEX datatree_attribute_idx ON horde_datatree_attributes (datatree_id);
+CREATE INDEX datatree_attribute_name_idx ON horde_datatree_attributes (attribute_name);
+CREATE INDEX datatree_attribute_key_idx ON horde_datatree_attributes (attribute_key);
+CREATE INDEX datatree_attribute_value_idx ON horde_datatree_attributes (attribute_value);
+
+
+CREATE TABLE horde_tokens (
+ token_address VARCHAR(100) NOT NULL,
+ token_id VARCHAR(32) NOT NULL,
+ token_timestamp BIGINT NOT NULL,
+--
+ PRIMARY KEY (token_address, token_id)
+);
+
+
+CREATE TABLE horde_vfs (
+ vfs_id INT UNSIGNED NOT NULL,
+ vfs_type SMALLINT UNSIGNED NOT NULL,
+ vfs_path VARCHAR(255) NOT NULL,
+ vfs_name VARCHAR(255) NOT NULL,
+ vfs_modified BIGINT NOT NULL,
+ vfs_owner VARCHAR(255) NOT NULL,
+ vfs_data LONGBLOB,
+-- Or, on some DBMS systems:
+-- vfs_data IMAGE,
+ PRIMARY KEY (vfs_id)
+);
+
+CREATE INDEX vfs_path_idx ON horde_vfs (vfs_path);
+CREATE INDEX vfs_name_idx ON horde_vfs (vfs_name);
+
+
+CREATE TABLE horde_histories (
+ history_id INT UNSIGNED NOT NULL,
+ object_uid VARCHAR(255) NOT NULL,
+ history_action VARCHAR(32) NOT NULL,
+ history_ts BIGINT NOT NULL,
+ history_desc TEXT,
+ history_who VARCHAR(255),
+ history_extra TEXT,
+--
+ PRIMARY KEY (history_id)
+);
+
+CREATE INDEX history_action_idx ON horde_histories (history_action);
+CREATE INDEX history_ts_idx ON horde_histories (history_ts);
+CREATE INDEX history_uid_idx ON horde_histories (object_uid);
+
+
+CREATE TABLE horde_sessionhandler (
+ session_id VARCHAR(32) NOT NULL,
+ session_lastmodified BIGINT NOT NULL,
+ session_data LONGBLOB,
+-- Or, on some DBMS systems:
+-- session_data IMAGE,
+
+ PRIMARY KEY (session_id)
+);
+
+CREATE TABLE horde_syncml_map (
+ syncml_syncpartner VARCHAR(255) NOT NULL,
+ syncml_db VARCHAR(255) NOT NULL,
+ syncml_uid VARCHAR(255) NOT NULL,
+ syncml_cuid VARCHAR(255),
+ syncml_suid VARCHAR(255),
+ syncml_timestamp BIGINT
+);
+
+CREATE INDEX syncml_syncpartner_idx ON horde_syncml_map (syncml_syncpartner);
+CREATE INDEX syncml_db_idx ON horde_syncml_map (syncml_db);
+CREATE INDEX syncml_uid_idx ON horde_syncml_map (syncml_uid);
+CREATE INDEX syncml_cuid_idx ON horde_syncml_map (syncml_cuid);
+CREATE INDEX syncml_suid_idx ON horde_syncml_map (syncml_suid);
+
+CREATE TABLE horde_syncml_anchors(
+ syncml_syncpartner VARCHAR(255) NOT NULL,
+ syncml_db VARCHAR(255) NOT NULL,
+ syncml_uid VARCHAR(255) NOT NULL,
+ syncml_clientanchor VARCHAR(255),
+ syncml_serveranchor VARCHAR(255)
+);
+
+CREATE INDEX syncml_anchors_syncpartner_idx ON horde_syncml_anchors (syncml_syncpartner);
+CREATE INDEX syncml_anchors_db_idx ON horde_syncml_anchors (syncml_db);
+CREATE INDEX syncml_anchors_uid_idx ON horde_syncml_anchors (syncml_uid);
+
+
+CREATE TABLE horde_alarms (
+ alarm_id VARCHAR(255) NOT NULL,
+ alarm_uid VARCHAR(255),
+ alarm_start DATETIME NOT NULL,
+ alarm_end DATETIME,
+ alarm_methods VARCHAR(255),
+ alarm_params TEXT,
+ alarm_title VARCHAR(255) NOT NULL,
+ alarm_text TEXT,
+ alarm_snooze DATETIME,
+ alarm_dismissed SMALLINT DEFAULT 0 NOT NULL,
+ alarm_internal TEXT
+);
+
+CREATE INDEX alarm_id_idx ON horde_alarms (alarm_id);
+CREATE INDEX alarm_user_idx ON horde_alarms (alarm_uid);
+CREATE INDEX alarm_start_idx ON horde_alarms (alarm_start);
+CREATE INDEX alarm_end_idx ON horde_alarms (alarm_end);
+CREATE INDEX alarm_snooze_idx ON horde_alarms (alarm_snooze);
+CREATE INDEX alarm_dismissed_idx ON horde_alarms (alarm_dismissed);
+
+
+CREATE TABLE horde_cache (
+ cache_id VARCHAR(32) NOT NULL,
+ cache_timestamp BIGINT NOT NULL,
+ cache_expiration BIGINT NOT NULL,
+ cache_data LONGBLOB,
+-- Or on some other DBMS systems:
+-- cache_data IMAGE,
+
+ PRIMARY KEY (cache_id)
+);
+
+CREATE TABLE horde_locks (
+ lock_id VARCHAR(36) NOT NULL,
+ lock_owner VARCHAR(32) NOT NULL,
+ lock_scope VARCHAR(32) NOT NULL,
+ lock_principal VARCHAR(255) NOT NULL,
+ lock_origin_timestamp BIGINT NOT NULL,
+ lock_update_timestamp BIGINT NOT NULL,
+ lock_expiry_timestamp BIGINT NOT NULL,
+ lock_type SMALLINT UNSIGNED NOT NULL,
+
+ PRIMARY KEY (lock_id)
+);
+
+-- $Horde: imp/scripts/sql/imp.sql,v 1.1.2.1 2007/12/20 14:00:36 jan Exp $
+
+CREATE TABLE imp_sentmail (
+ sentmail_id BIGINT NOT NULL,
+ sentmail_who VARCHAR(255) NOT NULL,
+ sentmail_ts BIGINT NOT NULL,
+ sentmail_messageid VARCHAR(255) NOT NULL,
+ sentmail_action VARCHAR(32) NOT NULL,
+ sentmail_recipient VARCHAR(255) NOT NULL,
+ sentmail_success INT NOT NULL,
+--
+ PRIMARY KEY (sentmail_id)
+);
+
+CREATE INDEX sentmail_ts_idx ON imp_sentmail (sentmail_ts);
+CREATE INDEX sentmail_who_idx ON imp_sentmail (sentmail_who);
+CREATE INDEX sentmail_success_idx ON imp_sentmail (sentmail_success);
+
+-- $Horde: turba/scripts/sql/turba.sql,v 1.1.2.7 2008/09/23 15:18:25 jan Exp $
+
+CREATE TABLE turba_objects (
+ object_id VARCHAR(32) NOT NULL,
+ owner_id VARCHAR(255) NOT NULL,
+ object_type VARCHAR(255) DEFAULT 'Object' NOT NULL,
+ object_uid VARCHAR(255),
+ object_members BLOB,
+ object_firstname VARCHAR(255),
+ object_lastname VARCHAR(255),
+ object_middlenames VARCHAR(255),
+ object_nameprefix VARCHAR(32),
+ object_namesuffix VARCHAR(32),
+ object_alias VARCHAR(32),
+ object_photo BLOB,
+ object_phototype VARCHAR(10),
+ object_bday VARCHAR(10),
+ object_homestreet VARCHAR(255),
+ object_homepob VARCHAR(10),
+ object_homecity VARCHAR(255),
+ object_homeprovince VARCHAR(255),
+ object_homepostalcode VARCHAR(10),
+ object_homecountry VARCHAR(255),
+ object_workstreet VARCHAR(255),
+ object_workpob VARCHAR(10),
+ object_workcity VARCHAR(255),
+ object_workprovince VARCHAR(255),
+ object_workpostalcode VARCHAR(10),
+ object_workcountry VARCHAR(255),
+ object_tz VARCHAR(32),
+ object_geo VARCHAR(255),
+ object_email VARCHAR(255),
+ object_homephone VARCHAR(25),
+ object_workphone VARCHAR(25),
+ object_cellphone VARCHAR(25),
+ object_fax VARCHAR(25),
+ object_pager VARCHAR(25),
+ object_title VARCHAR(255),
+ object_role VARCHAR(255),
+ object_logo BLOB,
+ object_logotype VARCHAR(10),
+ object_company VARCHAR(255),
+ object_category VARCHAR(80),
+ object_notes TEXT,
+ object_url VARCHAR(255),
+ object_freebusyurl VARCHAR(255),
+ object_pgppublickey TEXT,
+ object_smimepublickey TEXT,
+ PRIMARY KEY(object_id)
+);
+
+CREATE INDEX turba_owner_idx ON turba_objects (owner_id);
+CREATE INDEX turba_email_idx ON turba_objects (object_email);
+CREATE INDEX turba_firstname_idx ON turba_objects (object_firstname);
+CREATE INDEX turba_lastname_idx ON turba_objects (object_lastname);
+
+CREATE TABLE turba_shares (
+ share_id INT NOT NULL,
+ share_name VARCHAR(255) NOT NULL,
+ share_owner VARCHAR(32) NOT NULL,
+ share_flags SMALLINT NOT NULL DEFAULT 0,
+ perm_creator SMALLINT NOT NULL DEFAULT 0,
+ perm_default SMALLINT NOT NULL DEFAULT 0,
+ perm_guest SMALLINT NOT NULL DEFAULT 0,
+ attribute_name VARCHAR(255) NOT NULL,
+ attribute_desc VARCHAR(255),
+ attribute_params TEXT,
+ PRIMARY KEY (share_id)
+);
+
+CREATE INDEX turba_shares_share_name_idx ON turba_shares (share_name);
+CREATE INDEX turba_shares_share_owner_idx ON turba_shares (share_owner);
+CREATE INDEX turba_shares_perm_creator_idx ON turba_shares (perm_creator);
+CREATE INDEX turba_shares_perm_default_idx ON turba_shares (perm_default);
+CREATE INDEX turba_shares_perm_guest_idx ON turba_shares (perm_guest);
+
+CREATE TABLE turba_shares_groups (
+ share_id INT NOT NULL,
+ group_uid VARCHAR(255) NOT NULL,
+ perm SMALLINT NOT NULL
+);
+
+CREATE INDEX turba_shares_groups_share_id_idx ON turba_shares_groups (share_id);
+CREATE INDEX turba_shares_groups_group_uid_idx ON turba_shares_groups (group_uid);
+CREATE INDEX turba_shares_groups_perm_idx ON turba_shares_groups (perm);
+
+CREATE TABLE turba_shares_users (
+ share_id INT NOT NULL,
+ user_uid VARCHAR(255) NOT NULL,
+ perm SMALLINT NOT NULL
+);
+
+CREATE INDEX turba_shares_users_share_id_idx ON turba_shares_users (share_id);
+CREATE INDEX turba_shares_users_user_uid_idx ON turba_shares_users (user_uid);
+CREATE INDEX turba_shares_users_perm_idx ON turba_shares_users (perm);
+
+-- $Horde: ingo/scripts/sql/ingo.sql,v 1.6.2.5 2008/06/18 00:42:08 mrubinsk Exp $
+
+CREATE TABLE ingo_rules (
+ rule_id INT NOT NULL,
+ rule_owner VARCHAR(255) NOT NULL,
+ rule_name VARCHAR(255) NOT NULL,
+ rule_action INT NOT NULL,
+ rule_value VARCHAR(255),
+ rule_flags INT,
+ rule_conditions TEXT,
+ rule_combine INT,
+ rule_stop INT,
+ rule_active INT DEFAULT 1 NOT NULL,
+ rule_order INT DEFAULT 0 NOT NULL,
+--
+ PRIMARY KEY (rule_id)
+);
+
+CREATE INDEX rule_owner_idx ON ingo_rules (rule_owner);
+
+
+CREATE TABLE ingo_lists (
+ list_owner VARCHAR(255) NOT NULL,
+ list_blacklist INT DEFAULT 0,
+ list_address VARCHAR(255) NOT NULL
+);
+
+CREATE INDEX list_idx ON ingo_lists (list_owner, list_blacklist);
+
+
+CREATE TABLE ingo_forwards (
+ forward_owner VARCHAR(255) NOT NULL,
+ forward_addresses TEXT,
+ forward_keep INT DEFAULT 0 NOT NULL,
+--
+ PRIMARY KEY (forward_owner)
+);
+
+
+CREATE TABLE ingo_vacations (
+ vacation_owner VARCHAR(255) NOT NULL,
+ vacation_addresses TEXT,
+ vacation_subject VARCHAR(255),
+ vacation_reason TEXT,
+ vacation_days INT DEFAULT 7,
+ vacation_start INT,
+ vacation_end INT,
+ vacation_excludes TEXT,
+ vacation_ignorelists INT DEFAULT 1,
+--
+ PRIMARY KEY (vacation_owner)
+);
+
+
+CREATE TABLE ingo_spam (
+ spam_owner VARCHAR(255) NOT NULL,
+ spam_level INT DEFAULT 5,
+ spam_folder VARCHAR(255),
+--
+ PRIMARY KEY (spam_owner)
+);
+
+
+CREATE TABLE ingo_shares (
+ share_id INT NOT NULL,
+ share_name VARCHAR(255) NOT NULL,
+ share_owner VARCHAR(32) NOT NULL,
+ share_flags SMALLINT NOT NULL DEFAULT 0,
+ perm_creator SMALLINT NOT NULL DEFAULT 0,
+ perm_default SMALLINT NOT NULL DEFAULT 0,
+ perm_guest SMALLINT NOT NULL DEFAULT 0,
+ attribute_name VARCHAR(255) NOT NULL,
+ attribute_desc VARCHAR(255),
+ PRIMARY KEY (share_id)
+);
+
+CREATE INDEX ingo_shares_share_name_idx ON ingo_shares (share_name);
+CREATE INDEX ingo_shares_share_owner_idx ON ingo_shares (share_owner);
+CREATE INDEX ingo_shares_perm_creator_idx ON ingo_shares (perm_creator);
+CREATE INDEX ingo_shares_perm_default_idx ON ingo_shares (perm_default);
+CREATE INDEX ingo_shares_perm_guest_idx ON ingo_shares (perm_guest);
+
+CREATE TABLE ingo_shares_groups (
+ share_id INT NOT NULL,
+ group_uid INT NOT NULL,
+ perm SMALLINT NOT NULL
+);
+
+CREATE INDEX ingo_shares_groups_share_id_idx ON ingo_shares_groups (share_id);
+CREATE INDEX ingo_shares_groups_group_uid_idx ON ingo_shares_groups (group_uid);
+CREATE INDEX ingo_shares_groups_perm_idx ON ingo_shares_groups (perm);
+
+CREATE TABLE ingo_shares_users (
+ share_id INT NOT NULL,
+ user_uid VARCHAR(255) NOT NULL,
+ perm SMALLINT NOT NULL
+);
+
+CREATE INDEX ingo_shares_users_share_id_idx ON ingo_shares_users (share_id);
+CREATE INDEX ingo_shares_users_user_uid_idx ON ingo_shares_users (user_uid);
+CREATE INDEX ingo_shares_users_perm_idx ON ingo_shares_users (perm);
+
+-- $Horde: kronolith/scripts/sql/kronolith.sql,v 1.3.2.8 2008/09/23 15:18:27 jan Exp $
+
+CREATE TABLE kronolith_events (
+ event_id VARCHAR(32) NOT NULL,
+ event_uid VARCHAR(255) NOT NULL,
+ calendar_id VARCHAR(255) NOT NULL,
+ event_creator_id VARCHAR(255) NOT NULL,
+ event_description TEXT,
+ event_location TEXT,
+ event_status INT DEFAULT 0,
+ event_attendees TEXT,
+ event_keywords TEXT,
+ event_exceptions TEXT,
+ event_title VARCHAR(255),
+ event_category VARCHAR(80),
+ event_recurtype INT DEFAULT 0,
+ event_recurinterval INT,
+ event_recurdays INT,
+ event_recurenddate DATETIME,
+ event_recurcount INT,
+ event_start DATETIME,
+ event_end DATETIME,
+ event_alarm INT DEFAULT 0,
+ event_modified INT NOT NULL,
+ event_private INT DEFAULT 0 NOT NULL,
+
+ PRIMARY KEY (event_id)
+);
+
+CREATE INDEX kronolith_calendar_idx ON kronolith_events (calendar_id);
+CREATE INDEX kronolith_uid_idx ON kronolith_events (event_uid);
+
+
+CREATE TABLE kronolith_storage (
+ vfb_owner VARCHAR(255) DEFAULT NULL,
+ vfb_email VARCHAR(255) DEFAULT '' NOT NULL,
+ vfb_serialized TEXT NOT NULL
+);
+
+CREATE INDEX kronolith_vfb_owner_idx ON kronolith_storage (vfb_owner);
+CREATE INDEX kronolith_vfb_email_idx ON kronolith_storage (vfb_email);
+
+
+CREATE TABLE kronolith_shares (
+ share_id INT NOT NULL,
+ share_name VARCHAR(255) NOT NULL,
+ share_owner VARCHAR(255) NOT NULL,
+ share_flags SMALLINT NOT NULL DEFAULT 0,
+ perm_creator SMALLINT NOT NULL DEFAULT 0,
+ perm_default SMALLINT NOT NULL DEFAULT 0,
+ perm_guest SMALLINT NOT NULL DEFAULT 0,
+ attribute_name VARCHAR(255) NOT NULL,
+ attribute_desc VARCHAR(255),
+ PRIMARY KEY (share_id)
+);
+
+CREATE INDEX kronolith_shares_share_name_idx ON kronolith_shares (share_name);
+CREATE INDEX kronolith_shares_share_owner_idx ON kronolith_shares (share_owner);
+CREATE INDEX kronolith_shares_perm_creator_idx ON kronolith_shares (perm_creator);
+CREATE INDEX kronolith_shares_perm_default_idx ON kronolith_shares (perm_default);
+CREATE INDEX kronolith_shares_perm_guest_idx ON kronolith_shares (perm_guest);
+
+CREATE TABLE kronolith_shares_groups (
+ share_id INT NOT NULL,
+ group_uid VARCHAR(255) NOT NULL,
+ perm SMALLINT NOT NULL
+);
+
+CREATE INDEX kronolith_shares_groups_share_id_idx ON kronolith_shares_groups (share_id);
+CREATE INDEX kronolith_shares_groups_group_uid_idx ON kronolith_shares_groups (group_uid);
+CREATE INDEX kronolith_shares_groups_perm_idx ON kronolith_shares_groups (perm);
+
+CREATE TABLE kronolith_shares_users (
+ share_id INT NOT NULL,
+ user_uid VARCHAR(255) NOT NULL,
+ perm SMALLINT NOT NULL
+);
+
+CREATE INDEX kronolith_shares_users_share_id_idx ON kronolith_shares_users (share_id);
+CREATE INDEX kronolith_shares_users_user_uid_idx ON kronolith_shares_users (user_uid);
+CREATE INDEX kronolith_shares_users_perm_idx ON kronolith_shares_users (perm);
+
+-- $Horde: nag/scripts/sql/nag.sql,v 1.4.8.7 2008/09/23 15:18:22 jan Exp $
+
+CREATE TABLE nag_tasks (
+ task_id VARCHAR(32) NOT NULL,
+ task_owner VARCHAR(255) NOT NULL,
+ task_creator VARCHAR(255) NOT NULL,
+ task_parent VARCHAR(32) NOT NULL,
+ task_assignee VARCHAR(255),
+ task_name VARCHAR(255) NOT NULL,
+ task_uid VARCHAR(255) NOT NULL,
+ task_desc TEXT,
+ task_start INT,
+ task_due INT,
+ task_priority INT DEFAULT 0 NOT NULL,
+ task_estimate FLOAT,
+ task_category VARCHAR(80),
+ task_completed SMALLINT DEFAULT 0 NOT NULL,
+ task_completed_date INT,
+ task_alarm INT DEFAULT 0 NOT NULL,
+ task_private SMALLINT DEFAULT 0 NOT NULL,
+--
+ PRIMARY KEY (task_id)
+);
+
+CREATE INDEX nag_tasklist_idx ON nag_tasks (task_owner);
+CREATE INDEX nag_uid_idx ON nag_tasks (task_uid);
+CREATE INDEX nag_start_idx ON nag_tasks (task_start);
+
+CREATE TABLE nag_shares (
+ share_id INT NOT NULL,
+ share_name VARCHAR(255) NOT NULL,
+ share_owner VARCHAR(32) NOT NULL,
+ share_flags SMALLINT NOT NULL DEFAULT 0,
+ perm_creator SMALLINT NOT NULL DEFAULT 0,
+ perm_default SMALLINT NOT NULL DEFAULT 0,
+ perm_guest SMALLINT NOT NULL DEFAULT 0,
+ attribute_name VARCHAR(255) NOT NULL,
+ attribute_desc VARCHAR(255),
+ PRIMARY KEY (share_id)
+);
+
+CREATE INDEX nag_shares_share_name_idx ON nag_shares (share_name);
+CREATE INDEX nag_shares_share_owner_idx ON nag_shares (share_owner);
+CREATE INDEX nag_shares_perm_creator_idx ON nag_shares (perm_creator);
+CREATE INDEX nag_shares_perm_default_idx ON nag_shares (perm_default);
+CREATE INDEX nag_shares_perm_guest_idx ON nag_shares (perm_guest);
+
+CREATE TABLE nag_shares_groups (
+ share_id INT NOT NULL,
+ group_uid VARCHAR(255) NOT NULL,
+ perm SMALLINT NOT NULL
+);
+
+CREATE INDEX nag_shares_groups_share_id_idx ON nag_shares_groups (share_id);
+CREATE INDEX nag_shares_groups_group_uid_idx ON nag_shares_groups (group_uid);
+CREATE INDEX nag_shares_groups_perm_idx ON nag_shares_groups (perm);
+
+CREATE TABLE nag_shares_users (
+ share_id INT NOT NULL,
+ user_uid VARCHAR(255) NOT NULL,
+ perm SMALLINT NOT NULL
+);
+
+CREATE INDEX nag_shares_users_share_id_idx ON nag_shares_users (share_id);
+CREATE INDEX nag_shares_users_user_uid_idx ON nag_shares_users (user_uid);
+CREATE INDEX nag_shares_users_perm_idx ON nag_shares_users (perm);
+
+-- $Horde: mnemo/scripts/sql/mnemo.sql,v 1.5.2.5 2008/06/18 00:42:10 mrubinsk Exp $
+
+CREATE TABLE mnemo_memos (
+ memo_owner VARCHAR(255) NOT NULL,
+ memo_id VARCHAR(32) NOT NULL,
+ memo_uid VARCHAR(255) NOT NULL,
+ memo_desc VARCHAR(64) NOT NULL,
+ memo_body TEXT,
+ memo_category VARCHAR(80),
+ memo_private SMALLINT DEFAULT 0 NOT NULL,
+--
+ PRIMARY KEY (memo_owner, memo_id)
+);
+
+CREATE INDEX mnemo_notepad_idx ON mnemo_memos (memo_owner);
+CREATE INDEX mnemo_uid_idx ON mnemo_memos (memo_uid);
+
+CREATE TABLE mnemo_shares (
+ share_id INT NOT NULL,
+ share_name VARCHAR(255) NOT NULL,
+ share_owner VARCHAR(32) NOT NULL,
+ share_flags SMALLINT NOT NULL DEFAULT 0,
+ perm_creator SMALLINT NOT NULL DEFAULT 0,
+ perm_default SMALLINT NOT NULL DEFAULT 0,
+ perm_guest SMALLINT NOT NULL DEFAULT 0,
+ attribute_name VARCHAR(255) NOT NULL,
+ attribute_desc VARCHAR(255),
+ PRIMARY KEY (share_id)
+);
+
+CREATE INDEX mnemo_shares_share_name_idx ON mnemo_shares (share_name);
+CREATE INDEX mnemo_shares_share_owner_idx ON mnemo_shares (share_owner);
+CREATE INDEX mnemo_shares_perm_creator_idx ON mnemo_shares (perm_creator);
+CREATE INDEX mnemo_shares_perm_default_idx ON mnemo_shares (perm_default);
+CREATE INDEX mnemo_shares_perm_guest_idx ON mnemo_shares (perm_guest);
+
+CREATE TABLE mnemo_shares_groups (
+ share_id INT NOT NULL,
+ group_uid INT NOT NULL,
+ perm SMALLINT NOT NULL
+);
+
+CREATE INDEX mnemo_shares_groups_share_id_idx ON mnemo_shares_groups (share_id);
+CREATE INDEX mnemo_shares_groups_group_uid_idx ON mnemo_shares_groups (group_uid);
+CREATE INDEX mnemo_shares_groups_perm_idx ON mnemo_shares_groups (perm);
+
+CREATE TABLE mnemo_shares_users (
+ share_id INT NOT NULL,
+ user_uid VARCHAR(255) NOT NULL,
+ perm SMALLINT NOT NULL
+);
+
+CREATE INDEX mnemo_shares_users_share_id_idx ON mnemo_shares_users (share_id);
+CREATE INDEX mnemo_shares_users_user_uid_idx ON mnemo_shares_users (user_uid);
+CREATE INDEX mnemo_shares_users_perm_idx ON mnemo_shares_users (perm);
+
More information about the pkg-kolab-devel
mailing list