sql confusion

[Mark G. Thomas]

Hi,

I've been running horde-1.2.x and imp-2.2.x for awhile.

Several months ago I started experimenting with horde-2.0 and imp-3.0 CVS
versions (or maybe really horde-1.3.x and imp-2.3.x), and had things 
more or less working.

Now, I'm trying to install horde-2.0 with imp-3.0, but getting sql errors 
at login because apparently some things changed about the horde_prefs table.

What SQL commands do I need to insert into mysql_create.sql to
delete any prior horde_users, horde_prefs, horde_categories, 
and horde_categories_categories tables, before recreation?  Is
there some better way of fixing my problem?

I don't want to run mysql_drop.sql, because I don't want to blow away the 
old imp_addr and imp_pref tables my old active horde-1.x/imp-2.x still uses
for user preferences in the same horde database.

Also, I used to have stuff in horde/imp/config/conf.php for
"$conf['prefs']['driver'] = 'sql';" user database setup as well as 
"$conf['connections']['driver'] = 'sql'; connection tracking setup.

I see that now the preferences driver "$conf['prefs']['driver'] = 'sql';"
is set in horde/config/horde.php, however I can't find anyting about
connection tracking setup.  Can I or should I no longer use sql for this?
Do I have to do or set anything to handle connection tracking?

Sorry for such basic SQL questions, but I'm really not sure where to
go from here.

Here is the login error I'm currently getting with imp-3.0, with the incorrect
sql tables from the older imp CVS I had been running:
--------------------------------------------------------------------------------
object(db_error)(7) {
   ["error_message_prefix"]=>
   string(0) ""
   ["mode"]=>
   int(1)
   ["level"]=>
   int(1024)
   ["code"]=>
   int(-19)
   ["message"]=>
   string(23) "DB Error: no such field"
   ["userinfo"]=>
   string(463) "update horde_prefs set pref_value = 'a:1:{i:0;a:9:{s:2:\"id\";s:16:\"Default
 Identity\";s:8:\"fullname\";s:0:\"\";s:9:\"from_addr\";s:0:\"\";s:12:\"replyto_addr\";s:0:\"\";s:9:\"signature\";s:0:\"\";s:9:\"sig_first\";i:0;s:10:\"sig_dashes\";i:0;s:14:\"save_sent-mail\";N;s:16:\"sent_mail_folder\";s:9:\"sent-mail\";}}'
 where pref_uid = 'mark@misty.com' and pref_name = 'identities' and pref_scope = 'horde'
 [nativecode=Unknown column 'pref_uid' in 'where clause']"
   ["callback"]=>
   NULL
 }
 [/sites/mgtmail.com/horde/lib/Prefs/sql.php : 273]
--------------------------------------------------------------------------------

-- 
Mark G. Thomas (Mark@Misty.com)
http://www.misty.com/  http://mail-cleaner.com/