[horde] horde 3.1.3 mysql creation scripts

[John H. Bennett III]

Hello,

 

I need clarification on the horde mysql create scripts in horde/scripts/sql.
Currently, there are two create scripts for a mysql database.
Create.mysql.sql 

-- $Horde: horde/scripts/sql/create.mysql.sql,v 1.4.6.9 2006/07/05 15:53:10
jan Exp $

and create.sql.  

--$Horde: horde/scripts/sql/create.sql,v 1.1.2.3 2006/05/22 21:27:33 jan Exp
$

 

Which one is the one I should be using?  I have been using the
create.mysql.sql one for all previous installs.  I ask because in
create.mysql.sql there is this section:

 

CREATE TABLE horde_prefs (

    pref_uid        VARCHAR(200) NOT NULL,

    pref_scope      VARCHAR(16) NOT NULL DEFAULT '',

    pref_name       VARCHAR(32) NOT NULL,

    pref_value      LONGTEXT NULL,

 

    PRIMARY KEY (pref_uid, pref_scope, pref_name)

);

 

CREATE INDEX pref_uid_idx ON horde_prefs (pref_uid);

CREATE INDEX pref_scope_idx ON horde_prefs (pref_scope);

 

When using this and looking at the tables in phpmyadmin, there is a warning
error saying that Primary and Index keys should not both be set for column
pref_uid.  The create.sql file doesn't have the index section.

 

While, I'm asking, the same is true for mnemo as well.

 

-- $Horde: mnemo/scripts/sql/mnemo.sql,v 1.5 2004/12/21 15:55:24 chuck 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 NOT NULL DEFAULT 0,

--

    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);

 

GRANT SELECT, INSERT, UPDATE, DELETE ON mnemo_memos TO horde;

 

Thanks,

 

John Bennett