[dev] DataTree_sql_flat

Duck duck at obala.net
Sat Dec 10 08:36:14 PST 2005


This is the first try to extend DataTree attributes to allow splitting 
group_uid 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

-------------- next part --------------
CREATE TABLE `agora_datatree_attributes_forums` (
    `datatree_id` int(10) unsigned NOT NULL,
    `message_seq` int(10) NOT NULL,
    `forum_description` varchar(255) NOT NULL,
    `forum_moderated` varchar(255) NOT NULL,
    `forum_attachments` varchar(255) NOT NULL,
    PRIMARY KEY  (`datatree_id`)
);

CREATE TABLE `agora_datatree_attributes_messages` (
    `datatree_id` int(10) unsigned NOT NULL,
    `message_seq` int(10) NOT NULL,
    `message_forum_id` int(10) NOT NULL,
    `message_subject` varchar(255) NOT NULL,
    `message_body` varchar(255) NOT NULL,
    `message_author` varchar(255) NOT NULL,
    `message_timestamp` int(10) NOT NULL,
    `message_messag_attachment` varchar(255) NOT NULL,
    `message_message_seq` int(10) NOT NULL,
    `message_last_message` varchar(255) default NULL,
    `message_last_timestamp` int(10) default NULL,
    `message_last_author` varchar(255) default NULL,
    `message_moderate` int(10) NOT NULL,
    PRIMARY KEY  (`datatree_id`)
);
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Messages.diff
Type: text/x-diff
Size: 1261 bytes
Desc: not available
Url : http://lists.horde.org/archives/dev/attachments/20051210/b322c765/Messages-0001.bin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sql_flat.php
Type: application/x-php
Size: 7394 bytes
Desc: not available
Url : http://lists.horde.org/archives/dev/attachments/20051210/b322c765/sql_flat-0001.bin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: attributes2flat.php
Type: application/x-php
Size: 973 bytes
Desc: not available
Url : http://lists.horde.org/archives/dev/attachments/20051210/b322c765/attributes2flat-0001.bin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: conf.diff
Type: text/x-diff
Size: 404 bytes
Desc: not available
Url : http://lists.horde.org/archives/dev/attachments/20051210/b322c765/conf-0001.bin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Forums.diff
Type: text/x-diff
Size: 614 bytes
Desc: not available
Url : http://lists.horde.org/archives/dev/attachments/20051210/b322c765/Forums-0001.bin


More information about the dev mailing list