我从 horde 获得了 SQL 格式的数据库文件转储,但是它不包含任何 CREATE TABLE 命令,这是一个问题。手动创建表似乎有点没意义,但我似乎找不到 SQL 文件的副本来实际创建数据库。我确实找到了架构的副本,但似乎缺少很多表。作为参考,一个表的插入如下所示:
INSERT INTO `turba_objects` (`object_id`, `owner_id`, `object_type`, `object_uid`, `object_members`, `object_firstname`, `object_lastname`, `object_middlenames`, `object_nameprefix`, `object_namesuffix`, `object_alias`, `object_photo`, `object_phototype`, `object_bday`, `object_homestreet`, `object_homepob`, `object_homecity`, `object_homeprovince`, `object_homepostalcode`, `object_homecountry`, `object_workstreet`, `object_workpob`, `object_workcity`, `object_workprovince`, `object_workpostalcode`, `object_workcountry`, `object_tz`, `object_geo`, `object_email`, `object_homephone`, `object_workphone`, `object_cellphone`, `object_fax`, `object_pager`, `object_title`, `object_role`, `object_logo`, `object_logotype`, `object_company`, `object_category`, `object_notes`, `object_url`, `object_freebusyurl`, `object_pgppublickey`, `object_smimepublickey`)
有谁有/知道我可以在哪里获得原始架构?
提前致谢。
答案1
你使用的是哪个操作系统?
哪个版本的 horde?
无论如何,这应该包含在包中,例如/usr/share/doc/horde3/examples/scripts/sql/create.mysql.sql.gz