[Comoblog-commit] comoblog/_install comoblog_db.xml,1.8,1.9
Status: Inactive
Brought to you by:
markwallis
|
From: iamdecal <iam...@us...> - 2006-08-16 16:39:05
|
Update of /cvsroot/comoblog/comoblog/_install In directory sc8-pr-cvs4.sourceforge.net:/tmp/cvs-serv8874/_install Modified Files: comoblog_db.xml Log Message: Initial cache code added, just libraries and base schema, not linked in functionally Index: comoblog_db.xml =================================================================== RCS file: /cvsroot/comoblog/comoblog/_install/comoblog_db.xml,v retrieving revision 1.8 retrieving revision 1.9 diff -u -d -r1.8 -r1.9 --- comoblog_db.xml 15 Aug 2006 16:56:30 -0000 1.8 +++ comoblog_db.xml 16 Aug 2006 16:39:00 -0000 1.9 @@ -9,22 +9,22 @@ <field name="comment_author_email" specs="varchar(128) default NULL" /> <field name="comment_author_url" specs="varchar(128) default NULL" /> <field name="comment_added" specs="int(10) unsigned default NULL" /> - <field name="post_id" specs="int(10) unsigned NOT NULL default '0'" /> + <field name="post_id" specs="int(10) unsigned NOT NULL default '0'" /> <field name="comment_live" specs="varchar(1) default 'N'" /> <pk name="comment_id" /> </table> - - - - <table name="comoblog_commenters"> - <field name="commenter_id" specs="int(10) unsigned NOT NULL auto_increment" /> - <field name="commenter_author_email" specs="varchar(128) default NULL" /> - <field name="commenter_default" specs="varchar(1) default 'N'" /> - - - <pk name="commenter_id" /> - </table> + + + + <table name="comoblog_commenters"> + <field name="commenter_id" specs="int(10) unsigned NOT NULL auto_increment" /> + <field name="commenter_author_email" specs="varchar(128) default NULL" /> + <field name="commenter_default" specs="varchar(1) default 'N'" /> + + + <pk name="commenter_id" /> + </table> <table name="comoblog_images"> <field name="img_id" specs="int(10) unsigned NOT NULL auto_increment" /> @@ -289,4 +289,52 @@ <pk name="trackback_id" /> </table> + + <!-- //ADDED 1.3 + holds the cached pages + + there is no point haveing caches that all expire at the same time - you want to be able to clear them when + specific things happen as well, so as well as datas, there are some extra control fields + + cache_keyphrase = the identifier used to find and save this row i.e. postpage,indexpage or mod_rss + cache_post_id = the post id - most of the caching will relate to post pages. this should speed it up. + cache_clearcodes - a comma seperated string eg (newpost,byage,oncomment,onedit) + cache_added - the date this cached page was added / updated + cache_clear - the date this cached page should be cleared (see byage) + cache_text - the content of the text + + a row might look like this... + + 1,"postpage","123","oncomment,onedit","2006-01-01 12:00:00","2009-01-01 12:00:00","foo bah humbug", + + which would represent the post page for post 123, + as a rule we wont want to change this cache very often, but we will if the post is editied or a comment is added + + the post edit page will be adapted to clear caches with a cache_clearcode like "onedit" OR a keyphrase ='postpage-123' + + or + + 2,"mod_rss,0,"byage","2006-01-01 12:00:00","2006-01-02 12:00:00","foo bah humbug", + + which will only expire by age (every 1 days) + + remeber we may also need to clear the index page etc as they may have the cached details if its a post. + + + --> + + <table name="comoblog_cache"> + <field name="cache_id" specs="int(10) unsigned NOT NULL auto_increment" /> + <field name="cache_keyphrase" specs="varchar(64) default NULL" /> + <field name="cache_post_id" specs="int(10) unsigned NOT NULL " /> + <field name="cache_clearcodes" specs="varchar(255) default NULL" /> + <field name="cache_added" specs="int(14) unsigned not NULL" /> + <field name="cache_clear" specs="int(14) unsigned not NULL" /> + <field name="cache_text" specs="text" /> + <pk name="cache_id" /> + <uk name="cache_keyphrase" /> + </table> + + + </comoblog_db> |