6.0.0-git
2019-03-24

[#3126] Split DataTree tables by group_uid and flatten attribute tables
Summary Split DataTree tables by group_uid and flatten attribute tables
Queue Horde Framework Packages
Queue Version FRAMEWORK_3
Type Enhancement
State Rejected
Priority 2. Medium
Owners Horde Developers (at) , ben (at)
Requester duck (at) obala (dot) net
Created 2005-12-12 (4850 days ago)
Due
Updated 2006-10-12 (4546 days ago)
Assigned
Resolved 2006-10-12 (4546 days ago)
Milestone
Patch Yes

History
2006-10-12 16:59:54 Chuck Hagenbuch Comment #8
State ⇒ Rejected
Reply to this comment
We're going to move entirely away from the datatree, so this work 
doesn't help us with our real goal. We'll live with the current 
datatree where we have to until we can get rid of it for good.
2006-03-02 11:17:41 duck (at) obala (dot) net Comment #7
New Attachment: dt20060302.tgz Download
Reply to this comment
Moved DT controls form Application level to Api Classes. Allows to 
split root for each app class and to decide to split/flat the scecific 
class data or not inside the same app.
2005-12-24 18:53:18 duck (at) obala (dot) net Comment #6
New Attachment: dt24122005.tgz Download
Reply to this comment
First merge of Ban and my work. We can only split agora DT from the 
shared one, only flatter attributes or both - split the index and 
flatter attributes in dedicated tables.


2005-12-24 18:15:48 duck (at) obala (dot) net Comment #5
New Attachment: datatree24122005.patch Download
Reply to this comment
Don't store group_uid in split tables.
2005-12-24 13:18:12 duck (at) obala (dot) net Comment #4
New Attachment: sql_flat.php Download
Reply to this comment
Updated DataTree_sql_flat to use Ben's DT root split.
2005-12-18 13:51:53 duck (at) obala (dot) net Comment #3
New Attachment: attributes2flat.php Download
Reply to this comment
New version of attributes2flat.php. Now runs as Horde CLI script, and 
shows existing group_uid, their name/key pairs for creating tables and 
transfers data to a flat table. This will made the migration to a flat 
attribute schema much easier.
2005-12-13 22:27:03 Chuck Hagenbuch Summary ⇒ Split DataTree tables by group_uid and flatten attribute tables
 
2005-12-13 06:17:05 ben Assigned to ben
Assigned to Horde DevelopersHorde Developers
State ⇒ Accepted
 
2005-12-12 15:07:23 ben Comment #2
New Attachment: datatree.patch Download
Reply to this comment
Here's the patch that I've been working on.  I have finals this week, 
so I will not be able to work on this any more until after Friday.
2005-12-12 14:51:05 duck (at) obala (dot) net Comment #1
Type ⇒ Enhancement
State ⇒ New
Priority ⇒ 2. Medium
Summary ⇒ Split DataTree tables by group_uid and Flattern attribute tables
Queue ⇒ Horde Framework Packages
New Attachment: dt-12122005.tgz Download
Reply to this comment
This is the first try to extend DataTree attributes to allow splitting

class specific attributes in a dedicated flat tables.



Attached Files:

- Forums.diff   tells to DT to use a flat table

- Messages.diff         tells to DT to use a flat table

- agora.sql     flat attributes tables for agora forums and messages

- attributes2flat.php   transfers data from normal DT to specific flat table

- conf.diff     add an boolean DT config option -> support flat tables or not

- sql_flat.php          and finally the DataTree_sql_flat class file

Saved Queries