[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